[Home] [Help]
46: --
47: g_has_inactive_pe_flag VARCHAR2(1);
48:
49: -- Global variable to hold the Document Number variable
50: g_neg_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
51:
52: -- Global variable for message sufix
53: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
54:
52: -- Global variable for message sufix
53: g_message_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
54:
55: -- Global variable for auction_origination_code
56: g_auc_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
57:
58: -- Global variable for Rate Based Temp Labor line type
59: g_temp_labor CONSTANT VARCHAR2(10) := 'TEMP LABOR';
60:
61: -- Global variable for inactive attribute message flag
62: g_added_inactv_attr_grp_msg VARCHAR2(1);
63:
64: g_source_doc_id NUMBER;
65: g_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
66: g_source_doc_int_name VARCHAR2(50);
67:
68: -- flag to know if lot/lot line/group/group line is deleted (due to style)
69: g_line_deleted VARCHAR2(1);
385: FUNCTION GET_REVISION_NUMBER(p_auction_header_id IN NUMBER) RETURN NUMBER;
386:
387: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
388:
389: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
386:
387: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
388:
389: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
387: TYPE AUC_HDR_TYPE_BASE_DATA IS RECORD (
388:
389: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
388:
389: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
389: BID_VISIBILITY_CODE PON_AUCTION_HEADERS_ALL.BID_VISIBILITY_CODE%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
390: BID_SCOPE_CODE PON_AUCTION_HEADERS_ALL.BID_SCOPE_CODE%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
391: CONTRACT_TYPE PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
392: PO_START_DATE PON_AUCTION_HEADERS_ALL.PO_START_DATE%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
393: PO_END_DATE PON_AUCTION_HEADERS_ALL.PO_END_DATE%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
394: PO_AGREED_AMOUNT PON_AUCTION_HEADERS_ALL.PO_AGREED_AMOUNT%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
395: MANUAL_CLOSE_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_CLOSE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
396: MANUAL_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.MANUAL_EXTEND_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
397: SHOW_BIDDER_NOTES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_NOTES%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
398: MULTIPLE_ROUNDS_FLAG PON_AUCTION_HEADERS_ALL.MULTIPLE_ROUNDS_FLAG%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
399: AUTO_EXTEND_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_FLAG%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
400: AUTO_EXTEND_ALL_LINES_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_ALL_LINES_FLAG%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
401: AUTO_EXTEND_MIN_TRIGGER_RANK PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_MIN_TRIGGER_RANK%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
402: AUTO_EXTEND_DURATION PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_DURATION%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
403: AUTO_EXTEND_TYPE_FLAG PON_AUCTION_HEADERS_ALL.AUTO_EXTEND_TYPE_FLAG%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
404: GLOBAL_AGREEMENT_FLAG PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
405: PO_MIN_REL_AMOUNT PON_AUCTION_HEADERS_ALL.PO_MIN_REL_AMOUNT%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
406: EVENT_ID PON_AUCTION_HEADERS_ALL.EVENT_ID%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
407: EVENT_TITLE PON_AUCTION_HEADERS_ALL.EVENT_TITLE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
408: BID_RANKING PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
409: BILL_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
410: SHIP_TO_LOCATION_ID PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
411: CARRIER_CODE PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE,
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
412: FREIGHT_TERMS_CODE PON_AUCTION_HEADERS_ALL.FREIGHT_TERMS_CODE%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
413: FOB_CODE PON_AUCTION_HEADERS_ALL.FOB_CODE%TYPE,
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
414: BID_LIST_TYPE PON_AUCTION_HEADERS_ALL.BID_LIST_TYPE%TYPE,
415: BID_FREQUENCY_CODE PON_AUCTION_HEADERS_ALL.BID_FREQUENCY_CODE%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
422: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
416: FULL_QUANTITY_BID_CODE PON_AUCTION_HEADERS_ALL.FULL_QUANTITY_BID_CODE%TYPE,
417: RANK_INDICATOR PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
422: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
423: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
424: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
418: SHOW_BIDDER_SCORES PON_AUCTION_HEADERS_ALL.SHOW_BIDDER_SCORES%TYPE,
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
422: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
423: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
424: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
425: ALLOW_PRICE_ELEMENT VARCHAR2(1),
426: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
419:
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
422: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
423: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
424: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
425: ALLOW_PRICE_ELEMENT VARCHAR2(1),
426: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
427: START_PRICE VARCHAR2(1),
420: PF_TYPE_ALLOWED PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE,
421:
422: PRICE_DRIVEN_AUCTION_FLAG PON_AUCTION_HEADERS_ALL.PRICE_DRIVEN_AUCTION_FLAG%TYPE,
423: MIN_BID_CHANGE_TYPE PON_AUCTION_HEADERS_ALL.MIN_BID_CHANGE_TYPE%TYPE,
424: PAYMENT_TERMS_ID PON_AUCTION_HEADERS_ALL.PAYMENT_TERMS_ID%TYPE,
425: ALLOW_PRICE_ELEMENT VARCHAR2(1),
426: NO_PRICE_QTY_ITEMS_POSSIBLE VARCHAR2(1),
427: START_PRICE VARCHAR2(1),
428: RESERVE_PRICE VARCHAR2(1),
432: PRICE_BREAK VARCHAR2(1),
433: ALLOW_PRICE_DIFFERENTIAL VARCHAR2(1),
434: NUMBER_OF_BIDS NUMBER,
435: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
436: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
433: ALLOW_PRICE_DIFFERENTIAL VARCHAR2(1),
434: NUMBER_OF_BIDS NUMBER,
435: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
436: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
434: NUMBER_OF_BIDS NUMBER,
435: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
436: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
435: AWARD_TYPE_RULE_FIXED_VALUE VARCHAR2(20),
436: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
436: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
437: RATE_TYPE PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE,
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
445: ALLOW_STAGGERED_AWARDS PON_AUCTION_HEADERS_ALL.ALLOW_STAGGERED_AWARDS%TYPE
438: FIRST_LINE_CLOSE_DATE PON_AUCTION_HEADERS_ALL.FIRST_LINE_CLOSE_DATE%TYPE,
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
445: ALLOW_STAGGERED_AWARDS PON_AUCTION_HEADERS_ALL.ALLOW_STAGGERED_AWARDS%TYPE
446: );
439: STAGGERED_CLOSING_INTERVAL PON_AUCTION_HEADERS_ALL.STAGGERED_CLOSING_INTERVAL%TYPE,
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
445: ALLOW_STAGGERED_AWARDS PON_AUCTION_HEADERS_ALL.ALLOW_STAGGERED_AWARDS%TYPE
446: );
447:
440: PRICE_TIERS_INDICATOR PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE,
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
445: ALLOW_STAGGERED_AWARDS PON_AUCTION_HEADERS_ALL.ALLOW_STAGGERED_AWARDS%TYPE
446: );
447:
448: --
441: QTY_PRICE_TIERS_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.QTY_PRICE_TIERS_ENABLED_FLAG%TYPE,
442: ALLOW_UNSOL_OFFER_LINES PON_AUCTION_HEADERS_ALL.ALLOW_UNSOL_OFFER_LINES%TYPE,
443: ALLOW_WITHDRAW_FLAG PON_AUCTION_HEADERS_ALL.ALLOW_WITHDRAW_FLAG%TYPE,
444: ALLOW_MULTIPLE_ACTIVE_OFFERS PON_AUCTION_HEADERS_ALL.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE,
445: ALLOW_STAGGERED_AWARDS PON_AUCTION_HEADERS_ALL.ALLOW_STAGGERED_AWARDS%TYPE
446: );
447:
448: --
449: -- This variable will be used access the doctype based bizrule data accross different procedure.
454:
455:
456: TYPE NEG_STYLE_DATA IS RECORD (
457:
458: style_id pon_auction_headers_all.style_id%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
455:
456: TYPE NEG_STYLE_DATA IS RECORD (
457:
458: style_id pon_auction_headers_all.style_id%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
456: TYPE NEG_STYLE_DATA IS RECORD (
457:
458: style_id pon_auction_headers_all.style_id%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
457:
458: style_id pon_auction_headers_all.style_id%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
458: style_id pon_auction_headers_all.style_id%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
459: line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
460: line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
461: price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
462: rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
463: lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
464: group_enabled_flag pon_auction_headers_all.group_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
465: large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%type,
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
466: hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%type,
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
467: neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
468: proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%type,
469: power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%type,
470: auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
471: team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
472: qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
473:
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
474: -- Begin Supplier Management: Bug 8993731
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
475: supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
476: supp_eval_flag pon_auction_headers_all.supp_eval_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
477: hide_terms_flag pon_auction_headers_all.hide_terms_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
478: hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
479: hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
480: internal_eval_flag pon_auction_headers_all.internal_eval_flag%type,
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
488: intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%type
481: hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%type,
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
488: intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%type
489: -- End Supplier Management: Bug 8993731
482: intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%type,
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
488: intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%type
489: -- End Supplier Management: Bug 8993731
490:
483: intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%type,
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
488: intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%type
489: -- End Supplier Management: Bug 8993731
490:
491: );
484: line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%type,
485: item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%type,
486: intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%type,
487: intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%type,
488: intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%type
489: -- End Supplier Management: Bug 8993731
490:
491: );
492:
496: -- this variable stores reconciled style settings, it's used to control copy routines
497: g_neg_style_control NEG_STYLE_DATA;
498:
499:
500: g_price_break_response pon_auction_headers_all.price_break_response%type;
501:
502: FUNCTION GET_HDR_CROSS_COPY_DATA ( p_source_auction_header_id IN NUMBER,
503: p_auction_header_id IN NUMBER,
504: p_doctype_id IN NUMBER,
689: l_last_amendment_number NUMBER := 0;
690: l_org_id NUMBER := 0;
691: l_round_number NUMBER := 0;
692: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
693: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
694: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
695:
696: --This variable is used to store the document number of the new auction
697: --that is created by the COPY_HEADER procedure
690: l_org_id NUMBER := 0;
691: l_round_number NUMBER := 0;
692: l_source_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
693: l_source_auc_orig_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
694: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
695:
696: --This variable is used to store the document number of the new auction
697: --that is created by the COPY_HEADER procedure
698: l_new_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
694: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
695:
696: --This variable is used to store the document number of the new auction
697: --that is created by the COPY_HEADER procedure
698: l_new_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
699: l_is_amendment VARCHAR2(20);
700: l_error_code_update VARCHAR2(2000);
701: l_error_msg_update VARCHAR2(2000);
702:
729: /* Sol Project : For Super large negotiations
730: 'Y' : If p_copy_type = g_conformed_doc_copy and approval_status = 'NOT_REQUIRED'
731: */
732: l_is_conf_cpy_pub_flow VARCHAR2(1) := 'N';
733: l_approval_status PON_AUCTION_HEADERS_ALL.APPROVAL_STATUS%TYPE;
734:
735: BEGIN
736:
737: -- { Beginning of COPY_NEGOTIATION
760: --If it is -1, then the styleId of the source auction
761: --has to be retained
762: --
763: if nvl(p_style_id,-1) < 0 then
764: select style_id into l_style_id from pon_auction_headers_all
765: where auction_header_id = p_source_auction_header_id;
766: else
767: l_style_id := p_style_id;
768: end if;
834: IF p_copy_type = g_conformed_doc_copy THEN
835:
836: select approval_status
837: into l_approval_status
838: from pon_auction_headers_all
839: where
840: auction_header_id = p_source_auction_header_id;
841:
842: IF l_approval_status = 'NOT_REQUIRED' THEN
878: RAISE FND_API.G_EXC_ERROR;*/
879: --
880: -- Get the company name for the given trading_partner_id
881: -- The resultant company name will be used in the trading partner
882: --name column of PON_AUCTION_HEADERS_ALL table
883: --
884: BEGIN
885: SELECT PARTY_NAME
886: INTO l_tp_name
951: LOG_MESSAGE('copy_negotiation','Locking the header');
952:
953: SELECT auction_header_id
954: INTO l_locked_auction_header_id
955: FROM pon_auction_headers_all
956: WHERE auction_header_id = p_source_auction_header_id
957: FOR UPDATE;
958:
959: -- Check if the there are already new rounds or
969: LOG_MESSAGE('copy_negotiation','Checking for multiple new rounds');
970:
971: select count(auction_header_id)
972: into l_newround_amendment_count
973: from pon_auction_headers_all
974: where auction_header_id_prev_round = p_source_auction_header_id;
975: LOG_MESSAGE('copy_negotiation','l_newround_amendment_count : ' || l_newround_amendment_count);
976:
977: if l_newround_amendment_count <> 0 then
988: LOG_MESSAGE('copy_negotiation','Checking for multiple new rounds or amendments');
989:
990: select count(auction_header_id)
991: into l_newround_amendment_count
992: from pon_auction_headers_all
993: where auction_header_id_prev_amend = p_source_auction_header_id;
994:
995: LOG_MESSAGE('copy_negotiation','l_newround_amendment_count : ' || l_newround_amendment_count);
996:
1004: end if;
1005: elsif p_copy_type = g_conformed_doc_copy then
1006:
1007: LOG_MESSAGE('conform_amendment','Checking for multiple conformed documents');
1008: select auction_header_id_prev_amend into l_source_orig_amend_id from pon_auction_headers_all
1009: where auction_header_id = p_source_auction_header_id;
1010:
1011: select count(auction_header_id)
1012: into l_newround_amendment_count
1009: where auction_header_id = p_source_auction_header_id;
1010:
1011: select count(auction_header_id)
1012: into l_newround_amendment_count
1013: from pon_auction_headers_all
1014: where auction_header_id_prev_amend = l_source_orig_amend_id and nvl(amendment_flag,'N') = 'N';
1015:
1016: LOG_MESSAGE('copy_negotiation','l_newround_amendment_count : ' || l_newround_amendment_count);
1017:
1058: A.PRICE_BREAK_RESPONSE
1059: INTO l_source_doctype_id, l_source_orig_round_id, l_source_prev_round_id, l_round_number,
1060: l_last_amendment_number, l_source_orig_amend_id, l_org_id, l_source_doctype_grp_name,
1061: g_message_suffix, l_source_auc_orig_code,l_source_doc_num, g_price_break_response
1062: FROM PON_AUCTION_HEADERS_ALL A, PON_AUC_DOCTYPES D
1063: WHERE auction_header_id = p_source_auction_header_id AND D.DOCTYPE_ID = A.DOCTYPE_ID ;
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN
1066: -- The way I am adding this error may get changed in the future.
1104: then
1105: --
1106: -- Get the new auction_header_id for the new negotiation document
1107: -- from
1108: -- the PON_AUCTION_HEADERS_ALL_S sequence
1109: --
1110: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1111: INTO l_auction_header_id
1112: FROM DUAL;
1106: -- Get the new auction_header_id for the new negotiation document
1107: -- from
1108: -- the PON_AUCTION_HEADERS_ALL_S sequence
1109: --
1110: SELECT PON_AUCTION_HEADERS_ALL_S.NEXTVAL
1111: INTO l_auction_header_id
1112: FROM DUAL;
1113: --
1114: --Initialise global variables here
1219:
1220: LOG_MESSAGE('copy_negotiation','Copied the header with document number : '||l_new_doc_number);
1221: --
1222: -- if it is a super large auction, then initiate a concurrent
1223: -- request, update the PON_AUCTION_HEADERS_ALL and return with a
1224: -- CONC_REQ_SUBMITTED status
1225: --
1226:
1227: -- Sol Project : Added condition l_is_conf_cpy_pub_flow = 'N'
1254: argument16 => to_char(l_auction_header_id),
1255: argument17 => to_char(l_style_id));
1256:
1257: g_err_loc := '3. Before submitting the concurrent request';
1258: --update the pon_auction_headers_all table
1259: --
1260: update pon_auction_headers_all set
1261: request_id = l_request_id,
1262: requested_by = p_user_id,
1256:
1257: g_err_loc := '3. Before submitting the concurrent request';
1258: --update the pon_auction_headers_all table
1259: --
1260: update pon_auction_headers_all set
1261: request_id = l_request_id,
1262: requested_by = p_user_id,
1263: request_date = sysdate,
1264: last_update_date = sysdate,
1380: -- internal name if it is copy from RFI to Auction/RFQ. Set it to NULL
1381: -- for the active negotiation copy. Carry it in all other cases
1382: IF (p_copy_type = g_rfi_to_other_copy) THEN
1383: SELECT INTERNAL_NAME INTO l_source_doc_internal_name
1384: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1385: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1386: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1387: g_auc_origination_code := l_source_doc_internal_name;
1388: ELSIF (p_copy_type = g_active_neg_copy) THEN
1398: /*IF ( p_copy_type = g_conformed_doc_copy ) THEN
1399: LOG_MESSAGE('copy negotiation','Marking Amendment as APPLIED for Federal CLM');
1400:
1401:
1402: update pon_auction_headers_all
1403: set AUCTION_STATUS = 'APPLIED'
1404: where auction_header_id = p_source_auction_header_id;
1405: l_copy_type := g_amend_copy;
1406: END IF;*/
1435: x_msg_data => x_msg_data
1436: );
1437:
1438: --
1439: -- Set the COMPLETE_FLAG for this acution in PON_AUCTION_HEADERS_ALL
1440: -- to 'Y' since the auction has been copied successfully
1441: --
1442: update pon_auction_headers_all set
1443: complete_flag = 'Y'
1438: --
1439: -- Set the COMPLETE_FLAG for this acution in PON_AUCTION_HEADERS_ALL
1440: -- to 'Y' since the auction has been copied successfully
1441: --
1442: update pon_auction_headers_all set
1443: complete_flag = 'Y'
1444: where auction_header_id = l_auction_header_id;
1445:
1446: end if;
1463:
1464: --
1465: -- Bug# 5591755
1466: --This exception block is to release the lock put on the row
1467: --in pon_auction_headers_all for p_auction_header_id
1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: ROLLBACK TO PON_NEGOTIATION_COPY_GRP;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1586: l_init_msg_list VARCHAR2(1) := 'T';
1587: l_is_conc_call VARCHAR2(1) := 'F';
1588: l_large_auction_header_id NUMBER := -1;
1589:
1590: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1591: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1587: l_is_conc_call VARCHAR2(1) := 'F';
1588: l_large_auction_header_id NUMBER := -1;
1589:
1590: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1591: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1588: l_large_auction_header_id NUMBER := -1;
1589:
1590: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1591: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id
1589:
1590: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1591: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id
1597: l_user_id FND_USER.USER_ID%TYPE;
1590: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1591: l_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id
1597: l_user_id FND_USER.USER_ID%TYPE;
1598: l_user_name FND_USER.USER_NAME%TYPE;
1592: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1593: l_is_award_approval_reqd PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_FLAG%TYPE;
1594: l_style_id PON_AUCTION_HEADERS_ALL.STYLE_ID%TYPE;
1595: l_mgr_id FND_USER.USER_ID%TYPE;
1596: -- user id is derived from pon_auction_headers_all instead of using fnd_global.user_id
1597: l_user_id FND_USER.USER_ID%TYPE;
1598: l_user_name FND_USER.USER_NAME%TYPE;
1599:
1600: -- Bug:9954903-start
1598: l_user_name FND_USER.USER_NAME%TYPE;
1599:
1600: -- Bug:9954903-start
1601: l_return_value number;
1602: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1603: l_src_rev_num PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
1604: l_pdfFileName varchar2(300);
1605: -- Bug:9954903-end
1606: BEGIN
1599:
1600: -- Bug:9954903-start
1601: l_return_value number;
1602: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1603: l_src_rev_num PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
1604: l_pdfFileName varchar2(300);
1605: -- Bug:9954903-end
1606: BEGIN
1607:
1611: AWARD_APPROVAL_FLAG,STYLE_ID,CREATED_BY, DOCUMENT_NUMBER
1612: INTO l_trading_partner_id,l_trading_partner_contact_id,
1613: l_doctype_id,l_is_award_approval_reqd,l_style_id,l_user_id,
1614: l_doc_number
1615: FROM PON_AUCTION_HEADERS_ALL
1616: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
1617:
1618: SELECT USER_NAME INTO l_user_name
1619: FROM FND_USER
1768: x_document_number OUT NOCOPY VARCHAR2
1769: )
1770: IS
1771: l_contracts_doctype VARCHAR2(50);
1772: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1773: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1774: l_return_value NUMBER;
1775: BEGIN --{ Start of COPY_HEADER
1776:
1769: )
1770: IS
1771: l_contracts_doctype VARCHAR2(50);
1772: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1773: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1774: l_return_value NUMBER;
1775: BEGIN --{ Start of COPY_HEADER
1776:
1777: --
1805: x_document_number := l_document_number;
1806:
1807: g_err_loc := '1.11 Going to create discussions record';
1808: l_return_value := PON_THREAD_DISC_PKG.insert_pon_discussions(
1809: p_entity_name => 'PON_AUCTION_HEADERS_ALL',
1810: p_entity_pk1 => p_auction_header_id,
1811: p_entity_pk2 => '',
1812: p_entity_pk3 => '',
1813: p_entity_pk4 => '',
1889: x_document_number OUT NOCOPY VARCHAR2
1890: )
1891: IS
1892: l_is_succession CHAR(1);
1893: l_source_doc_number pon_auction_Headers_all.document_number%TYPE := NULL;
1894: l_source_doc_id NUMBER := NULL;
1895: l_source_doc_msg_app VARCHAR2(4) := NULL;
1896: l_source_doc_msg VARCHAR2(30) := NULL;
1897: l_source_doc_msg_suffix VARCHAR2(2) := NULL;
1902: l_auction_header_id_prev_round NUMBER;
1903: l_auction_round_number NUMBER;
1904: l_last_amendment_number NUMBER;
1905: l_copy_buyer_id VARCHAR2(1);
1906: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1907: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1908: l_contract_terms_exisits VARCHAR2(2);
1909: l_contract_doctype VARCHAR2(50);
1910: l_is_award_approval_reqd VARCHAR2(2);
1903: l_auction_round_number NUMBER;
1904: l_last_amendment_number NUMBER;
1905: l_copy_buyer_id VARCHAR2(1);
1906: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1907: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1908: l_contract_terms_exisits VARCHAR2(2);
1909: l_contract_doctype VARCHAR2(50);
1910: l_is_award_approval_reqd VARCHAR2(2);
1911: l_destination_doctype_grp_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1934: --
1935: l_is_document_federal NUMBER;
1936:
1937: -- clm printing project
1938: l_standard_form pon_auction_headers_all.standard_form%TYPE;
1939: l_document_format pon_auction_headers_all.document_format%TYPE;
1940:
1941: l_template_id NUMBER;
1942: l_doc_number VARCHAR2(50);
1935: l_is_document_federal NUMBER;
1936:
1937: -- clm printing project
1938: l_standard_form pon_auction_headers_all.standard_form%TYPE;
1939: l_document_format pon_auction_headers_all.document_format%TYPE;
1940:
1941: l_template_id NUMBER;
1942: l_doc_number VARCHAR2(50);
1943: l_err_msg VARCHAR2(2000);
1973: IF ( p_copy_type = g_rfi_to_other_copy) THEN
1974: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1975: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1976: l_source_doc_number
1977: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1978: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
1979: AND AUCTION_HEADER_ID = p_source_auction_header_id;
1980:
1981: LOG_MESSAGE('copy_negotiation','1.1.0.1 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);
1994: IF ( p_copy_type = g_new_rnd_copy AND p_doctype_id <> p_source_doctype_id) THEN
1995: SELECT INTERNAL_NAME, MESSAGE_SUFFIX , DOCUMENT_NUMBER
1996: INTO l_source_doc_internal_name, l_source_doc_msg_suffix,
1997: l_source_doc_number
1998: FROM PON_AUC_DOCTYPES P, PON_AUCTION_HEADERS_ALL A
1999: WHERE P.DOCTYPE_ID = A.DOCTYPE_ID
2000: AND AUCTION_HEADER_ID = p_source_auction_header_id;
2001:
2002: LOG_MESSAGE('copy_negotiation','1.1.0.2 --- Starting Copy Header Basic. l_source_doc_msg_suffix:'||l_source_doc_msg_suffix);
2125: ELSIF (p_copy_type = g_conformed_doc_copy) THEN
2126:
2127: SELECT prev.standard_form, prev.document_format
2128: INTO l_standard_form, l_document_format
2129: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2130: WHERE pah.auction_header_id = p_source_auction_header_id
2131: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;
2132:
2133: /* Bug : 16560215 : When copying draft amendments, standard form and
2136: ELSIF (p_copy_type = g_draft_neg_copy) THEN
2137:
2138: SELECT prev.standard_form, prev.document_format
2139: INTO l_standard_form, l_document_format
2140: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2141: WHERE pah.auction_header_id = p_source_auction_header_id
2142: AND Nvl(pah.amendment_flag, 'N') = 'Y'
2143: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;
2144:
2157:
2158: -- If multiround document
2159: IF (l_auction_round_number IS NOT NULL AND l_auction_round_number > 1) THEN
2160: begin
2161: select document_number into l_orig_document_number from pon_auction_headers_all where auction_header_id = l_auction_header_id_orig_round;
2162: exception
2163: when others then
2164: l_orig_document_number := l_auction_header_id_orig_round;
2165: end;
2190: ELSIF ( l_last_amendment_number > 0 ) THEN -- a first round negotiation that has been amended
2191: IF ( p_copy_type = g_conformed_doc_copy ) THEN
2192: --
2193: begin
2194: select document_number into l_document_number from pon_auction_headers_all where auction_header_id = p_source_orig_amend_id;
2195: exception
2196: when others then
2197: l_document_number := p_source_orig_amend_id;
2198: end;
2520: LOG_MESSAGE('copy_negotiation','Default Enforce Min Bid Price Across Rounds:'||l_MinBidPriceVal1);
2521: END IF;
2522: -- end enforce bid price flag code.
2523:
2524: g_err_loc := '1.3 Going to insert data into PON_AUCTION_HEADERS_ALL';
2525:
2526: INSERT INTO PON_AUCTION_HEADERS_ALL
2527: ( AUCTION_HEADER_ID,
2528: AUCTION_TITLE,
2522: -- end enforce bid price flag code.
2523:
2524: g_err_loc := '1.3 Going to insert data into PON_AUCTION_HEADERS_ALL';
2525:
2526: INSERT INTO PON_AUCTION_HEADERS_ALL
2527: ( AUCTION_HEADER_ID,
2528: AUCTION_TITLE,
2529: AUCTION_STATUS,
2530: AUCTION_STATUS_NAME,
3335: g_new_rnd_copy, FEDERAL_PUBLICATION_EXCEPTION,
3336: NULL), -- FBO bug 13445860, 13450752
3337: t_record.ALLOW_MULTIPLE_ACTIVE_OFFERS, --Copy Allow multiple active offers flag from base doc
3338: t_record.ALLOW_STAGGERED_AWARDS --Copy Allow staggered awards flag from base doc
3339: FROM PON_AUCTION_HEADERS_ALL
3340: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
3341:
3342: /* Modified for CLM QA bug : 8831577
3343: * Set Revision to zero in case of creating new round/copying active or draft document.
3350: l_Revision_Number := 0;
3351: END IF;
3352: END IF;
3353: LOG_MESSAGE('copy Header Basic','Updating Revision Number for Federal CLM');
3354: update pon_auction_headers_all
3355: set revision = l_Revision_Number
3356: where auction_header_id = p_auction_header_id;
3357:
3358: --
4272:
4273: IF p_copy_type = g_conformed_doc_copy THEN
4274: select auction_header_id_prev_amend
4275: into l_source_prev_amend_id
4276: from pon_auction_headers_all
4277: where auction_header_id = p_source_auction_header_id;
4278:
4279: FOR base_attach_rec IN
4280: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE
4721: -- BPA as it can be BPA or CPA and user can choose them on the Creation
4722: -- Header page
4723: --
4724: IF (l_has_temp_labor_lines = 'Y') THEN
4725: UPDATE PON_AUCTION_HEADERS_ALL
4726: SET GLOBAL_AGREEMENT_FLAG = 'Y'
4727: WHERE AUCTION_HEADER_ID = p_auction_header_id;
4728: END IF;
4729: END;
4848: l_scoring_method PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
4849:
4850: l_has_inactv_hdr_attr_grp VARCHAR2(1);
4851:
4852: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
4853:
4854: BEGIN
4855: --{ Start of COPY_HEADER_ATTRIBUTE
4856:
5131:
5132: l_temp VARCHAR2(300);
5133: l_has_inactv_hdr_attr_grp VARCHAR2(1);
5134:
5135: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
5136:
5137: BEGIN
5138: --{ Start of COPY_LINE_ATTRIBUTE
5139:
5466: -- Synch up descriptors when copying
5467: -- only update descriptor name and remove dropped descriptors
5468: SELECT contract_type
5469: INTO l_contract_type
5470: FROM pon_auction_headers_all
5471: WHERE auction_header_id = p_auction_header_id;
5472:
5473: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
5474: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
5994: l_keep_effective_end_date := 'Y';
5995:
5996: SELECT price_tiers_indicator
5997: INTO l_src_price_tiers_indicator
5998: FROM pon_auction_headers_all
5999: WHERE auction_header_id = p_source_auction_header_id;
6000:
6001: --
6002: -- Should copy only when Price Breaks are allowed for the
6348: l_from_emd_flag PON_NEG_COPY_DATATYPES_GRP.VARCHAR1_TYPE; -- Added by Lion for EMD 04/02/2009
6349: -- bug 7376924, handling inactive supplier contact
6350: l_inactive_supplier_contacts PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6351:
6352: l_auction_header_id_orig_amend PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID_ORIG_AMEND%type;
6353:
6354: BEGIN
6355: -- { Start of COPY_INVITEES
6356:
6372: END IF;
6373:
6374: SELECT AUCTION_HEADER_ID_ORIG_AMEND
6375: INTO l_auction_header_id_orig_amend
6376: FROM PON_AUCTION_HEADERS_ALL
6377: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
6378:
6379: --
6380: -- For Copy Negotiation and Amendment
6887: FROM PON_BID_HEADERS PBH
6888: WHERE PBH.SHORTLIST_FLAG = 'N'
6889: AND PBH.AUCTION_HEADER_ID IN
6890: (SELECT AUCTION_HEADER_ID
6891: FROM PON_AUCTION_HEADERS_ALL
6892: WHERE AUCTION_HEADER_ID_ORIG_AMEND =
6893: l_auction_header_id_orig_amend)
6894: AND PBH.BID_STATUS IN('ACTIVE','RESUBMISSION'))
6895: AND PBP.TRADING_PARTNER_ID = PV.PARTY_ID
6981: FROM PON_BID_HEADERS PBH
6982: WHERE PBH.SHORTLIST_FLAG <> 'N'
6983: AND PBH.AUCTION_HEADER_ID IN
6984: (SELECT AUCTION_HEADER_ID
6985: FROM PON_AUCTION_HEADERS_ALL
6986: WHERE AUCTION_HEADER_ID_ORIG_AMEND =
6987: l_auction_header_id_orig_amend
6988: )
6989: AND PBH.BID_STATUS IN ('ACTIVE', 'RESUBMISSION')
7345: FND_USER U,
7346: PER_ALL_PEOPLE_F P,
7347: PER_ALL_ASSIGNMENTS_F A,
7348: PER_ALL_POSITIONS S,
7349: PON_AUCTION_HEADERS_ALL AH,
7350: FINANCIALS_SYSTEM_PARAMS_ALL F
7351: WHERE U.USER_ID = PNTM.USER_ID
7352: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
7353: AND AH.AUCTION_HEADER_ID = PNTM.AUCTION_HEADER_ID
7922: p_user_id,
7923: XML_LAST_SENT_DATE
7924: FROM PON_FORMS_SECTIONS FS,
7925: PON_FORMS_INSTANCES FI
7926: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7927: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7928: AND FI.FORM_ID = FS.FORM_ID
7929: AND FS.STATUS = 'ACTIVE');
7930:
7965: p_user_id,
7966: NULL
7967: FROM PON_FORMS_INSTANCES FI,
7968: PON_FORMS_SECTIONS FS
7969: WHERE ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7970: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7971: AND FI.FORM_ID = FS.FORM_ID
7972: AND FS.STATUS = 'ACTIVE'
7973: AND (Nvl(l_is_Federal,0)<>1 OR FS.FORM_CODE='ABSTRACT' ));
7980: INTO
7981: l_inactive_sections
7982: FROM PON_FORMS_INSTANCES FI,
7983: PON_FORMS_SECTIONS FS
7984: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7985: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7986: AND FI.FORM_ID = FS.FORM_ID
7987: AND FS.STATUS = 'INACTIVE'
7988: AND (Nvl(l_is_Federal,0)<>1 OR FS.FORM_CODE='ABSTRACT' ); -- FedBizOpps changes
8031: SELECT
8032: FI.FORM_ID
8033: FROM PON_FORMS_INSTANCES FI,
8034: PON_FORMS_SECTIONS FS
8035: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8036: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8037: AND FI.FORM_ID = FS.FORM_ID
8038: AND FS.STATUS = 'ACTIVE'
8039: AND (PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) <>1 OR
8053: INTO
8054: l_has_children
8055: FROM PON_FORM_FIELD_VALUES
8056: WHERE FORM_ID = form.FORM_ID
8057: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8058: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8059: AND PARENT_FIELD_VALUES_FK = -1;
8060:
8061: IF l_has_children > 0 THEN
8065: INTO
8066: l_orig_parent_field_val_fk
8067: FROM PON_FORM_FIELD_VALUES
8068: WHERE FORM_ID = form.FORM_ID
8069: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8070: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8071: AND PARENT_FIELD_VALUES_FK = -1;
8072:
8073: COPY_FORM_FIELD_CHILDREN (
8464: FROM PON_FORM_FIELD_VALUES
8465: WHERE PARENT_FIELD_VALUES_FK = p_orig_parent_fld_values_fk
8466: AND FORM_ID = p_form_id
8467: AND ENTITY_PK1 = p_old_entity_pk1
8468: AND OWNING_ENTITY_CODE='PON_AUCTION_HEADERS_ALL';
8469:
8470:
8471: BEGIN
8472: -- { Start of COPY_FORM_FIELD_CHILDREN
8848: VALUES
8849: (
8850: l_new_field_values_fk,
8851: field_value.FORM_ID,
8852: 'PON_AUCTION_HEADERS_ALL',
8853: p_new_entity_pk1,
8854: field_value.SECTION_ID,
8855: p_new_parent_field_values_fk,
8856: field_value.TEXTCOL1,
9274: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
9275: l_user_id NUMBER := p_user_id;
9276: l_source_doctype_id NUMBER := p_source_doctype_id;
9277: l_round_number NUMBER := p_round_number;
9278: L_SOURCE_DOC_NUM pon_auction_headers_all.document_number%TYPE := p_source_doc_num;
9279: L_ORG_ID NUMBER := p_org_id;
9280: L_LAST_AMENDMENT_NUMBER NUMBER := p_last_amendment_number;
9281: L_IS_AMENDMENT VARCHAR2(20);
9282: L_RETAIN_ATTACHMENTS VARCHAR2(1);
9298: l_s_line_attr_enabled_flag VARCHAR2(1);
9299: l_s_rfi_line_enabled_flag VARCHAR2(1);
9300: l_s_doctype_name VARCHAR2(240);
9301: l_s_pf_type_allowed VARCHAR2(25);
9302: l_s_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9303: l_s_global_agmt_flag VARCHAR2(1);
9304: l_s_lot_enabled_flag VARCHAR2(1);
9305: l_s_grp_enabled_flag VARCHAR2(1);
9306: l_s_has_hdr_attr_flag VARCHAR2(1);
9311: l_d_line_attr_enabled_flag VARCHAR2(1);
9312: l_d_rfi_line_enabled_flag VARCHAR2(1);
9313: l_d_doctype_name VARCHAR2(240);
9314: l_d_pe_enabled_flag VARCHAR2(1); --styles flag for PE
9315: l_d_po_style_id pon_auction_headers_all.po_style_id%type;
9316: l_d_pb_enabled_flag VARCHAR2(1); --styles flag for PB
9317: l_d_pd_enabled_flag VARCHAR2(1); --styles flag for PD
9318: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9319: l_d_lot_enabled_flag VARCHAR2(1);
9314: l_d_pe_enabled_flag VARCHAR2(1); --styles flag for PE
9315: l_d_po_style_id pon_auction_headers_all.po_style_id%type;
9316: l_d_pb_enabled_flag VARCHAR2(1); --styles flag for PB
9317: l_d_pd_enabled_flag VARCHAR2(1); --styles flag for PD
9318: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
9319: l_d_lot_enabled_flag VARCHAR2(1);
9320: l_d_grp_enabled_flag VARCHAR2(1);
9321: l_d_hdr_attr_enabled_flag VARCHAR2(1);
9322:
9360: headers.AUCTION_STATUS,
9361: nvl(styles.LARGE_NEG_ENABLED_FLAG,'N'),
9362: staggered_closing_interval into IS_LARGE_SOURCE,CURRENT_STATUS,IS_LARGE_DESTINATION,l_staggered_closing_interval
9363: from
9364: PON_AUCTION_HEADERS_ALL headers,
9365: PON_NEGOTIATION_STYLES styles
9366: where
9367: headers.AUCTION_HEADER_ID = p_source_auction_header_id and
9368: styles.STYLE_ID = p_style_id;
9395: l_d_po_style_id,
9396: l_d_doctype_name,
9397: l_d_hdr_attr_enabled_flag
9398: FROM
9399: PON_AUCTION_HEADERS_ALL hdr,
9400: PON_AUC_DOCTYPES doctypes
9401: WHERE
9402: hdr.auction_header_id = l_auction_header_id AND
9403: doctypes.DOCTYPE_ID = p_doctype_id;
9473: l_s_has_hdr_attr_flag,
9474: l_s_hdr_attr_enabled_flag,
9475: l_s_pe_enabled_flag
9476: FROM
9477: PON_AUCTION_HEADERS_ALL hdr,
9478: PON_AUC_DOCTYPES doctypes
9479: WHERE
9480: auction_header_id = p_source_auction_header_id AND
9481: doctypes.DOCTYPE_ID = hdr.DOCTYPE_ID;
9838: select nvl(max(line_number),0) into l_max_line_number from PON_AUCTION_ITEM_PRICES_ALL
9839: where auction_header_id = p_source_auction_header_id;
9840: else
9841:
9842: 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');
9843:
9844: select nvl(max_internal_line_num,0) into l_max_line_number from PON_AUCTION_HEADERS_ALL
9845: where auction_header_id = p_source_auction_header_id;
9846: end if;
9840: else
9841:
9842: 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');
9843:
9844: select nvl(max_internal_line_num,0) into l_max_line_number from PON_AUCTION_HEADERS_ALL
9845: where auction_header_id = p_source_auction_header_id;
9846: end if;
9847:
9848: /* ELINs & CDRLs QA Bug : 16685354 : When copying draft neg, CDRLs can exist without lines.
10280: -- Delete all attribute scores where there is no parent attribute
10281:
10282: SELECT contract_type
10283: INTO l_contract_type
10284: FROM pon_auction_headers_all
10285: WHERE auction_header_id = l_auction_header_id;
10286:
10287: IF (l_contract_type in ('BLANKET', 'CONTRACT') and
10288: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
10383:
10384: END IF;
10385:
10386: --
10387: --Update the LAST_LINE_NUMBER and NUMBER_OF_LINES fields in pon_auction_headers_all
10388: --
10389: LOG_MESSAGE('copy_negotiation','Querying for NUMBER_OF_LINES and LAST_LINE_NUMBER');
10390:
10391: SELECT
10396: AUCTION_HEADER_ID = l_auction_header_id;
10397:
10398: LOG_MESSAGE('copy_lines_and_children','l_number_of_lines : ' || l_number_of_lines || ' ; l_last_line_number : ' || l_last_line_number);
10399:
10400: UPDATE pon_auction_headers_all
10401: SET number_of_lines = l_number_of_lines, LAST_LINE_NUMBER = l_last_line_number
10402: WHERE
10403: AUCTION_HEADER_ID = l_auction_header_id;
10404:
10401: SET number_of_lines = l_number_of_lines, LAST_LINE_NUMBER = l_last_line_number
10402: WHERE
10403: AUCTION_HEADER_ID = l_auction_header_id;
10404:
10405: LOG_MESSAGE('copy_lines_and_children','Updated NUMBER_OF_LINES and LAST_LINE_NUMBER fields in PON_AUCTION_HEADERS_ALL');
10406:
10407: --
10408: -- Now get message count to initialize the OUT variable (x_msg_count)
10409: --
10548: l_pref_pf_unused_3 VARCHAR2(300);
10549:
10550: l_temp_labor_count NUMBER;
10551:
10552: l_default_currency_code PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE;
10553: l_default_rate_type PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE;
10554:
10555:
10556: BEGIN
10549:
10550: l_temp_labor_count NUMBER;
10551:
10552: l_default_currency_code PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE;
10553: l_default_rate_type PON_AUCTION_HEADERS_ALL.RATE_TYPE%TYPE;
10554:
10555:
10556: BEGIN
10557:
11292: t_record.ALLOW_UNSOL_OFFER_LINES,
11293: t_record.ALLOW_WITHDRAW_FLAG,
11294: t_record.ALLOW_MULTIPLE_ACTIVE_OFFERS,
11295: t_record.ALLOW_STAGGERED_AWARDS
11296: FROM PON_AUCTION_HEADERS_ALL A,
11297: PON_AUC_BIZRULES BID_VISIB,
11298: PON_AUC_DOCTYPE_RULES R_BID_VISIB,
11299: PON_AUC_BIZRULES BID_SCOPE,
11300: PON_AUC_DOCTYPE_RULES R_BID_SCOPE,
11688: IS
11689: l_source_doc_id NUMBER;
11690: l_auction_header_id NUMBER;
11691: l_contracts_doctype VARCHAR2(60);
11692: l_site_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11693: l_auc_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11694: l_keep_version VARCHAR2(1);
11695: l_return_status VARCHAR2(1);
11696: l_msg_data VARCHAR2(400);
11689: l_source_doc_id NUMBER;
11690: l_auction_header_id NUMBER;
11691: l_contracts_doctype VARCHAR2(60);
11692: l_site_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11693: l_auc_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11694: l_keep_version VARCHAR2(1);
11695: l_return_status VARCHAR2(1);
11696: l_msg_data VARCHAR2(400);
11697: l_msg_count NUMBER;
11699: l_error_message VARCHAR2(400);
11700: l_is_reset_contracts VARCHAR2(1);
11701: l_copy_for_amendment VARCHAR2(1);
11702: l_po_doctype VARCHAR2(50);
11703: l_conterms_exist_flag pon_auction_headers_all.conterms_exist_flag%TYPE;
11704: l_copy_abstract_yn VARCHAR2(1);
11705: l_old_org_id NUMBER;
11706: l_old_policy VARCHAR2(2);
11707:
11711: l_attached_document_id_t number_table;
11712: l_document_id_t number_table;
11713: l_datatype_id_t number_table;
11714: l_is_federal NUMBER;
11715: l_source_orig_amend_id pon_auction_headers_all.auction_header_id_prev_amend%TYPE;
11716:
11717: --end of federal CLM
11718:
11719: BEGIN --{ Start of COPY_CONTRACTS_ATTACHMENTS
11969: IF p_copy_type = g_conformed_doc_copy THEN
11970:
11971: select auction_header_id_prev_amend
11972: into l_source_orig_amend_id
11973: from pon_auction_headers_all
11974: where auction_header_id = p_source_auction_header_id;
11975:
11976: FOR base_attach_rec IN
11977: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11976: FOR base_attach_rec IN
11977: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11978: FROM FND_ATTACHED_DOCUMENTS
11979: WHERE pk1_value = to_char(p_source_auction_header_id)
11980: AND ENTITY_NAME = 'PON_AUCTION_HEADERS_ALL'
11981: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl
11982: WHERE NAME = 'PonAmendmentSpecific')
11983: UNION
11984: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11983: UNION
11984: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11985: FROM FND_ATTACHED_DOCUMENTS
11986: WHERE pk1_value = To_Char(l_source_orig_amend_id)
11987: AND ENTITY_NAME = 'PON_AUCTION_HEADERS_ALL'
11988: AND ATTACHED_DOCUMENT_ID NOT IN
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
11990: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
11991:
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
11990: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
11991:
11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
11993: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
11994: X_from_pk1_value => base_attach_rec.pk1_value,
11995: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
11996: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
11997: X_created_by => p_user_id, -- CREATED_BY
11991:
11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
11993: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
11994: X_from_pk1_value => base_attach_rec.pk1_value,
11995: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
11996: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
11997: X_created_by => p_user_id, -- CREATED_BY
11998: X_last_update_login => fnd_global.login_id, -- LAST_UPDATE_LOGIN
11999: X_orig_attach_doc_id => base_attach_rec.ATTACHED_DOCUMENT_ID
12001: END LOOP;
12002:
12003: ELSE
12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
12005: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
12006: X_from_pk1_value => to_char(p_source_auction_header_id),
12007: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
12008: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
12009: X_created_by => p_user_id, -- CREATED_BY
12003: ELSE
12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
12005: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
12006: X_from_pk1_value => to_char(p_source_auction_header_id),
12007: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
12008: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
12009: X_created_by => p_user_id, -- CREATED_BY
12010: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
12011: );
12162: ITEM_SUPP_ATTR_ENABLED_FLAG, INTGR_CAT_LINE_ATTR_FLAG,
12163: INTGR_ITEM_LINE_ATTR_FLAG, INTGR_CAT_LINE_ASL_FLAG
12164: -- End Supplier Management: Bug 8993731
12165: INTO g_neg_style_raw
12166: FROM PON_AUCTION_HEADERS_ALL
12167: WHERE auction_header_id = p_source_auction_header_id;
12168: END IF;
12169: EXCEPTION
12170: WHEN NO_DATA_FOUND THEN
12193: ITEM_SUPP_ATTR_ENABLED_FLAG, INTGR_CAT_LINE_ATTR_FLAG,
12194: INTGR_ITEM_LINE_ATTR_FLAG, INTGR_CAT_LINE_ASL_FLAG
12195: -- End Supplier Management: Bug 8993731
12196: INTO g_neg_style_raw
12197: FROM PON_AUCTION_HEADERS_ALL
12198: WHERE auction_header_id = p_source_auction_header_id;
12199: EXCEPTION
12200: WHEN NO_DATA_FOUND THEN
12201: LOG_MESSAGE('SET_NEG_STYLE','Invalid Neg Num');
12404: p_from_line_number IN NUMBER,
12405: p_to_line_number IN NUMBER)
12406: is
12407:
12408: l_current_status pon_auction_headers_all.auction_status%type;
12409: l_is_large_neg_enabled pon_auction_headers_all.LARGE_NEG_ENABLED_FLAG%type;
12410: BEGIN
12411: --{ start of PON_LRG_DRAFT_TO_ORD_PF_COPY
12412: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY',
12405: p_to_line_number IN NUMBER)
12406: is
12407:
12408: l_current_status pon_auction_headers_all.auction_status%type;
12409: l_is_large_neg_enabled pon_auction_headers_all.LARGE_NEG_ENABLED_FLAG%type;
12410: BEGIN
12411: --{ start of PON_LRG_DRAFT_TO_ORD_PF_COPY
12412: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY',
12413: 'Entered the procedure with p_source_auction_hdr_id : ' || p_source_auction_hdr_id ||
12421:
12422: select large_neg_enabled_flag, auction_status
12423: into l_is_large_neg_enabled, l_current_status
12424: from
12425: pon_auction_headers_all
12426: where
12427: auction_header_id = p_source_auction_hdr_id;
12428: if l_is_large_neg_enabled = 'Y' then
12429:
12646: p_large_auction_header_id IN NUMBER,
12647: p_style_id IN NUMBER)
12648: IS
12649: l_auction_header_id NUMBER;
12650: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
12651: l_return_status VARCHAR2(1);
12652: l_msg_count NUMBER;
12653: l_msg_data VARCHAR2(400);
12654: l_request_id NUMBER := NULL;
12653: l_msg_data VARCHAR2(400);
12654: l_request_id NUMBER := NULL;
12655: l_program_type_code VARCHAR2(30);
12656: l_message_suffix VARCHAR2(30);
12657: l_source_doc_num PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
12658: BEGIN
12659: --{Start of PON_CONC_COPY_SUPER_LARGE_NEG
12660:
12661: --Choose the appropriate ProgramTypeCode
12703: --get the request id for the new auction
12704: --for workflow calls
12705: --
12706: select request_id into l_request_id
12707: from pon_auction_headers_all
12708: where auction_header_id = p_large_auction_header_id;
12709:
12710:
12711: if l_return_status = 'E' then
12735: --concurrent program has to be shown to the user
12736: --
12737: --Ref: ECO - 4517992
12738: --
12739: -- update pon_auction_headers_all
12740: -- set request_id = null
12741: -- where auction_header_id = p_large_auction_header_id;
12742: --commit this updation
12743: -- commit;
12763: p_ProgramTypeCode => l_program_type_code,
12764: p_DestinationPageCode => 'PON_CONCURRENT_ERRORS',
12765: p_bid_number => NULL);
12766:
12767: select document_number into l_source_doc_num from pon_auction_headers_all where auction_Header_id = p_source_auction_header_id;
12768:
12769: insert into pon_interface_errors (
12770: ERROR_MESSAGE_NAME,
12771: request_id,
12831: -- check if the source auction has any scoring teams
12832: -- if it does not, do not do anything
12833: SELECT has_scoring_teams_flag
12834: INTO l_source_has_scoring_teams
12835: FROM pon_auction_headers_all
12836: WHERE auction_header_id = p_source_auction_header_id;
12837:
12838: IF l_source_has_scoring_teams <> 'Y' THEN
12839: RETURN;
13075: )
13076: IS
13077:
13078: l_auction_header_id NUMBER := null;
13079: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
13080: l_request_id NUMBER;
13081: l_return_status VARCHAR2(1);
13082: l_msg_count NUMBER;
13083: l_msg_data VARCHAR2(500);
13124: and x_auction_header_id is not null then
13125:
13126: LOG_MESSAGE('FED_CREATE_AMD_COPY_NEG','Updating AMENDMENT_FLAG ');
13127:
13128: update PON_AUCTION_HEADERS_ALL
13129: set AMENDMENT_FLAG = decode(p_copy_type,g_amend_copy,'Y','N'),
13130: CANCEL_AMENDMENT = decode(p_is_cancel_amendment,'Y','Y','N')
13131: where AUCTION_HEADER_ID = x_auction_header_id;
13132: COMMIT;
13144:
13145: l_revision NUMBER;
13146: BEGIN
13147: select
13148: nvl((select (max(revision)+1) from pon_auction_headers_all where auction_header_id_orig_amend =
13149: (select auction_header_id_orig_amend from pon_auction_headers_all where auction_header_id = p_auction_header_id)),0)
13150: INTO l_revision
13151: from dual;
13152:
13145: l_revision NUMBER;
13146: BEGIN
13147: select
13148: nvl((select (max(revision)+1) from pon_auction_headers_all where auction_header_id_orig_amend =
13149: (select auction_header_id_orig_amend from pon_auction_headers_all where auction_header_id = p_auction_header_id)),0)
13150: INTO l_revision
13151: from dual;
13152:
13153: return l_revision;
13169: -- check if source is an evaluation RFx
13170: -- if it is not, do not do anything
13171: SELECT supp_eval_flag
13172: INTO l_source_is_evaluation
13173: FROM pon_auction_headers_all
13174: WHERE auction_header_id = p_source_auction_header_id;
13175:
13176: IF l_source_is_evaluation <> 'Y' THEN
13177: RETURN;