APPS.OTA_CPR_UTILITY dependencies on PER_COMPETENCE_ELEMENTS

Line 27: p_comp_id in per_competence_elements.competence_id%type,

23: -- {End of Comments}
24: ------------------------------------------------------------------
25: FUNCTION is_competency_acheived
26: (p_person_id in per_all_people_f.person_id%type,
27: p_comp_id in per_competence_elements.competence_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

Line 28: p_level_id in per_competence_elements.proficiency_level_id%type

24: ------------------------------------------------------------------
25: FUNCTION is_competency_acheived
26: (p_person_id in per_all_people_f.person_id%type,
27: p_comp_id in per_competence_elements.competence_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,

Line 33: p_comp_id in per_competence_elements.competence_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:
37: FUNCTION is_course_completed

Line 34: p_level_id in per_competence_elements.proficiency_level_id%type

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:
37: FUNCTION is_course_completed
38: (p_person_id in per_all_people_f.person_id%type,

Line 92: p_comp_id in per_competence_elements.competence_id%type,

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:
96: FUNCTION get_prereq_not_met_count

Line 93: p_level_id in per_competence_elements.proficiency_level_id%type

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:
96: FUNCTION get_prereq_not_met_count
97: (p_event_id in ota_events.event_id%type,

Line 99: p_comp_id in per_competence_elements.competence_id%type,

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:
103: FUNCTION is_mand_comp_prereqs_comp_evt

Line 100: p_level_id in per_competence_elements.proficiency_level_id%type

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:
103: FUNCTION is_mand_comp_prereqs_comp_evt
104: (p_person_id in per_all_people_f.person_id%type,