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_BID_VALIDATIONS_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 238: FROM pon_bid_payments_shipments bps

234: OR EXISTS
235:
236: -- Check payments for xml spreadsheet upload case
237: (SELECT bps.bid_line_number
238: FROM pon_bid_payments_shipments bps
239: WHERE p_spreadsheet = g_xml_upload_mode
240: AND bps.bid_number = bl.bid_number
241: AND bps.bid_line_number = bl.line_number
242: AND (NVL(bps.payment_display_number, g_null_int) <> NVL(old_payment_display_number, g_null_int)

Line 259: from pon_bid_payments_shipments bps

255: AND rownum = 1)
256:
257: -- Check if any payments were deleted
258: OR (nvl(bl.old_no_of_payments,0) <> (select count(payment_display_number)
259: from pon_bid_payments_shipments bps
260: where bps.bid_number = bl.bid_number
261: and bps.bid_line_number = bl.line_number))
262:
263: OR ( (bl.has_shipments_flag = 'Y' or bl.has_quantity_tiers = 'Y')

Line 3505: FROM PON_BID_PAYMENTS_SHIPMENTS p_bps

3501: (p_spreadsheet = g_online_mode OR p_spreadsheet = g_xml_upload_mode) AND progress_payment_type = 'FINANCE' AND
3502: recoupment_rate_percent IS NOT NULL AND progress_pymt_rate_percent IS NOT NULL AND
3503: s_bid_currency_unit_price IS NOT NULL AND
3504: recoupment_rate_percent < (((((progress_pymt_rate_percent/100) * (SELECT nvl(sum(nvl(bid_currency_price,0)*nvl(quantity,nvl(s_bid_quantity,1))),0)
3505: FROM PON_BID_PAYMENTS_SHIPMENTS p_bps
3506: WHERE p_bps.auction_header_id=p_auc_header_id
3507: AND p_bps.bid_line_number=s_line_number
3508: AND p_bps.bid_number=p_bid_number))
3509: + nvl(bid_curr_advance_amount,0)) * 100)/((nvl(s_bid_quantity, 1) * s_bid_currency_unit_price))) THEN

Line 3602: FROM pon_bid_payments_shipments

3598: has_bid_payments_flag = 'Y' AND
3599: s_group_type NOT IN ('GROUP','LOT_LINE') AND
3600: s_bid_currency_unit_price IS NOT NULL AND
3601: (nvl(s_bid_quantity,1)* s_bid_currency_unit_price)- nvl(bid_curr_advance_amount,0) < (SELECT nvl(sum(nvl(bid_currency_price,0) * DECODE(s_order_type_lookup_code,'GOODS',NVL(s_auc_quantity,1),NVL(quantity,1))),0)
3602: FROM pon_bid_payments_shipments
3603: WHERE auction_header_id = p_auc_header_id
3604: AND bid_number = p_bid_number
3605: AND bid_line_number = s_line_number) THEN
3606: INTO pon_interface_errors

Line 3794: FROM pon_bid_payments_shipments pbps

3790: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3791: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
3792: al.line_num_display s_clm_line_num_display,
3793: (SELECT nvl(Sum (round(NVL(pbps.bid_currency_price,0) * NVL(pbps.quantity,nvl(bl.quantity,1)),p_amt_precision)),0)
3794: FROM pon_bid_payments_shipments pbps
3795: WHERE pbps.auction_header_id = p_auc_header_id
3796: AND pbps.bid_number = p_bid_number
3797: AND pbps.bid_line_number = bl.line_number) s_sum_pymt_amt --bug 14657112
3798: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

Line 7104: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,

7100: 'LINENUM',
7101: pai.document_disp_line_number,
7102: 'PAYITEMNUM',
7103: pbps.payment_display_number
7104: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,
7105: PON_AUCTION_ITEM_PRICES_ALL pai
7106: WHERE pbps.auction_header_id= pai.auction_header_id
7107: AND pbps.auction_header_id=p_auc_header_id
7108: AND pbps.bid_line_number = pai.line_number

Line 7138: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7134: (
7135: p_request_id, 'PaymentDisplayNumber', 'PON_PYMT_NUM_WRONG', -- 1
7136: 'NUM', payment_display_number, NULL, -- 2
7137: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7138: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7139: p_batch_id, NULL, 'BID_PYMTS', -- 5
7140: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7141: l_exp_date, p_userid, SYSDATE, -- 7
7142: p_userid, SYSDATE, l_loginid -- 8

Line 7161: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7157: (
7158: p_request_id, 'Quantity', 'PON_PYMT_QTY_WRONG', -- 1
7159: 'NUM', quantity, NULL, -- 2
7160: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7161: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7162: p_batch_id, NULL, 'BID_PYMTS', -- 5
7163: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7164: l_exp_date, p_userid, SYSDATE, -- 7
7165: p_userid, SYSDATE, l_loginid -- 8

Line 7184: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7180: (
7181: p_request_id, 'BidCurrencyPrice', 'PON_PYMT_PRICE_WRONG', -- 1
7182: 'NUM', bid_currency_price, NULL, -- 2
7183: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7184: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7185: p_batch_id, NULL, 'BID_PYMTS', -- 5
7186: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7187: l_exp_date, p_userid, SYSDATE, -- 7
7188: p_userid, SYSDATE, l_loginid -- 8

Line 7207: NULL, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7203: (
7204: p_request_id, 'PaymentDisplayNumber', 'PON_PYMT_NUM_MISSING', -- 1
7205: 'TXT', payment_display_number, NULL, -- 2
7206: 'LINENUM', document_disp_line_number, NULL, -- 3
7207: NULL, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7208: p_batch_id, NULL, 'BID_PYMTS', -- 5
7209: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7210: l_exp_date, p_userid, SYSDATE, -- 7
7211: p_userid, SYSDATE, l_loginid -- 8

Line 7230: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7226: (
7227: p_request_id, 'PaymentTypeCode', 'PON_PYMT_TYPE_NULL', -- 1
7228: 'TXT', NULL, NULL, -- 2
7229: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7230: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7231: p_batch_id, NULL, 'BID_PYMTS', -- 5
7232: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7233: l_exp_date, p_userid, SYSDATE, -- 7
7234: p_userid, SYSDATE, l_loginid -- 8

Line 7253: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7249: (
7250: p_request_id, 'PaymentDescription', 'PON_PYMT_DESC_NULL', -- 1
7251: 'TXT', NULL, NULL, -- 2
7252: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7253: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7254: p_batch_id, NULL, 'BID_PYMTS', -- 5
7255: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7256: l_exp_date, p_userid, SYSDATE, -- 7
7257: p_userid, SYSDATE, l_loginid -- 8

Line 7276: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7272: (
7273: p_request_id, 'Quantity', 'PON_PYMT_QTY_NULL', -- 1
7274: 'TXT', NULL, NULL, -- 2
7275: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7276: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7277: p_batch_id, NULL, 'BID_PYMTS', -- 5
7278: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7279: l_exp_date, p_userid, SYSDATE, -- 7
7280: p_userid, SYSDATE, l_loginid -- 8

Line 7299: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7295: (
7296: p_request_id, 'UomCode', 'PON_PYMT_UOM_NULL', -- 1
7297: 'TXT', NULL, NULL, -- 2
7298: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7299: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7300: p_batch_id, NULL, 'BID_PYMTS', -- 5
7301: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7302: l_exp_date, p_userid, SYSDATE, -- 7
7303: p_userid, SYSDATE, l_loginid -- 8

Line 7322: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7318: (
7319: p_request_id, 'BidCurrencyPrice', 'PON_PYMT_BID_PRICE_NULL', -- 1
7320: 'TXT', bid_currency_price, NULL, -- 2
7321: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7322: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7323: p_batch_id, NULL, 'BID_PYMTS', -- 5
7324: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7325: l_exp_date, p_userid, SYSDATE, -- 7
7326: p_userid, SYSDATE, l_loginid -- 8

Line 7345: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7341: (
7342: p_request_id, 'PromisedDate', 'PON_PYMT_PDATE_LESS_CDATE', -- 1
7343: 'DAT', NULL, promised_date, -- 2
7344: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7345: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7346: p_batch_id, NULL, 'BID_PYMTS', -- 5
7347: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7348: l_exp_date, p_userid, SYSDATE, -- 7
7349: p_userid, SYSDATE, l_loginid -- 8

Line 7369: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4

7365: (
7366: p_request_id, 'BidCurrencyPrice', 'PON_QUOTEPRICE_INVALID_PREC_P', -- 1
7367: 'NUM', bid_currency_price, NULL, -- 2
7368: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
7369: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
7370: p_batch_id, NULL, 'BID_PYMTS', -- 5
7371: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
7372: l_exp_date, p_userid, SYSDATE, -- 7
7373: p_userid, SYSDATE, l_loginid -- 8

Line 7389: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,

7385: pai.line_number auction_line_number,
7386: pai.close_bidding_date,
7387: pbp.bid_payment_id,
7388: pbi.line_number bid_line_number
7389: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
7390: PON_AUCTION_ITEM_PRICES_ALL pai,
7391: PON_BID_ITEM_PRICES pbi
7392: WHERE pbp.auction_header_id = pai.auction_header_id
7393: AND pbp.auction_line_number = pai.line_number