71: x_course_cd IN VARCHAR2,
72: x_last_date_of_attendance OUT NOCOPY DATE );
73:
74: FUNCTION get_coo_id(
75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
72: x_last_date_of_attendance OUT NOCOPY DATE );
73:
74: FUNCTION get_coo_id(
75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
73:
74: FUNCTION get_coo_id(
75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81: RETURN igs_ps_ofr_opt.coo_id%TYPE;
74: FUNCTION get_coo_id(
75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81: RETURN igs_ps_ofr_opt.coo_id%TYPE;
82:
75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81: RETURN igs_ps_ofr_opt.coo_id%TYPE;
82:
83: FUNCTION get_class_std_id(
76: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81: RETURN igs_ps_ofr_opt.coo_id%TYPE;
82:
83: FUNCTION get_class_std_id(
84: p_class_standing IN igs_pr_class_std.class_standing%TYPE)
77: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81: RETURN igs_ps_ofr_opt.coo_id%TYPE;
82:
83: FUNCTION get_class_std_id(
84: p_class_standing IN igs_pr_class_std.class_standing%TYPE)
85: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE;