APPS.INVIDIT2 dependencies on MTL_PENDING_ITEM_STATUS

Line 5: -- insert into mtl_pending_item_status

1: PACKAGE BODY INVIDIT2 AS
2: /* $Header: INVIDI2B.pls 120.5.12010000.2 2008/09/09 11:41:39 appldev ship $ */
3:
4: -- After inserting an item:
5: -- insert into mtl_pending_item_status
6: -- insert into mtl_item_revisions
7: -- insert into mtl_item_categories
8: -- call CSTPIICI to insert into cst_item_costs
9: -- insert into mtl_uom_conversions

Line 13: -- insert into mtl_pending_item_status

9: -- insert into mtl_uom_conversions
10: -- Call other procedures passing event='INSERT'
11:
12: -- After updating an item:
13: -- insert into mtl_pending_item_status
14: -- insert into mtl_item_categories
15: -- insert into mtl_uom_conversions
16: -- Call other procedures passing event = 'UPDATE'
17:

Line 21: -- insert into mtl_pending_item_status

17:
18: -- After assigning the item to a child org:
19: -- delete from mtl_item_categories
20: -- insert into mtl_item_categories
21: -- insert into mtl_pending_item_status
22: -- insert into mtl_item_revisions
23: -- call CSTPIICI to insert into cst_item_costs
24: -- Call other procedures passing event = 'ORG_ASSIGN'
25:

Line 27: -- insert into mtl_pending_item_status

23: -- call CSTPIICI to insert into cst_item_costs
24: -- Call other procedures passing event = 'ORG_ASSIGN'
25:
26: -- After updating item/org attributes:
27: -- insert into mtl_pending_item_status
28: -- insert into mtl_item_categories
29: -- insert into mtl_uom_conversions
30: -- Call other procedures passing event = 'ITEM_ORG'
31:

Line 108: -- form, so don't insert another row into mtl_pending_item_status.

104:
105: elsif ( X_event = 'UPDATE' ) then
106:
107: -- If X_status_code is null, then the status was not changed in the
108: -- form, so don't insert another row into mtl_pending_item_status.
109:
110: if ( X_status_code is not null ) then
111: Insert_Pending_Status('UPDATE', X_item_id, X_org_id, X_master_org_id,
112: X_status_code,P_Lifecycle_Id,P_Current_Phase_Id);

Line 161: -- form, so don't insert another row into mtl_pending_item_status.

157:
158: elsif ( X_event = 'ITEM_ORG' ) then
159:
160: -- If X_status_code is null, then the status was not changed in the
161: -- form, so don't insert another row into mtl_pending_item_status.
162:
163: if ( X_status_code is not null ) then
164: Insert_Pending_Status('ITEM_ORG', X_item_id, X_org_id, X_master_org_id,
165: X_status_code,P_Lifecycle_Id,P_Current_Phase_Id);

Line 265: insert into mtl_pending_item_status

261: if (X_event = 'INSERT') then
262:
263: -- X_org_id will be the master org
264:
265: insert into mtl_pending_item_status
266: (inventory_item_id,
267: organization_id,
268: status_code,
269: effective_date,

Line 304: insert into mtl_pending_item_status

300: if (status_level = 2) then
301:
302: -- Use this same sql if called from Update Item form
303: -- pass in current org instead of master org
304: insert into mtl_pending_item_status
305: (inventory_item_id,
306: organization_id,
307: status_code,
308: effective_date,

Line 333: insert into mtl_pending_item_status

329: l_user_id);
330:
331: elsif (status_level = 1) then
332:
333: insert into mtl_pending_item_status
334: (inventory_item_id,
335: organization_id,
336: status_code,
337: effective_date,

Line 369: insert into mtl_pending_item_status

365: end if;
366:
367: elsif (X_event = 'ITEM_ORG') then
368:
369: insert into mtl_pending_item_status
370: (inventory_item_id,
371: organization_id,
372: status_code,
373: effective_date,

Line 398: insert into mtl_pending_item_status

394: l_user_id);
395:
396: elsif (X_event = 'ORG_ASSIGN') then
397:
398: insert into mtl_pending_item_status
399: (inventory_item_id,
400: organization_id,
401: status_code,
402: effective_date,