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_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 146: l_date ota_events.course_end_date%type;

142: and fcr.STATUS_CODE = 'R' and nvl(PARENT_REQUEST_ID,-1) = -1
143: and fcr.REQUEST_ID <> c_conc_req_id;
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;

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 209: ota_events evt

205: 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,
206: l_rec.org_structure_version_id,l_rec.user_group_id,l_rec.requestor_id
207: FROM
208: ota_event_associations oea ,
209: ota_events evt
210: WHERE oea.event_id = evt.event_id
211: AND oea.MANDATORY_ENROLLMENT_FLAG = 'Y'
212: AND ota_timezone_util.convert_date(trunc(sysdate),to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code , evt.timezone)
213: BETWEEN decode(evt.enrolment_start_date, NULL, to_date('0001/01/01','YYYY/MM/DD'),

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

375:
376:
377: FUNCTION learner_is_notSelected_inClass(p_person_id IN per_all_people_f.person_id%type
378: ,p_assignment_id per_all_assignments_f.assignment_id%type
379: ,p_event_id IN ota_events.event_id%type)
380: RETURN Boolean IS
381:
382: CURSOR lrnr_already_selected IS
383: SELECT assignment_id

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

426: END learner_is_notSelected_inClass;
427:
428: FUNCTION lrn_is_notSelected_inClass_mul(p_person_id IN per_all_people_f.person_id%type
429: ,p_assignment_id per_all_assignments_f.assignment_id%type
430: ,p_event_id IN ota_events.event_id%type)
431: RETURN Boolean IS
432:
433: CURSOR lrnr_already_selected IS
434: SELECT assignment_id

Line 614: req_event_id IN ota_events.event_id%type,

610:
611:
612: PROCEDURE create_request_member_record(l_person_id IN ota_mandatory_enr_req_members.person_id%type,
613: req_mandatory_enr_request_id IN ota_mandatory_enr_req_members.mandatory_enr_request_id%type,
614: req_event_id IN ota_events.event_id%type,
615: req_enr_prereq_type IN varchar2,
616: lrnr_completed_crs_prereq ota_mandatory_enr_req_members.completed_course_prereq%type,
617: lrnr_completed_comp_prereq ota_mandatory_enr_req_members.completed_competence_prereq%type,
618: l_numberof_records_processed IN OUT NOCOPY NUMBER) IS

Line 706: req_event_id IN ota_events.event_id%type,

702: end create_request_member_record;
703:
704: PROCEDURE create_request_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,
705: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,
706: req_event_id IN ota_events.event_id%type,
707: req_enr_prereq_type IN varchar2,
708: lrnr_completed_crs_prereq OTA_MAND_MULTI_ENR_REQ_MEMBERS.completed_course_prereq%type,
709: lrnr_completed_comp_prereq OTA_MAND_MULTI_ENR_REQ_MEMBERS.completed_competence_prereq%type,
710: l_numberof_records_processed IN OUT NOCOPY NUMBER,

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:

Line 2244: l_date ota_events.course_end_date%type;

2240: certification_id dbms_sql.number_table
2241: );
2242:
2243: l_rec auto_cert_subscr_rec;
2244: l_date ota_events.course_end_date%type;
2245: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;
2246: l_cert_name ota_certifications_tl.name%type;
2247: l_chunk_size number := nvl(p_chunk_size,1000);
2248: l_threads number := nvl(p_thread_count,3);