CIPs - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

PROCEDURE SET_S2008(p_log_id IN NUMBER);

Is called by the creation of the spec-file. This procedure summarizes all calls to attributes in the spec-file which are mapped in the Smart Materials-screen S.20.08.

FUNCTION bfle_weight(p_ident IN m_idents.ident%TYPE,

p_weight IN NUMBER)

RETURN NUMBER;

You can write in c.dat-file a second weight. This CIP calculates this weight.

FUNCTION CATE (P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

Returns the cate. Standard is the commodity code interfaced translation for PDMS.

PRAGMA RESTRICT_REFERENCES(CATE, WNDS,WNPS);

FUNCTION CATE_TEXT (P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

This function is used for the g.dat file. It is additional information about the cate.

FUNCTION GTYPE (P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

Returns the gtype for the g.dat file.

FUNCTION CATE_STEXT (P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

This function is used for the g.dat file. It is additional information about the cate.

FUNCTION SCOM (P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE,

P_IDENT IN M_IDENTS.IDENT%TYPE,

P_LOG_ID IN NUMBER )

RETURN VARCHAR2;

This function is used for the g.dat-file and the spec-file. Standard is that the function returns the cate and information about the Nominal Sizes.

FUNCTION s2008(p_commodity_id NUMBER ,

p_translation VARCHAR2 ,

p_interface_id NUMBER )

RETURN VARCHAR2;

This function looks for the mappings in S.20.08, for the styp, btyp, radius, angle, shop.

FUNCTION SECT (P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE,

P_NLS_ID IN m_nls.nls_id%TYPE)

RETURN VARCHAR2;

Returns the section for all PDMS 20.01 related files. Standard is that the function returns the part nls for the nls_id which is defined in PDMS 30.01 for RTEXT-Nls.

FUNCTION FIND_IN_CCD (P_COMMODITY_ID NUMBER

,P_TRANSLATION VARCHAR2

,p_INTERFACE_ID NUMBER

,p_nls_id NUMBER

,p_code_or_desc VARCHAR2)

RETURN VARCHAR2;

Looks for the material-reference or the description. It is used in the specfile or for the m.dat-file.

PROCEDURE GENERAL_SPEC_FILE_UPDATE(P_LOG_ID IN m_pdms_logs.id%TYPE);

With this procedure you can manipulate the spec-file-result at least. After this call there is no manipulation inside the standard-package.

FUNCTION example_cip_pdms3002 (P_IDENT IN M_IDENTS.IDENT%TYPE)

RETURN VARCHAR2;

FUNCTION GET_UNIT(p_commodity_id IN m_commodity_codes.commodity_id%TYPE,

p_digit IN m_obj_parm_det.detail_id%TYPE)

RETURN VARCHAR2;

Looks for the unit of several Attributes.

FUNCTION get_insu_name (p_gd_id IN m_geom_details.gd_id%TYPE)

RETURN VARCHAR2;

This function returns the needed name reference for the spec file

FUNCTION get_insu_type

RETURN VARCHAR2;

This function returns the needed g-type reference for the spec file

FUNCTION get_insu_temp (p_gd_id IN m_geom_details.gd_id%TYPE,

p_temp_from_value IN VARCHAR2,

p_temp_to_value IN VARCHAR2)

RETURN VARCHAR2;

This function returns the needed temp for the spec file

FUNCTION get_insu_pbor0 (p_gd_id IN m_geom_details.gd_id%TYPE,

p_dn_from_value IN VARCHAR2,

p_dn_to_value IN VARCHAR2,

p_unit IN VARCHAR2)

RETURN VARCHAR2;

=> this function returns the needed pbor0 for the spec file

FUNCTION get_insu_catref (p_gd_id IN m_geom_details.gd_id%TYPE,

p_insu_thk_value IN VARCHAR2)

RETURN VARCHAR2;

=>this function returns the needed catref reference for the spec file

FUNCTION get_insu_detail (p_gd_id IN m_geom_details.gd_id%TYPE)

RETURN VARCHAR2;

=> this function returns the needed detail reference for the spec file

FUNCTION get_insu_heading

RETURN VARCHAR2;

=>this function returns the needed heading fields for the spec file

FUNCTION set_insu_fields (p_name IN m_pdms_spec_gds.name%TYPE,

p_type IN m_pdms_spec_gds.type%TYPE,

p_temp IN m_pdms_spec_gds.temp%TYPE,

p_pbor0 IN m_pdms_spec_gds.pbor0%TYPE,

p_catref IN m_pdms_spec_gds.catref%TYPE,

p_detail IN m_pdms_spec_gds.detail%TYPE,

p_unit0 IN m_pdms_spec_gds.unit0%TYPE)

RETURN VARCHAR2;

=> User defined heading fields for Insulation Specifications

FUNCTION get_insu_g_dat (p_field IN VARCHAR2,

p_gn_id IN m_geom_names.gn_id%TYPE,

p_dn IN m_nominal_size_details.dn%TYPE,

p_unit IN m_units.unit_code%TYPE DEFAULT NULL)

RETURN VARCHAR2;

=> this function returns the needed values for the insulation _g.dat file

PROCEDURE GENERAL_PDMS2001(p_pcc_id IN m_pdms_copy_ccs.pcc_id%TYPE);

This procedure is called from a transfer started in PDMS 20.01. This procedure call is the last step in the transfer and you have the possibility to modify any format or data in the output files.

PROCEDURE PREP_OUTPUT(p_log_id IN m_pdms_logs.id%TYPE);

Gives you the possibility to add additional attributes into the spec-file. For this purpose, please use the SUB_SEQ_ID on the table m_pdms_lines. The attributes for one line must have the same seq_id with the sub_seq_id in the order in which the attributes should be written in the spec-file. This procedure is called for the file with new lines.

PROCEDURE PREP_OUTPUT_DEL(p_log_id IN m_pdms_logs.id%TYPE);

Gives you the possibility to add additional attributes into the spec-file. For this purpose, please use the SUB_SEQ_ID on the table m_pdms_lines. The attributes for one line must have the same seq_id with the sub_seq_id in the order in which the attributes should be written in the spec-file. This procedure is called for the file with deleted lines.

PROCEDURE PREP_OUTPUT_INS(p_log_id IN m_pdms_logs.id%TYPE);

Gives you the possibility to add additional attributes into the spec-file. For this purpose, please use the SUB_SEQ_ID on the table m_pdms_lines. The attributes for one line must have the same seq_id with the sub_seq_id in the order in which the attributes should be written in the spec-file. This procedure is called for the file with inserted lines.

PROCEDURE PREP_OUTPUT_MOD(p_log_id IN m_pdms_logs.id%TYPE);

Gives you the possibility to add additional attributes into the spec-file. For this purpose, please use the SUB_SEQ_ID on the table m_pdms_lines. The attributes for one line must have than the same seq_id with the sub_seq_id in the order in which the attributes should be written in the spec-file. This procedure is called for the file with modified lines.

FUNCTION prep_out_set_delete_desc (p_log_id IN m_pdms_logs.id%TYPE)

RETURN VARCHAR2;

=> this function returns a header line for the delete-file

FUNCTION TEXT (P_IDENT IN m_idents.ident%TYPE,

P_NLS_ID IN m_nls.nls_id%TYPE,

p_COMMODITY_ID m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

Returns the detail-text in the d.dat-file.

PROCEDURE spec_bolt_ref (p_commodity_id IN m_commodity_codes.commodity_id%TYPE,

p_ident IN m_idents.ident%TYPE,

p_spec_item_id IN m_spec_items.spec_item_id%TYPE,

p_type IN m_pdms_spec_idents.type%TYPE,

p_pdms_si_id IN m_pdms_spec_idents.pdms_si_id%TYPE);

CIP to fill the Bolt-related data into the specfile.

PROCEDURE file_bolt_ref(p_pcc_id IN m_pdms_copy_ccs.pcc_id%TYPE,

p_commodity_id IN m_commodity_codes.commodity_id%TYPE,

p_input_1 IN m_idents.input_1%TYPE);

CIP to fill the SingleBolt-File.

FUNCTION COCO

(p_commodity_id IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

Get the connection-type for g.dat-file.

FUNCTION GET_BTYPE(p_ident IN m_idents.ident%TYPE,

p_attr_id IN m_attrs.attr_id%TYPE)

RETURN VARCHAR2 ;

Get the bolttype for f.dat-file.

FUNCTION IDENT_ATTRS

(P_IDENT IN m_idents.ident%TYPE,

P_INTERFACE_ID IN m_interfaces.interface_id%TYPE)

RETURN VARCHAR2;

Fill the parad-line in the g.dat-file.

PROCEDURE GPD_REF(P_INTERFACE_ID IN NUMBER,

P_COMMODITY_ID IN NUMBER,

P_IDENT IN NUMBER,

p_gmref OUT VARCHAR2,

p_tref OUT VARCHAR2,

p_dref OUT VARCHAR2

);

This procedure returns the gmref, ptref, dtref fields for the g.dat-file.

FUNCTION get_flbp(p_commodity_id IN NUMBER,

p_parad IN VARCHAR2)

RETURN PLS_INTEGER;

FUNCTION GET_IDENT_CODE(p_ident IN NUMBER)

RETURN VARCHAR2;

This function gives you the possibility to translate the ident-code which you see in the b.dat file(as a user-defined-attribute).

FUNCTION DTSE

(P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE,

P_INTERFACE_ID IN m_interfaces.interface_id%TYPE)

RETURN VARCHAR2;

Only for the dataset used. The dataset describes the attribute-set which you transfer with the g.dat-file. This file-type is only available when in PDMS 30.01 the checkbox ‘With dataset?’ is marked.

FUNCTION SKEY

(P_INTERFACE_ID IN m_interfaces.interface_id%TYPE,

P_COMMODITY_ID IN m_commodity_codes.commodity_id%TYPE)

RETURN VARCHAR2;

Returns the skey for the d.dat-file.

FUNCTION GET_CATA(p_type IN VARCHAR2,

p_pk IN NUMBER)

RETURN VARCHAR2;

Returns the Cata for all result-files. Depending on if the file is ident or commodity-code driven, the standard-function looks for the proj_id from the ident or commodity code.

PROCEDURE FILL_COMP_ATTRS(p_pcc_Id IN NUMBER,

p_pw_id IN NUMBER,

p_ident IN NUMBER

);

Give you the possibility to fill data into m_pdms_weight_attrs which you can spool out into the c.dat-file. The example-code used for this purpose the screen A.60.13 Ident Attribute Functions.

PROCEDURE PREP_OUTPUT_HEADING(p_log_id IN m_pdms_logs.id%TYPE,

p_log_type IN m_pdms_lines.log_type%TYPE);

Fill the heading lines like ‘MATREF’, ‘RATING’. You can change the default here.