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

Line 61: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

57: DECLARE
58: v_closed_ind VARCHAR2(1);
59: v_error_ind NUMBER(5) := 0;
60: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
61: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
62: v_pee_seq_num IGS_PE_PERSENC_EFFCT.sequence_number%TYPE;
63: v_message_string VARCHAR2(5512);
64: v_return_type VARCHAR2(1);
65: CURSOR c_s_encmb_effect_type (

Line 85: FROM IGS_EN_STDNT_PS_ATT

81: FROM IGS_EN_ENCMB_EFCTTYP_V
82: WHERE s_encmb_effect_type = cp_s_encmb_effect_type;
83: CURSOR c_student_course_attempt IS
84: SELECT course_cd
85: FROM IGS_EN_STDNT_PS_ATT
86: WHERE person_id = p_person_id AND
87: course_attempt_status NOT IN ('DISCONTIN', 'COMPLETED', 'DELETED', 'LAPSED',
88: 'UNCONFIRM');
89:

Line 441: || This will get called from the igs_en_stdnt_ps_att_pkg.

437: /*
438: || Created By : [email protected]
439: || Created On : 22-NOV-2001
440: || Purpose : Added this procedure as per the UK Award Aims DLD.
441: || This will get called from the igs_en_stdnt_ps_att_pkg.
442: || Change History :
443: || Who When What
444: || anilk 30-Sep-2003 Changed for Program Completion Validation build
445: || Prajeesh Chandran .K 11-Jun-2002

Line 474: FROM igs_en_stdnt_ps_att

470: course_cd = p_course_cd;
471:
472: CURSOR cur_course IS
473: SELECT commencement_dt, course_rqrmnt_complete_ind
474: FROM igs_en_stdnt_ps_att
475: WHERE person_id = p_person_id AND
476: course_cd = p_course_cd AND
477: version_number = p_version_number;
478:

Line 731: FROM IGS_EN_STDNT_PS_ATT sca,

727: v_dummy VARCHAR2(1);
728:
729: CURSOR c_am IS
730: SELECT am.govt_attendance_mode
731: FROM IGS_EN_STDNT_PS_ATT sca,
732: IGS_EN_ATD_MODE am
733: WHERE sca.person_id = p_person_id AND
734: sca.course_cd = p_course_cd AND
735: am.attendance_mode = sca.attendance_mode;

Line 1499: -- IGS_EN_STDNT_PS_ATT.attendance_type is changed.

1495: RETURN BOOLEAN AS
1496:
1497: BEGIN -- enrp_ins_sca_cah
1498: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1499: -- IGS_EN_STDNT_PS_ATT.attendance_type is changed.
1500: -- The following is validated:
1501: -- Research IGS_RE_CANDIDATURE exists.
1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained
1503: DECLARE

Line 1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

1628: --stutta 11-Dec-2004 Replace insert_row of igs_as_sc_attempt_h_pkg with add_row. This is done
1629: -- avoid record already exists msg when more than one history record is created
1630: -- within the same second. Bug # 4061929
1631: PROCEDURE Enrp_Ins_Sca_Hist(
1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,

Line 1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

1629: -- avoid record already exists msg when more than one history record is created
1630: -- within the same second. Bug # 4061929
1631: PROCEDURE Enrp_Ins_Sca_Hist(
1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,

Line 1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

1630: -- within the same second. Bug # 4061929
1631: PROCEDURE Enrp_Ins_Sca_Hist(
1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,

1631: PROCEDURE Enrp_Ins_Sca_Hist(
1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

Line 1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,

1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,

Line 1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,

1633: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,

Line 1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

1634: p_new_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,

Line 1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,

1635: p_old_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,

Line 1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,

1636: p_new_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

Line 1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,

1637: p_old_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.cal_type%TYPE ,
1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

Line 1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,

1638: p_new_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

Line 1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,

1639: p_old_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

Line 1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

1640: p_new_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

Line 1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,

1641: p_old_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.attendance_mode%TYPE ,
1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

Line 1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

1642: p_new_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,

Line 1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,

1643: p_old_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.attendance_type%TYPE ,
1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,

Line 1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

1644: p_new_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

Line 1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,

1645: p_old_student_confirmed_ind IN IGS_EN_STDNT_PS_ATT_ALL.student_confirmed_ind%TYPE ,
1646: p_new_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1647: p_old_commencement_dt IN IGS_EN_STDNT_PS_ATT_ALL.commencement_dt%TYPE ,
1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

Line 1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

1648: p_new_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

Line 1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,

1649: p_old_course_attempt_status IN IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE ,
1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

Line 1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,

1650: p_new_progression_status IN VARCHAR2 ,
1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

Line 1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,

1651: p_old_progression_status IN VARCHAR2 ,
1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

Line 1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

1652: p_new_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,

Line 1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,

1653: p_old_derived_att_type IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_type%TYPE ,
1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,

Line 1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

1654: p_new_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,

Line 1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,

1655: p_old_derived_att_mode IN IGS_EN_STDNT_PS_ATT_ALL.derived_att_mode%TYPE ,
1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,

Line 1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,

1656: p_new_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,

Line 1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,

1657: p_old_provisional_ind IN IGS_EN_STDNT_PS_ATT_ALL.provisional_ind%TYPE ,
1658: p_new_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1659: p_old_discontinued_dt IN IGS_EN_STDNT_PS_ATT_ALL.discontinued_dt%TYPE ,
1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,

Line 1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,

1660: p_new_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

Line 1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,

1661: p_old_dscntntn_reason_cd IN IGS_EN_STDNT_PS_ATT_ALL.discontinuation_reason_cd%TYPE ,
1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

Line 1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,

1662: p_new_lapsed_dt IN DATE ,
1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

Line 1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,

1663: p_old_lapsed_dt IN DATE ,
1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

Line 1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

1664: p_new_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

Line 1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,

1665: p_old_funding_source IN IGS_EN_STDNT_PS_ATT_ALL.funding_source%TYPE ,
1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

Line 1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

1666: p_new_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

Line 1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,

1667: p_old_exam_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.exam_location_cd%TYPE ,
1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

Line 1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

1668: p_new_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

Line 1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,

1669: p_old_derived_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_yr%TYPE ,
1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

Line 1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

1670: p_new_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

Line 1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,

1671: p_old_derived_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.derived_completion_perd%TYPE ,
1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

Line 1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

1672: p_new_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

Line 1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,

1673: p_old_nominated_cmpltn_yr IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_yr%TYPE ,
1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

Line 1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

1674: p_new_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

Line 1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,

1675: p_old_nominated_cmpltn_perd IN IGS_EN_STDNT_PS_ATT_ALL.nominated_completion_perd%TYPE ,
1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

Line 1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

1676: p_new_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

Line 1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,

1677: p_old_rule_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.rule_check_ind%TYPE ,
1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

Line 1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

1678: p_new_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1686: p_new_crs_rqrmnts_complete_dt IN DATE ,

Line 1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,

1679: p_old_waive_option_check_ind IN IGS_EN_STDNT_PS_ATT_ALL.waive_option_check_ind%TYPE ,
1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1686: p_new_crs_rqrmnts_complete_dt IN DATE ,
1687: p_old_crs_rqrmnts_complete_dt IN DATE ,

Line 1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

1680: p_new_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1686: p_new_crs_rqrmnts_complete_dt IN DATE ,
1687: p_old_crs_rqrmnts_complete_dt IN DATE ,
1688: p_new_s_completed_source_type IN VARCHAR2 ,

Line 1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,

1681: p_old_last_rule_check_dt IN IGS_EN_STDNT_PS_ATT_ALL.last_rule_check_dt%TYPE ,
1682: p_new_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1683: p_old_publish_outcomes_ind IN IGS_EN_STDNT_PS_ATT_ALL.publish_outcomes_ind%TYPE ,
1684: p_new_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1685: p_old_crs_rqrmnt_complete_ind IN IGS_EN_STDNT_PS_ATT_ALL.course_rqrmnt_complete_ind%TYPE ,
1686: p_new_crs_rqrmnts_complete_dt IN DATE ,
1687: p_old_crs_rqrmnts_complete_dt IN DATE ,
1688: p_new_s_completed_source_type IN VARCHAR2 ,
1689: p_old_s_completed_source_type IN VARCHAR2 ,

Line 1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,

1686: p_new_crs_rqrmnts_complete_dt IN DATE ,
1687: p_old_crs_rqrmnts_complete_dt IN DATE ,
1688: p_new_s_completed_source_type IN VARCHAR2 ,
1689: p_old_s_completed_source_type IN VARCHAR2 ,
1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

Line 1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,

1687: p_old_crs_rqrmnts_complete_dt IN DATE ,
1688: p_new_s_completed_source_type IN VARCHAR2 ,
1689: p_old_s_completed_source_type IN VARCHAR2 ,
1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

Line 1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,

1688: p_new_s_completed_source_type IN VARCHAR2 ,
1689: p_old_s_completed_source_type IN VARCHAR2 ,
1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1696: p_new_self_help_group_ind IN VARCHAR2 ,

Line 1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,

1689: p_old_s_completed_source_type IN VARCHAR2 ,
1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1696: p_new_self_help_group_ind IN VARCHAR2 ,
1697: p_old_self_help_group_ind IN VARCHAR2 ,

Line 1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

1690: p_new_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1696: p_new_self_help_group_ind IN VARCHAR2 ,
1697: p_old_self_help_group_ind IN VARCHAR2 ,
1698: p_new_correspondence_cat IN VARCHAR2 ,

Line 1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

1691: p_old_override_time_limitation IN IGS_EN_STDNT_PS_ATT_ALL.override_time_limitation%TYPE ,
1692: p_new_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1693: p_old_advanced_standing_ind IN IGS_EN_STDNT_PS_ATT_ALL.advanced_standing_ind%TYPE ,
1694: p_new_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1696: p_new_self_help_group_ind IN VARCHAR2 ,
1697: p_old_self_help_group_ind IN VARCHAR2 ,
1698: p_new_correspondence_cat IN VARCHAR2 ,
1699: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.correspondence_cat%TYPE ,

Line 1699: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.correspondence_cat%TYPE ,

1695: p_old_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1696: p_new_self_help_group_ind IN VARCHAR2 ,
1697: p_old_self_help_group_ind IN VARCHAR2 ,
1698: p_new_correspondence_cat IN VARCHAR2 ,
1699: p_old_correspondence_cat IN IGS_EN_STDNT_PS_ATT_ALL.correspondence_cat%TYPE ,
1700: p_new_adm_adm_appl_number IN NUMBER ,
1701: p_old_adm_adm_appl_number IN NUMBER ,
1702: p_new_adm_nominated_course_cd IN VARCHAR2 ,
1703: p_old_adm_nominated_course_cd IN VARCHAR2 ,

Line 1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,

1702: p_new_adm_nominated_course_cd IN VARCHAR2 ,
1703: p_old_adm_nominated_course_cd IN VARCHAR2 ,
1704: p_new_adm_sequence_number IN NUMBER ,
1705: p_old_adm_sequence_number IN NUMBER ,
1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,

Line 1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,

1703: p_old_adm_nominated_course_cd IN VARCHAR2 ,
1704: p_new_adm_sequence_number IN NUMBER ,
1705: p_old_adm_sequence_number IN NUMBER ,
1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,

Line 1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,

1704: p_new_adm_sequence_number IN NUMBER ,
1705: p_old_adm_sequence_number IN NUMBER ,
1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,

Line 1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,

1705: p_old_adm_sequence_number IN NUMBER ,
1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,

Line 1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,

1706: p_new_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,

Line 1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,

1707: p_old_update_who IN IGS_EN_STDNT_PS_ATT_ALL.last_updated_by%TYPE ,
1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,

Line 1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,

1708: p_new_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,

Line 1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,

1709: p_old_update_on IN IGS_EN_STDNT_PS_ATT_ALL.last_update_date%TYPE ,
1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,

Line 1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,

1710: p_new_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,

Line 1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,

1711: p_old_last_date_of_attendance IN IGS_EN_STDNT_PS_ATT_ALL.last_date_of_attendance%TYPE ,
1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,

Line 1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,

1712: p_new_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,

Line 1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,

1713: p_old_dropped_by IN IGS_EN_STDNT_PS_ATT_ALL.dropped_by%TYPE ,
1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,

Line 1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,

1714: p_new_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,

Line 1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,

1715: p_old_primary_program_type IN IGS_EN_STDNT_PS_ATT_ALL.primary_program_type%TYPE ,
1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,

Line 1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,

1716: p_new_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE,
1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,

Line 1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,

1717: p_old_primary_prog_type_source IN IGS_EN_STDNT_PS_ATT_ALl.primary_prog_type_source%TYPE ,
1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,

Line 1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,

1718: p_new_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,

Line 1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,

1719: p_old_catalog_cal_type IN IGS_EN_STDNT_PS_ATT_ALl.catalog_cal_type%TYPE ,
1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,

Line 1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,

1720: p_new_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE,
1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

Line 1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,

1721: p_old_catalog_seq_num IN IGS_EN_STDNT_PS_ATT_ALl.catalog_seq_num%TYPE ,
1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

Line 1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,

1722: p_new_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,

Line 1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,

1723: p_old_key_program IN IGS_EN_STDNT_PS_ATT_ALl.key_program%TYPE ,
1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,
1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE

Line 1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

1724: p_new_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,
1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE
1732: )

Line 1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,

1725: p_old_override_cmpl_dt IN IGS_EN_STDNT_PS_ATT_ALL.override_cmpl_dt%TYPE ,
1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,
1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE
1732: )
1733: AS

Line 1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,

1726: p_new_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE ,
1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,
1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE
1732: )
1733: AS
1734:

Line 1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE

1727: p_old_manual_ovr_cmpl_dt_ind IN IGS_EN_STDNT_PS_ATT_ALL.manual_ovr_cmpl_dt_ind%TYPE,
1728: p_new_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1729: p_old_coo_id IN IGS_EN_STDNT_PS_ATT_ALL.coo_id%TYPE,
1730: p_new_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE,
1731: p_old_igs_pr_class_std_id IGS_EN_STDNT_PS_ATT_ALL.igs_pr_class_std_id%TYPE
1732: )
1733: AS
1734:
1735: BEGIN

Line 2556: FROM igs_en_stdnt_ps_att

2552: SELECT location_cd,
2553: attendance_mode,
2554: attendance_type,
2555: version_number
2556: FROM igs_en_stdnt_ps_att
2557: WHERE person_id = p_person_id
2558: AND course_cd = p_program_cd;
2559:
2560: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;