DBA Data[Home] [Help]

APPS.PA_REVENUE_AMT dependencies on PA_CURRENCY

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

969:
970: l_message_code := 'Error in update on pa_cut_rev_dist_lines_all';
971:
972: UPDATE pa_cust_rev_dist_lines_all l
973: SET l.amount = PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
974: DECODE(code_combination_id, -1, roundoff_amount,
975: -2, roundoff_amount,
976: -roundoff_amount)),
977: l.projfunc_revenue_amount = -- Below lines added for Bug 5042421

Line 979: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

975: -2, roundoff_amount,
976: -roundoff_amount)),
977: l.projfunc_revenue_amount = -- Below lines added for Bug 5042421
978: DECODE(l.revproc_currency_code, l.projfunc_currency_code,
979: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
980: DECODE(code_combination_id, -1, roundoff_amount,
981: -2, roundoff_amount,
982: -roundoff_amount)),
983: projfunc_revenue_amount),

Line 986: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

982: -roundoff_amount)),
983: projfunc_revenue_amount),
984: l.project_revenue_amount =
985: DECODE(l.revproc_currency_code, l.project_currency_code,
986: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
987: DECODE(code_combination_id, -1, roundoff_amount,
988: -2, roundoff_amount,
989: -roundoff_amount)),
990: project_revenue_amount),

Line 993: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

989: -roundoff_amount)),
990: project_revenue_amount),
991: l.funding_revenue_amount =
992: DECODE(l.revproc_currency_code, l.funding_currency_code,
993: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
994: DECODE(code_combination_id, -1, roundoff_amount,
995: -2, roundoff_amount,
996: -roundoff_amount)),
997: funding_revenue_amount),

Line 1000: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -

996: -roundoff_amount)),
997: funding_revenue_amount),
998: l.revtrans_amount =
999: DECODE(l.revproc_currency_code, l.revtrans_currency_code,
1000: PA_CURRENCY.ROUND_CURRENCY_AMT(l.amount -
1001: DECODE(code_combination_id, -1, roundoff_amount,
1002: -2, roundoff_amount,
1003: -roundoff_amount)),
1004: revtrans_amount) -- End of Bug 5042421