192:
193: PROCEDURE enrp_get_inst_latt
194: (
195: p_person_id IN hz_parties.party_id%TYPE,
196: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
197: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
198: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
199: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
200: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
193: PROCEDURE enrp_get_inst_latt
194: (
195: p_person_id IN hz_parties.party_id%TYPE,
196: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
197: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
198: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
199: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
200: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
201: );
204: -- Function to calculate the Institutional Level Attendance Type, called from View Academic History Page
205: PROCEDURE enrp_get_inst_latt_fte
206: (
207: p_person_id IN hz_parties.party_id%TYPE,
208: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
209: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
210: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
211: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
212: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
205: PROCEDURE enrp_get_inst_latt_fte
206: (
207: p_person_id IN hz_parties.party_id%TYPE,
208: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
209: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
210: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
211: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
212: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
213: );
233:
234: --Procedure to get latest load for an acad calendar
235: PROCEDURE get_latest_load_for_acad_cal
236: (
237: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
238: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
239: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
240: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
241: )
234: --Procedure to get latest load for an acad calendar
235: PROCEDURE get_latest_load_for_acad_cal
236: (
237: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
238: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
239: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
240: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
241: )
242: ;
235: PROCEDURE get_latest_load_for_acad_cal
236: (
237: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
238: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
239: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
240: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
241: )
242: ;
243:
236: (
237: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
238: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
239: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
240: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
241: )
242: ;
243:
244:
262: -- Function to calculate the Institutional Level Attendance Type
263:
264: FUNCTION enrp_get_inst_attendance(
265: p_person_id IN hz_parties.party_id%TYPE,
266: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
267: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
268: ) RETURN VARCHAR2;
269:
270: -- Function to calculate the Institutional Level Attendance Type
263:
264: FUNCTION enrp_get_inst_attendance(
265: p_person_id IN hz_parties.party_id%TYPE,
266: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
267: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
268: ) RETURN VARCHAR2;
269:
270: -- Function to calculate the Institutional Level Attendance Type
271: FUNCTION enrp_get_inst_cp(
269:
270: -- Function to calculate the Institutional Level Attendance Type
271: FUNCTION enrp_get_inst_cp(
272: p_person_id IN hz_parties.party_id%TYPE,
273: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
274: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
275: ) RETURN VARCHAR2;
276:
277: -- get_term_credits: Gets the total credits for the given person, program and term.
270: -- Function to calculate the Institutional Level Attendance Type
271: FUNCTION enrp_get_inst_cp(
272: p_person_id IN hz_parties.party_id%TYPE,
273: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
274: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
275: ) RETURN VARCHAR2;
276:
277: -- get_term_credits: Gets the total credits for the given person, program and term.
278: FUNCTION get_term_credits (p_n_person_id IN NUMBER,