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

Line 13: csr_person_id in ota_cert_enrollments.person_id%TYPE,

9: --
10: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
11: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
12: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
13: csr_person_id in ota_cert_enrollments.person_id%TYPE,
14: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS
15: SELECT DECODE(bst.type,'C','Z',bst.type) status,
16: evt.event_type,
17: tdb.DATE_STATUS_CHANGED,

Line 14: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS

10: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
11: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
12: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
13: csr_person_id in ota_cert_enrollments.person_id%TYPE,
14: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS
15: SELECT DECODE(bst.type,'C','Z',bst.type) status,
16: evt.event_type,
17: tdb.DATE_STATUS_CHANGED,
18: evt.COURSE_START_DATE,

Line 53: FROM ota_cert_enrollments cre,

49: IS
50:
51: CURSOR csr_cert_enrl IS
52: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date
53: FROM ota_cert_enrollments cre,
54: ota_cert_prd_enrollments cpe
55: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
56: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
57:

Line 60: l_person_id ota_cert_enrollments.person_id%TYPE;

56: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
57:
58: l_proc VARCHAR2(72) := g_package|| 'get_enrl_status_on_update';
59:
60: l_person_id ota_cert_enrollments.person_id%TYPE;
61: l_contact_id ota_cert_enrollments.contact_id%TYPE;
62: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
63: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
64:

Line 61: l_contact_id ota_cert_enrollments.contact_id%TYPE;

57:
58: l_proc VARCHAR2(72) := g_package|| 'get_enrl_status_on_update';
59:
60: l_person_id ota_cert_enrollments.person_id%TYPE;
61: l_contact_id ota_cert_enrollments.contact_id%TYPE;
62: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
63: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
64:
65: l_enroll_status VARCHAR2(30);

Line 113: FROM ota_cert_enrollments cre,

109: IS
110:
111: CURSOR csr_cert_enrl IS
112: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date
113: FROM ota_cert_enrollments cre,
114: ota_cert_prd_enrollments cpe
115: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
116: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
117:

Line 120: l_person_id ota_cert_enrollments.person_id%TYPE;

116: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
117:
118: l_proc VARCHAR2(72) := g_package|| 'calculate_cme_status';
119:
120: l_person_id ota_cert_enrollments.person_id%TYPE;
121: l_contact_id ota_cert_enrollments.contact_id%TYPE;
122: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
123: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
124:

Line 121: l_contact_id ota_cert_enrollments.contact_id%TYPE;

117:
118: l_proc VARCHAR2(72) := g_package|| 'calculate_cme_status';
119:
120: l_person_id ota_cert_enrollments.person_id%TYPE;
121: l_contact_id ota_cert_enrollments.contact_id%TYPE;
122: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%type;
123: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_start_date%type;
124:
125: l_enroll_status VARCHAR2(30);

Line 212: p_person_id IN ota_cert_enrollments.person_id%TYPE,

208: -- ---------------------------------------------------------------------------
209: -- |----------------------< update_cme_status >-------------------|
210: -- ---------------------------------------------------------------------------
211: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,
212: p_person_id IN ota_cert_enrollments.person_id%TYPE,
213: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,
214: p_cert_prd_enrollment_ids OUT NOCOPY varchar2)
215: IS
216:

Line 213: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,

209: -- |----------------------< update_cme_status >-------------------|
210: -- ---------------------------------------------------------------------------
211: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,
212: p_person_id IN ota_cert_enrollments.person_id%TYPE,
213: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,
214: p_cert_prd_enrollment_ids OUT NOCOPY varchar2)
215: IS
216:
217: l_proc VARCHAR2(72) := g_package|| 'update_cme_status';

Line 239: ota_cert_enrollments cre

235: cme.member_status_code
236: FROM ota_certification_members cmb,
237: ota_cert_mbr_enrollments cme,
238: ota_cert_prd_enrollments cpe,
239: ota_cert_enrollments cre
240: WHERE
241: cre.cert_enrollment_id = cpe.cert_enrollment_id
242: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
243: AND cme.cert_member_id = cmb.certification_member_id

Line 361: FROM ota_cert_enrollments cre,

357: SELECT cre.certification_id,
358: cpe.cert_enrollment_id,
359: cpe.cert_prd_enrollment_id,
360: cpe.period_status_code
361: FROM ota_cert_enrollments cre,
362: ota_cert_prd_enrollments cpe,
363: ota_cert_mbr_enrollments cme
364: WHERE cre.cert_enrollment_id = cpe.cert_enrollment_id
365: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id

Line 386: FROM ota_cert_enrollments cre

382:
383: CURSOR csr_cre_update(csr_cert_enrollment_id number)
384: IS
385: SELECT cre.object_version_number
386: FROM ota_cert_enrollments cre
387: where cre.cert_enrollment_id = csr_cert_enrollment_id;
388:
389:
390: -- l_exists ota_cert_prd_enrollments.cert_mbr_enrollment_id%TYPE;

Line 391: cre_object_version_number ota_cert_enrollments.object_version_number%type;

387: where cre.cert_enrollment_id = csr_cert_enrollment_id;
388:
389:
390: -- l_exists ota_cert_prd_enrollments.cert_mbr_enrollment_id%TYPE;
391: cre_object_version_number ota_cert_enrollments.object_version_number%type;
392: cpe_object_version_number ota_cert_prd_enrollments.object_version_number%type;
393: l_period_status_code ota_cert_prd_enrollments.period_status_code%TYPE;
394: l_certification_status_code ota_cert_enrollments.certification_status_code%TYPE;
395: l_chk_cert_prd_compl varchar2(1);

Line 394: l_certification_status_code ota_cert_enrollments.certification_status_code%TYPE;

390: -- l_exists ota_cert_prd_enrollments.cert_mbr_enrollment_id%TYPE;
391: cre_object_version_number ota_cert_enrollments.object_version_number%type;
392: cpe_object_version_number ota_cert_prd_enrollments.object_version_number%type;
393: l_period_status_code ota_cert_prd_enrollments.period_status_code%TYPE;
394: l_certification_status_code ota_cert_enrollments.certification_status_code%TYPE;
395: l_chk_cert_prd_compl varchar2(1);
396: l_completion_date date;
397: */
398: rec_cpe_status csr_cpe_status%rowtype;

Line 400: l_certification_status_code ota_cert_enrollments.certification_status_code%TYPE;

396: l_completion_date date;
397: */
398: rec_cpe_status csr_cpe_status%rowtype;
399: l_period_status_code ota_cert_prd_enrollments.period_status_code%TYPE;
400: l_certification_status_code ota_cert_enrollments.certification_status_code%TYPE;
401:
402: l_proc VARCHAR2(72) := g_package|| 'Update_cpe_status';
403:
404: l_child_update_flag varchar2(1) := 'N';

Line 570: FROM ota_cert_enrollments cre,

566: CURSOR csr_cpe IS
567: select
568: cre.certification_id,
569: cpe.business_group_id
570: FROM ota_cert_enrollments cre,
571: ota_cert_prd_enrollments cpe,
572: ota_certifications_b crt
573: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
574: and cre.certification_id = crt.certification_id

Line 781: ota_cert_enrollments cre,

777: ota_events_tl et,
778: ota_activity_versions a,
779: ota_delegate_bookings b,
780: ota_booking_status_types_VL s,
781: ota_cert_enrollments cre,
782: ota_cert_prd_enrollments cpe,
783: ota_cert_mbr_enrollments cme,
784: ota_certification_members cmb,
785: ota_offerings ofr,