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_REVIEW_PKG dependencies on ICX_SEC

Line 58: IF NOT icx_sec.validatesession THEN

54: l_result_index NUMBER;
55:
56: BEGIN
57:
58: IF NOT icx_sec.validatesession THEN
59: RETURN;
60: END IF;
61:
62: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);

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

58: IF NOT icx_sec.validatesession THEN
59: RETURN;
60: END IF;
61:
62: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
63: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
64: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
65: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
66: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

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

59: RETURN;
60: END IF;
61:
62: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
63: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
64: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
65: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
66: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
67: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

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

61:
62: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
63: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
64: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
65: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
66: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
67: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
68:
69: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);

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

62: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
63: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
64: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
65: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
66: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
67: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
68:
69: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);
70:

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

63: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
64: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
65: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
66: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
67: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
68:
69: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);
70:
71: htp.htmlOpen;

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

127: l_total_rows NUMBER := 0;
128:
129: BEGIN
130:
131: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
132:
133: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
134:
135: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,

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

134:
135: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
136: p_parent_region_code=>'POS_ASN_REVIEW_HEADERS_R',
137: p_where_clause=>l_where_clause,
138: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
139: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
140: p_return_parents=>'T',
141: p_return_children=>'F');
142:

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

135: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
136: p_parent_region_code=>'POS_ASN_REVIEW_HEADERS_R',
137: p_where_clause=>l_where_clause,
138: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
139: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
140: p_return_parents=>'T',
141: p_return_children=>'F');
142:
143: DupResultTable(ak_query_pkg.g_results_table, g_header_results_table);

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

147:
148: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
149: p_parent_region_code=>'POS_ASN_REVIEW_INV_HDR_R',
150: p_where_clause=>l_where_clause,
151: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
152: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
153: p_return_parents=>'T',
154: p_return_children=>'F');
155:

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

148: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
149: p_parent_region_code=>'POS_ASN_REVIEW_INV_HDR_R',
150: p_where_clause=>l_where_clause,
151: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
152: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
153: p_return_parents=>'T',
154: p_return_children=>'F');
155:
156: DupResultTable(ak_query_pkg.g_results_table, g_inv_hdr_results_table);

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

189: l_result_index NUMBER;
190:
191: BEGIN
192:
193: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
194:
195: l_where_clause := 'SESSION_ID = ' || to_char(l_session_id);
196:
197: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,

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

196:
197: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
198: p_parent_region_code=>'POS_ASN_REVIEW_DETAILS_SEQ_R',
199: p_where_clause=>l_where_clause,
200: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
201: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
202: p_return_parents=>'T',
203: p_return_children=>'F');
204:

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

197: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
198: p_parent_region_code=>'POS_ASN_REVIEW_DETAILS_SEQ_R',
199: p_where_clause=>l_where_clause,
200: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
201: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
202: p_return_parents=>'T',
203: p_return_children=>'F');
204:
205: DupResultTable(ak_query_pkg.g_results_table, g_seq_results_table);

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

207:
208: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
209: p_parent_region_code=>'POS_ASN_REVIEW_PO_DETAILS_R',
210: p_where_clause=>l_where_clause,
211: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
212: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
213: p_return_parents=>'T',
214: p_return_children=>'F');
215:

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

208: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
209: p_parent_region_code=>'POS_ASN_REVIEW_PO_DETAILS_R',
210: p_where_clause=>l_where_clause,
211: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
212: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
213: p_return_parents=>'T',
214: p_return_children=>'F');
215:
216: DupResultTable(ak_query_pkg.g_results_table, g_lines_results_table);

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

218:
219: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
220: p_parent_region_code=>'POS_ASN_REVIEW_SHIP_DETAILS_R',
221: p_where_clause=>l_where_clause,
222: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
223: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
224: p_return_parents=>'T',
225: p_return_children=>'F');
226:

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

219: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
220: p_parent_region_code=>'POS_ASN_REVIEW_SHIP_DETAILS_R',
221: p_where_clause=>l_where_clause,
222: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
223: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
224: p_return_parents=>'T',
225: p_return_children=>'F');
226:
227: DupResultTable(ak_query_pkg.g_results_table, g_ship_results_table);

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

231:
232: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
233: p_parent_region_code=>'POS_ASN_REVIEW_INV_DETAILS_R',
234: p_where_clause=>l_where_clause,
235: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
236: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
237: p_return_parents=>'T',
238: p_return_children=>'F');
239:

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

232: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
233: p_parent_region_code=>'POS_ASN_REVIEW_INV_DETAILS_R',
234: p_where_clause=>l_where_clause,
235: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
236: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
237: p_return_parents=>'T',
238: p_return_children=>'F');
239:
240: DupResultTable(ak_query_pkg.g_results_table, g_inv_dtl_results_table);