56: ,p_status => p_status
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_FYI_NOTIFY'
64: ,p_hook_type => 'BP'
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_FYI_NOTIFY'
64: ,p_hook_type => 'BP'
65: );
99: ,p_object_version_number => l_object_version_number
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_FYI_NOTIFY'
106: ,p_hook_type => 'AP'
107: );
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_FYI_NOTIFY'
106: ,p_hook_type => 'AP'
107: );
108: --
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
158: --
159: procedure update_fyi_notify
160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
159: procedure update_fyi_notify
160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
160: (p_validate in boolean default false
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
161: ,p_fyi_notified_id in number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
162: ,p_transaction_category_id in number default hr_api.g_number
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date
163: ,p_transaction_id in number default hr_api.g_number
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date
171: ) is
164: ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
165: ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
166: ,p_notified_name in varchar2 default hr_api.g_varchar2
167: ,p_notification_date in date default hr_api.g_date
168: ,p_status in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_effective_date in date
171: ) is
172: --
206: ,p_object_version_number => p_object_version_number
207: ,p_effective_date => trunc(p_effective_date)
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'UPDATE_FYI_NOTIFY'
213: ,p_hook_type => 'BP'
214: );
207: ,p_effective_date => trunc(p_effective_date)
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'UPDATE_FYI_NOTIFY'
213: ,p_hook_type => 'BP'
214: );
215: --
248: ,p_object_version_number => l_object_version_number
249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_FYI_NOTIFY'
255: ,p_hook_type => 'AP'
256: );
249: ,p_effective_date => trunc(p_effective_date)
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'UPDATE_FYI_NOTIFY'
255: ,p_hook_type => 'AP'
256: );
257: --
263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then
267: raise hr_api.validate_enabled;
268: end if;
269: --
270: -- Set all output arguments
271: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --
338: ,p_object_version_number => p_object_version_number
339: ,p_effective_date => trunc(p_effective_date)
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'DELETE_FYI_NOTIFY'
345: ,p_hook_type => 'BP'
346: );
339: ,p_effective_date => trunc(p_effective_date)
340: );
341: exception
342: when hr_api.cannot_find_prog_unit then
343: hr_api.cannot_find_prog_unit_error
344: (p_module_name => 'DELETE_FYI_NOTIFY'
345: ,p_hook_type => 'BP'
346: );
347: --
366: ,p_object_version_number => l_object_version_number
367: ,p_effective_date => trunc(p_effective_date)
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'DELETE_FYI_NOTIFY'
373: ,p_hook_type => 'AP'
374: );
367: ,p_effective_date => trunc(p_effective_date)
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'DELETE_FYI_NOTIFY'
373: ,p_hook_type => 'AP'
374: );
375: --
381: --
382: -- When in validation only mode raise the Validate_Enabled exception
383: --
384: if p_validate then
385: raise hr_api.validate_enabled;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 70);
389: --
388: hr_utility.set_location(' Leaving:'||l_proc, 70);
389: --
390: exception
391: --
392: when hr_api.validate_enabled then
393: --
394: -- As the Validate_Enabled exception has been raised
395: -- we must rollback to the savepoint
396: --