56: ,p_valid_second_lac_flag => p_valid_second_lac_flag
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_noac_las'
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_noac_las'
64: ,p_hook_type => 'BP'
65: );
99: ,p_valid_second_lac_flag => p_valid_second_lac_flag
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_noac_las'
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_noac_las'
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: --
156: --
157: procedure update_noac_las
158: (p_validate in boolean default false
159: ,p_noac_la_id in number
160: ,p_nature_of_action_id in number default hr_api.g_number
161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
157: procedure update_noac_las
158: (p_validate in boolean default false
159: ,p_noac_la_id in number
160: ,p_nature_of_action_id in number default hr_api.g_number
161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
158: (p_validate in boolean default false
159: ,p_noac_la_id in number
160: ,p_nature_of_action_id in number default hr_api.g_number
161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
166: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
159: ,p_noac_la_id in number
160: ,p_nature_of_action_id in number default hr_api.g_number
161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
166: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
167: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
160: ,p_nature_of_action_id in number default hr_api.g_number
161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
166: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
167: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
168: ,p_effective_date in date
162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
166: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
167: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
168: ,p_effective_date in date
169: ) is
170: --
163: ,p_date_from in date default hr_api.g_date
164: ,p_date_to in date default hr_api.g_date
165: ,p_object_version_number in out number
166: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
167: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
168: ,p_effective_date in date
169: ) is
170: --
171: -- Declare cursors and local variables
204: ,p_valid_second_lac_flag => p_valid_second_lac_flag
205: ,p_effective_date => trunc(p_effective_date)
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'UPDATE_noac_las'
211: ,p_hook_type => 'BP'
212: );
205: ,p_effective_date => trunc(p_effective_date)
206: );
207: exception
208: when hr_api.cannot_find_prog_unit then
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'UPDATE_noac_las'
211: ,p_hook_type => 'BP'
212: );
213: --
246: ,p_valid_second_lac_flag => p_valid_second_lac_flag
247: ,p_effective_date => trunc(p_effective_date)
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'UPDATE_noac_las'
253: ,p_hook_type => 'AP'
254: );
247: ,p_effective_date => trunc(p_effective_date)
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'UPDATE_noac_las'
253: ,p_hook_type => 'AP'
254: );
255: --
261: --
262: -- When in validation only mode raise the Validate_Enabled exception
263: --
264: if p_validate then
265: raise hr_api.validate_enabled;
266: end if;
267: --
268: -- Set all output arguments
269: --
272: hr_utility.set_location(' Leaving:'||l_proc, 70);
273: --
274: exception
275: --
276: when hr_api.validate_enabled then
277: --
278: -- As the Validate_Enabled exception has been raised
279: -- we must rollback to the savepoint
280: --
335: ,p_object_version_number => p_object_version_number
336: ,p_effective_date => trunc(p_effective_date)
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'DELETE_noac_las'
342: ,p_hook_type => 'BP'
343: );
336: ,p_effective_date => trunc(p_effective_date)
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'DELETE_noac_las'
342: ,p_hook_type => 'BP'
343: );
344: --
363: ,p_object_version_number => l_object_version_number
364: ,p_effective_date => trunc(p_effective_date)
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'DELETE_noac_las'
370: ,p_hook_type => 'AP'
371: );
364: ,p_effective_date => trunc(p_effective_date)
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'DELETE_noac_las'
370: ,p_hook_type => 'AP'
371: );
372: --
378: --
379: -- When in validation only mode raise the Validate_Enabled exception
380: --
381: if p_validate then
382: raise hr_api.validate_enabled;
383: end if;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 70);
386: --
385: hr_utility.set_location(' Leaving:'||l_proc, 70);
386: --
387: exception
388: --
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- we must rollback to the savepoint
393: --