APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_REQ_SPLIT_LINES_GT

Line 764: INSERT INTO po_req_split_lines_GT (

760: p_split_result := FND_API.G_RET_STS_SUCCESS;
761: ELSE
762:
763: -- Insert values into po's split temp global table
764: INSERT INTO po_req_split_lines_GT (
765: auction_header_id,
766: bid_number,
767: bid_line_number,
768: requisition_header_id,

Line 784: -- INSERT INTO po_req_split_lines_gt_debug (SELECT * FROM po_req_split_lines_gt WHERE auction_header_id = p_auction_header_id);

780: nvl(paa.split_req_line_id, -999)= -999 AND
781: nvl(paa.allocated_qty,0) > 0;
782:
783: -- DEBUG CODE
784: -- INSERT INTO po_req_split_lines_gt_debug (SELECT * FROM po_req_split_lines_gt WHERE auction_header_id = p_auction_header_id);
785:
786: if(l_debug_enabled = 'Y') then
787: x_progress := ++l_progress || l_api_name || ' : invoke po_negotiations4_grp.split_requisitionlines :';
788: log_message(x_progress);

Line 827: from po_req_split_lines_gt prlst

823:
824: UPDATE PON_AWARD_ALLOCATIONS PAA
825: SET split_req_line_id=
826: (select new_req_line_id
827: from po_req_split_lines_gt prlst
828: where prlst.requisition_line_id = PAA.orig_req_line_id
829: and prlst.auction_header_id = PAA.auction_header_id
830: and prlst.bid_number = PAA.bid_number
831: and prlst.bid_line_number = PAA.bid_line_number