1 PACKAGE igs_en_workflow AS
2 /* $Header: IGSEN85S.pls 120.2 2006/04/13 01:53:54 smaddali ship $ */
3
4 /******************************************************************
5 Created By :Sanjeeb Rakshit
6 Date Created By :18-Jul-2001
7 Purpose :This package implements procedure concerned to workflow
8 remarks :
9 Change History
10 Who When What
11 vchappid 26-Jul-01 Two new procedures have been included
12 knaraset 18-Nov-2003 Added procedure student_placement_event, for placement build
13 bdeviset 20-Mar-2006 Added procedure raise_spi_rcond_event for bug# 5083465
14 ******************************************************************/
15
16
17 PROCEDURE sua_status_change_mail( p_unit_status IN VARCHAR2,
18 p_person_id IN NUMBER,
19 p_uoo_id IN NUMBER
20 );
21
22 PROCEDURE inform_stdnt_instruct_action( p_student_id IN NUMBER,
23 p_instructor_id IN NUMBER,
24 p_uoo_id IN NUMBER,
25 p_approval_status IN VARCHAR2,
26 p_date_submission IN DATE,
27 p_request_type IN VARCHAR2
28 );
29
30 PROCEDURE inform_instruct_stdnt_petition( p_student_id IN NUMBER,
31 p_instructor_id IN NUMBER,
32 p_uoo_id IN NUMBER,
33 p_date_submission IN DATE,
34 p_transaction_type IN VARCHAR2,
35 p_request_type IN VARCHAR2
36 );
37 PROCEDURE intermission_event(p_personid IN NUMBER ,
38 p_program_cd IN VARCHAR2,
39 p_intmtype IN VARCHAR2,
40 p_startdt IN DATE,
41 p_enddt IN DATE ,
42 p_inst_name IN VARCHAR2,
43 p_max_cp IN NUMBER,
44 p_max_term IN NUMBER,
45 p_anti_cp IN NUMBER,
46 p_approver IN NUMBER
47 );
48
49 PROCEDURE progdiscont_event (
50 p_personid IN NUMBER ,
51 p_programcd IN VARCHAR2,
52 p_discontindt IN DATE ,
53 p_discontincd IN VARCHAR2
54 );
55
56 PROCEDURE progtrans_event (
57 p_personid IN NUMBER ,
58 p_destprogcd IN VARCHAR2,
59 p_progstartdt IN DATE ,
60 p_location IN VARCHAR2,
61 p_atten_type IN VARCHAR2,
62 p_atten_mode IN VARCHAR2,
63 p_prog_status IN VARCHAR2,
64 p_trsnfrdt IN DATE,
65 p_sourceprogcd IN VARCHAR2
66 );
67
68 PROCEDURE progofropt_event (
69 p_personid IN NUMBER ,
70 p_programcd IN VARCHAR2 ,
71 p_locationcd IN VARCHAR2 ,
72 p_prev_location_cd IN VARCHAR2 ,
73 p_attndmode IN VARCHAR2 ,
74 p_prev_attndmode IN VARCHAR2 ,
75 p_attndtype IN VARCHAR2 ,
76 p_prev_attndtype IN VARCHAR2
77
78 );
79
80 PROCEDURE enr_notification ( ERRBUF OUT NOCOPY VARCHAR2 ,
81 RETCODE OUT NOCOPY NUMBER ,
82 p_acad_cal_type IN VARCHAR2 ,
83 p_sub_offset_day IN NUMBER
84 );
85
86
87 PROCEDURE intermission_not (
88 itemtype IN VARCHAR2 ,
89 itemkey IN VARCHAR2 ,
90 actid IN NUMBER ,
91 funcmode IN VARCHAR2 ,
92 resultout OUT NOCOPY VARCHAR2 );
93
94
95 PROCEDURE progtrans_not (
96 itemtype IN VARCHAR2 ,
97 itemkey IN VARCHAR2 ,
98 actid IN NUMBER ,
99 funcmode IN VARCHAR2 ,
100 resultout OUT NOCOPY VARCHAR2 );
101
102 PROCEDURE progofropt_not (
103 itemtype IN VARCHAR2 ,
104 itemkey IN VARCHAR2 ,
105 actid IN NUMBER ,
106 funcmode IN VARCHAR2 ,
107 resultout OUT NOCOPY VARCHAR2 );
108
109
110 PROCEDURE progdiscont_not (
111 itemtype IN VARCHAR2 ,
112 itemkey IN VARCHAR2 ,
113 actid IN NUMBER ,
114 funcmode IN VARCHAR2 ,
115 resultout OUT NOCOPY VARCHAR2 );
116
117 PROCEDURE student_placement_event(p_person_id IN NUMBER ,
118 p_program_cd IN VARCHAR2,
119 p_unit_cd IN VARCHAR2,
120 p_unit_class IN VARCHAR2,
121 p_location_cd IN VARCHAR2,
122 p_uoo_id IN NUMBER);
123
124 procedure raise_withdraw_perm_evt (p_n_uoo_id IN NUMBER,
125 p_c_load_cal IN VARCHAR2,
126 p_n_load_seq_num IN NUMBER,
127 p_n_person_id IN NUMBER,
128 p_c_course_cd IN VARCHAR2,
129 p_c_approval_type IN VARCHAR2);
130
131
132 PROCEDURE raise_spi_rcond_event ( p_person_id IN NUMBER,
133 p_program_cd IN VARCHAR2,
134 p_intm_type IN VARCHAR2,
135 p_changed_rconds IN VARCHAR2,
136 p_changed_rconds_desc IN VARCHAR2);
137
138 END igs_en_workflow;