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

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

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

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

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

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

Line 2283: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,

2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2282: pah.time_zone,
2283: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
2284: pah.open_auction_now_flag,
2285: pah.publish_auction_now_flag,
2286: fl.meaning pon_bid_visibility_display,
2287: pah.bid_visibility_code,

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

2477: postyl.retainage_flag,
2478: postyl.progress_payment_flag,
2479: postyl.contract_financing_flag,
2480: 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,
2481: pon_auction_pkg.GetPAOUInstalled(pah.org_id) projects_installed_flag,
2482: pon_auction_pkg.GetGMSOUInstalled(pah.org_id) grants_installed_flag,
2483: pah.large_neg_enabled_flag,
2484: pah.team_scoring_enabled_flag,
2485: pah.has_scoring_teams_flag,

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

2478: postyl.progress_payment_flag,
2479: postyl.contract_financing_flag,
2480: 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,
2481: pon_auction_pkg.GetPAOUInstalled(pah.org_id) projects_installed_flag,
2482: pon_auction_pkg.GetGMSOUInstalled(pah.org_id) grants_installed_flag,
2483: pah.large_neg_enabled_flag,
2484: pah.team_scoring_enabled_flag,
2485: pah.has_scoring_teams_flag,
2486: NVL(pah.enforce_prevrnd_bid_price_flag, 'N') enforce_prevrnd_bid_price_flag,

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

2777: paip.has_price_differentials_flag,
2778: paip.price_diff_shipment_number,
2779: paip.differential_response_type,
2780: paip.purchase_basis,
2781: pon_auction_pkg.getNeedByDatesToPrint(paip.auction_header_id,paip.line_number,p_date_format) as need_by_dates_to_print,
2782: paip.document_disp_line_number,
2783: paip.group_type,
2784: 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,
2785: tl.territory_short_name country_name,

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

4294: AND ad.entity_name IN ('PON_BID_HEADERS',
4295: 'PON_BID_ITEM_PRICES')
4296: and ad.pk1_value = to_char(p_auction_header_id)
4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment
4299: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
4300: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
4301: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
4302: and categories.category_id = d.category_id

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

4295: 'PON_BID_ITEM_PRICES')
4296: and ad.pk1_value = to_char(p_auction_header_id)
4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment
4299: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
4300: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
4301: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
4302: and categories.category_id = d.category_id
4303: and categories.category_id = categories_tl.category_id

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

4296: and ad.pk1_value = to_char(p_auction_header_id)
4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment
4299: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
4300: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
4301: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
4302: and categories.category_id = d.category_id
4303: and categories.category_id = categories_tl.category_id
4304: and categories_tl.language = l_printing_language

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

4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment
4299: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)
4300: or (l_attach_categ_option = 2 and categories.name = pon_auction_pkg.g_technical_attachment)
4301: or (l_attach_categ_option = 3 and categories.name in (pon_auction_pkg.g_technical_attachment,pon_auction_pkg.g_commercial_attachment)))
4302: and categories.category_id = d.category_id
4303: and categories.category_id = categories_tl.category_id
4304: and categories_tl.language = l_printing_language
4305: --bidpdf:pay item attachments in bid

Line 4329: and categories.name = pon_auction_pkg.g_supplier_attachment

4325: and pbhs.bid_number (+) = p_bid_number
4326: and
4327: ad.entity_name IN ('PON_BID_PAYMENTS_SHIPMENTS')
4328: and ad.pk1_value = to_char(pbhs.bid_number)
4329: and categories.name = pon_auction_pkg.g_supplier_attachment
4330: and categories.category_id = d.category_id
4331: and categories.category_id = categories_tl.category_id
4332: and categories_tl.language = l_printing_language
4333: UNION ALL