eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_ASN_SEARCH_PKG dependencies on ICX_SEC

Line 77: IF NOT icx_sec.validatesession THEN

73: l_session_id NUMBER;
74:
75: BEGIN
76:
77: IF NOT icx_sec.validatesession THEN
78: RETURN;
79: END IF;
80:
81: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

77: IF NOT icx_sec.validatesession THEN
78: RETURN;
79: END IF;
80:
81: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
82: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
83: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
84: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
85: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

78: RETURN;
79: END IF;
80:
81: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
82: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
83: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
84: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
85: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
86:

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

80:
81: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
82: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
83: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
84: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
85: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
86:
87:
88: if p_start_row = 0 then

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

81: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
82: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
83: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
84: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
85: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
86:
87:
88: if p_start_row = 0 then
89:

Line 159: IF NOT icx_sec.validatesession THEN

155: l_ship_to_location VARCHAR2(20);
156:
157: BEGIN
158:
159: IF NOT icx_sec.validatesession THEN
160: RETURN;
161: END IF;
162:
163: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

159: IF NOT icx_sec.validatesession THEN
160: RETURN;
161: END IF;
162:
163: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
164: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
165: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
166: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
167: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

160: RETURN;
161: END IF;
162:
163: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
164: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
165: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
166: 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_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

162:
163: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
164: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
165: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
166: 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_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
169:
170: htp.htmlOpen;

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

163: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
164: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
165: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
166: 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_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
169:
170: htp.htmlOpen;
171: htp.headOpen;

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

164: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
165: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
166: 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_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
169:
170: htp.htmlOpen;
171: htp.headOpen;
172: htp.linkRel('STYLESHEET', '/OA_HTML/' || l_language || '/POSSTYLE.css');

Line 301: IF NOT icx_sec.validatesession THEN

297: l_msg VARCHAR2(200);
298:
299: BEGIN
300:
301: IF NOT icx_sec.validatesession THEN
302: RETURN;
303: END IF;
304:
305: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

301: IF NOT icx_sec.validatesession THEN
302: RETURN;
303: END IF;
304:
305: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
306: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
307: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
308: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
309: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

302: RETURN;
303: END IF;
304:
305: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
306: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
307: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
308: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
309: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
310:

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

304:
305: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
306: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
307: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
308: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
309: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
310:
311: htp.htmlOpen;
312: htp.headOpen;

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

305: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
306: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
307: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
308: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
309: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
310:
311: htp.htmlOpen;
312: htp.headOpen;
313: htp.linkRel('STYLESHEET', '/OA_HTML/' || l_language || '/POSSTYLE.css');

Line 398: IF NOT icx_sec.validatesession THEN

394: l_format_mask icx_sessions.DATE_FORMAT_MASK%TYPE;
395:
396: BEGIN
397:
398: IF NOT icx_sec.validatesession THEN
399: RETURN;
400: END IF;
401:
402: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

398: IF NOT icx_sec.validatesession THEN
399: RETURN;
400: END IF;
401:
402: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
403: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
404: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
405: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
406: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

399: RETURN;
400: END IF;
401:
402: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
403: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
404: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
405: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
406: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
407:

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

401:
402: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
403: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
404: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
405: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
406: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
407:
408: fnd_client_info.set_org_context(l_org_id);
409:

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

402: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
403: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
404: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
405: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
406: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
407:
408: fnd_client_info.set_org_context(l_org_id);
409:
410: IF p_query = 'N' THEN

Line 550: IF NOT icx_sec.validatesession THEN

546: l_num_results NUMBER;
547:
548: BEGIN
549:
550: IF NOT icx_sec.validatesession THEN
551: RETURN;
552: END IF;
553:
554: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

550: IF NOT icx_sec.validatesession THEN
551: RETURN;
552: END IF;
553:
554: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
555: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
556: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

551: RETURN;
552: END IF;
553:
554: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
555: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
556: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
559:

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

553:
554: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
555: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
556: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
559:
560: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
561:

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

554: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
555: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
556: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
559:
560: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
561:
562: fnd_client_info.set_org_context(l_org_id);

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

579:
580: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
581: p_parent_region_code=>'POS_ASN_RESULT_R',
582: p_where_clause=>l_where_clause,
583: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
584: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
585: p_return_parents=>'T',
586: p_return_children=>'F');
587:

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

580: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
581: p_parent_region_code=>'POS_ASN_RESULT_R',
582: p_where_clause=>l_where_clause,
583: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
584: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
585: p_return_parents=>'T',
586: p_return_children=>'F');
587:
588: l_num_results := ak_query_pkg.g_results_table.count;

Line 651: IF NOT icx_sec.validatesession THEN

647: l_first_loc_id NUMBER := -1;
648:
649: BEGIN
650:
651: IF NOT icx_sec.validatesession THEN
652: RETURN;
653: END IF;
654:
655: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

651: IF NOT icx_sec.validatesession THEN
652: RETURN;
653: END IF;
654:
655: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
656: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
657: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
658: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
659: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

652: RETURN;
653: END IF;
654:
655: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
656: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
657: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
658: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
659: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
660:

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

654:
655: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
656: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
657: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
658: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
659: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
660:
661: fnd_client_info.set_org_context(l_org_id);
662:

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

655: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
656: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
657: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
658: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
659: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
660:
661: fnd_client_info.set_org_context(l_org_id);
662:
663: -- Check whether multiple ship to org are selected.

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

973: BEGIN
974:
975: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
976: p_parent_region_code=>'POS_ASN_SEARCH_R',
977: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
978: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
979: p_return_parents=>'F',
980: p_return_children=>'F');
981:

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

974:
975: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
976: p_parent_region_code=>'POS_ASN_SEARCH_R',
977: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
978: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
979: p_return_parents=>'F',
980: p_return_children=>'F');
981:
982: l_count := 0;

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

1121: BEGIN
1122:
1123: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1124: p_parent_region_code=>'POS_ASN_ADV_SEARCH_R',
1125: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1126: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1127: p_return_parents=>'F',
1128: p_return_children=>'F');
1129:

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

1122:
1123: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1124: p_parent_region_code=>'POS_ASN_ADV_SEARCH_R',
1125: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1126: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1127: p_return_parents=>'F',
1128: p_return_children=>'F');
1129:
1130: l_count := 0;

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

1243: l_current_col NUMBER := 0;
1244: l_current_row NUMBER := 0;
1245: l_total_rows NUMBER := 0;
1246:
1247: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);
1248: l_script_name VARCHAR2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
1249: l_language VARCHAR2(5) := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1250:
1251: l_where_clause VARCHAR2(2000) := 'SESSION_ID = ' || to_char(l_session_id);

Line 1249: l_language VARCHAR2(5) := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1245: l_total_rows NUMBER := 0;
1246:
1247: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);
1248: l_script_name VARCHAR2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
1249: l_language VARCHAR2(5) := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1250:
1251: l_where_clause VARCHAR2(2000) := 'SESSION_ID = ' || to_char(l_session_id);
1252:
1253: l_empty_cart VARCHAR2(1);

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

1304:
1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',
1307: p_where_clause=>l_where_clause,
1308: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1309: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1310: p_return_parents=>'T',
1311: p_return_children=>'F');
1312:

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

1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',
1307: p_where_clause=>l_where_clause,
1308: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1309: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1310: p_return_parents=>'T',
1311: p_return_children=>'F');
1312:
1313: l_total_rows := ak_query_pkg.g_results_table.count;