eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTR_VALUES_INTERFACE

Line 223: FROM pon_bid_attr_values_interface bai

219: -- No attributes
220: AND (al.has_attributes_flag = 'N'
221: OR NOT EXISTS -- no attributes
222: (SELECT bai.attribute_name
223: FROM pon_bid_attr_values_interface bai
224: WHERE bai.batch_id = bli.batch_id
225: AND bai.interface_line_id = bli.interface_line_id
226: AND bai.value IS NOT null))));
227:

Line 341: DELETE FROM pon_bid_attr_values_interface bai

337: -- from the interface tables, along with their children
338: -- flag 'N' indicates that only erroneous records are to be purged
339:
340: -- Delete from attributes interface table
341: DELETE FROM pon_bid_attr_values_interface bai
342: WHERE bai.batch_id = p_batch_id
343: AND bai.interface_line_id in (
344: select bli.interface_line_id
345: from pon_bid_item_prices_interface bli

Line 382: UPDATE pon_bid_attr_values_interface bai

378:
379: -- Update attributes' internal line numbers's
380: -- NOTE: we also update line_number for those attributes with
381: -- valid line_numbers
382: UPDATE pon_bid_attr_values_interface bai
383: SET bai.line_number =
384: (SELECT bli.line_number
385: FROM pon_bid_item_prices_interface bli
386: WHERE bli.batch_id = bai.batch_id

Line 427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

423: p_suffix IN VARCHAR2,
424: p_batch_id IN pon_interface_errors.batch_id%TYPE,
425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;

424: p_batch_id IN pon_interface_errors.batch_id%TYPE,
425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
432: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

Line 429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;

425: p_request_id IN pon_interface_errors.request_id%TYPE
426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
432: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
433:

Line 430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;

426: ) IS
427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
432: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
433:
434: l_int_lines intLineTab;

Line 431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;

427: TYPE intLineTab IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
428: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
429: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
430: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
431: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
432: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
433:
434: l_int_lines intLineTab;
435: l_line_numbers lineNumberTab;

Line 476: FROM pon_bid_attr_values_interface bai,

472: l_attr_names,
473: l_datatypes,
474: l_values,
475: l_disp_line_numbers
476: FROM pon_bid_attr_values_interface bai,
477: pon_auction_item_prices_all al
478: WHERE bai.batch_id = p_batch_id
479: AND al.auction_header_id = bai.auction_header_id
480: AND al.line_number = bai.line_number;

Line 484: UPDATE pon_bid_attr_values_interface bai

480: AND al.line_number = bai.line_number;
481:
482: -- Mark every attribute as invalid
483: -- The following statement will re-validate each attribute
484: UPDATE pon_bid_attr_values_interface bai
485: SET bai.line_number = g_error_int
486: WHERE bai.batch_id = p_batch_id;
487:
488: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');

Line 506: UPDATE pon_bid_attr_values_interface bai

502: END if;
503:
504: -- Attempt the datatype conversions
505: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
506: UPDATE pon_bid_attr_values_interface bai
507: SET bai.value = decode(l_datatypes(i),
508: 'TXT', l_values(i),
509: 'NUM', to_char(decode (l_has_profile_value_numeric, 'Y', to_number(replace(l_values(i), l_grouping_separator_character),
510: 'FM9999999999999999999999999999999999999999999999D9999999999999999',

Line 653: UPDATE pon_bid_attr_values_interface bai

649:
650: -- Determine if there are any invalid attributes.
651: -- line_number is assigned a sentinel indicating an error
652: -- instead of attribute_name since attribute_name is a string.
653: UPDATE pon_bid_attr_values_interface bai
654: SET bai.line_number =
655: nvl((SELECT ba.line_number
656: FROM pon_bid_attribute_values ba
657: WHERE ba.bid_number = bai.bid_number

Line 677: DELETE FROM pon_bid_attr_values_interface bai

673:
674: WHERE bai.batch_id = p_batch_id;
675:
676: --bug 5166407: ignore the display only attributes
677: DELETE FROM pon_bid_attr_values_interface bai
678: WHERE bai.batch_id = p_batch_id
679: AND (bai.bid_number, bai.line_number, bai.sequence_number) in
680: (
681: select bh.bid_number, bh.line_number, aa.sequence_number

Line 728: FROM pon_bid_attr_values_interface bai

724: bai.auction_header_id,
725: bai.bid_number,
726: bai.line_number,
727: g_exp_date
728: FROM pon_bid_attr_values_interface bai
729: WHERE bai.batch_id = p_batch_id
730: AND bai.line_number = g_error_int);
731:
732: -- Remove all invalid attributes before validating datatypes

Line 735: DELETE FROM pon_bid_attr_values_interface bai

731:
732: -- Remove all invalid attributes before validating datatypes
733:
734: -- Delete from attributes interface table
735: DELETE FROM pon_bid_attr_values_interface bai
736: WHERE bai.batch_id = p_batch_id
737: AND bai.line_number = g_error_int;
738:
739: -- Validate attributes' datatypes

Line 749: DELETE FROM pon_bid_attr_values_interface bai

745: p_batch_id,
746: p_request_id);
747:
748: -- Delete from attributes interface table
749: DELETE FROM pon_bid_attr_values_interface bai
750: WHERE bai.batch_id = p_batch_id
751: AND bai.line_number = g_error_int;
752:
753: -- 2. PRICE ELEMENTS/COST FACTORS

Line 1253: FROM pon_bid_attr_values_interface

1249: sequence_number,
1250: value,
1251: worksheet_name,
1252: worksheet_sequence_number
1253: FROM pon_bid_attr_values_interface
1254: WHERE auction_header_id = p_auction_header_id
1255: AND bid_number = p_bid_number
1256: AND batch_id = p_batch_id) bai
1257: ON (ba.auction_header_id = bai.auction_header_id

Line 1502: DELETE FROM pon_bid_attr_values_interface bai

1498: -- Remove all records for the current batch from the interface table
1499: DELETE FROM pon_bid_item_prices_interface bli
1500: WHERE bli.batch_id = p_batch_id;
1501:
1502: DELETE FROM pon_bid_attr_values_interface bai
1503: WHERE bai.batch_id = p_batch_id;
1504:
1505: DELETE FROM pon_bid_price_elements_int bpfi
1506: WHERE bpfi.batch_id = p_batch_id;

Line 2394: FROM pon_bid_attr_values_interface bai

2390: -- No attributes
2391: AND (al.has_attributes_flag = 'N'
2392: OR NOT EXISTS -- no attributes
2393: (SELECT bai.attribute_name
2394: FROM pon_bid_attr_values_interface bai
2395: WHERE bai.batch_id = bli.batch_id
2396: AND bai.line_number = bli.line_number
2397: AND bai.value IS NOT null))
2398: -- No payments

Line 2437: DELETE FROM pon_bid_attr_values_interface bai

2433: -- determine_xml_closed_lines(p_auc_header_id, p_batch_id, p_request_id, p_userid, p_suffix);
2434: -- end if;
2435:
2436: -- delete bid attribute values from interface tables
2437: DELETE FROM pon_bid_attr_values_interface bai
2438: WHERE bai.batch_id = p_batch_id
2439: AND bai.line_number in (
2440: select bli.line_number
2441: from pon_bid_item_prices_interface bli

Line 2503: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

2499: p_request_id IN pon_interface_errors.request_id%TYPE
2500: ) IS
2501: -- Define table definitions
2502: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2503: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2504: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2505: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2506: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2507: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 2507: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

2503: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2504: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2505: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2506: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2507: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2508: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2509: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2510:
2511: -- Local table variables

Line 2508: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

2504: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2505: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2506: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2507: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2508: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2509: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2510:
2511: -- Local table variables
2512: l_line_numbers lineNumberTable;

Line 2509: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

2505: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2506: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2507: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2508: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2509: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2510:
2511: -- Local table variables
2512: l_line_numbers lineNumberTable;
2513: l_int_lines intLineTable;

Line 2575: pon_bid_attr_values_interface pbai,

2571: l_values,
2572: l_worksheet_names,
2573: l_worksheet_seq_numbers
2574: FROM
2575: pon_bid_attr_values_interface pbai,
2576: pon_auction_attributes paa
2577: WHERE
2578: pbai.auction_header_id = p_auction_header_id
2579: AND pbai.bid_number = p_bid_number

Line 2588: UPDATE pon_bid_attr_values_interface pbai

2584: AND pbai.sequence_number = paa.sequence_number;
2585:
2586: -- Attempt the datatype conversions
2587: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
2588: UPDATE pon_bid_attr_values_interface pbai
2589: SET pbai.value = decode(l_datatypes(i),
2590: 'TXT', l_values(i),
2591: 'NUM', to_char(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,'''),
2592: decode(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''') - floor(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''')),

Line 2667: pon_bid_attr_values_interface pbai

2663: l_worksheet_seq_numbers(l_index),
2664: 'PON_AUC_REQUIREMENTS');
2665:
2666: UPDATE
2667: pon_bid_attr_values_interface pbai
2668: SET
2669: pbai.value = null
2670: WHERE
2671: pbai.auction_header_id = p_auction_header_id

Line 2695: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;

2691: ) IS
2692: -- Define table definitions
2693: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2694: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2695: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2696: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2697: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2698: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2699: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

Line 2699: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;

2695: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2696: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2697: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2698: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2699: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2700: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2701: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2702:
2703: -- Local table variables

Line 2700: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

2696: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2697: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2698: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2699: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2700: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2701: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2702:
2703: -- Local table variables
2704: l_disp_line_numbers docDispLineNumTable;

Line 2701: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

2697: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2698: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2699: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2700: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2701: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2702:
2703: -- Local table variables
2704: l_disp_line_numbers docDispLineNumTable;
2705: l_line_numbers lineNumberTable;

Line 2771: pon_bid_attr_values_interface pbai,

2767: l_values,
2768: l_worksheet_names,
2769: l_worksheet_seq_numbers
2770: FROM
2771: pon_bid_attr_values_interface pbai,
2772: pon_auction_attributes paa,
2773: pon_auction_item_prices_all paip
2774: WHERE
2775: pbai.auction_header_id = p_auction_header_id

Line 2787: UPDATE pon_bid_attr_values_interface pbai

2783: AND paa.line_number = paip.line_number;
2784:
2785: -- Attempt the datatype conversions
2786: FORALL i IN l_int_lines.FIRST..l_int_lines.LAST SAVE EXCEPTIONS
2787: UPDATE pon_bid_attr_values_interface pbai
2788: SET pbai.value = decode(l_datatypes(i),
2789: 'TXT', l_values(i),
2790: 'NUM', to_char(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,'''),
2791: decode(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''') - floor(to_number(l_values(i), g_xml_number_mask, 'NLS_NUMERIC_CHARACTERS=''.,''')),

Line 2874: pon_bid_attr_values_interface pbai

2870: l_worksheet_seq_numbers(l_index),
2871: 'PON_AUC_ATTRIBUTES');
2872:
2873: UPDATE
2874: pon_bid_attr_values_interface pbai
2875: SET
2876: pbai.value = null
2877: WHERE
2878: pbai.auction_header_id = p_auction_header_id