eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_BUDGET_VERSIONS

Line 13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;

9: g_rowcount NUMBER;
10: g_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
11: g_project_currency_code Varchar2(30);
12: g_projfunc_currency_code Varchar2(30);
13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;
14: g_project_id pa_resource_assignments.project_id%TYPE;
15: g_task_id pa_resource_assignments.task_id%TYPE;
16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

Line 18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;

14: g_project_id pa_resource_assignments.project_id%TYPE;
15: g_task_id pa_resource_assignments.task_id%TYPE;
16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;

Line 20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;
23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;

Line 27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;
25: g_spread_required_flag VARCHAR2(1) := 'N';
26: g_rollup_required_flag VARCHAR2(1) := 'Y';
27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
28: g_proj_structure_ver_id NUMBER;
29: g_ra_bl_txn_currency_code pa_budget_lines.txn_currency_code%TYPE := NULL;
30: g_line_start_date pa_fp_res_assignments_tmp.line_start_date%TYPE;
31: g_line_end_date pa_fp_res_assignments_tmp.line_end_date%TYPE;

Line 268: ,pa_budget_versions bv

264: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
265: ,decode(fpt.plan_class_code,'BUDGET'
266: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
267: FROM pa_proj_fp_options pfo
268: ,pa_budget_versions bv
269: ,pa_projects_all pp
270: ,pa_fin_plan_types_b fpt
271: WHERE pfo.fin_plan_version_id = bv.budget_version_id
272: AND bv.project_id = pp.project_id

Line 1417: ,pa_budget_versions v

1413: ,o.project_rev_rate_type
1414: ,o.project_rev_rate_date_type
1415: ,o.project_rev_rate_date
1416: FROM pa_proj_fp_options o
1417: ,pa_budget_versions v
1418: WHERE v.budget_version_id = p_budget_version_id
1419: AND o.project_id = v.project_id
1420: AND nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)
1421: AND o.fin_plan_version_id = v.budget_version_id;

Line 2238: p_project_id IN pa_budget_versions.project_id%type

2234:
2235: END DbugPjiVals;
2236:
2237: PROCEDURE Update_PCPFC_rounding_diff(
2238: p_project_id IN pa_budget_versions.project_id%type
2239: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2240: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2241: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2242: ,p_wp_cost_enabled_flag IN varchar2

Line 2239: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2235: END DbugPjiVals;
2236:
2237: PROCEDURE Update_PCPFC_rounding_diff(
2238: p_project_id IN pa_budget_versions.project_id%type
2239: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2240: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2241: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2242: ,p_wp_cost_enabled_flag IN varchar2
2243: ,p_budget_version_type IN varchar2

Line 2557: p_project_id IN pa_budget_versions.project_id%type

2553: /* This API rounds off the amounts to currency precision level and the last budget line of resoruce per currency will be
2554: * updated with the rounding discrepancy amounts
2555: */
2556: PROCEDURE Update_rounding_diff(
2557: p_project_id IN pa_budget_versions.project_id%type
2558: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2559: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2560: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2561: ,p_wp_cost_enabled_flag IN varchar2

Line 2558: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2554: * updated with the rounding discrepancy amounts
2555: */
2556: PROCEDURE Update_rounding_diff(
2557: p_project_id IN pa_budget_versions.project_id%type
2558: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2559: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2560: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2561: ,p_wp_cost_enabled_flag IN varchar2
2562: ,p_budget_version_type IN varchar2

Line 2794: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2790: -- 3. p_resource_assignment_tab and txn_currency_code_tab must not have NULL values if passed
2791: -- 4. If any other parameter is passed they must have an equal count to _resource_assignment_tab
2792: */
2793: PROCEDURE validate_inputs( p_project_id IN pa_projects_all.project_id%TYPE
2794: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2795: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2796: ,p_refresh_rates_flag IN VARCHAR2 DEFAULT NULL
2797: ,p_refresh_conv_rates_flag IN VARCHAR2 DEFAULT NULL
2798: ,p_mass_adjust_flag IN VARCHAR2

Line 3730: l_version_name pa_budget_versions.version_name%type;

3726: l_agreement_id Number;
3727: l_ci_id Number;
3728: l_agr_curr_code Varchar2(100);
3729: l_agr_con_reqd_flag varchar2(1) := 'N';
3730: l_version_name pa_budget_versions.version_name%type;
3731: l_version_type pa_budget_versions.version_type%type;
3732: l_error_msg_code Varchar2(100);
3733: INVALID_EXCEPTION EXCEPTION;
3734: BEGIN

Line 3731: l_version_type pa_budget_versions.version_type%type;

3727: l_ci_id Number;
3728: l_agr_curr_code Varchar2(100);
3729: l_agr_con_reqd_flag varchar2(1) := 'N';
3730: l_version_name pa_budget_versions.version_name%type;
3731: l_version_type pa_budget_versions.version_type%type;
3732: l_error_msg_code Varchar2(100);
3733: INVALID_EXCEPTION EXCEPTION;
3734: BEGIN
3735: IF p_pa_debug_mode = 'Y' Then

Line 4721: ,pa_budget_versions pbv

4717: ppfo.all_time_phased_code) time_phase_code
4718: FROM gl_sets_of_books gsb
4719: ,pa_implementations_all pia
4720: ,pa_projects_all ppa
4721: ,pa_budget_versions pbv
4722: ,pa_proj_fp_options ppfo
4723: WHERE ppa.project_id = pbv.project_id
4724: AND pbv.budget_version_id = ppfo.fin_plan_version_id
4725: /* MOAC Changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */

Line 5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

5635: -- p_raw_revenue is passed then must pass p_override_currency_code
5636: */
5637:
5638: PROCEDURE chk_req_rate_api_inputs
5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE

Line 5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE

5636: */
5637:
5638: PROCEDURE chk_req_rate_api_inputs
5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE

Line 6942: -- pa_resource_assignments to pa_budget_versions

6938:
6939: /*
6940: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6941: -- This procedure is called to Rollup PC and PFC numbers stored in
6942: -- pa_resource_assignments to pa_budget_versions
6943: */
6944: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6945: ,x_return_status OUT NOCOPY VARCHAR2
6946: ,x_msg_count OUT NOCOPY NUMBER

Line 6944: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

6940: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6941: -- This procedure is called to Rollup PC and PFC numbers stored in
6942: -- pa_resource_assignments to pa_budget_versions
6943: */
6944: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6945: ,x_return_status OUT NOCOPY VARCHAR2
6946: ,x_msg_count OUT NOCOPY NUMBER
6947: ,x_msg_data OUT NOCOPY VARCHAR2) IS
6948:

Line 7015: --print_msg(to_char(l_stage)||' rollup_ra_csr%NOTFOUND nothing to rollup to pa_budget_versions');

7011:
7012: FETCH rollup_ra_csr into rollup_ra_rec;
7013: IF rollup_ra_csr%NOTFOUND THEN
7014: l_stage := 6010;
7015: --print_msg(to_char(l_stage)||' rollup_ra_csr%NOTFOUND nothing to rollup to pa_budget_versions');
7016: BEGIN
7017: l_stage := 6015;
7018: UPDATE pa_budget_versions SET
7019: raw_cost = to_number(NULL)

Line 7018: UPDATE pa_budget_versions SET

7014: l_stage := 6010;
7015: --print_msg(to_char(l_stage)||' rollup_ra_csr%NOTFOUND nothing to rollup to pa_budget_versions');
7016: BEGIN
7017: l_stage := 6015;
7018: UPDATE pa_budget_versions SET
7019: raw_cost = to_number(NULL)
7020: ,burdened_cost = to_number(NULL)
7021: ,revenue = to_number(NULL)
7022: ,total_project_raw_cost = to_number(NULL)

Line 7036: print_msg(to_char(l_stage)||' ERROR Updating pa_budget_versions in rollup_pf_pfc_to_bv');

7032: ,last_update_login = fnd_global.login_id
7033: WHERE budget_version_id = p_budget_version_id;
7034: EXCEPTION
7035: WHEN OTHERS THEN
7036: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
7037: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
7038: IF P_PA_DEBUG_MODE = 'Y' THEN
7039: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7040: END IF;

Line 7037: pa_debug.g_err_stage := to_char(l_stage)||': ERROR Updating pa_budget_versions in rollup_pf_pfc_to_bv';

7033: WHERE budget_version_id = p_budget_version_id;
7034: EXCEPTION
7035: WHEN OTHERS THEN
7036: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
7037: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
7038: IF P_PA_DEBUG_MODE = 'Y' THEN
7039: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7040: END IF;
7041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7049: /*print_msg(to_char(l_stage)||'UPDATE pa_budget_versions with the following:');

7045: RETURN;
7046: END;
7047: ELSE
7048: l_stage := 6020;
7049: /*print_msg(to_char(l_stage)||'UPDATE pa_budget_versions with the following:');
7050: print_msg(' raw_cost = '||to_char(rollup_ra_rec.total_plan_raw_cost));
7051: print_msg(' burdened_cost = '||to_char(rollup_ra_rec.total_plan_burdened_cost));
7052: print_msg(' revenue = '||to_char(rollup_ra_rec.total_plan_revenue));
7053: print_msg(' total_project_raw_cost = '||to_char(rollup_ra_rec.total_project_raw_cost));

Line 7062: UPDATE pa_budget_versions

7058: */
7059:
7060: BEGIN
7061: l_stage := 6029;
7062: UPDATE pa_budget_versions
7063: SET raw_cost = rollup_ra_rec.total_plan_raw_cost
7064: ,burdened_cost = rollup_ra_rec.total_plan_burdened_cost
7065: ,revenue = rollup_ra_rec.total_plan_revenue
7066: ,total_project_raw_cost = rollup_ra_rec.total_project_raw_cost

Line 7080: print_msg(to_char(l_stage)||' ERROR Updating pa_budget_versions in rollup_pf_pfc_to_bv');

7076: ,last_update_login = fnd_global.login_id
7077: WHERE budget_version_id = p_budget_version_id;
7078: EXCEPTION
7079: WHEN OTHERS THEN
7080: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
7081: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
7082: IF P_PA_DEBUG_MODE = 'Y' THEN
7083: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7084: END IF;

Line 7081: pa_debug.g_err_stage := to_char(l_stage)||': ERROR Updating pa_budget_versions in rollup_pf_pfc_to_bv';

7077: WHERE budget_version_id = p_budget_version_id;
7078: EXCEPTION
7079: WHEN OTHERS THEN
7080: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
7081: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
7082: IF P_PA_DEBUG_MODE = 'Y' THEN
7083: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
7084: END IF;
7085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7242: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7238: */
7239:
7240:
7241: PROCEDURE convert_ra_txn_currency
7242: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7243: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7244: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE

Line 7850: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7846: * p_addl_qty_tab,p_addl_raw_cost_tab,p_addl_burdened_cost_tab,p_addl_revenue_tab
7847: *
7848: */
7849: PROCEDURE calculate ( p_project_id IN pa_projects_all.project_id%TYPE
7850: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7851: ,p_refresh_rates_flag IN VARCHAR2 := 'N'
7852: ,p_refresh_conv_rates_flag IN VARCHAR2 := 'N'
7853: ,p_spread_required_flag IN VARCHAR2 := 'Y'
7854: ,p_conv_rates_required_flag IN VARCHAR2 := 'Y'

Line 8110: ,pa_budget_versions bv

8106: ,bv.ci_id CiId
8107: /*Bugfix:4272944 */
8108: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
8109: FROM pa_proj_fp_options pfo
8110: ,pa_budget_versions bv
8111: ,pa_projects_all pp
8112: WHERE pfo.fin_plan_version_id = bv.budget_version_id
8113: AND bv.project_id = pp.project_id
8114: AND bv.budget_version_id = p_budget_version_id;

Line 8180: ,pa_budget_versions bv

8176: ,tmp.txn_init_burdened_cost
8177: ,tmp.txn_init_revenue
8178: -- End for 6781055
8179: FROM pa_fp_rollup_tmp tmp
8180: ,pa_budget_versions bv
8181: ,pa_resource_assignments ra
8182: ,pa_resource_list_members rl
8183: WHERE bv.budget_version_id = p_budget_version_id
8184: AND ra.budget_version_id = bv.budget_version_id

Line 11298: -- ROLLUP PC and PFC numbers to pa_budget_versions

11294: End If;
11295: **************END of MRC Elimination changes ***/
11296:
11297: /*
11298: -- ROLLUP PC and PFC numbers to pa_budget_versions
11299: */
11300: IF NVL(l_entire_return_status,'S') = 'S' Then
11301: l_stage := 1300;
11302: If P_PA_DEBUG_MODE = 'Y' Then

Line 11931: ,pa_budget_versions bv

11927: ,pp.non_labor_sch_type
11928: ,bv.project_structure_version_id
11929: ,bv.project_id
11930: FROM pa_proj_fp_options pfo
11931: ,pa_budget_versions bv
11932: ,pa_projects_all pp
11933: WHERE pfo.fin_plan_version_id = bv.budget_version_id
11934: AND bv.budget_version_id = p_budget_version_id
11935: AND pp.project_id = bv.project_id