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_ENROLLMENTS

Line 29: ota_cert_enrollments cre,

25: cpe.cert_period_end_date,
26: cre.certification_id
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

Line 97: -- ota_cert_enrollments cre,

93: tav.activity_version_id
94:
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:

Line 253: FROM ota_cert_enrollments cre,

249: select cre.certification_status_code, cre.object_version_number, cre.completion_date,
250: cre.certification_id,
251: cre.person_id,
252: cre.expiration_date
253: FROM ota_cert_enrollments cre,
254: ota_cert_prd_enrollments cpe
255: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
256: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
257:

Line 277: l_certification_status_code ota_cert_enrollments.certification_status_code%type := 'ENROLLED';

273:
274: l_complete_cert_prd_ok VARCHAR2(30);
275: l_period_status_code VARCHAR2(30);
276: n_period_status_code VARCHAR2(30) := 'ENROLLED';
277: l_certification_status_code ota_cert_enrollments.certification_status_code%type := 'ENROLLED';
278:
279: l_object_version_number1 number;
280: l_object_version_number2 number;
281: l_object_version_number3 number;

Line 418: function is_period_renewable(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type)

414: raise;
415: end update_cpe_status;
416:
417:
418: function is_period_renewable(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type)
419: return varchar2 is
420:
421: CURSOR csr_crt IS
422: select

Line 428: ota_cert_enrollments cre

424: , b.RENEWABLE_FLAG
425: , b.INITIAL_COMPLETION_DURATION
426: , cre.expiration_date
427: from ota_certifications_b b,
428: ota_cert_enrollments cre
429: where cre.certification_id = b.certification_id
430: and cre.cert_enrollment_id = p_cert_enrollment_id;
431:
432: CURSOR csr_max_cpe_exp_dt IS

Line 436: ota_cert_enrollments cre

432: CURSOR csr_max_cpe_exp_dt IS
433: select
434: max(cpe.expiration_date)
435: from ota_cert_prd_enrollments cpe,
436: ota_cert_enrollments cre
437: where cpe.cert_enrollment_id = cre.cert_enrollment_id
438: and cre.cert_enrollment_id = p_cert_enrollment_id;
439:
440: CURSOR csr_dupl_prd(csr_expiration_date ota_cert_enrollments.expiration_date%type) is

Line 440: CURSOR csr_dupl_prd(csr_expiration_date ota_cert_enrollments.expiration_date%type) is

436: ota_cert_enrollments cre
437: where cpe.cert_enrollment_id = cre.cert_enrollment_id
438: and cre.cert_enrollment_id = p_cert_enrollment_id;
439:
440: CURSOR csr_dupl_prd(csr_expiration_date ota_cert_enrollments.expiration_date%type) is
441: select 'Y' as dupl_prd_exists
442: from ota_cert_enrollments
443: where cert_enrollment_id = p_cert_enrollment_id
444: and expiration_date = csr_expiration_date;

Line 442: from ota_cert_enrollments

438: and cre.cert_enrollment_id = p_cert_enrollment_id;
439:
440: CURSOR csr_dupl_prd(csr_expiration_date ota_cert_enrollments.expiration_date%type) is
441: select 'Y' as dupl_prd_exists
442: from ota_cert_enrollments
443: where cert_enrollment_id = p_cert_enrollment_id
444: and expiration_date = csr_expiration_date;
445:
446: l_proc VARCHAR2(72) := g_package||'is_period_renewable';

Line 448: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

444: and expiration_date = csr_expiration_date;
445:
446: l_proc VARCHAR2(72) := g_package||'is_period_renewable';
447:
448: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
449: l_expiration_date ota_cert_enrollments.expiration_date%type;
450: l_curr_dt date;
451: l_dupl_prd_exists varchar2(1) := 'N';
452:

Line 449: l_expiration_date ota_cert_enrollments.expiration_date%type;

445:
446: l_proc VARCHAR2(72) := g_package||'is_period_renewable';
447:
448: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
449: l_expiration_date ota_cert_enrollments.expiration_date%type;
450: l_curr_dt date;
451: l_dupl_prd_exists varchar2(1) := 'N';
452:
453: rec_crt csr_crt%rowtype;

