497: */
498:
499: v_other_detail VARCHAR2(255);
500: v_person_id IGS_PE_PERSON.person_id%TYPE;
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
505: v_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE;
498:
499: v_other_detail VARCHAR2(255);
500: v_person_id IGS_PE_PERSON.person_id%TYPE;
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
505: v_attendance_mode IGS_PS_OFR_OPT.attendance_mode%TYPE;
506: v_attendance_type IGS_PS_OFR_OPT.attendance_type%TYPE;
499: v_other_detail VARCHAR2(255);
500: v_person_id IGS_PE_PERSON.person_id%TYPE;
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
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;
500: v_person_id IGS_PE_PERSON.person_id%TYPE;
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
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:
501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
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
502: v_version_number IGS_PS_OFR_OPT.version_number%TYPE;
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
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,
503: v_cal_type IGS_PS_OFR_OPT.cal_type%TYPE;
504: v_location_cd IGS_PS_OFR_OPT.location_cd%TYPE;
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.*