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_SECTION_ITEMS

Line 339: FROM ibe_dsp_section_items

335: -- Get all the children items for the section l_c_section_id
336: --
337: CURSOR c3(l_c_section_id IN NUMBER)
338: IS SELECT section_item_id
339: FROM ibe_dsp_section_items
340: WHERE section_id = l_c_section_id;
341:
342: BEGIN
343:

Line 871: FROM ibe_dsp_section_items

867: WHERE access_name = l_c_access_name;
868:
869: CURSOR c3(l_c_section_id IN NUMBER)
870: IS SELECT section_item_id
871: FROM ibe_dsp_section_items
872: WHERE section_id = l_c_section_id;
873:
874: CURSOR c4 IS SELECT msite_root_section_id
875: FROM ibe_msites_b

Line 2206: IS SELECT section_item_id FROM ibe_dsp_section_items

2202:
2203: CURSOR c2(l_c_section_id IN NUMBER,
2204: l_c_inventory_item_id IN NUMBER,
2205: l_c_organization_id IN NUMBER)
2206: IS SELECT section_item_id FROM ibe_dsp_section_items
2207: WHERE section_id = l_c_section_id
2208: AND inventory_item_id = l_c_inventory_item_id
2209: AND organization_id = l_c_organization_id;
2210:

Line 2264: -- insert an entry in ibe_dsp_section_items table

2260:
2261: CLOSE c2;
2262: l_duplicate_flags(i) := FND_API.G_RET_STS_SUCCESS;
2263:
2264: -- insert an entry in ibe_dsp_section_items table
2265: IBE_DSP_SECTION_ITEM_PVT.Create_Section_Item
2266: (
2267: p_api_version => p_api_version,
2268: p_init_msg_list => FND_API.G_FALSE,

Line 2426: IS SELECT section_item_id FROM ibe_dsp_section_items

2422:
2423: CURSOR c2(l_c_section_id IN NUMBER,
2424: l_c_inventory_item_id IN NUMBER,
2425: l_c_organization_id IN NUMBER)
2426: IS SELECT section_item_id FROM ibe_dsp_section_items
2427: WHERE section_id = l_c_section_id
2428: AND inventory_item_id = l_c_inventory_item_id
2429: AND organization_id = l_c_organization_id;
2430:

Line 2481: -- insert an entry in ibe_dsp_section_items table

2477:
2478: CLOSE c2;
2479:
2480: --
2481: -- insert an entry in ibe_dsp_section_items table
2482: --
2483: IBE_DSP_SECTION_ITEM_PVT.Create_Section_Item
2484: (
2485: p_api_version => p_api_version,

Line 2642: -- delete entry in ibe_dsp_section_items table

2638: -- todo optimize using FORALL and BIND COLLECT
2639: FOR i IN 1..p_section_ids.COUNT LOOP
2640:
2641: FOR j IN 1..p_inventory_item_ids.COUNT LOOP
2642: -- delete entry in ibe_dsp_section_items table
2643: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
2644: (
2645: p_api_version => p_api_version,
2646: p_init_msg_list => FND_API.G_FALSE,

Line 2768: -- delete entry in ibe_dsp_section_items table

2764:
2765: -- todo optimize using FORALL and BIND COLLECT
2766: FOR i IN 1..p_section_item_ids.COUNT LOOP
2767:
2768: -- delete entry in ibe_dsp_section_items table
2769: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
2770: (
2771: p_api_version => p_api_version,
2772: p_init_msg_list => FND_API.G_FALSE,

Line 2915: ibe_dsp_section_items SI,

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
2919: AND SI.section_id = MSS.child_section_id

Line 2927: ibe_dsp_section_items SI,

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
2931: AND SI.section_id = MSS.child_section_id

Line 2959: -- FROM ibe_dsp_msite_sct_sects MSS, ibe_dsp_section_items SI

2955: --
2956: -- CURSOR c5(l_c_section_id IN NUMBER,
2957: -- l_c_master_mini_site_id IN NUMBER)
2958: -- IS SELECT SI.section_item_id
2959: -- FROM ibe_dsp_msite_sct_sects MSS, ibe_dsp_section_items SI
2960: -- WHERE SI.section_id = MSS.child_section_id
2961: -- AND MSS.mini_site_id = l_c_master_mini_site_id
2962: -- AND (MSS.child_section_id = l_c_section_id OR
2963: -- MSS.child_section_id IN

Line 3684: IS SELECT section_item_id FROM ibe_dsp_section_items

3680: CURSOR c1(l_c_inventory_item_id IN NUMBER,
3681: l_c_organization_id IN NUMBER,
3682: l_c_mini_site_id IN NUMBER,
3683: l_c_master_mini_site_id IN NUMBER)
3684: IS SELECT section_item_id FROM ibe_dsp_section_items
3685: WHERE inventory_item_id = l_c_inventory_item_id
3686: AND organization_id = l_c_organization_id
3687: AND EXISTS (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
3688: WHERE child_section_id = section_id

Line 3727: (SELECT section_item_id FROM ibe_dsp_section_items

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);
3730:
3731: IF (sql%NOTFOUND) THEN

Line 4138: FROM ibe_dsp_section_items

4134:
4135: -- Get the section-item-ids for the section
4136: CURSOR c2(l_c_section_id IN NUMBER)
4137: IS SELECT section_item_id
4138: FROM ibe_dsp_section_items
4139: WHERE section_id = l_c_section_id;
4140:
4141: -- Get all the descendant sections including l_c_section_id, starting from
4142: -- l_c_section_id

Line 4607: FROM ibe_dsp_section_items

4603: --
4604: CURSOR c3(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
4605: IS SELECT section_item_id, section_id, inventory_item_id, organization_id,
4606: start_date_active, end_date_active, sort_order, association_reason_code
4607: FROM ibe_dsp_section_items
4608: WHERE section_id = l_c_section_id
4609: OR section_id IN
4610: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
4611: WHERE mini_site_id = l_c_master_mini_site_id