[Home] [Help]
787: ORDER BY sequence ;
788:
789: l_rec Cur_get_folder_cols%ROWTYPE;
790: BEGIN
791: DELETE FROM gmd_technical_parameter_gtmp;
792: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));
793: IF (V_folder_name IS NOT NULL) THEN
794: OPEN Cur_get_folder_cols;
795: LOOP
794: OPEN Cur_get_folder_cols;
795: LOOP
796: FETCH Cur_get_folder_cols INTO l_rec;
797: EXIT WHEN Cur_get_folder_cols%NOTFOUND;
798: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
799: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,
800: DATA_TYPE,EXPRESSION_CHAR,LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,
801: UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
802: VALUES (V_entity_id,l_rec.tech_parm_name,l_rec.tech_parm_id,l_rec.parm_description,l_rec.sequence,l_rec.qcassy_typ_id,
806: END LOOP;
807: CLOSE Cur_get_folder_cols;
808:
809: ELSIF (V_sprd_id IS NOT NULL) THEN
810: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
811: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
812: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,OPTIMIZE_TYPE,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
813: SELECT a.sprd_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,b.qcassy_typ_id,
814: b.data_type,b.expression_char,b.lm_unit_code,
846: OPEN Cur_get_item_count;
847: FETCH Cur_get_item_count INTO l_count;
848: CLOSE Cur_get_item_count;
849: IF (l_count > 0) THEN
850: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
851: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
852: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
853: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
854: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
864: OPEN Cur_get_category_count;
865: FETCH Cur_get_category_count INTO l_count;
866: CLOSE Cur_get_category_count;
867: IF (l_count > 0) THEN
868: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
869: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
870: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
871: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
872: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
878: AND a.category_id = l_category_id
879: AND a.organization_id = V_orgn_id;
880: ELSE
881: --If organization has the parameters then insert
882: INSERT INTO GMD_TECHNICAL_PARAMETER_GTMP
883: (ENTITY_ID,TECH_PARM_NAME,TECH_PARM_ID,PARM_DESCRIPTION,SORT_SEQ,QCASSY_TYP_ID,DATA_TYPE,EXPRESSION_CHAR,
884: LM_UNIT_CODE,SIGNIF_FIGURES,LOWERBOUND_NUM,UPPERBOUND_NUM,LOWERBOUND_CHAR,UPPERBOUND_CHAR,MAX_LENGTH)
885: SELECT V_entity_id,a.tech_parm_name,b.tech_parm_id,b.parm_description,a.sort_seq,
886: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
1091: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1092: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1093: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1094: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1095: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1096: WHERE a.tech_parm_id = b.tech_parm_id
1097: AND a.sprd_id = V_entity_id
1098: AND a.line_id = c.sprd_line_id
1099: AND a.organization_id = V_orgn_id
1130: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1131: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1132: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1133: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1134: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1135: WHERE a.tech_parm_id = b.tech_parm_id
1136: AND a.organization_id = V_orgn_id
1137: AND a.inventory_item_id = c.inventory_item_id
1138: AND (V_matl_detl_id IS NULL OR c.parent_line_id = V_matl_detl_id)
1193: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1194: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1195: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1196: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1197: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1198: WHERE a.tech_parm_id = b.tech_parm_id
1199: AND a.organization_id = V_orgn_id
1200: AND a.inventory_item_id = c.inventory_item_id
1201: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
1309: last_updated_by,last_update_date,created_by,creation_date)
1310: SELECT X_sprd_id, V_orgn_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1311: expression_char,lowerbound_num,upperbound_num,signif_figures,optimize_type,
1312: l_user_id,sysdate,l_user_id,sysdate
1313: FROM gmd_technical_parameter_gtmp
1314: WHERE entity_id = V_entity_id;
1315:
1316: FOR l_rec IN Cur_sprd_insert LOOP
1317: OPEN Cur_line_id;
1560: PROCEDURE load_quality_data (V_line_id IN NUMBER, V_orgn_id IN NUMBER,V_plant_id IN NUMBER) IS
1561:
1562: CURSOR Cur_get_qmdata IS
1563: SELECT *
1564: FROM gmd_technical_parameter_gtmp
1565: WHERE qcassy_typ_id IS NOT NULL;
1566:
1567: CURSOR Cur_get_data IS
1568: SELECT *
1835: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1836: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1837: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1838: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1839: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1840: WHERE a.tech_parm_id = b.tech_parm_id
1841: AND a.organization_id = V_orgn_id
1842: AND a.inventory_item_id = c.inventory_item_id
1843: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
1868: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1869: CURSOR Cur_get_type IS
1870: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq,
1871: c.inventory_item_id,c.detail_uom
1872: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1873: WHERE a.tech_parm_id = b.tech_parm_id
1874: AND c.line_id = V_line_id;
1875: CURSOR Cur_get_item (V_inv_item_id NUMBER) IS
1876: SELECT primary_uom_code
2109: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2110: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2111: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2112: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2113: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2114: WHERE a.tech_parm_id = b.tech_parm_id
2115: AND a.organization_id = V_orgn_id
2116: AND a.item_id = c.item_id
2117: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)
2133: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2134: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2135: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2136: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2137: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2138: WHERE a.tech_parm_id = b.tech_parm_id
2139: AND a.organization_id = V_orgn_id
2140: AND a.inventory_item_id = c.inventory_item_id
2141: and c.organization_id = V_orgn_id
2164: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2165: SELECT V_entity_id,V_line_id,a.tech_parm_name,a.tech_parm_id,
2166: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2167: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2168: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b--, gmd_material_details_gtmp c
2169: WHERE a.tech_parm_id = b.tech_parm_id
2170: AND a.organization_id = V_orgn_id ---1
2171: AND a.inventory_item_id = V_item_id
2172: AND a.formula_id is null