19: -- Pre-reqs : None.
20: -- Parameters :
21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- p_rule_rec_type IN
29: -- CN_Rule_PUB.rule_rec_type
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- p_rule_rec_type IN
29: -- CN_Rule_PUB.rule_rec_type
30: --
31: -- OUT : x_return_status OUT VARCHAR2(1)
44: -- End of comments
45:
46: PROCEDURE Create_Rule
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
45:
46: PROCEDURE Create_Rule
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
46: PROCEDURE Create_Rule
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: x_loading_status OUT NOCOPY VARCHAR2,
62: -- Pre-reqs : None.
63: -- Parameters :
64: -- IN : p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
64: -- IN : p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_rule_rec_type IN
72: -- CN_Rule_PUB.rule_rec_type
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_rule_rec_type IN
72: -- CN_Rule_PUB.rule_rec_type
73: --
74: -- OUT : x_return_status OUT VARCHAR2(1)
88:
89:
90: PROCEDURE Update_Rule
91: ( p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
89:
90: PROCEDURE Update_Rule
91: ( p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
90: PROCEDURE Update_Rule
91: ( p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: x_loading_status OUT NOCOPY VARCHAR2,
108: -- Pre-reqs : None.
109: -- Parameters :
110: -- IN : p_api_version IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
110: -- IN : p_api_version IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_rule_rec_type IN
118: -- CN_Rule_PUB.rule_rec_type
112: -- Default = FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_rule_rec_type IN
118: -- CN_Rule_PUB.rule_rec_type
119: -- OUT : x_return_status OUT VARCHAR2(1)
120: -- x_msg_count OUT NUMBER
132: -- End of comments
133:
134: PROCEDURE Delete_Rule
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
133:
134: PROCEDURE Delete_Rule
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
134: PROCEDURE Delete_Rule
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: x_loading_status OUT NOCOPY VARCHAR2,