DBA Data[Home] [Help]

APPS.IGS_PR_CP_GPA dependencies on IGS_CA_INST

Line 55: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
57: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
58: p_system_stat IN VARCHAR2,
59: p_earned_cp OUT NOCOPY NUMBER,

Line 56: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%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,
57: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
58: p_system_stat IN VARCHAR2,
59: p_earned_cp OUT NOCOPY NUMBER,
60: p_attempted_cp OUT NOCOPY NUMBER,

Line 77: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
79: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
80: p_system_stat IN VARCHAR2,
81: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

Line 78: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%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,
79: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
80: p_system_stat IN VARCHAR2,
81: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
82: p_gpa_value OUT NOCOPY NUMBER,

Line 96: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,

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,
99: p_cumulative_ind IN VARCHAR2,
100: p_earned_cp OUT NOCOPY NUMBER,

Line 97: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

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,
99: p_cumulative_ind IN VARCHAR2,
100: p_earned_cp OUT NOCOPY NUMBER,
101: p_attempted_cp OUT NOCOPY NUMBER,

Line 116: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
119: p_cumulative_ind IN VARCHAR2,
120: p_earned_cp OUT NOCOPY NUMBER,

Line 117: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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,
119: p_cumulative_ind IN VARCHAR2,
120: p_earned_cp OUT NOCOPY NUMBER,
121: p_attempted_cp OUT NOCOPY NUMBER,

Line 133: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
136: p_cumulative_ind IN VARCHAR2,
137: p_gpa_value OUT NOCOPY NUMBER,

Line 134: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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,
136: p_cumulative_ind IN VARCHAR2,
137: p_gpa_value OUT NOCOPY NUMBER,
138: p_gpa_cp OUT NOCOPY NUMBER,

Line 155: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,

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,
158: p_cumulative_ind IN VARCHAR2,
159: p_earned_cp OUT NOCOPY NUMBER,

Line 156: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

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,
158: p_cumulative_ind IN VARCHAR2,
159: p_earned_cp OUT NOCOPY NUMBER,
160: p_attempted_cp OUT NOCOPY NUMBER,