62: ,p_date_to => p_date_to
63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_noac_remarks'
70: ,p_hook_type => 'BP'
63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_noac_remarks'
70: ,p_hook_type => 'BP'
71: );
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_noac_remarks'
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_noac_remarks'
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_noac_remarks
162: (p_validate in boolean default false
163: ,p_noac_remark_id in number
164: ,p_nature_of_action_id in number default hr_api.g_number
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
161: procedure update_noac_remarks
162: (p_validate in boolean default false
163: ,p_noac_remark_id in number
164: ,p_nature_of_action_id in number default hr_api.g_number
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
169: ,p_date_to in date default hr_api.g_date
162: (p_validate in boolean default false
163: ,p_noac_remark_id in number
164: ,p_nature_of_action_id in number default hr_api.g_number
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
169: ,p_date_to in date default hr_api.g_date
170: ,p_object_version_number in out number
163: ,p_noac_remark_id in number
164: ,p_nature_of_action_id in number default hr_api.g_number
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
169: ,p_date_to in date default hr_api.g_date
170: ,p_object_version_number in out number
171: ,p_effective_date in date
164: ,p_nature_of_action_id in number default hr_api.g_number
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
169: ,p_date_to in date default hr_api.g_date
170: ,p_object_version_number in out number
171: ,p_effective_date in date
172: ) is
165: ,p_remark_id in number default hr_api.g_number
166: ,p_required_flag in varchar2 default hr_api.g_varchar2
167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
168: ,p_date_from in date default hr_api.g_date
169: ,p_date_to in date default hr_api.g_date
170: ,p_object_version_number in out number
171: ,p_effective_date in date
172: ) is
173: --
215: ,p_object_version_number => p_object_version_number
216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'UPDATE_noac_remarks'
222: ,p_hook_type => 'BP'
223: );
216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'UPDATE_noac_remarks'
222: ,p_hook_type => 'BP'
223: );
224: --
255: ,p_object_version_number => l_object_version_number
256: ,p_effective_date => trunc(p_effective_date)
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'UPDATE_noac_remarks'
262: ,p_hook_type => 'AP'
263: );
256: ,p_effective_date => trunc(p_effective_date)
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'UPDATE_noac_remarks'
262: ,p_hook_type => 'AP'
263: );
264: --
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then
274: raise hr_api.validate_enabled;
275: end if;
276: --
277: -- Set all output arguments
278: --
281: hr_utility.set_location(' Leaving:'||l_proc, 70);
282: --
283: exception
284: --
285: when hr_api.validate_enabled then
286: --
287: -- As the Validate_Enabled exception has been raised
288: -- we must rollback to the savepoint
289: --
344: ,p_object_version_number => p_object_version_number
345: ,p_effective_date => trunc(p_effective_date)
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'DELETE_noac_remarks'
351: ,p_hook_type => 'BP'
352: );
345: ,p_effective_date => trunc(p_effective_date)
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'DELETE_noac_remarks'
351: ,p_hook_type => 'BP'
352: );
353: --
372: ,p_object_version_number => l_object_version_number
373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_noac_remarks'
379: ,p_hook_type => 'AP'
380: );
373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_noac_remarks'
379: ,p_hook_type => 'AP'
380: );
381: --
387: --
388: -- When in validation only mode raise the Validate_Enabled exception
389: --
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
396: exception
397: --
398: when hr_api.validate_enabled then
399: --
400: -- As the Validate_Enabled exception has been raised
401: -- we must rollback to the savepoint
402: --