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 117: when hr_api.cannot_find_prog_unit then

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

Line 118: hr_api.cannot_find_prog_unit_error

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

Line 200: when hr_api.cannot_find_prog_unit then

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

Line 201: hr_api.cannot_find_prog_unit_error

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

Line 211: raise hr_api.validate_enabled;

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

Line 216: when hr_api.validate_enabled then

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

Line 251: ,p_completion_date in date default hr_api.g_date

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

Line 252: ,p_business_group_id in number default hr_api.g_number

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

Line 253: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 254: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 255: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 256: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 257: ,p_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 258: ,p_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 259: ,p_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 260: ,p_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 261: ,p_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 262: ,p_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 263: ,p_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 264: ,p_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 265: ,p_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 266: ,p_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 267: ,p_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 268: ,p_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 269: ,p_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 270: ,p_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 271: ,p_attribute18 in varchar2 default hr_api.g_varchar2

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

Line 272: ,p_attribute19 in varchar2 default hr_api.g_varchar2

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

Line 273: ,p_attribute20 in varchar2 default hr_api.g_varchar2

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

Line 366: when hr_api.cannot_find_prog_unit then

362: ,p_attribute20 => p_attribute20
363: );
364:
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'UPDATE_cert_mbr_enrollment'
369: ,p_hook_type => 'BP'
370: );

Line 367: hr_api.cannot_find_prog_unit_error

363: );
364:
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'UPDATE_cert_mbr_enrollment'
369: ,p_hook_type => 'BP'
370: );
371: end;

Line 446: when hr_api.cannot_find_prog_unit then

442: ,p_attribute20 => p_attribute20
443: );
444:
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_CERT_MBR_ENROLLMENT'
449: ,p_hook_type => 'AP'
450: );

Line 447: hr_api.cannot_find_prog_unit_error

443: );
444:
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_CERT_MBR_ENROLLMENT'
449: ,p_hook_type => 'AP'
450: );
451: end;

Line 458: raise hr_api.validate_enabled;

454: --
455: -- When in validation only mode raise the Validate_Enabled exception
456: --
457: if p_validate then
458: raise hr_api.validate_enabled;
459: end if;
460: --
461: -- Set all output arguments
462: --

Line 467: when hr_api.validate_enabled then

463: p_object_version_number := l_object_version_number;
464:
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised
470: -- we must rollback to the savepoint
471: --

Line 523: when hr_api.cannot_find_prog_unit then

519: (p_cert_mbr_enrollment_id => p_cert_mbr_enrollment_id
520: ,p_object_version_number => p_object_version_number
521: );
522: exception
523: when hr_api.cannot_find_prog_unit then
524: hr_api.cannot_find_prog_unit_error
525: (p_module_name => 'DELETE_cert_mbr_enrollment'
526: ,p_hook_type => 'BP'
527: );

Line 524: hr_api.cannot_find_prog_unit_error

520: ,p_object_version_number => p_object_version_number
521: );
522: exception
523: when hr_api.cannot_find_prog_unit then
524: hr_api.cannot_find_prog_unit_error
525: (p_module_name => 'DELETE_cert_mbr_enrollment'
526: ,p_hook_type => 'BP'
527: );
528: end;

Line 547: when hr_api.cannot_find_prog_unit then

543: (p_cert_mbr_enrollment_id => p_cert_mbr_enrollment_id
544: ,p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'DELETE_cert_mbr_enrollment'
550: ,p_hook_type => 'AP'
551: );

Line 548: hr_api.cannot_find_prog_unit_error

544: ,p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'DELETE_cert_mbr_enrollment'
550: ,p_hook_type => 'AP'
551: );
552: end;

Line 558: raise hr_api.validate_enabled;

554: --
555: -- When in validation only mode raise the Validate_Enabled exception
556: --
557: if p_validate then
558: raise hr_api.validate_enabled;
559: end if;
560: --
561: -- Set all output arguments
562: --

Line 566: when hr_api.validate_enabled then

562: --
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 170);
565: exception
566: when hr_api.validate_enabled then
567: --
568: -- As the Validate_Enabled exception has been raised
569: -- we must rollback to the savepoint
570: --