DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on FND_CURRENCY

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

677: to fix the bug 2124494 for MCB2 */
678: /* Changed the length of the format mask for all column from 15 to 22
679: to fix the bug 2162900 for MCB2 */
680: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
681: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
682: || ' ,((' ||
683: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
684: || '/' ||
685: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

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

679: to fix the bug 2162900 for MCB2 */
680: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
681: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
682: || ' ,((' ||
683: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
684: || '/' ||
685: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
686: || ' * (' ||
687: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

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

681: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
682: || ' ,((' ||
683: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
684: || '/' ||
685: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
686: || ' * (' ||
687: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
688: || ' - ' ||
689: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))

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

683: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
684: || '/' ||
685: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
686: || ' * (' ||
687: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
688: || ' - ' ||
689: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
690: || ')) - '||
691: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

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

685: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
686: || ' * (' ||
687: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
688: || ' - ' ||
689: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
690: || ')) - '||
691: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
692: || ' ))';
693: IF g1_debug_mode = 'Y' THEN

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

687: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
688: || ' - ' ||
689: to_char(nvl(event_revenue,0),fnd_currency.get_format_mask(l_currency_code,22))
690: || ')) - '||
691: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
692: || ' ))';
693: IF g1_debug_mode = 'Y' THEN
694: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
695: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));

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

751: to fix the bug 2124494 for MCB2 */
752: /* Changed the length of the format mask for all column from 15 to 22
753: to fix the bug 2162900 for MCB2 */
754: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
755: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
756: || ' ,((' ||
757: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
758: || '/' ||
759: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))

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

753: to fix the bug 2162900 for MCB2 */
754: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
755: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
756: || ' ,((' ||
757: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
758: || '/' ||
759: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
760: || ' * (' ||
761: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))

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

755: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
756: || ' ,((' ||
757: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
758: || '/' ||
759: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
760: || ' * (' ||
761: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
762: || ' - ' ||
763: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))

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

757: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
758: || '/' ||
759: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
760: || ' * (' ||
761: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
762: || ' - ' ||
763: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
764: || ')) - '||
765: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))

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

759: to_char(budget_cost,fnd_currency.get_format_mask(l_currency_code,22))
760: || ' * (' ||
761: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
762: || ' - ' ||
763: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
764: || ')) - '||
765: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
766: || ' ))';
767:

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

761: to_char(budget_revenue,fnd_currency.get_format_mask(l_currency_code,22))
762: || ' - ' ||
763: to_char(nvl(event_invoice,0),fnd_currency.get_format_mask(l_currency_code,22))
764: || ')) - '||
765: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
766: || ' ))';
767:
768: IF g1_debug_mode = 'Y' THEN
769: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);