[Home] [Help]
PACKAGE: APPS.PA_FIN_PLAN_VIEW_GLOBAL
Source
1 PACKAGE pa_fin_plan_view_global AUTHID CURRENT_USER as
2 /* $Header: PARFPSVS.pls 120.1 2005/08/19 16:52:11 mwasowic noship $ */
3
4 G_FP_ORG_ID number;
5 G_FP_VIEW_VERSION_ID number;--:=1830;
6 G_FP_PLAN_TYPE_ID number;
7 G_FP_RA_ID number;--:=5301;
8 G_FP_AMOUNT_TYPE_CODE VARCHAR2(30);--:='COST';
9 G_FP_ADJ_REASON_CODE VARCHAR2(15);--:='REVENUE';
10 G_FP_CURRENCY_CODE VARCHAR2(15);--:='USD';
11 G_FP_CURRENCY_TYPE VARCHAR2(30):='PROJ_FUNCTIONAL';
12 G_FP_VIEW_START_DATE1 date;--:=to_date('01-Mar-02');
13 G_FP_VIEW_START_DATE2 date;--:=to_date('01-Apr_02');
14 G_FP_VIEW_START_DATE3 date;--:=to_date('01-May-02');
15 G_FP_VIEW_START_DATE4 date;--:=to_date('01-Jun-02');
16 G_FP_VIEW_START_DATE5 date;--:=to_date('01-Jul-02');
17 G_FP_VIEW_START_DATE6 date;--:=to_date('01-Aug-02');
18 G_FP_VIEW_START_DATE7 date;--:=to_date('01-Feb-03');
19 G_FP_VIEW_START_DATE8 date;--:=to_date('01-Mar-03');
20 G_FP_VIEW_START_DATE9 date;--:=to_date('01-Apr-03');
21 G_FP_VIEW_START_DATE10 date;--:=to_date('01-May-03');
22 G_FP_VIEW_START_DATE11 date;--:=to_date('01-Jun-03');
23 G_FP_VIEW_START_DATE12 date;--:=to_date('01-Jul-03');
24 G_FP_VIEW_START_DATE13 date;--:=to_date('01-Aug-03');
25 G_FP_VIEW_END_DATE1 date;--:=to_date('31-Mar-02');
26 G_FP_VIEW_END_DATE2 date;--:=to_date('30-Apr-02');
27 G_FP_VIEW_END_DATE3 date;--:=to_date('31-May-02');
28 G_FP_VIEW_END_DATE4 date;--:=to_date('30-Jun-02');
29 G_FP_VIEW_END_DATE5 date;--:=to_date('31-Jul-02');
30 G_FP_VIEW_END_DATE6 date;--:=to_date('31-Aug-02');
31 G_FP_VIEW_END_DATE7 date;--:=to_date('28-Feb-03');
32 G_FP_VIEW_END_DATE8 date;--:=to_date('31-Mar-03');
33 G_FP_VIEW_END_DATE9 date;--:=to_date('30-Apr-03');
34 G_FP_VIEW_END_DATE10 date;--:=to_date('31-May-03');
35 G_FP_VIEW_END_DATE11 date;--:=to_date('30-Jun-03');
36 G_FP_VIEW_END_DATE12 date;--:=to_date('31-Jul-03');
37 G_FP_VIEW_END_DATE13 date;--:=to_date('31-Aug-03');
38 G_FP_PERIOD_TYPE VARCHAR2(30);
39 G_FP_PLAN_START_DATE date;--:=to_date('01-Mar-02');
40 G_FP_PLAN_END_DATE date;--:=to_date('31-Aug-02');
41
42 PROCEDURE pa_fp_get_budget_status_code(
43 p_budget_version_id IN NUMBER,
44 x_budget_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48 );
49
50
51
52 PROCEDURE pa_fp_set_orgfcst_version_id(
53 p_orgfcst_version_id IN NUMBER,
54 p_period_start_date IN VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
57 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 );
59
60
61 PROCEDURE pa_fp_set_Adj_Reason_Code(
62 p_adj_reason_code IN VARCHAR2,
63 x_adj_comments OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
64 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
65 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
66 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67 );
68
69 PROCEDURE pa_fp_viewby_set_globals(
70 p_amount_type_code IN VARCHAR2,
71 p_resource_assignment_id IN NUMBER,
72 p_budget_version_id IN NUMBER,
73 p_start_period IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
76 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77 );
78 PROCEDURE pa_fp_set_periods (
79 p_period_start_date IN VARCHAR2,
80 p_period_type IN VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
82 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
83 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
84
85 );
86 PROCEDURE pa_fp_set_periods_nav ( p_direction IN VARCHAR2,
87 p_num_of_periods IN NUMBER,
88 p_period_type IN VARCHAR2,
89 x_start_date OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
91 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
92 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93 );
94
95
96 PROCEDURE pa_fp_update_tables( p_amount_type_code IN VARCHAR2,
97 p_amount_subtype_code IN VARCHAR2,
98 p_adj_reason_code IN VARCHAR2,
99 p_adj_comments IN VARCHAR2,
100 p_currency_code IN VARCHAR2,
101 p_project_id IN NUMBER,
102 p_period1 IN NUMBER,
103 p_period2 IN NUMBER,
104 p_period3 IN NUMBER,
105 p_period4 IN NUMBER,
106 p_period5 IN NUMBER,
107 p_period6 IN NUMBER,
108 p_period7 IN NUMBER,
109 p_period8 IN NUMBER,
110 p_period9 IN NUMBER,
111 p_period10 IN NUMBER,
112 p_period11 IN NUMBER,
113 p_period12 IN NUMBER,
114 p_period13 IN NUMBER,
115 p_period_type IN VARCHAR2,
116 p_budget_version_id IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
118 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
119 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
120
121
122 FUNCTION Get_Version_ID return Number;
123 FUNCTION Get_Org_ID return Number;
124 FUNCTION Get_Plan_Type_ID return NUMBER;
125 FUNCTION Get_Resource_assignment_ID return NUMBER;
126 FUNCTION Get_Amount_Type_code return VARCHAR2;
127 FUNCTION Get_Adj_Reason_code return VARCHAR2;
128 FUNCTION Get_Currency_Code return VARCHAR2;
129 FUNCTION Get_Currency_Type return VARCHAR2;
130 FUNCTION Get_Period_Start_Date1 return Date;
131 FUNCTION Get_Period_Start_Date2 return Date;
132 FUNCTION Get_Period_Start_Date3 return Date;
133 FUNCTION Get_Period_Start_Date4 return Date;
134 FUNCTION Get_Period_Start_Date5 return Date;
135 FUNCTION Get_Period_Start_Date6 return Date;
136 FUNCTION Get_Period_Start_Date7 return Date;
137 FUNCTION Get_Period_Start_Date8 return Date;
138 FUNCTION Get_Period_Start_Date9 return Date;
139 FUNCTION Get_Period_Start_Date10 return Date;
140 FUNCTION Get_Period_Start_Date11 return Date;
141 FUNCTION Get_Period_Start_Date12 return Date;
142 FUNCTION Get_Period_Start_Date13 return Date;
143 FUNCTION Get_Plan_Start_Date return Date;
144 FUNCTION Get_Plan_End_Date return Date;
145
146
147
148 END pa_fin_plan_view_global;