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_PROJ_FP_OPTIONS

Line 147: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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;
147: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
148: BEGIN
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: select pt.plan_class_code,
151: po.fin_plan_preference_code

Line 156: pa_proj_fp_options po

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
159: bv.budget_version_id = po.fin_plan_version_id;
160: if l_plan_class_code = 'BUDGET' then

Line 166: from pa_proj_fp_options po,

162: begin
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

Line 168: pa_proj_fp_options po2

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
172: po.project_id = po2.project_id and

Line 186: from pa_proj_fp_options po,

182: -- RETRIEVE ORIGINAL BASELINED VERSION (IF IT EXISTS)
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

Line 188: pa_proj_fp_options po2

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
192: po.project_id = po2.project_id and

Line 208: from pa_proj_fp_options po,

204: -- looking for PRIMARY COST FORECAST plan type
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

Line 224: from pa_proj_fp_options po,

220: -- looking for PRIMARY REVENUE FORECAST plan type
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

Line 242: from pa_proj_fp_options po,

238: -- CURRENT PLAN VERSION IS FORECAST PLAN CLASS
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

Line 244: pa_proj_fp_options po2

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
248: po.project_id = po2.project_id and

Line 266: from pa_proj_fp_options po,

262: -- looking for APPROVED COST BUDGET plan type
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

Line 282: from pa_proj_fp_options po,

278: -- looking for APPROVED REVENUE BUDGET plan type
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

Line 298: from pa_proj_fp_options po,

294: -- looking for APPROVED COST AND REVENUE BUDGET plan type
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

Line 318: from pa_proj_fp_options po,

314: -- looking for APPROVED COST BUDGET plan type
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

Line 334: from pa_proj_fp_options po,

330: -- looking for APPROVED REVENUE BUDGET plan type
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

Line 395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is

391: -- Bug 4057673. Added a parameter p_fin_plan_level_code. It will be either 'P','L' or 'M'
392: --depending on the planning level of the budget version
393: FUNCTION get_project_task_level
394: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is
396:
397: l_project_id pa_resource_assignments.project_id%TYPE;
398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;
399: l_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

Line 847: pa_proj_fp_options po

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
851: ra.budget_version_id = bv.budget_version_id and

Line 975: -- pa_proj_fp_options po

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
979: -- ra.resource_assignment_id = rac.resource_assignment_id AND

Line 1171: pa_proj_fp_options po

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
1175: po.fin_plan_option_level_code = 'PLAN_VERSION';

Line 1402: pa_proj_fp_options po

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
1406: rac.resource_assignment_id = ra.resource_assignment_id AND

Line 1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1586:
1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
1588:
1589: l_start_date pa_budget_lines.start_date%TYPE;

Line 1759: pa_proj_fp_options po

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
1763: ra.resource_assignment_id = rac.resource_assignment_id AND

Line 2013: pa_proj_fp_options po

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
2017: po.fin_plan_option_level_code = 'PLAN_VERSION';

Line 2373: pa_proj_fp_options po

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
2377: ra.resource_assignment_id = rac.resource_assignment_id and

Line 3320: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%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;
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;