DBA Data[Home] [Help]

APPS.IGS_EN_CAREER_MODEL dependencies on IGS_EN_GEN_006

Line 306: -- by igs_en_gen_006.enrp_get_sca_status.

302: OPEN c_exst_primary_rank(v_course_type);
303: FETCH c_exst_primary_rank INTO v_exst_primary_rank ,v_exst_key_program;
304: IF c_exst_primary_rank%NOTFOUND THEN
305: -- this will over-ride the course attempt status calculated
306: -- by igs_en_gen_006.enrp_get_sca_status.
307: -- it is important to maintain the order in which this procedure
308: -- and igs_en_gen_006.enrp_get_sca_status. are called
309: -- the call to the igs_en_gen_006.enrp_get_sca_status. should be
310: -- first in the order

Line 308: -- and igs_en_gen_006.enrp_get_sca_status. are called

304: IF c_exst_primary_rank%NOTFOUND THEN
305: -- this will over-ride the course attempt status calculated
306: -- by igs_en_gen_006.enrp_get_sca_status.
307: -- it is important to maintain the order in which this procedure
308: -- and igs_en_gen_006.enrp_get_sca_status. are called
309: -- the call to the igs_en_gen_006.enrp_get_sca_status. should be
310: -- first in the order
311: -- If the secondary program is active then recalculate its program attempt status depending on the
312: -- primary programs status

Line 309: -- the call to the igs_en_gen_006.enrp_get_sca_status. should be

305: -- this will over-ride the course attempt status calculated
306: -- by igs_en_gen_006.enrp_get_sca_status.
307: -- it is important to maintain the order in which this procedure
308: -- and igs_en_gen_006.enrp_get_sca_status. are called
309: -- the call to the igs_en_gen_006.enrp_get_sca_status. should be
310: -- first in the order
311: -- If the secondary program is active then recalculate its program attempt status depending on the
312: -- primary programs status
313: IF p_new_course_attempt_status IN ('INACTIVE','ENROLLED','LAPSED','INTERMIT') THEN

Line 321: l_new_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(p_person_id ,

317: p_primary_program_type ,
318: p_primary_prog_type_source,
319: v_course_type );
320: IF l_new_course_attempt_status IS NULL THEN
321: l_new_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(p_person_id ,
322: p_course_cd,
323: null,null,null,null,null,null);
324: END IF;
325:

Line 494: v_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(c_person_id ,

490: v_sca_upd_rec.primary_prog_type_source,
491: v_course_type ,
492: c_course_cd );
493: IF v_course_attempt_status IS NULL THEN
494: v_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(c_person_id ,
495: v_sca_upd_rec.course_cd,
496: null,null,null,null,null,null);
497: END IF;
498:

Line 522: v_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(c_person_id ,

518: v_sca_upd_rec.primary_prog_type_source,
519: v_course_type ,
520: c_course_cd );
521: IF v_course_attempt_status IS NULL THEN
522: v_course_attempt_status := IGS_EN_GEN_006.ENRP_GET_SCA_STATUS(c_person_id ,
523: v_sca_upd_rec.course_cd,
524: null,null,null,null,null,null);
525: END IF;
526: