DBA Data[Home] [Help]

APPS.AMS_MINISITE_DENORM_PVT dependencies on AMS_IBA_MS_ITEMS_DENORM

Line 5: -- script used to populate AMS_IBA_MS_ITEMS_DENORM table

1: package body AMS_MINISITE_DENORM_PVT as
2: /* $Header: amsvmsib.pls 120.2 2005/12/30 00:33:00 sikalyan ship $ */
3:
4: --=======================================================
5: -- script used to populate AMS_IBA_MS_ITEMS_DENORM table
6: -- with data required for section search
7: --=======================================================
8:
9: procedure loadMsitesDenormTable(

Line 106: DELETE FROM ams_iba_ms_items_denorm;

102:
103:
104: BEGIN
105:
106: DELETE FROM ams_iba_ms_items_denorm;
107:
108: --commit;
109:
110: for v_CompoundData in compCur loop

Line 116: insert into ams_iba_ms_items_denorm

112: for sectionIdData in allTopLevelSections(v_CompoundData.MSITE_ID, v_CompoundData.MSITE_ROOT_SECTION_ID ) loop
113:
114: for ItemData in ItemCur(sectionIdData.section_id, v_CompoundData.MSITE_ID)
115: loop
116: insert into ams_iba_ms_items_denorm
117: ( item_id --inventory_item_id
118: , inventory_org_id --organization_id
119: , top_section_id --section_id
120: , minisite_id

Line 136: ams_iba_ms_items_denorm_s.nextval,

132: ItemData.inventory_item_id,
133: ItemData.organization_id,
134: sectionIdData.section_id,
135: v_CompoundData.MSITE_ID,
136: ams_iba_ms_items_denorm_s.nextval,
137: v_CompoundData.start_date_active,
138: 1,
139: FND_GLOBAL.user_id,
140: SYSDATE,

Line 150: -- NextMinisiteItemId, --ams_iba_ms_items_denorm_s.nextval,

146: end loop;
147: /*
148: select distinct f.inventory_item_id,f.organization_id, sectionIdData.section_id,
149: v_CompoundData.MSITE_ID,
150: -- NextMinisiteItemId, --ams_iba_ms_items_denorm_s.nextval,
151: ams_iba_ms_items_denorm_s.nextval,
152: v_CompoundData.start_date_active,
153: 1,
154: FND_GLOBAL.user_id,

Line 151: ams_iba_ms_items_denorm_s.nextval,

147: /*
148: select distinct f.inventory_item_id,f.organization_id, sectionIdData.section_id,
149: v_CompoundData.MSITE_ID,
150: -- NextMinisiteItemId, --ams_iba_ms_items_denorm_s.nextval,
151: ams_iba_ms_items_denorm_s.nextval,
152: v_CompoundData.start_date_active,
153: 1,
154: FND_GLOBAL.user_id,
155: SYSDATE,