57: ,p_valid_second_lac_flag => p_valid_second_lac_flag
58: ,p_effective_date => trunc(p_effective_date)
59: );
60: exception
61: when hr_api.cannot_find_prog_unit then
62: hr_api.cannot_find_prog_unit_error
63: (
64: p_module_name => 'CREATE_noac_las'
65: ,p_hook_type => 'BP'
58: ,p_effective_date => trunc(p_effective_date)
59: );
60: exception
61: when hr_api.cannot_find_prog_unit then
62: hr_api.cannot_find_prog_unit_error
63: (
64: p_module_name => 'CREATE_noac_las'
65: ,p_hook_type => 'BP'
66: );
100: ,p_valid_second_lac_flag => p_valid_second_lac_flag
101: ,p_effective_date => trunc(p_effective_date)
102: );
103: exception
104: when hr_api.cannot_find_prog_unit then
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'CREATE_noac_las'
107: ,p_hook_type => 'AP'
108: );
101: ,p_effective_date => trunc(p_effective_date)
102: );
103: exception
104: when hr_api.cannot_find_prog_unit then
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'CREATE_noac_las'
107: ,p_hook_type => 'AP'
108: );
109: --
115: --
116: -- When in validation only mode raise the Validate_Enabled exception
117: --
118: if p_validate then
119: raise hr_api.validate_enabled;
120: end if;
121: --
122: -- Set all output arguments
123: --
127: hr_utility.set_location(' Leaving:'||l_proc, 70);
128: --
129: exception
130: --
131: when hr_api.validate_enabled then
132: --
133: -- As the Validate_Enabled exception has been raised
134: -- we must rollback to the savepoint
135: --
159: --
160: procedure update_noac_las
161: (p_validate in boolean default false
162: ,p_noac_la_id in number
163: ,p_nature_of_action_id in number default hr_api.g_number
164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
160: procedure update_noac_las
161: (p_validate in boolean default false
162: ,p_noac_la_id in number
163: ,p_nature_of_action_id in number default hr_api.g_number
164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
161: (p_validate in boolean default false
162: ,p_noac_la_id in number
163: ,p_nature_of_action_id in number default hr_api.g_number
164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
169: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
162: ,p_noac_la_id in number
163: ,p_nature_of_action_id in number default hr_api.g_number
164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
169: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
170: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
163: ,p_nature_of_action_id in number default hr_api.g_number
164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
169: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
170: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
171: ,p_effective_date in date
165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
169: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
170: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
171: ,p_effective_date in date
172: ) is
173: --
166: ,p_date_from in date default hr_api.g_date
167: ,p_date_to in date default hr_api.g_date
168: ,p_object_version_number in out NOCOPY number
169: ,p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2
170: ,p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
171: ,p_effective_date in date
172: ) is
173: --
174: -- Declare cursors and local variables
212: ,p_valid_second_lac_flag => p_valid_second_lac_flag
213: ,p_effective_date => trunc(p_effective_date)
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_noac_las'
220: ,p_hook_type => 'BP'
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_noac_las'
220: ,p_hook_type => 'BP'
221: );
222: --
255: ,p_valid_second_lac_flag => p_valid_second_lac_flag
256: ,p_effective_date => trunc(p_effective_date)
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: p_object_version_number := l_obj_version_number;
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'UPDATE_noac_las'
263: ,p_hook_type => 'AP'
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: p_object_version_number := l_obj_version_number;
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'UPDATE_noac_las'
263: ,p_hook_type => 'AP'
264: );
265: --
271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: -- Set all output arguments
279: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: --
284: exception
285: --
286: when hr_api.validate_enabled then
287: --
288: -- As the Validate_Enabled exception has been raised
289: -- we must rollback to the savepoint
290: --
350: ,p_object_version_number => p_object_version_number
351: ,p_effective_date => trunc(p_effective_date)
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: p_object_version_number := l_obj_version_number;
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'DELETE_noac_las'
358: ,p_hook_type => 'BP'
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: p_object_version_number := l_obj_version_number;
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'DELETE_noac_las'
358: ,p_hook_type => 'BP'
359: );
360: --
379: ,p_object_version_number => l_object_version_number
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: p_object_version_number := l_obj_version_number;
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'DELETE_noac_las'
387: ,p_hook_type => 'AP'
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: p_object_version_number := l_obj_version_number;
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'DELETE_noac_las'
387: ,p_hook_type => 'AP'
388: );
389: --
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 70);
403: --
402: hr_utility.set_location(' Leaving:'||l_proc, 70);
403: --
404: exception
405: --
406: when hr_api.validate_enabled then
407: --
408: -- As the Validate_Enabled exception has been raised
409: -- we must rollback to the savepoint
410: --