[Home] [Help]
534: fc.precision fc_precision,
535: pbh.number_price_decimals pbh_price_precision
536: FROM PON_BID_PAYMENTS_INTERFACE pbp,
537: PON_AUCTION_ITEM_PRICES_ALL pai,
538: PON_BID_ITEM_PRICES pbi,
539: PON_AUCTION_HEADERS_ALL pah,
540: MTL_UNITS_OF_MEASURE uom,
541: PO_LOOKUP_CODES fl,
542: FND_CURRENCIES fc,
1314: END validate_creation;
1315: --
1316:
1317: PROCEDURE copy_payments_from_int_to_txn(
1318: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1319: p_spreadsheet_type IN VARCHAR2,
1320: p_bid_number IN NUMBER,
1321: p_auction_header_id IN NUMBER,
1322: x_result OUT NOCOPY VARCHAR2, -- S: Success, E: failure
1396: nvl(pah.supplier_enterable_pymt_flag,'N') supplier_can_modify_pymts
1397: FROM pon_bid_payments_interface pbpi,
1398: pon_auction_item_prices_all paip,
1399: pon_auction_headers_all pah,
1400: pon_bid_item_prices pbip,
1401: MTL_UNITS_OF_MEASURE uom,
1402: PO_LOOKUP_CODES fl
1403: WHERE pbpi.batch_id = p_batch_id
1404: AND pbpi.auction_header_id = p_auction_header_id
1518: AND pai.auction_header_id = pbpi.auction_header_id
1519: AND pai.document_disp_line_number = pbpi.document_disp_line_number
1520: AND pbp.bid_line_number = pai.line_number)
1521: AND pbp.bid_number = p_bid_number
1522: AND pbp.bid_line_number IN (SELECT pbi.line_number FROM PON_BID_ITEM_PRICES_INTERFACE pbi WHERE pbi.batch_id = p_batch_id);
1523:
1524: -- To delete attachments of pon_bid_payments_shipments
1525: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor
1526: LOOP
1541:
1542:
1543: --before deleting, set the is_changed_line_flag column for the lines for which
1544: --payments are uploaded in this batch
1545: UPDATE pon_bid_item_prices pbip SET pbip.IS_CHANGED_LINE_FLAG = 'Y',
1546: LAST_UPDATE_DATE = sysdate,
1547: LAST_UPDATED_BY = FND_GLOBAL.user_id
1548: WHERE pbip.line_number IN (
1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE