eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PRINTING_PKG dependencies on PON_PRINTING_PKG

Line 1: PACKAGE BODY PON_PRINTING_PKG as

1: PACKAGE BODY PON_PRINTING_PKG as
2: /* $Header: PONPRNB.pls 120.72.12010000.2 2008/10/30 10:03:38 jianliu ship $ */
3:
4: -------------------------------------------------------------------------------
5:

Line 284: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999.9999999999999999'));

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:

Line 286: return pon_printing_pkg.format_number(to_number(p_value,'9999999999999999999999999999999999999999'));

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

Line 554: --NEED TO SEE IF PON_PRINTING_PKG.UNSET_SESSION_LAGUAGE is to be called

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');

Line 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);

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

Line 866: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';

862: l_start_time DATE;
863: l_end_time DATE;
864: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
865: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
866: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
867:
868:
869: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
870: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;

Line 1266: 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);

1262: 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);
1263: END IF;
1264:
1265: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
1266: 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);
1267: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
1268: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
1269:
1270: OPEN xml_query_cursor FOR

Line 1267: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);

1263: END IF;
1264:
1265: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
1266: 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);
1267: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
1268: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
1269:
1270: OPEN xml_query_cursor FOR
1271: SELECT

Line 1268: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);

1264:
1265: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
1266: 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);
1267: l_two_part_tech_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_technical_meaning);
1268: l_two_part_comm_msg := pon_printing_pkg.get_messages('PON_TWO_PART_SECTION','PART',pon_auction_pkg.get_commercial_meaning);
1269:
1270: OPEN xml_query_cursor FOR
1271: SELECT
1272: pah.auction_header_id,

Line 1348: 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,

1344: pah.auto_extend_number,
1345: pah.auto_extend_enabled_flag,
1346: pah.number_of_extensions,
1347: pah.min_bid_decrement,
1348: 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,
1349: pah.price_driven_auction_flag,
1350: pah.payment_terms_id,
1351: ap.name payment_terms,
1352: pah.freight_terms_code,

Line 1359: pon_printing_pkg.get_carrier_description(pah.org_id,pah.carrier_code) carrier,

1355: fl_fob.meaning fob,
1356: pah.carrier_code,
1357: pah.currency_code,
1358: l_currency_code l_currency_code,
1359: pon_printing_pkg.get_carrier_description(pah.org_id,pah.carrier_code) carrier,
1360: currency_tl.name currency_name,
1361: -- bidpdf: whether this is for a bid pdf
1362: l_is_bidpdf is_bidpdf,
1363: l_price_visibility price_visibility,

Line 1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,

1441: p_printing_warning_flag print_warning_flag,
1442: l_cont_attach_doc_flag contract_attached_doc,
1443: l_cont_nonmerge_flag contract_non_mergeable,
1444: p_neg_printed_with_contracts neg_printed_with_contracts,
1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,

Line 1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,

1442: l_cont_attach_doc_flag contract_attached_doc,
1443: l_cont_nonmerge_flag contract_non_mergeable,
1444: p_neg_printed_with_contracts neg_printed_with_contracts,
1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,

Line 1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,

1443: l_cont_nonmerge_flag contract_non_mergeable,
1444: p_neg_printed_with_contracts neg_printed_with_contracts,
1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,

Line 1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,

1444: p_neg_printed_with_contracts neg_printed_with_contracts,
1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,

Line 1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,

1445: pon_printing_pkg.get_messages('PON_AUCTS_START_CUR_PRICE','CURRENCY_CODE', l_currency_code) start_price_msg,
1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,

Line 1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,

1446: pon_printing_pkg.get_messages('PON_AUCTS_TARGET_PRICE_CURR','CURRENCY_CODE', l_currency_code) target_price_msg,
1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,
1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,

Line 1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,

1447: pon_printing_pkg.get_messages('PON_AUC_CURRENT_PRICE', 'AUCTION_CURRENCY', l_currency_code) current_price_msg,
1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,
1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
1455: -- two-part project messages

Line 1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,

1448: pon_printing_pkg.get_messages('PON_AUCTS_MIN_RELEASE_CURR','AUCTION_CURRENCY', l_currency_code) min_release_amt_msg,
1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,
1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
1455: -- two-part project messages
1456: l_two_part_general_msg two_part_general_info_msg,

Line 1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,

1449: pon_printing_pkg.get_messages('PON_AUCTS_AGREEMENT_AMOUNT_CUR','CURRENCY', l_currency_code) agreement_amount_msg,
1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,
1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
1455: -- two-part project messages
1456: l_two_part_general_msg two_part_general_info_msg,
1457: l_two_part_tech_msg two_part_technical_msg,

Line 1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,

1450: pon_printing_pkg.get_messages('PON_MAX_RTNGE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) max_retainage_amt_curr_msg,
1451: pon_printing_pkg.get_messages('PON_ADVANCE_AMT_WITH_CURR','AUCTION_CURRENCY', l_currency_code) advance_amount_curr_msg,
1452: pon_printing_pkg.get_messages('PON_ESTIMATED_TOTAL_AMT_CURR','CURRENCY_CODE', l_currency_code) estimated_amt_msg,
1453: pon_printing_pkg.get_messages('PON_AUC_PRN_LEGAL_CONSEQUENCES','LEGAL_ENTITY_NAME',entitytl.name) legal_consequences_msg,
1454: pon_printing_pkg.get_messages('PON_AUC_INTERVAL_MIN','MINUTES',pah.staggered_closing_interval) stagger_auc_interval_min,
1455: -- two-part project messages
1456: l_two_part_general_msg two_part_general_info_msg,
1457: l_two_part_tech_msg two_part_technical_msg,
1458: l_two_part_comm_msg two_part_commercial_msg,

Line 1461: 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),

1457: l_two_part_tech_msg two_part_technical_msg,
1458: l_two_part_comm_msg two_part_commercial_msg,
1459: -- bidpdf: doc title and footer
1460: decode(l_is_bidpdf, 'Y',
1461: 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),
1462: 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)
1463: ) page_heading_msg,
1464: pbhs.bid_status,
1465: -- bidpdf: document type

Line 1462: 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)

1458: l_two_part_comm_msg two_part_commercial_msg,
1459: -- bidpdf: doc title and footer
1460: decode(l_is_bidpdf, 'Y',
1461: 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),
1462: 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)
1463: ) page_heading_msg,
1464: pbhs.bid_status,
1465: -- bidpdf: document type
1466: doctypes.doctype_group_name,

Line 1490: pon_printing_pkg.get_user_email(hp1.party_id) email,

1486: pbhs.note_to_auction_owner note_to_buyer, --Note to Buyer
1487: --bidpdf: Response Received Time value
1488: 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,
1489: pbhs.surrog_bid_flag surrog_bid_flag, --Surrogate Bid Flag
1490: pon_printing_pkg.get_user_email(hp1.party_id) email,
1491: pah.abstract_details,
1492: fl_security.meaning security_level,
1493: pah.approval_status,
1494: ps.display_name outcome,

Line 1541: 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,

1537: pah.price_element_enabled_flag,
1538: buyer_phone.phone_number,
1539: buyer_fax.phone_number fax_number,
1540: -- bidpdf: Proxy response decrement
1541: 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,
1542: pon_printing_pkg.get_messages('PON_AUCTS_CUR_PROXY_DEC','CURRENCY_CODE',l_currency_code) supplier_proxy_dec_msg,
1543: -- bidpdf: response total
1544: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
1545: 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)

Line 1542: pon_printing_pkg.get_messages('PON_AUCTS_CUR_PROXY_DEC','CURRENCY_CODE',l_currency_code) supplier_proxy_dec_msg,

1538: buyer_phone.phone_number,
1539: buyer_fax.phone_number fax_number,
1540: -- bidpdf: Proxy response decrement
1541: 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,
1542: pon_printing_pkg.get_messages('PON_AUCTS_CUR_PROXY_DEC','CURRENCY_CODE',l_currency_code) supplier_proxy_dec_msg,
1543: -- bidpdf: response total
1544: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
1545: 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)
1546: ) supplier_bid_total,

Line 1547: pon_printing_pkg.get_messages('PON_BID_CUR_TOTAL','CURRENCY_CODE', l_currency_code) supplier_response_total_msg,

