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.

[Home] [Help]

APPS.PON_AWARD_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 73: pon_auction_headers_all paha

69: pbip.price,
70: null
71: from
72: pon_auction_item_prices_all paip,
73: pon_auction_headers_all paha
74: where pbip.bid_number = p_bid_number
75: and pbip.auction_header_id = paip.auction_header_id
76: and pbip.line_number = paip.line_number
77: and paha.auction_header_id = pbip.auction_header_id

Line 160: pon_auction_headers_all paha

156: p_award_date,
157: p_auctioneer_id
158: from
159: pon_bid_item_prices pbip,
160: pon_auction_headers_all paha
161: where pbip.bid_number = p_bid_number
162: and pbip.auction_header_id = paip.auction_header_id
163: and pbip.line_number = paip.line_number
164: and paha.auction_header_id = pbip.auction_header_id

Line 248: from pon_auction_headers_all ah,

244: -- FPK: CPA select all active bids for which award decision is not made.
245: CURSOR active_bid_headers(p_auction_header_id NUMBER) IS
246: select nvl(ah.award_status,'NO'),
247: bh.bid_number
248: from pon_auction_headers_all ah,
249: pon_bid_headers bh
250: where bh.auction_header_id = p_auction_header_id
251: and bh.auction_header_id = ah.auction_header_id
252: and nvl(bh.bid_status,'NONE') = 'ACTIVE'

Line 461: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE; -- FPK: CPA

457: x_line_number pon_auction_item_prices_all.line_number%type;
458: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
459: x_error_code VARCHAR2(20);
460: x_awarded_quantity NUMBER;
461: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE; -- FPK: CPA
462:
463: --Business Events Changes
464: x_return_status VARCHAR2(20);
465: x_msg_count NUMBER;

Line 591: update pon_auction_headers_all

587: -- Thus setShareAwardDecision will be N. We do not want that.
588: -- As otherwise the button will appear in bidViewAuction
589: -- update database w/ outcome status, source req result,
590: -- and award completion date
591: update pon_auction_headers_all
592: set outcome_status = p_outcome_status,
593: award_complete_date = sysdate,
594: source_reqs_flag = p_source_reqs_flag,
595: share_award_decision = decode(p_no_bids_flag, 'Y', 'I', share_award_decision),

Line 620: x_event_id pon_auction_headers_all.event_id%type;

616: ----------------------------------------------------------------
617:
618: PROCEDURE complete_auction (p_auction_header_id IN NUMBER ) IS
619:
620: x_event_id pon_auction_headers_all.event_id%type;
621: x_count NUMBER;
622:
623: BEGIN
624: -- complete auction header disposition

Line 626: update pon_auction_headers_all

622:
623: BEGIN
624: -- complete auction header disposition
625: -- clear out the request_id for super-large auctions
626: update pon_auction_headers_all
627: set AWARD_STATUS = 'COMPLETED',
628: AUCTION_STATUS = 'AUCTION_CLOSED',
629: REQUEST_ID = NULL,
630: LAST_UPDATE_DATE = sysdate

Line 650: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;

646: p_shared_award_decision IN VARCHAR2) IS
647:
648: x_bid_number pon_bid_headers.bid_number%type;
649: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
650: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
651: x_auction_title pon_auction_headers_all.auction_title%type;
652:
653: CURSOR all_bidders(p_auction_header_id NUMBER) IS
654: select b.bid_number,

Line 651: x_auction_title pon_auction_headers_all.auction_title%type;

647:
648: x_bid_number pon_bid_headers.bid_number%type;
649: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
650: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
651: x_auction_title pon_auction_headers_all.auction_title%type;
652:
653: CURSOR all_bidders(p_auction_header_id NUMBER) IS
654: select b.bid_number,
655: b.trading_partner_contact_name contact,

Line 659: pon_auction_headers_all a

655: b.trading_partner_contact_name contact,
656: a.trading_partner_name auctioneer,
657: a.auction_title
658: from pon_bid_headers b,
659: pon_auction_headers_all a
660: where b.auction_header_id = p_auction_header_id
661: and not nvl(b.bid_status,'NONE') in ('ARCHIVED','DISQUALIFIED')
662: and a.auction_header_id = b.auction_header_id;
663:

Line 687: -- update pon_auction_headers_all

683: p_auction_header_id_encrypted);
684: end loop;
685: close all_bidders;
686:
687: -- update pon_auction_headers_all
688: update pon_auction_headers_all
689: set SHARE_AWARD_DECISION = p_shared_award_decision
690: where auction_header_id = p_auction_header_id;
691:

