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 173: from pa_budget_versions bv,

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

Line 269: from pa_budget_versions bv,

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

Line 428: from pa_budget_versions

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

Line 452: pa_budget_versions pbv

448: into ll_plan_period_type,
449: pp_plan_start_date,
450: l_period_profile_id
451: from pa_proj_period_profiles pp,
452: pa_budget_versions pbv
453: where pbv.budget_version_id = p_orgfcst_version_id
454: and pbv.period_profile_id = pp.period_profile_id;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN

Line 672: from pa_budget_versions

668: select plan_processing_code,
669: request_id
670: into l_plan_processing_code,
671: l_request_id
672: from pa_budget_versions
673: where budget_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
674: if l_plan_processing_code = 'PPP' then
675: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
676: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 694: from pa_budget_versions

690: select plan_processing_code,
691: request_id
692: into l_plan_processing_code,
693: l_request_id
694: from pa_budget_versions
695: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
696: if l_plan_processing_code = 'PPP' then
697: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
698: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 716: from pa_budget_versions

712: select plan_processing_code,
713: request_id
714: into l_plan_processing_code,
715: l_request_id
716: from pa_budget_versions
717: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
718: if l_plan_processing_code = 'PPP' then
719: x_refresh_pd_flag := 'Y'; -- OUTPUT: x_refresh_pd_flag
720: x_refresh_req_id := l_request_id; -- OUTPUT: x_refresh_req_id

Line 775: from pa_budget_versions

771: select plan_processing_code,
772: request_id
773: into l_plan_processing_code,
774: l_request_id
775: from pa_budget_versions
776: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
777: if l_request_id is not null then
778: x_refresh_req_id := l_request_id;
779: end if;

Line 784: from pa_budget_versions

780: select plan_processing_code,
781: request_id
782: into l_plan_processing_code2,
783: l_request_id
784: from pa_budget_versions
785: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
786: if l_request_id is not null then
787: x_refresh_req_id := l_request_id;
788: end if;

Line 860: from pa_budget_versions

856: select record_version_number, -- OUTPUT: x_cost_rv_number
857: budget_status_code -- OUTPUT: x_cost_budget_status_code
858: into x_cost_rv_number,
859: x_cost_budget_status_code
860: from pa_budget_versions
861: --4/16/03 where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
862: where budget_version_id = x_cost_bv_id;
863: pa_fin_plan_utils.Check_Locked_By_User
864: (p_user_id => p_user_id,

Line 891: from pa_budget_versions

887: select record_version_number, -- OUTPUT: x_rev_rv_number
888: budget_status_code -- OUTPUT: x_rev_budget_status_code
889: into x_rev_rv_number,
890: x_rev_budget_status_code
891: from pa_budget_versions
892: -- where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
893: where budget_version_id = x_revenue_bv_id;
894: pa_fin_plan_utils.Check_Locked_By_User
895: (p_user_id => p_user_id,

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

935: END pa_fp_viewplan_hgrid_init;
936: /* ------------------------------------------------------------------------- */
937:
938: PROCEDURE pa_fp_viewplan_hgrid_init_ci
939: (p_project_id IN pa_budget_versions.project_id%TYPE,
940: p_ci_id IN pa_budget_versions.ci_id%TYPE,
941: p_user_id IN NUMBER,
942: p_period_start_date IN VARCHAR2,
943: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 940: p_ci_id IN pa_budget_versions.ci_id%TYPE,

936: /* ------------------------------------------------------------------------- */
937:
938: PROCEDURE pa_fp_viewplan_hgrid_init_ci
939: (p_project_id IN pa_budget_versions.project_id%TYPE,
940: p_ci_id IN pa_budget_versions.ci_id%TYPE,
941: p_user_id IN NUMBER,
942: p_period_start_date IN VARCHAR2,
943: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
944: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 943: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

939: (p_project_id IN pa_budget_versions.project_id%TYPE,
940: p_ci_id IN pa_budget_versions.ci_id%TYPE,
941: p_user_id IN NUMBER,
942: p_period_start_date IN VARCHAR2,
943: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
944: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
945: p_display_quantity IN VARCHAR2,
946: p_display_rawcost IN VARCHAR2,
947: p_display_burdcost IN VARCHAR2,

Line 944: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

940: p_ci_id IN pa_budget_versions.ci_id%TYPE,
941: p_user_id IN NUMBER,
942: p_period_start_date IN VARCHAR2,
943: p_user_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
944: p_user_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
945: p_display_quantity IN VARCHAR2,
946: p_display_rawcost IN VARCHAR2,
947: p_display_burdcost IN VARCHAR2,
948: p_display_revenue IN VARCHAR2,

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

957: x_plan_period_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
958: x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
959: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
960: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
961: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
962: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
963: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
964: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
965: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

958: x_labor_hrs_from_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
959: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
960: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
961: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
962: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
963: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
964: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
965: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
966: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

959: x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
960: x_calc_margin_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
961: x_cost_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
962: x_revenue_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
963: x_plan_type_id OUT NOCOPY pa_budget_versions.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
964: x_plan_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
965: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
966: x_factor_by_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
967: x_diff_pd_profile_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 999: l_cost_version_number pa_budget_versions.version_number%TYPE;

995: l_num_of_periods NUMBER;
996: l_project_id NUMBER;
997: l_org_id NUMBER;
998: l_cost_or_revenue VARCHAR2(1);
999: l_cost_version_number pa_budget_versions.version_number%TYPE;
1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

Line 1000: l_rev_version_number pa_budget_versions.version_number%TYPE;

996: l_project_id NUMBER;
997: l_org_id NUMBER;
998: l_cost_or_revenue VARCHAR2(1);
999: l_cost_version_number pa_budget_versions.version_number%TYPE;
1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 1001: l_cost_version_name pa_budget_versions.version_name%TYPE;

997: l_org_id NUMBER;
998: l_cost_or_revenue VARCHAR2(1);
999: l_cost_version_number pa_budget_versions.version_number%TYPE;
1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 1002: l_rev_version_name pa_budget_versions.version_name%TYPE;

998: l_cost_or_revenue VARCHAR2(1);
999: l_cost_version_number pa_budget_versions.version_number%TYPE;
1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

999: l_cost_version_number pa_budget_versions.version_number%TYPE;
1000: l_rev_version_number pa_budget_versions.version_number%TYPE;
1001: l_cost_version_name pa_budget_versions.version_name%TYPE;
1002: l_rev_version_name pa_budget_versions.version_name%TYPE;
1003: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1004: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1005: l_labor_hours_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
1006: l_cost_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
1007: l_rev_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 1032: l_version_type pa_budget_versions.version_type%TYPE;

1028: l_cur_end_period VARCHAR2(30);
1029:
1030: -- variables for default settings
1031: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1032: l_version_type pa_budget_versions.version_type%TYPE;
1033: l_display_quantity VARCHAR2(1);
1034: l_display_rawcost VARCHAR2(1);
1035: l_display_burdcost VARCHAR2(1);
1036: l_display_revenue VARCHAR2(1);

Line 1042: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

1038: l_display_marginpct VARCHAR2(1);
1039:
1040: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1041: l_working_or_baselined VARCHAR2(30);
1042: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
1043: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
1044:
1045: cursor ci_csr is
1046: select bv.budget_version_id,

Line 1043: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

1039:
1040: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1041: l_working_or_baselined VARCHAR2(30);
1042: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
1043: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
1044:
1045: cursor ci_csr is
1046: select bv.budget_version_id,
1047: po.proj_fp_options_id,

Line 1049: from pa_budget_versions bv,

1045: cursor ci_csr is
1046: select bv.budget_version_id,
1047: po.proj_fp_options_id,
1048: NVL(po.plan_in_multi_curr_flag, 'N') as plan_in_multi_curr_flag
1049: from pa_budget_versions bv,
1050: pa_proj_fp_options po
1051: where bv.project_id = p_project_id and
1052: bv.ci_id = p_ci_id and
1053: bv.budget_version_id = po.fin_plan_version_id and

Line 1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

1061: l_grouping_type VARCHAR2(30);
1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;

1062: l_compl_grouping_type VARCHAR2(30);
1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 1067: l_rv_number pa_budget_versions.record_version_number%TYPE;

1063: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1071:

Line 1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

1064: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1071:
1072: l_is_cost_locked_by_user VARCHAR2(1);

Line 1078: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1074: l_cost_locked_by_person_id NUMBER;
1075: l_rev_locked_by_person_id NUMBER;
1076:
1077: l_ci_row_index NUMBER := 0;
1078: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1079:
1080: -- uncategorized list info
1081: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1082: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

Line 1158: from pa_budget_versions bv,

1154: l_rv_number,
1155: l_ac_flag,
1156: l_ar_flag,
1157: l_uncategorized_flag
1158: from pa_budget_versions bv,
1159: pa_resource_lists_all_bg rl
1160: where bv.budget_version_id = ci_rec.budget_version_id and
1161: bv.resource_list_id = rl.resource_list_id;
1162:

Line 1290: from pa_budget_versions bv,

1286: into l_compl_grouping_type,
1287: l_compl_resource_list_id,
1288: l_compl_rv_number,
1289: l_compl_uncategorized_flag
1290: from pa_budget_versions bv,
1291: pa_resource_lists_all_bg rl
1292: where bv.budget_version_id = ci_rec.budget_version_id and
1293: bv.resource_list_id = rl.resource_list_id;
1294: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;

Line 1352: from pa_budget_versions bv,

1348: into l_compl_grouping_type,
1349: l_compl_resource_list_id,
1350: l_compl_rv_number,
1351: l_compl_uncategorized_flag
1352: from pa_budget_versions bv,
1353: pa_resource_lists_all_bg rl
1354: where bv.budget_version_id = ci_rec.budget_version_id and
1355: bv.resource_list_id = rl.resource_list_id;
1356: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;

Line 1415: from pa_budget_versions bv,

1411: into l_compl_grouping_type,
1412: l_compl_resource_list_id,
1413: l_compl_rv_number,
1414: l_compl_uncategorized_flag
1415: from pa_budget_versions bv,
1416: pa_resource_lists_all_bg rl
1417: where bv.budget_version_id = ci_rec.budget_version_id and
1418: bv.resource_list_id = rl.resource_list_id;
1419: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;

Line 1477: from pa_budget_versions bv,

1473: into l_compl_grouping_type,
1474: l_compl_resource_list_id,
1475: l_compl_rv_number,
1476: l_compl_uncategorized_flag
1477: from pa_budget_versions bv,
1478: pa_resource_lists_all_bg rl
1479: where bv.budget_version_id = ci_rec.budget_version_id and
1480: bv.resource_list_id = rl.resource_list_id;
1481: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;

Line 1542: from pa_budget_versions bv,

1538: 'PROJFUNC', pa.projfunc_currency_code,
1539: 'TXN')
1540: into l_project_id,
1541: l_projfunc_currency_code
1542: from pa_budget_versions bv,
1543: pa_projects_all pa
1544: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1545: bv.project_id = pa.project_id;
1546: select nvl(org_id,-99)

Line 1620: from pa_budget_versions bv,

1616: po.factor_by_code
1617: into l_amount_set_id,
1618: l_version_type,
1619: x_factor_by_code -- OUTPUT: x_factor_by_code
1620: from pa_budget_versions bv,
1621: pa_proj_fp_options po
1622: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1623: bv.fin_plan_type_id = po.fin_plan_type_id and
1624: po.project_id = l_project_id and

Line 1712: from pa_budget_versions

1708: nvl(approved_rev_plan_type_flag, 'N')
1709: into l_cost_or_revenue,
1710: x_budget_status_code, -- OUTPUT: x_budget_status_code
1711: x_ar_flag -- OUTPUT: x_ar_flag
1712: from pa_budget_versions
1713: where budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID;
1714: end if;
1715: -- END OF USER CUSTOMIZATIONS (ADVANCED DISPLAY OPTIONS)
1716: pa_fp_view_plans_pub.G_DEFAULT_AMOUNT_TYPE_CODE := l_default_amount_type_code;

Line 1730: pa_budget_versions pbv

1726: into ll_plan_period_type,
1727: pp_plan_start_date,
1728: l_period_profile_id
1729: from pa_proj_period_profiles pp,
1730: pa_budget_versions pbv
1731: where pbv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID
1732: and pp.period_profile_id = pbv.period_profile_id;
1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN

Line 1955: from pa_budget_versions

1951: select record_version_number, -- OUTPUT: x_cost_rv_number
1952: budget_status_code -- OUTPUT: x_budget_status_code
1953: into x_cost_rv_number,
1954: x_budget_status_code
1955: from pa_budget_versions
1956: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
1957: pa_fin_plan_utils.Check_Locked_By_User
1958: (p_user_id => p_user_id,
1959: p_budget_version_id => pa_fp_view_plans_pub.G_FP_COST_VERSION_ID,

Line 1983: from pa_budget_versions

1979: select record_version_number, -- OUTPUT: x_rev_rv_number
1980: budget_status_code -- OUTPUT: x_budget_status_code
1981: into x_rev_rv_number,
1982: x_budget_status_code
1983: from pa_budget_versions
1984: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
1985: pa_fin_plan_utils.Check_Locked_By_User
1986: (p_user_id => p_user_id,
1987: p_budget_version_id => pa_fp_view_plans_pub.G_FP_REV_VERSION_ID,

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

2568: -- pa_fp_vp_pop_tables_separate
2569: -- ELSE pa_fp_vp_pop_tables_single using the single BV
2570: -- 11/22/02: out parameter: x_diff_pd_profile_flag -> 'Y' when don't match
2571: procedure view_plan_temp_tables
2572: (p_project_id IN pa_budget_versions.project_id%TYPE,
2573: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2574: p_cost_or_revenue IN VARCHAR2,
2575: p_user_bv_flag IN VARCHAR2,
2576: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2573: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

2569: -- ELSE pa_fp_vp_pop_tables_single using the single BV
2570: -- 11/22/02: out parameter: x_diff_pd_profile_flag -> 'Y' when don't match
2571: procedure view_plan_temp_tables
2572: (p_project_id IN pa_budget_versions.project_id%TYPE,
2573: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2574: p_cost_or_revenue IN VARCHAR2,
2575: p_user_bv_flag IN VARCHAR2,
2576: x_cost_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2577: x_rev_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2587: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

2583: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2584: )
2585: as
2586:
2587: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
2588:
2589: cursor l_ra_csr is
2590: select * from pa_resource_assignments where budget_version_id=p_budget_version_id;
2591: l_ra_rec l_ra_csr%ROWTYPE;

Line 2601: pa_budget_versions bv

2597: cursor l_compl_c_w_csr is
2598: select bv.budget_version_id,
2599: po.proj_fp_options_id
2600: from pa_proj_fp_options po,
2601: pa_budget_versions bv
2602: where po.project_id = p_project_id and
2603: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2604: po.fin_plan_preference_code = 'REVENUE_ONLY' and
2605: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2614: pa_budget_versions bv

2610: cursor l_compl_c_b_csr is
2611: select bv.budget_version_id,
2612: po.proj_fp_options_id
2613: from pa_proj_fp_options po,
2614: pa_budget_versions bv
2615: where po.project_id = p_project_id and
2616: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2617: po.fin_plan_preference_code = 'REVENUE_ONLY' and
2618: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2627: pa_budget_versions bv

2623: cursor l_compl_r_w_csr is
2624: select bv.budget_version_id,
2625: po.proj_fp_options_id
2626: from pa_proj_fp_options po,
2627: pa_budget_versions bv
2628: where po.project_id = p_project_id and
2629: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2630: po.fin_plan_preference_code = 'COST_ONLY' and
2631: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2640: pa_budget_versions bv

2636: cursor l_compl_r_b_csr is
2637: select bv.budget_version_id,
2638: po.proj_fp_options_id
2639: from pa_proj_fp_options po,
2640: pa_budget_versions bv
2641: where po.project_id = p_project_id and
2642: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2643: po.fin_plan_preference_code = 'COST_ONLY' and
2644: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2653: pa_budget_versions bv

2649: cursor l_compl_crsep_c_w_csr is
2650: select bv.budget_version_id,
2651: po.proj_fp_options_id
2652: from pa_proj_fp_options po,
2653: pa_budget_versions bv
2654: where po.project_id = p_project_id and
2655: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2656: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2657: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2667: pa_budget_versions bv

2663: cursor l_compl_crsep_r_w_csr is
2664: select bv.budget_version_id,
2665: po.proj_fp_options_id
2666: from pa_proj_fp_options po,
2667: pa_budget_versions bv
2668: where po.project_id = p_project_id and
2669: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2670: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2671: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2684: pa_budget_versions bv

2680: cursor l_compl_crsep_c_b_csr is
2681: select bv.budget_version_id,
2682: po.proj_fp_options_id
2683: from pa_proj_fp_options po,
2684: pa_budget_versions bv
2685: where po.project_id = p_project_id and
2686: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2687: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2688: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2698: pa_budget_versions bv

2694: cursor l_compl_crsep_r_b_csr is
2695: select bv.budget_version_id,
2696: po.proj_fp_options_id
2697: from pa_proj_fp_options po,
2698: pa_budget_versions bv
2699: where po.project_id = p_project_id and
2700: po.fin_plan_type_id = l_fin_plan_type_id and -- same plan type
2701: -- po.fin_plan_preference_code = 'COST_AND_REV_SEP' and
2702: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2706: l_compl_crsep_r_b_rec l_compl_crsep_r_b_csr%ROWTYPE;
2707:
2708: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2709: l_working_or_baselined VARCHAR2(1);
2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;

Line 2715: l_cost_version_number pa_budget_versions.version_number%TYPE;

2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;
2718: l_rev_version_name pa_budget_versions.version_name%TYPE;
2719: l_diff_pd_profile_flag VARCHAR2(1);

Line 2716: l_rev_version_number pa_budget_versions.version_number%TYPE;

2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;
2718: l_rev_version_name pa_budget_versions.version_name%TYPE;
2719: l_diff_pd_profile_flag VARCHAR2(1);
2720:

Line 2717: l_cost_version_name pa_budget_versions.version_name%TYPE;

2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;
2718: l_rev_version_name pa_budget_versions.version_name%TYPE;
2719: l_diff_pd_profile_flag VARCHAR2(1);
2720:
2721: -- values used to populate temp table

Line 2718: l_rev_version_name pa_budget_versions.version_name%TYPE;

2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;
2718: l_rev_version_name pa_budget_versions.version_name%TYPE;
2719: l_diff_pd_profile_flag VARCHAR2(1);
2720:
2721: -- values used to populate temp table
2722: l_element_name VARCHAR2(1000);

Line 2725: l_primary_bvid pa_budget_versions.budget_version_id%TYPE;

2721: -- values used to populate temp table
2722: l_element_name VARCHAR2(1000);
2723:
2724: -- for Advanced Display Options customization
2725: l_primary_bvid pa_budget_versions.budget_version_id%TYPE;
2726:
2727: -- error handling variables
2728: l_return_status VARCHAR2(1);
2729: l_msg_count NUMBER;

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

2754: --hr_utility.trace('allversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID));
2755: --hr_utility.trace('COSTversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID));
2756: --hr_utility.trace('REVversionid= ' || to_char(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID));
2757:
2758: --hr_utility.trace('selecting from pa_budget_versions');
2759: select DECODE(budget_status_code,
2760: 'B', 'B',
2761: 'W'),
2762: fin_plan_type_id

Line 2765: from pa_budget_versions

2761: 'W'),
2762: fin_plan_type_id
2763: into l_working_or_baselined,
2764: l_fin_plan_type_id
2765: from pa_budget_versions
2766: where budget_version_id = p_budget_version_id;
2767: -- retrieve fin_plan_preference_code from PLAN_TYPE record
2768: select fin_plan_preference_code
2769: into l_fp_preference_code

Line 2790: from pa_budget_versions

2786: select version_name,
2787: version_number
2788: into l_cost_version_name,
2789: l_cost_version_number
2790: from pa_budget_versions
2791: where budget_version_id = p_budget_version_id;
2792: l_rev_version_name := l_cost_version_name;
2793: l_rev_version_number := l_cost_version_number;
2794: pa_fp_view_plans_pub.G_FP_ALL_VERSION_NAME := l_cost_version_name;

Line 2810: from pa_budget_versions

2806: select version_number,
2807: version_name
2808: into l_cost_version_number,
2809: l_cost_version_name
2810: from pa_budget_versions
2811: where budget_version_id = p_budget_version_id;
2812: l_rev_version_number := null;
2813: l_rev_version_name := ' ';
2814: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;

Line 2831: from pa_budget_versions

2827: select version_number,
2828: version_name
2829: into l_rev_version_number,
2830: l_rev_version_name
2831: from pa_budget_versions
2832: where budget_version_id = p_budget_version_id;
2833: l_cost_version_number := null;
2834: l_cost_version_name := ' ';
2835: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

Line 2853: from pa_budget_versions

2849:
2850: -- BEFORE MERGING, MAKE SURE PERIOD PROFILES MATCH
2851: select period_profile_id
2852: into l_period_profile_id1
2853: from pa_budget_versions
2854: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2855: select period_profile_id
2856: into l_period_profile_id2
2857: from pa_budget_versions

Line 2857: from pa_budget_versions

2853: from pa_budget_versions
2854: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2855: select period_profile_id
2856: into l_period_profile_id2
2857: from pa_budget_versions
2858: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2859: --hr_utility.trace('retrieved the period profile ids');
2860: if (pa_fp_view_plans_util.check_compatible_pd_profiles
2861: (p_period_profile_id1 => l_period_profile_id1,

Line 2871: from pa_budget_versions

2867: select version_number,
2868: version_name
2869: into l_cost_version_number,
2870: l_cost_version_name
2871: from pa_budget_versions
2872: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2873: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
2874: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;
2875: select version_number,

Line 2879: from pa_budget_versions

2875: select version_number,
2876: version_name
2877: into l_rev_version_number,
2878: l_rev_version_name
2879: from pa_budget_versions
2880: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2881: pa_fp_view_plans_pub.G_FP_REV_VERSION_NUMBER := l_rev_version_number;
2882: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;
2883: --hr_utility.trace('entering pa_fp_vp_pop_tables_separate');

Line 2901: from pa_budget_versions

2897: select version_number,
2898: version_name
2899: into l_cost_version_number,
2900: l_cost_version_name
2901: from pa_budget_versions
2902: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2903: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
2904: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;
2905: select version_number,

Line 2909: from pa_budget_versions

2905: select version_number,
2906: version_name
2907: into l_rev_version_number,
2908: l_rev_version_name
2909: from pa_budget_versions
2910: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2911: pa_fp_view_plans_pub.G_FP_REV_VERSION_NUMBER := l_rev_version_number;
2912: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;
2913: pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate

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 = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2930: l_rev_version_number := null;
2931: l_rev_version_name := ' ';
2932: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 2948: from pa_budget_versions

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

Line 2975: from pa_budget_versions

2971: 'W'),
2972: fin_plan_type_id
2973: into l_working_or_baselined,
2974: l_fin_plan_type_id
2975: from pa_budget_versions
2976: where budget_version_id = p_budget_version_id;
2977: -- retrieve fin_plan_preference_code from PLAN_TYPE record
2978: select fin_plan_preference_code
2979: into l_fp_preference_code

Line 2995: from pa_budget_versions

2991: select version_name,
2992: version_number
2993: into l_cost_version_name,
2994: l_cost_version_number
2995: from pa_budget_versions
2996: where budget_version_id = p_budget_version_id;
2997: l_rev_version_name := l_cost_version_name;
2998: l_rev_version_number := l_cost_version_number;
2999: pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID := p_budget_version_id;

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 = p_budget_version_id;
3021: l_rev_version_number := null;
3022: l_rev_version_name := ' ';
3023: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3042: from pa_budget_versions

3038: select version_number,
3039: version_name
3040: into l_rev_version_number,
3041: l_rev_version_name
3042: from pa_budget_versions
3043: where budget_version_id = p_budget_version_id;
3044: l_cost_version_number := null;
3045: l_cost_version_name := ' ';
3046: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3090: from pa_budget_versions

3086: select version_number,
3087: version_name
3088: into l_cost_version_number,
3089: l_cost_version_name
3090: from pa_budget_versions
3091: where budget_version_id = p_budget_version_id;
3092: l_rev_version_number := null;
3093: l_rev_version_name := ' ';
3094: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3108: from pa_budget_versions

3104: else
3105: -- found a compl for the COST version: merge only if period profiles are compatible
3106: select period_profile_id
3107: into l_period_profile_id1
3108: from pa_budget_versions
3109: where budget_version_id = p_budget_version_id;
3110: select period_profile_id
3111: into l_period_profile_id2
3112: from pa_budget_versions

Line 3112: from pa_budget_versions

3108: from pa_budget_versions
3109: where budget_version_id = p_budget_version_id;
3110: select period_profile_id
3111: into l_period_profile_id2
3112: from pa_budget_versions
3113: where budget_version_id = l_compl_budget_version_id;
3114: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3115: (p_period_profile_id1 => l_period_profile_id1,
3116: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3126: from pa_budget_versions

3122: select version_number,
3123: version_name
3124: into l_cost_version_number,
3125: l_cost_version_name
3126: from pa_budget_versions
3127: where budget_version_id = p_budget_version_id;
3128: select version_number,
3129: version_name
3130: into l_rev_version_number,

Line 3132: from pa_budget_versions

3128: select version_number,
3129: version_name
3130: into l_rev_version_number,
3131: l_rev_version_name
3132: from pa_budget_versions
3133: where budget_version_id = l_compl_budget_version_id;
3134: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;
3135: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3136: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3158: from pa_budget_versions

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

Line 3180: from pa_budget_versions

3176: select version_number,
3177: version_name
3178: into l_cost_version_number,
3179: l_cost_version_name
3180: from pa_budget_versions
3181: where budget_version_id = p_budget_version_id;
3182: l_rev_version_number := null;
3183: l_rev_version_name := ' ';
3184: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3219: from pa_budget_versions

3215: select version_number,
3216: version_name
3217: into l_rev_version_number,
3218: l_rev_version_name
3219: from pa_budget_versions
3220: where budget_version_id = p_budget_version_id;
3221: l_cost_version_number := null;
3222: l_cost_version_name := ' ';
3223: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3237: from pa_budget_versions

3233: else
3234: -- found a compl for the REVENUE version; merge only if period profiles are compatible
3235: select period_profile_id
3236: into l_period_profile_id1
3237: from pa_budget_versions
3238: where budget_version_id = p_budget_version_id;
3239: select period_profile_id
3240: into l_period_profile_id2
3241: from pa_budget_versions

Line 3241: from pa_budget_versions

3237: from pa_budget_versions
3238: where budget_version_id = p_budget_version_id;
3239: select period_profile_id
3240: into l_period_profile_id2
3241: from pa_budget_versions
3242: where budget_version_id = l_compl_budget_version_id;
3243: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3244: (p_period_profile_id1 => l_period_profile_id1,
3245: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3255: from pa_budget_versions

3251: select version_number,
3252: version_name
3253: into l_rev_version_number,
3254: l_rev_version_name
3255: from pa_budget_versions
3256: where budget_version_id = p_budget_version_id;
3257: select version_number,
3258: version_name
3259: into l_cost_version_number,

Line 3261: from pa_budget_versions

3257: select version_number,
3258: version_name
3259: into l_cost_version_number,
3260: l_cost_version_name
3261: from pa_budget_versions
3262: where budget_version_id = l_compl_budget_version_id;
3263: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_compl_budget_version_id;
3264: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3265: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3286: from pa_budget_versions

3282: select version_number,
3283: version_name
3284: into l_rev_version_number,
3285: l_rev_version_name
3286: from pa_budget_versions
3287: where budget_version_id = p_budget_version_id;
3288: l_cost_version_number := null;
3289: l_cost_version_name := ' ';
3290: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3307: from pa_budget_versions

3303: select version_number,
3304: version_name
3305: into l_rev_version_number,
3306: l_rev_version_name
3307: from pa_budget_versions
3308: where budget_version_id = p_budget_version_id;
3309: l_cost_version_number := null;
3310: l_cost_version_name := ' ';
3311: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

Line 3351: from pa_budget_versions

3347: select version_number,
3348: version_name
3349: into l_cost_version_number,
3350: l_cost_version_name
3351: from pa_budget_versions
3352: where budget_version_id = p_budget_version_id;
3353: l_rev_version_number := null;
3354: l_rev_version_name := ' ';
3355: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3369: from pa_budget_versions

3365: else
3366: -- found a compl for the COST version; merge only if period profiles are compatible
3367: select period_profile_id
3368: into l_period_profile_id1
3369: from pa_budget_versions
3370: where budget_version_id = p_budget_version_id;
3371: select period_profile_id
3372: into l_period_profile_id2
3373: from pa_budget_versions

Line 3373: from pa_budget_versions

3369: from pa_budget_versions
3370: where budget_version_id = p_budget_version_id;
3371: select period_profile_id
3372: into l_period_profile_id2
3373: from pa_budget_versions
3374: where budget_version_id = l_compl_budget_version_id;
3375: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3376: (p_period_profile_id1 => l_period_profile_id1,
3377: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3387: from pa_budget_versions

3383: select version_number,
3384: version_name
3385: into l_cost_version_number,
3386: l_cost_version_name
3387: from pa_budget_versions
3388: where budget_version_id = p_budget_version_id;
3389: select version_number,
3390: version_name
3391: into l_rev_version_number,

Line 3393: from pa_budget_versions

3389: select version_number,
3390: version_name
3391: into l_rev_version_number,
3392: l_rev_version_name
3393: from pa_budget_versions
3394: where budget_version_id = l_compl_budget_version_id;
3395: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;
3396: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3397: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3418: from pa_budget_versions

3414: select version_number,
3415: version_name
3416: into l_cost_version_number,
3417: l_cost_version_name
3418: from pa_budget_versions
3419: where budget_version_id = p_budget_version_id;
3420: l_rev_version_number := null;
3421: l_rev_version_name := ' ';
3422: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_budget_version_id;

Line 3439: from pa_budget_versions

3435: select version_number,
3436: version_name
3437: into l_cost_version_number,
3438: l_cost_version_name
3439: from pa_budget_versions
3440: where budget_version_id = p_budget_version_id;
3441: l_rev_version_number := null;
3442: l_rev_version_name := ' ';
3443: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3479: from pa_budget_versions

3475: select version_number,
3476: version_name
3477: into l_rev_version_number,
3478: l_rev_version_name
3479: from pa_budget_versions
3480: where budget_version_id = p_budget_version_id;
3481: l_cost_version_number := null;
3482: l_cost_version_name := ' ';
3483: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3497: from pa_budget_versions

3493: else
3494: -- found a compl for the REVENUE version; merge only if period profiles are compatible
3495: select period_profile_id
3496: into l_period_profile_id1
3497: from pa_budget_versions
3498: where budget_version_id = p_budget_version_id;
3499: select period_profile_id
3500: into l_period_profile_id2
3501: from pa_budget_versions

Line 3501: from pa_budget_versions

3497: from pa_budget_versions
3498: where budget_version_id = p_budget_version_id;
3499: select period_profile_id
3500: into l_period_profile_id2
3501: from pa_budget_versions
3502: where budget_version_id = l_compl_budget_version_id;
3503: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3504: (p_period_profile_id1 => l_period_profile_id1,
3505: p_period_profile_id2 => l_period_profile_id2) = 'Y') or

Line 3515: from pa_budget_versions

3511: select version_number,
3512: version_name
3513: into l_rev_version_number,
3514: l_rev_version_name
3515: from pa_budget_versions
3516: where budget_version_id = p_budget_version_id;
3517: select version_number,
3518: version_name
3519: into l_cost_version_number,

Line 3521: from pa_budget_versions

3517: select version_number,
3518: version_name
3519: into l_cost_version_number,
3520: l_cost_version_name
3521: from pa_budget_versions
3522: where budget_version_id = l_compl_budget_version_id;
3523: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_compl_budget_version_id;
3524: pa_fp_view_plans_pub.G_FP_COST_VERSION_NUMBER := l_cost_version_number;
3525: pa_fp_view_plans_pub.G_FP_COST_VERSION_NAME := l_cost_version_name;

Line 3546: from pa_budget_versions

3542: select version_number,
3543: version_name
3544: into l_rev_version_number,
3545: l_rev_version_name
3546: from pa_budget_versions
3547: where budget_version_id = p_budget_version_id;
3548: l_cost_version_number := null;
3549: l_cost_version_name := ' ';
3550: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_budget_version_id;

Line 3567: from pa_budget_versions

3563: select version_number,
3564: version_name
3565: into l_rev_version_number,
3566: l_rev_version_name
3567: from pa_budget_versions
3568: where budget_version_id = p_budget_version_id;
3569: l_cost_version_number := -1;
3570: l_cost_version_name := ' ';
3571: pa_fp_view_plans_pub.G_FP_REV_VERSION_NAME := l_rev_version_name;

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

3620: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
3621: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
3622: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3623: procedure pa_fp_vp_pop_tables_separate
3624: (p_project_id IN pa_budget_versions.project_id%TYPE,
3625: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3626: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3627: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3628: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3625: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3621: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
3622: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3623: procedure pa_fp_vp_pop_tables_separate
3624: (p_project_id IN pa_budget_versions.project_id%TYPE,
3625: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3626: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3627: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3628: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3629: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3626: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3622: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
3623: procedure pa_fp_vp_pop_tables_separate
3624: (p_project_id IN pa_budget_versions.project_id%TYPE,
3625: p_cost_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3626: p_rev_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3627: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3628: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3629: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3630: )

Line 3860: pa_budget_versions bv

3856: l_default_amount_type_code,
3857: l_default_amount_subtype_code,
3858: l_period_profile_id
3859: from pa_proj_fp_options po,
3860: pa_budget_versions bv
3861: where bv.budget_version_id = p_cost_budget_version_id and
3862: bv.fin_plan_type_id = po.fin_plan_type_id and
3863: po.project_id = p_project_id and
3864: po.fin_plan_option_level_code = 'PLAN_TYPE';

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

6244: -- 02/17/2003 Dlai: added l_pd_unit_of_measure (bug 2807032)
6245: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
6246: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
6247: procedure pa_fp_vp_pop_tables_together
6248: (p_project_id IN pa_budget_versions.project_id%TYPE,
6249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6251: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6252: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 6249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6245: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
6246: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
6247: procedure pa_fp_vp_pop_tables_together
6248: (p_project_id IN pa_budget_versions.project_id%TYPE,
6249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6251: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6252: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
6253: is

Line 6435: pa_budget_versions bv

6431: l_default_amount_type_code,
6432: l_default_amount_subtype_code,
6433: l_period_profile_id
6434: from pa_proj_fp_options po,
6435: pa_budget_versions bv
6436: where bv.budget_version_id = p_budget_version_id and
6437: bv.fin_plan_type_id = po.fin_plan_type_id and
6438: po.project_id = p_project_id and
6439: po.fin_plan_option_level_code = 'PLAN_TYPE';

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

7325: -- 02/20/2003 Dlai: added l_has_child_element/l_pd_has_child_element
7326: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
7327: -- 10/07/2003 Dlai: added l_pd_project_total(l_row_number) := null for Margin row
7328: procedure pa_fp_vp_pop_tables_single
7329: (p_project_id IN pa_budget_versions.project_id%TYPE,
7330: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
7331: p_cost_or_rev IN VARCHAR2,
7332: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7333: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 7330: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

7326: -- 07/25/2003 Dlai: for PA_FIN_VP_PDS_VIEW_TMP, populate project_total
7327: -- 10/07/2003 Dlai: added l_pd_project_total(l_row_number) := null for Margin row
7328: procedure pa_fp_vp_pop_tables_single
7329: (p_project_id IN pa_budget_versions.project_id%TYPE,
7330: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
7331: p_cost_or_rev IN VARCHAR2,
7332: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7333: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7334: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 7549: pa_budget_versions bv

7545: l_default_amount_type_code,
7546: l_default_amount_subtype_code,
7547: l_period_profile_id
7548: from pa_proj_fp_options po,
7549: pa_budget_versions bv
7550: where bv.budget_version_id = p_budget_version_id and
7551: bv.fin_plan_type_id = po.fin_plan_type_id and
7552: po.project_id = p_project_id and
7553: po.fin_plan_option_level_code = 'PLAN_TYPE';