APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHINST_RANK

Line 676: igs_pr_cohinst_rank_pkg.update_row (

672:
673: --
674: -- Updating the Cohert Instance rank table with the recent ranking and the GPA value as of now. Rest of the values are retained.
675: --
676: igs_pr_cohinst_rank_pkg.update_row (
677: x_rowid => cohort_inst_person_rec.row_id ,
678: x_cohort_name => cohort_inst_person_rec.cohort_name,
679: x_load_cal_type => cohort_inst_person_rec.load_cal_type ,
680: x_load_ci_sequence_number => cohort_inst_person_rec.load_ci_sequence_number ,

Line 740: igs_pr_cohinst_rank_pkg.update_row (

736: --
737: -- Updating the Cohert Instance rank table with the recent ranking and the GPA value as of now. Rest of the values are retained.
738: --
739:
740: igs_pr_cohinst_rank_pkg.update_row (
741: x_rowid => cohort_inst_person_rec.row_id ,
742: x_cohort_name => cohort_inst_person_rec.cohort_name,
743: x_load_cal_type => cohort_inst_person_rec.load_cal_type ,
744: x_load_ci_sequence_number => cohort_inst_person_rec.load_ci_sequence_number ,

Line 934: igs_pr_cohinst_rank_pkg.update_row (

930:
931: l_old_flag := 'N';
932:
933:
934: igs_pr_cohinst_rank_pkg.update_row (
935: x_rowid => l_old_population_table_rec(i).p_rowid ,
936: x_cohort_name => l_old_population_table_rec(i).p_cohort_name,
937: x_load_cal_type => l_old_population_table_rec(i).p_load_cal_type ,
938: x_load_ci_sequence_number => l_old_population_table_rec(i).p_load_ci_sequence_number ,

Line 965: igs_pr_cohinst_rank_pkg.insert_row (

961:
962:
963: IF l_old_flag = 'Y' THEN
964:
965: igs_pr_cohinst_rank_pkg.insert_row (
966: x_rowid => l_rowid ,
967: x_cohort_name => l_new_population_table_rec(l_new_count).p_cohort_name ,
968: x_load_cal_type => l_new_population_table_rec(l_new_count).p_load_cal_type ,
969: x_load_ci_sequence_number => l_new_population_table_rec(l_new_count).p_load_ci_sequence_number,

Line 1002: igs_pr_cohinst_rank_pkg.delete_row (

998: FOR j IN 1..l_old_count LOOP
999:
1000: IF l_old_population_table_rec(j).p_deletion_indicator = 'Y' THEN
1001:
1002: igs_pr_cohinst_rank_pkg.delete_row (
1003: x_rowid => l_old_population_table_rec(j).p_rowid
1004: );
1005:
1006: END IF;

Line 1114: igs_pr_cohinst_rank_pkg.update_row (

1110:
1111:
1112: l_old_flag := 'N';
1113:
1114: igs_pr_cohinst_rank_pkg.update_row (
1115: x_rowid => l_old_population_table_rec(i).p_rowid ,
1116: x_cohort_name => l_old_population_table_rec(i).p_cohort_name,
1117: x_load_cal_type => l_old_population_table_rec(i).p_load_cal_type ,
1118: x_load_ci_sequence_number => l_old_population_table_rec(i).p_load_ci_sequence_number ,

Line 1142: igs_pr_cohinst_rank_pkg.insert_row (

1138:
1139: END LOOP;
1140:
1141: IF l_old_flag = 'Y' THEN
1142: igs_pr_cohinst_rank_pkg.insert_row (
1143: x_rowid => l_rowid ,
1144: x_cohort_name => l_new_population_table_rec(l_new_count).p_cohort_name ,
1145: x_load_cal_type => l_new_population_table_rec(l_new_count).p_load_cal_type ,
1146: x_load_ci_sequence_number => l_new_population_table_rec(l_new_count).p_load_ci_sequence_number,

Line 1182: igs_pr_cohinst_rank_pkg.delete_row (

1178: FOR j IN 1..l_old_count LOOP
1179:
1180: IF l_old_population_table_rec(j).p_deletion_indicator = 'Y' THEN
1181:
1182: igs_pr_cohinst_rank_pkg.delete_row (
1183: x_rowid => l_old_population_table_rec(j).p_rowid
1184: );
1185:
1186: END IF;

Line 1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,

1528: -- cursor to select the rank
1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)
1535: FROM igs_pr_cohort_inst_rank_v cohirv
1536: WHERE cohirv.cohort_name = cp_cohort_name

Line 1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS

1529: CURSOR c_rank (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1530: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)
1535: FROM igs_pr_cohort_inst_rank_v cohirv
1536: WHERE cohirv.cohort_name = cp_cohort_name
1537: AND cohirv.load_cal_type = cp_cal_type

Line 1541: l_rank igs_pr_cohinst_rank.cohort_rank%TYPE;

1537: AND cohirv.load_cal_type = cp_cal_type
1538: AND cohirv.load_ci_sequence_number = cp_ci_sequence_number
1539: AND cohirv.person_id = cp_person_id
1540: AND cohirv.course_cd = cp_program_cd;
1541: l_rank igs_pr_cohinst_rank.cohort_rank%TYPE;
1542:
1543: -- cursor to get the cohort population
1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,