eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CERT_CATEGORY_API dependencies on HR_API

Line 99: when hr_api.cannot_find_prog_unit then

95: p_primary_flag => p_primary_flag,
96: p_category_usage_id => p_category_usage_id
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'create_cert_cat_inclusion_b'
102: ,p_hook_type => 'BP'
103: );

Line 100: hr_api.cannot_find_prog_unit_error

96: p_category_usage_id => p_category_usage_id
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'create_cert_cat_inclusion_b'
102: ,p_hook_type => 'BP'
103: );
104: end;

Line 178: when hr_api.cannot_find_prog_unit then

174: p_category_usage_id => p_category_usage_id
175: );
176:
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'create_cert_cat_inclusion_a'
181: ,p_hook_type => 'AP'
182: );

Line 179: hr_api.cannot_find_prog_unit_error

175: );
176:
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'create_cert_cat_inclusion_a'
181: ,p_hook_type => 'AP'
182: );
183: end;

Line 188: raise hr_api.validate_enabled;

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

Line 198: when hr_api.validate_enabled then

194: p_object_version_number := l_object_version_number;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 70);
197: exception
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 229: ,p_attribute_category in varchar2 default hr_api.g_varchar2

225: (p_validate in boolean default false
226: ,p_effective_date in date
227: ,p_certification_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute1 in varchar2 default hr_api.g_varchar2

226: ,p_effective_date in date
227: ,p_certification_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute2 in varchar2 default hr_api.g_varchar2

227: ,p_certification_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute3 in varchar2 default hr_api.g_varchar2

228: ,p_object_version_number in out nocopy number
229: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute4 in varchar2 default hr_api.g_varchar2

229: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute5 in varchar2 default hr_api.g_varchar2

230: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute6 in varchar2 default hr_api.g_varchar2

231: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute7 in varchar2 default hr_api.g_varchar2

232: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute8 in varchar2 default hr_api.g_varchar2

233: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute9 in varchar2 default hr_api.g_varchar2

234: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute10 in varchar2 default hr_api.g_varchar2

235: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute11 in varchar2 default hr_api.g_varchar2

236: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute12 in varchar2 default hr_api.g_varchar2

237: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute13 in varchar2 default hr_api.g_varchar2

238: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute14 in varchar2 default hr_api.g_varchar2

239: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute15 in varchar2 default hr_api.g_varchar2

240: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute16 in varchar2 default hr_api.g_varchar2

241: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute17 in varchar2 default hr_api.g_varchar2

242: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date

Line 247: ,p_attribute18 in varchar2 default hr_api.g_varchar2

243: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date

Line 248: ,p_attribute19 in varchar2 default hr_api.g_varchar2

244: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date
252: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute20 in varchar2 default hr_api.g_varchar2

245: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date
252: ,p_primary_flag in varchar2 default hr_api.g_varchar2
253: ,p_category_usage_id in number

Line 250: ,p_start_date_active in date default hr_api.g_date

246: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date
252: ,p_primary_flag in varchar2 default hr_api.g_varchar2
253: ,p_category_usage_id in number
254: ) is

Line 251: ,p_end_date_active in date default hr_api.g_date

247: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date
252: ,p_primary_flag in varchar2 default hr_api.g_varchar2
253: ,p_category_usage_id in number
254: ) is
255: --

Line 252: ,p_primary_flag in varchar2 default hr_api.g_varchar2

248: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_start_date_active in date default hr_api.g_date
251: ,p_end_date_active in date default hr_api.g_date
252: ,p_primary_flag in varchar2 default hr_api.g_varchar2
253: ,p_category_usage_id in number
254: ) is
255: --
256: -- Declare cursors and local variables

Line 310: when hr_api.cannot_find_prog_unit then

306: p_category_usage_id => p_category_usage_id
307: );
308:
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_cert_cat_inclusion_b'
313: ,p_hook_type => 'BP'
314: );

Line 311: hr_api.cannot_find_prog_unit_error

307: );
308:
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_cert_cat_inclusion_b'
313: ,p_hook_type => 'BP'
314: );
315: end;

Line 387: when hr_api.cannot_find_prog_unit then

383: p_primary_flag => p_primary_flag,
384: p_category_usage_id => p_category_usage_id
385: );
386: exception
387: when hr_api.cannot_find_prog_unit then
388: hr_api.cannot_find_prog_unit_error
389: (p_module_name => 'update_cert_cat_inclusion'
390: ,p_hook_type => 'AP'
391: );

Line 388: hr_api.cannot_find_prog_unit_error

384: p_category_usage_id => p_category_usage_id
385: );
386: exception
387: when hr_api.cannot_find_prog_unit then
388: hr_api.cannot_find_prog_unit_error
389: (p_module_name => 'update_cert_cat_inclusion'
390: ,p_hook_type => 'AP'
391: );
392: end;

Line 397: raise hr_api.validate_enabled;

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

Line 406: when hr_api.validate_enabled then

402: p_object_version_number := l_object_version_number;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 70);
405: exception
406: when hr_api.validate_enabled then
407: --
408: -- As the Validate_Enabled exception has been raised
409: -- we must rollback to the savepoint
410: --

Line 462: when hr_api.cannot_find_prog_unit then

458: p_category_usage_id => p_category_usage_id,
459: p_object_version_number => p_object_version_number);
460:
461: exception
462: when hr_api.cannot_find_prog_unit then
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'delete_cert_cat_inclusion_b '
465: ,p_hook_type => 'BP'
466: );

Line 463: hr_api.cannot_find_prog_unit_error

459: p_object_version_number => p_object_version_number);
460:
461: exception
462: when hr_api.cannot_find_prog_unit then
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'delete_cert_cat_inclusion_b '
465: ,p_hook_type => 'BP'
466: );
467: end;

Line 487: when hr_api.cannot_find_prog_unit then

483: (p_certification_id => p_certification_id ,
484: p_category_usage_id => p_category_usage_id,
485: p_object_version_number => p_object_version_number);
486: exception
487: when hr_api.cannot_find_prog_unit then
488: hr_api.cannot_find_prog_unit_error
489: (p_module_name => 'delete_cert_cat_inclusion_a '
490: ,p_hook_type => 'AP'
491: );

Line 488: hr_api.cannot_find_prog_unit_error

484: p_category_usage_id => p_category_usage_id,
485: p_object_version_number => p_object_version_number);
486: exception
487: when hr_api.cannot_find_prog_unit then
488: hr_api.cannot_find_prog_unit_error
489: (p_module_name => 'delete_cert_cat_inclusion_a '
490: ,p_hook_type => 'AP'
491: );
492: end;

Line 497: raise hr_api.validate_enabled;

493: --
494: -- When in validation only mode raise the Validate_Enabled exception
495: --
496: if p_validate then
497: raise hr_api.validate_enabled;
498: end if;
499: --
500: -- Set all output arguments
501: --

Line 505: when hr_api.validate_enabled then

501: --
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 170);
504: exception
505: when hr_api.validate_enabled then
506: --
507: -- As the Validate_Enabled exception has been raised
508: -- we must rollback to the savepoint
509: --