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