1 PACKAGE BODY PA_ONLINE_EXP AS
2 /* $Header: PAXONTEB.pls 120.2 2005/08/09 04:31:32 avajain ship $ */
3
4 PROCEDURE BUILD_DENORM_TABLE (X_exp_id IN NUMBER,
5 X_exp_class_code IN VARCHAR2,
6 X_exp_status_code IN VARCHAR2,
7 X_exp_source_code IN VARCHAR2,
8 X_person_id IN NUMBER)
9 IS
10
11
12 BEGIN
13
14 Null;
15
16 END BUILD_DENORM_TABLE;
17
18 PROCEDURE SET_DAY
19
20 IS
21
22 BEGIN
23
24 Null;
25
26 END SET_DAY;
27
28 FUNCTION GET_DAY(X_matrix_column IN NUMBER) return varchar2
29 IS
30
31 BEGIN
32
33 RETURN(NULL) ;
34
35 END GET_DAY;
36
37 PROCEDURE GET_NUM_DAYOFWEEK ( X_name_dayof_week IN VARCHAR2,
38 X_num_dayof_week OUT NOCOPY VARCHAR2)
39 IS
40
41 BEGIN
42
43 Null;
44
45 END GET_NUM_DAYOFWEEK;
46
47 PROCEDURE FIND_DELETE_EXP_ITEMS(x_denorm_id IN NUMBER,
48 X_COLUMN IN NUMBER,
49 X_status OUT NOCOPY NUMBER)
50
51 IS
52
53 BEGIN
54
55 Null;
56
57 END FIND_DELETE_EXP_ITEMS;
58
59
60 FUNCTION GET_LAST_RTE_COMMENT (X_exp_id IN NUMBER) RETURN VARCHAR2
61 IS
62
63 BEGIN
64
65 RETURN ( Null );
66
67 END GET_LAST_RTE_COMMENT;
68
69 FUNCTION GET_EXP_TOTAL_HOURS( X_exp_id IN NUMBER,
70 X_exp_class_code IN VARCHAR2) RETURN NUMBER
71
72 IS
73
74 BEGIN
75
76 Return ( 0 );
77
78 END GET_EXP_TOTAL_HOURS;
79
80 FUNCTION GET_EI_TOTAL_HOURS(X_exp_id IN NUMBER,
81 X_exp_class_code IN VARCHAR2) RETURN NUMBER
82 IS
83
84 BEGIN
85
86 RETURN( 0 ) ;
87
88 END GET_EI_TOTAL_HOURS;
89
90 FUNCTION GET_DENORM_TOTAL_HOURS (x_exp_id IN NUMBER,
91 x_exp_class_code IN VARCHAR2) RETURN NUMBER
92
93 IS
94
95 BEGIN
96
97 RETURN( 0 );
98
99 END GET_DENORM_TOTAL_HOURS;
100
101 FUNCTION GET_EXP_TOTAL_COST( X_exp_id IN NUMBER,
102 X_exp_class_code IN VARCHAR2) RETURN NUMBER
103 IS
104
105 BEGIN
106
107 RETURN ( 0 );
108
109 END GET_EXP_TOTAL_COST;
110
111 FUNCTION GET_EI_TOTAL_COST(X_exp_id IN NUMBER,
112 X_exp_class_code IN VARCHAR2) RETURN NUMBER
113 IS
114
115 BEGIN
116
117 RETURN( 0 ) ;
118
119 END GET_EI_TOTAL_COST;
120
121 FUNCTION GET_DENORM_TOTAL_COST (x_exp_id IN NUMBER,
122 x_exp_class_code IN VARCHAR2) RETURN NUMBER
123
124 IS
125
126 BEGIN
127
128 RETURN( 0 );
129
130 END GET_DENORM_TOTAL_COST;
131
132 FUNCTION GET_EXP_TRANS ( X_exp_class_code IN VARCHAR2) RETURN VARCHAR2
133
134 IS
135
136 BEGIN
137
138 RETURN ( NULL ) ;
139
140 END GET_EXP_TRANS;
141
142 FUNCTION GET_EXP_SRC (X_exp_class_code IN VARCHAR2,
143 X_exp_group IN VARCHAR2,
144 X_pte_ref IN NUMBER) RETURN VARCHAR2
145 IS
146
147 BEGIN
148
149 RETURN ( NULL );
150
151 END GET_EXP_SRC;
152
153 FUNCTION GET_EXP_SRC_CODE (X_exp_class_code IN VARCHAR2,
154 X_exp_group IN VARCHAR2,
155 X_pte_ref IN NUMBER) RETURN VARCHAR2
156 IS
157
158 BEGIN
159
160 RETURN ( NULL );
161
162 END GET_EXP_SRC_CODE;
163
164
165 PROCEDURE STORE_REVERSE_ITEMS (X_exp_item_id IN NUMBER)
166 IS
167
168 BEGIN
169
170 Null;
171
172 END STORE_REVERSE_ITEMS;
173
174 PROCEDURE PROCESS_REVERSE_ITEMS (X_Exp_id IN NUMBER,
175 X_entered_by_person_id IN NUMBER,
176 X_user_id IN NUMBER,
177 X_new_exp_id in NUMBER,
178 X_status OUT NOCOPY VARCHAR2)
179 IS
180
181 BEGIN
182
183 Null;
184
185 END PROCESS_REVERSE_ITEMS;
186
187 FUNCTION GET_OLD_EI_COMMENT(x_exp_item_id IN NUMBER) RETURN VARCHAR2
188 IS
189
190 BEGIN
191
192 RETURN ( NULL );
193
194 END GET_OLD_EI_COMMENT;
195
196 FUNCTION GET_EXPREP_PAID_AMT (X_exp_id IN NUMBER) RETURN NUMBER
197
198 IS
199
200 BEGIN
201
202 RETURN(0);
203
204 END GET_EXPREP_PAID_AMT;
205
206 PROCEDURE SET_ADMIN_PERSON_ID (X_person_id IN NUMBER)
207 IS
208
209 BEGIN
210
211 Null;
212
213 END SET_ADMIN_PERSON_ID;
214
215 FUNCTION GetAdminPersonId RETURN NUMBER
216 IS
217
218 BEGIN
219
220 RETURN (Null);
221
222 END GetAdminPersonId;
223
224 FUNCTION Get_wte_reference (X_exp_group IN VARCHAR2,
225 X_exp_class_code IN VARCHAR2 )RETURN VARCHAR2
226
227 IS
228
229 BEGIN
230
231 RETURN ( NULL );
232
233 END Get_Wte_Reference;
234
235 PROCEDURE INSERT_PA_EI_DENORM_REC (
236 x_exp_id IN NUMBER,
237 x_denorm_id IN NUMBER,
238 x_person_id IN NUMBER,
239 x_project_id IN NUMBER,
240 x_task_id IN NUMBER,
241 x_billable_flag IN VARCHAR2,
242 x_expenditure_type IN VARCHAR2,
243 x_default_sys_link_func IN VARCHAR2,
244 x_unit_of_measure_code IN VARCHAR2,
245 x_unit_of_measure IN VARCHAR2,
246 x_expenditure_item_id_1 IN NUMBER,
247 x_expenditure_item_date_1 IN DATE,
248 x_quantity_1 IN NUMBER,
249 x_system_linkage_function_1 IN VARCHAR2,
250 x_non_labor_resource_1 IN VARCHAR2,
251 x_organization_id_1 IN NUMBER,
252 x_override_to_org_id_1 IN NUMBER,
253 x_raw_cost_1 IN NUMBER,
254 x_raw_cost_rate_1 IN NUMBER,
255 x_attribute_category_1 IN VARCHAR2,
256 x_attribute1_1 IN VARCHAR2,
257 x_attribute1_2 IN VARCHAR2,
258 x_attribute1_3 IN VARCHAR2,
259 x_attribute1_4 IN VARCHAR2,
260 x_attribute1_5 IN VARCHAR2,
261 x_attribute1_6 IN VARCHAR2,
262 x_attribute1_7 IN VARCHAR2,
263 x_attribute1_8 IN VARCHAR2,
264 x_attribute1_9 IN VARCHAR2,
265 x_attribute1_10 IN VARCHAR2,
266 x_orig_transaction_reference_1 IN VARCHAR2,
267 x_adj_expenditure_item_id_1 IN NUMBER,
268 x_net_zero_adjustment_flag_1 IN VARCHAR2,
269 x_expenditure_comment_1 IN VARCHAR2,
270 x_expenditure_item_id_2 IN NUMBER,
271 x_expenditure_item_date_2 IN DATE,
272 x_quantity_2 IN NUMBER,
273 x_system_linkage_function_2 IN VARCHAR2,
274 x_non_labor_resource_2 IN VARCHAR2,
275 x_organization_id_2 IN NUMBER,
276 x_override_to_org_id_2 IN NUMBER,
277 x_raw_cost_2 IN NUMBER,
278 x_raw_cost_rate_2 IN NUMBER,
279 x_attribute_category_2 IN VARCHAR2,
280 x_attribute2_1 IN VARCHAR2,
281 x_attribute2_2 IN VARCHAR2,
282 x_attribute2_3 IN VARCHAR2,
283 x_attribute2_4 IN VARCHAR2,
284 x_attribute2_5 IN VARCHAR2,
285 x_attribute2_6 IN VARCHAR2,
286 x_attribute2_7 IN VARCHAR2,
287 x_attribute2_8 IN VARCHAR2,
288 x_attribute2_9 IN VARCHAR2,
289 x_attribute2_10 IN VARCHAR2,
290 x_orig_transaction_reference_2 IN VARCHAR2,
291 x_adj_expenditure_item_id_2 IN NUMBER,
292 x_net_zero_adjustment_flag_2 IN VARCHAR2,
293 x_expenditure_comment_2 IN VARCHAR2,
294 x_expenditure_item_id_3 IN NUMBER,
295 x_expenditure_item_date_3 IN DATE,
296 x_quantity_3 IN NUMBER,
297 x_system_linkage_function_3 IN VARCHAR2,
298 x_non_labor_resource_3 IN VARCHAR2,
299 x_organization_id_3 IN NUMBER,
300 x_override_to_org_id_3 IN NUMBER,
301 x_raw_cost_3 IN NUMBER,
302 x_raw_cost_rate_3 IN NUMBER,
303 x_attribute_category_3 IN VARCHAR2,
304 x_attribute3_1 IN VARCHAR2,
305 x_attribute3_2 IN VARCHAR2,
306 x_attribute3_3 IN VARCHAR2,
307 x_attribute3_4 IN VARCHAR2,
308 x_attribute3_5 IN VARCHAR2,
309 x_attribute3_6 IN VARCHAR2,
310 x_attribute3_7 IN VARCHAR2,
311 x_attribute3_8 IN VARCHAR2,
312 x_attribute3_9 IN VARCHAR2,
313 x_attribute3_10 IN VARCHAR2,
314 x_orig_transaction_reference_3 IN VARCHAR2,
315 x_adj_expenditure_item_id_3 IN NUMBER,
316 x_net_zero_adjustment_flag_3 IN VARCHAR2,
317 x_expenditure_comment_3 IN VARCHAR2,
318 x_expenditure_item_id_4 IN NUMBER,
319 x_expenditure_item_date_4 IN DATE,
320 x_quantity_4 IN NUMBER,
321 x_system_linkage_function_4 IN VARCHAR2,
322 x_non_labor_resource_4 IN VARCHAR2,
323 x_organization_id_4 IN NUMBER,
324 x_override_to_org_id_4 IN NUMBER,
325 x_raw_cost_4 IN NUMBER,
326 x_raw_cost_rate_4 IN NUMBER,
327 x_attribute_category_4 IN VARCHAR2,
328 x_attribute4_1 IN VARCHAR2,
329 x_attribute4_2 IN VARCHAR2,
330 x_attribute4_3 IN VARCHAR2,
331 x_attribute4_4 IN VARCHAR2,
332 x_attribute4_5 IN VARCHAR2,
333 x_attribute4_6 IN VARCHAR2,
334 x_attribute4_7 IN VARCHAR2,
335 x_attribute4_8 IN VARCHAR2,
336 x_attribute4_9 IN VARCHAR2,
337 x_attribute4_10 IN VARCHAR2,
338 x_orig_transaction_reference_4 IN VARCHAR2,
339 x_adj_expenditure_item_id_4 IN NUMBER,
340 x_net_zero_adjustment_flag_4 IN VARCHAR2,
341 x_expenditure_comment_4 IN VARCHAR2,
342 x_expenditure_item_id_5 IN NUMBER,
343 x_expenditure_item_date_5 IN DATE,
344 x_quantity_5 IN NUMBER,
345 x_system_linkage_function_5 IN VARCHAR2,
346 x_non_labor_resource_5 IN VARCHAR2,
347 x_organization_id_5 IN NUMBER,
348 x_override_to_org_id_5 IN NUMBER,
349 x_raw_cost_5 IN NUMBER,
350 x_raw_cost_rate_5 IN NUMBER,
351 x_attribute_category_5 IN VARCHAR2,
352 x_attribute5_1 IN VARCHAR2,
353 x_attribute5_2 IN VARCHAR2,
354 x_attribute5_3 IN VARCHAR2,
355 x_attribute5_4 IN VARCHAR2,
356 x_attribute5_5 IN VARCHAR2,
357 x_attribute5_6 IN VARCHAR2,
358 x_attribute5_7 IN VARCHAR2,
359 x_attribute5_8 IN VARCHAR2,
360 x_attribute5_9 IN VARCHAR2,
361 x_attribute5_10 IN VARCHAR2,
362 x_orig_transaction_reference_5 IN VARCHAR2,
363 x_adj_expenditure_item_id_5 IN NUMBER,
364 x_net_zero_adjustment_flag_5 IN VARCHAR2,
365 x_expenditure_comment_5 IN VARCHAR2,
366 x_expenditure_item_id_6 IN NUMBER,
367 x_expenditure_item_date_6 IN DATE,
368 x_quantity_6 IN NUMBER,
369 x_system_linkage_function_6 IN VARCHAR2,
370 x_non_labor_resource_6 IN VARCHAR2,
371 x_organization_id_6 IN NUMBER,
372 x_override_to_org_id_6 IN NUMBER,
373 x_raw_cost_6 IN NUMBER,
374 x_raw_cost_rate_6 IN NUMBER,
375 x_attribute_category_6 IN VARCHAR2,
376 x_attribute6_1 IN VARCHAR2,
377 x_attribute6_2 IN VARCHAR2,
378 x_attribute6_3 IN VARCHAR2,
379 x_attribute6_4 IN VARCHAR2,
380 x_attribute6_5 IN VARCHAR2,
381 x_attribute6_6 IN VARCHAR2,
382 x_attribute6_7 IN VARCHAR2,
383 x_attribute6_8 IN VARCHAR2,
384 x_attribute6_9 IN VARCHAR2,
385 x_attribute6_10 IN VARCHAR2,
386 x_orig_transaction_reference_6 IN VARCHAR2,
387 x_adj_expenditure_item_id_6 IN NUMBER,
388 x_net_zero_adjustment_flag_6 IN VARCHAR2,
389 x_expenditure_comment_6 IN VARCHAR2,
390 x_expenditure_item_id_7 IN NUMBER,
391 x_expenditure_item_date_7 IN DATE,
392 x_quantity_7 IN NUMBER,
393 x_system_linkage_function_7 IN VARCHAR2,
394 x_non_labor_resource_7 IN VARCHAR2,
395 x_organization_id_7 IN NUMBER,
396 x_override_to_org_id_7 IN NUMBER,
397 x_raw_cost_7 IN NUMBER,
398 x_raw_cost_rate_7 IN NUMBER,
399 x_attribute_category_7 IN VARCHAR2,
400 x_attribute7_1 IN VARCHAR2,
401 x_attribute7_2 IN VARCHAR2,
402 x_attribute7_3 IN VARCHAR2,
403 x_attribute7_4 IN VARCHAR2,
404 x_attribute7_5 IN VARCHAR2,
405 x_attribute7_6 IN VARCHAR2,
406 x_attribute7_7 IN VARCHAR2,
407 x_attribute7_8 IN VARCHAR2,
408 x_attribute7_9 IN VARCHAR2,
409 x_attribute7_10 IN VARCHAR2,
410 x_orig_transaction_reference_7 IN VARCHAR2,
411 x_adj_expenditure_item_id_7 IN NUMBER,
412 x_net_zero_adjustment_flag_7 IN VARCHAR2,
413 x_expenditure_comment_7 IN VARCHAR2,
414 x_total_qty IN NUMBER,
415 x_total_amount IN NUMBER,
416 x_created_by IN NUMBER,
417 x_creation_date IN DATE,
418 x_last_update_date IN DATE,
419 x_last_updated_by IN NUMBER,
420 x_last_update_login IN NUMBER,
421 x_job_id_1 IN NUMBER,
422 x_job_id_2 IN NUMBER,
423 x_job_id_3 IN NUMBER,
424 x_job_id_4 IN NUMBER,
425 x_job_id_5 IN NUMBER,
426 x_job_id_6 IN NUMBER,
427 x_job_id_7 IN NUMBER)
428
429 IS
430
431 BEGIN
432
433 NULL;
434
435 END INSERT_PA_EI_DENORM_REC;
436
437
438
439 END PA_ONLINE_EXP;