APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_EVENTS_TL

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 148: l_event_title ota_events_tl.title%type;

144:
145: l_rec mandatory_event_assoc_rec;
146: l_date ota_events.course_end_date%type;
147: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;
148: l_event_title ota_events_tl.title%type;
149: l_request_id number;
150: l_person_name per_all_people_f.full_name%type;
151: l_mand_multi_conc_exist number;
152: l_chunk_size number := nvl(p_chunk_size,1000);

Line 1770: l_class_name ota_events_tl.title%type;

1766:
1767: l_cost_center_info csr_get_cost_center_info%rowtype;
1768:
1769: l_person_name per_all_people_f.full_name%type;
1770: l_class_name ota_events_tl.title%type;
1771: l_proc varchar2(72) := g_package||'create_enrollments';
1772:
1773: BEGIN
1774:

Line 1930: l_class_name ota_events_tl.title%type;

1926:
1927: l_cost_center_info csr_get_cost_center_info%rowtype;
1928:
1929: l_person_name per_all_people_f.full_name%type;
1930: l_class_name ota_events_tl.title%type;
1931: l_proc varchar2(72) := g_package||'create_enrollments_multi';
1932:
1933: BEGIN
1934: