APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_EVENTS

Line 27: l_date ota_events.course_end_date%type;

23: requestor_id dbms_sql.number_table
24: );
25:
26: l_rec mandatory_event_assoc_rec;
27: l_date ota_events.course_end_date%type;
28: l_conc_request_id ota_mandatory_enr_requests.conc_program_request_id%type;
29: l_event_title ota_events_tl.title%type;
30: l_proc varchar2(72) := g_package||'process_mandatory_event_assoc';
31:

Line 29: l_event_title ota_events_tl.title%type;

25:
26: l_rec mandatory_event_assoc_rec;
27: l_date ota_events.course_end_date%type;
28: l_conc_request_id ota_mandatory_enr_requests.conc_program_request_id%type;
29: l_event_title ota_events_tl.title%type;
30: l_proc varchar2(72) := g_package||'process_mandatory_event_assoc';
31:
32:
33: BEGIN

Line 66: ota_events evt

62: l_rec.enr_prereq_type,l_rec.event_id,l_rec.person_id,l_rec.organization_id,l_rec.job_id,l_rec.position_id,
63: l_rec.org_structure_version_id,l_rec.user_group_id,l_rec.requestor_id
64: FROM
65: ota_event_associations oea ,
66: ota_events evt
67: WHERE oea.event_id = evt.event_id
68: AND oea.MANDATORY_ENROLLMENT_FLAG = 'Y'
69: AND ota_timezone_util.convert_date(trunc(sysdate),to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code , evt.timezone)
70: BETWEEN decode(evt.enrolment_start_date, NULL, to_date('0001/01/01','YYYY/MM/DD'),

Line 171: ,p_event_id IN ota_events.event_id%type)

167:
168:
169: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type
170: ,p_assignment_id per_all_assignments_f.assignment_id%type
171: ,p_event_id IN ota_events.event_id%type)
172: RETURN Boolean IS
173:
174: CURSOR lrnr_already_selected IS
175: SELECT assignment_id

Line 274: req_event_id IN ota_events.event_id%type,

270:
271:
272: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
273: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
274: req_event_id IN ota_events.event_id%type,
275: req_enr_prereq_type IN varchar2,
276: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
277: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
278: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS

Line 654: l_class_name ota_events_tl.title%type;

650:
651: l_cost_center_info csr_get_cost_center_info%rowtype;
652:
653: l_person_name per_all_people_f.full_name%type;
654: l_class_name ota_events_tl.title%type;
655: l_proc varchar2(72) := g_package||'create_enrollments';
656:
657: BEGIN
658: