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_AUCTION_ATTRIBUTES

Line 682: from pon_auction_attributes aa

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
682: from pon_auction_attributes aa
683: , pon_bid_item_prices bh
684: where bh.bid_number = bai.bid_number
685: and bh.line_number = bai.line_number
686: and aa.auction_header_id = bh.auction_header_id

Line 2504: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%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;
2508: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

Line 2505: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;

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;
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;

Line 2506: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;

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;
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:

Line 2576: pon_auction_attributes paa

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
2580: AND pbai.batch_id = p_batch_id

Line 2696: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;

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;
2700: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

Line 2697: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;

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;
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;

Line 2698: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%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;
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:

Line 2772: pon_auction_attributes paa,

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
2776: AND pbai.bid_number = p_bid_number