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.

[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 49: FROM PA_PROJ_FP_OPTIONS

45: PRAGMA exception_init(Resource_Busy,-00054);
46:
47: CURSOR source_fp_opt_cur IS
48: SELECT record_version_number
49: FROM PA_PROJ_FP_OPTIONS
50: WHERE fin_plan_version_id = p_source_plan_version_id
51: FOR UPDATE NOWAIT;
52:
53: CURSOR source_bdgt_vers_cur IS

Line 61: FROM PA_PROJ_FP_OPTIONS

57: FOR UPDATE NOWAIT;
58:
59: CURSOR target_fp_opt_cur IS
60: SELECT record_version_number
61: FROM PA_PROJ_FP_OPTIONS
62: WHERE fin_plan_version_id = p_target_plan_version_id
63: FOR UPDATE NOWAIT;
64:
65: CURSOR target_bdgt_vers_cur IS

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 90: pa_debug.g_err_stage:='Acquiring lock on pa_proj_fp_options';

86: * underlying child tables
87: */
88:
89: IF P_PA_DEBUG_MODE = 'Y' THEN
90: pa_debug.g_err_stage:='Acquiring lock on pa_proj_fp_options';
91: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
92: END IF;
93:
94: OPEN source_fp_opt_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 113: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_proj_fp_options';

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';
114: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
115: END IF;
116:
117: UPDATE PA_PROJ_FP_OPTIONS

Line 117: UPDATE PA_PROJ_FP_OPTIONS

113: pa_debug.g_err_stage:='Incrementing record version number of target version in pa_proj_fp_options';
114: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
115: END IF;
116:
117: UPDATE PA_PROJ_FP_OPTIONS
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

Line 252: l_source_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;

248: l_msg_index_out NUMBER;
249: l_return_status VARCHAR2(2000);
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;

Line 253: l_target_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;

249: l_return_status VARCHAR2(2000);
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;

Line 265: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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
269:

Line 312: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

308: l_pc_rev_exchange_rate_tbl pc_rev_exchange_rate_tbl_typ;
309: l_pfc_cost_exchange_rate_tbl pfc_cost_exchange_rate_tbl_typ;
310: l_pfc_rev_exchange_rate_tbl pfc_rev_exchange_rate_tbl_typ;
311:
312: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
313: l_source_appr_rev_plan_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE; /* Bug 3276128 */
314:
315: -- End of plsql tables defined for bug#2729191
316:

Line 313: l_source_appr_rev_plan_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE; /* Bug 3276128 */

309: l_pfc_cost_exchange_rate_tbl pfc_cost_exchange_rate_tbl_typ;
310: l_pfc_rev_exchange_rate_tbl pfc_rev_exchange_rate_tbl_typ;
311:
312: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
313: l_source_appr_rev_plan_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE; /* Bug 3276128 */
314:
315: -- End of plsql tables defined for bug#2729191
316:
317: -- Start of cursors defined for bug#2729191

Line 336: FROM PA_PROJ_FP_OPTIONS

332: ,project_cost_rate_date
333: ,project_rev_rate_type
334: ,project_rev_rate_date_type
335: ,project_rev_rate_date
336: FROM PA_PROJ_FP_OPTIONS
337: WHERE fin_plan_version_id = p_target_plan_version_id;
338:
339: target_fp_options_rec target_fp_options_cur%ROWTYPE;
340:

Line 411: FROM pa_proj_fp_options

407: ,nvl(approved_rev_plan_type_flag,'N') /* Bug#3276128 */
408: INTO l_source_fp_pref_code
409: ,l_source_plan_in_mc_flag -- Bug#2729191
410: ,l_source_appr_rev_plan_flag /* Bug#3276128 */
411: FROM pa_proj_fp_options
412: WHERE fin_plan_version_id=p_source_plan_version_id;
413:
414: IF P_PA_DEBUG_MODE = 'Y' THEN
415: pa_debug.g_err_stage:='Fetching the target plan preference code';

Line 421: FROM pa_proj_fp_options

417: END IF;
418:
419: SELECT fin_plan_preference_code,nvl(approved_rev_plan_type_flag,'N')
420: INTO l_target_fp_pref_code,l_target_appr_rev_plan_flag
421: FROM pa_proj_fp_options
422: WHERE fin_plan_version_id=p_target_plan_version_id;
423:
424: IF P_PA_DEBUG_MODE = 'Y' THEN
425: pa_debug.g_err_stage:='Checking the compatability of the plans';

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 638: UPDATE PA_PROJ_FP_OPTIONS

634: pa_debug.g_err_stage:='Updating the target proj fp option with the MC attributes';
635: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
636: END IF;
637:
638: UPDATE PA_PROJ_FP_OPTIONS
639: SET plan_in_multi_curr_flag = target_fp_options_rec.plan_in_multi_curr_flag
640: ,projfunc_cost_rate_type = target_fp_options_rec.projfunc_cost_rate_type
641: ,projfunc_cost_rate_date_type = target_fp_options_rec.projfunc_cost_rate_date_type
642: ,projfunc_cost_rate_date = target_fp_options_rec.projfunc_cost_rate_date

Line 785: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE)

781: /*===========================================================================
782: This function is used to return fin plan amount type for given plan version
783: ===========================================================================*/
784: FUNCTION Get_Fin_Plan_Amount_Type (
785: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE)
786: RETURN VARCHAR2
787: IS
788: l_amount_type VARCHAR2(30);
789: BEGIN

Line 795: FROM PA_PROJ_FP_OPTIONS

791: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, 'A'
792: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, 'R'
793: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, 'C')
794: INTO l_amount_type
795: FROM PA_PROJ_FP_OPTIONS
796: WHERE fin_plan_version_id = p_fin_plan_version_id;
797:
798: RETURN l_amount_type;
799: END Get_Fin_Plan_Amount_Type;

Line 807: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

803: This procedure is used to acquire all the required locks for copy_actual
804: ==============================================================================*/
805:
806: PROCEDURE Acquire_Locks_For_Copy_Actual(
807: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
808: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
809: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
810: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
811: AS

Line 822: FROM PA_PROJ_FP_OPTIONS

818: pragma exception_init(Resource_Busy,-00054);
819:
820: CURSOR fp_opt_cur IS
821: SELECT record_version_number
822: FROM PA_PROJ_FP_OPTIONS
823: WHERE fin_plan_version_id = p_plan_version_id
824: FOR UPDATE NOWAIT;
825:
826: CURSOR bdgt_ver_cur IS

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 849: pa_debug.g_err_stage:='Acquiring lock on pa_proj_fp_options';

845: * underlying child tables
846: */
847:
848: IF P_PA_DEBUG_MODE = 'Y' THEN
849: pa_debug.g_err_stage:='Acquiring lock on pa_proj_fp_options';
850: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
851: END IF;
852:
853: OPEN fp_opt_cur;

Line 863: --pa_proj_fp_options

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';
867: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);

Line 866: pa_debug.g_err_stage:='Incrementing record version number of plan version pa_proj_fp_options';

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';
867: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
868: END IF;
869:
870: UPDATE PA_PROJ_FP_OPTIONS

Line 870: UPDATE PA_PROJ_FP_OPTIONS

866: pa_debug.g_err_stage:='Incrementing record version number of plan version pa_proj_fp_options';
867: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,3);
868: END IF;
869:
870: UPDATE PA_PROJ_FP_OPTIONS
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

Line 1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

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;
1036: l_version_type pa_budget_versions.version_type%TYPE;

Line 1059: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

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;
1063: l_gl_start_Date VARCHAR2(100);

Line 1693: FROM pa_proj_fp_options

1689: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, 'Y',
1690: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, 'Y') --revenue_flag
1691: INTO l_cost_flag
1692: ,l_revenue_flag
1693: FROM pa_proj_fp_options
1694: WHERE fin_plan_version_id = px_target_version_id;
1695:
1696: --Set the cost and revenue flags to 'N' if adj percentage is nonzero.
1697:

Line 2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

2264: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
2265:
2266: l_tmp NUMBER;
2267: l_source_project_id pa_projects_all.project_id%TYPE;
2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;
2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2271:
2272: l_project_org pa_projects_all.carrying_out_organization_id%TYPE; -- bug 6161031

Line 2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

2266: l_tmp NUMBER;
2267: l_source_project_id pa_projects_all.project_id%TYPE;
2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;
2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2271:
2272: l_project_org pa_projects_all.carrying_out_organization_id%TYPE; -- bug 6161031
2273:
2274:

Line 2349: FROM pa_proj_fp_options pfot,--target

