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_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type;
35: -- End of comments
36: --------------------------------------------------------------------------------------+
37: PROCEDURE create_ruleset_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_ruleset_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_ruleset_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_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type;
80: -- End of comments
81: --------------------------------------------------------------------------------------+
82: PROCEDURE create_ruleset_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_ruleset_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_ruleset_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,
103: --
104: -- Parameters :
105: -- IN : p_api_version IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- IN : p_api_version IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
112: -- OUT : x_return_status OUT VARCHAR2(1)
113: -- x_msg_count OUT NUMBER
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
112: -- OUT : x_return_status OUT VARCHAR2(1)
113: -- x_msg_count OUT NUMBER
114: -- x_msg_data OUT VARCHAR2(2000)
115: -- IN OUT : p_old_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
127: -- End of comments
128: --------------------------------------------------------------------------------------+
129: PROCEDURE update_ruleset_pre
130: ( p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
128: --------------------------------------------------------------------------------------+
129: PROCEDURE update_ruleset_pre
130: ( p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
129: PROCEDURE update_ruleset_pre
130: ( p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: x_loading_status OUT NOCOPY VARCHAR2,
151: --
152: -- Parameters :
153: -- IN : p_api_version IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional
155: -- Default = FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default = FND_API.G_VALID_LEVEL_FULL
153: -- IN : p_api_version IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional
155: -- Default = FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default = FND_API.G_VALID_LEVEL_FULL
160: -- OUT : x_return_status OUT VARCHAR2(1)
161: -- x_msg_count OUT NUMBER
155: -- Default = FND_API.G_FALSE
156: -- p_commit IN VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional
159: -- Default = FND_API.G_VALID_LEVEL_FULL
160: -- OUT : x_return_status OUT VARCHAR2(1)
161: -- x_msg_count OUT NUMBER
162: -- x_msg_data OUT VARCHAR2(2000)
163: -- IN OUT : p_old_ruleset_id IN CN_Ruleset_PUB.ruleset_rec_type
175: -- End of comments
176: --------------------------------------------------------------------------------------+
177: PROCEDURE update_ruleset_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_ruleset_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_ruleset_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,