APPS.CSP_ITEM_SUB_INVENTORIES_PKG dependencies on MTL_ITEM_SUB_INVENTORIES

Line 58: INSERT INTO MTL_ITEM_SUB_INVENTORIES(

54:
55: IS
56: BEGIN
57:
58: INSERT INTO MTL_ITEM_SUB_INVENTORIES(
59: INVENTORY_ITEM_ID,
60: ORGANIZATION_ID,
61: SECONDARY_INVENTORY,
62: LAST_UPDATE_DATE,

Line 184: Update MTL_ITEM_SUB_INVENTORIES

180: p_POSTPROCESSING_LEAD_TIME NUMBER)
181:
182: IS
183: BEGIN
184: Update MTL_ITEM_SUB_INVENTORIES
185: SET
186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),

Line 240: DELETE FROM MTL_ITEM_SUB_INVENTORIES

236: p_ORGANIZATION_ID NUMBER,
237: p_SECONDARY_INVENTORY VARCHAR2)
238: IS
239: BEGIN
240: DELETE FROM MTL_ITEM_SUB_INVENTORIES
241: where inventory_item_id = p_INVENTORY_ITEM_ID
242: and secondary_inventory = p_SECONDARY_INVENTORY
243: and organization_id = p_ORGANIZATION_ID;
244: If (SQL%NOTFOUND) then

Line 294: FROM MTL_ITEM_SUB_INVENTORIES

290:
291: IS
292: CURSOR C IS
293: SELECT *
294: FROM MTL_ITEM_SUB_INVENTORIES
295: where inventory_item_id = p_INVENTORY_ITEM_ID
296: and secondary_inventory = p_SECONDARY_INVENTORY
297: and organization_id = p_ORGANIZATION_ID
298: FOR UPDATE of INVENTORY_ITEM_ID NOWAIT;