[Home] [Help]
1: PACKAGE BODY PON_PRINTING_PKG as
2: /* $Header: PONPRNB.pls 120.93.12020000.4 2013/05/31 07:17:50 sgulkota ship $ */
3:
4: -------------------------------------------------------------------------------
5:
280: if (p_value is null) then
281: return null;
282:
283: elsif (instr(p_value, '.')>0) then
284: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999.9999999999999999'));
285: else
286: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999'));
287: end if;
288:
282:
283: elsif (instr(p_value, '.')>0) then
284: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999.9999999999999999'));
285: else
286: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999'));
287: end if;
288:
289: EXCEPTION
290: when others then
550:
551: begin
552:
553: --need to get this based on user language
554: --NEED TO SEE IF PON_PRINTING_PKG.UNSET_SESSION_LAGUAGE is to be called
555: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, USERENV('LANG'));
556:
557: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
558: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
670: l_display_rate := (1/PON_AUCTION_PKG.getClosestRate(p_auction_currency_code,p_bid_currency_code,p_rate_date,p_rate_type,0));
671:
672: end if;
673:
674: l_printing_text := pon_printing_pkg.get_messages('PON_AUC_DISPLAY_RATE','AUCTION_CURRENCY',p_auction_currency_code,'RATE',pon_printing_pkg.format_number(l_display_rate),'BID_CURRENCY',p_bid_currency_code);
675:
676: exception
677:
678: when others then
828: l_start_time DATE;
829: l_end_time DATE;
830: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
831: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
832: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_EMD_XML';
833:
834: BEGIN
835:
836: OPEN xml_query_cursor FOR
1033: l_start_time DATE;
1034: l_end_time DATE;
1035: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1036: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1037: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_SUPPLIER_XML';
1038: l_emd_current_status varchar2(20);
1039: --Begin: Added by Chaoqun on 11-Jan_2009
1040: l_cust_trx_id NUMBER;
1041: l_cust_trx_num VARCHAR2(20);
1479: l_start_time DATE;
1480: l_end_time DATE;
1481: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1482: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1483: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_RECEIPT_XML';
1484: --p_supplier_id := 12438;
1485: --l_emd_current_status pon_emd_transactions.status_lookup_code%type;
1486: TYPE emd_current_status_type is ref cursor;
1487: emd_current_status emd_current_status_type;
1797: l_start_time DATE;
1798: l_end_time DATE;
1799: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1800: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1801: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
1802:
1803:
1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
2209: FND_LOG.string(l_statement_log_level, l_module_name, 'Two-Part related variables: l_hide_comm_part: '||l_hide_comm_part||'; l_attach_categ_option: '|| l_attach_categ_option);
2210: END IF;
2211:
2212: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
2213: l_two_part_general_msg := pon_printing_pkg.get_messages('PON_TWO_PART_INFO','TECHNICAL',pon_auction_pkg.get_technical_meaning, 'COMMERCIAL',pon_auction_pkg.get_commercial_meaning);
2214: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
2215: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
2216:
2217: --Fix for bug 12655380
2210: END IF;
2211:
2212: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
2213: l_two_part_general_msg := pon_printing_pkg.get_messages('PON_TWO_PART_INFO','TECHNICAL',pon_auction_pkg.get_technical_meaning, 'COMMERCIAL',pon_auction_pkg.get_commercial_meaning);
2214: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
2215: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
2216:
2217: --Fix for bug 12655380
2218: --Splitting the cursor query and concatenating the xmls from each query to reduce sharable memory usage
2211:
2212: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
2213: l_two_part_general_msg := pon_printing_pkg.get_messages('PON_TWO_PART_INFO','TECHNICAL',pon_auction_pkg.get_technical_meaning, 'COMMERCIAL',pon_auction_pkg.get_commercial_meaning);
2214: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
2215: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
2216:
2217: --Fix for bug 12655380
2218: --Splitting the cursor query and concatenating the xmls from each query to reduce sharable memory usage
2219: OPEN xml_query_cursor FOR
2293: pah.auto_extend_number,
2294: pah.auto_extend_enabled_flag,
2295: pah.number_of_extensions,
2296: pah.min_bid_decrement,
2297: decode(pah.min_bid_change_type, 'PERCENTAGE', pon_printing_pkg.format_number(pah.min_bid_decrement), pon_printing_pkg.format_price(pah.min_bid_decrement*l_rate, l_price_mask, l_price_precision)) min_bid_decrement_disp,
2298: pah.price_driven_auction_flag,
2299: pah.payment_terms_id,
2300: ap.name payment_terms,
2301: pah.freight_terms_code,
2304: fl_fob.meaning fob,
2305: pah.carrier_code,
2306: pah.currency_code,
2307: l_currency_code l_currency_code,
2308: pon_printing_pkg.get_carrier_description(pah.org_id,pah.carrier_code) carrier,
2309: currency_tl.name currency_name,
2310: -- bidpdf: whether this is for a bid pdf
2311: l_is_bidpdf is_bidpdf,
2312: l_price_visibility price_visibility,
2392: p_printing_warning_flag print_warning_flag,
2393: l_cont_attach_doc_flag contract_attached_doc,
2394: l_cont_nonmerge_flag contract_non_mergeable,
2395: p_neg_printed_with_contracts neg_printed_with_contracts,
2396: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2393: l_cont_attach_doc_flag contract_attached_doc,
2394: l_cont_nonmerge_flag contract_non_mergeable,
2395: p_neg_printed_with_contracts neg_printed_with_contracts,
2396: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2394: l_cont_nonmerge_flag contract_non_mergeable,
2395: p_neg_printed_with_contracts neg_printed_with_contracts,
2396: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2395: p_neg_printed_with_contracts neg_printed_with_contracts,
2396: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2396: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2397: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2405: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',pon_conterms_utl_pvt.GET_LEGAL_ENTITY_NAME(pah.org_id)) legal_consequences_msg,
2398: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2405: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',pon_conterms_utl_pvt.GET_LEGAL_ENTITY_NAME(pah.org_id)) legal_consequences_msg,
2406: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
2399: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
2400: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2405: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',pon_conterms_utl_pvt.GET_LEGAL_ENTITY_NAME(pah.org_id)) legal_consequences_msg,
2406: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
2407: -- two-part project messages
2401: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2405: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',pon_conterms_utl_pvt.GET_LEGAL_ENTITY_NAME(pah.org_id)) legal_consequences_msg,
2406: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
2407: -- two-part project messages
2408: l_two_part_general_msg two_part_general_info_msg,
2409: l_two_part_tech_msg two_part_technical_msg,
2402: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
2403: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
2404: --bug 7592494, call to get_legal_entity_name
2405: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',pon_conterms_utl_pvt.GET_LEGAL_ENTITY_NAME(pah.org_id)) legal_consequences_msg,
2406: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
2407: -- two-part project messages
2408: l_two_part_general_msg two_part_general_info_msg,
2409: l_two_part_tech_msg two_part_technical_msg,
2410: l_two_part_comm_msg two_part_commercial_msg,
2409: l_two_part_tech_msg two_part_technical_msg,
2410: l_two_part_comm_msg two_part_commercial_msg,
2411: -- bidpdf: doc title and footer
2412: decode(l_is_bidpdf, 'Y',
2413: get_messages(pon_printing_pkg.get_document_message_name('PON_BID_PRN_PAGE_HEADING',doctypes.message_suffix),'DOCUMENT_NUMBER',pah.document_number,'BID_NUMBER',p_bid_number),
2414: pon_printing_pkg.get_messages(pon_printing_pkg.get_document_message_name('PON_AUCTS_PRN_PAGE_HEADING',doctypes.message_suffix),'DOCUMENT_NUMBER',pah.document_number)
2415: ) page_heading_msg,
2416: pbhs.bid_status,
2417: -- bidpdf: document type
2410: l_two_part_comm_msg two_part_commercial_msg,
2411: -- bidpdf: doc title and footer
2412: decode(l_is_bidpdf, 'Y',
2413: get_messages(pon_printing_pkg.get_document_message_name('PON_BID_PRN_PAGE_HEADING',doctypes.message_suffix),'DOCUMENT_NUMBER',pah.document_number,'BID_NUMBER',p_bid_number),
2414: pon_printing_pkg.get_messages(pon_printing_pkg.get_document_message_name('PON_AUCTS_PRN_PAGE_HEADING',doctypes.message_suffix),'DOCUMENT_NUMBER',pah.document_number)
2415: ) page_heading_msg,
2416: pbhs.bid_status,
2417: -- bidpdf: document type
2418: doctypes.doctype_group_name,
2438: pbhs.note_to_auction_owner note_to_buyer, --Note to Buyer
2439: --bidpdf: Response Received Time value
2440: pon_oa_util_pkg.display_date_time(pbhs.surrog_bid_receipt_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_received_time,
2441: pbhs.surrog_bid_flag surrog_bid_flag, --Surrogate Bid Flag
2442: pon_printing_pkg.get_user_email(hp1.party_id) email,
2443: pah.abstract_details,
2444: fl_security.meaning security_level,
2445: pah.approval_status,
2446: ps.display_name outcome,
2489: pah.price_element_enabled_flag,
2490: buyer_phone.phone_number,
2491: buyer_fax.phone_number fax_number,
2492: -- bidpdf: Proxy response decrement
2493: decode(pah.min_bid_change_type, 'PERCENTAGE', pon_printing_pkg.format_number(pbhs.min_bid_change)||'%', pon_printing_pkg.format_price(pbhs.min_bid_change*l_rate, l_price_mask, l_price_precision)) min_bid_currency_change,
2494: pon_printing_pkg.get_messages('PON_AUCTS_CUR_PROXY_DEC','CURRENCY_CODE',l_currency_code) supplier_proxy_dec_msg,
2495: -- bidpdf: response total
2496: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
2497: to_char(get_supplier_bid_total(pah.auction_header_id, pbhs.bid_number, pbhs.buyer_bid_total, pah.contract_type, doctypes.doctype_group_name,pbhs.bid_status), l_amount_mask)
2490: buyer_phone.phone_number,
2491: buyer_fax.phone_number fax_number,
2492: -- bidpdf: Proxy response decrement
2493: decode(pah.min_bid_change_type, 'PERCENTAGE', pon_printing_pkg.format_number(pbhs.min_bid_change)||'%', pon_printing_pkg.format_price(pbhs.min_bid_change*l_rate, l_price_mask, l_price_precision)) min_bid_currency_change,
2494: pon_printing_pkg.get_messages('PON_AUCTS_CUR_PROXY_DEC','CURRENCY_CODE',l_currency_code) supplier_proxy_dec_msg,
2495: -- bidpdf: response total
2496: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
2497: to_char(get_supplier_bid_total(pah.auction_header_id, pbhs.bid_number, pbhs.buyer_bid_total, pah.contract_type, doctypes.doctype_group_name,pbhs.bid_status), l_amount_mask)
2498: ) supplier_bid_total,
2495: -- bidpdf: response total
2496: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
2497: to_char(get_supplier_bid_total(pah.auction_header_id, pbhs.bid_number, pbhs.buyer_bid_total, pah.contract_type, doctypes.doctype_group_name,pbhs.bid_status), l_amount_mask)
2498: ) supplier_bid_total,
2499: pon_printing_pkg.get_messages('PON_BID_CUR_TOTAL','CURRENCY_CODE', l_currency_code) supplier_response_total_msg,
2500: pah.price_tiers_indicator,
2501:
2502: --------------------Begin: Add by Chaoqun for addiing EMD info into Printable View on 6-NOV-2008-------------------
2503: pah.EMD_ENABLE_FLAG,
2703: paip.ip_category_id,
2704: icx.category_name ip_category_name,
2705: paip.uom_code,
2706: units.unit_of_measure_tl,
2707: pon_printing_pkg.format_number(paip.quantity) quantity,
2708: -- bidpdf: Note to Buyer
2709: pbip.note_to_auction_owner,
2710: -- bidpdf: add bid price info
2711: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_price, l_price_mask, l_price_precision)) bid_currency_price,
2707: pon_printing_pkg.format_number(paip.quantity) quantity,
2708: -- bidpdf: Note to Buyer
2709: pbip.note_to_auction_owner,
2710: -- bidpdf: add bid price info
2711: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_price, l_price_mask, l_price_precision)) bid_currency_price,
2712: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
2713: pon_oa_util_pkg.display_date_time(pbip.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date,
2714: --in MAS case, pbip.quantity is null, use paip.quantity instead
2715: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(l_contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
2708: -- bidpdf: Note to Buyer
2709: pbip.note_to_auction_owner,
2710: -- bidpdf: add bid price info
2711: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_price, l_price_mask, l_price_precision)) bid_currency_price,
2712: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
2713: pon_oa_util_pkg.display_date_time(pbip.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date,
2714: --in MAS case, pbip.quantity is null, use paip.quantity instead
2715: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(l_contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
2716: --response/inquiry/server/ViewBidItemsVORowImpl.java:getBidTotalDisplay(): exchange_rate * PON_TRANSFORM_BIDDING_PKG.calculate_quote_amount (paip.auction_header_id, pbip.line_number, pbip.bid_number, 'TRANSFORMED', 12637, 12438, -1) bid_amount,
2718: decode(p_user_view_type, 'BUYER', to_char(pbip.po_min_rel_amount, l_amount_mask), to_char(pbip.po_bid_min_rel_amount, l_amount_mask)) bid_min_rel_amount,
2719: --bidpdf: MAS Score
2720: pbip.total_weighted_score,
2721: --bidpdf: Proxy Minimum
2722: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.proxy_bid_limit_price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_limit_price, l_price_mask, l_price_precision)) bid_currency_limit_price,
2723: paip.ship_to_location_id,
2724:
2725: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
2726: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,
2721: --bidpdf: Proxy Minimum
2722: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.proxy_bid_limit_price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_limit_price, l_price_mask, l_price_precision)) bid_currency_limit_price,
2723: paip.ship_to_location_id,
2724:
2725: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
2726: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,
2727: p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),l_price_mask, l_price_precision)
2728: target_price,
2729: -- Start price comes from the earlier bid for a supplier if he had bid
2733: -- auction start price
2734: --untransform_one_price
2735:
2736: DECODE(l_is_supplier_bidpdf, 'Y',
2737: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id, paip.line_number,
2738: nvl(pbip.bid_start_price, paip.bid_start_price)*l_rate, paip.quantity,
2739: p_trading_partner_id,
2740: p_trading_partner_contact_id,
2741: p_vendor_site_id,
2740: p_trading_partner_contact_id,
2741: p_vendor_site_id,
2742: p_requested_supplier_id),l_price_mask, l_price_precision),
2743: DECODE(l_start_price_from_prev_rnd, 'N',
2744: pon_printing_pkg.format_price(
2745: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, paip.line_number, paip.bid_start_price, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
2746: l_price_mask, l_price_precision),
2747: pon_printing_pkg.format_price(
2748: NVL(pon_auction_headers_pkg.apply_price_factors(p_auction_header_id ,l_prev_rnd_bid_number,paip.line_number, l_contract_type, l_supplier_view_type, l_pf_type_allowed, 'Y'),paip.bid_start_price),
2743: DECODE(l_start_price_from_prev_rnd, 'N',
2744: pon_printing_pkg.format_price(
2745: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, paip.line_number, paip.bid_start_price, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
2746: l_price_mask, l_price_precision),
2747: pon_printing_pkg.format_price(
2748: NVL(pon_auction_headers_pkg.apply_price_factors(p_auction_header_id ,l_prev_rnd_bid_number,paip.line_number, l_contract_type, l_supplier_view_type, l_pf_type_allowed, 'Y'),paip.bid_start_price),
2749: l_price_mask, l_price_precision)
2750: )
2751: ) bid_start_price,
2797: paip.requisition_number,
2798: paip.line_origination_code,
2799: nvl2(paip.source_doc_number, paip.source_doc_number || nvl2(paip.source_line_number, ' / ' || paip.source_line_number, null), null) source_doc_line_display,
2800: lt.line_type,
2801: pon_printing_pkg.format_price(paip.current_price, l_price_mask, l_price_precision) current_price,
2802: pon_printing_pkg.format_price(paip.unit_target_price, l_price_mask, l_price_precision) unit_target_price,
2803: paip.unit_display_target_flag
2804: ,paip.has_payments_flag
2805: ,to_char(paip.advance_amount*l_rate, l_amount_mask) advance_amount
2798: paip.line_origination_code,
2799: nvl2(paip.source_doc_number, paip.source_doc_number || nvl2(paip.source_line_number, ' / ' || paip.source_line_number, null), null) source_doc_line_display,
2800: lt.line_type,
2801: pon_printing_pkg.format_price(paip.current_price, l_price_mask, l_price_precision) current_price,
2802: pon_printing_pkg.format_price(paip.unit_target_price, l_price_mask, l_price_precision) unit_target_price,
2803: paip.unit_display_target_flag
2804: ,paip.has_payments_flag
2805: ,to_char(paip.advance_amount*l_rate, l_amount_mask) advance_amount
2806: ,decode(p_user_view_type, 'BUYER', to_char(pbip.advance_amount, l_amount_mask), to_char(pbip.bid_curr_advance_amount, l_amount_mask)) bid_advance_amount
2927: ,lkp1.displayed_field payment_type_disp
2928: ,pay.quantity
2929: ,pay.uom_code
2930: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2931: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2932: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
2933: ,pay.work_approver_user_id
2934: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2935: FROM per_all_people_f per
3003: ,lkp1.displayed_field payment_type_disp
3004: ,pay.quantity
3005: ,pay.uom_code
3006: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
3007: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
3008: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
3009: ,pay.work_approver_user_id
3010: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
3011: FROM per_all_people_f per
3026: ,pay.project_exp_organization_id project_exp_organization_id
3027: ,hrorg.name project_exp_organization_name
3028: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
3029: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
3030: ,decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbp.price, l_price_mask,l_price_precision), pon_printing_pkg.format_price(pbp.bid_currency_price,l_price_mask,l_price_precision)) pay_item_price
3031: ,to_char(decode(pbp.quantity,null,decode(pbip.quantity, null, 1,pbip.quantity),pbp.quantity)*decode(p_user_view_type, 'BUYER',pbp.price,pbp.bid_currency_price), l_amount_mask) amount_display
3032: ,pon_oa_util_pkg.display_date_time(pbp.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date
3033: FROM
3034: pon_auc_payments_shipments pay,
3169: flv.meaning pricing_basis_display,
3170: pe.value value,
3171: --only in supplier bid pdf, the target value is in supplier currency and number format
3172: --in neg pdf and buyer side bid pdf, the target value is in buyer currency
3173: nvl2(pe.value, decode(pe.pricing_basis, 'PER_UNIT', pon_printing_pkg.format_price(pe.value*l_rate, l_price_mask, l_price_precision) ||' ('||l_currency_code||')',
3174: 'FIXED_AMOUNT', to_char(pe.value*l_rate, l_amount_mask) ||' ('||l_currency_code||')',
3175: pon_printing_pkg.format_number(pe.value)),
3176: null) target_value_display,
3177: -- bidpdf: response value
3171: --only in supplier bid pdf, the target value is in supplier currency and number format
3172: --in neg pdf and buyer side bid pdf, the target value is in buyer currency
3173: nvl2(pe.value, decode(pe.pricing_basis, 'PER_UNIT', pon_printing_pkg.format_price(pe.value*l_rate, l_price_mask, l_price_precision) ||' ('||l_currency_code||')',
3174: 'FIXED_AMOUNT', to_char(pe.value*l_rate, l_amount_mask) ||' ('||l_currency_code||')',
3175: pon_printing_pkg.format_number(pe.value)),
3176: null) target_value_display,
3177: -- bidpdf: response value
3178: nvl2(pbpe.bid_currency_value,
3179: decode(pe.pricing_basis,
3177: -- bidpdf: response value
3178: nvl2(pbpe.bid_currency_value,
3179: decode(pe.pricing_basis,
3180: 'PER_UNIT', decode(p_user_view_type,
3181: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
3182: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
3183: 'FIXED_AMOUNT', decode(p_user_view_type, 'BUYER',to_char(pbpe.auction_currency_value, l_amount_mask)||' ('||l_currency_code||')',to_char(pbpe.bid_currency_value, l_amount_mask)||' ('||l_currency_code||')'),
3184: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
3185: null) bid_value_display,
3178: nvl2(pbpe.bid_currency_value,
3179: decode(pe.pricing_basis,
3180: 'PER_UNIT', decode(p_user_view_type,
3181: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
3182: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
3183: 'FIXED_AMOUNT', decode(p_user_view_type, 'BUYER',to_char(pbpe.auction_currency_value, l_amount_mask)||' ('||l_currency_code||')',to_char(pbpe.bid_currency_value, l_amount_mask)||' ('||l_currency_code||')'),
3184: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
3185: null) bid_value_display,
3186: pe.price_element_type_id,
3180: 'PER_UNIT', decode(p_user_view_type,
3181: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
3182: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
3183: 'FIXED_AMOUNT', decode(p_user_view_type, 'BUYER',to_char(pbpe.auction_currency_value, l_amount_mask)||' ('||l_currency_code||')',to_char(pbpe.bid_currency_value, l_amount_mask)||' ('||l_currency_code||')'),
3184: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
3185: null) bid_value_display,
3186: pe.price_element_type_id,
3187: pe.sequence_number,
3188: pe.display_target_flag,
3191: pe.display_to_suppliers_flag,
3192: flv2.meaning pf_type_display,
3193: --only in supplier bid pdf, the buyer response value is in supplier currency and number format
3194: --in neg pdf and buyer side bid pdf, the buyer response value is in buyer currency
3195: nvl2(pf_values.value, decode(pe.pf_type, 'BUYER', decode(pe.pricing_basis, 'PER_UNIT', pon_printing_pkg.format_price(pf_values.value*l_rate, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
3196: 'FIXED_AMOUNT', to_char(pf_values.value*l_rate, l_amount_mask)||' ('||l_currency_code||')',
3197: pon_printing_pkg.format_number(pf_values.value)),
3198: null),
3199: null) buyer_pf_value_display,
3193: --only in supplier bid pdf, the buyer response value is in supplier currency and number format
3194: --in neg pdf and buyer side bid pdf, the buyer response value is in buyer currency
3195: nvl2(pf_values.value, decode(pe.pf_type, 'BUYER', decode(pe.pricing_basis, 'PER_UNIT', pon_printing_pkg.format_price(pf_values.value*l_rate, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
3196: 'FIXED_AMOUNT', to_char(pf_values.value*l_rate, l_amount_mask)||' ('||l_currency_code||')',
3197: pon_printing_pkg.format_number(pf_values.value)),
3198: null),
3199: null) buyer_pf_value_display,
3200: decode(pah.trading_partner_id,
3201: p_trading_partner_id, 'Y',
3262: OPEN line_price_diff_cursor FOR SELECT
3263: ppd.shipment_number,
3264: ppd.price_differential_number,
3265: ppd.price_type,
3266: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
3267: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
3268: FROM pon_price_differentials ppd,
3269: -- bidpdf: add response multiplier for price differentials
3270: pon_bid_price_differentials pbpd
3263: ppd.shipment_number,
3264: ppd.price_differential_number,
3265: ppd.price_type,
3266: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
3267: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
3268: FROM pon_price_differentials ppd,
3269: -- bidpdf: add response multiplier for price differentials
3270: pon_bid_price_differentials pbpd
3271: WHERE ppd.auction_header_id = p_auction_header_id
3299: pbsm.ship_to_organization_id,
3300: mp.organization_code ship_to_organization,
3301: pbsm.ship_to_location_id,
3302: loc.location_code ship_to_location,
3303: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3304: -- in case when supplier add new shipments, there's no target price
3305: decode(pbsm.auction_shipment_number, null, null,
3306: pon_printing_pkg.format_price(
3307: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
3302: loc.location_code ship_to_location,
3303: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3304: -- in case when supplier add new shipments, there's no target price
3305: decode(pbsm.auction_shipment_number, null, null,
3306: pon_printing_pkg.format_price(
3307: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
3308: l_price_mask, l_price_precision)
3309: ) price,
3310:
3312: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_end_date,
3313: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
3314: pbsm.has_price_differentials_flag,
3315: pas.differential_response_type,
3316: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_price,l_price_mask, l_price_precision)) bid_currency_price,
3317: pbsm.price_type,
3318: pbsm.price_discount
3319: FROM pon_auction_shipments_all pas,
3320: pon_auction_item_prices_all paip,
3342: pas.ship_to_organization_id,
3343: mp.organization_code ship_to_organization,
3344: pas.ship_to_location_id,
3345: loc.location_code ship_to_location,
3346: pon_printing_pkg.format_number(pas.quantity) quantity,
3347: pon_printing_pkg.format_price(
3348: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3349: l_price_mask,
3350: l_price_precision
3343: mp.organization_code ship_to_organization,
3344: pas.ship_to_location_id,
3345: loc.location_code ship_to_location,
3346: pon_printing_pkg.format_number(pas.quantity) quantity,
3347: pon_printing_pkg.format_price(
3348: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3349: l_price_mask,
3350: l_price_precision
3351: ) price,
3392: ppd.line_number,
3393: ppd.shipment_number,
3394: ppd.price_differential_number,
3395: ppd.price_type,
3396: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
3397: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
3398: FROM pon_price_differentials ppd,
3399: -- bidpdf: add response multiplier for price differentials
3400: pon_bid_price_differentials pbpd
3393: ppd.shipment_number,
3394: ppd.price_differential_number,
3395: ppd.price_type,
3396: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
3397: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
3398: FROM pon_price_differentials ppd,
3399: -- bidpdf: add response multiplier for price differentials
3400: pon_bid_price_differentials pbpd
3401: WHERE ppd.auction_header_id = p_auction_header_id
3426: CLOSE item_price_diff_cursor;
3427:
3428: OPEN item_quan_cursor FOR SELECT pbsm.auction_shipment_number shipment_number,
3429: pbsm.shipment_number bid_shipment_number,
3430: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3431: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
3432: -- in case when supplier add new shipments, there's no target price
3433: nvl2(pbsm.auction_shipment_number,
3434: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
3427:
3428: OPEN item_quan_cursor FOR SELECT pbsm.auction_shipment_number shipment_number,
3429: pbsm.shipment_number bid_shipment_number,
3430: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3431: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
3432: -- in case when supplier add new shipments, there's no target price
3433: nvl2(pbsm.auction_shipment_number,
3434: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
3435: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
3430: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3431: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
3432: -- in case when supplier add new shipments, there's no target price
3433: nvl2(pbsm.auction_shipment_number,
3434: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
3435: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
3436: p_requested_supplier_id),l_price_mask, l_price_precision)
3437: , null
3438: ) price,
3435: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
3436: p_requested_supplier_id),l_price_mask, l_price_precision)
3437: , null
3438: ) price,
3439: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.unit_price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_unit_price,l_price_mask, l_price_precision)) bid_currency_unit_price
3440: FROM pon_auction_shipments_all pas,
3441: pon_auction_item_prices_all paip,
3442: pon_bid_shipments pbsm
3443: WHERE pbsm.bid_number = p_bid_number
3453: UNION ALL
3454:
3455: SELECT pas.shipment_number,
3456: pas.shipment_number bid_shipment_number,
3457: pon_printing_pkg.format_number(pas.quantity) quantity,
3458: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
3459: pon_printing_pkg.format_price(
3460: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3461: l_price_mask,
3454:
3455: SELECT pas.shipment_number,
3456: pas.shipment_number bid_shipment_number,
3457: pon_printing_pkg.format_number(pas.quantity) quantity,
3458: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
3459: pon_printing_pkg.format_price(
3460: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3461: l_price_mask,
3462: l_price_precision
3455: SELECT pas.shipment_number,
3456: pas.shipment_number bid_shipment_number,
3457: pon_printing_pkg.format_number(pas.quantity) quantity,
3458: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
3459: pon_printing_pkg.format_price(
3460: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3461: l_price_mask,
3462: l_price_precision
3463: ) price,
3711: ftl.name bid_currency_name,
3712: pacr.number_price_decimals,
3713: -- bug 8667493 following column added to display EMD amount, if enabled, in different currencies
3714: to_char((Nvl(pah.emd_amount,0) * pacr.rate),'FM999G999G999G999G999G999G999G999G999G999D00') emd_resp_curr_amount,
3715: pon_printing_pkg.get_display_rate(pacr.rate_dsp,pah.rate_type,pah.rate_date,pah.currency_code,bid_currency_code) display_rate
3716: FROM
3717: pon_auction_headers_all pah,
3718: pon_auction_currency_rates pacr ,
3719: fnd_currencies_tl ftl
3747: ftl.name bid_currency_name,
3748: pbp.number_price_decimals,
3749: -- bug 8667493 following column added to display EMD amount, if enabled, in different currencies
3750: to_char((Nvl(pah.emd_amount,0) * pbp.rate),'FM999G999G999G999G999G999G999G999G999G999D00') emd_resp_curr_amount,
3751: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
3752: FROM
3753: pon_auction_headers_all pah,
3754: pon_bidding_parties pbp,
3755: fnd_currencies_tl ftl
3820: pas.from_range,
3821: pas.to_range,
3822: pas.score,
3823: pas.sequence_number,
3824: pon_printing_pkg.get_acceptable_value(pah.HDR_ATTR_DISPLAY_SCORE,pas.attribute_sequence_number,pa.datatype,pas.from_range,pas.to_range,pas.value,pas.score, p_client_time_zone, p_server_time_zone, p_date_format, l_is_buyer_negpdf) display_score
3825: from
3826: pon_auction_headers_all pah,
3827: pon_attribute_scores pas
3828: where
3898: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name,
3899: pbp.additional_contact_email,
3900: pbp.bid_currency_code,
3901: pbp.rate_dsp,
3902: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as rate_dsp_display,
3903: pbp.number_price_decimals,
3904: pbp.access_type,
3905: pbp.auction_header_id,
3906: pbp.trading_partner_id,
4792: fnd_new_messages msgs
4793: where pah.auction_header_id = p_auction_header_id
4794: AND doctypes.doctype_id = pah.doctype_id
4795: AND msgs.message_name in (
4796: pon_printing_pkg.get_document_message_name('PON_CONT_MERGE_WARNING',doctypes.message_suffix), -- Note: There are contract terms associated to the RFQ that are not included in this document. The contract terms are an inseparable part of this RFQ.
4797: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix), -- Response Style
4798: pon_printing_pkg.get_document_message_name('PON_ALLOW_WITHDRAW_FLAG',doctypes.message_suffix) -- Allow Withdraw Flag
4799: ) and msgs.application_id =396
4800: and msgs.language_code = l_printing_language;
4793: where pah.auction_header_id = p_auction_header_id
4794: AND doctypes.doctype_id = pah.doctype_id
4795: AND msgs.message_name in (
4796: pon_printing_pkg.get_document_message_name('PON_CONT_MERGE_WARNING',doctypes.message_suffix), -- Note: There are contract terms associated to the RFQ that are not included in this document. The contract terms are an inseparable part of this RFQ.
4797: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix), -- Response Style
4798: pon_printing_pkg.get_document_message_name('PON_ALLOW_WITHDRAW_FLAG',doctypes.message_suffix) -- Allow Withdraw Flag
4799: ) and msgs.application_id =396
4800: and msgs.language_code = l_printing_language;
4801:
4794: AND doctypes.doctype_id = pah.doctype_id
4795: AND msgs.message_name in (
4796: pon_printing_pkg.get_document_message_name('PON_CONT_MERGE_WARNING',doctypes.message_suffix), -- Note: There are contract terms associated to the RFQ that are not included in this document. The contract terms are an inseparable part of this RFQ.
4797: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix), -- Response Style
4798: pon_printing_pkg.get_document_message_name('PON_ALLOW_WITHDRAW_FLAG',doctypes.message_suffix) -- Allow Withdraw Flag
4799: ) and msgs.application_id =396
4800: and msgs.language_code = l_printing_language;
4801:
4802:
4836:
4837: END GENERATE_AUCTION_XML;
4838:
4839:
4840: END PON_PRINTING_PKG;