1 PACKAGE FLM_FLMRFLIN_XMLP_PKG AS
2 /* $Header: FLMRFLINS.pls 120.0 2007/12/24 15:32:00 nchinnam noship $ */
3 P_DEBUG NUMBER;
4
5 P_DATE_FROM DATE;
6
7 P_DATE_TO DATE;
8
9 P_ORG_ID NUMBER;
10
11 P_DATE_FROM_1 varchar2(12);
12
13 P_DATE_TO_1 varchar2(12);
14
15 P_ORGANIZATION VARCHAR2(240);
16
17 P_LINE_FROM VARCHAR2(10);
18
19 P_LINE_TO VARCHAR2(10);
20
21 P_SCH_GROUP VARCHAR2(32767);
22
23 P_ASSY_FLEX VARCHAR2(850);
24
25 P_CONC_REQUEST_ID NUMBER;
26
27 P_REPORT_OPTION NUMBER;
28
29 P_SORT_OPTION NUMBER;
30
31 P_QUERY_ID NUMBER;
32
33 P_REPORT_OPTION_NAME VARCHAR2(32767);
34
35 P_SORT_OPTION_NAME VARCHAR2(32767);
36
37 function BeforeReport return boolean;
38
39 P_ASSY_FLEX2 VARCHAR2(850);
40
41 P_PRECISION NUMBER;
42
43 FUNCTION AFTERREPORT RETURN BOOLEAN;
44
45 FUNCTION AFTERPFORM RETURN BOOLEAN;
46
47 FUNCTION WEEKLY_PLANFORMULA(DAY1_PLAN IN NUMBER
48 ,DAY2_PLAN IN NUMBER
49 ,DAY3_PLAN IN NUMBER
50 ,DAY4_PLAN IN NUMBER
51 ,DAY5_PLAN IN NUMBER
52 ,DAY6_PLAN IN NUMBER
53 ,DAY7_PLAN IN NUMBER) RETURN NUMBER;
54
55 FUNCTION WEEKLY_ACTUALFORMULA(DAY1_ACTUAL IN NUMBER
56 ,DAY2_ACTUAL IN NUMBER
57 ,DAY3_ACTUAL IN NUMBER
58 ,DAY4_ACTUAL IN NUMBER
59 ,DAY5_ACTUAL IN NUMBER
60 ,DAY6_ACTUAL IN NUMBER
61 ,DAY7_ACTUAL IN NUMBER) RETURN NUMBER;
62
63 FUNCTION WEEKLY_VARFORMULA(WEEKLY_PLAN IN NUMBER
64 ,WEEKLY_ACTUAL IN NUMBER) RETURN NUMBER;
65
66 FUNCTION WEEKLY_LINFORMULA(WEEKLY_PLAN IN NUMBER
67 ,WEEKLY_ACTUAL IN NUMBER) RETURN NUMBER;
68
69 FUNCTION DAY1_VAR_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
70 ,DAY1_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
71
72 FUNCTION DAY2_VAR_GROUPFORMULA(DAY2_PLAN_GROUP IN NUMBER
73 ,DAY2_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
74
75 FUNCTION DAY3_VAR_GROUPFORMULA(DAY3_PLAN_GROUP IN NUMBER
76 ,DAY3_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
77
78 FUNCTION DAY4_VAR_GROUPFORMULA(DAY4_PLAN_GROUP IN NUMBER
79 ,DAY4_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
80
81 FUNCTION DAY5_VAR_GROUPFORMULA(DAY5_PLAN_GROUP IN NUMBER
82 ,DAY5_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
83
84 FUNCTION DAY6_VAR_GROUPFORMULA(DAY6_PLAN_GROUP IN NUMBER
85 ,DAY6_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
86
87 FUNCTION DAY7_VAR_GROUPFORMULA(DAY7_PLAN_GROUP IN NUMBER
88 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
89
90 FUNCTION WEEKLY_PLAN_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
91 ,DAY2_PLAN_GROUP IN NUMBER
92 ,DAY3_PLAN_GROUP IN NUMBER
93 ,DAY4_PLAN_GROUP IN NUMBER
94 ,DAY5_PLAN_GROUP IN NUMBER
95 ,DAY6_PLAN_GROUP IN NUMBER
96 ,DAY7_PLAN_GROUP IN NUMBER) RETURN NUMBER;
97
98 FUNCTION WEEKLY_ACTUAL_GROUPFORMULA(DAY1_ACTUAL_GROUP IN NUMBER
99 ,DAY2_ACTUAL_GROUP IN NUMBER
100 ,DAY3_ACTUAL_GROUP IN NUMBER
101 ,DAY4_ACTUAL_GROUP IN NUMBER
102 ,DAY5_ACTUAL_GROUP IN NUMBER
103 ,DAY6_ACTUAL_GROUP IN NUMBER
104 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
105
106 FUNCTION WEEKLY_VAR_GROUPFORMULA(WEEKLY_PLAN_GROUP IN NUMBER
107 ,WEEKLY_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
108
109 FUNCTION WEEKLY_LIN_GROUPFORMULA(WEEKLY_PLAN_GROUP IN NUMBER
110 ,WEEKLY_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
111
112 FUNCTION DAY1_LIN_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
113 ,DAY1_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
114
115 FUNCTION DAY2_LIN_GROUPFORMULA(DAY2_PLAN_GROUP IN NUMBER
116 ,DAY2_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
117
118 FUNCTION DAY3_LIN_GROUPFORMULA(DAY3_PLAN_GROUP IN NUMBER
119 ,DAY3_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
120
121 FUNCTION DAY4_LIN_GROUPFORMULA(DAY4_PLAN_GROUP IN NUMBER
122 ,DAY4_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
123
124 FUNCTION DAY5_LIN_GROUPFORMULA(DAY5_PLAN_GROUP IN NUMBER
125 ,DAY5_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
126
127 FUNCTION DAY6_LIN_GROUPFORMULA(DAY6_PLAN_GROUP IN NUMBER
128 ,DAY6_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
129
130 FUNCTION DAY7_LIN_GROUPFORMULA(DAY7_PLAN_GROUP IN NUMBER
131 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER;
132
133 FUNCTION DAY1_VAR_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
134 ,DAY1_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
135
136 FUNCTION DAY2_VAR_LINEFORMULA(DAY2_PLAN_LINE IN NUMBER
137 ,DAY2_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
138
139 FUNCTION DAY3_VAR_LINEFORMULA(DAY3_PLAN_LINE IN NUMBER
140 ,DAY3_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
141
142 FUNCTION DAY4_VAR_LINEFORMULA(DAY4_PLAN_LINE IN NUMBER
143 ,DAY4_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
144
145 FUNCTION DAY5_VAR_LINEFORMULA(DAY5_PLAN_LINE IN NUMBER
146 ,DAY5_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
147
148 FUNCTION DAY6_VAR_LINEFORMULA(DAY6_PLAN_LINE IN NUMBER
149 ,DAY6_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
150
151 FUNCTION DAY7_VAR_LINEFORMULA(DAY7_PLAN_LINE IN NUMBER
152 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
153
154 FUNCTION WEEKLY_VAR_LINEFORMULA(WEEKLY_PLAN_LINE IN NUMBER
155 ,WEEKLY_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
156
157 FUNCTION DAY1_LIN_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
158 ,DAY1_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
159
160 FUNCTION DAY2_LIN_LINEFORMULA(DAY2_PLAN_LINE IN NUMBER
161 ,DAY2_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
162
163 FUNCTION DAY3_LIN_LINEFORMULA(DAY3_PLAN_LINE IN NUMBER
164 ,DAY3_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
165
166 FUNCTION DAY4_LIN_LINEFORMULA(DAY4_PLAN_LINE IN NUMBER
167 ,DAY4_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
168
169 FUNCTION DAY5_LIN_LINEFORMULA(DAY5_PLAN_LINE IN NUMBER
170 ,DAY5_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
171
172 FUNCTION DAY6_LIN_LINEFORMULA(DAY6_PLAN_LINE IN NUMBER
173 ,DAY6_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
174
175 FUNCTION DAY7_LIN_LINEFORMULA(DAY7_PLAN_LINE IN NUMBER
176 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
177
178 FUNCTION WEEKLY_LIN_LINEFORMULA(WEEKLY_PLAN_LINE IN NUMBER
179 ,WEEKLY_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
180
181 FUNCTION WEEKLY_PLAN_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
182 ,DAY2_PLAN_LINE IN NUMBER
183 ,DAY3_PLAN_LINE IN NUMBER
184 ,DAY4_PLAN_LINE IN NUMBER
185 ,DAY5_PLAN_LINE IN NUMBER
186 ,DAY6_PLAN_LINE IN NUMBER
187 ,DAY7_PLAN_LINE IN NUMBER) RETURN NUMBER;
188
189 FUNCTION WEEKLY_ACTUAL_LINEFORMULA(DAY1_ACTUAL_LINE IN NUMBER
190 ,DAY2_ACTUAL_LINE IN NUMBER
191 ,DAY3_ACTUAL_LINE IN NUMBER
192 ,DAY4_ACTUAL_LINE IN NUMBER
193 ,DAY5_ACTUAL_LINE IN NUMBER
194 ,DAY6_ACTUAL_LINE IN NUMBER
195 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER;
196
197 FUNCTION WEEKLY_PLAN_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
198 ,DAY2_PLAN_WEEK IN NUMBER
199 ,DAY3_PLAN_WEEK IN NUMBER
200 ,DAY4_PLAN_WEEK IN NUMBER
201 ,DAY5_PLAN_WEEK IN NUMBER
202 ,DAY6_PLAN_WEEK IN NUMBER
203 ,DAY7_PLAN_WEEK IN NUMBER) RETURN NUMBER;
204
205 FUNCTION WEEKLY_ACTUAL_WEEKFORMULA(DAY1_ACTUAL_WEEK IN NUMBER
206 ,DAY2_ACTUAL_WEEK IN NUMBER
207 ,DAY3_ACTUAL_WEEK IN NUMBER
208 ,DAY4_ACTUAL_WEEK IN NUMBER
209 ,DAY5_ACTUAL_WEEK IN NUMBER
210 ,DAY6_ACTUAL_WEEK IN NUMBER
211 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
212
213 FUNCTION DAY1_VAR_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
214 ,DAY1_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
215
216 FUNCTION DAY2_VAR_WEEKFORMULA(DAY2_PLAN_WEEK IN NUMBER
217 ,DAY2_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
218
219 FUNCTION DAY3_VAR_WEEKFORMULA(DAY3_PLAN_WEEK IN NUMBER
220 ,DAY3_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
221
222 FUNCTION DAY4_VAR_WEEKFORMULA(DAY4_PLAN_WEEK IN NUMBER
223 ,DAY4_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
224
225 FUNCTION DAY5_VAR_WEEKFORMULA(DAY5_PLAN_WEEK IN NUMBER
226 ,DAY5_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
227
228 FUNCTION DAY6_VAR_WEEKFORMULA(DAY6_PLAN_WEEK IN NUMBER
229 ,DAY6_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
230
231 FUNCTION DAY7_VAR_WEEKFORMULA(DAY7_PLAN_WEEK IN NUMBER
232 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
233
234 FUNCTION WEEKLY_VAR_WEEKFORMULA(WEEKLY_PLAN_WEEK IN NUMBER
235 ,WEEKLY_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
236
237 FUNCTION DAY1_LIN_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
238 ,DAY1_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
239
240 FUNCTION GET_VAR(L_PLAN IN NUMBER
241 ,L_ACTUAL IN NUMBER) RETURN NUMBER;
242
243 FUNCTION DAY2_LIN_WEEKFORMULA(DAY2_PLAN_WEEK IN NUMBER
244 ,DAY2_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
245
246 FUNCTION DAY3_LIN_WEEKFORMULA(DAY3_PLAN_WEEK IN NUMBER
247 ,DAY3_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
248
249 FUNCTION DAY4_LIN_WEEKFORMULA(DAY4_PLAN_WEEK IN NUMBER
250 ,DAY4_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
251
252 FUNCTION DAY5_LIN_WEEKFORMULA(DAY5_PLAN_WEEK IN NUMBER
253 ,DAY5_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
254
255 FUNCTION DAY6_LIN_WEEKFORMULA(DAY6_PLAN_WEEK IN NUMBER
256 ,DAY6_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
257
258 FUNCTION DAY7_LIN_WEEKFORMULA(DAY7_PLAN_WEEK IN NUMBER
259 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
260
261 FUNCTION WEEKLY_LIN_WEEKFORMULA(WEEKLY_PLAN_WEEK IN NUMBER
262 ,WEEKLY_ACTUAL_WEEK IN NUMBER) RETURN NUMBER;
263
264 FUNCTION CF_1FORMULA(DAY1_PLAN2 IN NUMBER
265 ,DAY2_PLAN2 IN NUMBER
266 ,DAY3_PLAN2 IN NUMBER
267 ,DAY4_PLAN2 IN NUMBER
268 ,DAY5_PLAN2 IN NUMBER
269 ,DAY6_PLAN2 IN NUMBER
270 ,DAY7_PLAN2 IN NUMBER) RETURN NUMBER;
271
272 FUNCTION WEEKLY_ACTUAL2FORMULA(DAY1_ACTUAL2 IN NUMBER
273 ,DAY2_ACTUAL2 IN NUMBER
274 ,DAY3_ACTUAL2 IN NUMBER
275 ,DAY4_ACTUAL2 IN NUMBER
276 ,DAY5_ACTUAL2 IN NUMBER
277 ,DAY6_ACTUAL2 IN NUMBER
278 ,DAY7_ACTUAL2 IN NUMBER) RETURN NUMBER;
279
280 FUNCTION WEEKLY_VAR2FORMULA(WEEKLY_PLAN2 IN NUMBER
281 ,WEEKLY_ACTUAL2 IN NUMBER) RETURN NUMBER;
282
283 FUNCTION WEEKLY_LIN2FORMULA(WEEKLY_PLAN2 IN NUMBER
284 ,WEEKLY_ACTUAL2 IN NUMBER) RETURN NUMBER;
285
286 FUNCTION WEEKLY_PLAN_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
287 ,DAY2_PLAN_WEEK2 IN NUMBER
288 ,DAY3_PLAN_WEEK2 IN NUMBER
289 ,DAY4_PLAN_WEEK2 IN NUMBER
290 ,DAY5_PLAN_WEEK2 IN NUMBER
291 ,DAY6_PLAN_WEEK2 IN NUMBER
292 ,DAY7_PLAN_WEEK2 IN NUMBER) RETURN NUMBER;
293
294 FUNCTION WEEKLY_ACTUAL_WEEK2FORMULA(DAY1_ACTUAL_WEEK2 IN NUMBER
295 ,DAY2_ACTUAL_WEEK2 IN NUMBER
296 ,DAY3_ACTUAL_WEEK2 IN NUMBER
297 ,DAY4_ACTUAL_WEEK2 IN NUMBER
298 ,DAY5_ACTUAL_WEEK2 IN NUMBER
299 ,DAY6_ACTUAL_WEEK2 IN NUMBER
300 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
301
302 FUNCTION WEEKLY_VAR_WEEK2FORMULA(WEEKLY_PLAN_WEEK2 IN NUMBER
303 ,WEEKLY_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
304
305 FUNCTION DAY1_VAR_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
306 ,DAY1_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
307
308 FUNCTION DAY2_VAR_WEEK2FORMULA(DAY2_PLAN_WEEK2 IN NUMBER
309 ,DAY2_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
310
311 FUNCTION DAY3_VAR_WEEK2FORMULA(DAY3_PLAN_WEEK2 IN NUMBER
312 ,DAY3_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
313
314 FUNCTION DAY4_VAR_WEEK2FORMULA(DAY4_PLAN_WEEK2 IN NUMBER
315 ,DAY4_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
316
317 FUNCTION DAY5_VAR_WEEK2FORMULA(DAY5_PLAN_WEEK2 IN NUMBER
318 ,DAY5_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
319
320 FUNCTION DAY6_VAR_WEEK2FORMULA(DAY6_PLAN_WEEK2 IN NUMBER
321 ,DAY6_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
322
323 FUNCTION DAY7_VAR_WEEK2FORMULA(DAY7_PLAN_WEEK2 IN NUMBER
324 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
325
326 FUNCTION DAY1_LIN_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
327 ,DAY1_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
328
329 FUNCTION DAY2_LIN_WEEK2FORMULA(DAY2_PLAN_WEEK2 IN NUMBER
330 ,DAY2_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
331
332 FUNCTION DAY3_LIN_WEEK2FORMULA(DAY3_PLAN_WEEK2 IN NUMBER
333 ,DAY3_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
334
335 FUNCTION DAY4_LIN_WEEK2FORMULA(DAY4_PLAN_WEEK2 IN NUMBER
336 ,DAY4_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
337
338 FUNCTION DAY5_LIN_WEEK2FORMULA(DAY5_PLAN_WEEK2 IN NUMBER
339 ,DAY5_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
340
341 FUNCTION DAY6_LIN_WEEK2FORMULA(DAY6_PLAN_WEEK2 IN NUMBER
342 ,DAY6_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
343
344 FUNCTION DAY7_LIN_WEEK2FORMULA(DAY7_PLAN_WEEK2 IN NUMBER
345 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
346
347 FUNCTION WEEKLY_LIN_WEEK2FORMULA(WEEKLY_PLAN_WEEK2 IN NUMBER
348 ,WEEKLY_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER;
349
350 FUNCTION DAY1_VAR_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
351 ,DAY1_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
352
353 FUNCTION DAY2_VAR_GROUP2FORMULA(DAY2_PLAN_GROUP2 IN NUMBER
354 ,DAY2_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
355
356 FUNCTION DAY3_VAR_GROUP2FORMULA(DAY3_PLAN_GROUP2 IN NUMBER
357 ,DAY3_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
358
359 FUNCTION DAY4_VAR_GROUP2FORMULA(DAY4_PLAN_GROUP2 IN NUMBER
360 ,DAY4_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
361
362 FUNCTION DAY5_VAR_GROUP2FORMULA(DAY5_PLAN_GROUP2 IN NUMBER
363 ,DAY5_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
364
365 FUNCTION DAY6_VAR_GROUP2FORMULA(DAY6_PLAN_GROUP2 IN NUMBER
366 ,DAY6_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
367
368 FUNCTION DAY7_VAR_GROUP2FORMULA(DAY7_PLAN_GROUP2 IN NUMBER
369 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
370
371 FUNCTION WEEKLY_VAR_GROUP2FORMULA(WEEKLY_PLAN_GROUP2 IN NUMBER
375 ,DAY2_PLAN_GROUP2 IN NUMBER
372 ,WEEKLY_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
373
374 FUNCTION WEEKLY_PLAN_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
376 ,DAY3_PLAN_GROUP2 IN NUMBER
377 ,DAY4_PLAN_GROUP2 IN NUMBER
378 ,DAY5_PLAN_GROUP2 IN NUMBER
379 ,DAY6_PLAN_GROUP2 IN NUMBER
380 ,DAY7_PLAN_GROUP2 IN NUMBER) RETURN NUMBER;
381
382 FUNCTION WEEKLY_ACTUAL_GROUP2FORMULA(DAY1_ACTUAL_GROUP2 IN NUMBER
383 ,DAY2_ACTUAL_GROUP2 IN NUMBER
384 ,DAY3_ACTUAL_GROUP2 IN NUMBER
385 ,DAY4_ACTUAL_GROUP2 IN NUMBER
386 ,DAY5_ACTUAL_GROUP2 IN NUMBER
387 ,DAY6_ACTUAL_GROUP2 IN NUMBER
388 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
389
390 FUNCTION DAY1_LIN_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
391 ,DAY1_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
392
393 FUNCTION DAY2_LIN_GROUP2FORMULA(DAY2_PLAN_GROUP2 IN NUMBER
394 ,DAY2_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
395
396 FUNCTION DAY3_LIN_GROUP2FORMULA(DAY3_PLAN_GROUP2 IN NUMBER
397 ,DAY3_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
398
399 FUNCTION DAY4_LIN_GROUP2FORMULA(DAY4_PLAN_GROUP2 IN NUMBER
400 ,DAY4_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
401
402 FUNCTION DAY5_LIN_GROUP2FORMULA(DAY5_PLAN_GROUP2 IN NUMBER
403 ,DAY5_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
404
405 FUNCTION DAY6_LIN_GROUP2FORMULA(DAY6_PLAN_GROUP2 IN NUMBER
406 ,DAY6_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
407
408 FUNCTION DAY7_LIN_GROUP2FORMULA(DAY7_PLAN_GROUP2 IN NUMBER
409 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
410
411 FUNCTION WEEKLY_LIN_GROUP2FORMULA(WEEKLY_PLAN_GROUP2 IN NUMBER
412 ,WEEKLY_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER;
413
414 FUNCTION WEEKLY_PLAN_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
415 ,DAY2_PLAN_LINE2 IN NUMBER
416 ,DAY3_PLAN_LINE2 IN NUMBER
417 ,DAY4_PLAN_LINE2 IN NUMBER
418 ,DAY5_PLAN_LINE2 IN NUMBER
419 ,DAY6_PLAN_LINE2 IN NUMBER
420 ,DAY7_PLAN_LINE2 IN NUMBER) RETURN NUMBER;
421
422 FUNCTION WEEKLY_ACTUAL_LINE2FORMULA(DAY1_ACTUAL_LINE2 IN NUMBER
423 ,DAY2_ACTUAL_LINE2 IN NUMBER
424 ,DAY3_ACTUAL_LINE2 IN NUMBER
425 ,DAY4_ACTUAL_LINE2 IN NUMBER
426 ,DAY5_ACTUAL_LINE2 IN NUMBER
427 ,DAY6_ACTUAL_LINE2 IN NUMBER
428 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
429
430 FUNCTION DAY1_VAR_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
431 ,DAY1_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
432
433 FUNCTION DAY2_VAR_LINE2FORMULA(DAY2_PLAN_LINE2 IN NUMBER
434 ,DAY2_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
435
436 FUNCTION DAY3_VAR_LINE2FORMULA(DAY3_PLAN_LINE2 IN NUMBER
437 ,DAY3_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
438
439 FUNCTION DAY4_VAR_LINE2FORMULA(DAY4_PLAN_LINE2 IN NUMBER
440 ,DAY4_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
441
442 FUNCTION DAY5_VAR_LINE2FORMULA(DAY5_PLAN_LINE2 IN NUMBER
443 ,DAY5_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
444
445 FUNCTION DAY6_VAR_LINE2FORMULA(DAY6_PLAN_LINE2 IN NUMBER
446 ,DAY6_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
447
448 FUNCTION DAY7_VAR_LINE2FORMULA(DAY7_PLAN_LINE2 IN NUMBER
449 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
450
451 FUNCTION WEEKLY_VAR_LINE2FORMULA(WEEKLY_PLAN_LINE2 IN NUMBER
452 ,WEEKLY_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
453
454 FUNCTION DAY1_LIN_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
455 ,DAY1_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
456
457 FUNCTION DAY2_LIN_LINE2FORMULA(DAY2_PLAN_LINE2 IN NUMBER
458 ,DAY2_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
459
460 FUNCTION DAY3_LIN_LINE2FORMULA(DAY3_PLAN_LINE2 IN NUMBER
461 ,DAY3_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
462
463 FUNCTION DAY4_LIN_LINE2FORMULA(DAY4_PLAN_LINE2 IN NUMBER
464 ,DAY4_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
465
466 FUNCTION DAY5_LIN_LINE2FORMULA(DAY5_PLAN_LINE2 IN NUMBER
467 ,DAY5_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
468
469 FUNCTION DAY6_LIN_LINE2FORMULA(DAY6_PLAN_LINE2 IN NUMBER
470 ,DAY6_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
471
472 FUNCTION DAY7_LIN_LINE2FORMULA(DAY7_PLAN_LINE2 IN NUMBER
473 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
474
475 FUNCTION WEEKLY_LIN_LINE2FORMULA(WEEKLY_PLAN_LINE2 IN NUMBER
476 ,WEEKLY_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER;
477
478 FUNCTION DAY1_LIN2FORMULA(DAY1_PLAN2 IN NUMBER
479 ,DAY1_ACTUAL2 IN NUMBER) RETURN NUMBER;
480
481 FUNCTION DAY2_LIN2FORMULA(DAY2_PLAN2 IN NUMBER
482 ,DAY2_ACTUAL2 IN NUMBER) RETURN NUMBER;
483
484 FUNCTION DAY3_LIN2FORMULA(DAY3_PLAN2 IN NUMBER
485 ,DAY3_ACTUAL2 IN NUMBER) RETURN NUMBER;
486
487 FUNCTION DAY4_LIN2FORMULA(DAY4_PLAN2 IN NUMBER
488 ,DAY4_ACTUAL2 IN NUMBER) RETURN NUMBER;
489
490 FUNCTION DAY5_LIN2FORMULA(DAY5_PLAN2 IN NUMBER
491 ,DAY5_ACTUAL2 IN NUMBER) RETURN NUMBER;
492
493 FUNCTION DAY6_LIN2FORMULA(DAY6_PLAN2 IN NUMBER
494 ,DAY6_ACTUAL2 IN NUMBER) RETURN NUMBER;
495
496 FUNCTION DAY7_LIN2FORMULA(DAY7_PLAN2 IN NUMBER
497 ,DAY7_ACTUAL2 IN NUMBER) RETURN NUMBER;
498
499 FUNCTION DAY1_LINFORMULA(DAY1_PLAN IN NUMBER
500 ,DAY1_ACTUAL IN NUMBER) RETURN NUMBER;
501
502 FUNCTION DAY2_LINFORMULA(DAY2_PLAN IN NUMBER
503 ,DAY2_ACTUAL IN NUMBER) RETURN NUMBER;
504
505 FUNCTION DAY3_LINFORMULA(DAY3_PLAN IN NUMBER
506 ,DAY3_ACTUAL IN NUMBER) RETURN NUMBER;
507
508 FUNCTION DAY4_LINFORMULA(DAY4_PLAN IN NUMBER
509 ,DAY4_ACTUAL IN NUMBER) RETURN NUMBER;
510
511 FUNCTION DAY5_LINFORMULA(DAY5_PLAN IN NUMBER
512 ,DAY5_ACTUAL IN NUMBER) RETURN NUMBER;
513
514 FUNCTION DAY6_LINFORMULA(DAY6_PLAN IN NUMBER
515 ,DAY6_ACTUAL IN NUMBER) RETURN NUMBER;
516
517 FUNCTION DAY7_LINFORMULA(DAY7_PLAN IN NUMBER
518 ,DAY7_ACTUAL IN NUMBER) RETURN NUMBER;
519
520 END FLM_FLMRFLIN_XMLP_PKG;
521
[Home] [Help]