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_AUCTION_PKG

Line 555: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, USERENV('LANG'));

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');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');

Line 557: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');

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');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');

Line 558: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');

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');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');

Line 559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');

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');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');

Line 560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');

556:
557: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
558: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');
564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');

Line 561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');

557: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
558: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');
564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');
565:

Line 562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');

558: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');
564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');
565:
566: dateFmtMask := p_date_format;

Line 563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');

559: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');
564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');
565:
566: dateFmtMask := p_date_format;
567: dateFmtSave := 'DD-MM-RRRR';

Line 564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');

560: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
561: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
562: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
563: msgGreaterThan := PON_AUCTION_PKG.getMessage('PON_AUC_GREATER_THAN');
564: msgUpTo := PON_AUCTION_PKG.getMessage('PON_AUC_UP_TO');
565:
566: dateFmtMask := p_date_format;
567: dateFmtSave := 'DD-MM-RRRR';
568:

Line 670: l_display_rate := (1/PON_AUCTION_PKG.getClosestRate(p_auction_currency_code,p_bid_currency_code,p_rate_date,p_rate_type,0));

666: l_display_rate := p_rate_dsp;
667:
668: else
669:
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);

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 1334: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,

1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1333: pah.time_zone,
1334: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
1335: pah.open_auction_now_flag,
1336: pah.publish_auction_now_flag,
1337: fl.meaning pon_bid_visibility_display,
1338: pah.bid_visibility_code,

Line 1529: pon_auction_pkg.GetPAOUInstalled(pah.org_id) projects_installed_flag,

1525: postyl.retainage_flag,
1526: postyl.progress_payment_flag,
1527: postyl.contract_financing_flag,
1528: NVL((SELECT pdsv.enabled_flag FROM po_doc_style_values pdsv WHERE pdsv.style_id = pah.po_style_id AND pdsv.style_attribute_name = 'PAY_ITEM_TYPES' AND pdsv.style_allowed_value = 'RATE'), 'N') rate_payments_allowed_flag,
1529: pon_auction_pkg.GetPAOUInstalled(pah.org_id) projects_installed_flag,
1530: pon_auction_pkg.GetGMSOUInstalled(pah.org_id) grants_installed_flag,
1531: pah.large_neg_enabled_flag,
1532: pah.team_scoring_enabled_flag,
1533: pah.has_scoring_teams_flag,

Line 1530: pon_auction_pkg.GetGMSOUInstalled(pah.org_id) grants_installed_flag,

1526: postyl.progress_payment_flag,
1527: postyl.contract_financing_flag,
1528: NVL((SELECT pdsv.enabled_flag FROM po_doc_style_values pdsv WHERE pdsv.style_id = pah.po_style_id AND pdsv.style_attribute_name = 'PAY_ITEM_TYPES' AND pdsv.style_allowed_value = 'RATE'), 'N') rate_payments_allowed_flag,
1529: pon_auction_pkg.GetPAOUInstalled(pah.org_id) projects_installed_flag,
1530: pon_auction_pkg.GetGMSOUInstalled(pah.org_id) grants_installed_flag,
1531: pah.large_neg_enabled_flag,
1532: pah.team_scoring_enabled_flag,
1533: pah.has_scoring_teams_flag,
1534: NVL(pah.enforce_prevrnd_bid_price_flag, 'N') enforce_prevrnd_bid_price_flag,

Line 1636: pon_auction_pkg.getNeedByDatesToPrint(paip.auction_header_id,paip.line_number,p_date_format) as need_by_dates_to_print,

1632: paip.has_price_differentials_flag,
1633: paip.price_diff_shipment_number,
1634: paip.differential_response_type,
1635: paip.purchase_basis,
1636: pon_auction_pkg.getNeedByDatesToPrint(paip.auction_header_id,paip.line_number,p_date_format) as need_by_dates_to_print,
1637: paip.document_disp_line_number,
1638: paip.group_type,
1639: decode(paip.parent_line_number, null,to_char(null),(select paip2.item_description from pon_auction_item_prices_all paip2 where paip2.auction_header_id = paip.auction_header_id and paip2.line_number = paip.parent_line_number)) parent_line_description,
1640: tl.territory_short_name country_name,

Line 2710: --and categories.name=pon_auction_pkg.g_supplier_attachment

2706: ad.entity_name IN ('PON_BID_HEADERS',
2707: 'PON_BID_ITEM_PRICES')
2708: and ad.pk1_value = to_char(p_auction_header_id)
2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment
2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
2712: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
2713: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
2714: and categories.category_id = d.category_id

Line 2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)

2707: 'PON_BID_ITEM_PRICES')
2708: and ad.pk1_value = to_char(p_auction_header_id)
2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment
2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
2712: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
2713: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
2714: and categories.category_id = d.category_id
2715: and categories.category_id = categories_tl.category_id

Line 2712: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)

2708: and ad.pk1_value = to_char(p_auction_header_id)
2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment
2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
2712: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
2713: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
2714: and categories.category_id = d.category_id
2715: and categories.category_id = categories_tl.category_id
2716: and categories_tl.language = l_printing_language

Line 2713: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))

2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment
2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
2712: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
2713: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
2714: and categories.category_id = d.category_id
2715: and categories.category_id = categories_tl.category_id
2716: and categories_tl.language = l_printing_language
2717: --bidpdf:pay item attachments in bid

Line 2738: and categories.name = pon_auction_pkg.g_supplier_attachment

2734: where d.document_id = ad.document_id
2735: and
2736: ad.entity_name IN ('PON_BID_PAYMENTS_SHIPMENTS')
2737: and ad.pk1_value = to_char(pbhs.bid_number)
2738: and categories.name = pon_auction_pkg.g_supplier_attachment
2739: and categories.category_id = d.category_id
2740: and categories.category_id = categories_tl.category_id
2741: and categories_tl.language = l_printing_language
2742: UNION ALL