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.ICX_REQ_UPDATE_SAVED_CARTS dependencies on AK_QUERY_PKG

Line 74: l_where_binds ak_query_pkg.bind_tab;

70: l_emergency_flag_value_id number;
71: l_emergency varchar2(30);
72:
73: /* New vars to use the Bind vars logic **/
74: l_where_binds ak_query_pkg.bind_tab;
75: l_where_clause varchar2(2000);
76: v_index number;
77:
78: begin

Line 181: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

177: else
178: end_row := p_end_row;
179: end if;
180:
181: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
182: P_PARENT_REGION_CODE => 'ICX_SAVED_CARTS_R',
183: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
184: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
185: -- P_WHERE_CLAUSE => where_clause,

Line 197: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;

193:
194: /* get number of total rows returned by lov to be used to determine if
195: we need to display the next/previous buttons */
196:
197: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
198: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
199: if end_row > total_rows then
200: end_row := total_rows;
201: end if;

Line 198: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;

194: /* get number of total rows returned by lov to be used to determine if
195: we need to display the next/previous buttons */
196:
197: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
198: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
199: if end_row > total_rows then
200: end_row := total_rows;
201: end if;
202:

Line 210: if ak_query_pkg.g_results_table.COUNT > 0 then

206:
207:
208: i := 0;
209:
210: if ak_query_pkg.g_results_table.COUNT > 0 then
211: htp.tableOpen('BORDER=0');
212: htp.tableRowOpen;
213: htp.tableData('

'||c_title||'

');
214: htp.tableRowClose;

Line 223: if ak_query_pkg.g_results_table.COUNT = 0 then

219: end if;
220: end if;
221:
222:
223: if ak_query_pkg.g_results_table.COUNT = 0 then
224: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
225: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
226: htp.p('

'||fnd_message.get||'

');
227: else

Line 230: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

226: htp.p('

'||fnd_message.get||'

');
227: else
228: htp.tableOpen('BORDER=4');
229: htp.p('');
230: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
231: if ak_query_pkg.g_items_table(i).secured_column = 'F'
232: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
233: then
234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);

Line 231: if ak_query_pkg.g_items_table(i).secured_column = 'F'

227: else
228: htp.tableOpen('BORDER=4');
229: htp.p('');
230: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
231: if ak_query_pkg.g_items_table(i).secured_column = 'F'
232: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
233: then
234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
235: end if;

Line 232: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

228: htp.tableOpen('BORDER=4');
229: htp.p('');
230: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
231: if ak_query_pkg.g_items_table(i).secured_column = 'F'
232: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
233: then
234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
235: end if;
236:

Line 234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);

230: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
231: if ak_query_pkg.g_items_table(i).secured_column = 'F'
232: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
233: then
234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
235: end if;
236:
237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;

Line 237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then

233: then
234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
235: end if;
236:
237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;
239: end if;
240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;

Line 238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;

234: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
235: end if;
236:
237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;
239: end if;
240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;
242: end if;

Line 240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then

236:
237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;
239: end if;
240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;
242: end if;
243: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
244: l_cart_name_value_id := ak_query_pkg.g_items_table(i).value_id;

Line 241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;

237: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
238: l_cart_id_value_id := ak_query_pkg.g_items_table(i).value_id;
239: end if;
240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;
242: end if;
243: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
244: l_cart_name_value_id := ak_query_pkg.g_items_table(i).value_id;
245: end if;

Line 243: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then

239: end if;
240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;
242: end if;
243: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
244: l_cart_name_value_id := ak_query_pkg.g_items_table(i).value_id;
245: end if;
246:
247: end loop;

Line 244: l_cart_name_value_id := ak_query_pkg.g_items_table(i).value_id;

240: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EMERGENCY_FLAG' then
241: l_emergency_flag_value_id := ak_query_pkg.g_items_table(i).value_id;
242: end if;
243: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
244: l_cart_name_value_id := ak_query_pkg.g_items_table(i).value_id;
245: end if;
246:
247: end loop;
248: htp.tableData('');

Line 250: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

246:
247: end loop;
248: htp.tableData('');
249: htp.tableRowClose;
250: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
251: -- if r >= p_start_row-1 and r <= end_row-1
252: -- then
253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;

Line 253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

249: htp.tableRowClose;
250: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
251: -- if r >= p_start_row-1 and r <= end_row-1
252: -- then
253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;
255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

251: -- if r >= p_start_row-1 and r <= end_row-1
252: -- then
253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;
255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
258: then
259: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then

Line 256: if ak_query_pkg.g_items_table(i).secured_column = 'F'

252: -- then
253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;
255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
258: then
259: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
260:

Line 257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;
255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
258: then
259: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
260:
261: if (y_table(l_emergency_flag_value_id) = 'N') OR

Line 259: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then

255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
258: then
259: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then
260:
261: if (y_table(l_emergency_flag_value_id) = 'N') OR
262: (y_table(l_emergency_flag_value_id) IS NULL) then
263: l_emergency := 'NO';

Line 269: y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));

265: l_emergency := 'YES';
266: end if;
267:
268: htp.tableData(htf.anchor('icx_req_navigation.ic_parent?cart_id='|| icx_call.encrypt2(y_table(l_cart_id_value_id)) ||'&'||'emergency='||icx_call.encrypt2(l_emergency),
269: y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
270:
271: --Display status falg in plain ENGLISH
272: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SAVED_FLAG') then
273: if ( y_table(ak_query_pkg.g_items_table(i).value_id) = '4' ) then

Line 272: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SAVED_FLAG') then

268: htp.tableData(htf.anchor('icx_req_navigation.ic_parent?cart_id='|| icx_call.encrypt2(y_table(l_cart_id_value_id)) ||'&'||'emergency='||icx_call.encrypt2(l_emergency),
269: y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
270:
271: --Display status falg in plain ENGLISH
272: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SAVED_FLAG') then
273: if ( y_table(ak_query_pkg.g_items_table(i).value_id) = '4' ) then
274:
275: -- display_text := 'Error';
276: FND_MESSAGE.SET_NAME('FND','AFDICT_ERROR_TITLE');

Line 273: if ( y_table(ak_query_pkg.g_items_table(i).value_id) = '4' ) then

269: y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
270:
271: --Display status falg in plain ENGLISH
272: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SAVED_FLAG') then
273: if ( y_table(ak_query_pkg.g_items_table(i).value_id) = '4' ) then
274:
275: -- display_text := 'Error';
276: FND_MESSAGE.SET_NAME('FND','AFDICT_ERROR_TITLE');
277: display_text := FND_MESSAGE.GET;

Line 279: elsif ( y_table(ak_query_pkg.g_items_table(i).value_id) = '1' ) then

275: -- display_text := 'Error';
276: FND_MESSAGE.SET_NAME('FND','AFDICT_ERROR_TITLE');
277: display_text := FND_MESSAGE.GET;
278:
279: elsif ( y_table(ak_query_pkg.g_items_table(i).value_id) = '1' ) then
280:
281: FND_MESSAGE.SET_NAME('ICX','ICX_SAVED');
282: display_text := FND_MESSAGE.GET;
283: else

Line 291: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELETE') then

287: end if;
288: htp.tableData(display_text);
289:
290: --Display delete button
291: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELETE') then
292: condensed_params := icx_call.encrypt2( y_table(l_cart_id_value_id) ||'*'|| p_start_row||'*'||end_row||'*'||l_encrypted_where||'**]');
293:
294:
295:

Line 306: if ak_query_pkg.g_items_table(i).value_id is null then

302: htp.tableData(htf.anchor('javascript:delete_saved_cart('''||icx_util.replace_quotes(FND_MESSAGE.GET) ||''','''||condensed_params||''')',
303: htf.img('/OA_MEDIA/'||c_language||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));
304:
305: else
306: if ak_query_pkg.g_items_table(i).value_id is null then
307: htp.tableData('');
308: else
309: if (y_table(ak_query_pkg.g_items_table(i).value_id) is not null) then
310: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));

Line 309: if (y_table(ak_query_pkg.g_items_table(i).value_id) is not null) then

305: else
306: if ak_query_pkg.g_items_table(i).value_id is null then
307: htp.tableData('');
308: else
309: if (y_table(ak_query_pkg.g_items_table(i).value_id) is not null) then
310: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
311: else
312: htp.tableData(htf.br);
313: end if;

Line 310: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));

306: if ak_query_pkg.g_items_table(i).value_id is null then
307: htp.tableData('');
308: else
309: if (y_table(ak_query_pkg.g_items_table(i).value_id) is not null) then
310: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
311: else
312: htp.tableData(htf.br);
313: end if;
314: end if;