Line 688: update pon_auction_headers_all

684: end loop;
685: close all_bidders;
686:
687: -- update pon_auction_headers_all
688: update pon_auction_headers_all
689: set SHARE_AWARD_DECISION = p_shared_award_decision
690: where auction_header_id = p_auction_header_id;
691:
692: end if;

Line 765: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

761: --
762: l_award_lines t_award_lines;
763: -- FPK: CPA
764: l_awarded_bid_headers t_awarded_bid_headers;
765: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
766:
767: l_matrix_index NUMBER;
768: --
769: l_current_bid_number NUMBER;

Line 777: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;

773: l_award_date DATE;
774: TYPE BID_LIST_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
775: l_bid_list BID_LIST_TYPE;
776: l_winning_bid NUMBER;
777: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;
778:
779: --
780: l_has_quantity_tiers pon_auction_item_prices_all.has_quantity_tiers%TYPE;
781: l_award_shipment_number NUMBER;

Line 800: from pon_auction_headers_all

796: l_neg_has_lines := PON_AUCTION_PKG.neg_has_lines(p_auction_header_id);
797:
798: select contract_type
799: into l_neg_contract_type
800: from pon_auction_headers_all
801: where auction_header_id = p_auction_header_id
802: and rownum =1;
803:
804: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 817: update pon_auction_headers_all

813: clear_draft_awards (p_auction_header_id, p_line_num, l_award_date, p_auctioneer_id, l_neg_has_lines);
814:
815: /* update auction-header by nulling out the request-id */
816:
817: update pon_auction_headers_all
818: set request_id = to_number(null)
819: where auction_header_id = p_auction_header_id;
820:
821: -- Need to expand all the AWARDED bids to build the lines

Line 1137: UPDATE pon_Auction_headers_all

1133: */
1134: IF (((x_status is NULL) OR (x_status = 'SUCCESS')) AND (is_auction_not_updated (p_auction_header_id, p_last_update_date))) THEN
1135: x_status := 'SUCCESS';
1136: -- update the last update date
1137: UPDATE pon_Auction_headers_all
1138: SET last_update_date = SYSDATE
1139: WHERE auction_header_id = p_auction_header_id;
1140: --
1141: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1558: FROM pon_auction_headers_all ah, pon_bid_headers bh

1554: l_total_lines := 0;
1555: l_award_status := null;
1556: --
1557: SELECT ah.contract_type INTO l_contract_type
1558: FROM pon_auction_headers_all ah, pon_bid_headers bh
1559: WHERE bh.bid_number = p_bid_number
1560: AND bh.auction_header_id = ah.auction_header_id;
1561: --
1562: OPEN c_bid_lines (p_bid_number);

Line 1719: FROM pon_auction_headers_all ah

1715: l_award_made := FALSE;
1716: l_item_award_mode := null;
1717: --
1718: SELECT ah.contract_type INTO l_contract_type
1719: FROM pon_auction_headers_all ah
1720: WHERE ah.auction_header_id = p_auction_id;
1721: --
1722: OPEN c_bid_items(p_auction_id, p_line_number) ;
1723: LOOP

Line 1864: UPDATE PON_Auction_HEADERS_all

1860: END;
1861:
1862: END IF; -- IF p_neg_has_lines = 'Y'
1863:
1864: UPDATE PON_Auction_HEADERS_all
1865: SET AWARD_STATUS = l_award_status,
1866: award_mode = l_award_mode,
1867: award_date = p_award_date,
1868: last_updated_by = p_auctioneer_id

Line 1874: UPDATE PON_AUCTION_HEADERS_ALL

1870: --award_approval_status = 'REQUIRED'
1871: --last_update_date = SYSDATE
1872: WHERE auction_header_id = p_auction_id ;
1873:
1874: UPDATE PON_AUCTION_HEADERS_ALL
1875: SET award_approval_status = 'REQUIRED'
1876: WHERE auction_header_id = p_auction_id
1877: AND nvl(award_approval_flag, 'N') = 'Y';
1878: --

Line 1892: UPDATE PON_AUCTION_HEADERS_ALL

1888: )
1889: IS
1890: BEGIN
1891: -- Updates approval_status if approval flag is set
1892: UPDATE PON_AUCTION_HEADERS_ALL
1893: SET award_approval_status = 'REQUIRED'
1894: WHERE auction_header_id = p_auction_id
1895: AND nvl(award_approval_flag, 'N') = 'Y';
1896: --

Line 1898: UPDATE PON_Auction_HEADERS_all

1894: WHERE auction_header_id = p_auction_id
1895: AND nvl(award_approval_flag, 'N') = 'Y';
1896: --
1897: -- Updates last update date etc since award is modified.
1898: UPDATE PON_Auction_HEADERS_all
1899: SET award_date = SYSDATE,
1900: last_updated_by = p_auctioneer_id,
1901: last_update_date = SYSDATE
1902: WHERE auction_header_id = p_auction_id ;

Line 2320: pon_auction_headers_all pah,

2316: por.line_number,
2317: por.award_quantity,
2318: por.award_shipment_number
2319: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
2320: pon_auction_headers_all pah,
2321: pon_bid_item_prices pbip
2322: WHERE pah.auction_header_id = l_auction_header_id
2323: AND pah.auction_header_id = paip.auction_header_id
2324: AND por.bid_number = pbip.bid_number

Line 2388: , pon_auction_headers_all ah

2384: ai.group_type,
2385: pas.award_shipment_number
2386: FROM pon_auction_summary pas
2387: , pon_auction_item_prices_all ai
2388: , pon_auction_headers_all ah
2389: WHERE
2390: pas.award_quantity >0
2391: AND pas.batch_id = c_batch_id
2392: AND ah.auction_header_id = pas.auction_id

Line 2457: UPDATE PON_Auction_HEADERS_all

2453: */
2454: IF (is_auction_not_updated (l_auction_header_id, p_last_update_date)) THEN
2455: x_status := 'SUCCESS';
2456: -- update the last update date
2457: UPDATE PON_Auction_HEADERS_all
2458: SET last_update_date = SYSDATE
2459: WHERE auction_header_id = l_auction_header_id;
2460: --
2461: ELSE

Line 2793: UPDATE pon_Auction_headers_all

2789:
2790: IF (is_auction_not_updated (p_auction_header_id, p_last_update_date)) THEN
2791: x_status := 'SUCCESS';
2792: -- update the last update date
2793: UPDATE pon_Auction_headers_all
2794: SET last_update_date = SYSDATE
2795: WHERE auction_header_id = p_auction_header_id;
2796: --
2797: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2853: pon_auction_headers_all pah

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
2855: aii.batch_id = c_batch_id
2856: AND aii.auction_header_id = c_auction_header_id
2857: AND aii.auction_header_id = ai.auction_header_id

Line 2997: UPDATE pon_Auction_headers_all

2993:
2994: IF (is_auction_not_updated (p_auction_header_id, p_last_update_date)) THEN
2995: x_status := 'SUCCESS';
2996: -- update the last update date
2997: UPDATE pon_Auction_headers_all
2998: SET last_update_date = SYSDATE
2999: WHERE auction_header_id = p_auction_header_id;
3000: --
3001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3038: FROM pon_auction_headers_all

3034: IS
3035: l_current_update_date DATE;
3036: BEGIN
3037: SELECT last_update_date INTO l_current_update_date
3038: FROM pon_auction_headers_all
3039: WHERE auction_header_id = p_auction_header_id;
3040: IF (l_current_update_date = p_last_update_date) THEN
3041: RETURN TRUE;
3042: ELSE

Line 3095: pon_auction_headers_all ah,

3091: BEGIN
3092: SELECT SUM(DECODE(ah.contract_type, 'STANDARD', bh.total_award_amount, bh.po_agreed_amount * (1/nvl(bh.rate, 1))))
3093: INTO l_award_amount
3094: FROM
3095: pon_auction_headers_all ah,
3096: pon_bid_headers bh
3097: WHERE
3098: ah.auction_header_id = p_auction_header_id
3099: AND ah.auction_header_id = bh.auction_header_id

Line 3402: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

3398: l_new_scenario_id NUMBER;
3399: l_status VARCHAR2(10);
3400: l_order_type_lookup_code PON_AUCTION_ITEM_PRICES_ALL.order_type_lookup_code%TYPE;
3401: l_auction_qty NUMBER;
3402: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
3403: l_module VARCHAR2(200);
3404: l_priority VARCHAR2(30);
3405: BEGIN
3406:

Line 3486: FROM pon_auction_headers_all pah,

3482: nvl(pai.quantity, 1)
3483: INTO l_contract_type,
3484: l_order_type_lookup_code,
3485: l_auction_qty
3486: FROM pon_auction_headers_all pah,
3487: pon_auction_item_prices_all pai,
3488: pon_optimize_scenarios pos
3489: WHERE pah.auction_header_id = pai.auction_header_id
3490: AND pah.auction_header_id = pos.auction_header_id