DBA Data[Home] [Help]

APPS.GHR_NOAC_REMARKS_API dependencies on HR_API

Line 66: when hr_api.cannot_find_prog_unit then

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'

Line 67: hr_api.cannot_find_prog_unit_error

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

Line 107: when hr_api.cannot_find_prog_unit then

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

Line 108: hr_api.cannot_find_prog_unit_error

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

Line 122: raise hr_api.validate_enabled;

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

Line 134: when hr_api.validate_enabled then

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

Line 164: ,p_nature_of_action_id in number default hr_api.g_number

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

Line 165: ,p_remark_id in number default hr_api.g_number

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

Line 166: ,p_required_flag in varchar2 default hr_api.g_varchar2

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

Line 167: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

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

Line 168: ,p_date_from in date default hr_api.g_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

Line 169: ,p_date_to in date default hr_api.g_date

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

Line 219: when hr_api.cannot_find_prog_unit then

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

Line 220: hr_api.cannot_find_prog_unit_error

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

Line 259: when hr_api.cannot_find_prog_unit then

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

Line 260: hr_api.cannot_find_prog_unit_error

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

Line 274: raise hr_api.validate_enabled;

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

Line 285: when hr_api.validate_enabled then

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

Line 348: when hr_api.cannot_find_prog_unit then

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

Line 349: hr_api.cannot_find_prog_unit_error

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

Line 376: when hr_api.cannot_find_prog_unit then

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

Line 377: hr_api.cannot_find_prog_unit_error

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

Line 391: raise hr_api.validate_enabled;

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

Line 398: when hr_api.validate_enabled then

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