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_EN_STDNT_PS_ATT

Line 377: -- IGS_EN_STDNT_PS_ATT.attendance_type.

373: p_message_name OUT NOCOPY VARCHAR2)
374: RETURN BOOLEAN AS
375: BEGIN -- resp_val_ca_att_perc
376: -- This module validates IGS_RE_CANDIDATURE.attendance_percentage and
377: -- IGS_EN_STDNT_PS_ATT.attendance_type.
378: -- Validations are:
379: -- * The load of the research at the nominated attendance percentage must be
380: -- within the upper and lower load ranges for the attendance type in the
381: -- load calendar targetted. This is a warning only.

Line 389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

385: -- to one load calendar instance.
386: DECLARE
387: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

Line 390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

386: DECLARE
387: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

Line 404: FROM IGS_EN_STDNT_PS_ATT sca

400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
401: CURSOR c_sca IS
402: SELECT sca.attendance_type,
403: sca.student_confirmed_ind
404: FROM IGS_EN_STDNT_PS_ATT sca
405: WHERE sca.person_id = p_person_id AND
406: sca.course_cd = p_course_cd;
407: CURSOR c_ca IS
408: SELECT ca.attendance_percentage

Line 451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS

447: dla.teach_cal_type = cp_teach_cal_type AND
448: dla.percentage = 100;
449: CURSOR c_atl (
450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
452: SELECT atl.lower_enr_load_range,
453: atl.upper_enr_load_range
454: FROM IGS_EN_ATD_TYPE_LOAD atl
455: WHERE atl.cal_type = cp_load_cal_type AND

Line 882: -- This module validates that the IGS_EN_STDNT_PS_ATT enrolled units satisfy

878: p_message_name OUT NOCOPY VARCHAR2,
879: p_message_text OUT NOCOPY VARCHAR2 )
880: RETURN BOOLEAN AS
881: BEGIN -- enrp_val_unit_rule
882: -- This module validates that the IGS_EN_STDNT_PS_ATT enrolled units satisfy
883: -- unit rules. This routine is to be called when all changes have been posted.
884: DECLARE
885: cst_enrolled CONSTANT
886: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

Line 1025: -- To validate the IGS_EN_STDNT_PS_ATT.lapse_dt

