1 PACKAGE PO_REQAPPROVAL_ACTION AUTHID CURRENT_USER AS
2 /* $Header: POXWPA4S.pls 115.5 2002/11/25 21:47:42 sbull ship $ */
3
4
5 /*=======================================================================+
6 | FILENAME
7 | POXWPA4S.sql
8 |
9 | DESCRIPTION
10 | PL/SQL spec for package: PO_REQAPPROVAL_ACTION
11 |
12 | NOTES
13 | CREATE Ben Chihaoui 6/19/97
14 | MODIFIED
15 *=====================================================================*/
16
17
18 -- State_Check_approve
19 -- Is the state of the document compatible with the reject action.
20 --
21 -- IN
22 -- itemtype -- itemkey -- actid -- funcmode
23 -- OUT
24 -- Resultout
25 -- - Activity Performed - Activity was completed without any errors.
26 --
27
28 doc_mgr_err_num number; --global variable used to set doc mgr error.
29 /*1942091*/
30 sysadmin_err_msg varchar2(2000); --global variable used to set sysadmin mesg.
31
32 procedure State_Check_approve( itemtype in varchar2,
33 itemkey in varchar2,
34 actid in number,
35 funcmode in varchar2,
36 resultout out NOCOPY varchar2 );
37
38 -- State_Check_reject
39 -- Is the state of the document compatible with the reject action.
40 --
41 -- IN
42 -- itemtype -- itemkey -- actid -- funcmode
43 -- OUT
44 -- Resultout
45 -- - Activity Performed - Activity was completed without any errors.
46 --
47 procedure State_Check_reject( itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 resultout out NOCOPY varchar2 );
52
53 -- Doc_complete_check
54 -- Is the doc complete (all quantities match, at least one line and one distribution ...)
55 --
56 -- IN
57 -- itemtype -- itemkey -- actid -- funcmode
58 -- OUT
59 -- Resultout
60 -- - Activity Performed - Activity was completed without any errors.
61 --
62 procedure Doc_complete_check( itemtype in varchar2,
63 itemkey in varchar2,
64 actid in number,
65 funcmode in varchar2,
66 resultout out NOCOPY varchar2 );
67
68 --
69 -- Approve_doc
70 -- Approve the document
71 -- IN
72 -- itemtype -- itemkey -- actid -- funcmode
73 -- OUT
74 -- Resultout
75 -- - Activity Performed - Activity was completed without any errors.
76 --
77 procedure Approve_doc( itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 funcmode in varchar2,
81 resultout out NOCOPY varchar2 );
82
83 -- Approve_and_forward_doc
84 -- Approve and forward the doc (i.e. set it status to PRE-APPROVED)
85 -- IN
86 -- itemtype -- itemkey -- actid -- funcmode
87 -- OUT
88 -- Resultout
89 -- - Activity Performed - Activity was completed without any errors.
90 --
91 procedure Approve_and_forward_doc( itemtype in varchar2,
92 itemkey in varchar2,
93 actid in number,
94 funcmode in varchar2,
95 resultout out NOCOPY varchar2 );
96
97 --
98 -- Forward_doc_inprocess
99 -- If document status is INCOMPLETE, then call cover routine to set the
100 -- status to INPROCESS and forward to the approver.
101 --
102 -- IN
103 -- itemtype -- itemkey -- actid -- funcmode
104 -- OUT
105 -- Resultout
106 -- - Activity Performed - Activity was completed without any errors.
107 --
108 procedure Forward_doc_inprocess( itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 resultout out NOCOPY varchar2 );
113
114 --
115 -- Forward_doc_preapproved
116 -- If document status is PRE-APPROVED then call cover routine to
117 -- forward the document to the next approver (doc status stays PRE-APPROVED).
118 -- IN
119 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
120 -- itemkey - A string generated from the application object's primary key.
121 -- actid - The notification process activity(instance id).
122 -- funcmode - Run/Cancel
123 -- OUT
124 -- Resultout
125 --
126 --
127 procedure Forward_doc_preapproved( itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 resultout out NOCOPY varchar2 );
132 --
133
134 -- Reject_doc
135 -- Get the manager of the current employee in the HR hierarchy
136 -- IN
137 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
138 -- itemkey - A string generated from the application object's primary key.
139 -- actid - The notification process activity(instance id).
140 -- funcmode - Run/Cancel
141 -- OUT
142 -- Resultout
143 --
144 --
145 procedure Reject_doc( itemtype in varchar2,
146 itemkey in varchar2,
147 actid in number,
148 funcmode in varchar2,
149 resultout out NOCOPY varchar2 );
150 --
151
152 -- Verify_authority
153 -- Verify the approval authority against the PO setup control rules.
154 -- IN
155 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
156 -- itemkey - A string generated from the application object's primary key.
157 -- actid - The notification process activity(instance id).
158 -- funcmode - Run/Cancel
159 -- OUT
160 -- Resultout
161 -- Y - The approver has the authority to approve.
162 -- N - The approver does not have the authority to approve.
163 --
164 procedure Verify_authority( itemtype in varchar2,
165 itemkey in varchar2,
166 actid in number,
167 funcmode in varchar2,
168 resultout out NOCOPY varchar2 );
169 --
170
171 -- Open_Doc_State
172 --
173 -- IN
174 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
175 -- itemkey - A string generated from the application object's primary key.
176 -- actid - The notification process activity(instance id).
177 -- funcmode - Run/Cancel
178 -- OUT
179 -- Resultout
180 -- Y -
181 -- N -
182 --
183 procedure Open_Doc_State( itemtype in varchar2,
184 itemkey in varchar2,
185 actid in number,
186 funcmode in varchar2,
187 resultout out NOCOPY varchar2 );
188 --
189 -- Reserve_doc
190 --
191 -- IN
192 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
193 -- itemkey - A string generated from the application object's primary key.
194 -- actid - The notification process activity(instance id).
195 -- funcmode - Run/Cancel
196 -- OUT
197 -- Resultout
198 -- Y -
199 -- N -
200 --
201 procedure Reserve_doc( itemtype in varchar2,
202 itemkey in varchar2,
203 actid in number,
204 funcmode in varchar2,
205 resultout out NOCOPY varchar2 );
206
207 --
208
209 /* Bug# 2234341: kagarwal */
210
211 -- Reserve_doc_Override
212 --
213 -- IN
214 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
215 -- itemkey - A string generated from the application object's primary key.
216 -- actid - The notification process activity(instance id).
217 -- funcmode - Run/Cancel
218 -- OUT
219 -- Resultout
220 -- Y -
221 -- N -
222 --
223 procedure Reserve_doc_Override( itemtype in varchar2,
224 itemkey in varchar2,
225 actid in number,
226 funcmode in varchar2,
227 resultout out NOCOPY varchar2 );
228
229 --
230
231 end PO_REQAPPROVAL_ACTION;