APPS.BOM_ROUTINGINTERFACE_PUB dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 449: Insert into mtl_rtg_item_revs_interface

445:
446: -- insert given process_revision
447: If nvl(l_interface_rec.process_revision, G_NullChar) <>
448: G_NullChar and l_phase = 1 then
449: Insert into mtl_rtg_item_revs_interface
450: (inventory_item_id,
451: inventory_item_number,
452: organization_id,
453: organization_code,

Line 2044: From mtl_rtg_item_revs_interface

2040: attribute13,
2041: attribute14,
2042: attribute15,
2043: transaction_type
2044: From mtl_rtg_item_revs_interface
2045: Where process_flag = 1
2046: And (g_AllOrgs = g_yes
2047: or organization_id = g_OrgId
2048: or organization_code = g_OrgCode

Line 2358: Delete from mtl_rtg_item_revs_interface

2354: End if; -- insert, update and delete
2355:
2356: If l_return_status = Fnd_Api.G_RET_STS_SUCCESS then
2357: If g_DeleteRows then
2358: Delete from mtl_rtg_item_revs_interface
2359: Where rowid = l_interface_rec.rowid;
2360: Else
2361: Update mtl_rtg_item_revs_interface
2362: Set process_flag = 7,

Line 2361: Update mtl_rtg_item_revs_interface

2357: If g_DeleteRows then
2358: Delete from mtl_rtg_item_revs_interface
2359: Where rowid = l_interface_rec.rowid;
2360: Else
2361: Update mtl_rtg_item_revs_interface
2362: Set process_flag = 7,
2363: transaction_id = mtl_system_items_interface_s.nextval,
2364: request_id = nvl(request_id,g_RequestId),
2365: program_id = nvl(program_id,g_ProgramId),

Line 2394: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

2390: prog_id => g_ProgramId,
2391: req_id => g_RequestId,
2392: trans_id => l_transaction_rec.transaction_id,
2393: error_text => l_msg_data,
2394: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
2395: msg_name => l_msg_name,
2396: err_text => l_msg_data);
2397: If l_ret_code <> 0 then
2398: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2400: Update mtl_rtg_item_revs_interface

2396: err_text => l_msg_data);
2397: If l_ret_code <> 0 then
2398: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2399: end if;
2400: Update mtl_rtg_item_revs_interface
2401: Set process_flag = 3,
2402: transaction_id = l_transaction_rec.transaction_id
2403: Where rowid = l_interface_rec.rowid;
2404: End loop; -- log error