APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_DSP_SECTIONS_TL

Line 4617: -- Cursor to get the translated rows of the section from ibe_Dsp_sections_tl table

4613: AND mini_site_id = l_c_master_mini_site_id
4614: CONNECT BY PRIOR child_section_id = parent_section_id
4615: AND mini_site_id = l_c_master_mini_site_id);
4616:
4617: -- Cursor to get the translated rows of the section from ibe_Dsp_sections_tl table
4618: --bug 3303424
4619: CURSOR c4(l_c_section_id IN NUMBER)
4620: IS SELECT language,source_lang,display_name,description,long_description,keywords
4621: from ibe_dsp_sections_tl where section_id=l_c_section_id;

Line 4621: from ibe_dsp_sections_tl where section_id=l_c_section_id;

4617: -- Cursor to get the translated rows of the section from ibe_Dsp_sections_tl table
4618: --bug 3303424
4619: CURSOR c4(l_c_section_id IN NUMBER)
4620: IS SELECT language,source_lang,display_name,description,long_description,keywords
4621: from ibe_dsp_sections_tl where section_id=l_c_section_id;
4622:
4623: BEGIN
4624:
4625: -- Standard Start of API savepoint

Line 4807: update ibe_dsp_sections_tl set

4803: -- customer bug 3303424:
4804:
4805: if ( l_count_langs >1)then -- if more than one lang installed
4806: FOR r4 IN c4(p_src_section_id) LOOP
4807: update ibe_dsp_sections_tl set
4808: display_name= r4.display_name,
4809: description = r4.description,
4810: long_description = r4.long_description,
4811: keywords= r4.keywords,

Line 4820: update ibe_dsp_sections_tl

4816: end if;
4817:
4818: -- modify the display name for the sesion language.
4819: if p_new_display_name is not null then
4820: update ibe_dsp_sections_tl
4821: set display_name = p_new_display_name
4822: where section_id = x_new_src_section_id
4823: and language= userenv('lang');
4824: end if;

Line 4834: update ibe_dsp_sections_tl set

4830: -- if multiple lang installed and the input display name for the duplicated section
4831: -- is same as the src section display name then update the translated rows from src section
4832: -- except for the session lang row.
4833:
4834: update ibe_dsp_sections_tl set
4835: display_name = r4.display_name,
4836: description = r4.description,
4837: long_description = r4.long_description,
4838: keywords= r4.keywords,

Line 4850: update ibe_dsp_sections_tl set

4846: -- if new display name is not same as the src section name then
4847: -- update the duplicated section display name with the new display name
4848: -- for all rows, keeping the source_lang column same as the userenv(lang).
4849:
4850: update ibe_dsp_sections_tl set
4851: display_name = p_new_display_name,
4852: description = r4.description,
4853: long_description = r4.long_description,
4854: keywords= r4.keywords

Line 5110: update ibe_dsp_sections_tl set

5106:
5107: if ( l_count_langs >1)then -- if more than one lang installed
5108: FOR r4 IN c4(r2.section_id) LOOP
5109:
5110: update ibe_dsp_sections_tl set
5111: display_name= r4.display_name,
5112: description = r4.description,
5113: long_description = r4.long_description,
5114: keywords= r4.keywords,