DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_CURRENCY

Line 1868: * indirect_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost*compiled_multiplier,

1864:
1865: /*
1866: * Bug#2110452
1867: *
1868: * indirect_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost*compiled_multiplier,
1869: * l_project_currency_code);
1870: * indirect_cost_denom := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_denom*compiled_multiplier,
1871: * l_denom_currency_code);
1872: * indirect_cost_acct := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_acct*compiled_multiplier,

Line 1870: * indirect_cost_denom := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_denom*compiled_multiplier,

1866: * Bug#2110452
1867: *
1868: * indirect_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost*compiled_multiplier,
1869: * l_project_currency_code);
1870: * indirect_cost_denom := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_denom*compiled_multiplier,
1871: * l_denom_currency_code);
1872: * indirect_cost_acct := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_acct*compiled_multiplier,
1873: * l_acct_currency_code);
1874: * indirect_cost_project := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_project*compiled_multiplier,

Line 1872: * indirect_cost_acct := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_acct*compiled_multiplier,

1868: * indirect_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost*compiled_multiplier,
1869: * l_project_currency_code);
1870: * indirect_cost_denom := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_denom*compiled_multiplier,
1871: * l_denom_currency_code);
1872: * indirect_cost_acct := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_acct*compiled_multiplier,
1873: * l_acct_currency_code);
1874: * indirect_cost_project := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_project*compiled_multiplier,
1875: * l_project_currency_code);
1876: */

Line 1874: * indirect_cost_project := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_project*compiled_multiplier,

1870: * indirect_cost_denom := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_denom*compiled_multiplier,
1871: * l_denom_currency_code);
1872: * indirect_cost_acct := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_acct*compiled_multiplier,
1873: * l_acct_currency_code);
1874: * indirect_cost_project := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(direct_cost_project*compiled_multiplier,
1875: * l_project_currency_code);
1876: */
1877:
1878: stage := 700;

Line 2426: /* No longer precision argument is used; PA_CURRENCY.ROUND_CURRENCY_AMT

2422:
2423: status := 0;
2424: stage := 100;
2425:
2426: /* No longer precision argument is used; PA_CURRENCY.ROUND_CURRENCY_AMT
2427: is going to take care that. */
2428:
2429: --
2430: -- Here the occurrence of ROUND_CURRENCY_AMT was not changed to ROUND_TRANS_CURRENCY_AMT

Line 2434: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))

2430: -- Here the occurrence of ROUND_CURRENCY_AMT was not changed to ROUND_TRANS_CURRENCY_AMT
2431: -- because this is used in View Burden Costs for which displays the amount fields in
2432: -- functional currency
2433: --
2434: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2435: into indirect_cost_sum
2436: FROM pa_ind_compiled_sets ics,
2437: pa_compiled_multipliers icpm
2438: WHERE

Line 2500: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),

2496:
2497: status := 0;
2498: stage := 100;
2499: /* Begin bug 5391496 */
2500: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2501: -- l_projfunc_currency_code)),
2502: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2503: -- l_denom_currency_code)),
2504: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),

Line 2502: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),

2498: stage := 100;
2499: /* Begin bug 5391496 */
2500: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2501: -- l_projfunc_currency_code)),
2502: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2503: -- l_denom_currency_code)),
2504: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2505: -- l_acct_currency_code)),
2506: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),

Line 2504: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),

2500: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2501: -- l_projfunc_currency_code)),
2502: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2503: -- l_denom_currency_code)),
2504: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2505: -- l_acct_currency_code)),
2506: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
2507: -- l_project_currency_code))
2508: -- into indirect_cost_sum,

Line 2506: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),

2502: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2503: -- l_denom_currency_code)),
2504: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2505: -- l_acct_currency_code)),
2506: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
2507: -- l_project_currency_code))
2508: -- into indirect_cost_sum,
2509: -- indirect_cost_denom_sum,
2510: -- indirect_cost_acct_sum,

Line 2522: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),

2518: -- AND ics.ind_compiled_set_id = icpm.ind_compiled_set_id
2519: -- AND ics.cost_base =icpm.cost_base /*Bug# 2933915*/
2520: -- AND icpm.cost_base = c_base;
2521:
2522: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2523: l_projfunc_currency_code)),
2524: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2525: l_denom_currency_code)),
2526: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),

Line 2524: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),

2520: -- AND icpm.cost_base = c_base;
2521:
2522: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2523: l_projfunc_currency_code)),
2524: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2525: l_denom_currency_code)),
2526: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2527: l_acct_currency_code)),
2528: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),

Line 2526: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),

2522: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2523: l_projfunc_currency_code)),
2524: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2525: l_denom_currency_code)),
2526: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2527: l_acct_currency_code)),
2528: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),
2529: l_project_currency_code))
2530: into indirect_cost_sum,

Line 2528: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),

2524: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2525: l_denom_currency_code)),
2526: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2527: l_acct_currency_code)),
2528: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),
2529: l_project_currency_code))
2530: into indirect_cost_sum,
2531: indirect_cost_denom_sum,
2532: indirect_cost_acct_sum,