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_MSITES_B

Line 55: SELECT msite_id, msite_root_section_id FROM ibe_msites_b

51: 'Get_Master_Mini_Site_Id';
52: l_api_version CONSTANT NUMBER := 1.0;
53:
54: CURSOR c1 IS
55: SELECT msite_id, msite_root_section_id FROM ibe_msites_b
56: WHERE UPPER(master_msite_flag) = 'Y';
57: BEGIN
58:
59: OPEN c1;

Line 875: FROM ibe_msites_b

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
876: WHERE master_msite_flag = 'Y';
877:
878: CURSOR c5(l_c_master_mini_site_id IN NUMBER)
879: IS SELECT msite_id

Line 1152: -- If root section is being inserted, make sure that ibe_msites_b is

1148:
1149: -- todo fm
1150:
1151: --
1152: -- If root section is being inserted, make sure that ibe_msites_b is
1153: -- updated to have msite_root_section_id as x_section_id
1154: --
1155: IF (l_is_root_section) THEN
1156:

Line 1157: UPDATE ibe_msites_b

1153: -- updated to have msite_root_section_id as x_section_id
1154: --
1155: IF (l_is_root_section) THEN
1156:
1157: UPDATE ibe_msites_b
1158: SET msite_root_section_id = x_section_id,
1159: object_version_number = object_version_number + 1
1160: WHERE master_msite_flag = 'Y';
1161:

Line 2200: (SELECT msite_id FROM ibe_msites_b

2196: CURSOR c1(l_c_section_id IN NUMBER)
2197: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
2198: WHERE child_section_id = l_c_section_id
2199: AND mini_site_id NOT IN
2200: (SELECT msite_id FROM ibe_msites_b
2201: WHERE UPPER(master_msite_flag) = 'Y');
2202:
2203: CURSOR c2(l_c_section_id IN NUMBER,
2204: l_c_inventory_item_id IN NUMBER,

Line 2420: (SELECT msite_id FROM ibe_msites_b

2416: CURSOR c1(l_c_section_id IN NUMBER)
2417: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
2418: WHERE child_section_id = l_c_section_id
2419: AND mini_site_id NOT IN
2420: (SELECT msite_id FROM ibe_msites_b
2421: WHERE UPPER(master_msite_flag) = 'Y');
2422:
2423: CURSOR c2(l_c_section_id IN NUMBER,
2424: l_c_inventory_item_id IN NUMBER,

Line 2974: FROM ibe_msites_b

2970: -- Get the list of mini-sites for which l_c_section_id is the
2971: -- root section id
2972: --
2973: CURSOR c6(l_c_section_id IN NUMBER) IS SELECT msite_id
2974: FROM ibe_msites_b
2975: WHERE msite_root_section_id = l_c_section_id
2976: AND master_msite_flag <> 'Y';
2977:
2978: --

Line 3283: -- p_mini_site_id in ibe_msites_b table

3279: -- Previously associated sections and items for this mini-site will be removed
3280: -- Also all the descendants of p_section_id will have an association with
3281: -- p_mini_site_id (for seciton, if available_in_all_sites_flag is 'Y')
3282: -- This procedure doesn't check if p_section_id is root section id for
3283: -- p_mini_site_id in ibe_msites_b table
3284: --
3285: PROCEDURE Associate_Root_Sct_To_MSite
3286: (
3287: p_api_version IN NUMBER,

Line 4153: -- ibe_dsp_msite_sct_sects) and with l_c_section_id (from ibe_msites_b)

4149: AND PRIOR mini_site_id = l_c_master_mini_site_id
4150: AND mini_site_id = l_c_master_mini_site_id;
4151:
4152: -- Get all the mini-sites associated with the parent of l_c_section_id (from
4153: -- ibe_dsp_msite_sct_sects) and with l_c_section_id (from ibe_msites_b)
4154: -- where l_c_section_id is root section of mini-sites (excluding master
4155: -- mini-site)
4156: CURSOR c4(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
4157: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

Line 4164: SELECT msite_id AS mini_site_id FROM ibe_msites_b

4160: WHERE child_section_id = l_c_section_id
4161: AND mini_site_id = l_c_master_mini_site_id)
4162: AND mini_site_id <> l_c_master_mini_site_id
4163: UNION
4164: SELECT msite_id AS mini_site_id FROM ibe_msites_b
4165: WHERE msite_root_section_id = l_c_section_id
4166: AND msite_id <> l_c_master_mini_site_id;
4167:
4168: --

Line 4367: -- to which the current section is the root section (ibe_msites_b). Since

4363: -- Associate the new set of mini-sites to p_src_section_id and its
4364: -- descendants including section-items. For each of these sections (starting
4365: -- from p_src_section_id), the list of mini-sites associated will be the
4366: -- union of mini-sites to which their respective parent belong and mini-sites
4367: -- to which the current section is the root section (ibe_msites_b). Since
4368: -- the association with start in top-down fashion, the query for c4 will
4369: -- return the updated results as the loop for c3 progresses.
4370: --
4371: -- For each descendant sections of p_src_section_id including

Line 4376: -- and with r33.child_section_id (thru ibe_msites_b)

4372: -- p_src_section_id
4373: FOR r33 IN c3(p_src_section_id, l_master_mini_site_id) LOOP
4374:
4375: -- For each mini-site associated with parent of r33.child_section_id
4376: -- and with r33.child_section_id (thru ibe_msites_b)
4377: l_counter := 1;
4378: l_mini_site_ids := JTF_NUMBER_TABLE();
4379: FOR r4 IN c4(r33.child_section_id, l_master_mini_site_id) LOOP
4380: l_mini_site_ids.EXTEND();