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_SECTIONS_B

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 556: FROM ibe_dsp_sections_b

552: x_layout_type OUT NOCOPY VARCHAR2)
553: IS
554: CURSOR c_get_deliverable_id_csr(c_section_id NUMBER) IS
555: SELECT deliverable_id
556: FROM ibe_dsp_sections_b
557: WHERE section_id = c_section_id;
558:
559: l_deliverable_id NUMBER;
560: BEGIN

Line 861: FROM ibe_dsp_sections_b

857: AND application_id = l_c_application_id;
858:
859: CURSOR c1(l_c_section_id IN NUMBER)
860: IS SELECT section_type_code
861: FROM ibe_dsp_sections_b
862: WHERE section_id = l_c_section_id;
863:
864: CURSOR c2(l_c_access_name IN VARCHAR2)
865: IS SELECT section_id, section_type_code

Line 866: FROM ibe_dsp_sections_b

862: WHERE section_id = l_c_section_id;
863:
864: CURSOR c2(l_c_access_name IN VARCHAR2)
865: IS SELECT section_id, section_type_code
866: FROM ibe_dsp_sections_b
867: WHERE access_name = l_c_access_name;
868:
869: CURSOR c3(l_c_section_id IN NUMBER)
870: IS SELECT section_item_id

Line 1502: IS SELECT section_id, object_version_number FROM ibe_dsp_sections_b

1498: -- Get the descendant sections of l_c_section_id (not including
1499: -- l_c_section_id)
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

Line 1834: IS SELECT section_id FROM ibe_dsp_sections_b

1830: l_master_mini_site_id NUMBER;
1831: l_master_root_section_id NUMBER;
1832:
1833: CURSOR c1(l_c_access_name IN VARCHAR2)
1834: IS SELECT section_id FROM ibe_dsp_sections_b
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

Line 2018: IS SELECT section_id FROM ibe_dsp_sections_b

2014: l_master_mini_site_id NUMBER;
2015: l_master_root_section_id NUMBER;
2016:
2017: CURSOR c1(l_c_access_name IN VARCHAR2)
2018: IS SELECT section_id FROM ibe_dsp_sections_b
2019: WHERE access_name = l_c_access_name;
2020:
2021: BEGIN
2022:

Line 4132: FROM ibe_dsp_sections_b

4128:
4129: -- Get the section type code for the section
4130: CURSOR c1(l_c_section_id IN NUMBER)
4131: IS SELECT section_type_code
4132: FROM ibe_dsp_sections_b
4133: WHERE section_id = l_c_section_id;
4134:
4135: -- Get the section-item-ids for the section
4136: CURSOR c2(l_c_section_id IN NUMBER)

Line 6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');

6175: IBE_UTIL.debug('Updating section deliverable id');
6176: END IF;
6177: -- x_section_ids := JTF_NUMBER_TABLE();
6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,
6182: last_update_date = SYSDATE,
6183: last_updated_by = FND_GLOBAL.user_id,

Line 6180: UPDATE ibe_dsp_sections_b

6176: END IF;
6177: -- x_section_ids := JTF_NUMBER_TABLE();
6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');
6180: UPDATE ibe_dsp_sections_b
6181: SET deliverable_id = l_new_deliverable_id,
6182: last_update_date = SYSDATE,
6183: last_updated_by = FND_GLOBAL.user_id,
6184: object_version_number = object_version_number + 1

Line 6186: -- dbms_output.put_line('After updating ibe_dsp_sections_b');

6182: last_update_date = SYSDATE,
6183: last_updated_by = FND_GLOBAL.user_id,
6184: object_version_number = object_version_number + 1
6185: WHERE section_id = p_section_id;
6186: -- dbms_output.put_line('After updating ibe_dsp_sections_b');
6187: -------------------------------------
6188: -------------------------------------
6189: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6190: IF (l_debug = 'Y') THEN

Line 6255: UPDATE ibe_dsp_sections_b

6251: Get_Master_Mini_Site_Id(x_mini_site_id => l_master_minisite_id,
6252: x_root_section_id => l_root_section_id);
6253: FOR child_section IN c_get_child_section(p_section_id,
6254: l_master_minisite_id) LOOP
6255: UPDATE ibe_dsp_sections_b
6256: SET deliverable_id = l_new_deliverable_id,
6257: last_update_date = SYSDATE,
6258: last_updated_by = FND_GLOBAL.user_id,
6259: object_version_number = object_version_number + 1

Line 6286: UPDATE ibe_dsp_sections_b

6282: IF (l_org_layout_type = 'C') THEN
6283: -- No cascading for standard layout
6284: l_org_deliverable_id := null;
6285: -- Set the section deliverable_id to old processing page
6286: UPDATE ibe_dsp_sections_b
6287: SET deliverable_id = l_org_deliverable_id
6288: WHERE section_id = p_section_id;
6289: END IF;
6290: END IF;