APPS.OTA_CPR_UTILITY dependencies on OTA_CPR_UTILITY

Line 1: package body ota_cpr_utility as

1: package body ota_cpr_utility as
2: /* $Header: otcprutl.pkb 120.11 2011/12/02 12:03:52 jaysridh ship $ */
3:
4: g_package varchar2(33) := ' ota_cpr_utility.'; -- Global package name
5:

Line 4: g_package varchar2(33) := ' ota_cpr_utility.'; -- Global package name

1: package body ota_cpr_utility as
2: /* $Header: otcprutl.pkb 120.11 2011/12/02 12:03:52 jaysridh ship $ */
3:
4: g_package varchar2(33) := ' ota_cpr_utility.'; -- Global package name
5:
6: FUNCTION is_competency_acheived
7: (p_person_id in per_all_people_f.person_id%type,
8: p_comp_id in per_competence_elements.competence_id%type,

Line 563: ota_cpr_utility.is_course_completed

559: --
560: --
561: Cursor c_course_prereq_status is
562: select
563: ota_cpr_utility.is_course_completed
564: (odb.delegate_person_id
565: ,odb.delegate_contact_id
566: ,nvl(odb.delegate_person_id,odb.delegate_contact_id)
567: ,decode(odb.delegate_person_id,null,'C', 'E')

Line 606: ota_cpr_utility.is_competency_acheived

602: --
603: --
604: Cursor c_comp_prereq_status is
605: select
606: ota_cpr_utility.is_competency_acheived
607: (odb.delegate_person_id
608: ,p_comp_id
609: ,p_level_id
610: ) prereq_met

Line 874: end ota_cpr_utility;

870: End Loop;
871: return l_depend_course_names;
872: End get_all_dependent_courses;
873: --
874: end ota_cpr_utility;