[Home] [Help]
PACKAGE BODY: APPS.PJI_PROCESS_UTIL
Source
1 package body PJI_PROCESS_UTIL as
2 /* $Header: PJIUT03B.pls 120.16.12000000.2 2007/05/21 14:26:09 sacgupta ship $ */
3
4 -- Global variables -----------------------------------
5 g_check_step varchar2(1) := 'Y';
6
7 -- ----------------------------------------------------------
8 -- function SUMMARIZATION_STARTED
9 -- ----------------------------------------------------------
10 function SUMMARIZATION_STARTED
11 (
12 p_stage in varchar2 default 'STAGE1_EXTR'
13 ) return varchar2 is
14
15 l_permanent_param varchar2(240);
16 l_running_param varchar2(240);
17
18 l_stage2_pji_process varchar2(30);
19
20 begin
21
22 if (p_stage = 'STAGE1_EXTR') then
23
24 l_permanent_param := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
25 l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
26 (PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
27
28 if (l_running_param is not null) then
29
30 return 'RUNNING';
31
32 elsif (l_permanent_param is not null) then
33
34 return 'HAS_RUN';
35
36 end if;
37
38 elsif (p_stage = 'STAGE2_PJI') then
39
40 begin
41
42 execute immediate 'begin
43 select PJI_RM_SUM_MAIN.g_process
44 into :l_stage2_pji_process
45 from DUAL;
46 end;'
47 using out l_stage2_pji_process;
48
49 exception when others then
50
51 l_stage2_pji_process := null;
52
53 end;
54
55 l_permanent_param := PJI_UTILS.GET_PARAMETER('LAST_PJI_EXTR_DATE');
56 l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
57 -- Remove dependency on STAGE2_PJI
58 (l_stage2_pji_process, 'PROCESS_RUNNING');
59 -- (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING');
60
61 if (l_running_param is not null) then
62
63 return 'RUNNING';
64
65 elsif (l_permanent_param is not null) then
66
67 return 'HAS_RUN';
68
69 end if;
70
71 elsif (p_stage = 'STAGE3_PJP') then
72
73 begin
74
75 select VALUE
76 into l_permanent_param
77 from PJI_SYSTEM_PARAMETERS
78 where NAME like 'LAST_PJP_EXTR_DATE%' and
79 ROWNUM = 1;
80
81 exception when no_data_found then
82
83 l_permanent_param := null;
84
85 end;
86
87 begin
88
89 select VALUE
90 into l_running_param
91 from PJI_SYSTEM_PARAMETERS
92 where NAME like PJI_PJP_SUM_MAIN.g_process || '%PROCESS_RUNNING' and
93 ROWNUM = 1;
94
95 exception when no_data_found then
96
97 l_running_param := null;
98
99 end;
100
101 if (l_running_param is not null) then
102
103 return 'RUNNING';
104
105 elsif (l_permanent_param is not null) then
106
107 return 'HAS_RUN';
108
109 end if;
110
111 end if;
112
113 return 'NOT_STARTED';
114
115 end SUMMARIZATION_STARTED;
116
117
118 -- ----------------------------------------------------------
119 -- function NEED_TO_RUN_STEP
120 --
121 -- This function returns false if the current process
122 -- step has run before, usually within the context of
123 -- a single batch.
124 --
125 -- ----------------------------------------------------------
126 function NEED_TO_RUN_STEP
127 (
128 p_process in varchar2,
129 p_step in varchar2
130 ) return boolean is
131
132 l_status varchar2(1);
133 l_seq number;
134 l_count number;
135
136 begin
137
138 if (g_check_step = 'Y') then
139 null;
140 else
141 return true;
142 end if;
143
144 select count(*)
145 into l_count
146 from PJI_SYSTEM_PRC_STATUS
147 where PROCESS_NAME = p_process and
148 STEP_NAME = p_step;
149
150 if (l_count = 0) then
151 return false;
152 end if;
153
154 select STEP_STATUS,
155 STEP_SEQ
156 into l_status,
157 l_seq
158 from PJI_SYSTEM_PRC_STATUS
159 where PROCESS_NAME = p_process and
160 STEP_NAME = p_step;
161
162 if (l_status = 'C') then -- Step is complete, do not need to run it again.
163 return false;
164 else
165
166 update PJI_SYSTEM_PRC_STATUS
167 set START_DATE = sysdate
168 where PROCESS_NAME = p_process and
169 STEP_NAME = p_step and
170 START_DATE is null;
171
172 -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));
173 PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,
174 true, 0);
175 return true;
176 end if;
177
178 end NEED_TO_RUN_STEP;
179
180
181 -- ----------------------------------------------------------
182 -- procedure REGISTER_STEP_COMPLETION
183 --
184 -- This utility procedure is called from individual steps.
185 -- Procedure updates process log table with successful
186 -- completion status for a given step.
187 -- ----------------------------------------------------------
188 procedure REGISTER_STEP_COMPLETION
189 (
190 p_process in varchar2,
191 p_step in varchar2
192 ) is
193 begin
194
195 if (g_check_step = 'Y') then
196 null;
197 else
198 return;
199 end if;
200
201 update PJI_SYSTEM_PRC_STATUS
202 set STEP_STATUS = 'C',
203 END_DATE = sysdate
204 where PROCESS_NAME = p_process and
205 STEP_NAME = p_step;
206
207 -- PJI_UTILS.RESET_CURR_FUNCTION;
208 PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,
209 true, 0);
210
211 end REGISTER_STEP_COMPLETION;
212
213
214 -- ----------------------------------------------------------
215 -- procedure CHECK_STEP
216 --
217 -- This utility is for debugging purposes.
218 -- If check step is not set to 'Y' any step can be run in
219 -- the summarization process without looking at
220 -- PJI_SYSTEM_PRC_STATUS to see if the step has run before.
221 -- ----------------------------------------------------------
222 procedure CHECK_STEP (p_check_step in varchar2 default 'Y') is
223
224 begin
225
226 if (p_check_step = 'Y') then
227 g_check_step := 'Y';
228 else
229 g_check_step := 'N';
230 end if;
231
232 end CHECK_STEP;
233
234
235 -- ----------------------------------------------------------
236 -- procedure WRAPUP_PROCESS
237 --
238 -- If process completed successfuly, we clean up process
239 -- log table from the step status records.
240 -- ----------------------------------------------------------
241 procedure WRAPUP_PROCESS (p_process in varchar2) is
242
243 begin
244
245 delete
246 from PJI_SYSTEM_PRC_STATUS
247 where PROCESS_NAME = p_process;
248
249 delete
250 from PJI_SYSTEM_PARAMETERS
251 where NAME like p_process || '$%';
252
253 end WRAPUP_PROCESS;
254
255
256 -- ----------------------------------------------------------
257 -- procedure ADD_STEPS
258 -- ----------------------------------------------------------
259 procedure ADD_STEPS
260 (
261 p_process in varchar2,
262 p_step_process in varchar2,
263 p_extraction_type in varchar2
264 ) is
265
266 l_process varchar2(30);
267 l_transition_flag varchar2(1);
268 l_params_proj_perf_flag varchar2(1);
269 l_params_cost_flag varchar2(1);
270 l_params_profit_flag varchar2(1);
271 l_params_util_flag varchar2(1);
272 l_extraction_type number;
273
274 begin
275
276 -- if the step already exists we do not want to update it because it may
277 -- contain error recovery state from the previous iteration
278
279 l_process := PJI_FM_SUM_MAIN.g_process;
280
281 l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
282 'TRANSITION');
283
284 if (l_transition_flag = 'Y') then
285
286 l_params_proj_perf_flag :=
287 nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
288 'CONFIG_PROJ_PERF_FLAG'), 'N');
289 l_params_cost_flag :=
290 nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
291 'CONFIG_COST_FLAG'), 'N');
292 l_params_profit_flag :=
293 nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
294 'CONFIG_PROFIT_FLAG'), 'N');
295 l_params_util_flag :=
296 nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
297 'CONFIG_UTIL_FLAG'), 'N');
298
299 else -- l_transition is null or 'N'
300
301 l_params_proj_perf_flag :=
302 nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROJ_PERF_FLAG'), 'N');
303 l_params_cost_flag :=
304 nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
305 l_params_profit_flag :=
306 nvl(PJI_UTILS.GET_PARAMETER('CONFIG_PROFIT_FLAG'), 'N');
307 l_params_util_flag :=
308 nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'), 'N');
309
310 end if;
311
312 if (p_extraction_type = 'FULL') then
313 l_extraction_type := 1;
314 elsif (p_extraction_type = 'INCREMENTAL') then
315 l_extraction_type := 2;
316 elsif (p_extraction_type = 'PARTIAL') then
317 l_extraction_type := 4;
318 elsif (p_extraction_type = 'RBS') then
319 l_extraction_type := 8;
320 else
321 l_extraction_type := 0;
322 end if;
323
324 insert into PJI_SYSTEM_PRC_STATUS
325 (
326 PROCESS_NAME,
327 STEP_NAME,
328 STEP_STATUS,
329 STEP_SEQ
330 )
331 select
332 p_process,
333 STEP_NAME,
334 null,
335 STEP_SEQ
336 from
337 PJI_MT_PRC_STEPS
338 where
339 PROCESS_NAME = p_step_process and
340 ((CONFIG_PROJ_PERF_FLAG = 'Y' and l_params_proj_perf_flag = 'Y') or
341 (CONFIG_COST_FLAG = 'Y' and l_params_cost_flag = 'Y') or
342 (CONFIG_PROFIT_FLAG = 'Y' and l_params_profit_flag = 'Y') or
343 (CONFIG_UTIL_FLAG = 'Y' and l_params_util_flag = 'Y') or
344 p_step_process = 'PJI_PJP_FPM_UPGRADE') and
345 bitand(to_number(STEP_TYPE), l_extraction_type) = l_extraction_type and
346 (STEP_NAME,
347 STEP_SEQ) not in (select STEP_NAME,
348 STEP_SEQ
349 from PJI_SYSTEM_PRC_STATUS
350 where PROCESS_NAME = p_process);
351
352 end ADD_STEPS;
353
354
355 -- ----------------------------------------------------------
356 -- funtion PRIOR_ITERATION_SUCCESSFUL
357 --
358 -- This function returns true if prior load process
359 -- completed successful.
360 -- If prior iteration is successful, process log table
361 -- does not have any records for the process.
362 -- ----------------------------------------------------------
363 function PRIOR_ITERATION_SUCCESSFUL (p_process in varchar2) return boolean is
364
365 l_count number;
366
367 begin
368
369 select count(*)
370 into l_count
371 from PJI_SYSTEM_PRC_STATUS
372 where PROCESS_NAME = p_process;
373
374 if (l_count = 0) then
375 return true;
376 else
377 return false;
378 end if;
379
380 end PRIOR_ITERATION_SUCCESSFUL;
381
382
383 -- ----------------------------------------------------------
384 -- procedure GET_PROCESS_PARAMETER
385 -- ----------------------------------------------------------
386 function GET_PROCESS_PARAMETER
387 (
388 p_process in varchar2,
389 p_parameter in varchar2
390 ) return varchar2 is
391
392 begin
393
394 return PJI_UTILS.GET_PARAMETER(p_process || '$' || p_parameter);
395
396 end;
397
398 -- ----------------------------------------------------------
399 -- procedure SET_PROCESS_PARAMETER
400 -- ----------------------------------------------------------
401 procedure SET_PROCESS_PARAMETER
402 (
403 p_process in varchar2,
404 p_parameter in varchar2,
405 p_value in varchar2
406 ) is
407
408 begin
409
410 PJI_UTILS.SET_PARAMETER(p_process || '$' || p_parameter, p_value);
411
412 end;
413
414
415 -- ----------------------------------------------------------
416 -- procedure SLEEP
417 -- ----------------------------------------------------------
418
419 procedure SLEEP (p_time_in_seconds in number) is
420
421 begin
422
423 DBMS_LOCK.SLEEP(p_time_in_seconds);
424
425 end SLEEP;
426
427 -- ----------------------------------------------------------
428 -- procedure TRUNC_INT_TABLE
429 -- ----------------------------------------------------------
430 procedure TRUNC_INT_TABLE
431 ( p_schema in varchar2
432 , p_tablename in varchar2
433 , p_trunc_type in varchar2
434 , p_partition in varchar2
435 ) is
436
437 begin
438
439 IF 1=1 THEN -- so that this is a controlled feature
440
441 IF (p_trunc_type = 'NORMAL') THEN
442
443 execute immediate
444 'truncate table '||p_schema||'.'||p_tablename||' drop storage';
445 ELSIF (p_trunc_type = 'PARTITION') THEN
446 execute immediate
447 'alter table '||p_schema||'.'||p_tablename||' truncate partition '||p_partition||' drop storage';
448 END IF;
449
450 ELSE
451 null;
452 END IF;
453
454 end TRUNC_INT_TABLE;
455
456
457 -- ----------------------------------------------------------
458 -- function WAIT_FOR_STEP
459 --
460 -- This function waits until all applicable workers have
461 -- compeleted p_step.
462 -- ----------------------------------------------------------
463 function WAIT_FOR_STEP
464 (
465 p_process in varchar2,
466 p_step in varchar2,
467 p_timeout in number,
468 p_exists in varchar2 default 'ONLY_IF_EXISTS'
469 ) return boolean is
470
471 l_done boolean;
472 l_worker_count number;
473
474 l_stage2_pji_process varchar2(30);
475 l_stage2_pji_running varchar2(30);
476
477 begin
478
479 if (p_exists = 'EVEN_IF_NOT_EXISTS') then
480
481 l_done := false;
482
483 while not l_done loop
484
485 select count(*)
486 into l_worker_count
487 from PJI_SYSTEM_PRC_STATUS
488 where PROCESS_NAME like p_process || '%' and
489 STEP_NAME = p_step;
490
491 if (l_worker_count > 0) then
492 l_done := true;
493 end if;
494
495 end loop;
496
497 end if;
498
499 l_done := false;
500
501 while not l_done loop
502
503 select count(*)
504 into l_worker_count
505 from PJI_SYSTEM_PRC_STATUS
506 where PROCESS_NAME like p_process || '%' and
507 STEP_NAME = p_step and
508 STEP_STATUS is null;
509
510 begin
511
512 execute immediate 'begin
513 select PJI_RM_SUM_MAIN.g_process
514 into :l_stage2_pji_process
515 from DUAL;
516 end;'
517 using out l_stage2_pji_process;
518
519 if (p_process = l_stage2_pji_process) then
520
521 execute immediate
522 'begin
523 if (PJI_RM_SUM_MAIN.PROCESS_RUNNING(''DO_NOT_WAIT'')) then
524 :l_stage2_pji_running := ''True'';
525 else
526 :l_stage2_pji_running := ''False'';
527 end if;
528 end;'
529 using out l_stage2_pji_running;
530
531 end if;
532
533 exception when others then
534
535 l_stage2_pji_process := null;
536 l_stage2_pji_running := null;
537
538 end;
539
540 if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
541 (p_process, 'PROCESS_RUNNING'), 'F') = 'F') then
542 l_done := true;
543 l_worker_count := -1;
544 -- Remove dependency on STAGE2_PJI
545 elsif (p_process = l_stage2_pji_process and
546 l_stage2_pji_running = 'False') then
547 -- elsif (p_process = PJI_RM_SUM_MAIN.g_process and
548 -- not PJI_RM_SUM_MAIN.PROCESS_RUNNING('DO_NOT_WAIT')) then
549 l_done := true;
550 l_worker_count := -1;
551 elsif (p_process = PJI_FM_SUM_MAIN.g_process and
552 not PJI_FM_SUM_MAIN.PROCESS_RUNNING('DO_NOT_WAIT')) then
553 l_done := true;
554 l_worker_count := -1;
555 elsif (l_worker_count = 0) then
556 l_done := true;
557 else
558 SLEEP(p_timeout);
559 end if;
560
561 end loop;
562
563 if (l_worker_count = 0) then
564 return true;
565 else
566 return false;
567 end if;
568
569 end WAIT_FOR_STEP;
570
571
572 -- ----------------------------------------------------------
573 -- procedure CLEAN_HELPER_BATCH_TABLE
574 -- ----------------------------------------------------------
575 procedure CLEAN_HELPER_BATCH_TABLE is
576
577 begin
578
579 delete
580 from PJI_HELPER_BATCH_MAP
581 where STATUS = 'P';
582
583 commit;
584
585 end;
586
587
588 -- -----------------------------------------------------
589 -- function REQUEST_STATUS
590 -- -----------------------------------------------------
591 function REQUEST_STATUS
592 (
593 p_mode in varchar2,
594 p_request_id in number,
595 p_request_name in varchar2
596 ) return boolean is
597
598 l_request_id number;
599 l_phase varchar2(255);
600 l_status varchar2(255);
601 l_dev_phase varchar2(255);
602 l_dev_status varchar2(255);
603 l_message varchar2(255);
604
605 l_process_id number;
606 l_session_id number;
607 l_count number;
608
609 begin
610
611 if (p_request_id is null) then
612 return false;
613 end if;
614
615 l_request_id := p_request_id;
616
617 if (FND_CONCURRENT.GET_REQUEST_STATUS
618 (
619 l_request_id,
620 PJI_UTILS.GET_PJI_SCHEMA_NAME,
621 p_request_name,
622 l_phase,
623 l_status,
624 l_dev_phase,
625 l_dev_status,
626 l_message
627 )) then
628 null;
629 end if;
630
631 /* possible states
632
633 PENDING NORMAL
634 STANDBY
635 SCHEDULED
636 PAUSED
637
638 RUNNING NORMAL
639 WAITING
640 RESUMING
641 TERMINATING
642
643 COMPLETE NORMAL
644 ERROR
645 WARNING
646 CANCELLED
647 TERMINATED
648
649 INACTIVE DISABLED
650 ON_HOLD
651 NO_MANAGER
652 SUSPENDED */
653
654 if (p_mode = 'OKAY') then
655
656 if ((l_dev_phase = 'RUNNING' and (l_dev_status = 'TERMINATING')) or
657 (l_dev_phase = 'COMPLETE' and (l_dev_status = 'ERROR' or
658 l_dev_status = 'WARNING' or
659 l_dev_status = 'CANCELLED' or
660 l_dev_status = 'DELETED' or
661 l_dev_status = 'TERMINATED'))) then
662 return false;
663 else
664 return true;
665 end if;
666
667 elsif (p_mode = 'RUNNING') then
668
669 if (l_dev_phase = 'PENDING' or
670 l_dev_phase = 'RUNNING' or
671 l_dev_phase = 'INACTIVE') then
672 return true;
673 else
674
675 begin -- ensure that the underlying database process has completed
676
677 select
678 ORACLE_PROCESS_ID,
679 ORACLE_SESSION_ID
680 into
681 l_process_id,
682 l_session_id
683 from
684 FND_CONCURRENT_REQUESTS
685 where
686 REQUEST_ID = l_request_id;
687
688 select
689 count(*)
690 into
691 l_count
692 from
693 V$PROCESS
694 where
695 SPID = l_process_id and
696 ROWNUM = 1;
697
698 if (l_count > 0) then
699 return true;
700 end if;
701
702 exception when no_data_found then null;
703
704 end;
705
706 return false;
707
708 end if;
709
710 end if;
711
712 end REQUEST_STATUS;
713
714
715 -- -----------------------------------------------------
716 -- procedure WAIT_FOR_REQUEST
717 -- -----------------------------------------------------
718 procedure WAIT_FOR_REQUEST
719 (
720 p_request_id in number,
721 p_delay in number
722 ) is
723
724 l_process varchar2(30);
725 l_request_id number;
726
727 l_phase varchar2(255);
728 l_status varchar2(255);
729 l_dev_phase varchar2(255);
730 l_dev_status varchar2(255);
731 l_message varchar2(255);
732
733 begin
734
735 if (p_request_id is null) then
736 return;
737 end if;
738
739 if (FND_CONCURRENT.WAIT_FOR_REQUEST
740 (
741 p_request_id,
742 p_delay,
743 0, -- wait forever
744 l_phase,
745 l_status,
746 l_dev_phase,
747 l_dev_status,
748 l_message
749 )) then
750 null;
751 end if;
752
753 end WAIT_FOR_REQUEST;
754
755
756 -- ----------------------------------------------------------
757 -- procedure REFRESH_STEP_TABLE
758 -- ----------------------------------------------------------
759 procedure REFRESH_STEP_TABLE is
760
761 l_count number;
762 l_step_seq number;
763
764 begin
765
766 /* We will use bitand logic to determine to which extraction type
767 * a given step applies.
768 *
769 * 1 = 'FULL' extraction
770 * 2 = 'INCREMENTAL' extraction
771 * 4 = 'PARTIAL' refresh
772 * 8 = 'RBS' change processing
773 * 16 =
774 * 32 =
775 * 64 =
776 * 128 =
777 *
778 */
779
780 select count(*)
781 into l_count
782 from PJI_MT_PRC_STEPS
783 where ROWNUM = 1;
784
785 if (l_count > 0) then
786 null;
787 -- return;
788 end if;
789
790 delete from PJI_MT_PRC_STEPS;
791
792 -- ------------------------------------------------------------------------
793 -- Stage 1 Summarization - Project Intellingence / Performance extraction
794 -- ------------------------------------------------------------------------
795
796 l_step_seq := 10;
797
798 insert into PJI_MT_PRC_STEPS
799 (
800 PROCESS_NAME,
801 STEP_NAME,
802 STEP_SEQ,
803 STEP_TYPE,
804 CONFIG_PROJ_PERF_FLAG,
805 CONFIG_COST_FLAG,
806 CONFIG_PROFIT_FLAG,
807 CONFIG_UTIL_FLAG
808 )
809 values
810 (
811 'PJI_EXTR',
812 'PJI_FM_SUM_MAIN.INIT_PROCESS;',
813 l_step_seq,
814 to_char(1 + 2 + 4 + 8), -- generic
815 'Y',
816 'Y',
817 'Y',
818 'Y'
819 );
820
821 l_step_seq := l_step_seq + 10;
822
823 insert into PJI_MT_PRC_STEPS
824 (
825 PROCESS_NAME,
826 STEP_NAME,
827 STEP_SEQ,
828 STEP_TYPE,
829 CONFIG_PROJ_PERF_FLAG,
830 CONFIG_COST_FLAG,
831 CONFIG_PROFIT_FLAG,
832 CONFIG_UTIL_FLAG
833 )
834 values
835 (
836 'PJI_EXTR',
837 'PJI_FM_SUM_MAIN.RUN_PROCESS;',
838 l_step_seq,
839 to_char(1 + 2 + 4 + 8), -- generic
840 'Y',
841 'Y',
842 'Y',
843 'Y'
844 );
845
846 l_step_seq := l_step_seq + 10;
847
848 insert into PJI_MT_PRC_STEPS
849 (
850 PROCESS_NAME,
851 STEP_NAME,
852 STEP_SEQ,
853 STEP_TYPE,
854 CONFIG_PROJ_PERF_FLAG,
855 CONFIG_COST_FLAG,
856 CONFIG_PROFIT_FLAG,
857 CONFIG_UTIL_FLAG
858 )
859 values
860 (
861 'PJI_EXTR',
862 'PJI_FM_SUM_MAIN.WRAPUP_PROCESS;',
863 l_step_seq,
864 to_char(1 + 2 + 4 + 8), -- generic
865 'Y',
866 'Y',
867 'Y',
868 'Y'
869 );
870
871 l_step_seq := l_step_seq + 10;
872
873 insert into PJI_MT_PRC_STEPS
874 (
875 PROCESS_NAME,
876 STEP_NAME,
877 STEP_SEQ,
878 STEP_TYPE,
879 CONFIG_PROJ_PERF_FLAG,
880 CONFIG_COST_FLAG,
881 CONFIG_PROFIT_FLAG,
882 CONFIG_UTIL_FLAG
883 )
884 values
885 (
886 'PJI_EXTR',
887 'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);',
888 l_step_seq,
889 to_char(1 + 2 + 4 + 8), -- generic
890 'Y',
891 'Y',
892 'Y',
893 'Y'
894 );
895
896 l_step_seq := l_step_seq + 10;
897
898 insert into PJI_MT_PRC_STEPS
899 (
900 PROCESS_NAME,
901 STEP_NAME,
902 STEP_SEQ,
903 STEP_TYPE,
904 CONFIG_PROJ_PERF_FLAG,
905 CONFIG_COST_FLAG,
906 CONFIG_PROFIT_FLAG,
907 CONFIG_UTIL_FLAG
908 )
909 values
910 (
911 'PJI_EXTR',
912 'PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);',
913 l_step_seq,
914 to_char(1 + 2 + 4 + 8), -- generic
915 'Y',
916 'Y',
917 'Y',
918 'N'
919 );
920
921 l_step_seq := l_step_seq + 10;
922
923 insert into PJI_MT_PRC_STEPS
924 (
925 PROCESS_NAME,
926 STEP_NAME,
927 STEP_SEQ,
928 STEP_TYPE,
929 CONFIG_PROJ_PERF_FLAG,
930 CONFIG_COST_FLAG,
931 CONFIG_PROFIT_FLAG,
932 CONFIG_UTIL_FLAG
933 )
934 values
935 (
936 'PJI_EXTR',
937 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_PRE(p_worker_id);',
938 l_step_seq,
939 to_char(1 + 2 + 4 + 8), -- generic
940 'Y',
941 'Y',
942 'Y',
943 'N'
944 );
945
946 l_step_seq := l_step_seq + 10;
947
948 -- helper step
949 insert into PJI_MT_PRC_STEPS
950 (
951 PROCESS_NAME,
952 STEP_NAME,
953 STEP_SEQ,
954 STEP_TYPE,
955 CONFIG_PROJ_PERF_FLAG,
956 CONFIG_COST_FLAG,
957 CONFIG_PROFIT_FLAG,
958 CONFIG_UTIL_FLAG
959 )
960 values
961 (
962 'PJI_EXTR_HELPER',
963 'PJI_FM_EXTR.MARK_EXTRACTED_DREV(p_worker_id);',
964 l_step_seq,
965 to_char(1 + 2 + 4 + 8), -- generic
966 'Y',
967 'Y',
968 'Y',
969 'N'
970 );
971
972 l_step_seq := l_step_seq + 10;
973
974 insert into PJI_MT_PRC_STEPS
975 (
976 PROCESS_NAME,
977 STEP_NAME,
978 STEP_SEQ,
979 STEP_TYPE,
980 CONFIG_PROJ_PERF_FLAG,
981 CONFIG_COST_FLAG,
982 CONFIG_PROFIT_FLAG,
983 CONFIG_UTIL_FLAG
984 )
985 values
986 (
987 'PJI_EXTR',
988 'PJI_FM_EXTR.MARK_EXTRACTED_DREV_POST(p_worker_id);',
989 l_step_seq,
990 to_char(1 + 2 + 4 + 8), -- generic
991 'Y',
992 'Y',
993 'Y',
994 'N'
995 );
996
997 l_step_seq := l_step_seq + 10;
998
999 insert into PJI_MT_PRC_STEPS
1000 (
1001 PROCESS_NAME,
1002 STEP_NAME,
1003 STEP_SEQ,
1004 STEP_TYPE,
1005 CONFIG_PROJ_PERF_FLAG,
1006 CONFIG_COST_FLAG,
1007 CONFIG_PROFIT_FLAG,
1008 CONFIG_UTIL_FLAG
1009 )
1010 values
1011 (
1012 'PJI_EXTR',
1013 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_ROWIDS(p_worker_id);',
1014 l_step_seq,
1015 to_char(1 + 2 + 4 + 8), -- generic
1016 'Y',
1017 'Y',
1018 'Y',
1019 'Y'
1020 );
1021
1022 l_step_seq := l_step_seq + 10;
1023
1024 insert into PJI_MT_PRC_STEPS
1025 (
1026 PROCESS_NAME,
1027 STEP_NAME,
1028 STEP_SEQ,
1029 STEP_TYPE,
1030 CONFIG_PROJ_PERF_FLAG,
1031 CONFIG_COST_FLAG,
1032 CONFIG_PROFIT_FLAG,
1033 CONFIG_UTIL_FLAG
1034 )
1035 values
1036 (
1037 'PJI_EXTR',
1038 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_PRE(p_worker_id);',
1039 l_step_seq,
1040 to_char(1 + 2 + 4 + 8), -- generic
1041 'Y',
1042 'Y',
1043 'Y',
1044 'Y'
1045 );
1046
1047 l_step_seq := l_step_seq + 10;
1048
1049 -- helper step
1050 insert into PJI_MT_PRC_STEPS
1051 (
1052 PROCESS_NAME,
1053 STEP_NAME,
1054 STEP_SEQ,
1055 STEP_TYPE,
1056 CONFIG_PROJ_PERF_FLAG,
1057 CONFIG_COST_FLAG,
1058 CONFIG_PROFIT_FLAG,
1059 CONFIG_UTIL_FLAG
1060 )
1061 values
1062 (
1063 'PJI_EXTR_HELPER',
1064 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS(p_worker_id);',
1065 l_step_seq,
1066 to_char(1 + 2 + 4 + 8), -- generic
1067 'Y',
1068 'Y',
1069 'Y',
1070 'Y'
1071 );
1072
1073 l_step_seq := l_step_seq + 10;
1074
1075 insert into PJI_MT_PRC_STEPS
1076 (
1077 PROCESS_NAME,
1078 STEP_NAME,
1079 STEP_SEQ,
1080 STEP_TYPE,
1081 CONFIG_PROJ_PERF_FLAG,
1082 CONFIG_COST_FLAG,
1083 CONFIG_PROFIT_FLAG,
1084 CONFIG_UTIL_FLAG
1085 )
1086 values
1087 (
1088 'PJI_EXTR',
1089 'PJI_FM_EXTR.MARK_EXTRACTED_CDL_ROWS_POST(p_worker_id);',
1090 l_step_seq,
1091 to_char(1 + 2 + 4 + 8), -- generic
1092 'Y',
1093 'Y',
1094 'Y',
1095 'Y'
1096 );
1097
1098 l_step_seq := l_step_seq + 10;
1099
1100 insert into PJI_MT_PRC_STEPS
1101 (
1102 PROCESS_NAME,
1103 STEP_NAME,
1104 STEP_SEQ,
1105 STEP_TYPE,
1106 CONFIG_PROJ_PERF_FLAG,
1107 CONFIG_COST_FLAG,
1108 CONFIG_PROFIT_FLAG,
1109 CONFIG_UTIL_FLAG
1110 )
1111 values
1112 (
1113 'PJI_EXTR',
1114 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_CRDL_FULL(p_worker_id);',
1115 l_step_seq,
1116 to_char(1), -- full
1117 'Y',
1118 'Y',
1119 'Y',
1120 'Y'
1121 );
1122
1123 l_step_seq := l_step_seq + 10;
1124
1125 insert into PJI_MT_PRC_STEPS
1126 (
1127 PROCESS_NAME,
1128 STEP_NAME,
1129 STEP_SEQ,
1130 STEP_TYPE,
1131 CONFIG_PROJ_PERF_FLAG,
1132 CONFIG_COST_FLAG,
1133 CONFIG_PROFIT_FLAG,
1134 CONFIG_UTIL_FLAG
1135 )
1136 values
1137 (
1138 'PJI_EXTR',
1139 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_FULL(p_worker_id);',
1140 l_step_seq,
1141 to_char(1), -- full
1142 'Y',
1143 'Y',
1144 'Y',
1145 'N'
1146 );
1147
1148 l_step_seq := l_step_seq + 10;
1149
1150 insert into PJI_MT_PRC_STEPS
1151 (
1152 PROCESS_NAME,
1153 STEP_NAME,
1154 STEP_SEQ,
1155 STEP_TYPE,
1156 CONFIG_PROJ_PERF_FLAG,
1157 CONFIG_COST_FLAG,
1158 CONFIG_PROFIT_FLAG,
1159 CONFIG_UTIL_FLAG
1160 )
1161 values
1162 (
1163 'PJI_EXTR',
1164 'PJI_FM_EXTR.EXTRACT_BATCH_CRDL_ROWIDS(p_worker_id);',
1165 l_step_seq,
1166 to_char(2 + 4), -- incremental + partial
1167 'Y',
1168 'Y',
1169 'Y',
1170 'N'
1171 );
1172
1173 l_step_seq := l_step_seq + 10;
1174
1175 insert into PJI_MT_PRC_STEPS
1176 (
1177 PROCESS_NAME,
1178 STEP_NAME,
1179 STEP_SEQ,
1180 STEP_TYPE,
1181 CONFIG_PROJ_PERF_FLAG,
1182 CONFIG_COST_FLAG,
1183 CONFIG_PROFIT_FLAG,
1184 CONFIG_UTIL_FLAG
1185 )
1186 values
1187 (
1188 'PJI_EXTR',
1189 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL_ROWIDS(p_worker_id);',
1190 l_step_seq,
1191 to_char(2 + 4), -- incremental + partial
1192 'Y',
1193 'Y',
1194 'Y',
1195 'N'
1196 );
1197
1198 l_step_seq := l_step_seq + 10;
1199
1200 insert into PJI_MT_PRC_STEPS
1201 (
1202 PROCESS_NAME,
1203 STEP_NAME,
1204 STEP_SEQ,
1205 STEP_TYPE,
1206 CONFIG_PROJ_PERF_FLAG,
1207 CONFIG_COST_FLAG,
1208 CONFIG_PROFIT_FLAG,
1209 CONFIG_UTIL_FLAG
1210 )
1211 values
1212 (
1213 'PJI_EXTR',
1214 'PJI_FM_EXTR.EXTRACT_BATCH_CDL_AND_CRDL(p_worker_id);',
1215 l_step_seq,
1216 to_char(2 + 4), -- incremental + partial
1217 'Y',
1218 'Y',
1219 'Y',
1220 'Y'
1221 );
1222
1223 l_step_seq := l_step_seq + 10;
1224
1225 insert into PJI_MT_PRC_STEPS
1226 (
1227 PROCESS_NAME,
1228 STEP_NAME,
1229 STEP_SEQ,
1230 STEP_TYPE,
1231 CONFIG_PROJ_PERF_FLAG,
1232 CONFIG_COST_FLAG,
1233 CONFIG_PROFIT_FLAG,
1234 CONFIG_UTIL_FLAG
1235 )
1236 values
1237 (
1238 'PJI_EXTR',
1239 'PJI_FM_EXTR.EXTRACT_BATCH_ERDL(p_worker_id);',
1240 l_step_seq,
1241 to_char(1 + 2 + 4 + 8), -- generic
1242 'Y',
1243 'Y',
1244 'Y',
1245 'N'
1246 );
1247
1248 l_step_seq := l_step_seq + 10;
1249
1250 insert into PJI_MT_PRC_STEPS
1251 (
1252 PROCESS_NAME,
1253 STEP_NAME,
1254 STEP_SEQ,
1255 STEP_TYPE,
1256 CONFIG_PROJ_PERF_FLAG,
1257 CONFIG_COST_FLAG,
1258 CONFIG_PROFIT_FLAG,
1259 CONFIG_UTIL_FLAG
1260 )
1261 values
1262 (
1263 'PJI_EXTR',
1264 'PJI_FM_EXTR.EXTRACT_BATCH_FND(p_worker_id);',
1265 l_step_seq,
1266 to_char(1 + 2 + 4 + 8), -- generic
1267 'Y',
1268 'N',
1269 'Y',
1270 'N'
1271 );
1272
1273 l_step_seq := l_step_seq + 10;
1274
1275 insert into PJI_MT_PRC_STEPS
1276 (
1277 PROCESS_NAME,
1278 STEP_NAME,
1279 STEP_SEQ,
1280 STEP_TYPE,
1281 CONFIG_PROJ_PERF_FLAG,
1282 CONFIG_COST_FLAG,
1283 CONFIG_PROFIT_FLAG,
1284 CONFIG_UTIL_FLAG
1285 )
1286 values
1287 (
1288 'PJI_EXTR',
1289 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_PRE(p_worker_id);',
1290 l_step_seq,
1291 to_char(1 + 2 + 4 + 8), -- generic
1292 'Y',
1293 'N',
1294 'Y',
1295 'N'
1296 );
1297
1298 l_step_seq := l_step_seq + 10;
1299
1300 -- helper step
1301 insert into PJI_MT_PRC_STEPS
1302 (
1303 PROCESS_NAME,
1304 STEP_NAME,
1305 STEP_SEQ,
1306 STEP_TYPE,
1307 CONFIG_PROJ_PERF_FLAG,
1308 CONFIG_COST_FLAG,
1309 CONFIG_PROFIT_FLAG,
1310 CONFIG_UTIL_FLAG
1311 )
1312 values
1313 (
1314 'PJI_EXTR_HELPER',
1315 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS(p_worker_id);',
1316 l_step_seq,
1317 to_char(1 + 2 + 4 + 8), -- generic
1318 'Y',
1319 'N',
1320 'Y',
1321 'N'
1322 );
1323
1324 l_step_seq := l_step_seq + 10;
1325
1326 insert into PJI_MT_PRC_STEPS
1327 (
1328 PROCESS_NAME,
1329 STEP_NAME,
1330 STEP_SEQ,
1331 STEP_TYPE,
1332 CONFIG_PROJ_PERF_FLAG,
1333 CONFIG_COST_FLAG,
1334 CONFIG_PROFIT_FLAG,
1335 CONFIG_UTIL_FLAG
1336 )
1337 values
1338 (
1339 'PJI_EXTR',
1340 'PJI_FM_EXTR.MARK_EXTRACTED_FND_ROWS_POST(p_worker_id);',
1341 l_step_seq,
1342 to_char(1 + 2 + 4 + 8), -- generic
1343 'Y',
1344 'N',
1345 'Y',
1346 'N'
1347 );
1348
1349 l_step_seq := l_step_seq + 10;
1350
1351 insert into PJI_MT_PRC_STEPS
1352 (
1353 PROCESS_NAME,
1354 STEP_NAME,
1355 STEP_SEQ,
1356 STEP_TYPE,
1357 CONFIG_PROJ_PERF_FLAG,
1358 CONFIG_COST_FLAG,
1359 CONFIG_PROFIT_FLAG,
1360 CONFIG_UTIL_FLAG
1361 )
1362 values
1363 (
1364 'PJI_EXTR',
1365 'PJI_FM_EXTR.EXTRACT_BATCH_DINV(p_worker_id);',
1366 l_step_seq,
1367 to_char(1 + 2 + 4 + 8), -- generic
1368 'Y',
1369 'N',
1370 'Y',
1371 'N'
1372 );
1373
1374 l_step_seq := l_step_seq + 10;
1375
1376 insert into PJI_MT_PRC_STEPS
1377 (
1378 PROCESS_NAME,
1379 STEP_NAME,
1380 STEP_SEQ,
1381 STEP_TYPE,
1382 CONFIG_PROJ_PERF_FLAG,
1383 CONFIG_COST_FLAG,
1384 CONFIG_PROFIT_FLAG,
1385 CONFIG_UTIL_FLAG
1386 )
1387 values
1388 (
1389 'PJI_EXTR',
1390 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);',
1391 l_step_seq,
1392 to_char(1 + 2 + 4 + 8), -- generic
1393 'Y',
1394 'N',
1395 'Y',
1396 'N'
1397 );
1398
1399 l_step_seq := l_step_seq + 10;
1400
1401 insert into PJI_MT_PRC_STEPS
1402 (
1403 PROCESS_NAME,
1404 STEP_NAME,
1405 STEP_SEQ,
1406 STEP_TYPE,
1407 CONFIG_PROJ_PERF_FLAG,
1408 CONFIG_COST_FLAG,
1409 CONFIG_PROFIT_FLAG,
1410 CONFIG_UTIL_FLAG
1411 )
1412 values
1413 (
1414 'PJI_EXTR',
1415 'PJI_FM_EXTR.EXTRACT_BATCH_DINVITEM(p_worker_id);',
1416 l_step_seq,
1417 to_char(1 + 2 + 4 + 8), -- generic
1418 'Y',
1419 'N',
1420 'Y',
1421 'N'
1422 );
1423
1424 l_step_seq := l_step_seq + 10;
1425
1426 insert into PJI_MT_PRC_STEPS
1427 (
1428 PROCESS_NAME,
1429 STEP_NAME,
1430 STEP_SEQ,
1431 STEP_TYPE,
1432 CONFIG_PROJ_PERF_FLAG,
1433 CONFIG_COST_FLAG,
1434 CONFIG_PROFIT_FLAG,
1435 CONFIG_UTIL_FLAG
1436 )
1437 values
1438 (
1439 'PJI_EXTR',
1440 'PJI_FM_EXTR.EXTRACT_BATCH_ARINV(p_worker_id);',
1441 l_step_seq,
1442 to_char(1 + 2 + 4 + 8), -- generic
1443 'Y',
1444 'N',
1445 'Y',
1446 'N'
1447 );
1448
1449 l_step_seq := l_step_seq + 10;
1450
1451 insert into PJI_MT_PRC_STEPS
1452 (
1453 PROCESS_NAME,
1454 STEP_NAME,
1455 STEP_SEQ,
1456 STEP_TYPE,
1457 CONFIG_PROJ_PERF_FLAG,
1458 CONFIG_COST_FLAG,
1459 CONFIG_PROFIT_FLAG,
1460 CONFIG_UTIL_FLAG
1461 )
1462 values
1463 (
1464 'PJI_EXTR',
1465 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_PRE(p_worker_id);',
1466 l_step_seq,
1467 to_char(1 + 2 + 4 + 8), -- generic
1468 'Y',
1469 'N',
1470 'Y',
1471 'N'
1472 );
1473
1474 l_step_seq := l_step_seq + 10;
1475
1476 -- helper step
1477 insert into PJI_MT_PRC_STEPS
1478 (
1479 PROCESS_NAME,
1480 STEP_NAME,
1481 STEP_SEQ,
1482 STEP_TYPE,
1483 CONFIG_PROJ_PERF_FLAG,
1484 CONFIG_COST_FLAG,
1485 CONFIG_PROFIT_FLAG,
1486 CONFIG_UTIL_FLAG
1487 )
1488 values
1489 (
1490 'PJI_EXTR_HELPER',
1491 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES(p_worker_id);',
1492 l_step_seq,
1493 to_char(1 + 2 + 4 + 8), -- generic
1494 'Y',
1495 'N',
1496 'Y',
1497 'N'
1498 );
1499
1500 l_step_seq := l_step_seq + 10;
1501
1502 insert into PJI_MT_PRC_STEPS
1503 (
1504 PROCESS_NAME,
1505 STEP_NAME,
1506 STEP_SEQ,
1507 STEP_TYPE,
1508 CONFIG_PROJ_PERF_FLAG,
1509 CONFIG_COST_FLAG,
1510 CONFIG_PROFIT_FLAG,
1511 CONFIG_UTIL_FLAG
1512 )
1513 values
1514 (
1515 'PJI_EXTR',
1516 'PJI_FM_EXTR.MARK_FULLY_PAID_INVOICES_POST(p_worker_id);',
1517 l_step_seq,
1518 to_char(1 + 2 + 4 + 8), -- generic
1519 'Y',
1520 'N',
1521 'Y',
1522 'N'
1523 );
1524
1525 l_step_seq := l_step_seq + 10;
1526
1527 insert into PJI_MT_PRC_STEPS
1528 (
1529 PROCESS_NAME,
1530 STEP_NAME,
1531 STEP_SEQ,
1532 STEP_TYPE,
1533 CONFIG_PROJ_PERF_FLAG,
1534 CONFIG_COST_FLAG,
1535 CONFIG_PROFIT_FLAG,
1536 CONFIG_UTIL_FLAG
1537 )
1538 values
1539 (
1540 'PJI_EXTR',
1541 'PJI_FM_SUM_ACT.BASE_SUMMARY(p_worker_id);',
1542 l_step_seq,
1543 to_char(1 + 2 + 4 + 8), -- generic
1544 'Y',
1545 'N',
1546 'Y',
1547 'N'
1548 );
1549
1550 l_step_seq := l_step_seq + 10;
1551
1552 insert into PJI_MT_PRC_STEPS
1553 (
1554 PROCESS_NAME,
1555 STEP_NAME,
1556 STEP_SEQ,
1557 STEP_TYPE,
1558 CONFIG_PROJ_PERF_FLAG,
1559 CONFIG_COST_FLAG,
1560 CONFIG_PROFIT_FLAG,
1561 CONFIG_UTIL_FLAG
1562 )
1563 values
1564 (
1565 'PJI_EXTR',
1566 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);',
1567 l_step_seq,
1568 to_char(1 + 2 + 4 + 8), -- generic
1569 'Y',
1570 'Y',
1571 'N',
1572 'N'
1573 );
1574
1575 l_step_seq := l_step_seq + 10;
1576
1577 insert into PJI_MT_PRC_STEPS
1578 (
1579 PROCESS_NAME,
1580 STEP_NAME,
1581 STEP_SEQ,
1582 STEP_TYPE,
1583 CONFIG_PROJ_PERF_FLAG,
1584 CONFIG_COST_FLAG,
1585 CONFIG_PROFIT_FLAG,
1586 CONFIG_UTIL_FLAG
1587 )
1588 values
1589 (
1590 'PJI_EXTR_HELPER',
1591 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);',
1592 l_step_seq,
1593 to_char(1 + 2 + 4 + 8), -- generic
1594 'Y',
1595 'Y',
1596 'N',
1597 'N'
1598 );
1599
1600 l_step_seq := l_step_seq + 10;
1601
1602 insert into PJI_MT_PRC_STEPS
1603 (
1604 PROCESS_NAME,
1605 STEP_NAME,
1606 STEP_SEQ,
1607 STEP_TYPE,
1608 CONFIG_PROJ_PERF_FLAG,
1609 CONFIG_COST_FLAG,
1610 CONFIG_PROFIT_FLAG,
1611 CONFIG_UTIL_FLAG
1612 )
1613 values
1614 (
1615 'PJI_EXTR',
1616 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);',
1617 l_step_seq,
1618 to_char(1 + 2 + 4 + 8), -- generic
1619 'Y',
1620 'Y',
1621 'N',
1622 'N'
1623 );
1624
1625 l_step_seq := l_step_seq + 10;
1626
1627 insert into PJI_MT_PRC_STEPS
1628 (
1629 PROCESS_NAME,
1630 STEP_NAME,
1631 STEP_SEQ,
1632 STEP_TYPE,
1633 CONFIG_PROJ_PERF_FLAG,
1634 CONFIG_COST_FLAG,
1635 CONFIG_PROFIT_FLAG,
1636 CONFIG_UTIL_FLAG
1637 )
1638 values
1639 (
1640 'PJI_EXTR',
1641 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);',
1642 l_step_seq,
1643 to_char(1 + 2 + 4 + 8), -- generic
1644 'Y',
1645 'Y',
1646 'Y',
1647 'Y'
1648 );
1649
1650 l_step_seq := l_step_seq + 10;
1651
1652 insert into PJI_MT_PRC_STEPS
1653 (
1654 PROCESS_NAME,
1655 STEP_NAME,
1656 STEP_SEQ,
1657 STEP_TYPE,
1658 CONFIG_PROJ_PERF_FLAG,
1659 CONFIG_COST_FLAG,
1660 CONFIG_PROFIT_FLAG,
1661 CONFIG_UTIL_FLAG
1662 )
1663 values
1664 (
1665 'PJI_EXTR',
1666 'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);',
1667 l_step_seq,
1668 to_char(1 + 2 + 4 + 8), -- generic
1669 'Y',
1670 'Y',
1671 'Y',
1672 'Y'
1673 );
1674
1675 l_step_seq := l_step_seq + 10;
1676
1677 insert into PJI_MT_PRC_STEPS
1678 (
1679 PROCESS_NAME,
1680 STEP_NAME,
1681 STEP_SEQ,
1682 STEP_TYPE,
1683 CONFIG_PROJ_PERF_FLAG,
1684 CONFIG_COST_FLAG,
1685 CONFIG_PROFIT_FLAG,
1686 CONFIG_UTIL_FLAG
1687 )
1688 values
1689 (
1690 'PJI_EXTR',
1691 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);',
1692 l_step_seq,
1693 to_char(1 + 2 + 4 + 8), -- generic
1694 'Y',
1695 'Y',
1696 'N',
1697 'Y'
1698 );
1699
1700 l_step_seq := l_step_seq + 10;
1701
1702 insert into PJI_MT_PRC_STEPS
1703 (
1704 PROCESS_NAME,
1705 STEP_NAME,
1706 STEP_SEQ,
1707 STEP_TYPE,
1708 CONFIG_PROJ_PERF_FLAG,
1709 CONFIG_COST_FLAG,
1710 CONFIG_PROFIT_FLAG,
1711 CONFIG_UTIL_FLAG
1712 )
1713 values
1714 (
1715 'PJI_EXTR',
1716 'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);',
1717 l_step_seq,
1718 to_char(1 + 2 + 4 + 8), -- generic
1719 'Y',
1720 'N',
1721 'Y',
1722 'N'
1723 );
1724
1725 l_step_seq := l_step_seq + 10;
1726
1727 insert into PJI_MT_PRC_STEPS
1728 (
1729 PROCESS_NAME,
1730 STEP_NAME,
1731 STEP_SEQ,
1732 STEP_TYPE,
1733 CONFIG_PROJ_PERF_FLAG,
1734 CONFIG_COST_FLAG,
1735 CONFIG_PROFIT_FLAG,
1736 CONFIG_UTIL_FLAG
1737 )
1738 values
1739 (
1740 'PJI_EXTR',
1741 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);',
1742 l_step_seq,
1743 to_char(1 + 2 + 4 + 8), -- generic
1744 'Y',
1745 'Y',
1746 'N',
1747 'Y'
1748 );
1749
1750 l_step_seq := l_step_seq + 10;
1751
1752 insert into PJI_MT_PRC_STEPS
1753 (
1754 PROCESS_NAME,
1755 STEP_NAME,
1756 STEP_SEQ,
1757 STEP_TYPE,
1758 CONFIG_PROJ_PERF_FLAG,
1759 CONFIG_COST_FLAG,
1760 CONFIG_PROFIT_FLAG,
1761 CONFIG_UTIL_FLAG
1762 )
1763 values
1764 (
1765 'PJI_EXTR',
1766 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);',
1767 l_step_seq,
1768 to_char(1 + 2 + 4 + 8), -- generic
1769 'Y',
1770 'N',
1771 'Y',
1772 'N'
1773 );
1774
1775 l_step_seq := l_step_seq + 10;
1776
1777 insert into PJI_MT_PRC_STEPS
1778 (
1779 PROCESS_NAME,
1780 STEP_NAME,
1781 STEP_SEQ,
1782 STEP_TYPE,
1783 CONFIG_PROJ_PERF_FLAG,
1784 CONFIG_COST_FLAG,
1785 CONFIG_PROFIT_FLAG,
1786 CONFIG_UTIL_FLAG
1787 )
1788 values
1789 (
1790 'PJI_EXTR',
1791 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);',
1792 l_step_seq,
1793 to_char(1 + 2 + 4 + 8), -- generic
1794 'Y',
1795 'Y',
1796 'N',
1797 'N'
1798 );
1799
1800 l_step_seq := l_step_seq + 10;
1801
1802 insert into PJI_MT_PRC_STEPS
1803 (
1804 PROCESS_NAME,
1805 STEP_NAME,
1806 STEP_SEQ,
1807 STEP_TYPE,
1808 CONFIG_PROJ_PERF_FLAG,
1809 CONFIG_COST_FLAG,
1810 CONFIG_PROFIT_FLAG,
1811 CONFIG_UTIL_FLAG
1812 )
1813 values
1814 (
1815 'PJI_EXTR',
1816 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);',
1817 l_step_seq,
1818 to_char(1 + 2 + 4 + 8), -- generic
1819 'Y',
1820 'Y',
1821 'N',
1822 'Y'
1823 );
1824
1825 l_step_seq := l_step_seq + 10;
1826
1827 insert into PJI_MT_PRC_STEPS
1828 (
1829 PROCESS_NAME,
1830 STEP_NAME,
1831 STEP_SEQ,
1832 STEP_TYPE,
1833 CONFIG_PROJ_PERF_FLAG,
1834 CONFIG_COST_FLAG,
1835 CONFIG_PROFIT_FLAG,
1836 CONFIG_UTIL_FLAG
1837 )
1838 values
1839 (
1840 'PJI_EXTR',
1841 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);',
1842 l_step_seq,
1843 to_char(1 + 2 + 4 + 8), -- generic
1844 'Y',
1845 'Y',
1846 'N',
1847 'Y'
1848 );
1849
1850 l_step_seq := l_step_seq + 10;
1851
1852 insert into PJI_MT_PRC_STEPS
1853 (
1854 PROCESS_NAME,
1855 STEP_NAME,
1856 STEP_SEQ,
1857 STEP_TYPE,
1858 CONFIG_PROJ_PERF_FLAG,
1859 CONFIG_COST_FLAG,
1860 CONFIG_PROFIT_FLAG,
1861 CONFIG_UTIL_FLAG
1862 )
1863 values
1864 (
1865 'PJI_EXTR',
1866 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);',
1867 l_step_seq,
1868 to_char(1 + 2 + 4 + 8), -- generic
1869 'Y',
1870 'N',
1871 'Y',
1872 'N'
1873 );
1874
1875 l_step_seq := l_step_seq + 10;
1876
1877 insert into PJI_MT_PRC_STEPS
1878 (
1879 PROCESS_NAME,
1880 STEP_NAME,
1881 STEP_SEQ,
1882 STEP_TYPE,
1883 CONFIG_PROJ_PERF_FLAG,
1884 CONFIG_COST_FLAG,
1885 CONFIG_PROFIT_FLAG,
1886 CONFIG_UTIL_FLAG
1887 )
1888 values
1889 (
1890 'PJI_EXTR',
1891 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);',
1892 l_step_seq,
1893 to_char(1 + 2 + 4 + 8), -- generic
1894 'Y',
1895 'N',
1896 'Y',
1897 'N'
1898 );
1899
1900 l_step_seq := l_step_seq + 10;
1901
1902 insert into PJI_MT_PRC_STEPS
1903 (
1904 PROCESS_NAME,
1905 STEP_NAME,
1906 STEP_SEQ,
1907 STEP_TYPE,
1908 CONFIG_PROJ_PERF_FLAG,
1909 CONFIG_COST_FLAG,
1910 CONFIG_PROFIT_FLAG,
1911 CONFIG_UTIL_FLAG
1912 )
1913 values
1914 (
1915 'PJI_EXTR',
1916 'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);',
1917 l_step_seq,
1918 to_char(1 + 2 + 4 + 8), -- generic
1919 'Y',
1920 'N',
1921 'N',
1922 'N'
1923 );
1924
1925 l_step_seq := l_step_seq + 10;
1926
1927 insert into PJI_MT_PRC_STEPS
1928 (
1929 PROCESS_NAME,
1930 STEP_NAME,
1931 STEP_SEQ,
1932 STEP_TYPE,
1933 CONFIG_PROJ_PERF_FLAG,
1934 CONFIG_COST_FLAG,
1935 CONFIG_PROFIT_FLAG,
1936 CONFIG_UTIL_FLAG
1937 )
1938 values
1939 (
1940 'PJI_EXTR',
1941 'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);',
1942 l_step_seq,
1943 to_char(1 + 2 + 4 + 8), -- generic
1944 'Y',
1945 'N',
1946 'N',
1947 'N'
1948 );
1949
1950 l_step_seq := l_step_seq + 10;
1951
1952 insert into PJI_MT_PRC_STEPS
1953 (
1954 PROCESS_NAME,
1955 STEP_NAME,
1956 STEP_SEQ,
1957 STEP_TYPE,
1958 CONFIG_PROJ_PERF_FLAG,
1959 CONFIG_COST_FLAG,
1960 CONFIG_PROFIT_FLAG,
1961 CONFIG_UTIL_FLAG
1962 )
1963 values
1964 (
1965 'PJI_EXTR',
1966 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);',
1967 l_step_seq,
1968 to_char(1 + 2 + 4 + 8), -- generic
1969 'Y',
1970 'N',
1971 'N',
1972 'N'
1973 );
1974
1975 l_step_seq := l_step_seq + 10;
1976
1977 insert into PJI_MT_PRC_STEPS
1978 (
1979 PROCESS_NAME,
1980 STEP_NAME,
1981 STEP_SEQ,
1982 STEP_TYPE,
1983 CONFIG_PROJ_PERF_FLAG,
1984 CONFIG_COST_FLAG,
1985 CONFIG_PROFIT_FLAG,
1986 CONFIG_UTIL_FLAG
1987 )
1988 values
1989 (
1990 'PJI_EXTR',
1991 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);',
1992 l_step_seq,
1993 to_char(1 + 2 + 4 + 8), -- generic
1994 'Y',
1995 'N',
1996 'N',
1997 'N'
1998 );
1999
2000 l_step_seq := l_step_seq + 10;
2001
2002 insert into PJI_MT_PRC_STEPS
2003 (
2004 PROCESS_NAME,
2005 STEP_NAME,
2006 STEP_SEQ,
2007 STEP_TYPE,
2008 CONFIG_PROJ_PERF_FLAG,
2009 CONFIG_COST_FLAG,
2010 CONFIG_PROFIT_FLAG,
2011 CONFIG_UTIL_FLAG
2012 )
2013 values
2014 (
2015 'PJI_EXTR',
2016 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);',
2017 l_step_seq,
2018 to_char(1 + 2 + 4 + 8), -- generic
2019 'Y',
2020 'N',
2021 'N',
2022 'N'
2023 );
2024
2025 l_step_seq := l_step_seq + 10;
2026
2027 insert into PJI_MT_PRC_STEPS
2028 (
2029 PROCESS_NAME,
2030 STEP_NAME,
2031 STEP_SEQ,
2032 STEP_TYPE,
2033 CONFIG_PROJ_PERF_FLAG,
2034 CONFIG_COST_FLAG,
2035 CONFIG_PROFIT_FLAG,
2036 CONFIG_UTIL_FLAG
2037 )
2038 values
2039 (
2040 'PJI_EXTR',
2041 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);',
2042 l_step_seq,
2043 to_char(1 + 2 + 4 + 8), -- generic
2044 'Y',
2045 'N',
2046 'N',
2047 'N'
2048 );
2049
2050 l_step_seq := l_step_seq + 10;
2051
2052 insert into PJI_MT_PRC_STEPS
2053 (
2054 PROCESS_NAME,
2055 STEP_NAME,
2056 STEP_SEQ,
2057 STEP_TYPE,
2058 CONFIG_PROJ_PERF_FLAG,
2059 CONFIG_COST_FLAG,
2060 CONFIG_PROFIT_FLAG,
2061 CONFIG_UTIL_FLAG
2062 )
2063 values
2064 (
2065 'PJI_EXTR',
2066 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);',
2067 l_step_seq,
2068 to_char(1 + 2 + 4 + 8), -- generic
2069 'Y',
2070 'N',
2071 'N',
2072 'N'
2073 );
2074
2075 l_step_seq := l_step_seq + 10;
2076
2077 insert into PJI_MT_PRC_STEPS
2078 (
2079 PROCESS_NAME,
2080 STEP_NAME,
2081 STEP_SEQ,
2082 STEP_TYPE,
2083 CONFIG_PROJ_PERF_FLAG,
2084 CONFIG_COST_FLAG,
2085 CONFIG_PROFIT_FLAG,
2086 CONFIG_UTIL_FLAG
2087 )
2088 values
2089 (
2090 'PJI_EXTR',
2091 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);',
2092 l_step_seq,
2093 to_char(1 + 2 + 4 + 8), -- generic
2094 'Y',
2095 'N',
2096 'N',
2097 'N'
2098 );
2099
2100 l_step_seq := l_step_seq + 10;
2101
2102 insert into PJI_MT_PRC_STEPS
2103 (
2104 PROCESS_NAME,
2105 STEP_NAME,
2106 STEP_SEQ,
2107 STEP_TYPE,
2108 CONFIG_PROJ_PERF_FLAG,
2109 CONFIG_COST_FLAG,
2110 CONFIG_PROFIT_FLAG,
2111 CONFIG_UTIL_FLAG
2112 )
2113 values
2114 (
2115 'PJI_EXTR',
2116 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);',
2117 l_step_seq,
2118 to_char(1 + 2 + 4 + 8), -- generic
2119 'Y',
2120 'N',
2121 'N',
2122 'N'
2123 );
2124
2125 l_step_seq := l_step_seq + 10;
2126
2127 insert into PJI_MT_PRC_STEPS
2128 (
2129 PROCESS_NAME,
2130 STEP_NAME,
2131 STEP_SEQ,
2132 STEP_TYPE,
2133 CONFIG_PROJ_PERF_FLAG,
2134 CONFIG_COST_FLAG,
2135 CONFIG_PROFIT_FLAG,
2136 CONFIG_UTIL_FLAG
2137 )
2138 values
2139 (
2140 'PJI_EXTR',
2141 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);',
2142 l_step_seq,
2143 to_char(1 + 2 + 4 + 8), -- generic
2144 'Y',
2145 'N',
2146 'N',
2147 'N'
2148 );
2149
2150 l_step_seq := l_step_seq + 10;
2151
2152 insert into PJI_MT_PRC_STEPS
2153 (
2154 PROCESS_NAME,
2155 STEP_NAME,
2156 STEP_SEQ,
2157 STEP_TYPE,
2158 CONFIG_PROJ_PERF_FLAG,
2159 CONFIG_COST_FLAG,
2160 CONFIG_PROFIT_FLAG,
2161 CONFIG_UTIL_FLAG
2162 )
2163 values
2164 (
2165 'PJI_EXTR',
2166 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);',
2167 l_step_seq,
2168 to_char(1 + 2 + 4 + 8), -- generic
2169 'Y',
2170 'N',
2171 'N',
2172 'N'
2173 );
2174
2175 l_step_seq := l_step_seq + 10;
2176
2177 insert into PJI_MT_PRC_STEPS
2178 (
2179 PROCESS_NAME,
2180 STEP_NAME,
2181 STEP_SEQ,
2182 STEP_TYPE,
2183 CONFIG_PROJ_PERF_FLAG,
2184 CONFIG_COST_FLAG,
2185 CONFIG_PROFIT_FLAG,
2186 CONFIG_UTIL_FLAG
2187 )
2188 values
2189 (
2190 'PJI_EXTR',
2191 'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);',
2192 l_step_seq,
2193 to_char(1 + 2 + 4 + 8), -- generic
2194 'Y',
2195 'N',
2196 'N',
2197 'N'
2198 );
2199
2200 l_step_seq := l_step_seq + 10;
2201
2202 insert into PJI_MT_PRC_STEPS
2203 (
2204 PROCESS_NAME,
2205 STEP_NAME,
2206 STEP_SEQ,
2207 STEP_TYPE,
2208 CONFIG_PROJ_PERF_FLAG,
2209 CONFIG_COST_FLAG,
2210 CONFIG_PROFIT_FLAG,
2211 CONFIG_UTIL_FLAG
2212 )
2213 values
2214 (
2215 'PJI_EXTR',
2216 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);',
2217 l_step_seq,
2218 to_char(1 + 2 + 4 + 8), -- generic
2219 'N',
2220 'N',
2221 'N',
2222 'Y'
2223 );
2224
2225 l_step_seq := l_step_seq + 10;
2226
2227 insert into PJI_MT_PRC_STEPS
2228 (
2229 PROCESS_NAME,
2230 STEP_NAME,
2231 STEP_SEQ,
2232 STEP_TYPE,
2233 CONFIG_PROJ_PERF_FLAG,
2234 CONFIG_COST_FLAG,
2235 CONFIG_PROFIT_FLAG,
2236 CONFIG_UTIL_FLAG
2237 )
2238 values
2239 (
2240 'PJI_EXTR',
2241 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);',
2242 l_step_seq,
2243 to_char(1 + 2 + 4 + 8), -- generic
2244 'N',
2245 'Y',
2246 'N',
2247 'N'
2248 );
2249
2250 l_step_seq := l_step_seq + 10;
2251
2252 insert into PJI_MT_PRC_STEPS
2253 (
2254 PROCESS_NAME,
2255 STEP_NAME,
2256 STEP_SEQ,
2257 STEP_TYPE,
2258 CONFIG_PROJ_PERF_FLAG,
2259 CONFIG_COST_FLAG,
2260 CONFIG_PROFIT_FLAG,
2261 CONFIG_UTIL_FLAG
2262 )
2263 values
2264 (
2265 'PJI_EXTR',
2266 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);',
2267 l_step_seq,
2268 to_char(1 + 2 + 4 + 8), -- generic
2269 'N',
2270 'N',
2271 'Y',
2272 'N'
2273 );
2274
2275 l_step_seq := l_step_seq + 10;
2276
2277 insert into PJI_MT_PRC_STEPS
2278 (
2279 PROCESS_NAME,
2280 STEP_NAME,
2281 STEP_SEQ,
2282 STEP_TYPE,
2283 CONFIG_PROJ_PERF_FLAG,
2284 CONFIG_COST_FLAG,
2285 CONFIG_PROFIT_FLAG,
2286 CONFIG_UTIL_FLAG
2287 )
2288 values
2289 (
2290 'PJI_EXTR',
2291 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);',
2292 l_step_seq,
2293 to_char(1 + 2 + 4 + 8), -- generic
2294 'N',
2295 'Y',
2296 'Y',
2297 'Y'
2298 );
2299
2300 l_step_seq := l_step_seq + 10;
2301
2302 insert into PJI_MT_PRC_STEPS
2303 (
2304 PROCESS_NAME,
2305 STEP_NAME,
2306 STEP_SEQ,
2307 STEP_TYPE,
2308 CONFIG_PROJ_PERF_FLAG,
2309 CONFIG_COST_FLAG,
2310 CONFIG_PROFIT_FLAG,
2311 CONFIG_UTIL_FLAG
2312 )
2313 values
2314 (
2315 'PJI_EXTR',
2316 'PJI_FM_SUM_EXTR.CLEANUP_WORKER(p_worker_id);',
2317 l_step_seq,
2318 to_char(1 + 2 + 4 + 8), -- generic
2319 'Y',
2320 'Y',
2321 'Y',
2322 'Y'
2323 );
2324
2325 -- ------------------------------------------------------------------------
2326 -- Stage 2 Summarization - Project Intellingence - FM and RM
2327 -- ------------------------------------------------------------------------
2328
2329 l_step_seq := 10;
2330
2331 insert into PJI_MT_PRC_STEPS
2332 (
2333 PROCESS_NAME,
2334 STEP_NAME,
2335 STEP_SEQ,
2336 STEP_TYPE,
2337 CONFIG_PROJ_PERF_FLAG,
2338 CONFIG_COST_FLAG,
2339 CONFIG_PROFIT_FLAG,
2340 CONFIG_UTIL_FLAG
2341 )
2342 values
2343 (
2344 'PJI_PJI',
2345 'PJI_RM_SUM_MAIN.INIT_PROCESS;',
2346 l_step_seq,
2347 to_char(1 + 2 + 4 + 8), -- generic
2348 'N',
2349 'Y',
2350 'Y',
2351 'Y'
2352 );
2353
2354 l_step_seq := l_step_seq + 10;
2355
2356 insert into PJI_MT_PRC_STEPS
2357 (
2358 PROCESS_NAME,
2359 STEP_NAME,
2360 STEP_SEQ,
2361 STEP_TYPE,
2362 CONFIG_PROJ_PERF_FLAG,
2363 CONFIG_COST_FLAG,
2364 CONFIG_PROFIT_FLAG,
2365 CONFIG_UTIL_FLAG
2366 )
2367 values
2368 (
2369 'PJI_PJI',
2370 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);',
2371 l_step_seq,
2372 to_char(1 + 2 + 4 + 8), -- generic
2373 'N',
2374 'Y',
2375 'Y',
2376 'Y'
2377 );
2378
2379 l_step_seq := l_step_seq + 10;
2380
2381 insert into PJI_MT_PRC_STEPS
2382 (
2383 PROCESS_NAME,
2384 STEP_NAME,
2385 STEP_SEQ,
2386 STEP_TYPE,
2387 CONFIG_PROJ_PERF_FLAG,
2388 CONFIG_COST_FLAG,
2389 CONFIG_PROFIT_FLAG,
2390 CONFIG_UTIL_FLAG
2391 )
2392 values
2393 (
2394 'PJI_PJI',
2395 'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);',
2396 l_step_seq,
2397 to_char(1 + 2 + 4 + 8), -- generic
2398 'N',
2399 'Y',
2400 'Y',
2401 'Y'
2402 );
2403
2404 l_step_seq := l_step_seq + 10;
2405
2406 insert into PJI_MT_PRC_STEPS
2407 (
2408 PROCESS_NAME,
2409 STEP_NAME,
2410 STEP_SEQ,
2411 STEP_TYPE,
2412 CONFIG_PROJ_PERF_FLAG,
2413 CONFIG_COST_FLAG,
2414 CONFIG_PROFIT_FLAG,
2415 CONFIG_UTIL_FLAG
2416 )
2417 values
2418 (
2419 'PJI_PJI',
2420 'PJI_RM_SUM_MAIN.RUN_PROCESS;',
2421 l_step_seq,
2422 to_char(1 + 2 + 4 + 8), -- generic
2423 'N',
2424 'Y',
2425 'Y',
2426 'Y'
2427 );
2428
2429 l_step_seq := l_step_seq + 10;
2430
2431 insert into PJI_MT_PRC_STEPS
2432 (
2433 PROCESS_NAME,
2434 STEP_NAME,
2435 STEP_SEQ,
2436 STEP_TYPE,
2437 CONFIG_PROJ_PERF_FLAG,
2438 CONFIG_COST_FLAG,
2439 CONFIG_PROFIT_FLAG,
2440 CONFIG_UTIL_FLAG
2441 )
2442 values
2443 (
2444 'PJI_PJI',
2445 'PJI_RM_SUM_MAIN.WRAPUP_PROCESS;',
2446 l_step_seq,
2447 to_char(1 + 2 + 4 + 8), -- generic
2448 'N',
2449 'Y',
2450 'Y',
2451 'Y'
2452 );
2453
2454 l_step_seq := l_step_seq + 10;
2455
2456 insert into PJI_MT_PRC_STEPS
2457 (
2458 PROCESS_NAME,
2459 STEP_NAME,
2460 STEP_SEQ,
2461 STEP_TYPE,
2462 CONFIG_PROJ_PERF_FLAG,
2463 CONFIG_COST_FLAG,
2464 CONFIG_PROFIT_FLAG,
2465 CONFIG_UTIL_FLAG
2466 )
2467 values
2468 (
2469 'PJI_PJI',
2470 'PJI_FM_PLAN_EXTR.UPDATE_PLAN_ORG_INFO(p_worker_id);',
2471 l_step_seq,
2472 to_char(1 + 2 + 4 + 8), -- generic
2473 'N',
2474 'Y',
2475 'N',
2476 'N'
2477 );
2478
2479 l_step_seq := l_step_seq + 10;
2480
2481 insert into PJI_MT_PRC_STEPS
2482 (
2483 PROCESS_NAME,
2484 STEP_NAME,
2485 STEP_SEQ,
2486 STEP_TYPE,
2487 CONFIG_PROJ_PERF_FLAG,
2488 CONFIG_COST_FLAG,
2489 CONFIG_PROFIT_FLAG,
2490 CONFIG_UTIL_FLAG
2491 )
2492 values
2493 (
2494 'PJI_PJI',
2495 'PJI_FM_PLAN_EXTR.EXTRACT_PLAN_VERSIONS(p_worker_id);',
2496 l_step_seq,
2497 to_char(1 + 2 + 4 + 8), -- generic
2498 'N',
2499 'Y',
2500 'N',
2501 'N'
2502 );
2503
2504 l_step_seq := l_step_seq + 10;
2505
2506 insert into PJI_MT_PRC_STEPS
2507 (
2508 PROCESS_NAME,
2509 STEP_NAME,
2510 STEP_SEQ,
2511 STEP_TYPE,
2512 CONFIG_PROJ_PERF_FLAG,
2513 CONFIG_COST_FLAG,
2514 CONFIG_PROFIT_FLAG,
2515 CONFIG_UTIL_FLAG
2516 )
2517 values
2518 (
2519 'PJI_PJI',
2520 'PJI_FM_PLAN_EXTR.EXTRACT_BATCH_PLAN(p_worker_id);',
2521 l_step_seq,
2522 to_char(1 + 2 + 4 + 8), -- generic
2523 'N',
2524 'Y',
2525 'N',
2526 'N'
2527 );
2528
2529 l_step_seq := l_step_seq + 10;
2530
2531 insert into PJI_MT_PRC_STEPS
2532 (
2533 PROCESS_NAME,
2534 STEP_NAME,
2535 STEP_SEQ,
2536 STEP_TYPE,
2537 CONFIG_PROJ_PERF_FLAG,
2538 CONFIG_COST_FLAG,
2539 CONFIG_PROFIT_FLAG,
2540 CONFIG_UTIL_FLAG
2541 )
2542 values
2543 (
2544 'PJI_PJI',
2545 'PJI_FM_PLAN_EXTR.SPREAD_ENT_PLANS(p_worker_id);',
2546 l_step_seq,
2547 to_char(1 + 2 + 4 + 8), -- generic
2548 'N',
2549 'Y',
2550 'N',
2551 'N'
2552 );
2553
2554 l_step_seq := l_step_seq + 10;
2555
2556 insert into PJI_MT_PRC_STEPS
2557 (
2558 PROCESS_NAME,
2559 STEP_NAME,
2560 STEP_SEQ,
2561 STEP_TYPE,
2562 CONFIG_PROJ_PERF_FLAG,
2563 CONFIG_COST_FLAG,
2564 CONFIG_PROFIT_FLAG,
2565 CONFIG_UTIL_FLAG
2566 )
2567 values
2568 (
2569 'PJI_PJI',
2570 'PJI_FM_PLAN_EXTR.PLAN_CURR_CONV_TABLE(p_worker_id);',
2571 l_step_seq,
2572 to_char(1 + 2 + 4 + 8), -- generic
2573 'N',
2574 'Y',
2575 'N',
2576 'N'
2577 );
2578
2579 l_step_seq := l_step_seq + 10;
2580
2581 insert into PJI_MT_PRC_STEPS
2582 (
2583 PROCESS_NAME,
2584 STEP_NAME,
2585 STEP_SEQ,
2586 STEP_TYPE,
2587 CONFIG_PROJ_PERF_FLAG,
2588 CONFIG_COST_FLAG,
2589 CONFIG_PROFIT_FLAG,
2590 CONFIG_UTIL_FLAG
2591 )
2592 values
2593 (
2594 'PJI_PJI',
2595 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL_CURRENCY(p_worker_id);',
2596 l_step_seq,
2597 to_char(1 + 2 + 4 + 8), -- generic
2598 'N',
2599 'Y',
2600 'N',
2601 'N'
2602 );
2603
2604 l_step_seq := l_step_seq + 10;
2605
2606 insert into PJI_MT_PRC_STEPS
2607 (
2608 PROCESS_NAME,
2609 STEP_NAME,
2610 STEP_SEQ,
2611 STEP_TYPE,
2612 CONFIG_PROJ_PERF_FLAG,
2613 CONFIG_COST_FLAG,
2614 CONFIG_PROFIT_FLAG,
2615 CONFIG_UTIL_FLAG
2616 )
2617 values
2618 (
2619 'PJI_PJI',
2620 'PJI_FM_PLAN_EXTR.CONVERT_TO_GLOBAL2_CURRENCY(p_worker_id);',
2621 l_step_seq,
2622 to_char(1 + 2 + 4 + 8), -- generic
2623 'N',
2624 'Y',
2625 'N',
2626 'N'
2627 );
2628
2629 l_step_seq := l_step_seq + 10;
2630
2631 insert into PJI_MT_PRC_STEPS
2632 (
2633 PROCESS_NAME,
2634 STEP_NAME,
2635 STEP_SEQ,
2636 STEP_TYPE,
2637 CONFIG_PROJ_PERF_FLAG,
2638 CONFIG_COST_FLAG,
2639 CONFIG_PROFIT_FLAG,
2640 CONFIG_UTIL_FLAG
2641 )
2642 values
2643 (
2644 'PJI_PJI',
2645 'PJI_FM_PLAN_EXTR.CONVERT_TO_PA_PERIODS(p_worker_id);',
2646 l_step_seq,
2647 to_char(1 + 2 + 4 + 8), -- generic
2648 'N',
2649 'Y',
2650 'N',
2651 'N'
2652 );
2653
2654 l_step_seq := l_step_seq + 10;
2655
2656 insert into PJI_MT_PRC_STEPS
2657 (
2658 PROCESS_NAME,
2659 STEP_NAME,
2660 STEP_SEQ,
2661 STEP_TYPE,
2662 CONFIG_PROJ_PERF_FLAG,
2663 CONFIG_COST_FLAG,
2664 CONFIG_PROFIT_FLAG,
2665 CONFIG_UTIL_FLAG
2666 )
2667 values
2668 (
2669 'PJI_PJI',
2670 'PJI_FM_PLAN_EXTR.CONVERT_TO_GL_PERIODS(p_worker_id);',
2671 l_step_seq,
2672 to_char(1 + 2 + 4 + 8), -- generic
2673 'N',
2674 'Y',
2675 'N',
2676 'N'
2677 );
2678
2679 l_step_seq := l_step_seq + 10;
2680
2681 insert into PJI_MT_PRC_STEPS
2682 (
2683 PROCESS_NAME,
2684 STEP_NAME,
2685 STEP_SEQ,
2686 STEP_TYPE,
2687 CONFIG_PROJ_PERF_FLAG,
2688 CONFIG_COST_FLAG,
2689 CONFIG_PROFIT_FLAG,
2690 CONFIG_UTIL_FLAG
2691 )
2692 values
2693 (
2694 'PJI_PJI',
2695 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENT_PERIODS(p_worker_id);',
2696 l_step_seq,
2697 to_char(1 + 2 + 4 + 8), -- generic
2698 'N',
2699 'Y',
2700 'N',
2701 'N'
2702 );
2703
2704 l_step_seq := l_step_seq + 10;
2705
2706 insert into PJI_MT_PRC_STEPS
2707 (
2708 PROCESS_NAME,
2709 STEP_NAME,
2710 STEP_SEQ,
2711 STEP_TYPE,
2712 CONFIG_PROJ_PERF_FLAG,
2713 CONFIG_COST_FLAG,
2714 CONFIG_PROFIT_FLAG,
2715 CONFIG_UTIL_FLAG
2716 )
2717 values
2718 (
2719 'PJI_PJI',
2720 'PJI_FM_PLAN_EXTR.CONVERT_TO_ENTW_PERIODS(p_worker_id);',
2721 l_step_seq,
2722 to_char(1 + 2 + 4 + 8), -- generic
2723 'N',
2724 'Y',
2725 'N',
2726 'N'
2727 );
2728
2729 l_step_seq := l_step_seq + 10;
2730
2731 insert into PJI_MT_PRC_STEPS
2732 (
2733 PROCESS_NAME,
2734 STEP_NAME,
2735 STEP_SEQ,
2736 STEP_TYPE,
2737 CONFIG_PROJ_PERF_FLAG,
2738 CONFIG_COST_FLAG,
2739 CONFIG_PROFIT_FLAG,
2740 CONFIG_UTIL_FLAG
2741 )
2742 values
2743 (
2744 'PJI_PJI',
2745 'PJI_FM_PLAN_EXTR.DANGLING_PLAN_VERSIONS(p_worker_id);',
2746 l_step_seq,
2747 to_char(1 + 2 + 4 + 8), -- generic
2748 'N',
2749 'Y',
2750 'N',
2751 'N'
2752 );
2753
2754 l_step_seq := l_step_seq + 10;
2755
2756 insert into PJI_MT_PRC_STEPS
2757 (
2758 PROCESS_NAME,
2759 STEP_NAME,
2760 STEP_SEQ,
2761 STEP_TYPE,
2762 CONFIG_PROJ_PERF_FLAG,
2763 CONFIG_COST_FLAG,
2764 CONFIG_PROFIT_FLAG,
2765 CONFIG_UTIL_FLAG
2766 )
2767 values
2768 (
2769 'PJI_PJI',
2770 'PJI_FM_PLAN_EXTR.SUMMARIZE_EXTRACT(p_worker_id);',
2771 l_step_seq,
2772 to_char(1 + 2 + 4 + 8), -- generic
2773 'N',
2774 'Y',
2775 'N',
2776 'N'
2777 );
2778
2779 l_step_seq := l_step_seq + 10;
2780
2781 insert into PJI_MT_PRC_STEPS
2782 (
2783 PROCESS_NAME,
2784 STEP_NAME,
2785 STEP_SEQ,
2786 STEP_TYPE,
2787 CONFIG_PROJ_PERF_FLAG,
2788 CONFIG_COST_FLAG,
2789 CONFIG_PROFIT_FLAG,
2790 CONFIG_UTIL_FLAG
2791 )
2792 values
2793 (
2794 'PJI_PJI',
2795 'PJI_FM_PLAN_EXTR.EXTRACT_UPDATED_VERSIONS(p_worker_id);',
2796 l_step_seq,
2797 to_char(1 + 2 + 4 + 8), -- generic
2798 'N',
2799 'Y',
2800 'N',
2801 'N'
2802 );
2803
2804 l_step_seq := l_step_seq + 10;
2805
2806 insert into PJI_MT_PRC_STEPS
2807 (
2808 PROCESS_NAME,
2809 STEP_NAME,
2810 STEP_SEQ,
2811 STEP_TYPE,
2812 CONFIG_PROJ_PERF_FLAG,
2813 CONFIG_COST_FLAG,
2814 CONFIG_PROFIT_FLAG,
2815 CONFIG_UTIL_FLAG
2816 )
2817 values
2818 (
2819 'PJI_PJI',
2820 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_PRE(p_worker_id);',
2821 l_step_seq,
2822 to_char(1 + 2 + 4 + 8), -- generic
2823 'N',
2824 'Y',
2825 'N',
2826 'N'
2827 );
2828
2829 l_step_seq := l_step_seq + 10;
2830
2831 -- helper step
2832 insert into PJI_MT_PRC_STEPS
2833 (
2834 PROCESS_NAME,
2835 STEP_NAME,
2836 STEP_SEQ,
2837 STEP_TYPE,
2838 CONFIG_PROJ_PERF_FLAG,
2839 CONFIG_COST_FLAG,
2840 CONFIG_PROFIT_FLAG,
2841 CONFIG_UTIL_FLAG
2842 )
2843 values
2844 (
2845 'PJI_PJI_HELPER',
2846 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS(p_worker_id);',
2847 l_step_seq,
2848 to_char(1 + 2 + 4 + 8), -- generic
2849 'N',
2850 'Y',
2851 'N',
2852 'N'
2853 );
2854
2855 l_step_seq := l_step_seq + 10;
2856
2857 insert into PJI_MT_PRC_STEPS
2858 (
2859 PROCESS_NAME,
2860 STEP_NAME,
2861 STEP_SEQ,
2862 STEP_TYPE,
2863 CONFIG_PROJ_PERF_FLAG,
2864 CONFIG_COST_FLAG,
2865 CONFIG_PROFIT_FLAG,
2866 CONFIG_UTIL_FLAG
2867 )
2868 values
2869 (
2870 'PJI_PJI',
2871 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_VERSIONS_POST(p_worker_id);',
2872 l_step_seq,
2873 to_char(1 + 2 + 4 + 8), -- generic
2874 'N',
2875 'Y',
2876 'N',
2877 'N'
2878 );
2879
2880 l_step_seq := l_step_seq + 10;
2881
2882 insert into PJI_MT_PRC_STEPS
2883 (
2884 PROCESS_NAME,
2885 STEP_NAME,
2886 STEP_SEQ,
2887 STEP_TYPE,
2888 CONFIG_PROJ_PERF_FLAG,
2889 CONFIG_COST_FLAG,
2890 CONFIG_PROFIT_FLAG,
2891 CONFIG_UTIL_FLAG
2892 )
2893 values
2894 (
2895 'PJI_PJI',
2896 'PJI_FM_PLAN_EXTR.UPDATE_BATCH_STATUSES(p_worker_id);',
2897 l_step_seq,
2898 to_char(1 + 2 + 4 + 8), -- generic
2899 'N',
2900 'Y',
2901 'Y',
2902 'N'
2903 );
2904
2905 l_step_seq := l_step_seq + 10;
2906
2907 insert into PJI_MT_PRC_STEPS
2908 (
2909 PROCESS_NAME,
2910 STEP_NAME,
2911 STEP_SEQ,
2912 STEP_TYPE,
2913 CONFIG_PROJ_PERF_FLAG,
2914 CONFIG_COST_FLAG,
2915 CONFIG_PROFIT_FLAG,
2916 CONFIG_UTIL_FLAG
2917 )
2918 values
2919 (
2920 'PJI_PJI',
2921 'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);',
2922 l_step_seq,
2923 to_char(1 + 2 + 4 + 8), -- generic
2924 'N',
2925 'Y',
2926 'Y',
2927 'N'
2928 );
2929
2930 l_step_seq := l_step_seq + 10;
2931
2932 insert into PJI_MT_PRC_STEPS
2933 (
2934 PROCESS_NAME,
2935 STEP_NAME,
2936 STEP_SEQ,
2937 STEP_TYPE,
2938 CONFIG_PROJ_PERF_FLAG,
2939 CONFIG_COST_FLAG,
2940 CONFIG_PROFIT_FLAG,
2941 CONFIG_UTIL_FLAG
2942 )
2943 values
2944 (
2945 'PJI_PJI',
2946 'PJI_RM_SUM_EXTR.PROCESS_DANGLING_ROWS(p_worker_id);',
2947 l_step_seq,
2948 to_char(1 + 2 + 4 + 8), -- generic
2949 'N',
2950 'N',
2951 'N',
2952 'Y'
2953 );
2954
2955 l_step_seq := l_step_seq + 10;
2956
2957 insert into PJI_MT_PRC_STEPS
2958 (
2959 PROCESS_NAME,
2960 STEP_NAME,
2961 STEP_SEQ,
2962 STEP_TYPE,
2963 CONFIG_PROJ_PERF_FLAG,
2964 CONFIG_COST_FLAG,
2965 CONFIG_PROFIT_FLAG,
2966 CONFIG_UTIL_FLAG
2967 )
2968 values
2969 (
2970 'PJI_PJI',
2971 'PJI_RM_SUM_EXTR.PURGE_DANGLING_ROWS(p_worker_id);',
2972 l_step_seq,
2973 to_char(1 + 2 + 4 + 8), -- generic
2974 'N',
2975 'N',
2976 'N',
2977 'Y'
2978 );
2979
2980 l_step_seq := l_step_seq + 10;
2981
2982 insert into PJI_MT_PRC_STEPS
2983 (
2984 PROCESS_NAME,
2985 STEP_NAME,
2986 STEP_SEQ,
2987 STEP_TYPE,
2988 CONFIG_PROJ_PERF_FLAG,
2989 CONFIG_COST_FLAG,
2990 CONFIG_PROFIT_FLAG,
2991 CONFIG_UTIL_FLAG
2992 )
2993 values
2994 (
2995 'PJI_PJI',
2996 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);',
2997 l_step_seq,
2998 to_char(2 + 4), -- incremental + partial
2999 'N',
3000 'N',
3001 'N',
3002 'Y'
3003 );
3004
3005 l_step_seq := l_step_seq + 10;
3006
3007 insert into PJI_MT_PRC_STEPS
3008 (
3009 PROCESS_NAME,
3010 STEP_NAME,
3011 STEP_SEQ,
3012 STEP_TYPE,
3013 CONFIG_PROJ_PERF_FLAG,
3014 CONFIG_COST_FLAG,
3015 CONFIG_PROFIT_FLAG,
3016 CONFIG_UTIL_FLAG
3017 )
3018 values
3019 (
3020 'PJI_PJI',
3021 'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID_ROWIDS(p_worker_id);',
3022 l_step_seq,
3023 to_char(1 + 2 + 4 + 8), -- generic
3024 'N',
3025 'N',
3026 'N',
3027 'Y'
3028 );
3029
3030 l_step_seq := l_step_seq + 10;
3031
3032 insert into PJI_MT_PRC_STEPS
3033 (
3034 PROCESS_NAME,
3035 STEP_NAME,
3036 STEP_SEQ,
3037 STEP_TYPE,
3038 CONFIG_PROJ_PERF_FLAG,
3039 CONFIG_COST_FLAG,
3040 CONFIG_PROFIT_FLAG,
3041 CONFIG_UTIL_FLAG
3042 )
3043 values
3044 (
3045 'PJI_PJI',
3046 'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_PRE(p_worker_id);',
3047 l_step_seq,
3048 to_char(1 + 2 + 4 + 8), -- generic
3049 'N',
3050 'N',
3051 'N',
3052 'Y'
3053 );
3054
3055 l_step_seq := l_step_seq + 10;
3056
3057 -- helper step
3058 insert into PJI_MT_PRC_STEPS
3059 (
3060 PROCESS_NAME,
3061 STEP_NAME,
3062 STEP_SEQ,
3063 STEP_TYPE,
3064 CONFIG_PROJ_PERF_FLAG,
3065 CONFIG_COST_FLAG,
3066 CONFIG_PROFIT_FLAG,
3067 CONFIG_UTIL_FLAG
3068 )
3069 values
3070 (
3071 'PJI_PJI_HELPER',
3072 'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS(p_worker_id);',
3073 l_step_seq,
3074 to_char(1 + 2 + 4 + 8), -- generic
3075 'N',
3076 'N',
3077 'N',
3078 'Y'
3079 );
3080
3081 l_step_seq := l_step_seq + 10;
3082
3083 insert into PJI_MT_PRC_STEPS
3084 (
3085 PROCESS_NAME,
3086 STEP_NAME,
3087 STEP_SEQ,
3088 STEP_TYPE,
3089 CONFIG_PROJ_PERF_FLAG,
3090 CONFIG_COST_FLAG,
3091 CONFIG_PROFIT_FLAG,
3092 CONFIG_UTIL_FLAG
3093 )
3094 values
3095 (
3096 'PJI_PJI',
3097 'PJI_RM_SUM_EXTR.MARK_EXTRACTED_ROWS_POST(p_worker_id);',
3098 l_step_seq,
3099 to_char(1 + 2 + 4 + 8), -- generic
3100 'N',
3101 'N',
3102 'N',
3103 'Y'
3104 );
3105
3106 l_step_seq := l_step_seq + 10;
3107
3108 insert into PJI_MT_PRC_STEPS
3109 (
3110 PROCESS_NAME,
3111 STEP_NAME,
3112 STEP_SEQ,
3113 STEP_TYPE,
3114 CONFIG_PROJ_PERF_FLAG,
3115 CONFIG_COST_FLAG,
3116 CONFIG_PROFIT_FLAG,
3117 CONFIG_UTIL_FLAG
3118 )
3119 values
3120 (
3121 'PJI_PJI',
3122 'PJI_RM_SUM_EXTR.RES_ROWID_TABLE(p_worker_id);',
3123 l_step_seq,
3124 to_char(1 + 2 + 4 + 8), -- generic
3125 'N',
3126 'N',
3127 'N',
3128 'Y'
3129 );
3130
3131 l_step_seq := l_step_seq + 10;
3132
3133 insert into PJI_MT_PRC_STEPS
3134 (
3135 PROCESS_NAME,
3136 STEP_NAME,
3137 STEP_SEQ,
3138 STEP_TYPE,
3139 CONFIG_PROJ_PERF_FLAG,
3140 CONFIG_COST_FLAG,
3141 CONFIG_PROFIT_FLAG,
3142 CONFIG_UTIL_FLAG
3143 )
3144 values
3145 (
3146 'PJI_PJI',
3147 'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID_FULL(p_worker_id);',
3148 l_step_seq,
3149 to_char(1), -- full
3150 'N',
3151 'N',
3152 'N',
3153 'Y'
3154 );
3155
3156 l_step_seq := l_step_seq + 10;
3157
3158 insert into PJI_MT_PRC_STEPS
3159 (
3160 PROCESS_NAME,
3161 STEP_NAME,
3162 STEP_SEQ,
3163 STEP_TYPE,
3164 CONFIG_PROJ_PERF_FLAG,
3165 CONFIG_COST_FLAG,
3166 CONFIG_PROFIT_FLAG,
3167 CONFIG_UTIL_FLAG
3168 )
3169 values
3170 (
3171 'PJI_PJI',
3172 'PJI_RM_SUM_EXTR.EXTRACT_BATCH_FID(p_worker_id);',
3173 l_step_seq,
3174 to_char(2 + 4), -- incremental + partial
3175 'N',
3176 'N',
3177 'N',
3178 'Y'
3179 );
3180
3181 l_step_seq := l_step_seq + 10;
3182
3183 insert into PJI_MT_PRC_STEPS
3184 (
3185 PROCESS_NAME,
3186 STEP_NAME,
3187 STEP_SEQ,
3188 STEP_TYPE,
3189 CONFIG_PROJ_PERF_FLAG,
3190 CONFIG_COST_FLAG,
3191 CONFIG_PROFIT_FLAG,
3192 CONFIG_UTIL_FLAG
3193 )
3194 values
3195 (
3196 'PJI_PJI',
3197 'PJI_RM_SUM_EXTR.MOVE_DANGLING_ROWS(p_worker_id);',
3198 l_step_seq,
3199 to_char(1 + 2 + 4 + 8), -- generic
3200 'N',
3201 'N',
3202 'N',
3203 'Y'
3204 );
3205
3206 l_step_seq := l_step_seq + 10;
3207
3208 insert into PJI_MT_PRC_STEPS
3209 (
3210 PROCESS_NAME,
3211 STEP_NAME,
3212 STEP_SEQ,
3213 STEP_TYPE,
3214 CONFIG_PROJ_PERF_FLAG,
3215 CONFIG_COST_FLAG,
3216 CONFIG_PROFIT_FLAG,
3217 CONFIG_UTIL_FLAG
3218 )
3219 values
3220 (
3221 'PJI_PJI',
3222 'PJI_RM_SUM_EXTR.PURGE_RES_DATA(p_worker_id);',
3223 l_step_seq,
3224 to_char(1 + 2 + 4 + 8), -- generic
3225 'N',
3226 'N',
3227 'N',
3228 'Y'
3229 );
3230
3231 l_step_seq := l_step_seq + 10;
3232
3233 insert into PJI_MT_PRC_STEPS
3234 (
3235 PROCESS_NAME,
3236 STEP_NAME,
3237 STEP_SEQ,
3238 STEP_TYPE,
3239 CONFIG_PROJ_PERF_FLAG,
3240 CONFIG_COST_FLAG,
3241 CONFIG_PROFIT_FLAG,
3242 CONFIG_UTIL_FLAG
3243 )
3244 values
3245 (
3246 'PJI_PJI',
3247 'PJI_RM_SUM_EXTR.GET_JOB_ID_LOOKUPS(p_worker_id);',
3248 l_step_seq,
3249 to_char(1 + 2 + 4 + 8), -- generic
3250 'N',
3251 'N',
3252 'N',
3253 'Y'
3254 );
3255
3256 l_step_seq := l_step_seq + 10;
3257
3258 insert into PJI_MT_PRC_STEPS
3259 (
3260 PROCESS_NAME,
3261 STEP_NAME,
3262 STEP_SEQ,
3263 STEP_TYPE,
3264 CONFIG_PROJ_PERF_FLAG,
3265 CONFIG_COST_FLAG,
3266 CONFIG_PROFIT_FLAG,
3267 CONFIG_UTIL_FLAG
3268 )
3269 values
3270 (
3271 'PJI_PJI',
3272 'PJI_RM_SUM_EXTR.PROCESS_JOB_ID(p_worker_id);',
3273 l_step_seq,
3274 to_char(1 + 2 + 4 + 8), -- generic
3275 'N',
3276 'N',
3277 'N',
3278 'Y'
3279 );
3280
3281 l_step_seq := l_step_seq + 10;
3282
3283 insert into PJI_MT_PRC_STEPS
3284 (
3285 PROCESS_NAME,
3286 STEP_NAME,
3287 STEP_SEQ,
3288 STEP_TYPE,
3289 CONFIG_PROJ_PERF_FLAG,
3290 CONFIG_COST_FLAG,
3291 CONFIG_PROFIT_FLAG,
3292 CONFIG_UTIL_FLAG
3293 )
3294 values
3295 (
3296 'PJI_PJI',
3297 'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);',
3298 l_step_seq,
3299 to_char(1 + 2 + 4 + 8), -- generic
3300 'N',
3301 'N',
3302 'N',
3303 'Y'
3304 );
3305
3306 l_step_seq := l_step_seq + 10;
3307
3308 insert into PJI_MT_PRC_STEPS
3309 (
3310 PROCESS_NAME,
3311 STEP_NAME,
3312 STEP_SEQ,
3313 STEP_TYPE,
3314 CONFIG_PROJ_PERF_FLAG,
3315 CONFIG_COST_FLAG,
3316 CONFIG_PROFIT_FLAG,
3317 CONFIG_UTIL_FLAG
3318 )
3319 values
3320 (
3321 'PJI_PJI',
3322 'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);',
3323 l_step_seq,
3324 to_char(1 + 2 + 4 + 8), -- generic
3325 'N',
3326 'N',
3327 'N',
3328 'Y'
3329 );
3330
3331 l_step_seq := l_step_seq + 10;
3332
3333 -- helper step
3334 insert into PJI_MT_PRC_STEPS
3335 (
3336 PROCESS_NAME,
3337 STEP_NAME,
3338 STEP_SEQ,
3339 STEP_TYPE,
3340 CONFIG_PROJ_PERF_FLAG,
3341 CONFIG_COST_FLAG,
3342 CONFIG_PROFIT_FLAG,
3343 CONFIG_UTIL_FLAG
3344 )
3345 values
3346 (
3347 'PJI_PJI_HELPER',
3348 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);',
3349 l_step_seq,
3350 to_char(1 + 2 + 4 + 8), -- generic
3351 'N',
3352 'N',
3353 'N',
3354 'Y'
3355 );
3356
3357 l_step_seq := l_step_seq + 10;
3358
3359 insert into PJI_MT_PRC_STEPS
3360 (
3361 PROCESS_NAME,
3362 STEP_NAME,
3363 STEP_SEQ,
3364 STEP_TYPE,
3365 CONFIG_PROJ_PERF_FLAG,
3366 CONFIG_COST_FLAG,
3367 CONFIG_PROFIT_FLAG,
3368 CONFIG_UTIL_FLAG
3369 )
3370 values
3371 (
3372 'PJI_PJI',
3373 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_FIN(p_worker_id);',
3374 l_step_seq,
3375 to_char(1 + 2 + 4 + 8), -- generic
3376 'Y',
3377 'Y',
3378 'N',
3379 'Y'
3380 );
3381
3382 l_step_seq := l_step_seq + 10;
3383
3384 insert into PJI_MT_PRC_STEPS
3385 (
3386 PROCESS_NAME,
3387 STEP_NAME,
3388 STEP_SEQ,
3389 STEP_TYPE,
3390 CONFIG_PROJ_PERF_FLAG,
3391 CONFIG_COST_FLAG,
3392 CONFIG_PROFIT_FLAG,
3393 CONFIG_UTIL_FLAG
3394 )
3395 values
3396 (
3397 'PJI_PJI',
3398 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_FIN(p_worker_id);',
3399 l_step_seq,
3400 to_char(1 + 2 + 4 + 8), -- generic
3401 'Y',
3402 'Y',
3403 'N',
3404 'Y'
3405 );
3406
3407 l_step_seq := l_step_seq + 10;
3408
3409 insert into PJI_MT_PRC_STEPS
3410 (
3411 PROCESS_NAME,
3412 STEP_NAME,
3413 STEP_SEQ,
3414 STEP_TYPE,
3415 CONFIG_PROJ_PERF_FLAG,
3416 CONFIG_COST_FLAG,
3417 CONFIG_PROFIT_FLAG,
3418 CONFIG_UTIL_FLAG
3419 )
3420 values
3421 (
3422 'PJI_PJI',
3423 'PJI_FM_SUM_BKLG.ROWID_ACTIVITY_DATES_ACT(p_worker_id);',
3424 l_step_seq,
3425 to_char(1 + 2 + 4 + 8), -- generic
3426 'Y',
3427 'N',
3428 'Y',
3429 'N'
3430 );
3431
3432 l_step_seq := l_step_seq + 10;
3433
3434 insert into PJI_MT_PRC_STEPS
3435 (
3436 PROCESS_NAME,
3437 STEP_NAME,
3438 STEP_SEQ,
3439 STEP_TYPE,
3440 CONFIG_PROJ_PERF_FLAG,
3441 CONFIG_COST_FLAG,
3442 CONFIG_PROFIT_FLAG,
3443 CONFIG_UTIL_FLAG
3444 )
3445 values
3446 (
3447 'PJI_PJI',
3448 'PJI_FM_SUM_BKLG.UPDATE_ACTIVITY_DATES_ACT(p_worker_id);',
3449 l_step_seq,
3450 to_char(1 + 2 + 4 + 8), -- generic
3451 'Y',
3452 'N',
3453 'Y',
3454 'N'
3455 );
3456
3457 l_step_seq := l_step_seq + 10;
3458
3459 insert into PJI_MT_PRC_STEPS
3460 (
3461 PROCESS_NAME,
3462 STEP_NAME,
3463 STEP_SEQ,
3464 STEP_TYPE,
3465 CONFIG_PROJ_PERF_FLAG,
3466 CONFIG_COST_FLAG,
3467 CONFIG_PROFIT_FLAG,
3468 CONFIG_UTIL_FLAG
3469 )
3470 values
3471 (
3472 'PJI_PJI',
3473 'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);',
3474 l_step_seq,
3475 to_char(1 + 2 + 4 + 8), -- generic
3476 'N',
3477 'Y',
3478 'Y',
3479 'N'
3480 );
3481
3482 l_step_seq := l_step_seq + 10;
3483
3484 insert into PJI_MT_PRC_STEPS
3485 (
3486 PROCESS_NAME,
3487 STEP_NAME,
3488 STEP_SEQ,
3489 STEP_TYPE,
3490 CONFIG_PROJ_PERF_FLAG,
3491 CONFIG_COST_FLAG,
3492 CONFIG_PROFIT_FLAG,
3493 CONFIG_UTIL_FLAG
3494 )
3495 values
3496 (
3497 'PJI_PJI',
3498 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);',
3499 l_step_seq,
3500 to_char(1 + 2 + 4 + 8), -- generic
3501 'N',
3502 'Y',
3503 'Y',
3504 'N'
3505 );
3506
3507 l_step_seq := l_step_seq + 10;
3508
3509 insert into PJI_MT_PRC_STEPS
3510 (
3511 PROCESS_NAME,
3512 STEP_NAME,
3513 STEP_SEQ,
3514 STEP_TYPE,
3515 CONFIG_PROJ_PERF_FLAG,
3516 CONFIG_COST_FLAG,
3517 CONFIG_PROFIT_FLAG,
3518 CONFIG_UTIL_FLAG
3519 )
3520 values
3521 (
3522 'PJI_PJI',
3523 'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);',
3524 l_step_seq,
3525 to_char(1 + 2 + 4 + 8), -- generic
3526 'N',
3527 'Y',
3528 'Y',
3529 'N'
3530 );
3531
3532 l_step_seq := l_step_seq + 10;
3533
3534 insert into PJI_MT_PRC_STEPS
3535 (
3536 PROCESS_NAME,
3537 STEP_NAME,
3538 STEP_SEQ,
3539 STEP_TYPE,
3540 CONFIG_PROJ_PERF_FLAG,
3541 CONFIG_COST_FLAG,
3542 CONFIG_PROFIT_FLAG,
3543 CONFIG_UTIL_FLAG
3544 )
3545 values
3546 (
3547 'PJI_PJI',
3548 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);',
3549 l_step_seq,
3550 to_char(1 + 2 + 4 + 8), -- generic
3551 'N',
3552 'Y',
3553 'Y',
3554 'N'
3555 );
3556
3557 l_step_seq := l_step_seq + 10;
3558
3559 insert into PJI_MT_PRC_STEPS
3560 (
3561 PROCESS_NAME,
3562 STEP_NAME,
3563 STEP_SEQ,
3564 STEP_TYPE,
3565 CONFIG_PROJ_PERF_FLAG,
3566 CONFIG_COST_FLAG,
3567 CONFIG_PROFIT_FLAG,
3568 CONFIG_UTIL_FLAG
3569 )
3570 values
3571 (
3572 'PJI_PJI',
3573 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);',
3574 l_step_seq,
3575 to_char(1 + 2 + 4 + 8), -- generic
3576 'N',
3577 'Y',
3578 'Y',
3579 'N'
3580 );
3581
3582 l_step_seq := l_step_seq + 10;
3583
3584 insert into PJI_MT_PRC_STEPS
3585 (
3586 PROCESS_NAME,
3587 STEP_NAME,
3588 STEP_SEQ,
3589 STEP_TYPE,
3590 CONFIG_PROJ_PERF_FLAG,
3591 CONFIG_COST_FLAG,
3592 CONFIG_PROFIT_FLAG,
3593 CONFIG_UTIL_FLAG
3594 )
3595 values
3596 (
3597 'PJI_PJI',
3598 'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);',
3599 l_step_seq,
3600 to_char(1 + 2 + 4 + 8), -- generic
3601 'N',
3602 'Y',
3603 'Y',
3604 'N'
3605 );
3606
3607 l_step_seq := l_step_seq + 10;
3608
3609 insert into PJI_MT_PRC_STEPS
3610 (
3611 PROCESS_NAME,
3612 STEP_NAME,
3613 STEP_SEQ,
3614 STEP_TYPE,
3615 CONFIG_PROJ_PERF_FLAG,
3616 CONFIG_COST_FLAG,
3617 CONFIG_PROFIT_FLAG,
3618 CONFIG_UTIL_FLAG
3619 )
3620 values
3621 (
3622 'PJI_PJI',
3623 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);',
3624 l_step_seq,
3625 to_char(1 + 2 + 4 + 8), -- generic
3626 'N',
3627 'Y',
3628 'Y',
3629 'N'
3630 );
3631
3632 l_step_seq := l_step_seq + 10;
3633
3634 insert into PJI_MT_PRC_STEPS
3635 (
3636 PROCESS_NAME,
3637 STEP_NAME,
3638 STEP_SEQ,
3639 STEP_TYPE,
3640 CONFIG_PROJ_PERF_FLAG,
3641 CONFIG_COST_FLAG,
3642 CONFIG_PROFIT_FLAG,
3643 CONFIG_UTIL_FLAG
3644 )
3645 values
3646 (
3647 'PJI_PJI',
3648 'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);',
3649 l_step_seq,
3650 to_char(1 + 2 + 4 + 8), -- generic
3651 'N',
3652 'Y',
3653 'Y',
3654 'N'
3655 );
3656
3657 l_step_seq := l_step_seq + 10;
3658
3659 insert into PJI_MT_PRC_STEPS
3660 (
3661 PROCESS_NAME,
3662 STEP_NAME,
3663 STEP_SEQ,
3664 STEP_TYPE,
3665 CONFIG_PROJ_PERF_FLAG,
3666 CONFIG_COST_FLAG,
3667 CONFIG_PROFIT_FLAG,
3668 CONFIG_UTIL_FLAG
3669 )
3670 values
3671 (
3672 'PJI_PJI',
3673 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);',
3674 l_step_seq,
3675 to_char(1 + 2 + 4 + 8), -- generic
3676 'N',
3677 'N',
3678 'N',
3679 'Y'
3680 );
3681
3682 l_step_seq := l_step_seq + 10;
3683
3684 insert into PJI_MT_PRC_STEPS
3685 (
3686 PROCESS_NAME,
3687 STEP_NAME,
3688 STEP_SEQ,
3689 STEP_TYPE,
3690 CONFIG_PROJ_PERF_FLAG,
3691 CONFIG_COST_FLAG,
3692 CONFIG_PROFIT_FLAG,
3693 CONFIG_UTIL_FLAG
3694 )
3695 values
3696 (
3697 'PJI_PJI',
3698 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);',
3699 l_step_seq,
3700 to_char(1 + 2 + 4 + 8), -- generic
3701 'N',
3702 'N',
3703 'N',
3704 'Y'
3705 );
3706
3707 l_step_seq := l_step_seq + 10;
3708
3709 insert into PJI_MT_PRC_STEPS
3710 (
3711 PROCESS_NAME,
3712 STEP_NAME,
3713 STEP_SEQ,
3714 STEP_TYPE,
3715 CONFIG_PROJ_PERF_FLAG,
3716 CONFIG_COST_FLAG,
3717 CONFIG_PROFIT_FLAG,
3718 CONFIG_UTIL_FLAG
3719 )
3720 values
3721 (
3722 'PJI_PJI',
3723 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);',
3724 l_step_seq,
3725 to_char(1 + 2 + 4 + 8), -- generic
3726 'N',
3727 'N',
3728 'N',
3729 'Y'
3730 );
3731
3732 l_step_seq := l_step_seq + 10;
3733
3734 insert into PJI_MT_PRC_STEPS
3735 (
3736 PROCESS_NAME,
3737 STEP_NAME,
3738 STEP_SEQ,
3739 STEP_TYPE,
3740 CONFIG_PROJ_PERF_FLAG,
3741 CONFIG_COST_FLAG,
3742 CONFIG_PROFIT_FLAG,
3743 CONFIG_UTIL_FLAG
3744 )
3745 values
3746 (
3747 'PJI_PJI',
3748 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);',
3749 l_step_seq,
3750 to_char(1 + 2 + 4 + 8), -- generic
3751 'N',
3752 'N',
3753 'N',
3754 'Y'
3755 );
3756
3757 l_step_seq := l_step_seq + 10;
3758
3759 insert into PJI_MT_PRC_STEPS
3760 (
3761 PROCESS_NAME,
3762 STEP_NAME,
3763 STEP_SEQ,
3764 STEP_TYPE,
3765 CONFIG_PROJ_PERF_FLAG,
3766 CONFIG_COST_FLAG,
3767 CONFIG_PROFIT_FLAG,
3768 CONFIG_UTIL_FLAG
3769 )
3770 values
3771 (
3772 'PJI_PJI',
3773 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);',
3774 l_step_seq,
3775 to_char(1 + 2 + 4 + 8), -- generic
3776 'N',
3777 'N',
3778 'N',
3779 'Y'
3780 );
3781
3782 l_step_seq := l_step_seq + 10;
3783
3784 insert into PJI_MT_PRC_STEPS
3785 (
3786 PROCESS_NAME,
3787 STEP_NAME,
3788 STEP_SEQ,
3789 STEP_TYPE,
3790 CONFIG_PROJ_PERF_FLAG,
3791 CONFIG_COST_FLAG,
3792 CONFIG_PROFIT_FLAG,
3793 CONFIG_UTIL_FLAG
3794 )
3795 values
3796 (
3797 'PJI_PJI',
3798 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);',
3799 l_step_seq,
3800 to_char(1 + 2 + 4 + 8), -- generic
3801 'N',
3802 'N',
3803 'N',
3804 'Y'
3805 );
3806
3807 l_step_seq := l_step_seq + 10;
3808
3809 insert into PJI_MT_PRC_STEPS
3810 (
3811 PROCESS_NAME,
3812 STEP_NAME,
3813 STEP_SEQ,
3814 STEP_TYPE,
3815 CONFIG_PROJ_PERF_FLAG,
3816 CONFIG_COST_FLAG,
3817 CONFIG_PROFIT_FLAG,
3818 CONFIG_UTIL_FLAG
3819 )
3820 values
3821 (
3822 'PJI_PJI',
3823 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);',
3824 l_step_seq,
3825 to_char(1 + 2 + 4 + 8), -- generic
3826 'N',
3827 'N',
3828 'N',
3829 'Y'
3830 );
3831
3832 l_step_seq := l_step_seq + 10;
3833
3834 insert into PJI_MT_PRC_STEPS
3835 (
3836 PROCESS_NAME,
3837 STEP_NAME,
3838 STEP_SEQ,
3839 STEP_TYPE,
3840 CONFIG_PROJ_PERF_FLAG,
3841 CONFIG_COST_FLAG,
3842 CONFIG_PROFIT_FLAG,
3843 CONFIG_UTIL_FLAG
3844 )
3845 values
3846 (
3847 'PJI_PJI',
3848 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);',
3849 l_step_seq,
3850 to_char(1 + 2 + 4 + 8), -- generic
3851 'N',
3852 'N',
3853 'N',
3854 'Y'
3855 );
3856
3857 l_step_seq := l_step_seq + 10;
3858
3859 insert into PJI_MT_PRC_STEPS
3860 (
3861 PROCESS_NAME,
3862 STEP_NAME,
3863 STEP_SEQ,
3864 STEP_TYPE,
3865 CONFIG_PROJ_PERF_FLAG,
3866 CONFIG_COST_FLAG,
3867 CONFIG_PROFIT_FLAG,
3868 CONFIG_UTIL_FLAG
3869 )
3870 values
3871 (
3872 'PJI_PJI',
3873 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);',
3874 l_step_seq,
3875 to_char(1 + 2 + 4 + 8), -- generic
3876 'N',
3877 'Y',
3878 'N',
3879 'N'
3880 );
3881
3882 l_step_seq := l_step_seq + 10;
3883
3884 insert into PJI_MT_PRC_STEPS
3885 (
3886 PROCESS_NAME,
3887 STEP_NAME,
3888 STEP_SEQ,
3889 STEP_TYPE,
3890 CONFIG_PROJ_PERF_FLAG,
3891 CONFIG_COST_FLAG,
3892 CONFIG_PROFIT_FLAG,
3893 CONFIG_UTIL_FLAG
3894 )
3895 values
3896 (
3897 'PJI_PJI',
3898 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);',
3899 l_step_seq,
3900 to_char(1 + 2 + 4 + 8), -- generic
3901 'N',
3902 'Y',
3903 'N',
3904 'N'
3905 );
3906
3907 l_step_seq := l_step_seq + 10;
3908
3909 insert into PJI_MT_PRC_STEPS
3910 (
3911 PROCESS_NAME,
3912 STEP_NAME,
3913 STEP_SEQ,
3914 STEP_TYPE,
3915 CONFIG_PROJ_PERF_FLAG,
3916 CONFIG_COST_FLAG,
3917 CONFIG_PROFIT_FLAG,
3918 CONFIG_UTIL_FLAG
3919 )
3920 values
3921 (
3922 'PJI_PJI',
3923 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);',
3924 l_step_seq,
3925 to_char(1 + 2 + 4 + 8), -- generic
3926 'N',
3927 'Y',
3928 'N',
3929 'N'
3930 );
3931
3932 l_step_seq := l_step_seq + 10;
3933
3934 insert into PJI_MT_PRC_STEPS
3935 (
3936 PROCESS_NAME,
3937 STEP_NAME,
3938 STEP_SEQ,
3939 STEP_TYPE,
3940 CONFIG_PROJ_PERF_FLAG,
3941 CONFIG_COST_FLAG,
3942 CONFIG_PROFIT_FLAG,
3943 CONFIG_UTIL_FLAG
3944 )
3945 values
3946 (
3947 'PJI_PJI',
3948 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);',
3949 l_step_seq,
3950 to_char(1 + 2 + 4 + 8), -- generic
3951 'N',
3952 'Y',
3953 'N',
3954 'N'
3955 );
3956
3957 l_step_seq := l_step_seq + 10;
3958
3959 insert into PJI_MT_PRC_STEPS
3960 (
3961 PROCESS_NAME,
3962 STEP_NAME,
3963 STEP_SEQ,
3964 STEP_TYPE,
3965 CONFIG_PROJ_PERF_FLAG,
3966 CONFIG_COST_FLAG,
3967 CONFIG_PROFIT_FLAG,
3968 CONFIG_UTIL_FLAG
3969 )
3970 values
3971 (
3972 'PJI_PJI',
3973 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);',
3974 l_step_seq,
3975 to_char(1 + 2 + 4 + 8), -- generic
3976 'N',
3977 'Y',
3978 'N',
3979 'N'
3980 );
3981
3982 l_step_seq := l_step_seq + 10;
3983
3984 insert into PJI_MT_PRC_STEPS
3985 (
3986 PROCESS_NAME,
3987 STEP_NAME,
3988 STEP_SEQ,
3989 STEP_TYPE,
3990 CONFIG_PROJ_PERF_FLAG,
3991 CONFIG_COST_FLAG,
3992 CONFIG_PROFIT_FLAG,
3993 CONFIG_UTIL_FLAG
3994 )
3995 values
3996 (
3997 'PJI_PJI',
3998 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);',
3999 l_step_seq,
4000 to_char(1 + 2 + 4 + 8), -- generic
4001 'N',
4002 'Y',
4003 'N',
4004 'N'
4005 );
4006
4007 l_step_seq := l_step_seq + 10;
4008
4009 insert into PJI_MT_PRC_STEPS
4010 (
4011 PROCESS_NAME,
4012 STEP_NAME,
4013 STEP_SEQ,
4014 STEP_TYPE,
4015 CONFIG_PROJ_PERF_FLAG,
4016 CONFIG_COST_FLAG,
4017 CONFIG_PROFIT_FLAG,
4018 CONFIG_UTIL_FLAG
4019 )
4020 values
4021 (
4022 'PJI_PJI',
4023 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);',
4024 l_step_seq,
4025 to_char(1 + 2 + 4 + 8), -- generic
4026 'N',
4027 'Y',
4028 'N',
4029 'N'
4030 );
4031
4032 l_step_seq := l_step_seq + 10;
4033
4034 insert into PJI_MT_PRC_STEPS
4035 (
4036 PROCESS_NAME,
4037 STEP_NAME,
4038 STEP_SEQ,
4039 STEP_TYPE,
4040 CONFIG_PROJ_PERF_FLAG,
4041 CONFIG_COST_FLAG,
4042 CONFIG_PROFIT_FLAG,
4043 CONFIG_UTIL_FLAG
4044 )
4045 values
4046 (
4047 'PJI_PJI',
4048 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);',
4049 l_step_seq,
4050 to_char(1 + 2 + 4 + 8), -- generic
4051 'N',
4052 'Y',
4053 'N',
4054 'N'
4055 );
4056
4057 l_step_seq := l_step_seq + 10;
4058
4059 insert into PJI_MT_PRC_STEPS
4060 (
4061 PROCESS_NAME,
4062 STEP_NAME,
4063 STEP_SEQ,
4064 STEP_TYPE,
4065 CONFIG_PROJ_PERF_FLAG,
4066 CONFIG_COST_FLAG,
4067 CONFIG_PROFIT_FLAG,
4068 CONFIG_UTIL_FLAG
4069 )
4070 values
4071 (
4072 'PJI_PJI',
4073 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);',
4074 l_step_seq,
4075 to_char(1 + 2 + 4 + 8), -- generic
4076 'N',
4077 'Y',
4078 'N',
4079 'N'
4080 );
4081
4082 l_step_seq := l_step_seq + 10;
4083
4084 insert into PJI_MT_PRC_STEPS
4085 (
4086 PROCESS_NAME,
4087 STEP_NAME,
4088 STEP_SEQ,
4089 STEP_TYPE,
4090 CONFIG_PROJ_PERF_FLAG,
4091 CONFIG_COST_FLAG,
4092 CONFIG_PROFIT_FLAG,
4093 CONFIG_UTIL_FLAG
4094 )
4095 values
4096 (
4097 'PJI_PJI',
4098 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);',
4099 l_step_seq,
4100 to_char(1 + 2 + 4 + 8), -- generic
4101 'N',
4102 'Y',
4103 'N',
4104 'N'
4105 );
4106
4107 l_step_seq := l_step_seq + 10;
4108
4109 insert into PJI_MT_PRC_STEPS
4110 (
4111 PROCESS_NAME,
4112 STEP_NAME,
4113 STEP_SEQ,
4114 STEP_TYPE,
4115 CONFIG_PROJ_PERF_FLAG,
4116 CONFIG_COST_FLAG,
4117 CONFIG_PROFIT_FLAG,
4118 CONFIG_UTIL_FLAG
4119 )
4120 values
4121 (
4122 'PJI_PJI',
4123 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);',
4124 l_step_seq,
4125 to_char(1 + 2 + 4 + 8), -- generic
4126 'N',
4127 'Y',
4128 'N',
4129 'N'
4130 );
4131
4132 l_step_seq := l_step_seq + 10;
4133
4134 insert into PJI_MT_PRC_STEPS
4135 (
4136 PROCESS_NAME,
4137 STEP_NAME,
4138 STEP_SEQ,
4139 STEP_TYPE,
4140 CONFIG_PROJ_PERF_FLAG,
4141 CONFIG_COST_FLAG,
4142 CONFIG_PROFIT_FLAG,
4143 CONFIG_UTIL_FLAG
4144 )
4145 values
4146 (
4147 'PJI_PJI',
4148 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);',
4149 l_step_seq,
4150 to_char(1 + 2 + 4 + 8), -- generic
4151 'N',
4152 'Y',
4153 'N',
4154 'N'
4155 );
4156
4157 l_step_seq := l_step_seq + 10;
4158
4159 insert into PJI_MT_PRC_STEPS
4160 (
4161 PROCESS_NAME,
4162 STEP_NAME,
4163 STEP_SEQ,
4164 STEP_TYPE,
4165 CONFIG_PROJ_PERF_FLAG,
4166 CONFIG_COST_FLAG,
4167 CONFIG_PROFIT_FLAG,
4168 CONFIG_UTIL_FLAG
4169 )
4170 values
4171 (
4172 'PJI_PJI',
4173 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''N'');',
4174 l_step_seq,
4175 to_char(1 + 2 + 4 + 8), -- generic
4176 'N',
4177 'N',
4178 'Y',
4179 'N'
4180 );
4181
4182 l_step_seq := l_step_seq + 10;
4183
4184 insert into PJI_MT_PRC_STEPS
4185 (
4186 PROCESS_NAME,
4187 STEP_NAME,
4188 STEP_SEQ,
4189 STEP_TYPE,
4190 CONFIG_PROJ_PERF_FLAG,
4191 CONFIG_COST_FLAG,
4192 CONFIG_PROFIT_FLAG,
4193 CONFIG_UTIL_FLAG
4194 )
4195 values
4196 (
4197 'PJI_PJI',
4198 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''N'');',
4199 l_step_seq,
4200 to_char(1 + 2 + 4 + 8), -- generic
4201 'N',
4202 'N',
4203 'Y',
4204 'N'
4205 );
4206
4207 l_step_seq := l_step_seq + 10;
4208
4209 insert into PJI_MT_PRC_STEPS
4210 (
4211 PROCESS_NAME,
4212 STEP_NAME,
4213 STEP_SEQ,
4214 STEP_TYPE,
4215 CONFIG_PROJ_PERF_FLAG,
4216 CONFIG_COST_FLAG,
4217 CONFIG_PROFIT_FLAG,
4218 CONFIG_UTIL_FLAG
4219 )
4220 values
4221 (
4222 'PJI_PJI',
4223 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''N'');',
4224 l_step_seq,
4225 to_char(1 + 2 + 4 + 8), -- generic
4226 'N',
4227 'N',
4228 'Y',
4229 'N'
4230 );
4231
4232 l_step_seq := l_step_seq + 10;
4233
4234 insert into PJI_MT_PRC_STEPS
4235 (
4236 PROCESS_NAME,
4237 STEP_NAME,
4238 STEP_SEQ,
4239 STEP_TYPE,
4240 CONFIG_PROJ_PERF_FLAG,
4241 CONFIG_COST_FLAG,
4242 CONFIG_PROFIT_FLAG,
4243 CONFIG_UTIL_FLAG
4244 )
4245 values
4246 (
4247 'PJI_PJI',
4248 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''N'');',
4249 l_step_seq,
4250 to_char(1 + 2 + 4 + 8), -- generic
4251 'N',
4252 'N',
4253 'Y',
4254 'N'
4255 );
4256
4257 l_step_seq := l_step_seq + 10;
4258
4259 insert into PJI_MT_PRC_STEPS
4260 (
4261 PROCESS_NAME,
4262 STEP_NAME,
4263 STEP_SEQ,
4264 STEP_TYPE,
4265 CONFIG_PROJ_PERF_FLAG,
4266 CONFIG_COST_FLAG,
4267 CONFIG_PROFIT_FLAG,
4268 CONFIG_UTIL_FLAG
4269 )
4270 values
4271 (
4272 'PJI_PJI',
4273 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);',
4274 l_step_seq,
4275 to_char(1 + 2 + 4 + 8), -- generic
4276 'N',
4277 'N',
4278 'N',
4279 'Y'
4280 );
4281
4282 l_step_seq := l_step_seq + 10;
4283
4284 insert into PJI_MT_PRC_STEPS
4285 (
4286 PROCESS_NAME,
4287 STEP_NAME,
4288 STEP_SEQ,
4289 STEP_TYPE,
4290 CONFIG_PROJ_PERF_FLAG,
4291 CONFIG_COST_FLAG,
4292 CONFIG_PROFIT_FLAG,
4293 CONFIG_UTIL_FLAG
4294 )
4295 values
4296 (
4297 'PJI_PJI',
4298 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);',
4299 l_step_seq,
4300 to_char(1 + 2 + 4 + 8), -- generic
4301 'N',
4302 'N',
4303 'N',
4304 'Y'
4305 );
4306
4307 l_step_seq := l_step_seq + 10;
4308
4309 insert into PJI_MT_PRC_STEPS
4310 (
4311 PROCESS_NAME,
4312 STEP_NAME,
4313 STEP_SEQ,
4314 STEP_TYPE,
4315 CONFIG_PROJ_PERF_FLAG,
4316 CONFIG_COST_FLAG,
4317 CONFIG_PROFIT_FLAG,
4318 CONFIG_UTIL_FLAG
4319 )
4320 values
4321 (
4322 'PJI_PJI',
4323 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);',
4324 l_step_seq,
4325 to_char(1 + 2 + 4 + 8), -- generic
4326 'N',
4327 'N',
4328 'N',
4329 'Y'
4330 );
4331
4332 l_step_seq := l_step_seq + 10;
4333
4334 insert into PJI_MT_PRC_STEPS
4335 (
4336 PROCESS_NAME,
4337 STEP_NAME,
4338 STEP_SEQ,
4339 STEP_TYPE,
4340 CONFIG_PROJ_PERF_FLAG,
4341 CONFIG_COST_FLAG,
4342 CONFIG_PROFIT_FLAG,
4343 CONFIG_UTIL_FLAG
4344 )
4345 values
4346 (
4347 'PJI_PJI',
4348 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);',
4349 l_step_seq,
4350 to_char(1 + 2 + 4 + 8), -- generic
4351 'N',
4352 'N',
4353 'N',
4354 'Y'
4355 );
4356
4357 l_step_seq := l_step_seq + 10;
4358
4359 insert into PJI_MT_PRC_STEPS
4360 (
4361 PROCESS_NAME,
4362 STEP_NAME,
4363 STEP_SEQ,
4364 STEP_TYPE,
4365 CONFIG_PROJ_PERF_FLAG,
4366 CONFIG_COST_FLAG,
4367 CONFIG_PROFIT_FLAG,
4368 CONFIG_UTIL_FLAG
4369 )
4370 values
4371 (
4372 'PJI_PJI',
4373 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);',
4374 l_step_seq,
4375 to_char(1 + 2 + 4 + 8), -- generic
4376 'N',
4377 'N',
4378 'N',
4379 'Y'
4380 );
4381
4382 l_step_seq := l_step_seq + 10;
4383
4384 -- helper step
4385 insert into PJI_MT_PRC_STEPS
4386 (
4387 PROCESS_NAME,
4388 STEP_NAME,
4389 STEP_SEQ,
4390 STEP_TYPE,
4391 CONFIG_PROJ_PERF_FLAG,
4392 CONFIG_COST_FLAG,
4393 CONFIG_PROFIT_FLAG,
4394 CONFIG_UTIL_FLAG
4395 )
4396 values
4397 (
4398 'PJI_PJI_HELPER',
4399 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);',
4400 l_step_seq,
4401 to_char(1 + 2 + 4 + 8), -- generic
4402 'N',
4403 'N',
4404 'N',
4405 'Y'
4406 );
4407
4408 l_step_seq := l_step_seq + 10;
4409
4410 insert into PJI_MT_PRC_STEPS
4411 (
4412 PROCESS_NAME,
4413 STEP_NAME,
4414 STEP_SEQ,
4415 STEP_TYPE,
4416 CONFIG_PROJ_PERF_FLAG,
4417 CONFIG_COST_FLAG,
4418 CONFIG_PROFIT_FLAG,
4419 CONFIG_UTIL_FLAG
4420 )
4421 values
4422 (
4423 'PJI_PJI',
4424 'PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);',
4425 l_step_seq,
4426 to_char(1 + 2 + 4 + 8), -- generic
4427 'N',
4428 'N',
4429 'N',
4430 'Y'
4431 );
4432
4433 l_step_seq := l_step_seq + 10;
4434
4435 insert into PJI_MT_PRC_STEPS
4436 (
4437 PROCESS_NAME,
4438 STEP_NAME,
4439 STEP_SEQ,
4440 STEP_TYPE,
4441 CONFIG_PROJ_PERF_FLAG,
4442 CONFIG_COST_FLAG,
4443 CONFIG_PROFIT_FLAG,
4444 CONFIG_UTIL_FLAG
4445 )
4446 values
4447 (
4448 'PJI_PJI',
4449 'PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);',
4450 l_step_seq,
4451 to_char(1 + 2 + 4 + 8), -- generic
4452 'N',
4453 'N',
4454 'N',
4455 'Y'
4456 );
4457
4458 l_step_seq := l_step_seq + 10;
4459
4460 insert into PJI_MT_PRC_STEPS
4461 (
4462 PROCESS_NAME,
4463 STEP_NAME,
4464 STEP_SEQ,
4465 STEP_TYPE,
4466 CONFIG_PROJ_PERF_FLAG,
4467 CONFIG_COST_FLAG,
4468 CONFIG_PROFIT_FLAG,
4469 CONFIG_UTIL_FLAG
4470 )
4471 values
4472 (
4473 'PJI_PJI',
4474 'PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);',
4475 l_step_seq,
4476 to_char(1 + 2 + 4 + 8), -- generic
4477 'N',
4478 'N',
4479 'N',
4480 'Y'
4481 );
4482
4483 l_step_seq := l_step_seq + 10;
4484
4485 insert into PJI_MT_PRC_STEPS
4486 (
4487 PROCESS_NAME,
4488 STEP_NAME,
4489 STEP_SEQ,
4490 STEP_TYPE,
4491 CONFIG_PROJ_PERF_FLAG,
4492 CONFIG_COST_FLAG,
4493 CONFIG_PROFIT_FLAG,
4494 CONFIG_UTIL_FLAG
4495 )
4496 values
4497 (
4498 'PJI_PJI',
4499 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);',
4500 l_step_seq,
4501 to_char(1 + 2 + 4 + 8), -- generic
4502 'N',
4503 'Y',
4504 'N',
4505 'N'
4506 );
4507
4508 l_step_seq := l_step_seq + 10;
4509
4510 insert into PJI_MT_PRC_STEPS
4511 (
4512 PROCESS_NAME,
4513 STEP_NAME,
4514 STEP_SEQ,
4515 STEP_TYPE,
4516 CONFIG_PROJ_PERF_FLAG,
4517 CONFIG_COST_FLAG,
4518 CONFIG_PROFIT_FLAG,
4519 CONFIG_UTIL_FLAG
4520 )
4521 values
4522 (
4523 'PJI_PJI',
4524 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);',
4525 l_step_seq,
4526 to_char(1 + 2 + 4 + 8), -- generic
4527 'N',
4528 'Y',
4529 'N',
4530 'N'
4531 );
4532
4533 l_step_seq := l_step_seq + 10;
4534
4535 insert into PJI_MT_PRC_STEPS
4536 (
4537 PROCESS_NAME,
4538 STEP_NAME,
4539 STEP_SEQ,
4540 STEP_TYPE,
4541 CONFIG_PROJ_PERF_FLAG,
4542 CONFIG_COST_FLAG,
4543 CONFIG_PROFIT_FLAG,
4544 CONFIG_UTIL_FLAG
4545 )
4546 values
4547 (
4548 'PJI_PJI',
4549 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);',
4550 l_step_seq,
4551 to_char(1 + 2 + 4 + 8), -- generic
4552 'N',
4553 'Y',
4554 'N',
4555 'N'
4556 );
4557
4558 l_step_seq := l_step_seq + 10;
4559
4560 insert into PJI_MT_PRC_STEPS
4561 (
4562 PROCESS_NAME,
4563 STEP_NAME,
4564 STEP_SEQ,
4565 STEP_TYPE,
4566 CONFIG_PROJ_PERF_FLAG,
4567 CONFIG_COST_FLAG,
4568 CONFIG_PROFIT_FLAG,
4569 CONFIG_UTIL_FLAG
4570 )
4571 values
4572 (
4573 'PJI_PJI',
4574 'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''N'');',
4575 l_step_seq,
4576 to_char(1 + 2 + 4 + 8), -- generic
4577 'N',
4578 'N',
4579 'Y',
4580 'N'
4581 );
4582
4583 l_step_seq := l_step_seq + 10;
4584
4585 insert into PJI_MT_PRC_STEPS
4586 (
4587 PROCESS_NAME,
4588 STEP_NAME,
4589 STEP_SEQ,
4590 STEP_TYPE,
4591 CONFIG_PROJ_PERF_FLAG,
4592 CONFIG_COST_FLAG,
4593 CONFIG_PROFIT_FLAG,
4594 CONFIG_UTIL_FLAG
4595 )
4596 values
4597 (
4598 'PJI_PJI',
4599 'PJI_FM_SUM_BKLG.SCOPE_PROJECTS_BKLG(p_worker_id);',
4600 l_step_seq,
4601 to_char(1 + 2 + 4 + 8), -- generic
4602 'N',
4603 'N',
4604 'Y',
4605 'N'
4606 );
4607
4608 l_step_seq := l_step_seq + 10;
4609
4610 insert into PJI_MT_PRC_STEPS
4611 (
4612 PROCESS_NAME,
4613 STEP_NAME,
4614 STEP_SEQ,
4615 STEP_TYPE,
4616 CONFIG_PROJ_PERF_FLAG,
4617 CONFIG_COST_FLAG,
4618 CONFIG_PROFIT_FLAG,
4619 CONFIG_UTIL_FLAG
4620 )
4621 values
4622 (
4623 'PJI_PJI',
4624 'PJI_FM_SUM_BKLG.CLEANUP_INT_TABLE(p_worker_id);',
4625 l_step_seq,
4626 to_char(1 + 2 + 4 + 8), -- generic
4627 'N',
4628 'N',
4629 'Y',
4630 'N'
4631 );
4632
4633 l_step_seq := l_step_seq + 10;
4634
4635 -- helper step
4636 insert into PJI_MT_PRC_STEPS
4637 (
4638 PROCESS_NAME,
4639 STEP_NAME,
4640 STEP_SEQ,
4641 STEP_TYPE,
4642 CONFIG_PROJ_PERF_FLAG,
4643 CONFIG_COST_FLAG,
4644 CONFIG_PROFIT_FLAG,
4645 CONFIG_UTIL_FLAG
4646 )
4647 values
4648 (
4649 'PJI_PJI_HELPER',
4650 'PJI_FM_SUM_BKLG.PROCESS_DRMT_BKLG(p_worker_id);',
4651 l_step_seq,
4652 to_char(1 + 2 + 4 + 8), -- generic
4653 'N',
4654 'N',
4655 'Y',
4656 'N'
4657 );
4658
4659 l_step_seq := l_step_seq + 10;
4660
4661 insert into PJI_MT_PRC_STEPS
4662 (
4663 PROCESS_NAME,
4664 STEP_NAME,
4665 STEP_SEQ,
4666 STEP_TYPE,
4667 CONFIG_PROJ_PERF_FLAG,
4668 CONFIG_COST_FLAG,
4669 CONFIG_PROFIT_FLAG,
4670 CONFIG_UTIL_FLAG
4671 )
4672 values
4673 (
4674 'PJI_PJI',
4675 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''Y'');',
4676 l_step_seq,
4677 to_char(1 + 2 + 4 + 8), -- generic
4678 'N',
4679 'N',
4680 'Y',
4681 'N'
4682 );
4683
4684 l_step_seq := l_step_seq + 10;
4685
4686 insert into PJI_MT_PRC_STEPS
4687 (
4688 PROCESS_NAME,
4689 STEP_NAME,
4690 STEP_SEQ,
4691 STEP_TYPE,
4692 CONFIG_PROJ_PERF_FLAG,
4693 CONFIG_COST_FLAG,
4694 CONFIG_PROFIT_FLAG,
4695 CONFIG_UTIL_FLAG
4696 )
4697 values
4698 (
4699 'PJI_PJI',
4700 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''Y'');',
4701 l_step_seq,
4702 to_char(1 + 2 + 4 + 8), -- generic
4703 'N',
4704 'N',
4705 'Y',
4706 'N'
4707 );
4708
4709 l_step_seq := l_step_seq + 10;
4710
4711 insert into PJI_MT_PRC_STEPS
4712 (
4713 PROCESS_NAME,
4714 STEP_NAME,
4715 STEP_SEQ,
4716 STEP_TYPE,
4717 CONFIG_PROJ_PERF_FLAG,
4718 CONFIG_COST_FLAG,
4719 CONFIG_PROFIT_FLAG,
4720 CONFIG_UTIL_FLAG
4721 )
4722 values
4723 (
4724 'PJI_PJI',
4725 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''Y'');',
4726 l_step_seq,
4727 to_char(1 + 2 + 4 + 8), -- generic
4728 'N',
4729 'N',
4730 'Y',
4731 'N'
4732 );
4733
4734 l_step_seq := l_step_seq + 10;
4735
4736 insert into PJI_MT_PRC_STEPS
4737 (
4738 PROCESS_NAME,
4739 STEP_NAME,
4740 STEP_SEQ,
4741 STEP_TYPE,
4742 CONFIG_PROJ_PERF_FLAG,
4743 CONFIG_COST_FLAG,
4744 CONFIG_PROFIT_FLAG,
4745 CONFIG_UTIL_FLAG
4746 )
4747 values
4748 (
4749 'PJI_PJI',
4750 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''Y'');',
4751 l_step_seq,
4752 to_char(1 + 2 + 4 + 8), -- generic
4753 'N',
4754 'N',
4755 'Y',
4756 'N'
4757 );
4758
4759 l_step_seq := l_step_seq + 10;
4760
4761 insert into PJI_MT_PRC_STEPS
4762 (
4763 PROCESS_NAME,
4764 STEP_NAME,
4765 STEP_SEQ,
4766 STEP_TYPE,
4767 CONFIG_PROJ_PERF_FLAG,
4768 CONFIG_COST_FLAG,
4769 CONFIG_PROFIT_FLAG,
4770 CONFIG_UTIL_FLAG
4771 )
4772 values
4773 (
4774 'PJI_PJI',
4775 'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''Y'');',
4776 l_step_seq,
4777 to_char(1 + 2 + 4 + 8), -- generic
4778 'N',
4779 'N',
4780 'Y',
4781 'N'
4782 );
4783
4784 l_step_seq := l_step_seq + 10;
4785
4786 insert into PJI_MT_PRC_STEPS
4787 (
4788 PROCESS_NAME,
4789 STEP_NAME,
4790 STEP_SEQ,
4791 STEP_TYPE,
4792 CONFIG_PROJ_PERF_FLAG,
4793 CONFIG_COST_FLAG,
4794 CONFIG_PROFIT_FLAG,
4795 CONFIG_UTIL_FLAG
4796 )
4797 values
4798 (
4799 'PJI_PJI',
4800 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);',
4801 l_step_seq,
4802 to_char(1 + 2 + 4 + 8), -- generic
4803 'N',
4804 'Y',
4805 'N',
4806 'N'
4807 );
4808
4809 l_step_seq := l_step_seq + 10;
4810
4811 insert into PJI_MT_PRC_STEPS
4812 (
4813 PROCESS_NAME,
4814 STEP_NAME,
4815 STEP_SEQ,
4816 STEP_TYPE,
4817 CONFIG_PROJ_PERF_FLAG,
4818 CONFIG_COST_FLAG,
4819 CONFIG_PROFIT_FLAG,
4820 CONFIG_UTIL_FLAG
4821 )
4822 values
4823 (
4824 'PJI_PJI',
4825 'PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);',
4826 l_step_seq,
4827 to_char(1 + 2 + 4 + 8), -- generic
4828 'N',
4829 'N',
4830 'Y',
4831 'N'
4832 );
4833
4834 l_step_seq := l_step_seq + 10;
4835
4836 insert into PJI_MT_PRC_STEPS
4837 (
4838 PROCESS_NAME,
4839 STEP_NAME,
4840 STEP_SEQ,
4841 STEP_TYPE,
4842 CONFIG_PROJ_PERF_FLAG,
4843 CONFIG_COST_FLAG,
4844 CONFIG_PROFIT_FLAG,
4845 CONFIG_UTIL_FLAG
4846 )
4847 values
4848 (
4849 'PJI_PJI',
4850 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);',
4851 l_step_seq,
4852 to_char(1 + 2 + 4 + 8), -- generic
4853 'N',
4854 'N',
4855 'N',
4856 'Y'
4857 );
4858
4859 l_step_seq := l_step_seq + 10;
4860
4861 insert into PJI_MT_PRC_STEPS
4862 (
4863 PROCESS_NAME,
4864 STEP_NAME,
4865 STEP_SEQ,
4866 STEP_TYPE,
4867 CONFIG_PROJ_PERF_FLAG,
4868 CONFIG_COST_FLAG,
4869 CONFIG_PROFIT_FLAG,
4870 CONFIG_UTIL_FLAG
4871 )
4872 values
4873 (
4874 'PJI_PJI',
4875 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);',
4876 l_step_seq,
4877 to_char(1 + 2 + 4 + 8), -- generic
4878 'N',
4879 'N',
4880 'N',
4881 'Y'
4882 );
4883
4884 l_step_seq := l_step_seq + 10;
4885
4886 insert into PJI_MT_PRC_STEPS
4887 (
4888 PROCESS_NAME,
4889 STEP_NAME,
4890 STEP_SEQ,
4891 STEP_TYPE,
4892 CONFIG_PROJ_PERF_FLAG,
4893 CONFIG_COST_FLAG,
4894 CONFIG_PROFIT_FLAG,
4895 CONFIG_UTIL_FLAG
4896 )
4897 values
4898 (
4899 'PJI_PJI',
4900 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);',
4901 l_step_seq,
4902 to_char(1 + 2 + 4 + 8), -- generic
4903 'N',
4904 'N',
4905 'N',
4906 'Y'
4907 );
4908
4909 l_step_seq := l_step_seq + 10;
4910
4911 insert into PJI_MT_PRC_STEPS
4912 (
4913 PROCESS_NAME,
4914 STEP_NAME,
4915 STEP_SEQ,
4916 STEP_TYPE,
4917 CONFIG_PROJ_PERF_FLAG,
4918 CONFIG_COST_FLAG,
4919 CONFIG_PROFIT_FLAG,
4920 CONFIG_UTIL_FLAG
4921 )
4922 values
4923 (
4924 'PJI_PJI',
4925 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);',
4926 l_step_seq,
4927 to_char(1 + 2 + 4 + 8), -- generic
4928 'N',
4929 'N',
4930 'N',
4931 'Y'
4932 );
4933
4934 l_step_seq := l_step_seq + 10;
4935
4936 insert into PJI_MT_PRC_STEPS
4937 (
4938 PROCESS_NAME,
4939 STEP_NAME,
4940 STEP_SEQ,
4941 STEP_TYPE,
4942 CONFIG_PROJ_PERF_FLAG,
4943 CONFIG_COST_FLAG,
4944 CONFIG_PROFIT_FLAG,
4945 CONFIG_UTIL_FLAG
4946 )
4947 values
4948 (
4949 'PJI_PJI',
4950 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);',
4951 l_step_seq,
4952 to_char(1 + 2 + 4 + 8), -- generic
4953 'N',
4954 'N',
4955 'N',
4956 'Y'
4957 );
4958
4959 l_step_seq := l_step_seq + 10;
4960
4961 insert into PJI_MT_PRC_STEPS
4962 (
4963 PROCESS_NAME,
4964 STEP_NAME,
4965 STEP_SEQ,
4966 STEP_TYPE,
4967 CONFIG_PROJ_PERF_FLAG,
4968 CONFIG_COST_FLAG,
4969 CONFIG_PROFIT_FLAG,
4970 CONFIG_UTIL_FLAG
4971 )
4972 values
4973 (
4974 'PJI_PJI',
4975 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);',
4976 l_step_seq,
4977 to_char(1 + 2 + 4 + 8), -- generic
4978 'N',
4979 'N',
4980 'N',
4981 'Y'
4982 );
4983
4984 l_step_seq := l_step_seq + 10;
4985
4986 insert into PJI_MT_PRC_STEPS
4987 (
4988 PROCESS_NAME,
4989 STEP_NAME,
4990 STEP_SEQ,
4991 STEP_TYPE,
4992 CONFIG_PROJ_PERF_FLAG,
4993 CONFIG_COST_FLAG,
4994 CONFIG_PROFIT_FLAG,
4995 CONFIG_UTIL_FLAG
4996 )
4997 values
4998 (
4999 'PJI_PJI',
5000 'PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);',
5001 l_step_seq,
5002 to_char(1 + 2 + 4 + 8), -- generic
5003 'N',
5004 'N',
5005 'N',
5006 'Y'
5007 );
5008
5009 l_step_seq := l_step_seq + 10;
5010
5011 insert into PJI_MT_PRC_STEPS
5012 (
5013 PROCESS_NAME,
5014 STEP_NAME,
5015 STEP_SEQ,
5016 STEP_TYPE,
5017 CONFIG_PROJ_PERF_FLAG,
5018 CONFIG_COST_FLAG,
5019 CONFIG_PROFIT_FLAG,
5020 CONFIG_UTIL_FLAG
5021 )
5022 values
5023 (
5024 'PJI_PJI',
5025 'PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);',
5026 l_step_seq,
5027 to_char(1 + 2 + 4 + 8), -- generic
5028 'N',
5029 'N',
5030 'N',
5031 'Y'
5032 );
5033
5034 l_step_seq := l_step_seq + 10;
5035
5036 insert into PJI_MT_PRC_STEPS
5037 (
5038 PROCESS_NAME,
5039 STEP_NAME,
5040 STEP_SEQ,
5041 STEP_TYPE,
5042 CONFIG_PROJ_PERF_FLAG,
5043 CONFIG_COST_FLAG,
5044 CONFIG_PROFIT_FLAG,
5045 CONFIG_UTIL_FLAG
5046 )
5047 values
5048 (
5049 'PJI_PJI',
5050 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);',
5051 l_step_seq,
5052 to_char(1 + 2 + 4 + 8), -- generic
5053 'N',
5054 'Y',
5055 'N',
5056 'N'
5057 );
5058
5059 l_step_seq := l_step_seq + 10;
5060
5061 insert into PJI_MT_PRC_STEPS
5062 (
5063 PROCESS_NAME,
5064 STEP_NAME,
5065 STEP_SEQ,
5066 STEP_TYPE,
5067 CONFIG_PROJ_PERF_FLAG,
5068 CONFIG_COST_FLAG,
5069 CONFIG_PROFIT_FLAG,
5070 CONFIG_UTIL_FLAG
5071 )
5072 values
5073 (
5074 'PJI_PJI',
5075 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);',
5076 l_step_seq,
5077 to_char(1 + 2 + 4 + 8), -- generic
5078 'N',
5079 'Y',
5080 'N',
5081 'N'
5082 );
5083
5084 l_step_seq := l_step_seq + 10;
5085
5086 insert into PJI_MT_PRC_STEPS
5087 (
5088 PROCESS_NAME,
5089 STEP_NAME,
5090 STEP_SEQ,
5091 STEP_TYPE,
5092 CONFIG_PROJ_PERF_FLAG,
5093 CONFIG_COST_FLAG,
5094 CONFIG_PROFIT_FLAG,
5095 CONFIG_UTIL_FLAG
5096 )
5097 values
5098 (
5099 'PJI_PJI',
5100 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);',
5101 l_step_seq,
5102 to_char(1 + 2 + 4 + 8), -- generic
5103 'N',
5104 'Y',
5105 'N',
5106 'N'
5107 );
5108
5109 l_step_seq := l_step_seq + 10;
5110
5111 insert into PJI_MT_PRC_STEPS
5112 (
5113 PROCESS_NAME,
5114 STEP_NAME,
5115 STEP_SEQ,
5116 STEP_TYPE,
5117 CONFIG_PROJ_PERF_FLAG,
5118 CONFIG_COST_FLAG,
5119 CONFIG_PROFIT_FLAG,
5120 CONFIG_UTIL_FLAG
5121 )
5122 values
5123 (
5124 'PJI_PJI',
5125 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);',
5126 l_step_seq,
5127 to_char(1 + 2 + 4 + 8), -- generic
5128 'N',
5129 'Y',
5130 'N',
5131 'N'
5132 );
5133
5134 l_step_seq := l_step_seq + 10;
5135
5136 insert into PJI_MT_PRC_STEPS
5137 (
5138 PROCESS_NAME,
5139 STEP_NAME,
5140 STEP_SEQ,
5141 STEP_TYPE,
5142 CONFIG_PROJ_PERF_FLAG,
5143 CONFIG_COST_FLAG,
5144 CONFIG_PROFIT_FLAG,
5145 CONFIG_UTIL_FLAG
5146 )
5147 values
5148 (
5149 'PJI_PJI',
5150 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);',
5151 l_step_seq,
5152 to_char(1 + 2 + 4 + 8), -- generic
5153 'N',
5154 'Y',
5155 'N',
5156 'N'
5157 );
5158
5159 l_step_seq := l_step_seq + 10;
5160
5161 insert into PJI_MT_PRC_STEPS
5162 (
5163 PROCESS_NAME,
5164 STEP_NAME,
5165 STEP_SEQ,
5166 STEP_TYPE,
5167 CONFIG_PROJ_PERF_FLAG,
5168 CONFIG_COST_FLAG,
5169 CONFIG_PROFIT_FLAG,
5170 CONFIG_UTIL_FLAG
5171 )
5172 values
5173 (
5174 'PJI_PJI',
5175 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);',
5176 l_step_seq,
5177 to_char(1 + 2 + 4 + 8), -- generic
5178 'N',
5179 'Y',
5180 'N',
5181 'N'
5182 );
5183
5184 l_step_seq := l_step_seq + 10;
5185
5186 insert into PJI_MT_PRC_STEPS
5187 (
5188 PROCESS_NAME,
5189 STEP_NAME,
5190 STEP_SEQ,
5191 STEP_TYPE,
5192 CONFIG_PROJ_PERF_FLAG,
5193 CONFIG_COST_FLAG,
5194 CONFIG_PROFIT_FLAG,
5195 CONFIG_UTIL_FLAG
5196 )
5197 values
5198 (
5199 'PJI_PJI',
5200 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACO(p_worker_id);',
5201 l_step_seq,
5202 to_char(1 + 2 + 4 + 8), -- generic
5203 'N',
5204 'N',
5205 'Y',
5206 'N'
5207 );
5208
5209 l_step_seq := l_step_seq + 10;
5210
5211 insert into PJI_MT_PRC_STEPS
5212 (
5213 PROCESS_NAME,
5214 STEP_NAME,
5215 STEP_SEQ,
5216 STEP_TYPE,
5217 CONFIG_PROJ_PERF_FLAG,
5218 CONFIG_COST_FLAG,
5219 CONFIG_PROFIT_FLAG,
5220 CONFIG_UTIL_FLAG
5221 )
5222 values
5223 (
5224 'PJI_PJI',
5225 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACC(p_worker_id);',
5226 l_step_seq,
5227 to_char(1 + 2 + 4 + 8), -- generic
5228 'N',
5229 'N',
5230 'Y',
5231 'N'
5232 );
5233
5234 l_step_seq := l_step_seq + 10;
5235
5236 insert into PJI_MT_PRC_STEPS
5237 (
5238 PROCESS_NAME,
5239 STEP_NAME,
5240 STEP_SEQ,
5241 STEP_TYPE,
5242 CONFIG_PROJ_PERF_FLAG,
5243 CONFIG_COST_FLAG,
5244 CONFIG_PROFIT_FLAG,
5245 CONFIG_UTIL_FLAG
5246 )
5247 values
5248 (
5249 'PJI_PJI',
5250 'PJI_RM_SUM_EXTR.CLEANUP_WORKER(p_worker_id);',
5251 l_step_seq,
5252 to_char(1 + 2 + 4 + 8), -- generic
5253 'N',
5254 'Y',
5255 'Y',
5256 'Y'
5257 );
5258
5259 -- ------------------------------------------------------------------------
5260 -- Stage 3 Summarization - Project Performance
5261 -- ------------------------------------------------------------------------
5262
5263 l_step_seq := 10;
5264
5265 insert into PJI_MT_PRC_STEPS
5266 (
5267 PROCESS_NAME,
5268 STEP_NAME,
5269 STEP_SEQ,
5270 STEP_TYPE,
5271 CONFIG_PROJ_PERF_FLAG,
5272 CONFIG_COST_FLAG,
5273 CONFIG_PROFIT_FLAG,
5274 CONFIG_UTIL_FLAG
5275 )
5276 values
5277 (
5278 'PJI_PJP',
5279 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);',
5280 l_step_seq,
5281 to_char(1 + 2 + 4 + 8), -- generic
5282 'Y',
5283 'N',
5284 'N',
5285 'N'
5286 );
5287
5288 l_step_seq := l_step_seq + 10;
5289
5290 insert into PJI_MT_PRC_STEPS
5291 (
5292 PROCESS_NAME,
5293 STEP_NAME,
5294 STEP_SEQ,
5295 STEP_TYPE,
5296 CONFIG_PROJ_PERF_FLAG,
5297 CONFIG_COST_FLAG,
5298 CONFIG_PROFIT_FLAG,
5299 CONFIG_UTIL_FLAG
5300 )
5301 values
5302 (
5303 'PJI_PJP',
5304 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);',
5305 l_step_seq,
5306 to_char(1 + 2 + 4 + 8), -- generic
5307 'Y',
5308 'N',
5309 'N',
5310 'N'
5311 );
5312
5313 l_step_seq := l_step_seq + 10;
5314
5315 insert into PJI_MT_PRC_STEPS
5316 (
5317 PROCESS_NAME,
5318 STEP_NAME,
5319 STEP_SEQ,
5320 STEP_TYPE,
5321 CONFIG_PROJ_PERF_FLAG,
5322 CONFIG_COST_FLAG,
5323 CONFIG_PROFIT_FLAG,
5324 CONFIG_UTIL_FLAG
5325 )
5326 values
5327 (
5328 'PJI_PJP',
5329 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);',
5330 l_step_seq,
5331 to_char(1 + 2 + 4 + 8), -- generic
5332 'Y',
5333 'N',
5334 'N',
5335 'N'
5336 );
5337
5338 l_step_seq := l_step_seq + 10;
5339
5340 insert into PJI_MT_PRC_STEPS
5341 (
5342 PROCESS_NAME,
5343 STEP_NAME,
5344 STEP_SEQ,
5345 STEP_TYPE,
5346 CONFIG_PROJ_PERF_FLAG,
5347 CONFIG_COST_FLAG,
5348 CONFIG_PROFIT_FLAG,
5349 CONFIG_UTIL_FLAG
5350 )
5351 values
5352 (
5353 'PJI_PJP',
5354 'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);',
5355 l_step_seq,
5356 to_char(1 + 2 + 4 + 8), -- generic
5357 'Y',
5358 'N',
5359 'N',
5360 'N'
5361 );
5362
5363 l_step_seq := l_step_seq + 10;
5364
5365 insert into PJI_MT_PRC_STEPS
5366 (
5367 PROCESS_NAME,
5368 STEP_NAME,
5369 STEP_SEQ,
5370 STEP_TYPE,
5371 CONFIG_PROJ_PERF_FLAG,
5372 CONFIG_COST_FLAG,
5373 CONFIG_PROFIT_FLAG,
5374 CONFIG_UTIL_FLAG
5375 )
5376 values
5377 (
5378 'PJI_PJP',
5379 'PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);',
5380 l_step_seq,
5381 to_char(1 + 2 + 4 + 8), -- generic
5382 'Y',
5383 'N',
5384 'N',
5385 'N'
5386 );
5387
5388 l_step_seq := l_step_seq + 10;
5389
5390 insert into PJI_MT_PRC_STEPS
5391 (
5392 PROCESS_NAME,
5393 STEP_NAME,
5394 STEP_SEQ,
5395 STEP_TYPE,
5396 CONFIG_PROJ_PERF_FLAG,
5397 CONFIG_COST_FLAG,
5398 CONFIG_PROFIT_FLAG,
5399 CONFIG_UTIL_FLAG
5400 )
5401 values
5402 (
5403 'PJI_PJP',
5404 'PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);',
5405 l_step_seq,
5406 to_char(1 + 2 + 4 + 8), -- generic
5407 'Y',
5408 'N',
5409 'N',
5410 'N'
5411 );
5412
5413 l_step_seq := l_step_seq + 10;
5414
5415 insert into PJI_MT_PRC_STEPS
5416 (
5417 PROCESS_NAME,
5418 STEP_NAME,
5419 STEP_SEQ,
5420 STEP_TYPE,
5421 CONFIG_PROJ_PERF_FLAG,
5422 CONFIG_COST_FLAG,
5423 CONFIG_PROFIT_FLAG,
5424 CONFIG_UTIL_FLAG
5425 )
5426 values
5427 (
5428 'PJI_PJP',
5429 'PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);',
5430 l_step_seq,
5431 to_char(8), -- rbs
5432 'Y',
5433 'N',
5434 'N',
5435 'N'
5436 );
5437
5438 l_step_seq := l_step_seq + 10;
5439
5440 insert into PJI_MT_PRC_STEPS
5441 (
5442 PROCESS_NAME,
5443 STEP_NAME,
5444 STEP_SEQ,
5445 STEP_TYPE,
5446 CONFIG_PROJ_PERF_FLAG,
5447 CONFIG_COST_FLAG,
5448 CONFIG_PROFIT_FLAG,
5449 CONFIG_UTIL_FLAG
5450 )
5451 values
5452 (
5453 'PJI_PJP',
5454 'PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id);',
5455 l_step_seq,
5456 to_char(1 + 2 + 4), -- generic - rbs
5457 'Y',
5458 'N',
5459 'N',
5460 'N'
5461 );
5462
5463 l_step_seq := l_step_seq + 10;
5464
5465 insert into PJI_MT_PRC_STEPS
5466 (
5467 PROCESS_NAME,
5468 STEP_NAME,
5469 STEP_SEQ,
5470 STEP_TYPE,
5471 CONFIG_PROJ_PERF_FLAG,
5472 CONFIG_COST_FLAG,
5473 CONFIG_PROFIT_FLAG,
5474 CONFIG_UTIL_FLAG
5475 )
5476 values
5477 (
5478 'PJI_PJP',
5479 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);',
5480 l_step_seq,
5481 to_char(1 + 2 + 4), -- generic - rbs
5482 'Y',
5483 'N',
5484 'N',
5485 'N'
5486 );
5487
5488 l_step_seq := l_step_seq + 10;
5489
5490 insert into PJI_MT_PRC_STEPS
5491 (
5492 PROCESS_NAME,
5493 STEP_NAME,
5494 STEP_SEQ,
5495 STEP_TYPE,
5496 CONFIG_PROJ_PERF_FLAG,
5497 CONFIG_COST_FLAG,
5498 CONFIG_PROFIT_FLAG,
5499 CONFIG_UTIL_FLAG
5500 )
5501 values
5502 (
5503 'PJI_PJP',
5504 'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);',
5505 l_step_seq,
5506 to_char(1 + 2 + 4), -- generic - rbs
5507 'Y',
5508 'N',
5509 'N',
5510 'N'
5511 );
5512
5513 l_step_seq := l_step_seq + 10;
5514
5515 insert into PJI_MT_PRC_STEPS
5516 (
5517 PROCESS_NAME,
5518 STEP_NAME,
5519 STEP_SEQ,
5520 STEP_TYPE,
5521 CONFIG_PROJ_PERF_FLAG,
5522 CONFIG_COST_FLAG,
5523 CONFIG_PROFIT_FLAG,
5524 CONFIG_UTIL_FLAG
5525 )
5526 values
5527 (
5528 'PJI_PJP',
5529 'PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);',
5530 l_step_seq,
5531 to_char(1 + 2 + 4 + 8), -- generic
5532 'Y',
5533 'N',
5534 'N',
5535 'N'
5536 );
5537
5538 l_step_seq := l_step_seq + 10;
5539
5540 insert into PJI_MT_PRC_STEPS
5541 (
5542 PROCESS_NAME,
5543 STEP_NAME,
5544 STEP_SEQ,
5545 STEP_TYPE,
5546 CONFIG_PROJ_PERF_FLAG,
5547 CONFIG_COST_FLAG,
5548 CONFIG_PROFIT_FLAG,
5549 CONFIG_UTIL_FLAG
5550 )
5551 values
5552 (
5553 'PJI_PJP',
5554 'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);',
5555 l_step_seq,
5556 to_char(1 + 2 + 4 + 8), -- generic
5557 'Y',
5558 'N',
5559 'N',
5560 'N'
5561 );
5562
5563 l_step_seq := l_step_seq + 10;
5564
5565 insert into PJI_MT_PRC_STEPS
5566 (
5567 PROCESS_NAME,
5568 STEP_NAME,
5569 STEP_SEQ,
5570 STEP_TYPE,
5571 CONFIG_PROJ_PERF_FLAG,
5572 CONFIG_COST_FLAG,
5573 CONFIG_PROFIT_FLAG,
5574 CONFIG_UTIL_FLAG
5575 )
5576 values
5577 (
5578 'PJI_PJP',
5579 'PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);',
5580 l_step_seq,
5581 to_char(1 + 2 + 4 + 8), -- generic
5582 'Y',
5583 'N',
5584 'N',
5585 'N'
5586 );
5587
5588 l_step_seq := l_step_seq + 10;
5589
5590 insert into PJI_MT_PRC_STEPS
5591 (
5592 PROCESS_NAME,
5593 STEP_NAME,
5594 STEP_SEQ,
5595 STEP_TYPE,
5596 CONFIG_PROJ_PERF_FLAG,
5597 CONFIG_COST_FLAG,
5598 CONFIG_PROFIT_FLAG,
5599 CONFIG_UTIL_FLAG
5600 )
5601 values
5602 (
5603 'PJI_PJP',
5604 'PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);',
5605 l_step_seq,
5606 to_char(1 + 2 + 4 + 8), -- generic
5607 'Y',
5608 'N',
5609 'N',
5610 'N'
5611 );
5612
5613 l_step_seq := l_step_seq + 10;
5614
5615 insert into PJI_MT_PRC_STEPS
5616 (
5617 PROCESS_NAME,
5618 STEP_NAME,
5619 STEP_SEQ,
5620 STEP_TYPE,
5621 CONFIG_PROJ_PERF_FLAG,
5622 CONFIG_COST_FLAG,
5623 CONFIG_PROFIT_FLAG,
5624 CONFIG_UTIL_FLAG
5625 )
5626 values
5627 (
5628 'PJI_PJP',
5629 'PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id);',
5630 l_step_seq,
5631 to_char(1 + 2 + 4 + 8), -- generic
5632 'Y',
5633 'N',
5634 'N',
5635 'N'
5636 );
5637
5638 l_step_seq := l_step_seq + 10;
5639
5640 insert into PJI_MT_PRC_STEPS
5641 (
5642 PROCESS_NAME,
5643 STEP_NAME,
5644 STEP_SEQ,
5645 STEP_TYPE,
5646 CONFIG_PROJ_PERF_FLAG,
5647 CONFIG_COST_FLAG,
5648 CONFIG_PROFIT_FLAG,
5649 CONFIG_UTIL_FLAG
5650 )
5651 values
5652 (
5653 'PJI_PJP',
5654 'PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);',
5655 l_step_seq,
5656 to_char(1 + 2 + 4), -- generic - rbs
5657 'Y',
5658 'N',
5659 'N',
5660 'N'
5661 );
5662
5663 l_step_seq := l_step_seq + 10;
5664
5665 insert into PJI_MT_PRC_STEPS
5666 (
5667 PROCESS_NAME,
5668 STEP_NAME,
5669 STEP_SEQ,
5670 STEP_TYPE,
5671 CONFIG_PROJ_PERF_FLAG,
5672 CONFIG_COST_FLAG,
5673 CONFIG_PROFIT_FLAG,
5674 CONFIG_UTIL_FLAG
5675 )
5676 values
5677 (
5678 'PJI_PJP',
5679 'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);',
5680 l_step_seq,
5681 to_char(1 + 2 + 4 + 8), -- generic
5682 'Y',
5683 'N',
5684 'N',
5685 'N'
5686 );
5687
5688 l_step_seq := l_step_seq + 10;
5689
5690 insert into PJI_MT_PRC_STEPS
5691 (
5692 PROCESS_NAME,
5693 STEP_NAME,
5694 STEP_SEQ,
5695 STEP_TYPE,
5696 CONFIG_PROJ_PERF_FLAG,
5697 CONFIG_COST_FLAG,
5698 CONFIG_PROFIT_FLAG,
5699 CONFIG_UTIL_FLAG
5700 )
5701 values
5702 (
5703 'PJI_PJP',
5704 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);',
5705 l_step_seq,
5706 to_char(1 + 2 + 4), -- generic - rbs
5707 'Y',
5708 'N',
5709 'N',
5710 'N'
5711 );
5712
5713 l_step_seq := l_step_seq + 10;
5714
5715 insert into PJI_MT_PRC_STEPS
5716 (
5717 PROCESS_NAME,
5718 STEP_NAME,
5719 STEP_SEQ,
5720 STEP_TYPE,
5721 CONFIG_PROJ_PERF_FLAG,
5722 CONFIG_COST_FLAG,
5723 CONFIG_PROFIT_FLAG,
5724 CONFIG_UTIL_FLAG
5725 )
5726 values
5727 (
5728 'PJI_PJP',
5729 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);',
5730 l_step_seq,
5731 to_char(1 + 2 + 4), -- generic - rbs
5732 'Y',
5733 'N',
5734 'N',
5735 'N'
5736 );
5737
5738 l_step_seq := l_step_seq + 10;
5739
5740 insert into PJI_MT_PRC_STEPS
5741 (
5742 PROCESS_NAME,
5743 STEP_NAME,
5744 STEP_SEQ,
5745 STEP_TYPE,
5746 CONFIG_PROJ_PERF_FLAG,
5747 CONFIG_COST_FLAG,
5748 CONFIG_PROFIT_FLAG,
5749 CONFIG_UTIL_FLAG
5750 )
5751 values
5752 (
5753 'PJI_PJP',
5754 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);',
5755 l_step_seq,
5756 to_char(1 + 2 + 4 + 8), -- generic
5757 'Y',
5758 'N',
5759 'N',
5760 'N'
5761 );
5762
5763 l_step_seq := l_step_seq + 10;
5764
5765 insert into PJI_MT_PRC_STEPS
5766 (
5767 PROCESS_NAME,
5768 STEP_NAME,
5769 STEP_SEQ,
5770 STEP_TYPE,
5771 CONFIG_PROJ_PERF_FLAG,
5772 CONFIG_COST_FLAG,
5773 CONFIG_PROFIT_FLAG,
5774 CONFIG_UTIL_FLAG
5775 )
5776 values
5777 (
5778 'PJI_PJP',
5779 'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);',
5780 l_step_seq,
5781 to_char(1 + 2 + 4), -- generic - rbs
5782 'Y',
5783 'N',
5784 'N',
5785 'N'
5786 );
5787
5788 l_step_seq := l_step_seq + 10;
5789
5790 insert into PJI_MT_PRC_STEPS
5791 (
5792 PROCESS_NAME,
5793 STEP_NAME,
5794 STEP_SEQ,
5795 STEP_TYPE,
5796 CONFIG_PROJ_PERF_FLAG,
5797 CONFIG_COST_FLAG,
5798 CONFIG_PROFIT_FLAG,
5799 CONFIG_UTIL_FLAG
5800 )
5801 values
5802 (
5803 'PJI_PJP',
5804 'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);',
5805 l_step_seq,
5806 to_char(1 + 2 + 4 + 8), -- generic
5807 'Y',
5808 'N',
5809 'N',
5810 'N'
5811 );
5812
5813 l_step_seq := l_step_seq + 10;
5814
5815 insert into PJI_MT_PRC_STEPS
5816 (
5817 PROCESS_NAME,
5818 STEP_NAME,
5819 STEP_SEQ,
5820 STEP_TYPE,
5821 CONFIG_PROJ_PERF_FLAG,
5822 CONFIG_COST_FLAG,
5823 CONFIG_PROFIT_FLAG,
5824 CONFIG_UTIL_FLAG
5825 )
5826 values
5827 (
5828 'PJI_PJP',
5829 'PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);',
5830 l_step_seq,
5831 to_char(1 + 2 + 4 + 8), -- generic
5832 'Y',
5833 'N',
5834 'N',
5835 'N'
5836 );
5837
5838 l_step_seq := l_step_seq + 10;
5839
5840 insert into PJI_MT_PRC_STEPS
5841 (
5842 PROCESS_NAME,
5843 STEP_NAME,
5844 STEP_SEQ,
5845 STEP_TYPE,
5846 CONFIG_PROJ_PERF_FLAG,
5847 CONFIG_COST_FLAG,
5848 CONFIG_PROFIT_FLAG,
5849 CONFIG_UTIL_FLAG
5850 )
5851 values
5852 (
5853 'PJI_PJP',
5854 'PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);',
5855 l_step_seq,
5856 to_char(1 + 2 + 4), -- generic - rbs
5857 'Y',
5858 'N',
5859 'N',
5860 'N'
5861 );
5862
5863 l_step_seq := l_step_seq + 10;
5864
5865 insert into PJI_MT_PRC_STEPS
5866 (
5867 PROCESS_NAME,
5868 STEP_NAME,
5869 STEP_SEQ,
5870 STEP_TYPE,
5871 CONFIG_PROJ_PERF_FLAG,
5872 CONFIG_COST_FLAG,
5873 CONFIG_PROFIT_FLAG,
5874 CONFIG_UTIL_FLAG
5875 )
5876 values
5877 (
5878 'PJI_PJP',
5879 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);',
5880 l_step_seq,
5881 to_char(1 + 2 + 4 + 8), -- generic
5882 'Y',
5883 'N',
5884 'N',
5885 'N'
5886 );
5887
5888 l_step_seq := l_step_seq + 10;
5889
5890 insert into PJI_MT_PRC_STEPS
5891 (
5892 PROCESS_NAME,
5893 STEP_NAME,
5894 STEP_SEQ,
5895 STEP_TYPE,
5896 CONFIG_PROJ_PERF_FLAG,
5897 CONFIG_COST_FLAG,
5898 CONFIG_PROFIT_FLAG,
5899 CONFIG_UTIL_FLAG
5900 )
5901 values
5902 (
5903 'PJI_PJP',
5904 'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);',
5905 l_step_seq,
5906 to_char(1 + 2 + 4), -- generic - rbs
5907 'Y',
5908 'N',
5909 'N',
5910 'N'
5911 );
5912
5913 l_step_seq := l_step_seq + 10;
5914
5915 insert into PJI_MT_PRC_STEPS
5916 (
5917 PROCESS_NAME,
5918 STEP_NAME,
5919 STEP_SEQ,
5920 STEP_TYPE,
5921 CONFIG_PROJ_PERF_FLAG,
5922 CONFIG_COST_FLAG,
5923 CONFIG_PROFIT_FLAG,
5924 CONFIG_UTIL_FLAG
5925 )
5926 values
5927 (
5928 'PJI_PJP',
5929 'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);',
5930 l_step_seq,
5931 to_char(1 + 2 + 4 + 8), -- generic
5932 'Y',
5933 'N',
5934 'N',
5935 'N'
5936 );
5937
5938 l_step_seq := l_step_seq + 10;
5939
5940 insert into PJI_MT_PRC_STEPS
5941 (
5942 PROCESS_NAME,
5943 STEP_NAME,
5944 STEP_SEQ,
5945 STEP_TYPE,
5946 CONFIG_PROJ_PERF_FLAG,
5947 CONFIG_COST_FLAG,
5948 CONFIG_PROFIT_FLAG,
5949 CONFIG_UTIL_FLAG
5950 )
5951 values
5952 (
5953 'PJI_PJP',
5954 'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);',
5955 l_step_seq,
5956 to_char(4), -- partial refresh
5957 'Y',
5958 'N',
5959 'N',
5960 'N'
5961 );
5962
5963 l_step_seq := l_step_seq + 10;
5964
5965 insert into PJI_MT_PRC_STEPS
5966 (
5967 PROCESS_NAME,
5968 STEP_NAME,
5969 STEP_SEQ,
5970 STEP_TYPE,
5971 CONFIG_PROJ_PERF_FLAG,
5972 CONFIG_COST_FLAG,
5973 CONFIG_PROFIT_FLAG,
5974 CONFIG_UTIL_FLAG
5975 )
5976 values
5977 (
5978 'PJI_PJP',
5979 'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);',
5980 l_step_seq,
5981 to_char(8), -- rbs
5982 'Y',
5983 'N',
5984 'N',
5985 'N'
5986 );
5987
5988 l_step_seq := l_step_seq + 10;
5989
5990 insert into PJI_MT_PRC_STEPS
5991 (
5992 PROCESS_NAME,
5993 STEP_NAME,
5994 STEP_SEQ,
5995 STEP_TYPE,
5996 CONFIG_PROJ_PERF_FLAG,
5997 CONFIG_COST_FLAG,
5998 CONFIG_PROFIT_FLAG,
5999 CONFIG_UTIL_FLAG
6000 )
6001 values
6002 (
6003 'PJI_PJP',
6004 'PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);',
6005 l_step_seq,
6006 to_char(2), -- incremental only
6007 'Y',
6008 'N',
6009 'N',
6010 'N'
6011 );
6012
6013 l_step_seq := l_step_seq + 10;
6014
6015 insert into PJI_MT_PRC_STEPS
6016 (
6017 PROCESS_NAME,
6018 STEP_NAME,
6019 STEP_SEQ,
6020 STEP_TYPE,
6021 CONFIG_PROJ_PERF_FLAG,
6022 CONFIG_COST_FLAG,
6023 CONFIG_PROFIT_FLAG,
6024 CONFIG_UTIL_FLAG
6025 )
6026 values
6027 (
6028 'PJI_PJP',
6029 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);',
6030 l_step_seq,
6031 to_char(1 + 2 + 4 + 8), -- generic
6032 'Y',
6033 'N',
6034 'N',
6035 'N'
6036 );
6037
6038 l_step_seq := l_step_seq + 10;
6039
6040 insert into PJI_MT_PRC_STEPS
6041 (
6042 PROCESS_NAME,
6043 STEP_NAME,
6044 STEP_SEQ,
6045 STEP_TYPE,
6046 CONFIG_PROJ_PERF_FLAG,
6047 CONFIG_COST_FLAG,
6048 CONFIG_PROFIT_FLAG,
6049 CONFIG_UTIL_FLAG
6050 )
6051 values
6052 (
6053 'PJI_PJP',
6054 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);',
6055 l_step_seq,
6056 to_char(1 + 2 + 4 + 8), -- generic
6057 'Y',
6058 'N',
6059 'N',
6060 'N'
6061 );
6062
6063 l_step_seq := l_step_seq + 10;
6064
6065 insert into PJI_MT_PRC_STEPS
6066 (
6067 PROCESS_NAME,
6068 STEP_NAME,
6069 STEP_SEQ,
6070 STEP_TYPE,
6071 CONFIG_PROJ_PERF_FLAG,
6072 CONFIG_COST_FLAG,
6073 CONFIG_PROFIT_FLAG,
6074 CONFIG_UTIL_FLAG
6075 )
6076 values
6077 (
6078 'PJI_PJP',
6079 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);',
6080 l_step_seq,
6081 to_char(1 + 2 + 4), -- generic - rbs
6082 'Y',
6083 'N',
6084 'N',
6085 'N'
6086 );
6087
6088 l_step_seq := l_step_seq + 10;
6089
6090 insert into PJI_MT_PRC_STEPS
6091 (
6092 PROCESS_NAME,
6093 STEP_NAME,
6094 STEP_SEQ,
6095 STEP_TYPE,
6096 CONFIG_PROJ_PERF_FLAG,
6097 CONFIG_COST_FLAG,
6098 CONFIG_PROFIT_FLAG,
6099 CONFIG_UTIL_FLAG
6100 )
6101 values
6102 (
6103 'PJI_PJP',
6104 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);',
6105 l_step_seq,
6106 to_char(1 + 2 + 4 + 8), -- generic
6107 'Y',
6108 'N',
6109 'N',
6110 'N'
6111 );
6112
6113 l_step_seq := l_step_seq + 10;
6114
6115 insert into PJI_MT_PRC_STEPS
6116 (
6117 PROCESS_NAME,
6118 STEP_NAME,
6119 STEP_SEQ,
6120 STEP_TYPE,
6121 CONFIG_PROJ_PERF_FLAG,
6122 CONFIG_COST_FLAG,
6123 CONFIG_PROFIT_FLAG,
6124 CONFIG_UTIL_FLAG
6125 )
6126 values
6127 (
6128 'PJI_PJP',
6129 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);',
6130 l_step_seq,
6131 to_char(1 + 2 + 4 + 8), -- generic
6132 'Y',
6133 'N',
6134 'N',
6135 'N'
6136 );
6137
6138 l_step_seq := l_step_seq + 10;
6139
6140 insert into PJI_MT_PRC_STEPS
6141 (
6142 PROCESS_NAME,
6143 STEP_NAME,
6144 STEP_SEQ,
6145 STEP_TYPE,
6146 CONFIG_PROJ_PERF_FLAG,
6147 CONFIG_COST_FLAG,
6148 CONFIG_PROFIT_FLAG,
6149 CONFIG_UTIL_FLAG
6150 )
6151 values
6152 (
6153 'PJI_PJP',
6154 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);',
6155 l_step_seq,
6156 to_char(1 + 2 + 4 + 8), -- generic
6157 'Y',
6158 'N',
6159 'N',
6160 'N'
6161 );
6162
6163 l_step_seq := l_step_seq + 10;
6164
6165 insert into PJI_MT_PRC_STEPS
6166 (
6167 PROCESS_NAME,
6168 STEP_NAME,
6169 STEP_SEQ,
6170 STEP_TYPE,
6171 CONFIG_PROJ_PERF_FLAG,
6172 CONFIG_COST_FLAG,
6173 CONFIG_PROFIT_FLAG,
6174 CONFIG_UTIL_FLAG
6175 )
6176 values
6177 (
6178 'PJI_PJP',
6179 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);',
6180 l_step_seq,
6181 to_char(1 + 2 + 4 + 8), -- generic
6182 'Y',
6183 'N',
6184 'N',
6185 'N'
6186 );
6187
6188 l_step_seq := l_step_seq + 10;
6189
6190 insert into PJI_MT_PRC_STEPS
6191 (
6192 PROCESS_NAME,
6193 STEP_NAME,
6194 STEP_SEQ,
6195 STEP_TYPE,
6196 CONFIG_PROJ_PERF_FLAG,
6197 CONFIG_COST_FLAG,
6198 CONFIG_PROFIT_FLAG,
6199 CONFIG_UTIL_FLAG
6200 )
6201 values
6202 (
6203 'PJI_PJP',
6204 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);',
6205 l_step_seq,
6206 to_char(1 + 2 + 4), -- generic - rbs
6207 'Y',
6208 'N',
6209 'N',
6210 'N'
6211 );
6212
6213 l_step_seq := l_step_seq + 10;
6214
6215 insert into PJI_MT_PRC_STEPS
6216 (
6217 PROCESS_NAME,
6218 STEP_NAME,
6219 STEP_SEQ,
6220 STEP_TYPE,
6221 CONFIG_PROJ_PERF_FLAG,
6222 CONFIG_COST_FLAG,
6223 CONFIG_PROFIT_FLAG,
6224 CONFIG_UTIL_FLAG
6225 )
6226 values
6227 (
6228 'PJI_PJP',
6229 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);',
6230 l_step_seq,
6231 to_char(1 + 2 + 4), -- generic - rbs
6232 'Y',
6233 'N',
6234 'N',
6235 'N'
6236 );
6237
6238 l_step_seq := l_step_seq + 10;
6239
6240 insert into PJI_MT_PRC_STEPS
6241 (
6242 PROCESS_NAME,
6243 STEP_NAME,
6244 STEP_SEQ,
6245 STEP_TYPE,
6246 CONFIG_PROJ_PERF_FLAG,
6247 CONFIG_COST_FLAG,
6248 CONFIG_PROFIT_FLAG,
6249 CONFIG_UTIL_FLAG
6250 )
6251 values
6252 (
6253 'PJI_PJP',
6254 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);',
6255 l_step_seq,
6256 to_char(1 + 2 + 4), -- generic - rbs
6257 'Y',
6258 'N',
6259 'N',
6260 'N'
6261 );
6262
6263 l_step_seq := l_step_seq + 10;
6264
6265 insert into PJI_MT_PRC_STEPS
6266 (
6267 PROCESS_NAME,
6268 STEP_NAME,
6269 STEP_SEQ,
6270 STEP_TYPE,
6271 CONFIG_PROJ_PERF_FLAG,
6272 CONFIG_COST_FLAG,
6273 CONFIG_PROFIT_FLAG,
6274 CONFIG_UTIL_FLAG
6275 )
6276 values
6277 (
6278 'PJI_PJP',
6279 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);',
6280 l_step_seq,
6281 to_char(1 + 2 + 4), -- generic - rbs
6282 'Y',
6283 'N',
6284 'N',
6285 'N'
6286 );
6287
6288 l_step_seq := l_step_seq + 10;
6289
6290 insert into PJI_MT_PRC_STEPS
6291 (
6292 PROCESS_NAME,
6293 STEP_NAME,
6294 STEP_SEQ,
6295 STEP_TYPE,
6296 CONFIG_PROJ_PERF_FLAG,
6297 CONFIG_COST_FLAG,
6298 CONFIG_PROFIT_FLAG,
6299 CONFIG_UTIL_FLAG
6300 )
6301 values
6302 (
6303 'PJI_PJP',
6304 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);',
6305 l_step_seq,
6306 to_char(1 + 2 + 4 + 8), -- generic
6307 'Y',
6308 'N',
6309 'N',
6310 'N'
6311 );
6312
6313 l_step_seq := l_step_seq + 10;
6314
6315 insert into PJI_MT_PRC_STEPS
6316 (
6317 PROCESS_NAME,
6318 STEP_NAME,
6319 STEP_SEQ,
6320 STEP_TYPE,
6321 CONFIG_PROJ_PERF_FLAG,
6322 CONFIG_COST_FLAG,
6323 CONFIG_PROFIT_FLAG,
6324 CONFIG_UTIL_FLAG
6325 )
6326 values
6327 (
6328 'PJI_PJP',
6329 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);',
6330 l_step_seq,
6331 to_char(1 + 2 + 4), -- generic - rbs
6332 'Y',
6333 'N',
6334 'N',
6335 'N'
6336 );
6337
6338 l_step_seq := l_step_seq + 10;
6339
6340 insert into PJI_MT_PRC_STEPS
6341 (
6342 PROCESS_NAME,
6343 STEP_NAME,
6344 STEP_SEQ,
6345 STEP_TYPE,
6346 CONFIG_PROJ_PERF_FLAG,
6347 CONFIG_COST_FLAG,
6348 CONFIG_PROFIT_FLAG,
6349 CONFIG_UTIL_FLAG
6350 )
6351 values
6352 (
6353 'PJI_PJP',
6354 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);',
6355 l_step_seq,
6356 to_char(1 + 2 + 4), -- generic - rbs
6357 'Y',
6358 'N',
6359 'N',
6360 'N'
6361 );
6362
6363 l_step_seq := l_step_seq + 10;
6364
6365 insert into PJI_MT_PRC_STEPS
6366 (
6367 PROCESS_NAME,
6368 STEP_NAME,
6369 STEP_SEQ,
6370 STEP_TYPE,
6371 CONFIG_PROJ_PERF_FLAG,
6372 CONFIG_COST_FLAG,
6373 CONFIG_PROFIT_FLAG,
6374 CONFIG_UTIL_FLAG
6375 )
6376 values
6377 (
6378 'PJI_PJP',
6379 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);',
6380 l_step_seq,
6381 to_char(1 + 2 + 4), -- generic - rbs
6382 'Y',
6383 'N',
6384 'N',
6385 'N'
6386 );
6387
6388 l_step_seq := l_step_seq + 10;
6389
6390 insert into PJI_MT_PRC_STEPS
6391 (
6392 PROCESS_NAME,
6393 STEP_NAME,
6394 STEP_SEQ,
6395 STEP_TYPE,
6396 CONFIG_PROJ_PERF_FLAG,
6397 CONFIG_COST_FLAG,
6398 CONFIG_PROFIT_FLAG,
6399 CONFIG_UTIL_FLAG
6400 )
6401 values
6402 (
6403 'PJI_PJP',
6404 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);',
6405 l_step_seq,
6406 to_char(1 + 2 + 4), -- generic - rbs
6407 'Y',
6408 'N',
6409 'N',
6410 'N'
6411 );
6412
6413 l_step_seq := l_step_seq + 10;
6414
6415 insert into PJI_MT_PRC_STEPS
6416 (
6417 PROCESS_NAME,
6418 STEP_NAME,
6419 STEP_SEQ,
6420 STEP_TYPE,
6421 CONFIG_PROJ_PERF_FLAG,
6422 CONFIG_COST_FLAG,
6423 CONFIG_PROFIT_FLAG,
6424 CONFIG_UTIL_FLAG
6425 )
6426 values
6427 (
6428 'PJI_PJP',
6429 'PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);',
6430 l_step_seq,
6431 to_char(1 + 2 + 4 + 8), -- partial + rbs
6432 'Y',
6433 'N',
6434 'N',
6435 'N'
6436 );
6437
6438 l_step_seq := l_step_seq + 10;
6439
6440 insert into PJI_MT_PRC_STEPS
6441 (
6442 PROCESS_NAME,
6443 STEP_NAME,
6444 STEP_SEQ,
6445 STEP_TYPE,
6446 CONFIG_PROJ_PERF_FLAG,
6447 CONFIG_COST_FLAG,
6448 CONFIG_PROFIT_FLAG,
6449 CONFIG_UTIL_FLAG
6450 )
6451 values
6452 (
6453 'PJI_PJP',
6454 'PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);',
6455 l_step_seq,
6456 to_char(1 + 2 + 4 + 8), -- partial + rbs
6457 'Y',
6458 'N',
6459 'N',
6460 'N'
6461 );
6462
6463 l_step_seq := l_step_seq + 10;
6464
6465 insert into PJI_MT_PRC_STEPS
6466 (
6467 PROCESS_NAME,
6468 STEP_NAME,
6469 STEP_SEQ,
6470 STEP_TYPE,
6471 CONFIG_PROJ_PERF_FLAG,
6472 CONFIG_COST_FLAG,
6473 CONFIG_PROFIT_FLAG,
6474 CONFIG_UTIL_FLAG
6475 )
6476 values
6477 (
6478 'PJI_PJP',
6479 'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);',
6480 l_step_seq,
6481 to_char(1 + 2 + 4 + 8),
6482 'Y',
6483 'N',
6484 'N',
6485 'N'
6486 );
6487
6488 l_step_seq := l_step_seq + 10;
6489
6490 /* Bug 6063826. Added MERGE_INTO_FP_FACT and commented out the next four */
6491 insert into PJI_MT_PRC_STEPS
6492 (
6493 PROCESS_NAME,
6494 STEP_NAME,
6495 STEP_SEQ,
6496 STEP_TYPE,
6497 CONFIG_PROJ_PERF_FLAG,
6498 CONFIG_COST_FLAG,
6499 CONFIG_PROFIT_FLAG,
6500 CONFIG_UTIL_FLAG
6501 )
6502 values
6503 (
6504 'PJI_PJP',
6505 'PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACT(p_worker_id);',
6506 l_step_seq,
6507 to_char(1 + 2 + 4 + 8), -- generic
6508 'Y',
6509 'N',
6510 'N',
6511 'N'
6512 );
6513 /*
6514 insert into PJI_MT_PRC_STEPS
6515 (
6516 PROCESS_NAME,
6517 STEP_NAME,
6518 STEP_SEQ,
6519 STEP_TYPE,
6520 CONFIG_PROJ_PERF_FLAG,
6521 CONFIG_COST_FLAG,
6522 CONFIG_PROFIT_FLAG,
6523 CONFIG_UTIL_FLAG
6524 )
6525 values
6526 (
6527 'PJI_PJP',
6528 'PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);',
6529 l_step_seq,
6530 to_char(1 + 2 + 4 + 8), -- generic
6531 'Y',
6532 'N',
6533 'N',
6534 'N'
6535 );
6536
6537 l_step_seq := l_step_seq + 10;
6538
6539 insert into PJI_MT_PRC_STEPS
6540 (
6541 PROCESS_NAME,
6542 STEP_NAME,
6543 STEP_SEQ,
6544 STEP_TYPE,
6545 CONFIG_PROJ_PERF_FLAG,
6546 CONFIG_COST_FLAG,
6547 CONFIG_PROFIT_FLAG,
6548 CONFIG_UTIL_FLAG
6549 )
6550 values
6551 (
6552 'PJI_PJP',
6553 'PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);',
6554 l_step_seq,
6555 to_char(1 + 2 + 4 + 8), -- generic
6556 'Y',
6557 'N',
6558 'N',
6559 'N'
6560 );
6561
6562 l_step_seq := l_step_seq + 10;
6563
6564 insert into PJI_MT_PRC_STEPS
6565 (
6566 PROCESS_NAME,
6567 STEP_NAME,
6568 STEP_SEQ,
6569 STEP_TYPE,
6570 CONFIG_PROJ_PERF_FLAG,
6571 CONFIG_COST_FLAG,
6572 CONFIG_PROFIT_FLAG,
6573 CONFIG_UTIL_FLAG
6574 )
6575 values
6576 (
6577 'PJI_PJP',
6578 'PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);',
6579 l_step_seq,
6580 to_char(1 + 2 + 4 + 8), -- generic
6581 'Y',
6582 'N',
6583 'N',
6584 'N'
6585 );
6586
6587 l_step_seq := l_step_seq + 10;
6588
6589 insert into PJI_MT_PRC_STEPS
6590 (
6591 PROCESS_NAME,
6592 STEP_NAME,
6593 STEP_SEQ,
6594 STEP_TYPE,
6595 CONFIG_PROJ_PERF_FLAG,
6596 CONFIG_COST_FLAG,
6597 CONFIG_PROFIT_FLAG,
6598 CONFIG_UTIL_FLAG
6599 )
6600 values
6601 (
6602 'PJI_PJP',
6603 'PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);',
6604 l_step_seq,
6605 to_char(1 + 2 + 4 + 8), -- generic
6606 'Y',
6607 'N',
6608 'N',
6609 'N'
6610 );
6611 */
6612 l_step_seq := l_step_seq + 10;
6613
6614 insert into PJI_MT_PRC_STEPS
6615 (
6616 PROCESS_NAME,
6617 STEP_NAME,
6618 STEP_SEQ,
6619 STEP_TYPE,
6620 CONFIG_PROJ_PERF_FLAG,
6621 CONFIG_COST_FLAG,
6622 CONFIG_PROFIT_FLAG,
6623 CONFIG_UTIL_FLAG
6624 )
6625 values
6626 (
6627 'PJI_PJP',
6628 'PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);',
6629 l_step_seq,
6630 to_char(1 + 2 + 4), -- generic - rbs
6631 'Y',
6632 'N',
6633 'N',
6634 'N'
6635 );
6636
6637 l_step_seq := l_step_seq + 10;
6638
6639 insert into PJI_MT_PRC_STEPS
6640 (
6641 PROCESS_NAME,
6642 STEP_NAME,
6643 STEP_SEQ,
6644 STEP_TYPE,
6645 CONFIG_PROJ_PERF_FLAG,
6646 CONFIG_COST_FLAG,
6647 CONFIG_PROFIT_FLAG,
6648 CONFIG_UTIL_FLAG
6649 )
6650 values
6651 (
6652 'PJI_PJP',
6653 'PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);',
6654 l_step_seq,
6655 to_char(1 + 2 + 4), -- generic - rbs
6656 'Y',
6657 'N',
6658 'N',
6659 'N'
6660 );
6661
6662 l_step_seq := l_step_seq + 10;
6663
6664 insert into PJI_MT_PRC_STEPS
6665 (
6666 PROCESS_NAME,
6667 STEP_NAME,
6668 STEP_SEQ,
6669 STEP_TYPE,
6670 CONFIG_PROJ_PERF_FLAG,
6671 CONFIG_COST_FLAG,
6672 CONFIG_PROFIT_FLAG,
6673 CONFIG_UTIL_FLAG
6674 )
6675 values
6676 (
6677 'PJI_PJP',
6678 'PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);',
6679 l_step_seq,
6680 to_char(1 + 2 + 4), -- generic - rbs
6681 'Y',
6682 'N',
6683 'N',
6684 'N'
6685 );
6686
6687 l_step_seq := l_step_seq + 10;
6688
6689 insert into PJI_MT_PRC_STEPS
6690 (
6691 PROCESS_NAME,
6692 STEP_NAME,
6693 STEP_SEQ,
6694 STEP_TYPE,
6695 CONFIG_PROJ_PERF_FLAG,
6696 CONFIG_COST_FLAG,
6697 CONFIG_PROFIT_FLAG,
6698 CONFIG_UTIL_FLAG
6699 )
6700 values
6701 (
6702 'PJI_PJP',
6703 'PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);',
6704 l_step_seq,
6705 to_char(1 + 2 + 4), -- generic - rbs
6706 'Y',
6707 'N',
6708 'N',
6709 'N'
6710 );
6711
6712 l_step_seq := l_step_seq + 10;
6713
6714 insert into PJI_MT_PRC_STEPS
6715 (
6716 PROCESS_NAME,
6717 STEP_NAME,
6718 STEP_SEQ,
6719 STEP_TYPE,
6720 CONFIG_PROJ_PERF_FLAG,
6721 CONFIG_COST_FLAG,
6722 CONFIG_PROFIT_FLAG,
6723 CONFIG_UTIL_FLAG
6724 )
6725 values
6726 (
6727 'PJI_PJP',
6728 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);',
6729 l_step_seq,
6730 to_char(1 + 2 + 4), -- generic - rbs
6731 'Y',
6732 'N',
6733 'N',
6734 'N'
6735 );
6736
6737 l_step_seq := l_step_seq + 10;
6738
6739 insert into PJI_MT_PRC_STEPS
6740 (
6741 PROCESS_NAME,
6742 STEP_NAME,
6743 STEP_SEQ,
6744 STEP_TYPE,
6745 CONFIG_PROJ_PERF_FLAG,
6746 CONFIG_COST_FLAG,
6747 CONFIG_PROFIT_FLAG,
6748 CONFIG_UTIL_FLAG
6749 )
6750 values
6751 (
6752 'PJI_PJP',
6753 'PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);',
6754 l_step_seq,
6755 to_char(1 + 2 + 4 + 8), -- generic
6756 'Y',
6757 'N',
6758 'N',
6759 'N'
6760 );
6761
6762 l_step_seq := l_step_seq + 10;
6763
6764 insert into PJI_MT_PRC_STEPS
6765 (
6766 PROCESS_NAME,
6767 STEP_NAME,
6768 STEP_SEQ,
6769 STEP_TYPE,
6770 CONFIG_PROJ_PERF_FLAG,
6771 CONFIG_COST_FLAG,
6772 CONFIG_PROFIT_FLAG,
6773 CONFIG_UTIL_FLAG
6774 )
6775 values
6776 (
6777 'PJI_PJP',
6778 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);',
6779 l_step_seq,
6780 to_char(1 + 2 + 4 + 8), -- generic
6781 'Y',
6782 'N',
6783 'N',
6784 'N'
6785 );
6786
6787 l_step_seq := l_step_seq + 10;
6788
6789 insert into PJI_MT_PRC_STEPS
6790 (
6791 PROCESS_NAME,
6792 STEP_NAME,
6793 STEP_SEQ,
6794 STEP_TYPE,
6795 CONFIG_PROJ_PERF_FLAG,
6796 CONFIG_COST_FLAG,
6797 CONFIG_PROFIT_FLAG,
6798 CONFIG_UTIL_FLAG
6799 )
6800 values
6801 (
6802 'PJI_PJP',
6803 'PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);',
6804 l_step_seq,
6805 to_char(1 + 2 + 4 + 8), -- generic
6806 'Y',
6807 'N',
6808 'N',
6809 'N'
6810 );
6811
6812 l_step_seq := l_step_seq + 10;
6813
6814 insert into PJI_MT_PRC_STEPS
6815 (
6816 PROCESS_NAME,
6817 STEP_NAME,
6818 STEP_SEQ,
6819 STEP_TYPE,
6820 CONFIG_PROJ_PERF_FLAG,
6821 CONFIG_COST_FLAG,
6822 CONFIG_PROFIT_FLAG,
6823 CONFIG_UTIL_FLAG
6824 )
6825 values
6826 (
6827 'PJI_PJP',
6828 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);',
6829 l_step_seq,
6830 to_char(1 + 2 + 4), -- generic - rbs
6831 'Y',
6832 'N',
6833 'N',
6834 'N'
6835 );
6836
6837 l_step_seq := l_step_seq + 10;
6838
6839 insert into PJI_MT_PRC_STEPS
6840 (
6841 PROCESS_NAME,
6842 STEP_NAME,
6843 STEP_SEQ,
6844 STEP_TYPE,
6845 CONFIG_PROJ_PERF_FLAG,
6846 CONFIG_COST_FLAG,
6847 CONFIG_PROFIT_FLAG,
6848 CONFIG_UTIL_FLAG
6849 )
6850 values
6851 (
6852 'PJI_PJP',
6853 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);',
6854 l_step_seq,
6855 to_char(1 + 2 + 4), -- generic - rbs
6856 'Y',
6857 'N',
6858 'N',
6859 'N'
6860 );
6861
6862 l_step_seq := l_step_seq + 10;
6863
6864 insert into PJI_MT_PRC_STEPS
6865 (
6866 PROCESS_NAME,
6867 STEP_NAME,
6868 STEP_SEQ,
6869 STEP_TYPE,
6870 CONFIG_PROJ_PERF_FLAG,
6871 CONFIG_COST_FLAG,
6872 CONFIG_PROFIT_FLAG,
6873 CONFIG_UTIL_FLAG
6874 )
6875 values
6876 (
6877 'PJI_PJP',
6878 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);',
6879 l_step_seq,
6880 to_char(1 + 2 + 4), -- generic - rbs
6881 'Y',
6882 'N',
6883 'N',
6884 'N'
6885 );
6886
6887 l_step_seq := l_step_seq + 10;
6888
6889 insert into PJI_MT_PRC_STEPS
6890 (
6891 PROCESS_NAME,
6892 STEP_NAME,
6893 STEP_SEQ,
6894 STEP_TYPE,
6895 CONFIG_PROJ_PERF_FLAG,
6896 CONFIG_COST_FLAG,
6897 CONFIG_PROFIT_FLAG,
6898 CONFIG_UTIL_FLAG
6899 )
6900 values
6901 (
6902 'PJI_PJP',
6903 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);',
6904 l_step_seq,
6905 to_char(1 + 2 + 4), -- generic - rbs
6906 'Y',
6907 'N',
6908 'N',
6909 'N'
6910 );
6911
6912 l_step_seq := l_step_seq + 10;
6913
6914 insert into PJI_MT_PRC_STEPS
6915 (
6916 PROCESS_NAME,
6917 STEP_NAME,
6918 STEP_SEQ,
6919 STEP_TYPE,
6920 CONFIG_PROJ_PERF_FLAG,
6921 CONFIG_COST_FLAG,
6922 CONFIG_PROFIT_FLAG,
6923 CONFIG_UTIL_FLAG
6924 )
6925 values
6926 (
6927 'PJI_PJP',
6928 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);',
6929 l_step_seq,
6930 to_char(1 + 2 + 4), -- generic - rbs
6931 'Y',
6932 'N',
6933 'N',
6934 'N'
6935 );
6936
6937 l_step_seq := l_step_seq + 10;
6938
6939 insert into PJI_MT_PRC_STEPS
6940 (
6941 PROCESS_NAME,
6942 STEP_NAME,
6943 STEP_SEQ,
6944 STEP_TYPE,
6945 CONFIG_PROJ_PERF_FLAG,
6946 CONFIG_COST_FLAG,
6947 CONFIG_PROFIT_FLAG,
6948 CONFIG_UTIL_FLAG
6949 )
6950 values
6951 (
6952 'PJI_PJP',
6953 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);',
6954 l_step_seq,
6955 to_char(1 + 2 + 4), -- generic - rbs
6956 'Y',
6957 'N',
6958 'N',
6959 'N'
6960 );
6961
6962 l_step_seq := l_step_seq + 10;
6963
6964 insert into PJI_MT_PRC_STEPS
6965 (
6966 PROCESS_NAME,
6967 STEP_NAME,
6968 STEP_SEQ,
6969 STEP_TYPE,
6970 CONFIG_PROJ_PERF_FLAG,
6971 CONFIG_COST_FLAG,
6972 CONFIG_PROFIT_FLAG,
6973 CONFIG_UTIL_FLAG
6974 )
6975 values
6976 (
6977 'PJI_PJP',
6978 'PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);',
6979 l_step_seq,
6980 to_char(1 + 2 + 4 + 8), -- generic
6981 'Y',
6982 'N',
6983 'N',
6984 'N'
6985 );
6986
6987 l_step_seq := l_step_seq + 10;
6988
6989 insert into PJI_MT_PRC_STEPS
6990 (
6991 PROCESS_NAME,
6992 STEP_NAME,
6993 STEP_SEQ,
6994 STEP_TYPE,
6995 CONFIG_PROJ_PERF_FLAG,
6996 CONFIG_COST_FLAG,
6997 CONFIG_PROFIT_FLAG,
6998 CONFIG_UTIL_FLAG
6999 )
7000 values
7001 (
7002 'PJI_PJP',
7003 'PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);',
7004 l_step_seq,
7005 to_char(1 + 2 + 4 + 8), -- generic
7006 'Y',
7007 'N',
7008 'N',
7009 'N'
7010 );
7011
7012 -- ------------------------------------------------------------------------
7013 -- Stage 3 Summarization - Project Performance - FP.M Upgrade
7014 -- ------------------------------------------------------------------------
7015
7016 l_step_seq := 10;
7017
7018 insert into PJI_MT_PRC_STEPS
7019 (
7020 PROCESS_NAME,
7021 STEP_NAME,
7022 STEP_SEQ,
7023 STEP_TYPE,
7024 CONFIG_PROJ_PERF_FLAG,
7025 CONFIG_COST_FLAG,
7026 CONFIG_PROFIT_FLAG,
7027 CONFIG_UTIL_FLAG
7028 )
7029 values
7030 (
7031 'PJI_PJP_FPM_UPGRADE',
7032 'PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(p_worker_id);',
7033 l_step_seq,
7034 to_char(1), -- full
7035 'Y',
7036 'N',
7037 'N',
7038 'N'
7039 );
7040
7041 l_step_seq := l_step_seq + 10;
7042
7043 insert into PJI_MT_PRC_STEPS
7044 (
7045 PROCESS_NAME,
7046 STEP_NAME,
7047 STEP_SEQ,
7048 STEP_TYPE,
7049 CONFIG_PROJ_PERF_FLAG,
7050 CONFIG_COST_FLAG,
7051 CONFIG_PROFIT_FLAG,
7052 CONFIG_UTIL_FLAG
7053 )
7054 values
7055 (
7056 'PJI_PJP_FPM_UPGRADE',
7057 'PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id);',
7058 l_step_seq,
7059 to_char(1), -- full
7060 'Y',
7061 'N',
7062 'N',
7063 'N'
7064 );
7065
7066 l_step_seq := l_step_seq + 10;
7067
7068 insert into PJI_MT_PRC_STEPS
7069 (
7070 PROCESS_NAME,
7071 STEP_NAME,
7072 STEP_SEQ,
7073 STEP_TYPE,
7074 CONFIG_PROJ_PERF_FLAG,
7075 CONFIG_COST_FLAG,
7076 CONFIG_PROFIT_FLAG,
7077 CONFIG_UTIL_FLAG
7078 )
7079 values
7080 (
7081 'PJI_PJP_FPM_UPGRADE',
7082 'PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);',
7083 l_step_seq,
7084 to_char(1), -- full
7085 'Y',
7086 'N',
7087 'N',
7088 'N'
7089 );
7090
7091 l_step_seq := l_step_seq + 10;
7092
7093 insert into PJI_MT_PRC_STEPS
7094 (
7095 PROCESS_NAME,
7096 STEP_NAME,
7097 STEP_SEQ,
7098 STEP_TYPE,
7099 CONFIG_PROJ_PERF_FLAG,
7100 CONFIG_COST_FLAG,
7101 CONFIG_PROFIT_FLAG,
7102 CONFIG_UTIL_FLAG
7103 )
7104 values
7105 (
7106 'PJI_PJP_FPM_UPGRADE',
7107 'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);',
7108 l_step_seq,
7109 to_char(1), -- full
7110 'Y',
7111 'N',
7112 'N',
7113 'N'
7114 );
7115
7116 l_step_seq := l_step_seq + 10;
7117
7118 insert into PJI_MT_PRC_STEPS
7119 (
7120 PROCESS_NAME,
7121 STEP_NAME,
7122 STEP_SEQ,
7123 STEP_TYPE,
7124 CONFIG_PROJ_PERF_FLAG,
7125 CONFIG_COST_FLAG,
7126 CONFIG_PROFIT_FLAG,
7127 CONFIG_UTIL_FLAG
7128 )
7129 values
7130 (
7131 'PJI_PJP_FPM_UPGRADE',
7132 'PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id);',
7133 l_step_seq,
7134 to_char(1), -- full
7135 'Y',
7136 'N',
7137 'N',
7138 'N'
7139 );
7140
7141 l_step_seq := l_step_seq + 10;
7142
7143 insert into PJI_MT_PRC_STEPS
7144 (
7145 PROCESS_NAME,
7146 STEP_NAME,
7147 STEP_SEQ,
7148 STEP_TYPE,
7149 CONFIG_PROJ_PERF_FLAG,
7150 CONFIG_COST_FLAG,
7151 CONFIG_PROFIT_FLAG,
7152 CONFIG_UTIL_FLAG
7153 )
7154 values
7155 (
7156 'PJI_PJP_FPM_UPGRADE',
7157 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);',
7158 l_step_seq,
7159 to_char(1), -- full
7160 'Y',
7161 'N',
7162 'N',
7163 'N'
7164 );
7165
7166 l_step_seq := l_step_seq + 10;
7167
7168 insert into PJI_MT_PRC_STEPS
7169 (
7170 PROCESS_NAME,
7171 STEP_NAME,
7172 STEP_SEQ,
7173 STEP_TYPE,
7174 CONFIG_PROJ_PERF_FLAG,
7175 CONFIG_COST_FLAG,
7176 CONFIG_PROFIT_FLAG,
7177 CONFIG_UTIL_FLAG
7178 )
7179 values
7180 (
7181 'PJI_PJP_FPM_UPGRADE',
7182 'PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(p_worker_id);',
7183 l_step_seq,
7184 to_char(1), -- full
7185 'Y',
7186 'N',
7187 'N',
7188 'N'
7189 );
7190
7191 l_step_seq := l_step_seq + 10;
7192
7193 insert into PJI_MT_PRC_STEPS
7194 (
7195 PROCESS_NAME,
7196 STEP_NAME,
7197 STEP_SEQ,
7198 STEP_TYPE,
7199 CONFIG_PROJ_PERF_FLAG,
7200 CONFIG_COST_FLAG,
7201 CONFIG_PROFIT_FLAG,
7202 CONFIG_UTIL_FLAG
7203 )
7204 values
7205 (
7206 'PJI_PJP_FPM_UPGRADE',
7207 'PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(p_worker_id);',
7208 l_step_seq,
7209 to_char(1), -- full
7210 'Y',
7211 'N',
7212 'N',
7213 'N'
7214 );
7215
7216 l_step_seq := l_step_seq + 10;
7217
7218 insert into PJI_MT_PRC_STEPS
7219 (
7220 PROCESS_NAME,
7221 STEP_NAME,
7222 STEP_SEQ,
7223 STEP_TYPE,
7224 CONFIG_PROJ_PERF_FLAG,
7225 CONFIG_COST_FLAG,
7226 CONFIG_PROFIT_FLAG,
7227 CONFIG_UTIL_FLAG
7228 )
7229 values
7230 (
7231 'PJI_PJP_FPM_UPGRADE',
7232 'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(p_worker_id);',
7233 l_step_seq,
7234 to_char(1), -- full
7235 'Y',
7236 'N',
7237 'N',
7238 'N'
7239 );
7240
7241 l_step_seq := l_step_seq + 10;
7242
7243 insert into PJI_MT_PRC_STEPS
7244 (
7245 PROCESS_NAME,
7246 STEP_NAME,
7247 STEP_SEQ,
7248 STEP_TYPE,
7249 CONFIG_PROJ_PERF_FLAG,
7250 CONFIG_COST_FLAG,
7251 CONFIG_PROFIT_FLAG,
7252 CONFIG_UTIL_FLAG
7253 )
7254 values
7255 (
7256 'PJI_PJP_FPM_UPGRADE',
7257 'PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(p_worker_id);',
7258 l_step_seq,
7259 to_char(1), -- full
7260 'Y',
7261 'N',
7262 'N',
7263 'N'
7264 );
7265
7266 l_step_seq := l_step_seq + 10;
7267
7268 insert into PJI_MT_PRC_STEPS
7269 (
7270 PROCESS_NAME,
7271 STEP_NAME,
7272 STEP_SEQ,
7273 STEP_TYPE,
7274 CONFIG_PROJ_PERF_FLAG,
7275 CONFIG_COST_FLAG,
7276 CONFIG_PROFIT_FLAG,
7277 CONFIG_UTIL_FLAG
7278 )
7279 values
7280 (
7281 'PJI_PJP_FPM_UPGRADE',
7282 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(p_worker_id);',
7283 l_step_seq,
7284 to_char(1), -- full
7285 'Y',
7286 'N',
7287 'N',
7288 'N'
7289 );
7290
7291 l_step_seq := l_step_seq + 10;
7292
7293 insert into PJI_MT_PRC_STEPS
7294 (
7295 PROCESS_NAME,
7296 STEP_NAME,
7297 STEP_SEQ,
7298 STEP_TYPE,
7299 CONFIG_PROJ_PERF_FLAG,
7300 CONFIG_COST_FLAG,
7301 CONFIG_PROFIT_FLAG,
7302 CONFIG_UTIL_FLAG
7303 )
7304 values
7305 (
7306 'PJI_PJP_FPM_UPGRADE',
7307 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(p_worker_id);',
7308 l_step_seq,
7309 to_char(1), -- full
7310 'Y',
7311 'N',
7312 'N',
7313 'N'
7314 );
7315
7316 l_step_seq := l_step_seq + 10;
7317
7318 insert into PJI_MT_PRC_STEPS
7319 (
7320 PROCESS_NAME,
7321 STEP_NAME,
7322 STEP_SEQ,
7323 STEP_TYPE,
7324 CONFIG_PROJ_PERF_FLAG,
7325 CONFIG_COST_FLAG,
7326 CONFIG_PROFIT_FLAG,
7327 CONFIG_UTIL_FLAG
7328 )
7329 values
7330 (
7331 'PJI_PJP_FPM_UPGRADE',
7332 'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);',
7333 l_step_seq,
7334 to_char(1), -- full
7335 'Y',
7336 'N',
7337 'N',
7338 'N'
7339 );
7340
7341 l_step_seq := l_step_seq + 10;
7342
7343 insert into PJI_MT_PRC_STEPS
7344 (
7345 PROCESS_NAME,
7346 STEP_NAME,
7347 STEP_SEQ,
7348 STEP_TYPE,
7349 CONFIG_PROJ_PERF_FLAG,
7350 CONFIG_COST_FLAG,
7351 CONFIG_PROFIT_FLAG,
7352 CONFIG_UTIL_FLAG
7353 )
7354 values
7355 (
7356 'PJI_PJP_FPM_UPGRADE',
7357 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(p_worker_id);',
7358 l_step_seq,
7359 to_char(1), -- full
7360 'Y',
7361 'N',
7362 'N',
7363 'N'
7364 );
7365
7366 l_step_seq := l_step_seq + 10;
7367
7368 insert into PJI_MT_PRC_STEPS
7369 (
7370 PROCESS_NAME,
7371 STEP_NAME,
7372 STEP_SEQ,
7373 STEP_TYPE,
7374 CONFIG_PROJ_PERF_FLAG,
7375 CONFIG_COST_FLAG,
7376 CONFIG_PROFIT_FLAG,
7377 CONFIG_UTIL_FLAG
7378 )
7379 values
7380 (
7381 'PJI_PJP_FPM_UPGRADE',
7382 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);',
7383 l_step_seq,
7384 to_char(1), -- full
7385 'Y',
7386 'N',
7387 'N',
7388 'N'
7389 );
7390
7391 l_step_seq := l_step_seq + 10;
7392
7393 insert into PJI_MT_PRC_STEPS
7394 (
7395 PROCESS_NAME,
7396 STEP_NAME,
7397 STEP_SEQ,
7398 STEP_TYPE,
7399 CONFIG_PROJ_PERF_FLAG,
7400 CONFIG_COST_FLAG,
7401 CONFIG_PROFIT_FLAG,
7402 CONFIG_UTIL_FLAG
7403 )
7404 values
7405 (
7406 'PJI_PJP_FPM_UPGRADE',
7407 'PJI_PJP_SUM_ROLLUP.CREATE_FP_PA_PRI_ROLLUP(p_worker_id);',
7408 l_step_seq,
7409 to_char(1), -- full
7410 'Y',
7411 'N',
7412 'N',
7413 'N'
7414 );
7415
7416 l_step_seq := l_step_seq + 10;
7417
7418 insert into PJI_MT_PRC_STEPS
7419 (
7420 PROCESS_NAME,
7421 STEP_NAME,
7422 STEP_SEQ,
7423 STEP_TYPE,
7424 CONFIG_PROJ_PERF_FLAG,
7425 CONFIG_COST_FLAG,
7426 CONFIG_PROFIT_FLAG,
7427 CONFIG_UTIL_FLAG
7428 )
7429 values
7430 (
7431 'PJI_PJP_FPM_UPGRADE',
7432 'PJI_PJP_SUM_ROLLUP.CREATE_FP_GL_PRI_ROLLUP(p_worker_id);',
7433 l_step_seq,
7434 to_char(1), -- full
7435 'Y',
7436 'N',
7437 'N',
7438 'N'
7439 );
7440
7441 l_step_seq := l_step_seq + 10;
7442
7443 insert into PJI_MT_PRC_STEPS
7444 (
7445 PROCESS_NAME,
7446 STEP_NAME,
7447 STEP_SEQ,
7448 STEP_TYPE,
7449 CONFIG_PROJ_PERF_FLAG,
7450 CONFIG_COST_FLAG,
7451 CONFIG_PROFIT_FLAG,
7452 CONFIG_UTIL_FLAG
7453 )
7454 values
7455 (
7456 'PJI_PJP_FPM_UPGRADE',
7457 'PJI_PJP_SUM_ROLLUP.CREATE_FP_ALL_PRI_ROLLUP(p_worker_id);',
7458 l_step_seq,
7459 to_char(1), -- full
7460 'Y',
7461 'N',
7462 'N',
7463 'N'
7464 );
7465
7466 l_step_seq := l_step_seq + 10;
7467
7468 insert into PJI_MT_PRC_STEPS
7469 (
7470 PROCESS_NAME,
7471 STEP_NAME,
7472 STEP_SEQ,
7473 STEP_TYPE,
7474 CONFIG_PROJ_PERF_FLAG,
7475 CONFIG_COST_FLAG,
7476 CONFIG_PROFIT_FLAG,
7477 CONFIG_UTIL_FLAG
7478 )
7479 values
7480 (
7481 'PJI_PJP_FPM_UPGRADE',
7482 'PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(p_worker_id);',
7483 l_step_seq,
7484 to_char(1), -- full
7485 'Y',
7486 'N',
7487 'N',
7488 'N'
7489 );
7490
7491 l_step_seq := l_step_seq + 10;
7492
7493 insert into PJI_MT_PRC_STEPS
7494 (
7495 PROCESS_NAME,
7496 STEP_NAME,
7497 STEP_SEQ,
7498 STEP_TYPE,
7499 CONFIG_PROJ_PERF_FLAG,
7500 CONFIG_COST_FLAG,
7501 CONFIG_PROFIT_FLAG,
7502 CONFIG_UTIL_FLAG
7503 )
7504 values
7505 (
7506 'PJI_PJP_FPM_UPGRADE',
7507 'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(p_worker_id);',
7508 l_step_seq,
7509 to_char(1), -- full
7510 'Y',
7511 'N',
7512 'N',
7513 'N'
7514 );
7515
7516 end REFRESH_STEP_TABLE;
7517
7518 end PJI_PROCESS_UTIL;