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

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

352: end if; -- p_default_title = 'Y'
353:
354: if 175 = 178 then
355:
356: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
357: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
358: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
359: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
360: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',

Line 365: if ak_query_pkg.g_results_table.count > 0 then

361:
362: P_RETURN_PARENTS => 'T',
363: P_RETURN_CHILDREN => 'F');
364:
365: if ak_query_pkg.g_results_table.count > 0 then
366: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'
368: then
369: l_category_id := ak_query_pkg.g_items_table(i).value_id;

Line 366: for i in 0 .. ak_query_pkg.g_items_table.LAST loop

362: P_RETURN_PARENTS => 'T',
363: P_RETURN_CHILDREN => 'F');
364:
365: if ak_query_pkg.g_results_table.count > 0 then
366: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'
368: then
369: l_category_id := ak_query_pkg.g_items_table(i).value_id;
370: end if;

Line 367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'

363: P_RETURN_CHILDREN => 'F');
364:
365: if ak_query_pkg.g_results_table.count > 0 then
366: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'
368: then
369: l_category_id := ak_query_pkg.g_items_table(i).value_id;
370: end if;
371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'

Line 369: l_category_id := ak_query_pkg.g_items_table(i).value_id;

365: if ak_query_pkg.g_results_table.count > 0 then
366: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'
368: then
369: l_category_id := ak_query_pkg.g_items_table(i).value_id;
370: end if;
371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'
372: then
373: l_category_name := ak_query_pkg.g_items_table(i).value_id;

Line 371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'

367: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_ID'
368: then
369: l_category_id := ak_query_pkg.g_items_table(i).value_id;
370: end if;
371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'
372: then
373: l_category_name := ak_query_pkg.g_items_table(i).value_id;
374: end if;
375: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RELATED_CATEGORY'

Line 373: l_category_name := ak_query_pkg.g_items_table(i).value_id;

369: l_category_id := ak_query_pkg.g_items_table(i).value_id;
370: end if;
371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'
372: then
373: l_category_name := ak_query_pkg.g_items_table(i).value_id;
374: end if;
375: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RELATED_CATEGORY'
376: then
377: l_category_name := ak_query_pkg.g_items_table(i).value_id;

Line 375: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RELATED_CATEGORY'

371: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CATEGORY_NAME'
372: then
373: l_category_name := ak_query_pkg.g_items_table(i).value_id;
374: end if;
375: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RELATED_CATEGORY'
376: then
377: l_category_name := ak_query_pkg.g_items_table(i).value_id;
378: end if;
379: end loop;

Line 377: l_category_name := ak_query_pkg.g_items_table(i).value_id;

373: l_category_name := ak_query_pkg.g_items_table(i).value_id;
374: end if;
375: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RELATED_CATEGORY'
376: then
377: l_category_name := ak_query_pkg.g_items_table(i).value_id;
378: end if;
379: end loop;
380:
381: htp.p('Item Category is');

Line 388: for i in 0 .. ak_query_pkg.g_results_table.last loop

384: l_categories := l_categories||'

Line 389: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i),l_values);

385: else
386: l_categories := l_categories||'

Line 1078: where_clause_binds ak_query_pkg.bind_tab;

1074:
1075: v_use_context_search CHAR(1) := 'N';
1076:
1077: l_where_clause varchar2(2000);
1078: where_clause_binds ak_query_pkg.bind_tab;
1079: v_index NUMBER;
1080:
1081: begin
1082: -- dbms_session.set_sql_trace(TRUE);

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

1193: is null(v_use_context_search = 'N'). This will prevent context from
1194: returning huge number of rows when a blind query is entered */
1195: IF (v_use_context_search = 'N' ) THEN
1196:
1197: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
1198: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
1199: P_WHERE_CLAUSE => l_where_clause,
1200: P_WHERE_BINDS => where_clause_binds,
1201: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

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

1206: P_RANGE_HIGH => end_row );
1207: ELSE
1208: -- where condition is used; use the context region
1209:
1210: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
1211: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1212: P_WHERE_CLAUSE => l_where_clause,
1213: P_WHERE_BINDS => where_clause_binds,
1214: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

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

