DBA Data[Home] [Help]

APPS.IGS_EN_PRC_LOAD dependencies on IGS_CA_INST

Line 196: p_load_cal_type IN igs_ca_inst.cal_type%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,
200: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE

Line 197: p_load_seq_number IN igs_ca_inst.sequence_number%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: );

Line 208: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

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

Line 209: p_load_seq_number IN igs_ca_inst.sequence_number%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: );

Line 237: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

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: )

Line 238: p_acad_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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: ;

Line 239: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

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:

Line 240: p_load_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE

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:

Line 266: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

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

Line 267: p_load_seq_number IN igs_ca_inst.sequence_number%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(

Line 273: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

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.

Line 274: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE

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,