APPS.ICX_DEFINE_PAGES dependencies on ICX_PAGES

Line 68: from icx_pages ip,

64: l_alert VARCHAR2(120);
65:
66: cursor wlistcurs is
67: select ip.page_id, ipt.page_name, ip.page_type
68: from icx_pages ip,
69: icx_pages_tl ipt
70: where ip.user_id = l_user_id
71: and ipt.language = userenv('LANG')
72: and ip.page_id = ipt.page_id

Line 69: icx_pages_tl ipt

65:
66: cursor wlistcurs is
67: select ip.page_id, ipt.page_name, ip.page_type
68: from icx_pages ip,
69: icx_pages_tl ipt
70: where ip.user_id = l_user_id
71: and ipt.language = userenv('LANG')
72: and ip.page_id = ipt.page_id
73: and ip.page_type in ('USER', 'SEED')

Line 90: from icx_pages_tl

86: if (p_page_id IS NOT NULL) then
87:
88: select MAX(page_name)
89: into l_page_name
90: from icx_pages_tl
91: where page_id = p_page_id
92: and language = userenv('LANG');
93:
94: end if;

Line 367: update icx_pages

363: if (l_page_id IS NOT NULL) then
364:
365: l_position := l_position + 1;
366:
367: update icx_pages
368: set SEQUENCE_NUMBER = l_position
369: where user_id = l_user_id
370: and page_id = TO_NUMBER(l_page_id);
371:

Line 482: from icx_pages ip,

478:
479:
480: cursor wlistcurs is
481: select ip.page_id, ipt.page_name
482: from icx_pages ip,
483: icx_pages_tl ipt
484: where ip.user_id = l_user_id
485: and ipt.language = userenv('LANG')
486: and ip.page_id = ipt.page_id

Line 483: icx_pages_tl ipt

479:
480: cursor wlistcurs is
481: select ip.page_id, ipt.page_name
482: from icx_pages ip,
483: icx_pages_tl ipt
484: where ip.user_id = l_user_id
485: and ipt.language = userenv('LANG')
486: and ip.page_id = ipt.page_id
487: and ip.page_type = 'USER'