1 PACKAGE PV_PROCESS_RULE_PVT AUTHID CURRENT_USER as
2 /* $Header: pvrvprus.pls 115.9 2002/12/03 23:23:07 ryellapu ship $ */
3 -- Start of Comments
4 -- Package name : PV_PROCESS_RULE_PVT
5 -- Purpose :
6 -- History :
7 -- 01/08/2002 SOLIN Created.
8 -- NOTE :
9 -- End of Comments
10
11
12
13 -- *******************************************************
14 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_process_rule
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25 -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26 --
27 -- OUT:
28 -- x_return_status OUT VARCHAR2
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2
31 -- Version : Current version 2.0
32 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
33 -- and basic operation, developer must manually add parameters and business logic as necessary.
34 --
35 -- End of Comments
36 --
37
38 PROCEDURE Create_process_rule(
39 P_Api_Version_Number IN NUMBER,
40 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43 P_Identity_Resource_Id IN NUMBER,
44 P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
45 := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
46 X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
47 X_Return_Status OUT NOCOPY VARCHAR2,
48 X_Msg_Count OUT NOCOPY NUMBER,
49 X_Msg_Data OUT NOCOPY VARCHAR2
50 );
51
52 -- *******************************************************
53 -- Start of Comments
54 -- *******************************************************
55 -- API Name: Update_process_rule
56 -- Type : Private
57 -- Pre-Req :
58 -- Parameters:
59 -- IN
60 -- p_api_version_number IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_identity_resource_id IN NUMBER Optional Default = NULL
65 -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
66 --
67 -- OUT:
68 -- x_return_status OUT VARCHAR2
69 -- x_msg_count OUT NUMBER
70 -- x_msg_data OUT VARCHAR2
71 -- Version : Current version 2.0
72 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
73 -- and basic operation, developer must manually add parameters and business logic as necessary.
74 --
75 -- End of Comments
76 --
77 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78 PROCEDURE Update_process_rule(
79 P_Api_Version_Number IN NUMBER,
80 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 P_Identity_Resource_Id IN NUMBER,
84 P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2
88 );
89
90 -- *******************************************************
91 -- Start of Comments
92 -- *******************************************************
93 -- API Name: Delete_process_rule
94 -- Type : Private
95 -- Pre-Req :
96 -- Parameters:
97 -- IN
98 -- p_api_version_number IN NUMBER Required
99 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102 -- p_identity_resource_id IN NUMBER Optional Default = NULL
103 -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
104 --
105 -- OUT:
106 -- x_return_status OUT VARCHAR2
107 -- x_msg_count OUT NUMBER
108 -- x_msg_data OUT VARCHAR2
109 -- Version : Current version 2.0
110 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
111 -- and basic operation, developer must manually add parameters and business logic as necessary.
112 --
113 -- End of Comments
114 --
115 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
116 -- The Master delete procedure may not be needed depends on different business requirements.
117 PROCEDURE Delete_process_rule(
118 P_Api_Version_Number IN NUMBER,
119 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 P_Identity_Resource_Id IN NUMBER,
123 P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
124 X_Return_Status OUT NOCOPY VARCHAR2,
125 X_Msg_Count OUT NOCOPY NUMBER,
126 X_Msg_Data OUT NOCOPY VARCHAR2
127 );
128
129 -- *******************************************************
130 -- Start of Comments
131 -- *******************************************************
132 -- API Name: Copy_process_rule
133 -- Type : Private
134 -- Pre-Req :
135 -- Parameters:
136 -- IN
137 -- p_api_version_number IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141 -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142 --
143 -- OUT:
144 -- x_return_status OUT VARCHAR2
145 -- x_msg_count OUT NUMBER
146 -- x_msg_data OUT VARCHAR2
147 -- Version : Current version 2.0
148 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
149 -- and basic operation, developer must manually add parameters and business logic as necessary.
150 --
151 -- End of Comments
152 --
153
154 PROCEDURE Copy_process_rule(
155 P_Api_Version_Number IN NUMBER,
156 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 P_Identity_Resource_Id IN NUMBER,
160 P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
161 := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
162 X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
163 X_Return_Status OUT NOCOPY VARCHAR2,
164 X_Msg_Count OUT NOCOPY NUMBER,
165 X_Msg_Data OUT NOCOPY VARCHAR2
166 );
167
168
169
170 -- Start of Comments
171 --
172 -- Item level validation procedures
173 --
174 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
175 -- For create: G_CREATE, for update: G_UPDATE
176 -- Note: 1. This is automated generated item level validation procedure.
177 -- The actual validation detail is needed to be added.
178 --
179 -- End of Comments
180
181 PROCEDURE Validate_PROCESS_RULE_ID (
182 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183 P_Validation_mode IN VARCHAR2,
184 P_PROCESS_RULE_ID IN NUMBER,
185 X_Return_Status OUT NOCOPY VARCHAR2,
186 X_Msg_Count OUT NOCOPY NUMBER,
187 X_Msg_Data OUT NOCOPY VARCHAR2
188 );
189
190
191 -- Start of Comments
192 --
193 -- Item level validation procedures
194 --
195 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
196 -- For create: G_CREATE, for update: G_UPDATE
197 -- Note: 1. This is automated generated item level validation procedure.
198 -- The actual validation detail is needed to be added.
199 --
200 -- End of Comments
201
202 PROCEDURE Validate_OWNER_RESOURCE_ID (
203 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204 P_Validation_mode IN VARCHAR2,
205 P_OWNER_RESOURCE_ID IN NUMBER,
206 X_Return_Status OUT NOCOPY VARCHAR2,
207 X_Msg_Count OUT NOCOPY NUMBER,
208 X_Msg_Data OUT NOCOPY VARCHAR2
209 );
210
211
212 -- Start of Comments
213 --
214 -- Item level validation procedures
215 --
216 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
217 -- For create: G_CREATE, for update: G_UPDATE
218 -- Note: 1. This is automated generated item level validation procedure.
219 -- The actual validation detail is needed to be added.
220 --
221 -- End of Comments
222
223 PROCEDURE Validate_CURRENCY_CODE (
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Validation_mode IN VARCHAR2,
226 P_CURRENCY_CODE IN VARCHAR2,
227 X_Return_Status OUT NOCOPY VARCHAR2,
228 X_Msg_Count OUT NOCOPY NUMBER,
229 X_Msg_Data OUT NOCOPY VARCHAR2
230 );
231
232
233 -- Start of Comments
234 --
235 -- validation procedures
236 --
237 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
238 -- For create: G_CREATE, for update: G_UPDATE
239 -- Note: 1. This is automated generated item level validation procedure.
240 -- The actual validation detail is needed to be added.
241 -- 2. We can also validate table instead of record. There will be an option for user to choose.
242 -- End of Comments
243
244 PROCEDURE Validate_RANK (
245 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246 P_Validation_mode IN VARCHAR2,
247 P_Parent_Rule_ID IN NUMBER,
248 P_Child_Rule_ID IN NUMBER,
249 P_RANK IN NUMBER,
250 X_Return_Status OUT NOCOPY VARCHAR2,
251 X_Msg_Count OUT NOCOPY NUMBER,
252 X_Msg_Data OUT NOCOPY VARCHAR2
253 );
254
255 -- Start of Comments
256 --
257 -- Item level validation procedures
258 --
259 -- ryellapu to validate the end date for a process rule to be greater than start date
260 --
261 -- End of Comments
262
263 PROCEDURE Validate_enddate(
264 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265 P_Validation_mode IN VARCHAR2,
266 P_START_DATE IN DATE,
267 P_END_DATE IN DATE,
268 X_Return_Status OUT NOCOPY VARCHAR2,
269 X_Msg_Count OUT NOCOPY NUMBER,
270 X_Msg_Data OUT NOCOPY VARCHAR2
271 );
272
273 PROCEDURE Validate_startdate(
274 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275 P_Validation_mode IN VARCHAR2,
276 P_Parent_Rule_ID IN NUMBER,
277 P_START_DATE IN DATE,
278 X_Return_Status OUT NOCOPY VARCHAR2,
279 X_Msg_Count OUT NOCOPY NUMBER,
280 X_Msg_Data OUT NOCOPY VARCHAR2
281 );
282
283 PROCEDURE Validate_status(
284 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285 P_Validation_mode IN VARCHAR2,
286 P_Parent_Rule_ID IN NUMBER,
287 P_STATUS IN VARCHAR2,
288 X_Return_Status OUT NOCOPY VARCHAR2,
289 X_Msg_Count OUT NOCOPY NUMBER,
290 X_Msg_Data OUT NOCOPY VARCHAR2
291 );
292
293
294 -- Start of Comments
295 --
296 -- Item level validation procedures
297 --
298 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
299 -- For create: G_CREATE, for update: G_UPDATE
300 -- Note: 1. This is automated generated item level validation procedure.
301 -- The actual validation detail is needed to be added.
302 --
303 -- End of Comments
304
305 PROCEDURE Validate_process_rule(
306 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308 P_Validation_mode IN VARCHAR2,
309 P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
310 X_Return_Status OUT NOCOPY VARCHAR2,
311 X_Msg_Count OUT NOCOPY NUMBER,
312 X_Msg_Data OUT NOCOPY VARCHAR2
313 );
314
315
316 End PV_PROCESS_RULE_PVT;