APPS.ICX_REQ_ORDER dependencies on AK_QUERY_PKG

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

370: -- old background
371: htp.p('');
372: htp.p('');
373:
374: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
375:
376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or

Line 376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and

372: htp.p('

');
373:
374: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
375:
376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'

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

373:
374: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
375:
376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'

Line 378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or

374: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
375:
376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and

Line 379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or

375:
376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and

Line 380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'

376: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or

Line 381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'

377: ((ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or
385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and

Line 382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and

378: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or
385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and
386: v_vendor_on_flag = 'Y') then

Line 383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and

379: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or
385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and
386: v_vendor_on_flag = 'Y') then
387:

Line 384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or

380: ((ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE'
381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or
385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and
386: v_vendor_on_flag = 'Y') then
387:
388: v_table_attribute := '';

Line 385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and

381: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT'
382: or ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE') and
383: v_vendor_on_flag = 'Y' and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
384: ak_query_pkg.g_items_table(i).secured_column <> 'T' ))) or
385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and
386: v_vendor_on_flag = 'Y') then
387:
388: v_table_attribute := '';
389: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' then

Line 389: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' then

385: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and
386: v_vendor_on_flag = 'Y') then
387:
388: v_table_attribute := '';
389: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' then
390: v_table_attribute := ' COLSPAN=2 ';
391: l_col := l_col + 1;
392: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and v_vendor_on_flag = 'Y' then
393:

Line 392: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and v_vendor_on_flag = 'Y' then

388: v_table_attribute := '';
389: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' then
390: v_table_attribute := ' COLSPAN=2 ';
391: l_col := l_col + 1;
392: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and v_vendor_on_flag = 'Y' then
393:
394: v_table_attribute := ' COLSPAN=2 ';
395: l_col := l_col + 1;
396:

Line 397: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).update_flag = 'Y' and v_req_overwrite_flag = 'Y' then

393:
394: v_table_attribute := ' COLSPAN=2 ';
395: l_col := l_col + 1;
396:
397: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).update_flag = 'Y' and v_req_overwrite_flag = 'Y' then
398: v_table_attribute := ' COLSPAN=2 ';
399: l_col := l_col + 1;
400:
401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and

Line 401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and

397: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).update_flag = 'Y' and v_req_overwrite_flag = 'Y' then
398: v_table_attribute := ' COLSPAN=2 ';
399: l_col := l_col + 1;
400:
401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and

Line 402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and

398: v_table_attribute := ' COLSPAN=2 ';
399: l_col := l_col + 1;
400:
401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and

Line 403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then

399: l_col := l_col + 1;
400:
401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and

Line 405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and

401: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
408: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then
409:

Line 406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and

402: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
408: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then
409:
410: v_table_attribute := ' COLSPAN=2 ';

Line 407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and

403: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
408: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then
409:
410: v_table_attribute := ' COLSPAN=2 ';
411: l_col := l_col + 1;

Line 408: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then

404:
405: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
406: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
407: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
408: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' then
409:
410: v_table_attribute := ' COLSPAN=2 ';
411: l_col := l_col + 1;
412:

Line 416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and

412:
413: end if;
414: end if;
415:
416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and
417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and

Line 417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and

413: end if;
414: end if;
415:
416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and
417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and

Line 418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and

414: end if;
415:
416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and
417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and

Line 419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and

415:
416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and
417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and

Line 420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and

416: if (ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID' and
417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then

Line 421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and

417: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID' and
418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:

Line 422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and

418: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR_ID' and
419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:
426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then

Line 423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and

419: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SHOPPER_ID' and
420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:
426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then
427:

Line 424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then

420: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_CART_ID' and
421: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_APPROVER_ID' and
422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:
426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then
427:
428: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );

Line 426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then

422: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_ORG_ID' and
423: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_ID' and
424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:
426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then
427:
428: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
429:
430: else

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

424: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_REQ_LOC_CD') then
425:
426: if ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_UNIT_PRICE' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_EXT_PRICE' then
427:
428: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
429:
430: else
431:
432: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ') ' );

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

428: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
429:
430: else
431:
432: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ') ' );
433:
434:
435: end if;
436:

Line 439: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

435: end if;
436:
437: l_col := l_col + 1;
438:
439: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
440: l_total_price_column := l_col;
441: end if;
442: end if;
443:

Line 488: for r in 0..ak_query_pkg.g_results_table.LAST loop

484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop

Line 490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

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

488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
495: and ak_query_pkg.g_items_table(i).secured_column = 'F'
496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

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

490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
495: and ak_query_pkg.g_items_table(i).secured_column = 'F'
496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
497: then
498:

Line 495: and ak_query_pkg.g_items_table(i).secured_column = 'F'

491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
495: and ak_query_pkg.g_items_table(i).secured_column = 'F'
496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
497: then
498:
499: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code || 'A', cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

Line 496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
495: and ak_query_pkg.g_items_table(i).secured_column = 'F'
496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
497: then
498:
499: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code || 'A', cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
500:

Line 499: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code || 'A', cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

495: and ak_query_pkg.g_items_table(i).secured_column = 'F'
496: and ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
497: then
498:
499: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code || 'A', cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
500:
501: -- remember org id and loc id positions for LOV use
502: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID_L' then
503: l_org_id_pos := l_pos;

Line 502: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID_L' then

498:
499: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code || 'A', cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
500:
501: -- remember org id and loc id positions for LOV use
502: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID_L' then
503: l_org_id_pos := l_pos;
504: end if;
505: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID_L' then
506: l_loc_id_pos := l_pos;

Line 505: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID_L' then

501: -- remember org id and loc id positions for LOV use
502: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID_L' then
503: l_org_id_pos := l_pos;
504: end if;
505: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID_L' then
506: l_loc_id_pos := l_pos;
507: end if;
508:
509: l_pos := l_pos + 1;

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

512: end loop;
513:
514: htp.p('

');
515:
516: for i in 0..ak_query_pkg.g_items_table.LAST loop
517:
518: --add by alex
519: pk := l_values(p_cart_line_id_value);
520: --

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

517:
518: --add by alex
519: pk := l_values(p_cart_line_id_value);
520: --
521: if ak_query_pkg.g_items_table(i).value_id is null
522: then
523: l_value := '';
524: else
525: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 525: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);

521: if ak_query_pkg.g_items_table(i).value_id is null
522: then
523: l_value := '';
524: else
525: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);
526:
527: /* compute price total */
528: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
529: l_ext_price_total := l_ext_price_total + to_number(nvl(l_value,0));

Line 528: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

524: else
525: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);
526:
527: /* compute price total */
528: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
529: l_ext_price_total := l_ext_price_total + to_number(nvl(l_value,0));
530: end if;
531:
532: end if;

