58: ,p_business_group_id => p_business_group_id
59: ,p_effective_date => trunc(p_effective_date)
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (
65: p_module_name => 'CREATE_batch_actn_item_info'
66: ,p_hook_type => 'BP'
59: ,p_effective_date => trunc(p_effective_date)
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (
65: p_module_name => 'CREATE_batch_actn_item_info'
66: ,p_hook_type => 'BP'
67: );
103: ,p_object_version_number => l_object_version_number
104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_batch_actn_item_info'
110: ,p_hook_type => 'AP'
111: );
104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_batch_actn_item_info'
110: ,p_hook_type => 'AP'
111: );
112: --
118: --
119: -- When in validation only mode raise the Validate_Enabled exception
120: --
121: if p_validate then
122: raise hr_api.validate_enabled;
123: end if;
124: --
125: -- Set all output arguments
126: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --
132: exception
133: --
134: when hr_api.validate_enabled then
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint
138: --
160: --
161: procedure update_batch_actn_item_info
162: (p_validate in boolean default false
163: ,p_batch_actn_item_id in number
164: ,p_benefit_action_id in number default hr_api.g_number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
161: procedure update_batch_actn_item_info
162: (p_validate in boolean default false
163: ,p_batch_actn_item_id in number
164: ,p_benefit_action_id in number default hr_api.g_number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
162: (p_validate in boolean default false
163: ,p_batch_actn_item_id in number
164: ,p_benefit_action_id in number default hr_api.g_number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
163: ,p_batch_actn_item_id in number
164: ,p_benefit_action_id in number default hr_api.g_number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
171: ,p_business_group_id in number default hr_api.g_number
164: ,p_benefit_action_id in number default hr_api.g_number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
171: ,p_business_group_id in number default hr_api.g_number
172: ,p_object_version_number in out nocopy number
165: ,p_person_id in number default hr_api.g_number
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
171: ,p_business_group_id in number default hr_api.g_number
172: ,p_object_version_number in out nocopy number
173: ,p_effective_date in date
166: ,p_actn_typ_id in number default hr_api.g_number
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
171: ,p_business_group_id in number default hr_api.g_number
172: ,p_object_version_number in out nocopy number
173: ,p_effective_date in date
174: ) is
167: ,p_cmpltd_dt in date default hr_api.g_date
168: ,p_due_dt in date default hr_api.g_date
169: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
170: ,p_actn_cd in varchar2 default hr_api.g_varchar2
171: ,p_business_group_id in number default hr_api.g_number
172: ,p_object_version_number in out nocopy number
173: ,p_effective_date in date
174: ) is
175: --
210: ,p_object_version_number => p_object_version_number
211: ,p_effective_date => trunc(p_effective_date)
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'UPDATE_batch_actn_item_info'
217: ,p_hook_type => 'BP'
218: );
211: ,p_effective_date => trunc(p_effective_date)
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'UPDATE_batch_actn_item_info'
217: ,p_hook_type => 'BP'
218: );
219: --
254: ,p_object_version_number => l_object_version_number
255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_batch_actn_item_info'
261: ,p_hook_type => 'AP'
262: );
255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_batch_actn_item_info'
261: ,p_hook_type => 'AP'
262: );
263: --
269: --
270: -- When in validation only mode raise the Validate_Enabled exception
271: --
272: if p_validate then
273: raise hr_api.validate_enabled;
274: end if;
275: --
276: -- Set all output arguments
277: --
280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: --
282: exception
283: --
284: when hr_api.validate_enabled then
285: --
286: -- As the Validate_Enabled exception has been raised
287: -- we must rollback to the savepoint
288: --
343: ,p_object_version_number => p_object_version_number
344: ,p_effective_date => trunc(p_effective_date)
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'DELETE_batch_actn_item_info'
350: ,p_hook_type => 'BP'
351: );
344: ,p_effective_date => trunc(p_effective_date)
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'DELETE_batch_actn_item_info'
350: ,p_hook_type => 'BP'
351: );
352: --
371: ,p_object_version_number => l_object_version_number
372: ,p_effective_date => trunc(p_effective_date)
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'DELETE_batch_actn_item_info'
378: ,p_hook_type => 'AP'
379: );
372: ,p_effective_date => trunc(p_effective_date)
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'DELETE_batch_actn_item_info'
378: ,p_hook_type => 'AP'
379: );
380: --
386: --
387: -- When in validation only mode raise the Validate_Enabled exception
388: --
389: if p_validate then
390: raise hr_api.validate_enabled;
391: end if;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: --
395: exception
396: --
397: when hr_api.validate_enabled then
398: --
399: -- As the Validate_Enabled exception has been raised
400: -- we must rollback to the savepoint
401: --