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', 'COMPLETED')
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 941: From ota_cert_mbr_enrollments

937:
938: Cursor get_cert_mbr_status is
939: Select member_status_code
940: ,ota_utility.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS', member_status_code, 810) member_status
941: From ota_cert_mbr_enrollments
942: where
943: cert_member_id = p_cert_mbr_id
944: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
945:

Line 946: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;

942: where
943: cert_member_id = p_cert_mbr_id
944: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;
945:
946: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
947: l_member_status varchar2(240);
948:
949: Begin
950: Open get_cert_mbr_status;

Line 1256: from ota_cert_mbr_enrollments cme

1252: where cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
1253:
1254: Cursor one_child_active(l_cert_prd_enrollment_id in number) IS
1255: Select cme.cert_mbr_enrollment_id
1256: from ota_cert_mbr_enrollments cme
1257: where member_status_code in ('ACTIVE', 'COMPLETED')
1258: and cert_prd_enrollment_id = l_cert_prd_enrollment_id and rownum=1;
1259:
1260: CURSOR csr_prd_enrl_count IS

Line 1267: from ota_cert_mbr_enrollments cme

1263: where cert_enrollment_id = p_cert_enrollment_id;
1264:
1265: Cursor get_mbr_completion_date(l_cert_prd_enrollment_id in number) is
1266: Select min(cme.completion_date)
1267: from ota_cert_mbr_enrollments cme
1268: where member_status_code = 'COMPLETED'
1269: and cert_prd_enrollment_id = l_cert_prd_enrollment_id;
1270: l_proc varchar2(72) := g_package || ' create_cpe_rec';
1271: l_cert_rec csr_cert_info%ROWTYPE;

Line 1437: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'

1433: l_attribute20 := NULL;
1434:
1435: ota_utility.Get_Default_Value_Dff(
1436: appl_short_name => 'OTA'
1437: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'
1438: ,p_attribute_category => l_attribute_category
1439: ,p_attribute1 => l_attribute1
1440: ,p_attribute2 => l_attribute2
1441: ,p_attribute3 => l_attribute3

Line 1646: DELETE FROM ota_cert_mbr_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;

1642: DELETE FROM ota_performances
1643: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1644:
1645: --delete cert mbr enrollments
1646: DELETE FROM ota_cert_mbr_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1647:
1648: --delete cert prd enrollments
1649: DELETE FROM ota_cert_prd_enrollments where cert_prd_enrollment_id = p_cert_prd_enrollment_id;
1650:

Line 1986: from ota_cert_mbr_enrollments cme,

1982:
1983: is
1984: select cme.cert_mbr_enrollment_id,
1985: cmb.object_id
1986: from ota_cert_mbr_enrollments cme,
1987: ota_certification_members cmb
1988: where cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1989: and cme.cert_member_id = cmb.certification_member_id
1990: and object_type = 'H';

Line 2169: ota_cert_mbr_enrollments cme,

2165:
2166: CURSOR csr_chk_prds(l_activity_version_id number) IS
2167: SELECT null
2168: FROM ota_certification_members cmb,
2169: ota_cert_mbr_enrollments cme,
2170: ota_cert_prd_enrollments cpe,
2171: ota_cert_enrollments cre
2172: WHERE
2173: cre.cert_enrollment_id = cpe.cert_enrollment_id

Line 2315: FROM ota_cert_mbr_enrollments cme,

2311:
2312: CURSOR csr_course_info(p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is
2313: SELECT cme.cert_mbr_enrollment_id,
2314: cmb.object_id
2315: FROM ota_cert_mbr_enrollments cme,
2316: ota_certification_members cmb
2317: WHERE cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
2318: AND cme.cert_member_id = cmb.certification_member_id
2319: AND object_type = 'H'