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

Line 11: pa_budget_versions.period_profile_id%TYPE INDEX BY BINARY_INTEGER;

7: -- Bug Fix: 4569365. Removed MRC code.
8: -- g_mrc_exception EXCEPTION;
9:
10: TYPE g_period_profile_tbl_typ IS TABLE OF
11: pa_budget_versions.period_profile_id%TYPE INDEX BY BINARY_INTEGER;
12:
13: g_source_period_profile_tbl g_period_profile_tbl_typ;
14: g_target_period_profile_tbl g_period_profile_tbl_typ;
15:

Line 43: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

39: l_msg_index_out NUMBER;
40: l_debug_mode VARCHAR2(30);
41:
42: --rel_lock NUMBER;
43: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
44: Resource_Busy EXCEPTION;
45: PRAGMA exception_init(Resource_Busy,-00054);
46:
47: CURSOR source_fp_opt_cur IS

Line 55: FROM PA_BUDGET_VERSIONS

51: FOR UPDATE NOWAIT;
52:
53: CURSOR source_bdgt_vers_cur IS
54: SELECT record_version_number
55: FROM PA_BUDGET_VERSIONS
56: WHERE budget_version_id = p_source_plan_version_id
57: FOR UPDATE NOWAIT;
58:
59: CURSOR target_fp_opt_cur IS

Line 67: FROM PA_BUDGET_VERSIONS

63: FOR UPDATE NOWAIT;
64:
65: CURSOR target_bdgt_vers_cur IS
66: SELECT record_version_number
67: FROM PA_BUDGET_VERSIONS
68: WHERE budget_version_id = p_target_plan_version_id
69: FOR UPDATE NOWAIT;
70: BEGIN
71:

Line 84: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that

80: IF P_PA_DEBUG_MODE = 'Y' THEN
81: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
82: END IF;
83: /*
84: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that
85: * no other process would be able to modify these tables and all
86: * underlying child tables
87: */
88:

Line 99: pa_debug.g_err_stage:='Acquiring lock on pa_budget_versions';

95:
96: OPEN target_fp_opt_cur;
97:
98: IF P_PA_DEBUG_MODE = 'Y' THEN
99: pa_debug.g_err_stage:='Acquiring lock on pa_budget_versions';
100: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
101: END IF;
102:
103: OPEN source_bdgt_vers_cur;

Line 109: * pa_budget_versions and pa_proj_fp_options

105: OPEN target_bdgt_vers_cur;
106:
107: /*
108: * Increment the record_version_number of target version in
109: * pa_budget_versions and pa_proj_fp_options
110: */
111:
112: IF P_PA_DEBUG_MODE = 'Y' THEN
113: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_proj_fp_options';

Line 122: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_budget_versions';

118: SET record_version_number = record_version_number+1
119: WHERE fin_plan_version_id=p_target_plan_version_id;
120:
121: IF P_PA_DEBUG_MODE = 'Y' THEN
122: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_budget_versions';
123: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
124: END IF;
125:
126: UPDATE PA_BUDGET_VERSIONS

Line 126: UPDATE PA_BUDGET_VERSIONS

122: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_budget_versions';
123: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
124: END IF;
125:
126: UPDATE PA_BUDGET_VERSIONS
127: SET record_version_number = record_version_number+1
128: WHERE budget_version_id = p_target_plan_version_id;
129:
130: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 254: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

250: l_debug_mode VARCHAR2(30);
251:
252: l_source_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
253: l_target_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
254: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
255: l_project_id pa_projects_all.project_id%TYPE;
256: l_source_resource_list_id pa_budget_versions.resource_list_id%TYPE;
257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;
258:

Line 256: l_source_resource_list_id pa_budget_versions.resource_list_id%TYPE;

252: l_source_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
253: l_target_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
254: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
255: l_project_id pa_projects_all.project_id%TYPE;
256: l_source_resource_list_id pa_budget_versions.resource_list_id%TYPE;
257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;
258:
259: --This variable contains the resource list id of baselined version
260:

Line 257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;

253: l_target_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
254: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
255: l_project_id pa_projects_all.project_id%TYPE;
256: l_source_resource_list_id pa_budget_versions.resource_list_id%TYPE;
257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;
258:
259: --This variable contains the resource list id of baselined version
260:
261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

Line 261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;
258:
259: --This variable contains the resource list id of baselined version
260:
261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;

258:
259: --This variable contains the resource list id of baselined version
260:
261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 263: l_version_type pa_budget_versions.version_type%TYPE;

259: --This variable contains the resource list id of baselined version
260:
261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
267:

Line 264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

260:
261: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
267:
268: -- Start of Variables defined for bug 2729498

Line 266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

262: l_target_plan_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
267:
268: -- Start of Variables defined for bug 2729498
269:
270: l_target_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 270: l_target_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

266: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
267:
268: -- Start of Variables defined for bug 2729498
269:
270: l_target_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
271: l_target_version_type pa_budget_versions.version_type%TYPE;
272:
273: -- End of variables defined for bug 2729498
274:

Line 271: l_target_version_type pa_budget_versions.version_type%TYPE;

267:
268: -- Start of Variables defined for bug 2729498
269:
270: l_target_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
271: l_target_version_type pa_budget_versions.version_type%TYPE;
272:
273: -- End of variables defined for bug 2729498
274:
275: Resource_Busy EXCEPTION;

Line 477: pa_debug.g_err_stage:='Checking if pa_budget_versions is locked';

473:
474: --Checking if target version is locked or not
475:
476: IF P_PA_DEBUG_MODE = 'Y' THEN
477: pa_debug.g_err_stage:='Checking if pa_budget_versions is locked';
478: END IF;
479: IF P_PA_DEBUG_MODE = 'Y' THEN
480: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
481: END IF;

Line 487: FROM PA_BUDGET_VERSIONS

483: SELECT locked_by_person_id
484: ,project_id
485: INTO l_locked_by_person_id
486: ,l_project_id
487: FROM PA_BUDGET_VERSIONS
488: WHERE budget_version_id = p_target_plan_version_id;
489:
490: IF l_locked_by_person_id IS NOT NULL THEN
491: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',

Line 503: FROM PA_BUDGET_VERSIONS

499: END IF;
500:
501: SELECT project_id
502: INTO l_project_id
503: FROM PA_BUDGET_VERSIONS
504: WHERE budget_version_id = p_target_plan_version_id;
505:
506: --Acquire lock on pa_proj_fp_options and pa_budget_versions so that
507: --no other process would be able to modify these tables and all

Line 506: --Acquire lock on pa_proj_fp_options and pa_budget_versions so that

502: INTO l_project_id
503: FROM PA_BUDGET_VERSIONS
504: WHERE budget_version_id = p_target_plan_version_id;
505:
506: --Acquire lock on pa_proj_fp_options and pa_budget_versions so that
507: --no other process would be able to modify these tables and all
508: --underlying child tables
509:
510: Acquire_Locks_For_Copy_Plan(

Line 828: FROM PA_BUDGET_VERSIONS

824: FOR UPDATE NOWAIT;
825:
826: CURSOR bdgt_ver_cur IS
827: SELECT record_version_number
828: FROM PA_BUDGET_VERSIONS
829: WHERE budget_version_id = p_plan_version_id
830: FOR UPDATE NOWAIT;
831: BEGIN
832:

Line 843: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that

839: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
840: l_debug_mode := NVL(l_debug_mode, 'Y');
841:
842: /*
843: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that
844: * no other process would be able to modify these tables and all
845: * underlying child tables
846: */
847:

Line 856: pa_debug.g_err_stage:='Acquiring lock on pa_budget_versions';

852:
853: OPEN fp_opt_cur;
854:
855: IF P_PA_DEBUG_MODE = 'Y' THEN
856: pa_debug.g_err_stage:='Acquiring lock on pa_budget_versions';
857: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
858: END IF;
859:
860: OPEN bdgt_ver_cur;

Line 862: --Increment the record_version_number in pa_budget_versions and

858: END IF;
859:
860: OPEN bdgt_ver_cur;
861:
862: --Increment the record_version_number in pa_budget_versions and
863: --pa_proj_fp_options
864:
865: IF P_PA_DEBUG_MODE = 'Y' THEN
866: pa_debug.g_err_stage:='Incrementing record version number of plan version pa_proj_fp_options';

Line 875: pa_debug.g_err_stage:='Incrementing record version number of plan version in pa_budget_versions';

871: SET record_version_number = record_version_number+1
872: WHERE fin_plan_version_id=p_plan_version_id;
873:
874: IF P_PA_DEBUG_MODE = 'Y' THEN
875: pa_debug.g_err_stage:='Incrementing record version number of plan version in pa_budget_versions';
876: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
877: END IF;
878:
879: UPDATE PA_BUDGET_VERSIONS

Line 879: UPDATE PA_BUDGET_VERSIONS

875: pa_debug.g_err_stage:='Incrementing record version number of plan version in pa_budget_versions';
876: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
877: END IF;
878:
879: UPDATE PA_BUDGET_VERSIONS
880: SET record_version_number = record_version_number+1
881: WHERE budget_version_id = p_plan_version_id ;
882:
883: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 966: -- insert pa_budget_versions

962: -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:
963: -- Make code changes Copy_Budget_Version
964: -- procedure to
965: -- enable population of new parameters on
966: -- insert pa_budget_versions
967: --
968: -- 01-AUG-2003 jwhite - Bug 3079891
969: -- For Copy_Budget_Version, hardcoded
970: -- the following columns to NULL:

Line 983: - INSERT INTO PA_BUDGET_VERSIONS (

979: 08-JAN-2004 jwhite Bug 3362316
980:
981: Extensively rewrote Copy_Budget_Version
982: - CURSOR l_bv_csr IS
983: - INSERT INTO PA_BUDGET_VERSIONS (
984: - UPDATE pa_budget_versions
985:
986: 29-JAN-2004 sgoteti Bug 3354518: Added the parameter
987: p_struct_elem_version_id

Line 984: - UPDATE pa_budget_versions

980:
981: Extensively rewrote Copy_Budget_Version
982: - CURSOR l_bv_csr IS
983: - INSERT INTO PA_BUDGET_VERSIONS (
984: - UPDATE pa_budget_versions
985:
986: 29-JAN-2004 sgoteti Bug 3354518: Added the parameter
987: p_struct_elem_version_id
988:

Line 1012: ,p_struct_elem_version_id IN pa_budget_versions.budget_version_id%TYPE --Bug 3354518

1008: ,p_calling_module IN VARCHAR2
1009: ,p_shift_days IN NUMBER
1010: ,p_copy_actuals_flag IN VARCHAR2
1011: ,px_target_version_id IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1012: ,p_struct_elem_version_id IN pa_budget_versions.budget_version_id%TYPE --Bug 3354518
1013: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1014: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1015: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1016: AS

Line 1031: l_version_name pa_budget_versions.version_name%TYPE;

1027:
1028: l_adj_percentage NUMBER;
1029: l_source_project_id pa_projects_all.project_id%TYPE;
1030: l_target_project_id pa_projects_all.project_id%TYPE;
1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;

Line 1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;

1029: l_source_project_id pa_projects_all.project_id%TYPE;
1030: l_target_project_id pa_projects_all.project_id%TYPE;
1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

Line 1034: l_max_version pa_budget_versions.version_number%TYPE;

1030: l_target_project_id pa_projects_all.project_id%TYPE;
1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

Line 1035: l_version_number pa_budget_versions.version_number%TYPE;

1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;

Line 1036: l_version_type pa_budget_versions.version_type%TYPE;

1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

Line 1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;

Line 1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

1034: l_max_version pa_budget_versions.version_number%TYPE;
1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;
1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;

Line 1039: l_current_flag pa_budget_versions.current_flag%TYPE;

1035: l_version_number pa_budget_versions.version_number%TYPE;
1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;
1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;
1043:

Line 1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

1036: l_version_type pa_budget_versions.version_type%TYPE;
1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;
1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;
1043:
1044: l_cost_flag VARCHAR2(1);

Line 1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;

1037: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;
1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;
1043:
1044: l_cost_flag VARCHAR2(1);
1045: l_revenue_flag VARCHAR2(1);

Line 1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;

1038: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1039: l_current_flag pa_budget_versions.current_flag%TYPE;
1040: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
1041: l_baselined_by_person_id pa_budget_versions.baselined_by_person_id%TYPE;
1042: l_baselined_date pa_budget_versions.baselined_date%TYPE;
1043:
1044: l_cost_flag VARCHAR2(1);
1045: l_revenue_flag VARCHAR2(1);
1046:

Line 1056: l_wbs_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;

1052: l_process_code VARCHAR2(30) := NULL;
1053:
1054: -- rravipat 3/26/2004 Added for FP M Phase II copy project impact
1055:
1056: l_wbs_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
1057: l_source_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1058: l_target_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1059: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
1060:

Line 1057: l_source_cur_planning_period pa_budget_versions.current_planning_period%TYPE;

1053:
1054: -- rravipat 3/26/2004 Added for FP M Phase II copy project impact
1055:
1056: l_wbs_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
1057: l_source_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1058: l_target_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1059: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
1060:
1061: l_gl_start_period gl_periods.period_name%TYPE;

Line 1058: l_target_cur_planning_period pa_budget_versions.current_planning_period%TYPE;

1054: -- rravipat 3/26/2004 Added for FP M Phase II copy project impact
1055:
1056: l_wbs_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
1057: l_source_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1058: l_target_cur_planning_period pa_budget_versions.current_planning_period%TYPE;
1059: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
1060:
1061: l_gl_start_period gl_periods.period_name%TYPE;
1062: l_gl_end_period gl_periods.period_name%TYPE;

Line 1123: FROM pa_budget_versions

1119: ,last_amt_gen_date
1120: ,actual_amts_thru_period
1121: ,project_structure_version_id
1122: ,etc_start_date --Bug 3927244
1123: FROM pa_budget_versions
1124: WHERE budget_version_id = p_source_version_id;
1125:
1126: -- ---------------------------------------------------------------------------
1127:

Line 1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

1131: -- Bug 3927244
1132: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1133: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1134:
1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
1136: SELECT pfb.plan_class_code,pbv.project_id
1137: FROM pa_fin_plan_types_b pfb,
1138: pa_budget_versions pbv
1139: WHERE pbv.budget_version_id = c_budget_version_id

Line 1138: pa_budget_versions pbv

1134:
1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
1136: SELECT pfb.plan_class_code,pbv.project_id
1137: FROM pa_fin_plan_types_b pfb,
1138: pa_budget_versions pbv
1139: WHERE pbv.budget_version_id = c_budget_version_id
1140: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
1141: -- Bug 3927244
1142:

Line 1219: -- pa_budget_versions using source_version_id

1215: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1216: END IF;
1217:
1218: -- Get the fin plan type id, source version name, project id from
1219: -- pa_budget_versions using source_version_id
1220:
1221: IF px_target_version_id IS NULL THEN
1222:
1223: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1242: FROM pa_budget_versions

1238: ,l_fin_plan_type_id
1239: ,l_version_type
1240: ,l_ci_id
1241: ,l_source_cur_planning_period
1242: FROM pa_budget_versions
1243: WHERE budget_version_id = p_source_version_id;
1244:
1245: -- 3/30/2004 Raja FP M Phase II Dev Changes
1246: -- If source project and target project are different do not copy

Line 1301: FROM pa_budget_versions

1297: --start of changes for bug:- 2570250
1298: /*
1299: SELECT NVL(MAX(version_number),0)
1300: INTO l_max_version
1301: FROM pa_budget_versions
1302: WHERE project_id = l_project_id
1303: AND fin_plan_type_id = l_fin_plan_type_id
1304: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,
1305: PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED); */

Line 1331: an update would be done to the pa_budget_versions directly.

1327: l_baselined_by_person_id := NULL;
1328:
1329: /* #2634622: The version name will not be appended with 'Copy' from now on.
1330: From any calling place, where the version name is expected to be different,
1331: an update would be done to the pa_budget_versions directly.
1332:
1333: FND_MESSAGE.SET_NAME('PA','PA_FP_COPY_MESSAGE');
1334: l_version_name:= l_version_name ||'-'||FND_MESSAGE.GET;
1335: */

Line 1351: FROM pa_budget_versions

1347: --start of changes for bug :- 2570250
1348: /*
1349: SELECT NVL(MAX(version_number),0)
1350: INTO l_max_version
1351: FROM pa_budget_versions
1352: WHERE project_id = l_project_id
1353: AND fin_plan_type_id = l_fin_plan_type_id
1354: AND budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED;
1355: */

Line 1376: -- Stamp employee_id in baseliend_by_person_id of pa_budget_versions table when

1372: l_budget_status_code := PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED;
1373: l_current_flag := 'Y';
1374:
1375: -- For bug 3858601
1376: -- Stamp employee_id in baseliend_by_person_id of pa_budget_versions table when
1377: -- a budget version is baselined instead of user id.
1378:
1379: l_baselined_date := SYSDATE;
1380: --l_baselined_by_person_id := FND_GLOBAL.USER_ID;

Line 1402: SELECT pa_budget_versions_s.NEXTVAL

1398: pa_debug.g_err_stage := 'Fetch new budget version id';
1399: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1400: END IF;
1401:
1402: SELECT pa_budget_versions_s.NEXTVAL
1403: INTO px_target_version_id
1404: FROM DUAL;
1405:
1406: -- For workplan context project structure version id should be populated

Line 1430: From pa_budget_versions a

1426: l_exists varchar2(1);
1427: Begin
1428: Select 'Y'
1429: Into l_exists
1430: From pa_budget_versions a
1431: Where project_structure_version_id = l_wbs_struct_version_id
1432: And wp_version_flag = 'Y'
1433: And exists (select 'x' from pa_budget_versions b where b.budget_version_id = p_source_version_id and b.wp_version_flag = 'Y') ;
1434:

Line 1433: And exists (select 'x' from pa_budget_versions b where b.budget_version_id = p_source_version_id and b.wp_version_flag = 'Y') ;

1429: Into l_exists
1430: From pa_budget_versions a
1431: Where project_structure_version_id = l_wbs_struct_version_id
1432: And wp_version_flag = 'Y'
1433: And exists (select 'x' from pa_budget_versions b where b.budget_version_id = p_source_version_id and b.wp_version_flag = 'Y') ;
1434:
1435: IF P_PA_DEBUG_MODE = 'Y' THEN
1436: pa_debug.g_err_stage:='proj sv id = ' || l_wbs_struct_version_id;
1437: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 1459: -- Insert a new row in pa_budget_versions

1455: When No_Data_Found Then
1456: Null;
1457: End;
1458:
1459: -- Insert a new row in pa_budget_versions
1460:
1461: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
1462:
1463: INSERT INTO PA_BUDGET_VERSIONS (

Line 1463: INSERT INTO PA_BUDGET_VERSIONS (

1459: -- Insert a new row in pa_budget_versions
1460:
1461: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
1462:
1463: INSERT INTO PA_BUDGET_VERSIONS (
1464: budget_version_id
1465: ,project_id
1466: ,budget_type_code
1467: ,version_number

Line 1659: FROM PA_BUDGET_VERSIONS pbv

1655: ,pbv.last_amt_gen_date --Bug 4228859
1656: ,decode(p_copy_actuals_flag,'N',null,pbv.actual_amts_thru_period) -- Bug 3927244
1657: ,l_ci_id -- Raja FP M 06 JUl 04 bug 3677924
1658: ,decode(p_copy_actuals_flag,'N',null,pbv.etc_start_date) -- Bug 3927244
1659: FROM PA_BUDGET_VERSIONS pbv
1660: WHERE pbv.budget_version_id = p_source_version_id;
1661:
1662: -- End, jwhite, 26-JUN-2003: Plannable Task Effort --------------------------------
1663:

Line 1746: UPDATE pa_budget_versions

1742:
1743:
1744: IF l_bv_csr%FOUND THEN
1745:
1746: UPDATE pa_budget_versions
1747: SET resource_list_id = l_bv_rec.resource_list_id /* Added for bug# 2757847 */
1748: ,labor_quantity = l_bv_rec.labor_quantity /* Added for bug# 2645579 */
1749: ,raw_cost = DECODE(l_adj_percentage, 0, DECODE(l_cost_flag,'Y',l_bv_rec.raw_cost,NULL), NULL)
1750: ,burdened_cost = DECODE(l_adj_percentage, 0, DECODE(l_cost_flag,'Y',l_bv_rec.burdened_cost,NULL), NULL)

Line 1817: (X_from_entity_name => 'PA_BUDGET_VERSIONS',

1813: END IF;
1814: -- bug fix 2933695
1815: -- Copy attachments which are associated with the budget version
1816: fnd_attached_documents2_pkg.copy_attachments
1817: (X_from_entity_name => 'PA_BUDGET_VERSIONS',
1818: X_from_pk1_value => to_char(p_source_version_id),
1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',
1820: X_to_pk1_value => px_target_version_id,
1821: X_created_by => FND_GLOBAL.USER_ID,

Line 1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',

1815: -- Copy attachments which are associated with the budget version
1816: fnd_attached_documents2_pkg.copy_attachments
1817: (X_from_entity_name => 'PA_BUDGET_VERSIONS',
1818: X_from_pk1_value => to_char(p_source_version_id),
1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',
1820: X_to_pk1_value => px_target_version_id,
1821: X_created_by => FND_GLOBAL.USER_ID,
1822: X_last_update_login => FND_GLOBAL.LOGIN_ID,
1823: X_program_application_id => FND_GLOBAL.PROG_APPL_ID);

Line 4012: pa_budget_versions pbv

4008:
4009: select ppa.carrying_out_organization_id
4010: into l_project_org
4011: from pa_projects_all ppa,
4012: pa_budget_versions pbv
4013: where pbv.budget_version_id = p_target_plan_version_id
4014: and pbv.project_id = ppa.project_id;
4015:
4016: update pa_resource_assignments

Line 4083: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

4079: ----2. Call PA_FP_CALC_PLAN_PKG.CheckZeroQTyNegETC to check for the negative ETC/Qty in the target version
4080: ----3. Update rate based flag for RAs in the target version if any RAs have to be converted to non rate based
4081: ----4. Update the budget lines with the missing amounts
4082: PROCEDURE derv_missing_amts_chk_neg_qty
4083: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4084: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4085: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4086: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4087: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

Line 4085: p_source_version_type IN pa_budget_versions.version_type%TYPE,

4081: ----4. Update the budget lines with the missing amounts
4082: PROCEDURE derv_missing_amts_chk_neg_qty
4083: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4084: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4085: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4086: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4087: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
4088: p_derv_rates_missing_amts_flag IN VARCHAR2,
4089: p_adj_percentage IN NUMBER,

Line 4086: p_target_version_type IN pa_budget_versions.version_type%TYPE,

4082: PROCEDURE derv_missing_amts_chk_neg_qty
4083: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4084: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4085: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4086: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4087: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
4088: p_derv_rates_missing_amts_flag IN VARCHAR2,
4089: p_adj_percentage IN NUMBER,
4090: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4715: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;

4711: l_msg_index_out NUMBER;
4712: l_return_status VARCHAR2(2000);
4713: l_debug_mode VARCHAR2(30);
4714:
4715: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
4716: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
4717:
4718: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
4719: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;

Line 4716: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;

4712: l_return_status VARCHAR2(2000);
4713: l_debug_mode VARCHAR2(30);
4714:
4715: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
4716: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
4717:
4718: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
4719: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
4720:

Line 4726: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

4722: l_period_profiles_same_flag VARCHAR2(1);
4723:
4724: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4725: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4726: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4727:
4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4729: l_temp NUMBER;
4730:

Line 4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

4724: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4725: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4726: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4727:
4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4729: l_temp NUMBER;
4730:
4731: l_source_version_type pa_budget_versions.version_type%TYPE;
4732: l_target_version_type pa_budget_versions.version_type%TYPE;

Line 4731: l_source_version_type pa_budget_versions.version_type%TYPE;

4727:
4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4729: l_temp NUMBER;
4730:
4731: l_source_version_type pa_budget_versions.version_type%TYPE;
4732: l_target_version_type pa_budget_versions.version_type%TYPE;
4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4735:

Line 4732: l_target_version_type pa_budget_versions.version_type%TYPE;

4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4729: l_temp NUMBER;
4730:
4731: l_source_version_type pa_budget_versions.version_type%TYPE;
4732: l_target_version_type pa_budget_versions.version_type%TYPE;
4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4735:
4736: -- Bug 4493425: Added pbv.project_id in the select.

Line 4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425

4729: l_temp NUMBER;
4730:
4731: l_source_version_type pa_budget_versions.version_type%TYPE;
4732: l_target_version_type pa_budget_versions.version_type%TYPE;
4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4735:
4736: -- Bug 4493425: Added pbv.project_id in the select.
4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

Line 4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425

4730:
4731: l_source_version_type pa_budget_versions.version_type%TYPE;
4732: l_target_version_type pa_budget_versions.version_type%TYPE;
4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4735:
4736: -- Bug 4493425: Added pbv.project_id in the select.
4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
4738: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date,pbv.version_type,pbv.project_id

Line 4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

4733: l_source_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4734: l_target_project_id pa_budget_versions.project_id%TYPE; -- Bug 4493425
4735:
4736: -- Bug 4493425: Added pbv.project_id in the select.
4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
4738: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date,pbv.version_type,pbv.project_id
4739: FROM pa_fin_plan_types_b pfb,
4740: pa_budget_versions pbv
4741: WHERE pbv.budget_version_id = c_budget_version_id

Line 4740: pa_budget_versions pbv

4736: -- Bug 4493425: Added pbv.project_id in the select.
4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
4738: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date,pbv.version_type,pbv.project_id
4739: FROM pa_fin_plan_types_b pfb,
4740: pa_budget_versions pbv
4741: WHERE pbv.budget_version_id = c_budget_version_id
4742: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
4743: -- Bug 3927244
4744:

Line 5671: FROM pa_budget_versions v

5667: SELECT t.budget_type_code
5668: ,t.budget_amount_code
5669: FROM pa_budget_types t
5670: WHERE EXISTS ( SELECT 1
5671: FROM pa_budget_versions v
5672: WHERE v.project_id = x_orig_project_id
5673: AND v.budget_type_code = t.budget_type_code)
5674: ORDER BY t.budget_type_code;
5675:

Line 5859: FROM pa_budget_versions

5855: || x_new_project_id;
5856:
5857: SELECT budget_version_id
5858: INTO x_new_budget_ver_id
5859: FROM pa_budget_versions
5860: WHERE project_id = x_new_project_id
5861: AND budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING
5862: AND budget_type_code = c1_rec.budget_type_code;
5863:

Line 6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;

6024:
6025: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6026:
6027: l_source_template_flag pa_projects_all.template_flag%TYPE;
6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6030: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6031: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6032: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

Line 6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

6025: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6026:
6027: l_source_template_flag pa_projects_all.template_flag%TYPE;
6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6030: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6031: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6032: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6033:

Line 6031: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;

6027: l_source_template_flag pa_projects_all.template_flag%TYPE;
6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6030: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6031: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6032: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6033:
6034: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6035:

Line 6036: l_target_version_id pa_budget_versions.budget_version_id%TYPE;

6032: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6033:
6034: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6035:
6036: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6037: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6038: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6039: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;
6040: l_version_type pa_budget_versions.version_type%TYPE;

Line 6037: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;

6033:
6034: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6035:
6036: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6037: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6038: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6039: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;
6040: l_version_type pa_budget_versions.version_type%TYPE;
6041: l_funding_exists_flag VARCHAR2(1);

Line 6039: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;

6035:
6036: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6037: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6038: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6039: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;
6040: l_version_type pa_budget_versions.version_type%TYPE;
6041: l_funding_exists_flag VARCHAR2(1);
6042:
6043:

Line 6040: l_version_type pa_budget_versions.version_type%TYPE;

6036: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6037: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6038: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6039: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;
6040: l_version_type pa_budget_versions.version_type%TYPE;
6041: l_funding_exists_flag VARCHAR2(1);
6042:
6043:
6044: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;

Line 6054: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS

6050: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6051:
6052:
6053: /* Code addition for bug 2986930 starts */
6054: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS
6055: SELECT 'Y'
6056: FROM dual
6057: WHERE EXISTS(SELECT NULL
6058: FROM pa_budget_versions

Line 6058: FROM pa_budget_versions

6054: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS
6055: SELECT 'Y'
6056: FROM dual
6057: WHERE EXISTS(SELECT NULL
6058: FROM pa_budget_versions
6059: WHERE budget_version_id = p_source_ver_id
6060: AND approved_rev_plan_type_flag = 'Y');
6061:
6062: CURSOR c_bfl IS

Line 6496: x_from_entity_name => 'PA_BUDGET_VERSIONS'

6492:
6493: /* BUG FIX 2955827
6494: * copy_attachments is already done in PA_FP_COPY_FROM_PKG.Copy_Budget_Version
6495: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
6496: x_from_entity_name => 'PA_BUDGET_VERSIONS'
6497: ,x_from_pk1_value => l_source_version_id
6498: ,x_from_pk2_value => NULL
6499: ,x_from_pk3_value => NULL
6500: ,x_from_pk4_value => NULL

Line 6502: ,x_to_entity_name => 'PA_BUDGET_VERSIONS'

6498: ,x_from_pk2_value => NULL
6499: ,x_from_pk3_value => NULL
6500: ,x_from_pk4_value => NULL
6501: ,x_from_pk5_value => NULL
6502: ,x_to_entity_name => 'PA_BUDGET_VERSIONS'
6503: ,x_to_pk1_value => l_target_version_id
6504: ,x_to_pk2_value => NULL
6505: ,x_to_pk3_value => NULL
6506: ,x_to_pk4_value => NULL

Line 6676: FROM pa_budget_versions

6672: SELECT current_flag
6673: ,record_version_number
6674: INTO l_source_current_flag
6675: ,l_source_record_version_num
6676: FROM pa_budget_versions
6677: WHERE budget_version_id = l_source_version_id;
6678:
6679: --Fetch target version properties for the api calls
6680:

Line 6690: FROM pa_budget_versions

6686: SELECT record_version_number
6687: ,version_type
6688: INTO l_target_record_version_num
6689: ,l_version_type
6690: FROM pa_budget_versions
6691: WHERE budget_version_id = l_target_version_id;
6692:
6693: IF (l_source_template_flag = 'Y') AND
6694: (l_source_current_flag = 'Y' )

Line 8158: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;

8154: l_msg_data VARCHAR2(2000);
8155: l_msg_index_out NUMBER;
8156: l_return_status VARCHAR2(2000);
8157:
8158: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
8159: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
8160: l_dummy NUMBER;
8161:
8162: CURSOR current_period_profiles_cur IS

Line 8159: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;

8155: l_msg_index_out NUMBER;
8156: l_return_status VARCHAR2(2000);
8157:
8158: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
8159: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
8160: l_dummy NUMBER;
8161:
8162: CURSOR current_period_profiles_cur IS
8163: SELECT period_profile_id

Line 8739: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;

8735:
8736: --End of variables used for debugging
8737: l_module_name VARCHAR2(200) := g_module_name || '.copy_wp_budget_versions';
8738: i NUMBER;
8739: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8740: --l_src_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8741: --l_targ_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8742: l_adj_percentage NUMBER;
8743: l_copy_mode VARCHAR2(1) := p_copy_mode;

Line 8745: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;

8741: --l_targ_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8742: l_adj_percentage NUMBER;
8743: l_copy_mode VARCHAR2(1) := p_copy_mode;
8744: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8745: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8746: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8747: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8748: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8749: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 8773: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE

8769: l_src_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8770:
8771: --Cursor for getting the source and target element version ids. This will be used in calling the
8772: --Copy Planning Txn API
8773: CURSOR l_prep_plan_txn_csr(c_source_plan_version_id pa_budget_versions.budget_version_id%TYPE
8774: ,c_src_struct_ver_id pa_proj_element_versions.element_version_id%TYPE
8775: ,c_targ_struct_ver_id pa_proj_element_versions.element_version_id%TYPE)
8776: IS
8777: SELECT selv.element_version_id

Line 9472: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

9468: l_period_nameTab.delete;
9469:
9470: END InitPLSQLTab; ** bug 3709036 */
9471:
9472: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
9473:
9474: --Bug 4290043.
9475: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9476: l_source_version_type pa_budget_versions.version_type%TYPE;

Line 9476: l_source_version_type pa_budget_versions.version_type%TYPE;

9472: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
9473:
9474: --Bug 4290043.
9475: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9476: l_source_version_type pa_budget_versions.version_type%TYPE;
9477: l_target_version_type pa_budget_versions.version_type%TYPE;
9478: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
9479:
9480: BEGIN

Line 9477: l_target_version_type pa_budget_versions.version_type%TYPE;

9473:
9474: --Bug 4290043.
9475: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9476: l_source_version_type pa_budget_versions.version_type%TYPE;
9477: l_target_version_type pa_budget_versions.version_type%TYPE;
9478: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
9479:
9480: BEGIN
9481:

Line 9554: FROM pa_budget_versions

9550: SELECT etc_start_date,
9551: version_type
9552: INTO l_etc_start_date,
9553: l_target_version_type
9554: FROM pa_budget_versions
9555: WHERE budget_version_id=p_target_plan_version_id;
9556: --Bug 3927244
9557:
9558: --Bug 4290043.

Line 9563: FROM pa_budget_versions pbv,

9559: SELECT pbv.version_type,
9560: fin.plan_class_code
9561: INTO l_source_version_type,
9562: l_src_plan_class_code
9563: FROM pa_budget_versions pbv,
9564: pa_fin_plan_types_b fin
9565: WHERE pbv.fin_plan_type_id=fin.fin_plan_type_id
9566: AND pbv.budget_version_id = p_source_plan_version_id;
9567:

Line 10064: statement on pa_budget_versions, so that the quantity and cost amount columns gets

10060: Bug 4101153: Current Planning period should always get the value from the source version and
10061: not from the workplan plan type option. Removed the update to current planning period
10062:
10063: Bug 4337221: dbora- Excluded the quantity and cost amount columns from the update
10064: statement on pa_budget_versions, so that the quantity and cost amount columns gets
10065: copied as it is from the source version retaining the version level rolled up figures.
10066: ==============================================================================*/
10067:
10068: PROCEDURE Update_Plan_Setup_For_WP_Copy(

Line 10070: ,p_wp_version_id IN pa_budget_versions.fin_plan_type_id%TYPE

10066: ==============================================================================*/
10067:
10068: PROCEDURE Update_Plan_Setup_For_WP_Copy(
10069: p_project_id IN pa_projects_all.project_id%TYPE
10070: ,p_wp_version_id IN pa_budget_versions.fin_plan_type_id%TYPE
10071: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10072: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10073: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10074: AS

Line 10141: ,pa_budget_versions bv

10137: SELECT pfo.proj_fp_options_id
10138: ,pfo.rbs_version_id
10139: ,pfo.cost_resource_list_id
10140: FROM pa_proj_fp_options pfo
10141: ,pa_budget_versions bv
10142: WHERE bv.budget_version_id = p_wp_version_id
10143: AND bv.project_id = pfo.project_id
10144: AND pfo.fin_plan_version_id = bv.budget_version_id;
10145:

Line 10215: -- Update pa_budget_versions table data

10211: ELSE
10212: l_rbs_version_change_flag := 'N';
10213: END IF;
10214:
10215: -- Update pa_budget_versions table data
10216: -- Note that period mask and planning period could have changed so this update
10217: -- is necessary even if resource list is not changed
10218:
10219: UPDATE pa_budget_versions

Line 10219: UPDATE pa_budget_versions

10215: -- Update pa_budget_versions table data
10216: -- Note that period mask and planning period could have changed so this update
10217: -- is necessary even if resource list is not changed
10218:
10219: UPDATE pa_budget_versions
10220: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
10221: ,period_mask_id = parent_plan_type_rec.cost_period_mask_id
10222: /* Bug 4337221: removed from the update
10223: ,raw_cost = 0