Line 534: IF (NOT (ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

530: end if;
531:
532: end if;
533:
534: IF (NOT (ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
535: and ak_query_pkg.g_items_table(i).secured_column = 'F'))
536: THEN
537: /* if item is on of suggested_vendor_phone/contact/name and
538: it's not displayed, we still need to save a space for it to

Line 535: and ak_query_pkg.g_items_table(i).secured_column = 'F'))

531:
532: end if;
533:
534: IF (NOT (ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
535: and ak_query_pkg.g_items_table(i).secured_column = 'F'))
536: THEN
537: /* if item is on of suggested_vendor_phone/contact/name and
538: it's not displayed, we still need to save a space for it to
539: store its value in case if user changes the suggested_vendor */

Line 540: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

536: THEN
537: /* if item is on of suggested_vendor_phone/contact/name and
538: it's not displayed, we still need to save a space for it to
539: store its value in case if user changes the suggested_vendor */
540: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
541: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
542: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
543: v_vendor_LOV_flag = 'Y' then
544: htp.p(' 549: || '">');

Line 556: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

552:
553: end if;
554:
555: ELSE /* if node_display_flag='Y' and secured_column = 'F' */
556: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
557: then
558: null;
559: elsif ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
560: then

Line 559: elsif ak_query_pkg.g_items_table(i).item_style = 'IMAGE'

555: ELSE /* if node_display_flag='Y' and secured_column = 'F' */
556: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
557: then
558: null;
559: elsif ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
560: then
561: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELETE'
562: then
563: htp.tableData(cvalue => ' 564: || l_values(p_cart_line_id_value)
565: -- || ')">

Line 567: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

563: htp.tableData(cvalue => ' 566: || ')" onMouseOver="window.status='''
567: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
568: || '''; return true"> 569: || l_language_code
570: -- || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no>',
571: || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'

Line 572: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

568: || '''; return true"> 569: || l_language_code
570: -- || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no>',
571: || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'
572: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
573: || '">',
574: crowspan => 2,
575: -- add by Mary
576: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

Line 576: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

572: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
573: || '">',
574: crowspan => 2,
575: -- add by Mary
576: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
577:
578: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SPLIT'
579: then
580: htp.tableData(cvalue => ' 581: || l_values(p_cart_line_id_value)
582: -- || ')">

Line 584: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

580: htp.tableData(cvalue => ' 583: || ')" onMouseOver="window.status='''
584: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
585: || '''; return true"> 586: || l_language_code
587: -- || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no>',
588: || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'

Line 589: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

585: || '''; return true"> 586: || l_language_code
587: -- || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no>',
588: || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'
589: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
590: || '">',
591: crowspan => 2,
592: -- add by Mary
593: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

Line 593: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

589: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
590: || '">',
591: crowspan => 2,
592: -- add by Mary
593: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
594:
595: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ACCT_DIST'
596: then
597: htp.tableData(cvalue => '

Line 595: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ACCT_DIST'

591: crowspan => 2,
592: -- add by Mary
593: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
594:
595: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ACCT_DIST'
596: then
597: htp.tableData(cvalue => ' 598: href="javascript:accountDist('
599: || l_values(p_cart_line_id_value)

Line 602: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

598: href="javascript:accountDist('
599: || l_values(p_cart_line_id_value)
600: -- || ')"> 601: || ')" onMouseOver="window.status='''
602: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
603: || '''; return true"> 604: || l_language_code
605: -- || '/FNDIMADS.gif HEIGHT=16 WIDTH=16 BORDER=no>',
606: || '/FNDISPLT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'

Line 607: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

603: || '''; return true"> 604: || l_language_code
605: -- || '/FNDIMADS.gif HEIGHT=16 WIDTH=16 BORDER=no>',
606: || '/FNDISPLT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
607: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
608: || '">',
609: crowspan => 2,
610: -- add by Mary
611: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);--

Line 611: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);--

607: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
608: || '">',
609: crowspan => 2,
610: -- add by Mary
611: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);--
612:
613: --add by alex
614: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PAPER_CLIP' then
615: fnd_webattch.GetSummaryStatus('ICX_REQS', 'REQ_LINES',

Line 614: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PAPER_CLIP' then

610: -- add by Mary
611: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);--
612:
613: --add by alex
614: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PAPER_CLIP' then
615: fnd_webattch.GetSummaryStatus('ICX_REQS', 'REQ_LINES',
616: pk, NULL, NULL, NULL, NULL, attachment_status);
617: if (attachment_status <> 'DISABLE' AND attachment_status = 'FULL') then
618: htp.tableData(cvalue => '

Line 624: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

620: || pk
621: || ''' ,'''' , '''
622: || v_dcdname
623: ||''')" onMouseOver="window.status='''
624: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
625: || '''; return true"> 626: || l_language_code
627: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

Line 628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

624: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
625: || '''; return true"> 626: || l_language_code
627: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
629: || '">',
630: crowspan => 2,
631: -- add by Mary
632: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

Line 632: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
629: || '">',
630: crowspan => 2,
631: -- add by Mary
632: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
633: elsif (attachment_status <> 'DISABLE') then
634: htp.tableData(cvalue => ' 635: href="javascript:attachment(2, '''
636: || pk

Line 641: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

637: || ''' ,'''' , '''
638: ||v_dcdname
639: -- ||''')"> 640: ||''')" onMouseOver="window.status='''
641: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
642: || '''; return true"> 643: || l_language_code
644: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

Line 645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)

641: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
642: || '''; return true"> 643: || l_language_code
644: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
646: || '">',
647: crowspan => 2,
648: -- add by Mary
649: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

Line 649: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);

645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
646: || '">',
647: crowspan => 2,
648: -- add by Mary
649: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
650: end if;
651: --
652:
653: end if; -- attribute_code

Line 655: if ak_query_pkg.g_items_table(i).update_flag = 'Y'

651: --
652:
653: end if; -- attribute_code
654: else
655: if ak_query_pkg.g_items_table(i).update_flag = 'Y'
656: then
657:
658: l_colspan := 1;
659:

Line 663: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then

659:
660: -- if location code, null out locaiton id and org id if user
661: -- type in code manually, so that submit will validate the
662: -- code and fill in the ids
663: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then
664:
665: htp.tableData(cvalue => ' 667: || to_char(l_org_id_pos) || '].value ="";document.KEVIN.elements[' || to_char(l_loc_id_pos) || '].value="";''>', crowspan => 2);

Line 665: htp.tableData(cvalue => ' 664:
665: htp.tableData(cvalue => ' 667: || to_char(l_org_id_pos) || '].value ="";document.KEVIN.elements[' || to_char(l_loc_id_pos) || '].value="";''>', crowspan => 2);
668: else
669:

Line 666: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE = "'|| replace(l_value,'"','"') ||'" onBlur='' document.KEVIN.elements['

662: -- code and fill in the ids
663: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then
664:
665: htp.tableData(cvalue => ' 667: || to_char(l_org_id_pos) || '].value ="";document.KEVIN.elements[' || to_char(l_loc_id_pos) || '].value="";''>', crowspan => 2);
668: else
669:
670: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

Line 670: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

666: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE = "'|| replace(l_value,'"','"') ||'" onBlur='' document.KEVIN.elements['
667: || to_char(l_org_id_pos) || '].value ="";document.KEVIN.elements[' || to_char(l_loc_id_pos) || '].value="";''>', crowspan => 2);
668: else
669:
670: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
671: l_value := to_char(to_number(l_value),v_money_fmt_mask);
672: l_value := replace(l_value,',','');
673: end if;
674:

Line 675: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or

671: l_value := to_char(to_number(l_value),v_money_fmt_mask);
672: l_value := replace(l_value,',','');
673: end if;
674:
675: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
676: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
677: l_value := replace(l_value,',','');
678:
679: htp.tableData(cvalue => '

672: l_value := replace(l_value,',','');
673: end if;
674:
675: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V' or
676: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
677: l_value := replace(l_value,',','');
678:
679: htp.tableData(cvalue => ' 676: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
677: l_value := replace(l_value,',','');
678:
679: htp.tableData(cvalue => '', crowspan => 2);
682:
683: else

Line 680: ak_query_pkg.g_items_table(i).display_value_length || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE = "'

676: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
677: l_value := replace(l_value,',','');
678:
679: htp.tableData(cvalue => '', crowspan => 2);
682:
683: else
684:

Line 685: htp.tableData(cvalue => '', crowspan => 2);
682:
683: else
684:
685: htp.tableData(cvalue => '', crowspan => 2);
688:
689: end if;

Line 686: || 'A' || ' size=' || ak_query_pkg.g_items_table(i).display_value_length || ' maxlength='

682:
683: else
684:
685: htp.tableData(cvalue => '', crowspan => 2);
688:
689: end if;
690:

Line 687: || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE = "'|| replace(l_value,'"','"') ||'">', crowspan => 2);

683: else
684:
685: htp.tableData(cvalue => '', crowspan => 2);
688:
689: end if;
690:
691: end if;

Line 693: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V'

689: end if;
690:
691: end if;
692:
693: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY_V'
694: then
695: l_spin_pos := l_pos;
696: htp.tableData(cvalue => '',cattributes => 'width=18 valign=bottom');
701: end if;
702:
703: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
704:
705: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV1(''178'',''ICX_SUGGESTED_VENDOR_NAME'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''','''
706: || to_char(l_pos) || ''',''' || to_char(l_pos + 1) || ''',''' || to_char(l_pos + 2) || ''',''' || to_char(l_pos + 3) || ''')',htf.img('/OA_MEDIA/'
707: ||l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''

Line 710: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then -- must be location LOV

706: || to_char(l_pos) || ''',''' || to_char(l_pos + 1) || ''',''' || to_char(l_pos + 2) || ''',''' || to_char(l_pos + 3) || ''')',htf.img('/OA_MEDIA/'
707: ||l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''
708: || icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
709:
710: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then -- must be location LOV
711:
712: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV2(''178'',''ICX_DELIVER_TO_LOCATION_L'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' ||
713: to_char(l_org_id_pos) || ''',''' || to_char(l_loc_id_pos) || ''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||l_language_code||
714: '/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''|| icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);

Line 717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and

713: to_char(l_org_id_pos) || ''',''' || to_char(l_loc_id_pos) || ''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||l_language_code||
714: '/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''|| icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
715:
716: -- user has LOV
717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and

Line 718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and

714: '/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''|| icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
715:
716: -- user has LOV
717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and

Line 719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and

715:
716: -- user has LOV
717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then

Line 720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and

716: -- user has LOV
717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:

Line 721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and

717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:
725:

Line 722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and

718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:
725:
726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||

Line 723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then

719: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and
720: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and
721: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and
722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:
725:
726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||
727: ''',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||

Line 726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||

722: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and
723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:
725:
726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||
727: ''',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||
728: l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''||
729: icx_util.replace_onMouseOver_quotes(c_title) || ''';return true"'), crowspan => 2);
730:

Line 736: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

732:
733: l_pos := l_pos + 1;
734:
735: ELSE /* if update_flag <> 'Y' */
736: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
737: l_value := to_char(to_number(l_value),v_money_fmt_mask);
738: end if;
739:
740: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

Line 740: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

736: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
737: l_value := to_char(to_number(l_value),v_money_fmt_mask);
738: end if;
739:
740: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
741: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
742: ak_query_pkg.g_items_table(i).attribute_code =
743: 'ICX_SUGGESTED_VENDOR_SITE')
744: AND v_vendor_LOV_flag = 'Y'

Line 741: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or

737: l_value := to_char(to_number(l_value),v_money_fmt_mask);
738: end if;
739:
740: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
741: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
742: ak_query_pkg.g_items_table(i).attribute_code =
743: 'ICX_SUGGESTED_VENDOR_SITE')
744: AND v_vendor_LOV_flag = 'Y'
745: THEN

Line 742: ak_query_pkg.g_items_table(i).attribute_code =

738: end if;
739:
740: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
741: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
742: ak_query_pkg.g_items_table(i).attribute_code =
743: 'ICX_SUGGESTED_VENDOR_SITE')
744: AND v_vendor_LOV_flag = 'Y'
745: THEN
746: /* Even if update_flag <> 'Y', we still want it to be an

Line 750: || ak_query_pkg.g_items_table(i).attribute_code|| 'A'

746: /* Even if update_flag <> 'Y', we still want it to be an
747: input text field so that it can be dynamically changed
748: when ICX_SUGGESTED_VENDOR_NAME is changed */
749: htp.tableData(cvalue => ' 751: || ' size='|| ak_query_pkg.g_items_table(i).display_value_length
752: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length
753: || ' VALUE = "'|| replace(l_value,'"','"')
754: ||'" onFocus=''document.KEVIN.elements['

Line 751: || ' size='|| ak_query_pkg.g_items_table(i).display_value_length

747: input text field so that it can be dynamically changed
748: when ICX_SUGGESTED_VENDOR_NAME is changed */
749: htp.tableData(cvalue => ' 751: || ' size='|| ak_query_pkg.g_items_table(i).display_value_length
752: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length
753: || ' VALUE = "'|| replace(l_value,'"','"')
754: ||'" onFocus=''document.KEVIN.elements['
755: || to_char(l_pos-1) || '].focus(); ''>',

Line 752: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length

748: when ICX_SUGGESTED_VENDOR_NAME is changed */
749: htp.tableData(cvalue => ' 751: || ' size='|| ak_query_pkg.g_items_table(i).display_value_length
752: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length
753: || ' VALUE = "'|| replace(l_value,'"','"')
754: ||'" onFocus=''document.KEVIN.elements['
755: || to_char(l_pos-1) || '].focus(); ''>',
756: crowspan => 2);

Line 761: ak_query_pkg.g_items_table(i).bold,

757: l_pos := l_pos + 1;
758: ELSE /* if attribute_code <> 'ICX_SUGGESTED_VENDOR_*' */
759: htp.tableData(cvalue =>
760: icx_on_utilities.formatText(replace(l_value,'"','"'),
761: ak_query_pkg.g_items_table(i).bold,
762: ak_query_pkg.g_items_table(i).italic),
763: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
764: cattributes =>'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => 2);
765: END IF; /* attribute_code */

Line 762: ak_query_pkg.g_items_table(i).italic),

758: ELSE /* if attribute_code <> 'ICX_SUGGESTED_VENDOR_*' */
759: htp.tableData(cvalue =>
760: icx_on_utilities.formatText(replace(l_value,'"','"'),
761: ak_query_pkg.g_items_table(i).bold,
762: ak_query_pkg.g_items_table(i).italic),
763: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
764: cattributes =>'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => 2);
765: END IF; /* attribute_code */
766: -- end if;

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

759: htp.tableData(cvalue =>
760: icx_on_utilities.formatText(replace(l_value,'"','"'),
761: ak_query_pkg.g_items_table(i).bold,
762: ak_query_pkg.g_items_table(i).italic),
763: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
764: cattributes =>'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => 2);
765: END IF; /* attribute_code */
766: -- end if;
767: end if; -- update_flag

Line 764: cattributes =>'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => 2);

760: icx_on_utilities.formatText(replace(l_value,'"','"'),
761: ak_query_pkg.g_items_table(i).bold,
762: ak_query_pkg.g_items_table(i).italic),
763: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
764: cattributes =>'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => 2);
765: END IF; /* attribute_code */
766: -- end if;
767: end if; -- update_flag
768:

Line 794: procedure PrintTotal(v_items_table ak_query_pkg.items_table_type) is

790: end PrintItems;
791:
792:
793: ------------------------------------------------------------
794: procedure PrintTotal(v_items_table ak_query_pkg.items_table_type) is
795: ------------------------------------------------------------
796:
797: i number := 0;
798: column_number number := 0;

Line 876: l_cart_line_id_value := ak_query_pkg.g_items_table(0).value_id;

872: end if;
873:
874: -- cartline id is always return as the first item
875: -- required to pass back for delete and split button
876: l_cart_line_id_value := ak_query_pkg.g_items_table(0).value_id;
877:
878: for i in 0..ak_query_pkg.g_items_table.last loop
879:
880: -- turn all on if one is on for supplier LOV

Line 878: for i in 0..ak_query_pkg.g_items_table.last loop

874: -- cartline id is always return as the first item
875: -- required to pass back for delete and split button
876: l_cart_line_id_value := ak_query_pkg.g_items_table(0).value_id;
877:
878: for i in 0..ak_query_pkg.g_items_table.last loop
879:
880: -- turn all on if one is on for supplier LOV
881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or

Line 881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or

877:
878: for i in 0..ak_query_pkg.g_items_table.last loop
879:
880: -- turn all on if one is on for supplier LOV
881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and

Line 882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or

878: for i in 0..ak_query_pkg.g_items_table.last loop
879:
880: -- turn all on if one is on for supplier LOV
881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and

Line 883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

879:
880: -- turn all on if one is on for supplier LOV
881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and

Line 884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and

880: -- turn all on if one is on for supplier LOV
881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then

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

881: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
889:

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

882: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
889:
890: v_vendor_LOV_flag := 'Y';

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

883: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
889:
890: v_vendor_LOV_flag := 'Y';
891: exit;

Line 888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then

884: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
885: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
886: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
887: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
888: ak_query_pkg.g_items_table(i).update_flag = 'Y' then
889:
890: v_vendor_LOV_flag := 'Y';
891: exit;
892: end if;

Line 896: --dc for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

892: end if;
893: end loop; -- g_items_table
894:
895: --dc
896: --dc for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
897:
898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

Line 898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or

894:
895: --dc
896: --dc for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
897:
898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then

Line 899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or

895: --dc
896: --dc for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
897:
898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc

Line 900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

896: --dc for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
897:
898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc
904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';

Line 901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and

897:
898: --dc if (ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
899: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc
904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
905: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then

Line 904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';

900: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc
904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
905: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
906: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
907: --dc
908: --dc end if;

Line 905: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then

901: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc
904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
905: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
906: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
907: --dc
908: --dc end if;
909:

Line 906: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';

902: --dc v_vendor_LOV_flag = 'Y' then
903: --dc
904: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
905: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
906: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
907: --dc
908: --dc end if;
909:
910: --dc end if;

Line 914: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then

910: --dc end if;
911:
912:
913: -- required to pass back for delete and split button
914: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
915: --dc l_cart_line_id_value := ak_query_pkg.g_items_table(j).value_id;
916: --dc end if; -- attribute_code
917:
918: -- required hidden ids fields

Line 915: --dc l_cart_line_id_value := ak_query_pkg.g_items_table(j).value_id;

911:
912:
913: -- required to pass back for delete and split button
914: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
915: --dc l_cart_line_id_value := ak_query_pkg.g_items_table(j).value_id;
916: --dc end if; -- attribute_code
917:
918: -- required hidden ids fields
919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then

Line 919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then

915: --dc l_cart_line_id_value := ak_query_pkg.g_items_table(j).value_id;
916: --dc end if; -- attribute_code
917:
918: -- required hidden ids fields
919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or

Line 920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or

916: --dc end if; -- attribute_code
917:
918: -- required hidden ids fields
919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then

Line 921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or

917:
918: -- required hidden ids fields
919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';

Line 922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or

918: -- required hidden ids fields
919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';
926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';

Line 923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or

919: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CART_LINE_ID' then
920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';
926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
927:

Line 924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then

920: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_ID' or
921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';
926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
927:
928: --dc end if;

Line 925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';

921: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_CATEGORY_ID' or
922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';
926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
927:
928: --dc end if;
929:

Line 926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';

922: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DEST_ORG_ID' or
923: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_LINE_TYPE_ID' or
924: --dc -- ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
925: --dc ak_query_pkg.g_items_table(j).item_style := 'HIDDEN';
926: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
927:
928: --dc end if;
929:
930: -- required and updatable fields

Line 931: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_QTY_V' then

927:
928: --dc end if;
929:
930: -- required and updatable fields
931: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_QTY_V' then
932: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
933: --dc ak_query_pkg.g_items_table(j).update_flag := 'Y';
934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';
935: --dc end if;

Line 932: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';

928: --dc end if;
929:
930: -- required and updatable fields
931: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_QTY_V' then
932: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
933: --dc ak_query_pkg.g_items_table(j).update_flag := 'Y';
934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';
935: --dc end if;
936:

Line 933: --dc ak_query_pkg.g_items_table(j).update_flag := 'Y';

929:
930: -- required and updatable fields
931: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_QTY_V' then
932: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
933: --dc ak_query_pkg.g_items_table(j).update_flag := 'Y';
934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';
935: --dc end if;
936:
937: -- location LOV and flag setting

Line 934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';

930: -- required and updatable fields
931: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_QTY_V' then
932: --dc ak_query_pkg.g_items_table(j).node_display_flag := 'Y';
933: --dc ak_query_pkg.g_items_table(j).update_flag := 'Y';
934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';
935: --dc end if;
936:
937: -- location LOV and flag setting
938: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION' then

Line 938: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION' then

934: --dc ak_query_pkg.g_items_table(j).item_style := 'TEXT';
935: --dc end if;
936:
937: -- location LOV and flag setting
938: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION' then
939: --dc if v_req_overwrite_flag = 'Y' and ak_query_pkg.g_items_table(j).update_flag = 'Y' then
940: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
941: --dc v_location_LOV_flag := 'Y';
942: --dc else

Line 939: --dc if v_req_overwrite_flag = 'Y' and ak_query_pkg.g_items_table(j).update_flag = 'Y' then

935: --dc end if;
936:
937: -- location LOV and flag setting
938: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION' then
939: --dc if v_req_overwrite_flag = 'Y' and ak_query_pkg.g_items_table(j).update_flag = 'Y' then
940: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
941: --dc v_location_LOV_flag := 'Y';
942: --dc else
943: --dc ak_query_pkg.g_items_table(j).update_flag := 'N';

Line 940: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';

936:
937: -- location LOV and flag setting
938: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELIVER_TO_LOCATION' then
939: --dc if v_req_overwrite_flag = 'Y' and ak_query_pkg.g_items_table(j).update_flag = 'Y' then
940: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
941: --dc v_location_LOV_flag := 'Y';
942: --dc else
943: --dc ak_query_pkg.g_items_table(j).update_flag := 'N';
944: --dc end if;

Line 943: --dc ak_query_pkg.g_items_table(j).update_flag := 'N';

939: --dc if v_req_overwrite_flag = 'Y' and ak_query_pkg.g_items_table(j).update_flag = 'Y' then
940: --dc ak_query_pkg.g_items_table(j).item_style := 'POPLIST';
941: --dc v_location_LOV_flag := 'Y';
942: --dc else
943: --dc ak_query_pkg.g_items_table(j).update_flag := 'N';
944: --dc end if;
945: --dc end if;
946:
947: -- image fields

Line 948: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SPLIT' or

944: --dc end if;
945: --dc end if;
946:
947: -- image fields
948: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SPLIT' or
949: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELETE' then
950: --dc ak_query_pkg.g_items_table(j).item_style := 'IMAGE';
951: --dc end if;
952:

Line 949: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELETE' then

945: --dc end if;
946:
947: -- image fields
948: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SPLIT' or
949: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELETE' then
950: --dc ak_query_pkg.g_items_table(j).item_style := 'IMAGE';
951: --dc end if;
952:
953: --dc end loop;

Line 950: --dc ak_query_pkg.g_items_table(j).item_style := 'IMAGE';

946:
947: -- image fields
948: --dc if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_SPLIT' or
949: --dc ak_query_pkg.g_items_table(j).attribute_code = 'ICX_DELETE' then
950: --dc ak_query_pkg.g_items_table(j).item_style := 'IMAGE';
951: --dc end if;
952:
953: --dc end loop;
954:

Line 1173: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first),y_table);

1169: v_dcdName varchar2(1000) := owa_util.get_cgi_env('SCRIPT_NAME');
1170:
1171: begin
1172:
1173: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first),y_table);
1174:
1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);

