DBA Data[Home] [Help]

APPS.PA_REVENUE_AMT dependencies on PA_CURRENCY

Line 968: SET l.amount = PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

964:
965: l_message_code := 'Error in update on pa_cut_rev_dist_lines_all';
966:
967: UPDATE pa_cust_rev_dist_lines_all l
968: SET l.amount = PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
969: DECODE(code_combination_id, -1, roundoff_amount,
970: -2, roundoff_amount,
971: -roundoff_amount)),
972: l.projfunc_revenue_amount = -- Below lines added for Bug 5042421

Line 974: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

970: -2, roundoff_amount,
971: -roundoff_amount)),
972: l.projfunc_revenue_amount = -- Below lines added for Bug 5042421
973: DECODE(l.revproc_currency_code, l.projfunc_currency_code,
974: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
975: DECODE(code_combination_id, -1, roundoff_amount,
976: -2, roundoff_amount,
977: -roundoff_amount)),
978: projfunc_revenue_amount),

Line 981: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

977: -roundoff_amount)),
978: projfunc_revenue_amount),
979: l.project_revenue_amount =
980: DECODE(l.revproc_currency_code, l.project_currency_code,
981: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
982: DECODE(code_combination_id, -1, roundoff_amount,
983: -2, roundoff_amount,
984: -roundoff_amount)),
985: project_revenue_amount),

Line 988: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

984: -roundoff_amount)),
985: project_revenue_amount),
986: l.funding_revenue_amount =
987: DECODE(l.revproc_currency_code, l.funding_currency_code,
988: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
989: DECODE(code_combination_id, -1, roundoff_amount,
990: -2, roundoff_amount,
991: -roundoff_amount)),
992: funding_revenue_amount),

Line 995: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

991: -roundoff_amount)),
992: funding_revenue_amount),
993: l.revtrans_amount =
994: DECODE(l.revproc_currency_code, l.revtrans_currency_code,
995: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
996: DECODE(code_combination_id, -1, roundoff_amount,
997: -2, roundoff_amount,
998: -roundoff_amount)),
999: revtrans_amount) -- End of Bug 5042421