12: --
13: -- Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : x_return_status OUT VARCHAR2(1)
22: -- x_msg_count OUT NUMBER
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : x_return_status OUT VARCHAR2(1)
22: -- x_msg_count OUT NUMBER
23: -- x_msg_data OUT VARCHAR2(2000)
24: -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
35: -- End of comments
36: --------------------------------------------------------------------------------------+
37: PROCEDURE create_ruleattribute_pre
38: ( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
36: --------------------------------------------------------------------------------------+
37: PROCEDURE create_ruleattribute_pre
38: ( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
37: PROCEDURE create_ruleattribute_pre
38: ( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: x_loading_status OUT NOCOPY VARCHAR2,
57: --
58: -- Parameters :
59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- OUT : x_return_status OUT VARCHAR2(1)
67: -- x_msg_count OUT NUMBER
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- OUT : x_return_status OUT VARCHAR2(1)
67: -- x_msg_count OUT NUMBER
68: -- x_msg_data OUT VARCHAR2(2000)
69: -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
80: -- End of comments
81: --------------------------------------------------------------------------------------+
82: PROCEDURE create_ruleattribute_post
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
81: --------------------------------------------------------------------------------------+
82: PROCEDURE create_ruleattribute_post
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
82: PROCEDURE create_ruleattribute_post
83: ( p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: x_loading_status OUT NOCOPY VARCHAR2,
102: --
103: -- Parameters :
104: -- IN : p_api_version IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- IN : p_api_version IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
111: -- OUT : x_return_status OUT VARCHAR2(1)
112: -- x_msg_count OUT NUMBER
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
111: -- OUT : x_return_status OUT VARCHAR2(1)
112: -- x_msg_count OUT NUMBER
113: -- x_msg_data OUT VARCHAR2(2000)
114: -- IN : p_old_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
126: -- End of comments
127: --------------------------------------------------------------------------------------+
128: PROCEDURE update_ruleattribute_pre
129: ( p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
127: --------------------------------------------------------------------------------------+
128: PROCEDURE update_ruleattribute_pre
129: ( p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
128: PROCEDURE update_ruleattribute_pre
129: ( p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: x_loading_status OUT NOCOPY VARCHAR2,
150: --
151: -- Parameters :
152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- OUT : x_return_status OUT VARCHAR2(1)
160: -- x_msg_count OUT NUMBER
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- OUT : x_return_status OUT VARCHAR2(1)
160: -- x_msg_count OUT NUMBER
161: -- x_msg_data OUT VARCHAR2(2000)
162: -- IN : p_old_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
175: --------------------------------------------------------------------------------------+
176:
177: PROCEDURE update_ruleattribute_post
178: ( p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
176:
177: PROCEDURE update_ruleattribute_post
178: ( p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
177: PROCEDURE update_ruleattribute_post
178: ( p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: x_loading_status OUT NOCOPY VARCHAR2,
199: --
200: -- Parameters :
201: -- IN : p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL
201: -- IN : p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL
208: -- OUT : x_return_status OUT VARCHAR2(1)
209: -- x_msg_count OUT NUMBER
203: -- Default = FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Optional
205: -- Default = FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Optional
207: -- Default = FND_API.G_VALID_LEVEL_FULL
208: -- OUT : x_return_status OUT VARCHAR2(1)
209: -- x_msg_count OUT NUMBER
210: -- x_msg_data OUT VARCHAR2(2000)
211: -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
222: -- End of comments
223: --------------------------------------------------------------------------------------+
224: PROCEDURE delete_ruleattribute_pre
225: ( p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
223: --------------------------------------------------------------------------------------+
224: PROCEDURE delete_ruleattribute_pre
225: ( p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
224: PROCEDURE delete_ruleattribute_pre
225: ( p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: x_loading_status OUT NOCOPY VARCHAR2,
245: --
246: -- Parameters :
247: -- IN : p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Optional
249: -- Default = FND_API.G_FALSE
250: -- p_commit IN VARCHAR2 Optional
251: -- Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional
253: -- Default = FND_API.G_VALID_LEVEL_FULL
247: -- IN : p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Optional
249: -- Default = FND_API.G_FALSE
250: -- p_commit IN VARCHAR2 Optional
251: -- Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional
253: -- Default = FND_API.G_VALID_LEVEL_FULL
254: -- OUT : x_return_status OUT VARCHAR2(1)
255: -- x_msg_count OUT NUMBER
249: -- Default = FND_API.G_FALSE
250: -- p_commit IN VARCHAR2 Optional
251: -- Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional
253: -- Default = FND_API.G_VALID_LEVEL_FULL
254: -- OUT : x_return_status OUT VARCHAR2(1)
255: -- x_msg_count OUT NUMBER
256: -- x_msg_data OUT VARCHAR2(2000)
257: -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
268: -- End of comments
269: --------------------------------------------------------------------------------------+
270: PROCEDURE delete_ruleattribute_post
271: ( p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
269: --------------------------------------------------------------------------------------+
270: PROCEDURE delete_ruleattribute_post
271: ( p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
270: PROCEDURE delete_ruleattribute_post
271: ( p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: x_loading_status OUT NOCOPY VARCHAR2,