APPS.ICX_CAT dependencies on ICX_SEC

Line 12: if icx_sec.validateSession then

8: l_title varchar2(80);
9: l_prompts icx_util.g_prompts_table;
10:
11: begin
12: if icx_sec.validateSession then
13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
14:
15: htp.htmlOpen;
16: htp.headOpen;

Line 74: if icx_sec.validateSession then

70: temp_relation_code varchar2(30);
71: temp_relation varchar2(80);
72:
73: begin
74: if icx_sec.validateSession then
75: icx_util.error_page_setup;
76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts);

Line 76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

72:
73: begin
74: if icx_sec.validateSession then
75: icx_util.error_page_setup;
76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts);
79:
80: htp.htmlOpen;

Line 268: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

264: p_start_row in number default 1,
265: p_end_row in number default null) is
266:
267: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME');
268: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
269: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
270: l_title varchar2(80);
271: l_prompts icx_util.g_prompts_table;
272: err_num number;

Line 269: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

265: p_end_row in number default null) is
266:
267: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME');
268: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
269: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
270: l_title varchar2(80);
271: l_prompts icx_util.g_prompts_table;
272: err_num number;
273: err_mesg varchar2(512);

Line 292: if icx_sec.validateSession then

288: temp_related_cat varchar2(240);
289: temp_relation_item number;
290:
291: begin
292: if icx_sec.validateSession then
293: icx_util.error_page_setup;
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts);
296:

Line 294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

290:
291: begin
292: if icx_sec.validateSession then
293: icx_util.error_page_setup;
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts);
296:
297: htp.htmlOpen;
298: htp.headOpen;

Line 572: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

568:
569: l_return_status varchar2(1) := 'S';
570: l_msg_count number;
571: l_msg_data varchar2(240);
572: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
573:
574:
575: begin
576: if icx_sec.validateSession then

Line 576: if icx_sec.validateSession then

572: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
573:
574:
575: begin
576: if icx_sec.validateSession then
577: icx_util.error_page_setup;
578:
579: -- insert top relation for this category if needed
580: if icx_relation = 'TOP' then

Line 658: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

654:
655: l_return_status varchar2(1) := 'S';
656: l_msg_count number;
657: l_msg_data varchar2(240);
658: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
659: l_category varchar2(245);
660:
661:
662: begin

Line 663: if icx_sec.validateSession then

659: l_category varchar2(245);
660:
661:
662: begin
663: if icx_sec.validateSession then
664: icx_util.error_page_setup;
665:
666:
667: -- delete relation