APPS.POS_ACK_SEARCH dependencies on ICX_SEC

Line 50: IF NOT icx_sec.validatesession THEN

46: Veera_Debug('Start Search_PO');
47: Veera_Debug('Pk1: ' || pk1 || ', Pk2: ' || pk2);
48: Veera_Debug('Pk1: ' || pk1 || ', Pk2: ' || pk2);
49:
50: IF NOT icx_sec.validatesession THEN
51: RETURN;
52: END IF;
53:
54: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

Line 54: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

50: IF NOT icx_sec.validatesession THEN
51: RETURN;
52: END IF;
53:
54: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
55:
56: select org_id into l_org_id
57: from po_headers_all where po_header_id = to_number(pk1);
58:

Line 68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

64: select segment1 into l_po_number
65: from po_headers_all
66: where po_header_id = to_number(pk1);
67:
68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
69: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
70: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

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

65: from po_headers_all
66: where po_header_id = to_number(pk1);
67:
68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
69: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
70: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
73:

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

67:
68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
69: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
70: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
73:
74: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
75: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

Line 72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

68: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
69: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
70: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
73:
74: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
75: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
76:

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

70: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
73:
74: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
75: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
76:
77: l_supplier_contact := Get_Supplier_ID(l_user_id);
78:

Line 75: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

71: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
72: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
73:
74: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
75: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
76:
77: l_supplier_contact := Get_Supplier_ID(l_user_id);
78:
79: fnd_client_info.set_org_context(l_org_id);

Line 167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

163: BEGIN
164:
165: POS_INIT_SESSION_PKG.InitSession(p_resp_id);
166:
167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
169: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

Line 168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

164:
165: POS_INIT_SESSION_PKG.InitSession(p_resp_id);
166:
167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
169: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

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

165: POS_INIT_SESSION_PKG.InitSession(p_resp_id);
166:
167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
169: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
173:

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

167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
169: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
173:
174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
175: l_supplier_contact := Get_Supplier_ID(l_user_id);

Line 172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

168: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
169: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
173:
174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
175: l_supplier_contact := Get_Supplier_ID(l_user_id);
176:

Line 174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

170: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
171: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
172: g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
173:
174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
175: l_supplier_contact := Get_Supplier_ID(l_user_id);
176:
177: htp.htmlOpen;
178: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));

Line 289: IF NOT icx_sec.validatesession THEN

285: BEGIN
286:
287: Veera_Debug('Start Criteria_Frame');
288: Veera_Debug('Po Number ' || l_po_number);
289: IF NOT icx_sec.validatesession THEN
290: RETURN;
291: END IF;
292:
293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

Line 293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

289: IF NOT icx_sec.validatesession THEN
290: RETURN;
291: END IF;
292:
293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
296: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

290: RETURN;
291: END IF;
292:
293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
296: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
298: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

292:
293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
296: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
298: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
299:
300: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||

Line 297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

293: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
296: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
298: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
299:
300: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
301: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||

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

294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
296: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
297: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
298: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
299:
300: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
301: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||
302: 'Session Id: ' || to_char(l_session_id));

Line 385: IF NOT icx_sec.validatesession THEN

381: PROCEDURE FIXED_FRAME(l_supplier_contact in number)
382: IS
383: BEGIN
384:
385: IF NOT icx_sec.validatesession THEN
386: RETURN;
387: END IF;
388:
389: htp.htmlopen;

Line 427: IF NOT icx_sec.validatesession THEN

423: l_msg VARCHAR2(2000);
424:
425: BEGIN
426:
427: IF NOT icx_sec.validatesession THEN
428: RETURN;
429: END IF;
430:
431: htp.htmlopen;

Line 478: IF NOT icx_sec.validatesession THEN

474: l_session_id NUMBER;
475: l_responsibility_id NUMBER;
476: BEGIN
477:
478: IF NOT icx_sec.validatesession THEN
479: RETURN;
480: END IF;
481:
482: veera_debug('Start Blank_Frame');

Line 483: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

479: RETURN;
480: END IF;
481:
482: veera_debug('Start Blank_Frame');
483: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
484: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
485: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
486: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

480: END IF;
481:
482: veera_debug('Start Blank_Frame');
483: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
484: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
485: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
486: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
488: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

482: veera_debug('Start Blank_Frame');
483: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
484: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
485: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
486: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
488: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
489:
490: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||

Line 487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

483: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
484: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
485: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
486: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
488: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
489:
490: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
491: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||

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

484: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
485: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
486: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
488: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
489:
490: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
491: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||
492: 'Session Id: ' || to_char(l_session_id));

Line 556: IF NOT icx_sec.validatesession THEN

552:
553: BEGIN
554:
555: -- Bug 1785297 mji
556: IF NOT icx_sec.validatesession THEN
557: RETURN;
558: END IF;
559:
560: htp.htmlOpen;

Line 672: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);

668: l_result_index NUMBER;
669: l_current_col NUMBER;
670: l_current_row NUMBER;
671: l_row NUMBER := 0;
672: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);
673: l_where_clause VARCHAR2(2000) := '';
674: BEGIN
675: Veera_Debug('Paint_Search: Po Number: ' || l_po_number);
676: htp.p('');

Line 690: p_responsibility_id => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

