1 PACKAGE PO_APPROVAL_LIST_WF1S AUTHID CURRENT_USER AS
2 /* $Header: POXWAL1S.pls 120.1 2006/09/22 18:33:10 tolick noship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWAL1S.sql
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_APPROVAL_LIST_WF1S
10 | This package contains procedure to support
11 | requisition approval workflow
12 | extension for Web Requisition 4.0
13 |
14 | NOTES
15 | Created 10/04/98 ecso
16 *=====================================================================*/
17
18 -- Does_Approval_list_Exist
19 -- Check if there exists an approval list
20 -- for a requisition
21 --
22 procedure Does_Approval_List_Exist( itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout out NOCOPY varchar2);
27
28 -- Find_Approval_List
29 -- 1. search for an approval list created by preparer
30 -- through web requisition
31 -- 2. if approval list is found,
32 -- record the approval list id on workflow attribute and
33 -- mark approval list with workflow itemtype, itemkey
34 -- by calling update_approval_list_itemkey API
35 --
36 procedure Find_Approval_List ( itemtype in varchar2,
37 itemkey in varchar2,
38 actid in number,
39 funcmode in varchar2,
40 resultout out NOCOPY varchar2);
41
42 -- Build_Default_Approval_List
43 --
44 procedure Build_Default_Approval_list(itemtype in varchar2,
45 itemkey in varchar2,
46 actid in number,
47 funcmode in varchar2,
48 resultout out NOCOPY varchar2);
49
50 -- Rebuild_Approval_List
51 -- An approval list will be rebuilt under the following scenario:
52 -- (1) Approver forwarded the requisition
53 -- (2) Approver modified the requisition
54 -- (3) The current approver is not valid
55 --
56
57 procedure Rebuild_List_Forward(itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout out NOCOPY varchar2);
62 --
63 procedure Rebuild_List_Doc_Changed(itemtype in varchar2,
64 itemkey in varchar2,
65 actid in number,
66 funcmode in varchar2,
67 resultout out NOCOPY varchar2);
68 --
69 procedure Rebuild_List_Invalid_Approver(itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 resultout out NOCOPY varchar2);
74 --
75 -- Get_Next_Approver
76 -- get the next approver name from the approval list
77 -- and update workflow attributes
78 --
79 procedure Get_Next_Approver(itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 resultout out NOCOPY varchar2);
84
85 -- Is_Approval_List_Empty
86 --
87 procedure Is_Approval_List_Empty(itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funcmode in varchar2,
91 resultout out NOCOPY varchar2);
92
93 -- Update action history
94 -- The following procedures record the response
95 -- from workflow notifications in po_action_history table
96 --
97 procedure Insert_Action_History(itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 resultout out NOCOPY varchar2);
102
103 procedure Update_Action_History_Approve(itemtype in varchar2,
104 itemkey in varchar2,
105 actid in number,
106 funcmode in varchar2,
107 resultout out NOCOPY varchar2);
108
109 procedure Update_Action_History_Timeout(itemtype in varchar2,
110 itemkey in varchar2,
111 actid in number,
112 funcmode in varchar2,
113 resultout out NOCOPY varchar2);
114
115 procedure Update_Action_History_App_Fwd(itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out NOCOPY varchar2);
120
121 procedure Update_Action_History_Forward(itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 resultout out NOCOPY varchar2);
126
127 procedure Update_Action_History_Reject(itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 resultout out NOCOPY varchar2);
132
133 -- Update Approval List Response
134 -- This procedure record the response
135 -- from workflow notifications in
136 -- po_approval_list_headers and po_approval_list_lines tables
137 --
138 procedure Update_Approval_List_Response(itemtype in varchar2,
139 itemkey in varchar2,
140 actid in number,
141 funcmode in varchar2,
142 resultout out NOCOPY varchar2);
143
144
145 /* Bug# 1712121: kagarwal
146 ** Desc: Created new workflow API: Update_App_List_Resp_Success.
147 **
148 ** This is same as Update_Approval_List_Response but the return values
149 ** will be SUCCESS-FAILURE.
150 */
151
152 procedure Update_App_List_Resp_Success(itemtype in varchar2,
153 itemkey in varchar2,
154 actid in number,
155 funcmode in varchar2,
156 resultout out NOCOPY varchar2);
157
158 procedure Create_Attach_Info_Temp(itemtype in varchar2,
159 itemkey in varchar2,
160 actid in number,
161 funcmode in varchar2,
162 resultout out NOCOPY varchar2);
163
164 procedure Is_Document_Manager_Error_1_2(itemtype in varchar2,
165 itemkey in varchar2,
166 actid in number,
167 funcmode in varchar2,
168 resultout out NOCOPY varchar2);
169
170 /* Bug# 2684757: kagarwal
171 ** Desc: Added new wf api to insert null action before
172 ** Reserving a Requisition, if the null action does not exists.
173 ** Otherwise the Reserve action is not recorded.
174 */
175 procedure Insert_Res_Action_History(itemtype in varchar2,
176 itemkey in varchar2,
177 actid in number,
178 funcmode in varchar2,
179 resultout out NOCOPY varchar2);
180 /* FPJ AME integration */
181 procedure get_approval_response(itemtype in varchar2,
182 itemkey in varchar2,
183 responderId out NOCOPY number,
184 response out NOCOPY varchar2,
185 responseEndDate out NOCOPY date,
186 forwardToId out NOCOPY number);
187
188 END PO_APPROVAL_LIST_WF1S;