Line 526: Function get_earl_enrl_dt(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

522: RETURN null;
523:
524: End is_period_renewable;
525:
526: Function get_earl_enrl_dt(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
527: p_expiration_date in ota_cert_enrollments.expiration_date%type)
528: return date
529: IS
530:

Line 527: p_expiration_date in ota_cert_enrollments.expiration_date%type)

523:
524: End is_period_renewable;
525:
526: Function get_earl_enrl_dt(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
527: p_expiration_date in ota_cert_enrollments.expiration_date%type)
528: return date
529: IS
530:
531: CURSOR csr_crt IS

Line 548: ota_cert_enrollments cre

544: , b.PUBLIC_FLAG
545: , b.START_DATE_ACTIVE
546: , b.END_DATE_ACTIVE
547: from ota_certifications_b b,
548: ota_cert_enrollments cre
549: where cre.certification_id = b.certification_id
550: and cre.cert_enrollment_id = p_cert_enrollment_id;
551:
552: l_proc VARCHAR2(72) := g_package||' get_earl_enrl_dt';

Line 555: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

551:
552: l_proc VARCHAR2(72) := g_package||' get_earl_enrl_dt';
553: rec_crt csr_crt%rowtype;
554:
555: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
556:
557:
558: BEGIN
559:

Line 607: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

603: RETURN NULL;
604:
605: end get_earl_enrl_dt;
606:
607: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
608: p_certification_id in ota_cert_enrollments.certification_id%type,
609: p_mode in varchar2,
610: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
611: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,

Line 608: p_certification_id in ota_cert_enrollments.certification_id%type,

604:
605: end get_earl_enrl_dt;
606:
607: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
608: p_certification_id in ota_cert_enrollments.certification_id%type,
609: p_mode in varchar2,
610: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
611: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
612: p_cert_period_start_date in date default sysdate)

Line 610: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,

606:
607: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
608: p_certification_id in ota_cert_enrollments.certification_id%type,
609: p_mode in varchar2,
610: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
611: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
612: p_cert_period_start_date in date default sysdate)
613: IS
614:

Line 611: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,

607: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
608: p_certification_id in ota_cert_enrollments.certification_id%type,
609: p_mode in varchar2,
610: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
611: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
612: p_cert_period_start_date in date default sysdate)
613: IS
614:
615: CURSOR csr_crt IS

Line 640: ota_cert_enrollments cre

636: select
637: cre.earliest_enroll_date
638: , cre.expiration_date
639: from ota_certifications_b b,
640: ota_cert_enrollments cre
641: where cre.certification_id = b.certification_id
642: and cre.cert_enrollment_id = p_cert_enrollment_id;
643:
644:

Line 649: ota_cert_enrollments cre

645: CURSOR csr_max_cpe_exp_dt IS
646: select
647: max(cpe.expiration_date)
648: from ota_cert_prd_enrollments cpe,
649: ota_cert_enrollments cre
650: where cpe.cert_enrollment_id = cre.cert_enrollment_id
651: and cre.cert_enrollment_id = p_cert_enrollment_id;
652:
653: l_proc VARCHAR2(72) := g_package||'calc_cre_dates';

Line 659: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

655: rec_cre csr_cre%rowtype;
656:
657: l_curr_dt date;
658:
659: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
660: l_expiration_date ota_cert_enrollments.expiration_date%type;
661: l_max_expiration_date date;
662:
663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

Line 660: l_expiration_date ota_cert_enrollments.expiration_date%type;

656:
657: l_curr_dt date;
658:
659: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
660: l_expiration_date ota_cert_enrollments.expiration_date%type;
661: l_max_expiration_date date;
662:
663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
664: l_next_expiration_date ota_cert_enrollments.expiration_date%type;

Line 663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

659: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
660: l_expiration_date ota_cert_enrollments.expiration_date%type;
661: l_max_expiration_date date;
662:
663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
664: l_next_expiration_date ota_cert_enrollments.expiration_date%type;
665:
666: BEGIN
667: hr_utility.set_location('Entering :'||l_proc,5);

Line 664: l_next_expiration_date ota_cert_enrollments.expiration_date%type;

660: l_expiration_date ota_cert_enrollments.expiration_date%type;
661: l_max_expiration_date date;
662:
663: l_next_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
664: l_next_expiration_date ota_cert_enrollments.expiration_date%type;
665:
666: BEGIN
667: hr_utility.set_location('Entering :'||l_proc,5);
668:

Line 824: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

820: p_expiration_date := null;
821: RAISE;
822: END calc_cre_dates;
823:
824: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
825: p_cert_period_start_date in date default sysdate )
826: return varchar2
827: IS
828:

Line 841: ota_cert_enrollments cre

837: , b.END_DATE_ACTIVE
838: , cre.expiration_date
839: , b.renewable_flag --Bug 4545407
840: from ota_certifications_b b,
841: ota_cert_enrollments cre
842: where cre.certification_id = b.certification_id
843: and cre.cert_enrollment_id = p_cert_enrollment_id;
844:
845:

Line 850: ota_cert_enrollments cre

846: CURSOR csr_max_cpe_exp_dt IS
847: select
848: max(cpe.expiration_date)
849: from ota_cert_prd_enrollments cpe,
850: ota_cert_enrollments cre
851: where cpe.cert_enrollment_id = cre.cert_enrollment_id
852: and cre.cert_enrollment_id = p_cert_enrollment_id;
853:
854: l_proc VARCHAR2(72) := g_package||' get_next_prd_dur_days';

Line 859: l_next_expiration_date ota_cert_enrollments.expiration_date%type;

855: rec_crt csr_crt%rowtype;
856:
857: l_curr_dt date;
858: l_prd_durn varchar2(10);
859: l_next_expiration_date ota_cert_enrollments.expiration_date%type;
860: l_max_expiration_date date;
861: l_due_date date;
862: l_elapsed_due_date date;
863:

Line 991: FUNCTION get_cre_status (p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

987:
988: return l_member_name;
989: End get_cert_mbr_name;
990:
991: FUNCTION get_cre_status (p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,
992: p_mode in varchar2 default 'm')
993: RETURN varchar2 is
994:
995: Cursor csr_cre_status is

Line 1003: From ota_cert_enrollments cre,

999: ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', cre.certification_status_code, 810) cre_status,
1000: crt.renewable_flag,
1001: cre.expiration_date,
1002: nvl(crt.end_date_active,to_date('4712/12/31','YYYY/MM/DD')) end_date_active
1003: From ota_cert_enrollments cre,
1004: ota_certifications_b crt
1005: where cre.cert_enrollment_id = p_cert_enrollment_id
1006: and crt.certification_id = cre.certification_id;
1007:

Line 1075: From ota_cert_enrollments cre,

1071:
1072: Cursor csr_cpe is
1073: Select
1074: get_cre_status(cre.cert_enrollment_id, 'c') certification_status_code
1075: From ota_cert_enrollments cre,
1076: ota_cert_prd_enrollments cpe
1077: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1078: and cre.cert_enrollment_id = cpe.cert_enrollment_id;
1079:

Line 1119: FROM ota_cert_enrollments cre,

1115: crt.renewable_flag,
1116: crt.initial_completion_duration,
1117: crt.validity_duration,
1118: crt.validity_start_type
1119: FROM ota_cert_enrollments cre,
1120: ota_cert_prd_enrollments cpe,
1121: ota_certifications_b crt
1122: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id
1123: and cre.certification_id = crt.certification_id

Line 1206: procedure create_cpe_rec(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

1202: return l_return_status;
1203:
1204: END chk_prd_end_date;
1205:
1206: procedure create_cpe_rec(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
1207: p_expiration_date in date,
1208: p_cert_period_start_date in date default sysdate,
1209: p_cert_prd_enrollment_id OUT NOCOPY ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1210: p_certification_status_code OUT NOCOPY VARCHAR2)

Line 1212: CURSOR csr_cert_info(p_certification_id in ota_cert_enrollments.certification_id%type) IS

1208: p_cert_period_start_date in date default sysdate,
1209: p_cert_prd_enrollment_id OUT NOCOPY ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1210: p_certification_status_code OUT NOCOPY VARCHAR2)
1211: IS
1212: CURSOR csr_cert_info(p_certification_id in ota_cert_enrollments.certification_id%type) IS
1213: select
1214: b.certification_id certification_id
1215: , b.INITIAL_COMPLETION_DATE
1216: , b.INITIAL_COMPLETION_DURATION

Line 1231: CURSOR csr_cert_mbr(p_certification_id in ota_cert_enrollments.certification_id%type) IS

1227: , b.END_DATE_ACTIVE
1228: from ota_certifications_b b
1229: where b.certification_id = p_certification_id;
1230:
1231: CURSOR csr_cert_mbr(p_certification_id in ota_cert_enrollments.certification_id%type) IS
1232: select
1233: cmb.CERTIFICATION_MEMBER_ID
1234: , cmb.CERTIFICATION_ID
1235: , cmb.OBJECT_ID

Line 1246: FROM ota_cert_enrollments

1242: and trunc(sysdate) between trunc(cmb.START_DATE_ACTIVE) and nvl(trunc(cmb.end_date_active), to_date('4712/12/31', 'YYYY/MM/DD'));
1243:
1244: CURSOR csr_cert_enrl IS
1245: select certification_id, cert_enrollment_id, business_group_id, certification_status_code, object_version_number, completion_date
1246: FROM ota_cert_enrollments
1247: where cert_enrollment_id = p_cert_enrollment_id;
1248:
1249: CURSOR csr_prd_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
1250: select period_status_code, object_version_number, completion_date

Line 1662: p_certification_status_code in ota_cert_enrollments.certification_status_code%type,

1658: END delete_prd_cascade;
1659:
1660: procedure update_admin_changes(p_cert_enrollment_id in ota_cert_prd_enrollments.cert_enrollment_id%type,
1661: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1662: p_certification_status_code in ota_cert_enrollments.certification_status_code%type,
1663: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null,
1664: p_return_status out NOCOPY VARCHAR2,
1665: p_cert_period_completion_date in ota_cert_prd_enrollments.completion_date%type default trunc(sysdate) ) is
1666:

Line 1672: FROM ota_cert_enrollments cre

1668: select cre.certification_status_code, cre.object_version_number, cre.completion_date,
1669: cre.certification_id,
1670: cre.person_id,
1671: cre.expiration_date
1672: FROM ota_cert_enrollments cre
1673: where cre.cert_enrollment_id = p_cert_enrollment_id;
1674:
1675: CURSOR csr_prd_enrl IS
1676: select period_status_code, object_version_number, completion_date, cert_enrollment_id, cert_period_start_date, cert_period_end_date

Line 1844: ,ota_cert_enrollments enr

1840: ,prd.period_status_code
1841: ,prd.cert_period_end_date
1842: ,prd.object_version_number
1843: From ota_certifications_vl ceb
1844: ,ota_cert_enrollments enr
1845: ,ota_cert_prd_enrollments prd
1846: Where
1847: ceb.certification_id = enr.certification_id
1848: and enr.cert_enrollment_id = prd.cert_enrollment_id

Line 1867: ,ota_cert_enrollments enr

1863: ,prd.cert_period_end_date
1864: ,ceb.initial_completion_date
1865: ,enr.object_version_number
1866: From ota_certifications_vl ceb
1867: ,ota_cert_enrollments enr
1868: ,ota_cert_prd_enrollments prd
1869: Where
1870: ceb.certification_id = enr.certification_id
1871: and enr.cert_enrollment_id = prd.cert_enrollment_id

Line 1976: ota_cert_enrollments cre

1972: select cpe.cert_prd_enrollment_id,
1973: cpe.period_status_code,
1974: cpe.cert_period_start_date
1975: from ota_cert_prd_enrollments cpe,
1976: ota_cert_enrollments cre
1977: where cpe.period_status_code not in ('COMPLETED', 'CANCELLED') and
1978: cpe.cert_enrollment_id = cre.cert_enrollment_id --bug#6338987
1979: order by cre.certification_id;
1980:

Line 2055: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

2051: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
2052: ||','||SUBSTR(SQLERRM, 1, 500));
2053: end sync_cert_status_to_class_enrl;
2054: --
2055: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,
2056: p_col_name in varchar2 default 'Period_Status_Meaning')
2057: RETURN varchar2 is
2058:
2059: Cursor csr_latest_cpe is

Line 2171: ota_cert_enrollments cre

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
2174: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
2175: AND cme.cert_member_id = cmb.certification_member_id

Line 2301: FROM ota_certifications_vl ocb, ota_cert_enrollments oce, ota_cert_prd_enrollments ocpe

2297: ocpe.cert_prd_enrollment_id,
2298: ocpe.cert_period_start_date,
2299: ocpe.cert_period_end_date,
2300: ocpe.expiration_date
2301: FROM ota_certifications_vl ocb, ota_cert_enrollments oce, ota_cert_prd_enrollments ocpe
2302: WHERE ocb.certification_id = oce.certification_id
2303: AND oce.cert_enrollment_id = ocpe.cert_enrollment_id
2304: AND trunc(SYSDATE) BETWEEN trunc(ocb.start_date_active) AND trunc(nvl(ocb.end_date_active, SYSDATE))
2305: AND ocb.renewable_flag = 'Y'

Line 2325: csr_person_id in ota_cert_enrollments.person_id%TYPE,

2321:
2322: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
2323: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
2324: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
2325: csr_person_id in ota_cert_enrollments.person_id%TYPE,
2326: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS
2327: SELECT DECODE(bst.type,'C','Z',bst.type) status,
2328: evt.event_type,
2329: tdb.DATE_STATUS_CHANGED,

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

2322: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
2323: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
2324: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
2325: csr_person_id in ota_cert_enrollments.person_id%TYPE,
2326: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS
2327: SELECT DECODE(bst.type,'C','Z',bst.type) status,
2328: evt.event_type,
2329: tdb.DATE_STATUS_CHANGED,
2330: evt.COURSE_START_DATE,

Line 2356: CURSOR csr_cert_enrl(p_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type) IS

2352: OR (csr_contact_id IS NOT NULL AND tdb.delegate_contact_id = csr_contact_id)
2353: )
2354: order by status;
2355:
2356: CURSOR csr_cert_enrl(p_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type) IS
2357: SELECT certification_id,
2358: cert_enrollment_id,
2359: business_group_id,
2360: certification_status_code,

Line 2364: FROM ota_cert_enrollments

2360: certification_status_code,
2361: object_version_number,
2362: completion_date,
2363: earliest_enroll_date
2364: FROM ota_cert_enrollments
2365: WHERE cert_enrollment_id = p_cert_enrollment_id;
2366:
2367: CURSOR csr_prd_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
2368: select cert_enrollment_id, cert_prd_enrollment_id, period_status_code, object_version_number, completion_date

Line 2379: l_cert_completion_date ota_cert_enrollments.completion_date%type;

2375: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
2376:
2377: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE;
2378: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE;
2379: l_cert_completion_date ota_cert_enrollments.completion_date%type;
2380: l_cert_prd_completion_date ota_cert_prd_enrollments.completion_date%type;
2381: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
2382: l_expiration_date ota_cert_prd_enrollments.expiration_date%type;
2383:

Line 2381: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;

2377: l_cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE;
2378: l_cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE;
2379: l_cert_completion_date ota_cert_enrollments.completion_date%type;
2380: l_cert_prd_completion_date ota_cert_prd_enrollments.completion_date%type;
2381: l_earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%type;
2382: l_expiration_date ota_cert_prd_enrollments.expiration_date%type;
2383:
2384: begin
2385: