APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_RTG_OPER_RES_TEMP

Line 450: FROM bom_rtg_oper_res_temp tmp

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

Line 514: FROM bom_rtg_oper_res_temp tmp

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

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

871:
872: -- Routing Operation Resources Table
873: IF (P_rtg_op_res_XML IS NOT NULL) THEN
874: -- get the context handle
875: insCtx := DBMS_XMLSave.newContext('BOM_RTG_OPER_RES_TEMP');
876: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
877: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
878: DBMS_XMLSave.setRowTag(insCtx , 'OperationResourcesVO');
879: -- this inserts the document