DBA Data[Home] [Help]

APPS.BEN_EXT_RCD_IN_FILE_API dependencies on HR_API

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_chg_rcd_upd_flag => p_chg_rcd_upd_flag
71: ,p_effective_date => trunc(p_effective_date)
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_EXT_RCD_IN_FILE'
78: ,p_hook_type => 'BP'

Line 75: hr_api.cannot_find_prog_unit_error

71: ,p_effective_date => trunc(p_effective_date)
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_EXT_RCD_IN_FILE'
78: ,p_hook_type => 'BP'
79: );

Line 131: when hr_api.cannot_find_prog_unit then

127: ,p_chg_rcd_upd_flag => p_chg_rcd_upd_flag
128: ,p_effective_date => trunc(p_effective_date)
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'CREATE_EXT_RCD_IN_FILE'
134: ,p_hook_type => 'AP'
135: );

Line 132: hr_api.cannot_find_prog_unit_error

128: ,p_effective_date => trunc(p_effective_date)
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'CREATE_EXT_RCD_IN_FILE'
134: ,p_hook_type => 'AP'
135: );
136: --

Line 146: raise hr_api.validate_enabled;

142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --

Line 158: when hr_api.validate_enabled then

154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: --
156: exception
157: --
158: when hr_api.validate_enabled then
159: --
160: -- As the Validate_Enabled exception has been raised
161: -- we must rollback to the savepoint
162: --

Line 190: ,p_seq_num in number default hr_api.g_number

186: --
187: procedure update_EXT_RCD_IN_FILE
188: (p_validate in boolean default false
189: ,p_ext_rcd_in_file_id in number
190: ,p_seq_num in number default hr_api.g_number
191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number

Line 191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2

187: procedure update_EXT_RCD_IN_FILE
188: (p_validate in boolean default false
189: ,p_ext_rcd_in_file_id in number
190: ,p_seq_num in number default hr_api.g_number
191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number

Line 192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number

188: (p_validate in boolean default false
189: ,p_ext_rcd_in_file_id in number
190: ,p_seq_num in number default hr_api.g_number
191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number

Line 193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number

189: ,p_ext_rcd_in_file_id in number
190: ,p_seq_num in number default hr_api.g_number
191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number

Line 194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number

190: ,p_seq_num in number default hr_api.g_number
191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number

Line 195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number

191: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 196: ,p_ext_rcd_id in number default hr_api.g_number

192: ,p_sort1_data_elmt_in_rcd_id in number default hr_api.g_number
193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number

Line 197: ,p_ext_file_id in number default hr_api.g_number

193: ,p_sort2_data_elmt_in_rcd_id in number default hr_api.g_number
194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2

Line 198: ,p_business_group_id in number default hr_api.g_number

194: ,p_sort3_data_elmt_in_rcd_id in number default hr_api.g_number
195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2

Line 199: ,p_legislation_code in varchar2 default hr_api.g_varchar2

195: ,p_sort4_data_elmt_in_rcd_id in number default hr_api.g_number
196: ,p_ext_rcd_id in number default hr_api.g_number
197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2
203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2

Line 201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2

197: ,p_ext_file_id in number default hr_api.g_number
198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2
203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
204: ,p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
205: ,p_effective_date in date

Line 202: ,p_hide_flag in varchar2 default hr_api.g_varchar2

198: ,p_business_group_id in number default hr_api.g_number
199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2
203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
204: ,p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
205: ,p_effective_date in date
206: ) is

Line 203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2

199: ,p_legislation_code in varchar2 default hr_api.g_varchar2
200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2
203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
204: ,p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
205: ,p_effective_date in date
206: ) is
207: --

Line 204: ,p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2

200: ,p_object_version_number in out nocopy number
201: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
202: ,p_hide_flag in varchar2 default hr_api.g_varchar2
203: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
204: ,p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
205: ,p_effective_date in date
206: ) is
207: --
208: -- Declare cursors and local variables

Line 252: when hr_api.cannot_find_prog_unit then

248: ,p_chg_rcd_upd_flag => p_chg_rcd_upd_flag
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_EXT_RCD_IN_FILE'
255: ,p_hook_type => 'BP'
256: );

Line 253: hr_api.cannot_find_prog_unit_error

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_EXT_RCD_IN_FILE'
255: ,p_hook_type => 'BP'
256: );
257: --

Line 308: when hr_api.cannot_find_prog_unit then

304: ,p_chg_rcd_upd_flag => p_chg_rcd_upd_flag
305: ,p_effective_date => trunc(p_effective_date)
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_EXT_RCD_IN_FILE'
311: ,p_hook_type => 'AP'
312: );

Line 309: hr_api.cannot_find_prog_unit_error

305: ,p_effective_date => trunc(p_effective_date)
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_EXT_RCD_IN_FILE'
311: ,p_hook_type => 'AP'
312: );
313: --

Line 323: raise hr_api.validate_enabled;

319: --
320: -- When in validation only mode raise the Validate_Enabled exception
321: --
322: if p_validate then
323: raise hr_api.validate_enabled;
324: end if;
325: --
326: -- Set all output arguments
327: --

Line 334: when hr_api.validate_enabled then

330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: --
332: exception
333: --
334: when hr_api.validate_enabled then
335: --
336: -- As the Validate_Enabled exception has been raised
337: -- we must rollback to the savepoint
338: --

Line 399: when hr_api.cannot_find_prog_unit then

395: ,p_object_version_number => p_object_version_number
396: ,p_effective_date => trunc(p_effective_date)
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'DELETE_EXT_RCD_IN_FILE'
402: ,p_hook_type => 'BP'
403: );

Line 400: hr_api.cannot_find_prog_unit_error

396: ,p_effective_date => trunc(p_effective_date)
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'DELETE_EXT_RCD_IN_FILE'
402: ,p_hook_type => 'BP'
403: );
404: --

Line 429: when hr_api.cannot_find_prog_unit then

425: ,p_object_version_number => l_object_version_number
426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_EXT_RCD_IN_FILE'
432: ,p_hook_type => 'AP'
433: );

Line 430: hr_api.cannot_find_prog_unit_error

426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_EXT_RCD_IN_FILE'
432: ,p_hook_type => 'AP'
433: );
434: --

Line 444: raise hr_api.validate_enabled;

440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: --

Line 451: when hr_api.validate_enabled then

447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: --
449: exception
450: --
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised
454: -- we must rollback to the savepoint
455: --