DBA Data[Home] [Help]

APPS.IGS_PR_CP_GPA dependencies on IGS_EN_STDNT_PS_ATT

Line 51: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

47: -- kdande; 23-Apr-2003; Bug# 2829262
48: -- Added p_uoo_id parameter to the FUNCTION get_sua_cp
49: --
50: PROCEDURE get_sua_cp(
51: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
52: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
53: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
54: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
55: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 52: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

48: -- Added p_uoo_id parameter to the FUNCTION get_sua_cp
49: --
50: PROCEDURE get_sua_cp(
51: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
52: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
53: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
54: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
55: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
56: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 73: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

69: -- kdande; 23-Apr-2003; Bug# 2829262
70: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
71: --
72: PROCEDURE get_sua_gpa (
73: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
74: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
75: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
76: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
77: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 74: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

70: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
71: --
72: PROCEDURE get_sua_gpa (
73: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
74: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
75: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
76: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
77: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
78: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 93: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

89: p_use_released_grade IN VARCHAR2 DEFAULT NULL);
90:
91:
92: PROCEDURE get_all_stats(
93: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
94: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
95: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
96: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
97: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 94: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,

90:
91:
92: PROCEDURE get_all_stats(
93: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
94: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
95: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
96: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
97: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
98: p_system_stat IN VARCHAR2,

Line 113: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

109: p_use_released_grade IN VARCHAR2 DEFAULT NULL);
110:
111:
112: PROCEDURE get_cp_stats(
113: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
114: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
115: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
116: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
117: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 114: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

110:
111:
112: PROCEDURE get_cp_stats(
113: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
114: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
115: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
116: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
117: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
118: p_system_stat IN VARCHAR2,

Line 130: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

126: p_use_released_grade IN VARCHAR2 DEFAULT NULL);
127:
128:
129: PROCEDURE get_gpa_stats(
130: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
131: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
132: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
133: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
134: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 131: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

127:
128:
129: PROCEDURE get_gpa_stats(
130: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
131: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
132: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
133: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
134: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
135: p_system_stat IN VARCHAR2,

Line 152: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

148: -- Added get_all_stats_new procedure which stubs procedure get_all_stats
149: --
150:
151: PROCEDURE get_all_stats_new(
152: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
153: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
154: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
155: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
156: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 153: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,

149: --
150:
151: PROCEDURE get_all_stats_new(
152: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
153: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
154: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
155: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
156: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
157: p_system_stat IN VARCHAR2,