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

Line 20: (budget_version_id pa_budget_versions.budget_version_id%TYPE

16: ----NONE(Impact can be implemented)
17: --impl_cost_flag and impl_rev_flag will be either Y or N indicating whether the ci id can be implemented in
18: --the budget version id or not
19: TYPE budget_ci_map_rec IS RECORD
20: (budget_version_id pa_budget_versions.budget_version_id%TYPE
21: ,ci_id pa_control_items.ci_id%TYPE
22: ,impact_type_code VARCHAR2(10)
23: ,impl_cost_flag VARCHAR2(1)
24: ,impl_rev_flag VARCHAR2(1));

Line 71: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

67:
68: PROCEDURE FP_CI_LINK_CONTROL_ITEMS
69: (
70: p_project_id IN NUMBER,
71: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
72: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_inclusion_method IN VARCHAR2,
74: p_included_by IN NUMBER,
75: --Added for bug 3550073

Line 72: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

68: PROCEDURE FP_CI_LINK_CONTROL_ITEMS
69: (
70: p_project_id IN NUMBER,
71: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
72: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_inclusion_method IN VARCHAR2,
74: p_included_by IN NUMBER,
75: --Added for bug 3550073
76: p_version_type IN pa_budget_versions.version_type%TYPE,

Line 76: p_version_type IN pa_budget_versions.version_type%TYPE,

72: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
73: p_inclusion_method IN VARCHAR2,
74: p_included_by IN NUMBER,
75: --Added for bug 3550073
76: p_version_type IN pa_budget_versions.version_type%TYPE,
77: p_ci_id IN pa_control_items.ci_id%TYPE,
78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,

Line 102: l_s_ci_id pa_budget_versions.ci_id%TYPE;

98: l_creation_date DATE := SYSDATE;
99: l_last_update_date DATE := l_creation_date;
100: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
101:
102: l_s_ci_id pa_budget_versions.ci_id%TYPE;
103: l_included_by NUMBER := 0;
104: l_party_id NUMBER := 0;
105: l_debug_mode VARCHAR2(30);
106: l_module_name VARCHAR2(100):='PAFPCIMB.FP_CI_LINK_CONTROL_ITEMS';

Line 212: FROM pa_budget_versions bv

208: SELECT
209: bv.ci_id
210: INTO
211: l_s_ci_id
212: FROM pa_budget_versions bv
213: WHERE bv.budget_version_id = p_s_fp_version_id
214: AND bv.project_id = p_project_id;
215: EXCEPTION
216: WHEN NO_DATA_FOUND THEN

Line 400: p_project_id IN pa_budget_versions.project_id%TYPE,

396: ***************************************************************/
397:
398: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
399: (
400: p_project_id IN pa_budget_versions.project_id%TYPE,
401: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
402: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
403: p_merge_unmerge_mode IN VARCHAR2 ,
404: p_commit_flag IN VARCHAR2 ,

Line 401: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

397:
398: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
399: (
400: p_project_id IN pa_budget_versions.project_id%TYPE,
401: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
402: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
403: p_merge_unmerge_mode IN VARCHAR2 ,
404: p_commit_flag IN VARCHAR2 ,
405: p_init_msg_list IN VARCHAR2 ,

Line 402: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

398: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
399: (
400: p_project_id IN pa_budget_versions.project_id%TYPE,
401: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
402: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
403: p_merge_unmerge_mode IN VARCHAR2 ,
404: p_commit_flag IN VARCHAR2 ,
405: p_init_msg_list IN VARCHAR2 ,
406: p_update_agreement IN VARCHAR2,

Line 420: l_target_ver_type pa_budget_versions.version_type%TYPE;

416: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
417:
418: l_debug_mode VARCHAR2(30);
419:
420: l_target_ver_type pa_budget_versions.version_type%TYPE;
421:
422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

Line 422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

418: l_debug_mode VARCHAR2(30);
419:
420: l_target_ver_type pa_budget_versions.version_type%TYPE;
421:
422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

Line 423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;

419:
420: l_target_ver_type pa_budget_versions.version_type%TYPE;
421:
422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

Line 424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

420: l_target_ver_type pa_budget_versions.version_type%TYPE;
421:
422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

Line 425: l_est_quantity pa_budget_versions.est_quantity%TYPE;

421:
422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

422: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;
430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;

Line 427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

423: l_est_project_burdened_cost pa_budget_versions.est_project_burdened_cost%TYPE;
424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;
430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;
431:

Line 428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

424: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;
430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;
431:
432: BEGIN

Line 429: l_agreement_id pa_budget_versions.agreement_id%TYPE;

425: l_est_quantity pa_budget_versions.est_quantity%TYPE;
426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;
430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;
431:
432: BEGIN
433: IF p_pa_debug_mode = 'Y' THEN

Line 430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;

426: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
427: l_est_projfunc_burdened_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
428: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
429: l_agreement_id pa_budget_versions.agreement_id%TYPE;
430: l_est_equipment_quantity pa_budget_versions.est_equipment_quantity%TYPE;
431:
432: BEGIN
433: IF p_pa_debug_mode = 'Y' THEN
434: pa_debug.init_err_stack('PAFPCIMB.FP_CI_UPDATE_EST_AMOUNTS');

Line 488: FROM pa_budget_versions bv

484: -- Get the target version type
485: BEGIN
486: SELECT bv.version_type
487: INTO l_target_ver_type
488: FROM pa_budget_versions bv
489: WHERE
490: bv.project_id = p_project_id
491: AND bv.budget_version_id = p_target_version_id;
492: EXCEPTION

Line 524: FROM PA_BUDGET_VERSIONS bv

520: l_est_projfunc_burdened_cost,
521: l_est_projfunc_revenue,
522: l_est_equipment_quantity,
523: l_agreement_id
524: FROM PA_BUDGET_VERSIONS bv
525: WHERE
526: bv.project_id = p_project_id
527: AND bv.budget_version_id = p_source_version_id;
528:

Line 541: UPDATE PA_BUDGET_VERSIONS bv

537:
538: -- Update the budget versions table for the target version
539: -- based on version type
540: IF(l_target_ver_type = 'ALL') THEN
541: UPDATE PA_BUDGET_VERSIONS bv
542: SET
543: est_project_raw_cost = NVL(est_project_raw_cost,0) + DECODE
544: (p_merge_unmerge_mode,
545: 'MERGE', l_est_project_raw_cost,

Line 583: UPDATE PA_BUDGET_VERSIONS bv

579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: ELSIF(l_target_ver_type = 'COST') THEN
583: UPDATE PA_BUDGET_VERSIONS bv
584: SET
585: est_project_raw_cost = NVL(est_project_raw_cost,0) + DECODE
586: (p_merge_unmerge_mode,
587: 'MERGE', l_est_project_raw_cost,

Line 613: UPDATE PA_BUDGET_VERSIONS bv

609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: ELSIF(l_target_ver_type = 'REVENUE') THEN
613: UPDATE PA_BUDGET_VERSIONS bv
614: SET
615: est_project_revenue = NVL(est_project_revenue,0) + DECODE
616: (p_merge_unmerge_mode,
617: 'MERGE', l_est_project_revenue,

Line 637: UPDATE PA_BUDGET_VERSIONS bv

633: END IF;
634: END IF;
635:
636: IF (p_update_agreement = 'Y') THEN
637: UPDATE PA_BUDGET_VERSIONS bv
638: SET
639: agreement_id = l_agreement_id
640: WHERE
641: bv.project_id = p_project_id

Line 834: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,

830:
831: PROCEDURE FP_CI_MERGE_CI_ITEMS
832: (
833: p_project_id IN NUMBER,
834: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
835: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
836: p_merge_unmerge_mode IN VARCHAR2 ,
837: p_commit_flag IN VARCHAR2 ,
838: p_init_msg_list IN VARCHAR2 ,

Line 835: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,

831: PROCEDURE FP_CI_MERGE_CI_ITEMS
832: (
833: p_project_id IN NUMBER,
834: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
835: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
836: p_merge_unmerge_mode IN VARCHAR2 ,
837: p_commit_flag IN VARCHAR2 ,
838: p_init_msg_list IN VARCHAR2 ,
839: p_calling_context IN VARCHAR2,

Line 847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;

843: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
844: )
845: IS
846: --Defining PL/SQL local variables
847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;

Line 848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;

844: )
845: IS
846: --Defining PL/SQL local variables
847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

Line 849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

845: IS
846: --Defining PL/SQL local variables
847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;

Line 850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;

846: --Defining PL/SQL local variables
847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;
854: l_task_id NUMBER;

Line 851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;

847: l_s_fp_ci_id pa_budget_versions.ci_id%TYPE;
848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;
854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;

Line 852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;

848: l_t_fp_ci_id pa_budget_versions.ci_id%TYPE;
849: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
850: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;
854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;

851: l_target_version_id_tmp pa_budget_versions.budget_version_id%TYPE;
852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;
854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

Line 863: l_s_version_type pa_budget_versions.version_type%TYPE;

859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;

Line 864: l_s_ci_id pa_budget_versions.ci_id%TYPE;

860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

Line 865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;

861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 873: l_t_version_type pa_budget_versions.version_type%TYPE;

869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;
875: l_source_ver_type pa_budget_versions.version_type%TYPE;
876: l_target_ver_type pa_budget_versions.version_type%TYPE;
877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 874: l_t_ci_id pa_budget_versions.ci_id%TYPE;

870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;
875: l_source_ver_type pa_budget_versions.version_type%TYPE;
876: l_target_ver_type pa_budget_versions.version_type%TYPE;
877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
878:

Line 875: l_source_ver_type pa_budget_versions.version_type%TYPE;

871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;
875: l_source_ver_type pa_budget_versions.version_type%TYPE;
876: l_target_ver_type pa_budget_versions.version_type%TYPE;
877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
878:
879: --Defining Local PL/SQL variables for source version

Line 876: l_target_ver_type pa_budget_versions.version_type%TYPE;

872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;
875: l_source_ver_type pa_budget_versions.version_type%TYPE;
876: l_target_ver_type pa_budget_versions.version_type%TYPE;
877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
878:
879: --Defining Local PL/SQL variables for source version
880: l_source_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 965: FROM pa_budget_versions bv

961:
962: --Check if any budget versions exist for the target
963: --control item id or not
964: SELECT COUNT(*) INTO l_t_count_versions
965: FROM pa_budget_versions bv
966: WHERE
967: bv.project_id = p_project_id
968: AND bv.ci_id = l_t_fp_ci_id
969: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 985: FROM pa_budget_versions bv

981:
982: -- Get the number of source budget versions
983: SELECT count(*)
984: INTO l_s_version_id_count
985: FROM pa_budget_versions bv
986: WHERE
987: bv.project_id = p_project_id
988: AND bv.ci_id = l_s_fp_ci_id
989: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 997: FROM pa_budget_versions bv

993:
994: --Get source version id
995: SELECT bv.budget_version_id
996: BULK COLLECT INTO l_source_id_tbl
997: FROM pa_budget_versions bv
998: WHERE
999: bv.project_id = p_project_id
1000: AND bv.ci_id = l_s_fp_ci_id
1001: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 1013: FROM pa_budget_versions bv

1009:
1010: -- Get the source version type
1011: SELECT bv.version_type
1012: INTO l_source_ver_type
1013: FROM pa_budget_versions bv
1014: WHERE
1015: bv.project_id = p_project_id
1016: AND bv.budget_version_id = l_source_version_id;
1017:

Line 1023: FROM pa_budget_versions bv

1019: --Get target version id
1020: BEGIN
1021: SELECT bv.budget_version_id
1022: INTO l_target_version_id
1023: FROM pa_budget_versions bv
1024: WHERE
1025: bv.project_id = p_project_id
1026: AND bv.ci_id = l_t_fp_ci_id
1027: AND bv.version_type = l_source_ver_type

Line 1168: UPDATE pa_budget_versions bv

1164: END IF;
1165:
1166: l_update_agreement_flag := 'Y';
1167: --Stamp the Control item ids for these budget versions
1168: UPDATE pa_budget_versions bv
1169: SET CI_ID = l_t_fp_ci_id
1170: ,VERSION_NUMBER = 1 -- bug 3677924
1171: WHERE
1172: p_project_id = bv.project_id

Line 1183: FROM pa_budget_versions bv

1179: --Get target version id for correct source version type
1180: BEGIN
1181: SELECT bv.budget_version_id
1182: INTO l_target_version_id
1183: FROM pa_budget_versions bv
1184: WHERE
1185: bv.project_id = p_project_id
1186: AND bv.ci_id = l_t_fp_ci_id
1187: AND bv.version_type = l_source_ver_type

Line 1458: FROM pa_budget_versions bv

1454: ELSIF (l_s_version_id_count = 2) THEN
1455: --Get both source version ids
1456: SELECT bv.budget_version_id
1457: BULK COLLECT INTO l_source_fp_version_id_tbl
1458: FROM pa_budget_versions bv
1459: WHERE
1460: bv.project_id = p_project_id
1461: AND bv.ci_id = l_s_fp_ci_id
1462: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 1596: UPDATE pa_budget_versions bv

1592:
1593: l_update_agreement_flag := 'Y';
1594:
1595: --Stamp the Control item ids for this budget versions
1596: UPDATE pa_budget_versions bv
1597: SET CI_ID = l_t_fp_ci_id
1598: ,version_number = 1 -- Bug 3677924 Jul 06 2004 Raja
1599: WHERE
1600: p_project_id = bv.project_id

Line 1636: FROM pa_budget_versions bv

1632: --Get target version id
1633: --Since ordered by version type, the first version should be cost and the second one should be revenue
1634: SELECT bv.budget_version_id
1635: BULK COLLECT INTO l_target_fp_version_id_tbl
1636: FROM pa_budget_versions bv
1637: WHERE
1638: bv.project_id = p_project_id
1639: AND bv.ci_id = l_t_fp_ci_id
1640: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 1931: FROM pa_budget_versions bv

1927: ELSIF(l_t_count_versions = 1) THEN
1928: --Get target version id and version type
1929: SELECT bv.budget_version_id, bv.version_type
1930: INTO l_target_version_id, l_target_ver_type
1931: FROM pa_budget_versions bv
1932: WHERE
1933: bv.project_id = p_project_id
1934: AND bv.ci_id = l_t_fp_ci_id
1935: AND (NVL(bv.approved_rev_plan_type_flag,'N') = 'Y'

Line 2030: FROM pa_budget_versions bv

2026:
2027: -- Get the source version type
2028: SELECT bv.version_type
2029: INTO l_source_ver_type
2030: FROM pa_budget_versions bv
2031: WHERE bv.project_id = p_project_id
2032: AND bv.budget_version_id = l_source_version_id;
2033:
2034: IF(l_source_ver_type <> l_target_ver_type) THEN

Line 2157: UPDATE pa_budget_versions bv

2153: RETURN;
2154: END IF;
2155: l_update_agreement_flag := 'Y';
2156: --Stamp the Control item ids for these budget versions
2157: UPDATE pa_budget_versions bv
2158: SET CI_ID = l_t_fp_ci_id
2159: WHERE
2160: p_project_id = bv.project_id
2161: AND bv.budget_version_id = l_target_version_id

Line 2534: ( p_project_id IN pa_budget_versions.project_id%TYPE

2530: ==================================================================*/
2531:
2532: --Bug 4247703. Added the parameter p_calling_context. The valid values are NULL or GENERATION
2533: PROCEDURE copy_merged_ctrl_items
2534: ( p_project_id IN pa_budget_versions.project_id%TYPE
2535: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
2536: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
2537: ,p_calling_context IN VARCHAR2
2538: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2535: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE

2531:
2532: --Bug 4247703. Added the parameter p_calling_context. The valid values are NULL or GENERATION
2533: PROCEDURE copy_merged_ctrl_items
2534: ( p_project_id IN pa_budget_versions.project_id%TYPE
2535: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
2536: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
2537: ,p_calling_context IN VARCHAR2
2538: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2539: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2536: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE

2532: --Bug 4247703. Added the parameter p_calling_context. The valid values are NULL or GENERATION
2533: PROCEDURE copy_merged_ctrl_items
2534: ( p_project_id IN pa_budget_versions.project_id%TYPE
2535: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
2536: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
2537: ,p_calling_context IN VARCHAR2
2538: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2539: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2540: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2641: pa_budget_versions sourcever,

2637: ,pmc.impl_quantity impl_quantity
2638: ,pmc.impl_equipment_quantity impl_equipment_quantity
2639: ,pmc.impl_agr_revenue impl_agr_revenue
2640: FROM pa_fp_merged_ctrl_items pmc,
2641: pa_budget_versions sourcever,
2642: pa_budget_versions targetver -- Bug 3720445
2643: WHERE plan_version_id = p_source_version_id
2644: AND sourcever.budget_version_id=p_source_version_id
2645: AND targetver.budget_version_id=p_target_version_id -- Bug 3720445

Line 2642: pa_budget_versions targetver -- Bug 3720445

2638: ,pmc.impl_equipment_quantity impl_equipment_quantity
2639: ,pmc.impl_agr_revenue impl_agr_revenue
2640: FROM pa_fp_merged_ctrl_items pmc,
2641: pa_budget_versions sourcever,
2642: pa_budget_versions targetver -- Bug 3720445
2643: WHERE plan_version_id = p_source_version_id
2644: AND sourcever.budget_version_id=p_source_version_id
2645: AND targetver.budget_version_id=p_target_version_id -- Bug 3720445
2646: AND pmc.version_type = Decode (targetver.version_type, 'ALL', pmc.version_type,

Line 2770: pa_budget_versions sourcever,

2766: ,pmc.impl_quantity
2767: ,pmc.impl_equipment_quantity
2768: ,pmc.impl_agr_revenue
2769: FROM pa_fp_merged_ctrl_items pmc,
2770: pa_budget_versions sourcever,
2771: pa_budget_versions targetver -- Bug 3720445
2772: WHERE plan_version_id = p_source_version_id
2773: AND sourcever.budget_version_id=p_source_version_id
2774: AND targetver.budget_version_id=p_target_version_id -- Bug 3720445

Line 2771: pa_budget_versions targetver -- Bug 3720445

2767: ,pmc.impl_equipment_quantity
2768: ,pmc.impl_agr_revenue
2769: FROM pa_fp_merged_ctrl_items pmc,
2770: pa_budget_versions sourcever,
2771: pa_budget_versions targetver -- Bug 3720445
2772: WHERE plan_version_id = p_source_version_id
2773: AND sourcever.budget_version_id=p_source_version_id
2774: AND targetver.budget_version_id=p_target_version_id -- Bug 3720445
2775: AND pmc.project_id = p_project_id -- Bug 4493425

Line 2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

2853: PROCEDURE FP_CI_MANUAL_MERGE
2854: (
2855: p_project_id IN NUMBER,
2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,

Line 2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

2854: (
2855: p_project_id IN NUMBER,
2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
2862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,

2855: p_project_id IN NUMBER,
2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
2862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2863: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
2862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2863: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2864: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,

2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
2861: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
2862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2863: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2864: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2865: )

Line 2881: CURSOR c_impl_dtls_csr (c_ci_version_id pa_budget_versions.budget_version_id%TYPE)

2877: l_impl_version_type pa_fp_merged_ctrl_items.version_type%TYPE;
2878:
2879: --This cursor is introduced for bug 3550073. In manual merge a link will be created which
2880: --indicates that the amounts are copied from the source to the target version. The user has to
2881: CURSOR c_impl_dtls_csr (c_ci_version_id pa_budget_versions.budget_version_id%TYPE)
2882: IS
2883: SELECT pbvs.burdened_cost pfc_burd_cost,
2884: pbvs.revenue pfc_revenue,
2885: pbvs.raw_cost pfc_raw_cost,

Line 2893: FROM pa_budget_versions pbvs

2889: DECODE(pbvs.version_type,'REVENUE',NULL,pbvs.labor_quantity) cost_ppl_qty,
2890: DECODE(pbvs.version_type,'REVENUE',NULL,pbvs.equipment_quantity) cost_equip_qty,
2891: DECODE(pbvs.version_type,'REVENUE',pbvs.labor_quantity,NULL) rev_ppl_qty,
2892: DECODE(pbvs.version_type,'REVENUE',pbvs.equipment_quantity,NULL) rev_equip_qty
2893: FROM pa_budget_versions pbvs
2894: WHERE pbvs.budget_version_id=c_ci_version_id;
2895:
2896: l_impl_dtls_rec c_impl_dtls_csr%ROWTYPE;
2897:

Line 3428: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed

3424:
3425: PROCEDURE implement_ci_into_single_ver(p_context IN VARCHAR2
3426: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- bug 3934574
3427: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
3428: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3429: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3430: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
3431: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
3432: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

Line 3429: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed

3425: PROCEDURE implement_ci_into_single_ver(p_context IN VARCHAR2
3426: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- bug 3934574
3427: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
3428: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3429: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3430: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
3431: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
3432: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3433: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

Line 3430: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed

3426: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- bug 3934574
3427: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
3428: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3429: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3430: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
3431: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
3432: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3433: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3434: ,P_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation

Line 3431: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented

3427: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
3428: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3429: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
3430: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
3431: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
3432: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3433: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3434: ,P_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
3435: ,p_cost_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether cost can be implemented or not.

Line 3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;

3489: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3490:
3491: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
3492:
3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;
3494: l_partial_factor NUMBER := 1;
3495: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3496: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
3497: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;

Line 3496: l_total_amt pa_budget_versions.total_project_revenue%TYPE;

3492:
3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;
3494: l_partial_factor NUMBER := 1;
3495: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3496: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
3497: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
3498: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
3499:
3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;

3828: l_bl_rbf_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3829:
3830: -- End of tables prepared to insert/update into pa_budget_lines
3831:
3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3835:
3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

Line 3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;

3829:
3830: -- End of tables prepared to insert/update into pa_budget_lines
3831:
3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3835:
3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
3837: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

Line 3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;

3830: -- End of tables prepared to insert/update into pa_budget_lines
3831:
3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3835:
3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
3837: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
3838:

Line 3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

3832: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3835:
3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
3837: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
3838:
3839: L_SAME_MULTI_CURR_FLAG VARCHAR2(1);
3840: l_amt_used_for_rate_calc NUMBER;

Line 3851: FROM pa_budget_versions

3847: ,nvl(burdened_cost,0)
3848: ,nvl(revenue,0)
3849: ,nvl(labor_quantity,0)
3850: ,nvl(equipment_quantity,0)
3851: FROM pa_budget_versions
3852: WHERE budget_version_id = p_budget_version_id;
3853:
3854:
3855: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS

Line 3856: l_version_type pa_budget_versions.version_type%TYPE;

3852: WHERE budget_version_id = p_budget_version_id;
3853:
3854:
3855: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3856: l_version_type pa_budget_versions.version_type%TYPE;
3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;

Line 3867: l_target_version_type pa_budget_versions.version_type%TYPE;

3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);

Line 3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;

Line 3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;

3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;

Line 3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;

3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;

Line 3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;

3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;

Line 3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;

3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;

Line 3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;

3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;

Line 3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;

3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;
3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;

Line 3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;

3873: l_targ_eqp_qty_before_merge pa_budget_versions.equipment_quantity%TYPE;
3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;

Line 3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;

3874: l_targ_pfc_rawc_before_merge pa_budget_versions.raw_cost%TYPE;
3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;

Line 3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;

3875: l_targ_pfc_burdc_before_merge pa_budget_versions.burdened_cost%TYPE;
3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;

Line 3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;

3876: l_targ_pfc_rev_before_merge pa_budget_versions.revenue%TYPE;
3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;

Line 3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;

3877: l_targ_pc_rawc_before_merge pa_budget_versions.total_project_raw_cost%TYPE;
3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;

Line 3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;

3878: l_targ_pc_burdc_before_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;

Line 3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;

3879: l_targ_pc_rev_before_merge pa_budget_versions.total_project_revenue%TYPE;
3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;

Line 3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;

3880: l_targ_lab_qty_after_merge pa_budget_versions.labor_quantity%TYPE;
3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;
3888: l_impl_earlier VARCHAR2(1);

Line 3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;

3881: l_targ_eqp_qty_after_merge pa_budget_versions.equipment_quantity%TYPE;
3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;
3888: l_impl_earlier VARCHAR2(1);
3889: l_total_agr_revenue pa_budget_lines.txn_revenue%TYPE;

Line 3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;

3882: l_targ_pfc_rawc_after_merge pa_budget_versions.raw_cost%TYPE;
3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;
3888: l_impl_earlier VARCHAR2(1);
3889: l_total_agr_revenue pa_budget_lines.txn_revenue%TYPE;
3890:

Line 3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;

3883: l_targ_pfc_burdc_after_merge pa_budget_versions.burdened_cost%TYPE;
3884: l_targ_pfc_rev_after_merge pa_budget_versions.revenue%TYPE;
3885: l_targ_pc_rawc_after_merge pa_budget_versions.total_project_raw_cost%TYPE;
3886: l_targ_pc_burdc_after_merge pa_budget_versions.total_project_burdened_cost%TYPE;
3887: l_targ_pc_rev_after_merge pa_budget_versions.total_project_revenue%TYPE;
3888: l_impl_earlier VARCHAR2(1);
3889: l_total_agr_revenue pa_budget_lines.txn_revenue%TYPE;
3890:
3891: l_partial_impl_rev_amt NUMBER;

Line 3898: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

3894: --Variable used for passing ci id to the change management baseline API.
3895: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
3896: l_temp NUMBER;
3897: X_Err_Code NUMBER;
3898: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3899:
3900: -- variables introduced for bug 3934574
3901: l_retain_manual_lines_flag VARCHAR2(1);
3902:

Line 3937: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS

3933: -- Added a condition to choose only the RA having the budget lines as the LAST RA.This cursor will be
3934: -- used in the case when both source and target have the same resource lists.(Please note that any changes
3935: -- in this cursor might have to be done in src_delta_amt_adj_ra_cur1 also)
3936: CURSOR src_delta_amt_adj_ra_cur
3937: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3938: SELECT pra.task_id, pra.resource_list_member_id, pra.resource_assignment_id,
3939: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3940: FROM pa_resource_assignments pra, pa_resource_list_members rlm
3941: WHERE pra.budget_version_id = c_budget_version_id

Line 3952: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS

3948: --This cursor is same as src_delta_amt_adj_ra_cur. This will be used when the source and target
3949: --have different resource lists.(Please note that any changes in this cursor might have to be
3950: --done in src_delta_amt_adj_ra_cur also)
3951: CURSOR src_delta_amt_adj_ra_cur1
3952: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)IS
3953: SELECT pra.task_id, tmp4.resource_list_member_id, pra.resource_assignment_id,
3954: PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(pra.task_id) as dispSeq, rlm.alias
3955: FROM pa_resource_assignments pra, pa_resource_list_members rlm,pa_res_list_map_tmp4 tmp4
3956: WHERE pra.budget_version_id = c_budget_version_id

Line 4033: -- Select the details required from pa_budget_versions so that they can be used in the later part of the code

4029: END IF;
4030:
4031: --dbms_output.put_line('I3');
4032: BEGIN
4033: -- Select the details required from pa_budget_versions so that they can be used in the later part of the code
4034: SELECT etc_start_date
4035: ,project_id
4036: ,version_type
4037: ,PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )

Line 4060: from pa_budget_versions

4056: ,l_targ_pc_rawc_before_merge
4057: ,l_targ_pc_burdc_before_merge
4058: ,l_targ_pc_rev_before_merge
4059: ,l_current_working_flag
4060: from pa_budget_versions
4061: WHERE budget_version_id = p_budget_version_id;
4062:
4063: IF P_PA_debug_mode = 'Y' THEN
4064: pa_debug.g_err_stage:= 'Fetching l_etc_start_date :'||l_etc_start_date;

Line 9410: FROM pa_budget_versions cibv,

9406: SELECT agr.agreement_id,
9407: agr.agreement_currency_code
9408: INTO l_agreement_id,
9409: l_agreement_currency_code
9410: FROM pa_budget_versions cibv,
9411: pa_agreements_all agr
9412: WHERE cibv.budget_version_id = l_src_ver_id_tbl(j)
9413: AND cibv.agreement_id = agr.agreement_id;
9414:

Line 10649: FROM pa_budget_versions

10645: ELSE*/-- Commented as part of bug 3877815, would remove completely, once review is done.
10646:
10647: SELECT record_version_number
10648: INTO l_record_version_number
10649: FROM pa_budget_versions
10650: WHERE budget_version_id=p_budget_version_id;
10651:
10652: pa_fin_plan_pub.Submit_Current_Working
10653: (p_project_id => l_project_id,

Line 10837: --rev_partially_impl_flag of pa_budget_Versions should be updated in case of partial implementation

10833: END IF;
10834:
10835: END IF;
10836:
10837: --rev_partially_impl_flag of pa_budget_Versions should be updated in case of partial implementation
10838: --It should be Y if the CO is implemented partially. It should be N if the CO has got fully implemented
10839: -- If the CO has earlier been partially implemented(l_impl_earlier = 'Y'), inclusion will make it fully implemented.
10840: -- So, rev_partially_impl_flag should be set to 'N'
10841: IF p_context='PARTIAL_REV' OR l_impl_earlier = 'Y' THEN

Line 10845: UPDATE pa_budget_versions

10841: IF p_context='PARTIAL_REV' OR l_impl_earlier = 'Y' THEN
10842:
10843: IF nvl(l_impl_amt,0) + l_partial_impl_rev_amt = l_total_amt THEN
10844:
10845: UPDATE pa_budget_versions
10846: SET rev_partially_impl_flag ='N'
10847: ,record_version_number =record_version_number+1
10848: ,last_update_date =sysdate
10849: ,last_update_login =fnd_global.login_id

Line 10855: --Update pa_budget_versions only if rev_partially_impl_flag is not already Y

10851: WHERE budget_version_id = l_src_ver_id_tbl(j);
10852:
10853: ELSE
10854:
10855: --Update pa_budget_versions only if rev_partially_impl_flag is not already Y
10856: UPDATE pa_budget_versions
10857: SET rev_partially_impl_flag ='Y'
10858: ,record_version_number =record_version_number+1
10859: ,last_update_date =sysdate

Line 10856: UPDATE pa_budget_versions

10852:
10853: ELSE
10854:
10855: --Update pa_budget_versions only if rev_partially_impl_flag is not already Y
10856: UPDATE pa_budget_versions
10857: SET rev_partially_impl_flag ='Y'
10858: ,record_version_number =record_version_number+1
10859: ,last_update_date =sysdate
10860: ,last_update_login =fnd_global.login_id

Line 10997: l_ci_cost_version_id_tbl pa_budget_versions.budget_version_id%TYPE;

10993: l_debug_mode VARCHAR2(30);
10994: l_module_name VARCHAR2(100):='PAFPCIMB.validate_ci_merge_input_data';
10995: --End of variables used for debugging
10996: i NUMBER;
10997: l_ci_cost_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10998: l_ci_rev_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);

Line 10998: l_ci_rev_version_id_tbl pa_budget_versions.budget_version_id%TYPE;

10994: l_module_name VARCHAR2(100):='PAFPCIMB.validate_ci_merge_input_data';
10995: --End of variables used for debugging
10996: i NUMBER;
10997: l_ci_cost_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10998: l_ci_rev_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

Line 10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;

10995: --End of variables used for debugging
10996: i NUMBER;
10997: l_ci_cost_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10998: l_ci_rev_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;

Line 11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

10998: l_ci_rev_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
11004: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
11006: l_project_id pa_projects_all.project_id%TYPE;

Line 11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;

10999: l_ci_all_version_id_tbl pa_budget_versions.budget_version_id%TYPE;
11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
11004: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
11006: l_project_id pa_projects_all.project_id%TYPE;
11007: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 11004: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;

11000: l_out_index NUMBER;
11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
11004: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
11006: l_project_id pa_projects_all.project_id%TYPE;
11007: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
11008: l_calling_mode_for_chk_api VARCHAR2(30);

Line 11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;

11001: l_error_occurred_flag VARCHAR2(1);
11002: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
11003: l_ci_cost_version_id pa_budget_versions.budget_version_id%TYPE;
11004: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
11005: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
11006: l_project_id pa_projects_all.project_id%TYPE;
11007: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
11008: l_calling_mode_for_chk_api VARCHAR2(30);
11009: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

Line 11011: l_record_version_number pa_budget_versions.record_Version_number%TYPE;

11007: l_source_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
11008: l_calling_mode_for_chk_api VARCHAR2(30);
11009: l_merge_possible_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
11010: l_copy_ci_ver_flag VARCHAR2(1);
11011: l_record_version_number pa_budget_versions.record_Version_number%TYPE;
11012: l_cost_ci_ver_index NUMBER;
11013: l_rev_ci_ver_index NUMBER;
11014: l_all_ci_ver_index NUMBER;
11015: l_index NUMBER:=0;

Line 11036: CURSOR c_chk_rej_codes (ci_ci_ver_id1 pa_budget_versions.budget_version_id%TYPE,

11032: l_implemented_amount NUMBER;
11033: l_remaining_amount NUMBER;
11034: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
11035:
11036: CURSOR c_chk_rej_codes (ci_ci_ver_id1 pa_budget_versions.budget_version_id%TYPE,
11037: ci_ci_ver_id2 pa_budget_versions.budget_version_id%TYPE)
11038: IS
11039: SELECT 'Y'
11040: FROM DUAL

Line 11037: ci_ci_ver_id2 pa_budget_versions.budget_version_id%TYPE)

11033: l_remaining_amount NUMBER;
11034: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
11035:
11036: CURSOR c_chk_rej_codes (ci_ci_ver_id1 pa_budget_versions.budget_version_id%TYPE,
11037: ci_ci_ver_id2 pa_budget_versions.budget_version_id%TYPE)
11038: IS
11039: SELECT 'Y'
11040: FROM DUAL
11041: WHERE EXISTS (SELECT 1

Line 11057: l_version_type pa_budget_versions.version_type%TYPE;

11053: --different then the error status will be returned as E from the API. This will be done only when the p_context='CI_MERGE'
11054: l_init_msg_count NUMBER;
11055: l_msg_count_at_end NUMBER;
11056:
11057: l_version_type pa_budget_versions.version_type%TYPE;
11058: l_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
11059: l_fin_plan_type_name_tbl SYSTEM.pa_varchar2_150_tbl_type :=SYSTEM.pa_varchar2_150_tbl_type();
11060: l_part_impl_err VARCHAR2(1);
11061: l_ci_name VARCHAR2(300);

Line 11066: l_targ_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;

11062:
11063: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
11064:
11065: -- Bug 3986129: Added the following
11066: l_targ_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;
11067:
11068: BEGIN
11069: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
11070: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 11436: FROM pa_budget_versions

11432: -- Get the project id
11433:
11434: SELECT project_id
11435: INTO l_project_id
11436: FROM pa_budget_versions
11437: WHERE budget_version_id=p_budget_version_id_tbl(i);
11438:
11439:
11440: IF l_debug_mode = 'Y' THEN

Line 11638: FROM pa_budget_Versions

11634: nvl(l_ci_rev_version_id, l_ci_all_version_id) IS NOT NULL THEN
11635:
11636: SELECT agreement_id
11637: INTO x_agreement_id
11638: FROM pa_budget_Versions
11639: WHERE budget_Version_id=nvl(l_ci_rev_version_id, l_ci_all_version_id);
11640:
11641: END IF;
11642:

Line 11676: pa_budget_versions pbv

11672: fin.fin_plan_type_id
11673: INTO l_fin_plan_type_name,
11674: l_fin_plan_type_id
11675: FROM pa_fin_plan_types_vl fin,
11676: pa_budget_versions pbv
11677: WHERE fin.fin_plan_type_id=pbv.fin_plan_type_id
11678: AND pbv.budget_version_id=p_budget_version_id_tbl(i);
11679: ELSE
11680: l_fin_plan_type_name := p_fin_plan_type_name_tbl(i);

Line 11726: FROM pa_budget_versions pbv

11722: l_record_version_number,
11723: l_project_id,
11724: l_version_type,
11725: l_targ_ver_plan_prc_code -- for Bug 3986129
11726: FROM pa_budget_versions pbv
11727: WHERE pbv.budget_version_id=p_budget_version_id_tbl(i);
11728:
11729:
11730: IF l_budget_status_code ='S' THEN

Line 12244: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed

12240: * iv. Call is made to pa_fp_ci_merge.FP_CI_UPDATE_IMPACT.
12241: *--------------------------------------------------------------------------------------------------------*/
12242:
12243: PROCEDURE impl_ci_into_autobaseline_proj( p_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
12244: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
12245: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
12246: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12247: ,p_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
12248: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.

Line 12245: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented

12241: *--------------------------------------------------------------------------------------------------------*/
12242:
12243: PROCEDURE impl_ci_into_autobaseline_proj( p_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
12244: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
12245: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
12246: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12247: ,p_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
12248: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
12249: ,p_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N

Line 12296: l_new_cw_version_id pa_budget_versions.budget_version_id%TYPE;

12292: --Variable used for passing ci id to the change management baseline API.
12293: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
12294: X_Err_Code NUMBER;
12295:
12296: l_new_cw_version_id pa_budget_versions.budget_version_id%TYPE;
12297: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE;
12298: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12299: -- Variable to be used for calling FP_CI_LINK_CONTROL_ITEMS
12300: l_rev_ppl_quantity NUMBER;

Line 12297: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE;

12293: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
12294: X_Err_Code NUMBER;
12295:
12296: l_new_cw_version_id pa_budget_versions.budget_version_id%TYPE;
12297: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE;
12298: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12299: -- Variable to be used for calling FP_CI_LINK_CONTROL_ITEMS
12300: l_rev_ppl_quantity NUMBER;
12301: l_rev_equip_quantity NUMBER;

Line 12330: l_final_rev_par_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE;

12326: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12327: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
12328: l_ci_already_impl_flag VARCHAR2(1) := 'N';
12329:
12330: l_final_rev_par_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE;
12331: --Bug 4136238
12332: l_partial_impl_rev_amt pa_budget_lines.txn_revenue%TYPE;
12333:
12334: BEGIN

Line 12466: FROM pa_budget_versions pbv,

12462: l_impl_pc_revenue_bf_mg,
12463: l_project_id,
12464: l_project_currency_code,
12465: l_projfunc_currency_code
12466: FROM pa_budget_versions pbv,
12467: pa_projects_all p
12468: WHERE pbv.project_id = p.project_id
12469: AND pbv.budget_version_id = p_budget_version_id;
12470:

Line 12769: FROM pa_budget_versions

12765: l_rev_equip_quantity_af_mg,
12766: l_impl_pfc_revenue_af_mg,
12767: l_impl_pc_revenue_af_mg,
12768: l_final_rev_par_impl_flag
12769: FROM pa_budget_versions
12770: WHERE project_id = l_project_id
12771: AND budget_version_id = l_new_cw_version_id;
12772:
12773: IF l_debug_mode = 'Y' THEN

Line 12949: UPDATE pa_budget_versions

12945: IF l_debug_mode = 'Y' THEN
12946: pa_debug.g_err_stage:='Setting rev_impl_flag to N after autobaseline call';
12947: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12948: END IF;
12949: UPDATE pa_budget_versions
12950: SET rev_partially_impl_flag ='N'
12951: ,record_version_number = record_version_number+1
12952: ,last_update_date = sysdate
12953: ,last_update_login = fnd_global.login_id

Line 12967: UPDATE pa_budget_versions

12963: IF l_debug_mode = 'Y' THEN
12964: pa_debug.g_err_stage:='Setting rev_impl_flag to Y after autobaseline call';
12965: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12966: END IF;
12967: UPDATE pa_budget_versions
12968: SET rev_partially_impl_flag ='Y'
12969: ,record_version_number = record_version_number+1
12970: ,last_update_date = sysdate
12971: ,last_update_login = fnd_global.login_id

Line 13118: l_cost_ci_version_id pa_budget_Versions.budget_version_id%TYPE;

13114: l_ci_number_collection VARCHAR2(2000);
13115: l_partial_impl_succeeded VARCHAR2(1);
13116: l_ci_bv_merge_possible_map_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
13117: l_index NUMBER;
13118: l_cost_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13119: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13120: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13121: l_budget_ci_map_rec_tbl budget_ci_map_rec_tbl_type;
13122: l_impl_impact_type_code VARCHAR2(10);

Line 13119: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;

13115: l_partial_impl_succeeded VARCHAR2(1);
13116: l_ci_bv_merge_possible_map_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
13117: l_index NUMBER;
13118: l_cost_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13119: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13120: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13121: l_budget_ci_map_rec_tbl budget_ci_map_rec_tbl_type;
13122: l_impl_impact_type_code VARCHAR2(10);
13123: l_agreement_id pa_agreements_all.agreement_id%TYPE;

Line 13120: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;

13116: l_ci_bv_merge_possible_map_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
13117: l_index NUMBER;
13118: l_cost_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13119: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13120: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13121: l_budget_ci_map_rec_tbl budget_ci_map_rec_tbl_type;
13122: l_impl_impact_type_code VARCHAR2(10);
13123: l_agreement_id pa_agreements_all.agreement_id%TYPE;
13124: l_funding_category VARCHAR2(30);

Line 13378: pa_budget_versions bv

13374: INTO l_targ_app_cost_flag,
13375: l_targ_app_rev_flag,
13376: l_baseline_funding_flag
13377: FROM pa_projects_all pj,
13378: pa_budget_versions bv
13379: WHERE bv.budget_version_id = l_budget_version_id_tbl(j)
13380: AND bv.project_id = pj.project_id;
13381: EXCEPTION
13382: WHEN OTHERS THEN