[Home] [Help]
11: -- |----------------------< crt_comp_upd_succ_att >-----------------------------|
12: -- ---------------------------------------------------------------------------
13: --
14:
15: Procedure crt_comp_upd_succ_att(p_event_id in ota_events.event_id%type,
16: p_person_id in number
17: )
18: is
19:
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
36: and evt.activity_version_id = tav.activity_version_id
37: AND cmb.object_id = tav.activity_version_id
112:
113: Cursor Csr_Crt_mbr_cls_status(p_act_version_id ota_activity_versions.activity_version_id%Type
114: ) is
115: Select tdb.successful_attendance_flag
116: From ota_events evt,ota_delegate_bookings tdb,ota_booking_status_types bst
117: Where
118: evt.activity_version_id = p_act_version_id
119: and tdb.event_id = evt.event_id
120: and tdb.booking_status_type_id = bst.booking_status_type_id
2142: hr_utility.set_location('Leaving :'||l_proc,15);
2143: RETURN NULL;
2144: end get_elapsed_due_date;
2145:
2146: function check_active_periods(p_event_id ota_events.event_id%type) return varchar2
2147: is
2148: cursor csr_onl_sync_flag is
2149: select csu.online_flag,
2150: csu.synchronous_flag,
2150: csu.synchronous_flag,
2151: ofr.offering_id
2152: from ota_category_usages csu,
2153: ota_offerings ofr,
2154: ota_events evt
2155: where evt.event_id = p_event_id
2156: and evt.parent_offering_id = ofr.offering_id
2157: and ofr.delivery_mode_id = csu.category_usage_id;
2158:
2328: evt.event_type,
2329: tdb.DATE_STATUS_CHANGED,
2330: evt.COURSE_START_DATE,
2331: evt.COURSE_END_DATE
2332: FROM ota_events evt,
2333: ota_delegate_bookings tdb,
2334: ota_booking_status_types bst
2335: WHERE evt.event_id = tdb.event_id
2336: AND bst.booking_status_type_id = tdb.booking_status_type_id