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 PON_AWARD_ALLOCATIONS

Line 218: -- pon_award_allocations with split_req_id

214: log_message(x_progress);
215: end if;
216:
217: -- Call procedure to split req lines and update
218: -- pon_award_allocations with split_req_id
219:
220: SPLIT_REQ_LINES(p_auction_header_id,
221: x_split_result,
222: x_split_failure_reason,

Line 544: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,

540: -- rescheduling has rescheduled the req quantity to a value lower than
541: -- the alloc quantity
542: CURSOR reqRescheduledSingleSupplier IS
543: SELECT paa.orig_req_line_id, prlsv.requisition_quantity
544: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
545: pon_auction_item_prices_all paip
546: WHERE paa.allocated_qty > prlsv.requisition_quantity AND
547: paa.auction_header_id = p_auction_header_id AND
548: nvl(paa.split_req_line_id, -999)= -999 AND

Line 563: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,

559: -- which the req qty is lower than the allocated qty as a result
560: -- of mrp rescheduling
561: CURSOR reqRescheduledMultSupplier IS
562: SELECT paa.orig_req_line_id
563: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
564: pon_auction_item_prices_all paip
565: WHERE paa.auction_header_id = p_auction_header_id AND
566: nvl(paa.split_req_line_id, -999)= -999 AND
567: nvl(paa.allocated_qty,0) > 0 AND

Line 584: pon_award_allocations paa

580: SELECT distinct paa.bid_line_number, itm.item_number, itm.item_revision, itm.item_description,
581: itm.requisition_number, pjo.name
582: FROM pon_auction_item_prices_all itm,
583: per_jobs pjo,
584: pon_award_allocations paa
585: WHERE paa.auction_header_id = itm.auction_header_id AND
586: paa.bid_line_number = itm.line_number AND
587: paa.orig_req_line_id = p_orig_req_line_id AND
588: itm.auction_header_id = p_auction_header_id AND

Line 704: UPDATE PON_AWARD_ALLOCATIONS

700: FETCH reqRescheduledSingleSupplier
701: INTO l_orig_req_line, l_req_qty;
702: EXIT WHEN reqRescheduledSingleSupplier%NOTFOUND;
703:
704: UPDATE PON_AWARD_ALLOCATIONS
705: SET allocated_qty = l_req_qty,
706: last_update_date = sysdate,
707: last_updated_by = l_user_id
708: WHERE orig_req_line_id = l_orig_req_line;

Line 728: FROM pon_award_allocations paa

724: paa.bid_line_number,
725: paa.orig_req_header_id,
726: paa.orig_req_line_id,
727: paa.allocated_qty
728: FROM pon_award_allocations paa
729: WHERE paa.auction_header_id = p_auction_header_id AND
730: nvl(paa.split_req_line_id, -999)= -999 AND
731: nvl(paa.allocated_qty,0) > 0;
732:

Line 772: UPDATE PON_AWARD_ALLOCATIONS PAA

768: x_progress := ++l_progress || l_api_name || ' : p_split_result is successful :';
769: log_message(x_progress);
770: end if;
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

Line 790: x_progress := ++l_progress || l_api_name || ' : after updating pon_award_allocations with split_req_line_id :';

786: nvl(paa.split_req_line_id, -999)= -999 AND
787: nvl(paa.allocated_qty,0) > 0;
788:
789: if(l_debug_enabled = 'Y') then
790: x_progress := ++l_progress || l_api_name || ' : after updating pon_award_allocations with split_req_line_id :';
791: log_message(x_progress);
792: end if;
793:
794:

Line 1091: INSERT INTO pon_award_allocations(bid_number, bid_line_number, orig_req_line_id, orig_req_header_id, allocated_qty, auction_header_id, created_by, last_update_date, last_updated_by, last_update_login, creation_date)

1087: l_login_id := fnd_global.login_id;
1088:
1089: -- doing bulk insert
1090: FORALL l_count IN 1..l_bid_number_insertcol.COUNT
1091: INSERT INTO pon_award_allocations(bid_number, bid_line_number, orig_req_line_id, orig_req_header_id, allocated_qty, auction_header_id, created_by, last_update_date, last_updated_by, last_update_login, creation_date)
1092: VALUES(l_bid_number_insertcol(l_count),
1093: l_bid_line_number_insertcol(l_count),
1094: l_orig_req_line_insertcol(l_count),
1095: l_orig_req_header_insertcol(l_count),

Line 1806: FROM pon_award_allocations

1802:
1803: /* queries the allocation table to get req lines and the allocated quantity backing that particular bid and bid line.*/
1804: CURSOR reqBackingBidItem IS
1805: SELECT split_req_line_id, allocated_qty
1806: FROM pon_award_allocations
1807: WHERE auction_header_id = p_auction_header_id and
1808: bid_number = p_bid_number and
1809: bid_line_number = x_line_number and
1810: nvl(allocated_qty,0) <> 0 and

Line 1818: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP

1814: up lines that have no allocations, but have backing requisitions to get a
1815: sum of 0 */
1816: CURSOR sumOfReqAllocQuantities is
1817: SELECT PAIP.line_number, nvl(sum(nvl(PAA.allocated_qty,0)), 0)
1818: FROM PON_AWARD_ALLOCATIONS PAA, PON_AUCTION_ITEM_PRICES_ALL PAIP
1819: WHERE PAIP.auction_header_id = p_auction_header_id
1820: AND PAIP.award_status = 'COMPLETED'
1821: AND nvl(PAIP.awarded_quantity,0) > 0
1822: AND PAA.auction_header_id(+) = PAIP.auction_header_id