[Home] [Help]
1 package PJI_PROCESS_UTIL as
2 /* $Header: PJIUT03S.pls 120.2 2005/12/06 16:29:01 appldev noship $ */
3
4 -- ----------------------------------------------------------
5 -- function SUMMARIZATION_STARTED
6 -- ----------------------------------------------------------
7 function SUMMARIZATION_STARTED
8 (
9 p_stage in varchar2 default 'STAGE1_EXTR'
10 ) return varchar2;
11
12 -- ----------------------------------------------------------
13 -- function NEED_TO_RUN_STEP
14 --
15 -- This function returns FALSE if a given process step
16 -- did not run before or has failed during prior
17 -- process iteration.
18 -- ----------------------------------------------------------
19 function NEED_TO_RUN_STEP
20 (
21 p_process in varchar2,
22 p_step in varchar2
23 ) return boolean;
24
25
26 -- ----------------------------------------------------------
27 -- procedure REGISTER_STEP_COMPLETION
28 --
29 -- This utility procedure is called from individual steps.
30 -- Procedure updates process log table with successful
31 -- completion status for a given step.
32 -- ----------------------------------------------------------
33 procedure REGISTER_STEP_COMPLETION
34 (
35 p_process in varchar2,
36 p_step in varchar2
37 );
38
39
40 -- ----------------------------------------------------------
41 -- procedure CHECK_STEP
42 --
43 -- This utility is for debugging purposes.
44 -- If check step is not set to 'Y' any step can be run in
45 -- the summarization process without looking at
46 -- PJI_SYSTEM_PRC_STATUS to see if the step has run before.
47 -- ----------------------------------------------------------
48 procedure CHECK_STEP (p_check_step in varchar2 default 'Y');
49
50
51 -- ----------------------------------------------------------
52 -- procedure WRAPUP_PROCESS
53 --
54 -- If process completed successfuly, we clean up process
55 -- log table from the step status records.
56 -- ----------------------------------------------------------
57 procedure WRAPUP_PROCESS (p_process in varchar2);
58
59
60 -- ----------------------------------------------------------
61 -- procedure ADD_STEPS
62 -- ----------------------------------------------------------
63 procedure ADD_STEPS
64 (
65 p_process in varchar2,
66 p_step_process in varchar2,
67 p_extraction_type in varchar2
68 );
69
70
71 -- ----------------------------------------------------------
72 -- function PRIOR_ITERATION_SUCCESSFUL
73 --
74 -- This function returns TRUE if prior load process
75 -- completed successful.
76 -- If prior iteration is successful, process log table
77 -- does not have any records for the process.
78 -- ----------------------------------------------------------
79 function PRIOR_ITERATION_SUCCESSFUL (p_process in varchar2) return boolean;
80
81
82 -- ----------------------------------------------------------
83 -- function GET_PROCESS_PARAMETER
84 -- ----------------------------------------------------------
85 function GET_PROCESS_PARAMETER
86 (
87 p_process in varchar2,
88 p_parameter in varchar2
89 ) return varchar2;
90
91
92 -- ----------------------------------------------------------
93 -- procedure SET_PROCESS_PARAMETER
94 -- ----------------------------------------------------------
95 procedure SET_PROCESS_PARAMETER
96 (
97 p_process in varchar2,
98 p_parameter in varchar2,
99 p_value in varchar2
100 );
101
102
103 -- ----------------------------------------------------------
104 -- procedure SLEEP
105 -- ----------------------------------------------------------
106 procedure SLEEP (p_time_in_seconds in number);
107
108
109 -- ----------------------------------------------------------
110 -- procedure TRUNC_INT_TABLE
111 -- ----------------------------------------------------------
112 procedure TRUNC_INT_TABLE
113 ( p_schema in varchar2
114 , p_tablename in varchar2
115 , p_trunc_type in varchar2
116 , p_partition in varchar2
117 );
118
119
120 -- ----------------------------------------------------------
121 -- function WAIT_FOR_STEP
122 --
123 -- This function waits until all applicable workers have
124 -- completed p_step.
125 -- ----------------------------------------------------------
126 function WAIT_FOR_STEP
127 (
128 p_process in varchar2,
129 p_step in varchar2,
130 p_timeout in number,
131 p_exists in varchar2 default 'ONLY_IF_EXISTS'
132 ) return boolean;
133
134
135 -- ----------------------------------------------------------
136 -- procedure CLEAN_HELPER_BATCH_TABLE
137 -- ----------------------------------------------------------
138 procedure CLEAN_HELPER_BATCH_TABLE;
139
140
141 -- -----------------------------------------------------
142 -- function REQUEST_STATUS
143 -- -----------------------------------------------------
144 function REQUEST_STATUS
145 (
146 p_mode in varchar2,
147 p_request_id in number,
148 p_request_name in varchar2
149 ) return boolean;
150
151
152 -- -----------------------------------------------------
153 -- procedure WAIT_FOR_REQUEST
154 -- -----------------------------------------------------
155 procedure WAIT_FOR_REQUEST
156 (
157 p_request_id in number,
158 p_delay in number
159 );
160
161 -- ----------------------------------------------------------
162 -- procedure REFRESH_STEP_TABLE
163 -- ----------------------------------------------------------
164 procedure REFRESH_STEP_TABLE;
165
166 end pji_process_util;
|
|
|
|