APPS.PON_AWARD_PKG dependencies on PON_AWARD_ITEMS_INTERFACE

Line 410: UPDATE pon_award_items_interface

406: BEGIN
407:
408: -- update the award quantity to 0 for those fields that have award quantity
409: -- less than 0
410: UPDATE pon_award_items_interface
411: SET award_quantity = 0
412: WHERE batch_id = p_batch_id
413: AND award_quantity < 0;
414:

Line 4047: FROM pon_award_items_interface aii,

4043: g_AWARD_OUTCOME_LOSE) award_outcome,
4044: aii.awardreject_reason,
4045: ai.group_type,
4046: aii.award_shipment_number
4047: FROM pon_award_items_interface aii,
4048: pon_auction_item_prices_all ai,
4049: pon_bid_item_prices bi,
4050: pon_auction_headers_all pah
4051: WHERE

Line 4090: FROM pon_award_items_interface

4086: --
4087:
4088: -- Get distinct lines awarded/rejected
4089: SELECT DISTINCT auction_line_number BULK COLLECT INTO l_item_list
4090: FROM pon_award_items_interface
4091: WHERE batch_id = p_batch_id
4092: AND auction_header_id = p_auction_header_id;
4093:
4094: -- Get distinct bids awarded/rejected

Line 4096: FROM pon_award_items_interface

4092: AND auction_header_id = p_auction_header_id;
4093:
4094: -- Get distinct bids awarded/rejected
4095: SELECT DISTINCT bid_number BULK COLLECT INTO l_bid_list
4096: FROM pon_award_items_interface
4097: WHERE batch_id = p_batch_id
4098: AND auction_header_id = p_auction_header_id;
4099: --
4100: -- Need to set award quantity and award_status and award_date

Line 4216: delete from pon_award_items_interface

4212:
4213: else
4214:
4215: -- delete interface data
4216: delete from pon_award_items_interface
4217: where batch_id = p_batch_id;
4218:
4219: x_status := 'SUCCESS';
4220: