DBA Data[Home] [Help]

APPS.HR_CAGR_GRADE_STRUCTURES_API dependencies on HR_API

Line 94: when hr_api.cannot_find_prog_unit then

90: ,p_attribute20 => p_attribute20
91: ,p_effective_date => trunc(p_effective_date)
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_CAGR_GRADE_STRUCTURES'
98: ,p_hook_type => 'BP'

Line 95: hr_api.cannot_find_prog_unit_error

91: ,p_effective_date => trunc(p_effective_date)
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_CAGR_GRADE_STRUCTURES'
98: ,p_hook_type => 'BP'
99: );

Line 171: when hr_api.cannot_find_prog_unit then

167: ,p_attribute20 => p_attribute20
168: ,p_effective_date => trunc(p_effective_date)
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CAGR_GRADE_SRUCTURE'
174: ,p_hook_type => 'AP'
175: );

Line 172: hr_api.cannot_find_prog_unit_error

168: ,p_effective_date => trunc(p_effective_date)
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CAGR_GRADE_SRUCTURE'
174: ,p_hook_type => 'AP'
175: );
176: --

Line 186: raise hr_api.validate_enabled;

182: --
183: -- When in validation only mode raise the Validate_Enabled exception
184: --
185: if p_validate then
186: raise hr_api.validate_enabled;
187: end if;
188: --
189: -- Set all output arguments
190: --

Line 198: when hr_api.validate_enabled then

194: hr_utility.set_location(' Leaving:'||l_proc, 70);
195: --
196: exception
197: --
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised
201: -- we must rollback to the savepoint
202: --

Line 234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2

230: procedure update_cagr_grade_structures
231: (p_validate in boolean default false
232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute_category in varchar2 default hr_api.g_varchar2

231: (p_validate in boolean default false
232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute1 in varchar2 default hr_api.g_varchar2

232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute2 in varchar2 default hr_api.g_varchar2

233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute3 in varchar2 default hr_api.g_varchar2

234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute4 in varchar2 default hr_api.g_varchar2

235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute5 in varchar2 default hr_api.g_varchar2

236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute6 in varchar2 default hr_api.g_varchar2

237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute7 in varchar2 default hr_api.g_varchar2

238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute8 in varchar2 default hr_api.g_varchar2

239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute9 in varchar2 default hr_api.g_varchar2

240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute10 in varchar2 default hr_api.g_varchar2

241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute11 in varchar2 default hr_api.g_varchar2

242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute12 in varchar2 default hr_api.g_varchar2

243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute13 in varchar2 default hr_api.g_varchar2

244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute14 in varchar2 default hr_api.g_varchar2

245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute15 in varchar2 default hr_api.g_varchar2

246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute16 in varchar2 default hr_api.g_varchar2

247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute17 in varchar2 default hr_api.g_varchar2

248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date

Line 253: ,p_attribute18 in varchar2 default hr_api.g_varchar2

249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is

Line 254: ,p_attribute19 in varchar2 default hr_api.g_varchar2

250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is
258: --

Line 255: ,p_attribute20 in varchar2 default hr_api.g_varchar2

251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is
258: --
259: -- Declare cursors and local variables

Line 312: when hr_api.cannot_find_prog_unit then

308: ,p_attribute20 => p_attribute20
309: ,p_effective_date => trunc(p_effective_date)
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
315: ,p_hook_type => 'BP'
316: );

Line 313: hr_api.cannot_find_prog_unit_error

309: ,p_effective_date => trunc(p_effective_date)
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
315: ,p_hook_type => 'BP'
316: );
317: --

Line 384: when hr_api.cannot_find_prog_unit then

380: ,p_attribute20 => p_attribute20
381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
387: ,p_hook_type => 'AP'
388: );

Line 385: hr_api.cannot_find_prog_unit_error

381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
387: ,p_hook_type => 'AP'
388: );
389: --

Line 399: raise hr_api.validate_enabled;

395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: -- Set all output arguments
403: --

Line 410: when hr_api.validate_enabled then

406: hr_utility.set_location(' Leaving:'||l_proc, 70);
407: --
408: exception
409: --
410: when hr_api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --

Line 478: when hr_api.cannot_find_prog_unit then

474: ,p_object_version_number => p_object_version_number
475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'DELETE_CAGR_GRADES_STRUCTURES'
481: ,p_hook_type => 'BP'
482: );

Line 479: hr_api.cannot_find_prog_unit_error

475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'DELETE_CAGR_GRADES_STRUCTURES'
481: ,p_hook_type => 'BP'
482: );
483: --

Line 506: when hr_api.cannot_find_prog_unit then

502: ,p_object_version_number => l_object_version_number
503: ,p_effective_date => trunc(p_effective_date)
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_CAGR_GRADE_STRUCTURES'
509: ,p_hook_type => 'AP'
510: );

Line 507: hr_api.cannot_find_prog_unit_error

503: ,p_effective_date => trunc(p_effective_date)
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_CAGR_GRADE_STRUCTURES'
509: ,p_hook_type => 'AP'
510: );
511: --

Line 521: raise hr_api.validate_enabled;

517: --
518: -- When in validation only mode raise the Validate_Enabled exception
519: --
520: if p_validate then
521: raise hr_api.validate_enabled;
522: end if;
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 70);
525: --

Line 528: when hr_api.validate_enabled then

524: hr_utility.set_location(' Leaving:'||l_proc, 70);
525: --
526: exception
527: --
528: when hr_api.validate_enabled then
529: --
530: -- As the Validate_Enabled exception has been raised
531: -- we must rollback to the savepoint
532: --