eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 2294: -- add entries into ibe_dsp_msite_sct_items for each mini-site (except

2290: END IF;
2291:
2292: END LOOP;
2293:
2294: -- add entries into ibe_dsp_msite_sct_items for each mini-site (except
2295: -- master mini-sites)
2296: FOR r1 IN c1(p_section_id) LOOP -- for each mini-site
2297:
2298: FOR i IN 1..x_section_item_ids.COUNT LOOP

Line 2508: -- add entries into ibe_dsp_msite_sct_items for each mini-site (except

2504: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507:
2508: -- add entries into ibe_dsp_msite_sct_items for each mini-site (except
2509: -- master mini-sites)
2510: FOR r1 IN c1(p_section_ids(i)) LOOP -- for each mini-site
2511:
2512: IBE_DSP_MSITE_SCT_ITEM_PVT.Create_MSite_Section_Item

Line 2905: -- Get the row in ibe_dsp_msite_sct_items which belongs to mini-site

2901: WHERE child_section_id = l_c_section_id
2902: AND mini_site_id <> l_c_master_mini_site_id;
2903:
2904: --
2905: -- Get the row in ibe_dsp_msite_sct_items which belongs to mini-site
2906: -- l_c_mini_site_id, and the section item id is one of the descendants
2907: -- of the section l_c_section_id
2908: --
2909: -- Bug 2684417 (use UNION instead of OR clause)

Line 2914: FROM ibe_dsp_msite_sct_items MSI,

2910: CURSOR c3(l_c_section_id IN NUMBER,
2911: l_c_mini_site_id IN NUMBER,
2912: l_c_master_mini_site_id IN NUMBER)
2913: IS SELECT MSI.mini_site_section_item_id
2914: FROM ibe_dsp_msite_sct_items MSI,
2915: ibe_dsp_section_items SI,
2916: ibe_dsp_msite_sct_sects MSS
2917: WHERE MSI.mini_site_id = l_c_mini_site_id
2918: AND MSI.section_item_id = SI.section_item_id

Line 2926: FROM ibe_dsp_msite_sct_items MSI,

2922:
2923: UNION
2924:
2925: SELECT MSI.mini_site_section_item_id
2926: FROM ibe_dsp_msite_sct_items MSI,
2927: ibe_dsp_section_items SI,
2928: ibe_dsp_msite_sct_sects MSS
2929: WHERE MSI.mini_site_id = l_c_mini_site_id
2930: AND MSI.section_item_id = SI.section_item_id

Line 3124: -- ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items

3120: END LOOP; -- j loop
3121:
3122: IF (NOT l_found_flag) THEN
3123: -- l_old_mini_site_ids(i)'s association to be removed from
3124: -- ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items
3125:
3126: -- remove from ibe_dsp_msite_sct_items
3127: FOR r3 IN c3(p_section_id, l_old_mini_site_ids(i), l_master_mini_site_id) LOOP
3128: DELETE FROM ibe_dsp_msite_sct_items

Line 3126: -- remove from ibe_dsp_msite_sct_items

3122: IF (NOT l_found_flag) THEN
3123: -- l_old_mini_site_ids(i)'s association to be removed from
3124: -- ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items
3125:
3126: -- remove from ibe_dsp_msite_sct_items
3127: FOR r3 IN c3(p_section_id, l_old_mini_site_ids(i), l_master_mini_site_id) LOOP
3128: DELETE FROM ibe_dsp_msite_sct_items
3129: WHERE mini_site_section_item_id = r3.mini_site_section_item_id;
3130: END LOOP;

Line 3128: DELETE FROM ibe_dsp_msite_sct_items

3124: -- ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items
3125:
3126: -- remove from ibe_dsp_msite_sct_items
3127: FOR r3 IN c3(p_section_id, l_old_mini_site_ids(i), l_master_mini_site_id) LOOP
3128: DELETE FROM ibe_dsp_msite_sct_items
3129: WHERE mini_site_section_item_id = r3.mini_site_section_item_id;
3130: END LOOP;
3131:
3132: -- remove from ibe_dsp_msite_sct_sects

Line 3191: -- ibe_dsp_msite_sct_items table

3187:
3188: IF (NOT l_found_flag) THEN
3189: -- new entry found, should add entry for p_section_id and for all
3190: -- its descendants in ibe_dsp_msite_sct_sects and
3191: -- ibe_dsp_msite_sct_items table
3192:
3193: -- add entries in ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items
3194: -- table
3195: Associate_Recursive_MSite_Sct

Line 3193: -- add entries in ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items

3189: -- new entry found, should add entry for p_section_id and for all
3190: -- its descendants in ibe_dsp_msite_sct_sects and
3191: -- ibe_dsp_msite_sct_items table
3192:
3193: -- add entries in ibe_dsp_msite_sct_sects and ibe_dsp_msite_sct_items
3194: -- table
3195: Associate_Recursive_MSite_Sct
3196: (
3197: p_api_version => p_api_version,

Line 3347: -- and ibe_dsp_msite_sct_items table

3343: END IF;
3344:
3345: --
3346: -- Remove all the occurrences of p_mini_site_id from ibe_dsp_msite_sct_sects
3347: -- and ibe_dsp_msite_sct_items table
3348: --
3349: DELETE FROM ibe_dsp_msite_sct_sects
3350: WHERE mini_site_id = p_mini_site_id;
3351: IF (sql%NOTFOUND) THEN

Line 3356: DELETE FROM ibe_dsp_msite_sct_items

3352: -- ok, as there could be no data in ibe_dsp_msite_sct_sects
3353: NULL;
3354: END IF;
3355:
3356: DELETE FROM ibe_dsp_msite_sct_items
3357: WHERE mini_site_id = p_mini_site_id;
3358: IF (sql%NOTFOUND) THEN
3359: -- ok, as there could be no data in ibe_dsp_msite_sct_items
3360: NULL;

Line 3359: -- ok, as there could be no data in ibe_dsp_msite_sct_items

3355:
3356: DELETE FROM ibe_dsp_msite_sct_items
3357: WHERE mini_site_id = p_mini_site_id;
3358: IF (sql%NOTFOUND) THEN
3359: -- ok, as there could be no data in ibe_dsp_msite_sct_items
3360: NULL;
3361: END IF;
3362:
3363: -- Associate p_mini_site_id with p_section_id and all its descendants

Line 3723: -- ibe_dsp_msite_sct_items table

3719:
3720:
3721: --
3722: -- Delete all the associations for mini-site and inventory item from
3723: -- ibe_dsp_msite_sct_items table
3724: --
3725: DELETE FROM ibe_dsp_msite_sct_items
3726: WHERE section_item_id IN
3727: (SELECT section_item_id FROM ibe_dsp_section_items

Line 3725: DELETE FROM ibe_dsp_msite_sct_items

3721: --
3722: -- Delete all the associations for mini-site and inventory item from
3723: -- ibe_dsp_msite_sct_items table
3724: --
3725: DELETE FROM ibe_dsp_msite_sct_items
3726: WHERE section_item_id IN
3727: (SELECT section_item_id FROM ibe_dsp_section_items
3728: WHERE inventory_item_id = p_inventory_item_id
3729: AND organization_id = p_organization_id);