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.8 2005/12/27 01:20 rdola noship $ */
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.8 2005/12/27 01:20 rdola noship $ */
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 557: ota_cpr_utility.is_course_completed

553: --
554: --
555: Cursor c_course_prereq_status is
556: select
557: ota_cpr_utility.is_course_completed
558: (odb.delegate_person_id
559: ,odb.delegate_contact_id
560: ,nvl(odb.delegate_person_id,odb.delegate_contact_id)
561: ,decode(odb.delegate_person_id,null,'C', 'E')

Line 600: ota_cpr_utility.is_competency_acheived

596: --
597: --
598: Cursor c_comp_prereq_status is
599: select
600: ota_cpr_utility.is_competency_acheived
601: (odb.delegate_person_id
602: ,p_comp_id
603: ,p_level_id
604: ) prereq_met

Line 823: end ota_cpr_utility;

819: return l_flag;
820: hr_utility.set_location(' Leaving:'|| l_proc, 10);
821: End is_valid_classes_available;
822: --
823: end ota_cpr_utility;