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_AWARD_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 46: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE) IS

42: p_emd_admin_name VARCHAR2, -- 3
43: p_auction_tp_name VARCHAR2, -- 4
44: p_auction_title VARCHAR2, -- 5
45: p_auction_header_id_encrypted VARCHAR2, -- 6
46: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE) IS
47:
48:
49:
50: x_number_awarded NUMBER;

Line 81: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

77: x_bid VARCHAR2(10);
78: x_bid_caps VARCHAR2(10);
79: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
80: x_view_quote_url_supplier VARCHAR2(2000);
81: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
82: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
83: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
84: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
85: x_preview_date DATE;

Line 82: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

78: x_bid_caps VARCHAR2(10);
79: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
80: x_view_quote_url_supplier VARCHAR2(2000);
81: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
82: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
83: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
84: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
85: x_preview_date DATE;
86: x_preview_date_in_tz DATE;

Line 88: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

84: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
85: x_preview_date DATE;
86: x_preview_date_in_tz DATE;
87: x_timezone1_disp VARCHAR2(240);
88: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
89: x_staggered_closing_interval NUMBER;
90: x_staggered_close_note VARCHAR2(1000);
91: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
92:

Line 276: pon_auction_headers_all paha

272: pbip.price,
273: null
274: from
275: pon_auction_item_prices_all paip,
276: pon_auction_headers_all paha
277: where pbip.bid_number = p_bid_number
278: and pbip.auction_header_id = paip.auction_header_id
279: and pbip.line_number = paip.line_number
280: and paha.auction_header_id = pbip.auction_header_id

Line 367: pon_auction_headers_all paha

363: p_award_date,
364: p_auctioneer_id
365: from
366: pon_bid_item_prices pbip,
367: pon_auction_headers_all paha
368: where pbip.bid_number = p_bid_number
369: and pbip.auction_header_id = paip.auction_header_id
370: and pbip.line_number = paip.line_number
371: and paha.auction_header_id = pbip.auction_header_id

Line 455: from pon_auction_headers_all ah,

451: -- FPK: CPA select all active bids for which award decision is not made.
452: CURSOR active_bid_headers(p_auction_header_id NUMBER) IS
453: select nvl(ah.award_status,'NO'),
454: bh.bid_number
455: from pon_auction_headers_all ah,
456: pon_bid_headers bh
457: where bh.auction_header_id = p_auction_header_id
458: and bh.auction_header_id = ah.auction_header_id
459: and nvl(bh.bid_status,'NONE') = 'ACTIVE'

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

674: x_line_number pon_auction_item_prices_all.line_number%type;
675: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
676: x_error_code VARCHAR2(20);
677: x_awarded_quantity NUMBER;
678: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE; -- FPK: CPA
679:
680: --Business Events Changes
681: x_return_status VARCHAR2(20);
682: x_msg_count NUMBER;

Line 696: FROM pon_auction_headers_all pah,

692: AND nvl(number_of_bids,0) = 0
693: AND line_origination_code = 'REQUISITION'
694: AND NOT EXISTS
695: (SELECT 1
696: FROM pon_auction_headers_all pah,
697: pon_bid_item_prices pbip,
698: pon_bid_item_references pbir
699: WHERE pah.auction_header_id = p_auction_header_id
700: AND Nvl(pah.ALLOW_UNSOL_OFFER_LINES,'N') = 'Y'

Line 741: select nvl(allow_staggered_awards, 'N') into l_allow_stag_awards from pon_auction_headers_all where auction_header_id = p_auction_header_id;

737: BEGIN
738:
739: l_neg_has_lines := PON_AUCTION_PKG.neg_has_lines(p_auction_header_id); -- FPK: CPA
740:
741: select nvl(allow_staggered_awards, 'N') into l_allow_stag_awards from pon_auction_headers_all where auction_header_id = p_auction_header_id;
742:
743: select count(DISTINCT line_number) into l_unawarded_line_count from pon_auction_item_prices_all where auction_header_id = p_auction_header_id and nvl(award_status,'NO') = 'NO';
744:
745: select count(DISTINCT line_number) into l_line_count from pon_auction_item_prices_all where auction_header_id = p_auction_header_id;

Line 930: update pon_auction_headers_all

926: -- Thus setShareAwardDecision will be N. We do not want that.
927: -- As otherwise the button will appear in bidViewAuction
928: -- update database w/ outcome status, source req result,
929: -- and award completion date
930: update pon_auction_headers_all
931: set outcome_status = p_outcome_status,
932: award_complete_date = sysdate,
933: source_reqs_flag = p_source_reqs_flag,
934: share_award_decision = decode(p_no_bids_flag, 'Y', 'I', share_award_decision),

Line 959: x_event_id pon_auction_headers_all.event_id%type;

955: ----------------------------------------------------------------
956:
957: PROCEDURE complete_auction (p_auction_header_id IN NUMBER ) IS
958:
959: x_event_id pon_auction_headers_all.event_id%type;
960: x_count NUMBER;
961:
962: BEGIN
963: -- complete auction header disposition

Line 965: update pon_auction_headers_all

961:
962: BEGIN
963: -- complete auction header disposition
964: -- clear out the request_id for super-large auctions
965: update pon_auction_headers_all
966: set AWARD_STATUS = 'COMPLETED',
967: AUCTION_STATUS = 'AUCTION_CLOSED',
968: REQUEST_ID = NULL,
969: LAST_UPDATE_DATE = sysdate

Line 989: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;

985: p_shared_award_decision IN VARCHAR2) IS
986:
987: x_bid_number pon_bid_headers.bid_number%type;
988: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
989: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
990: x_auction_title pon_auction_headers_all.auction_title%type;
991: x_emd_admin_name pon_neg_team_members.user_name%type;
992: x_doc_number_dsp pon_auction_headers_all.document_number%type;
993: CURSOR all_bidders(p_auction_header_id NUMBER) IS

Line 990: x_auction_title pon_auction_headers_all.auction_title%type;

986:
987: x_bid_number pon_bid_headers.bid_number%type;
988: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
989: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
990: x_auction_title pon_auction_headers_all.auction_title%type;
991: x_emd_admin_name pon_neg_team_members.user_name%type;
992: x_doc_number_dsp pon_auction_headers_all.document_number%type;
993: CURSOR all_bidders(p_auction_header_id NUMBER) IS
994: select b.bid_number,

Line 992: x_doc_number_dsp pon_auction_headers_all.document_number%type;

988: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
989: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
990: x_auction_title pon_auction_headers_all.auction_title%type;
991: x_emd_admin_name pon_neg_team_members.user_name%type;
992: x_doc_number_dsp pon_auction_headers_all.document_number%type;
993: CURSOR all_bidders(p_auction_header_id NUMBER) IS
994: select b.bid_number,
995: b.trading_partner_contact_name contact,
996: a.trading_partner_name auctioneer,

Line 1001: pon_auction_headers_all a

997: a.auction_title,
998: a.allow_staggered_awards, --added for staggered award project
999: b.award_status -- added for staggered award project
1000: from pon_bid_headers b,
1001: pon_auction_headers_all a
1002: where b.auction_header_id = p_auction_header_id
1003: and not nvl(b.bid_status,'NONE') in ('ARCHIVED','DISQUALIFIED','DRAFT')
1004: and a.auction_header_id = b.auction_header_id;
1005:

Line 1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1008: select u.user_name,
1009: a.trading_partner_name auctioneer,
1010: a.auction_title,
1011: a.document_number
1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1013: where b.menu_name = 'EMD_ADMIN'
1014: and b.approver_flag = 'Y'
1015: and a.auction_header_id = b.auction_header_id
1016: and u.user_id = b.user_id

Line 1021: x_allow_staggered_awards pon_auction_headers_all.allow_staggered_awards%TYPE;

1017: and a.auction_header_id = p_auction_header_id;
1018:
1019: --Staggered award project
1020: x_bid_award_status pon_bid_headers.award_status%type;
1021: x_allow_staggered_awards pon_auction_headers_all.allow_staggered_awards%TYPE;
1022: x_completed_lines NUMBER;
1023:
1024: BEGIN
1025:

Line 1059: -- update pon_auction_headers_all

1055: END IF;
1056: end loop;
1057: close all_bidders;
1058:
1059: -- update pon_auction_headers_all
1060: update pon_auction_headers_all
1061: set SHARE_AWARD_DECISION = p_shared_award_decision
1062: where auction_header_id = p_auction_header_id;
1063:

Line 1060: update pon_auction_headers_all

1056: end loop;
1057: close all_bidders;
1058:
1059: -- update pon_auction_headers_all
1060: update pon_auction_headers_all
1061: set SHARE_AWARD_DECISION = p_shared_award_decision
1062: where auction_header_id = p_auction_header_id;
1063:
1064: end if;

Line 1386: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

1382: --
1383: l_award_lines t_award_lines;
1384: -- FPK: CPA
1385: l_awarded_bid_headers t_awarded_bid_headers;
1386: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
1387:
1388: l_matrix_index NUMBER;
1389: --
1390: l_current_bid_number NUMBER;

Line 1398: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;

1394: l_award_date DATE;
1395: TYPE BID_LIST_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1396: l_bid_list BID_LIST_TYPE;
1397: l_winning_bid NUMBER;
1398: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;
1399:
1400: --
1401: l_has_quantity_tiers pon_auction_item_prices_all.has_quantity_tiers%TYPE;
1402: l_award_shipment_number NUMBER;

Line 1406: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;

1402: l_award_shipment_number NUMBER;
1403: l_suffix VARCHAR2(2);
1404:
1405: --Unsolicited Lines Project
1406: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;
1407:
1408: --Staggered Awards project
1409: l_allow_staggered_awards pon_auction_headers_all.ALLOW_STAGGERED_AWARDS%TYPE;
1410: l_total_agreed_amt pon_bid_headers.po_agreed_amount%TYPE;

Line 1409: l_allow_staggered_awards pon_auction_headers_all.ALLOW_STAGGERED_AWARDS%TYPE;

1405: --Unsolicited Lines Project
1406: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;
1407:
1408: --Staggered Awards project
1409: l_allow_staggered_awards pon_auction_headers_all.ALLOW_STAGGERED_AWARDS%TYPE;
1410: l_total_agreed_amt pon_bid_headers.po_agreed_amount%TYPE;
1411:
1412: l_org_id pon_auction_headers_all.org_id%TYPE;
1413: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

Line 1412: l_org_id pon_auction_headers_all.org_id%TYPE;

1408: --Staggered Awards project
1409: l_allow_staggered_awards pon_auction_headers_all.ALLOW_STAGGERED_AWARDS%TYPE;
1410: l_total_agreed_amt pon_bid_headers.po_agreed_amount%TYPE;
1411:
1412: l_org_id pon_auction_headers_all.org_id%TYPE;
1413: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
1414: l_are_exhibits_enabled VARCHAR2(1);
1415: --
1416: BEGIN

Line 1413: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

1409: l_allow_staggered_awards pon_auction_headers_all.ALLOW_STAGGERED_AWARDS%TYPE;
1410: l_total_agreed_amt pon_bid_headers.po_agreed_amount%TYPE;
1411:
1412: l_org_id pon_auction_headers_all.org_id%TYPE;
1413: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
1414: l_are_exhibits_enabled VARCHAR2(1);
1415: --
1416: BEGIN
1417: --

Line 1433: from pon_auction_headers_all

1429: select contract_type,Nvl(ALLOW_UNSOL_OFFER_LINES,'Y'),
1430: Nvl(allow_staggered_awards, 'N'), org_id, doctype_id --ELINs project
1431: into l_neg_contract_type,l_allow_unsol_lines, -- Unsolicited Lines Project
1432: l_allow_staggered_awards, l_org_id, l_doctype_id --ELINs project
1433: from pon_auction_headers_all
1434: where auction_header_id = p_auction_header_id
1435: and rownum =1;
1436:
1437: --ELINs project

Line 1470: update pon_auction_headers_all

1466: --END IF;
1467:
1468: /* update auction-header by nulling out the request-id */
1469:
1470: update pon_auction_headers_all
1471: set request_id = to_number(null)
1472: where auction_header_id = p_auction_header_id;
1473:
1474: -- Need to expand all the AWARDED bids to build the lines

Line 1862: UPDATE pon_Auction_headers_all

1858: */
1859: IF (((x_status is NULL) OR (x_status = 'SUCCESS')) AND (is_auction_not_updated (p_auction_header_id, p_last_update_date))) THEN
1860: x_status := 'SUCCESS';
1861: -- update the last update date
1862: UPDATE pon_Auction_headers_all
1863: SET last_update_date = SYSDATE
1864: WHERE auction_header_id = p_auction_header_id;
1865: --
1866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2250: l_org_id pon_auction_headers_all.org_id%TYPE;

2246: l_bid_number pon_bid_item_prices.bid_number%type;
2247:
2248: --ELINs project
2249: l_are_exhibits_enabled VARCHAR2(1);
2250: l_org_id pon_auction_headers_all.org_id%TYPE;
2251: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
2252: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2253: --
2254: BEGIN

Line 2251: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

