[Home] [Help]
PACKAGE: APPS.PA_FORECASTITEM_PVT
Source
1 PACKAGE PA_FORECASTITEM_PVT AUTHID CURRENT_USER as
2 --/* $Header: PARFIGPS.pls 120.1 2005/08/29 20:50:39 sunkalya noship $ */
3
4
5 PROCEDURE print_message(p_msg IN varchar2);
6
7 PROCEDURE Create_ForeCast_Item(
8 p_assignment_id IN NUMBER,
9 p_start_date IN DATE DEFAULT NULL,
10 p_end_date IN DATE DEFAULT NULL,
11 p_process_mode IN VARCHAR2,
12 p_gen_res_fi_flag IN VARCHAR2 := 'Y',
13 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
14 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
15 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
16
17 PROCEDURE Create_Forecast_Item(
18 p_resource_id IN NUMBER,
19 p_start_date IN DATE DEFAULT NULL,
20 p_end_date IN DATE DEFAULT NULL,
21 p_process_mode IN VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
23 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
24 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
25
26 PROCEDURE Create_Forecast_Item (
27 p_person_id IN NUMBER,
28 p_start_date IN DATE DEFAULT NULL,
29 p_end_date IN DATE DEFAULT NULL,
30 p_process_mode IN VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
32 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
33 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
34
35 PROCEDURE Create_ForeCast_Item(
36 p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
37 p_process_mode IN VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
39 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
40 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
41
42 PROCEDURE Delete_Forecast_Item (
43 p_assignment_id IN NUMBER,
44 p_resource_id IN NUMBER,
45 p_start_date IN DATE,
46 p_end_date IN DATE,
47 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
48 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
49 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
50
51 PROCEDURE Get_Assignment_Dtls(
52 p_assignment_id IN NUMBER,
53 x_AsgnDtlRec OUT NOCOPY PA_FORECAST_GLOB.AsgnDtlRecord, /* 2674619 - Nocopy change */
54 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
55 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
56 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
57
58 PROCEDURE Get_Project_Dtls(
59 p_project_id IN NUMBER,
60 x_project_org_id OUT NOCOPY NUMBER, --Bug: 4537865
61 x_project_orgn_id OUT NOCOPY NUMBER, --Bug: 4537865
62 x_work_type_id OUT NOCOPY NUMBER, --Bug: 4537865
63 x_project_type_class OUT NOCOPY VARCHAR2, --Bug: 4537865
64 x_project_status_code OUT NOCOPY VARCHAR2, --Bug: 4537865
65 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
66 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
67 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
68
69 PROCEDURE Generate_Requirement_FI(
70 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
71 p_process_mode IN VARCHAR2,
72 p_start_date IN DATE,
73 p_end_date IN DATE,
74 p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
75 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
76 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
77 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
78
79 PROCEDURE Initialize_Day_FI(
80 p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
81 p_process_mode IN VARCHAR2,
82 p_start_date IN DATE,
83 p_end_date IN DATE,
84 x_FIDayTab OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */
85 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
86 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
87 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
88
89 PROCEDURE Build_Day_FI(
90 p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
91 p_start_date IN DATE,
92 p_end_date IN DATE,
93 p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */
94 p_AsgType IN VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
96 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
97 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
98
99 PROCEDURE Reverse_FI_Hdr(
100 p_assignment_id IN NUMBER,
101 p_start_date IN DATE,
102 p_end_date IN DATE,
103 x_old_start_date IN OUT NOCOPY DATE, --Bug: 4537865
104 x_old_end_date IN OUT NOCOPY DATE, --Bug: 4537865
105 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
106 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
107 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
108
109 PROCEDURE Reverse_FI_Dtl(
110 p_assignment_id IN NUMBER,
111 p_start_date IN DATE,
112 p_end_date IN DATE,
113 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
114 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
115 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
116
117 PROCEDURE Fetch_FI_Hdr(
118 p_assignment_id IN NUMBER,
119 p_resource_id IN NUMBER,
120 p_start_date IN DATE,
121 p_end_date IN DATE,
122 x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
123 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
124 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
125 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
126
127 PROCEDURE Fetch_FI_Dtl(
128 p_assignment_id IN NUMBER,
129 p_resource_id IN NUMBER,
130 p_start_date IN DATE,
131 p_end_date IN DATE,
132 x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
133 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
134 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
135 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
136
137 PROCEDURE Build_FI_Hdr_Req(
138 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139 p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140 p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141 x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142 x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
143 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
144 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
145 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
146
147 PROCEDURE Build_FI_Dtl_Req(
148 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149 p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150 p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151 x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152 x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
153 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
154 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
155 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
156
157 PROCEDURE Generate_Assignment_FI(
158 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
159 p_process_mode IN VARCHAR2,
160 p_start_date IN DATE,
161 p_end_date IN DATE,
162 p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
163 x_res_start_date OUT NOCOPY DATE, --Bug: 4537865
164 x_res_end_date OUT NOCOPY DATE, --Bug: 4537865
165 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
166 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
167 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
168
169 PROCEDURE Delete_FI(
170 p_assignment_id IN NUMBER,
171 --Bug: 4537865
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2);
175 --Bug: 4537865
176 PROCEDURE Delete_FI_hdr(
177 p_assignment_id IN NUMBER,
178 --Bug: 4537865
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2);
182 --Bug: 4537865
183
184 PROCEDURE Delete_FI_dtl(
185 p_assignment_id IN NUMBER,
186 --Bug: 4537865
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2);
190 --Bug: 4537865
191
192 PROCEDURE Delete_FI(
193 p_resource_id IN NUMBER,
194 --Bug: 4537865
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2);
198 --Bug: 4537865
199
200 PROCEDURE Delete_FI_hdr(
201 p_resource_id IN NUMBER,
202 --Bug: 4537865
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2);
206 --Bug: 4537865
207
208 PROCEDURE Delete_FI_dtl(
209 p_resource_id IN NUMBER,
210 --Bug: 4537865
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2);
214 --Bug: 4537865
215
216 PROCEDURE Build_FI_Hdr_Asg(
217 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218 p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219 p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220 x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221 x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
222 --Bug: 4537865
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2);
226 --Bug: 4537865
227
228 PROCEDURE Build_FI_Dtl_Asg(
229 p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230 p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231 p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232 x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233 x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
234 --Bug: 4537865
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2);
238 --Bug: 4537865
239
240
241 PROCEDURE Regenerate_Res_Unassigned_FI(
242 p_resource_id IN NUMBER,
243 p_start_date IN OUT NOCOPY DATE, --Bug: 4537865
244 p_end_date IN OUT NOCOPY DATE, --Bug: 4537865
245 p_process_mode IN VARCHAR2,
246 p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
247 p_date_validation IN VARCHAR2 := 'Y',
248 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
249 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
250 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
251
252 PROCEDURE Fetch_FI_Hdr_Res(
253 p_resource_id IN NUMBER,
254 p_start_date IN DATE,
255 p_end_date IN DATE,
256 x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
257 --Bug: 4537865
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2);
261 --Bug: 4537865
262
263 PROCEDURE Fetch_FI_Dtl_Res(
264 p_resource_id IN NUMBER,
265 p_start_date IN DATE,
266 p_end_date IN DATE,
267 x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
268 x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
269 x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
270 x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
271
272 PROCEDURE Build_FI_Hdr_Res(
273 p_resource_id IN NUMBER,
274 p_start_date IN DATE,
275 p_end_date IN DATE,
276 p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
277 p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,
278 x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
279 x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
280 --Bug: 4537865
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2);
284 --Bug: 4537865
285
286 PROCEDURE Build_FI_Dtl_Res(
287 p_resource_id IN NUMBER,
288 p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
289 p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
290 x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
291 x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
292 --Bug: 4537865
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2);
296 --Bug: 4537865
297
298 PROCEDURE Resource_UnAsg_Error_Process(
299 p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
300 p_process_mode IN VARCHAR2,
301 --Bug: 4537865
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2);
305 --Bug: 4537865
306
307 PROCEDURE FI_Error_Process(
308 p_AsgnDtlRec IN PA_FORECAST_GLOB.AsgnDtlRecord,
309 p_Process_Mode IN VARCHAR2,
310 p_Start_date IN DATE,
311 p_End_date IN DATE,
312 --Bug: 4537865
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2);
316 --Bug: 4537865
317
318 PROCEDURE regenrate_orgz_forecast(
319 p_orgz_id IN NUMBER,
320 p_start_date IN DATE,
321 p_end_date IN DATE,
322 p_process_mode IN VARCHAR2,
323 --Bug: 4537865
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2);
327 --Bug: 4537865
328
329 PROCEDURE Regenrate_Unassigned(
330 p_orgz_id IN NUMBER,
331 p_start_date IN DATE,
332 p_end_date IN DATE,
333 p_process_mode IN VARCHAR2,
334 --Bug: 4537865
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2);
338 --Bug: 4537865
339
340 PROCEDURE Regenrate_Asgn_Req(
341 p_orgz_id IN NUMBER,
342 p_start_date IN DATE,
343 p_end_date IN DATE,
344 p_process_mode IN VARCHAR2,
345 --Bug: 4537865
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2);
349 --Bug: 4537865
350
351
352 FUNCTION Chk_Requirement_FI_Exist(
353 p_assignment_id IN NUMBER) RETURN VARCHAR2;
354
355 Function Chk_Assignment_FI_Exist(
356 p_assignment_id IN NUMBER) RETURN VARCHAR2;
357
358 FUNCTION Is_include_Forecast (
359 p_project_status_code IN VARCHAR2,
360 p_action_code IN VARCHAR2) RETURN VARCHAR2;
361
362 FUNCTION Get_AmountTypeID RETURN NUMBER ;
363
364 --Bug No:1967832
365 Procedure Is_Include_Utilisation (p_person_id IN NUMBER,
366 p_item_date IN DATE,
367 --Bug: 4537865
368 x_Start_Date OUT NOCOPY DATE,
369 x_End_Date OUT NOCOPY DATE,
370 x_inc_util_flag OUT NOCOPY VARCHAR2,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2);
374 --Bug: 4537865
375
376
377 Procedure Check_Person_Billable(p_person_id IN NUMBER,
378 p_item_date IN DATE,
379 --Bug: 4537865
380 x_Start_Date OUT NOCOPY DATE,
381 x_End_Date OUT NOCOPY Date,
382 x_billable_flag OUT NOCOPY VARCHAR2,
383 x_return_status OUT NOCOPY VARCHAR2,
384 x_msg_count OUT NOCOPY NUMBER,
385 x_msg_data OUT NOCOPY VARCHAR2);
386 --Bug: 4537865
387
388
389 PROCEDURE copy_requirement_fi (
390 p_requirement_id_tbl IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
391 p_requirement_source_id IN NUMBER,
392 --Bug: 4537865
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_msg_count OUT NOCOPY NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2);
396 --Bug: 4537865
397
398 END PA_FORECASTITEM_PVT;