APPS.AMS_CAMPAIGN_ITEMS_DENORM_PVT dependencies on AMS_IBA_CPN_ITEMS_DENORM

Line 5: -- script to populate AMS_IBA_CPN_ITEMS_DENORM table

1: package body AMS_CAMPAIGN_ITEMS_DENORM_PVT as
2: /* $Header: amsvcpib.pls 115.3 2003/02/18 13:35:56 sikalyan ship $ */
3:
4: --=======================================================
5: -- script to populate AMS_IBA_CPN_ITEMS_DENORM table
6: --=======================================================
7:
8: procedure loadCampaignItemsDenormTable(
9: errbuf OUT NOCOPY VARCHAR2,

Line 32: DELETE FROM ams_iba_cpn_items_denorm;

28: -- AND nvl(b.end_date_time,SYSDATE) >= SYSDATE
29:
30: BEGIN
31:
32: DELETE FROM ams_iba_cpn_items_denorm;
33:
34: -- commit;
35:
36: for SchedItem in SchedCur loop

Line 40: insert into ams_iba_cpn_items_denorm

36: for SchedItem in SchedCur loop
37:
38: IF SchedItem.inventory_item_id is NOT NULL
39: THEN
40: insert into ams_iba_cpn_items_denorm
41: ( cpn_item_id
42: , item_id
43: , inventory_org_id
44: , object_used_by_type

Line 54: ams_iba_cpn_items_denorm_s.nextval,

50: , LAST_UPDATED_DATE
51: , LAST_UPDATE_LOGIN
52: )
53: select
54: ams_iba_cpn_items_denorm_s.nextval,
55: SchedItem.inventory_item_id,
56: SchedItem.organization_id,
57: SchedItem.arc_act_product_used_by,
58: SchedItem.act_product_used_by_id,

Line 70: INSERT INTO ams_iba_cpn_items_denorm

66: END IF;
67:
68: IF SchedItem.category_id IS NOT NULL
69: THEN
70: INSERT INTO ams_iba_cpn_items_denorm
71: ( cpn_item_id
72: , item_id
73: , inventory_org_id
74: , object_used_by_type

Line 84: ams_iba_cpn_items_denorm_s.nextval,

80: , LAST_UPDATED_DATE
81: , LAST_UPDATE_LOGIN
82: )
83: SELECT
84: ams_iba_cpn_items_denorm_s.nextval,
85: inventory_item_id,
86: organization_id,
87: SchedItem.arc_act_product_used_by,
88: SchedItem.act_product_used_by_id,

Line 98: (select 'x' from ams_iba_cpn_items_denorm

94: FND_GLOBAL.conc_login_id
95: FROM mtl_item_categories a
96: WHERE category_id = SchedItem.category_id
97: AND NOT EXISTS
98: (select 'x' from ams_iba_cpn_items_denorm
99: where item_id = a.inventory_item_id
100: AND inventory_org_id = a.organization_id);
101:
102: END IF;