APPS.OTA_CPR_UTILITY dependencies on OTA_ACTIVITY_VERSIONS

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

28: p_level_id in per_competence_elements.proficiency_level_id%type
29: ) RETURN varchar2;
30:
31: FUNCTION check_learner_comp_step_values
32: (p_act_ver_id in ota_activity_versions.activity_version_id%type,
33: p_comp_id in per_competence_elements.competence_id%type,
34: p_level_id in per_competence_elements.proficiency_level_id%type
35: ) RETURN varchar2;
36:

Line 42: p_act_ver_id in ota_activity_versions.activity_version_id%type

38: (p_person_id in per_all_people_f.person_id%type,
39: p_delegate_contact_id in NUMBER,
40: p_user_id in NUMBER,
41: p_user_type in ota_attempts.user_type%type,
42: p_act_ver_id in ota_activity_versions.activity_version_id%type
43: ) RETURN varchar2;
44:
45: FUNCTION is_mandatory_prereqs_completed
46: (p_person_id in per_all_people_f.person_id%type,

Line 50: p_act_ver_id in ota_activity_versions.activity_version_id%type

46: (p_person_id in per_all_people_f.person_id%type,
47: p_delegate_contact_id in NUMBER,
48: p_user_id in NUMBER,
49: p_user_type in ota_attempts.user_type%type,
50: p_act_ver_id in ota_activity_versions.activity_version_id%type
51: ) RETURN varchar2;
52:
53: FUNCTION is_advisory_prereqs_completed
54: (p_person_id in per_all_people_f.person_id%type,

Line 58: p_act_ver_id in ota_activity_versions.activity_version_id%type

54: (p_person_id in per_all_people_f.person_id%type,
55: p_delegate_contact_id in NUMBER,
56: p_user_id in NUMBER,
57: p_user_type in ota_attempts.user_type%type,
58: p_act_ver_id in ota_activity_versions.activity_version_id%type
59: ) RETURN varchar2;
60:
61: FUNCTION get_enroll_image
62: (p_person_id in per_all_people_f.person_id%type,

Line 80: p_act_ver_id in ota_activity_versions.activity_version_id%type

76: (p_person_id in per_all_people_f.person_id%type,
77: p_delegate_contact_id in NUMBER,
78: p_user_id in NUMBER,
79: p_user_type in ota_attempts.user_type%type,
80: p_act_ver_id in ota_activity_versions.activity_version_id%type
81: ) RETURN varchar2;
82:
83: FUNCTION is_mand_comp_prereqs_completed
84: (p_person_id in per_all_people_f.person_id%type,

Line 85: p_act_ver_id in ota_activity_versions.activity_version_id%type

81: ) RETURN varchar2;
82:
83: FUNCTION is_mand_comp_prereqs_completed
84: (p_person_id in per_all_people_f.person_id%type,
85: p_act_ver_id in ota_activity_versions.activity_version_id%type
86: ) RETURN varchar2;
87:
88:
89: FUNCTION get_prereq_met_count

Line 91: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

87:
88:
89: FUNCTION get_prereq_met_count
90: (p_event_id in ota_events.event_id%type,
91: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
92: p_comp_id in per_competence_elements.competence_id%type,
93: p_level_id in per_competence_elements.proficiency_level_id%type
94: ) RETURN varchar2;
95:

Line 98: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,

94: ) RETURN varchar2;
95:
96: FUNCTION get_prereq_not_met_count
97: (p_event_id in ota_events.event_id%type,
98: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
99: p_comp_id in per_competence_elements.competence_id%type,
100: p_level_id in per_competence_elements.proficiency_level_id%type
101: ) RETURN varchar2;
102: