1 PACKAGE igs_as_notify_pkg AS
2 /* $Header: IGSAS40S.pls 120.0 2005/07/05 12:49:07 appldev noship $ */
3
4 /*
5 || Created By : nmankodi
6 || Created On : 01-FEB-2002
7 || Purpose : To Generate Notifications for Attendance and Grading.
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || Who When What
11 || (reverse chronological order - newest change first)
12 */
13
14 PROCEDURE gen_as_notifications (
15 errbuf OUT NOCOPY VARCHAR2, -- Standard Error Buffer Variable
16 retcode OUT NOCOPY NUMBER, -- Standard Concurrent Return code
17 p_load_calendar IN VARCHAR2, -- Load Calendar ( Concatenated value of Calandar Type and Sequence Number )
18 p_attend_advance_offset IN NUMBER, -- No. of Days offset for Attendance Submission advanced notification.
19 p_attend_start_offset IN NUMBER, -- No. of Days offset for Attendance Submission is available notification.
20 p_attend_end_offset IN NUMBER, -- No. of Days offset for Attendance Submission is ending soon notification.
21 p_midterm_advance_offset IN NUMBER, -- No. of Days offset for Mid Term Grading submission advanced notification.
22 p_midterm_start_offset IN NUMBER, -- No. of Days offset for Mid Term Grading submission is available notification.
23 p_midterm_end_offset IN NUMBER, -- No. of Days offset for Mid Term Grading submission is ending soon notification.
24 p_earlyfinal_advance_offset IN NUMBER, -- No. of Days offset for Early-Final Grading Submission advanced notification.
25 p_earlyfinal_start_offset IN NUMBER, -- No. of Days offset for Early-Final Grading Submission is available notification.
26 p_earlyfinal_end_offset IN NUMBER, -- No. of Days offset for Early-Final Grading Submission is ending soon notification.
27 p_final_advance_offset IN NUMBER, -- No. of Days offset for Final Grading Submission advanced notification.
28 p_final_start_offset IN NUMBER, -- No. of Days offset for Final Grading Submission is available notification.
29 p_final_end_offset IN NUMBER -- No. of Days offset for Final Grading Submission is ending soon notification.
30 -- Offsets can be Positive,Zero or NULL.
31 -- NULL means that the notification will not be generated.
32 -- Zero means Notification will be generated if the Alias Date is todate.
33 -- Positive Offset means before the Alias Date.
34 );
35 PROCEDURE raise_sua_ref_cd_be( P_AUTH_PERSON_ID IN NUMBER,
36 P_PERSON_ID IN NUMBER,
37 P_SUAR_ID IN NUMBER,
38 P_ACTION IN VARCHAR2 );
39
40 END igs_as_notify_pkg;