APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_AUCTION_HEADERS_ALL

Line 4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;

4416: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
4418: l_org_id NUMBER;
4419: l_period_name gl_period_statuses.period_name%TYPE;
4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;
4421: l_document_num pon_auction_headers_all.document_number%TYPE;
4422: BEGIN
4423:
4424: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4421: l_document_num pon_auction_headers_all.document_number%TYPE;

4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
4418: l_org_id NUMBER;
4419: l_period_name gl_period_statuses.period_name%TYPE;
4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;
4421: l_document_num pon_auction_headers_all.document_number%TYPE;
4422: BEGIN
4423:
4424: x_return_status := FND_API.G_RET_STS_SUCCESS;
4425:

Line 4433: FROM PON_AUCTION_HEADERS_ALL

4429: DOCUMENT_NUMBER
4430: INTO l_org_id,
4431: l_auction_status,
4432: l_document_num
4433: FROM PON_AUCTION_HEADERS_ALL
4434: WHERE AUCTION_HEADER_ID = p_emd_transaction_rec.auction_header_id;
4435: EXCEPTION
4436: WHEN no_data_found THEN
4437: FND_MESSAGE.SET_NAME('PON','NEGOTIATION_NOT_FOUND');