APPS.ICX_TEMPLATE_HEIRARCHY 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_TEMPLATES_R',l_title,l_prompts);
14:
15: htp.htmlOpen;
16: htp.headOpen;

Line 65: if icx_sec.validateSession then

61: temp_relation_code varchar2(30);
62: temp_relation varchar2(80);
63:
64: begin
65: if icx_sec.validateSession then
66: icx_util.error_page_setup;
67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts);

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

63:
64: begin
65: if icx_sec.validateSession then
66: icx_util.error_page_setup;
67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts);
70:
71: htp.htmlOpen;

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

221: p_start_row in number default 1,
222: p_end_row in number default null) is
223:
224: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME');
225: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
226: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
227: l_title varchar2(80);
228: l_prompts icx_util.g_prompts_table;
229: err_num number;

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

222: p_end_row in number default null) is
223:
224: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME');
225: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
226: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
227: l_title varchar2(80);
228: l_prompts icx_util.g_prompts_table;
229: err_num number;
230: err_mesg varchar2(512);

Line 250: if icx_sec.validateSession then

246: temp_template varchar2(240);
247: temp_related_template varchar2(240);
248:
249: begin
250: if icx_sec.validateSession then
251:
252: v_index := 1;
253:
254:

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

252: v_index := 1;
253:
254:
255: icx_util.error_page_setup;
256: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts);
258:
259: htp.htmlOpen;
260: htp.headOpen;

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

501:
502: l_return_status varchar2(1) := 'S';
503: l_msg_count number;
504: l_msg_data varchar2(240);
505: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
506:
507:
508: begin
509: if icx_sec.validateSession then

Line 509: if icx_sec.validateSession then

505: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
506:
507:
508: begin
509: if icx_sec.validateSession then
510: icx_util.error_page_setup;
511:
512: -- insert top relation for this category if needed
513: if icx_relation = 'TOP' then

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

574:
575: l_return_status varchar2(1) := 'S';
576: l_msg_count number;
577: l_msg_data varchar2(240);
578: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
579: l_icx_template1 varchar2(240) := replace(icx_template1,'@~$',' ');
580: l_icx_related_template varchar2(240) := replace(icx_related_template,'@~$',' ');
581:
582:

Line 584: if icx_sec.validateSession then

580: l_icx_related_template varchar2(240) := replace(icx_related_template,'@~$',' ');
581:
582:
583: begin
584: if icx_sec.validateSession then
585: icx_util.error_page_setup;
586:
587:
588: -- delete relation