1 PACKAGE PO_REQAPPROVAL_ACTION AUTHID CURRENT_USER AS
2 /* $Header: POXWPA4S.pls 120.1.12020000.3 2013/02/11 13:21:40 vegajula 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 --Added as part of bug 16021525 fix
33 application_id number;
34 responsibility_id number;
35 user_id number;
36
37 procedure State_Check_approve( itemtype in varchar2,
38 itemkey in varchar2,
39 actid in number,
40 funcmode in varchar2,
41 resultout out NOCOPY varchar2 );
42
43 -- State_Check_reject
44 -- Is the state of the document compatible with the reject action.
45 --
46 -- IN
47 -- itemtype -- itemkey -- actid -- funcmode
48 -- OUT
49 -- Resultout
50 -- - Activity Performed - Activity was completed without any errors.
51 --
52 procedure State_Check_reject( itemtype in varchar2,
53 itemkey in varchar2,
54 actid in number,
55 funcmode in varchar2,
56 resultout out NOCOPY varchar2 );
57
58 -- Doc_complete_check
59 -- Is the doc complete (all quantities match, at least one line and one distribution ...)
60 --
61 -- IN
62 -- itemtype -- itemkey -- actid -- funcmode
63 -- OUT
64 -- Resultout
65 -- - Activity Performed - Activity was completed without any errors.
66 --
67 procedure Doc_complete_check( itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 resultout out NOCOPY varchar2 );
72
73 --
74 -- Approve_doc
75 -- Approve the document
76 -- IN
77 -- itemtype -- itemkey -- actid -- funcmode
78 -- OUT
79 -- Resultout
80 -- - Activity Performed - Activity was completed without any errors.
81 --
82 procedure Approve_doc( itemtype in varchar2,
83 itemkey in varchar2,
84 actid in number,
85 funcmode in varchar2,
86 resultout out NOCOPY varchar2 );
87
88 -- Approve_and_forward_doc
89 -- Approve and forward the doc (i.e. set it status to PRE-APPROVED)
90 -- IN
91 -- itemtype -- itemkey -- actid -- funcmode
92 -- OUT
93 -- Resultout
94 -- - Activity Performed - Activity was completed without any errors.
95 --
96 procedure Approve_and_forward_doc( itemtype in varchar2,
97 itemkey in varchar2,
98 actid in number,
99 funcmode in varchar2,
100 resultout out NOCOPY varchar2 );
101
102 --
103 -- Forward_doc_inprocess
104 -- If document status is INCOMPLETE, then call cover routine to set the
105 -- status to INPROCESS and forward to the approver.
106 --
107 -- IN
108 -- itemtype -- itemkey -- actid -- funcmode
109 -- OUT
110 -- Resultout
111 -- - Activity Performed - Activity was completed without any errors.
112 --
113 procedure Forward_doc_inprocess( itemtype in varchar2,
114 itemkey in varchar2,
115 actid in number,
116 funcmode in varchar2,
117 resultout out NOCOPY varchar2 );
118
119 --
120 -- Forward_doc_preapproved
121 -- If document status is PRE-APPROVED then call cover routine to
122 -- forward the document to the next approver (doc status stays PRE-APPROVED).
123 -- IN
124 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
125 -- itemkey - A string generated from the application object's primary key.
126 -- actid - The notification process activity(instance id).
127 -- funcmode - Run/Cancel
128 -- OUT
129 -- Resultout
130 --
131 --
132 procedure Forward_doc_preapproved( itemtype in varchar2,
133 itemkey in varchar2,
134 actid in number,
135 funcmode in varchar2,
136 resultout out NOCOPY varchar2 );
137 --
138
139 -- Reject_doc
140 -- Get the manager of the current employee in the HR hierarchy
141 -- IN
142 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
143 -- itemkey - A string generated from the application object's primary key.
144 -- actid - The notification process activity(instance id).
145 -- funcmode - Run/Cancel
146 -- OUT
147 -- Resultout
148 --
149 --
150 procedure Reject_doc( itemtype in varchar2,
151 itemkey in varchar2,
152 actid in number,
153 funcmode in varchar2,
154 resultout out NOCOPY varchar2 );
155 --
156
157 -- Verify_authority
158 -- Verify the approval authority against the PO setup control rules.
159 -- IN
160 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
161 -- itemkey - A string generated from the application object's primary key.
162 -- actid - The notification process activity(instance id).
163 -- funcmode - Run/Cancel
164 -- OUT
165 -- Resultout
166 -- Y - The approver has the authority to approve.
167 -- N - The approver does not have the authority to approve.
168 --
169 procedure Verify_authority( itemtype in varchar2,
170 itemkey in varchar2,
171 actid in number,
172 funcmode in varchar2,
173 resultout out NOCOPY varchar2 );
174 --
175
176 -- Open_Doc_State
177 --
178 -- IN
179 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
180 -- itemkey - A string generated from the application object's primary key.
181 -- actid - The notification process activity(instance id).
182 -- funcmode - Run/Cancel
183 -- OUT
184 -- Resultout
185 -- Y -
186 -- N -
187 --
188 procedure Open_Doc_State( itemtype in varchar2,
189 itemkey in varchar2,
190 actid in number,
191 funcmode in varchar2,
192 resultout out NOCOPY varchar2 );
193 --
194 -- Reserve_doc
195 --
196 -- IN
197 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
198 -- itemkey - A string generated from the application object's primary key.
199 -- actid - The notification process activity(instance id).
200 -- funcmode - Run/Cancel
201 -- OUT
202 -- Resultout
203 -- Y -
204 -- N -
205 --
206 procedure Reserve_doc( itemtype in varchar2,
207 itemkey in varchar2,
208 actid in number,
209 funcmode in varchar2,
210 resultout out NOCOPY varchar2 );
211
212 --
213
214 /* Bug# 2234341: kagarwal */
215
216 -- Reserve_doc_Override
217 --
218 -- IN
219 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
220 -- itemkey - A string generated from the application object's primary key.
221 -- actid - The notification process activity(instance id).
222 -- funcmode - Run/Cancel
223 -- OUT
224 -- Resultout
225 -- Y -
226 -- N -
227 --
228 procedure Reserve_doc_Override( itemtype in varchar2,
229 itemkey in varchar2,
230 actid in number,
231 funcmode in varchar2,
232 resultout out NOCOPY varchar2 );
233
234 --Bug 12944203
235 PROCEDURE InsertHistForOwnerApprove (itemtype VARCHAR2,
236 itemkey VARCHAR2,
237 p_document_id NUMBER,
238 p_document_type VARCHAR2,
239 p_document_subtype VARCHAR2);
240
241 --
242
243 end PO_REQAPPROVAL_ACTION;