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_UTILS dependencies on PA_BUDGET_TYPES

Line 35: from pa_budget_versions bv , pa_budget_types bt

31:
32:
33: select bv.budget_version_id
34: into x_budget_version_id
35: from pa_budget_versions bv , pa_budget_types bt
36: where bv.project_id = x_project_id
37: and bv.budget_type_code = x_budget_type_code
38: and bv.budget_status_code in ('W', 'S')
39: and bv.budget_type_code = bt.budget_type_code

Line 93: from pa_budget_versions bv, pa_budget_types bt

89: || '><' || x_budget_type_code || '>' ;
90:
91: select bv.budget_version_id
92: into x_budget_version_id
93: from pa_budget_versions bv, pa_budget_types bt
94: where bv.project_id = x_project_id
95: and bv.budget_type_code = x_budget_type_code
96: and bv.current_flag = 'Y'
97: and bv.budget_type_code = bt.budget_type_code

Line 135: from pa_budget_versions bv, pa_budget_types bt

131: || '><' || x_budget_type_code || '>' ;
132:
133: select bv.budget_version_id
134: into x_budget_version_id
135: from pa_budget_versions bv, pa_budget_types bt
136: where bv.project_id = x_project_id
137: and bv.budget_type_code = x_budget_type_code
138: and bv.current_original_flag = 'Y'
139: and bv.budget_type_code = bt.budget_type_code

Line 184: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;

180: x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
181: x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
182: x_err_stack in out NOCOPY varchar2) --File.Sql.39 bug 4440895
183: is
184: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
185: x_allow_budget_entry_flag varchar2(2);
186: x_baselined_version_id number;
187: old_stack varchar2(630);
188:

Line 233: from pa_budget_types

229: x_err_stage := 'get budget amount code <' || x_budget_type_code || '>' ;
230:
231: select budget_amount_code
232: into x_budget_amount_code
233: from pa_budget_types
234: where budget_type_code = x_budget_type_code;
235:
236: x_err_stage := 'get default resource list id <' || to_char(x_project_id)
237: || '>' ;

Line 296: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;

292: x_err_code in out NOCOPY number, --File.Sql.39 bug 4440895
293: x_err_stage in out NOCOPY varchar2, --File.Sql.39 bug 4440895
294: x_err_stack in out NOCOPY varchar2) --File.Sql.39 bug 4440895
295: is
296: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
297: x_allow_budget_entry_flag varchar2(2);
298: old_stack varchar2(630);
299:
300: begin

Line 310: from pa_budget_types

306: x_err_stage := 'get budget amount code <' || x_budget_type_code || '>' ;
307:
308: select budget_amount_code
309: into x_budget_amount_code
310: from pa_budget_types
311: where budget_type_code = x_budget_type_code;
312:
313: x_err_stage := 'get default budget entry method <'
314: || to_char(x_project_id) || '>' ;

Line 372: from pa_budget_types

368: x_budget_type_code := NULL;
369:
370: select budget_type_code
371: into x_budget_type_code
372: from pa_budget_types
373: where budget_type = x_budget_type;
374:
375: return x_budget_type_code;
376:

Line 528: from pa_budget_versions bv, pa_budget_types bt

