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 1387: ,pa_budget_versions v

1383: ,o.project_rev_rate_type
1384: ,o.project_rev_rate_date_type
1385: ,o.project_rev_rate_date
1386: FROM pa_proj_fp_options o
1387: ,pa_budget_versions v
1388: WHERE v.budget_version_id = p_budget_version_id
1389: AND o.project_id = v.project_id
1390: AND nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)
1391: AND o.fin_plan_version_id = v.budget_version_id;

Line 2208: p_project_id IN pa_budget_versions.project_id%type

2204:
2205: END DbugPjiVals;
2206:
2207: PROCEDURE Update_PCPFC_rounding_diff(
2208: p_project_id IN pa_budget_versions.project_id%type
2209: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2210: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2211: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2212: ,p_wp_cost_enabled_flag IN varchar2

Line 2209: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2205: END DbugPjiVals;
2206:
2207: PROCEDURE Update_PCPFC_rounding_diff(
2208: p_project_id IN pa_budget_versions.project_id%type
2209: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2210: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2211: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2212: ,p_wp_cost_enabled_flag IN varchar2
2213: ,p_budget_version_type IN varchar2

Line 2527: p_project_id IN pa_budget_versions.project_id%type

2523: /* This API rounds off the amounts to currency precision level and the last budget line of resoruce per currency will be
2524: * updated with the rounding discrepancy amounts
2525: */
2526: PROCEDURE Update_rounding_diff(
2527: p_project_id IN pa_budget_versions.project_id%type
2528: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2529: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2530: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2531: ,p_wp_cost_enabled_flag IN varchar2

Line 2528: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2524: * updated with the rounding discrepancy amounts
2525: */
2526: PROCEDURE Update_rounding_diff(
2527: p_project_id IN pa_budget_versions.project_id%type
2528: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2529: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2530: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2531: ,p_wp_cost_enabled_flag IN varchar2
2532: ,p_budget_version_type IN varchar2

Line 2764: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2760: -- 3. p_resource_assignment_tab and txn_currency_code_tab must not have NULL values if passed
2761: -- 4. If any other parameter is passed they must have an equal count to _resource_assignment_tab
2762: */
2763: PROCEDURE validate_inputs( p_project_id IN pa_projects_all.project_id%TYPE
2764: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2765: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2766: ,p_refresh_rates_flag IN VARCHAR2 DEFAULT NULL
2767: ,p_refresh_conv_rates_flag IN VARCHAR2 DEFAULT NULL
2768: ,p_mass_adjust_flag IN VARCHAR2

Line 3698: l_version_name pa_budget_versions.version_name%type;

3694: l_agreement_id Number;
3695: l_ci_id Number;
3696: l_agr_curr_code Varchar2(100);
3697: l_agr_con_reqd_flag varchar2(1) := 'N';
3698: l_version_name pa_budget_versions.version_name%type;
3699: l_version_type pa_budget_versions.version_type%type;
3700: l_error_msg_code Varchar2(100);
3701: INVALID_EXCEPTION EXCEPTION;
3702: BEGIN

Line 3699: l_version_type pa_budget_versions.version_type%type;

3695: l_ci_id Number;
3696: l_agr_curr_code Varchar2(100);
3697: l_agr_con_reqd_flag varchar2(1) := 'N';
3698: l_version_name pa_budget_versions.version_name%type;
3699: l_version_type pa_budget_versions.version_type%type;
3700: l_error_msg_code Varchar2(100);
3701: INVALID_EXCEPTION EXCEPTION;
3702: BEGIN
3703: IF p_pa_debug_mode = 'Y' Then

Line 4686: ,pa_budget_versions pbv

4682: ppfo.all_time_phased_code) time_phase_code
4683: FROM gl_sets_of_books gsb
4684: ,pa_implementations_all pia
4685: ,pa_projects_all ppa
4686: ,pa_budget_versions pbv
4687: ,pa_proj_fp_options ppfo
4688: WHERE ppa.project_id = pbv.project_id
4689: AND pbv.budget_version_id = ppfo.fin_plan_version_id
4690: /* MOAC Changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */

Line 5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

5600: -- p_raw_revenue is passed then must pass p_override_currency_code
5601: */
5602:
5603: PROCEDURE chk_req_rate_api_inputs
5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE

Line 5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE

5601: */
5602:
5603: PROCEDURE chk_req_rate_api_inputs
5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE

Line 6852: -- pa_resource_assignments to pa_budget_versions

6848:
6849: /*
6850: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6851: -- This procedure is called to Rollup PC and PFC numbers stored in
6852: -- pa_resource_assignments to pa_budget_versions
6853: */
6854: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6855: ,x_return_status OUT NOCOPY VARCHAR2
6856: ,x_msg_count OUT NOCOPY NUMBER

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

6850: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6851: -- This procedure is called to Rollup PC and PFC numbers stored in
6852: -- pa_resource_assignments to pa_budget_versions
6853: */
6854: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6855: ,x_return_status OUT NOCOPY VARCHAR2
6856: ,x_msg_count OUT NOCOPY NUMBER
6857: ,x_msg_data OUT NOCOPY VARCHAR2) IS
6858:

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

6921:
6922: FETCH rollup_ra_csr into rollup_ra_rec;
6923: IF rollup_ra_csr%NOTFOUND THEN
6924: l_stage := 6010;
6925: --print_msg(to_char(l_stage)||' rollup_ra_csr%NOTFOUND nothing to rollup to pa_budget_versions');
6926: BEGIN
6927: l_stage := 6015;
6928: UPDATE pa_budget_versions SET
6929: raw_cost = to_number(NULL)

Line 6928: UPDATE pa_budget_versions SET

6924: l_stage := 6010;
6925: --print_msg(to_char(l_stage)||' rollup_ra_csr%NOTFOUND nothing to rollup to pa_budget_versions');
6926: BEGIN
6927: l_stage := 6015;
6928: UPDATE pa_budget_versions SET
6929: raw_cost = to_number(NULL)
6930: ,burdened_cost = to_number(NULL)
6931: ,revenue = to_number(NULL)
6932: ,total_project_raw_cost = to_number(NULL)

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

6942: ,last_update_login = fnd_global.login_id
6943: WHERE budget_version_id = p_budget_version_id;
6944: EXCEPTION
6945: WHEN OTHERS THEN
6946: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
6947: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
6948: IF P_PA_DEBUG_MODE = 'Y' THEN
6949: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6950: END IF;

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

6943: WHERE budget_version_id = p_budget_version_id;
6944: EXCEPTION
6945: WHEN OTHERS THEN
6946: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
6947: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
6948: IF P_PA_DEBUG_MODE = 'Y' THEN
6949: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6950: END IF;
6951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6955: RETURN;
6956: END;
6957: ELSE
6958: l_stage := 6020;
6959: /*print_msg(to_char(l_stage)||'UPDATE pa_budget_versions with the following:');
6960: print_msg(' raw_cost = '||to_char(rollup_ra_rec.total_plan_raw_cost));
6961: print_msg(' burdened_cost = '||to_char(rollup_ra_rec.total_plan_burdened_cost));
6962: print_msg(' revenue = '||to_char(rollup_ra_rec.total_plan_revenue));
6963: print_msg(' total_project_raw_cost = '||to_char(rollup_ra_rec.total_project_raw_cost));

Line 6972: UPDATE pa_budget_versions

6968: */
6969:
6970: BEGIN
6971: l_stage := 6029;
6972: UPDATE pa_budget_versions
6973: SET raw_cost = rollup_ra_rec.total_plan_raw_cost
6974: ,burdened_cost = rollup_ra_rec.total_plan_burdened_cost
6975: ,revenue = rollup_ra_rec.total_plan_revenue
6976: ,total_project_raw_cost = rollup_ra_rec.total_project_raw_cost

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

6986: ,last_update_login = fnd_global.login_id
6987: WHERE budget_version_id = p_budget_version_id;
6988: EXCEPTION
6989: WHEN OTHERS THEN
6990: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
6991: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
6992: IF P_PA_DEBUG_MODE = 'Y' THEN
6993: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6994: END IF;

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

6987: WHERE budget_version_id = p_budget_version_id;
6988: EXCEPTION
6989: WHEN OTHERS THEN
6990: print_msg(to_char(l_stage)||' ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv');
6991: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Updating pa_budget_versions in rollup_pf_pfc_to_bv';
6992: IF P_PA_DEBUG_MODE = 'Y' THEN
6993: pa_debug.write('rollup_pf_pfc_to_bv: ' || g_module_name,pa_debug.g_err_stage,3);
6994: END IF;
6995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7152: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7148: */
7149:
7150:
7151: PROCEDURE convert_ra_txn_currency
7152: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7153: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7155: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7156: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE

Line 7760: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7756: * p_addl_qty_tab,p_addl_raw_cost_tab,p_addl_burdened_cost_tab,p_addl_revenue_tab
7757: *
7758: */
7759: PROCEDURE calculate ( p_project_id IN pa_projects_all.project_id%TYPE
7760: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7761: ,p_refresh_rates_flag IN VARCHAR2 := 'N'
7762: ,p_refresh_conv_rates_flag IN VARCHAR2 := 'N'
7763: ,p_spread_required_flag IN VARCHAR2 := 'Y'
7764: ,p_conv_rates_required_flag IN VARCHAR2 := 'Y'

Line 8005: ,pa_budget_versions bv

8001: ,bv.ci_id CiId
8002: /*Bugfix:4272944 */
8003: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
8004: FROM pa_proj_fp_options pfo
8005: ,pa_budget_versions bv
8006: ,pa_projects_all pp
8007: WHERE pfo.fin_plan_version_id = bv.budget_version_id
8008: AND bv.project_id = pp.project_id
8009: AND bv.budget_version_id = p_budget_version_id;

Line 8075: ,pa_budget_versions bv

8071: ,tmp.txn_init_burdened_cost
8072: ,tmp.txn_init_revenue
8073: -- End for 6781055
8074: FROM pa_fp_rollup_tmp tmp
8075: ,pa_budget_versions bv
8076: ,pa_resource_assignments ra
8077: ,pa_resource_list_members rl
8078: WHERE bv.budget_version_id = p_budget_version_id
8079: AND ra.budget_version_id = bv.budget_version_id

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

11114: End If;
11115: **************END of MRC Elimination changes ***/
11116:
11117: /*
11118: -- ROLLUP PC and PFC numbers to pa_budget_versions
11119: */
11120: IF NVL(l_entire_return_status,'S') = 'S' Then
11121: l_stage := 1300;
11122: If P_PA_DEBUG_MODE = 'Y' Then

Line 11751: ,pa_budget_versions bv

11747: ,pp.non_labor_sch_type
11748: ,bv.project_structure_version_id
11749: ,bv.project_id
11750: FROM pa_proj_fp_options pfo
11751: ,pa_budget_versions bv
11752: ,pa_projects_all pp
11753: WHERE pfo.fin_plan_version_id = bv.budget_version_id
11754: AND bv.budget_version_id = p_budget_version_id
11755: AND pp.project_id = bv.project_id