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_EN_VAL_SCA dependencies on IGS_AD_PS_APPL

Line 66: -- This module validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt

62: p_candidature_exists_ind OUT NOCOPY VARCHAR2 ,
63: p_message_name OUT NOCOPY VARCHAR2)
64: RETURN BOOLEAN AS
65: BEGIN -- admp_val_ca_comm
66: -- This module validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt
67: -- in the context of research candidature.
68: DECLARE
69: cst_sca CONSTANT VARCHAR2(10) := 'SCA';
70: cst_acai CONSTANT VARCHAR2(10) := 'ACAI';

Line 78: v_s_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;

74: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
75: v_message_name varchar2(30) ;
76: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
77: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;
78: v_s_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
79: CURSOR c_ca IS
80: SELECT ca.sequence_number,
81: ca.min_submission_dt
82: FROM IGS_RE_CANDIDATURE ca

Line 219: -- This modules validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt.

215: p_parent IN VARCHAR2 ,
216: p_message_name OUT NOCOPY VARCHAR2)
217: RETURN BOOLEAN AS
218: BEGIN -- admp_val_ca_comm_val
219: -- This modules validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt.
220: -- Validations are:
221: -- * Prpsd_commencement_dt must be greater than the earlier of the course
222: -- start date or the admission academic period earliest research start date.
223: -- * Warn if the Prpsd_commencement_dt is prior to passed census dates for

Line 228: v_course_start_dt IGS_AD_PS_APPL_INST.prpsd_commencement_dt%TYPE;

224: -- the admission academic period.
225: DECLARE
226: cst_ca CONSTANT VARCHAR2(10):='CA';
227: cst_teaching CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'TEACHING';
228: v_course_start_dt IGS_AD_PS_APPL_INST.prpsd_commencement_dt%TYPE;
229: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;
231: CURSOR c_acaiv IS
232: SELECT acaiv.adm_cal_type,

Line 229: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;

225: DECLARE
226: cst_ca CONSTANT VARCHAR2(10):='CA';
227: cst_teaching CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'TEACHING';
228: v_course_start_dt IGS_AD_PS_APPL_INST.prpsd_commencement_dt%TYPE;
229: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;
231: CURSOR c_acaiv IS
232: SELECT acaiv.adm_cal_type,
233: acaiv.adm_ci_sequence_number

Line 230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;

226: cst_ca CONSTANT VARCHAR2(10):='CA';
227: cst_teaching CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'TEACHING';
228: v_course_start_dt IGS_AD_PS_APPL_INST.prpsd_commencement_dt%TYPE;
229: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;
231: CURSOR c_acaiv IS
232: SELECT acaiv.adm_cal_type,
233: acaiv.adm_ci_sequence_number
234: FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv

Line 234: FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv

230: v_adm_ci_sequence_number IGS_AD_PS_APPL_INST_APLINST_V.adm_ci_sequence_number%TYPE;
231: CURSOR c_acaiv IS
232: SELECT acaiv.adm_cal_type,
233: acaiv.adm_ci_sequence_number
234: FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv
235: WHERE acaiv.person_id = p_person_id AND
236: acaiv.admission_appl_number = p_acai_admission_appl_number AND
237: acaiv.nominated_course_cd = p_acai_nominated_course_cd AND
238: acaiv.sequence_number = p_acai_sequence_number;

Line 608: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'N'.

604: -- offer can be accepted. The following is checked:
605: -- ? Return TRUE if either the conditional offer has been satisfied or waived,
606: -- or the conditional offer is still pending, but it is not a requirement
607: -- that the condition be satisfied for acceptance ie.
608: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'N'.
609: -- ? Return FALSE if conditional offer is unsatisfactory, or the conditional
610: -- offer is still pending and it is a requirement that the condition be
611: -- satisfied for acceptance ie.
612: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'Y'.

Line 612: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'Y'.

