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:
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
278: SELECT cpr.prerequisite_course_id

Line 331: p_act_ver_id in ota_activity_versions.activity_version_id%type

327: (p_person_id in per_all_people_f.person_id%type,
328: p_delegate_contact_id in NUMBER,
329: p_user_id in NUMBER,
330: p_user_type in ota_attempts.user_type%type,
331: p_act_ver_id in ota_activity_versions.activity_version_id%type
332: ) RETURN varchar2 is
333:
334: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is
335: SELECT cpr.prerequisite_course_id

Line 399: l_act_ver_id ota_activity_versions.activity_version_id%type;

395:
396: l_enroll_image varchar2(20);
397: l_enrollment_status varchar2(1);
398: l_prereq_completed_status varchar2(1);
399: l_act_ver_id ota_activity_versions.activity_version_id%type;
400: Begin
401: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, p_event_id, 1);
402: If ( l_enrollment_status = 'P' or l_enrollment_status = 'W' or l_enrollment_status = 'R' or l_enrollment_status = 'A') Then --Bug 4518920
403: l_enroll_image := 'AE'; -- Already enrolled

Line 457: l_act_ver_id ota_activity_versions.activity_version_id%type;

453:
454: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
455: l_user_id number;
456: l_user_type ota_attempts.user_type%type;
457: l_act_ver_id ota_activity_versions.activity_version_id%type;
458: l_prereq_completed_status varchar2(1);
459:
460: Begin
461: If ( p_delegate_contact_id is not null ) Then

Line 489: p_act_ver_id in ota_activity_versions.activity_version_id%type

485: (p_person_id in per_all_people_f.person_id%type,
486: p_delegate_contact_id in NUMBER,
487: p_user_id in NUMBER,
488: p_user_type in ota_attempts.user_type%type,
489: p_act_ver_id in ota_activity_versions.activity_version_id%type
490: ) RETURN varchar2
491: IS
492:
493: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

Line 523: p_act_ver_id in ota_activity_versions.activity_version_id%type

519: END is_mand_crs_prereqs_completed;
520:
521: FUNCTION is_mand_comp_prereqs_completed
522: (p_person_id in per_all_people_f.person_id%type,
523: p_act_ver_id in ota_activity_versions.activity_version_id%type
524: ) RETURN varchar2
525: IS
526: Cursor c_get_mandatory_competencies is
527: SELECT cpe.competence_id,

Line 551: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type

547:
548: Function Get_course_prereq_count
549: (p_prereq_met varchar2
550: ,p_event_id in ota_events.event_id%type
551: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type
552: ) Return varchar2 is
553: --
554: --
555: Cursor c_course_prereq_status is

Line 631: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

627: End Get_comp_prereq_count;
628:
629: FUNCTION get_prereq_met_count
630: (p_event_id in ota_events.event_id%type,
631: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
632: p_comp_id in per_competence_elements.competence_id%type,
633: p_level_id in per_competence_elements.proficiency_level_id%type
634: ) RETURN varchar2 is
635: --

Line 667: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

663:
664:
665: FUNCTION get_prereq_not_met_count
666: (p_event_id in ota_events.event_id%type,
667: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
668: p_comp_id in per_competence_elements.competence_id%type,
669: p_level_id in per_competence_elements.proficiency_level_id%type
670: ) RETURN varchar2 is
671:

Line 711: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

707: SELECT activity_version_id
708: FROM ota_events
709: WHERE event_id = p_event_id;
710:
711: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
712:
713: BEGIN
714: OPEN csr_get_course_id;
715: FETCH csr_get_course_id INTO l_activity_version_id;

Line 735: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

731: SELECT activity_version_id
732: FROM ota_events
733: WHERE event_id = p_event_id;
734:
735: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
736:
737: BEGIN
738: OPEN csr_get_course_id;
739: FETCH csr_get_course_id INTO l_activity_version_id;