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 849: insCtx := DBMS_XMLSave.newContext('BOM_RTG_REVISIONS_TEMP');

845: DBMS_XMLSave.closeContext(insCtx);
846: -- Routing Revisions Table
847: IF (P_rtg_rev_XML IS NOT NULL) THEN
848: -- get the context handle
849: insCtx := DBMS_XMLSave.newContext('BOM_RTG_REVISIONS_TEMP');
850: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
851: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
852: DBMS_XMLSave.setRowTag(insCtx , 'RoutingRevisionsVO');
853: -- this inserts the document