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_SECTS

Line 89: SELECT parent_section_id FROM ibe_dsp_msite_sct_sects

85: --
86: -- Get the list of ancestors for l_c_section_id upto the root section
87: --
88: CURSOR c1(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER) IS
89: SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
90: WHERE parent_section_id IS NOT NULL
91: AND mini_site_id = l_c_master_mini_site_id
92: START WITH child_section_id = l_c_section_id
93: CONNECT BY PRIOR parent_section_id = child_section_id

Line 142: SELECT child_section_id FROM ibe_dsp_msite_sct_sects

138: l_mini_site_id NUMBER;
139: l_count NUMBER := -1;
140:
141: CURSOR c1(l_c_section_id IN NUMBER) IS
142: SELECT child_section_id FROM ibe_dsp_msite_sct_sects
143: WHERE parent_section_id = l_c_section_id AND
144: mini_site_id = p_master_mini_site_id;
145:
146: BEGIN

Line 318: FROM ibe_dsp_msite_sct_sects

314: --
315: CURSOR c1(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
316: IS SELECT parent_section_id, child_section_id, start_date_active,
317: end_date_active, sort_order
318: FROM ibe_dsp_msite_sct_sects
319: WHERE child_section_id = l_c_section_id
320: AND mini_site_id = l_c_master_mini_site_id;
321:
322: --

Line 328: FROM ibe_dsp_msite_sct_sects MSS, ibe_dsp_sections_b S

324: -- available_in_all_sites_flag set to 'Y' (for master mini-site)
325: --
326: CURSOR c2(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
327: IS SELECT S.section_id AS s_section_id
328: FROM ibe_dsp_msite_sct_sects MSS, ibe_dsp_sections_b S
329: WHERE MSS.child_section_id = S.section_id
330: AND MSS.parent_section_id = l_c_section_id
331: AND MSS.mini_site_id = l_c_master_mini_site_id
332: AND S.available_in_all_sites_flag = 'Y';

Line 890: EXISTS (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

886: IS SELECT msite_id
887: FROM ibe_msites_vl
888: WHERE msite_id <> l_c_master_mini_site_id AND
889: (msite_root_section_id = l_c_section_id OR
890: EXISTS (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
891: WHERE mini_site_id = msite_id
892: AND mini_site_id <> l_c_master_mini_site_id
893: AND child_section_id = l_c_parent_section_id));
894:

Line 1419: -- if sort_number specified, then update ibe_dsp_msite_sct_sects table too

1415: );
1416: END Create_Hierarchy_Section;
1417:
1418: --
1419: -- if sort_number specified, then update ibe_dsp_msite_sct_sects table too
1420: -- p_mss_object_version_number will be used only then, and also it should be
1421: -- specified if sort_number is specified
1422: -- p_upd_dsc_scts_status (value 'Y' or 'N') will be used to update all the
1423: -- descendant section's (of p_section_id) status to p_status_code. If Y, then

Line 1487: FROM ibe_dsp_msite_sct_sects

1483: l_master_root_section_id NUMBER;
1484:
1485: CURSOR c1(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
1486: IS SELECT parent_section_id
1487: FROM ibe_dsp_msite_sct_sects
1488: WHERE child_section_id = l_c_section_id
1489: AND mini_site_id = l_c_master_mini_site_id;
1490:
1491: CURSOR c2(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)

Line 1493: FROM ibe_dsp_msite_sct_sects

1489: AND mini_site_id = l_c_master_mini_site_id;
1490:
1491: CURSOR c2(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
1492: IS SELECT mini_site_section_section_id
1493: FROM ibe_dsp_msite_sct_sects
1494: WHERE mini_site_id = l_c_master_mini_site_id
1495: AND parent_section_id = l_c_section_id;
1496:
1497: --

Line 1504: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

1500: --
1501: CURSOR c3(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
1502: IS SELECT section_id, object_version_number FROM ibe_dsp_sections_b
1503: WHERE section_id IN
1504: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
1505: WHERE mini_site_id = l_c_master_mini_site_id
1506: START WITH parent_section_id = l_c_section_id
1507: AND mini_site_id = l_c_master_mini_site_id
1508: CONNECT BY PRIOR child_section_id = parent_section_id

Line 1640: -- Update ibe_dsp_msite_sct_sects only if the sort order is present

1636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1637: END IF;
1638:
1639: --
1640: -- Update ibe_dsp_msite_sct_sects only if the sort order is present
1641: --
1642: IF (p_sort_order <> FND_API.G_MISS_NUM) THEN
1643: --
1644: -- get parent section id of the section to be updated

Line 1658: -- update ibe_dsp_msite_sct_sects

1654: END IF;
1655: CLOSE c1;
1656:
1657: --
1658: -- update ibe_dsp_msite_sct_sects
1659: --
1660: IBE_DSP_MSITE_SCT_SECT_PVT.Update_MSite_Section_Section
1661: (
1662: p_api_version => p_api_version,

Line 1839: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

1835: WHERE access_name = l_c_access_name;
1836:
1837: CURSOR c_get_child_sections( l_section_id in NUMBER ,l_master_mini_site_id in NUMBER) IS
1838: SELECT S.section_id
1839: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
1840: WHERE S.section_id = MSS.child_section_id
1841: AND MSS.mini_site_id = l_master_mini_site_id
1842: AND S.section_id IN
1843: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 1843: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

1839: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
1840: WHERE S.section_id = MSS.child_section_id
1841: AND MSS.mini_site_id = l_master_mini_site_id
1842: AND S.section_id IN
1843: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
1844: WHERE mini_site_id = l_master_mini_site_id
1845: START WITH parent_section_id = l_section_id
1846: AND mini_site_id = l_master_mini_site_id
1847: CONNECT BY PRIOR child_section_id = parent_section_id

Line 2197: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

2193:
2194: -- get all the mini-sites to which the section belongs to except the
2195: -- master mini-site(s)
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');

Line 2417: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

2413:
2414: -- get all the mini-sites to which the section belongs to except the
2415: -- master mini-site(s)
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');

Line 2887: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

2883: -- and which does not include master mini-site id
2884: --
2885: CURSOR c1(l_c_child_section_id IN NUMBER,
2886: l_c_master_mini_site_id IN NUMBER)
2887: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
2888: WHERE child_section_id =
2889: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
2890: WHERE child_section_id = l_c_child_section_id
2891: AND mini_site_id = l_c_master_mini_site_id)

Line 2889: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects

2885: CURSOR c1(l_c_child_section_id IN NUMBER,
2886: l_c_master_mini_site_id IN NUMBER)
2887: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
2888: WHERE child_section_id =
2889: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
2890: WHERE child_section_id = l_c_child_section_id
2891: AND mini_site_id = l_c_master_mini_site_id)
2892: AND mini_site_id <> l_c_master_mini_site_id;
2893:

Line 2900: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

2896: -- not include master mini-site id
2897: --
2898: CURSOR c2(l_c_section_id IN NUMBER,
2899: l_c_master_mini_site_id IN NUMBER)
2900: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
2901: WHERE child_section_id = l_c_section_id
2902: AND mini_site_id <> l_c_master_mini_site_id;
2903:
2904: --

Line 2916: ibe_dsp_msite_sct_sects MSS

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
2920: AND MSS.mini_site_id = l_c_master_mini_site_id

Line 2928: ibe_dsp_msite_sct_sects MSS

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
2932: AND MSS.mini_site_id = l_c_master_mini_site_id

Line 2935: FROM ibe_dsp_msite_sct_sects

2931: AND SI.section_id = MSS.child_section_id
2932: AND MSS.mini_site_id = l_c_master_mini_site_id
2933: AND MSS.child_section_id IN
2934: (SELECT child_section_id
2935: FROM ibe_dsp_msite_sct_sects
2936: START WITH parent_section_id = l_c_section_id
2937: AND mini_site_id = l_master_mini_site_id
2938: CONNECT BY PRIOR child_section_id = parent_section_id
2939: AND mini_site_id = l_master_mini_site_id);

Line 2949: -- FROM ibe_dsp_msite_sct_sects

2945: -- CURSOR c4(l_c_section_id IN NUMBER,
2946: -- l_c_master_mini_site_id IN NUMBER)
2947: -- IS SELECT parent_section_id, child_section_id, start_date_active,
2948: -- end_date_active, sort_order
2949: -- FROM ibe_dsp_msite_sct_sects
2950: -- WHERE mini_site_id = l_c_master_mini_site_id
2951: -- START WITH child_section_id = l_c_section_id
2952: -- CONNECT BY PRIOR child_section_id = parent_section_id
2953: -- AND PRIOR mini_site_id = l_c_master_mini_site_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 2964: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
2964: -- (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
2965: -- START WITH child_section_id = l_c_section_id
2966: -- CONNECT BY PRIOR child_section_id = parent_section_id
2967: -- AND PRIOR mini_site_id = l_c_master_mini_site_id));
2968:

Line 2985: FROM ibe_dsp_msite_sct_sects

2981: --
2982: CURSOR c_get_section_hierary_info(l_c_section_id IN NUMBER,
2983: l_c_master_mini_site_id IN NUMBER)
2984: IS SELECT parent_section_id, start_date_active, end_date_active, sort_order
2985: FROM ibe_dsp_msite_sct_sects
2986: WHERE child_section_id = l_c_section_id
2987: AND mini_site_id = l_c_master_mini_site_id;
2988:
2989: l_parent_section_id NUMBER;

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 3132: -- remove from ibe_dsp_msite_sct_sects

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
3133: --Bug 2684417 (break up into 2 deletes)
3134: DELETE FROM ibe_dsp_msite_sct_sects
3135: WHERE mini_site_id = l_old_mini_site_ids(i)
3136: AND child_section_id = p_section_id;

Line 3134: DELETE FROM ibe_dsp_msite_sct_sects

3130: END LOOP;
3131:
3132: -- remove from ibe_dsp_msite_sct_sects
3133: --Bug 2684417 (break up into 2 deletes)
3134: DELETE FROM ibe_dsp_msite_sct_sects
3135: WHERE mini_site_id = l_old_mini_site_ids(i)
3136: AND child_section_id = p_section_id;
3137:
3138: DELETE FROM ibe_dsp_msite_sct_sects

Line 3138: DELETE FROM ibe_dsp_msite_sct_sects

3134: DELETE FROM ibe_dsp_msite_sct_sects
3135: WHERE mini_site_id = l_old_mini_site_ids(i)
3136: AND child_section_id = p_section_id;
3137:
3138: DELETE FROM ibe_dsp_msite_sct_sects
3139: WHERE mini_site_id = l_old_mini_site_ids(i)
3140: AND child_section_id IN
3141: (SELECT child_section_id
3142: FROM ibe_dsp_msite_sct_sects

Line 3142: FROM ibe_dsp_msite_sct_sects

3138: DELETE FROM ibe_dsp_msite_sct_sects
3139: WHERE mini_site_id = l_old_mini_site_ids(i)
3140: AND child_section_id IN
3141: (SELECT child_section_id
3142: FROM ibe_dsp_msite_sct_sects
3143: START WITH parent_section_id = p_section_id
3144: AND mini_site_id = l_master_mini_site_id
3145: CONNECT BY prior child_section_id = parent_section_id
3146: AND mini_site_id = l_master_mini_site_id);

Line 3173: UPDATE IBE_DSP_MSITE_SCT_SECTS

3169: -- minisite id is linked to the section already
3170: -- If so, update the section-msite record if the parent section
3171: -- is not set correctly.
3172: IF (l_parent_section_id <> -1) AND (l_parent_section_id IS NOT NULL) THEN
3173: UPDATE IBE_DSP_MSITE_SCT_SECTS
3174: SET parent_section_id = l_parent_section_id,
3175: start_date_active = l_start_date_active,
3176: end_date_active = l_end_date_active,
3177: sort_order = l_sort_order,

Line 3190: -- its descendants in ibe_dsp_msite_sct_sects and

3186: END LOOP; -- loop j
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

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 3346: -- Remove all the occurrences of p_mini_site_id from ibe_dsp_msite_sct_sects

3342: RAISE FND_API.G_EXC_ERROR;
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;

Line 3349: DELETE FROM ibe_dsp_msite_sct_sects

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
3352: -- ok, as there could be no data in ibe_dsp_msite_sct_sects
3353: NULL;

Line 3352: -- ok, as there could be no data in ibe_dsp_msite_sct_sects

3348: --
3349: DELETE FROM ibe_dsp_msite_sct_sects
3350: WHERE mini_site_id = p_mini_site_id;
3351: IF (sql%NOTFOUND) THEN
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

Line 3687: AND EXISTS (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
3689: AND mini_site_id = l_c_mini_site_id
3690: AND mini_site_id <> l_c_master_mini_site_id);
3691:

Line 3732: -- ok, as there could be no data in ibe_dsp_msite_sct_sects

3728: WHERE inventory_item_id = p_inventory_item_id
3729: AND organization_id = p_organization_id);
3730:
3731: IF (sql%NOTFOUND) THEN
3732: -- ok, as there could be no data in ibe_dsp_msite_sct_sects
3733: NULL;
3734: END IF;
3735:
3736: --

Line 3853: IS SELECT child_section_id FROM ibe_dsp_msite_sct_sects

3849: l_section_item_id NUMBER;
3850: l_child_section_id NUMBER;
3851:
3852: CURSOR c1(l_c_msite_section_section_id IN NUMBER)
3853: IS SELECT child_section_id FROM ibe_dsp_msite_sct_sects
3854: WHERE mini_site_section_section_id = l_c_msite_section_section_id;
3855:
3856: BEGIN
3857:

Line 4097: -- concat_ids is updated in table IBE_DSP_MSITE_SCT_SECTS for master mini-site.

4093: -- section should not have children as items and also cannot be a featured
4094: -- section. After validation, this procedure makes p_dst_parent_section_id
4095: -- as the parent of p_src_section_id. Then for all the descendant sections
4096: -- of p_src_section_id including p_src_section_id, the level_number and
4097: -- concat_ids is updated in table IBE_DSP_MSITE_SCT_SECTS for master mini-site.
4098: -- Lastly, the association of the (p_src_section_id and all it's descendants
4099: -- including sections and section-items) and mini-sites is updated.
4100: --
4101: PROCEDURE Cut_And_Paste_Section

Line 4144: IS SELECT parent_section_id, child_section_id FROM ibe_dsp_msite_sct_sects

4140:
4141: -- Get all the descendant sections including l_c_section_id, starting from
4142: -- l_c_section_id
4143: CURSOR c3(l_c_section_id IN NUMBER, l_c_master_mini_site_id IN NUMBER)
4144: IS SELECT parent_section_id, child_section_id FROM ibe_dsp_msite_sct_sects
4145: WHERE mini_site_id = l_c_master_mini_site_id
4146: START WITH child_section_id = l_c_section_id
4147: AND mini_site_id = l_c_master_mini_site_id
4148: CONNECT BY PRIOR child_section_id = parent_section_id

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 4157: IS SELECT mini_site_id FROM ibe_dsp_msite_sct_sects

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
4158: WHERE child_section_id =
4159: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
4160: WHERE child_section_id = l_c_section_id
4161: AND mini_site_id = l_c_master_mini_site_id)

Line 4159: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects

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
4158: WHERE child_section_id =
4159: (SELECT parent_section_id FROM ibe_dsp_msite_sct_sects
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

Line 4176: IS SELECT child_section_id FROM ibe_dsp_msite_sct_sects

4172: --
4173: CURSOR c5(l_c_src_section_id IN NUMBER,
4174: l_c_dst_parent_section_id IN NUMBER,
4175: l_c_master_mini_site_id IN NUMBER)
4176: IS SELECT child_section_id FROM ibe_dsp_msite_sct_sects
4177: WHERE child_section_id = l_c_dst_parent_section_id
4178: AND mini_site_id = l_c_master_mini_site_id
4179: START WITH child_section_id = l_c_src_section_id
4180: AND mini_site_id = l_c_master_mini_site_id

Line 4307: UPDATE ibe_dsp_msite_sct_sects

4303: -- Make p_dst_parent_section_id parent of p_src_section_id by removing
4304: -- p_src_section_id as a child from its current parent at the same time
4305: --
4306: BEGIN
4307: UPDATE ibe_dsp_msite_sct_sects
4308: SET parent_section_id = p_dst_parent_section_id
4309: WHERE child_section_id = p_src_section_id
4310: AND mini_site_id = l_master_mini_site_id;
4311: EXCEPTION

Line 4338: UPDATE ibe_dsp_msite_sct_sects

4334: x_concat_ids => l_concat_ids,
4335: x_level_number => l_level_number
4336: );
4337:
4338: UPDATE ibe_dsp_msite_sct_sects
4339: SET concat_ids = l_concat_ids,
4340: level_number = l_level_number + 1
4341: WHERE child_section_id = r3.child_section_id
4342: AND mini_site_id = l_master_mini_site_id;

Line 4571: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

4567: S.attribute_category, S.attribute1, S.attribute2, S.attribute3,
4568: S.attribute4, S.attribute5, S.attribute6, S.attribute7, S.attribute8,
4569: S.attribute9, S.attribute10, S.attribute11, S.attribute12, S.attribute13,
4570: S.attribute14, S.attribute15, MSS.sort_order
4571: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
4572: WHERE S.section_id = l_c_section_id
4573: AND MSS.child_section_id = S.section_id
4574: AND MSS.mini_site_id = l_c_master_mini_site_id;
4575:

Line 4589: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

4585: S.attribute_category, S.attribute1, S.attribute2, S.attribute3,
4586: S.attribute4, S.attribute5, S.attribute6, S.attribute7, S.attribute8,
4587: S.attribute9, S.attribute10, S.attribute11, S.attribute12, S.attribute13,
4588: S.attribute14, S.attribute15, MSS.sort_order, MSS.parent_section_id
4589: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
4590: WHERE S.section_id = MSS.child_section_id
4591: AND MSS.mini_site_id = l_c_master_mini_site_id
4592: AND S.section_id IN
4593: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 4593: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

4589: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
4590: WHERE S.section_id = MSS.child_section_id
4591: AND MSS.mini_site_id = l_c_master_mini_site_id
4592: AND S.section_id IN
4593: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects
4594: WHERE mini_site_id = l_c_master_mini_site_id
4595: START WITH parent_section_id = l_c_section_id
4596: AND mini_site_id = l_c_master_mini_site_id
4597: CONNECT BY PRIOR child_section_id = parent_section_id

Line 4610: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

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
4612: START WITH parent_section_id = l_c_section_id
4613: AND mini_site_id = l_c_master_mini_site_id
4614: CONNECT BY PRIOR child_section_id = parent_section_id

Line 5817: FROM ibe_dsp_msite_sct_sects

5813: CURSOR c_get_child_section(
5814: c_section_id NUMBER,
5815: c_master_mini_site_id NUMBER) IS
5816: SELECT child_section_id
5817: FROM ibe_dsp_msite_sct_sects
5818: WHERE mini_site_id = c_master_mini_site_id
5819: START WITH parent_section_id = c_section_id
5820: AND mini_site_id = c_master_mini_site_id
5821: CONNECT BY PRIOR child_section_id = parent_section_id

Line 6105: FROM ibe_dsp_msite_sct_sects

6101:
6102: CURSOR c_get_child_section(c_section_id NUMBER,
6103: c_master_mini_site_id NUMBER) IS
6104: SELECT child_section_id
6105: FROM ibe_dsp_msite_sct_sects
6106: WHERE mini_site_id = c_master_mini_site_id
6107: START WITH parent_section_id = c_section_id
6108: AND mini_site_id = c_master_mini_site_id
6109: CONNECT BY PRIOR child_section_id = parent_section_id