1021: IGS_GE_MSG_STACK.ADD;
1022: App_Exception.Raise_Exception;
1023: END enrp_val_sca_cat;
1024: --
1025: -- To validate the IGS_EN_STDNT_PS_ATT.lapse_dt
1026: FUNCTION enrp_val_sca_lapse(
1027: p_course_attempt_status IN VARCHAR2 ,
1028: p_lapse_dt IN DATE ,
1029: p_message_name OUT NOCOPY VARCHAR2,

Line 1036: || (mostly within the IGS_EN_STDNT_PS_ATT table).

1032: /*-------------------------------------------------------------------------------------------------------
1033: || Created By :
1034: || Created On :
1035: || Purpose : validate the setting of lapse date against other enrolment details
1036: || (mostly within the IGS_EN_STDNT_PS_ATT table).
1037: || Known limitations, enhancements or remarks :
1038: || Change History :
1039: || Who When What
1040: || kkillams 11-11-2002 Modified function logic due to addition of new parameter p_legacy

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 1123: -- This is not a IGS_EN_STDNT_PS_ATT inserted as a result of an admission

1119: sct.transfer_course_cd = aca.transfer_course_cd;
1120: BEGIN
1121: IF p_admission_appl_number IS NULL OR
1122: p_nominated_course_cd IS NULL THEN
1123: -- This is not a IGS_EN_STDNT_PS_ATT inserted as a result of an admission
1124: -- application
1125: p_message_name := null;
1126: RETURN TRUE;
1127: END IF;

Line 1148: -- IGS_EN_STDNT_PS_ATT

1144: FETCH c_aca_sct INTO v_dummy;
1145: IF (c_aca_sct%NOTFOUND) THEN
1146: IF (p_student_confirmed_ind = 'Y') THEN
1147: -- return_message for confirmation of
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

Line 1196: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1192: -- Validate that the change of course offering option is allowed.
1193: DECLARE
1194: v_ret_val BOOLEAN := TRUE;
1195: CURSOR c_student_course_attempt (
1196: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1197: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1198: SELECT course_attempt_status,
1199: version_number
1200: FROM

Line 1197: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

1193: DECLARE
1194: v_ret_val BOOLEAN := TRUE;
1195: CURSOR c_student_course_attempt (
1196: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1197: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1198: SELECT course_attempt_status,
1199: version_number
1200: FROM
1201: IGS_EN_STDNT_PS_ATT

Line 1201: IGS_EN_STDNT_PS_ATT

1197: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1198: SELECT course_attempt_status,
1199: version_number
1200: FROM
1201: IGS_EN_STDNT_PS_ATT
1202: WHERE
1203: person_id = cp_person_id AND
1204: course_cd = cp_course_cd;
1205: BEGIN

Line 1258: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1254: p_mess3 varchar2(30);
1255: v_message_name varchar2(30);
1256: v_attendance_types VARCHAR2(100);
1257: CURSOR c_sua (
1258: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
1262: SELECT sua.location_cd,

Line 1259: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1255: v_message_name varchar2(30);
1256: v_attendance_types VARCHAR2(100);
1257: CURSOR c_sua (
1258: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1261: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
1262: SELECT sua.location_cd,
1263: sua.unit_class

Line 1352: -- IGS_EN_STDNT_PS_ATT :

1348: p_message_name OUT NOCOPY VARCHAR2)
1349: RETURN BOOLEAN AS
1350: BEGIN -- enrp_val_sca_confirm.
1351: -- Validate the student_confirmed_ind from the
1352: -- IGS_EN_STDNT_PS_ATT :
1353: -- * course_attempt_status must be 'ENROLLED',
1354: -- 'INACTIVE' or 'UNCONFIRM' to unset the
1355: -- student_confrimed_ind.
1356: -- * student_confirmed_ind must not be unset

Line 1704: || Purpose : validate the IGS_EN_DCNT_REASONCD from the IGS_EN_STDNT_PS_ATT table

1700: RETURN BOOLEAN AS
1701: /*----------------------------------------------------------------------------
1702: || Created By :
1703: || Created On :
1704: || Purpose : validate the IGS_EN_DCNT_REASONCD from the IGS_EN_STDNT_PS_ATT table
1705: ||
1706: || Known limitations, enhancements or remarks :
1707: || Change History :
1708: || Who When What

Line 1868: || from the IGS_EN_STDNT_PS_ATT :

1864: /*----------------------------------------------------------------------------
1865: || Created By :
1866: || Created On :
1867: || Purpose : Validate the IGS_EN_DCNT_REASONCD and discontinued_dt
1868: || from the IGS_EN_STDNT_PS_ATT :
1869: || * If the discontinuation_reason code is set it must not be closed
1870: || * If both discontinued_dt and commencement_dt are set then
1871: || discontinued_dt must be >= commencement_dt
1872: || * If either reason or date are set then both must be set

Line 1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';

1895: ------------------------------------------------------------------------------*/
1896: BEGIN
1897: DECLARE
1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

Line 1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';

1896: BEGIN
1897: DECLARE
1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

Line 1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

1897: DECLARE
1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1905: l_dummy_boolean BOOLEAN;

Line 1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';

1898: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE :='ACTIVE';
1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1905: l_dummy_boolean BOOLEAN;
1906: CURSOR c_cv IS

Line 1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

1899: cst_discontin CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE :='DISCONTIN';
1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1905: l_dummy_boolean BOOLEAN;
1906: CURSOR c_cv IS
1907: SELECT 'x'

Line 1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

1900: cst_enrolled CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1901: cst_inactive CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1902: cst_intermit CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INTERMIT';
1903: cst_lapsed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1904: cst_completed CONSTANT IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1905: l_dummy_boolean BOOLEAN;
1906: CURSOR c_cv IS
1907: SELECT 'x'
1908: FROM IGS_PS_VER cv,

Line 2137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

2133: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
2134: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
2135: cst_sca CONSTANT VARCHAR2(4) := 'SCA';
2136: -- Variables
2137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2138: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
2139: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
2140: v_candidature_exists_ind VARCHAR2(1);
2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 2151: IGS_EN_STDNT_PS_ATT sca,

2147: v_commencement_dt_validated BOOLEAN;
2148: CURSOR c_sct_sca_crv IS
2149: SELECT sca.commencement_dt
2150: FROM IGS_PS_STDNT_TRN sct,
2151: IGS_EN_STDNT_PS_ATT sca,
2152: IGS_PS_VER crv
2153: WHERE sct.person_id = p_person_id AND
2154: sca.person_id = sct.person_id AND
2155: sct.course_cd = p_course_cd AND

Line 2167: FROM IGS_EN_STDNT_PS_ATT sca

2163: sca.person_id,
2164: sca.adm_admission_appl_number,
2165: sca.adm_nominated_course_cd,
2166: sca.adm_sequence_number
2167: FROM IGS_EN_STDNT_PS_ATT sca
2168: WHERE sca.person_id = p_person_id AND
2169: sca.course_cd = p_course_cd;
2170: v_sca_rec c_sca%ROWTYPE;
2171: CURSOR c_acaiv (

Line 2172: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2168: WHERE sca.person_id = p_person_id AND
2169: sca.course_cd = p_course_cd;
2170: v_sca_rec c_sca%ROWTYPE;
2171: CURSOR c_acaiv (
2172: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2173: cp_adm_adm_appl_num IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
2174: cp_adm_nom_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
2175: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
2176: SELECT acaiv.admission_appl_number,

Line 2173: cp_adm_adm_appl_num IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,

2169: sca.course_cd = p_course_cd;
2170: v_sca_rec c_sca%ROWTYPE;
2171: CURSOR c_acaiv (
2172: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2173: cp_adm_adm_appl_num IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
2174: cp_adm_nom_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
2175: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
2176: SELECT acaiv.admission_appl_number,
2177: acaiv.nominated_course_cd,

Line 2174: cp_adm_nom_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,

2170: v_sca_rec c_sca%ROWTYPE;
2171: CURSOR c_acaiv (
2172: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2173: cp_adm_adm_appl_num IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
2174: cp_adm_nom_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
2175: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
2176: SELECT acaiv.admission_appl_number,
2177: acaiv.nominated_course_cd,
2178: acaiv.sequence_number,

Line 2175: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS

2171: CURSOR c_acaiv (
2172: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2173: cp_adm_adm_appl_num IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
2174: cp_adm_nom_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
2175: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
2176: SELECT acaiv.admission_appl_number,
2177: acaiv.nominated_course_cd,
2178: acaiv.sequence_number,
2179: acaiv.adm_cal_type,

Line 2226: IGS_EN_STDNT_PS_ATT sca

2222: CURSOR c_sct_ca_sca IS
2223: SELECT sca.commencement_dt
2224: FROM IGS_PS_STDNT_TRN sct,
2225: IGS_RE_CANDIDATURE ca,
2226: IGS_EN_STDNT_PS_ATT sca
2227: WHERE sct.person_id = p_person_id AND
2228: sct.course_cd = p_course_cd AND
2229: sct.person_id = ca.person_id AND
2230: sct.transfer_course_cd = ca.sca_course_cd AND

Line 2521: -- from the IGS_EN_STDNT_PS_ATT.

2517: version_number = p_version_number AND
2518: restricted_ind = 'Y';
2519: BEGIN
2520: -- This module validates the IGS_FI_FUND_SRC
2521: -- from the IGS_EN_STDNT_PS_ATT.
2522: -- checking if p_funding_source is not set
2523: IF (p_funding_source IS NULL) THEN
2524: p_message_name := null;
2525: RETURN TRUE;

Line 2580: -- Validate the IGS_PS_OFR_PAT for a IGS_EN_STDNT_PS_ATT

2576: IGS_GE_MSG_STACK.ADD;
2577: App_Exception.Raise_Exception;
2578: END ENRP_VAL_SCA_FS;
2579: --
2580: -- Validate the IGS_PS_OFR_PAT for a IGS_EN_STDNT_PS_ATT
2581: FUNCTION enrp_val_sca_cop(
2582: p_course_cd IN VARCHAR2 ,
2583: p_version_number IN NUMBER ,
2584: p_location_cd IN VARCHAR2 ,

Line 2622: -- for the curent IGS_EN_STDNT_PS_ATT.

2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.
2623: -- checking if the IGS_PS_OFR_PAT
2624: -- offered_ind is set to 'N'
2625: OPEN c_cop_rec;
2626: FETCH c_cop_rec INTO v_cop_rec;

Line 2685: -- was invoked from IGS_EN_STDNT_PS_ATT_PKG.

2681: -- A FUNCTION enrp_val_sca_fc in this package has been removed as this will not be invoked
2682: -- as per the build changes for the Fee clac Build (Bug 1851586)
2683: -- This function validates whether the Student Program Attempt had an assessment
2684: -- record with the specified Fee Category.
2685: -- was invoked from IGS_EN_STDNT_PS_ATT_PKG.
2686:
2687: --
2688: -- Validate if IGS_FI_FEE_CAT.fee_cat is closed.
2689: FUNCTION finp_val_fc_closed(

Line 2733: CURSOR c_sua_term (cp_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,

2729: p_commencement_dt IN DATE,
2730: p_message_name OUT NOCOPY VARCHAR2
2731: ) RETURN BOOLEAN AS
2732:
2733: CURSOR c_sua_term (cp_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
2734: cp_course_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
2735: SELECT tlv.LOAD_END_DT
2736: From igs_ca_teach_to_load_V tlv,
2737: igs_en_su_attempt sua

Line 2734: cp_course_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS

2730: p_message_name OUT NOCOPY VARCHAR2
2731: ) RETURN BOOLEAN AS
2732:
2733: CURSOR c_sua_term (cp_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
2734: cp_course_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
2735: SELECT tlv.LOAD_END_DT
2736: From igs_ca_teach_to_load_V tlv,
2737: igs_en_su_attempt sua
2738: Where sua.person_id = cp_person_id

Line 2769: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2765:
2766: END enrf_val_sua_term_sca_comm;
2767:
2768: FUNCTION del_unconfirm_sua_for_reopen(
2769: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2770: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
2771: RETURN BOOLEAN
2772: AS
2773: CURSOR c_sua IS

Line 2770: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

2766: END enrf_val_sua_term_sca_comm;
2767:
2768: FUNCTION del_unconfirm_sua_for_reopen(
2769: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2770: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
2771: RETURN BOOLEAN
2772: AS
2773: CURSOR c_sua IS
2774: SELECT uoo_id

Line 2800: from igs_en_stdnt_ps_att_all spa

2796: IS
2797: --cursor to fetch the program attempts for the admission application in context
2798: Cursor cur_spa(cp_rowid ROWID) IS
2799: Select spa.rowid,spa.*
2800: from igs_en_stdnt_ps_att_all spa
2801: where spa.rowid = cp_rowid;
2802:
2803: --cursor to check if any unit attempts other than unconfirmed unit attempts
2804: --exist for a program attempt

Line 2836: igs_en_stdnt_ps_att sca

2832: cp_version_number NUMBER,
2833: cp_person_id NUMBER) IS
2834: Select ps.course_type
2835: from igs_ps_ver ps,
2836: igs_en_stdnt_ps_att sca
2837: where ps.course_cd=cp_course_cd
2838: and ps.version_number = cp_version_number
2839: and sca.course_cd = ps.course_cd
2840: and sca.version_number = ps.version_number

Line 2847: FROM igs_en_stdnt_ps_att spa,

2843: --Cursor to check secondary prgoram exist for a career
2844: Cursor cur_ps_sec(cp_person_id NUMBER,
2845: cp_course_type VARCHAR2) IS
2846: SELECT spa.course_cd
2847: FROM igs_en_stdnt_ps_att spa,
2848: igs_ps_ver pv
2849: WHERE spa.person_id = cp_person_id
2850: AND spa.primary_program_type = 'SECONDARY'
2851: AND spa.STUDENT_CONFIRMED_IND = 'Y'

Line 2868: FROM igs_en_stdnt_ps_att spa,

2864:
2865: CURSOR cur_pri_prg(cp_person_id NUMBER,
2866: cp_course_type VARCHAR2) IS
2867: SELECT 'x'
2868: FROM igs_en_stdnt_ps_att spa,
2869: igs_ps_ver pv
2870: WHERE spa.person_id = cp_person_id
2871: AND spa.primary_program_type = 'PRIMARY'
2872: AND spa.course_cd = pv.course_cd

Line 2879: FROM igs_en_stdnt_ps_att spa

2875:
2876: CURSOR cur_confirm_prg(cp_person_id NUMBER,
2877: cp_course_cd VARCHAR2) IS
2878: SELECT 'x'
2879: FROM igs_en_stdnt_ps_att spa
2880: WHERE spa.person_id = cp_person_id
2881: AND spa.course_cd <> cp_course_cd
2882: AND spa.student_confirmed_ind = 'Y' ;
2883:

Line 2888: l_sec_courseCD igs_en_stdnt_ps_att.course_cd%TYPE;

2884:
2885: l_sua_check VARCHAR2(1);
2886: l_sua_unconfirm_check VARCHAR2(1);
2887: l_career igs_ps_ver.course_type%TYPE;
2888: l_sec_courseCD igs_en_stdnt_ps_att.course_cd%TYPE;
2889: l_primaryInd igs_en_stdnt_ps_att.primary_program_type%TYPE;
2890: l_pri_prg VARCHAR2(1);
2891:
2892: BEGIN

Line 2889: l_primaryInd igs_en_stdnt_ps_att.primary_program_type%TYPE;

2885: l_sua_check VARCHAR2(1);
2886: l_sua_unconfirm_check VARCHAR2(1);
2887: l_career igs_ps_ver.course_type%TYPE;
2888: l_sec_courseCD igs_en_stdnt_ps_att.course_cd%TYPE;
2889: l_primaryInd igs_en_stdnt_ps_att.primary_program_type%TYPE;
2890: l_pri_prg VARCHAR2(1);
2891:
2892: BEGIN
2893: -- fetch all program attempts using the application context parameters passed.

Line 3110: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

3106:
3107: END LOOP; -- end of looping through unit sets attempts
3108: END IF; --end of pre-enrollment year check
3109:
3110: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
3111: X_ROWID => vcur_spa.rowid,
3112: X_PERSON_ID => vcur_spa.PERSON_ID,
3113: X_COURSE_CD => vcur_spa.COURSE_CD,
3114: X_ADVANCED_STANDING_IND => vcur_spa.ADVANCED_STANDING_IND,

Line 3215: from igs_en_stdnt_ps_att_all spa

3211: cp_adm_appl_number NUMBER,
3212: cp_adm_nom_course_cd VARCHAR2,
3213: cp_adm_sequence_num NUMBER) IS
3214: Select spa.rowid
3215: from igs_en_stdnt_ps_att_all spa
3216: where spa.person_id=cp_person_id
3217: and spa.adm_admission_appl_number=cp_adm_appl_number
3218: and spa.adm_nominated_course_cd=cp_adm_nom_course_cd
3219: and spa.adm_sequence_number = cp_adm_sequence_num;

Line 3224: FROM igs_en_stdnt_ps_att_all spa

3220:
3221: -- Get the details of
3222: CURSOR cur_spa_en IS
3223: SELECT spa.rowid
3224: FROM igs_en_stdnt_ps_att_all spa
3225: WHERE spa.person_id = p_person_id
3226: AND spa.course_cd = p_nominated_course_cd;
3227:
3228: l_message VARCHAR2(200);