eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_ST_GEN_003 dependencies on IGS_EN_STDNT_PS_ATT

Line 249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;

245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;
246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
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;

Line 250: v_crs_req_cmplt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
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;

Line 251: v_comm_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
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

Line 291: FROM IGS_EN_STDNT_PS_ATT sca,

287: SELECT sca.fee_cat,
288: sca.course_rqrmnt_complete_ind,
289: sca.commencement_dt,
290: hpo.govt_hecs_payment_option
291: FROM IGS_EN_STDNT_PS_ATT sca,
292: IGS_EN_STDNTPSHECSOP scho,
293: IGS_FI_HECS_PAY_OPTN hpo
294: WHERE sca.person_id = p_person_id AND
295: sca.course_cd = p_course_cd AND

Line 769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;

765: gv_other_detail VARCHAR2(255);
766: BEGIN -- stap_get_sca_data
767: DECLARE
768: v_adm_admission_appl_number
769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;
770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;
771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
773: v_exemption_institution_cd IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE;

Line 770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;

766: BEGIN -- stap_get_sca_data
767: DECLARE
768: v_adm_admission_appl_number
769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;
770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;
771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
773: v_exemption_institution_cd IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE;
774: v_govt_exemption_inst_cd

Line 776: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
773: v_exemption_institution_cd IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE;
774: v_govt_exemption_inst_cd
775: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
776: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
777: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;
778: v_govt_basis_for_adm_type IGS_AD_BASIS_FOR_AD.govt_basis_for_adm_type%TYPE;
779: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
780: v_result_obtained_yr IGS_AD_AUS_SEC_EDU.result_obtained_yr%TYPE;

Line 803: FROM IGS_EN_STDNT_PS_ATT sca

799: CURSOR c_sca IS
800: SELECT sca.commencement_dt,
801: sca.adm_admission_appl_number,
802: sca.adm_nominated_course_cd
803: FROM IGS_EN_STDNT_PS_ATT sca
804: WHERE sca.person_id = p_person_id AND
805: sca.course_cd = p_course_cd;
806: CURSOR c_aca (
807: cp_admission_appl_number

Line 808: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,

804: WHERE sca.person_id = p_person_id AND
805: sca.course_cd = p_course_cd;
806: CURSOR c_aca (
807: cp_admission_appl_number
808: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
809: cp_nominated_course_cd
810: IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE) IS
811: SELECT aca.basis_for_admission_type
812: FROM IGS_AD_PS_APPL aca

Line 810: IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE) IS

806: CURSOR c_aca (
807: cp_admission_appl_number
808: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
809: cp_nominated_course_cd
810: IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE) IS
811: SELECT aca.basis_for_admission_type
812: FROM IGS_AD_PS_APPL aca
813: WHERE aca.person_id = p_person_id AND
814: aca.admission_appl_number = cp_admission_appl_number AND