APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_RTG_OPER_RES_TEMP

Line 452: FROM bom_rtg_oper_res_temp tmp

448: , 'CREATE'
449: , NULL
450: , tmp.SetupType
451: , NULL row_identifier
452: FROM bom_rtg_oper_res_temp tmp
453: WHERE tmp.AssemblyItemName = P_assembly_item_name
454: AND tmp.OrganizationCode = P_organization_code
455: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
456: AND NOT EXISTS (SELECT 1

Line 518: FROM bom_rtg_oper_res_temp tmp

514: , 'UPDATE'
515: , NULL
516: , tmp.SetupType
517: , NULL row_identifier
518: FROM bom_rtg_oper_res_temp tmp
519: WHERE tmp.AssemblyItemName = P_assembly_item_name
520: AND tmp.OrganizationCode = P_organization_code
521: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
522: AND EXISTS (SELECT 1

Line 881: insCtx := DBMS_XMLSave.newContext('BOM_RTG_OPER_RES_TEMP');

877:
878: -- Routing Operation Resources Table
879: IF (P_rtg_op_res_XML IS NOT NULL) THEN
880: -- get the context handle
881: insCtx := DBMS_XMLSave.newContext('BOM_RTG_OPER_RES_TEMP');
882: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
883: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
884: DBMS_XMLSave.setRowTag(insCtx , 'OperationResourcesVO');
885: -- this inserts the document