APPS.IGS_PR_CP_GPA dependencies on IGS_PR_STU_ACAD_STAT

Line 138: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE);

134: p_msg_count OUT NOCOPY NUMBER,
135: p_msg_data OUT NOCOPY VARCHAR2,
136: p_uoo_id IN NUMBER,
137: p_use_released_grade IN VARCHAR2,
138: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE);
139:
140:
141: FUNCTION chk_av_unit_ref_cd (
142: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

Line 1083: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE) IS

1079: p_msg_count OUT NOCOPY NUMBER,
1080: p_msg_data OUT NOCOPY VARCHAR2,
1081: p_uoo_id IN NUMBER,
1082: p_use_released_grade IN VARCHAR2,
1083: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE) IS
1084: --------------------------------------------------------------------------
1085: -- Created By : David Larsen
1086: -- Date Created On : 06-11-2002
1087: -- Purpose: To derive all of the statistic values for a given

Line 1865: p_enrolled_cp igs_pr_stu_acad_stat.gpa_quality_points%TYPE;

1861: p_msg_data OUT NOCOPY VARCHAR2,
1862: p_use_released_grade IN VARCHAR2) IS
1863:
1864:
1865: p_enrolled_cp igs_pr_stu_acad_stat.gpa_quality_points%TYPE;
1866: BEGIN
1867: ---- This procedure is being stubbed for the time being to reduce the impact of change for
1868: ---- Bug 3843525
1869: get_all_stats_new(

Line 1914: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE) IS

1910: p_return_status OUT NOCOPY VARCHAR2,
1911: p_msg_count OUT NOCOPY NUMBER,
1912: p_msg_data OUT NOCOPY VARCHAR2,
1913: p_use_released_grade IN VARCHAR2,
1914: p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE) IS
1915:
1916: -- Note param p_enrolled_cp added for bug 3843525 jhanda
1917: /*
1918: ||==============================================================================||

Line 1982: FROM igs_pr_stu_acad_stat sas

1978: sas.attempted_credit_points,
1979: sas.gpa,
1980: sas.gpa_credit_points,
1981: sas.gpa_quality_points
1982: FROM igs_pr_stu_acad_stat sas
1983: WHERE sas.person_id = p_person_id
1984: AND sas.course_cd = p_course_cd
1985: AND sas.cal_type = p_load_cal_type
1986: AND sas.ci_sequence_number = p_load_ci_sequence_number

Line 2013: l_enrolled_cp igs_pr_stu_acad_stat.gpa_credit_points%TYPE := 0;

2009: l_return_status VARCHAR2(30);
2010: l_msg_count NUMBER(2);
2011: l_msg_data VARCHAR2(30);
2012: l_org_id NUMBER(4);
2013: l_enrolled_cp igs_pr_stu_acad_stat.gpa_credit_points%TYPE := 0;
2014: l_enrolled_cp_total igs_ps_unit_ver.achievable_credit_points%TYPE := 0;
2015:
2016: -- Added as part of fix for Bug# 5260180
2017: v_inc_exc_ul VARCHAR2(1) := 'Y';