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_COPY_REQ dependencies on AK_QUERY_PKG

Line 225: l_where_binds ak_query_pkg.bind_tab;

221: l_err_mesg VARCHAR2(240) := NULL;
222: l_web_user_date_format VARCHAR2(240) := NULL;
223:
224: /* New vars to use the Bind vars logic **/
225: l_where_binds ak_query_pkg.bind_tab;
226: l_where_clause varchar2(2000);
227:
228:
229: BEGIN

Line 285: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,

281: /* added to take care of Bind vars Bug **/
282:
283: icx_on_utilities.unpack_whereSegment(v_where_clause, l_where_clause, l_where_binds);
284:
285: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
286: P_PARENT_REGION_CODE => 'ICX_PO_REQ_HEAD_SUM_R',
287: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
288: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
289: P_WHERE_CLAUSE => l_where_clause,

Line 298: v_total_rows := ak_query_pkg.g_results_table.count;

294: -- test - dump the plsql tables for debug purpose only!
295: -- icx_on_utilities2.printPLSQLtables;
296:
297: -- get the total number of rows
298: v_total_rows := ak_query_pkg.g_results_table.count;
299:
300: IF v_end_row > v_total_rows THEN
301: v_end_row := v_total_rows;
302: END IF;

Line 311: htp.title(ak_query_pkg.g_regions_table(0).name);

307: icx_util.copyright;
308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);
310: js.scriptClose;
311: htp.title(ak_query_pkg.g_regions_table(0).name);
312: htp.headClose;
313:
314: icx_admin_sig.toolbar(language_code => v_language_code,
315: disp_find => 'icx_req_copy_req.find_reqs');

Line 318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

314: icx_admin_sig.toolbar(language_code => v_language_code,
315: disp_find => 'icx_req_copy_req.find_reqs');
316:
317: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');

Line 336: htp.title(ak_query_pkg.g_regions_table(0).name);

332: js.scriptOpen;
333: icx_admin_sig.help_win_script(v_help_url, v_language_code);
334: js.scriptClose;
335:
336: htp.title(ak_query_pkg.g_regions_table(0).name);
337: htp.headClose;
338:
339: icx_admin_sig.toolbar(language_code => v_language_code,
340: disp_find => 'icx_req_copy_req.find_reqs');

Line 350: || ak_query_pkg.g_regions_table(0).name

346: -- Display Heading
347: htp.tableOpen('BORDER=0');
348: htp.tableRowOpen;
349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.br;

Line 372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

368: -- Print table header
369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');
370: htp.p('');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);

Line 373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'

369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');
370: htp.p('');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('');

Line 374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN

370: htp.p('');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('');
378:

Line 376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);

372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('');
378:
379: END IF; /* if ak_query_pkg.... */
380:

Line 379: END IF; /* if ak_query_pkg.... */

375:
376: htp.p('' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('');
378:
379: END IF; /* if ak_query_pkg.... */
380:
381: END LOOP;
382: htp.tableRowClose;
383: htp.tableData(''); -- ?

Line 385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP

381: END LOOP;
382: htp.tableRowClose;
383: htp.tableData(''); -- ?
384:
385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP
387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
388:
389: htp.tableRowOpen;

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

383: htp.tableData(''); -- ?
384:
385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP
387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
388:
389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

Line 391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP

387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
388:
389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN

Line 392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

388:
389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN

Line 393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')

389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN
397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN
397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);
398:

Line 395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN

391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN
397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);
398:
399: -- Build the parameter to jump into AK flow from here

Line 396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN

392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN
397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);
398:
399: -- Build the parameter to jump into AK flow from here
400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';

Line 397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);

393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')
394: OR (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
395: AND ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID') THEN
396: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_HEADER_ID' THEN
397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);
398:
399: -- Build the parameter to jump into AK flow from here
400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';
401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN

Line 401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN

397: v_req_header_id := y_table(ak_query_pkg.g_items_table(i).value_id);
398:
399: -- Build the parameter to jump into AK flow from here
400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';
401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN
402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
403:
404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN
405:

Line 402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));

398:
399: -- Build the parameter to jump into AK flow from here
400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';
401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN
402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
403:
404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN
405:
406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));

Line 404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN

400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';
401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN
402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
403:
404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN
405:
406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));
407:
408: ELSE

Line 409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN

405:
406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));
407:
408: ELSE
409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN
410: htp.tableData(' ');
411: ELSE
412: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
413: END IF;

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

408: ELSE
409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN
410: htp.tableData(' ');
411: ELSE
412: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
413: END IF;
414: END IF; /* ... ICX_REQ_NUM */
415: END IF; /* secured_column = 'F'... */
416: