APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_CLASS_RANK

Line 1: PACKAGE BODY IGS_PR_CLASS_RANK AS

1: PACKAGE BODY IGS_PR_CLASS_RANK AS
2: /* $Header: IGSPR37B.pls 120.2 2006/01/18 23:08:00 swaghmar ship $ */
3: /****************************************************************************************************************
4: || Created By : DDEY
5: || Created On : 28-OCT-2002

Line 364: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_CLASS_RANK.RUN_RANKING_PROCESS');

360: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
361: WHEN OTHERS THEN
362: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQL Error Message :' || SQLERRM);
363: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
364: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_CLASS_RANK.RUN_RANKING_PROCESS');
365: retcode := 2;
366: errbuf := fnd_message.get;
367: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
368: END run_ranking_process ;

Line 645: igs_pr_class_rank.get_cum_gpa (

641: OPEN frozen_rank_type_rec FOR
642: 'SELECT res.*,
643: RANK() OVER (ORDER BY res.cum_gpa DESC) new_rank
644: FROM (SELECT cohiv.*,
645: igs_pr_class_rank.get_cum_gpa (
646: cohiv.person_id,
647: cohiv.course_cd,
648: cohiv.cohort_name,
649: cohiv.load_cal_type,

Line 705: igs_pr_class_rank.get_cum_gpa (

701: OPEN frozen_denserank_type_rec FOR
702: 'SELECT res.*,
703: DENSE_RANK() OVER (ORDER BY res.cum_gpa DESC) new_rank
704: FROM (SELECT cohiv.*,
705: igs_pr_class_rank.get_cum_gpa (
706: cohiv.person_id,
707: cohiv.course_cd,
708: cohiv.cohort_name,
709: cohiv.load_cal_type,

Line 858: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',

854:
855: OPEN student_ranked_query_type_rec FOR
856: ' SELECT res.* , RANK () OVER (order by res.cum_gpa desc) AS new_rank
857: FROM
858: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',
859: ''' || p_cal_type || ''',' || p_ci_sequence_number || ',
860: ''' || stat_type_rec.stat_type ||''',
861: ''' || l_cumulative_ind || ''' ) cum_gpa
862: FROM igs_en_sca_v sca

Line 880: igs_pr_class_rank.rulp_val_senna_res (

876: AND load_ci_sequence_number = ' || p_ci_sequence_number || '
877: )
878: )
879: AND
880: igs_pr_class_rank.rulp_val_senna_res (
881: sca.person_id,
882: sca.course_cd,
883: sca.version_number,
884: NULL,

Line 1044: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',

1040:
1041: OPEN student_denrank_query_type_rec FOR
1042: ' SELECT res.* , DENSE_RANK () OVER (order by res.cum_gpa desc) AS new_rank
1043: FROM
1044: (SELECT person_id, course_cd, igs_pr_class_rank.get_cum_gpa ( sca.person_id,sca.course_cd,''' || p_cohort_name || ''',
1045: ''' || p_cal_type || ''',' || p_ci_sequence_number || ',
1046: ''' || stat_type_rec.stat_type ||''',
1047: ''' || l_cumulative_ind || ''' ) cum_gpa
1048: FROM igs_en_sca_v sca

Line 1066: igs_pr_class_rank.rulp_val_senna_res (

1062: AND load_ci_sequence_number = ' || p_ci_sequence_number || '
1063: )
1064: )
1065: AND
1066: igs_pr_class_rank.rulp_val_senna_res (
1067: sca.person_id,
1068: sca.course_cd,
1069: sca.version_number,
1070: NULL,

Line 1216: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_CLASS_RANK.RANKING_PROCESS');

1212: WHEN OTHERS THEN
1213: Fnd_Message.Set_Name('IGS', 'Ranking Process => ' || SQLERRM);
1214: IGS_GE_MSG_STACK.ADD;
1215: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1216: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_CLASS_RANK.RANKING_PROCESS');
1217: IGS_GE_MSG_STACK.ADD;
1218: App_Exception.Raise_Exception;
1219: END ranking_process ;
1220:

Line 1708: IGS_PR_CLASS_RANK.GET_FORMATTED_RANK (

1704: l_return_status VARCHAR2(10):=null;
1705: l_msg_count NUMBER :=null;
1706: l_msg_data VARCHAR2(2000):=null;
1707: BEGIN
1708: IGS_PR_CLASS_RANK.GET_FORMATTED_RANK (
1709: P_COHORT_NAME => p_cohort_name,
1710: P_CAL_TYPE => p_cal_type,
1711: P_CI_SEQUENCE_NUMBER => p_ci_sequence_number,
1712: P_PERSON_ID => p_person_id,

Line 1727: END igs_pr_class_rank;

1723: END IF;
1724: END get_formatted_rank;
1725:
1726:
1727: END igs_pr_class_rank;