1 PACKAGE OKS_RULE_MIGRATE AS
2 /* $Header: OKSRMIGS.pls 120.0 2005/05/25 18:30:57 appldev noship $ */
3
4 ---------------------------------------------------------------
5 --- The following procedures are for validation phase. -------
6 ---------------------------------------------------------------
7
8 PROCEDURE UPDATE_RULE_RECORD(
9 P_ID IN NUMBER,
10 P_COLUMN_NAME IN VARCHAR2,
11 P_NEW_VALUE IN VARCHAR2,
12 P_CURRENT_VALUE IN VARCHAR2,
13 P_RULE_INFO_CATEGORY IN VARCHAR2,
14 P_ROW_ID IN VARCHAR2,
15 P_MAJOR_VERSION IN NUMBER,
16 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
17 X_ERROR_MSG OUT NOCOPY VARCHAR2);
18
19 FUNCTION GET_DATA_VOLUME RETURN NUMBER ;
20
21 Procedure Validate_data1 (
22 ERRBUF OUT NOCOPY VARCHAR2,
23 RETCODE OUT NOCOPY NUMBER,
24 P_STATUS IN VARCHAR2,
25 P_ORG_ID IN NUMBER,
26 P_LEVEL IN VARCHAR2,
27 P_SUB_REQUESTS IN NUMBER,
28 P_BATCH_SIZE IN NUMBER );
29
30 Procedure VALIDATE_HDR_RULE
31 (ERRBUF OUT NOCOPY VARCHAR2,
32 RETCODE OUT NOCOPY NUMBER,
33 p_status in VARCHAR2,
34 p_org_id in NUMBER ,
35 p_batch_size in NUMBER,
36 p_us_yn in VARCHAR2,
37 p_id_low in NUMBER,
38 p_id_hig in NUMBER );
39
40 Procedure VALIDATE_HDR_HIST_RULE
41 (ERRBUF OUT NOCOPY VARCHAR2,
42 RETCODE OUT NOCOPY NUMBER,
43 p_status in VARCHAR2,
44 p_org_id in NUMBER ,
45 p_batch_size in NUMBER,
46 p_us_yn in VARCHAR2,
47 p_id_low in NUMBER,
48 p_id_hig in NUMBER );
49
50 Procedure VALIDATE_LINE_RULE(
51 ERRBUF OUT NOCOPY VARCHAR2 ,
52 RETCODE OUT NOCOPY NUMBER ,
53 p_status in VARCHAR2,
54 p_org_id in NUMBER ,
55 p_batch_size in NUMBER,
56 p_us_yn in VARCHAR2,
57 p_id_low in NUMBER,
58 p_id_hig in NUMBER);
59
60 Procedure VALIDATE_LINE_HIST_RULE(
61 ERRBUF OUT NOCOPY VARCHAR2 ,
62 RETCODE OUT NOCOPY NUMBER ,
63 p_status in VARCHAR2,
64 p_org_id in NUMBER ,
65 p_batch_size in NUMBER,
66 p_us_yn in VARCHAR2,
67 p_id_low in NUMBER,
68 p_id_hig in NUMBER);
69
70 Procedure VALIDATE_ALLH_RULE(
71 ERRBUF OUT NOCOPY VARCHAR2 ,
72 RETCODE OUT NOCOPY NUMBER ,
73 p_status in VARCHAR2,
74 p_org_id in NUMBER ,
75 p_batch_size in NUMBER,
76 p_us_yn in VARCHAR2,
77 p_id_low in NUMBER,
78 p_id_hig in NUMBER) ;
79
80 Procedure VALIDATE_ALL_RULE(
81 ERRBUF OUT NOCOPY VARCHAR2 ,
82 RETCODE OUT NOCOPY NUMBER ,
83 p_status in VARCHAR2,
84 p_org_id in NUMBER ,
85 p_batch_size in NUMBER,
86 p_us_yn in VARCHAR2,
87 p_id_low in NUMBER,
88 p_id_hig in NUMBER) ;
89
90 ----------------------------------------------------------
91 --The following procedures are for synchronization & --
92 --reprocessing. --
93 ----------------------------------------------------------
94 Procedure REPROCESS_HDR_RULE(
95 prow_id in ROWID ,
96 p_id in NUMBER ,
97 p_us_yn in BOOLEAN,
98 x_return_status out NOCOPY VARCHAR2);
99
100 Procedure REPROCESS_HDR_HIST_RULE(
101 prow_id in ROWID ,
102 p_id in NUMBER ,
103 p_major_version in NUMBER ,
104 p_us_yn in BOOLEAN,
105 x_return_status out NOCOPY VARCHAR2);
106
107 Procedure REPROCESS_LINE_RULE(
108 prow_id in ROWID ,
109 p_id in NUMBER ,
110 p_us_yn in BOOLEAN,
111 x_return_status out NOCOPY VARCHAR2);
112
113 Procedure REPROCESS_LINE_HIST_RULE(
114 prow_id in ROWID ,
115 p_id in NUMBER ,
116 p_major_version in NUMBER ,
117 p_us_yn in BOOLEAN,
118 x_return_status out NOCOPY VARCHAR2);
119
120
121 PROCEDURE SYNCHRONIZE_RULE_DATA_SUBREQ(
122 ERRBUF OUT NOCOPY VARCHAR2,
123 RETCODE OUT NOCOPY NUMBER,
124 P_BATCH_SIZE IN NUMBER,
125 P_ID_LOW IN NUMBER,
126 P_ID_HI IN NUMBER );
127
128 PROCEDURE REPROCESS_RULE_DATA_SUBREQ(
129 ERRBUF OUT NOCOPY VARCHAR2,
130 RETCODE OUT NOCOPY NUMBER,
131 P_BATCH_SIZE IN NUMBER,
132 P_ID_LOW IN NUMBER,
133 P_ID_HI IN NUMBER );
134
135 PROCEDURE SYNCHRONIZE_RULE_HDR(
136 P_RGP_ID IN NUMBER,
137 P_CHR_ID IN NUMBER,
138 p_us_yn in BOOLEAN,
139 x_return_status out NOCOPY VARCHAR2);
140
141 PROCEDURE SYNCHRONIZE_RULE_LINE(
142 P_RGP_ID IN NUMBER,
143 P_CLE_ID IN NUMBER,
144 DNZ_CHR_ID IN NUMBER,
145 p_us_yn in BOOLEAN,
146 x_return_status out NOCOPY VARCHAR2);
147
148 PROCEDURE SYNCHRONIZE_RULE_LINEH(
149 P_RGP_ID IN NUMBER,
150 P_CLE_ID IN NUMBER,
151 DNZ_CHR_ID IN NUMBER,
152 p_major_version in NUMBER ,
153 p_us_yn in BOOLEAN,
154 x_return_status out NOCOPY VARCHAR2);
155
156 PROCEDURE SYNCHRONIZE_RULE_HDRH(
157 P_RGP_ID IN NUMBER,
158 P_CHR_ID IN NUMBER,
159 p_major_version in NUMBER ,
160 p_us_yn in BOOLEAN,
161 x_return_status out NOCOPY VARCHAR2);
162
163 Procedure REPROCESS_SYNCHL_RULE (
164 prow_id in ROWID
165 ,p_id in NUMBER
166 ,p_major_version_number in NUMBER
167 ,p_us_yn in BOOLEAN
168 ,x_return_status OUT NOCOPY VARCHAR2 );
169
170 Procedure REPROCESS_OKSLEVEL (
171 prow_id in ROWID
172 ,p_id in NUMBER
173 ,p_major_version_number in NUMBER
174 ,p_us_yn in BOOLEAN
175 ,x_return_status OUT NOCOPY VARCHAR2 );
176
177 Procedure SYNCHRONIZE_RULE_CVR(
178 P_RGP_ID IN NUMBER,
179 P_CLE_ID IN NUMBER,
180 P_DNZ_CHR_ID IN NUMBER,
181 P_MAJOR_VERSION IN NUMBER,
182 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
183
184 Procedure SYNCHRONIZE_RULE_ATM(
185 P_RGP_ID IN NUMBER,
186 P_CLE_ID IN NUMBER,
187 P_DNZ_CHR_ID IN NUMBER,
188 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
189
190 Procedure SYNCHRONIZE_RULE_ATMH(
191 P_RGP_ID IN NUMBER,
192 P_CLE_ID IN NUMBER,
193 P_DNZ_CHR_ID IN NUMBER,
194 P_MAJOR_VERSION IN NUMBER,
195 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
196
197 Procedure SYNCHRONIZE_RULE_PML(
198 P_RGP_ID IN NUMBER,
199 P_CLE_ID IN NUMBER,
200 P_DNZ_CHR_ID IN NUMBER,
201 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
202
203 Procedure SYNCHRONIZE_RULE_SLL(
204 P_RGP_ID IN NUMBER,
205 P_CLE_ID IN NUMBER,
206 P_US_YN IN BOOLEAN,
207 X_RETURN_STATUS OUT NOCOPY VARCHAR2) ;
208
209 Procedure SYNCHRONIZE_RULE_SLLH(
210 P_RGP_ID IN NUMBER,
211 P_CHR_ID IN NUMBER,
212 P_US_YN IN BOOLEAN,
213 X_RETURN_STATUS OUT NOCOPY VARCHAR2) ;
214
215 PROCEDURE SYNCHRONIZE_REPROC_RULE_DATA(
216 ERRBUF OUT NOCOPY VARCHAR2,
217 RETCODE OUT NOCOPY NUMBER,
218 P_SUB_REQUESTS IN NUMBER,
219 P_BATCH_SIZE IN NUMBER );
220
221 PROCEDURE SYNCHRONIZE_RULE_OFS(
222 P_RGP_ID IN NUMBER,
223 P_CLE_ID IN NUMBER,
224 P_DNZ_CHR_ID IN NUMBER,
225 P_MAJOR_VERSION IN NUMBER,
226 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
227
228
229 END OKS_RULE_MIGRATE;
230