1 PACKAGE IGS_AS_GRD_ATT_BE_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSAS53S.pls 115.0 2002/12/26 09:49:01 ddey noship $ */
3
4 PROCEDURE Wf_Inform_Admin_CG
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,
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,
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
32 );
33 PROCEDURE Wf_Inform_Admin_Grd
34 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
35 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
36 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
37 p_title IN igs_ps_unit_ver_all.title%TYPE,
38 p_instructor IN hz_parties.party_name%TYPE,
39 p_submission_date IN DATE,
40 p_requestor_id IN VARCHAR2 /* Added by aiyer for the bug 2403814 */
41 );
42 PROCEDURE Wf_Inform_Admin_Grd_mt
43 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
44 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
45 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
46 p_title IN igs_ps_unit_ver_all.title%TYPE,
47 p_instructor IN hz_parties.party_name%TYPE,
48 p_submission_date IN DATE
49 );
50 PROCEDURE Wf_Inform_Admin_Attd
51 ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
52 p_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
53 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
54 p_title IN igs_ps_unit_ver_all.title%TYPE,
55 p_instructor IN hz_parties.party_name%TYPE,
56 p_submission_date IN DATE
57 );
58 PROCEDURE Wf_Inform_Admin_IncGrd
59 ( p_person_id IN igs_as_su_stmptout.person_id%TYPE ,
60 p_course_cd IN igs_as_su_stmptout.course_cd%TYPE,
61 p_unit_cd IN igs_as_su_stmptout.unit_cd%TYPE,
62 p_cal_type IN igs_as_su_stmptout.cal_type%TYPE,
63 p_ci_seq_num IN igs_as_su_stmptout.ci_sequence_number%TYPE,
64 p_date_changed IN DATE,
65 p_old_grade IN igs_as_su_stmptout.grade%TYPE,
66 p_new_grade IN igs_as_su_stmptout.incomp_default_grade%TYPE
67 );
68 PROCEDURE Wf_Inform_Admin_IncGrdSub
69 ( p_person_id IN igs_as_su_stmptout.person_id%TYPE ,
70 p_course_cd IN igs_as_su_stmptout.course_cd%TYPE,
71 p_unit_cd IN igs_as_su_stmptout.unit_cd%TYPE,
72 p_cal_type IN igs_as_su_stmptout.cal_type%TYPE,
73 p_ci_seq_num IN igs_as_su_stmptout.ci_sequence_number%TYPE,
74 p_grade IN igs_as_su_stmptout.grade%TYPE,
75 p_incomp_deadline_dt IN igs_as_su_stmptout.incomp_deadline_date%TYPE,
76 p_incomp_default_grd IN igs_as_su_stmptout.incomp_default_grade%TYPE,
77 p_incomp_default_mark IN igs_as_su_stmptout.incomp_default_mark%TYPE,
78 p_date_submitted IN DATE
79 );
80 END IGS_AS_GRD_ATT_BE_PKG;