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

Line 22: l_edit_plan_struct_id pa_budget_versions.project_structure_version_id%TYPE;

18:
19: --These variables are internally used by the API get_fin_struct_id. They should not be used by other
20: --APIs in this package. These are created for bug 3546208
21: l_edit_plan_project_id pa_projects_all.project_id%TYPE;
22: l_edit_plan_struct_id pa_budget_versions.project_structure_version_id%TYPE;
23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;
24:
25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,

Line 23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;

19: --These variables are internally used by the API get_fin_struct_id. They should not be used by other
20: --APIs in this package. These are created for bug 3546208
21: l_edit_plan_project_id pa_projects_all.project_id%TYPE;
22: l_edit_plan_struct_id pa_budget_versions.project_structure_version_id%TYPE;
23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;
24:
25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

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

22: l_edit_plan_struct_id pa_budget_versions.project_structure_version_id%TYPE;
23: l_edit_plan_bv_id pa_budget_versions.budget_version_id%TYPE;
24:
25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
28: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

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

24:
25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
28: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

25: PROCEDURE get_workplan_bvids
26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
28: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

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

26: (p_project_id IN pa_budget_versions.project_id%TYPE,
27: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
28: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
34: l_wp_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

Line 34: l_wp_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

30: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
34: l_wp_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: begin
38: -- RETRIEVE THE WORKPLAN STRUCTURE VERSION ID which is used for

Line 39: -- join with pa_budget_versions

35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: begin
38: -- RETRIEVE THE WORKPLAN STRUCTURE VERSION ID which is used for
39: -- join with pa_budget_versions
40: select evs.element_version_id -- changed by shyugen
41: into l_wp_structure_version_id
42: from pa_proj_element_versions ev,
43: pa_proj_elem_ver_structure evs

Line 63: from pa_budget_versions

59: begin
60: -- RETRIEVE CURRENT VERSION ID
61: select budget_version_id
62: into x_current_version_id
63: from pa_budget_versions
64: where project_id = p_project_id and
65: wp_version_flag = 'Y' and
66: project_structure_version_id = l_wp_structure_version_id;
67: exception

Line 78: pa_budget_versions bv

74: into x_baselined_version_id
75: from pa_proj_elem_ver_structure str,
76: pa_proj_element_versions ppev1,
77: pa_proj_element_versions ppev2,
78: pa_budget_versions bv
79: where ppev1.element_version_id = p_element_version_id
80: and ppev1.project_id = ppev2.project_id
81: and ppev1.proj_element_id = ppev2.proj_element_id -- all the other task versions
82: and ppev2.parent_structure_version_id = str.element_version_id --the structure version of each task version

Line 98: pa_budget_versions bv

94: into x_published_version_id
95: from pa_proj_elem_ver_structure str,
96: pa_proj_element_versions ppev1,
97: pa_proj_element_versions ppev2,
98: pa_budget_versions bv
99: where ppev1.element_version_id = p_element_version_id
100: and ppev1.project_id = ppev2.project_id
101: and ppev1.proj_element_id = ppev2.proj_element_id -- all the other task versions
102: and ppev2.parent_structure_version_id = str.element_version_id --the structure version of each task version

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

133: * 07/14/2005 dlai if p_budget_version is a FORECAST version, x_original_version_id will
134: * be passed if it exists (regardless of the value of p_view_plan_flag)
135: */
136: PROCEDURE get_finplan_bvids
137: (p_project_id IN pa_budget_versions.project_id%TYPE,
138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139: p_view_plan_flag IN VARCHAR2 default 'N',
140: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
141: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

134: * be passed if it exists (regardless of the value of p_view_plan_flag)
135: */
136: PROCEDURE get_finplan_bvids
137: (p_project_id IN pa_budget_versions.project_id%TYPE,
138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139: p_view_plan_flag IN VARCHAR2 default 'N',
140: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
141: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
142: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

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

136: PROCEDURE get_finplan_bvids
137: (p_project_id IN pa_budget_versions.project_id%TYPE,
138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139: p_view_plan_flag IN VARCHAR2 default 'N',
140: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
141: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
142: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
143: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

137: (p_project_id IN pa_budget_versions.project_id%TYPE,
138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139: p_view_plan_flag IN VARCHAR2 default 'N',
140: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
141: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
142: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
143: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
145: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

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

138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139: p_view_plan_flag IN VARCHAR2 default 'N',
140: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
141: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
142: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
143: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
144: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
145: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
146: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 154: from pa_budget_versions bv,

150: select pt.plan_class_code,
151: po.fin_plan_preference_code
152: into l_plan_class_code,
153: l_fin_plan_pref_code
154: from pa_budget_versions bv,
155: pa_fin_plan_types_b pt,
156: pa_proj_fp_options po
157: where bv.budget_version_id = p_budget_version_id and
158: bv.fin_plan_type_id = pt.fin_plan_type_id and

Line 167: pa_budget_versions bv,

163: -- RETRIEVE CURRENT BASELINED VERSION (IF IT EXISTS)
164: select bv.budget_version_id
165: into x_current_version_id
166: from pa_proj_fp_options po,
167: pa_budget_versions bv,
168: pa_proj_fp_options po2
169: where po.project_id = p_project_id and
170: po.fin_plan_version_id = p_budget_version_id and
171: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 187: pa_budget_versions bv,

183: begin
184: select bv.budget_version_id
185: into x_original_version_id
186: from pa_proj_fp_options po,
187: pa_budget_versions bv,
188: pa_proj_fp_options po2
189: where po.project_id = p_project_id and
190: po.fin_plan_version_id = p_budget_version_id and
191: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 209: pa_budget_versions bv

205: begin
206: select bv.budget_version_id
207: into x_prior_fcst_version_id
208: from pa_proj_fp_options po,
209: pa_budget_versions bv
210: where po.project_id = p_project_id and
211: po.fin_plan_option_level_code = 'PLAN_VERSION' and
212: bv.primary_cost_forecast_flag = 'Y' and
213: po.fin_plan_version_id = bv.budget_version_id and

Line 225: pa_budget_versions bv

221: begin
222: select bv.budget_version_id
223: into x_prior_fcst_version_id
224: from pa_proj_fp_options po,
225: pa_budget_versions bv
226: where po.project_id = p_project_id and
227: po.fin_plan_option_level_code = 'PLAN_VERSION' and
228: bv.primary_rev_forecast_flag = 'Y' and
229: po.fin_plan_version_id = bv.budget_version_id and

Line 243: pa_budget_versions bv,

239: begin
240: select bv.budget_version_id
241: into x_prior_fcst_version_id
242: from pa_proj_fp_options po,
243: pa_budget_versions bv,
244: pa_proj_fp_options po2
245: where po.project_id = p_project_id and
246: po.fin_plan_version_id = p_budget_version_id and
247: po.fin_plan_option_level_code = 'PLAN_VERSION' and

Line 267: pa_budget_versions bv

263: begin
264: select bv.budget_version_id
265: into x_original_version_id
266: from pa_proj_fp_options po,
267: pa_budget_versions bv
268: where po.project_id = p_project_id and
269: po.fin_plan_option_level_code = 'PLAN_VERSION' and
270: bv.approved_cost_plan_type_flag = 'Y' and
271: po.fin_plan_version_id = bv.budget_version_id and

Line 283: pa_budget_versions bv

279: begin
280: select bv.budget_version_id
281: into x_original_version_id
282: from pa_proj_fp_options po,
283: pa_budget_versions bv
284: where po.project_id = p_project_id and
285: po.fin_plan_option_level_code = 'PLAN_VERSION' and
286: bv.approved_rev_plan_type_flag = 'Y' and
287: po.fin_plan_version_id = bv.budget_version_id and

Line 299: pa_budget_versions bv

295: begin
296: select bv.budget_version_id
297: into x_original_version_id
298: from pa_proj_fp_options po,
299: pa_budget_versions bv
300: where po.project_id = p_project_id and
301: po.fin_plan_option_level_code = 'PLAN_VERSION' and
302: bv.approved_cost_plan_type_flag = 'Y' and
303: bv.approved_rev_plan_type_flag = 'Y' and

Line 319: pa_budget_versions bv

315: begin
316: select bv.budget_version_id
317: into x_current_version_id
318: from pa_proj_fp_options po,
319: pa_budget_versions bv
320: where po.project_id = p_project_id and
321: po.fin_plan_option_level_code = 'PLAN_VERSION' and
322: bv.approved_cost_plan_type_flag = 'Y' and
323: po.fin_plan_version_id = bv.budget_version_id and

Line 335: pa_budget_versions bv

331: begin
332: select bv.budget_version_id
333: into x_current_version_id
334: from pa_proj_fp_options po,
335: pa_budget_versions bv
336: where po.project_id = p_project_id and
337: po.fin_plan_option_level_code = 'PLAN_VERSION' and
338: bv.approved_rev_plan_type_flag = 'Y' and
339: po.fin_plan_version_id = bv.budget_version_id and

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

675: * 05/10/2005 - dlai - margin parameters are returned as null if
676: * p_budget_version_id refers to COST_ONLY or REVENUE_ONLY version
677: */
678: PROCEDURE get_common_budget_version_info
679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

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

682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

Line 846: pa_budget_versions bv,

842: null, 0,
843: (SUM(bl.txn_burdened_cost) - SUM(nvl(bl.txn_init_burdened_cost,0)))/(SUM(bl.quantity) - SUM(nvl(init_quantity,0))))
844: from pa_resource_assignments ra,
845: pa_budget_lines bl,
846: pa_budget_versions bv,
847: pa_proj_fp_options po
848: where ra.resource_assignment_id = l_resource_assignment_id and
849: ra.resource_assignment_id = bl.resource_assignment_id and
850: bl.txn_currency_code = p_txn_currency_code and

Line 974: -- pa_budget_versions bv,

970: -- DECODE(ra.rate_based_flag, 'Y', rac.txn_etc_burden_cost_rate, TO_NUMBER(NULL))
971: -- FROM pa_resource_assignments ra,
972: -- -- pa_budget_lines bl,
973: -- pa_resource_asgn_curr rac,
974: -- pa_budget_versions bv,
975: -- pa_proj_fp_options po
976: -- WHERE ra.resource_assignment_id = l_resource_assignment_id AND
977: -- -- ra.resource_assignment_id = bl.resource_assignment_id AND
978: -- -- bl.txn_currency_code = p_txn_currency_code AND

Line 1170: pa_budget_versions bv,

1166: x_margin_proj_cur,
1167: x_margin_proj_func_cur,
1168: x_margin_pct
1169: from pa_resource_assignments ra,
1170: pa_budget_versions bv,
1171: pa_proj_fp_options po
1172: where ra.resource_assignment_id = l_resource_assignment_id and
1173: ra.budget_version_id = bv.budget_version_id and
1174: bv.budget_version_id = po.fin_plan_version_id and

Line 1401: pa_budget_versions bv,

1397: x_etc_avg_burd_cost_rate
1398: FROM pa_resource_assignments ra,
1399: -- pa_budget_lines bl,
1400: pa_resource_asgn_curr rac,
1401: pa_budget_versions bv,
1402: pa_proj_fp_options po
1403: WHERE ra.resource_assignment_id = l_resource_assignment_id AND
1404: -- ra.resource_assignment_id = bl.resource_assignment_id AND
1405: -- bl.txn_currency_code = p_txn_currency_code AND

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

1509: * 06/02/2005 - dlai - queries for etc amounts should use nvl(..,0) so that they
1510: * are calculate correctly in case the act or fcst amounts are null
1511: */
1512: PROCEDURE get_common_bv_info_fcst
1513: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

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

1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

Line 1758: pa_budget_versions bv,

1754: po.margin_derived_from_code
1755: FROM pa_resource_assignments ra,
1756: -- pa_budget_lines bl,
1757: pa_resource_asgn_curr rac,
1758: pa_budget_versions bv,
1759: pa_proj_fp_options po
1760: WHERE ra.resource_assignment_id = l_resource_assignment_id AND
1761: -- ra.resource_assignment_id = bl.resource_assignment_id AND
1762: -- bl.txn_currency_code = p_txn_currency_code AND

Line 2012: pa_budget_versions bv,

2008: x_etc_margin_pct,
2009: x_fcst_margin_pct,
2010: l_margin_derived_from_code
2011: from pa_resource_assignments ra,
2012: pa_budget_versions bv,
2013: pa_proj_fp_options po
2014: where ra.resource_assignment_id = l_resource_assignment_id and
2015: ra.budget_version_id = bv.budget_version_id and
2016: bv.budget_version_id = po.fin_plan_version_id and

Line 2372: pa_budget_versions bv,

2368: l_margin_derived_from_code
2369: FROM pa_resource_assignments ra,
2370: -- pa_budget_lines bl,
2371: pa_resource_asgn_curr rac,
2372: pa_budget_versions bv,
2373: pa_proj_fp_options po
2374: where ra.resource_assignment_id = l_resource_assignment_id and
2375: -- ra.resource_assignment_id = bl.resource_assignment_id and
2376: -- bl.txn_currency_code = p_txn_currency_code and

Line 2680: p_project_id IN pa_budget_versions.project_id%TYPE,

2676: * version 115.29 of PAFPPEUB.pls
2677: */
2678: PROCEDURE add_new_resource_assignments
2679: (p_context IN VARCHAR2,
2680: p_project_id IN pa_budget_versions.project_id%TYPE,
2681: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2682: p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
2683: p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
2684: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

Line 2681: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

2677: */
2678: PROCEDURE add_new_resource_assignments
2679: (p_context IN VARCHAR2,
2680: p_project_id IN pa_budget_versions.project_id%TYPE,
2681: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
2682: p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
2683: p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
2684: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
2685: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(),

Line 3104: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2 is

3100: /* REVISION HISTORY
3101: * Created: 07/20/2004 by DLAI for bug 3747582
3102: */
3103: FUNCTION get_bv_name_from_id
3104: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2 is
3105: l_return_value pa_budget_versions.version_name%TYPE;
3106: BEGIN
3107: select version_name
3108: into l_return_value

Line 3105: l_return_value pa_budget_versions.version_name%TYPE;

3101: * Created: 07/20/2004 by DLAI for bug 3747582
3102: */
3103: FUNCTION get_bv_name_from_id
3104: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2 is
3105: l_return_value pa_budget_versions.version_name%TYPE;
3106: BEGIN
3107: select version_name
3108: into l_return_value
3109: from pa_budget_versions

Line 3109: from pa_budget_versions

3105: l_return_value pa_budget_versions.version_name%TYPE;
3106: BEGIN
3107: select version_name
3108: into l_return_value
3109: from pa_budget_versions
3110: where budget_version_id = p_budget_version_id;
3111: return l_return_value;
3112: EXCEPTION
3113: when NO_DATA_FOUND then

Line 3122: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)

3118:
3119: --Created for bug 3546208. This function will return the financial structure version id for the project
3120: --id passed.
3121: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,
3122: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
3123: RETURN NUMBER
3124: IS
3125: BEGIN
3126: IF (l_edit_plan_project_id IS NULL OR

Line 3136: FROM pa_budget_versions

3132: SELECT DECODE(wp_version_flag,
3133: 'Y',project_structure_version_id,
3134: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id))
3135: INTO l_edit_plan_struct_id
3136: FROM pa_budget_versions
3137: WHERE budget_Version_id=p_budget_version_id;
3138:
3139: l_edit_plan_project_id:= p_project_id;
3140: l_edit_plan_bv_id := p_budget_version_id;

Line 3234: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3230:
3231:
3232: FUNCTION get_task_percent_complete
3233: (p_project_id IN pa_projects_all.project_id%TYPE,
3234: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3235: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3236: p_calling_context IN VARCHAR2) return NUMBER
3237: is
3238: l_return_value NUMBER;

Line 3315: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,

3311: x_prior_fcst_version_id = Version previous to the current baselined version
3312: of same plan type
3313: */
3314: FUNCTION get_prior_forecast_version_id
3315: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
3316: p_project_id IN pa_projects_all.project_id%TYPE
3317: ) return NUMBER
3318: is
3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;

3317: ) return NUMBER
3318: is
3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;
3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;
3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;

Line 3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;

3318: is
3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;
3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;
3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;
3326:

Line 3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;

3319: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;
3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;
3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;
3326:
3327:

Line 3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;

3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;
3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;
3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;
3326:
3327:
3328: BEGIN

Line 3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;

3321: l_curr_fcst_ver_id pa_budget_versions.budget_version_id%TYPE := NULL;
3322: l_curr_fcst_ver_num pa_budget_versions.version_number%TYPE := NULL;
3323: l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE := NULL;
3324: l_version_type pa_budget_versions.version_type%TYPE := NULL;
3325: x_prior_fcst_version_id pa_budget_versions.budget_version_id%TYPE := NULL;
3326:
3327:
3328: BEGIN
3329: select pt.plan_class_code,

Line 3334: from pa_budget_versions bv,

3330: decode(bv.version_type,'COST','COST_ONLY','REVENUE','REVENUE_ONLY',
3331: 'ALL','COST_AND_REV_SAME')
3332: into l_plan_class_code,
3333: l_fin_plan_pref_code
3334: from pa_budget_versions bv,
3335: pa_fin_plan_types_b pt
3336: where bv.budget_version_id = p_plan_version_id and
3337: bv.fin_plan_type_id = pt.fin_plan_type_id;
3338:

Line 3349: from pa_budget_versions bv

3345: select bv.budget_version_id,
3346: bv.version_number
3347: into l_curr_fcst_ver_id,
3348: l_curr_fcst_ver_num
3349: from pa_budget_versions bv
3350: where bv.project_id = p_project_id and
3351: bv.primary_cost_forecast_flag = 'Y' and
3352: bv.current_flag = 'Y';
3353:

Line 3356: from pa_budget_versions bv1

3352: bv.current_flag = 'Y';
3353:
3354: select bv1.budget_version_id
3355: into x_prior_fcst_version_id
3356: from pa_budget_versions bv1
3357: where bv1.project_id = p_project_id
3358: and bv1.primary_cost_forecast_flag = 'Y'
3359: and bv1.budget_status_code = 'B'
3360: /*and bv1.version_number = l_curr_fcst_ver_num - 1;

Line 3363: from pa_budget_versions bv2

3359: and bv1.budget_status_code = 'B'
3360: /*and bv1.version_number = l_curr_fcst_ver_num - 1;
3361: commented and added below for bug 6870324 */
3362: and bv1.version_number = (select max(bv2.version_number)
3363: from pa_budget_versions bv2
3364: where bv2.project_id = p_project_id
3365: and bv2.primary_cost_forecast_flag = 'Y'
3366: and bv2.budget_status_code = 'B'
3367: and bv2.version_number < l_curr_fcst_ver_num

Line 3382: from pa_budget_versions bv

3378: select bv.budget_version_id,
3379: bv.version_number
3380: into l_curr_fcst_ver_id,
3381: l_curr_fcst_ver_num
3382: from pa_budget_versions bv
3383: where bv.project_id = p_project_id and
3384: bv.primary_rev_forecast_flag = 'Y' and
3385: bv.current_flag = 'Y';
3386:

Line 3389: from pa_budget_versions bv1

3385: bv.current_flag = 'Y';
3386:
3387: select bv1.budget_version_id
3388: into x_prior_fcst_version_id
3389: from pa_budget_versions bv1
3390: where bv1.project_id = p_project_id
3391: and bv1.primary_rev_forecast_flag = 'Y'
3392: and bv1.budget_status_code = 'B'
3393: /*and bv1.version_number = l_curr_fcst_ver_num - 1;

Line 3396: from pa_budget_versions bv2

3392: and bv1.budget_status_code = 'B'
3393: /*and bv1.version_number = l_curr_fcst_ver_num - 1;
3394: commented and added below for bug 6870324 */
3395: and bv1.version_number = (select max(bv2.version_number)
3396: from pa_budget_versions bv2
3397: where bv2.project_id = p_project_id
3398: and bv2.primary_rev_forecast_flag = 'Y'
3399: and bv2.budget_status_code = 'B'
3400: and bv2.version_number < l_curr_fcst_ver_num

Line 3414: from pa_budget_versions bv

3410: select bv.budget_version_id,
3411: bv.version_number
3412: into l_curr_fcst_ver_id,
3413: l_curr_fcst_ver_num
3414: from pa_budget_versions bv
3415: where bv.project_id = p_project_id and
3416: bv.primary_rev_forecast_flag = 'Y' and
3417: bv.primary_cost_forecast_flag = 'Y' and
3418: bv.current_flag = 'Y';

Line 3421: from pa_budget_versions bv1

3417: bv.primary_cost_forecast_flag = 'Y' and
3418: bv.current_flag = 'Y';
3419: select bv1.budget_version_id
3420: into x_prior_fcst_version_id
3421: from pa_budget_versions bv1
3422: where bv1.project_id = p_project_id
3423: and bv1.primary_rev_forecast_flag = 'Y'
3424: and bv1.primary_cost_forecast_flag = 'Y'
3425: and bv1.budget_status_code = 'B'

Line 3429: from pa_budget_versions bv2

3425: and bv1.budget_status_code = 'B'
3426: /*and bv1.version_number = l_curr_fcst_ver_num - 1;
3427: commented and added below for bug 6870324 */
3428: and bv1.version_number = (select max(bv2.version_number)
3429: from pa_budget_versions bv2
3430: where bv2.project_id = p_project_id
3431: and bv2.primary_rev_forecast_flag = 'Y'
3432: and bv2.primary_cost_forecast_flag = 'Y'
3433: and bv2.budget_status_code = 'B'

Line 3445: from pa_budget_versions bv

3441: select bv.budget_version_id,
3442: bv.version_number
3443: into l_curr_fcst_ver_id,
3444: l_curr_fcst_ver_num
3445: from pa_budget_versions bv
3446: where bv.project_id = p_project_id and
3447: bv.primary_cost_forecast_flag = 'Y' and
3448: bv.current_flag = 'Y';
3449:

Line 3452: from pa_budget_versions bv1

3448: bv.current_flag = 'Y';
3449:
3450: select bv1.budget_version_id
3451: into x_prior_fcst_version_id
3452: from pa_budget_versions bv1
3453: where bv1.project_id = p_project_id
3454: and bv1.primary_cost_forecast_flag = 'Y'
3455: and bv1.budget_status_code = 'B'
3456: /*and bv1.version_number = l_curr_fcst_ver_num - 1;

Line 3459: from pa_budget_versions bv2

3455: and bv1.budget_status_code = 'B'
3456: /*and bv1.version_number = l_curr_fcst_ver_num - 1;
3457: commented and added below for bug 6870324 */
3458: and bv1.version_number = (select max(bv2.version_number)
3459: from pa_budget_versions bv2
3460: where bv2.project_id = p_project_id
3461: and bv2.primary_cost_forecast_flag = 'Y'
3462: and bv2.budget_status_code = 'B'
3463: and bv2.version_number < l_curr_fcst_ver_num

Line 3474: from pa_budget_versions bv

3470: select bv.budget_version_id,
3471: bv.version_number
3472: into l_curr_fcst_ver_id,
3473: l_curr_fcst_ver_num
3474: from pa_budget_versions bv
3475: where bv.project_id = p_project_id and
3476: bv.primary_rev_forecast_flag = 'Y' and
3477: bv.current_flag = 'Y';
3478:

Line 3481: from pa_budget_versions bv1

3477: bv.current_flag = 'Y';
3478:
3479: select bv1.budget_version_id
3480: into x_prior_fcst_version_id
3481: from pa_budget_versions bv1
3482: where bv1.project_id = p_project_id
3483: and bv1.primary_rev_forecast_flag = 'Y'
3484: and bv1.budget_status_code = 'B'
3485: /*and bv1.version_number = l_curr_fcst_ver_num - 1;

Line 3488: from pa_budget_versions bv2

3484: and bv1.budget_status_code = 'B'
3485: /*and bv1.version_number = l_curr_fcst_ver_num - 1;
3486: commented and added below for bug 6870324 */
3487: and bv1.version_number = (select max(bv2.version_number)
3488: from pa_budget_versions bv2
3489: where bv2.project_id = p_project_id
3490: and bv2.primary_rev_forecast_flag = 'Y'
3491: and bv2.budget_status_code = 'B'
3492: and bv2.version_number < l_curr_fcst_ver_num

Line 3515: from pa_budget_versions bv1,

3511: into l_curr_fcst_ver_id,
3512: l_curr_fcst_ver_num,
3513: l_fp_type_id,
3514: l_version_type
3515: from pa_budget_versions bv1,
3516: pa_budget_versions bv2
3517: where bv1.project_id = p_project_id and
3518: bv1.budget_version_id = p_plan_version_id and
3519: bv1.project_id = bv2.project_id and

Line 3516: pa_budget_versions bv2

3512: l_curr_fcst_ver_num,
3513: l_fp_type_id,
3514: l_version_type
3515: from pa_budget_versions bv1,
3516: pa_budget_versions bv2
3517: where bv1.project_id = p_project_id and
3518: bv1.budget_version_id = p_plan_version_id and
3519: bv1.project_id = bv2.project_id and
3520: bv1.fin_plan_type_id = bv2.fin_plan_type_id and

Line 3526: from pa_budget_versions

3522: bv2.current_flag = 'Y';
3523:
3524: select budget_version_id
3525: into x_prior_fcst_version_id
3526: from pa_budget_versions
3527: where project_id = p_project_id and
3528: fin_plan_type_id = l_fp_type_id and
3529: version_type = l_version_type and
3530: budget_status_code = 'B' and

Line 3534: from pa_budget_versions bv1

3530: budget_status_code = 'B' and
3531: /* version_number = l_curr_fcst_ver_num - 1;
3532: commented and added below for bug 6870324 */
3533: version_number = (select max(bv1.version_number)
3534: from pa_budget_versions bv1
3535: where bv1.project_id = p_project_id
3536: and bv1.fin_plan_type_id = l_fp_type_id
3537: and bv1.version_type = l_version_type
3538: and bv1.budget_status_code = 'B'