APPS.IGS_ST_GEN_003 dependencies on IGS_EN_SU_ATTEMPT

Line 207: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

203: p_tr_ou_start_dt IN DATE ,
204: p_eftsu IN NUMBER ,
205: p_effective_dt IN DATE ,
206: p_exclusion_level OUT NOCOPY VARCHAR2,
207: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
208: RETURN VARCHAR2 AS
209: -------------------------------------------------------------------------------------------
210: -- stap_get_rptbl_govt
211: -- Routine to determine if a student unit attempt, or part of a student

Line 237: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

233: cst_warning CONSTANT VARCHAR2(1) := 'W';
234: cst_govt_report CONSTANT IGS_PS_UNIT_CATEGORY.unit_cat%TYPE := 'GOVT-RPT';
235: cst_govt_noreport CONSTANT IGS_PS_UNIT_CATEGORY.unit_cat%TYPE := 'GOVT-NORPT';
236: cst_tuition CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
237: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
238: 'ENROLLED';
239: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
240: 'DISCONTIN';
241: v_unit_cat IGS_PS_UNIT_CATEGORY.unit_cat%TYPE;

Line 239: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

235: cst_govt_noreport CONSTANT IGS_PS_UNIT_CATEGORY.unit_cat%TYPE := 'GOVT-NORPT';
236: cst_tuition CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
237: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
238: 'ENROLLED';
239: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
240: 'DISCONTIN';
241: v_unit_cat IGS_PS_UNIT_CATEGORY.unit_cat%TYPE;
242: v_crs_cat IGS_PS_CATEGORISE.course_cat%TYPE;
243: v_resp_ou_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;

Line 253: v_sua_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;
250: v_crs_req_cmplt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
251: v_comm_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
252: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
253: v_sua_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
254: v_charged_tuition_fees BOOLEAN DEFAULT FALSE;
255: CURSOR c_uc IS
256: SELECT uc.unit_cat
257: FROM IGS_PS_UNIT_CATEGORY uc

Line 310: FROM IGS_EN_SU_ATTEMPT sua

306: FROM IGS_FI_FEE_TYPE ft
307: WHERE ft.s_fee_type = cst_tuition;
308: CURSOR c_sua IS
309: SELECT sua.unit_attempt_status
310: FROM IGS_EN_SU_ATTEMPT sua
311: WHERE sua.person_id = p_person_id AND
312: sua.course_cd = p_course_cd AND
313: sua.uoo_id = p_uoo_id;
314: BEGIN

Line 495: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

491: p_govt_semester IN NUMBER ,
492: p_teach_census_dt IN DATE ,
493: p_load_cal_type IN VARCHAR2 ,
494: p_load_ci_sequence_number IN NUMBER,
495: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
496: RETURN VARCHAR2 AS
497: -------------------------------------------------------------------------------------------
498: -- This routine determines if a unit of study should be
499: -- reported to the government within a specified submission.

Line 519: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

515: -------------------------------------------------------------------------------------------
516: BEGIN
517: DECLARE
518: CURSOR c_daiv (
519: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
520: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
521: SELECT daiv.alias_val
522: FROM IGS_CA_DA_INST_V daiv,
523: IGS_GE_S_GEN_CAL_CON sgcc

Line 520: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS

516: BEGIN
517: DECLARE
518: CURSOR c_daiv (
519: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
520: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
521: SELECT daiv.alias_val
522: FROM IGS_CA_DA_INST_V daiv,
523: IGS_GE_S_GEN_CAL_CON sgcc
524: WHERE daiv.cal_type = cp_cal_type AND