1543: -- bidpdf: response total
1544: decode(p_user_view_type, 'BUYER', to_char(pbhs.buyer_bid_total, l_amount_mask),
1545: 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)
1546: ) supplier_bid_total,
1547: pon_printing_pkg.get_messages('PON_BID_CUR_TOTAL','CURRENCY_CODE', l_currency_code) supplier_response_total_msg,
1548: pah.price_tiers_indicator,
1549:
1550: cursor (
1551: Select

Line 1562: pon_printing_pkg.format_number(paip.quantity) quantity,

1558: paip.ip_category_id,
1559: icx.category_name ip_category_name,
1560: paip.uom_code,
1561: units.unit_of_measure_tl,
1562: pon_printing_pkg.format_number(paip.quantity) quantity,
1563: -- bidpdf: Note to Buyer
1564: pbip.note_to_auction_owner,
1565: -- bidpdf: add bid price info
1566: 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,

Line 1566: 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,

1562: pon_printing_pkg.format_number(paip.quantity) quantity,
1563: -- bidpdf: Note to Buyer
1564: pbip.note_to_auction_owner,
1565: -- bidpdf: add bid price info
1566: 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,
1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
1568: 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,
1569: --in MAS case, pbip.quantity is null, use paip.quantity instead
1570: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(pah.contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,

Line 1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,

1563: -- bidpdf: Note to Buyer
1564: pbip.note_to_auction_owner,
1565: -- bidpdf: add bid price info
1566: 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,
1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
1568: 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,
1569: --in MAS case, pbip.quantity is null, use paip.quantity instead
1570: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(pah.contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
1571: --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,

Line 1577: 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,

1573: 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,
1574: --bidpdf: MAS Score
1575: pbip.total_weighted_score,
1576: --bidpdf: Proxy Minimum
1577: 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,
1578: paip.ship_to_location_id,
1579:
1580: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
1581: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,

Line 1580: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,

1576: --bidpdf: Proxy Minimum
1577: 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,
1578: paip.ship_to_location_id,
1579:
1580: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
1581: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,
1582: p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),l_price_mask, l_price_precision)
1583: target_price,
1584: -- Start price comes from the earlier bid for a supplier if he had bid

Line 1592: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, paip.line_number,

1588: -- auction start price
1589: --untransform_one_price
1590:
1591: DECODE(l_is_supplier_bidpdf, 'Y',
1592: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, paip.line_number,
1593: nvl(pbip.bid_start_price, paip.bid_start_price)*l_rate, paip.quantity,
1594: p_trading_partner_id,
1595: p_trading_partner_contact_id,
1596: p_vendor_site_id,

Line 1599: pon_printing_pkg.format_price(

1595: p_trading_partner_contact_id,
1596: p_vendor_site_id,
1597: p_requested_supplier_id),l_price_mask, l_price_precision),
1598: DECODE(l_start_price_from_prev_rnd, 'N',
1599: pon_printing_pkg.format_price(
1600: pon_transform_bidding_pkg.calculate_price(pah.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),
1601: l_price_mask, l_price_precision),
1602: pon_printing_pkg.format_price(
1603: 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),

Line 1602: pon_printing_pkg.format_price(

1598: DECODE(l_start_price_from_prev_rnd, 'N',
1599: pon_printing_pkg.format_price(
1600: pon_transform_bidding_pkg.calculate_price(pah.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),
1601: l_price_mask, l_price_precision),
1602: pon_printing_pkg.format_price(
1603: 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),
1604: l_price_mask, l_price_precision)
1605: )
1606: ) bid_start_price,

Line 1656: pon_printing_pkg.format_price(paip.current_price, l_price_mask, l_price_precision) current_price,

1652: paip.requisition_number,
1653: paip.line_origination_code,
1654: nvl2(paip.source_doc_number, paip.source_doc_number || nvl2(paip.source_line_number, ' / ' || paip.source_line_number, null), null) source_doc_line_display,
1655: lt.line_type,
1656: pon_printing_pkg.format_price(paip.current_price, l_price_mask, l_price_precision) current_price,
1657: pon_printing_pkg.format_price(paip.unit_target_price, l_price_mask, l_price_precision) unit_target_price,
1658: paip.unit_display_target_flag
1659: ,paip.has_payments_flag
1660: ,to_char(paip.advance_amount*l_rate, l_amount_mask) advance_amount

Line 1657: pon_printing_pkg.format_price(paip.unit_target_price, l_price_mask, l_price_precision) unit_target_price,

1653: paip.line_origination_code,
1654: nvl2(paip.source_doc_number, paip.source_doc_number || nvl2(paip.source_line_number, ' / ' || paip.source_line_number, null), null) source_doc_line_display,
1655: lt.line_type,
1656: pon_printing_pkg.format_price(paip.current_price, l_price_mask, l_price_precision) current_price,
1657: pon_printing_pkg.format_price(paip.unit_target_price, l_price_mask, l_price_precision) unit_target_price,
1658: paip.unit_display_target_flag
1659: ,paip.has_payments_flag
1660: ,to_char(paip.advance_amount*l_rate, l_amount_mask) advance_amount
1661: ,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

Line 1857: pon_printing_pkg.get_display_rate(pacr.rate_dsp,pah.rate_type,pah.rate_date,pah.currency_code,bid_currency_code) display_rate

1853: select
1854: pacr.bid_currency_code,
1855: ftl.name bid_currency_name,
1856: pacr.number_price_decimals,
1857: pon_printing_pkg.get_display_rate(pacr.rate_dsp,pah.rate_type,pah.rate_date,pah.currency_code,bid_currency_code) display_rate
1858: from
1859: pon_auction_currency_rates pacr ,
1860: fnd_currencies_tl ftl
1861: where

Line 1871: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate

1867: SELECT
1868: pbp.bid_currency_code,
1869: ftl.name bid_currency_name,
1870: pbp.number_price_decimals,
1871: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
1872: FROM
1873: pon_bidding_parties pbp,
1874: fnd_currencies_tl ftl
1875: WHERE

Line 1922: 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

1918: pas.from_range,
1919: pas.to_range,
1920: pas.score,
1921: pas.sequence_number,
1922: 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
1923: from
1924: pon_attribute_scores pas
1925: where
1926: pas.auction_header_id = pa.auction_header_id

Line 1979: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as rate_dsp_display,

1975: 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,
1976: pbp.additional_contact_email,
1977: pbp.bid_currency_code,
1978: pbp.rate_dsp,
1979: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as rate_dsp_display,
1980: pbp.number_price_decimals,
1981: pbp.access_type,
1982: pbp.auction_header_id,
1983: pbp.trading_partner_id,

Line 2064: 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||')',

2060: flv.meaning pricing_basis_display,
2061: pe.value value,
2062: --only in supplier bid pdf, the target value is in supplier currency and number format
2063: --in neg pdf and buyer side bid pdf, the target value is in buyer currency
2064: 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||')',
2065: 'FIXED_AMOUNT', to_char(pe.value*l_rate, l_amount_mask) ||' ('||l_currency_code||')',
2066: pon_printing_pkg.format_number(pe.value)),
2067: null) target_value_display,
2068: -- bidpdf: response value

