[Home] [Help]
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,
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,
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,
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:
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,
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
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,
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;