DBA Data[Home] [Help]

APPS.GHR_NOAC_LAS_API dependencies on HR_API

Line 60: when hr_api.cannot_find_prog_unit then

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'

Line 61: hr_api.cannot_find_prog_unit_error

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

Line 103: when hr_api.cannot_find_prog_unit then

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

Line 104: hr_api.cannot_find_prog_unit_error

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

Line 118: raise hr_api.validate_enabled;

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

Line 130: when hr_api.validate_enabled then

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

Line 160: ,p_nature_of_action_id in number default hr_api.g_number

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

Line 161: ,p_lac_lookup_code in varchar2 default hr_api.g_varchar2

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

Line 162: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

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

Line 163: ,p_date_from in date default hr_api.g_date

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

Line 164: ,p_date_to in date default hr_api.g_date

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

Line 166: ,p_valid_first_lac_flag 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
169: ) is
170: --

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

Line 208: when hr_api.cannot_find_prog_unit then

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

Line 209: hr_api.cannot_find_prog_unit_error

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

Line 250: when hr_api.cannot_find_prog_unit then

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

Line 251: hr_api.cannot_find_prog_unit_error

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

Line 265: raise hr_api.validate_enabled;

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

Line 276: when hr_api.validate_enabled then

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

Line 339: when hr_api.cannot_find_prog_unit then

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

Line 340: hr_api.cannot_find_prog_unit_error

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

Line 367: when hr_api.cannot_find_prog_unit then

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

Line 368: hr_api.cannot_find_prog_unit_error

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

Line 382: raise hr_api.validate_enabled;

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

Line 389: when hr_api.validate_enabled then

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