eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_REQ_SPLIT_LINES_GT

Line 714: INSERT INTO po_req_split_lines_GT (

710: END LOOP;
711: CLOSE reqRescheduledSingleSupplier;
712:
713: -- Insert values into po's split temp global table
714: INSERT INTO po_req_split_lines_GT (
715: auction_header_id,
716: bid_number,
717: bid_line_number,
718: requisition_header_id,

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

730: nvl(paa.split_req_line_id, -999)= -999 AND
731: nvl(paa.allocated_qty,0) > 0;
732:
733: -- DEBUG CODE
734: -- INSERT INTO po_req_split_lines_gt_debug (SELECT * FROM po_req_split_lines_gt WHERE auction_header_id = p_auction_header_id);
735:
736: if(l_debug_enabled = 'Y') then
737: x_progress := ++l_progress || l_api_name || ' : invoke po_negotiations4_grp.split_requisitionlines :';
738: log_message(x_progress);

Line 775: from po_req_split_lines_gt prlst

771:
772: UPDATE PON_AWARD_ALLOCATIONS PAA
773: SET split_req_line_id=
774: (select new_req_line_id
775: from po_req_split_lines_gt prlst
776: where prlst.requisition_line_id = PAA.orig_req_line_id
777: and prlst.auction_header_id = PAA.auction_header_id
778: and prlst.bid_number = PAA.bid_number
779: and prlst.bid_line_number = PAA.bid_line_number