126: then
127: begin
128: select PAGE_ID,REFRESH_RATE
129: into l_page_id,l_refresh_rate
130: from ICX_PAGES
131: where USER_ID = icx_sec.g_user_id;
132: exception
133: when NO_DATA_FOUND then
134: htp.p('Add page creation code here');
739:
740:
741: cursor getPages (p_user_id number) is
742: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
743: from icx_pages ip,
744: icx_pages_tl ipt
745: where ip.user_id = p_user_id
746: and ipt.language = userenv('LANG')
747: and ip.page_id = ipt.page_id
740:
741: cursor getPages (p_user_id number) is
742: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
743: from icx_pages ip,
744: icx_pages_tl ipt
745: where ip.user_id = p_user_id
746: and ipt.language = userenv('LANG')
747: and ip.page_id = ipt.page_id
748: and ip.page_type in ('USER', 'MAIN')
855: p_display_name:=l_prompts(1);
856: l_user_id:=icx_sec.g_user_id;
857:
858: select count(*) into l_page_count
859: from icx_pages
860: where user_id = l_user_id;
861:
862: IF (l_page_count=1)THEN
863:
862: IF (l_page_count=1)THEN
863:
864: SELECT page_id
865: INTO l_page_id
866: FROM icx_pages
867: WHERE user_id = l_user_id;
868:
869: select count(*)
870: INTO l_region_count
1076: l_helpmsg := '';
1077: l_helptitle := '';
1078:
1079: select count(*) into l_page_count
1080: from icx_pages
1081: where user_id = icx_sec.g_user_id
1082: and page_type = 'MAIN';
1083:
1084: if ( l_page_count = 0 ) then
1217: l_active_page_id number;
1218:
1219: cursor getPages (p_user_id number) is
1220: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
1221: from icx_pages ip,
1222: icx_pages_tl ipt
1223: where ip.user_id = p_user_id
1224: and ipt.language = userenv('LANG')
1225: and ip.page_id = ipt.page_id
1218:
1219: cursor getPages (p_user_id number) is
1220: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
1221: from icx_pages ip,
1222: icx_pages_tl ipt
1223: where ip.user_id = p_user_id
1224: and ipt.language = userenv('LANG')
1225: and ip.page_id = ipt.page_id
1226: and ip.page_type in ('USER', 'MAIN')