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

Line 35: from pa_budget_versions v,

31:
32: /* Commenting out code for FP.M, Tracking Bug No - 3354518 : Starts */
33: /* cursor c_chk_bud(p_entry_level varchar2) is
34: select 'Y'
35: from pa_budget_versions v,
36: pa_budget_entry_methods m,
37: pa_budget_types bt
38: where v.project_id = x_project_id
39: and v.budget_status_code = 'W'

Line 47: from pa_budget_versions v

43: and v.budget_type_code = bt.budget_type_Code
44: and nvl(bt.plan_type,'BUDGET') = 'BUDGET'
45: UNION ALL
46: select 'Y'
47: from pa_budget_versions v
48: ,pa_proj_fp_options fo
49: where v.project_id = x_project_id
50: and v.budget_version_id = fo.fin_plan_version_id
51: and (fo.all_time_phased_code = 'N'

Line 64: from pa_budget_versions v,

60: /* Defining cursor below for checking if a budget-at-completion exists at the Project level */
61: /* Changes for FP.M, Tracking Bug No - 3354518 */
62: cursor c_chk_bud_p is
63: select 'Y'
64: from pa_budget_versions v,
65: pa_budget_entry_methods m,
66: pa_budget_types bt
67: where v.project_id = x_project_id
68: and v.budget_status_code = 'W'

Line 78: from pa_budget_versions v

74: and nvl(v.wp_version_flag,'N') = 'N'
75: and 'X' = DECODE(l_baseline_funding, 'Y', DECODE(v.budget_type_code, 'AR', 'Z', 'X'), 'X') --Bug 5098809.
76: UNION ALL
77: select 'Y'
78: from pa_budget_versions v
79: ,pa_proj_fp_options fo
80: where v.project_id = x_project_id
81: and v.budget_version_id = fo.fin_plan_version_id
82: and fo.project_id = v.project_id -- raja perf bug 3683360

Line 96: from pa_budget_versions v,

92: /* Defining cursor below for checking if a budget-at-completion exists at the Task level */
93: /* Changes for FP.M, Tracking Bug No - 3354518 */
94: cursor c_chk_bud_t is
95: select 'Y'
96: from pa_budget_versions v,
97: pa_budget_entry_methods m,
98: pa_budget_types bt
99: where v.project_id = x_project_id
100: and v.budget_status_code = 'W'

Line 110: from pa_budget_versions v

106: and nvl(v.wp_version_flag,'N') = 'N'
107: and 'X' = DECODE(l_baseline_funding, 'Y', DECODE(v.budget_type_code, 'AR', 'Z', 'X'), 'X') --Bug 5098809.
108: UNION ALL
109: select 'Y'
110: from pa_budget_versions v
111: ,pa_proj_fp_options fo
112: where v.project_id = x_project_id
113: and v.budget_version_id = fo.fin_plan_version_id
114: and fo.project_id = v.project_id -- raja perf bug 3683360

Line 207: UPDATE pa_budget_versions

203: x_err_stack := x_err_stack ||'->pa_budget_utils2.submit_budget';
204:
205: -- Set the budget_status_code to 'S' (Submit).
206:
207: UPDATE pa_budget_versions
208: SET budget_status_code = 'S'
209: WHERE budget_version_id = x_budget_version_id;
210:
211: x_err_stack := l_old_stack;

Line 237: UPDATE pa_budget_versions

233: x_err_stack := x_err_stack ||'->pa_budget_utils2.rework_budget';
234:
235: -- Set the budget_status_code to 'W' (Working).
236:
237: UPDATE pa_budget_versions
238: SET budget_status_code = 'W'
239: WHERE budget_version_id = x_budget_version_id;
240:
241: x_err_stack := l_old_stack;

Line 309: from pa_budget_versions v,

305: select 1
306: from dual
307: where exists
308: (select 'x' /* Old budgets model */
309: from pa_budget_versions v,
310: pa_budget_entry_methods m,
311: pa_resource_assignments r
312: where r.task_id = x_task_id
313: and ( (m.entry_level_code = 'L')

Line 323: from pa_budget_versions v,

319: and v.budget_version_id = r.budget_version_id
320: and v.budget_type_code is not null
321: union all
322: select 'x' /* Org Forcast Versions */
323: from pa_budget_versions v,
324: pa_resource_assignments r,
325: pa_fin_plan_types_b pft
326: where r.task_id = x_task_id
327: and v.budget_type_code is null

Line 335: -- Bug 2993894 ,pa_budget_versions bv

331: /* Commenting out the check for New model. FPM Dev changes - Tracking Bug - 3354518 - Starts*/
332: /* union all
333: select 'x' -- Financial plan versions
334: from pa_fp_elements fe
335: -- Bug 2993894 ,pa_budget_versions bv
336: where fe.task_id = x_task_id
337: -- Bug 2993894 and fe.fin_plan_version_id = bv.budget_version_id
338: and (x_task_id <> x_top_task_id OR fe.top_task_planning_level = 'LOWEST')); */
339: /* Commenting out the check for New model. FPM Dev changes - Tracking Bug - 3354518 - Ends*/

Line 346: from pa_budget_versions v,

342: select 1
343: from dual
344: where exists
345: (select 'x' /* Old budgets model */
346: from pa_budget_versions v,
347: pa_budget_entry_methods m,
348: pa_resource_assignments r
349: where r.task_id = x_task_id
350: and ( (m.entry_level_code = 'L')

Line 360: from pa_budget_versions v,

356: and v.budget_version_id = r.budget_version_id
357: and v.budget_type_code is not null
358: union all
359: select 'x' /* Org Forcast Versions */
360: from pa_budget_versions v,
361: pa_resource_assignments r,
362: pa_fin_plan_types_b pft
363: where r.task_id = x_task_id
364: and v.budget_type_code is null

Line 372: pa_budget_versions bv

368: /* Commenting out the check for New model. FPM Dev changes - Tracking Bug - 3354518 - Starts*/
369: /* union all
370: select 'x'-- Financial plan versions
371: from pa_fp_elements fe,
372: pa_budget_versions bv
373: where fe.task_id = x_task_id
374: and fe.fin_plan_version_id = bv.budget_version_id
375: and (fe.plan_amount_exists_flag = 'Y' or bv.budget_status_code = 'B')
376: and (x_task_id <> x_top_task_id OR fe.top_task_planning_level = 'LOWEST'));*/