DBA Data[Home] [Help]

APPS.IGS_EN_PRC_LOAD dependencies on IGS_EN_SU_ATTEMPT

Line 45: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,

41: p_load_cal_type IN VARCHAR2 ,
42: p_load_sequence_number IN NUMBER ,
43: p_truncate_ind IN VARCHAR2 DEFAULT 'N',
44: p_include_research_ind IN VARCHAR2 ,
45: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
46: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
47: p_credit_points OUT NOCOPY NUMBER )
48: RETURN NUMBER;
49: PRAGMA RESTRICT_REFERENCES (ENRP_CLC_EFTSU_TOTAL,WNDS,WNPS);

Line 46: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,

42: p_load_sequence_number IN NUMBER ,
43: p_truncate_ind IN VARCHAR2 DEFAULT 'N',
44: p_include_research_ind IN VARCHAR2 ,
45: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
46: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
47: p_credit_points OUT NOCOPY NUMBER )
48: RETURN NUMBER;
49: PRAGMA RESTRICT_REFERENCES (ENRP_CLC_EFTSU_TOTAL,WNDS,WNPS);
50: --

Line 67: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,

63: p_override_enrolled_cp IN NUMBER ,
64: p_override_eftsu IN NUMBER ,
65: p_truncate_ind IN VARCHAR2 DEFAULT 'N',
66: p_sca_cp_total IN NUMBER ,
67: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
68: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
69: p_credit_points OUT NOCOPY NUMBER ,
70: -- anilk, Audit special fee build
71: p_include_audit IN VARCHAR2 DEFAULT 'N')

Line 68: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,

64: p_override_eftsu IN NUMBER ,
65: p_truncate_ind IN VARCHAR2 DEFAULT 'N',
66: p_sca_cp_total IN NUMBER ,
67: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
68: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
69: p_credit_points OUT NOCOPY NUMBER ,
70: -- anilk, Audit special fee build
71: p_include_audit IN VARCHAR2 DEFAULT 'N')
72: RETURN NUMBER;

Line 184: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,

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: )
188: RETURN igs_en_su_attempt.course_cd%TYPE;

Line 188: RETURN igs_en_su_attempt.course_cd%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: )
188: RETURN igs_en_su_attempt.course_cd%TYPE;
189:
190:
191: -- Function to calculate the Institutional Level Attendance Type
192:

Line 199: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

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: );
202:
203: -- anilk, Bug# 3046897

Line 200: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%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: );
202:
203: -- anilk, Bug# 3046897
204: -- Function to calculate the Institutional Level Attendance Type, called from View Academic History Page

Line 211: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

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: );
214:
215: --Procedure to calculate the total credit points with in a given load calendar

Line 212: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%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: );
214:
215: --Procedure to calculate the total credit points with in a given load calendar
216: PROCEDURE enrp_clc_cp_upto_tp_start_dt