4 l_return VARCHAR2(240);
1 PACKAGE BODY FLM_FLMRFLIN_XMLP_PKG AS
2 /* $Header: FLMRFLINB.pls 120.1 2007/12/31 09:24:48 dwkrishn noship $ */
3 function BeforeReport return boolean is
5 l_start_date DATE;
6 l_offset NUMBER;
7 l_org_offset NUMBER;
8 l_date_offset NUMBER;
9 begin
10 P_DATE_FROM_1:=to_char(P_DATE_FROM,'DD-MON-YY');
11 P_DATE_TO_1:=to_char(P_DATE_TO,'DD-MON-YY');
12 if (P_REPORT_OPTION = 1) then
13 P_REPORT_OPTION_NAME := 'Summary';
14 else
15 P_REPORT_OPTION_NAME := 'Detail';
16 end if;
17
18 if (P_SORT_OPTION = 1) then
19 P_SORT_OPTION_NAME := 'Week';
20 else
21 P_SORT_OPTION_NAME := 'Line';
22 end if;
23
24 select o.organization_name
25 into P_ORGANIZATION
26 from org_organization_definitions o
27 where o.organization_id = P_ORG_ID;
28
29 if (P_LINE_FROM is NULL and P_LINE_TO is not NULL) then
30 P_LINE_FROM := P_LINE_TO;
31 elsif (P_LINE_FROM is NOT NULL and P_LINE_TO is NULL) then
32 P_LINE_TO := P_LINE_FROM;
33 end if;
34
35 select mrp_form_query_s.nextval
36 into P_QUERY_ID
37 from dual;
38
39
40 select to_number(to_char(to_date('25-10-99','DD-MM-RR'),'D'))
41 into l_org_offset
42 from dual;
43
44 select to_number(to_char(P_DATE_FROM,'D'))
45 into l_date_offset
46 from dual;
47
48 l_offset := l_date_offset - l_org_offset;
49 if (l_offset < 0) then
50 l_offset := l_offset + 7;
51 end if;
52
53 l_start_date := P_DATE_FROM - l_offset;
54
55 flm_linearity_report.populate_flow_summary (l_return, P_LINE_FROM, P_LINE_TO,
56 P_SCH_GROUP, P_ORG_ID, l_start_date, P_DATE_TO, P_QUERY_ID);
57
58 /*SRW.USER_EXIT('FND SRWINIT');
59 SRW.USER_EXIT('
60 FND FLEXSQL
61 CODE="MSTK"
62 APPL_SHORT_NAME="INV"
63 OUTPUT=":P_ASSY_FLEX"
64 TABLEALIAS="MSI1"
65 MODE="SELECT"
66 DISPLAY="ALL"
67 ');
68
69 SRW.USER_EXIT('
70 FND FLEXSQL
71 CODE="MSTK"
72 APPL_SHORT_NAME="INV"
73 OUTPUT=":P_ASSY_FLEX2"
74 TABLEALIAS="MSI1"
75 MODE="SELECT"
76 DISPLAY="ALL"
77 ');*/
78
79 RETURN(TRUE);
80 end;
81
82 FUNCTION AFTERREPORT RETURN BOOLEAN IS
83 BEGIN
84 DELETE FROM MRP_FORM_QUERY
85 WHERE QUERY_ID = P_QUERY_ID;
86 /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
87 RETURN (TRUE);
88 END AFTERREPORT;
89
90 FUNCTION AFTERPFORM RETURN BOOLEAN IS
91 BEGIN
92 RETURN (TRUE);
93 END AFTERPFORM;
94
95 FUNCTION WEEKLY_PLANFORMULA(DAY1_PLAN IN NUMBER
96 ,DAY2_PLAN IN NUMBER
97 ,DAY3_PLAN IN NUMBER
98 ,DAY4_PLAN IN NUMBER
99 ,DAY5_PLAN IN NUMBER
100 ,DAY6_PLAN IN NUMBER
101 ,DAY7_PLAN IN NUMBER) RETURN NUMBER IS
102 BEGIN
103 RETURN (NVL(DAY1_PLAN
104 ,0) + NVL(DAY2_PLAN
105 ,0) + NVL(DAY3_PLAN
106 ,0) + NVL(DAY4_PLAN
107 ,0) + NVL(DAY5_PLAN
108 ,0) + NVL(DAY6_PLAN
109 ,0) + NVL(DAY7_PLAN
110 ,0));
111 END WEEKLY_PLANFORMULA;
112
113 FUNCTION WEEKLY_ACTUALFORMULA(DAY1_ACTUAL IN NUMBER
114 ,DAY2_ACTUAL IN NUMBER
115 ,DAY3_ACTUAL IN NUMBER
116 ,DAY4_ACTUAL IN NUMBER
117 ,DAY5_ACTUAL IN NUMBER
118 ,DAY6_ACTUAL IN NUMBER
119 ,DAY7_ACTUAL IN NUMBER) RETURN NUMBER IS
123 ,0) + NVL(DAY3_ACTUAL
120 BEGIN
121 RETURN (NVL(DAY1_ACTUAL
122 ,0) + NVL(DAY2_ACTUAL
124 ,0) + NVL(DAY4_ACTUAL
125 ,0) + NVL(DAY5_ACTUAL
126 ,0) + NVL(DAY6_ACTUAL
127 ,0) + NVL(DAY7_ACTUAL
128 ,0));
129 END WEEKLY_ACTUALFORMULA;
130
131 FUNCTION WEEKLY_VARFORMULA(WEEKLY_PLAN IN NUMBER
132 ,WEEKLY_ACTUAL IN NUMBER) RETURN NUMBER IS
133 BEGIN
134 RETURN (WEEKLY_PLAN - WEEKLY_ACTUAL);
135 END WEEKLY_VARFORMULA;
136
137 FUNCTION WEEKLY_LINFORMULA(WEEKLY_PLAN IN NUMBER
138 ,WEEKLY_ACTUAL IN NUMBER) RETURN NUMBER IS
139 BEGIN
140 RETURN (GET_VAR(WEEKLY_PLAN
141 ,WEEKLY_ACTUAL));
142 END WEEKLY_LINFORMULA;
143
144 FUNCTION DAY1_VAR_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
145 ,DAY1_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
146 BEGIN
147 RETURN (DAY1_PLAN_GROUP - DAY1_ACTUAL_GROUP);
148 END DAY1_VAR_GROUPFORMULA;
149
150 FUNCTION DAY2_VAR_GROUPFORMULA(DAY2_PLAN_GROUP IN NUMBER
151 ,DAY2_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
152 BEGIN
153 RETURN (DAY2_PLAN_GROUP - DAY2_ACTUAL_GROUP);
154 END DAY2_VAR_GROUPFORMULA;
155
156 FUNCTION DAY3_VAR_GROUPFORMULA(DAY3_PLAN_GROUP IN NUMBER
157 ,DAY3_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
158 BEGIN
159 RETURN (DAY3_PLAN_GROUP - DAY3_ACTUAL_GROUP);
160 END DAY3_VAR_GROUPFORMULA;
161
162 FUNCTION DAY4_VAR_GROUPFORMULA(DAY4_PLAN_GROUP IN NUMBER
163 ,DAY4_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
164 BEGIN
165 RETURN (DAY4_PLAN_GROUP - DAY4_ACTUAL_GROUP);
166 END DAY4_VAR_GROUPFORMULA;
167
168 FUNCTION DAY5_VAR_GROUPFORMULA(DAY5_PLAN_GROUP IN NUMBER
169 ,DAY5_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
170 BEGIN
171 RETURN (DAY5_PLAN_GROUP - DAY5_ACTUAL_GROUP);
172 END DAY5_VAR_GROUPFORMULA;
173
174 FUNCTION DAY6_VAR_GROUPFORMULA(DAY6_PLAN_GROUP IN NUMBER
175 ,DAY6_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
176 BEGIN
177 RETURN (DAY6_PLAN_GROUP - DAY6_ACTUAL_GROUP);
178 END DAY6_VAR_GROUPFORMULA;
179
180 FUNCTION DAY7_VAR_GROUPFORMULA(DAY7_PLAN_GROUP IN NUMBER
181 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
182 BEGIN
183 RETURN (DAY7_PLAN_GROUP - DAY7_ACTUAL_GROUP);
184 END DAY7_VAR_GROUPFORMULA;
185
186 FUNCTION WEEKLY_PLAN_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
187 ,DAY2_PLAN_GROUP IN NUMBER
188 ,DAY3_PLAN_GROUP IN NUMBER
189 ,DAY4_PLAN_GROUP IN NUMBER
190 ,DAY5_PLAN_GROUP IN NUMBER
191 ,DAY6_PLAN_GROUP IN NUMBER
192 ,DAY7_PLAN_GROUP IN NUMBER) RETURN NUMBER IS
193 BEGIN
194 RETURN (NVL(DAY1_PLAN_GROUP
195 ,0) + NVL(DAY2_PLAN_GROUP
196 ,0) + NVL(DAY3_PLAN_GROUP
197 ,0) + NVL(DAY4_PLAN_GROUP
198 ,0) + NVL(DAY5_PLAN_GROUP
199 ,0) + NVL(DAY6_PLAN_GROUP
200 ,0) + NVL(DAY7_PLAN_GROUP
201 ,0));
202 END WEEKLY_PLAN_GROUPFORMULA;
203
204 FUNCTION WEEKLY_ACTUAL_GROUPFORMULA(DAY1_ACTUAL_GROUP IN NUMBER
205 ,DAY2_ACTUAL_GROUP IN NUMBER
206 ,DAY3_ACTUAL_GROUP IN NUMBER
207 ,DAY4_ACTUAL_GROUP IN NUMBER
208 ,DAY5_ACTUAL_GROUP IN NUMBER
209 ,DAY6_ACTUAL_GROUP IN NUMBER
210 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
211 BEGIN
212 RETURN (NVL(DAY1_ACTUAL_GROUP
213 ,0) + NVL(DAY2_ACTUAL_GROUP
214 ,0) + NVL(DAY3_ACTUAL_GROUP
215 ,0) + NVL(DAY4_ACTUAL_GROUP
216 ,0) + NVL(DAY5_ACTUAL_GROUP
217 ,0) + NVL(DAY6_ACTUAL_GROUP
218 ,0) + NVL(DAY7_ACTUAL_GROUP
219 ,0));
220 END WEEKLY_ACTUAL_GROUPFORMULA;
221
222 FUNCTION WEEKLY_VAR_GROUPFORMULA(WEEKLY_PLAN_GROUP IN NUMBER
223 ,WEEKLY_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
224 BEGIN
225 RETURN (WEEKLY_PLAN_GROUP - WEEKLY_ACTUAL_GROUP);
226 END WEEKLY_VAR_GROUPFORMULA;
227
228 FUNCTION WEEKLY_LIN_GROUPFORMULA(WEEKLY_PLAN_GROUP IN NUMBER
229 ,WEEKLY_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
230 BEGIN
231 RETURN (GET_VAR(WEEKLY_PLAN_GROUP
232 ,WEEKLY_ACTUAL_GROUP));
233 END WEEKLY_LIN_GROUPFORMULA;
234
235 FUNCTION DAY1_LIN_GROUPFORMULA(DAY1_PLAN_GROUP IN NUMBER
236 ,DAY1_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
237 BEGIN
238 RETURN (GET_VAR(DAY1_PLAN_GROUP
239 ,DAY1_ACTUAL_GROUP));
240 END DAY1_LIN_GROUPFORMULA;
241
242 FUNCTION DAY2_LIN_GROUPFORMULA(DAY2_PLAN_GROUP IN NUMBER
243 ,DAY2_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
244 BEGIN
245 RETURN (GET_VAR(DAY2_PLAN_GROUP
246 ,DAY2_ACTUAL_GROUP));
247 END DAY2_LIN_GROUPFORMULA;
248
249 FUNCTION DAY3_LIN_GROUPFORMULA(DAY3_PLAN_GROUP IN NUMBER
250 ,DAY3_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
251 BEGIN
252 RETURN (GET_VAR(DAY3_PLAN_GROUP
253 ,DAY3_ACTUAL_GROUP));
257 ,DAY4_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
254 END DAY3_LIN_GROUPFORMULA;
255
256 FUNCTION DAY4_LIN_GROUPFORMULA(DAY4_PLAN_GROUP IN NUMBER
258 BEGIN
259 RETURN (GET_VAR(DAY4_PLAN_GROUP
260 ,DAY4_ACTUAL_GROUP));
261 END DAY4_LIN_GROUPFORMULA;
262
263 FUNCTION DAY5_LIN_GROUPFORMULA(DAY5_PLAN_GROUP IN NUMBER
264 ,DAY5_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
265 BEGIN
266 RETURN (GET_VAR(DAY5_PLAN_GROUP
267 ,DAY5_ACTUAL_GROUP));
268 END DAY5_LIN_GROUPFORMULA;
269
270 FUNCTION DAY6_LIN_GROUPFORMULA(DAY6_PLAN_GROUP IN NUMBER
271 ,DAY6_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
272 BEGIN
273 RETURN (GET_VAR(DAY6_PLAN_GROUP
274 ,DAY6_ACTUAL_GROUP));
275 END DAY6_LIN_GROUPFORMULA;
276
277 FUNCTION DAY7_LIN_GROUPFORMULA(DAY7_PLAN_GROUP IN NUMBER
278 ,DAY7_ACTUAL_GROUP IN NUMBER) RETURN NUMBER IS
279 BEGIN
280 RETURN (GET_VAR(DAY7_PLAN_GROUP
281 ,DAY7_ACTUAL_GROUP));
282 END DAY7_LIN_GROUPFORMULA;
283
284 FUNCTION DAY1_VAR_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
285 ,DAY1_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
286 BEGIN
287 RETURN (DAY1_PLAN_LINE - DAY1_ACTUAL_LINE);
288 END DAY1_VAR_LINEFORMULA;
289
290 FUNCTION DAY2_VAR_LINEFORMULA(DAY2_PLAN_LINE IN NUMBER
291 ,DAY2_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
292 BEGIN
293 RETURN (DAY2_PLAN_LINE - DAY2_ACTUAL_LINE);
294 END DAY2_VAR_LINEFORMULA;
295
296 FUNCTION DAY3_VAR_LINEFORMULA(DAY3_PLAN_LINE IN NUMBER
297 ,DAY3_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
298 BEGIN
299 RETURN (DAY3_PLAN_LINE - DAY3_ACTUAL_LINE);
300 END DAY3_VAR_LINEFORMULA;
301
302 FUNCTION DAY4_VAR_LINEFORMULA(DAY4_PLAN_LINE IN NUMBER
303 ,DAY4_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
304 BEGIN
305 RETURN (DAY4_PLAN_LINE - DAY4_ACTUAL_LINE);
306 END DAY4_VAR_LINEFORMULA;
307
308 FUNCTION DAY5_VAR_LINEFORMULA(DAY5_PLAN_LINE IN NUMBER
309 ,DAY5_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
310 BEGIN
311 RETURN (DAY5_PLAN_LINE - DAY5_ACTUAL_LINE);
312 END DAY5_VAR_LINEFORMULA;
313
314 FUNCTION DAY6_VAR_LINEFORMULA(DAY6_PLAN_LINE IN NUMBER
315 ,DAY6_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
316 BEGIN
317 RETURN (DAY6_PLAN_LINE - DAY6_ACTUAL_LINE);
318 END DAY6_VAR_LINEFORMULA;
319
320 FUNCTION DAY7_VAR_LINEFORMULA(DAY7_PLAN_LINE IN NUMBER
321 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
322 BEGIN
323 RETURN (DAY7_PLAN_LINE - DAY7_ACTUAL_LINE);
324 END DAY7_VAR_LINEFORMULA;
325
326 FUNCTION WEEKLY_VAR_LINEFORMULA(WEEKLY_PLAN_LINE IN NUMBER
327 ,WEEKLY_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
328 BEGIN
329 RETURN (WEEKLY_PLAN_LINE - WEEKLY_ACTUAL_LINE);
330 END WEEKLY_VAR_LINEFORMULA;
331
332 FUNCTION DAY1_LIN_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
333 ,DAY1_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
334 BEGIN
335 RETURN (GET_VAR(DAY1_PLAN_LINE
336 ,DAY1_ACTUAL_LINE));
337 END DAY1_LIN_LINEFORMULA;
338
339 FUNCTION DAY2_LIN_LINEFORMULA(DAY2_PLAN_LINE IN NUMBER
340 ,DAY2_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
341 BEGIN
342 RETURN (GET_VAR(DAY2_PLAN_LINE
343 ,DAY2_ACTUAL_LINE));
344 END DAY2_LIN_LINEFORMULA;
345
346 FUNCTION DAY3_LIN_LINEFORMULA(DAY3_PLAN_LINE IN NUMBER
347 ,DAY3_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
348 BEGIN
349 RETURN (GET_VAR(DAY3_PLAN_LINE
350 ,DAY3_ACTUAL_LINE));
351 END DAY3_LIN_LINEFORMULA;
352
353 FUNCTION DAY4_LIN_LINEFORMULA(DAY4_PLAN_LINE IN NUMBER
354 ,DAY4_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
355 BEGIN
356 RETURN (GET_VAR(DAY4_PLAN_LINE
357 ,DAY4_ACTUAL_LINE));
358 END DAY4_LIN_LINEFORMULA;
359
360 FUNCTION DAY5_LIN_LINEFORMULA(DAY5_PLAN_LINE IN NUMBER
361 ,DAY5_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
362 BEGIN
363 RETURN (GET_VAR(DAY5_PLAN_LINE
364 ,DAY5_ACTUAL_LINE));
365 END DAY5_LIN_LINEFORMULA;
366
367 FUNCTION DAY6_LIN_LINEFORMULA(DAY6_PLAN_LINE IN NUMBER
368 ,DAY6_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
369 BEGIN
370 RETURN (GET_VAR(DAY6_PLAN_LINE
371 ,DAY6_ACTUAL_LINE));
372 END DAY6_LIN_LINEFORMULA;
373
374 FUNCTION DAY7_LIN_LINEFORMULA(DAY7_PLAN_LINE IN NUMBER
375 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
376 BEGIN
377 RETURN (GET_VAR(DAY7_PLAN_LINE
378 ,DAY7_ACTUAL_LINE));
379 END DAY7_LIN_LINEFORMULA;
380
381 FUNCTION WEEKLY_LIN_LINEFORMULA(WEEKLY_PLAN_LINE IN NUMBER
382 ,WEEKLY_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
383 BEGIN
384 RETURN (GET_VAR(WEEKLY_PLAN_LINE
385 ,WEEKLY_ACTUAL_LINE));
386 END WEEKLY_LIN_LINEFORMULA;
387
388 FUNCTION WEEKLY_PLAN_LINEFORMULA(DAY1_PLAN_LINE IN NUMBER
389 ,DAY2_PLAN_LINE IN NUMBER
390 ,DAY3_PLAN_LINE IN NUMBER
391 ,DAY4_PLAN_LINE IN NUMBER
392 ,DAY5_PLAN_LINE IN NUMBER
396 RETURN (NVL(DAY1_PLAN_LINE
393 ,DAY6_PLAN_LINE IN NUMBER
394 ,DAY7_PLAN_LINE IN NUMBER) RETURN NUMBER IS
395 BEGIN
400 ,0) + NVL(DAY5_PLAN_LINE
397 ,0) + NVL(DAY2_PLAN_LINE
398 ,0) + NVL(DAY3_PLAN_LINE
399 ,0) + NVL(DAY4_PLAN_LINE
401 ,0) + NVL(DAY6_PLAN_LINE
402 ,0) + NVL(DAY7_PLAN_LINE
403 ,0));
404 END WEEKLY_PLAN_LINEFORMULA;
405
406 FUNCTION WEEKLY_ACTUAL_LINEFORMULA(DAY1_ACTUAL_LINE IN NUMBER
407 ,DAY2_ACTUAL_LINE IN NUMBER
408 ,DAY3_ACTUAL_LINE IN NUMBER
409 ,DAY4_ACTUAL_LINE IN NUMBER
410 ,DAY5_ACTUAL_LINE IN NUMBER
411 ,DAY6_ACTUAL_LINE IN NUMBER
412 ,DAY7_ACTUAL_LINE IN NUMBER) RETURN NUMBER IS
413 BEGIN
414 RETURN (NVL(DAY1_ACTUAL_LINE
415 ,0) + NVL(DAY2_ACTUAL_LINE
416 ,0) + NVL(DAY3_ACTUAL_LINE
417 ,0) + NVL(DAY4_ACTUAL_LINE
418 ,0) + NVL(DAY5_ACTUAL_LINE
419 ,0) + NVL(DAY6_ACTUAL_LINE
420 ,0) + NVL(DAY7_ACTUAL_LINE
421 ,0));
422 END WEEKLY_ACTUAL_LINEFORMULA;
423
424 FUNCTION WEEKLY_PLAN_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
425 ,DAY2_PLAN_WEEK IN NUMBER
426 ,DAY3_PLAN_WEEK IN NUMBER
427 ,DAY4_PLAN_WEEK IN NUMBER
428 ,DAY5_PLAN_WEEK IN NUMBER
429 ,DAY6_PLAN_WEEK IN NUMBER
430 ,DAY7_PLAN_WEEK IN NUMBER) RETURN NUMBER IS
431 BEGIN
432 RETURN (NVL(DAY1_PLAN_WEEK
433 ,0) + NVL(DAY2_PLAN_WEEK
434 ,0) + NVL(DAY3_PLAN_WEEK
435 ,0) + NVL(DAY4_PLAN_WEEK
436 ,0) + NVL(DAY5_PLAN_WEEK
437 ,0) + NVL(DAY6_PLAN_WEEK
438 ,0) + NVL(DAY7_PLAN_WEEK
439 ,0));
440 END WEEKLY_PLAN_WEEKFORMULA;
441
442 FUNCTION WEEKLY_ACTUAL_WEEKFORMULA(DAY1_ACTUAL_WEEK IN NUMBER
443 ,DAY2_ACTUAL_WEEK IN NUMBER
444 ,DAY3_ACTUAL_WEEK IN NUMBER
445 ,DAY4_ACTUAL_WEEK IN NUMBER
446 ,DAY5_ACTUAL_WEEK IN NUMBER
447 ,DAY6_ACTUAL_WEEK IN NUMBER
448 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
449 BEGIN
450 RETURN (NVL(DAY1_ACTUAL_WEEK
451 ,0) + NVL(DAY2_ACTUAL_WEEK
452 ,0) + NVL(DAY3_ACTUAL_WEEK
453 ,0) + NVL(DAY4_ACTUAL_WEEK
454 ,0) + NVL(DAY5_ACTUAL_WEEK
455 ,0) + NVL(DAY6_ACTUAL_WEEK
456 ,0) + NVL(DAY7_ACTUAL_WEEK
457 ,0));
458 END WEEKLY_ACTUAL_WEEKFORMULA;
459
460 FUNCTION DAY1_VAR_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
461 ,DAY1_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
462 BEGIN
463 RETURN (DAY1_PLAN_WEEK - DAY1_ACTUAL_WEEK);
464 END DAY1_VAR_WEEKFORMULA;
465
466 FUNCTION DAY2_VAR_WEEKFORMULA(DAY2_PLAN_WEEK IN NUMBER
467 ,DAY2_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
468 BEGIN
469 RETURN (DAY2_PLAN_WEEK - DAY2_ACTUAL_WEEK);
470 END DAY2_VAR_WEEKFORMULA;
471
472 FUNCTION DAY3_VAR_WEEKFORMULA(DAY3_PLAN_WEEK IN NUMBER
473 ,DAY3_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
474 BEGIN
475 RETURN (DAY3_PLAN_WEEK - DAY3_ACTUAL_WEEK);
476 END DAY3_VAR_WEEKFORMULA;
477
478 FUNCTION DAY4_VAR_WEEKFORMULA(DAY4_PLAN_WEEK IN NUMBER
479 ,DAY4_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
480 BEGIN
481 RETURN (DAY4_PLAN_WEEK - DAY4_ACTUAL_WEEK);
482 END DAY4_VAR_WEEKFORMULA;
483
484 FUNCTION DAY5_VAR_WEEKFORMULA(DAY5_PLAN_WEEK IN NUMBER
485 ,DAY5_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
486 BEGIN
487 RETURN (DAY5_PLAN_WEEK - DAY5_ACTUAL_WEEK);
488 END DAY5_VAR_WEEKFORMULA;
489
490 FUNCTION DAY6_VAR_WEEKFORMULA(DAY6_PLAN_WEEK IN NUMBER
491 ,DAY6_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
492 BEGIN
493 RETURN (DAY6_PLAN_WEEK - DAY6_ACTUAL_WEEK);
494 END DAY6_VAR_WEEKFORMULA;
495
496 FUNCTION DAY7_VAR_WEEKFORMULA(DAY7_PLAN_WEEK IN NUMBER
497 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
498 BEGIN
502 FUNCTION WEEKLY_VAR_WEEKFORMULA(WEEKLY_PLAN_WEEK IN NUMBER
499 RETURN (DAY7_PLAN_WEEK - DAY7_ACTUAL_WEEK);
500 END DAY7_VAR_WEEKFORMULA;
501
503 ,WEEKLY_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
504 BEGIN
505 RETURN (WEEKLY_PLAN_WEEK - WEEKLY_ACTUAL_WEEK);
506 END WEEKLY_VAR_WEEKFORMULA;
507
508 FUNCTION DAY1_LIN_WEEKFORMULA(DAY1_PLAN_WEEK IN NUMBER
509 ,DAY1_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
510 BEGIN
511 RETURN (GET_VAR(DAY1_PLAN_WEEK
512 ,DAY1_ACTUAL_WEEK));
513 END DAY1_LIN_WEEKFORMULA;
514
515 FUNCTION GET_VAR(L_PLAN IN NUMBER
516 ,L_ACTUAL IN NUMBER) RETURN NUMBER IS
517 BEGIN
518 IF (L_PLAN = L_ACTUAL) THEN
519 RETURN (100);
520 ELSIF (L_PLAN = 0) THEN
521 RETURN (0);
522 ELSE
523 RETURN (ROUND((1 - (ABS(L_PLAN - L_ACTUAL) / L_PLAN)) * 100
524 ,P_PRECISION));
525 END IF;
526 END GET_VAR;
527
528 FUNCTION DAY2_LIN_WEEKFORMULA(DAY2_PLAN_WEEK IN NUMBER
529 ,DAY2_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
530 BEGIN
531 RETURN (GET_VAR(DAY2_PLAN_WEEK
532 ,DAY2_ACTUAL_WEEK));
533 END DAY2_LIN_WEEKFORMULA;
534
535 FUNCTION DAY3_LIN_WEEKFORMULA(DAY3_PLAN_WEEK IN NUMBER
536 ,DAY3_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
537 BEGIN
538 RETURN (GET_VAR(DAY3_PLAN_WEEK
539 ,DAY3_ACTUAL_WEEK));
540 END DAY3_LIN_WEEKFORMULA;
541
542 FUNCTION DAY4_LIN_WEEKFORMULA(DAY4_PLAN_WEEK IN NUMBER
543 ,DAY4_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
544 BEGIN
545 RETURN (GET_VAR(DAY4_PLAN_WEEK
546 ,DAY4_ACTUAL_WEEK));
547 END DAY4_LIN_WEEKFORMULA;
548
549 FUNCTION DAY5_LIN_WEEKFORMULA(DAY5_PLAN_WEEK IN NUMBER
550 ,DAY5_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
551 BEGIN
552 RETURN (GET_VAR(DAY5_PLAN_WEEK
553 ,DAY5_ACTUAL_WEEK));
554 END DAY5_LIN_WEEKFORMULA;
555
556 FUNCTION DAY6_LIN_WEEKFORMULA(DAY6_PLAN_WEEK IN NUMBER
557 ,DAY6_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
558 BEGIN
559 RETURN (GET_VAR(DAY6_PLAN_WEEK
560 ,DAY6_ACTUAL_WEEK));
561 END DAY6_LIN_WEEKFORMULA;
562
563 FUNCTION DAY7_LIN_WEEKFORMULA(DAY7_PLAN_WEEK IN NUMBER
564 ,DAY7_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
565 BEGIN
566 RETURN (GET_VAR(DAY7_PLAN_WEEK
567 ,DAY7_ACTUAL_WEEK));
568 END DAY7_LIN_WEEKFORMULA;
569
570 FUNCTION WEEKLY_LIN_WEEKFORMULA(WEEKLY_PLAN_WEEK IN NUMBER
571 ,WEEKLY_ACTUAL_WEEK IN NUMBER) RETURN NUMBER IS
572 BEGIN
573 RETURN (GET_VAR(WEEKLY_PLAN_WEEK
574 ,WEEKLY_ACTUAL_WEEK));
575 END WEEKLY_LIN_WEEKFORMULA;
576
577 FUNCTION CF_1FORMULA(DAY1_PLAN2 IN NUMBER
578 ,DAY2_PLAN2 IN NUMBER
579 ,DAY3_PLAN2 IN NUMBER
580 ,DAY4_PLAN2 IN NUMBER
581 ,DAY5_PLAN2 IN NUMBER
582 ,DAY6_PLAN2 IN NUMBER
583 ,DAY7_PLAN2 IN NUMBER) RETURN NUMBER IS
584 BEGIN
585 RETURN (NVL(DAY1_PLAN2
586 ,0) + NVL(DAY2_PLAN2
587 ,0) + NVL(DAY3_PLAN2
588 ,0) + NVL(DAY4_PLAN2
589 ,0) + NVL(DAY5_PLAN2
590 ,0) + NVL(DAY6_PLAN2
591 ,0) + NVL(DAY7_PLAN2
592 ,0));
593 END CF_1FORMULA;
594
595 FUNCTION WEEKLY_ACTUAL2FORMULA(DAY1_ACTUAL2 IN NUMBER
596 ,DAY2_ACTUAL2 IN NUMBER
597 ,DAY3_ACTUAL2 IN NUMBER
598 ,DAY4_ACTUAL2 IN NUMBER
599 ,DAY5_ACTUAL2 IN NUMBER
600 ,DAY6_ACTUAL2 IN NUMBER
601 ,DAY7_ACTUAL2 IN NUMBER) RETURN NUMBER IS
602 BEGIN
603 RETURN (NVL(DAY1_ACTUAL2
604 ,0) + NVL(DAY2_ACTUAL2
605 ,0) + NVL(DAY3_ACTUAL2
606 ,0) + NVL(DAY4_ACTUAL2
607 ,0) + NVL(DAY5_ACTUAL2
608 ,0) + NVL(DAY6_ACTUAL2
609 ,0) + NVL(DAY7_ACTUAL2
610 ,0));
611 END WEEKLY_ACTUAL2FORMULA;
612
613 FUNCTION WEEKLY_VAR2FORMULA(WEEKLY_PLAN2 IN NUMBER
614 ,WEEKLY_ACTUAL2 IN NUMBER) RETURN NUMBER IS
615 BEGIN
616 RETURN (WEEKLY_PLAN2 - WEEKLY_ACTUAL2);
617 END WEEKLY_VAR2FORMULA;
618
619 FUNCTION WEEKLY_LIN2FORMULA(WEEKLY_PLAN2 IN NUMBER
620 ,WEEKLY_ACTUAL2 IN NUMBER) RETURN NUMBER IS
621 BEGIN
622 RETURN (GET_VAR(WEEKLY_PLAN2
623 ,WEEKLY_ACTUAL2));
624 END WEEKLY_LIN2FORMULA;
625
626 FUNCTION WEEKLY_PLAN_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
627 ,DAY2_PLAN_WEEK2 IN NUMBER
628 ,DAY3_PLAN_WEEK2 IN NUMBER
629 ,DAY4_PLAN_WEEK2 IN NUMBER
630 ,DAY5_PLAN_WEEK2 IN NUMBER
631 ,DAY6_PLAN_WEEK2 IN NUMBER
632 ,DAY7_PLAN_WEEK2 IN NUMBER) RETURN NUMBER IS
633 BEGIN
634 RETURN (NVL(DAY1_PLAN_WEEK2
635 ,0) + NVL(DAY2_PLAN_WEEK2
636 ,0) + NVL(DAY3_PLAN_WEEK2
637 ,0) + NVL(DAY4_PLAN_WEEK2
638 ,0) + NVL(DAY5_PLAN_WEEK2
639 ,0) + NVL(DAY6_PLAN_WEEK2
643
640 ,0) + NVL(DAY7_PLAN_WEEK2
641 ,0));
642 END WEEKLY_PLAN_WEEK2FORMULA;
644 FUNCTION WEEKLY_ACTUAL_WEEK2FORMULA(DAY1_ACTUAL_WEEK2 IN NUMBER
645 ,DAY2_ACTUAL_WEEK2 IN NUMBER
646 ,DAY3_ACTUAL_WEEK2 IN NUMBER
647 ,DAY4_ACTUAL_WEEK2 IN NUMBER
648 ,DAY5_ACTUAL_WEEK2 IN NUMBER
649 ,DAY6_ACTUAL_WEEK2 IN NUMBER
650 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
651 BEGIN
652 RETURN (NVL(DAY1_ACTUAL_WEEK2
653 ,0) + NVL(DAY2_ACTUAL_WEEK2
654 ,0) + NVL(DAY3_ACTUAL_WEEK2
655 ,0) + NVL(DAY4_ACTUAL_WEEK2
656 ,0) + NVL(DAY5_ACTUAL_WEEK2
657 ,0) + NVL(DAY6_ACTUAL_WEEK2
658 ,0) + NVL(DAY7_ACTUAL_WEEK2
659 ,0));
660 END WEEKLY_ACTUAL_WEEK2FORMULA;
661
662 FUNCTION WEEKLY_VAR_WEEK2FORMULA(WEEKLY_PLAN_WEEK2 IN NUMBER
663 ,WEEKLY_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
664 BEGIN
665 RETURN (WEEKLY_PLAN_WEEK2 - WEEKLY_ACTUAL_WEEK2);
666 END WEEKLY_VAR_WEEK2FORMULA;
667
668 FUNCTION DAY1_VAR_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
669 ,DAY1_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
670 BEGIN
671 RETURN (DAY1_PLAN_WEEK2 - DAY1_ACTUAL_WEEK2);
672 END DAY1_VAR_WEEK2FORMULA;
673
674 FUNCTION DAY2_VAR_WEEK2FORMULA(DAY2_PLAN_WEEK2 IN NUMBER
675 ,DAY2_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
676 BEGIN
677 RETURN (DAY2_PLAN_WEEK2 - DAY2_ACTUAL_WEEK2);
678 END DAY2_VAR_WEEK2FORMULA;
679
680 FUNCTION DAY3_VAR_WEEK2FORMULA(DAY3_PLAN_WEEK2 IN NUMBER
681 ,DAY3_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
682 BEGIN
683 RETURN (DAY3_PLAN_WEEK2 - DAY3_ACTUAL_WEEK2);
684 END DAY3_VAR_WEEK2FORMULA;
685
686 FUNCTION DAY4_VAR_WEEK2FORMULA(DAY4_PLAN_WEEK2 IN NUMBER
687 ,DAY4_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
688 BEGIN
689 RETURN (DAY4_PLAN_WEEK2 - DAY4_ACTUAL_WEEK2);
690 END DAY4_VAR_WEEK2FORMULA;
691
692 FUNCTION DAY5_VAR_WEEK2FORMULA(DAY5_PLAN_WEEK2 IN NUMBER
693 ,DAY5_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
694 BEGIN
695 RETURN (DAY5_PLAN_WEEK2 - DAY5_ACTUAL_WEEK2);
696 END DAY5_VAR_WEEK2FORMULA;
697
698 FUNCTION DAY6_VAR_WEEK2FORMULA(DAY6_PLAN_WEEK2 IN NUMBER
699 ,DAY6_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
700 BEGIN
701 RETURN (DAY6_PLAN_WEEK2 - DAY6_ACTUAL_WEEK2);
702 END DAY6_VAR_WEEK2FORMULA;
703
704 FUNCTION DAY7_VAR_WEEK2FORMULA(DAY7_PLAN_WEEK2 IN NUMBER
705 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
706 BEGIN
707 RETURN (DAY7_PLAN_WEEK2 - DAY7_ACTUAL_WEEK2);
708 END DAY7_VAR_WEEK2FORMULA;
709
710 FUNCTION DAY1_LIN_WEEK2FORMULA(DAY1_PLAN_WEEK2 IN NUMBER
711 ,DAY1_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
712 BEGIN
713 RETURN (GET_VAR(DAY1_PLAN_WEEK2
714 ,DAY1_ACTUAL_WEEK2));
715 END DAY1_LIN_WEEK2FORMULA;
716
717 FUNCTION DAY2_LIN_WEEK2FORMULA(DAY2_PLAN_WEEK2 IN NUMBER
718 ,DAY2_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
719 BEGIN
720 RETURN (GET_VAR(DAY2_PLAN_WEEK2
721 ,DAY2_ACTUAL_WEEK2));
722 END DAY2_LIN_WEEK2FORMULA;
723
724 FUNCTION DAY3_LIN_WEEK2FORMULA(DAY3_PLAN_WEEK2 IN NUMBER
725 ,DAY3_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
726 BEGIN
727 RETURN (GET_VAR(DAY3_PLAN_WEEK2
728 ,DAY3_ACTUAL_WEEK2));
729 END DAY3_LIN_WEEK2FORMULA;
730
731 FUNCTION DAY4_LIN_WEEK2FORMULA(DAY4_PLAN_WEEK2 IN NUMBER
732 ,DAY4_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
733 BEGIN
734 RETURN (GET_VAR(DAY4_PLAN_WEEK2
735 ,DAY4_ACTUAL_WEEK2));
736 END DAY4_LIN_WEEK2FORMULA;
737
738 FUNCTION DAY5_LIN_WEEK2FORMULA(DAY5_PLAN_WEEK2 IN NUMBER
739 ,DAY5_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
740 BEGIN
741 RETURN (GET_VAR(DAY5_PLAN_WEEK2
742 ,DAY5_ACTUAL_WEEK2));
743 END DAY5_LIN_WEEK2FORMULA;
744
745 FUNCTION DAY6_LIN_WEEK2FORMULA(DAY6_PLAN_WEEK2 IN NUMBER
746 ,DAY6_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
747 BEGIN
748 RETURN (GET_VAR(DAY6_PLAN_WEEK2
749 ,DAY6_ACTUAL_WEEK2));
750 END DAY6_LIN_WEEK2FORMULA;
751
752 FUNCTION DAY7_LIN_WEEK2FORMULA(DAY7_PLAN_WEEK2 IN NUMBER
753 ,DAY7_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
754 BEGIN
755 RETURN (GET_VAR(DAY7_PLAN_WEEK2
756 ,DAY7_ACTUAL_WEEK2));
757 END DAY7_LIN_WEEK2FORMULA;
758
759 FUNCTION WEEKLY_LIN_WEEK2FORMULA(WEEKLY_PLAN_WEEK2 IN NUMBER
760 ,WEEKLY_ACTUAL_WEEK2 IN NUMBER) RETURN NUMBER IS
761 BEGIN
762 RETURN (GET_VAR(WEEKLY_PLAN_WEEK2
763 ,WEEKLY_ACTUAL_WEEK2));
764 END WEEKLY_LIN_WEEK2FORMULA;
765
766 FUNCTION DAY1_VAR_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
767 ,DAY1_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
768 BEGIN
769 RETURN (DAY1_PLAN_GROUP2 - DAY1_ACTUAL_GROUP2);
770 END DAY1_VAR_GROUP2FORMULA;
771
772 FUNCTION DAY2_VAR_GROUP2FORMULA(DAY2_PLAN_GROUP2 IN NUMBER
773 ,DAY2_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
774 BEGIN
778 FUNCTION DAY3_VAR_GROUP2FORMULA(DAY3_PLAN_GROUP2 IN NUMBER
775 RETURN (DAY2_PLAN_GROUP2 - DAY2_ACTUAL_GROUP2);
776 END DAY2_VAR_GROUP2FORMULA;
777
779 ,DAY3_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
780 BEGIN
781 RETURN (DAY3_PLAN_GROUP2 - DAY3_ACTUAL_GROUP2);
782 END DAY3_VAR_GROUP2FORMULA;
783
784 FUNCTION DAY4_VAR_GROUP2FORMULA(DAY4_PLAN_GROUP2 IN NUMBER
785 ,DAY4_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
786 BEGIN
787 RETURN (DAY4_PLAN_GROUP2 - DAY4_ACTUAL_GROUP2);
788 END DAY4_VAR_GROUP2FORMULA;
789
790 FUNCTION DAY5_VAR_GROUP2FORMULA(DAY5_PLAN_GROUP2 IN NUMBER
791 ,DAY5_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
792 BEGIN
793 RETURN (DAY5_PLAN_GROUP2 - DAY5_ACTUAL_GROUP2);
794 END DAY5_VAR_GROUP2FORMULA;
795
796 FUNCTION DAY6_VAR_GROUP2FORMULA(DAY6_PLAN_GROUP2 IN NUMBER
797 ,DAY6_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
798 BEGIN
799 RETURN (DAY6_PLAN_GROUP2 - DAY6_ACTUAL_GROUP2);
800 END DAY6_VAR_GROUP2FORMULA;
801
802 FUNCTION DAY7_VAR_GROUP2FORMULA(DAY7_PLAN_GROUP2 IN NUMBER
803 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
804 BEGIN
805 RETURN (DAY7_PLAN_GROUP2 - DAY7_ACTUAL_GROUP2);
806 END DAY7_VAR_GROUP2FORMULA;
807
808 FUNCTION WEEKLY_VAR_GROUP2FORMULA(WEEKLY_PLAN_GROUP2 IN NUMBER
809 ,WEEKLY_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
810 BEGIN
811 RETURN (WEEKLY_PLAN_GROUP2 - WEEKLY_ACTUAL_GROUP2);
812 END WEEKLY_VAR_GROUP2FORMULA;
813
814 FUNCTION WEEKLY_PLAN_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
815 ,DAY2_PLAN_GROUP2 IN NUMBER
816 ,DAY3_PLAN_GROUP2 IN NUMBER
817 ,DAY4_PLAN_GROUP2 IN NUMBER
818 ,DAY5_PLAN_GROUP2 IN NUMBER
819 ,DAY6_PLAN_GROUP2 IN NUMBER
820 ,DAY7_PLAN_GROUP2 IN NUMBER) RETURN NUMBER IS
821 BEGIN
822 RETURN (NVL(DAY1_PLAN_GROUP2
823 ,0) + NVL(DAY2_PLAN_GROUP2
824 ,0) + NVL(DAY3_PLAN_GROUP2
825 ,0) + NVL(DAY4_PLAN_GROUP2
826 ,0) + NVL(DAY5_PLAN_GROUP2
830 END WEEKLY_PLAN_GROUP2FORMULA;
827 ,0) + NVL(DAY6_PLAN_GROUP2
828 ,0) + NVL(DAY7_PLAN_GROUP2
829 ,0));
831
832 FUNCTION WEEKLY_ACTUAL_GROUP2FORMULA(DAY1_ACTUAL_GROUP2 IN NUMBER
833 ,DAY2_ACTUAL_GROUP2 IN NUMBER
834 ,DAY3_ACTUAL_GROUP2 IN NUMBER
835 ,DAY4_ACTUAL_GROUP2 IN NUMBER
836 ,DAY5_ACTUAL_GROUP2 IN NUMBER
837 ,DAY6_ACTUAL_GROUP2 IN NUMBER
838 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
839 BEGIN
840 RETURN (NVL(DAY1_ACTUAL_GROUP2
841 ,0) + NVL(DAY2_ACTUAL_GROUP2
842 ,0) + NVL(DAY3_ACTUAL_GROUP2
843 ,0) + NVL(DAY4_ACTUAL_GROUP2
844 ,0) + NVL(DAY5_ACTUAL_GROUP2
845 ,0) + NVL(DAY6_ACTUAL_GROUP2
846 ,0) + NVL(DAY7_ACTUAL_GROUP2
847 ,0));
848 END WEEKLY_ACTUAL_GROUP2FORMULA;
849
850 FUNCTION DAY1_LIN_GROUP2FORMULA(DAY1_PLAN_GROUP2 IN NUMBER
851 ,DAY1_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
852 BEGIN
853 RETURN (GET_VAR(DAY1_PLAN_GROUP2
854 ,DAY1_ACTUAL_GROUP2));
855 END DAY1_LIN_GROUP2FORMULA;
856
857 FUNCTION DAY2_LIN_GROUP2FORMULA(DAY2_PLAN_GROUP2 IN NUMBER
858 ,DAY2_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
859 BEGIN
860 RETURN (GET_VAR(DAY2_PLAN_GROUP2
861 ,DAY2_ACTUAL_GROUP2));
862 END DAY2_LIN_GROUP2FORMULA;
863
864 FUNCTION DAY3_LIN_GROUP2FORMULA(DAY3_PLAN_GROUP2 IN NUMBER
865 ,DAY3_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
866 BEGIN
867 RETURN (GET_VAR(DAY3_PLAN_GROUP2
868 ,DAY3_ACTUAL_GROUP2));
869 END DAY3_LIN_GROUP2FORMULA;
870
871 FUNCTION DAY4_LIN_GROUP2FORMULA(DAY4_PLAN_GROUP2 IN NUMBER
872 ,DAY4_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
873 BEGIN
874 RETURN (GET_VAR(DAY4_PLAN_GROUP2
875 ,DAY4_ACTUAL_GROUP2));
876 END DAY4_LIN_GROUP2FORMULA;
877
878 FUNCTION DAY5_LIN_GROUP2FORMULA(DAY5_PLAN_GROUP2 IN NUMBER
879 ,DAY5_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
880 BEGIN
884
881 RETURN (GET_VAR(DAY5_PLAN_GROUP2
882 ,DAY5_ACTUAL_GROUP2));
883 END DAY5_LIN_GROUP2FORMULA;
885 FUNCTION DAY6_LIN_GROUP2FORMULA(DAY6_PLAN_GROUP2 IN NUMBER
886 ,DAY6_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
887 BEGIN
888 RETURN (GET_VAR(DAY6_PLAN_GROUP2
889 ,DAY6_ACTUAL_GROUP2));
890 END DAY6_LIN_GROUP2FORMULA;
891
892 FUNCTION DAY7_LIN_GROUP2FORMULA(DAY7_PLAN_GROUP2 IN NUMBER
893 ,DAY7_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
894 BEGIN
895 RETURN (GET_VAR(DAY7_PLAN_GROUP2
896 ,DAY7_ACTUAL_GROUP2));
897 END DAY7_LIN_GROUP2FORMULA;
898
899 FUNCTION WEEKLY_LIN_GROUP2FORMULA(WEEKLY_PLAN_GROUP2 IN NUMBER
900 ,WEEKLY_ACTUAL_GROUP2 IN NUMBER) RETURN NUMBER IS
901 BEGIN
902 RETURN (GET_VAR(WEEKLY_PLAN_GROUP2
903 ,WEEKLY_ACTUAL_GROUP2));
904 END WEEKLY_LIN_GROUP2FORMULA;
905
906 FUNCTION WEEKLY_PLAN_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
907 ,DAY2_PLAN_LINE2 IN NUMBER
908 ,DAY3_PLAN_LINE2 IN NUMBER
909 ,DAY4_PLAN_LINE2 IN NUMBER
910 ,DAY5_PLAN_LINE2 IN NUMBER
911 ,DAY6_PLAN_LINE2 IN NUMBER
912 ,DAY7_PLAN_LINE2 IN NUMBER) RETURN NUMBER IS
913 BEGIN
914 RETURN (NVL(DAY1_PLAN_LINE2
915 ,0) + NVL(DAY2_PLAN_LINE2
916 ,0) + NVL(DAY3_PLAN_LINE2
917 ,0) + NVL(DAY4_PLAN_LINE2
918 ,0) + NVL(DAY5_PLAN_LINE2
919 ,0) + NVL(DAY6_PLAN_LINE2
920 ,0) + NVL(DAY7_PLAN_LINE2
921 ,0));
922 END WEEKLY_PLAN_LINE2FORMULA;
923
924 FUNCTION WEEKLY_ACTUAL_LINE2FORMULA(DAY1_ACTUAL_LINE2 IN NUMBER
925 ,DAY2_ACTUAL_LINE2 IN NUMBER
926 ,DAY3_ACTUAL_LINE2 IN NUMBER
927 ,DAY4_ACTUAL_LINE2 IN NUMBER
928 ,DAY5_ACTUAL_LINE2 IN NUMBER
929 ,DAY6_ACTUAL_LINE2 IN NUMBER
930 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
931 BEGIN
932 RETURN (NVL(DAY1_ACTUAL_LINE2
933 ,0) + NVL(DAY2_ACTUAL_LINE2
934 ,0) + NVL(DAY3_ACTUAL_LINE2
935 ,0) + NVL(DAY4_ACTUAL_LINE2
936 ,0) + NVL(DAY5_ACTUAL_LINE2
937 ,0) + NVL(DAY6_ACTUAL_LINE2
938 ,0) + NVL(DAY7_ACTUAL_LINE2
939 ,0));
940 END WEEKLY_ACTUAL_LINE2FORMULA;
941
942 FUNCTION DAY1_VAR_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
943 ,DAY1_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
944 BEGIN
945 RETURN (DAY1_PLAN_LINE2 - DAY1_ACTUAL_LINE2);
946 END DAY1_VAR_LINE2FORMULA;
947
948 FUNCTION DAY2_VAR_LINE2FORMULA(DAY2_PLAN_LINE2 IN NUMBER
949 ,DAY2_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
950 BEGIN
951 RETURN (DAY2_PLAN_LINE2 - DAY2_ACTUAL_LINE2);
952 END DAY2_VAR_LINE2FORMULA;
953
954 FUNCTION DAY3_VAR_LINE2FORMULA(DAY3_PLAN_LINE2 IN NUMBER
955 ,DAY3_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
956 BEGIN
957 RETURN (DAY3_PLAN_LINE2 - DAY3_ACTUAL_LINE2);
958 END DAY3_VAR_LINE2FORMULA;
959
960 FUNCTION DAY4_VAR_LINE2FORMULA(DAY4_PLAN_LINE2 IN NUMBER
961 ,DAY4_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
962 BEGIN
963 RETURN (DAY4_PLAN_LINE2 - DAY4_ACTUAL_LINE2);
964 END DAY4_VAR_LINE2FORMULA;
965
966 FUNCTION DAY5_VAR_LINE2FORMULA(DAY5_PLAN_LINE2 IN NUMBER
967 ,DAY5_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
968 BEGIN
969 RETURN (DAY5_PLAN_LINE2 - DAY5_ACTUAL_LINE2);
970 END DAY5_VAR_LINE2FORMULA;
971
972 FUNCTION DAY6_VAR_LINE2FORMULA(DAY6_PLAN_LINE2 IN NUMBER
973 ,DAY6_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
974 BEGIN
975 RETURN (DAY6_PLAN_LINE2 - DAY6_ACTUAL_LINE2);
976 END DAY6_VAR_LINE2FORMULA;
977
978 FUNCTION DAY7_VAR_LINE2FORMULA(DAY7_PLAN_LINE2 IN NUMBER
979 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
980 BEGIN
981 RETURN (DAY7_PLAN_LINE2 - DAY7_ACTUAL_LINE2);
982 END DAY7_VAR_LINE2FORMULA;
983
984 FUNCTION WEEKLY_VAR_LINE2FORMULA(WEEKLY_PLAN_LINE2 IN NUMBER
985 ,WEEKLY_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
986 BEGIN
987 RETURN (WEEKLY_PLAN_LINE2 - WEEKLY_ACTUAL_LINE2);
988 END WEEKLY_VAR_LINE2FORMULA;
989
990 FUNCTION DAY1_LIN_LINE2FORMULA(DAY1_PLAN_LINE2 IN NUMBER
991 ,DAY1_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
992 BEGIN
993 RETURN (GET_VAR(DAY1_PLAN_LINE2
994 ,DAY1_ACTUAL_LINE2));
995 END DAY1_LIN_LINE2FORMULA;
996
997 FUNCTION DAY2_LIN_LINE2FORMULA(DAY2_PLAN_LINE2 IN NUMBER
998 ,DAY2_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
999 BEGIN
1000 RETURN (GET_VAR(DAY2_PLAN_LINE2
1001 ,DAY2_ACTUAL_LINE2));
1002 END DAY2_LIN_LINE2FORMULA;
1003
1004 FUNCTION DAY3_LIN_LINE2FORMULA(DAY3_PLAN_LINE2 IN NUMBER
1005 ,DAY3_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1006 BEGIN
1007 RETURN (GET_VAR(DAY3_PLAN_LINE2
1008 ,DAY3_ACTUAL_LINE2));
1009 END DAY3_LIN_LINE2FORMULA;
1010
1011 FUNCTION DAY4_LIN_LINE2FORMULA(DAY4_PLAN_LINE2 IN NUMBER
1012 ,DAY4_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1016 END DAY4_LIN_LINE2FORMULA;
1013 BEGIN
1014 RETURN (GET_VAR(DAY4_PLAN_LINE2
1015 ,DAY4_ACTUAL_LINE2));
1017
1018 FUNCTION DAY5_LIN_LINE2FORMULA(DAY5_PLAN_LINE2 IN NUMBER
1019 ,DAY5_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1020 BEGIN
1021 RETURN (GET_VAR(DAY5_PLAN_LINE2
1022 ,DAY5_ACTUAL_LINE2));
1023 END DAY5_LIN_LINE2FORMULA;
1024
1025 FUNCTION DAY6_LIN_LINE2FORMULA(DAY6_PLAN_LINE2 IN NUMBER
1026 ,DAY6_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1027 BEGIN
1028 RETURN (GET_VAR(DAY6_PLAN_LINE2
1029 ,DAY6_ACTUAL_LINE2));
1030 END DAY6_LIN_LINE2FORMULA;
1031
1032 FUNCTION DAY7_LIN_LINE2FORMULA(DAY7_PLAN_LINE2 IN NUMBER
1033 ,DAY7_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1034 BEGIN
1035 RETURN (GET_VAR(DAY7_PLAN_LINE2
1036 ,DAY7_ACTUAL_LINE2));
1037 END DAY7_LIN_LINE2FORMULA;
1038
1039 FUNCTION WEEKLY_LIN_LINE2FORMULA(WEEKLY_PLAN_LINE2 IN NUMBER
1040 ,WEEKLY_ACTUAL_LINE2 IN NUMBER) RETURN NUMBER IS
1041 BEGIN
1042 RETURN (GET_VAR(WEEKLY_PLAN_LINE2
1043 ,WEEKLY_ACTUAL_LINE2));
1044 END WEEKLY_LIN_LINE2FORMULA;
1045
1046 FUNCTION DAY1_LIN2FORMULA(DAY1_PLAN2 IN NUMBER
1047 ,DAY1_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1048 BEGIN
1049 RETURN (GET_VAR(DAY1_PLAN2
1050 ,DAY1_ACTUAL2));
1051 END DAY1_LIN2FORMULA;
1052
1053 FUNCTION DAY2_LIN2FORMULA(DAY2_PLAN2 IN NUMBER
1054 ,DAY2_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1055 BEGIN
1056 RETURN (GET_VAR(DAY2_PLAN2
1057 ,DAY2_ACTUAL2));
1058 END DAY2_LIN2FORMULA;
1059
1060 FUNCTION DAY3_LIN2FORMULA(DAY3_PLAN2 IN NUMBER
1061 ,DAY3_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1062 BEGIN
1063 RETURN (GET_VAR(DAY3_PLAN2
1064 ,DAY3_ACTUAL2));
1065 END DAY3_LIN2FORMULA;
1066
1067 FUNCTION DAY4_LIN2FORMULA(DAY4_PLAN2 IN NUMBER
1068 ,DAY4_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1069 BEGIN
1070 RETURN (GET_VAR(DAY4_PLAN2
1071 ,DAY4_ACTUAL2));
1072 END DAY4_LIN2FORMULA;
1073
1074 FUNCTION DAY5_LIN2FORMULA(DAY5_PLAN2 IN NUMBER
1075 ,DAY5_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1076 BEGIN
1077 RETURN (GET_VAR(DAY5_PLAN2
1078 ,DAY5_ACTUAL2));
1079 END DAY5_LIN2FORMULA;
1080
1081 FUNCTION DAY6_LIN2FORMULA(DAY6_PLAN2 IN NUMBER
1082 ,DAY6_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1083 BEGIN
1084 RETURN (GET_VAR(DAY6_PLAN2
1085 ,DAY6_ACTUAL2));
1086 END DAY6_LIN2FORMULA;
1087
1088 FUNCTION DAY7_LIN2FORMULA(DAY7_PLAN2 IN NUMBER
1089 ,DAY7_ACTUAL2 IN NUMBER) RETURN NUMBER IS
1090 BEGIN
1091 RETURN (GET_VAR(DAY7_PLAN2
1092 ,DAY7_ACTUAL2));
1093 END DAY7_LIN2FORMULA;
1094
1095 FUNCTION DAY1_LINFORMULA(DAY1_PLAN IN NUMBER
1096 ,DAY1_ACTUAL IN NUMBER) RETURN NUMBER IS
1097 BEGIN
1098 RETURN (GET_VAR(DAY1_PLAN
1099 ,DAY1_ACTUAL));
1100 END DAY1_LINFORMULA;
1101
1102 FUNCTION DAY2_LINFORMULA(DAY2_PLAN IN NUMBER
1103 ,DAY2_ACTUAL IN NUMBER) RETURN NUMBER IS
1104 BEGIN
1105 RETURN (GET_VAR(DAY2_PLAN
1106 ,DAY2_ACTUAL));
1107 END DAY2_LINFORMULA;
1108
1109 FUNCTION DAY3_LINFORMULA(DAY3_PLAN IN NUMBER
1110 ,DAY3_ACTUAL IN NUMBER) RETURN NUMBER IS
1111 BEGIN
1112 RETURN (GET_VAR(DAY3_PLAN
1113 ,DAY3_ACTUAL));
1114 END DAY3_LINFORMULA;
1115
1116 FUNCTION DAY4_LINFORMULA(DAY4_PLAN IN NUMBER
1117 ,DAY4_ACTUAL IN NUMBER) RETURN NUMBER IS
1118 BEGIN
1119 RETURN (GET_VAR(DAY4_PLAN
1120 ,DAY4_ACTUAL));
1121 END DAY4_LINFORMULA;
1122
1123 FUNCTION DAY5_LINFORMULA(DAY5_PLAN IN NUMBER
1124 ,DAY5_ACTUAL IN NUMBER) RETURN NUMBER IS
1125 BEGIN
1126 RETURN (GET_VAR(DAY5_PLAN
1127 ,DAY5_ACTUAL));
1128 END DAY5_LINFORMULA;
1129
1130 FUNCTION DAY6_LINFORMULA(DAY6_PLAN IN NUMBER
1131 ,DAY6_ACTUAL IN NUMBER) RETURN NUMBER IS
1132 BEGIN
1133 RETURN (GET_VAR(DAY6_PLAN
1134 ,DAY6_ACTUAL));
1135 END DAY6_LINFORMULA;
1136
1137 FUNCTION DAY7_LINFORMULA(DAY7_PLAN IN NUMBER
1138 ,DAY7_ACTUAL IN NUMBER) RETURN NUMBER IS
1139 BEGIN
1140 RETURN (GET_VAR(DAY7_PLAN
1141 ,DAY7_ACTUAL));
1142 END DAY7_LINFORMULA;
1143
1144 END FLM_FLMRFLIN_XMLP_PKG;
1145