1220:
1221: END IF; /* if (where_caluse is null) */
1222:
1223: --get number of rows to display
1224: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
1225: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
1226: if end_row > total_rows then
1227: end_row := total_rows;
1228: end if;

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

1221: END IF; /* if (where_caluse is null) */
1222:
1223: --get number of rows to display
1224: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
1225: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
1226: if end_row > total_rows then
1227: end_row := total_rows;
1228: end if;
1229: htp.p( 'tr=' || total_rows);

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

1227: end_row := total_rows;
1228: end if;
1229: htp.p( 'tr=' || total_rows);
1230:
1231: if ak_query_pkg.g_results_table.COUNT = 0 then
1232: js.scriptClose;
1233: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/'
1234: || c_language || '/ICXBLUE.htm'', ''k_buttons'')" target="data"' );
1235:

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

1353: htp.tableOpen('BORDER');
1354: htp.p('');
1355:
1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:
1359: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or

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

1355:
1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:
1359: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or
1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:

Line 1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and

1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:
1359: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or
1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

Line 1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or

1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:
1359: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or
1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2

Line 1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1358:
1359: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or
1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

Line 1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1360: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
1361: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') or
1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',

Line 1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

1362: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else

Line 1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then

1363:
1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else
1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

Line 1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',

1364: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1365: --print quantity heading WITH COLSPAN=2
1366: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else
1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1372: end if;

Line 1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

1367: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1368: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')',
1369: 'CENTER','','','','width=80');
1370: else
1371: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1372: end if;
1373: end if;
1374:
1375: -- find line id, urls value id

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

1372: end if;
1373: end if;
1374:
1375: -- find line id, urls value id
1376: if ak_query_pkg.g_items_table(i).value_id is not null then
1377:
1378: --need line_id to call javascript function down() and up()
1379: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1379: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then

1375: -- find line id, urls value id
1376: if ak_query_pkg.g_items_table(i).value_id is not null then
1377:
1378: --need line_id to call javascript function down() and up()
1379: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1381: end if;
1382: -- find item_url and supplier_item_url
1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

Line 1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

1376: if ak_query_pkg.g_items_table(i).value_id is not null then
1377:
1378: --need line_id to call javascript function down() and up()
1379: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1381: end if;
1382: -- find item_url and supplier_item_url
1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

1379: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1381: end if;
1382: -- find item_url and supplier_item_url
1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1385: end if;
1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

1380: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1381: end if;
1382: -- find item_url and supplier_item_url
1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1385: end if;
1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1388: end if;

Line 1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then

1382: -- find item_url and supplier_item_url
1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1385: end if;
1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1388: end if;
1389: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1390: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

1383: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1384: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1385: end if;
1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1388: end if;
1389: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1390: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1391: end if;

Line 1389: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then

1385: end if;
1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1388: end if;
1389: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1390: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1391: end if;
1392: end if;
1393:

Line 1390: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

1386: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1387: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1388: end if;
1389: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1390: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1391: end if;
1392: end if;
1393:
1394: end loop;

Line 1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop

1396: htp.tableData('');
1397: htp.tableRowClose;
1398:
1399: -- for j in p_start_row-1 .. end_row-1 loop
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1401:
1402: temp_table(0) := '';
1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1404:

Line 1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);

1399: -- for j in p_start_row-1 .. end_row-1 loop
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1401:
1402: temp_table(0) := '';
1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1404:
1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1406:
1407: --print quantity input text box and up button if v_qty_flag is set

Line 1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

1401:
1402: temp_table(0) := '';
1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1404:
1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1406:
1407: --print quantity input text box and up button if v_qty_flag is set
1408: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1409: display_text := '

Line 1408: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1404:
1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1406:
1407: --print quantity input text box and up button if v_qty_flag is set
1408: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1409: display_text := '

1410: || ' SIZE=' || to_char(V_QUANTITY_LENGTH) || ' onChange=''if(!parent.parent.checkNumber(this)){this.focus();this.value="";}''>';
1411:
1412: --@@show the quantity in the box filled in in the previous record set

Line 1426: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then

1422:
1423: temp_table(0) := temp_table(0) || display_text;
1424: end if;
1425:
1426: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then
1427: display_text := '';
1428:
1429: l_pos := l_pos + 1;
1430: temp_table(0) := temp_table(0) || display_text;

