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_SU_ATTEMPT

Line 97: igs_en_su_attempt_pkg.check_constraints(

93:
94: -- If Program Code is specified , it should be in Upper Case.
95: IF p_sua_dtls_rec.program_cd IS NOT NULL THEN
96: BEGIN
97: igs_en_su_attempt_pkg.check_constraints(
98: column_name => 'COURSE_CD' ,
99: column_value => p_sua_dtls_rec.program_cd );
100:
101: EXCEPTION

Line 115: igs_en_su_attempt_pkg.check_constraints(

111:
112: -- If Unit Code is specified , it should be in Upper Case.
113: IF p_sua_dtls_rec.unit_cd IS NOT NULL THEN
114: BEGIN
115: igs_en_su_attempt_pkg.check_constraints(
116: column_name => 'UNIT_CD' ,
117: column_value => p_sua_dtls_rec.unit_cd );
118: EXCEPTION
119: WHEN OTHERS THEN

Line 132: igs_en_su_attempt_pkg.check_constraints(

128:
129: -- If Location Code is specified , it should be in Upper Case.
130: IF p_sua_dtls_rec.location_cd IS NOT NULL THEN
131: BEGIN
132: igs_en_su_attempt_pkg.check_constraints(
133: column_name => 'LOCATION_CD' ,
134: column_value => p_sua_dtls_rec.location_cd );
135: EXCEPTION
136: WHEN OTHERS THEN

Line 149: igs_en_su_attempt_pkg.check_constraints(

145:
146: -- If Unit class is specified , it should be in Upper Case.
147: IF p_sua_dtls_rec.unit_class IS NOT NULL THEN
148: BEGIN
149: igs_en_su_attempt_pkg.check_constraints(
150: column_name => 'UNIT_CLASS' ,
151: column_value => p_sua_dtls_rec.unit_class );
152: EXCEPTION
153: WHEN OTHERS THEN

Line 172: igs_en_su_attempt_pkg.check_constraints(

168:
169: -- If Discontinuation Reason Code is specified , it should be in Upper Case.
170: IF p_sua_dtls_rec.dcnt_reason_cd IS NOT NULL THEN
171: BEGIN
172: igs_en_su_attempt_pkg.check_constraints(
173: column_name => 'DCNT_REASON_CD' ,
174: column_value => p_sua_dtls_rec.dcnt_reason_cd );
175: EXCEPTION
176: WHEN OTHERS THEN

Line 189: igs_en_su_attempt_pkg.check_constraints(

185:
186: -- If Assesment Indicator is specified , Permitted values are 'Y' or 'N'.
187: IF p_sua_dtls_rec.no_assessment_ind IS NOT NULL THEN
188: BEGIN
189: igs_en_su_attempt_pkg.check_constraints(
190: column_name => 'NO_ASSESSMENT_IND' ,
191: column_value => p_sua_dtls_rec.no_assessment_ind );
192: EXCEPTION
193: WHEN OTHERS THEN

Line 207: igs_en_su_attempt_pkg.check_constraints(

203: -- If Override Enrolled Credit Points are specified, it must be between 0 and 999.999.
204: IF p_sua_dtls_rec.override_enrolled_cp IS NOT NULL THEN
205: BEGIN
206:
207: igs_en_su_attempt_pkg.check_constraints(
208: column_name => 'OVERRIDE_ENROLLED_CP' ,
209: column_value => igs_ge_number.to_cann(p_sua_dtls_rec.override_enrolled_cp ));
210: EXCEPTION
211: WHEN OTHERS THEN

Line 224: igs_en_su_attempt_pkg.check_constraints(

220:
221: -- If Override Enrolled Achievable Points are specified, it must be between 0 and 999.999.
222: IF p_sua_dtls_rec.override_achievable_cp IS NOT NULL THEN
223: BEGIN
224: igs_en_su_attempt_pkg.check_constraints(
225: column_name => 'OVERRIDE_ACHIEVABLE_CP' ,
226: column_value => igs_ge_number.to_cann(p_sua_dtls_rec.override_achievable_cp ));
227:
228: EXCEPTION

Line 399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146

395: enhancements,
396: remarks :
397: Change History
398: Who When What
399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146
400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function
401: w.r.t. bug number 2829262
402: rvangala 02-OCT-2003 Added validation to check value of core_indicator, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
403: amuthu 29-JUL-2004 Added validation for Administrative unit status, to call

Line 400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function

396: remarks :
397: Change History
398: Who When What
399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146
400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function
401: w.r.t. bug number 2829262
402: rvangala 02-OCT-2003 Added validation to check value of core_indicator, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
403: amuthu 29-JUL-2004 Added validation for Administrative unit status, to call
404: the IGS_AD_ADM_UNIT_STAT_PKG.Get_PK_For_Validation, to

Line 410: IF igs_en_su_attempt_pkg.get_pk_for_validation (

406: -----------------------------------------------------------------------------*/
407: l_indicator BOOLEAN := false;
408: BEGIN
409: -- Primary Key validation
410: IF igs_en_su_attempt_pkg.get_pk_for_validation (
411: p_person_id ,
412: p_sua_dtls_rec.program_cd,
413: p_uoo_id) THEN
414: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_ATMPT_EXTS');

Line 420: IF igs_en_su_attempt_pkg.Get_Uk_For_Validation (

416: g_sua_status := 'WARNING';
417: RETURN;
418: END IF ;
419: -- Unique Key validation
420: IF igs_en_su_attempt_pkg.Get_Uk_For_Validation (
421: x_person_id => p_person_id ,
422: x_course_cd => p_sua_dtls_rec.program_cd,
423: x_unit_cd => p_sua_dtls_rec.unit_cd,
424: x_cal_type => p_cal_type,

Line 532: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE

528: p_sua_dtls_rec IN sua_dtls_rec_type ,
529: p_version_number IN NUMBER ,
530: p_cal_type IN VARCHAR2 ,
531: p_ci_sequence_number IN NUMBER,
532: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE
533: ) AS
534: /*------------------------------------------------------------------
535: Created By : SVENKATA
536: Date Created By : 12-NOV-02

Line 1102: CURSOR c_get_wlst_suas (cp_person_id igs_en_su_attempt.person_id%TYPE,

1098: CURSOR c_get_max_wlst_per_stud IS
1099: SELECT NVL(max_waitlists_student_num,9999) max_waitlists
1100: FROM IGS_EN_INST_WL_STPS;
1101:
1102: CURSOR c_get_wlst_suas (cp_person_id igs_en_su_attempt.person_id%TYPE,
1103: cp_load_cal_type igs_en_su_attempt.cal_type%TYPE,
1104: cp_load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
1105: SELECT COUNT(ROWID) waitlists
1106: FROM igs_en_su_attempt

Line 1103: cp_load_cal_type igs_en_su_attempt.cal_type%TYPE,

1099: SELECT NVL(max_waitlists_student_num,9999) max_waitlists
1100: FROM IGS_EN_INST_WL_STPS;
1101:
1102: CURSOR c_get_wlst_suas (cp_person_id igs_en_su_attempt.person_id%TYPE,
1103: cp_load_cal_type igs_en_su_attempt.cal_type%TYPE,
1104: cp_load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
1105: SELECT COUNT(ROWID) waitlists
1106: FROM igs_en_su_attempt
1107: WHERE person_id = cp_person_id AND

Line 1104: cp_load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS

1100: FROM IGS_EN_INST_WL_STPS;
1101:
1102: CURSOR c_get_wlst_suas (cp_person_id igs_en_su_attempt.person_id%TYPE,
1103: cp_load_cal_type igs_en_su_attempt.cal_type%TYPE,
1104: cp_load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
1105: SELECT COUNT(ROWID) waitlists
1106: FROM igs_en_su_attempt
1107: WHERE person_id = cp_person_id AND
1108: unit_attempt_status ='WAITLISTED' AND

Line 1106: FROM igs_en_su_attempt

1102: CURSOR c_get_wlst_suas (cp_person_id igs_en_su_attempt.person_id%TYPE,
1103: cp_load_cal_type igs_en_su_attempt.cal_type%TYPE,
1104: cp_load_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE) IS
1105: SELECT COUNT(ROWID) waitlists
1106: FROM igs_en_su_attempt
1107: WHERE person_id = cp_person_id AND
1108: unit_attempt_status ='WAITLISTED' AND
1109: (cal_type,ci_sequence_number) IN
1110: (SELECT teach_cal_type,teach_ci_sequence_number

Line 1167: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL ;

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 ;
1170: l_message_token VARCHAR2(2000) := NULL ;
1171:

Line 1187: l_sup_sub_status igs_en_su_attempt.unit_attempt_status%TYPE;

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:
1190:
1191: BEGIN

Line 1817: p_sup_unit_version_number and pass these values in the insert statements for IGS_EN_SU_ATTEMPT_ALL as part

1813: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_gen_007.enrp_get_sua_status function
1814: w.r.t. bug number 2829262
1815: rvangala 01-OCT-2003 Added core_indicator value in the INSERT statements, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
1816: ptandon 17-OCT-2003 Modified call to validate_sua to take into consideration two new OUT parameters p_sup_unit_cd and
1817: p_sup_unit_version_number and pass these values in the insert statements for IGS_EN_SU_ATTEMPT_ALL as part
1818: of Placements build. Enh Bug# 3052438.
1819: ------------------------------------------------------------------*/
1820:
1821: --

Line 1831: FROM igs_en_su_attempt sua

1827: attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6,
1828: attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 ,
1829: attribute13 , attribute14 , attribute15 , attribute16 , attribute17 , attribute18 ,
1830: attribute19 , attribute20,upd_audit_flag,ss_source_ind
1831: FROM igs_en_su_attempt sua
1832: WHERE sua.person_id = p_person_id AND
1833: sua.course_cd = p_transfer_program_cd AND
1834: sua.unit_cd = p_unit_cd AND
1835: sua.uoo_id = p_uoo_id;

Line 1844: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS

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
1845: SELECT NVL(MAX(administrative_priority),0)+1
1846: FROM igs_en_su_attempt
1847: WHERE uoo_id=cp_uoo_id
1848: AND waitlist_dt<=cp_waitlist_dt

Line 1846: FROM igs_en_su_attempt

1842: FOR UPDATE;
1843:
1844: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS
1845: SELECT NVL(MAX(administrative_priority),0)+1
1846: FROM igs_en_su_attempt
1847: WHERE uoo_id=cp_uoo_id
1848: AND waitlist_dt<=cp_waitlist_dt
1849: AND unit_attempt_status='WAITLISTED';
1850:

Line 1861: l_adm_unit_status_ret igs_en_su_attempt.administrative_unit_Status %TYPE;

1857: l_insert_flag BOOLEAN := TRUE;
1858:
1859: l_primary_program_type igs_en_sca_v.course_type%TYPE ;
1860: l_person_id igs_pe_person.person_id%TYPE;
1861: l_adm_unit_status_ret igs_en_su_attempt.administrative_unit_Status %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;

Line 1867: l_cal_type igs_en_su_attempt.cal_type%TYPE;

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:
1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;

Line 1868: l_ci_sequence_number igs_en_su_attempt.ci_Sequence_number%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:
1871: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
1872: l_version_number igs_en_su_attempt.version_number%TYPE;

Line 1872: l_version_number igs_en_su_attempt.version_number%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:
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);

Line 1873: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;

1869: l_ci_start_dt igs_ca_inst.start_dt%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:

Line 1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;

1882: l_current_string VARCHAR2(300) := NULL;
1883: l_msg_count NUMBER ;
1884: l_msg_data VARCHAR2(2000);
1885:
1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;
1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;

Line 1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;

1883: l_msg_count NUMBER ;
1884: l_msg_data VARCHAR2(2000);
1885:
1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;
1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;

Line 1888: l_created_by igs_en_su_attempt.created_by%TYPE;

1884: l_msg_data VARCHAR2(2000);
1885:
1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;
1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;

Line 1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;

1885:
1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;
1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;

Line 1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;

1886: l_creation_date igs_en_su_attempt.creation_date%TYPE;
1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;

Line 1891: l_request_id igs_en_su_attempt.request_id%TYPE;

1887: l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

Line 1892: l_program_id igs_en_su_attempt.program_id%TYPE;

1888: l_created_by igs_en_su_attempt.created_by%TYPE;
1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;

Line 1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;

1889: l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;
1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;

Line 1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;

1890: l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;
1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;
1898: l_pref_weight NUMBER;

Line 1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

1891: l_request_id igs_en_su_attempt.request_id%TYPE;
1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;
1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;
1898: l_pref_weight NUMBER;
1899: l_pri_weight NUMBER;

Line 1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;

1892: l_program_id igs_en_su_attempt.program_id%TYPE;
1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;
1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;
1898: l_pref_weight NUMBER;
1899: l_pri_weight NUMBER;
1900: l_wlst_position NUMBER;

Line 1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;

1893: l_program_application_id igs_en_su_attempt.program_application_id%TYPE;
1894: l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
1895: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1896: l_student_career_transcript igs_en_su_attempt.student_career_transcript%TYPE;
1897: l_student_career_statistics igs_en_su_attempt.student_career_statistics%TYPE;
1898: l_pref_weight NUMBER;
1899: l_pri_weight NUMBER;
1900: l_wlst_position NUMBER;
1901:

Line 1904: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';

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;
1908: --

Line 1905: l_stat_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;

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;
1908: --
1909: -- The architecture of the Insert API is briefly described below. The validatins are done in the order mentioned below.

Line 1906: l_override_enrollment_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

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;
1908: --
1909: -- The architecture of the Insert API is briefly described below. The validatins are done in the order mentioned below.
1910: -- 1. The routine validate_parameters is invoked to validate all params for Mandatory/check constraints

Line 1907: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%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;
1908: --
1909: -- The architecture of the Insert API is briefly described below. The validatins are done in the order mentioned below.
1910: -- 1. The routine validate_parameters is invoked to validate all params for Mandatory/check constraints
1911: -- 2. All required parameters are derived .

Line 2266: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2262: --
2263: -- If transfer is not applicable, insert values passed to the API . derived from source Unit Attempt.
2264: IF p_sua_dtls_rec.transfer_dt IS NULL THEN
2265:
2266: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2267: person_id,
2268: course_cd,
2269: unit_cd,
2270: version_number,

Line 2432: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2428: );
2429: l_stat_sua_status := l_unit_attempt_status;
2430: ELSE
2431: -- If transfer is applicable, insert values derived from source Unit Attempt.
2432: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2433: person_id,
2434: course_cd,
2435: unit_cd,
2436: version_number,