Line 1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

1171: begin
1172:
1173: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first),y_table);
1174:
1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);

Line 1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then

1172:
1173: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first),y_table);
1174:
1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then

Line 1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);

1173: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first),y_table);
1174:
1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);

Line 1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then

1174:
1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1182: -- open requestor(l_requestor_id);

Line 1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);

1175: for l in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1182: -- open requestor(l_requestor_id);
1183: -- fetch requestor into l_requestor_name;

Line 1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then

1176: if ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' then
1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1182: -- open requestor(l_requestor_id);
1183: -- fetch requestor into l_requestor_name;
1184: -- close requestor;

Line 1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);

1177: l_location_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1178: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DEST_ORG_ID' then
1179: l_org_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1180: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1182: -- open requestor(l_requestor_id);
1183: -- fetch requestor into l_requestor_name;
1184: -- close requestor;
1185: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

Line 1185: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

1181: l_requestor_id := y_table(ak_query_pkg.g_items_table(l).value_id);
1182: -- open requestor(l_requestor_id);
1183: -- fetch requestor into l_requestor_name;
1184: -- close requestor;
1185: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1186: l_requestor_name := y_table(ak_query_pkg.g_items_table(l).value_id);
1187: end if;
1188: end loop;
1189:

Line 1186: l_requestor_name := y_table(ak_query_pkg.g_items_table(l).value_id);

