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_EN_STDNT_PS_ATT

Line 466: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (

462: g_sua_status := 'INVALID';
463: END IF;
464:
465: -- Foreign Key Validation - Check if Student Program Attempt exists.
466: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
467: x_person_id => p_person_id,
468: x_course_cd => p_sua_dtls_rec.program_cd) THEN
469:
470: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');

Line 766: FROM igs_en_stdnt_ps_att spa

762: --
763: -- Cursor to fetch Student Program Details .
764: CURSOR get_spa IS
765: SELECT ROWID , spa.*
766: FROM igs_en_stdnt_ps_att spa
767: WHERE spa.person_id = p_person_id AND
768: spa.course_cd = p_sua_dtls_rec.program_cd
769: FOR UPDATE NOWAIT;
770:

Line 783: FROM igs_en_stdnt_ps_att spa , igs_en_sca_v sca

779: --
780: -- Cursor to fetch all the secondary Programs in a career for the given Primary Program
781: CURSOR get_spa_sec_prgm (p_course_type IN VARCHAR2 ) IS
782: SELECT spa.ROWID
783: FROM igs_en_stdnt_ps_att spa , igs_en_sca_v sca
784: WHERE spa.person_id = p_person_id AND
785: spa.person_id = sca.person_id AND
786: sca.course_cd = spa.course_cd AND
787: sca.course_type = p_course_type AND

Line 805: l_course_attempt_status_after igs_en_stdnt_ps_att.course_attempt_status%TYPE := NULL ;

801:
802: l_return_status VARCHAR2(1) := NULL ;
803: l_msg_count NUMBER := 0;
804: l_msg_data VARCHAR2(2000) := NULL ;
805: l_course_attempt_status_after igs_en_stdnt_ps_att.course_attempt_status%TYPE := NULL ;
806: l_last_dt_of_att igs_en_stdnt_ps_att.last_date_of_attendance%TYPE := NULL ;
807:
808: BEGIN
809:

Line 806: l_last_dt_of_att igs_en_stdnt_ps_att.last_date_of_attendance%TYPE := NULL ;

802: l_return_status VARCHAR2(1) := NULL ;
803: l_msg_count NUMBER := 0;
804: l_msg_data VARCHAR2(2000) := NULL ;
805: l_course_attempt_status_after igs_en_stdnt_ps_att.course_attempt_status%TYPE := NULL ;
806: l_last_dt_of_att igs_en_stdnt_ps_att.last_date_of_attendance%TYPE := NULL ;
807:
808: BEGIN
809:
810: IF p_unit_attempt_status ='WAITLISTED' THEN

Line 972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,

968:
969: -- If the course attempt status changes as a result of the Unit Import , Update the Course Attempt Status .
970: BEGIN
971: IF l_last_dt_of_att IS NOT NULL THEN
972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,
973: LAST_DATE_OF_ATTENDANCE = l_last_dt_of_att WHERE ROWID = l_spa_row.ROWID;
974: ELSE
975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;
976: END IF;

Line 975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;

971: IF l_last_dt_of_att IS NOT NULL THEN
972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,
973: LAST_DATE_OF_ATTENDANCE = l_last_dt_of_att WHERE ROWID = l_spa_row.ROWID;
974: ELSE
975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;
976: END IF;
977:
978: -- If the Primary Program Status is updated, mirror all the secondary Programs with the same status as the primary program.
979: IF l_spa_row.primary_program_type = 'PRIMARY' THEN

Line 982: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = get_spa_sec_prgm_rec.ROWID ;

978: -- If the Primary Program Status is updated, mirror all the secondary Programs with the same status as the primary program.
979: IF l_spa_row.primary_program_type = 'PRIMARY' THEN
980: FOR get_spa_sec_prgm_rec IN get_spa_sec_prgm(l_course_type)
981: LOOP
982: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = get_spa_sec_prgm_rec.ROWID ;
983: END LOOP;
984: END IF;
985:
986: EXCEPTION

Line 1081: CURSOR c_get_prog_ver(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

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,
1082: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1083: SELECT version_number
1084: FROM igs_en_stdnt_ps_att
1085: WHERE

Line 1082: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

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,
1082: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1083: SELECT version_number
1084: FROM igs_en_stdnt_ps_att
1085: WHERE
1086: person_id = cp_person_id AND

Line 1084: FROM igs_en_stdnt_ps_att

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,
1082: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1083: SELECT version_number
1084: FROM igs_en_stdnt_ps_att
1085: WHERE
1086: person_id = cp_person_id AND
1087: course_cd = cp_course_cd;
1088:

Line 1119: FROM igs_en_Stdnt_ps_att

1115: --
1116: -- Cursor to get the Discontinued Date of the Program Attempt
1117: CURSOR get_prgm_discd_dt IS
1118: SELECT discontinued_dt
1119: FROM igs_en_Stdnt_ps_att
1120: WHERE course_cd = p_sua_dtls_rec.program_cd
1121: AND person_id = p_person_id;
1122:
1123: --

Line 1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;

1155:
1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;
1158: l_version_number igs_as_grd_sch_grade.version_number%TYPE := 0 ;
1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;
1161:
1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;
1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;

Line 1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;

1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;
1158: l_version_number igs_as_grd_sch_grade.version_number%TYPE := 0 ;
1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;
1161:
1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;
1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;
1164: l_person_id igs_pe_person.person_id%TYPE;

Line 1165: l_discontin_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE;

1161:
1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;
1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;
1164: l_person_id igs_pe_person.person_id%TYPE;
1165: l_discontin_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE;
1166:
1167: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL ;
1168: l_count NUMBER := 0 ;
1169: l_message_name VARCHAR2(60) := NULL ;

Line 1174: l_commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE;

1170: l_message_token VARCHAR2(2000) := NULL ;
1171:
1172: l_boolean BOOLEAN := TRUE;
1173: l_legacy VARCHAR2(1) ;
1174: l_commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE;
1175: l_prgm_ver igs_en_stdnt_ps_att.version_number%TYPE;
1176:
1177: l_msg_count NUMBER ;
1178: l_msg_data VARCHAR2(2000);

Line 1175: l_prgm_ver igs_en_stdnt_ps_att.version_number%TYPE;

1171:
1172: l_boolean BOOLEAN := TRUE;
1173: l_legacy VARCHAR2(1) ;
1174: l_commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE;
1175: l_prgm_ver igs_en_stdnt_ps_att.version_number%TYPE;
1176:
1177: l_msg_count NUMBER ;
1178: l_msg_data VARCHAR2(2000);
1179: l_wlst_alwd c_get_wlst_alwd_usec%ROWTYPE;

Line 1183: l_prog_version_spat igs_en_stdnt_ps_att.version_number%TYPE;

1179: l_wlst_alwd c_get_wlst_alwd_usec%ROWTYPE;
1180: l_wlst_actual NUMBER;
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;

Line 1874: l_program_attempt_status igs_en_Stdnt_ps_Att.course_attempt_status%TYPE;

1870:
1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
1872: l_version_number igs_en_su_attempt.version_number%TYPE;
1873: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
1874: l_program_attempt_status igs_en_Stdnt_ps_Att.course_attempt_status%TYPE;
1875: l_career_model_enabled VARCHAR2(1);
1876: l_return_status VARCHAR2(30);
1877:
1878: l_cart_status VARCHAR2(1);