DBA Data[Home] [Help]

APPS.CN_RULE_PUB_VUHK dependencies on CN_RULES

Line 2: -- $Header: cnirules.pls 120.1 2005/06/20 20:03:11 appldev ship $

1: PACKAGE CN_RULE_PUB_VUHK AUTHID CURRENT_USER as
2: -- $Header: cnirules.pls 120.1 2005/06/20 20:03:11 appldev ship $
3:
4: -------------------------------------------------------------------------------------+
5: -- Start of comments
6: -- API name : create_rule_pre

Line 205: -- : p_rule_name IN cn_rules.name%TYPE,

201: -- p_commit IN VARCHAR2 Optional
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: --

Line 206: -- : p_ruleset_name IN cn_rulesets.name%TYPE,

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)

Line 207: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

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

Line 208: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE

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)

Line 233: p_rule_name IN cn_rules.name%TYPE,

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,
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: );

Line 234: p_ruleset_name IN cn_rulesets.name%TYPE,

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:

Line 235: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

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:

Line 236: p_ruleset_end_date IN cn_rulesets.end_date%TYPE

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: -------------------------------------------------------------------------------------+

Line 257: -- : p_rule_name IN cn_rules.name%TYPE,

253: -- p_commit IN VARCHAR2 Optional
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: --

Line 258: -- : p_ruleset_name IN cn_rulesets.name%TYPE,

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)

Line 259: -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

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

Line 260: -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE

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)

Line 285: p_rule_name IN cn_rules.name%TYPE,

281: x_return_status OUT NOCOPY VARCHAR2,
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: );

Line 286: p_ruleset_name IN cn_rulesets.name%TYPE,

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:

Line 287: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

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: --------------------------------------------------------------------------------------+

Line 288: p_ruleset_end_date IN cn_rulesets.end_date%TYPE

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