DBA Data[Home] [Help]

APPS.GHR_NOAC_LAS_API dependencies on HR_API

Line 61: when hr_api.cannot_find_prog_unit then

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'

Line 62: hr_api.cannot_find_prog_unit_error

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: );

Line 104: when hr_api.cannot_find_prog_unit then

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: );

Line 105: hr_api.cannot_find_prog_unit_error

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: --

Line 119: raise hr_api.validate_enabled;

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: --

Line 131: when hr_api.validate_enabled then

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: --

Line 163: ,p_nature_of_action_id in number default hr_api.g_number

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

Line 164: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2

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

Line 165: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

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

Line 166: ,p_date_from in date default hr_api.g_date

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

Line 167: ,p_date_to in date default hr_api.g_date

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

Line 169: ,p_valid_first_lac_flag 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
172: ) is
173: --

Line 170: ,p_valid_second_lac_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: --
174: -- Declare cursors and local variables

Line 216: when hr_api.cannot_find_prog_unit then

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'

Line 218: hr_api.cannot_find_prog_unit_error

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: --

Line 259: when hr_api.cannot_find_prog_unit then

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'

Line 261: hr_api.cannot_find_prog_unit_error

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: --

Line 275: raise hr_api.validate_enabled;

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: --

Line 286: when hr_api.validate_enabled then

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: --

Line 354: when hr_api.cannot_find_prog_unit then

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'

Line 356: hr_api.cannot_find_prog_unit_error

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: --

Line 383: when hr_api.cannot_find_prog_unit then

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'

Line 385: hr_api.cannot_find_prog_unit_error

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: --

Line 399: raise hr_api.validate_enabled;

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: --

Line 406: when hr_api.validate_enabled then

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: --