APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 674: FROM po_requisition_lines_all

670: FOR l_index IN 1..20 LOOP
671: BEGIN
672: SELECT requisition_line_id
673: BULK COLLECT INTO l_req_line_id_col
674: FROM po_requisition_lines_all
675: WHERE auction_header_id = p_auction_header_id
676: FOR UPDATE NOWAIT;
677: EXIT;
678: EXCEPTION

Line 749: UPDATE po_requisition_lines_all prl

745: * can be cases where same req line is consumed by multiple bid lines. So
746: * for clm always populate -1 as bid number and bid_line_number.
747: */
748: IF l_is_neg_federal = 1 THEN
749: UPDATE po_requisition_lines_all prl
750: set bid_number = -1, bid_line_number = -1
751: where prl.requisition_line_id in
752: (select distinct orig_req_line_id
753: from pon_award_allocations alloc

Line 757: x_progress := ++l_progress || l_api_name || ' : Federal document : Updated po_requisition_lines_all with -1 :';

753: from pon_award_allocations alloc
754: where alloc.auction_header_id = p_auction_header_id);
755:
756: if(l_debug_enabled = 'Y') then
757: x_progress := ++l_progress || l_api_name || ' : Federal document : Updated po_requisition_lines_all with -1 :';
758: log_message(x_progress);
759: END IF;
760: p_split_result := FND_API.G_RET_STS_SUCCESS;
761: ELSE