DBA Data[Home] [Help]

APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_COMPONENT_OPERATIONS_TEMP

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 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 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 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