42: -- Pre-reqs : None.
43: -- Parameters :
44: -- IN : p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
44: -- IN : p_api_version IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
51: -- p_rule_rec_type IN
52: -- CN_Rule_PVT.rule_rec_type
46: -- Default = FND_API.G_FALSE
47: -- p_commit IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_validation_level IN NUMBER Optional
50: -- Default = FND_API.G_VALID_LEVEL_FULL
51: -- p_rule_rec_type IN
52: -- CN_Rule_PVT.rule_rec_type
53: --
54: -- OUT : x_return_status OUT VARCHAR2(1)
67: -- End of comments
68: --=============================================================================
69: PROCEDURE Create_Rule
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
68: --=============================================================================
69: PROCEDURE Create_Rule
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
69: PROCEDURE Create_Rule
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: x_loading_status OUT NOCOPY VARCHAR2,
86: -- Pre-reqs : None.
87: -- Parameters :
88: -- IN : p_api_version IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- IN : p_api_version IN NUMBER Required
89: -- p_init_msg_list IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_rule_rec_type IN
96: -- CN_Rule_PVT.rule_rec_type
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_rule_rec_type IN
96: -- CN_Rule_PVT.rule_rec_type
97: --
98: -- OUT : x_return_status OUT VARCHAR2(1)
112: --=============================================================================
113:
114: PROCEDURE Update_Rule
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
113:
114: PROCEDURE Update_Rule
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
114: PROCEDURE Update_Rule
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: x_loading_status OUT NOCOPY VARCHAR2,
132: -- Pre-reqs : None.
133: -- Parameters :
134: -- IN : p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional
136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL
134: -- IN : p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional
136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_rule_rec_type IN
142: -- CN_Rule_PVT.rule_rec_type
136: -- Default = FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional
140: -- Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_rule_rec_type IN
142: -- CN_Rule_PVT.rule_rec_type
143: -- OUT : x_return_status OUT VARCHAR2(1)
144: -- x_msg_count OUT NUMBER
156: -- End of comments
157: --=============================================================================
158: PROCEDURE Delete_Rule
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
157: --=============================================================================
158: PROCEDURE Delete_Rule
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
158: PROCEDURE Delete_Rule
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
179: -- Desc : Procedure to get Rules
180: -- Parameters :
181: -- IN : p_api_version IN NUMBER Require
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
181: -- IN : p_api_version IN NUMBER Require
182: -- p_init_msg_list IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- OUT : x_return_status OUT VARCHAR2(1)
189: -- x_msg_count OUT NUMBER
183: -- Default = FND_API.G_FALSE
184: -- p_commit IN VARCHAR2 Optional
185: -- Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional
187: -- Default = FND_API.G_VALID_LEVEL_FULL
188: -- OUT : x_return_status OUT VARCHAR2(1)
189: -- x_msg_count OUT NUMBER
190: -- x_msg_data OUT VARCHAR2(2000)
191: -- IN : p_ruleset_name, p_ruleset_name