2345: ,l_source_project_id
2346: ,l_fin_plan_level_code
2347: ,l_resource_list_id
2348: ,l_control_flag
2349: FROM pa_proj_fp_options pfot,--target
2350: pa_proj_fp_options pfos,--source
2351: pa_resource_lists_all_bg rl
2352: WHERE pfot.fin_plan_version_id=p_target_plan_version_id
2353: AND pfos.fin_plan_version_id=p_source_plan_version_id

Line 2350: pa_proj_fp_options pfos,--source

2346: ,l_fin_plan_level_code
2347: ,l_resource_list_id
2348: ,l_control_flag
2349: FROM pa_proj_fp_options pfot,--target
2350: pa_proj_fp_options pfos,--source
2351: pa_resource_lists_all_bg rl
2352: WHERE pfot.fin_plan_version_id=p_target_plan_version_id
2353: AND pfos.fin_plan_version_id=p_source_plan_version_id
2354: AND rl.resource_list_id=nvl(pfot.cost_resource_list_id, nvl(pfot.revenue_resource_list_id,pfot.all_resource_list_id));

Line 4096: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,

4092: ----3. Update rate based flag for RAs in the target version if any RAs have to be converted to non rate based
4093: ----4. Update the budget lines with the missing amounts
4094: PROCEDURE derv_missing_amts_chk_neg_qty
4095: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4096: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4097: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4098: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4099: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
4100: p_derv_rates_missing_amts_flag IN VARCHAR2,

Line 4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

4124: l_burd_cost_override_rate_tbl SYSTEM.pa_num_tbl_type;
4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4130: l_temp_flag VARCHAR2(1);
4131: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4132: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;

Line 4758: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

4754: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
4755: -- Bug 3927244
4756:
4757: --Bug 4290043
4758: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4759:
4760:
4761: BEGIN
4762:

Line 4840: FROM pa_proj_fp_options

4836: ,fin_plan_preference_code
4837: INTO l_revenue_flag
4838: ,l_cost_flag
4839: ,l_target_pref_code
4840: FROM pa_proj_fp_options
4841: WHERE fin_plan_version_id=p_target_plan_version_id;
4842: /*
4843: pa_debug.g_err_stage:='l_revenue_flag ='||l_revenue_flag;
4844: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5367: FROM pa_proj_fp_options

5363: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'-99') --copy both cost and revenue
5364: ,project_id
5365: INTO l_ignore_amount_type
5366: ,l_target_project_id
5367: FROM pa_proj_fp_options
5368: WHERE fin_plan_version_id=p_target_plan_version_id;
5369: /*
5370: pa_debug.g_err_stage:='l_ignore_amount_type = '||l_ignore_amount_type;
5371: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6000: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.

5996: PA_BUDGET_CORE.COPY_BUDGETS_FROM_PROJECT
5997: Bug# - 2981655 - Please see bug for the complete discussion about
5998: this bug. The core is, when copy_project is done with copy_budget_flag
5999: as N, we still have to copy the header level informations
6000: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.
6001: Also, we should not be copying the planning elements for any of the
6002: copied options since when copy_budget_flag is N, tasks may not have
6003: been copied from the source project to the target project.
6004:

Line 6043: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

6039:
6040: l_source_template_flag pa_projects_all.template_flag%TYPE;
6041: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6042: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6043: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6044: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6045: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6046:
6047: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 6045: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

6041: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6042: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6043: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6044: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6045: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6046:
6047: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6048:
6049: l_target_version_id pa_budget_versions.budget_version_id%TYPE;

Line 6047: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

6043: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6044: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;
6045: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6046:
6047: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6048:
6049: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6050: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6051: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 6051: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

6047: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
6048:
6049: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
6050: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
6051: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6052: l_target_record_version_num pa_budget_versions.record_version_number%TYPE;
6053: l_version_type pa_budget_versions.version_type%TYPE;
6054: l_funding_exists_flag VARCHAR2(1);
6055:

Line 6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;

6053: l_version_type pa_budget_versions.version_type%TYPE;
6054: l_funding_exists_flag VARCHAR2(1);
6055:
6056:
6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;

Line 6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

6054: l_funding_exists_flag VARCHAR2(1);
6055:
6056:
6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

6055:
6056:
6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;

6056:
6057: l_fp_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE;
6058: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
6059: l_appr_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
6060: l_appr_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
6061: l_struct_elem_version_id pa_proj_element_versions.element_version_id%TYPE;
6062: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6063: l_src_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6064:

Line 6264: FROM pa_proj_fp_options

6260: ,l_source_version_id
6261: ,l_source_fp_preference_code
6262: ,l_source_fin_plan_type_id
6263: ,l_plan_in_multi_curr_flag
6264: FROM pa_proj_fp_options
6265: WHERE proj_fp_options_id = l_proj_fp_options_id_tbl(l_index);
6266:
6267: IF P_PA_DEBUG_MODE = 'Y' THEN
6268: pa_debug.g_err_stage := 'Option level code = '||l_fp_option_level_code;

Line 6323: --Create equivalent fp option in pa_proj_fp_options for target

6319: END IF;/* Added for bug 2986930 */
6320: END IF;
6321:
6322: IF l_fp_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
6323: --Create equivalent fp option in pa_proj_fp_options for target
6324:
6325: IF P_PA_DEBUG_MODE = 'Y' THEN
6326: pa_debug.g_err_stage := 'Calling Create_Fp_Option';
6327: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 6330: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option (

6326: pa_debug.g_err_stage := 'Calling Create_Fp_Option';
6327: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6328: END IF;
6329:
6330: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option (
6331: px_target_proj_fp_option_id => l_target_proj_fp_options_id
6332: ,p_source_proj_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6333: ,p_target_fp_option_level_code => l_fp_option_level_code --same as source
6334: ,p_target_fp_preference_code => l_source_fp_preference_code

Line 6366: --Create equivalent fp option in pa_proj_fp_options for target

6362: ( NVL(p_agreement_amount,-1) < 0 AND NVL(l_baseline_funding_flag,'N') = 'N' ) OR
6363: ( NVL(p_agreement_amount,-1) > 0 and nvl(l_ar_exists,'N') = 'Y' and NVL(l_baseline_funding_flag,'N') = 'N')
6364: THEN
6365: /* Code addition for Bug 2986930 ends */
6366: --Create equivalent fp option in pa_proj_fp_options for target
6367:
6368: IF P_PA_DEBUG_MODE = 'Y' THEN
6369: pa_debug.g_err_stage := 'Calling Create_Fp_Option';
6370: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 6373: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option (

6369: pa_debug.g_err_stage := 'Calling Create_Fp_Option';
6370: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6371: END IF;
6372:
6373: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option (
6374: px_target_proj_fp_option_id => l_target_proj_fp_options_id
6375: ,p_source_proj_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6376: ,p_target_fp_option_level_code => l_fp_option_level_code --same as source
6377: ,p_target_fp_preference_code => l_source_fp_preference_code

Line 6886: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

6882: l_msg_index_out NUMBER;
6883: l_debug_mode VARCHAR2(30);
6884:
6885: l_index NUMBER;
6886: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6887: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6888: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6890:

Line 6887: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

6883: l_debug_mode VARCHAR2(30);
6884:
6885: l_index NUMBER;
6886: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6887: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6888: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6890:
6891: l_proj_fp_options_id_tbl PROJ_FP_OPTIONS_ID_TBL_TYP;

Line 6888: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

6884:
6885: l_index NUMBER;
6886: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6887: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6888: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6890:
6891: l_proj_fp_options_id_tbl PROJ_FP_OPTIONS_ID_TBL_TYP;
6892:

Line 6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

6885: l_index NUMBER;
6886: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6887: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
6888: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6890:
6891: l_proj_fp_options_id_tbl PROJ_FP_OPTIONS_ID_TBL_TYP;
6892:
6893: CURSOR cur_for_fp_options(c_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE) IS

Line 6893: CURSOR cur_for_fp_options(c_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE) IS

6889: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6890:
6891: l_proj_fp_options_id_tbl PROJ_FP_OPTIONS_ID_TBL_TYP;
6892:
6893: CURSOR cur_for_fp_options(c_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE) IS
6894: SELECT pfo.proj_fp_options_id
6895: ,pfo.fin_plan_type_id
6896: ,pfo.fin_plan_preference_code
6897: FROM pa_proj_fp_options pfo

Line 6897: FROM pa_proj_fp_options pfo

6893: CURSOR cur_for_fp_options(c_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE) IS
6894: SELECT pfo.proj_fp_options_id
6895: ,pfo.fin_plan_type_id
6896: ,pfo.fin_plan_preference_code
6897: FROM pa_proj_fp_options pfo
6898: ,pa_fin_plan_types_b fin
6899: WHERE project_id = p_source_project_id
6900: AND fin_plan_option_level_code = c_level_code
6901: AND pfo.fin_plan_type_id = fin.fin_plan_type_id(+)

Line 7237: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,

7233: Private procedure (not available in specification) used by COPY_BUDGET_LINES
7234: (with shift days logic) to insert shifted periods data into pa_fp_cpy_period_tmp */
7235:
7236: PROCEDURE populate_cpy_periods_tmp(p_budget_version_id PA_BUDGET_LINES.budget_version_id%type,
7237: p_period_type PA_PROJ_FP_OPTIONS.cost_time_phased_code%TYPE,
7238: p_shift_periods number) AS
7239: cursor bl_periods is
7240: SELECT distinct bl.period_name,bl.start_date
7241: FROM pa_budget_lines bl

Line 7342: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

7338: l_return_status VARCHAR2(2000);
7339: l_debug_mode VARCHAR2(30);
7340:
7341: l_shift_days NUMBER;
7342: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
7343: l_target_budget_entry_level pa_proj_fp_options.all_fin_plan_level_code%TYPE; /* bug2726011 */
7344: l_target_proj_start_date DATE; /*bug2726011*/
7345: l_target_proj_completion_date DATE; /*bug2726011*/
7346:

Line 7343: l_target_budget_entry_level pa_proj_fp_options.all_fin_plan_level_code%TYPE; /* bug2726011 */

7339: l_debug_mode VARCHAR2(30);
7340:
7341: l_shift_days NUMBER;
7342: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
7343: l_target_budget_entry_level pa_proj_fp_options.all_fin_plan_level_code%TYPE; /* bug2726011 */
7344: l_target_proj_start_date DATE; /*bug2726011*/
7345: l_target_proj_completion_date DATE; /*bug2726011*/
7346:
7347: /* Bug# 2634726 */

Line 8773: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

8769: l_adj_percentage NUMBER;
8770: l_copy_mode VARCHAR2(1) := p_copy_mode;
8771: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8772: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8773: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8774: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8775: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8776: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8777: l_pji_rollup_required VARCHAR(1);

Line 8774: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

8770: l_copy_mode VARCHAR2(1) := p_copy_mode;
8771: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8772: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8773: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8774: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8775: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8776: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8777: l_pji_rollup_required VARCHAR(1);
8778:

Line 8776: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

8772: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8773: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8774: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8775: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8776: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8777: l_pji_rollup_required VARCHAR(1);
8778:
8779: -- pjdvdsn1 compile issues, 03-FEB-2004, jwhite -------------------------
8780:

Line 9004: FROM pa_proj_fp_options

9000: BEGIN
9001:
9002: SELECT proj_fp_options_id
9003: INTO l_src_proj_fp_options_id
9004: FROM pa_proj_fp_options
9005: WHERE fin_plan_version_id=l_src_budget_version_id;
9006:
9007: EXCEPTION
9008: WHEN NO_DATA_FOUND THEN

Line 9011: pa_debug.g_err_stage:='No data found in pa_proj_fp_options for fin_plan_version_id '

9007: EXCEPTION
9008: WHEN NO_DATA_FOUND THEN
9009:
9010: IF l_debug_mode = 'Y' THEN
9011: pa_debug.g_err_stage:='No data found in pa_proj_fp_options for fin_plan_version_id '
9012: ||l_src_budget_version_id;
9013: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
9014: END IF;
9015: RAISE;

Line 9025: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option

9021: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
9022: END IF;
9023:
9024: --Call the method to create the FP Option
9025: PA_PROJ_FP_OPTIONS_PUB.Create_Fp_Option
9026: (
9027: px_target_proj_fp_option_id => l_targ_proj_fp_options_id
9028: ,p_source_proj_fp_option_id => l_src_proj_fp_options_id
9029: ,p_target_fp_option_level_code => PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

Line 9051: FROM pa_proj_fp_options

9047:
9048: --Derive the multi currency flag so as to call the copy planning txn currencies
9049: SELECT plan_in_multi_curr_flag
9050: INTO l_targ_multi_curr_flag
9051: FROM pa_proj_fp_options
9052: WHERE proj_fp_options_id=l_targ_proj_fp_options_id;
9053:
9054: IF l_debug_mode = 'Y' THEN
9055: pa_debug.g_err_stage:='Calling copy fp txn currencies';

Line 9502: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

9498:
9499: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
9500:
9501: --Bug 4290043.
9502: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9503: l_source_version_type pa_budget_versions.version_type%TYPE;
9504: l_target_version_type pa_budget_versions.version_type%TYPE;
9505: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
9506:

Line 9572: FROM pa_proj_fp_options

9568: ,fin_plan_preference_code
9569: INTO l_revenue_flag
9570: ,l_cost_flag
9571: ,l_targ_pref_code
9572: FROM pa_proj_fp_options
9573: WHERE fin_plan_version_id=p_target_plan_version_id;
9574:
9575: --Bug 3927244
9576: --Bug 4290043. Selected version type too

Line 10075: (pa_proj_fp_options)

10071: the budgets related data from source published version.
10072: Synchronisation involves:
10073: 1) pa_fp_txn_currencies
10074: 2) rate schedules, generation options and plan settings data
10075: (pa_proj_fp_options)
10076:
10077: Stating some of the business rules for clarity:
10078: i) If there is a published version, time phasing can not be changed
10079: ii) Planning resource list can change only if existing resource list is

Line 10085: Bug 3725414: In update to pa_proj_fp_options, rbs_version_id column is missing

10081: data. Please note that in this case, only 'PEOPLE' resource class assignments
10082: would be present.
10083: iii) RBS can be different only if existing RBS is null.
10084:
10085: Bug 3725414: In update to pa_proj_fp_options, rbs_version_id column is missing
10086:
10087: Bug 4101153: Current Planning period should always get the value from the source version and
10088: not from the workplan plan type option. Removed the update to current planning period
10089:

Line 10154: FROM pa_proj_fp_options pfo

10150: ,pfo.cost_job_rate_sch_id
10151: ,pfo.cost_non_labor_res_rate_sch_id
10152: ,pfo.cost_res_class_rate_sch_id
10153: ,pfo.cost_burden_rate_sch_id
10154: FROM pa_proj_fp_options pfo
10155: ,pa_fin_plan_types_b fpt
10156: WHERE pfo.project_id = p_project_id
10157: AND pfo.fin_plan_type_id = fpt.fin_plan_type_id
10158: AND fpt.use_for_workplan_flag = 'Y'

Line 10167: FROM pa_proj_fp_options pfo

10163: CURSOR wp_version_options_cur IS
10164: SELECT pfo.proj_fp_options_id
10165: ,pfo.rbs_version_id
10166: ,pfo.cost_resource_list_id
10167: FROM pa_proj_fp_options pfo
10168: ,pa_budget_versions bv
10169: WHERE bv.budget_version_id = p_wp_version_id
10170: AND bv.project_id = pfo.project_id
10171: AND pfo.fin_plan_version_id = bv.budget_version_id;

Line 10263: -- Update pa_proj_fp_options entity

10259: ,last_update_login = FND_GLOBAL.login_id
10260: ,record_version_number = record_version_number + 1
10261: WHERE budget_version_id = p_wp_version_id;
10262:
10263: -- Update pa_proj_fp_options entity
10264: UPDATE pa_proj_fp_options
10265: SET track_workplan_costs_flag = parent_plan_type_rec.track_workplan_costs_flag
10266: ,plan_in_multi_curr_flag = parent_plan_type_rec.plan_in_multi_curr_flag
10267: ,margin_derived_from_code = parent_plan_type_rec.margin_derived_from_code

Line 10264: UPDATE pa_proj_fp_options

10260: ,record_version_number = record_version_number + 1
10261: WHERE budget_version_id = p_wp_version_id;
10262:
10263: -- Update pa_proj_fp_options entity
10264: UPDATE pa_proj_fp_options
10265: SET track_workplan_costs_flag = parent_plan_type_rec.track_workplan_costs_flag
10266: ,plan_in_multi_curr_flag = parent_plan_type_rec.plan_in_multi_curr_flag
10267: ,margin_derived_from_code = parent_plan_type_rec.margin_derived_from_code
10268: ,factor_by_code = parent_plan_type_rec.factor_by_code