DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on FND_CURRENCY

Line 281: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))

277: to fix the bug 2162900 for MCB2 */
278: /* Removed the format mask for Percent_Complete as this was rounding off
279: the value for bug 6660286 */
280: Event_Description := 'Percent Complete Least ' || '(' ||
281: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
282: || ' ,((' ||
283: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
284: || ' * (' ||
285: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

Line 285: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

281: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
282: || ' ,((' ||
283: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
284: || ' * (' ||
285: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
286: || ' - ' ||
287: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
288: || ')) - '||
289: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

Line 287: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))

283: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
284: || ' * (' ||
285: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
286: || ' - ' ||
287: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
288: || ')) - '||
289: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
290: || ' ))';
291:

Line 289: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

285: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
286: || ' - ' ||
287: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
288: || ')) - '||
289: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
290: || ' ))';
291:
292: /** public api to insert event **/
293:

Line 364: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))

360: to fix the bug 2162900 for MCB2 */
361: /* Removed the format mask for Percent_Complete as this was rounding off
362: the value for bug 6660286 */
363: Event_Description := 'Percent Complete Least '|| '(' ||
364: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
365: || ' ,((' ||
366: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
367: || ' * (' ||
368: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

Line 368: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

364: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
365: || ' ,((' ||
366: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
367: || ' * (' ||
368: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
369: || ' - ' ||
370: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
371: || ')) - '||
372: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

Line 370: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))

366: rtrim(to_char(Percent_Complete * 0.01,'0.000000'),'0')
367: || ' * (' ||
368: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
369: || ' - ' ||
370: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
371: || ')) - '||
372: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
373: || ' ))';
374:

Line 372: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

368: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
369: || ' - ' ||
370: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
371: || ')) - '||
372: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
373: || ' ))';
374:
375: IF g1_debug_mode = 'Y' THEN
376: PA_MCB_INVOICE_PKG.log_message('Inv part inside pa_bill_pct.calc_pct_comp_amt event desc :'||Event_Description);