DBA Data[Home] [Help]

APPS.ICX_UTIL dependencies on ICX_SEC

Line 97: if icx_sec.validateSession then

93: l_lov_type varchar2(100) := 'HTML';
94: l_profile_defined boolean;
95:
96: begin
97: if icx_sec.validateSession then
98:
99: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
100:
101: fnd_profile.get_specific(name_z => 'ICX_LOV_TYPE',

Line 99: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);

95:
96: begin
97: if icx_sec.validateSession then
98:
99: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
100:
101: fnd_profile.get_specific(name_z => 'ICX_LOV_TYPE',
102: user_id_z => l_user_id,
103: val_z => l_lov_type,

Line 172: -- c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

168: l_where_clause varchar2(2000);
169:
170: begin
171: /* remove the following commented line if the oa media stuff works fine*/
172: -- c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
173:
174: getPrompts(601,'ICX_LOV',c_title,c_prompts);
175: l_where_clause := icx_call.encrypt2(c_where_clause);
176: temp := htf.anchor('javascript:LOV('''||c_attribute_app_id||''','''||c_attribute_code||''','''||c_region_app_id||''','''||c_region_code||''','''||c_form_name||''','''||c_frame_name||''','''||l_where_clause||''','''')',

Line 260: if icx_sec.validateSession then

256: l_user_id varchar2(100);
257: l_profile_defined boolean;
258:
259: begin
260: if icx_sec.validateSession then
261:
262: select attribute_label_long into LOV_title
263: from ak_region_items_vl
264: where region_application_id = c_region_app_id

Line 295: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);

291: l_where_clause := icx_call.encrypt2(replace(c_js_where_clause,'^@~^',' '));
292: end if;
293: end if;
294:
295: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
296:
297: fnd_profile.get_specific(name_z => 'ICX_LOV_TYPE',
298: user_id_z => l_user_id,
299: val_z => l_lov_type,

Line 464: l_sess_id number := icx_sec.getID(icx_sec.PV_SESSION_ID);

460: i number;
461: j number;
462: l_total_width number;
463: l_result_row_table icx_util.char240_table;
464: l_sess_id number := icx_sec.getID(icx_sec.PV_SESSION_ID);
465:
466: begin
467: if icx_sec.validateSession then
468:

Line 467: if icx_sec.validateSession then

463: l_result_row_table icx_util.char240_table;
464: l_sess_id number := icx_sec.getID(icx_sec.PV_SESSION_ID);
465:
466: begin
467: if icx_sec.validateSession then
468:
469: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
470: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
471:

Line 469: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

465:
466: begin
467: if icx_sec.validateSession then
468:
469: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
470: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
471:
472: -- get LOV window title
473: LOV_title := icx_util.getPrompt(601,'ICX_LOV',178,'ICX_LIST_OF_VALUES');

Line 470: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

466: begin
467: if icx_sec.validateSession then
468:
469: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
470: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
471:
472: -- get LOV window title
473: LOV_title := icx_util.getPrompt(601,'ICX_LOV',178,'ICX_LIST_OF_VALUES');
474: htp.p(LOV_title);

Line 820: if icx_sec.validateSession then

816: then
817: l_matchcase_lov := 'Checked';
818: end if;
819:
820: if icx_sec.validateSession then
821: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
822: getPrompts(601,'ICX_LOV',LOV_title,LOV_prompts);
823:
824:

Line 821: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

817: l_matchcase_lov := 'Checked';
818: end if;
819:
820: if icx_sec.validateSession then
821: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
822: getPrompts(601,'ICX_LOV',LOV_title,LOV_prompts);
823:
824:
825: htp.headOpen;

Line 1339: if icx_sec.validateSession then

1335: c_where_bind_vals VARCHAR2(2000); -- mputman added
1336: l_query_binds_index NUMBER;
1337:
1338: begin
1339: if icx_sec.validateSession then
1340:
1341: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1342: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1343:

Line 1341: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

1337:
1338: begin
1339: if icx_sec.validateSession then
1340:
1341: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1342: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1343:
1344: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1345: getPrompts(601,'ICX_LOV',LOV_title,LOV_prompts);

Line 1342: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1338: begin
1339: if icx_sec.validateSession then
1340:
1341: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1342: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1343:
1344: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1345: getPrompts(601,'ICX_LOV',LOV_title,LOV_prompts);
1346:

Line 1344: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1340:
1341: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1342: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1343:
1344: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1345: getPrompts(601,'ICX_LOV',LOV_title,LOV_prompts);
1346:
1347: l_error := FALSE;
1348: