APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_ROUTING_OPERATIONS_TEMP

Line 311: FROM bom_routing_operations_temp tmp

307: , NULL Delete_Group_Name
308: , NULL DG_Description
309: , NULL long_description
310: , NULL row_identifier
311: FROM bom_routing_operations_temp tmp
312: WHERE tmp.AssemblyItemName = P_assembly_item_name
313: AND tmp.OrganizationCode = P_organization_code
314: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
315: AND EXISTS (SELECT 1

Line 386: FROM bom_routing_operations_temp tmp

382: , NULL Delete_Group_Name
383: , NULL DG_Description
384: , NULL long_description
385: , NULL row_identifier
386: FROM bom_routing_operations_temp tmp
387: WHERE tmp.AssemblyItemName = P_assembly_item_name
388: AND tmp.OrganizationCode = P_organization_code
389: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
390: AND NOT EXISTS (SELECT 1

Line 862: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_OPERATIONS_TEMP');

858:
859: -- Routing Operations Table
860: IF (P_rtg_op_XML IS NOT NULL) THEN
861: -- get the context handle
862: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_OPERATIONS_TEMP');
863: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
864: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
865: DBMS_XMLSave.setRowTag(insCtx , 'OperationSequencesVO');
866: -- this inserts the document