APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_OPER_NETWORKS_TEMP

Line 733: FROM bom_oper_networks_temp tmp

729: , tmp.OriginalSystemReference
730: , 'CREATE' transaction_type
731: , NULL return_status
732: , NULL row_identifier
733: FROM bom_oper_networks_temp tmp
734: WHERE tmp.AssemblyItemName = P_assembly_item_name
735: AND tmp.OrganizationCode = P_organization_code
736: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
737: AND NOT EXISTS (SELECT 1

Line 799: FROM bom_oper_networks_temp tmp

795: , tmp.OriginalSystemReference
796: , 'UPDATE' transaction_type
797: , NULL return_status
798: , NULL row_identifier
799: FROM bom_oper_networks_temp tmp
800: WHERE tmp.AssemblyItemName = P_assembly_item_name
801: AND tmp.OrganizationCode = P_organization_code
802: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
803: AND EXISTS (SELECT 1

Line 907: insCtx := DBMS_XMLSave.newContext('BOM_OPER_NETWORKS_TEMP');

903:
904: -- Routing Operation Networks Table
905: IF (P_rtg_op_network_XML IS NOT NULL) THEN
906: -- get the context handle
907: insCtx := DBMS_XMLSave.newContext('BOM_OPER_NETWORKS_TEMP');
908: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
909: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
910: DBMS_XMLSave.setRowTag(insCtx , 'OperationNetworksVO');
911: -- this inserts the document