608: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'N'.
609: -- ? Return FALSE if conditional offer is unsatisfactory, or the conditional
610: -- offer is still pending and it is a requirement that the condition be
611: -- satisfied for acceptance ie.
612: -- IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind is 'Y'.
613: DECLARE
614: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
615: cst_unsatisfac CONSTANT VARCHAR2(10) := 'UNSATISFAC';
616: cst_satisfied CONSTANT VARCHAR2(9) := 'SATISFIED';

Line 620: IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status%TYPE;

616: cst_satisfied CONSTANT VARCHAR2(9) := 'SATISFIED';
617: cst_waived CONSTANT VARCHAR2(6) := 'WAIVED';
618: cst_pending CONSTANT VARCHAR2(7) := 'PENDING';
619: v_s_adm_cndtnl_offer_status
620: IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status%TYPE;
621: BEGIN
622: -- Determine system conditional offer status
623: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS(
624: p_adm_cndtnl_offer_status);

Line 1099: -- IGS_EN_STDNT_PS_ATT and IGS_AD_PS_APPL_INST database triggers,

1095: -- This module validates that acceptance of an admission course transfer
1096: -- application can only occur when matching IGS_PS_STDNT_TRN details
1097: -- exist.
1098: -- This validation routine will be called from ENRF3000, ADMF3240,
1099: -- IGS_EN_STDNT_PS_ATT and IGS_AD_PS_APPL_INST database triggers,
1100: -- and the pre-enrolment process.
1101: DECLARE
1102: v_s_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
1103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

Line 1102: v_s_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;

1098: -- This validation routine will be called from ENRF3000, ADMF3240,
1099: -- IGS_EN_STDNT_PS_ATT and IGS_AD_PS_APPL_INST database triggers,
1100: -- and the pre-enrolment process.
1101: DECLARE
1102: v_s_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
1103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1104: v_dummy VARCHAR2(1);
1105: CURSOR c_aa IS
1106: SELECT s_admission_process_type

Line 1112: FROM IGS_AD_PS_APPL aca,

1108: WHERE person_id = p_person_id AND
1109: admission_appl_number = p_admission_appl_number;
1110: CURSOR c_aca_sct IS
1111: SELECT 'x'
1112: FROM IGS_AD_PS_APPL aca,
1113: IGS_PS_STDNT_TRN sct
1114: WHERE aca.person_id = p_person_id AND
1115: aca.admission_appl_number = p_admission_appl_number AND
1116: aca.nominated_course_cd = p_nominated_course_cd AND

Line 1152: -- IGS_AD_PS_APPL_INST

1148: -- IGS_EN_STDNT_PS_ATT
1149: p_message_name := 'IGS_EN_STUD_PRG_ATTEMPT';
1150: ELSE
1151: -- return message for acceptance of
1152: -- IGS_AD_PS_APPL_INST
1153: p_message_name := 'IGS_EN_APPL_PRG_TRANSFER';
1154: END IF;
1155: CLOSE c_aca_sct;
1156: RETURN FALSE;

Line 2109: -- IGS_AD_PS_APPL_INST.prpsd_commencement_dt.

2105: -- If the course attempt originates from an offer other than process
2106: -- type TRANSFER, the date cannot be prior to the course start date of the
2107: -- students admission period OR the if research candidature is mandatory part
2108: -- of the offer, prior to the valid values for
2109: -- IGS_AD_PS_APPL_INST.prpsd_commencement_dt.
2110: -- If the course attempt is the result of a course transfer from a generic
2111: -- course, then the date can be no earlier than the commencement date of the
2112: -- originating course attempt.
2113: -- If the course attempt is a result of a course transfer from a IGS_PS_COURSE

Line 2181: FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv

2177: acaiv.nominated_course_cd,
2178: acaiv.sequence_number,
2179: acaiv.adm_cal_type,
2180: acaiv.adm_ci_sequence_number
2181: FROM IGS_AD_PS_APPL_INST_APLINST_V acaiv
2182: WHERE acaiv.person_id = cp_person_id AND
2183: acaiv.admission_appl_number = cp_adm_adm_appl_num AND
2184: acaiv.nominated_course_cd = cp_adm_nom_course_cd AND
2185: acaiv.sequence_number = cp_adm_sequence_number;