1 PACKAGE igs_re_workflow AUTHID CURRENT_USER AS
2 /* $Header: IGSRE21S.pls 115.1 2003/09/22 05:15:54 ddey noship $ */
3
4 /******************************************************************
5 Created By :Deepankar Dey
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 DDEY 8-Sep-2003 The changes are done as per the
12 Enrollments Notifications TD Bug # 3052429
13 ******************************************************************/
14
15 PROCEDURE retopic_event (
16 p_personid IN NUMBER ,
17 p_programcd IN VARCHAR2 ,
18 p_restopic IN VARCHAR2
19 );
20
21
22 PROCEDURE rethesis_event (
23 p_personid IN NUMBER ,
24 p_ca_seq_num IN NUMBER ,
25 p_thesistopic IN VARCHAR2 ,
26 p_thesistitle IN VARCHAR2 ,
27 p_approved IN VARCHAR2 ,
28 p_deleted IN VARCHAR2
29 );
30
31 PROCEDURE supervision_event (
32 p_personid IN NUMBER ,
33 p_ca_seq_num IN NUMBER ,
34 p_supervisorid IN NUMBER ,
35 p_startdt IN DATE ,
36 p_enddt IN DATE ,
37 p_spr_percent IN NUMBER ,
38 p_spr_type IN VARCHAR2,
39 p_fund_percent IN NUMBER ,
40 p_org_unit_cd IN VARCHAR2 ,
41 p_rep_person_id IN VARCHAR2 ,
42 p_rep_seq_num IN NUMBER
43 );
44 PROCEDURE overduesub_event (
45 p_personid IN NUMBER ,
46 p_programcd IN VARCHAR2,
47 p_thesistitle IN VARCHAR2,
48 p_maxsubdt IN DATE,
49 p_suprvsr IN VARCHAR2
50 );
51
52
53
54 PROCEDURE retopic_not (
55 itemtype IN VARCHAR2 ,
56 itemkey IN VARCHAR2 ,
57 actid IN NUMBER ,
58 funcmode IN VARCHAR2 ,
59 resultout OUT NOCOPY VARCHAR2 );
60
61 PROCEDURE thesis_not (
62 itemtype IN VARCHAR2 ,
63 itemkey IN VARCHAR2 ,
64 actid IN NUMBER ,
65 funcmode IN VARCHAR2 ,
66 resultout OUT NOCOPY VARCHAR2 );
67
68 PROCEDURE supervision_not (
69 itemtype IN VARCHAR2 ,
70 itemkey IN VARCHAR2 ,
71 actid IN NUMBER ,
72 funcmode IN VARCHAR2 ,
73 resultout OUT NOCOPY VARCHAR2 );
74
75 PROCEDURE overduesub_not (
76 itemtype IN VARCHAR2 ,
77 itemkey IN VARCHAR2 ,
78 actid IN NUMBER ,
79 funcmode IN VARCHAR2 ,
80 resultout OUT NOCOPY VARCHAR2 );
81
82
83 -- The changes are done as per the Enrollments Notifications TD Bug # 3052429
84
85 PROCEDURE milestone_event(
86 p_personid IN NUMBER ,
87 p_ca_seq_num IN NUMBER ,
88 p_milestn_typ IN VARCHAR2 ,
89 p_milestn_stat IN VARCHAR2 ,
90 p_due_dt IN DATE ,
91 p_dt_reached IN DATE ,
92 p_deleted IN VARCHAR2
93 );
94
95
96 PROCEDURE thesis_exam_event(
97 p_personid IN NUMBER ,
98 p_ca_sequence_number IN NUMBER ,
99 p_the_sequence_number IN NUMBER ,
100 p_creation_dt IN DATE ,
101 p_submission_dt IN DATE ,
102 p_thesis_exam_type IN VARCHAR2
103 );
104
105 PROCEDURE thesis_result_event(
106 p_personid IN NUMBER ,
107 p_ca_sequence_number IN NUMBER,
108 p_the_sequence_number IN NUMBER ,
109 p_creation_dt IN DATE ,
110 p_submission_dt IN DATE ,
111 p_thesis_exam_type IN VARCHAR2 ,
112 p_thesis_result_cd IN VARCHAR2 );
113
114 PROCEDURE confirm_reg_event (
115 p_personid IN NUMBER ,
116 p_programcd IN VARCHAR2,
117 p_spa_start_dt IN DATE ,
118 p_prog_attempt_stat IN VARCHAR2
119 );
120
121 PROCEDURE milstn_notify_prcs (
122 errbuf OUT NOCOPY VARCHAR2 ,
123 retcode OUT NOCOPY NUMBER ) ;
124 PROCEDURE create_adhoc_role (
125 itemtype IN VARCHAR2 ,
126 itemkey IN VARCHAR2 ,
127 actid IN NUMBER ,
128 funcmode IN VARCHAR2 ,
129 resultout OUT NOCOPY VARCHAR2 );
130 PROCEDURE confirm_reg_not(
131 itemtype IN VARCHAR2 ,
132 itemkey IN VARCHAR2 ,
133 actid IN NUMBER ,
134 funcmode IN VARCHAR2 ,
135 resultout OUT NOCOPY VARCHAR2
136 );
137
138 PROCEDURE milstn_notify_not(
139 itemtype IN VARCHAR2 ,
140 itemkey IN VARCHAR2 ,
141 actid IN NUMBER ,
142 funcmode IN VARCHAR2 ,
143 resultout OUT NOCOPY VARCHAR2
144 );
145
146
147 END igs_re_workflow;