DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on FND_CURRENCY

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

616: to fix the bug 2124494 for MCB2 */
617: /* Changed the length of the format mask for all column from 15 to 22
618: to fix the bug 2162900 for MCB2 */
619: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

Line 622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))

618: to fix the bug 2162900 for MCB2 */
619: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

Line 624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))

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

622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||
624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

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

624: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
625: || ' * (' ||
626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN

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

626: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
627: || ' - ' ||
628: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN
633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));

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

690: to fix the bug 2124494 for MCB2 */
691: /* Changed the length of the format mask for all column from 15 to 22
692: to fix the bug 2162900 for MCB2 */
693: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

Line 696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))

692: to fix the bug 2162900 for MCB2 */
693: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

Line 698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))

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

696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||
698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

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

698: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
699: || ' * (' ||
700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
705: || ' ))';
706:

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

700: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
701: || ' - ' ||
702: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
703: || ')) - '||
704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
705: || ' ))';
706:
707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);