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_SUA_LGCY_PUB dependencies on IGS_PS_UNIT_OFR_OPT

Line 493: IF NOT igs_ps_unit_ofr_opt_pkg.get_pk_for_validation (

489: g_sua_status := 'INVALID';
490: END IF;
491:
492: -- Foreign Key Validation - Check if Unit is being Offered.
493: IF NOT igs_ps_unit_ofr_opt_pkg.get_pk_for_validation (
494: x_unit_cd => p_sua_dtls_rec.unit_cd,
495: x_version_number => NVL ( p_sua_dtls_rec.version_number,p_unit_version_number),
496: x_cal_type => p_cal_type,
497: x_ci_sequence_number => p_ci_sequence_number,

Line 758: FROM igs_ps_unit_ofr_opt uoo

754: --
755: -- Cursor to get the Enrollment Actual for a Unit section.
756: CURSOR usec_upd_enr_act IS
757: SELECT ROWID,uoo.enrollment_actual, uoo.waitlist_actual
758: FROM igs_ps_unit_ofr_opt uoo
759: WHERE uoo_id = p_uoo_id
760: FOR UPDATE NOWAIT;
761:
762: --

Line 799: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE := 0 ;

795: l_spa_row_sec get_spa_sec_prgm %ROWTYPE;
796:
797: l_usec_row usec_upd_enr_act%ROWTYPE;
798: l_message_name VARCHAR2(60) := NULL ;
799: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE := 0 ;
800: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE:= 0 ;
801:
802: l_return_status VARCHAR2(1) := NULL ;
803: l_msg_count NUMBER := 0;

Line 800: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE:= 0 ;

796:
797: l_usec_row usec_upd_enr_act%ROWTYPE;
798: l_message_name VARCHAR2(60) := NULL ;
799: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE := 0 ;
800: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE:= 0 ;
801:
802: l_return_status VARCHAR2(1) := NULL ;
803: l_msg_count NUMBER := 0;
804: l_msg_data VARCHAR2(2000) := NULL ;

Line 860: UPDATE igs_ps_unit_ofr_opt_all SET enrollment_actual = l_enrollment_actual WHERE ROWID = l_usec_row.ROWID;

856: -- Increment the Total enrollment actual count by 1.
857: l_enrollment_actual := NVL(l_usec_row.ENROLLMENT_ACTUAL,0)+1;
858:
859: BEGIN
860: UPDATE igs_ps_unit_ofr_opt_all SET enrollment_actual = l_enrollment_actual WHERE ROWID = l_usec_row.ROWID;
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF (usec_upd_enr_act%ISOPEN) THEN

Line 879: UPDATE igs_ps_unit_ofr_opt_all SET waitlist_actual = l_waitlist_actual WHERE ROWID = l_usec_row.ROWID ;

875: -- Increment the Total waitlist actual count by 1.
876: l_waitlist_actual := NVL(l_usec_row.WAITLIST_ACTUAL,0)+1;
877:
878: BEGIN
879: UPDATE igs_ps_unit_ofr_opt_all SET waitlist_actual = l_waitlist_actual WHERE ROWID = l_usec_row.ROWID ;
880:
881: EXCEPTION
882: WHEN OTHERS THEN
883: IF (usec_upd_enr_act%ISOPEN) THEN

Line 1053: FROM igs_ps_unit_ofr_opt

1049: --
1050: -- Cursor to check if the auditable_ind is available at the unit section level.
1051: CURSOR get_audit_usec IS
1052: SELECT NVL(auditable_ind, 'N')
1053: FROM igs_ps_unit_ofr_opt
1054: WHERE uoo_id = p_uoo_id;
1055:
1056: CURSOR c_get_wlst_alwd_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1057: SELECT NVL(waitlist_allowed,'N') waitlist_allowed,NVL(max_students_per_waitlist,9999) max_students_per_waitlist

Line 1056: CURSOR c_get_wlst_alwd_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1052: SELECT NVL(auditable_ind, 'N')
1053: FROM igs_ps_unit_ofr_opt
1054: WHERE uoo_id = p_uoo_id;
1055:
1056: CURSOR c_get_wlst_alwd_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1057: SELECT NVL(waitlist_allowed,'N') waitlist_allowed,NVL(max_students_per_waitlist,9999) max_students_per_waitlist
1058: FROM igs_ps_usec_lim_wlst
1059: WHERE cp_uoo_id=uoo_id;
1060:

Line 1062: CURSOR c_get_wlst_alwd_oopt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1058: FROM igs_ps_usec_lim_wlst
1059: WHERE cp_uoo_id=uoo_id;
1060:
1061:
1062: CURSOR c_get_wlst_alwd_oopt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1063: SELECT NVL(uop.waitlist_allowed,'N') waitlist_allowed ,NVL(uop.max_students_per_waitlist,9999) max_students_per_waitlist
1064: FROM igs_ps_unit_ofr_pat uop,
1065: igs_ps_unit_ofr_opt uoo
1066: WHERE uop.unit_cd=uoo.unit_cd

Line 1065: igs_ps_unit_ofr_opt uoo

1061:
1062: CURSOR c_get_wlst_alwd_oopt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1063: SELECT NVL(uop.waitlist_allowed,'N') waitlist_allowed ,NVL(uop.max_students_per_waitlist,9999) max_students_per_waitlist
1064: FROM igs_ps_unit_ofr_pat uop,
1065: igs_ps_unit_ofr_opt uoo
1066: WHERE uop.unit_cd=uoo.unit_cd
1067: AND uop.version_number=uoo.version_number
1068: AND uop.cal_type=uoo.cal_type
1069: AND uop.ci_sequence_number=uoo.ci_sequence_number

Line 1075: CURSOR c_get_wlst_actual_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1071: AND uop.delete_flag='N';
1072:
1073:
1074:
1075: CURSOR c_get_wlst_actual_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1076: SELECT waitlist_actual
1077: FROM igs_ps_unit_ofr_opt
1078: WHERE uoo_id=p_uoo_id;
1079:

Line 1077: FROM igs_ps_unit_ofr_opt

1073:
1074:
1075: CURSOR c_get_wlst_actual_usec (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1076: SELECT waitlist_actual
1077: FROM igs_ps_unit_ofr_opt
1078: WHERE uoo_id=p_uoo_id;
1079:
1080: -- cursor to get version number for person and course
1081: CURSOR c_get_prog_ver(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 1126: CURSOR c_get_usec_relation(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1122:
1123: --
1124: -- Cursor to determine if the unit section is superior or subordinate
1125: --
1126: CURSOR c_get_usec_relation(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1127: SELECT NVL(RELATION_TYPE,'NONE')
1128: FROM igs_ps_unit_ofr_opt
1129: WHERE uoo_id = cp_uoo_id;
1130:

Line 1128: FROM igs_ps_unit_ofr_opt

1124: -- Cursor to determine if the unit section is superior or subordinate
1125: --
1126: CURSOR c_get_usec_relation(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1127: SELECT NVL(RELATION_TYPE,'NONE')
1128: FROM igs_ps_unit_ofr_opt
1129: WHERE uoo_id = cp_uoo_id;
1130:
1131: --
1132: -- Cursor to get superior unit section details

Line 1134: CURSOR c_get_superior_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1130:
1131: --
1132: -- Cursor to get superior unit section details
1133: --
1134: CURSOR c_get_superior_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1135: SELECT unit_cd,version_number
1136: FROM igs_ps_unit_ofr_opt
1137: WHERE uoo_id = (SELECT sup_uoo_id
1138: FROM igs_ps_unit_ofr_opt

Line 1136: FROM igs_ps_unit_ofr_opt

1132: -- Cursor to get superior unit section details
1133: --
1134: CURSOR c_get_superior_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1135: SELECT unit_cd,version_number
1136: FROM igs_ps_unit_ofr_opt
1137: WHERE uoo_id = (SELECT sup_uoo_id
1138: FROM igs_ps_unit_ofr_opt
1139: WHERE uoo_id = cp_uoo_id);
1140:

Line 1138: FROM igs_ps_unit_ofr_opt

1134: CURSOR c_get_superior_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1135: SELECT unit_cd,version_number
1136: FROM igs_ps_unit_ofr_opt
1137: WHERE uoo_id = (SELECT sup_uoo_id
1138: FROM igs_ps_unit_ofr_opt
1139: WHERE uoo_id = cp_uoo_id);
1140:
1141: -- Cursor to select the Term Calendar associated with a Teaching Calendar.
1142: CURSOR c_get_term_cal(cp_cal_type igs_ca_inst.cal_type%TYPE,

Line 1185: l_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE;

1181: l_wlst_suas NUMBER;
1182: l_max_wlst_per_stud NUMBER;
1183: l_prog_version_spat igs_en_stdnt_ps_att.version_number%TYPE;
1184:
1185: l_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE;
1186: l_get_superior_usec_rec c_get_superior_usec%ROWTYPE;
1187: l_sup_sub_status igs_en_su_attempt.unit_attempt_status%TYPE;
1188: l_term_cal_dtls c_get_term_cal%ROWTYPE;
1189:

Line 1840: FROM igs_ps_unit_ofr_opt

1836:
1837:
1838: CURSOR c_lock_parent_usec (cp_uoo_id IN NUMBER) IS
1839: SELECT uoo_id
1840: FROM igs_ps_unit_ofr_opt
1841: WHERE uoo_id=cp_uoo_id
1842: FOR UPDATE;
1843:
1844: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS

Line 1866: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

1862: l_adm_unit_status VARCHAR2(2000);
1863: l_alias_val igs_ca_da_inst.absolute_val%TYPE ;
1864:
1865: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
1866: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1867: l_cal_type igs_en_su_attempt.cal_type%TYPE;
1868: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%TYPE;
1869: l_ci_start_dt igs_ca_inst.start_dt%TYPE;
1870:

Line 1902: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

1898: l_pref_weight NUMBER;
1899: l_pri_weight NUMBER;
1900: l_wlst_position NUMBER;
1901:
1902: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
1903: l_sup_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
1904: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
1905: l_stat_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
1906: l_override_enrollment_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

Line 1903: l_sup_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;

1899: l_pri_weight NUMBER;
1900: l_wlst_position NUMBER;
1901:
1902: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
1903: l_sup_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
1904: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
1905: l_stat_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
1906: l_override_enrollment_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
1907: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;