APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_COMPONENT_OPERATIONS

Line 583: FROM bom_component_operations_temp tmp

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

Line 585: FROM bom_component_operations comp_oper,

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

Line 635: FROM bom_component_operations_temp tmp

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

Line 637: FROM bom_component_operations comp_oper,

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

Line 830: -- Bom Component Operations Table

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

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

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

Line 1209: -- Bom Component Operations Table

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

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

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