[Home] [Help]
39: --
40: g_has_inactive_pe_flag VARCHAR2(1);
41:
42: -- Global variable to hold the Document Number variable
43: g_neg_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
44:
45: -- Global variable for message sufix
46: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
47:
45: -- Global variable for message sufix
46: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
47:
48: -- Global variable for auction_origination_code
49: g_auc_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
50:
51: -- Global variable for Rate Based Temp Labor line type
52: g_temp_labor CONSTANT VARCHAR2(10) := 'TEMP LABOR';
53:
370: procedure renumber_lines(p_auction_header_id IN NUMBER);
371:
372: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
373:
374: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
371:
372: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
373:
374: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
372: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
373:
374: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
373:
374: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
374: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
375: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
376: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
377: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
378: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
379: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
380: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
381: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
382: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
383: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
384: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
385: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
386: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
387: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
388: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
389: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
390: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
391: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
392: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
393: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
394: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
395: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
396: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
397: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
398: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
399: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
400: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
407: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
401: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
402: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
407: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
408: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
409: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
403: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
407: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
408: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
409: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
410: ALLOW_PRICE_ELEMENT VARCHAR2(1),
411: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
404:
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
407: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
408: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
409: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
410: ALLOW_PRICE_ELEMENT VARCHAR2(1),
411: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
412: START_PRICE VARCHAR2(1),
405: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
406:
407: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
408: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
409: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
410: ALLOW_PRICE_ELEMENT VARCHAR2(1),
411: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
412: START_PRICE VARCHAR2(1),
413: RESERVE_PRICE VARCHAR2(1),
417: PRICE_BREAK VARCHAR2(1),
418: ALLOW_PRICE_DIFFERENTIAL VARCHAR2(1),
419: NUMBER_OF_BIDS NUMBER,
420: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
421: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
418: ALLOW_PRICE_DIFFERENTIAL VARCHAR2(1),
419: NUMBER_OF_BIDS NUMBER,
420: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
421: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
426: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE
419: NUMBER_OF_BIDS NUMBER,
420: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
421: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
426: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE
427: );
420: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
421: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
426: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE
427: );
428:
421: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
426: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE
427: );
428:
429: --
422: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
423: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
424: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
425: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
426: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE
427: );
428:
429: --
430: -- This variable will be used access the doctype based bizrule data accross different procedure.
435:
436:
437: TYPE NEG_STYLE_DATA IS RECORD (
438:
439: style_id pon_auction_headers_all.style_id%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
436:
437: TYPE NEG_STYLE_DATA IS RECORD (
438:
439: style_id pon_auction_headers_all.style_id%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
437: TYPE NEG_STYLE_DATA IS RECORD (
438:
439: style_id pon_auction_headers_all.style_id%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
438:
439: style_id pon_auction_headers_all.style_id%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
439: style_id pon_auction_headers_all.style_id%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
440: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
441: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
442: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
443: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
444: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
445: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
453: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type
446: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
453: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type
454:
447: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
453: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type
454:
455: );
448: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
453: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type
454:
455: );
456:
449: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
450: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
451: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
452: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
453: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type
454:
455: );
456:
457: -- this variable stores raw style settings (data from style table)
460: -- this variable stores reconciled style settings, it's used to control copy routines
461: g_neg_style_control NEG_STYLE_DATA;
462:
463:
464: g_price_break_response pon_auction_headers_all.price_break_response%type;
465:
466: FUNCTION GET_HDR_CROSS_COPY_DATA ( p_source_auction_header_id IN NUMBER,
467: p_auction_header_id IN NUMBER,
468: p_doctype_id IN NUMBER,
646: l_last_amendment_number NUMBER := 0;
647: l_org_id NUMBER := 0;
648: l_round_number NUMBER := 0;
649: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
650: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
651: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
652:
653: --This variable is used to store the document number of the new auction
654: --that is created by the COPY_HEADER procedure
647: l_org_id NUMBER := 0;
648: l_round_number NUMBER := 0;
649: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
650: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
651: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
652:
653: --This variable is used to store the document number of the new auction
654: --that is created by the COPY_HEADER procedure
655: l_new_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
651: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
652:
653: --This variable is used to store the document number of the new auction
654: --that is created by the COPY_HEADER procedure
655: l_new_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
656: l_is_amendment VARCHAR2(20);
657: l_error_code_update VARCHAR2(2000);
658: l_error_msg_update VARCHAR2(2000);
659:
709: --If it is -1, then the styleId of the source auction
710: --has to be retained
711: --
712: if nvl(p_style_id,-1) < 0 then
713: select style_id into l_style_id from pon_auction_headers_all
714: where auction_header_id = p_source_auction_header_id;
715: else
716: l_style_id := p_style_id;
717: end if;
801: END;
802: --
803: -- Get the company name for the given trading_partner_id
804: -- The resultant company name will be used in the trading partner
805: --name column of PON_AUCTION_HEADERS_ALL table
806: --
807: BEGIN
808: SELECT PARTY_NAME
809: INTO l_tp_name
869: LOG_MESSAGE('copy_negotiation','Locking the header');
870:
871: SELECT auction_header_id
872: INTO l_locked_auction_header_id
873: FROM pon_auction_headers_all
874: WHERE auction_header_id = p_source_auction_header_id
875: FOR UPDATE;
876:
877:
888: LOG_MESSAGE('copy_negotiation','Checking for multiple new rounds');
889:
890: select count(auction_header_id)
891: into l_newround_amendment_count
892: from pon_auction_headers_all
893: where auction_header_id_prev_round = p_source_auction_header_id;
894: LOG_MESSAGE('copy_negotiation','l_newround_amendment_count : ' || l_newround_amendment_count);
895:
896: if l_newround_amendment_count <> 0 then
907: LOG_MESSAGE('copy_negotiation','Checking for multiple new rounds or amendments');
908:
909: select count(auction_header_id)
910: into l_newround_amendment_count
911: from pon_auction_headers_all
912: where auction_header_id_prev_amend = p_source_auction_header_id;
913:
914: LOG_MESSAGE('copy_negotiation','l_newround_amendment_count : ' || l_newround_amendment_count);
915:
955: A.PRICE_BREAK_RESPONSE
956: INTO l_source_doctype_id, l_source_orig_round_id, l_source_prev_round_id, l_round_number,
957: l_last_amendment_number, l_source_orig_amend_id, l_org_id, l_source_doctype_grp_name,
958: g_message_suffix, l_source_auc_orig_code,l_source_doc_num, g_price_break_response
959: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D
960: WHERE auction_header_id = p_source_auction_header_id AND D.DOCTYPE_ID = A.DOCTYPE_ID ;
961: EXCEPTION
962: WHEN NO_DATA_FOUND THEN
963: -- The way I am adding this error may get changed in the future.
1001: then
1002: --
1003: -- Get the new auction_header_id for the new negotiation document
1004: -- from
1005: -- the PON_AUCTION_HEADERS_ALL_S sequence
1006: --
1007: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1008: INTO l_auction_header_id
1009: FROM DUAL;
1003: -- Get the new auction_header_id for the new negotiation document
1004: -- from
1005: -- the PON_AUCTION_HEADERS_ALL_S sequence
1006: --
1007: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1008: INTO l_auction_header_id
1009: FROM DUAL;
1010: --
1011: --Initialise global variables here
1106:
1107: LOG_MESSAGE('copy_negotiation','Copied the header with document number : '||l_new_doc_number);
1108: --
1109: -- if it is a super large auction, then initiate a concurrent
1110: -- request, update the PON_AUCTION_HEADERS_ALL and return with a
1111: -- CONC_REQ_SUBMITTED status
1112: --
1113: if (l_is_super_large_auction = 'Y') then
1114:
1138: argument16 => to_char(l_auction_header_id),
1139: argument17 => to_char(l_style_id));
1140:
1141: g_err_loc := '3. Before submitting the concurrent request';
1142: --update the pon_auction_headers_all table
1143: --
1144: update pon_auction_headers_all set
1145: request_id = l_request_id,
1146: requested_by = p_user_id,
1140:
1141: g_err_loc := '3. Before submitting the concurrent request';
1142: --update the pon_auction_headers_all table
1143: --
1144: update pon_auction_headers_all set
1145: request_id = l_request_id,
1146: requested_by = p_user_id,
1147: request_date = sysdate,
1148: last_update_date = sysdate,
1282: x_msg_count => x_msg_count,
1283: x_msg_data => x_msg_data
1284: );
1285: --
1286: -- Set the COMPLETE_FLAG for this acution in PON_AUCTION_HEADERS_ALL
1287: -- to 'Y' since the auction has been copied successfully
1288: --
1289: update pon_auction_headers_all set
1290: complete_flag = 'Y'
1285: --
1286: -- Set the COMPLETE_FLAG for this acution in PON_AUCTION_HEADERS_ALL
1287: -- to 'Y' since the auction has been copied successfully
1288: --
1289: update pon_auction_headers_all set
1290: complete_flag = 'Y'
1291: where auction_header_id = l_auction_header_id;
1292:
1293: end if;
1301:
1302: --
1303: -- Bug# 5591755
1304: --This exception block is to release the lock put on the row
1305: --in pon_auction_headers_all for p_auction_header_id
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1342: x_document_number OUT NOCOPY VARCHAR2
1343: )
1344: IS
1345: l_contracts_doctype VARCHAR2(50);
1346: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1347: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1348: l_return_value NUMBER;
1349: BEGIN --{ Start of COPY_HEADER
1350:
1343: )
1344: IS
1345: l_contracts_doctype VARCHAR2(50);
1346: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1347: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1348: l_return_value NUMBER;
1349: BEGIN --{ Start of COPY_HEADER
1350:
1351: --
1379: x_document_number := l_document_number;
1380:
1381: g_err_loc := '1.11 Going to create discussions record';
1382: l_return_value := PON_THREAD_DISC_PKG.insert_pon_discussions(
1383: p_entity_name => 'PON_AUCTION_HEADERS_ALL',
1384: p_entity_pk1 => p_auction_header_id,
1385: p_entity_pk2 => '',
1386: p_entity_pk3 => '',
1387: p_entity_pk4 => '',
1476: l_auction_header_id_prev_round NUMBER;
1477: l_auction_round_number NUMBER;
1478: l_last_amendment_number NUMBER;
1479: l_copy_buyer_id VARCHAR2(1);
1480: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1481: l_contract_terms_exisits VARCHAR2(2);
1482: l_contract_doctype VARCHAR2(50);
1483: l_is_award_approval_reqd VARCHAR2(2);
1484: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1521: IF ( p_copy_type = g_rfi_to_other_copy) THEN
1522: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1523: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1524: l_source_doc_number
1525: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1526: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1527: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1528:
1529: LOG_MESSAGE('copy_negotiation','1.1.0.1 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);
1542: IF ( p_copy_type = g_new_rnd_copy AND p_doctype_id <> p_source_doctype_id) THEN
1543: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1544: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1545: l_source_doc_number
1546: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1547: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1548: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1549:
1550: LOG_MESSAGE('copy_negotiation','1.1.0.2 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);
1880: LOG_MESSAGE('copy_negotiation','Default Enforce Min Bid Price Across Rounds:'||l_MinBidPriceVal1);
1881: END IF;
1882: -- end enforce bid price flag code.
1883:
1884: g_err_loc := '1.3 Going to insert data into PON_AUCTION_HEADERS_ALL';
1885:
1886: INSERT INTO PON_AUCTION_HEADERS_ALL
1887: ( AUCTION_HEADER_ID,
1888: AUCTION_TITLE,
1882: -- end enforce bid price flag code.
1883:
1884: g_err_loc := '1.3 Going to insert data into PON_AUCTION_HEADERS_ALL';
1885:
1886: INSERT INTO PON_AUCTION_HEADERS_ALL
1887: ( AUCTION_HEADER_ID,
1888: AUCTION_TITLE,
1889: AUCTION_STATUS,
1890: AUCTION_STATUS_NAME,
2583: DECODE(p_copy_type, g_amend_copy, ENFORCE_PREVRND_BID_PRICE_FLAG, l_MinBidPriceVal1),
2584: g_neg_style_raw.QTY_PRICE_TIERS_ENABLED_FLAG,
2585: t_record.PRICE_TIERS_INDICATOR,
2586: DECODE(p_doctype_id, g_rfq_doctype_id, TWO_PART_FLAG, NULL)
2587: FROM PON_AUCTION_HEADERS_ALL
2588: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
2589:
2590: END;
2591: --} End of COPY_HEADER_BASIC
3674: -- BPA as it can be BPA or CPA and user can choose them on the Creation
3675: -- Header page
3676: --
3677: IF (l_has_temp_labor_lines = 'Y') THEN
3678: UPDATE PON_AUCTION_HEADERS_ALL
3679: SET GLOBAL_AGREEMENT_FLAG = 'Y'
3680: WHERE AUCTION_HEADER_ID = p_auction_header_id;
3681: END IF;
3682: END;
3801: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
3802:
3803: l_has_inactv_hdr_attr_grp VARCHAR2(1);
3804:
3805: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
3806:
3807: BEGIN
3808: --{ Start of COPY_HEADER_ATTRIBUTE
3809:
4084:
4085: l_temp VARCHAR2(300);
4086: l_has_inactv_hdr_attr_grp VARCHAR2(1);
4087:
4088: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
4089:
4090: BEGIN
4091: --{ Start of COPY_LINE_ATTRIBUTE
4092:
4419: -- Synch up descriptors when copying
4420: -- only update descriptor name and remove dropped descriptors
4421: SELECT contract_type
4422: INTO l_contract_type
4423: FROM pon_auction_headers_all
4424: WHERE auction_header_id = p_auction_header_id;
4425:
4426: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
4427: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
4863: l_keep_effective_end_date := 'Y';
4864:
4865: SELECT price_tiers_indicator
4866: INTO l_src_price_tiers_indicator
4867: FROM pon_auction_headers_all
4868: WHERE auction_header_id = p_source_auction_header_id;
4869:
4870: --
4871: -- Should copy only when Price Breaks are allowed for the
5214: l_last_seq_number NUMBER;
5215: -- bug 7376924, handling inactive supplier contact
5216: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5217:
5218: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%type;
5219:
5220: BEGIN
5221: -- { Start of COPY_INVITEES
5222:
5238: END IF;
5239:
5240: SELECT AUCTION_HEADER_ID_ORIG_AMEND
5241: INTO l_auction_header_id_orig_amend
5242: FROM PON_AUCTION_HEADERS_ALL
5243: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
5244:
5245: --
5246: -- For Copy Negotiation and Amendment
5744: FROM PON_BID_HEADERS PBH
5745: WHERE PBH.SHORTLIST_FLAG = 'N'
5746: AND PBH.AUCTION_HEADER_ID IN
5747: (SELECT AUCTION_HEADER_ID
5748: FROM PON_AUCTION_HEADERS_ALL
5749: WHERE AUCTION_HEADER_ID_ORIG_AMEND =
5750: l_auction_header_id_orig_amend)
5751: AND PBH.BID_STATUS IN('ACTIVE','RESUBMISSION'))
5752: AND PBP.TRADING_PARTNER_ID = PV.PARTY_ID
5836: FROM PON_BID_HEADERS PBH
5837: WHERE PBH.SHORTLIST_FLAG <> 'N'
5838: AND PBH.AUCTION_HEADER_ID IN
5839: (SELECT AUCTION_HEADER_ID
5840: FROM PON_AUCTION_HEADERS_ALL
5841: WHERE AUCTION_HEADER_ID_ORIG_AMEND =
5842: l_auction_header_id_orig_amend
5843: )
5844: AND PBH.BID_STATUS IN ('ACTIVE', 'RESUBMISSION')
6199: FND_USER U,
6200: PER_ALL_PEOPLE_F P,
6201: PER_ALL_ASSIGNMENTS_F A,
6202: PER_ALL_POSITIONS S,
6203: PON_AUCTION_HEADERS_ALL AH,
6204: FINANCIALS_SYSTEM_PARAMS_ALL F
6205: WHERE U.USER_ID = PNTM.USER_ID
6206: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
6207: AND AH.AUCTION_HEADER_ID = PNTM.AUCTION_HEADER_ID
6764: p_user_id,
6765: XML_LAST_SENT_DATE
6766: FROM PON_FORMS_SECTIONS FS,
6767: PON_FORMS_INSTANCES FI
6768: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6769: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6770: AND FI.FORM_ID = FS.FORM_ID
6771: AND FS.STATUS = 'ACTIVE');
6772:
6805: p_user_id,
6806: NULL
6807: FROM PON_FORMS_INSTANCES FI,
6808: PON_FORMS_SECTIONS FS
6809: WHERE ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6810: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6811: AND FI.FORM_ID = FS.FORM_ID
6812: AND FS.STATUS = 'ACTIVE');
6813: END IF;
6818: INTO
6819: l_inactive_sections
6820: FROM PON_FORMS_INSTANCES FI,
6821: PON_FORMS_SECTIONS FS
6822: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6823: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6824: AND FI.FORM_ID = FS.FORM_ID
6825: AND FS.STATUS = 'INACTIVE';
6826:
6865: SELECT
6866: FI.FORM_ID
6867: FROM PON_FORMS_INSTANCES FI,
6868: PON_FORMS_SECTIONS FS
6869: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6870: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6871: AND FI.FORM_ID = FS.FORM_ID
6872: AND FS.STATUS = 'ACTIVE';
6873:
6885: INTO
6886: l_has_children
6887: FROM PON_FORM_FIELD_VALUES
6888: WHERE FORM_ID = form.FORM_ID
6889: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6890: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6891: AND PARENT_FIELD_VALUES_FK = -1;
6892:
6893: IF l_has_children > 0 THEN
6897: INTO
6898: l_orig_parent_field_val_fk
6899: FROM PON_FORM_FIELD_VALUES
6900: WHERE FORM_ID = form.FORM_ID
6901: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6902: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6903: AND PARENT_FIELD_VALUES_FK = -1;
6904:
6905: COPY_FORM_FIELD_CHILDREN (
7296: FROM PON_FORM_FIELD_VALUES
7297: WHERE PARENT_FIELD_VALUES_FK = p_orig_parent_fld_values_fk
7298: AND FORM_ID = p_form_id
7299: AND ENTITY_PK1 = p_old_entity_pk1
7300: AND OWNING_ENTITY_CODE='PON_AUCTION_HEADERS_ALL';
7301:
7302:
7303: BEGIN
7304: -- { Start of COPY_FORM_FIELD_CHILDREN
7680: VALUES
7681: (
7682: l_new_field_values_fk,
7683: field_value.FORM_ID,
7684: 'PON_AUCTION_HEADERS_ALL',
7685: p_new_entity_pk1,
7686: field_value.SECTION_ID,
7687: p_new_parent_field_values_fk,
7688: field_value.TEXTCOL1,
8130: l_s_line_attr_enabled_flag VARCHAR2(1);
8131: l_s_rfi_line_enabled_flag VARCHAR2(1);
8132: l_s_doctype_name VARCHAR2(240);
8133: l_s_pf_type_allowed VARCHAR2(25);
8134: l_s_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
8135: l_s_global_agmt_flag VARCHAR2(1);
8136: l_s_lot_enabled_flag VARCHAR2(1);
8137: l_s_grp_enabled_flag VARCHAR2(1);
8138: l_s_has_hdr_attr_flag VARCHAR2(1);
8143: l_d_line_attr_enabled_flag VARCHAR2(1);
8144: l_d_rfi_line_enabled_flag VARCHAR2(1);
8145: l_d_doctype_name VARCHAR2(240);
8146: l_d_pe_enabled_flag VARCHAR2(1); --styles flag for PE
8147: l_d_po_style_id pon_auction_headers_all.po_style_id%type;
8148: l_d_pb_enabled_flag VARCHAR2(1); --styles flag for PB
8149: l_d_pd_enabled_flag VARCHAR2(1); --styles flag for PD
8150: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
8151: l_d_lot_enabled_flag VARCHAR2(1);
8146: l_d_pe_enabled_flag VARCHAR2(1); --styles flag for PE
8147: l_d_po_style_id pon_auction_headers_all.po_style_id%type;
8148: l_d_pb_enabled_flag VARCHAR2(1); --styles flag for PB
8149: l_d_pd_enabled_flag VARCHAR2(1); --styles flag for PD
8150: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
8151: l_d_lot_enabled_flag VARCHAR2(1);
8152: l_d_grp_enabled_flag VARCHAR2(1);
8153: l_d_hdr_attr_enabled_flag VARCHAR2(1);
8154:
8189: headers.AUCTION_STATUS,
8190: nvl(styles.LARGE_NEG_ENABLED_FLAG,'N'),
8191: staggered_closing_interval into IS_LARGE_SOURCE,CURRENT_STATUS,IS_LARGE_DESTINATION,l_staggered_closing_interval
8192: from
8193: PON_AUCTION_HEADERS_ALL headers,
8194: PON_NEGOTIATION_STYLES styles
8195: where
8196: headers.AUCTION_HEADER_ID = p_source_auction_header_id and
8197: styles.STYLE_ID = p_style_id;
8225: l_d_po_style_id,
8226: l_d_doctype_name,
8227: l_d_hdr_attr_enabled_flag
8228: FROM
8229: PON_AUCTION_HEADERS_ALL hdr,
8230: PON_AUC_DOCTYPES doctypes
8231: WHERE
8232: hdr.auction_header_id = l_auction_header_id AND
8233: doctypes.DOCTYPE_ID = p_doctype_id;
8303: l_s_has_hdr_attr_flag,
8304: l_s_hdr_attr_enabled_flag,
8305: l_s_pe_enabled_flag
8306: FROM
8307: PON_AUCTION_HEADERS_ALL hdr,
8308: PON_AUC_DOCTYPES doctypes
8309: WHERE
8310: auction_header_id = p_source_auction_header_id AND
8311: doctypes.DOCTYPE_ID = hdr.DOCTYPE_ID;
8664: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
8665: where auction_header_id = p_source_auction_header_id;
8666: else
8667:
8668: LOG_MESSAGE('copy_negotiation','The source auction is not in DRAFT stage; so querying MAX_INTERNAL_LINE_NUM field in PON_AUCTION_HEADERS_ALL for l_max_line_number');
8669:
8670: select nvl(max_internal_line_num,0) into l_max_line_number from PON_AUCTION_HEADERS_ALL
8671: where auction_header_id = p_source_auction_header_id;
8672: end if;
8666: else
8667:
8668: LOG_MESSAGE('copy_negotiation','The source auction is not in DRAFT stage; so querying MAX_INTERNAL_LINE_NUM field in PON_AUCTION_HEADERS_ALL for l_max_line_number');
8669:
8670: select nvl(max_internal_line_num,0) into l_max_line_number from PON_AUCTION_HEADERS_ALL
8671: where auction_header_id = p_source_auction_header_id;
8672: end if;
8673:
8674:
9083: -- Delete all attribute scores where there is no parent attribute
9084:
9085: SELECT contract_type
9086: INTO l_contract_type
9087: FROM pon_auction_headers_all
9088: WHERE auction_header_id = l_auction_header_id;
9089:
9090: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
9091: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
9184:
9185: END IF;
9186:
9187: --
9188: --Update the LAST_LINE_NUMBER and NUMBER_OF_LINES fields in pon_auction_headers_all
9189: --
9190: LOG_MESSAGE('copy_negotiation','Querying for NUMBER_OF_LINES and LAST_LINE_NUMBER');
9191:
9192: SELECT
9197: AUCTION_HEADER_ID = l_auction_header_id;
9198:
9199: LOG_MESSAGE('copy_lines_and_children','l_number_of_lines : ' || l_number_of_lines || ' ; l_last_line_number : ' || l_last_line_number);
9200:
9201: UPDATE pon_auction_headers_all
9202: SET number_of_lines = l_number_of_lines, LAST_LINE_NUMBER = l_last_line_number
9203: WHERE
9204: AUCTION_HEADER_ID = l_auction_header_id;
9205:
9202: SET number_of_lines = l_number_of_lines, LAST_LINE_NUMBER = l_last_line_number
9203: WHERE
9204: AUCTION_HEADER_ID = l_auction_header_id;
9205:
9206: LOG_MESSAGE('copy_lines_and_children','Updated NUMBER_OF_LINES and LAST_LINE_NUMBER fields in PON_AUCTION_HEADERS_ALL');
9207:
9208: --
9209: -- Now get message count to initialize the OUT variable (x_msg_count)
9210: --
9276: l_pref_pf_unused_3 VARCHAR2(300);
9277:
9278: l_temp_labor_count NUMBER;
9279:
9280: l_default_currency_code PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE;
9281: l_default_rate_type PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE;
9282:
9283:
9284: BEGIN
9277:
9278: l_temp_labor_count NUMBER;
9279:
9280: l_default_currency_code PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE;
9281: l_default_rate_type PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE;
9282:
9283:
9284: BEGIN
9285:
9973: t_record.FIRST_LINE_CLOSE_DATE,
9974: t_record.STAGGERED_CLOSING_INTERVAL,
9975: t_record.QTY_PRICE_TIERS_ENABLED_FLAG,
9976: t_record.PRICE_TIERS_INDICATOR
9977: FROM PON_AUCTION_HEADERS_ALL A,
9978: PON_AUC_BIZRULES BID_VISIB,
9979: PON_AUC_DOCTYPE_RULES R_BID_VISIB,
9980: PON_AUC_BIZRULES BID_SCOPE,
9981: PON_AUC_DOCTYPE_RULES R_BID_SCOPE,
10349: IS
10350: l_source_doc_id NUMBER;
10351: l_auction_header_id NUMBER;
10352: l_contracts_doctype VARCHAR2(60);
10353: l_site_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
10354: l_auc_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
10355: l_keep_version VARCHAR2(1);
10356: l_return_status VARCHAR2(1);
10357: l_msg_data VARCHAR2(400);
10350: l_source_doc_id NUMBER;
10351: l_auction_header_id NUMBER;
10352: l_contracts_doctype VARCHAR2(60);
10353: l_site_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
10354: l_auc_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
10355: l_keep_version VARCHAR2(1);
10356: l_return_status VARCHAR2(1);
10357: l_msg_data VARCHAR2(400);
10358: l_msg_count NUMBER;
10360: l_error_message VARCHAR2(400);
10361: l_is_reset_contracts VARCHAR2(1);
10362: l_copy_for_amendment VARCHAR2(1);
10363: l_po_doctype VARCHAR2(50);
10364: l_conterms_exist_flag pon_auction_headers_all.conterms_exist_flag%TYPE;
10365: l_copy_abstract_yn VARCHAR2(1);
10366: l_old_org_id NUMBER;
10367: l_old_policy VARCHAR2(2);
10368:
10603: --
10604: -- Header Attachments copy
10605: --
10606: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
10607: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
10608: X_from_pk1_value => to_char(p_source_auction_header_id),
10609: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
10610: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
10611: X_created_by => p_user_id, -- CREATED_BY
10605: --
10606: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
10607: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
10608: X_from_pk1_value => to_char(p_source_auction_header_id),
10609: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
10610: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
10611: X_created_by => p_user_id, -- CREATED_BY
10612: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
10613: );
10753: HDR_ATTRIBUTE_ENABLED_FLAG, NEG_TEAM_ENABLED_FLAG, PROXY_BIDDING_ENABLED_FLAG,
10754: POWER_BIDDING_ENABLED_FLAG, AUTO_EXTEND_ENABLED_FLAG, TEAM_SCORING_ENABLED_FLAG,
10755: QTY_PRICE_TIERS_ENABLED_FLAG
10756: INTO g_neg_style_raw
10757: FROM PON_AUCTION_HEADERS_ALL
10758: WHERE auction_header_id = p_source_auction_header_id;
10759: EXCEPTION
10760: WHEN NO_DATA_FOUND THEN
10761: FND_MESSAGE.SET_NAME('PON','PON_INVALID_NEG_NUM');
10963: p_from_line_number IN NUMBER,
10964: p_to_line_number IN NUMBER)
10965: is
10966:
10967: l_current_status pon_auction_headers_all.auction_status%type;
10968: l_is_large_neg_enabled pon_auction_headers_all.LARGE_NEG_ENABLED_FLAG%type;
10969: BEGIN
10970: --{ start of PON_LRG_DRAFT_TO_ORD_PF_COPY
10971: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY',
10964: p_to_line_number IN NUMBER)
10965: is
10966:
10967: l_current_status pon_auction_headers_all.auction_status%type;
10968: l_is_large_neg_enabled pon_auction_headers_all.LARGE_NEG_ENABLED_FLAG%type;
10969: BEGIN
10970: --{ start of PON_LRG_DRAFT_TO_ORD_PF_COPY
10971: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY',
10972: 'Entered the procedure with p_source_auction_hdr_id : ' || p_source_auction_hdr_id ||
10980:
10981: select large_neg_enabled_flag, auction_status
10982: into l_is_large_neg_enabled, l_current_status
10983: from
10984: pon_auction_headers_all
10985: where
10986: auction_header_id = p_source_auction_hdr_id;
10987: if l_is_large_neg_enabled = 'Y' then
10988:
11207: p_large_auction_header_id IN NUMBER,
11208: p_style_id IN NUMBER)
11209: IS
11210: l_auction_header_id NUMBER;
11211: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11212: l_return_status VARCHAR2(1);
11213: l_msg_count NUMBER;
11214: l_msg_data VARCHAR2(400);
11215: l_request_id NUMBER := NULL;
11260: --get the request id for the new auction
11261: --for workflow calls
11262: --
11263: select request_id into l_request_id
11264: from pon_auction_headers_all
11265: where auction_header_id = p_large_auction_header_id;
11266:
11267:
11268: if l_return_status = 'E' then
11292: --concurrent program has to be shown to the user
11293: --
11294: --Ref: ECO - 4517992
11295: --
11296: -- update pon_auction_headers_all
11297: -- set request_id = null
11298: -- where auction_header_id = p_large_auction_header_id;
11299: --commit this updation
11300: -- commit;
11320: p_ProgramTypeCode => l_program_type_code,
11321: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
11322: p_bid_number => NULL);
11323:
11324: select document_number into l_source_doc_num from pon_auction_headers_all where auction_Header_id = p_source_auction_header_id;
11325:
11326: insert into pon_interface_errors (
11327: ERROR_MESSAGE_NAME,
11328: request_id,
11388: -- check if the source auction has any scoring teams
11389: -- if it does not, do not do anything
11390: SELECT has_scoring_teams_flag
11391: INTO l_source_has_scoring_teams
11392: FROM pon_auction_headers_all
11393: WHERE auction_header_id = p_source_auction_header_id;
11394:
11395: IF l_source_has_scoring_teams <> 'Y' THEN
11396: RETURN;