APPS.IGS_EN_GEN_011 dependencies on IGS_LOOKUP_VALUES

Line 1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;

1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;

Line 1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;

1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;
1317: l_person_number IGS_PE_PERSON.person_number%TYPE;

Line 1391: CURSOR c_enroll(cp_code igs_lookup_values.lookup_code%TYPE) IS

1387: OR NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N')
1388: ORDER BY sca.person_id,
1389: sca.course_cd
1390: FOR UPDATE NOWAIT;
1391: CURSOR c_enroll(cp_code igs_lookup_values.lookup_code%TYPE) IS
1392: SELECT meaning
1393: FROM igs_lookup_values v1
1394: WHERE v1.lookup_Type = 'VS_EN_ACT_UNIT' AND
1395: v1.lookup_code=cp_code;

Line 1393: FROM igs_lookup_values v1

1389: sca.course_cd
1390: FOR UPDATE NOWAIT;
1391: CURSOR c_enroll(cp_code igs_lookup_values.lookup_code%TYPE) IS
1392: SELECT meaning
1393: FROM igs_lookup_values v1
1394: WHERE v1.lookup_Type = 'VS_EN_ACT_UNIT' AND
1395: v1.lookup_code=cp_code;
1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,