1 PACKAGE IGS_AZ_GEN_001 AS
2 /* $Header: IGSAZ01S.pls 120.1 2005/11/18 01:44:57 appldev ship $ */
3
4 /*********************************************************************************************************
5 Created By : Girish Jha
6 Date Created By : 14 May 2003
7 Purpose : This package is the generaic package for advising functionality. This contains the routines
8 for Maintaining the advising group, apply advising holds on the students of the group and
9 sending the notifications to students and advisors.
10 This is modular approach to make the routines which can be called from 1. Concurrent program
11 2. Self service pages 3. Any pl/sql block separately.
12
13 remarks : None
14 Change History
15
16 Who When What
17 -----------------------------------------------------------
18 Girish Jha 12-May-2003 New Package created.
19 ***************************************************************************************************************/
20
21 PROCEDURE MAINTAIN_GROUPS
22 ( errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_group_name IN VARCHAR2 DEFAULT NULL,
25 p_APPLY_HOLD IN VARCHAR2 DEFAULT 'N',
26 p_NOTIFY IN VARCHAR2 DEFAULT 'Y');
27
28
29 PROCEDURE APPLY_HOLD
30 ( errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY VARCHAR2,
32 p_group_name IN VARCHAR2 DEFAULT NULL,
33 p_NOTIFY IN VARCHAR2 DEFAULT 'Y'
34 );
35
36
37 PROCEDURE SEND_NOTIFICATION
38 ( errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY VARCHAR2,
40 p_group_name IN VARCHAR2 DEFAULT NULL
41 );
42
43 PROCEDURE ASSIGN_STUDENTS_TO_ADVISORS (
44 p_group_name IN VARCHAR2,
45 p_n_processed OUT NOCOPY NUMBER,
46 p_start_date IN DATE DEFAULT NULL -- This is accepted because, the call from ss page requires the start date to be null so that it can be displayed for suggested match acceptance.
47 );
48
49 /******************************************************************
50 Created By : Girish Jha
51 Date Created By : 17-May-2003
52 Purpose : This procedure will be used for raising business event. This
53 procedure is made very generic.
54 This will acceept business event name and five pair of name value
55 pair of w/f parameters.
56 The name of the parameters must be registered with the w/f.
57 Change History
58 Who When What
59 ******************************************************************/
60 PROCEDURE notify_person(
61 p_busEvent IN VARCHAR2,
62 p_param_name1 IN VARCHAR2 DEFAULT NULL,
63 p_param_value1 IN VARCHAR2 DEFAULT NULL,
64 p_param_name2 IN VARCHAR2 DEFAULT NULL,
65 p_param_value2 IN VARCHAR2 DEFAULT NULL,
66 p_param_name3 IN VARCHAR2 DEFAULT NULL,
67 p_param_value3 IN VARCHAR2 DEFAULT NULL,
68 p_param_name4 IN VARCHAR2 DEFAULT NULL,
69 p_param_value4 IN VARCHAR2 DEFAULT NULL,
70 p_param_name5 IN VARCHAR2 DEFAULT NULL,
71 p_param_value5 IN VARCHAR2 DEFAULT NULL
72 );
73
74
75
76
77 PROCEDURE end_date_advisor(p_group_name VARCHAR2,
78 p_advisor_person_id NUMBER,
79 p_end_date DATE DEFAULT SYSDATE,
80 p_calling_mod VARCHAR2 DEFAULT 'C',
81 p_enforce VARCHAR2 DEFAULT NULL
82 );
83
84
85 PROCEDURE end_date_student(p_group_name VARCHAR2,
86 p_student_person_id NUMBER,
87 p_end_date DATE DEFAULT SYSDATE,
88 p_calling_mod VARCHAR2 DEFAULT 'C' ,
89 p_enforce VARCHAR2 DEFAULT NULL);
90
91 PROCEDURE end_std_advsng_hold(P_GROUP_NAME VARCHAR2, P_PERSON_ID NUMBER, p_hld_end_dt DATE DEFAULT SYSDATE);
92
93 procedure deactivate_Group
94 (p_group_name Varchar2,
95 x_return_status OUT NOCOPY varchar2,
96 x_msg_count OUT NOCOPY number,
97 x_msg_data OUT NOCOPY varchar2
98 );
99 procedure reactivate_Group
100 (p_group_name Varchar2,
101 x_return_status OUT NOCOPY varchar2,
102 x_msg_count OUT NOCOPY number,
103 x_msg_data OUT NOCOPY varchar2
104 );
105
106 PROCEDURE submit_maintain_group_job
107 (
108 p_group_name IN IGS_AZ_GROUPS.group_name%TYPE,
109 p_return_status OUT NOCOPY VARCHAR2,
110 p_message_data OUT NOCOPY VARCHAR2,
111 p_message_count OUT NOCOPY NUMBER,
112 p_request_id OUT NOCOPY NUMBER
113 );
114
115 /******************************************************************
116 Created By : anilk
117 Date Created By : 10-Jun-2003
118 Purpose : This procedure is called from workflow IGSAZ001
119 Change History
120 Who When What
121 ******************************************************************/
122 PROCEDURE wf_set_role (itemtype IN VARCHAR2 ,
123 itemkey IN VARCHAR2 ,
124 actid IN NUMBER ,
125 funcmode IN VARCHAR2 ,
126 resultout OUT NOCOPY VARCHAR2 ) ;
127
128
129 END IGS_AZ_GEN_001;