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_CRE_BUS dependencies on OTA_CERT_ENROLLMENTS

Line 31: , ota_cert_enrollments cre

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_cert_enrollments cre
32: where cre.cert_enrollment_id = p_cert_enrollment_id
33: and pbg.business_group_id = cre.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_cert_enrollments cre

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_cert_enrollments cre
102: where cre.cert_enrollment_id = p_cert_enrollment_id
103: and pbg.business_group_id = cre.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'OTA_CERT_ENROLLMENTS'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'OTA'
249: ,p_descflex_name => 'OTA_CERT_ENROLLMENTS'
250: ,p_attribute_category => p_rec.attribute_category
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 354: Procedure chk_person_contact (p_person_id ota_cert_enrollments.person_id%TYPE,

350: --
351: -- ---------------------------------------------------------------------------
352: -- |-------------------------< chk_person_contact >---------------------------|
353: -- ---------------------------------------------------------------------------
354: Procedure chk_person_contact (p_person_id ota_cert_enrollments.person_id%TYPE,
355: p_contact_id ota_cert_enrollments.contact_id%TYPE)
356: is
357: --
358: l_proc varchar2(72) := g_package||'chk_person_contact';

Line 355: p_contact_id ota_cert_enrollments.contact_id%TYPE)

351: -- ---------------------------------------------------------------------------
352: -- |-------------------------< chk_person_contact >---------------------------|
353: -- ---------------------------------------------------------------------------
354: Procedure chk_person_contact (p_person_id ota_cert_enrollments.person_id%TYPE,
355: p_contact_id ota_cert_enrollments.contact_id%TYPE)
356: is
357: --
358: l_proc varchar2(72) := g_package||'chk_person_contact';
359:

Line 411: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.PERSON_ID') THEN

407: EXCEPTION
408:
409: WHEN app_exception.application_exception THEN
410: IF hr_multi_message.exception_add(
411: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.PERSON_ID') THEN
412: hr_utility.set_location(' Leaving:'||l_proc, 52);
413: RAISE;
414:
415: END IF;

Line 427: ,p_certification_status_code IN ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE

423: -- ----------------------------------------------------------------------------
424: --
425: PROCEDURE chk_certification_status_code
426: (p_effective_date IN date
427: ,p_certification_status_code IN ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE
428: ) IS
429: --
430: l_proc varchar2(72) := g_package|| 'chk_certification_status_code';
431: --

Line 460: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.CERTIFICATION_STATUS_CODE') THEN

456: --MULTI MESSAGE SUPPORT
457: EXCEPTION
458: WHEN app_exception.application_exception THEN
459: IF hr_multi_message.exception_add(
460: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.CERTIFICATION_STATUS_CODE') THEN
461: hr_utility.set_location(' Leaving:'||l_proc, 32);
462: RAISE;
463:
464: END IF;

Line 475: (p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE)

471: -- |-----------------------------------------------|
472: -- ----------------------------------------------------------------------------
473: --
474: PROCEDURE chk_del_cert_enrollment_id
475: (p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE)
476: IS
477: --
478: l_exists varchar2(1);
479: l_proc varchar2(72) := g_package|| 'chk_del_cert_enrollment_id';

Line 489: FROM ota_cert_enrollments

485: WHERE cpe.cert_enrollment_id = p_cert_enrollment_id;
486:
487: CURSOR csr_cert_enr_status is
488: SELECT certification_status_code
489: FROM ota_cert_enrollments
490: WHERE cert_enrollment_id = p_cert_enrollment_id;
491:
492:
493: --

Line 544: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE

540: -- |-----------------------------------------------|
541: -- ----------------------------------------------------------------------------
542: --
543: PROCEDURE check_duplicate_subscription
544: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE
545: ,p_contact_id IN ota_cert_enrollments.contact_id%TYPE default NULL
546: ,p_person_id IN ota_cert_enrollments.person_id%TYPE default NULL)
547: IS
548: --

Line 545: ,p_contact_id IN ota_cert_enrollments.contact_id%TYPE default NULL

541: -- ----------------------------------------------------------------------------
542: --
543: PROCEDURE check_duplicate_subscription
544: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE
545: ,p_contact_id IN ota_cert_enrollments.contact_id%TYPE default NULL
546: ,p_person_id IN ota_cert_enrollments.person_id%TYPE default NULL)
547: IS
548: --
549: l_exists varchar2(1);

Line 546: ,p_person_id IN ota_cert_enrollments.person_id%TYPE default NULL)

542: --
543: PROCEDURE check_duplicate_subscription
544: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE
545: ,p_contact_id IN ota_cert_enrollments.contact_id%TYPE default NULL
546: ,p_person_id IN ota_cert_enrollments.person_id%TYPE default NULL)
547: IS
548: --
549: l_exists varchar2(1);
550: l_proc varchar2(72) := g_package|| 'check_duplicate_subscription';

Line 554: FROM ota_cert_enrollments cre

550: l_proc varchar2(72) := g_package|| 'check_duplicate_subscription';
551:
552: CURSOR csr_cert_enr_id IS
553: SELECT null
554: FROM ota_cert_enrollments cre
555: WHERE cre.certification_id = p_certification_id
556: AND ( cre.person_id = p_person_id and cre.contact_id IS NULL
557: OR cre.contact_id = p_contact_id and cre.person_id IS NULL)
558: AND cre.certification_status_code <> 'CANCELLED';

Line 618: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE)

614: -- Removed this check for renewal based certifications to allow for
615: -- new employees to subscribe to ongoing date based certs.
616: --
617: PROCEDURE check_due_date_passed
618: ( p_certification_id IN ota_cert_enrollments.certification_id%TYPE)
619: IS
620: --
621: l_exists varchar2(1);
622: l_proc varchar2(72) := g_package|| 'check_due_date_passed';