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_EVENT_ASSOCIATIONS

Line 65: ota_event_associations oea ,

61: BULK COLLECT INTO
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)

Line 208: ota_event_associations oea ,

204: BULK COLLECT INTO
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)

Line 539: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,

535: END learner_is_notSelected_inCert;
536:
537:
538:
539: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
540: p_organization_id IN ota_event_associations.organization_id%type,
541: p_person_id IN per_people_f.person_id%type)
542: RETURN VARCHAR2 IS
543:

Line 540: p_organization_id IN ota_event_associations.organization_id%type,

536:
537:
538:
539: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
540: p_organization_id IN ota_event_associations.organization_id%type,
541: p_person_id IN per_people_f.person_id%type)
542: RETURN VARCHAR2 IS
543:
544: /* CURSOR csr_lrnr_belongs_to_org IS

Line 827: p_person_id ota_event_associations.person_id%type,

823: );
824: lrnr_rec learner_rec;
825:
826: CURSOR csr_get_learner(
827: p_person_id ota_event_associations.person_id%type,
828: p_event_id ota_event_associations.event_id%type,
829: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
830: p_event_start_date date,
831: p_future_enddated_prof_val varchar2,

Line 828: p_event_id ota_event_associations.event_id%type,

824: lrnr_rec learner_rec;
825:
826: CURSOR csr_get_learner(
827: p_person_id ota_event_associations.person_id%type,
828: p_event_id ota_event_associations.event_id%type,
829: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
830: p_event_start_date date,
831: p_future_enddated_prof_val varchar2,
832: p_per_bg_grp_prof_val number,

Line 829: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

825:
826: CURSOR csr_get_learner(
827: p_person_id ota_event_associations.person_id%type,
828: p_event_id ota_event_associations.event_id%type,
829: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
830: p_event_start_date date,
831: p_future_enddated_prof_val varchar2,
832: p_per_bg_grp_prof_val number,
833: p_ota_global_bg_prof_val number

Line 879: p_organization_id ota_event_associations.organization_id%type,

875:
876:
877:
878: CURSOR csr_get_learners(
879: p_organization_id ota_event_associations.organization_id%type,
880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,

Line 880: p_job_id ota_event_associations.job_id%type,

876:
877:
878: CURSOR csr_get_learners(
879: p_organization_id ota_event_associations.organization_id%type,
880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,
884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

Line 881: p_position_id ota_event_associations.position_id%type,

877:
878: CURSOR csr_get_learners(
879: p_organization_id ota_event_associations.organization_id%type,
880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,
884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
885: p_event_start_date date,

Line 882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,

878: CURSOR csr_get_learners(
879: p_organization_id ota_event_associations.organization_id%type,
880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,
884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
885: p_event_start_date date,
886: p_future_enddated_prof_val varchar2,

Line 883: p_event_id ota_event_associations.event_id%type,

879: p_organization_id ota_event_associations.organization_id%type,
880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,
884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
885: p_event_start_date date,
886: p_future_enddated_prof_val varchar2,
887: p_per_bg_grp_prof_val number,

Line 884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

880: p_job_id ota_event_associations.job_id%type,
881: p_position_id ota_event_associations.position_id%type,
882: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
883: p_event_id ota_event_associations.event_id%type,
884: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
885: p_event_start_date date,
886: p_future_enddated_prof_val varchar2,
887: p_per_bg_grp_prof_val number,
888: p_ota_global_bg_prof_val number

Line 1210: p_person_id ota_event_associations.person_id%type,

1206: );
1207: lrnr_rec learner_rec;
1208:
1209: CURSOR csr_get_learner(
1210: p_person_id ota_event_associations.person_id%type,
1211: p_event_id ota_event_associations.event_id%type,
1212: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1213: p_event_start_date date,
1214: p_future_enddated_prof_val varchar2,

Line 1211: p_event_id ota_event_associations.event_id%type,

1207: lrnr_rec learner_rec;
1208:
1209: CURSOR csr_get_learner(
1210: p_person_id ota_event_associations.person_id%type,
1211: p_event_id ota_event_associations.event_id%type,
1212: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1213: p_event_start_date date,
1214: p_future_enddated_prof_val varchar2,
1215: p_per_bg_grp_prof_val number,

Line 1212: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

1208:
1209: CURSOR csr_get_learner(
1210: p_person_id ota_event_associations.person_id%type,
1211: p_event_id ota_event_associations.event_id%type,
1212: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1213: p_event_start_date date,
1214: p_future_enddated_prof_val varchar2,
1215: p_per_bg_grp_prof_val number,
1216: p_ota_global_bg_prof_val number

Line 1262: p_organization_id ota_event_associations.organization_id%type,

1258:
1259:
1260:
1261: CURSOR csr_get_learners(
1262: p_organization_id ota_event_associations.organization_id%type,
1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,

Line 1263: p_job_id ota_event_associations.job_id%type,

1259:
1260:
1261: CURSOR csr_get_learners(
1262: p_organization_id ota_event_associations.organization_id%type,
1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,
1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

Line 1264: p_position_id ota_event_associations.position_id%type,

1260:
1261: CURSOR csr_get_learners(
1262: p_organization_id ota_event_associations.organization_id%type,
1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,
1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1268: p_event_start_date date,

Line 1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,

1261: CURSOR csr_get_learners(
1262: p_organization_id ota_event_associations.organization_id%type,
1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,
1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1268: p_event_start_date date,
1269: p_future_enddated_prof_val varchar2,

Line 1266: p_event_id ota_event_associations.event_id%type,

1262: p_organization_id ota_event_associations.organization_id%type,
1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,
1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1268: p_event_start_date date,
1269: p_future_enddated_prof_val varchar2,
1270: p_per_bg_grp_prof_val number,

Line 1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

1263: p_job_id ota_event_associations.job_id%type,
1264: p_position_id ota_event_associations.position_id%type,
1265: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
1266: p_event_id ota_event_associations.event_id%type,
1267: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
1268: p_event_start_date date,
1269: p_future_enddated_prof_val varchar2,
1270: p_per_bg_grp_prof_val number,
1271: p_ota_global_bg_prof_val number

Line 2295: ota_event_associations oea ,

2291: BULK COLLECT INTO
2292: 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,
2293: l_rec.org_structure_version_id,l_rec.user_group_id,l_rec.requestor_id,l_rec.certification_id
2294: FROM
2295: ota_event_associations oea ,
2296: ota_certifications_b cert
2297: WHERE oea.certification_id = cert.certification_id
2298: AND oea.MANDATORY_ENROLLMENT_FLAG = 'Y'
2299: AND trunc(sysdate) BETWEEN trunc(cert.start_date_active) and nvl(cert.end_date_active, trunc(sysdate))

Line 2408: p_person_id ota_event_associations.person_id%type,

2404: );
2405: lrnr_rec learner_rec;
2406:
2407: CURSOR csr_get_learner(
2408: p_person_id ota_event_associations.person_id%type,
2409: p_per_bg_grp_prof_val number,
2410: p_ota_global_bg_prof_val number
2411: ) IS
2412: SELECT ppf.person_id

Line 2446: p_organization_id ota_event_associations.organization_id%type,

2442:
2443:
2444:
2445: CURSOR csr_get_learners(
2446: p_organization_id ota_event_associations.organization_id%type,
2447: p_job_id ota_event_associations.job_id%type,
2448: p_position_id ota_event_associations.position_id%type,
2449: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
2450: p_per_bg_grp_prof_val number,

Line 2447: p_job_id ota_event_associations.job_id%type,

2443:
2444:
2445: CURSOR csr_get_learners(
2446: p_organization_id ota_event_associations.organization_id%type,
2447: p_job_id ota_event_associations.job_id%type,
2448: p_position_id ota_event_associations.position_id%type,
2449: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
2450: p_per_bg_grp_prof_val number,
2451: p_ota_global_bg_prof_val number

Line 2448: p_position_id ota_event_associations.position_id%type,

2444:
2445: CURSOR csr_get_learners(
2446: p_organization_id ota_event_associations.organization_id%type,
2447: p_job_id ota_event_associations.job_id%type,
2448: p_position_id ota_event_associations.position_id%type,
2449: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
2450: p_per_bg_grp_prof_val number,
2451: p_ota_global_bg_prof_val number
2452: ) IS

Line 2449: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,

2445: CURSOR csr_get_learners(
2446: p_organization_id ota_event_associations.organization_id%type,
2447: p_job_id ota_event_associations.job_id%type,
2448: p_position_id ota_event_associations.position_id%type,
2449: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
2450: p_per_bg_grp_prof_val number,
2451: p_ota_global_bg_prof_val number
2452: ) IS
2453: SELECT ppf.person_id