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_CPE_UTIL dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 31: ota_cert_mbr_enrollments cme,

27: from
28: ota_activity_versions tav,
29: ota_cert_enrollments cre,
30: ota_cert_prd_enrollments cpe,
31: ota_cert_mbr_enrollments cme,
32: ota_certification_members cmb,
33: ota_events evt
34:
35: where evt.event_id = p_event_id

Line 99: ota_cert_mbr_enrollments cme,

95: FROM
96: ota_activity_versions tav,
97: -- ota_cert_enrollments cre,
98: ota_cert_prd_enrollments cpe,
99: ota_cert_mbr_enrollments cme,
100: ota_certification_members cmb
101:
102: WHERE
103: cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id

Line 187: from ota_cert_mbr_enrollments cme

183: IS
184:
185: Cursor any_child is
186: Select cme.cert_mbr_enrollment_id
187: from ota_cert_mbr_enrollments cme
188: where member_status_code <> 'CANCELLED'
189: and member_status_code <> 'COMPLETED'
190: and cert_prd_enrollment_id = p_cert_prd_enrollment_id and rownum=1;
191:

Line 194: from ota_cert_mbr_enrollments cme

190: and cert_prd_enrollment_id = p_cert_prd_enrollment_id and rownum=1;
191:
192: Cursor one_child_completed is
193: Select cme.cert_mbr_enrollment_id
194: from ota_cert_mbr_enrollments cme
195: where member_status_code = 'COMPLETED'
196: and cert_prd_enrollment_id = p_cert_prd_enrollment_id and rownum=1;
197:
198: l_proc VARCHAR2(72) := g_package ||'chk_cert_prd_compl';

Line 238: from ota_cert_mbr_enrollments cme

234: IS
235:
236: Cursor csr_mbr_enrl is
237: Select cme.cert_mbr_enrollment_id
238: from ota_cert_mbr_enrollments cme
239: where member_status_code <> 'CANCELLED'
240: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
241:
242: Cursor one_child_active IS

Line 244: from ota_cert_mbr_enrollments cme

240: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
241:
242: Cursor one_child_active IS
243: Select cme.cert_mbr_enrollment_id
244: from ota_cert_mbr_enrollments cme
245: where member_status_code in ('ACTIVE', 'PENDING', 'COMPLETED') --10164130
246: and cert_prd_enrollment_id = p_cert_prd_enrollment_id and rownum=1;
247:
248: CURSOR csr_cert_enrl IS

Line 265: from ota_cert_mbr_enrollments cme

261: where cert_prd_enrollment_id = p_cert_prd_enrollment_id;
262:
263: Cursor get_mbr_completion_date is
264: Select min(cme.completion_date)
265: from ota_cert_mbr_enrollments cme
266: where member_status_code = 'COMPLETED'
267: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
268: l_proc varchar2(72) := g_package || ' update_cpe_status';
269:

Line 949: From ota_cert_mbr_enrollments

945:
946: Cursor get_cert_mbr_status is
947: Select member_status_code
948: ,ota_utility.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS', member_status_code, 810) member_status
949: From ota_cert_mbr_enrollments
950: where
951: cert_member_id = p_cert_mbr_id
952: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
953:

Line 954: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;

950: where
951: cert_member_id = p_cert_mbr_id
952: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
953:
954: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
955: l_member_status varchar2(240);
956:
957: Begin
958: Open get_cert_mbr_status;

Line 1266: from ota_cert_mbr_enrollments cme

1262: where cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
1263:
1264: Cursor one_child_active(l_cert_prd_enrollment_id in number) IS
1265: Select cme.cert_mbr_enrollment_id
1266: from ota_cert_mbr_enrollments cme
1267: where member_status_code in ('ACTIVE', 'PENDING', 'COMPLETED') --10164130
1268: and cert_prd_enrollment_id = l_cert_prd_enrollment_id and rownum=1;
1269:
1270: CURSOR csr_prd_enrl_count IS

Line 1277: from ota_cert_mbr_enrollments cme

1273: where cert_enrollment_id = p_cert_enrollment_id;
1274:
1275: Cursor get_mbr_completion_date(l_cert_prd_enrollment_id in number) is
1276: Select min(cme.completion_date)
1277: from ota_cert_mbr_enrollments cme
1278: where member_status_code = 'COMPLETED'
1279: and cert_prd_enrollment_id = l_cert_prd_enrollment_id;
1280: l_proc varchar2(72) := g_package || ' create_cpe_rec';
1281: l_cert_rec csr_cert_info%ROWTYPE;

Line 1448: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'

1444: l_attribute20 := NULL;
1445:
1446: ota_utility.Get_Default_Value_Dff(
1447: appl_short_name => 'OTA'
1448: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'
1449: ,p_attribute_category => l_attribute_category
1450: ,p_attribute1 => l_attribute1
1451: ,p_attribute2 => l_attribute2
1452: ,p_attribute3 => l_attribute3

Line 1660: DELETE FROM ota_cert_mbr_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;

1656: DELETE FROM ota_performances
1657: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1658:
1659: --delete cert mbr enrollments
1660: DELETE FROM ota_cert_mbr_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1661:
1662: --delete cert prd enrollments
1663: DELETE FROM ota_cert_prd_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1664:

Line 2025: from ota_cert_mbr_enrollments cme,

2021:
2022: is
2023: select cme.cert_mbr_enrollment_id,
2024: cmb.object_id
2025: from ota_cert_mbr_enrollments cme,
2026: ota_certification_members cmb
2027: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2028: and cme.cert_member_id = cmb.certification_member_id
2029: and object_type = 'H';

Line 2208: ota_cert_mbr_enrollments cme,

2204:
2205: CURSOR csr_chk_prds(l_activity_version_id number) IS
2206: SELECT null
2207: FROM ota_certification_members cmb,
2208: ota_cert_mbr_enrollments cme,
2209: ota_cert_prd_enrollments cpe,
2210: ota_cert_enrollments cre
2211: WHERE
2212: cre.cert_enrollment_id = cpe.cert_enrollment_id

Line 2354: FROM ota_cert_mbr_enrollments cme,

2350:
2351: CURSOR csr_course_info(p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is
2352: SELECT cme.cert_mbr_enrollment_id,
2353: cmb.object_id
2354: FROM ota_cert_mbr_enrollments cme,
2355: ota_certification_members cmb
2356: WHERE cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2357: AND cme.cert_member_id = cmb.certification_member_id
2358: AND object_type = 'H'