DBA Data[Home] [Help]

APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PS_OFR_OPT

Line 75: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,

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,

Line 76: p_version_number IN igs_ps_ofr_opt.version_number%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)

Line 77: p_cal_type IN igs_ps_ofr_opt.cal_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;

Line 78: p_location_cd IN igs_ps_ofr_opt.location_cd%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:

Line 79: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,

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(

Line 80: p_attendance_type IN igs_ps_ofr_opt.attendance_type%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(
84: p_class_standing IN igs_pr_class_std.class_standing%TYPE)

Line 81: RETURN igs_ps_ofr_opt.coo_id%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;