1 PACKAGE igs_as_notify_student AUTHID CURRENT_USER AS
2 /* $Header: IGSAS50S.pls 115.4 2003/12/04 06:03:02 ddey noship $ */
3
4 /*************************************************************
5 Created By :Deepankar Dey
6 Date Created on : 21-Sept-2002
7 Purpose : This package will be called from the function node of IGSAS006.
8 The purpose of the function is to select the person_id and their user name and
9 add it to the ad hoc role and set it as an item attribute of the workflow.
10 This procedure also sets the item attributes by extracting them from the event parameters.
11 Change History
12 Who When What
13
14 (reverse chronological order - newest change first)
15 ***************************************************************/
16 PROCEDURE wf_notify_student(
17 p_busEvent IN VARCHAR2,
18 p_name IN VARCHAR2,
19 p_users IN VARCHAR2,
20 p_subject IN VARCHAR2,
21 p_message IN VARCHAR2 );
22
23 PROCEDURE wf_set_role (itemtype IN VARCHAR2 ,
24 itemkey IN VARCHAR2 ,
25 actid IN NUMBER ,
26 funcmode IN VARCHAR2 ,
27 resultout OUT NOCOPY VARCHAR2 ) ;
28 /*************************************************************
29 Created By :Sameer
30 Date Created on : 1-Nov-2002
31 Purpose : This procedure will be called to launch workflow IGSAS006.
32 Change History
33 Who When What
34
35 (reverse chronological order - newest change first)
36 ***************************************************************/
37
38 PROCEDURE wf_launch_as007 (
39 p_user IN VARCHAR2,
40 p_stud_id IN NUMBER,
41 p_stud_number IN VARCHAR2,
42 p_stud_name IN VARCHAR2,
43 p_order_number IN NUMBER,
44 p_item_number IN NUMBER);
45
46 /*************************************************************
47 Created By :Deepankar
48 Date Created on : 9-Nov-2003
49 Purpose : This procedure will be called to launch workflow IGSAS006.
50 Change History
51 Who When What
52
53 (reverse chronological order - newest change first)
54 ***************************************************************/
55
56 PROCEDURE raise_rel_subdate_event (
57 p_unit_cd IN VARCHAR2,
58 p_term IN VARCHAR2,
59 p_location IN VARCHAR2,
60 p_title IN VARCHAR2,
61 p_teaching_cal IN VARCHAR2,
62 p_sec_number IN VARCHAR2,
63 p_instructor IN NUMBER,
64 p_ass_id IN NUMBER,
65 p_ass_type IN VARCHAR2,
66 p_reference IN VARCHAR2 ,
67 p_grading_period IN VARCHAR2,
68 p_rel_sub_dt IN VARCHAR2 ,
69 p_event IN VARCHAR2
70 );
71
72
73 PROCEDURE set_adhoc_role (itemtype IN VARCHAR2 ,
74 itemkey IN VARCHAR2 ,
75 actid IN NUMBER ,
76 funcmode IN VARCHAR2 ,
77 resultout OUT NOCOPY VARCHAR2 ) ;
78
79 END igs_as_notify_student;