APPS.IGS_PR_GEN_002 dependencies on IGS_PR_GEN_001

Line 324: IGS_PR_GEN_001.prgp_get_cal_stream (

320: WHERE cat.cal_type = ci1.cal_type AND
321: cat.s_cal_cat = cst_progress AND
322: cs.cal_status = ci1.cal_status AND
323: cs.s_cal_status = cst_active AND
324: IGS_PR_GEN_001.prgp_get_cal_stream (
325: p_course_cd,
326: cp_version_number,
327: p_prg_cal_type,
328: ci1.cal_type)

Line 370: IF IGS_PR_GEN_001.prgp_get_msr_efctv (

366: FOR v_cat_ci_rec IN c_cat_ci (
367: v_version_number) LOOP
368: v_enrolled_in_prg_period := TRUE;
369: -- Determine if the student is effectively enrolled in the progression period
370: IF IGS_PR_GEN_001.prgp_get_msr_efctv (
371: v_cat_ci_rec.cal_type,
372: v_cat_ci_rec.sequence_number,
373: p_person_id,
374: p_course_cd) = 'N' THEN

Line 513: IGS_PR_GEN_001.prgp_get_cal_stream (

509: ci1.cal_type = cir.sup_cal_type AND
510: ci1.sequence_number = cir.sup_ci_sequence_number AND
511: cs.cal_status = ci1.cal_status AND
512: cs.s_cal_status = cst_active AND
513: IGS_PR_GEN_001.prgp_get_cal_stream (
514: p_course_cd,
515: cp_sca_version_number,
516: p_prg_cal_type,
517: cir.sup_cal_type) = 'Y' AND

Line 539: IGS_PR_GEN_001.prgp_get_cal_stream (

535: ci1.cal_type = cir.sup_cal_type AND
536: ci1.sequence_number = cir.sup_ci_sequence_number AND
537: cs.cal_status = ci1.cal_status AND
538: cs.s_cal_status = cst_active AND
539: IGS_PR_GEN_001.prgp_get_cal_stream (
540: p_course_cd,
541: cp_sca_version_number,
542: p_prg_cal_type,
543: cir.sup_cal_type) = 'Y' AND

Line 627: v_previous_cutoff_dt := IGS_PR_GEN_001.prgp_get_prg_efctv(

623: v_prev_prg_cal_type,
624: v_prev_prg_ci_sequence_number;
625: IF c_ci_cir_ct_cs1%FOUND THEN
626: CLOSE c_ci_cir_ct_cs1;
627: v_previous_cutoff_dt := IGS_PR_GEN_001.prgp_get_prg_efctv(
628: v_prev_prg_cal_type,
629: v_prev_prg_ci_sequence_number);
630: ELSE
631: CLOSE c_ci_cir_ct_cs1;

Line 653: v_cutoff_dt := IGS_PR_GEN_001.prgp_get_prg_efctv(

649: v_sca_version_number);
650: FETCH c_ci_cir_ct_cs2 INTO v_dummy;
651: IF c_ci_cir_ct_cs2%FOUND THEN
652: CLOSE c_ci_cir_ct_cs2;
653: v_cutoff_dt := IGS_PR_GEN_001.prgp_get_prg_efctv(
654: p_prg_cal_type,
655: p_prg_ci_sequence_number);
656: IF v_discontinued_dt IS NULL THEN
657: IF v_unit_attempt_status = cst_enrolled AND