[Home] [Help]
393: ) IS
394:
395: l_temp NUMBER;
396: l_temp_fnd NUMBER;
397: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
398: l_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.CLM_INFO_FLAG%TYPE;
399: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;
400:
401: BEGIN
395: l_temp NUMBER;
396: l_temp_fnd NUMBER;
397: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
398: l_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.CLM_INFO_FLAG%TYPE;
399: l_doctype_id PON_AUCTION_HEADERS_ALL.doctype_id%TYPE;
400:
401: BEGIN
402:
403: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{
413: END IF; --}
414:
415: BEGIN
416:
417: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;
418:
419: SELECT
420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
437: END IF;
438:
439: Select price_tiers_indicator
440: into l_price_tiers_indicator
441: from pon_auction_headers_all
442: where auction_header_id = p_auction_header_id ;
443:
444: l_temp_fnd := power (10, p_fnd_precision);
445: --Splited 1 - fix bug 4908493
1418: pah.close_bidding_date clm_sol_close_date,
1419: CLM_OPTION_TO_DATE sel_clm_option_to_date,
1420: CLM_BASE_LINE_NUM sel_clm_base_line_num
1421: FROM pon_auction_item_prices_all paip,
1422: pon_auction_headers_all pah
1423: WHERE paip.auction_header_id = p_auction_header_id
1424: AND paip.auction_header_id = pah.auction_header_id;
1425:
1426: /* Bug 9787380 - Start */
5692: p_batch_id IN NUMBER,
5693: p_fnd_currency_precision IN NUMBER
5694: )
5695: IS
5696: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
5697: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
5698: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
5699: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
5700:
5693: p_fnd_currency_precision IN NUMBER
5694: )
5695: IS
5696: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
5697: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
5698: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
5699: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
5700:
5701: CURSOR l_proj_cursor IS
5694: )
5695: IS
5696: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
5697: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
5698: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
5699: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
5700:
5701: CURSOR l_proj_cursor IS
5702: SELECT line_number, document_disp_line_number,
5695: IS
5696: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
5697: l_progress_payment_type PON_AUCTION_HEADERS_ALL.progress_payment_type%TYPE;
5698: l_recoupment_negotiable_flag PON_AUCTION_HEADERS_ALL.recoupment_negotiable_flag%TYPE;
5699: l_advance_negotiable_flag PON_AUCTION_HEADERS_ALL.advance_negotiable_flag%TYPE;
5700:
5701: CURSOR l_proj_cursor IS
5702: SELECT line_number, document_disp_line_number,
5703: project_id, project_task_id, project_expenditure_type,
5719: INTO l_contract_type,
5720: l_progress_payment_type,
5721: l_recoupment_negotiable_flag,
5722: l_advance_negotiable_flag
5723: FROM pon_auction_headers_all pah
5724: WHERE auction_header_id = p_auction_header_id;
5725:
5726: IF l_progress_payment_type <> 'NONE' AND l_contract_type = 'CONTRACT' THEN
5727: INSERT ALL
6811: pai.line_number s_line_number,
6812: pai.line_num_display
6813: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
6814: PON_AUCTION_ITEM_PRICES_ALL pai,
6815: PON_AUCTION_HEADERS_ALL pah
6816: WHERE ppi.auction_header_id = pai.auction_header_id
6817: AND ppi.line_number = pai.line_number
6818: AND pah.auction_header_id = ppi.auction_header_id
6819: AND ppi.auction_header_id = p_auction_header_id;
7000: pai.line_number s_line_number,
7001: pai.line_num_display
7002: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
7003: PON_AUCTION_ITEM_PRICES_ALL pai,
7004: PON_AUCTION_HEADERS_ALL pah
7005: WHERE ppi.auction_header_id = pai.auction_header_id
7006: AND ppi.line_number = pai.line_number
7007: AND ppi.auction_header_id = p_auction_header_id
7008: AND pah.auction_header_id = pai.auction_header_id
8642: END IF; --}
8643:
8644:
8645: UPDATE
8646: PON_AUCTION_HEADERS_ALL PAHA
8647: SET
8648: ATTRIBUTES_EXIST = l_attributes_exist,
8649: HAS_PRICE_ELEMENTS = l_has_price_elements,
8650: HAS_PE_FOR_ALL_ITEMS = l_has_pe_for_all_items,
8697:
8698: l_max_line_number NUMBER;
8699: l_batch_start NUMBER;
8700: l_batch_end NUMBER;
8701: l_supplier_payments PON_AUCTION_HEADERS_ALL.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
8702:
8703: l_batch_size NUMBER;
8704: l_module_name VARCHAR2(30);
8705: BEGIN
8717: SELECT large_neg_enabled_flag, complete_flag, supplier_enterable_pymt_flag,
8718: nvl2(staggered_closing_interval,'Y','N')
8719: INTO l_large_neg_enabled_flag, l_complete_flag, l_supplier_payments,
8720: l_stag_closing_enabled_flag
8721: FROM pon_auction_headers_all
8722: WHERE auction_header_id = p_auction_header_id;
8723:
8724: SELECT NVL (MAX (line_number), 0)
8725: INTO l_max_line_number
8894:
8895: -- set the auction_status to draft and the complete flag to Y
8896:
8897: UPDATE
8898: pon_auction_headers_all
8899: SET
8900: auction_status = 'DRAFT',
8901: last_updated_by = p_user_id,
8902: last_update_date = sysdate
8930:
8931: -- set the auction_status to active and the complete flag to Y
8932:
8933: UPDATE
8934: pon_auction_headers_all
8935: SET
8936: auction_status = 'ACTIVE',
8937: last_updated_by = p_user_id,
8938: last_update_date = sysdate
9210: l_is_amendment BOOLEAN;
9211: l_is_new_round BOOLEAN;
9212: l_login_id NUMBER;
9213:
9214: l_draft_locked PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9211: l_is_new_round BOOLEAN;
9212: l_login_id NUMBER;
9213:
9214: l_draft_locked PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9212: l_login_id NUMBER;
9213:
9214: l_draft_locked PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9213:
9214: l_draft_locked PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9214: l_draft_locked PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9215: l_draft_locked_by_contact_id PON_AUCTION_HEADERS_ALL.DRAFT_LOCKED_BY_CONTACT_ID%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9216: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9217: l_auction_currency_precision PON_AUCTION_HEADERS_ALL.NUMBER_PRICE_DECIMALS%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9218: l_close_bidding_date PON_AUCTION_HEADERS_ALL.cLOSE_BIDDING_DATE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9219: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9220: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9221: l_allow_other_bid_currency PON_AUCTION_HEADERS_ALL.ALLOW_OTHER_BID_CURRENCY_FLAG%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9222: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9223: l_po_start_date PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9224: l_po_end_date PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9225: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9226: l_full_quantity_bid_code PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9227: l_bid_list_type PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9228: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9229: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9230: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9231: l_auction_header_id_prev_round PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_ROUND%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9232: l_auction_header_id_prev_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_PREV_AMEND%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9233: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9234: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9235: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9236: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9237: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9238: l_open_auction_now_flag PON_AUCTION_HEADERS_ALL.OPEN_AUCTION_NOW_FLAG%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9239: l_publish_auction_now_flag PON_AUCTION_HEADERS_ALL.PUBLISH_AUCTION_NOW_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9240: l_open_bidding_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9241: l_view_by_date PON_AUCTION_HEADERS_ALL.VIEW_BY_DATE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9242: l_auto_extend_flag PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9243: l_auto_extend_number PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_NUMBER%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9244: l_bid_visibility_code PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9245: l_price_driven_auction_flag PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9246: l_min_bid_decrement PON_AUCTION_HEADERS_ALL.MIN_BID_DECREMENT%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9247: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9248: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9249: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9257: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
9250: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9257: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
9258:
9251: l_award_by_date PON_AUCTION_HEADERS_ALL.AWARD_BY_DATE%TYPE;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9257: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
9258:
9259: p_auction_header_id NUMBER;
9252: l_reminder_date PON_AUCTION_HEADERS_ALL.REMINDER_DATE%TYPE;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9257: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
9258:
9259: p_auction_header_id NUMBER;
9260: p_for_approval BOOLEAN;
9253: l_number_of_lines PON_AUCTION_HEADERS_ALL.NUMBER_OF_LINES%TYPE;
9254: l_event_id PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE;
9255: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
9256: l_note_to_bidders PON_AUCTION_HEADERS_ALL.NOTE_TO_BIDDERS%TYPE;
9257: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
9258:
9259: p_auction_header_id NUMBER;
9260: p_for_approval BOOLEAN;
9261: p_note_to_approvers VARCHAR2(2000);
9288:
9289: l_module_name VARCHAR2 (30);
9290:
9291: -- Sol Project
9292: l_conf_doc_auc_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
9293: l_conf_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9294: l_conf_doc_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9295: l_conf_doc_request_id NUMBER;
9296: l_amendment_flag PON_AUCTION_HEADERS_ALL.AMENDMENT_FLAG%TYPE;
9289: l_module_name VARCHAR2 (30);
9290:
9291: -- Sol Project
9292: l_conf_doc_auc_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
9293: l_conf_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9294: l_conf_doc_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9295: l_conf_doc_request_id NUMBER;
9296: l_amendment_flag PON_AUCTION_HEADERS_ALL.AMENDMENT_FLAG%TYPE;
9297: -- Sol Project
9290:
9291: -- Sol Project
9292: l_conf_doc_auc_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
9293: l_conf_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9294: l_conf_doc_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9295: l_conf_doc_request_id NUMBER;
9296: l_amendment_flag PON_AUCTION_HEADERS_ALL.AMENDMENT_FLAG%TYPE;
9297: -- Sol Project
9298:
9292: l_conf_doc_auc_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
9293: l_conf_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9294: l_conf_doc_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9295: l_conf_doc_request_id NUMBER;
9296: l_amendment_flag PON_AUCTION_HEADERS_ALL.AMENDMENT_FLAG%TYPE;
9297: -- Sol Project
9298:
9299: l_revNum PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9300: l_pdfFileName varchar2(300);
9295: l_conf_doc_request_id NUMBER;
9296: l_amendment_flag PON_AUCTION_HEADERS_ALL.AMENDMENT_FLAG%TYPE;
9297: -- Sol Project
9298:
9299: l_revNum PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
9300: l_pdfFileName varchar2(300);
9301: BEGIN
9302:
9303: -- STORE THE ARGUMENTS INTO LOCAL VARIABLES
9444: l_note_to_bidders,
9445: l_price_tiers_indicator,
9446: l_amendment_flag -- Sol Project
9447: FROM
9448: pon_auction_headers_all
9449: WHERE
9450: auction_header_id = p_auction_header_id;
9451:
9452: SELECT COUNT(auction_header_id)
9761: module => g_module_prefix || l_module_name,
9762: message => 'This is for approval');
9763: END IF; --}
9764:
9765: UPDATE PON_AUCTION_HEADERS_ALL
9766: SET
9767: DRAFT_LOCKED = 'N',
9768: DRAFT_LOCKED_BY = NULL,
9769: DRAFT_LOCKED_BY_CONTACT_ID = NULL,
10080: END IF; --}
10081:
10082: -- AuctionHeadersALLEOImpl.setAutoExtendFields
10083: IF (l_auto_extend_flag = null OR l_auto_extend_flag = 'N' OR l_bid_visibility_code = 'SEALED_AUCTION') THEN
10084: UPDATE PON_AUCTION_HEADERS_ALL
10085: SET
10086: AUTO_EXTEND_TYPE_FLAG = 'FROM_AUCTION_CLOSE_DATE',
10087: AUTO_EXTEND_DURATION = NULL,
10088: AUTO_EXTEND_NUMBER = NULL,
10093: WHERE
10094: AUCTION_HEADER_ID = p_auction_header_id;
10095:
10096: ELSIF (l_auto_extend_flag = 'Y' AND l_auto_extend_number = NULL) THEN
10097: UPDATE PON_AUCTION_HEADERS_ALL
10098: SET
10099: AUTO_EXTEND_NUMBER = g_unlimited_int,
10100: LAST_UPDATE_DATE = SYSDATE,
10101: LAST_UPDATED_BY = p_user_id
10105: END IF;
10106:
10107: -- AuctionHeadersALLEOImpl.setDecrementFields
10108: IF ('MULTI_ATTRIBUTE_SCORING' = l_bid_ranking) THEN
10109: UPDATE pon_auction_headers_all
10110: SET
10111: min_bid_change_type = null,
10112: price_driven_auction_flag = 'N',
10113: min_bid_decrement = NULL,
10117: auction_header_id = p_auction_header_id;
10118:
10119: ELSIF ( NVL (l_price_driven_auction_flag, g_invalid_string) <> 'Y') THEN
10120:
10121: UPDATE PON_AUCTION_HEADERS_ALL
10122: SET
10123: MIN_BID_CHANGE_TYPE = NULL,
10124: MIN_BID_DECREMENT = NULL,
10125: LAST_UPDATE_DATE = SYSDATE,
10127: WHERE
10128: AUCTION_HEADER_ID = p_auction_header_id;
10129: ELSIF (l_min_bid_decrement = null OR l_min_bid_decrement = '') THEN
10130:
10131: UPDATE PON_AUCTION_HEADERS_ALL
10132: SET
10133: MIN_BID_CHANGE_TYPE = NULL,
10134: LAST_UPDATE_DATE = SYSDATE,
10135: LAST_UPDATED_BY = p_user_id
10163: p_auction_title => l_auction_title, --14
10164: p_event_id => l_event_id); --15
10165:
10166: -- Make the auction active
10167: UPDATE PON_AUCTION_HEADERS_ALL
10168: SET
10169: AUCTION_STATUS = 'ACTIVE',
10170: REQUEST_ID = NULL,
10171: REQUESTED_BY = NULL,