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_ITEM_PRICES_ALL

Line 112: FROM pon_auction_item_prices_all al

108: AND bli.line_number <> g_skip_int
109: AND sysdate >
110: (SELECT decode(l_is_paused, 'N', al.close_bidding_date,
111: al.close_bidding_date + (sysdate - l_paused_date))
112: FROM pon_auction_item_prices_all al
113: WHERE al.auction_header_id = bli.auction_header_id
114: AND al.line_number = bli.line_number);
115:
116: -- Report errors for all closed lines

Line 173: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl

169: SET bli.line_number = g_skip_int
170: WHERE bli.batch_id = p_batch_id
171: AND EXISTS
172: (SELECT 'Y'
173: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl
174: WHERE bl.bid_number = bli.bid_number
175: AND bl.line_number = bli.line_number
176: AND al.auction_header_id = bl.auction_header_id
177: AND al.line_number = bl.line_number

Line 251: FROM pon_auction_item_prices_all al

247: -- set to g_error_int to indicate this
248: UPDATE pon_bid_item_prices_interface bli
249: SET bli.line_number =
250: nvl((SELECT al.line_number
251: FROM pon_auction_item_prices_all al
252: WHERE al.auction_header_id = bli.auction_header_id
253: AND al.document_disp_line_number = bli.document_disp_line_number),
254: g_error_int)
255: WHERE bli.batch_id = p_batch_id;

Line 405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

401: TYPE lineNumberTab IS TABLE of pon_bid_attr_values_interface.line_number%TYPE;
402: TYPE attrNameTab IS TABLE of pon_bid_attr_values_interface.attribute_name%TYPE;
403: TYPE datatypeTab IS TABLE of pon_bid_attr_values_interface.datatype%TYPE;
404: TYPE valueTab IS TABLE of pon_bid_attr_values_interface.value%TYPE;
405: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;
406:
407: l_int_lines intLineTab;
408: l_line_numbers lineNumberTab;
409: l_attr_names attrNameTab;

Line 439: pon_auction_item_prices_all al

435: l_datatypes,
436: l_values,
437: l_disp_line_numbers
438: FROM pon_bid_attr_values_interface bai,
439: pon_auction_item_prices_all al
440: WHERE bai.batch_id = p_batch_id
441: AND al.auction_header_id = bai.auction_header_id
442: AND al.line_number = bai.line_number;
443:

Line 819: pon_auction_item_prices_all al

815: SET bpdi.sequence_number =
816: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
817: g_skip_int, bpd.price_differential_number)
818: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,
819: pon_auction_item_prices_all al
820: WHERE pdl.price_differential_dsp = bpdi.price_type
821: AND bpd.bid_number = bpdi.bid_number
822: AND bpd.line_number = bpdi.auction_line_number
823: AND bpd.price_type = pdl.price_differential_type

Line 908: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

904: al.quantity_disabled_flag,
905: al.price_disabled_flag,
906: al.group_type,
907: al.order_type_lookup_code
908: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
909: WHERE bl.bid_number = p_bid_number
910: AND al.auction_header_id = bl.auction_header_id
911: AND al.line_number = bl.line_number) lines
912: ON (bli.bid_number = lines.bid_number

Line 1029: FROM pon_auction_item_prices_all al

1025: UPDATE pon_bid_item_prices bl
1026: SET batch_id = p_batch_id
1027: WHERE bl.bid_number = p_bid_number
1028: AND (SELECT al.group_type
1029: FROM pon_auction_item_prices_all al
1030: WHERE al.auction_header_id = bl.auction_header_id
1031: AND al.line_number = bl.line_number) = 'GROUP'
1032: AND EXISTS
1033: (SELECT bl2.line_number

Line 1034: FROM pon_bid_item_prices bl2, pon_auction_item_prices_all al2

1030: WHERE al.auction_header_id = bl.auction_header_id
1031: AND al.line_number = bl.line_number) = 'GROUP'
1032: AND EXISTS
1033: (SELECT bl2.line_number
1034: FROM pon_bid_item_prices bl2, pon_auction_item_prices_all al2
1035: WHERE bl2.bid_number = p_bid_number
1036: AND al2.auction_header_id = bl2.auction_header_id
1037: AND al2.line_number = bl2.line_number
1038: AND al2.parent_line_number = bl.line_number

Line 1079: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

1075: -- Update promised_date
1076: UPDATE pon_bid_attribute_values ba
1077: SET value =
1078: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')
1079: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1080: WHERE bl.bid_number = ba.bid_number
1081: AND bl.line_number = ba.line_number
1082: AND al.auction_header_id = bl.auction_header_id
1083: AND al.line_number = bl.line_number

Line 1092: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

1088: -- Update quantity
1089: UPDATE pon_bid_attribute_values ba
1090: SET value =
1091: nvl((SELECT to_char(bl.quantity)
1092: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1093: WHERE bl.bid_number = ba.bid_number
1094: AND bl.line_number = ba.line_number
1095: AND al.auction_header_id = bl.auction_header_id
1096: AND al.line_number = bl.line_number

Line 1983: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,

1979: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1980: p_request_id IN pon_bid_headers.request_id%TYPE,
1981: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
1982: p_suffix IN VARCHAR2,
1983: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
1984: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
1985: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
1986: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
1987: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,

Line 2113: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl

2109: SET bli.interface_line_id = g_skip_int
2110: WHERE bli.batch_id = p_batch_id
2111: AND EXISTS
2112: (SELECT 'Y'
2113: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl
2114: WHERE bl.bid_number = bli.bid_number
2115: AND bl.line_number = bli.line_number
2116: AND al.auction_header_id = bl.auction_header_id
2117: AND al.line_number = bl.line_number

Line 2265: pon_auction_item_prices_all pai

2261: WHERE pbpi.batch_id = p_batch_id
2262: AND pbpi.document_disp_line_number in (
2263: select pai.document_disp_line_number
2264: from pon_bid_item_prices_interface bli,
2265: pon_auction_item_prices_all pai
2266: where bli.batch_id = p_batch_id
2267: AND bli.interface_line_id = g_skip_int
2268: AND pai.auction_header_id = bli.auction_header_id
2269: AND pai.line_number = bli.line_number);

Line 2289: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

2285: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2286: p_request_id IN pon_interface_errors.request_id%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;

Line 2480: TYPE docDispLineNumTable IS TABLE of pon_auction_item_prices_all.document_disp_line_number%TYPE;

2476: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2477: p_request_id IN pon_interface_errors.request_id%TYPE
2478: ) IS
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;

Line 2481: TYPE lineNumberTable IS TABLE of pon_auction_item_prices_all.line_number%TYPE;

2477: p_request_id IN pon_interface_errors.request_id%TYPE
2478: ) IS
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;

Line 2560: pon_auction_item_prices_all paip

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