APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_SUB_OPER_RESOURCES_TEMP

Line 587: FROM bom_sub_oper_resources_temp tmp

583: , 'UPDATE'
584: , NULL
585: , tmp.SetupType
586: , NULL row_identifier
587: FROM bom_sub_oper_resources_temp tmp
588: WHERE tmp.AssemblyItemName = P_assembly_item_name
589: AND tmp.OrganizationCode = P_organization_code
590: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
591: AND EXISTS (SELECT 1

Line 658: FROM bom_sub_oper_resources_temp tmp

654: , 'CREATE'
655: , NULL
656: , tmp.SetupType
657: , NULL row_identifier
658: FROM bom_sub_oper_resources_temp tmp
659: WHERE tmp.AssemblyItemName = P_assembly_item_name
660: AND tmp.OrganizationCode = P_organization_code
661: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
662: AND NOT EXISTS (SELECT 1

Line 888: insCtx := DBMS_XMLSave.newContext('BOM_SUB_OPER_RESOURCES_TEMP');

884:
885: -- Routing Substitute Operation Resources Table
886: IF (p_rtg_sub_op_res_XML IS NOT NULL) THEN
887: -- get the context handle
888: insCtx := DBMS_XMLSave.newContext('BOM_SUB_OPER_RESOURCES_TEMP');
889: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
890: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
891: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteOperationResourcesVO');
892: -- this inserts the document