APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_SUB_OPER_RESOURCES_TEMP

Line 592: FROM bom_sub_oper_resources_temp tmp

588: , 'UPDATE'
589: , NULL
590: , tmp.SetupType
591: , NULL row_identifier
592: FROM bom_sub_oper_resources_temp tmp
593: WHERE tmp.AssemblyItemName = P_assembly_item_name
594: AND tmp.OrganizationCode = P_organization_code
595: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
596: AND EXISTS (SELECT 1

Line 664: FROM bom_sub_oper_resources_temp tmp

660: , 'CREATE'
661: , NULL
662: , tmp.SetupType
663: , NULL row_identifier
664: FROM bom_sub_oper_resources_temp tmp
665: WHERE tmp.AssemblyItemName = P_assembly_item_name
666: AND tmp.OrganizationCode = P_organization_code
667: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
668: AND NOT EXISTS (SELECT 1

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

890:
891: -- Routing Substitute Operation Resources Table
892: IF (p_rtg_sub_op_res_XML IS NOT NULL) THEN
893: -- get the context handle
894: insCtx := DBMS_XMLSave.newContext('BOM_SUB_OPER_RESOURCES_TEMP');
895: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
896: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
897: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteOperationResourcesVO');
898: -- this inserts the document