APPS.OTA_TRNG_PLAN_COMP_SS dependencies on OTA_EVENTS

Line 16: PROCEDURE update_tpc_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,

12: -- |----------------------< update_tpc_enroll_status_chg >--------------------------|
13: -- ---------------------------------------------------------------------------
14: --
15:
16: PROCEDURE update_tpc_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
17: p_person_id IN ota_training_plans.person_id%TYPE,
18: -- Modified for Bug#3479186
19: p_contact_id IN ota_training_plans.contact_id%TYPE,
20: p_learning_path_ids OUT NOCOPY varchar2)

Line 54: FROM ota_events

50: SELECT activity_version_id,
51: course_start_date,
52: course_end_date,
53: event_type
54: FROM ota_events
55: WHERE event_id = p_event_id;
56:
57:
58:

Line 180: PROCEDURE update_tpc_evt_change (p_event_id IN ota_Events.event_id%TYPE,

176: -- |----------------------< update_tpc_evt_change >--------------------------|
177: -- ---------------------------------------------------------------------------
178: --
179: --checkes component status on change of enrollment status
180: PROCEDURE update_tpc_evt_change (p_event_id IN ota_Events.event_id%TYPE,
181: p_course_start_date IN ota_events.course_start_date%TYPE,
182: p_course_end_date IN ota_events.course_end_date%TYPE)
183: IS
184: /* Commented out for bug#5086156

Line 181: p_course_start_date IN ota_events.course_start_date%TYPE,

177: -- ---------------------------------------------------------------------------
178: --
179: --checkes component status on change of enrollment status
180: PROCEDURE update_tpc_evt_change (p_event_id IN ota_Events.event_id%TYPE,
181: p_course_start_date IN ota_events.course_start_date%TYPE,
182: p_course_end_date IN ota_events.course_end_date%TYPE)
183: IS
184: /* Commented out for bug#5086156
185: CURSOR csr_tpm IS

Line 182: p_course_end_date IN ota_events.course_end_date%TYPE)

178: --
179: --checkes component status on change of enrollment status
180: PROCEDURE update_tpc_evt_change (p_event_id IN ota_Events.event_id%TYPE,
181: p_course_start_date IN ota_events.course_start_date%TYPE,
182: p_course_end_date IN ota_events.course_end_date%TYPE)
183: IS
184: /* Commented out for bug#5086156
185: CURSOR csr_tpm IS
186: SELECT tpm.training_plan_member_id,

Line 193: ota_events oe,

189: tp.contact_id,
190: tpm.object_version_number
191: FROM ota_training_plans tp,
192: ota_training_plan_members tpm,
193: ota_events oe,
194: ota_delegate_bookings odb,
195: ota_booking_status_types bst
196: WHERE oe.event_id = odb.event_id
197: AND odb.booking_status_type_id=bst.booking_status_type_id