[Home] [Help]
852:
853: -- Get the Competences Linked to a Course
854: cursor csr_get_course_compts(p_course_id number) is
855: select pce.competence_id
856: from per_competence_elements pce
857: where pce.type = 'DELIVERY'
858: and pce.activity_version_id = p_course_id
859: and pce.business_group_id = g_bg_id;
860:
860:
861: -- Get the Competences Linked to a Learning Path
862: cursor csr_get_lp_compts(p_lp_id number) is
863: select pce.competence_id
864: from per_competence_elements pce
865: where pce.type = 'OTA_LEARNING_PATH'
866: and pce.object_id = p_lp_id
867: and pce.business_group_id = g_bg_id;
868:
868:
869: -- Get the Competences Linked to a Certification
870: cursor csr_get_cert_compts(p_cert_id number) is
871: select pce.competence_id
872: from per_competence_elements pce
873: where pce.type = 'OTA_CERTIFICATION'
874: and pce.object_id = p_cert_id
875: and pce.business_group_id = g_bg_id;
876:
896: -- Exists cursors
897: --
898: cursor csr_exists_course_compts(p_course_id number) is
899: select count(pce.competence_id)
900: from per_competence_elements pce
901: where pce.type = 'DELIVERY'
902: and pce.activity_version_id = p_course_id
903: and pce.business_group_id = g_bg_id;
904: --
2996: --
2997: -- Get the Competences Linked to a Course
2998: cursor csr_get_course_compts(p_course_id number) is
2999: select pce.competence_id ,pc.name
3000: from per_competence_elements pce
3001: , per_competences pc
3002: where pce.type = 'DELIVERY'
3003: and pce.activity_version_id = p_course_id
3004: and pce.business_group_id = g_bg_id
3006: --
3007: -- Get the Competences Linked to a Learning Path
3008: cursor csr_get_lp_compts(p_lp_id number) is
3009: select pce.competence_id,pc.name
3010: from per_competence_elements pce
3011: , per_competences pc
3012: where pce.type = 'OTA_LEARNING_PATH'
3013: and pce.object_id = p_lp_id
3014: and pce.business_group_id = g_bg_id
3016: --
3017: -- Get the Competences Linked to a Certification
3018: cursor csr_get_cert_compts(p_cert_id number) is
3019: select pce.competence_id,pc.name
3020: from per_competence_elements pce
3021: , per_competences pc
3022: where pce.type = 'OTA_CERTIFICATION'
3023: and pce.object_id = p_cert_id
3024: and pce.business_group_id = g_bg_id
3046: -- Exists cursors
3047: --
3048: cursor csr_exists_course_compts(p_course_id number) is
3049: select count(pce.competence_id)
3050: from per_competence_elements pce
3051: where pce.type = 'DELIVERY'
3052: and pce.activity_version_id = p_course_id
3053: and pce.business_group_id = g_bg_id;
3054: --
3053: and pce.business_group_id = g_bg_id;
3054: --
3055: cursor csr_exists_lp_compts(p_lp_id number) is
3056: select count(pce.competence_id)
3057: from per_competence_elements pce
3058: where pce.type = 'OTA_LEARNING_PATH'
3059: and pce.object_id = p_lp_id
3060: and pce.business_group_id = g_bg_id;
3061: --
3069: and olps.learning_path_section_id = olpm.learning_path_section_id;
3070: --
3071: cursor csr_exists_cert_compts(p_cert_id number) is
3072: select count(pce.competence_id)
3073: from per_competence_elements pce
3074: where pce.type = 'OTA_CERTIFICATION'
3075: and pce.object_id = p_cert_id
3076: and pce.business_group_id = g_bg_id;
3077: --
3580: -- Competencies
3581: cursor csr_atr_competency(p_person_id number) is
3582: select pc.competence_id, pc.name , pce.achieved_date , pce.status
3583: from per_competences pc
3584: , per_competence_elements pce
3585: where pce.person_id = p_person_id
3586: and pce.competence_id = pc.competence_id
3587: and pce.effective_date_from between g_atr_start_date and g_atr_end_date
3588: and pce.type = 'PERSONAL';