APPS.IGS_PR_CLASS_RANK dependencies on IGS_CA_INST

Line 44: p_cal_type igs_ca_inst.cal_type%TYPE;

40: || swaghmar 16-Jan-2006 Bug# 4951054 - Added check for disabling UI's
41: || (reverse chronological order - newest change first)
42: ****************************************************************************************************************/
43:
44: p_cal_type igs_ca_inst.cal_type%TYPE;
45: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
46: l_cumulative_ind VARCHAR2(1);
47: l_count1 NUMBER ;
48: l_count NUMBER;

Line 45: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

41: || (reverse chronological order - newest change first)
42: ****************************************************************************************************************/
43:
44: p_cal_type igs_ca_inst.cal_type%TYPE;
45: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
46: l_cumulative_ind VARCHAR2(1);
47: l_count1 NUMBER ;
48: l_count NUMBER;
49: l_rowid VARCHAR2(4000) DEFAULT NULL;

Line 438: FROM igs_ca_inst_rel

434:
435: CURSOR cur_acad_cal (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
436: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
437: SELECT sup_cal_type, sup_ci_sequence_number
438: FROM igs_ca_inst_rel
439: WHERE
440: sub_cal_type = cp_cal_type
441: AND sub_ci_sequence_number = cp_ci_sequence_number
442: AND sup_cal_type IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC') ;

Line 1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,

1222: FUNCTION get_cum_gpa
1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,
1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1228: p_stat_type IN VARCHAR2,
1229: p_cumulative_ind IN VARCHAR2
1230: ) RETURN NUMBER IS

Line 1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1223: ( p_person_id IN igs_en_sca_v.person_id%TYPE,
1224: p_course_cd IN igs_en_sca_v.course_cd%TYPE,
1225: p_cohort_name IN igs_pr_cohort.cohort_name%TYPE,
1226: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1227: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1228: p_stat_type IN VARCHAR2,
1229: p_cumulative_ind IN VARCHAR2
1230: ) RETURN NUMBER IS
1231: /****************************************************************************************************************