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_GEN_012 dependencies on IGS_EN_STDNT_PS_ATT

Line 6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2: /* $Header: IGSEN12B.pls 120.9 2006/04/13 01:52:36 smaddali ship $ */
3: /*-------------------------------------------------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
7: call as a part of bug 3544927.
8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call
9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

Line 13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207
13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.
15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
16: --pradhakr 07-Dec-2001 Added a column deg_aud_detail_id in the TBH calls
17: -- of IGS_EN_SU_ATTEMPT_PKG as part of

Line 489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

485: || Purpose :
486: || Known limitations, enhancements or remarks :
487: || Change History :
488: || Who When What
489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
491: || call as a part of bug 3544927.
492: || smaddali 04-jul-03 Bug No: 3035523
493: || Added the logic for updating the version number in hesa program attempt details belonging to this program attempt

Line 490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

486: || Known limitations, enhancements or remarks :
487: || Change History :
488: || Who When What
489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
491: || call as a part of bug 3544927.
492: || smaddali 04-jul-03 Bug No: 3035523
493: || Added the logic for updating the version number in hesa program attempt details belonging to this program attempt
494: || (reverse chronological order - newest change first)

Line 509: CURSOR c_IGS_EN_STDNT_PS_ATT IS

505: v_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE;
506: v_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;
507: v_coo_id IGS_PS_OFR_OPT.coo_id%TYPE;
508:
509: CURSOR c_IGS_EN_STDNT_PS_ATT IS
510: SELECT ROWID,
511: IGS_EN_STDNT_PS_ATT.*
512: FROM IGS_EN_STDNT_PS_ATT
513: WHERE person_id = p_person_id AND

Line 511: IGS_EN_STDNT_PS_ATT.*

507: v_coo_id IGS_PS_OFR_OPT.coo_id%TYPE;
508:
509: CURSOR c_IGS_EN_STDNT_PS_ATT IS
510: SELECT ROWID,
511: IGS_EN_STDNT_PS_ATT.*
512: FROM IGS_EN_STDNT_PS_ATT
513: WHERE person_id = p_person_id AND
514: course_cd = p_course_cd
515: FOR UPDATE NOWAIT;

Line 512: FROM IGS_EN_STDNT_PS_ATT

508:
509: CURSOR c_IGS_EN_STDNT_PS_ATT IS
510: SELECT ROWID,
511: IGS_EN_STDNT_PS_ATT.*
512: FROM IGS_EN_STDNT_PS_ATT
513: WHERE person_id = p_person_id AND
514: course_cd = p_course_cd
515: FOR UPDATE NOWAIT;
516:

Line 557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP

553: v_attendance_type);
554:
555: -- Having gotten the lock, update the record.
556:
557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP
558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,

Line 559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

555: -- Having gotten the lock, update the record.
556:
557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP
558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,

Line 560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,

556:
557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP
558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,

Line 561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,

557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP
558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,

Line 562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,

558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,

Line 563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,

559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,

Line 564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,

560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,

Line 565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,

561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,

Line 566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,

562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,
570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,

Line 567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,

563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,
564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,
570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,
571: X_VERSION_NUMBER => p_version_number,

Line 568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,

564: X_FEE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.FEE_CAT,
565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,
570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,
571: X_VERSION_NUMBER => p_version_number,
572: X_CAL_TYPE => p_cal_type,

Line 569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,

565: X_CORRESPONDENCE_CAT => c_IGS_EN_STDNT_PS_ATT_rec.CORRESPONDENCE_CAT,
566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,
570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,
571: X_VERSION_NUMBER => p_version_number,
572: X_CAL_TYPE => p_cal_type,
573: X_LOCATION_CD => p_location_cd,

Line 570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,

566: X_SELF_HELP_GROUP_IND => c_IGS_EN_STDNT_PS_ATT_rec.SELF_HELP_GROUP_IND,
567: X_LOGICAL_DELETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.LOGICAL_DELETE_DT,
568: X_ADM_ADMISSION_APPL_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_ADMISSION_APPL_NUMBER,
569: X_ADM_NOMINATED_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.ADM_NOMINATED_COURSE_CD,
570: X_ADM_SEQUENCE_NUMBER => c_IGS_EN_STDNT_PS_ATT_rec.ADM_SEQUENCE_NUMBER,
571: X_VERSION_NUMBER => p_version_number,
572: X_CAL_TYPE => p_cal_type,
573: X_LOCATION_CD => p_location_cd,
574: X_ATTENDANCE_MODE => p_attendance_mode,

Line 577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,

573: X_LOCATION_CD => p_location_cd,
574: X_ATTENDANCE_MODE => p_attendance_mode,
575: X_ATTENDANCE_TYPE => p_attendance_type,
576: X_COO_ID => v_coo_id,
577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,
578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,

Line 578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,

574: X_ATTENDANCE_MODE => p_attendance_mode,
575: X_ATTENDANCE_TYPE => p_attendance_type,
576: X_COO_ID => v_coo_id,
577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,
578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,

Line 579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,

575: X_ATTENDANCE_TYPE => p_attendance_type,
576: X_COO_ID => v_coo_id,
577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,
578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,

Line 580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,

576: X_COO_ID => v_coo_id,
577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,
578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,

Line 581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,

577: X_STUDENT_CONFIRMED_IND => c_IGS_EN_STDNT_PS_ATT_rec.STUDENT_CONFIRMED_IND,
578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,

Line 582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,

578: X_COMMENCEMENT_DT => c_IGS_EN_STDNT_PS_ATT_rec.COMMENCEMENT_DT,
579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,

Line 583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,

579: X_COURSE_ATTEMPT_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_ATTEMPT_STATUS,
580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,

Line 584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,

580: X_PROGRESSION_STATUS => c_IGS_EN_STDNT_PS_ATT_rec.PROGRESSION_STATUS,
581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,

Line 585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,

581: X_DERIVED_ATT_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_TYPE,
582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,

Line 586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,

582: X_DERIVED_ATT_MODE => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_ATT_MODE,
583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,

Line 587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,

583: X_PROVISIONAL_IND => c_IGS_EN_STDNT_PS_ATT_rec.PROVISIONAL_IND,
584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,

Line 588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,

584: X_DISCONTINUED_DT => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUED_DT,
585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,

Line 589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,

585: X_DISCONTINUATION_REASON_CD => c_IGS_EN_STDNT_PS_ATT_rec.DISCONTINUATION_REASON_CD,
586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,

Line 590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,

586: X_LAPSED_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAPSED_DT,
587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,

Line 591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,

587: X_FUNDING_SOURCE => c_IGS_EN_STDNT_PS_ATT_rec.FUNDING_SOURCE,
588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,

Line 592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,

588: X_EXAM_LOCATION_CD => c_IGS_EN_STDNT_PS_ATT_rec.EXAM_LOCATION_CD,
589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,

Line 593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,

589: X_DERIVED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_YR,
590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,

Line 594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,

590: X_DERIVED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.DERIVED_COMPLETION_PERD,
591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,

Line 595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,

591: X_NOMINATED_COMPLETION_YR => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_YR,
592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,

Line 596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,

592: X_NOMINATED_COMPLETION_PERD => c_IGS_EN_STDNT_PS_ATT_rec.NOMINATED_COMPLETION_PERD,
593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,

Line 597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,

593: X_RULE_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.RULE_CHECK_IND,
594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',

Line 598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,

594: X_WAIVE_OPTION_CHECK_IND => c_IGS_EN_STDNT_PS_ATT_rec.WAIVE_OPTION_CHECK_IND,
595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,

Line 599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,

595: X_LAST_RULE_CHECK_DT => c_IGS_EN_STDNT_PS_ATT_rec.LAST_RULE_CHECK_DT,
596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,

Line 600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,

596: X_PUBLISH_OUTCOMES_IND => c_IGS_EN_STDNT_PS_ATT_rec.PUBLISH_OUTCOMES_IND,
597: X_COURSE_RQRMNT_COMPLETE_IND => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNT_COMPLETE_IND,
598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,

Line 602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,

598: X_COURSE_RQRMNTS_COMPLETE_DT => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_RQRMNTS_COMPLETE_DT,
599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,

Line 603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,

599: X_S_COMPLETED_SOURCE_TYPE => c_IGS_EN_STDNT_PS_ATT_rec.S_COMPLETED_SOURCE_TYPE,
600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,

Line 604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,

600: X_OVERRIDE_TIME_LIMITATION => c_IGS_EN_STDNT_PS_ATT_rec.OVERRIDE_TIME_LIMITATION,
601: X_MODE => 'R',
602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,

Line 606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,

602: X_LAST_DATE_OF_ATTENDANCE => c_IGS_EN_STDNT_PS_ATT_rec.LAST_DATE_OF_ATTENDANCE,
603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,

Line 607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,

603: X_DROPPED_BY => c_IGS_EN_STDNT_PS_ATT_rec.DROPPED_BY,
604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr

Line 608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,

604: X_IGS_PR_CLASS_STD_ID => c_IGS_EN_STDNT_PS_ATT_rec.IGS_PR_CLASS_STD_ID,
605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,

Line 609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,

605: -- Added next four parameters as per the Career Impact Build Bug# 2027984
606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,

Line 610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,

606: x_primary_program_type => c_IGS_EN_STDNT_PS_ATT_rec.primary_program_type,
607: x_primary_prog_type_source => c_IGS_EN_STDNT_PS_ATT_rec.primary_prog_type_source,
608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927

Line 612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,

608: x_catalog_cal_type => c_IGS_EN_STDNT_PS_ATT_rec.catalog_cal_type,
609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,

Line 613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,

609: x_catalog_seq_num => c_IGS_EN_STDNT_PS_ATT_rec.catalog_seq_num,
610: x_key_program => c_IGS_EN_STDNT_PS_ATT_rec.key_program,
611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,

Line 615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,

611: -- The following two parameters were added as part of EN015 build. Bug# 2158654 - pradhakr
612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,

Line 616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,

612: x_override_cmpl_dt => c_IGS_EN_STDNT_PS_ATT_rec.override_cmpl_dt,
613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,

Line 617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,

613: x_manual_ovr_cmpl_dt_ind => c_IGS_EN_STDNT_PS_ATT_rec.manual_ovr_cmpl_dt_ind,
614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,

Line 618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,

614: -- added by ckasu as part of bug # 3544927
615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,

Line 619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,

615: X_ATTRIBUTE_CATEGORY => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE_CATEGORY,
616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,

Line 620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,

616: X_ATTRIBUTE1 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE1,
617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,

Line 621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,

617: X_ATTRIBUTE2 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE2,
618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,

Line 622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,

618: X_ATTRIBUTE3 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE3,
619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,

Line 623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,

619: X_ATTRIBUTE4 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE4,
620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,

Line 624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,

620: X_ATTRIBUTE5 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE5,
621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,

Line 625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,

621: X_ATTRIBUTE6 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE6,
622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,

Line 626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,

622: X_ATTRIBUTE7 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE7,
623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,

Line 627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,

623: X_ATTRIBUTE8 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE8,
624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,

Line 628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,

624: X_ATTRIBUTE9 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE9,
625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,

Line 629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,

625: X_ATTRIBUTE10 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE10,
626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,

Line 630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,

626: X_ATTRIBUTE11 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE11,
627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,

Line 631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,

627: X_ATTRIBUTE12 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE12,
628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,

Line 632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,

628: X_ATTRIBUTE13 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE13,
629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,
636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);

Line 633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,

629: X_ATTRIBUTE14 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE14,
630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,
636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);
637:

Line 634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,

630: X_ATTRIBUTE15 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE15,
631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,
636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);
637:
638:

Line 635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,

631: X_ATTRIBUTE16 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE16,
632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,
636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);
637:
638:
639:

Line 636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);

632: X_ATTRIBUTE17 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE17,
633: X_ATTRIBUTE18 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE18,
634: X_ATTRIBUTE19 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE19,
635: X_ATTRIBUTE20 => c_IGS_EN_STDNT_PS_ATT_rec.ATTRIBUTE20,
636: X_FUTURE_DATED_TRANS_FLAG => c_IGS_EN_STDNT_PS_ATT_rec.FUTURE_DATED_TRANS_FLAG);
637:
638:
639:
640: -- Start of the New code added as per the HESA bug#3035523

Line 641: IF ( c_igs_en_stdnt_ps_att_rec.version_number <> p_version_number AND

637:
638:
639:
640: -- Start of the New code added as per the HESA bug#3035523
641: IF ( c_igs_en_stdnt_ps_att_rec.version_number <> p_version_number AND
642: fnd_profile.value('OSS_COUNTRY_CODE') = 'GB' ) THEN
643:
644: BEGIN
645: FOR c_upd_spa_rec IN c_upd_spa LOOP

Line 827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

823: || Purpose :
824: || Known limitations, enhancements or remarks :
825: || Change History :
826: || Who When What
827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
829: || call as a part of bug 3544927.
830: || kkillams 21-03-2003 Added new parameter p_transf_course_cd to the function.
831: || Which will distigush the from where this function was called.

Line 828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

824: || Known limitations, enhancements or remarks :
825: || Change History :
826: || Who When What
827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
829: || call as a part of bug 3544927.
830: || kkillams 21-03-2003 Added new parameter p_transf_course_cd to the function.
831: || Which will distigush the from where this function was called.
832: || Value will be passed if function is invoked from program transfer

Line 847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;

843: */
844: RETURN BOOLEAN AS
845: BEGIN
846: DECLARE
847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;
848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;
850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

846: DECLARE
847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;
848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;
850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
852: v_alias_val DATE;
853: v_message_name VARCHAR2(30);
854: v_admin_unit_status_str VARCHAR2(2000);

Line 851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;
848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;
850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
852: v_alias_val DATE;
853: v_message_name VARCHAR2(30);
854: v_admin_unit_status_str VARCHAR2(2000);
855: v_other_detail VARCHAR2(255);

Line 863: l_primary_prg_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE;

859: cst_intermit CONSTANT VARCHAR2(8) := 'INTERMIT';
860: cst_discontinue CONSTANT VARCHAR2(10) := 'DISCONTIN';
861: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED';
862: cst_waitlisted CONSTANT VARCHAR2(10) := 'WAITLISTED';
863: l_primary_prg_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE;
864: v_dummy VARCHAR2(1);
865: -- added for bug 3526251
866: NO_AUSL_RECORD_FOUND EXCEPTION;
867: PRAGMA EXCEPTION_INIT(NO_AUSL_RECORD_FOUND , -20010);

Line 870: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

866: NO_AUSL_RECORD_FOUND EXCEPTION;
867: PRAGMA EXCEPTION_INIT(NO_AUSL_RECORD_FOUND , -20010);
868:
869: CURSOR c_sua
870: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
871: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
872: SELECT sua.person_id,
873: sua.course_cd,
874: sua.unit_cd,

Line 871: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

867: PRAGMA EXCEPTION_INIT(NO_AUSL_RECORD_FOUND , -20010);
868:
869: CURSOR c_sua
870: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
871: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
872: SELECT sua.person_id,
873: sua.course_cd,
874: sua.unit_cd,
875: sua.version_number,

Line 890: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

886: ORDER BY sup_unit_cd ASC
887: FOR UPDATE NOWAIT;
888:
889: CURSOR c_suao_check
890: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
891: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
892: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
893: SELECT suao.person_id
894: FROM IGS_AS_SU_STMPTOUT suao

Line 891: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

887: FOR UPDATE NOWAIT;
888:
889: CURSOR c_suao_check
890: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
891: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
892: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
893: SELECT suao.person_id
894: FROM IGS_AS_SU_STMPTOUT suao
895: WHERE suao.person_id = cp_person_id AND

Line 900: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

896: suao.course_cd = cp_course_cd AND
897: suao.uoo_id = cp_uoo_id;
898:
899: CURSOR c_sca_check
900: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
901: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
902: SELECT sca.course_attempt_status, primary_program_type
903: FROM IGS_EN_STDNT_PS_ATT sca
904: WHERE sca.person_id = cp_person_id AND

Line 901: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

897: suao.uoo_id = cp_uoo_id;
898:
899: CURSOR c_sca_check
900: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
901: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
902: SELECT sca.course_attempt_status, primary_program_type
903: FROM IGS_EN_STDNT_PS_ATT sca
904: WHERE sca.person_id = cp_person_id AND
905: sca.course_cd = cp_course_cd;

Line 903: FROM IGS_EN_STDNT_PS_ATT sca

899: CURSOR c_sca_check
900: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
901: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
902: SELECT sca.course_attempt_status, primary_program_type
903: FROM IGS_EN_STDNT_PS_ATT sca
904: WHERE sca.person_id = cp_person_id AND
905: sca.course_cd = cp_course_cd;
906:
907: CURSOR c_prgs_in_career IS

Line 909: FROM igs_en_stdnt_ps_att spa, igs_ps_ver pv1, igs_ps_ver pv2

905: sca.course_cd = cp_course_cd;
906:
907: CURSOR c_prgs_in_career IS
908: SELECT 'X'
909: FROM igs_en_stdnt_ps_att spa, igs_ps_ver pv1, igs_ps_ver pv2
910: WHERE spa.person_id = p_person_id
911: AND spa.course_cd = p_transf_course_cd -- dest course cd
912: AND pv1.course_cd = spa.course_cd
913: AND pv1.version_number = spa.version_number

Line 938: -- This module updates the IGS_EN_STDNT_PS_ATT future dated

934: AND dcnt_unit_ind ='Y'
935: AND s_discontinuation_reason_type IS NULL;
936:
937: BEGIN
938: -- This module updates the IGS_EN_STDNT_PS_ATT future dated
939: -- discontinuation. This will need to do the following :
940: -- 1. Discontinue/delete currently enrolled student_unit_attmmpts :
941: -- a) check to see if a IGS_EN_SU_ATTEMPT can be deleted
942: -- as defined by IGS_PS_UNIT Discontinuation date Criteria

