DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_PS_OFR_OPT

Line 501: v_course_cd IGS_PS_OFR_OPT.course_cd%TYPE;

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;

Line 502: v_version_number IGS_PS_OFR_OPT.version_number%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;

Line 503: v_cal_type IGS_PS_OFR_OPT.cal_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;

Line 504: v_location_cd IGS_PS_OFR_OPT.location_cd%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:

Line 505: v_attendance_mode IGS_PS_OFR_OPT.attendance_mode%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:
509: CURSOR c_IGS_EN_STDNT_PS_ATT IS

Line 506: v_attendance_type IGS_PS_OFR_OPT.attendance_type%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
510: SELECT ROWID,

Line 507: v_coo_id IGS_PS_OFR_OPT.coo_id%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,
511: IGS_EN_STDNT_PS_ATT.*