[Home] [Help]
PACKAGE: APPS.PA_FORECAST_ITEMS_UTILS
Source
1 PACKAGE PA_FORECAST_ITEMS_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PARFIUTS.pls 120.2 2005/10/27 06:14:34 nkumbi noship $ */
3
4 FUNCTION Get_Next_ForeCast_Item_ID RETURN NUMBER;
5
6
7 --
8 -- Function : Get_Next_ForeCast_Item_ID
9 -- Purpose : This function gets the unique identifier for the forecast item.
10 -- Parameters :
11 --
12
13
14
15 FUNCTION Set_User_Lock ( p_source_id IN NUMBER,
16 p_lock_for IN VARCHAR2) RETURN NUMBER;
17
18 --
19 -- Function : Set_User_Lock
20 -- Purpose : This function will set and acquire the user lock.
21 -- Parameters :
22 --
23
24 FUNCTION Release_User_Lock (p_source_id IN NUMBER,
25 p_lock_for IN VARCHAR2) RETURN NUMBER;
26
27 --
28 -- Function : Release_User_Lock
29 -- Purpose : This procedure will release user lock.
30 -- Parameters :
31 --
32
33 PROCEDURE allocate_unique(p_lock_name IN VARCHAR2,
34 p_lock_handle OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
35
36 PROCEDURE log_message (p_log_msg IN VARCHAR2) ;
37
38 --
39 -- Procedure : log_message
40 -- Purpose : This procedure prints the text which is being passed as the input.
41 -- Parameters :
42 --
43
44
45 PROCEDURE Get_Resource_Asgn_Schedules (
46 p_resource_id IN NUMBER,
47 p_start_date IN DATE,
48 p_end_date IN DATE,
49 x_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
50 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
52 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
53
54
55
56 --
57 -- Procedure : Get_Resource_Asgn_Schedules
58 -- Purpose : This procedure gets the schedule related to the resource assignment.
59 -- Parameters :
60 --
61
62
63 PROCEDURE Get_Assignment_Schedule(p_assignment_id IN NUMBER,
64 p_start_date IN DATE ,
65 p_end_date IN DATE,
66 p_process_mode IN VARCHAR2,
67 X_ScheduleTab OUT NOCOPY PA_FORECAST_GLOB.ScheduleTabTyp, /* 2674619 - Nocopy change */
68 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
71
72
73
74 --
75 -- Procedure : Get_Assignment_Schedule
76 -- Purpose : This procedure will get all the schedule for the given assignment id.
77 -- Parameters :
78 --
79
80
81
82 FUNCTION Get_Period_Set_Name(p_org_id NUMBER) RETURN VARCHAR2;
83
84 --
85 -- Function : Get_Period_Set_Name
86 -- Purpose : To get the Period name for OU.
87 -- Parameters :
88 --
89
90
91 PROCEDURE Get_Work_Type_Details(p_work_type_id IN NUMBER,
92 x_BillableFlag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93 x_ResUtilPercentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
94 x_OrgUtilPercentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
95 x_ResUtilCategoryID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
96 x_OrgUtilCategoryID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
97 x_ReduceCapacityFlag OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
98
99 --
100 -- Procedure Get_Work_Type_Details
101 -- Purpose To get detail for the passed work type
102 -- Parameters
103 --
104
105
106 PROCEDURE Get_PA_Period_Name(p_org_id IN NUMBER,
107 p_start_date IN DATE,
108 p_end_date IN DATE,
109 x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
110 x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
111 x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) ; /* 2674619 - Nocopy change */
112
113
114 --
115 -- Procedure Get_PA_Period_Name
116 -- Purpose To get the PA Period name for OU
117 -- Parameters
118 --
119
120
121 PROCEDURE Get_GL_Period_Name(p_org_id IN NUMBER,
122 p_start_date IN DATE,
123 p_end_date IN DATE,
124 x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
125 x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
126 x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp); /* 2674619 - Nocopy change */
127
128 --
129 -- Procedure Get_GL_Period_Name
130 -- Purpose To get the GL Period name for OU
131 -- Parameters
132 --
133
134
135 PROCEDURE Get_Resource_OU(p_resource_id IN NUMBER,
136 p_start_date IN DATE,
137 p_end_date IN DATE,
138 x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
139 x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
140 x_ResourceOUTab OUT NOcopy PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
141
142 --
143 -- Procedure Get_Resource_OU
144 -- Purpose To get the Resource OU for a Period
145 -- Parameters
146 --
147
148
149 PROCEDURE Get_Res_Org_And_Job(p_person_id IN NUMBER,
150 p_start_date IN DATE,
151 p_end_date IN DATE,
152 x_StartDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
153 x_EndDateTab OUT NOCOPY PA_FORECAST_GLOB.DateTabTyp, /* 2674619 - Nocopy change */
154 x_ResourceOrganizationIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp, /* 2674619 - Nocopy change */
155 x_ResourceJobIDTab OUT NOCOPY PA_FORECAST_GLOB.NumberTabTyp); /* 2674619 - Nocopy change */
156
157 --
158 -- Procedure Get_Res_Org_And_Job
159 -- Purpose To get the Resource Organization for Period
160 -- Input parameters
161 --
162
163
164 FUNCTION Get_Person_Id(p_resource_id NUMBER) RETURN NUMBER;
165
166 --
167 -- Function Get_Person_Id
168 -- Purpose To get the Person ID for resource Id
169 -- Parameters
170 --
171
172 FUNCTION Get_resource_Id(p_person_id NUMBER) RETURN NUMBER;
173
174 --
175 -- Function Get_resource_Id
176 -- Purpose To get the Person ID for resource Id
177 -- Parameters
178 --
179
180 FUNCTION Get_Resource_Type(p_resource_id NUMBER) RETURN VARCHAR2;
181
182 --
183 -- Function Get_Resource_Type
184 -- Purpose To get the Resource Type for resource Id
185 -- Parameters
186 --
187
188
189 PROCEDURE Get_ForecastOptions( p_org_id IN NUMBER,
190 -- x_include_admin_proj_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895, Bug 4576715
191 x_util_cal_method OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
192 x_bill_unassign_proj_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
193 x_bill_unassign_exp_type_class OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
194 x_bill_unassign_exp_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195 x_nonbill_unassign_proj_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
196 x_nonbill_unassign_exp_typ_cls OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
197 x_nonbill_unassign_exp_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198 x_default_tp_amount_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
199 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
200 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
201 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
202
203 --
204 -- Procedure Get_ForecastOptions
205 -- Purpose To get the all forecast options from pa_forecasting_options_all table
206 -- Parameters
207 --
208
209
210 PROCEDURE Get_Week_Dates_Range_Fc( p_start_date IN DATE,
211 p_end_date IN DATE,
212 x_week_date_range_tab OUT NOCOPY PA_FORECAST_GLOB.WeekDatesRangeFcTabTyp , /* 2674619 - Nocopy change */
213 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
214 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
215 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
216
217
218 --
219 -- Procedure Get_Week_Dates_Range_Fc
220 -- Purpose To get the global week end date
221 -- Parameters
222 --
223 PROCEDURE Check_TPAmountType(
224 p_tp_amount_type_code IN VARCHAR2,
225 p_tp_amount_type_desc IN VARCHAR2,
226 p_check_id_flag IN VARCHAR2,
227 x_tp_amount_type_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
228 x_tp_amount_type_desc OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
230 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
231 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
232
233
234 PROCEDURE Get_Assignment_Default (p_assignment_type IN VARCHAR2,
235 p_project_id IN NUMBER,
236 p_project_role_id IN NUMBER,
237 p_work_type_id IN NUMBER,
238 x_work_type_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
239 x_default_tp_amount_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
240 x_default_job_group_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
241 x_default_job_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
242 x_org_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
243 x_carrying_out_organization_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
244 x_default_assign_exp_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
245 x_default_assign_exp_type_cls OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
246 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
247 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
248 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
249 );
250
251
252 --
253 -- Procedure Get_Assignment_Default
254 -- Purpose This procedure will get the defautl values for the Assignment
255 -- Parameters
256 --
257
258 PROCEDURE Get_Project_Default ( p_assignment_type IN VARCHAR2,
259 p_project_id IN NUMBER,
260 x_work_type_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
261 x_default_tp_amount_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
262 x_org_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
263 x_carrying_out_organization_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
264 x_default_assign_exp_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
265 x_default_assign_exp_type_cls OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
266 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
267 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
268 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
269 );
270
271 PROCEDURE Get_Project_Role_Default (p_assignment_type IN VARCHAR2,
272 p_project_role_id IN NUMBER,
273 x_default_job_group_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
274 x_default_job_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
275 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
276 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
277 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
278 );
279
280 END PA_FORECAST_ITEMS_UTILS;