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 868: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_OPERATIONS_TEMP');

864:
865: -- Routing Operations Table
866: IF (P_rtg_op_XML IS NOT NULL) THEN
867: -- get the context handle
868: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_OPERATIONS_TEMP');
869: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
870: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
871: DBMS_XMLSave.setRowTag(insCtx , 'OperationSequencesVO');
872: -- this inserts the document