1182: -- open requestor(l_requestor_id);
1183: -- fetch requestor into l_requestor_name;
1184: -- close requestor;
1185: elsif ak_query_pkg.g_items_table(l).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1186: l_requestor_name := y_table(ak_query_pkg.g_items_table(l).value_id);
1187: end if;
1188: end loop;
1189:
1190: htp.p('

');

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

1198: htp.p('');
1199: htp.p('');
1200: l_pos := l_pos + 8;
1201:
1202: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1203:
1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then

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

1200: l_pos := l_pos + 8;
1201:
1202: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1203:
1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or

Line 1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or

1201:
1202: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1203:
1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or

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

1202: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1203:
1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

Line 1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or

1203:
1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or

Line 1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or

1204: if (ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or

Line 1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or

1205: ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or

Line 1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

1206: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or

Line 1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or

1207: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then

Line 1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or

1208: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:

Line 1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or

1209: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:
1217:

Line 1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or

1210: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:
1217:
1218: if (ak_query_pkg.g_items_table(i).value_id is not null and

Line 1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then

1211: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1212: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' or
1213: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or
1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:
1217:
1218: if (ak_query_pkg.g_items_table(i).value_id is not null and
1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then

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

1214: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or
1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:
1217:
1218: if (ak_query_pkg.g_items_table(i).value_id is not null and
1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then
1220:
1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or

Line 1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then

1215: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD' then
1216:
1217:
1218: if (ak_query_pkg.g_items_table(i).value_id is not null and
1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then
1220:
1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or

Line 1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or

1218: if (ak_query_pkg.g_items_table(i).value_id is not null and
1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then
1220:
1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or

Line 1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or

1219: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION' and ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_REQUESTOR') then
1220:
1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or

Line 1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or

1220:
1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then

Line 1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

1221: --Special treatment object attributes
1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1229:

Line 1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or

1222: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' or
1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1229:
1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

Line 1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or

1223: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' or
1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1229:
1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1231: display_text := l_requestor_name;

Line 1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then

1224: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID' or
1225: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1229:
1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1231: display_text := l_requestor_name;
1232: else

Line 1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then

1226: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' or
1227: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_ID' or
1228: -- ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' then
1229:
1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1231: display_text := l_requestor_name;
1232: else
1233: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1234:

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

1229:
1230: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1231: display_text := l_requestor_name;
1232: else
1233: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1234:
1235: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1236: display_text := icx_call.encrypt2(y_table(ak_query_pkg.g_items_table(i).value_id));
1237: end if;

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

1231: display_text := l_requestor_name;
1232: else
1233: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1234:
1235: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1236: display_text := icx_call.encrypt2(y_table(ak_query_pkg.g_items_table(i).value_id));
1237: end if;
1238:
1239: end if;

Line 1236: display_text := icx_call.encrypt2(y_table(ak_query_pkg.g_items_table(i).value_id));

1232: else
1233: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1234:
1235: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then
1236: display_text := icx_call.encrypt2(y_table(ak_query_pkg.g_items_table(i).value_id));
1237: end if;
1238:
1239: end if;
1240:

Line 1241: htp.p('');
1243:
1244: l_pos := l_pos + 1;
1245: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RESERVED_PO_NUM' then

Line 1242: || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE="' || replace(display_text,'"','"e;') || '">');

1238:
1239: end if;
1240:
1241: htp.p('');
1243:
1244: l_pos := l_pos + 1;
1245: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RESERVED_PO_NUM' then
1246:

Line 1245: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RESERVED_PO_NUM' then

1241: htp.p('');
1243:
1244: l_pos := l_pos + 1;
1245: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_RESERVED_PO_NUM' then
1246:
1247: /* if a brand new po number, not yet reserve */
1248: /* print the button, if already reserved or a value */
1249: /* is already stored in the database, display the */

Line 1253: if y_table(ak_query_pkg.g_items_table(i).value_id) is not NULL then

1249: /* is already stored in the database, display the */
1250: /* newly reserved po or the value from database */
1251: l_po_number := v_po_number;
1252: if l_po_number is NULL then
1253: if y_table(ak_query_pkg.g_items_table(i).value_id) is not NULL then
1254: l_po_number := y_table(ak_query_pkg.g_items_table(i).value_id);
1255: end if;
1256: end if;
1257:

Line 1254: l_po_number := y_table(ak_query_pkg.g_items_table(i).value_id);

1250: /* newly reserved po or the value from database */
1251: l_po_number := v_po_number;
1252: if l_po_number is NULL then
1253: if y_table(ak_query_pkg.g_items_table(i).value_id) is not NULL then
1254: l_po_number := y_table(ak_query_pkg.g_items_table(i).value_id);
1255: end if;
1256: end if;
1257:
1258: htp.p('

');

Line 1258: htp.p('

');

1254: l_po_number := y_table(ak_query_pkg.g_items_table(i).value_id);
1255: end if;
1256: end if;
1257:
1258: htp.p('

');
1259:
1260: htp.p('');
1259:
1260: htp.p('');
1271: htp.p('');
1272:
1273:
1274: --htp.p('result += "');

Line 1307: htp.p('

');

1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then
1304:
1305: where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1306:
1307: htp.p('

');
1308: htp.p('');
1308: htp.p('');
1331: --dc htp.p('} else {');
1332: --dc htp.p('result += ""; }');
1333:
1334: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then
1335:
1336: htp.p('' );
1338:

Line 1336: htp.p(' 1333:
1334: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then
1335:
1336: htp.p('' );
1338:
1339: l_pos := l_pos + 1;
1340:

Line 1337: || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '">' );

1333:
1334: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then
1335:
1336: htp.p('' );
1338:
1339: l_pos := l_pos + 1;
1340:
1341: elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then

Line 1341: elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then

1337: || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '">' );
1338:
1339: l_pos := l_pos + 1;
1340:
1341: elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then
1342: htp.p('

');
1343: htp.p('');

1338:
1339: l_pos := l_pos + 1;
1340:
1341: elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then
1342: htp.p('

');
1343: htp.p('');
1343: htp.p('');
1343: htp.p('

' || ak_query_pkg.g_items_table(i).attribute_label_long || '
' || ak_query_pkg.g_items_table(i).attribute_label_long || '
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1261: htp.p(''); 1262: if (l_po_number is not null) then Line 1260: htp.p('	'); 1256: end if; 1257: 1258: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1261: htp.p(''); 1262: if (l_po_number is not null) then 1263: htp.p(l_po_number); 1264: Line 1274: --htp.p('result += "	";'); 1270: htp.p('		";'); 1275: 1276: htp.p('	'); 1277: if (l_po_number is NULL) then 1278: Line 1300: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_NAME' then 1296: /* 837698 increment l_pos if reserve po num is visible in emergency reqs*/ 1297: l_pos := l_pos + 1; 1298: 1299: 1300: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_NAME' then 1301: 1302: if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then 1304: Line 1302: if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1298: 1299: 1300: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_NAME' then 1301: 1302: if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then 1304: 1305: where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1306: Line 1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then 1299: 1300: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_APPROVER_NAME' then 1301: 1302: if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then 1304: 1305: where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1306: 1307: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '
' || ak_query_pkg.g_items_table(i).attribute_label_long || '
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1309: 1310: 1311: Line 1308: htp.p('	'); 1304: 1305: where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1306: 1307: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1309: 1310: 1311: 1312: htp.p(''); 1309: 1310: 1311: 1312: htp.p(' 1315: '" onBlur='' document.KEVIN.ICX_APPROVER_ID.value ="";''>'); 1316: Line 1313: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length 1309: 1310: 1311: 1312: htp.p(' 1315: '" onBlur='' document.KEVIN.ICX_APPROVER_ID.value ="";''>'); 1316: 1317: Line 1314: || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || 1310: 1311: 1312: htp.p(' 1315: '" onBlur='' document.KEVIN.ICX_APPROVER_ID.value ="";''>'); 1316: 1317: 1318: l_pos := l_pos + 1; Line 1334: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1330: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1344: 1345: Line 1342: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1344: 1345: 1346: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); Line 1343: htp.p('		'); 1339: l_pos := l_pos + 1; 1340: 1341: elsif (ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1342: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1344: 1345: 1346: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1347: Line 1346: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1342: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long || '	'); 1344: 1345: 1346: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1347: 1348: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1349: 1350: htp.p(' '); Line 1348: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1344: 1345: 1346: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1347: 1348: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1349: 1350: htp.p(''); Line 1381: if ak_query_pkg.g_items_table(i).update_flag = 'Y' then 1377: end if; 1378: 1379: else -- Special treatment object attributes 1380: 1381: if ak_query_pkg.g_items_table(i).update_flag = 'Y' then 1382: if ( ak_query_pkg.g_items_table(i).item_style = 'TEXT' ) then 1383: 1384: htp.p(' '); 1385: Line 1382: if ( ak_query_pkg.g_items_table(i).item_style = 'TEXT' ) then 1378: 1379: else -- Special treatment object attributes 1380: 1381: if ak_query_pkg.g_items_table(i).update_flag = 'Y' then 1382: if ( ak_query_pkg.g_items_table(i).item_style = 'TEXT' ) then 1383: 1384: htp.p(' '); 1385: 1386: /* dynamic LOV */ Line 1384: htp.p(' '); 1380: 1381: if ak_query_pkg.g_items_table(i).update_flag = 'Y' then 1382: if ( ak_query_pkg.g_items_table(i).item_style = 'TEXT' ) then 1383: 1384: htp.p(' '); 1385: 1386: /* dynamic LOV */ 1387: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1388: htp.p(''); 1385: 1386: /* dynamic LOV */ 1387: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1388: htp.p(''); 1385: 1386: /* dynamic LOV */ 1387: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1388: htp.p(''); 1411: 1412: /* dynamic LOV */ 1413: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1414: 1415: htp.p(''); 1426: 1427: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' ) then 1428: htp.p(''); 1430: 1431: l_pos := l_pos + 1; Line 1428: htp.p(''); 1426: 1427: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' ) then 1428: htp.p(''); 1430: 1431: l_pos := l_pos + 1; 1432: else Line 1429: || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '">'); 1425: htp.p(''); 1426: 1427: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' ) then 1428: htp.p(''); 1430: 1431: l_pos := l_pos + 1; 1432: else 1433: null; Line 1436: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' ) then 1432: else 1433: null; 1434: end if; 1435: else -- Update falg not set 1436: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' ) then 1437: 1438: htp.p(' '); 1439: htp.p(''); 1434: end if; 1435: else -- Update falg not set 1436: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' ) then 1437: 1438: htp.p(' '); 1439: htp.p(''); 1439: htp.p(''); 1439: htp.p(' '); 1351: else 1352: Line 1357: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1353: htp.p(' '); 1354: end if; 1355: 1356: --Bold 1357: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1358: htp.p(''); 1359: end if; 1360: --Italics 1361: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1361: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1357: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1358: htp.p(''); 1359: end if; 1360: --Italics 1361: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1362: htp.p(''); 1363: end if; 1364: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1365: Line 1364: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1360: --Italics 1361: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1362: htp.p(''); 1363: end if; 1364: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1365: 1366: --Bold 1367: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1368: htp.p(''); Line 1367: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1363: end if; 1364: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1365: 1366: --Bold 1367: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1368: htp.p(''); 1369: end if; 1370: --Italics 1371: if ak_query_pkg.g_items_table(i).bold = 'Y' then Line 1371: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1367: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1368: htp.p(''); 1369: end if; 1370: --Italics 1371: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1372: htp.p(''); 1373: end if; 1374: htp.p(' '); 1375: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); Line 1387: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1383: 1384: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1389: else 1390: htp.p(' '); 1391: end if; Line 1388: htp.p(' '); 1384: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1389: else 1390: htp.p(' '); 1391: end if; 1392: Line 1390: htp.p(' '); 1386: /* dynamic LOV */ 1387: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1388: htp.p(' '); 1389: else 1390: htp.p(' '); 1391: end if; 1392: 1393: display_text := ''); 1391: end if; 1392: 1393: display_text := ' 1396: 1397: l_pos := l_pos + 1; Line 1394: ak_query_pkg.g_items_table(i).display_value_length || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length 1390: htp.p(' '); 1391: end if; 1392: 1393: display_text := ' 1396: 1397: l_pos := l_pos + 1; 1398: Line 1395: || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"'; 1391: end if; 1392: 1393: display_text := ' 1396: 1397: l_pos := l_pos + 1; 1398: 1399: /* do not allow to change requisition number */ Line 1400: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then 1396: 1397: l_pos := l_pos + 1; 1398: 1399: /* do not allow to change requisition number */ 1400: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then 1401: --dc htp.p('result += " onBlur=''this.value=parent.my_cart_header.ICX_REQ_NUMBER_SEG1''>";'); 1402: 1403: display_text := display_text || ' onBlur=''this.value= ' || y_table(ak_query_pkg.g_items_table(i).value_id) || '>'; 1404: else Line 1403: display_text := display_text || ' onBlur=''this.value= ' || y_table(ak_query_pkg.g_items_table(i).value_id) || '>'; 1399: /* do not allow to change requisition number */ 1400: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUMBER_SEG1' then 1401: --dc htp.p('result += " onBlur=''this.value=parent.my_cart_header.ICX_REQ_NUMBER_SEG1''>";'); 1402: 1403: display_text := display_text || ' onBlur=''this.value= ' || y_table(ak_query_pkg.g_items_table(i).value_id) || '>'; 1404: else 1405: display_text := display_text || '>'; 1406: 1407: end if; Line 1413: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1409: htp.p(display_text); 1410: htp.p(' '); 1416: htp.p(icx_util.LOVButton(c_attribute_app_id => 178, 1417: c_attribute_code => ak_query_pkg.g_items_table(i).attribute_code, Line 1417: c_attribute_code => ak_query_pkg.g_items_table(i).attribute_code, 1413: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and ak_query_pkg.g_items_table(i).lov_region_code is not NULL then 1414: 1415: htp.p(' '); 1416: htp.p(icx_util.LOVButton(c_attribute_app_id => 178, 1417: c_attribute_code => ak_query_pkg.g_items_table(i).attribute_code, 1418: c_region_app_id => 601, 1419: c_region_code => 'ICX_SHOPPING_CART_HEADER_R', 1420: c_form_name => 'KEVIN', 1421: c_frame_name => 'my_order1')); Line 1427: elsif (ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' ) then 1423: end if; 1424: 1425: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1440: -- Line 1438: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1440: -- 1441: -- Add a table to create a white background 1442: -- htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); Line 1439: htp.p(' '); 1435: else -- Update falg not set 1436: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' ) then 1437: 1438: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1440: -- 1441: -- Add a table to create a white background 1442: -- htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1443: if (y_table(ak_query_pkg.g_items_table(i).value_id) is NULL) then Line 1442: -- htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1438: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1440: -- 1441: -- Add a table to create a white background 1442: -- htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1443: if (y_table(ak_query_pkg.g_items_table(i).value_id) is NULL) then 1444: 1445: htp.p(' '); 1446: else Line 1443: if (y_table(ak_query_pkg.g_items_table(i).value_id) is NULL) then 1439: htp.p(' '); 1440: -- 1441: -- Add a table to create a white background 1442: -- htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1443: if (y_table(ak_query_pkg.g_items_table(i).value_id) is NULL) then 1444: 1445: htp.p(''); 1476: --changed by alex 1477: else --it is a hidden field 1478: htp.p(''); 1480: l_pos := l_pos + 1; 1481: end if; 1482: end if; Line 1479: || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE="' || '">'); 1475: htp.p(''); 1476: --changed by alex 1477: else --it is a hidden field 1478: htp.p(''); 1480: l_pos := l_pos + 1; 1481: end if; 1482: end if; 1483: -- Line 1489: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' then 1485: 1486: else -- It is an attribute, treat each of them individually. 1487: 1488: 1489: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' then 1490: 1491: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1493: Line 1491: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1487: 1488: 1489: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' then 1490: 1491: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1493: 1494: 1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and Line 1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1488: 1489: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION' then 1490: 1491: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1493: 1494: 1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and 1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or Line 1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or 1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1493: 1494: 1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and 1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or 1497: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1498: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1499: ) then 1500: Line 1502: htp.p(' '); 1498: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1499: ) then 1500: 1501: 1502: htp.p(' '); 1503: htp.p(''); 1503: htp.p(''); 1503: htp.p(''); 1503: htp.p(''); 1517: else Line 1515: display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>'; 1511: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and 1512: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'N' or 1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then 1514: 1515: display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>'; 1516: htp.p(display_text || ''); 1517: else 1518: 1519: --dc htp.p('result += " onBlur=''parent.my_cart_header.ICX_DELIVER_TO_LOCATION=this.value;''>";'); Line 1534: htp.p(' '); 1530: end if; 1531: 1532: else 1533: 1534: htp.p(' '); 1535: htp.p(''); 1535: htp.p(''); 1535: htp.p(' '); 1446: else 1447: htp.p(''); Line 1478: htp.p(' '); Line 1450: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1446: else 1447: htp.p(' '); 1448: end if; 1449: --Bold 1450: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1451: htp.p(''); 1452: end if; 1453: --Italics 1454: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1454: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1450: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1451: htp.p(''); 1452: end if; 1453: --Italics 1454: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1455: htp.p(''); 1456: end if; 1457: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1458: Line 1457: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1453: --Italics 1454: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1455: htp.p(''); 1456: end if; 1457: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1458: 1459: --add by alex 1460: -- if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then 1461: pk1 := icx_call.decrypt2(n_cart_id); Line 1460: -- if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then 1456: end if; 1457: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' ' ); 1458: 1459: --add by alex 1460: -- if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CART_ID' then 1461: pk1 := icx_call.decrypt2(n_cart_id); 1462: -- 1463: -- end if; 1464: -- Line 1467: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1463: -- end if; 1464: -- 1465: 1466: --Bold 1467: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1468: htp.p(''); 1469: end if; 1470: --Italics 1471: if ak_query_pkg.g_items_table(i).bold = 'Y' then Line 1471: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1467: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1468: htp.p(''); 1469: end if; 1470: --Italics 1471: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1472: htp.p(''); 1473: end if; 1474: htp.p(' '); 1475: htp.p(' '); 1475: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1504: 1505: display_text := ' Line 1503: htp.p(' '); 1499: ) then 1500: 1501: 1502: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1504: 1505: display_text := ' 1507: Line 1505: display_text := ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1504: 1505: display_text := ' 1507: 1508: l_pos := l_pos + 1; 1509: Line 1506: || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"'; 1502: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1504: 1505: display_text := ' 1507: 1508: l_pos := l_pos + 1; 1509: 1510: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR Line 1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then 1509: 1510: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1511: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and 1512: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'N' or 1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then 1514: 1515: display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>'; 1516: htp.p(display_text || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1536: 1537: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1538: Line 1535: htp.p(' '); 1531: 1532: else 1533: 1534: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1536: 1537: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1538: 1539: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then Line 1537: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1533: 1534: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1536: 1537: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1538: 1539: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1540: htp.p(' '); 1541: --dc htp.p('else'); Line 1539: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1535: htp.p(' '); 1536: 1537: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1538: 1539: if y_table(ak_query_pkg.g_items_table(i).value_id) is NULL then 1540: htp.p(' '); 1541: --dc htp.p('else'); 1542: else 1543: htp.p(''); Line 1571: htp.p(''); 1573: 1574: l_pos := l_pos + 1; 1575: end if; Line 1572: || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '">'); 1568: 1569: else 1570: 1571: htp.p(''); 1573: 1574: l_pos := l_pos + 1; 1575: end if; 1576: Line 1578: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then 1574: l_pos := l_pos + 1; 1575: end if; 1576: 1577: 1578: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then 1579: 1580: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1582: ) and Line 1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1579: 1580: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1582: ) and 1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1586: 1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); Line 1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1580: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1582: ) and 1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1586: 1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1588: Line 1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG' 1582: ) and 1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and 1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and 1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1586: 1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1588: 1589: htp.p(' '); Line 1589: htp.p(' '); 1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then 1586: 1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1588: 1589: htp.p(' '); 1590: htp.p(''); 1590: htp.p(''); 1590: htp.p(''); 1590: htp.p(''); 1610: 1611: elsif ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1612: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and 1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and 1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1615: 1616: htp.p(''); Line 1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1610: 1611: elsif ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR 1612: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and 1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and 1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1615: 1616: htp.p(''); 1618: Line 1616: htp.p(' 1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and 1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1615: 1616: htp.p(''); 1618: 1619: l_pos := l_pos + 1; 1620: Line 1617: || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE="' || replace(l_requestor_name,'"','"') || '">'); 1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and 1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then 1615: 1616: htp.p(''); 1618: 1619: l_pos := l_pos + 1; 1620: 1621: Line 1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or 1619: l_pos := l_pos + 1; 1620: 1621: 1622: 1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or 1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1625: 1626: htp.p(' '); 1627: htp.p(''); 1627: htp.p(''); 1622: 1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or 1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1625: 1626: htp.p(' '); 1627: htp.p(''); 1627: htp.p(' '); Line 1547: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1543: htp.p(' '); 1544: end if; 1545: 1546: --Bold 1547: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1548: htp.p(''); 1549: end if; 1550: --Italics 1551: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1551: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1547: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1548: htp.p(''); 1549: end if; 1550: --Italics 1551: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1552: htp.p(''); 1553: end if; 1554: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' '); 1555: Line 1554: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' '); 1550: --Italics 1551: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1552: htp.p(''); 1553: end if; 1554: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' '); 1555: 1556: --Bold 1557: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1558: htp.p(''); Line 1557: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1553: end if; 1554: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id) || ' '); 1555: 1556: --Bold 1557: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1558: htp.p(''); 1559: end if; 1560: --Italics 1561: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1561: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1557: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1558: htp.p(''); 1559: end if; 1560: --Italics 1561: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1562: htp.p(''); 1563: end if; 1564: htp.p(' '); 1565: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1591: 1592: display_text := ' Line 1590: htp.p(' '); 1586: 1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID); 1588: 1589: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1591: 1592: display_text := ' 1594: Line 1592: display_text := ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1591: 1592: display_text := ' 1594: 1595: l_pos := l_pos + 1; 1596: Line 1593: || ' maxlength=' || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE="' || replace(l_requestor_name,'"','"') || '"'; 1589: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1591: 1592: display_text := ' 1594: 1595: l_pos := l_pos + 1; 1596: 1597: display_text := display_text || ' onBlur=''document.KEVIN.ICX_DELIVER_TO_REQUESTOR_ID.value="";''>'; Line 1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and 1609: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); Line 1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1620: 1621: 1622: 1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or 1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1625: 1626: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1628: Line 1626: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1628: 1629: 1630: Line 1627: htp.p(' '); 1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or 1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then 1625: 1626: htp.p(' ' || ak_query_pkg.g_items_table(i).attribute_label_long || ' '); 1628: 1629: 1630: 1631: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); Line 1631: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1627: htp.p(' '); 1628: 1629: 1630: 1631: --dc htp.p('if (parent.my_cart_header.' || ak_query_pkg.g_items_table(i).attribute_code || ' == "")'); 1632: 1633: if l_requestor_name is NULL then 1634: 1635: htp.p(''); Line 1662: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PO_BUTTON' then 1658: htp.p(''); 1659: 1660: end if; 1661: 1662: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PO_BUTTON' then 1663: /* 1664: htp.p('result += " ";'); 1665: 1666: htp.p('result += "";'); 1660: end if; 1661: 1662: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PO_BUTTON' then 1663: /* 1664: htp.p('result += " ";'); 1665: 1666: htp.p('result += "";'); 1665: 1666: htp.p('result += "";'); Line 1681: || ' VALUE=''' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_code) || ''' onClick=''get_po()''>";'); 1677: 1678: 1679: htp.p('result += " 1680: || ''' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length 1681: || ' VALUE=''' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_code) || ''' onClick=''get_po()''>";'); 1682: 1683: l_pos := l_pos + 1; 1684: htp.p('result += "";'); 1685: */ null; Line 1687: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or 1683: l_pos := l_pos + 1; 1684: htp.p('result += "";'); 1685: */ null; 1686: 1687: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1691: Line 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1684: htp.p('result += "";'); 1685: */ null; 1686: 1687: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1691: 1692: htp.p(''); Line 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1685: */ null; 1686: 1687: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1691: 1692: htp.p(''); 1693: Line 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1686: 1687: elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_ORG_ID' or 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1691: 1692: htp.p(''); 1693: 1694: l_pos := l_pos + 1; Line 1692: htp.p(''); 1688: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_ID' or 1689: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_LOC_CD') and 1690: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then 1691: 1692: htp.p(''); 1693: 1694: l_pos := l_pos + 1; 1695: 1696: Line 1703: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PAPER_CLIP') then 1699: end if; -- Object Attribute / Attribute 1700: 1701: end if; 1702: -- add by alex 1703: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PAPER_CLIP') then 1704: --l_pos := l_pos + 1; 1705: fnd_webattch.GetSummaryStatus('ICX_REQS', 'REQ_HEADERS', 1706: pk1, NULL, NULL, 1707: NULL, NULL, Line 1712: || ak_query_pkg.g_items_table(i).attribute_label_long || ''); 1708: attachment_status); 1709: 1710: 1711: htp.p(' '); 1713: 1714: if (attachment_status <> 'DISABLE' 1715: AND attachment_status = 'FULL') 1716: then Line 1722: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1718: || pk1 1719: || ''' ,'''', ''' 1720: ||v_dcdname 1721: ||''')" onMouseOver="window.status=''' 1722: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1723: ||''';return true"> 1724: || v_language 1725: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="' 1726: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) Line 1726: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1722: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1723: ||''';return true"> 1724: || v_language 1725: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="' 1726: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1727: ||'">' 1728: ,calign => 'LEFT'); 1729: elsif (attachment_status <> 'DISABLE') then 1730: htp.tableData(cvalue => ' 1737: || v_language 1738: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="' 1739: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) Line 1739: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1735: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1736: ||'''; return true"> 1737: || v_language 1738: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="' 1739: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1740: ||'">' 1741: , calign => 'LEFT'); 1742: end if; 1743: /* icx_util.DynamicButton(ak_query_pkg.g_items_table(i).attribute_label_long, Line 1743: /* icx_util.DynamicButton(ak_query_pkg.g_items_table(i).attribute_label_long, 1739: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) 1740: ||'">' 1741: , calign => 'LEFT'); 1742: end if; 1743: /* icx_util.DynamicButton(ak_query_pkg.g_items_table(i).attribute_label_long, 1744: 'FNDBPLAY', ak_query_pkg.g_items_table(i).attribute_label_long, 1745: 'javascript:attachment( 1, ''' || pk1 || ''', '''','''|| v_dcdName || ''')',v_language, false); */ 1746: htp.p(' '); 1747: htp.p(''); Line 1744: 'FNDBPLAY', ak_query_pkg.g_items_table(i).attribute_label_long, 1740: ||'">' 1741: , calign => 'LEFT'); 1742: end if; 1743: /* icx_util.DynamicButton(ak_query_pkg.g_items_table(i).attribute_label_long, 1744: 'FNDBPLAY', ak_query_pkg.g_items_table(i).attribute_label_long, 1745: 'javascript:attachment( 1, ''' || pk1 || ''', '''','''|| v_dcdName || ''')',v_language, false); */ 1746: htp.p(''); 1747: htp.p(' '); 1748: Line 2051: where_clause_binds ak_query_pkg.bind_tab; 2047: v_req_overwrite_flag varchar2(1); 2048: l_col number; 2049: l_shopper_id number; 2050: /* Change wrto Bug Fix to implement the Bind Vars **/ 2051: where_clause_binds ak_query_pkg.bind_tab; 2052: v_index NUMBER; 2053: 2054: begin 2055: Line 2070: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2066: where_clause_binds(v_index).value := v_cart_id; 2067: v_index := v_index + 1; 2068: 2069: 2070: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2071: P_PARENT_REGION_CODE => v_lines_region, 2072: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID), 2073: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID), 2074: P_WHERE_CLAUSE => v_where_clause, Line 2092: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 2088: 2089: v_req_overwrite_flag := icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG); 2090: ICX_REQ_NAVIGATION.chk_vendor_on(v_vendor_on_flag); 2091: 2092: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 2093: 2094: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and 2095: v_vendor_on_flag = 'Y') then 2096: Line 2094: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and 2090: ICX_REQ_NAVIGATION.chk_vendor_on(v_vendor_on_flag); 2091: 2092: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 2093: 2094: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' and 2095: v_vendor_on_flag = 'Y') then 2096: 2097: -- for LOV use 2098: htp.p(''); Line 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2104: end if; 2105: 2106: 2107: /* determine if LOV is user configurable */ 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and Line 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2105: 2106: 2107: /* determine if LOV is user configurable */ 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and Line 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2106: 2107: /* determine if LOV is user configurable */ 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and Line 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2107: /* determine if LOV is user configurable */ 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and Line 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2108: if ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then Line 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2109: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: Line 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2110: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_NAME' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then Line 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2111: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' and 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then 2119: l_shopper_id := icx_call.encrypt2(to_char(shopper_id)); Line 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2112: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_SITE' and 2113: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' and 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then 2119: l_shopper_id := icx_call.encrypt2(to_char(shopper_id)); 2120: htp.p(''); Line 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then 2114: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_L' and 2115: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DELIVER_TO_LOCATION_ID_L' and 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then 2119: l_shopper_id := icx_call.encrypt2(to_char(shopper_id)); 2120: htp.p(''); 2121: else 2122: Line 2120: htp.p(''); 2116: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then 2117: 2118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SHOPPER_ID' then 2119: l_shopper_id := icx_call.encrypt2(to_char(shopper_id)); 2120: htp.p(''); 2121: else 2122: 2123: htp.p(''); 2124: end if; Line 2123: htp.p(''); 2119: l_shopper_id := icx_call.encrypt2(to_char(shopper_id)); 2120: htp.p(''); 2121: else 2122: 2123: htp.p(''); 2124: end if; 2125: 2126: l_pos := l_pos + 1; 2127: Line 2196: v_regions_table ak_query_pkg.regions_table_type; 2192: n_cart_id number default NULL, 2193: v_po_number varchar2 default NULL) is 2194: ------------------------------------------------------------ 2195: 2196: v_regions_table ak_query_pkg.regions_table_type; 2197: v_items_table ak_query_pkg.items_table_type; 2198: v_results_table ak_query_pkg.results_table_type; 2199: 2200: v_emergency varchar2(10); Line 2197: v_items_table ak_query_pkg.items_table_type; 2193: v_po_number varchar2 default NULL) is 2194: ------------------------------------------------------------ 2195: 2196: v_regions_table ak_query_pkg.regions_table_type; 2197: v_items_table ak_query_pkg.items_table_type; 2198: v_results_table ak_query_pkg.results_table_type; 2199: 2200: v_emergency varchar2(10); 2201: v_org number; Line 2198: v_results_table ak_query_pkg.results_table_type; 2194: ------------------------------------------------------------ 2195: 2196: v_regions_table ak_query_pkg.regions_table_type; 2197: v_items_table ak_query_pkg.items_table_type; 2198: v_results_table ak_query_pkg.results_table_type; 2199: 2200: v_emergency varchar2(10); 2201: v_org number; 2202: v_cart_id number; Line 2219: where_clause_binds ak_query_pkg.bind_tab; 2215: l_total_price_column number := 0; 2216: l_pos number; 2217: 2218: /* Change wrto Bug Fix to implement the Bind Vars **/ 2219: where_clause_binds ak_query_pkg.bind_tab; 2220: where_clause_binds_empty ak_query_pkg.bind_tab; 2221: v_index NUMBER; 2222: begin 2223: Line 2220: where_clause_binds_empty ak_query_pkg.bind_tab; 2216: l_pos number; 2217: 2218: /* Change wrto Bug Fix to implement the Bind Vars **/ 2219: where_clause_binds ak_query_pkg.bind_tab; 2220: where_clause_binds_empty ak_query_pkg.bind_tab; 2221: v_index NUMBER; 2222: begin 2223: 2224: Line 2281: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2277: v_lines_region := 'ICX_SHOPPING_CART_LINES_R'; 2278: end if; 2279: 2280: -- Cart Lines Related Object Navigator 2281: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2282: P_PARENT_REGION_CODE => v_lines_region, 2283: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID), 2284: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID), 2285: P_RETURN_PARENTS => 'F', Line 2362: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2358: --insert into debug_timings values (1004, l_session_id, 2359: -- to_char(sysdate, 'HH24:MI:SS'), 'AK query header started.'); 2360: --debug 2361: 2362: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2363: P_PARENT_REGION_CODE => v_header_region, 2364: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID), 2365: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID), 2366: P_WHERE_CLAUSE => v_where_clause, Line 2398: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2394: --insert into debug_timings values (1008, l_session_id, 2395: -- to_char(sysdate, 'HH24:MI:SS'), 'AK query lines started.'); 2396: --debug 2397: 2398: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601, 2399: P_PARENT_REGION_CODE => v_lines_region, 2400: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID), 2401: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID), 2402: P_WHERE_CLAUSE => v_where_clause, Line 2413: if ak_query_pkg.g_results_table.COUNT = 0 then 2409: -- to_char(sysdate, 'HH24:MI:SS'), 'AK query line end.'); 2410: --debug 2411: 2412: 2413: if ak_query_pkg.g_results_table.COUNT = 0 then 2414: 2415: js.scriptOpen; 2416: htp.p('resetItemCount(document.LINE.itemCount)'); 2417: js.scriptClose; '); Line 1641: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1637: else 1638: htp.p(' '); 1639: end if; 1640: --Bold 1641: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1642: htp.p(''); 1643: end if; 1644: --Italics 1645: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1645: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1641: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1642: htp.p(''); 1643: end if; 1644: --Italics 1645: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1646: htp.p(''); 1647: end if; 1648: htp.p(l_requestor_name || ' ' ); 1649: --Bold Line 1650: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1646: htp.p(''); 1647: end if; 1648: htp.p(l_requestor_name || ' ' ); 1649: --Bold 1650: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1651: htp.p(''); 1652: end if; 1653: --Italics 1654: if ak_query_pkg.g_items_table(i).italic = 'Y' then Line 1654: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1650: if ak_query_pkg.g_items_table(i).bold = 'Y' then 1651: htp.p(''); 1652: end if; 1653: --Italics 1654: if ak_query_pkg.g_items_table(i).italic = 'Y' then 1655: htp.p(''); 1656: end if; 1657: htp.p(' '); 1658: htp.p(' ' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) || ' ";'); Line 1664: htp.p('result += " ' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) || ' ' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) || ' ";'); 1667: 1668: Line 1666: htp.p('result += " ";'); 1662: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PO_BUTTON' then 1663: /* 1664: htp.p('result += " ' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_label_long) || ' ";'); 1667: 1668: 1669: --dbutton := icx_util.DynamicButton(P_ButtonText => 'Get a PO Number', 1670: -- P_ImageFileName => 'FNDBNEW.gif', Line 1679: htp.p('result += " 1675: --dbutton := replace( dbutton, '"', '\"' ); 1676: --htp.p('result += "' || dbutton || '";'); 1677: 1678: 1679: htp.p('result += " 1680: || ''' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length 1681: || ' VALUE=''' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_code) || ''' onClick=''get_po()''>";'); 1682: 1683: l_pos := l_pos + 1; Line 1680: || ''' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length 1676: --htp.p('result += "' || dbutton || '";'); 1677: 1678: 1679: htp.p('result += " 1680: || ''' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length 1681: || ' VALUE=''' || icx_util.replace_quotes(ak_query_pkg.g_items_table(i).attribute_code) || ''' onClick=''get_po()''>";'); 1682: 1683: l_pos := l_pos + 1; 1684: htp.p('result += " ' 1712: || ak_query_pkg.g_items_table(i).attribute_label_long || '