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 277: FROM pon_auction_item_prices_all al

273: -- set to g_error_int to indicate this
274: UPDATE pon_bid_item_prices_interface bli
275: SET bli.line_number =
276: nvl((SELECT al.line_number
277: FROM pon_auction_item_prices_all al
278: WHERE al.auction_header_id = bli.auction_header_id
279: --AND al.document_disp_line_number = bli.document_disp_line_number),
280: AND Decode(Nvl(l_is_fed,'N'),'N',al.document_disp_line_number,al.line_num_display) = bli.document_disp_line_number),
281: g_error_int)

Line 432: TYPE docLineNumTab IS TABLE of pon_auction_item_prices_all.document_disp_line_number%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;
436: l_attr_names attrNameTab;

Line 477: pon_auction_item_prices_all al

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

Line 896: pon_auction_item_prices_all al

892: SET bpdi.sequence_number =
893: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
894: g_skip_int, bpd.price_differential_number)
895: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,
896: pon_auction_item_prices_all al
897: WHERE pdl.price_differential_dsp = bpdi.price_type
898: AND bpd.bid_number = bpdi.bid_number
899: AND bpd.line_number = bpdi.auction_line_number
900: AND bpd.price_type = pdl.price_differential_type

Line 1091: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

1087: al.quantity_disabled_flag,
1088: al.price_disabled_flag,
1089: al.group_type,
1090: al.order_type_lookup_code
1091: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1092: WHERE bl.bid_number = p_bid_number
1093: AND al.auction_header_id = bl.auction_header_id
1094: AND al.line_number = bl.line_number) lines
1095: ON (bli.bid_number = lines.bid_number

Line 1228: FROM pon_auction_item_prices_all al

1224: UPDATE pon_bid_item_prices bl
1225: SET batch_id = p_batch_id
1226: WHERE bl.bid_number = p_bid_number
1227: AND (SELECT al.group_type
1228: FROM pon_auction_item_prices_all al
1229: WHERE al.auction_header_id = bl.auction_header_id
1230: AND al.line_number = bl.line_number) = 'GROUP'
1231: AND EXISTS
1232: (SELECT bl2.line_number

Line 1233: FROM pon_bid_item_prices bl2, pon_auction_item_prices_all al2

1229: WHERE al.auction_header_id = bl.auction_header_id
1230: AND al.line_number = bl.line_number) = 'GROUP'
1231: AND EXISTS
1232: (SELECT bl2.line_number
1233: FROM pon_bid_item_prices bl2, pon_auction_item_prices_all al2
1234: WHERE bl2.bid_number = p_bid_number
1235: AND al2.auction_header_id = bl2.auction_header_id
1236: AND al2.line_number = bl2.line_number
1237: AND al2.parent_line_number = bl.line_number

Line 1278: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

1274: -- Update promised_date
1275: UPDATE pon_bid_attribute_values ba
1276: SET value =
1277: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')
1278: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1279: WHERE bl.bid_number = ba.bid_number
1280: AND bl.line_number = ba.line_number
1281: AND al.auction_header_id = bl.auction_header_id
1282: AND al.line_number = bl.line_number

Line 1291: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

1287: -- Update quantity
1288: UPDATE pon_bid_attribute_values ba
1289: SET value =
1290: nvl((SELECT to_char(bl.quantity)
1291: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1292: WHERE bl.bid_number = ba.bid_number
1293: AND bl.line_number = ba.line_number
1294: AND al.auction_header_id = bl.auction_header_id
1295: AND al.line_number = bl.line_number

Line 1532: pon_auction_item_prices_all paip

1528: SELECT bli.attachment_url,
1529: bli.attachment_desc,
1530: bli.line_number
1531: FROM pon_bid_item_prices_interface bli,
1532: pon_auction_item_prices_all paip
1533: WHERE bli.batch_id = p_batch_id
1534: AND bli.attachment_desc IS NOT null
1535: AND bli.attachment_url IS NOT null
1536: AND bli.auction_header_id = paip.auction_header_id

Line 2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,

2192: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2193: p_request_id IN pon_bid_headers.request_id%TYPE,
2194: p_user_id IN pon_bid_item_prices.last_updated_by%TYPE,
2195: p_suffix IN VARCHAR2,
2196: p_has_pe IN pon_auction_item_prices_all.HAS_PRICE_ELEMENTS_FLAG%TYPE,
2197: l_attr_enabled_flag IN pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
2198: l_req_enabled_flag IN pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
2199: l_has_hdr_attr_flag IN pon_auction_headers_all.has_hdr_attr_flag%TYPE,
2200: p_progress_payment_type IN pon_auction_headers_all.progress_payment_type%TYPE,

Line 2326: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl

2322: SET bli.interface_line_id = g_skip_int
2323: WHERE bli.batch_id = p_batch_id
2324: AND EXISTS
2325: (SELECT 'Y'
2326: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl
2327: WHERE bl.bid_number = bli.bid_number
2328: AND bl.line_number = bli.line_number
2329: AND al.auction_header_id = bl.auction_header_id
2330: AND al.line_number = bl.line_number

Line 2478: pon_auction_item_prices_all pai

2474: WHERE pbpi.batch_id = p_batch_id
2475: AND pbpi.document_disp_line_number in (
2476: select pai.document_disp_line_number
2477: from pon_bid_item_prices_interface bli,
2478: pon_auction_item_prices_all pai
2479: where bli.batch_id = p_batch_id
2480: AND bli.interface_line_id = g_skip_int
2481: AND pai.auction_header_id = bli.auction_header_id
2482: AND pai.line_number = bli.line_number);

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

2498: p_batch_id IN pon_interface_errors.batch_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;

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

2689: p_batch_id IN pon_interface_errors.batch_id%TYPE,
2690: p_request_id IN pon_interface_errors.request_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;

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

2690: p_request_id IN pon_interface_errors.request_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;

Line 2773: pon_auction_item_prices_all paip

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