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 221: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,

217:
218: END learner_is_notSelected;
219:
220:
221: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
222: p_organization_id IN ota_event_associations.organization_id%type,
223: p_person_id IN per_people_f.person_id%type)
224: RETURN VARCHAR2 IS
225:

Line 222: p_organization_id IN ota_event_associations.organization_id%type,

218: END learner_is_notSelected;
219:
220:
221: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
222: p_organization_id IN ota_event_associations.organization_id%type,
223: p_person_id IN per_people_f.person_id%type)
224: RETURN VARCHAR2 IS
225:
226: CURSOR csr_lrnr_belongs_to_org IS

Line 385: p_person_id ota_event_associations.person_id%type,

381: );
382: lrnr_rec learner_rec;
383:
384: CURSOR csr_get_learners(
385: p_person_id ota_event_associations.person_id%type,
386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,

Line 386: p_organization_id ota_event_associations.organization_id%type,

382: lrnr_rec learner_rec;
383:
384: CURSOR csr_get_learners(
385: p_person_id ota_event_associations.person_id%type,
386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,

Line 387: p_job_id ota_event_associations.job_id%type,

383:
384: CURSOR csr_get_learners(
385: p_person_id ota_event_associations.person_id%type,
386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,
391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

Line 388: p_position_id ota_event_associations.position_id%type,

384: CURSOR csr_get_learners(
385: p_person_id ota_event_associations.person_id%type,
386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,
391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
392: p_event_start_date date

Line 389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,

385: p_person_id ota_event_associations.person_id%type,
386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,
391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
392: p_event_start_date date
393: ) IS

Line 390: p_event_id ota_event_associations.event_id%type,

386: p_organization_id ota_event_associations.organization_id%type,
387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,
391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
392: p_event_start_date date
393: ) IS
394: SELECT ppf.person_id

Line 391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,

387: p_job_id ota_event_associations.job_id%type,
388: p_position_id ota_event_associations.position_id%type,
389: p_org_structure_version_id ota_event_associations. org_structure_version_id%type,
390: p_event_id ota_event_associations.event_id%type,
391: p_enr_prereq_type ota_event_associations.mandatory_enrollment_prereq%type,
392: p_event_start_date date
393: ) IS
394: SELECT ppf.person_id
395: , pjt.job_id Job_Id