524: into dummy
525: from dual
526: where exists
527: (select 1
528: from pa_budget_versions bv, pa_budget_types bt
529: where bv.project_id = x_project_id
530: and bv.budget_type_code is NOT NULL -- This must be specified for r11.5.7 Budgets Model
531: and bv.budget_type_code = bt.budget_type_code
532: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 585: from pa_budget_versions bv, pa_budget_types bt

581: into dummy
582: from dual
583: where exists
584: (select 1
585: from pa_budget_versions bv, pa_budget_types bt
586: where bv.project_id = x_project_id
587: and bv.budget_type_code = x_budget_type_code
588: and bv.budget_type_code = bt.budget_type_code
589: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 635: from pa_budget_versions bv, pa_budget_types bt

631: into dummy
632: from dual
633: where exists
634: (select 1
635: from pa_budget_versions bv, pa_budget_types bt
636: where bv.project_id = x_project_id
637: and bv.budget_type_code = x_budget_type_code
638: and bv.budget_type_code = bt.budget_type_code
639: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 809: from pa_budget_versions bv, pa_budget_types bt

805: into dummy
806: from dual
807: where exists
808: (select 1
809: from pa_budget_versions bv, pa_budget_types bt
810: where bv.project_id = x_project_id
811: and bv.budget_type_code = x_budget_type_code
812: and bv.budget_type_code = bt.budget_type_code
813: and nvl(bt.plan_type,'BUDGET') = 'BUDGET'

Line 955: , pa_budget_types bt

951: from dual
952: where exists
953: (select 1
954: from pa_budget_versions bv
955: , pa_budget_types bt
956: , pa_resource_assignments a
957: where a.task_id = x_task_id
958: and bv.budget_version_id = a.budget_version_id
959: and bv.budget_type_code is NOT NULL -- This must be specified for r11.5.7 Budgets Model

Line 1019: , pa_budget_types bt

1015: from dual
1016: where exists
1017: (select 1
1018: from pa_budget_versions bv
1019: , pa_budget_types bt
1020: , pa_resource_assignments a
1021: where a.task_id = x_task_id
1022: and bv.budget_version_id = a.budget_version_id
1023: and bv.budget_type_code = x_budget_type_code

Line 1075: , pa_budget_types bt

1071: from dual
1072: where exists
1073: (select 1
1074: from pa_budget_versions bv
1075: , pa_budget_types bt
1076: , pa_resource_assignments a
1077: where a.task_id = x_task_id
1078: and bv.budget_version_id = a.budget_version_id
1079: and bv.budget_type_code = x_budget_type_code

Line 1278: , pa_budget_types bt

1274: from dual
1275: where exists
1276: (select 1
1277: from pa_budget_versions bv
1278: , pa_budget_types bt
1279: , pa_tasks t
1280: , pa_resource_assignments a
1281: where a.budget_version_id = bv.budget_version_id
1282: and a.task_id = t.task_id

Line 2688: l_approved_code pa_budget_types.budget_type_code%TYPE := NULL;

2684: l_ext_err_msg_count NUMBER := 0;
2685:
2686:
2687: -- For FP Model
2688: l_approved_code pa_budget_types.budget_type_code%TYPE := NULL;
2689: l_Return_Status VARCHAR2(1) :=NULL;
2690: l_Msg_Data VARCHAR2(2000) :=NULL;
2691: l_Msg_Count NUMBER := 0;
2692:

Line 3049: l_gl_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;

3045: l_Dual_Bdgt_Cntrl_Flag VARCHAR2(1) :=NULL;
3046: l_CC_Budget_Version_id NUMBER := 0;
3047: l_gl_new_base_ver_id NUMBER := 0;
3048: l_cc_new_base_ver_id NUMBER := 0;
3049: l_gl_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;
3050: l_cc_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;
3051:
3052: l_Return_Status VARCHAR2(1) :=NULL;
3053: l_Msg_Data VARCHAR2(2000) :=NULL;

Line 3050: l_cc_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;

3046: l_CC_Budget_Version_id NUMBER := 0;
3047: l_gl_new_base_ver_id NUMBER := 0;
3048: l_cc_new_base_ver_id NUMBER := 0;
3049: l_gl_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;
3050: l_cc_budget_type_code pa_budget_types.budget_type_code%TYPE :=NULL;
3051:
3052: l_Return_Status VARCHAR2(1) :=NULL;
3053: l_Msg_Data VARCHAR2(2000) :=NULL;
3054: l_Msg_Count NUMBER := 0;

Line 3729: from pa_budget_types

3725: Function get_budget_amount_code (x_budget_type_code in varchar2)
3726: return varchar2 is
3727: cursor get_budget_amount_code is
3728: select budget_amount_code
3729: from pa_budget_types
3730: where budget_type_code = x_budget_type_code;
3731:
3732: v_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
3733:

Line 3732: v_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;

3728: select budget_amount_code
3729: from pa_budget_types
3730: where budget_type_code = x_budget_type_code;
3731:
3732: v_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
3733:
3734: Begin
3735: open get_budget_amount_code ;
3736: fetch get_budget_amount_code into v_budget_amount_code;