1 PACKAGE AHL_OPERATIONS_APPROVAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVOWKS.pls 115.1 2002/12/05 01:47:23 rtadikon noship $ */
3 PROCEDURE Set_Activity_Details(
4 itemtype IN VARCHAR2
5 ,itemkey IN VARCHAR2
6 ,actid IN NUMBER
7 ,funcmode IN VARCHAR2
8 ,resultout OUT NOCOPY VARCHAR2);
9
10
11 PROCEDURE Ntf_Forward_FYI(
12 document_id IN VARCHAR2
13 ,display_type IN VARCHAR2
14 ,document IN OUT NOCOPY VARCHAR2
15 ,document_type IN OUT NOCOPY VARCHAR2
16 );
17
18
19 PROCEDURE Ntf_Approved_FYI(
20 document_id IN VARCHAR2
21 ,display_type IN VARCHAR2
22 ,document IN OUT NOCOPY VARCHAR2
23 ,document_type IN OUT NOCOPY VARCHAR2
24 );
25
26 --------------------------------------------------------------------------
27 -- PROCEDURE
28 -- Ntf_Final_Approval_FYI
29 --
30 -- PURPOSE
31 -- Generate the FYI Document for display in messages, either text or html
32 --
33 -- IN
34 -- document_id - Item Key
35 -- display_type - either 'text/plain' or 'text/html'
36 -- document - document buffer
37 -- document_type - type of document buffer created, either 'text/plain'
38 -- or 'text/html'
39 -- OUT
40 --
41 -- USED BY
42 -- Oracle ASO Apporval
43 --
44 -- HISTORY
45 -- 05/01/2002 Rajanath Tadikonda created
46 --------------------------------------------------------------------------
47 PROCEDURE Ntf_Final_Approval_FYI(
48 document_id IN VARCHAR2
49 ,display_type IN VARCHAR2
50 ,document IN OUT NOCOPY VARCHAR2
51 ,document_type IN OUT NOCOPY VARCHAR2
52 );
53
54 --------------------------------------------------------------------------
55 -- PROCEDURE
56 -- Ntf_Rejected_FYI
57 --
58 -- PURPOSE
59 -- Generate the FYI Document for display in messages, either text or html
60 --
61 -- IN
62 -- document_id - Item Key
63 -- display_type - either 'text/plain' or 'text/html'
64 -- document - document buffer
65 -- document_type - type of document buffer created, either 'text/plain'
66 -- or 'text/html'
67 -- OUT
68 --
69 -- USED BY
70 -- Oracle ASO Apporval
71 --
72 -- HISTORY
73 -- 05/01/2002 Rajanath Tadikonda created
74 --------------------------------------------------------------------------
75 PROCEDURE Ntf_Rejected_FYI(
76 document_id IN VARCHAR2
77 ,display_type IN VARCHAR2
78 ,document IN OUT NOCOPY VARCHAR2
79 ,document_type IN OUT NOCOPY VARCHAR2
80 );
81
82
83 --------------------------------------------------------------------------
84 -- PROCEDURE
85 -- Ntf_Approval
86 --
87 -- PURPOSE
88 -- Generate the Document to ask for approval, either text or html
89 --
90 -- IN
91 -- document_id - Item Key
92 -- display_type - either 'text/plain' or 'text/html'
93 -- document - document buffer
94 -- document_type - type of document buffer created, either 'text/plain'
95 -- or 'text/html'
96 -- OUT
97 --
98 -- USED BY
99 -- Oracle ASO Apporval
100 --
101 -- HISTORY
102 -- 05/01/2002 Rajanath Tadikonda created
103 --------------------------------------------------------------------------
104 PROCEDURE Ntf_Approval(
105 document_id IN VARCHAR2
106 ,display_type IN VARCHAR2
107 ,document IN OUT NOCOPY VARCHAR2
108 ,document_type IN OUT NOCOPY VARCHAR2
109 );
110
111 --------------------------------------------------------------------------
112 -- PROCEDURE
113 -- Ntf_Approval_Reminder
114 --
115 -- PURPOSE
116 -- Generate the Reminder Document for display in messages, either text or html
117 --
118 -- IN
119 -- document_id - Item Key
120 -- display_type - either 'text/plain' or 'text/html'
121 -- document - document buffer
122 -- document_type - type of document buffer created, either 'text/plain'
123 -- or 'text/html'
124 -- OUT
125 --
126 -- USED BY
127 -- Oracle ASO Apporval
128 --
129 -- HISTORY
130 -- 05/01/2002 Rajanath Tadikonda created
131 --------------------------------------------------------------------------
132 PROCEDURE Ntf_Approval_Reminder(
133 document_id IN VARCHAR2
134 ,display_type IN VARCHAR2
135 ,document IN OUT NOCOPY VARCHAR2
136 ,document_type IN OUT NOCOPY VARCHAR2
137 );
138
139
140 --------------------------------------------------------------------------
141 -- PROCEDURE
142 -- Ntf_Error_Act
143 --
144 -- PURPOSE
145 -- Generate the Document to request action to handle error, either text or html
146 --
147 -- IN
148 -- document_id - Item Key
149 -- display_type - either 'text/plain' or 'text/html'
150 -- document - document buffer
151 -- document_type - type of document buffer created, either 'text/plain'
152 -- or 'text/html'
153 -- OUT
154 --
155 -- USED BY
156 -- Oracle ASO Apporval
157 --
158 -- HISTORY
159 -- 05/01/2002 Rajanath Tadikonda created
160 --------------------------------------------------------------------------
161 PROCEDURE Ntf_Error_Act(
162 document_id IN VARCHAR2
163 ,display_type IN VARCHAR2
164 ,document IN OUT NOCOPY VARCHAR2
165 ,document_type IN OUT NOCOPY VARCHAR2
166 );
167
168 ---------------------------------------------------------------------
169 -- PROCEDURE
170 -- Update_Status
171 --
172 -- PURPOSE
173 -- This Procedure will update the status
174 --
175 -- IN
176 --
177 -- OUT
178 --
179 -- USED BY
180 -- Oracle ASO Apporval
181 --
182 -- HISTORY
183 -- 05/01/2002 Rajanath Tadikonda created
184 --------------------------------------------------------------------------
185 PROCEDURE Update_Status(
186 itemtype IN VARCHAR2
187 ,itemkey IN VARCHAR2
188 ,actid IN NUMBER
189 ,funcmode IN VARCHAR2
190 ,resultout OUT NOCOPY VARCHAR2
191 );
192
193 ---------------------------------------------------------------------
194 -- PROCEDURE
195 -- Revert_Status
196 --
197 -- PURPOSE
198 -- This Procedure will revert the status in the case of an error
199 --
200 -- IN
201 --
202 -- OUT
203 --
204 -- USED BY
205 -- Oracle ASO Apporval
206 --
207 -- HISTORY
208 -- 05/01/2002 Rajanath Tadikonda created
209 --------------------------------------------------------------------------
210 PROCEDURE Revert_Status(
211 itemtype IN VARCHAR2
212 ,itemkey IN VARCHAR2
213 ,actid IN NUMBER
214 ,funcmode IN VARCHAR2
215 ,resultout OUT NOCOPY VARCHAR2
216 );
217 END AHL_OPERATIONS_APPROVAL_PVT;