APPS.PON_AWARD_PKG dependencies on PON_AWARD_ITEMS_INTERFACE

Line 202: UPDATE pon_award_items_interface

198: BEGIN
199:
200: -- update the award quantity to 0 for those fields that have award quantity
201: -- less than 0
202: UPDATE pon_award_items_interface
203: SET award_quantity = 0
204: WHERE batch_id = p_batch_id
205: AND award_quantity < 0;
206:

Line 2850: FROM pon_award_items_interface aii,

2846: g_AWARD_OUTCOME_LOSE) award_outcome,
2847: aii.awardreject_reason,
2848: ai.group_type,
2849: aii.award_shipment_number
2850: FROM pon_award_items_interface aii,
2851: pon_auction_item_prices_all ai,
2852: pon_bid_item_prices bi,
2853: pon_auction_headers_all pah
2854: WHERE

Line 2893: FROM pon_award_items_interface

2889: --
2890:
2891: -- Get distinct lines awarded/rejected
2892: SELECT DISTINCT auction_line_number BULK COLLECT INTO l_item_list
2893: FROM pon_award_items_interface
2894: WHERE batch_id = p_batch_id
2895: AND auction_header_id = p_auction_header_id;
2896:
2897: -- Get distinct bids awarded/rejected

Line 2899: FROM pon_award_items_interface

2895: AND auction_header_id = p_auction_header_id;
2896:
2897: -- Get distinct bids awarded/rejected
2898: SELECT DISTINCT bid_number BULK COLLECT INTO l_bid_list
2899: FROM pon_award_items_interface
2900: WHERE batch_id = p_batch_id
2901: AND auction_header_id = p_auction_header_id;
2902: --
2903: -- Need to set award quantity and award_status and award_date

Line 3019: delete from pon_award_items_interface

3015:
3016: else
3017:
3018: -- delete interface data
3019: delete from pon_award_items_interface
3020: where batch_id = p_batch_id;
3021:
3022: x_status := 'SUCCESS';
3023: