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_CPR_UTILITY dependencies on OTA_ACTIVITY_VERSIONS

Line 78: (p_act_ver_id in ota_activity_versions.activity_version_id%type,

74: End is_competency_acheived;
75:
76:
77: FUNCTION check_learner_comp_step_values
78: (p_act_ver_id in ota_activity_versions.activity_version_id%type,
79: p_comp_id in per_competence_elements.competence_id%type,
80: p_level_id in per_competence_elements.proficiency_level_id%type
81: ) RETURN varchar2 is
82:

Line 209: p_act_ver_id in ota_activity_versions.activity_version_id%type

205: (p_person_id in per_all_people_f.person_id%type,
206: p_delegate_contact_id in NUMBER,
207: p_user_id in NUMBER,
208: p_user_type in ota_attempts.user_type%type,
209: p_act_ver_id in ota_activity_versions.activity_version_id%type
210: ) RETURN varchar2 is
211:
212: Cursor c_get_classes is
213: SELECT

Line 218: ota_activity_versions OAV,

214: oev.event_id,
215: OCU.online_flag,
216: OFR.learning_object_id
217: FROM
218: ota_activity_versions OAV,
219: ota_offerings OFR,
220: ota_events OEV,
221: ota_category_usages OCU
222: WHERE

Line 274: p_act_ver_id in ota_activity_versions.activity_version_id%type

270: (p_person_id in per_all_people_f.person_id%type,
271: p_delegate_contact_id in NUMBER,
272: p_user_id in NUMBER,
273: p_user_type in ota_attempts.user_type%type,
274: p_act_ver_id in ota_activity_versions.activity_version_id%type
275: ) RETURN varchar2 is
276: -- Bug 13035257
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: select ocp.prerequisite_course_id

Line 279: from ota_activity_versions oav,

275: ) RETURN varchar2 is
276: -- Bug 13035257
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: select ocp.prerequisite_course_id
279: from ota_activity_versions oav,
280: ota_course_prerequisites ocp
281: where ocp.activity_version_id = p_act_ver_id
282: and ocp.enforcement_mode in ('B', p_enforcement_mode)
283: and ocp.prerequisite_type = 'M'

Line 334: p_act_ver_id in ota_activity_versions.activity_version_id%type

330: (p_person_id in per_all_people_f.person_id%type,
331: p_delegate_contact_id in NUMBER,
332: p_user_id in NUMBER,
333: p_user_type in ota_attempts.user_type%type,
334: p_act_ver_id in ota_activity_versions.activity_version_id%type
335: ) RETURN varchar2 is
336:
337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
338: select ocp.prerequisite_course_id

Line 339: from ota_activity_versions oav,

335: ) RETURN varchar2 is
336:
337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
338: select ocp.prerequisite_course_id
339: from ota_activity_versions oav,
340: ota_course_prerequisites ocp
341: where ocp.activity_version_id = p_act_ver_id
342: and ocp.enforcement_mode in ('B', p_enforcement_mode)
343: and ocp.prerequisite_type = 'A'

Line 405: l_act_ver_id ota_activity_versions.activity_version_id%type;

401:
402: l_enroll_image varchar2(20);
403: l_enrollment_status varchar2(1);
404: l_prereq_completed_status varchar2(1);
405: l_act_ver_id ota_activity_versions.activity_version_id%type;
406: Begin
407: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, p_event_id, 1);
408: If ( l_enrollment_status = 'P' or l_enrollment_status = 'W' or l_enrollment_status = 'R' or l_enrollment_status = 'A') Then --Bug 4518920
409: l_enroll_image := 'AE'; -- Already enrolled

Line 463: l_act_ver_id ota_activity_versions.activity_version_id%type;

459:
460: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
461: l_user_id number;
462: l_user_type ota_attempts.user_type%type;
463: l_act_ver_id ota_activity_versions.activity_version_id%type;
464: l_prereq_completed_status varchar2(1);
465:
466: Begin
467: If ( p_delegate_contact_id is not null ) Then

Line 495: p_act_ver_id in ota_activity_versions.activity_version_id%type

491: (p_person_id in per_all_people_f.person_id%type,
492: p_delegate_contact_id in NUMBER,
493: p_user_id in NUMBER,
494: p_user_type in ota_attempts.user_type%type,
495: p_act_ver_id in ota_activity_versions.activity_version_id%type
496: ) RETURN varchar2
497: IS
498:
499: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

Line 529: p_act_ver_id in ota_activity_versions.activity_version_id%type

525: END is_mand_crs_prereqs_completed;
526:
527: FUNCTION is_mand_comp_prereqs_completed
528: (p_person_id in per_all_people_f.person_id%type,
529: p_act_ver_id in ota_activity_versions.activity_version_id%type
530: ) RETURN varchar2
531: IS
532: Cursor c_get_mandatory_competencies is
533: SELECT cpe.competence_id,

Line 557: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type

553:
554: Function Get_course_prereq_count
555: (p_prereq_met varchar2
556: ,p_event_id in ota_events.event_id%type
557: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type
558: ) Return varchar2 is
559: --
560: --
561: Cursor c_course_prereq_status is

Line 637: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

633: End Get_comp_prereq_count;
634:
635: FUNCTION get_prereq_met_count
636: (p_event_id in ota_events.event_id%type,
637: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
638: p_comp_id in per_competence_elements.competence_id%type,
639: p_level_id in per_competence_elements.proficiency_level_id%type
640: ) RETURN varchar2 is
641: --

Line 673: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

669:
670:
671: FUNCTION get_prereq_not_met_count
672: (p_event_id in ota_events.event_id%type,
673: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
674: p_comp_id in per_competence_elements.competence_id%type,
675: p_level_id in per_competence_elements.proficiency_level_id%type
676: ) RETURN varchar2 is
677:

Line 717: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

713: SELECT activity_version_id
714: FROM ota_events
715: WHERE event_id = p_event_id;
716:
717: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
718:
719: BEGIN
720: OPEN csr_get_course_id;
721: FETCH csr_get_course_id INTO l_activity_version_id;

Line 741: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

737: SELECT activity_version_id
738: FROM ota_events
739: WHERE event_id = p_event_id;
740:
741: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
742:
743: BEGIN
744: OPEN csr_get_course_id;
745: FETCH csr_get_course_id INTO l_activity_version_id;

Line 839: (p_act_ver_id in ota_activity_versions.activity_version_id%type,

835: -- whose end date are greater than the given pre-req course.
836: --
837: -- Added for the bug 13035257
838: FUNCTION get_all_dependent_courses
839: (p_act_ver_id in ota_activity_versions.activity_version_id%type,
840: p_pre_req_crs_end_date varchar2) RETURN varchar2 is
841: --
842: cursor get_dependent_courses(p_act_ver_id in ota_attempts.user_type%type,
843: p_pre_req_crs_end_date date) is

Line 850: from ota_activity_versions oav,

846: ocp.enforcement_mode Enforcement_Mode,
847: ocp.activity_version_id Activity_Version_Id,
848: ocp.activity_version_id Dependant_Course_Id,
849: ocp.business_group_id Business_Group_Id
850: from ota_activity_versions oav,
851: ota_activity_versions_tl oavt,
852: ota_course_prerequisites ocp
853: where ocp.activity_version_id = oav.activity_version_id
854: and oav.activity_version_id = oavt.activity_version_id

Line 851: ota_activity_versions_tl oavt,

847: ocp.activity_version_id Activity_Version_Id,
848: ocp.activity_version_id Dependant_Course_Id,
849: ocp.business_group_id Business_Group_Id
850: from ota_activity_versions oav,
851: ota_activity_versions_tl oavt,
852: ota_course_prerequisites ocp
853: where ocp.activity_version_id = oav.activity_version_id
854: and oav.activity_version_id = oavt.activity_version_id
855: and oavt.language = userenv('LANG')