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 605: from pon_auction_attributes aa

601: WHERE bai.batch_id = p_batch_id
602: AND (bai.bid_number, bai.line_number, bai.sequence_number) in
603: (
604: select bh.bid_number, bh.line_number, aa.sequence_number
605: from pon_auction_attributes aa
606: , pon_bid_item_prices bh
607: where bh.bid_number = bai.bid_number
608: and bh.line_number = bai.line_number
609: and aa.auction_header_id = bh.auction_header_id

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

2287: ) IS
2288: -- Define table definitions
2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

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

2288: -- Define table definitions
2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

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

2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2290: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2291: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2292: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2293: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2294: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2295: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2296: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2297:

Line 2363: pon_auction_attributes paa

2359: l_worksheet_names,
2360: l_worksheet_seq_numbers
2361: FROM
2362: pon_bid_attr_values_interface pbai,
2363: pon_auction_attributes paa
2364: WHERE
2365: pbai.auction_header_id = p_auction_header_id
2366: AND pbai.bid_number = p_bid_number
2367: AND pbai.batch_id = p_batch_id

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

2479: -- Define table definitions
2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;

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

2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;

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

2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;
2482: TYPE intLineTable IS TABLE of pon_bid_attr_values_interface.interface_line_id%TYPE;
2483: TYPE attrNameTable IS TABLE of pon_auction_attributes.attribute_name%TYPE;
2484: TYPE seqNumTable IS TABLE of pon_auction_attributes.sequence_number%TYPE;
2485: TYPE datatypeTable IS TABLE of pon_auction_attributes.datatype%TYPE;
2486: TYPE valueTable IS TABLE of pon_bid_attr_values_interface.value%TYPE;
2487: TYPE worksheetTable IS TABLE of pon_bid_attr_values_interface.worksheet_name%TYPE;
2488: TYPE worksheetSeqNumTable IS TABLE of pon_bid_attr_values_interface.worksheet_sequence_number%TYPE;
2489:

Line 2559: pon_auction_attributes paa,

2555: l_worksheet_names,
2556: l_worksheet_seq_numbers
2557: FROM
2558: pon_bid_attr_values_interface pbai,
2559: pon_auction_attributes paa,
2560: pon_auction_item_prices_all paip
2561: WHERE
2562: pbai.auction_header_id = p_auction_header_id
2563: AND pbai.bid_number = p_bid_number