686:
687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
688: p_parent_region_code => 'POS_ACK_SEARCH_R',
689: p_where_clause => l_where_clause,
690: p_responsibility_id => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
691: p_user_id => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
692: p_return_parents => 'F',
693: p_return_children => 'F');
694:

Line 691: p_user_id => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
688: p_parent_region_code => 'POS_ACK_SEARCH_R',
689: p_where_clause => l_where_clause,
690: p_responsibility_id => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
691: p_user_id => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
692: p_return_parents => 'F',
693: p_return_children => 'F');
694:
695: l_attribute_index := ak_query_pkg.g_items_table.FIRST;

Line 877: IF NOT icx_sec.validatesession THEN

873: Bcos the session was not validated, the org context was not set
874: appropriately and hence the query returned no rows.
875: */
876:
877: IF NOT icx_sec.validatesession THEN
878: RETURN;
879: END IF;
880:
881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

Line 881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

877: IF NOT icx_sec.validatesession THEN
878: RETURN;
879: END IF;
880:
881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
882: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
883: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
884: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
885: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

878: RETURN;
879: END IF;
880:
881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
882: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
883: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
884: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
885: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
886: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

880:
881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
882: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
883: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
884: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
885: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
886: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
887:
888: /* bug 1361618 : setting the org context */

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

881: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
882: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
883: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
884: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
885: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
886: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
887:
888: /* bug 1361618 : setting the org context */
889: fnd_client_info.set_org_context(l_org_id);

Line 886: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

882: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
883: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
884: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
885: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
886: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
887:
888: /* bug 1361618 : setting the org context */
889: fnd_client_info.set_org_context(l_org_id);
890: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);

Line 1528: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

1524: --l_end_row := l_start_row + 25 - 1;
1525: l_end_row := 99999;
1526:
1527: veera_debug('Inside Paint_Edit_POS');
1528: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
1529: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1530: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1531: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1532: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

1525: l_end_row := 99999;
1526:
1527: veera_debug('Inside Paint_Edit_POS');
1528: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
1529: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1530: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1531: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1532: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1533: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

1527: veera_debug('Inside Paint_Edit_POS');
1528: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
1529: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1530: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1531: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1532: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1533: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1534:
1535: --l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);

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

1528: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
1529: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1530: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1531: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1532: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1533: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1534:
1535: --l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
1536: l_where_clause := '';

Line 1533: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

1529: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1530: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1531: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1532: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1533: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1534:
1535: --l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
1536: l_where_clause := '';
1537:

Line 1734:

');
1738: -- test promise date

Line 1791: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

1787:
1788: l_temp1 := fnd_message.get_string('ICX','ICX_POS_ACK_YES');
1789: l_temp2 := fnd_message.get_string('ICX','ICX_POS_ACK_NO');
1790:
1791: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
1792:
1793: -- Bug 1196968
1794:
1795: select date_format_mask

Line 1916: IF NOT icx_sec.validatesession THEN

1912:
1913: BEGIN
1914: veera_debug('Start Acknowledge_pos');
1915:
1916: IF NOT icx_sec.validatesession THEN
1917: RETURN;
1918: END IF;
1919:
1920: l_temp1 := fnd_message.get_string('ICX','ICX_POS_ACK_WEB');

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

1917: RETURN;
1918: END IF;
1919:
1920: l_temp1 := fnd_message.get_string('ICX','ICX_POS_ACK_WEB');
1921: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1922:
1923: FOR l_counter IN 1..pos_ack_po_header_id.count LOOP
1924: IF POS_ACK_ACCEPT(l_counter) <> 'None' then
1925: veera_debug('Acc Type Code: ' || pos_ack_acc_type_code(l_counter));

Line 2076: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

2072: l_session_id NUMBER;
2073: l_responsibility_id NUMBER;
2074: BEGIN
2075:
2076: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2077: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2078: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2079: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

2073: l_responsibility_id NUMBER;
2074: BEGIN
2075:
2076: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2077: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2078: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2079: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2081: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

2075:
2076: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2077: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2078: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2079: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2081: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2082:
2083: fnd_client_info.set_org_context(l_org_id);

Line 2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

2076: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2077: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2078: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2079: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2081: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2082:
2083: fnd_client_info.set_org_context(l_org_id);
2084:

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

2077: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2078: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2079: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2080: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2081: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2082:
2083: fnd_client_info.set_org_context(l_org_id);
2084:
2085: select rowidtochar(ROWID)

Line 2129: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

2125: l_session_id NUMBER;
2126: l_responsibility_id NUMBER;
2127: BEGIN
2128:
2129: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2130: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2131: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2132: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

2126: l_responsibility_id NUMBER;
2127: BEGIN
2128:
2129: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2130: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2131: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2132: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2134: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

2128:
2129: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2130: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2131: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2132: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2134: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2135:
2136: fnd_client_info.set_org_context(l_org_id);

Line 2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

2129: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
2130: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2131: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2132: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2134: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2135:
2136: fnd_client_info.set_org_context(l_org_id);
2137:

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

2130: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2131: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
2132: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2133: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
2134: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
2135:
2136: fnd_client_info.set_org_context(l_org_id);
2137:
2138: select rowidtochar(ROWID)

1735: ''''|| l_po_num ||'''' || ')"> ' || 1736: fnd_message.get_string('ICX','ICX_POS_ACK_PROMISED_DATE') || 1737: '' || l_hidden_fields_string || '