82: -- Parameters
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_pec_rules_rec IN pec_rules_rec_type Required
90: --
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_pec_rules_rec IN pec_rules_rec_type Required
90: --
91: -- OUT
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_pec_rules_rec IN pec_rules_rec_type Required
90: --
91: -- OUT
92: -- x_return_status OUT VARCHAR2
104: -- ==============================================================================
105:
106: PROCEDURE Create_Pec_Rules(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
105:
106: PROCEDURE Create_Pec_Rules(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
106: PROCEDURE Create_Pec_Rules(
107: p_api_version_number IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
129: -- Parameters
130: --
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_pec_rules_rec IN pec_rules_rec_type Required
137: --
130: --
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_pec_rules_rec IN pec_rules_rec_type Required
137: --
138: -- OUT
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_pec_rules_rec IN pec_rules_rec_type Required
137: --
138: -- OUT
139: -- x_return_status OUT VARCHAR2
151: -- ==============================================================================
152:
153: PROCEDURE Update_Pec_Rules(
154: p_api_version_number IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158:
159: x_return_status OUT NOCOPY VARCHAR2,
152:
153: PROCEDURE Update_Pec_Rules(
154: p_api_version_number IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158:
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
153: PROCEDURE Update_Pec_Rules(
154: p_api_version_number IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158:
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
176: -- Parameters
177: --
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_enrl_change_rule_id IN NUMBER
184: -- p_object_version_number IN NUMBER Optional Default = NULL
177: --
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_enrl_change_rule_id IN NUMBER
184: -- p_object_version_number IN NUMBER Optional Default = NULL
185: --
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_enrl_change_rule_id IN NUMBER
184: -- p_object_version_number IN NUMBER Optional Default = NULL
185: --
186: -- OUT
199: -- ==============================================================================
200:
201: PROCEDURE Delete_Pec_Rules(
202: p_api_version_number IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
200:
201: PROCEDURE Delete_Pec_Rules(
202: p_api_version_number IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
201: PROCEDURE Delete_Pec_Rules(
202: p_api_version_number IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_enrl_change_rule_id IN NUMBER,
222: -- Parameters
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_pec_rules_rec IN pec_rules_rec_type Required
230: --
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_pec_rules_rec IN pec_rules_rec_type Required
230: --
231: -- OUT
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_pec_rules_rec IN pec_rules_rec_type Required
230: --
231: -- OUT
232: -- x_return_status OUT VARCHAR2
244: -- ==============================================================================
245:
246: PROCEDURE Lock_Pec_Rules(
247: p_api_version_number IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249:
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
278:
279:
280: PROCEDURE Validate_Pec_Rules(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: p_pec_rules_rec IN pec_rules_rec_type,
285: p_validation_mode IN VARCHAR2,
286: x_return_status OUT NOCOPY VARCHAR2,
279:
280: PROCEDURE Validate_Pec_Rules(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: p_pec_rules_rec IN pec_rules_rec_type,
285: p_validation_mode IN VARCHAR2,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
337:
338:
339: PROCEDURE Validate_Pec_Rules_Rec (
340: p_api_version_number IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2,
345: p_pec_rules_rec IN pec_rules_rec_type