DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_HEADERS_INTERFACE

Line 1270: FROM PON_BID_HEADERS_INTERFACE pbhi

1266: pbhi.BIDDERS_BID_NUMBER,
1267: pbhi.BID_EXPIRATION_DATE,
1268: pbhi.NOTE_TO_AUCTION_OWNER,
1269: pbhi.MIN_BID_CHANGE
1270: FROM PON_BID_HEADERS_INTERFACE pbhi
1271: WHERE batch_id = p_batch_id)
1272: WHERE pbh.bid_number = p_bid_number;
1273:
1274: --Delete from header interface

Line 1275: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;

1271: WHERE batch_id = p_batch_id)
1272: WHERE pbh.bid_number = p_bid_number;
1273:
1274: --Delete from header interface
1275: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;
1276:
1277: -- Copy payments to transaction tables
1278: IF p_progress_payment_type <> 'NONE' THEN
1279: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,

Line 1873: FROM PON_BID_HEADERS_INTERFACE pbhi,

1869: pah.close_bidding_date s_close_bidding_date,
1870: pbh.old_surrog_bid_receipt_date s_old_response_recvd_time,
1871: pbh.surrog_bid_flag s_surrogate_bid_flag,
1872: pbh.number_price_decimals s_bid_price_precision
1873: FROM PON_BID_HEADERS_INTERFACE pbhi,
1874: PON_AUCTION_HEADERS_ALL pah,
1875: PON_BID_HEADERS pbh
1876: WHERE pbhi.batch_id = p_batch_id
1877: AND pbhi.bid_number = p_bid_number