DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_HEADERS_INTERFACE

Line 1469: FROM PON_BID_HEADERS_INTERFACE pbhi

1465: pbhi.BIDDERS_BID_NUMBER,
1466: pbhi.BID_EXPIRATION_DATE,
1467: pbhi.NOTE_TO_AUCTION_OWNER,
1468: pbhi.MIN_BID_CHANGE
1469: FROM PON_BID_HEADERS_INTERFACE pbhi
1470: WHERE batch_id = p_batch_id)
1471: WHERE pbh.bid_number = p_bid_number;
1472:
1473: --Delete from header interface

Line 1474: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;

1470: WHERE batch_id = p_batch_id)
1471: WHERE pbh.bid_number = p_bid_number;
1472:
1473: --Delete from header interface
1474: DELETE FROM PON_BID_HEADERS_INTERFACE WHERE batch_id = p_batch_id;
1475:
1476: -- Copy payments to transaction tables
1477: IF p_progress_payment_type <> 'NONE' THEN
1478: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,

Line 2086: FROM PON_BID_HEADERS_INTERFACE pbhi,

2082: pah.close_bidding_date s_close_bidding_date,
2083: pbh.old_surrog_bid_receipt_date s_old_response_recvd_time,
2084: pbh.surrog_bid_flag s_surrogate_bid_flag,
2085: pbh.number_price_decimals s_bid_price_precision
2086: FROM PON_BID_HEADERS_INTERFACE pbhi,
2087: PON_AUCTION_HEADERS_ALL pah,
2088: PON_BID_HEADERS pbh
2089: WHERE pbhi.batch_id = p_batch_id
2090: AND pbhi.bid_number = p_bid_number