202: -- Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional
204: -- Default = FND_API.G_VALID_LEVEL_FULL
205: -- : p_rule_name IN cn_rules.name%TYPE,
206: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
207: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
208: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
209: --
210: -- OUT : x_return_status OUT VARCHAR2(1)
203: -- p_validation_level IN NUMBER Optional
204: -- Default = FND_API.G_VALID_LEVEL_FULL
205: -- : p_rule_name IN cn_rules.name%TYPE,
206: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
207: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
208: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
209: --
210: -- OUT : x_return_status OUT VARCHAR2(1)
211: -- x_msg_count OUT NUMBER
204: -- Default = FND_API.G_VALID_LEVEL_FULL
205: -- : p_rule_name IN cn_rules.name%TYPE,
206: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
207: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
208: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
209: --
210: -- OUT : x_return_status OUT VARCHAR2(1)
211: -- x_msg_count OUT NUMBER
212: -- x_msg_data OUT VARCHAR2(2000)
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: x_loading_status OUT NOCOPY VARCHAR2,
233: p_rule_name IN cn_rules.name%TYPE,
234: p_ruleset_name IN cn_rulesets.name%TYPE,
235: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
236: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
237: );
238:
231: x_msg_data OUT NOCOPY VARCHAR2,
232: x_loading_status OUT NOCOPY VARCHAR2,
233: p_rule_name IN cn_rules.name%TYPE,
234: p_ruleset_name IN cn_rulesets.name%TYPE,
235: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
236: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
237: );
238:
239:
232: x_loading_status OUT NOCOPY VARCHAR2,
233: p_rule_name IN cn_rules.name%TYPE,
234: p_ruleset_name IN cn_rulesets.name%TYPE,
235: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
236: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
237: );
238:
239:
240: -------------------------------------------------------------------------------------+
254: -- Default = FND_API.G_FALSE
255: -- p_validation_level IN NUMBER Optional
256: -- Default = FND_API.G_VALID_LEVEL_FULL
257: -- : p_rule_name IN cn_rules.name%TYPE,
258: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
259: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
260: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
261: --
262: -- OUT : x_return_status OUT VARCHAR2(1)
255: -- p_validation_level IN NUMBER Optional
256: -- Default = FND_API.G_VALID_LEVEL_FULL
257: -- : p_rule_name IN cn_rules.name%TYPE,
258: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
259: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
260: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
261: --
262: -- OUT : x_return_status OUT VARCHAR2(1)
263: -- x_msg_count OUT NUMBER
256: -- Default = FND_API.G_VALID_LEVEL_FULL
257: -- : p_rule_name IN cn_rules.name%TYPE,
258: -- : p_ruleset_name IN cn_rulesets.name%TYPE,
259: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
260: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
261: --
262: -- OUT : x_return_status OUT VARCHAR2(1)
263: -- x_msg_count OUT NUMBER
264: -- x_msg_data OUT VARCHAR2(2000)
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: x_loading_status OUT NOCOPY VARCHAR2,
285: p_rule_name IN cn_rules.name%TYPE,
286: p_ruleset_name IN cn_rulesets.name%TYPE,
287: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
288: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
289: );
290:
283: x_msg_data OUT NOCOPY VARCHAR2,
284: x_loading_status OUT NOCOPY VARCHAR2,
285: p_rule_name IN cn_rules.name%TYPE,
286: p_ruleset_name IN cn_rulesets.name%TYPE,
287: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
288: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
289: );
290:
291: --------------------------------------------------------------------------------------+
284: x_loading_status OUT NOCOPY VARCHAR2,
285: p_rule_name IN cn_rules.name%TYPE,
286: p_ruleset_name IN cn_rulesets.name%TYPE,
287: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
288: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
289: );
290:
291: --------------------------------------------------------------------------------------+
292: -- Start of comments