DBA Data[Home] [Help]

APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_RTG_REVISIONS_TEMP

Line 201: FROM bom_rtg_revisions_temp tmp,

197: , tmp.OriginalSystemReference
198: , 'CREATE' transaction_type
199: , NULL return_status
200: , NULL row_identifier
201: FROM bom_rtg_revisions_temp tmp,
202: mtl_parameters org,
203: mtl_system_items_kfv item
204: WHERE org.organization_code = tmp.OrganizationCode
205: AND item.organization_id = org.organization_id

Line 240: FROM bom_rtg_revisions_temp tmp,

236: , tmp.OriginalSystemReference
237: , 'UPDATE' transaction_type
238: , NULL return_status
239: , NULL row_identifier
240: FROM bom_rtg_revisions_temp tmp,
241: mtl_parameters org,
242: mtl_system_items_kfv item
243: WHERE org.organization_code = tmp.OrganizationCode
244: AND item.organization_id = org.organization_id

Line 855: insCtx := DBMS_XMLSave.newContext('BOM_RTG_REVISIONS_TEMP');

851: DBMS_XMLSave.closeContext(insCtx);
852: -- Routing Revisions Table
853: IF (P_rtg_rev_XML IS NOT NULL) THEN
854: -- get the context handle
855: insCtx := DBMS_XMLSave.newContext('BOM_RTG_REVISIONS_TEMP');
856: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
857: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
858: DBMS_XMLSave.setRowTag(insCtx , 'RoutingRevisionsVO');
859: -- this inserts the document