59: created_by NUMBER,
60: last_update_date DATE,
61: last_updated_by NUMBER,
62: last_update_login NUMBER,
63: name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
64: description VARCHAR2(4000):= FND_API.G_MISS_CHAR
65: );
66:
67: g_miss_na_ddn_rule_rec na_ddn_rule_rec_type := NULL;
60: last_update_date DATE,
61: last_updated_by NUMBER,
62: last_update_login NUMBER,
63: name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
64: description VARCHAR2(4000):= FND_API.G_MISS_CHAR
65: );
66:
67: g_miss_na_ddn_rule_rec na_ddn_rule_rec_type := NULL;
68: TYPE na_ddn_rule_tbl_type IS TABLE OF na_ddn_rule_rec_type INDEX BY BINARY_INTEGER;
80: -- Parameters
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
88: --
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
88: --
89: -- OUT
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
88: --
89: -- OUT
90: -- x_return_status OUT VARCHAR2
102: -- ==============================================================================
103:
104: PROCEDURE Create_Na_Ddn_Rule(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
103:
104: PROCEDURE Create_Na_Ddn_Rule(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
104: PROCEDURE Create_Na_Ddn_Rule(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
127: -- Parameters
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
135: --
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
135: --
136: -- OUT
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
135: --
136: -- OUT
137: -- x_return_status OUT VARCHAR2
149: -- ==============================================================================
150:
151: PROCEDURE Update_Na_Ddn_Rule(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
150:
151: PROCEDURE Update_Na_Ddn_Rule(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
151: PROCEDURE Update_Na_Ddn_Rule(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
173: -- Parameters
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_na_deduction_rule_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_na_deduction_rule_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_na_deduction_rule_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
183: -- OUT
196: -- ==============================================================================
197:
198: PROCEDURE Delete_Na_Ddn_Rule(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
197:
198: PROCEDURE Delete_Na_Ddn_Rule(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
198: PROCEDURE Delete_Na_Ddn_Rule(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_na_deduction_rule_id IN NUMBER,
219: -- Parameters
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
227: --
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
227: --
228: -- OUT
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_na_ddn_rule_rec IN na_ddn_rule_rec_type Required
227: --
228: -- OUT
229: -- x_return_status OUT VARCHAR2
241: -- ==============================================================================
242:
243: PROCEDURE Lock_Na_Ddn_Rule(
244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246:
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
275:
276:
277: PROCEDURE Validate_Na_Ddn_Rule(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_na_ddn_rule_rec IN na_ddn_rule_rec_type,
282: p_validation_mode IN VARCHAR2,
283: x_return_status OUT NOCOPY VARCHAR2,
276:
277: PROCEDURE Validate_Na_Ddn_Rule(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_na_ddn_rule_rec IN na_ddn_rule_rec_type,
282: p_validation_mode IN VARCHAR2,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
334:
335:
336: PROCEDURE Validate_Na_Ddn_Rule_Rec (
337: p_api_version_number IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_na_ddn_rule_rec IN na_ddn_rule_rec_type