79: creation_date DATE,
80: last_updated_by NUMBER,
81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:
80: last_updated_by NUMBER,
81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:
88: );
81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:
88: );
89:
103: -- Parameters
104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --
104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --
112: -- OUT
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --
112: -- OUT
113: -- x_return_status OUT VARCHAR2
125: -- ==============================================================================
126:
127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
126:
127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required
159: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required
159: --
160: -- OUT
173: -- ==============================================================================
174: PROCEDURE Copy_Row
175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
174: PROCEDURE Copy_Row
175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
183: ,p_src_object_id IN NUMBER
196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --
205: -- OUT
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --
205: -- OUT
206: -- x_return_status OUT VARCHAR2
218: -- ==============================================================================
219:
220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
219:
220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
242: -- Parameters
243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL
243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL
251: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL
251: --
252: -- OUT
265: -- ==============================================================================
266:
267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
266:
267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_notif_rule_id IN NUMBER,
288: -- Parameters
289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --
289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --
297: -- OUT
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --
297: -- OUT
298: -- x_return_status OUT VARCHAR2
310: -- ==============================================================================
311:
312: PROCEDURE Lock_Ge_Notif_Rules(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315:
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
344:
345:
346: PROCEDURE Validate_Ge_Notif_Rules(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_ge_notif_rules_rec IN ge_notif_rules_rec_type,
351: p_validation_mode IN VARCHAR2,
352: x_return_status OUT NOCOPY VARCHAR2,
345:
346: PROCEDURE Validate_Ge_Notif_Rules(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_ge_notif_rules_rec IN ge_notif_rules_rec_type,
351: p_validation_mode IN VARCHAR2,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
403:
404:
405: PROCEDURE Validate_Ge_Notif_Rules_Rec (
406: p_api_version_number IN NUMBER,
407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2,
411: p_ge_notif_rules_rec IN ge_notif_rules_rec_type
412: );
413:
414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,
413:
414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,
414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,
422: x_msg_data OUT NOCOPY VARCHAR2,