Line 1427: display_text := '';

1423: temp_table(0) := temp_table(0) || display_text;
1424: end if;
1425:
1426: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then
1427: display_text := '';
1428:
1429: l_pos := l_pos + 1;
1430: temp_table(0) := temp_table(0) || display_text;
1431: end if;

Line 1434: if ak_query_pkg.g_items_table(i).value_id is not null

1430: temp_table(0) := temp_table(0) || display_text;
1431: end if;
1432:
1433:
1434: if ak_query_pkg.g_items_table(i).value_id is not null
1435: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1436: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1438:

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

1431: end if;
1432:
1433:
1434: if ak_query_pkg.g_items_table(i).value_id is not null
1435: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1436: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1438:
1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/

Line 1436: and ak_query_pkg.g_items_table(i).secured_column <> 'T'

1432:
1433:
1434: if ak_query_pkg.g_items_table(i).value_id is not null
1435: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1436: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1438:
1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1440:

Line 1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then

1433:
1434: if ak_query_pkg.g_items_table(i).value_id is not null
1435: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1436: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1438:
1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1440:
1441: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

Line 1441: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

1437: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1438:
1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1440:
1441: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1442: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1443: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1444: /* End Change Bug #640289 By Suri ***/
1445: else

Line 1442: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);

1438:
1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1440:
1441: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1442: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1443: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1444: /* End Change Bug #640289 By Suri ***/
1445: else
1446: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 1443: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));

1439: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1440:
1441: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1442: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1443: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1444: /* End Change Bug #640289 By Suri ***/
1445: else
1446: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1447: end if;

Line 1446: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

1442: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1443: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1444: /* End Change Bug #640289 By Suri ***/
1445: else
1446: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1447: end if;
1448:
1449: --Display item_description as a link and a tabledata
1450: if display_text is not NULL then

Line 1451: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') then

1447: end if;
1448:
1449: --Display item_description as a link and a tabledata
1450: if display_text is not NULL then
1451: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') then
1452: v_item_url := y_table(v_item_url_ind);
1453: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1454: end if;
1455: --Display source_name as a link

Line 1456: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then

1452: v_item_url := y_table(v_item_url_ind);
1453: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1454: end if;
1455: --Display source_name as a link
1456: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
1457: v_supplier_url := y_table(v_supplier_url_ind);
1458: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1459: end if;
1460: --Display supplier item number as a link

Line 1461: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' then

1457: v_supplier_url := y_table(v_supplier_url_ind);
1458: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1459: end if;
1460: --Display supplier item number as a link
1461: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' then
1462: v_supplier_item_url := y_table(v_supplier_item_url_ind);
1463: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_item_url, display_text);
1464: end if;
1465: end if;

Line 1474: if ak_query_pkg.g_items_table(i).bold = 'Y' then

1470: if display_text = '-' then
1471: display_text := htf.br;
1472: end if;
1473:
1474: if ak_query_pkg.g_items_table(i).bold = 'Y' then
1475: display_text := htf.bold(display_text);
1476: end if;
1477: --Italics
1478: if ak_query_pkg.g_items_table(i).italic = 'Y' then

Line 1478: if ak_query_pkg.g_items_table(i).italic = 'Y' then

1474: if ak_query_pkg.g_items_table(i).bold = 'Y' then
1475: display_text := htf.bold(display_text);
1476: end if;
1477: --Italics
1478: if ak_query_pkg.g_items_table(i).italic = 'Y' then
1479: display_text := htf.italic(display_text);
1480: end if;
1481: temp_table(0) := temp_table(0) ||
1482: htf.tableData( cvalue => display_text,

Line 1483: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,

1479: display_text := htf.italic(display_text);
1480: end if;
1481: temp_table(0) := temp_table(0) ||
1482: htf.tableData( cvalue => display_text,
1483: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1484: crowspan => '2',
1485: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1486: );
1487: end if;

Line 1485: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment

1481: temp_table(0) := temp_table(0) ||
1482: htf.tableData( cvalue => display_text,
1483: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1484: crowspan => '2',
1485: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1486: );
1487: end if;
1488: end loop; -- for i
1489: