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

Line 22: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

18: PROCEDURE pa_fp_viewplan_hgrid_init
19: ( p_user_id IN NUMBER,
20: p_orgfcst_version_id IN NUMBER,
21: p_period_start_date IN VARCHAR2,
22: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
23: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
24: px_display_quantity IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
25: px_display_rawcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: px_display_burdcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 23: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

19: ( p_user_id IN NUMBER,
20: p_orgfcst_version_id IN NUMBER,
21: p_period_start_date IN VARCHAR2,
22: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
23: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
24: px_display_quantity IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
25: px_display_rawcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: px_display_burdcost IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27: px_display_revenue IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 41: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

37: x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38: x_cost_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39: x_rev_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
42: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
43: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
44: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
45: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 42: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

38: x_cost_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39: x_rev_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
42: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
43: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
44: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
45: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 43: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

39: x_rev_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
42: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
43: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
44: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
45: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47: x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 53: -- x_primary_pp_bv_id OUT pa_budget_versions.budget_version_id%TYPE,

49: x_refresh_pd_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_cost_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
51: x_rev_rv_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
52: x_time_phase_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: -- x_primary_pp_bv_id OUT pa_budget_versions.budget_version_id%TYPE,
54: x_in_period_profile OUT NOCOPY VARCHAR2, -- 'B' for before, 'A' for after --File.Sql.39 bug 4440895
55: x_prec_pds_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56: x_succ_pds_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57: x_refresh_req_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 86: l_cost_version_number pa_budget_versions.version_number%TYPE;

82: l_num_of_periods NUMBER;
83: l_project_id NUMBER;
84: l_org_id NUMBER;
85: l_cost_or_revenue VARCHAR2(1);
86: l_cost_version_number pa_budget_versions.version_number%TYPE;
87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 87: l_rev_version_number pa_budget_versions.version_number%TYPE;

83: l_project_id NUMBER;
84: l_org_id NUMBER;
85: l_cost_or_revenue VARCHAR2(1);
86: l_cost_version_number pa_budget_versions.version_number%TYPE;
87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 88: l_cost_version_name pa_budget_versions.version_name%TYPE;

84: l_org_id NUMBER;
85: l_cost_or_revenue VARCHAR2(1);
86: l_cost_version_number pa_budget_versions.version_number%TYPE;
87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 89: l_rev_version_name pa_budget_versions.version_name%TYPE;

85: l_cost_or_revenue VARCHAR2(1);
86: l_cost_version_number pa_budget_versions.version_number%TYPE;
87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

86: l_cost_version_number pa_budget_versions.version_number%TYPE;
87: l_rev_version_number pa_budget_versions.version_number%TYPE;
88: l_cost_version_name pa_budget_versions.version_name%TYPE;
89: l_rev_version_name pa_budget_versions.version_name%TYPE;
90: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
91: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
92: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
93: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
94: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 122: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;

118: l_cur_period_start_date DATE;
119: l_cur_period_end_date DATE;
120:
121: -- other variables for Period Profile info
122: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
123: l_plan_processing_code2 pa_budget_versions.plan_processing_code%TYPE;
124: l_request_id pa_budget_versions.request_id%TYPE;
125:
126: -- variables for default settings

Line 123: l_plan_processing_code2 pa_budget_versions.plan_processing_code%TYPE;

119: l_cur_period_end_date DATE;
120:
121: -- other variables for Period Profile info
122: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
123: l_plan_processing_code2 pa_budget_versions.plan_processing_code%TYPE;
124: l_request_id pa_budget_versions.request_id%TYPE;
125:
126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 124: l_request_id pa_budget_versions.request_id%TYPE;

120:
121: -- other variables for Period Profile info
122: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
123: l_plan_processing_code2 pa_budget_versions.plan_processing_code%TYPE;
124: l_request_id pa_budget_versions.request_id%TYPE;
125:
126: -- variables for default settings
127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 131: l_version_type pa_budget_versions.version_type%TYPE;

127: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
128: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
129: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevsep
130: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE; --for costandrevtog
131: l_version_type pa_budget_versions.version_type%TYPE;
132: l_display_quantity VARCHAR2(1);
133: l_display_rawcost VARCHAR2(1);
134: l_display_burdcost VARCHAR2(1);
135: l_display_revenue VARCHAR2(1);

Line 176: from pa_budget_versions bv,

172: 'PROJFUNC', pa.projfunc_currency_code,
173: 'TXN')
174: into l_project_id,
175: l_projfunc_currency_code
176: from pa_budget_versions bv,
177: pa_projects_all pa
178: where bv.budget_version_id = p_orgfcst_version_id and
179: bv.project_id = pa.project_id;
180: select nvl(org_id,-99)

Line 272: from pa_budget_versions bv,

268: l_all_amount_set_id,
269: l_version_type,
270: -- x_factor_by_code,
271: l_plan_pref_code
272: from pa_budget_versions bv,
273: pa_proj_fp_options po
274: where bv.budget_version_id = p_orgfcst_version_id and
275: bv.fin_plan_type_id = po.fin_plan_type_id and
276: po.project_id = l_project_id and

Line 431: from pa_budget_versions

427: null),
428: nvl(approved_rev_plan_type_flag, 'N')
429: into l_cost_or_revenue,
430: x_ar_flag -- OUTPUT: x_ar_flag
431: from pa_budget_versions
432: where budget_version_id = p_orgfcst_version_id;
433: end if;
434: -- END OF USER CUSTOMIZATIONS (ADVANCED DISPLAY OPTIONS)
435: pa_fp_view_plans_pub.G_DEFAULT_AMOUNT_TYPE_CODE := l_default_amount_type_code;

Line 456: pa_budget_versions pbv

452: into ll_plan_period_type,
453: pp_plan_start_date,
454: l_period_profile_id
455: from pa_proj_period_profiles pp,
456: pa_budget_versions pbv
457: where pbv.budget_version_id = p_orgfcst_version_id
458: and pbv.period_profile_id = pp.period_profile_id;
459: Ends commented for 7514054 and added below code
460: */

Line 540: pa_budget_versions where budget_version_id = p_orgfcst_version_id);

536: into ll_plan_start_date, ll_plan_end_date
537: from pa_budget_lines
538: where resource_assignment_id in (select
539: resource_assignment_id from
540: pa_budget_versions where budget_version_id = p_orgfcst_version_id);
541: */
542:
543: select min(start_date), max(end_date)
544: into ll_plan_start_date, ll_plan_end_date

Line 717: FROM pa_budget_versions bv,

713: -- For uncategorized resource lists there is no need to store data against the resource list member ids coz
714: -- they are dummy ids for internal tracking and this is causing showing of data in twice at lowest level.
715: SELECT NVL(rl.uncategorized_flag, 'N')
716: INTO l_uncategorized_flag
717: FROM pa_budget_versions bv,
718: pa_resource_lists_all_bg rl
719: WHERE bv.budget_version_id = p_orgfcst_version_id AND
720: bv.resource_list_id = rl.resource_list_id;
721:

Line 768: from pa_budget_versions

764: select plan_processing_code,
765: request_id
766: into l_plan_processing_code,
767: l_request_id
768: from pa_budget_versions
769: where budget_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
770: if l_plan_processing_code = 'PPP' then
771: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
772: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 790: from pa_budget_versions

786: select plan_processing_code,
787: request_id
788: into l_plan_processing_code,
789: l_request_id
790: from pa_budget_versions
791: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
792: if l_plan_processing_code = 'PPP' then
793: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
794: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 812: from pa_budget_versions

808: select plan_processing_code,
809: request_id
810: into l_plan_processing_code,
811: l_request_id
812: from pa_budget_versions
813: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
814: if l_plan_processing_code = 'PPP' then
815: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
816: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 871: from pa_budget_versions

867: select plan_processing_code,
868: request_id
869: into l_plan_processing_code,
870: l_request_id
871: from pa_budget_versions
872: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
873: if l_request_id is not null then
874: x_refresh_req_id := l_request_id;
875: end if;

Line 880: from pa_budget_versions

876: select plan_processing_code,
877: request_id
878: into l_plan_processing_code2,
879: l_request_id
880: from pa_budget_versions
881: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
882: if l_request_id is not null then
883: x_refresh_req_id := l_request_id;
884: end if;

Line 956: from pa_budget_versions

952: select record_version_number, -- OUTPUT: x_cost_rv_number
953: budget_status_code -- OUTPUT: x_cost_budget_status_code
954: into x_cost_rv_number,
955: x_cost_budget_status_code
956: from pa_budget_versions
957: --4/16/03 where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
958: where budget_version_id = x_cost_bv_id;
959: pa_fin_plan_utils.Check_Locked_By_User
960: (p_user_id => p_user_id,

Line 987: from pa_budget_versions

983: select record_version_number, -- OUTPUT: x_rev_rv_number
984: budget_status_code -- OUTPUT: x_rev_budget_status_code
985: into x_rev_rv_number,
986: x_rev_budget_status_code
987: from pa_budget_versions
988: -- where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
989: where budget_version_id = x_revenue_bv_id;
990: pa_fin_plan_utils.Check_Locked_By_User
991: (p_user_id => p_user_id,

Line 1035: (p_project_id IN pa_budget_versions.project_id%TYPE,

1031: END pa_fp_viewplan_hgrid_init;
1032: /* ------------------------------------------------------------------------- */
1033:
1034: PROCEDURE pa_fp_viewplan_hgrid_init_ci
1035: (p_project_id IN pa_budget_versions.project_id%TYPE,
1036: p_ci_id IN pa_budget_versions.ci_id%TYPE,
1037: p_user_id IN NUMBER,
1038: p_period_start_date IN VARCHAR2,
1039: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 1036: p_ci_id IN pa_budget_versions.ci_id%TYPE,

1032: /* ------------------------------------------------------------------------- */
1033:
1034: PROCEDURE pa_fp_viewplan_hgrid_init_ci
1035: (p_project_id IN pa_budget_versions.project_id%TYPE,
1036: p_ci_id IN pa_budget_versions.ci_id%TYPE,
1037: p_user_id IN NUMBER,
1038: p_period_start_date IN VARCHAR2,
1039: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1040: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 1039: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

1035: (p_project_id IN pa_budget_versions.project_id%TYPE,
1036: p_ci_id IN pa_budget_versions.ci_id%TYPE,
1037: p_user_id IN NUMBER,
1038: p_period_start_date IN VARCHAR2,
1039: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1040: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
1041: p_display_quantity IN VARCHAR2,
1042: p_display_rawcost IN VARCHAR2,
1043: p_display_burdcost IN VARCHAR2,

Line 1040: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

1036: p_ci_id IN pa_budget_versions.ci_id%TYPE,
1037: p_user_id IN NUMBER,
1038: p_period_start_date IN VARCHAR2,
1039: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1040: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
1041: p_display_quantity IN VARCHAR2,
1042: p_display_rawcost IN VARCHAR2,
1043: p_display_burdcost IN VARCHAR2,
1044: p_display_revenue IN VARCHAR2,

Line 1057: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

1053: x_plan_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1054: x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1055: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1056: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1057: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1058: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1059: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
1060: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
1061: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1058: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

1054: x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1055: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1056: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1057: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1058: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1059: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
1060: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
1061: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1062: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1059: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

1055: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1056: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1057: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1058: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1059: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
1060: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
1061: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1062: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1063: x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1095: l_cost_version_number pa_budget_versions.version_number%TYPE;

1091: l_num_of_periods NUMBER;
1092: l_project_id NUMBER;
1093: l_org_id NUMBER;
1094: l_cost_or_revenue VARCHAR2(1);
1095: l_cost_version_number pa_budget_versions.version_number%TYPE;
1096: l_rev_version_number pa_budget_versions.version_number%TYPE;
1097: l_cost_version_name pa_budget_versions.version_name%TYPE;
1098: l_rev_version_name pa_budget_versions.version_name%TYPE;
1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 1096: l_rev_version_number pa_budget_versions.version_number%TYPE;

1092: l_project_id NUMBER;
1093: l_org_id NUMBER;
1094: l_cost_or_revenue VARCHAR2(1);
1095: l_cost_version_number pa_budget_versions.version_number%TYPE;
1096: l_rev_version_number pa_budget_versions.version_number%TYPE;
1097: l_cost_version_name pa_budget_versions.version_name%TYPE;
1098: l_rev_version_name pa_budget_versions.version_name%TYPE;
1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1100: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 1097: l_cost_version_name pa_budget_versions.version_name%TYPE;

1093: l_org_id NUMBER;
1094: l_cost_or_revenue VARCHAR2(1);
1095: l_cost_version_number pa_budget_versions.version_number%TYPE;
1096: l_rev_version_number pa_budget_versions.version_number%TYPE;
1097: l_cost_version_name pa_budget_versions.version_name%TYPE;
1098: l_rev_version_name pa_budget_versions.version_name%TYPE;
1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1100: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1101: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 1098: l_rev_version_name pa_budget_versions.version_name%TYPE;

1094: l_cost_or_revenue VARCHAR2(1);
1095: l_cost_version_number pa_budget_versions.version_number%TYPE;
1096: l_rev_version_number pa_budget_versions.version_number%TYPE;
1097: l_cost_version_name pa_budget_versions.version_name%TYPE;
1098: l_rev_version_name pa_budget_versions.version_name%TYPE;
1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1100: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1101: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1102: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

1095: l_cost_version_number pa_budget_versions.version_number%TYPE;
1096: l_rev_version_number pa_budget_versions.version_number%TYPE;
1097: l_cost_version_name pa_budget_versions.version_name%TYPE;
1098: l_rev_version_name pa_budget_versions.version_name%TYPE;
1099: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1100: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1101: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1102: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1103: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 1128: l_version_type pa_budget_versions.version_type%TYPE;

1124: l_cur_end_period VARCHAR2(30);
1125:
1126: -- variables for default settings
1127: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1128: l_version_type pa_budget_versions.version_type%TYPE;
1129: l_display_quantity VARCHAR2(1);
1130: l_display_rawcost VARCHAR2(1);
1131: l_display_burdcost VARCHAR2(1);
1132: l_display_revenue VARCHAR2(1);

Line 1138: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

1134: l_display_marginpct VARCHAR2(1);
1135:
1136: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1137: l_working_or_baselined VARCHAR2(30);
1138: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
1139: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
1140:
1141: cursor ci_csr is
1142: select bv.budget_version_id,

Line 1139: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

1135:
1136: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1137: l_working_or_baselined VARCHAR2(30);
1138: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
1139: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
1140:
1141: cursor ci_csr is
1142: select bv.budget_version_id,
1143: po.proj_fp_options_id,

Line 1145: from pa_budget_versions bv,

1141: cursor ci_csr is
1142: select bv.budget_version_id,
1143: po.proj_fp_options_id,
1144: NVL(po.plan_in_multi_curr_flag, 'N') as plan_in_multi_curr_flag
1145: from pa_budget_versions bv,
1146: pa_proj_fp_options po
1147: where bv.project_id = p_project_id and
1148: bv.ci_id = p_ci_id and
1149: bv.budget_version_id = po.fin_plan_version_id and

Line 1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

1157: l_grouping_type VARCHAR2(30);
1158: l_compl_grouping_type VARCHAR2(30);
1159: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1160: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;

1158: l_compl_grouping_type VARCHAR2(30);
1159: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1160: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 1163: l_rv_number pa_budget_versions.record_version_number%TYPE;

1159: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1160: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1167:

Line 1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

1160: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1167:
1168: l_is_cost_locked_by_user VARCHAR2(1);

Line 1174: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1170: l_cost_locked_by_person_id NUMBER;
1171: l_rev_locked_by_person_id NUMBER;
1172:
1173: l_ci_row_index NUMBER := 0;
1174: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1175:
1176: -- uncategorized list info
1177: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1178: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

Line 1254: from pa_budget_versions bv,

1250: l_rv_number,
1251: l_ac_flag,
1252: l_ar_flag,
1253: l_uncategorized_flag
1254: from pa_budget_versions bv,
1255: pa_resource_lists_all_bg rl
1256: where bv.budget_version_id = ci_rec.budget_version_id and
1257: bv.resource_list_id = rl.resource_list_id;
1258:

Line 1386: from pa_budget_versions bv,

1382: into l_compl_grouping_type,
1383: l_compl_resource_list_id,
1384: l_compl_rv_number,
1385: l_compl_uncategorized_flag
1386: from pa_budget_versions bv,
1387: pa_resource_lists_all_bg rl
1388: where bv.budget_version_id = ci_rec.budget_version_id and
1389: bv.resource_list_id = rl.resource_list_id;
1390: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;

Line 1448: from pa_budget_versions bv,

1444: into l_compl_grouping_type,
1445: l_compl_resource_list_id,
1446: l_compl_rv_number,
1447: l_compl_uncategorized_flag
1448: from pa_budget_versions bv,
1449: pa_resource_lists_all_bg rl
1450: where bv.budget_version_id = ci_rec.budget_version_id and
1451: bv.resource_list_id = rl.resource_list_id;
1452: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;

Line 1511: from pa_budget_versions bv,

1507: into l_compl_grouping_type,
1508: l_compl_resource_list_id,
1509: l_compl_rv_number,
1510: l_compl_uncategorized_flag
1511: from pa_budget_versions bv,
1512: pa_resource_lists_all_bg rl
1513: where bv.budget_version_id = ci_rec.budget_version_id and
1514: bv.resource_list_id = rl.resource_list_id;
1515: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;

Line 1573: from pa_budget_versions bv,

1569: into l_compl_grouping_type,
1570: l_compl_resource_list_id,
1571: l_compl_rv_number,
1572: l_compl_uncategorized_flag
1573: from pa_budget_versions bv,
1574: pa_resource_lists_all_bg rl
1575: where bv.budget_version_id = ci_rec.budget_version_id and
1576: bv.resource_list_id = rl.resource_list_id;
1577: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;

Line 1638: from pa_budget_versions bv,

1634: 'PROJFUNC', pa.projfunc_currency_code,
1635: 'TXN')
1636: into l_project_id,
1637: l_projfunc_currency_code
1638: from pa_budget_versions bv,
1639: pa_projects_all pa
1640: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1641: bv.project_id = pa.project_id;
1642: select nvl(org_id,-99)

Line 1716: from pa_budget_versions bv,

1712: po.factor_by_code
1713: into l_amount_set_id,
1714: l_version_type,
1715: x_factor_by_code -- OUTPUT: x_factor_by_code
1716: from pa_budget_versions bv,
1717: pa_proj_fp_options po
1718: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1719: bv.fin_plan_type_id = po.fin_plan_type_id and
1720: po.project_id = l_project_id and

Line 1808: from pa_budget_versions

1804: nvl(approved_rev_plan_type_flag, 'N')
1805: into l_cost_or_revenue,
1806: x_budget_status_code, -- OUTPUT: x_budget_status_code
1807: x_ar_flag -- OUTPUT: x_ar_flag
1808: from pa_budget_versions
1809: where budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID;
1810: end if;
1811: -- END OF USER CUSTOMIZATIONS (ADVANCED DISPLAY OPTIONS)
1812: pa_fp_view_plans_pub.G_DEFAULT_AMOUNT_TYPE_CODE := l_default_amount_type_code;

Line 1827: pa_budget_versions pbv

1823: into ll_plan_period_type,
1824: pp_plan_start_date,
1825: l_period_profile_id
1826: from pa_proj_period_profiles pp,
1827: pa_budget_versions pbv
1828: where pbv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID
1829: and pp.period_profile_id = pbv.period_profile_id;
1830: Ends commented for 7514054 and added below code
1831: */

Line 2066: from pa_budget_versions

2062: select record_version_number, -- OUTPUT: x_cost_rv_number
2063: budget_status_code -- OUTPUT: x_budget_status_code
2064: into x_cost_rv_number,
2065: x_budget_status_code
2066: from pa_budget_versions
2067: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2068: pa_fin_plan_utils.Check_Locked_By_User
2069: (p_user_id => p_user_id,
2070: p_budget_version_id => pa_fp_view_plans_pub.G_FP_COST_VERSION_ID,

Line 2094: from pa_budget_versions

2090: select record_version_number, -- OUTPUT: x_rev_rv_number
2091: budget_status_code -- OUTPUT: x_budget_status_code
2092: into x_rev_rv_number,
2093: x_budget_status_code
2094: from pa_budget_versions
2095: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2096: pa_fin_plan_utils.Check_Locked_By_User
2097: (p_user_id => p_user_id,
2098: p_budget_version_id => pa_fp_view_plans_pub.G_FP_REV_VERSION_ID,

Line 2690: (p_project_id IN pa_budget_versions.project_id%TYPE,

2686: -- pa_fp_vp_pop_tables_separate
2687: -- ELSE pa_fp_vp_pop_tables_single using the single BV
2688: -- 11/22/02: out parameter: x_diff_pd_profile_flag -> 'Y' when don't match
2689: procedure view_plan_temp_tables
2690: (p_project_id IN pa_budget_versions.project_id%TYPE,
2691: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2692: p_cost_or_revenue IN VARCHAR2,
2693: p_user_bv_flag IN VARCHAR2,
2694: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2691: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

2687: -- ELSE pa_fp_vp_pop_tables_single using the single BV
2688: -- 11/22/02: out parameter: x_diff_pd_profile_flag -> 'Y' when don't match
2689: procedure view_plan_temp_tables
2690: (p_project_id IN pa_budget_versions.project_id%TYPE,
2691: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2692: p_cost_or_revenue IN VARCHAR2,
2693: p_user_bv_flag IN VARCHAR2,
2694: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2695: x_rev_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2705: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

2701: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2702: )
2703: as
2704:
2705: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
2706:
2707: cursor l_ra_csr is
2708: select * from pa_resource_assignments where budget_version_id=p_budget_version_id;
2709: l_ra_rec l_ra_csr%ROWTYPE;

Line 2719: pa_budget_versions bv

2715: cursor l_compl_c_w_csr is
2716: select bv.budget_version_id,
2717: po.proj_fp_options_id
2718: from pa_proj_fp_options po,
2719: pa_budget_versions bv
2720: where po.project_id = p_project_id and
2721: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2722: po.fin_plan_preference_code = 'REVENUE_ONLY' and
2723: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2732: pa_budget_versions bv

2728: cursor l_compl_c_b_csr is
2729: select bv.budget_version_id,
2730: po.proj_fp_options_id
2731: from pa_proj_fp_options po,
2732: pa_budget_versions bv
2733: where po.project_id = p_project_id and
2734: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2735: po.fin_plan_preference_code = 'REVENUE_ONLY' and
2736: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2745: pa_budget_versions bv

2741: cursor l_compl_r_w_csr is
2742: select bv.budget_version_id,
2743: po.proj_fp_options_id
2744: from pa_proj_fp_options po,
2745: pa_budget_versions bv
2746: where po.project_id = p_project_id and
2747: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2748: po.fin_plan_preference_code = 'COST_ONLY' and
2749: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2758: pa_budget_versions bv

2754: cursor l_compl_r_b_csr is
2755: select bv.budget_version_id,
2756: po.proj_fp_options_id
2757: from pa_proj_fp_options po,
2758: pa_budget_versions bv
2759: where po.project_id = p_project_id and
2760: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2761: po.fin_plan_preference_code = 'COST_ONLY' and
2762: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2771: pa_budget_versions bv

2767: cursor l_compl_crsep_c_w_csr is
2768: select bv.budget_version_id,
2769: po.proj_fp_options_id
2770: from pa_proj_fp_options po,
2771: pa_budget_versions bv
2772: where po.project_id = p_project_id and
2773: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2774: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2775: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2785: pa_budget_versions bv

2781: cursor l_compl_crsep_r_w_csr is
2782: select bv.budget_version_id,
2783: po.proj_fp_options_id
2784: from pa_proj_fp_options po,
2785: pa_budget_versions bv
2786: where po.project_id = p_project_id and
2787: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2788: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2789: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2802: pa_budget_versions bv

2798: cursor l_compl_crsep_c_b_csr is
2799: select bv.budget_version_id,
2800: po.proj_fp_options_id
2801: from pa_proj_fp_options po,
2802: pa_budget_versions bv
2803: where po.project_id = p_project_id and
2804: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2805: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2806: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2816: pa_budget_versions bv

2812: cursor l_compl_crsep_r_b_csr is
2813: select bv.budget_version_id,
2814: po.proj_fp_options_id
2815: from pa_proj_fp_options po,
2816: pa_budget_versions bv
2817: where po.project_id = p_project_id and
2818: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2819: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2820: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2828: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2824: l_compl_crsep_r_b_rec l_compl_crsep_r_b_csr%ROWTYPE;
2825:
2826: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2827: l_working_or_baselined VARCHAR2(1);
2828: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2829: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2830: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;

Line 2833: l_cost_version_number pa_budget_versions.version_number%TYPE;

2829: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2830: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2836: l_rev_version_name pa_budget_versions.version_name%TYPE;
2837: l_diff_pd_profile_flag VARCHAR2(1);

Line 2834: l_rev_version_number pa_budget_versions.version_number%TYPE;

2830: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2836: l_rev_version_name pa_budget_versions.version_name%TYPE;
2837: l_diff_pd_profile_flag VARCHAR2(1);
2838:

Line 2835: l_cost_version_name pa_budget_versions.version_name%TYPE;

2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2836: l_rev_version_name pa_budget_versions.version_name%TYPE;
2837: l_diff_pd_profile_flag VARCHAR2(1);
2838:
2839: -- values used to populate temp table

Line 2836: l_rev_version_name pa_budget_versions.version_name%TYPE;

2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2836: l_rev_version_name pa_budget_versions.version_name%TYPE;
2837: l_diff_pd_profile_flag VARCHAR2(1);
2838:
2839: -- values used to populate temp table
2840: l_element_name VARCHAR2(1000);

Line 2843: l_primary_bvid pa_budget_versions.budget_version_id%TYPE;

2839: -- values used to populate temp table
2840: l_element_name VARCHAR2(1000);
2841:
2842: -- for Advanced Display Options customization
2843: l_primary_bvid pa_budget_versions.budget_version_id%TYPE;
2844:
2845: -- error handling variables
2846: l_return_status VARCHAR2(1);
2847: l_msg_count NUMBER;

Line 2876: --hr_utility.trace('selecting from pa_budget_versions');

2872: --hr_utility.trace('allversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID));
2873: --hr_utility.trace('COSTversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID));
2874: --hr_utility.trace('REVversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID));
2875:
2876: --hr_utility.trace('selecting from pa_budget_versions');
2877: select DECODE(budget_status_code,
2878: 'B', 'B',
2879: 'W'),
2880: fin_plan_type_id

Line 2883: from pa_budget_versions

2879: 'W'),
2880: fin_plan_type_id
2881: into l_working_or_baselined,
2882: l_fin_plan_type_id
2883: from pa_budget_versions
2884: where budget_version_id = p_budget_version_id;
2885: -- retrieve fin_plan_preference_code from PLAN_TYPE record
2886: select fin_plan_preference_code
2887: into l_fp_preference_code

Line 2908: from pa_budget_versions

2904: select version_name,
2905: version_number
2906: into l_cost_version_name,
2907: l_cost_version_number
2908: from pa_budget_versions
2909: where budget_version_id = p_budget_version_id;
2910: l_rev_version_name := l_cost_version_name;
2911: l_rev_version_number := l_cost_version_number;
2912: pa_fp_view_plans_pub.G_FP_ALL_VERSION_NAME := l_cost_version_name;

Line 2928: from pa_budget_versions

2924: select version_number,
2925: version_name
2926: into l_cost_version_number,
2927: l_cost_version_name
2928: from pa_budget_versions
2929: where budget_version_id = p_budget_version_id;
2930: l_rev_version_number := null;
2931: l_rev_version_name := ' ';
2932: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;

Line 2949: from pa_budget_versions

2945: select version_number,
2946: version_name
2947: into l_rev_version_number,
2948: l_rev_version_name
2949: from pa_budget_versions
2950: where budget_version_id = p_budget_version_id;
2951: l_cost_version_number := null;
2952: l_cost_version_name := ' ';
2953: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

Line 2971: from pa_budget_versions

2967:
2968: -- BEFORE MERGING, MAKE SURE PERIOD PROFILES MATCH
2969: select period_profile_id
2970: into l_period_profile_id1
2971: from pa_budget_versions
2972: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2973: select period_profile_id
2974: into l_period_profile_id2
2975: from pa_budget_versions

Line 2975: from pa_budget_versions

2971: from pa_budget_versions
2972: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2973: select period_profile_id
2974: into l_period_profile_id2
2975: from pa_budget_versions
2976: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2977: --hr_utility.trace('retrieved the period profile ids');
2978: if (pa_fp_view_plans_util.check_compatible_pd_profiles
2979: (p_period_profile_id1 => l_period_profile_id1,

Line 2989: from pa_budget_versions

2985: select version_number,
2986: version_name
2987: into l_cost_version_number,
2988: l_cost_version_name
2989: from pa_budget_versions
2990: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2991: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
2992: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;
2993: select version_number,

Line 2997: from pa_budget_versions

2993: select version_number,
2994: version_name
2995: into l_rev_version_number,
2996: l_rev_version_name
2997: from pa_budget_versions
2998: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2999: pa_fp_view_plans_pub.G_FP_REV_VERSION_NUMBER := l_rev_version_number;
3000: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;
3001: --hr_utility.trace('entering pa_fp_vp_pop_tables_separate');

Line 3019: from pa_budget_versions

3015: select version_number,
3016: version_name
3017: into l_cost_version_number,
3018: l_cost_version_name
3019: from pa_budget_versions
3020: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
3021: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3022: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;
3023: select version_number,

Line 3027: from pa_budget_versions

3023: select version_number,
3024: version_name
3025: into l_rev_version_number,
3026: l_rev_version_name
3027: from pa_budget_versions
3028: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
3029: pa_fp_view_plans_pub.G_FP_REV_VERSION_NUMBER := l_rev_version_number;
3030: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;
3031: pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate

Line 3046: from pa_budget_versions

3042: select version_number,
3043: version_name
3044: into l_cost_version_number,
3045: l_cost_version_name
3046: from pa_budget_versions
3047: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
3048: l_rev_version_number := null;
3049: l_rev_version_name := ' ';
3050: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3066: from pa_budget_versions

3062: select version_number,
3063: version_name
3064: into l_rev_version_number,
3065: l_rev_version_name
3066: from pa_budget_versions
3067: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
3068: l_cost_version_number := null;
3069: l_cost_version_name := ' ';
3070: pa_fp_view_plans_pub.G_FP_REV_VERSION_NUMBER := l_rev_version_number;

Line 3093: from pa_budget_versions

3089: 'W'),
3090: fin_plan_type_id
3091: into l_working_or_baselined,
3092: l_fin_plan_type_id
3093: from pa_budget_versions
3094: where budget_version_id = p_budget_version_id;
3095: -- retrieve fin_plan_preference_code from PLAN_TYPE record
3096: select fin_plan_preference_code
3097: into l_fp_preference_code

Line 3113: from pa_budget_versions

3109: select version_name,
3110: version_number
3111: into l_cost_version_name,
3112: l_cost_version_number
3113: from pa_budget_versions
3114: where budget_version_id = p_budget_version_id;
3115: l_rev_version_name := l_cost_version_name;
3116: l_rev_version_number := l_cost_version_number;
3117: pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID := p_budget_version_id;

Line 3137: from pa_budget_versions

3133: select version_number,
3134: version_name
3135: into l_cost_version_number,
3136: l_cost_version_name
3137: from pa_budget_versions
3138: where budget_version_id = p_budget_version_id;
3139: l_rev_version_number := null;
3140: l_rev_version_name := ' ';
3141: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3160: from pa_budget_versions

3156: select version_number,
3157: version_name
3158: into l_rev_version_number,
3159: l_rev_version_name
3160: from pa_budget_versions
3161: where budget_version_id = p_budget_version_id;
3162: l_cost_version_number := null;
3163: l_cost_version_name := ' ';
3164: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3208: from pa_budget_versions

3204: select version_number,
3205: version_name
3206: into l_cost_version_number,
3207: l_cost_version_name
3208: from pa_budget_versions
3209: where budget_version_id = p_budget_version_id;
3210: l_rev_version_number := null;
3211: l_rev_version_name := ' ';
3212: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3226: from pa_budget_versions

3222: else
3223: -- found a compl for the COST version: merge only if period profiles are compatible
3224: select period_profile_id
3225: into l_period_profile_id1
3226: from pa_budget_versions
3227: where budget_version_id = p_budget_version_id;
3228: select period_profile_id
3229: into l_period_profile_id2
3230: from pa_budget_versions

Line 3230: from pa_budget_versions

3226: from pa_budget_versions
3227: where budget_version_id = p_budget_version_id;
3228: select period_profile_id
3229: into l_period_profile_id2
3230: from pa_budget_versions
3231: where budget_version_id = l_compl_budget_version_id;
3232: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3233: (p_period_profile_id1 => l_period_profile_id1,
3234: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3244: from pa_budget_versions

3240: select version_number,
3241: version_name
3242: into l_cost_version_number,
3243: l_cost_version_name
3244: from pa_budget_versions
3245: where budget_version_id = p_budget_version_id;
3246: select version_number,
3247: version_name
3248: into l_rev_version_number,

Line 3250: from pa_budget_versions

3246: select version_number,
3247: version_name
3248: into l_rev_version_number,
3249: l_rev_version_name
3250: from pa_budget_versions
3251: where budget_version_id = l_compl_budget_version_id;
3252: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;
3253: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3254: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3276: from pa_budget_versions

3272: select version_number,
3273: version_name
3274: into l_cost_version_number,
3275: l_cost_version_name
3276: from pa_budget_versions
3277: where budget_version_id = p_budget_version_id;
3278: l_rev_version_number := null;
3279: l_rev_version_name := ' ';
3280: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3298: from pa_budget_versions

3294: select version_number,
3295: version_name
3296: into l_cost_version_number,
3297: l_cost_version_name
3298: from pa_budget_versions
3299: where budget_version_id = p_budget_version_id;
3300: l_rev_version_number := null;
3301: l_rev_version_name := ' ';
3302: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3337: from pa_budget_versions

3333: select version_number,
3334: version_name
3335: into l_rev_version_number,
3336: l_rev_version_name
3337: from pa_budget_versions
3338: where budget_version_id = p_budget_version_id;
3339: l_cost_version_number := null;
3340: l_cost_version_name := ' ';
3341: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3355: from pa_budget_versions

3351: else
3352: -- found a compl for the REVENUE version; merge only if period profiles are compatible
3353: select period_profile_id
3354: into l_period_profile_id1
3355: from pa_budget_versions
3356: where budget_version_id = p_budget_version_id;
3357: select period_profile_id
3358: into l_period_profile_id2
3359: from pa_budget_versions

Line 3359: from pa_budget_versions

3355: from pa_budget_versions
3356: where budget_version_id = p_budget_version_id;
3357: select period_profile_id
3358: into l_period_profile_id2
3359: from pa_budget_versions
3360: where budget_version_id = l_compl_budget_version_id;
3361: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3362: (p_period_profile_id1 => l_period_profile_id1,
3363: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3373: from pa_budget_versions

3369: select version_number,
3370: version_name
3371: into l_rev_version_number,
3372: l_rev_version_name
3373: from pa_budget_versions
3374: where budget_version_id = p_budget_version_id;
3375: select version_number,
3376: version_name
3377: into l_cost_version_number,

Line 3379: from pa_budget_versions

3375: select version_number,
3376: version_name
3377: into l_cost_version_number,
3378: l_cost_version_name
3379: from pa_budget_versions
3380: where budget_version_id = l_compl_budget_version_id;
3381: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_compl_budget_version_id;
3382: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3383: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3404: from pa_budget_versions

3400: select version_number,
3401: version_name
3402: into l_rev_version_number,
3403: l_rev_version_name
3404: from pa_budget_versions
3405: where budget_version_id = p_budget_version_id;
3406: l_cost_version_number := null;
3407: l_cost_version_name := ' ';
3408: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3425: from pa_budget_versions

3421: select version_number,
3422: version_name
3423: into l_rev_version_number,
3424: l_rev_version_name
3425: from pa_budget_versions
3426: where budget_version_id = p_budget_version_id;
3427: l_cost_version_number := null;
3428: l_cost_version_name := ' ';
3429: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

Line 3469: from pa_budget_versions

3465: select version_number,
3466: version_name
3467: into l_cost_version_number,
3468: l_cost_version_name
3469: from pa_budget_versions
3470: where budget_version_id = p_budget_version_id;
3471: l_rev_version_number := null;
3472: l_rev_version_name := ' ';
3473: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3487: from pa_budget_versions

3483: else
3484: -- found a compl for the COST version; merge only if period profiles are compatible
3485: select period_profile_id
3486: into l_period_profile_id1
3487: from pa_budget_versions
3488: where budget_version_id = p_budget_version_id;
3489: select period_profile_id
3490: into l_period_profile_id2
3491: from pa_budget_versions

Line 3491: from pa_budget_versions

3487: from pa_budget_versions
3488: where budget_version_id = p_budget_version_id;
3489: select period_profile_id
3490: into l_period_profile_id2
3491: from pa_budget_versions
3492: where budget_version_id = l_compl_budget_version_id;
3493: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3494: (p_period_profile_id1 => l_period_profile_id1,
3495: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3505: from pa_budget_versions

3501: select version_number,
3502: version_name
3503: into l_cost_version_number,
3504: l_cost_version_name
3505: from pa_budget_versions
3506: where budget_version_id = p_budget_version_id;
3507: select version_number,
3508: version_name
3509: into l_rev_version_number,

Line 3511: from pa_budget_versions

3507: select version_number,
3508: version_name
3509: into l_rev_version_number,
3510: l_rev_version_name
3511: from pa_budget_versions
3512: where budget_version_id = l_compl_budget_version_id;
3513: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;
3514: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3515: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3536: from pa_budget_versions

3532: select version_number,
3533: version_name
3534: into l_cost_version_number,
3535: l_cost_version_name
3536: from pa_budget_versions
3537: where budget_version_id = p_budget_version_id;
3538: l_rev_version_number := null;
3539: l_rev_version_name := ' ';
3540: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3557: from pa_budget_versions

3553: select version_number,
3554: version_name
3555: into l_cost_version_number,
3556: l_cost_version_name
3557: from pa_budget_versions
3558: where budget_version_id = p_budget_version_id;
3559: l_rev_version_number := null;
3560: l_rev_version_name := ' ';
3561: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3597: from pa_budget_versions

3593: select version_number,
3594: version_name
3595: into l_rev_version_number,
3596: l_rev_version_name
3597: from pa_budget_versions
3598: where budget_version_id = p_budget_version_id;
3599: l_cost_version_number := null;
3600: l_cost_version_name := ' ';
3601: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3615: from pa_budget_versions

3611: else
3612: -- found a compl for the REVENUE version; merge only if period profiles are compatible
3613: select period_profile_id
3614: into l_period_profile_id1
3615: from pa_budget_versions
3616: where budget_version_id = p_budget_version_id;
3617: select period_profile_id
3618: into l_period_profile_id2
3619: from pa_budget_versions

Line 3619: from pa_budget_versions

3615: from pa_budget_versions
3616: where budget_version_id = p_budget_version_id;
3617: select period_profile_id
3618: into l_period_profile_id2
3619: from pa_budget_versions
3620: where budget_version_id = l_compl_budget_version_id;
3621: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3622: (p_period_profile_id1 => l_period_profile_id1,
3623: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3633: from pa_budget_versions

3629: select version_number,
3630: version_name
3631: into l_rev_version_number,
3632: l_rev_version_name
3633: from pa_budget_versions
3634: where budget_version_id = p_budget_version_id;
3635: select version_number,
3636: version_name
3637: into l_cost_version_number,

Line 3639: from pa_budget_versions

3635: select version_number,
3636: version_name
3637: into l_cost_version_number,
3638: l_cost_version_name
3639: from pa_budget_versions
3640: where budget_version_id = l_compl_budget_version_id;
3641: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_compl_budget_version_id;
3642: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3643: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3664: from pa_budget_versions

3660: select version_number,
3661: version_name
3662: into l_rev_version_number,
3663: l_rev_version_name
3664: from pa_budget_versions
3665: where budget_version_id = p_budget_version_id;
3666: l_cost_version_number := null;
3667: l_cost_version_name := ' ';
3668: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3685: from pa_budget_versions

3681: select version_number,
3682: version_name
3683: into l_rev_version_number,
3684: l_rev_version_name
3685: from pa_budget_versions
3686: where budget_version_id = p_budget_version_id;
3687: l_cost_version_number := -1;
3688: l_cost_version_name := ' ';
3689: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

Line 3742: (p_project_id IN pa_budget_versions.project_id%TYPE,

3738: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
3739: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
3740: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3741: procedure pa_fp_vp_pop_tables_separate
3742: (p_project_id IN pa_budget_versions.project_id%TYPE,
3743: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3744: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3745: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3746: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3743: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3739: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
3740: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3741: procedure pa_fp_vp_pop_tables_separate
3742: (p_project_id IN pa_budget_versions.project_id%TYPE,
3743: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3744: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3745: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3746: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3747: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3744: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3740: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3741: procedure pa_fp_vp_pop_tables_separate
3742: (p_project_id IN pa_budget_versions.project_id%TYPE,
3743: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3744: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3745: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3746: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3747: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3748: )

Line 4010: pa_budget_versions bv

4006: l_default_amount_type_code,
4007: l_default_amount_subtype_code,
4008: l_period_profile_id
4009: from pa_proj_fp_options po,
4010: pa_budget_versions bv
4011: where bv.budget_version_id = p_cost_budget_version_id and
4012: bv.fin_plan_type_id = po.fin_plan_type_id and
4013: po.project_id = p_project_id and
4014: po.fin_plan_option_level_code = 'PLAN_TYPE';

Line 6847: (p_project_id IN pa_budget_versions.project_id%TYPE,

6843: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
6844: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
6845: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
6846: procedure pa_fp_vp_pop_tables_together
6847: (p_project_id IN pa_budget_versions.project_id%TYPE,
6848: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6849: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6850: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6851: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 6848: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6844: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
6845: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
6846: procedure pa_fp_vp_pop_tables_together
6847: (p_project_id IN pa_budget_versions.project_id%TYPE,
6848: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6849: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6850: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6851: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
6852: is

Line 7084: pa_budget_versions bv

7080: l_default_amount_type_code,
7081: l_default_amount_subtype_code,
7082: l_period_profile_id
7083: from pa_proj_fp_options po,
7084: pa_budget_versions bv
7085: where bv.budget_version_id = p_budget_version_id and
7086: bv.fin_plan_type_id = po.fin_plan_type_id and
7087: po.project_id = p_project_id and
7088: po.fin_plan_option_level_code = 'PLAN_TYPE';

Line 8283: (p_project_id IN pa_budget_versions.project_id%TYPE,

8279: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
8280: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
8281: -- 10/07/2003 Dlai: added l_pd_project_total(l_row_number) := null for Margin row
8282: procedure pa_fp_vp_pop_tables_single
8283: (p_project_id IN pa_budget_versions.project_id%TYPE,
8284: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8285: p_cost_or_rev IN VARCHAR2,
8286: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8287: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 8284: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

8280: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
8281: -- 10/07/2003 Dlai: added l_pd_project_total(l_row_number) := null for Margin row
8282: procedure pa_fp_vp_pop_tables_single
8283: (p_project_id IN pa_budget_versions.project_id%TYPE,
8284: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8285: p_cost_or_rev IN VARCHAR2,
8286: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8287: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8288: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 8557: pa_budget_versions bv

8553: l_default_amount_type_code,
8554: l_default_amount_subtype_code,
8555: l_period_profile_id
8556: from pa_proj_fp_options po,
8557: pa_budget_versions bv
8558: where bv.budget_version_id = p_budget_version_id and
8559: bv.fin_plan_type_id = po.fin_plan_type_id and
8560: po.project_id = p_project_id and
8561: po.fin_plan_option_level_code = 'PLAN_TYPE';