Line 2066: pon_printing_pkg.format_number(pe.value)),

2062: --only in supplier bid pdf, the target value is in supplier currency and number format
2063: --in neg pdf and buyer side bid pdf, the target value is in buyer currency
2064: 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||')',
2065: 'FIXED_AMOUNT', to_char(pe.value*l_rate, l_amount_mask) ||' ('||l_currency_code||')',
2066: pon_printing_pkg.format_number(pe.value)),
2067: null) target_value_display,
2068: -- bidpdf: response value
2069: nvl2(pbpe.bid_currency_value,
2070: decode(pe.pricing_basis,

Line 2072: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',

2068: -- bidpdf: response value
2069: nvl2(pbpe.bid_currency_value,
2070: decode(pe.pricing_basis,
2071: 'PER_UNIT', decode(p_user_view_type,
2072: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
2073: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
2074: '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||')'),
2075: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
2076: null) bid_value_display,

Line 2073: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),

2069: nvl2(pbpe.bid_currency_value,
2070: decode(pe.pricing_basis,
2071: 'PER_UNIT', decode(p_user_view_type,
2072: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
2073: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
2074: '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||')'),
2075: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
2076: null) bid_value_display,
2077: pe.price_element_type_id,

Line 2075: pon_printing_pkg.format_number(pbpe.bid_currency_value)),

2071: 'PER_UNIT', decode(p_user_view_type,
2072: 'BUYER', pon_printing_pkg.format_price(pbpe.auction_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')',
2073: pon_printing_pkg.format_price(pbpe.bid_currency_value, l_price_mask, l_price_precision)||' ('||l_currency_code||')'),
2074: '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||')'),
2075: pon_printing_pkg.format_number(pbpe.bid_currency_value)),
2076: null) bid_value_display,
2077: pe.price_element_type_id,
2078: pe.sequence_number,
2079: pe.display_target_flag,

Line 2086: 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||')',

2082: pe.display_to_suppliers_flag,
2083: flv2.meaning pf_type_display,
2084: --only in supplier bid pdf, the buyer response value is in supplier currency and number format
2085: --in neg pdf and buyer side bid pdf, the buyer response value is in buyer currency
2086: 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||')',
2087: 'FIXED_AMOUNT', to_char(pf_values.value*l_rate, l_amount_mask)||' ('||l_currency_code||')',
2088: pon_printing_pkg.format_number(pf_values.value)),
2089: null),
2090: null) buyer_pf_value_display,

