APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_COMPONENT_OPERATIONS

Line 584: FROM bom_component_operations_temp tmp

580: tmp.Attribute15 ,
581: NULL ReturnStatus ,
582: 'CREATE' TransactionType ,
583: NULL RowIdentifier
584: FROM bom_component_operations_temp tmp
585: WHERE NOT EXISTS (SELECT 1
586: FROM bom_component_operations comp_oper,
587: bom_inventory_components comp,
588: bom_bill_of_materials bom,

Line 586: FROM bom_component_operations comp_oper,

582: 'CREATE' TransactionType ,
583: NULL RowIdentifier
584: FROM bom_component_operations_temp tmp
585: WHERE NOT EXISTS (SELECT 1
586: FROM bom_component_operations comp_oper,
587: bom_inventory_components comp,
588: bom_bill_of_materials bom,
589: mtl_parameters org,
590: mtl_system_items_kfv item1,

Line 636: FROM bom_component_operations_temp tmp

632: tmp.Attribute15 ,
633: NULL ReturnStatus ,
634: 'UPDATE' TransactionType ,
635: NULL RowIdentifier
636: FROM bom_component_operations_temp tmp
637: WHERE EXISTS (SELECT 1
638: FROM bom_component_operations comp_oper,
639: bom_inventory_components comp,
640: bom_bill_of_materials bom,

Line 638: FROM bom_component_operations comp_oper,

634: 'UPDATE' TransactionType ,
635: NULL RowIdentifier
636: FROM bom_component_operations_temp tmp
637: WHERE EXISTS (SELECT 1
638: FROM bom_component_operations comp_oper,
639: bom_inventory_components comp,
640: bom_bill_of_materials bom,
641: mtl_parameters org,
642: mtl_system_items_kfv item1,

Line 832: -- Bom Component Operations Table

828: -- this closes the handle
829: DBMS_XMLSave.closeContext(insCtx);
830: END IF;
831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
832: -- Bom Component Operations Table
833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');

830: END IF;
831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
832: -- Bom Component Operations Table
833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document

Line 1212: -- Bom Component Operations Table

1208: END LOOP;
1209: END IF;
1210: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
1211: /*
1212: -- Bom Component Operations Table
1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');

1210: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
1211: /*
1212: -- Bom Component Operations Table
1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document