2247:
2248: --ELINs project
2249: l_are_exhibits_enabled VARCHAR2(1);
2250: l_org_id pon_auction_headers_all.org_id%TYPE;
2251: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
2252: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2253: --
2254: BEGIN
2255:

Line 2252: l_contract_type pon_auction_headers_all.contract_type%TYPE;

2248: --ELINs project
2249: l_are_exhibits_enabled VARCHAR2(1);
2250: l_org_id pon_auction_headers_all.org_id%TYPE;
2251: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
2252: l_contract_type pon_auction_headers_all.contract_type%TYPE;
2253: --
2254: BEGIN
2255:
2256: IF (g_debug_mode = 'Y') THEN

Line 2264: FROM pon_auction_headers_all

2260: END IF;
2261:
2262: --ELINs project
2263: SELECT org_id, doctype_id, contract_type INTO l_org_id, l_doctype_id, l_contract_type
2264: FROM pon_auction_headers_all
2265: WHERE auction_header_id = p_auction_id;
2266:
2267: l_are_exhibits_enabled := PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
2268: IF (g_debug_mode = 'Y') THEN

Line 2720: FROM pon_auction_headers_all ah, pon_bid_headers bh

2716: l_total_lines := 0;
2717: l_award_status := null;
2718: --
2719: SELECT ah.contract_type INTO l_contract_type
2720: FROM pon_auction_headers_all ah, pon_bid_headers bh
2721: WHERE bh.bid_number = p_bid_number
2722: AND bh.auction_header_id = ah.auction_header_id;
2723: --
2724: OPEN c_bid_lines (p_bid_number);

Line 2884: FROM pon_auction_headers_all ah

2880: l_award_made := FALSE;
2881: l_item_award_mode := null;
2882: --
2883: SELECT ah.contract_type INTO l_contract_type
2884: FROM pon_auction_headers_all ah
2885: WHERE ah.auction_header_id = p_auction_id;
2886: --
2887: OPEN c_bid_items(p_auction_id, p_line_number) ;
2888: LOOP

Line 3058: UPDATE PON_Auction_HEADERS_all

3054: END;
3055:
3056: END IF; -- IF p_neg_has_lines = 'Y'
3057:
3058: UPDATE PON_Auction_HEADERS_all
3059: SET AWARD_STATUS = l_award_status,
3060: award_mode = l_award_mode,
3061: award_date = p_award_date,
3062: last_updated_by = p_auctioneer_id

Line 3068: UPDATE PON_AUCTION_HEADERS_ALL

3064: --award_approval_status = 'REQUIRED'
3065: --last_update_date = SYSDATE
3066: WHERE auction_header_id = p_auction_id ;
3067:
3068: UPDATE PON_AUCTION_HEADERS_ALL
3069: SET award_approval_status = 'REQUIRED'
3070: WHERE auction_header_id = p_auction_id
3071: AND nvl(award_approval_flag, 'N') = 'Y';
3072: --

Line 3086: UPDATE PON_AUCTION_HEADERS_ALL

3082: )
3083: IS
3084: BEGIN
3085: -- Updates approval_status if approval flag is set
3086: UPDATE PON_AUCTION_HEADERS_ALL
3087: SET award_approval_status = 'REQUIRED'
3088: WHERE auction_header_id = p_auction_id
3089: AND nvl(award_approval_flag, 'N') = 'Y';
3090: --

Line 3092: UPDATE PON_Auction_HEADERS_all

3088: WHERE auction_header_id = p_auction_id
3089: AND nvl(award_approval_flag, 'N') = 'Y';
3090: --
3091: -- Updates last update date etc since award is modified.
3092: UPDATE PON_Auction_HEADERS_all
3093: SET award_date = SYSDATE,
3094: last_updated_by = p_auctioneer_id,
3095: last_update_date = SYSDATE
3096: WHERE auction_header_id = p_auction_id ;

Line 3517: pon_auction_headers_all pah,

3513: por.line_number,
3514: por.award_quantity,
3515: por.award_shipment_number
3516: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
3517: pon_auction_headers_all pah,
3518: pon_bid_item_prices pbip
3519: WHERE pah.auction_header_id = l_auction_header_id
3520: AND pah.auction_header_id = paip.auction_header_id
3521: AND por.bid_number = pbip.bid_number

Line 3585: , pon_auction_headers_all ah

3581: ai.group_type,
3582: pas.award_shipment_number
3583: FROM pon_auction_summary pas
3584: , pon_auction_item_prices_all ai
3585: , pon_auction_headers_all ah
3586: WHERE
3587: pas.award_quantity >0
3588: AND pas.batch_id = c_batch_id
3589: AND ah.auction_header_id = pas.auction_id

Line 3654: UPDATE PON_Auction_HEADERS_all

3650: */
3651: IF (is_auction_not_updated (l_auction_header_id, p_last_update_date)) THEN
3652: x_status := 'SUCCESS';
3653: -- update the last update date
3654: UPDATE PON_Auction_HEADERS_all
3655: SET last_update_date = SYSDATE
3656: WHERE auction_header_id = l_auction_header_id;
3657: --
3658: ELSE

Line 3990: UPDATE pon_Auction_headers_all

3986:
3987: IF (is_auction_not_updated (p_auction_header_id, p_last_update_date)) THEN
3988: x_status := 'SUCCESS';
3989: -- update the last update date
3990: UPDATE pon_Auction_headers_all
3991: SET last_update_date = SYSDATE
3992: WHERE auction_header_id = p_auction_header_id;
3993: --
3994: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4050: pon_auction_headers_all pah

4046: aii.award_shipment_number
4047: FROM pon_award_items_interface aii,
4048: pon_auction_item_prices_all ai,
4049: pon_bid_item_prices bi,
4050: pon_auction_headers_all pah
4051: WHERE
4052: aii.batch_id = c_batch_id
4053: AND aii.auction_header_id = c_auction_header_id
4054: AND aii.auction_header_id = ai.auction_header_id

Line 4194: UPDATE pon_Auction_headers_all

4190:
4191: IF (is_auction_not_updated (p_auction_header_id, p_last_update_date)) THEN
4192: x_status := 'SUCCESS';
4193: -- update the last update date
4194: UPDATE pon_Auction_headers_all
4195: SET last_update_date = SYSDATE
4196: WHERE auction_header_id = p_auction_header_id;
4197: --
4198: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4235: FROM pon_auction_headers_all

4231: IS
4232: l_current_update_date DATE;
4233: BEGIN
4234: SELECT last_update_date INTO l_current_update_date
4235: FROM pon_auction_headers_all
4236: WHERE auction_header_id = p_auction_header_id;
4237: IF (l_current_update_date = p_last_update_date) THEN
4238: RETURN TRUE;
4239: ELSE

Line 4292: pon_auction_headers_all ah,

4288: BEGIN
4289: SELECT SUM(DECODE(ah.contract_type, 'STANDARD', bh.total_award_amount, bh.po_agreed_amount * (1/nvl(bh.rate, 1))))
4290: INTO l_award_amount
4291: FROM
4292: pon_auction_headers_all ah,
4293: pon_bid_headers bh
4294: WHERE
4295: ah.auction_header_id = p_auction_header_id
4296: AND ah.auction_header_id = bh.auction_header_id

Line 4618: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

4614: l_new_scenario_id NUMBER;
4615: l_status VARCHAR2(10);
4616: l_order_type_lookup_code PON_AUCTION_ITEM_PRICES_ALL.order_type_lookup_code%TYPE;
4617: l_auction_qty NUMBER;
4618: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
4619: l_module VARCHAR2(200);
4620: l_priority VARCHAR2(30);
4621: BEGIN
4622:

Line 4702: FROM pon_auction_headers_all pah,

4698: nvl(pai.quantity, 1)
4699: INTO l_contract_type,
4700: l_order_type_lookup_code,
4701: l_auction_qty
4702: FROM pon_auction_headers_all pah,
4703: pon_auction_item_prices_all pai,
4704: pon_optimize_scenarios pos
4705: WHERE pah.auction_header_id = pai.auction_header_id
4706: AND pah.auction_header_id = pos.auction_header_id

Line 5680: x_event_id pon_auction_headers_all.event_id%type;

5676: END update_total_agreement_amount;
5677:
5678: PROCEDURE complete_partial_auction (p_auction_header_id IN NUMBER ) IS
5679:
5680: x_event_id pon_auction_headers_all.event_id%type;
5681: x_count NUMBER;
5682:
5683: BEGIN
5684: -- complete auction header disposition

Line 5686: update pon_auction_headers_all

5682:
5683: BEGIN
5684: -- complete auction header disposition
5685: -- clear out the request_id for super-large auctions
5686: update pon_auction_headers_all
5687: set AUCTION_STATUS = 'AUCTION_CLOSED',
5688: REQUEST_ID = NULL,
5689: LAST_UPDATE_DATE = sysdate
5690: where auction_header_id = p_auction_header_id;