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_MBR_ENROLLMENT_API dependencies on HR_API

Line 115: when hr_api.cannot_find_prog_unit then

111: ,p_attribute19 => p_attribute19
112: ,p_attribute20 => p_attribute20
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_cert_mbr_enrollment'
118: ,p_hook_type => 'BP'
119: );

Line 116: hr_api.cannot_find_prog_unit_error

112: ,p_attribute20 => p_attribute20
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_cert_mbr_enrollment'
118: ,p_hook_type => 'BP'
119: );
120: end;

Line 198: when hr_api.cannot_find_prog_unit then

194: ,p_attribute20 => p_attribute20
195: );
196:
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'CREATE_cert_mbr_enrollment'
201: ,p_hook_type => 'AP'
202: );

Line 199: hr_api.cannot_find_prog_unit_error

195: );
196:
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'CREATE_cert_mbr_enrollment'
201: ,p_hook_type => 'AP'
202: );
203: end;

Line 209: raise hr_api.validate_enabled;

205: --
206: -- When in validation only mode raise the Validate_Enabled exception
207: --
208: if p_validate then
209: raise hr_api.validate_enabled;
210: end if;
211:
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception

Line 214: when hr_api.validate_enabled then

210: end if;
211:
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception
214: when hr_api.validate_enabled then
215: --
216: -- As the Validate_Enabled exception has been raised
217: -- we must rollback to the savepoint
218: --

Line 249: ,p_completion_date in date default hr_api.g_date

245: ,p_object_version_number in out nocopy number
246: ,p_cert_prd_enrollment_id in number
247: ,p_cert_member_id in number
248: ,p_member_status_code in varchar2
249: ,p_completion_date in date default hr_api.g_date
250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 250: ,p_business_group_id in number default hr_api.g_number

246: ,p_cert_prd_enrollment_id in number
247: ,p_cert_member_id in number
248: ,p_member_status_code in varchar2
249: ,p_completion_date in date default hr_api.g_date
250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute_category in varchar2 default hr_api.g_varchar2

247: ,p_cert_member_id in number
248: ,p_member_status_code in varchar2
249: ,p_completion_date in date default hr_api.g_date
250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute1 in varchar2 default hr_api.g_varchar2

248: ,p_member_status_code in varchar2
249: ,p_completion_date in date default hr_api.g_date
250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute2 in varchar2 default hr_api.g_varchar2

249: ,p_completion_date in date default hr_api.g_date
250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute3 in varchar2 default hr_api.g_varchar2

250: ,p_business_group_id in number default hr_api.g_number
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute4 in varchar2 default hr_api.g_varchar2

251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute5 in varchar2 default hr_api.g_varchar2

252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute6 in varchar2 default hr_api.g_varchar2

253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute7 in varchar2 default hr_api.g_varchar2

254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 259: ,p_attribute8 in varchar2 default hr_api.g_varchar2

255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute9 in varchar2 default hr_api.g_varchar2

256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute10 in varchar2 default hr_api.g_varchar2

257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 262: ,p_attribute11 in varchar2 default hr_api.g_varchar2

258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 263: ,p_attribute12 in varchar2 default hr_api.g_varchar2

259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 264: ,p_attribute13 in varchar2 default hr_api.g_varchar2

260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 265: ,p_attribute14 in varchar2 default hr_api.g_varchar2

261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 266: ,p_attribute15 in varchar2 default hr_api.g_varchar2

262: ,p_attribute11 in varchar2 default hr_api.g_varchar2
263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 267: ,p_attribute16 in varchar2 default hr_api.g_varchar2

263: ,p_attribute12 in varchar2 default hr_api.g_varchar2
264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2
271: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 268: ,p_attribute17 in varchar2 default hr_api.g_varchar2

264: ,p_attribute13 in varchar2 default hr_api.g_varchar2
265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2
271: ,p_attribute20 in varchar2 default hr_api.g_varchar2
272: ,p_validate in boolean default false

Line 269: ,p_attribute18 in varchar2 default hr_api.g_varchar2

265: ,p_attribute14 in varchar2 default hr_api.g_varchar2
266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2
271: ,p_attribute20 in varchar2 default hr_api.g_varchar2
272: ,p_validate in boolean default false
273: ) is

Line 270: ,p_attribute19 in varchar2 default hr_api.g_varchar2

266: ,p_attribute15 in varchar2 default hr_api.g_varchar2
267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2
271: ,p_attribute20 in varchar2 default hr_api.g_varchar2
272: ,p_validate in boolean default false
273: ) is
274: --

Line 271: ,p_attribute20 in varchar2 default hr_api.g_varchar2

267: ,p_attribute16 in varchar2 default hr_api.g_varchar2
268: ,p_attribute17 in varchar2 default hr_api.g_varchar2
269: ,p_attribute18 in varchar2 default hr_api.g_varchar2
270: ,p_attribute19 in varchar2 default hr_api.g_varchar2
271: ,p_attribute20 in varchar2 default hr_api.g_varchar2
272: ,p_validate in boolean default false
273: ) is
274: --
275: -- Declare cursors and local variables

Line 355: when hr_api.cannot_find_prog_unit then

351: ,p_attribute20 => p_attribute20
352: );
353:
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_cert_mbr_enrollment'
358: ,p_hook_type => 'BP'
359: );

Line 356: hr_api.cannot_find_prog_unit_error

352: );
353:
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (p_module_name => 'UPDATE_cert_mbr_enrollment'
358: ,p_hook_type => 'BP'
359: );
360: end;

Line 435: when hr_api.cannot_find_prog_unit then

431: ,p_attribute20 => p_attribute20
432: );
433:
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'UPDATE_CERT_MBR_ENROLLMENT'
438: ,p_hook_type => 'AP'
439: );

Line 436: hr_api.cannot_find_prog_unit_error

432: );
433:
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'UPDATE_CERT_MBR_ENROLLMENT'
438: ,p_hook_type => 'AP'
439: );
440: end;

Line 447: raise hr_api.validate_enabled;

443: --
444: -- When in validation only mode raise the Validate_Enabled exception
445: --
446: if p_validate then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: -- Set all output arguments
451: --

Line 456: when hr_api.validate_enabled then

452: p_object_version_number := l_object_version_number;
453:
454: hr_utility.set_location(' Leaving:'||l_proc, 70);
455: exception
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --

Line 512: when hr_api.cannot_find_prog_unit then

508: (p_cert_mbr_enrollment_id => p_cert_mbr_enrollment_id
509: ,p_object_version_number => p_object_version_number
510: );
511: exception
512: when hr_api.cannot_find_prog_unit then
513: hr_api.cannot_find_prog_unit_error
514: (p_module_name => 'DELETE_cert_mbr_enrollment'
515: ,p_hook_type => 'BP'
516: );

Line 513: hr_api.cannot_find_prog_unit_error

509: ,p_object_version_number => p_object_version_number
510: );
511: exception
512: when hr_api.cannot_find_prog_unit then
513: hr_api.cannot_find_prog_unit_error
514: (p_module_name => 'DELETE_cert_mbr_enrollment'
515: ,p_hook_type => 'BP'
516: );
517: end;

Line 536: when hr_api.cannot_find_prog_unit then

532: (p_cert_mbr_enrollment_id => p_cert_mbr_enrollment_id
533: ,p_object_version_number => p_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_cert_mbr_enrollment'
539: ,p_hook_type => 'AP'
540: );

Line 537: hr_api.cannot_find_prog_unit_error

533: ,p_object_version_number => p_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_cert_mbr_enrollment'
539: ,p_hook_type => 'AP'
540: );
541: end;

Line 547: raise hr_api.validate_enabled;

543: --
544: -- When in validation only mode raise the Validate_Enabled exception
545: --
546: if p_validate then
547: raise hr_api.validate_enabled;
548: end if;
549: --
550: -- Set all output arguments
551: --

Line 555: when hr_api.validate_enabled then

551: --
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 170);
554: exception
555: when hr_api.validate_enabled then
556: --
557: -- As the Validate_Enabled exception has been raised
558: -- we must rollback to the savepoint
559: --