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 2396: /* No longer precision argument is used; PA_CURRENCY.ROUND_CURRENCY_AMT

2392:
2393: status := 0;
2394: stage := 100;
2395:
2396: /* No longer precision argument is used; PA_CURRENCY.ROUND_CURRENCY_AMT
2397: is going to take care that. */
2398:
2399: --
2400: -- Here the occurrence of ROUND_CURRENCY_AMT was not changed to ROUND_TRANS_CURRENCY_AMT

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

2400: -- Here the occurrence of ROUND_CURRENCY_AMT was not changed to ROUND_TRANS_CURRENCY_AMT
2401: -- because this is used in View Burden Costs for which displays the amount fields in
2402: -- functional currency
2403: --
2404: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2405: into indirect_cost_sum
2406: FROM pa_ind_compiled_sets ics,
2407: pa_compiled_multipliers icpm
2408: WHERE

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

2466:
2467: status := 0;
2468: stage := 100;
2469: /* Begin bug 5391496 */
2470: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2471: -- l_projfunc_currency_code)),
2472: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2473: -- l_denom_currency_code)),
2474: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),

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

2468: stage := 100;
2469: /* Begin bug 5391496 */
2470: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2471: -- l_projfunc_currency_code)),
2472: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2473: -- l_denom_currency_code)),
2474: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2475: -- l_acct_currency_code)),
2476: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),

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

2470: -- SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
2471: -- l_projfunc_currency_code)),
2472: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2473: -- l_denom_currency_code)),
2474: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2475: -- l_acct_currency_code)),
2476: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
2477: -- l_project_currency_code))
2478: -- into indirect_cost_sum,

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

2472: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
2473: -- l_denom_currency_code)),
2474: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_acct * icpm.compiled_multiplier),
2475: -- l_acct_currency_code)),
2476: -- SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
2477: -- l_project_currency_code))
2478: -- into indirect_cost_sum,
2479: -- indirect_cost_denom_sum,
2480: -- indirect_cost_acct_sum,

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

2488: -- AND ics.ind_compiled_set_id = icpm.ind_compiled_set_id
2489: -- AND ics.cost_base =icpm.cost_base /*Bug# 2933915*/
2490: -- AND icpm.cost_base = c_base;
2491:
2492: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2493: l_projfunc_currency_code)),
2494: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2495: l_denom_currency_code)),
2496: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),

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

2490: -- AND icpm.cost_base = c_base;
2491:
2492: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2493: l_projfunc_currency_code)),
2494: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2495: l_denom_currency_code)),
2496: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2497: l_acct_currency_code)),
2498: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),

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

2492: SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost * icpm.compiled_multiplier),
2493: l_projfunc_currency_code)),
2494: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2495: l_denom_currency_code)),
2496: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2497: l_acct_currency_code)),
2498: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),
2499: l_project_currency_code))
2500: into indirect_cost_sum,

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

2494: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_denom * icpm.compiled_multiplier),
2495: l_denom_currency_code)),
2496: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_acct * icpm.compiled_multiplier),
2497: l_acct_currency_code)),
2498: SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((direct_cost_project * icpm.compiled_multiplier),
2499: l_project_currency_code))
2500: into indirect_cost_sum,
2501: indirect_cost_denom_sum,
2502: indirect_cost_acct_sum,