APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 361: FROM bom_substitute_components_temp tmp

357: tmp.OriginalSystemReference ,
358: NULL ReturnStatus ,
359: 'UPDATE' TransactionType ,
360: NULL RowIdentifier
361: FROM bom_substitute_components_temp tmp
362: WHERE EXISTS (SELECT 1
363: FROM bom_substitute_components sub,
364: bom_inventory_components comp,
365: bom_bill_of_materials bom,

Line 363: FROM bom_substitute_components sub,

359: 'UPDATE' TransactionType ,
360: NULL RowIdentifier
361: FROM bom_substitute_components_temp tmp
362: WHERE EXISTS (SELECT 1
363: FROM bom_substitute_components sub,
364: bom_inventory_components comp,
365: bom_bill_of_materials bom,
366: mtl_parameters org,
367: mtl_system_items_kfv item1,

Line 420: FROM bom_substitute_components_temp tmp

416: tmp.OriginalSystemReference ,
417: NULL ReturnStatus ,
418: 'CREATE' TransactionType ,
419: NULL RowIdentifier
420: FROM bom_substitute_components_temp tmp
421: WHERE NOT EXISTS (SELECT 1
422: FROM bom_substitute_components sub,
423: bom_inventory_components comp,
424: bom_bill_of_materials bom,

Line 422: FROM bom_substitute_components sub,

418: 'CREATE' TransactionType ,
419: NULL RowIdentifier
420: FROM bom_substitute_components_temp tmp
421: WHERE NOT EXISTS (SELECT 1
422: FROM bom_substitute_components sub,
423: bom_inventory_components comp,
424: bom_bill_of_materials bom,
425: mtl_parameters org,
426: mtl_system_items_kfv item1,

Line 808: -- Bom Substitute Components Table

804: -- this closes the handle
805: DBMS_XMLSave.closeContext(insCtx);
806: END IF;
807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
808: -- Bom Substitute Components Table
809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

806: END IF;
807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
808: -- Bom Substitute Components Table
809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document

Line 1093: -- Bom Substitute Components Table

1089: END LOOP;
1090: END IF;
1091: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
1092: /*
1093: -- Bom Substitute Components Table
1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

1091: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
1092: /*
1093: -- Bom Substitute Components Table
1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document