APPS.ORACLECONFIGURE dependencies on ICX_PAGES

Line 37: from icx_pages

33: if (l_session_id > 0) then
34:
35: select nvl(max(sequence_number),1)
36: into l_sequence_number
37: from icx_pages
38: where user_id = icx_sec.g_user_id;
39:
40: select icx_pages_s.nextval
41: into l_page_id

Line 40: select icx_pages_s.nextval

36: into l_sequence_number
37: from icx_pages
38: where user_id = icx_sec.g_user_id;
39:
40: select icx_pages_s.nextval
41: into l_page_id
42: from sys.dual;
43:
44: l_main_region_id := icx_api_region.create_main_region;

Line 46: ICX_PAGES_PKG.INSERT_ROW(

42: from sys.dual;
43:
44: l_main_region_id := icx_api_region.create_main_region;
45: --added substr() to p_page_name 1388074 mputman
46: ICX_PAGES_PKG.INSERT_ROW(
47: x_rowid => l_rowid,
48: x_page_id => l_page_id,
49: x_page_code => 'ICX_PAGE_' || to_char(l_page_id),
50: x_main_region_id => l_main_region_id,

Line 153: from icx_pages

149:
150: begin
151: select nvl(max(sequence_number),1)
152: into l_sequence_number
153: from icx_pages
154: where user_id = icx_sec.g_user_id;
155: exception
156: when no_data_found then
157: htp.p(SQLERRM);

Line 163: from icx_pages

159:
160: begin
161: select main_region_id
162: into l_from_main_region_id
163: from icx_pages
164: where page_id = p_page_id;
165: exception
166: when no_data_found then
167: htp.p(SQLERRM);

Line 170: select icx_pages_s.nextval

166: when no_data_found then
167: htp.p(SQLERRM);
168: end;
169:
170: select icx_pages_s.nextval
171: into l_to_page_id
172: from sys.dual;
173:
174: l_to_main_region_id := icx_api_region.create_main_region;

Line 176: ICX_PAGES_PKG.INSERT_ROW(

172: from sys.dual;
173:
174: l_to_main_region_id := icx_api_region.create_main_region;
175:
176: ICX_PAGES_PKG.INSERT_ROW(
177: x_rowid => l_rowid,
178: x_page_id => l_to_page_id,
179: x_page_code => 'ICX_PAGE_' || to_char(l_to_page_id),
180: x_main_region_id => l_to_main_region_id,

Line 250: update icx_pages_tl

246: p_page_name in varchar2) is
247:
248: begin
249:
250: update icx_pages_tl
251: set page_name = p_page_name
252: where page_id = p_page_id
253: and language = userenv('LANG');
254:

Line 255: update icx_pages

251: set page_name = p_page_name
252: where page_id = p_page_id
253: and language = userenv('LANG');
254:
255: update icx_pages
256: set page_name = p_page_name
257: where page_id = p_page_id;
258:
259: exception

Line 310: from icx_pages

306:
307: begin
308: select main_region_id
309: into l_main_region_id
310: from icx_pages
311: where page_id = p_page_id;
312: exception
313: when no_data_found then
314: htp.p(SQLERRM);

Line 358: delete from icx_pages

354:
355: delete from icx_page_plugs
356: where page_id = p_page_id;
357:
358: delete from icx_pages
359: where page_id = p_page_id;
360:
361: delete from icx_pages_tl
362: where page_id = p_page_id;

Line 361: delete from icx_pages_tl

357:
358: delete from icx_pages
359: where page_id = p_page_id;
360:
361: delete from icx_pages_tl
362: where page_id = p_page_id;
363:
364: if (l_current_page_id = p_page_id) then --the page the user was on has been deleted
365: --return to the Main Page.

Line 368: from icx_pages

364: if (l_current_page_id = p_page_id) then --the page the user was on has been deleted
365: --return to the Main Page.
366: begin
367: select page_id into l_main_page_id
368: from icx_pages
369: where page_type = 'MAIN'
370: and user_id = icx_sec.g_user_id;
371: exception
372: when no_data_found then

Line 432: from icx_pages_tl

428:
429: begin
430: select page_name
431: into l_page_name
432: from icx_pages_tl
433: where page_id = l_page_id
434: and language = userenv('LANG');
435: exception
436: when no_data_found then

Line 486: from icx_pages

482:
483: begin
484: select main_region_id
485: into l_main_region_id
486: from icx_pages
487: where page_id = p_page_id;
488: exception
489: when NO_DATA_FOUND then
490: htp.p(SQLERRM);