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_EDIT_LINE_PKG dependencies on PA_BUDGET_VERSIONS

Line 24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895

20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
21: ,x_succeeding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
22: ,x_period_profile_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_period_profile_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

Line 94: pa_budget_versions pbv

90: ,x_period_profile_id
91: ,x_project_id
92: ,l_task_id
93: FROM pa_resource_assignments pra,
94: pa_budget_versions pbv
95: WHERE pra.resource_assignment_id = p_resource_assignment_id
96: AND pra.budget_version_id = pbv.budget_version_id;
97:
98: pa_debug.g_err_stage := 'getting x_time_phased_code ';

Line 293: l_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

289: l_msg_index_out NUMBER;
290: l_dummy_pd_name VARCHAR2(30);
291:
292: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
293: l_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
294: l_time_phased_code PA_PROJ_FP_OPTIONS.all_time_phased_code%TYPE;
295: l_project_start_date DATE;
296: l_project_end_date DATE;
297: l_proj_start_prd_start_dt DATE;

Line 696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

692: l_succeeding_prd_start_date pa_budget_lines.start_date%TYPE;
693: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;
694: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
695: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;

Line 2247: on pa_budget_versions table everytime there is a change to the version. */

2243: or tmp.quantity IS NOT NULL
2244: or tmp.txn_revenue IS NOT NULL));
2245:
2246: /* Added the following code for WebADI functionality. Increasing the record version number
2247: on pa_budget_versions table everytime there is a change to the version. */
2248:
2249: IF P_PA_DEBUG_MODE = 'Y' THEN
2250: pa_debug.g_err_stage := TO_CHAR(l_stage)||'inserted '|| sql%rowcount ||' budget lines ';
2251: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2260: UPDATE pa_budget_versions

2256: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
2257: END IF;
2258:
2259: IF nvl(p_calling_context,'-99') <> PA_FP_CONSTANTS_PKG.G_WEBADI THEN
2260: UPDATE pa_budget_versions
2261: SET record_version_number = nvl(record_version_number,0) + 1
2262: WHERE budget_version_id = l_budget_version_id;
2263: END IF;
2264:

Line 2747: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2743: END GET_ELEMENT_AMOUNT_INFO;
2744:
2745: PROCEDURE CALL_CLIENT_EXTENSIONS
2746: ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE
2747: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2748: ,p_task_id IN pa_tasks.TASK_ID%TYPE
2749: ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
2750: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
2751: ,p_resource_id IN pa_resources.RESOURCE_ID%TYPE

Line 3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

3219:
3220: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

3400: PROCEDURE GET_PRECEDING_SUCCEEDING_AMT(
3401: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

3510: END get_is_fn_security_available;
3511:
3512: PROCEDURE CALL_CLIENT_EXTENSIONS
3513: ( p_project_id IN pa_projects_all.project_id%TYPE
3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
3517: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3518: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type

Line 3905: ,pa_budget_versions pbv

3901: ,pra.resource_list_member_id
3902: ,pbv.budget_type_code
3903: ,pbv.fin_plan_type_id
3904: FROM pa_resource_assignments pra
3905: ,pa_budget_versions pbv
3906: WHERE pra.resource_assignment_id = c_resource_assignment_id
3907: AND pra.budget_version_id = pbv.budget_version_id ;
3908:
3909: l_res_assignment_details_rec l_res_assignment_details_csr%ROWTYPE;

Line 4051: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4047: place where budget lines are created always.
4048: =================================================================================================*/
4049:
4050: PROCEDURE PROCESS_BDGTLINES_FOR_VERSION
4051: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4052: ,p_calling_context IN VARCHAR2
4053: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4054: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4055: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4126: UPDATE pa_budget_versions

4122: pa_debug.g_err_stage := 'Increasing record version no. for Budget Version.';
4123: pa_debug.write('PROCESS_BDGTLINES_FOR_VERSION: ' || l_module_name,pa_debug.g_err_stage,3);
4124: END IF;
4125:
4126: UPDATE pa_budget_versions
4127: SET record_version_number = nvl(record_version_number,0) + 1
4128: ,last_update_date = SYSDATE
4129: ,last_updated_by = FND_GLOBAL.user_id
4130: ,last_update_login = FND_GLOBAL.login_id