Line 2088: pon_printing_pkg.format_number(pf_values.value)),

2084: --only in supplier bid pdf, the buyer response value is in supplier currency and number format
2085: --in neg pdf and buyer side bid pdf, the buyer response value is in buyer currency
2086: 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||')',
2087: 'FIXED_AMOUNT', to_char(pf_values.value*l_rate, l_amount_mask)||' ('||l_currency_code||')',
2088: pon_printing_pkg.format_number(pf_values.value)),
2089: null),
2090: null) buyer_pf_value_display,
2091: decode(pah.trading_partner_id,
2092: p_trading_partner_id, 'Y',

Line 2224: pon_printing_pkg.format_number(pbsm.quantity) quantity,

2220: pbsm.ship_to_organization_id,
2221: mp.organization_code ship_to_organization,
2222: pbsm.ship_to_location_id,
2223: loc.location_code ship_to_location,
2224: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2225: -- in case when supplier add new shipments, there's no target price
2226: decode(pbsm.auction_shipment_number, null, null,
2227: pon_printing_pkg.format_price(
2228: pon_transform_bidding_pkg.calculate_price(pah.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),

Line 2227: pon_printing_pkg.format_price(

2223: loc.location_code ship_to_location,
2224: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2225: -- in case when supplier add new shipments, there's no target price
2226: decode(pbsm.auction_shipment_number, null, null,
2227: pon_printing_pkg.format_price(
2228: pon_transform_bidding_pkg.calculate_price(pah.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),
2229: l_price_mask, l_price_precision)
2230: ) price,
2231:

Line 2237: 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,

2233: 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,
2234: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
2235: pbsm.has_price_differentials_flag,
2236: pas.differential_response_type,
2237: 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,
2238: pbsm.price_type,
2239: pbsm.price_discount
2240: FROM pon_auction_shipments_all pas,
2241: pon_auction_item_prices_all paip,

Line 2268: pon_printing_pkg.format_number(pas.quantity) quantity,

2264: pas.ship_to_organization_id,
2265: mp.organization_code ship_to_organization,
2266: pas.ship_to_location_id,
2267: loc.location_code ship_to_location,
2268: pon_printing_pkg.format_number(pas.quantity) quantity,
2269: pon_printing_pkg.format_price(
2270: pon_transform_bidding_pkg.calculate_price(pah.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),
2271: l_price_mask,
2272: l_price_precision

Line 2269: pon_printing_pkg.format_price(

2265: mp.organization_code ship_to_organization,
2266: pas.ship_to_location_id,
2267: loc.location_code ship_to_location,
2268: pon_printing_pkg.format_number(pas.quantity) quantity,
2269: pon_printing_pkg.format_price(
2270: pon_transform_bidding_pkg.calculate_price(pah.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),
2271: l_price_mask,
2272: l_price_precision
2273: ) price,

Line 2302: pon_printing_pkg.format_number(pbsm.quantity) quantity,

2298: SELECT pbsm.auction_header_id,
2299: pbsm.line_number,
2300: pbsm.auction_shipment_number shipment_number,
2301: pbsm.shipment_number bid_shipment_number,
2302: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2303: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
2304: -- in case when supplier add new shipments, there's no target price
2305: nvl2(pbsm.auction_shipment_number,
2306: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,

Line 2303: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,

2299: pbsm.line_number,
2300: pbsm.auction_shipment_number shipment_number,
2301: pbsm.shipment_number bid_shipment_number,
2302: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2303: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
2304: -- in case when supplier add new shipments, there's no target price
2305: nvl2(pbsm.auction_shipment_number,
2306: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
2307: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,

Line 2306: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,

2302: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2303: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
2304: -- in case when supplier add new shipments, there's no target price
2305: nvl2(pbsm.auction_shipment_number,
2306: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
2307: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
2308: p_requested_supplier_id),l_price_mask, l_price_precision)
2309: , null
2310: ) price,

Line 2311: 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

2307: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
2308: p_requested_supplier_id),l_price_mask, l_price_precision)
2309: , null
2310: ) price,
2311: 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
2312: FROM pon_auction_shipments_all pas,
2313: pon_auction_item_prices_all paip,
2314: pon_bid_shipments pbsm
2315: WHERE pbsm.bid_number = pbhs.bid_number

Line 2330: pon_printing_pkg.format_number(pas.quantity) quantity,

2326: SELECT pas.auction_header_id,
2327: pas.line_number,
2328: pas.shipment_number,
2329: pas.shipment_number bid_shipment_number,
2330: pon_printing_pkg.format_number(pas.quantity) quantity,
2331: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
2332: pon_printing_pkg.format_price(
2333: pon_transform_bidding_pkg.calculate_price(pah.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),
2334: l_price_mask,

Line 2331: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,

2327: pas.line_number,
2328: pas.shipment_number,
2329: pas.shipment_number bid_shipment_number,
2330: pon_printing_pkg.format_number(pas.quantity) quantity,
2331: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
2332: pon_printing_pkg.format_price(
2333: pon_transform_bidding_pkg.calculate_price(pah.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),
2334: l_price_mask,
2335: l_price_precision

Line 2332: pon_printing_pkg.format_price(

2328: pas.shipment_number,
2329: pas.shipment_number bid_shipment_number,
2330: pon_printing_pkg.format_number(pas.quantity) quantity,
2331: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
2332: pon_printing_pkg.format_price(
2333: pon_transform_bidding_pkg.calculate_price(pah.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),
2334: l_price_mask,
2335: l_price_precision
2336: ) price,

Line 2372: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price

2368: ,lkp1.displayed_field payment_type_disp
2369: ,pay.quantity
2370: ,pay.uom_code
2371: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2372: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2373: ,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
2374: ,pay.work_approver_user_id
2375: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2376: FROM per_all_people_f per

Line 2449: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price

2445: ,lkp1.displayed_field payment_type_disp
2446: ,pay.quantity
2447: ,pay.uom_code
2448: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2449: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2450: ,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
2451: ,pay.work_approver_user_id
2452: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2453: FROM per_all_people_f per

Line 2472: ,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

2468: ,pay.project_exp_organization_id project_exp_organization_id
2469: ,hrorg.name project_exp_organization_name
2470: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
2471: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2472: ,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
2473: ,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
2474: ,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
2475: FROM
2476: pon_auc_payments_shipments pay,

Line 2594: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,

2590: ppd.line_number,
2591: ppd.shipment_number,
2592: ppd.price_differential_number,
2593: ppd.price_type,
2594: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
2595: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
2596: FROM pon_price_differentials ppd,
2597: -- bidpdf: add response multiplier for price differentials
2598: pon_bid_price_differentials pbpd

Line 2595: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier

2591: ppd.shipment_number,
2592: ppd.price_differential_number,
2593: ppd.price_type,
2594: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
2595: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
2596: FROM pon_price_differentials ppd,
2597: -- bidpdf: add response multiplier for price differentials
2598: pon_bid_price_differentials pbpd
2599: WHERE ppd.auction_header_id = pah.auction_header_id

Line 2613: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,

2609: ppd.line_number,
2610: ppd.shipment_number,
2611: ppd.price_differential_number,
2612: ppd.price_type,
2613: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
2614: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
2615: FROM pon_price_differentials ppd,
2616: -- bidpdf: add response multiplier for price differentials
2617: pon_bid_price_differentials pbpd

Line 2614: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier

2610: ppd.shipment_number,
2611: ppd.price_differential_number,
2612: ppd.price_type,
2613: pon_printing_pkg.format_number(ppd.multiplier) as target_multiplier,
2614: pon_printing_pkg.format_number(pbpd.multiplier) as multiplier
2615: FROM pon_price_differentials ppd,
2616: -- bidpdf: add response multiplier for price differentials
2617: pon_bid_price_differentials pbpd
2618: WHERE ppd.auction_header_id = pah.auction_header_id

Line 3125: 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.

3121: message_text
3122: from
3123: fnd_new_messages
3124: where message_name in (
3125: 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.
3126: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix) -- Response Style
3127: ) and application_id =396
3128: and language_code = l_printing_language) as DOCUMENT_SPECIFIC_MESSAGES
3129: from

Line 3126: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix) -- Response Style

3122: from
3123: fnd_new_messages
3124: where message_name in (
3125: 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.
3126: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix) -- Response Style
3127: ) and application_id =396
3128: and language_code = l_printing_language) as DOCUMENT_SPECIFIC_MESSAGES
3129: from
3130: pon_auction_headers_all pah ,

Line 3270: END PON_PRINTING_PKG;

3266: END GENERATE_AUCTION_XML;
3267:
3268:
3269:
3270: END PON_PRINTING_PKG;