[Home] [Help]
5: (
6: p_person_id IN VARCHAR2,
7: p_person_number IN hz_parties.party_number%TYPE,
8: p_person_name IN hz_parties.party_name%TYPE,
9: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
10: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
6: p_person_id IN VARCHAR2,
7: p_person_number IN hz_parties.party_number%TYPE,
8: p_person_name IN hz_parties.party_name%TYPE,
9: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
10: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
7: p_person_number IN hz_parties.party_number%TYPE,
8: p_person_name IN hz_parties.party_name%TYPE,
9: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
10: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
9: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
10: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
10: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
11: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
12: p_title IN igs_ps_unit_ver_all.title%TYPE,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
13: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
14: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
15: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
16: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
22: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
17: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
22: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
23: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
18: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
22: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
23: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
19: p_requester_name IN VARCHAR2,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
22: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
23: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
27: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
20: p_requester_number IN VARCHAR2,
21: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
22: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
23: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
27: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
28: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
23: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
27: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
28: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
29: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
30: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
31: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
24: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
27: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
28: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
29: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
30: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
31: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
32: );
25: p_start_dt IN DATE,
26: p_end_dt IN DATE,
27: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
28: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
29: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
30: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
31: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
32: );
33: PROCEDURE Wf_Inform_Admin_Grd