Line 953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be

949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation
950: -- details
951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status
952: -- (this is done by table database trigger)
953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be
954: -- discontinued
955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default
956: -- IGS_EN_DCNT_REASONCD
957: -- 4. Set IGS_EN_STDNT_PS_ATT.course_attempt_status (this

Line 955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default

951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status
952: -- (this is done by table database trigger)
953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be
954: -- discontinued
955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default
956: -- IGS_EN_DCNT_REASONCD
957: -- 4. Set IGS_EN_STDNT_PS_ATT.course_attempt_status (this
958: -- is done by table database trigger).
959: --

Line 957: -- 4. Set IGS_EN_STDNT_PS_ATT.course_attempt_status (this

953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be
954: -- discontinued
955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default
956: -- IGS_EN_DCNT_REASONCD
957: -- 4. Set IGS_EN_STDNT_PS_ATT.course_attempt_status (this
958: -- is done by table database trigger).
959: --
960: -- IGS_GE_NOTE : This process will be called to the update student_
961: -- course_attempt.course_attempt_status process that

Line 1410: -- discontinue IGS_EN_STDNT_PS_ATT

1406: END LOOP;
1407: -- Suspend the current session to overcome problem of multiple updates
1408: -- affecting the SCA history table with primary key conflicts.
1409: DBMS_LOCK.SLEEP (1);
1410: -- discontinue IGS_EN_STDNT_PS_ATT
1411: -- validate discontinuation
1412: IF (Igs_En_Val_Sca.enrp_val_sca_discont(
1413: p_person_id,
1414: p_course_cd,

Line 1436: -- discontinue IGS_EN_STDNT_PS_ATT

1432: CLOSE c_sca_check;
1433: IF v_sca_status IN
1434: (cst_enrolled, cst_lapsed, cst_inactive, cst_intermit) OR
1435: (v_sca_status= cst_discontinue AND l_primary_prg_type='PRIMARY' AND p_source = 'PROGRAM_TRANSFER' )THEN
1436: -- discontinue IGS_EN_STDNT_PS_ATT
1437:
1438: DECLARE
1439: CURSOR c_si_en_stnd_ps_att IS
1440: SELECT ROWID, IGS_EN_STDNT_PS_ATT.*

Line 1440: SELECT ROWID, IGS_EN_STDNT_PS_ATT.*

1436: -- discontinue IGS_EN_STDNT_PS_ATT
1437:
1438: DECLARE
1439: CURSOR c_si_en_stnd_ps_att IS
1440: SELECT ROWID, IGS_EN_STDNT_PS_ATT.*
1441: FROM IGS_EN_STDNT_PS_ATT
1442: WHERE person_id = p_person_id AND
1443: course_cd = p_course_cd;
1444: BEGIN

Line 1441: FROM IGS_EN_STDNT_PS_ATT

1437:
1438: DECLARE
1439: CURSOR c_si_en_stnd_ps_att IS
1440: SELECT ROWID, IGS_EN_STDNT_PS_ATT.*
1441: FROM IGS_EN_STDNT_PS_ATT
1442: WHERE person_id = p_person_id AND
1443: course_cd = p_course_cd;
1444: BEGIN
1445:

Line 1461: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

1457: CLOSE c_prgs_in_career;
1458:
1459: END IF;
1460:
1461: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
1462: X_ROWID => c_si_en_stnd_ps_att_rec.ROWID,
1463: X_PERSON_ID => c_si_en_stnd_ps_att_rec.PERSON_ID,
1464: X_COURSE_CD => c_si_en_stnd_ps_att_rec.COURSE_CD,
1465: X_ADVANCED_STANDING_IND => c_si_en_stnd_ps_att_rec.ADVANCED_STANDING_IND,

Line 1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

1585: BEGIN
1586: /****************************************************************************
1587: History
1588: Who When Why
1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1591: call as a part of bug 3544927.
1592:
1593:

Line 1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

1586: /****************************************************************************
1587: History
1588: Who When Why
1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1591: call as a part of bug 3544927.
1592:
1593:
1594: *****************************************************************************/

Line 1645: FROM IGS_EN_STDNT_PS_ATT sca,

1641: --modified for perf bug 3699543 : sqlid 14792129
1642: CURSOR c_sca_crv IS
1643: SELECT sca.person_id,
1644: sca.course_cd
1645: FROM IGS_EN_STDNT_PS_ATT sca,
1646: IGS_PS_VER crv
1647: WHERE sca.cal_type = p_acad_cal_type AND
1648: sca.course_cd LIKE p_course_cd AND
1649: sca.course_attempt_status = cst_inactive AND

Line 1715: FROM IGS_EN_STDNT_PS_ATT sca

1711: CURSOR c_sca (
1712: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1713: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1714: SELECT ROWID,sca.*
1715: FROM IGS_EN_STDNT_PS_ATT sca
1716: WHERE sca.person_id = cp_person_id AND
1717: sca.course_cd = cp_course_cd
1718: FOR UPDATE NOWAIT;
1719: v_sca_exists c_sca%ROWTYPE;

Line 1848: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

1844: v_sca_crv_rec.person_id,
1845: v_sca_crv_rec.course_cd);
1846: FETCH c_sca INTO v_sca_exists;
1847: IF (c_sca%FOUND) THEN
1848: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
1849: X_ROWID => v_sca_exists.ROWID,
1850: X_PERSON_ID => v_sca_exists.PERSON_ID,
1851: X_COURSE_CD => v_sca_exists.COURSE_CD,
1852: X_ADVANCED_STANDING_IND => v_sca_exists.ADVANCED_STANDING_IND,

Line 2126: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2122: p_person_id IN NUMBER ,
2123: p_course_cd IN VARCHAR2 ,
2124: p_message_name OUT NOCOPY VARCHAR2)
2125: RETURN BOOLEAN AS
2126: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2127: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
2128: IS
2129: SELECT sca.course_attempt_status
2130: FROM IGS_EN_STDNT_PS_ATT sca

Line 2127: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

2123: p_course_cd IN VARCHAR2 ,
2124: p_message_name OUT NOCOPY VARCHAR2)
2125: RETURN BOOLEAN AS
2126: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2127: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
2128: IS
2129: SELECT sca.course_attempt_status
2130: FROM IGS_EN_STDNT_PS_ATT sca
2131: WHERE sca.person_id = p_person_id AND

Line 2130: FROM IGS_EN_STDNT_PS_ATT sca

2126: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2127: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
2128: IS
2129: SELECT sca.course_attempt_status
2130: FROM IGS_EN_STDNT_PS_ATT sca
2131: WHERE sca.person_id = p_person_id AND
2132: sca.course_cd = p_course_cd;
2133: v_course_attempt_status IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2134: v_new_course_attempt_status

Line 2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

2137: v_person_id IGS_PE_PERSON.person_id%TYPE;
2138: /****************************************************************************
2139: History
2140: Who When Why
2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2143: call as a part of bug 3544927.
2144:
2145: *****************************************************************************/

Line 2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2138: /****************************************************************************
2139: History
2140: Who When Why
2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2143: call as a part of bug 3544927.
2144:
2145: *****************************************************************************/
2146: BEGIN

Line 2170: IGS_EN_STDNT_PS_ATT.*

2166: -- the exception handler.
2167: DECLARE
2168: CURSOR c_ps_att IS
2169: SELECT ROWID,
2170: IGS_EN_STDNT_PS_ATT.*
2171: FROM IGS_EN_STDNT_PS_ATT
2172: WHERE person_id = p_person_id AND
2173: course_cd = p_course_cd
2174: FOR UPDATE NOWAIT;

Line 2171: FROM IGS_EN_STDNT_PS_ATT

2167: DECLARE
2168: CURSOR c_ps_att IS
2169: SELECT ROWID,
2170: IGS_EN_STDNT_PS_ATT.*
2171: FROM IGS_EN_STDNT_PS_ATT
2172: WHERE person_id = p_person_id AND
2173: course_cd = p_course_cd
2174: FOR UPDATE NOWAIT;
2175: BEGIN

Line 2179: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

2175: BEGIN
2176: -- Having gotten the lock, update the record.
2177:
2178: FOR c_ps_att_rec IN c_ps_att LOOP
2179: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
2180: X_ROWID => c_ps_att_rec.ROWID,
2181: X_PERSON_ID => c_ps_att_rec.PERSON_ID,
2182: X_COURSE_CD => c_ps_att_rec.COURSE_CD,
2183: X_ADVANCED_STANDING_IND => c_ps_att_rec.ADVANCED_STANDING_IND,

Line 2439: IGS_EN_STDNT_PS_ATT sca

2435: sca.course_cd,
2436: sca.course_attempt_status
2437: FROM IGS_EN_STDNT_PS_INTM sci,
2438: IGS_EN_INTM_TYPES eit,
2439: IGS_EN_STDNT_PS_ATT sca
2440: WHERE sci.start_dt <= trunc(SYSDATE) AND
2441: sci.end_dt >= trunc(SYSDATE) AND
2442: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND
2443: sca.person_id = sci.person_id AND

Line 2461: IGS_EN_STDNT_PS_ATT sca

2457: sci.logical_delete_date,
2458: cond_return_flag
2459: FROM IGS_EN_STDNT_PS_INTM sci,
2460: IGS_EN_INTM_TYPES eit,
2461: IGS_EN_STDNT_PS_ATT sca
2462: WHERE sci.end_dt < TRUNC(SYSDATE) AND
2463: sca.person_id = sci.person_id AND
2464: sca.course_cd = sci.course_cd AND
2465: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND

Line 2472: FROM IGS_EN_STDNT_PS_ATT sca

2468: sca.course_attempt_status = 'INTERMIT';
2469:
2470: CURSOR c_scae IS
2471: SELECT sca.person_id, sca.course_cd, sca.course_attempt_status
2472: FROM IGS_EN_STDNT_PS_ATT sca
2473: WHERE sca.course_attempt_status = 'ENROLLED' AND
2474: (
2475: sca.discontinued_dt IS NULL OR
2476: sca.discontinued_dt > SYSDATE

Line 2499: FROM IGS_EN_STDNT_PS_ATT sca

2495: CURSOR c_sca_inactive IS
2496: SELECT sca.person_id,
2497: sca.course_cd,
2498: sca.course_attempt_status
2499: FROM IGS_EN_STDNT_PS_ATT sca
2500: WHERE sca.course_attempt_status IN ('INACTIVE','LAPSED') AND
2501: EXISTS (
2502: SELECT 'x'
2503: FROM IGS_EN_SU_ATTEMPT sua

Line 2517: FROM IGS_EN_STDNT_PS_ATT sca

2513: sca.course_attempt_status,
2514: sca.commencement_dt,
2515: sca.discontinued_dt,
2516: sca.discontinuation_reason_cd
2517: FROM IGS_EN_STDNT_PS_ATT sca
2518: WHERE sca.discontinued_dt IS NOT NULL AND
2519: sca.discontinued_dt <= SYSDATE AND
2520: sca.course_attempt_status NOT IN ('DISCONTIN',
2521: 'DELETED');

Line 2539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2535: l_rcond_exists c_sci_rcond%ROWTYPE;
2536:
2537:
2538: FUNCTION enrpl_upd_get_status(
2539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2541: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE)
2542: RETURN BOOLEAN
2543: AS

Line 2540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2536:
2537:
2538: FUNCTION enrpl_upd_get_status(
2539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2541: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE)
2542: RETURN BOOLEAN
2543: AS
2544: e_resource_busy_exception EXCEPTION;

Line 2541: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE)

2537:
2538: FUNCTION enrpl_upd_get_status(
2539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2541: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE)
2542: RETURN BOOLEAN
2543: AS
2544: e_resource_busy_exception EXCEPTION;
2545: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);

Line 2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

2554:
2555: /****************************************************************************
2556: History
2557: Who When Why
2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2560: call as a part of bug 3544927.
2561: *****************************************************************************/
2562: BEGIN -- enrpl_upd_get_status

Line 2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2555: /****************************************************************************
2556: History
2557: Who When Why
2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2560: call as a part of bug 3544927.
2561: *****************************************************************************/
2562: BEGIN -- enrpl_upd_get_status
2563:

Line 2579: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

2575: SAVEPOINT enrpl_upd_get_status_a;
2576:
2577: DECLARE
2578: v_new_course_attempt_status
2579: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2580: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
2581: BEGIN
2582:
2583:

Line 2580: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

2576:
2577: DECLARE
2578: v_new_course_attempt_status
2579: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2580: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
2581: BEGIN
2582:
2583:
2584: v_new_course_attempt_status := Igs_En_Gen_006.enrp_get_sca_status(

Line 2601: IGS_EN_STDNT_PS_ATT.*

2597:
2598: DECLARE
2599: CURSOR c_enps_att IS
2600: SELECT ROWID,
2601: IGS_EN_STDNT_PS_ATT.*
2602: FROM IGS_EN_STDNT_PS_ATT
2603: WHERE person_id = p_person_id AND
2604: course_cd = p_course_cd
2605: FOR UPDATE NOWAIT;

Line 2602: FROM IGS_EN_STDNT_PS_ATT

2598: DECLARE
2599: CURSOR c_enps_att IS
2600: SELECT ROWID,
2601: IGS_EN_STDNT_PS_ATT.*
2602: FROM IGS_EN_STDNT_PS_ATT
2603: WHERE person_id = p_person_id AND
2604: course_cd = p_course_cd
2605: FOR UPDATE NOWAIT;
2606: BEGIN

Line 2613: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

2609: FOR c_enps_att_rec IN c_enps_att LOOP
2610:
2611:
2612:
2613: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
2614: X_ROWID => c_enps_att_rec.ROWID,
2615: X_PERSON_ID => c_enps_att_rec.PERSON_ID,
2616: X_COURSE_CD => c_enps_att_rec.COURSE_CD,
2617: X_ADVANCED_STANDING_IND => c_enps_att_rec.ADVANCED_STANDING_IND,

Line 2856: -- This updates the IGS_EN_STDNT_PS_ATT.course_attempt_status

2852: END IF;
2853: END enrpl_upd_get_status;
2854:
2855: BEGIN
2856: -- This updates the IGS_EN_STDNT_PS_ATT.course_attempt_status
2857: -- when an element of the student's enrolment has chaged IN
2858: -- such a way as to require a re-derivation of their status.
2859: -- These things are :
2860: -- 1. If an intermission period has commenced and their

Line 3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

3147: v_change_made BOOLEAN;
3148: PROCEDURE enrpl_upd_invalid_ua(
3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3155: BEGIN

Line 3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

3148: PROCEDURE enrpl_upd_invalid_ua(
3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3155: BEGIN
3156: -- Re-check all INVALID IGS_PS_UNIT attempts and switch to ENROLLED if the rules

Line 3181: IGS_EN_STDNT_PS_ATT sca

3177: sua.cal_type,
3178: sua.ci_sequence_number,
3179: cst_enrolled) enrolled_cutoff_date
3180: FROM IGS_EN_SU_ATTEMPT sua,
3181: IGS_EN_STDNT_PS_ATT sca
3182: WHERE sua.person_id = p_person_id AND
3183: sua.course_cd = p_course_cd AND
3184: sua.unit_attempt_status = cst_invalid AND
3185: sca.person_id = sua.person_id AND

Line 3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

3424:
3425: PROCEDURE enrpl_upd_enrolled_ua(
3426: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3432: -------------------------------------------------------------------------------------------

Line 3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

3425: PROCEDURE enrpl_upd_enrolled_ua(
3426: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3432: -------------------------------------------------------------------------------------------
3433: -- Check all ENROLLED IGS_PS_UNIT attempt IGS_PS_UNIT rules. If a IGS_RU_RULE is failed the

Line 3444: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

3440: -------------------------------------------------------------------------------------------
3441: BEGIN
3442: DECLARE
3443: -- Add the following one line of code. From Callista 2.0 18-May-2000
3444: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
3445: --
3446: CURSOR c_sua IS
3447: SELECT sua.person_id,
3448: sua.course_cd,

Line 3466: FROM IGS_EN_STDNT_PS_ATT sca

3462: sua.rule_waived_dt IS NULL;
3463: -- Add the following five lines of code. From Callista 2.0 18-May-2000
3464: CURSOR c_sca IS
3465: SELECT sca.version_number
3466: FROM IGS_EN_STDNT_PS_ATT sca
3467: WHERE sca.person_id = p_person_id AND
3468: sca.course_cd = p_course_cd;
3469:
3470: lv_rule_failed VARCHAR2(30);