[Home] [Help]
PACKAGE: APPS.AHL_MC_RULE_PVT
Source
1 PACKAGE AHL_MC_RULE_PVT AS
2 /* $Header: AHLVMCRS.pls 120.0.12010000.2 2008/11/26 14:09:40 sathapli ship $ */
3
4
5 ---------------------------------
6 -- Define Record Type for Node --
7 ---------------------------------
8 TYPE Rule_Rec_Type IS RECORD (
9 RULE_ID NUMBER,
10 OBJECT_VERSION_NUMBER NUMBER,
11 LAST_UPDATE_DATE DATE,
12 LAST_UPDATED_BY NUMBER(15) ,
13 CREATION_DATE DATE ,
14 CREATED_BY NUMBER(15) ,
15 LAST_UPDATE_LOGIN NUMBER(15),
16 MC_HEADER_ID NUMBER ,
17 -- SATHAPLI::FP ER 6504160, 25-Nov-2008, added MC_NAME and MC_REVISION to the record.
18 MC_NAME VARCHAR2(80) ,
19 MC_REVISION VARCHAR2(30) ,
20 RULE_NAME VARCHAR2(80) ,
21 RULE_TYPE_CODE VARCHAR2(30) ,
22 RULE_TYPE_MEANING VARCHAR2(80) ,
23 ACTIVE_START_DATE DATE,
24 ACTIVE_END_DATE DATE,
25 DESCRIPTION VARCHAR2(2000) ,
26 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
27 ATTRIBUTE1 VARCHAR2(150) ,
28 ATTRIBUTE2 VARCHAR2(150) ,
29 ATTRIBUTE3 VARCHAR2(150) ,
30 ATTRIBUTE4 VARCHAR2(150) ,
31 ATTRIBUTE5 VARCHAR2(150) ,
32 ATTRIBUTE6 VARCHAR2(150) ,
33 ATTRIBUTE7 VARCHAR2(150) ,
34 ATTRIBUTE8 VARCHAR2(150) ,
35 ATTRIBUTE9 VARCHAR2(150) ,
36 ATTRIBUTE10 VARCHAR2(150) ,
37 ATTRIBUTE11 VARCHAR2(150) ,
38 ATTRIBUTE12 VARCHAR2(150) ,
39 ATTRIBUTE13 VARCHAR2(150) ,
40 ATTRIBUTE14 VARCHAR2(150) ,
41 ATTRIBUTE15 VARCHAR2(150) ,
42 OPERATION_FLAG VARCHAR2(1) := null
43 );
44
45 TYPE Rule_Stmt_Rec_Type IS RECORD (
46 RULE_STATEMENT_ID NUMBER ,
47 OBJECT_VERSION_NUMBER NUMBER,
48 LAST_UPDATE_DATE DATE,
49 LAST_UPDATED_BY NUMBER(15) ,
50 CREATION_DATE DATE ,
51 CREATED_BY NUMBER(15) ,
52 LAST_UPDATE_LOGIN NUMBER(15),
53 RULE_ID NUMBER,
54 TOP_RULE_STMT_FLAG VARCHAR2(1),
55 NEGATION_FLAG VARCHAR2(1),
56 SUBJECT_ID NUMBER ,
57 SUBJECT_TYPE VARCHAR2(30) ,
58 OPERATOR VARCHAR2(30) ,
59 OBJECT_ID NUMBER ,
60 OBJECT_TYPE VARCHAR2(30) ,
61 OBJECT_ATTRIBUTE1 VARCHAR2(30),
62 OBJECT_ATTRIBUTE2 VARCHAR2(30),
63 OBJECT_ATTRIBUTE3 VARCHAR2(30),
64 OBJECT_ATTRIBUTE4 VARCHAR2(30),
65 OBJECT_ATTRIBUTE5 VARCHAR2(30),
66 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
67 ATTRIBUTE1 VARCHAR2(150) ,
68 ATTRIBUTE2 VARCHAR2(150) ,
69 ATTRIBUTE3 VARCHAR2(150) ,
70 ATTRIBUTE4 VARCHAR2(150) ,
71 ATTRIBUTE5 VARCHAR2(150) ,
72 ATTRIBUTE6 VARCHAR2(150) ,
73 ATTRIBUTE7 VARCHAR2(150) ,
74 ATTRIBUTE8 VARCHAR2(150) ,
75 ATTRIBUTE9 VARCHAR2(150) ,
76 ATTRIBUTE10 VARCHAR2(150) ,
77 ATTRIBUTE11 VARCHAR2(150) ,
78 ATTRIBUTE12 VARCHAR2(150) ,
79 ATTRIBUTE13 VARCHAR2(150) ,
80 ATTRIBUTE14 VARCHAR2(150) ,
81 ATTRIBUTE15 VARCHAR2(150) ,
82 OPERATION_FLAG VARCHAR2(1) := null
83 );
84
85
86 TYPE UI_Rule_Stmt_Rec_Type IS RECORD (
87 -- RULE_ID NUMBER,
88 SEQUENCE_NUM NUMBER,
89 LEFT_PAREN VARCHAR2(30),
90 RULE_STATEMENT_ID NUMBER ,
91 RULE_STMT_OBJ_VER_NUM NUMBER ,
92 RULE_STMT_DEPTH NUMBER,
93 POSITION_ID NUMBER,
94 POSITION_MEANING VARCHAR2(80) ,
95 OPERATOR VARCHAR2(80) ,
96 OPERATOR_MEANING VARCHAR2(80) ,
97 OBJECT_TYPE VARCHAR2(30) ,
98 OBJECT_TYPE_MEANING VARCHAR2(80),
99 OBJECT_ID NUMBER ,
100 OBJECT_MEANING VARCHAR2(80),
101 -- SATHAPLI::FP ER 6504160, 25-Nov-2008, added MC_REVISION to the record.
102 MC_REVISION VARCHAR2(30) ,
103 OBJECT_ATTRIBUTE1 VARCHAR2(30),
104 OBJECT_ATTRIBUTE2 VARCHAR2(30),
105 OBJECT_ATTRIBUTE3 VARCHAR2(30),
106 OBJECT_ATTRIBUTE4 VARCHAR2(30),
107 OBJECT_ATTRIBUTE5 VARCHAR2(30),
108 RIGHT_PAREN VARCHAR2(30),
109 RULE_OPERATOR VARCHAR2(80) ,
110 RULE_OPERATOR_MEANING VARCHAR2(80) ,
111 RULE_OPER_STMT_ID NUMBER,
112 RULE_OPER_STMT_OBJ_VER_NUM NUMBER,
113 RULE_OPER_STMT_DEPTH NUMBER,
114 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
115 ATTRIBUTE1 VARCHAR2(150) ,
116 ATTRIBUTE2 VARCHAR2(150) ,
117 ATTRIBUTE3 VARCHAR2(150) ,
118 ATTRIBUTE4 VARCHAR2(150) ,
119 ATTRIBUTE5 VARCHAR2(150) ,
120 ATTRIBUTE6 VARCHAR2(150) ,
121 ATTRIBUTE7 VARCHAR2(150) ,
122 ATTRIBUTE8 VARCHAR2(150) ,
123 ATTRIBUTE9 VARCHAR2(150) ,
124 ATTRIBUTE10 VARCHAR2(150) ,
125 ATTRIBUTE11 VARCHAR2(150) ,
126 ATTRIBUTE12 VARCHAR2(150) ,
127 ATTRIBUTE13 VARCHAR2(150) ,
128 ATTRIBUTE14 VARCHAR2(150) ,
129 ATTRIBUTE15 VARCHAR2(150)
130 );
131
132 ---------------------------------
133 -- Define Table Type for Node --
134 ---------------------------------
135 TYPE UI_Rule_Stmt_Tbl_Type IS TABLE OF UI_Rule_Stmt_Rec_Type INDEX BY BINARY_INTEGER;
136
137 TYPE Rule_Stmt_Tbl_Type IS TABLE OF Rule_Stmt_Rec_Type INDEX BY BINARY_INTEGER;
138
139 TYPE Rule_Tbl_Type IS TABLE OF Rule_Rec_Type INDEX BY BINARY_INTEGER;
140
141
142 ------------------------
143 -- Declare Procedures --
144 ------------------------
145 -- Start of Comments --
146 -- Procedure name : Load_Rule
147 -- Type : Private
148 -- Function : Builds the rule record and ui rule table for display purposes
149 -- Pre-reqs :
150 -- Parameters :
151 --
152 -- Load_Rule Parameters:
153 -- p_rule_id IN NUMBER Required
154 --
155 -- End of Comments.
156
157 PROCEDURE Load_Rule (
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_rule_id IN NUMBER,
166 x_rule_stmt_tbl OUT NOCOPY AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type);
167
168 --------------------------------
169 -- Start of Comments --
170 -- Procedure name : Insert_Rule
171 -- Type : Private
172 -- Function : Writes to DB the rule record and ui rule table
173 -- Pre-reqs :
174 -- Parameters :
175 --
176 -- Insert_Rule Parameters:
177 -- p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type Required
178 -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
179 --
180 -- End of Comments.
181
182 PROCEDURE Insert_Rule (
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_module IN VARCHAR2 := 'JSP',
191 p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type,
192 p_x_rule_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Rec_Type
193 );
194
195 --------------------------------
196 -- Start of Comments --
197 -- Procedure name : Update_Rule
198 -- Type : Private
199 -- Function : Writes to DB the rule record and ui rule table
200 -- Pre-reqs :
201 -- Parameters :
202 --
203 -- Update_Rule Parameters:
204 -- p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type Required
205 -- p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type Required
206 --
207 -- End of Comments.
208
209 PROCEDURE Update_Rule (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_module IN VARCHAR2 := 'JSP',
218 p_rule_rec IN AHL_MC_RULE_PVT.Rule_Rec_Type,
219 p_rule_stmt_tbl IN AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type);
220
221 -----------------------------
222 -- Start of Comments --
223 -- Procedure name : Delete_Rule
224 -- Type : Private
225 -- Function : Deletes the Rule corresponding to p_rule_rec
226 -- Pre-reqs :
227 -- Parameters :
228 --
229 -- Delete_Rule Parameters:
230 -- p_rule_rec.rule_id IN NUMBER Required
231 -- p_rule_rec.object_version_number IN NUMBER Required
232 --
233 -- End of Comments.
234
235 PROCEDURE Delete_Rule (
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE,
239 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_rule_rec IN RULE_REC_TYPE
244 );
245
246 -----------------------------
247 -- Start of Comments --
248 -- Procedure name : Copy_Rules_For_MC
249 -- Type : Private
250 -- Function : Copies all Rules for 1 MC to another MC
251 -- Pre-reqs :
252 -- Parameters :
253 --
254 -- Copy_Rule_For_MC Parameters:
255 -- p_from_mc_header_id IN NUMBER Required
256 -- p_to_mc_header_id IN NUMBER Required
257 --
258 -- End of Comments.
259
260 PROCEDURE Copy_Rules_For_MC (
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263 p_commit IN VARCHAR2 := FND_API.G_FALSE,
264 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_from_mc_header_id IN NUMBER,
269 p_to_mc_header_id IN NUMBER);
270
271 -----------------------------
272 -- Start of Comments --
273 -- Procedure name : Delete_Rules_For_MC
274 -- Type : Private
275 -- Function : Deletes the Rule corresponding to 1 MC
276 -- Pre-reqs :
277 -- Parameters :
278 --
279 -- Delete_Rules_For_MC Parameters:
280 -- p_mc_header_id IN NUMBER Required
281 --
282 -- End of Comments.
283
284 PROCEDURE Delete_Rules_For_MC (
285 p_api_version IN NUMBER,
286 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287 p_commit IN VARCHAR2 := FND_API.G_FALSE,
288 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_mc_header_id IN NUMBER);
293
294
295 -----------------------------
296 -- Start of Comments --
297 -- Procedure name : Get_Rules_For_Position
298 -- Type : Private
299 -- Function : Returns all the rules that belong to a position
300 -- Pre-reqs :
301 -- Parameters :
302 --
303 -- Copy_Rule_For_MC Parameters:
304 -- p_encoded_path IN VARCHAR2 Required
305 -- p_to_mc_header_id IN NUMBER Required
306 --
307 -- End of Comments.
308
309 PROCEDURE Get_Rules_For_Position (
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312 p_commit IN VARCHAR2 := FND_API.G_FALSE,
313 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 p_mc_header_id IN NUMBER,
318 p_encoded_path IN VARCHAR2,
319 x_rule_tbl OUT NOCOPY Rule_Tbl_Type);
320
321 End AHL_MC_RULE_PVT;