179: -- Function to get the Key Programs for a Particular Person
180:
181: FUNCTION enrp_clc_key_prog
182: (
183: p_person_id IN hz_parties.party_id%TYPE,
184: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,
185: p_term_cal_type IN VARCHAR2 DEFAULT NULL,
186: p_term_sequence_number IN NUMBER DEFAULT NULL
187: )
191: -- Function to calculate the Institutional Level Attendance Type
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,
203: -- anilk, Bug# 3046897
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,
261:
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:
268: ) RETURN VARCHAR2;
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: