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 225: FROM pon_bid_payments_shipments bps

221: OR EXISTS
222:
223: -- Check payments for xml spreadsheet upload case
224: (SELECT bps.bid_line_number
225: FROM pon_bid_payments_shipments bps
226: WHERE p_spreadsheet = g_xml_upload_mode
227: AND bps.bid_number = bl.bid_number
228: AND bps.bid_line_number = bl.line_number
229: AND (NVL(bps.payment_display_number, g_null_int) <> NVL(old_payment_display_number, g_null_int)

Line 246: from pon_bid_payments_shipments bps

242: AND rownum = 1)
243:
244: -- Check if any payments were deleted
245: OR (nvl(bl.old_no_of_payments,0) <> (select count(payment_display_number)
246: from pon_bid_payments_shipments bps
247: where bps.bid_number = bl.bid_number
248: and bps.bid_line_number = bl.line_number))
249:
250: OR ( (bl.has_shipments_flag = 'Y' or bl.has_quantity_tiers = 'Y')

Line 2834: FROM PON_BID_PAYMENTS_SHIPMENTS p_bps

2830: (p_spreadsheet = g_online_mode OR p_spreadsheet = g_xml_upload_mode) AND progress_payment_type = 'FINANCE' AND
2831: recoupment_rate_percent IS NOT NULL AND progress_pymt_rate_percent IS NOT NULL AND
2832: s_bid_currency_unit_price IS NOT NULL AND
2833: recoupment_rate_percent < (((((progress_pymt_rate_percent/100) * (SELECT nvl(sum(nvl(bid_currency_price,0)*nvl(quantity,nvl(s_bid_quantity,1))),0)
2834: FROM PON_BID_PAYMENTS_SHIPMENTS p_bps
2835: WHERE p_bps.auction_header_id=p_auc_header_id
2836: AND p_bps.bid_line_number=s_line_number
2837: AND p_bps.bid_number=p_bid_number))
2838: + nvl(bid_curr_advance_amount,0)) * 100)/((nvl(s_bid_quantity, 1) * s_bid_currency_unit_price))) THEN

Line 2894: FROM pon_bid_payments_shipments pbps

2890: s_group_type NOT IN ('GROUP','LOT_LINE') AND
2891: has_bid_payments_flag = 'Y' AND
2892: s_bid_currency_unit_price IS NOT NULL AND
2893: (nvl(s_bid_quantity,1)* s_bid_currency_unit_price) <> (SELECT nvl(sum(NVL(pbps.bid_currency_price,0) * NVL(pbps.quantity,nvl(s_bid_quantity,1))),0)
2894: FROM pon_bid_payments_shipments pbps
2895: WHERE pbps.auction_header_id = p_auc_header_id
2896: AND pbps.bid_number = p_bid_number
2897: AND pbps.bid_line_number = s_line_number) THEN
2898: INTO pon_interface_errors

Line 2926: FROM pon_bid_payments_shipments

2922: has_bid_payments_flag = 'Y' AND
2923: s_group_type NOT IN ('GROUP','LOT_LINE') AND
2924: s_bid_currency_unit_price IS NOT NULL AND
2925: (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)
2926: FROM pon_bid_payments_shipments
2927: WHERE auction_header_id = p_auc_header_id
2928: AND bid_number = p_bid_number
2929: AND bid_line_number = s_line_number) THEN
2930: INTO pon_interface_errors

Line 6356: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,

6352: 'LINENUM',
6353: pai.document_disp_line_number,
6354: 'PAYITEMNUM',
6355: pbps.payment_display_number
6356: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,
6357: PON_AUCTION_ITEM_PRICES_ALL pai
6358: WHERE pbps.auction_header_id= pai.auction_header_id
6359: AND pbps.auction_header_id=p_auc_header_id
6360: AND pbps.bid_line_number = pai.line_number

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

6386: (
6387: p_request_id, 'PaymentDisplayNumber', 'PON_PYMT_NUM_WRONG', -- 1
6388: 'NUM', payment_display_number, NULL, -- 2
6389: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6390: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6391: p_batch_id, NULL, 'BID_PYMTS', -- 5
6392: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6393: l_exp_date, p_userid, SYSDATE, -- 7
6394: p_userid, SYSDATE, l_loginid -- 8

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

6409: (
6410: p_request_id, 'Quantity', 'PON_PYMT_QTY_WRONG', -- 1
6411: 'NUM', quantity, NULL, -- 2
6412: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6413: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6414: p_batch_id, NULL, 'BID_PYMTS', -- 5
6415: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6416: l_exp_date, p_userid, SYSDATE, -- 7
6417: p_userid, SYSDATE, l_loginid -- 8

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

6432: (
6433: p_request_id, 'BidCurrencyPrice', 'PON_PYMT_PRICE_WRONG', -- 1
6434: 'NUM', bid_currency_price, NULL, -- 2
6435: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6436: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6437: p_batch_id, NULL, 'BID_PYMTS', -- 5
6438: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6439: l_exp_date, p_userid, SYSDATE, -- 7
6440: p_userid, SYSDATE, l_loginid -- 8

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

6455: (
6456: p_request_id, 'PaymentDisplayNumber', 'PON_PYMT_NUM_MISSING', -- 1
6457: 'TXT', payment_display_number, NULL, -- 2
6458: 'LINENUM', document_disp_line_number, NULL, -- 3
6459: NULL, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6460: p_batch_id, NULL, 'BID_PYMTS', -- 5
6461: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6462: l_exp_date, p_userid, SYSDATE, -- 7
6463: p_userid, SYSDATE, l_loginid -- 8

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

6478: (
6479: p_request_id, 'PaymentTypeCode', 'PON_PYMT_TYPE_NULL', -- 1
6480: 'TXT', NULL, NULL, -- 2
6481: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6482: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6483: p_batch_id, NULL, 'BID_PYMTS', -- 5
6484: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6485: l_exp_date, p_userid, SYSDATE, -- 7
6486: p_userid, SYSDATE, l_loginid -- 8

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

6501: (
6502: p_request_id, 'PaymentDescription', 'PON_PYMT_DESC_NULL', -- 1
6503: 'TXT', NULL, NULL, -- 2
6504: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6505: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6506: p_batch_id, NULL, 'BID_PYMTS', -- 5
6507: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6508: l_exp_date, p_userid, SYSDATE, -- 7
6509: p_userid, SYSDATE, l_loginid -- 8

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

6524: (
6525: p_request_id, 'Quantity', 'PON_PYMT_QTY_NULL', -- 1
6526: 'TXT', NULL, NULL, -- 2
6527: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6528: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6529: p_batch_id, NULL, 'BID_PYMTS', -- 5
6530: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6531: l_exp_date, p_userid, SYSDATE, -- 7
6532: p_userid, SYSDATE, l_loginid -- 8

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

6547: (
6548: p_request_id, 'UomCode', 'PON_PYMT_UOM_NULL', -- 1
6549: 'TXT', NULL, NULL, -- 2
6550: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6551: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6552: p_batch_id, NULL, 'BID_PYMTS', -- 5
6553: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6554: l_exp_date, p_userid, SYSDATE, -- 7
6555: p_userid, SYSDATE, l_loginid -- 8

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

6570: (
6571: p_request_id, 'BidCurrencyPrice', 'PON_PYMT_BID_PRICE_NULL', -- 1
6572: 'TXT', bid_currency_price, NULL, -- 2
6573: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6574: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6575: p_batch_id, NULL, 'BID_PYMTS', -- 5
6576: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6577: l_exp_date, p_userid, SYSDATE, -- 7
6578: p_userid, SYSDATE, l_loginid -- 8

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

6593: (
6594: p_request_id, 'PromisedDate', 'PON_PYMT_PDATE_LESS_CDATE', -- 1
6595: 'DAT', NULL, promised_date, -- 2
6596: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6597: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6598: p_batch_id, NULL, 'BID_PYMTS', -- 5
6599: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6600: l_exp_date, p_userid, SYSDATE, -- 7
6601: p_userid, SYSDATE, l_loginid -- 8

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

6617: (
6618: p_request_id, 'BidCurrencyPrice', 'PON_QUOTEPRICE_INVALID_PREC_P', -- 1
6619: 'NUM', bid_currency_price, NULL, -- 2
6620: 'LINENUM', document_disp_line_number, 'PAYITEMNUM', -- 3
6621: payment_display_number, p_interface_type, 'PON_BID_PAYMENTS_SHIPMENTS', -- 4
6622: p_batch_id, NULL, 'BID_PYMTS', -- 5
6623: auction_header_id, document_disp_line_number, bid_payment_id, -- 6
6624: l_exp_date, p_userid, SYSDATE, -- 7
6625: p_userid, SYSDATE, l_loginid -- 8

Line 6641: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,

6637: pai.line_number auction_line_number,
6638: pai.close_bidding_date,
6639: pbp.bid_payment_id,
6640: pbi.line_number bid_line_number
6641: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
6642: PON_AUCTION_ITEM_PRICES_ALL pai,
6643: PON_BID_ITEM_PRICES pbi
6644: WHERE pbp.auction_header_id = pai.auction_header_id
6645: AND pbp.auction_line_number = pai.line_number