1 PACKAGE POS_WCAPPROVE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSVWCAS.pls 120.6.12010000.2 2009/05/20 12:21:06 vchiranj ship $ */
3 --
4 -- Purpose: APIs called from the receiving processor to approve WCR document.
5 --
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- pparthas 02/15/05 Created Package
10 --
11 --
12
13 /*
14 g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
15 G_PKG_NAME CONSTANT VARCHAR2(30) := 'POS_WCAPPROVE_PVT';
16 G_FILE_NAME CONSTANT VARCHAR2(30) := 'POSVWCAS.pls';
17 */
18
19 PROCEDURE Start_WF_Process ( p_itemtype IN VARCHAR2,
20 p_itemkey IN OUT NOCOPY VARCHAR2,
21 p_workflow_process IN VARCHAR2,
22 p_work_confirmation_id IN NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2);
24
25
26
27 -- Remove_reminder_notif
28 -- IN
29 -- itemtype -- itemkey -- actid -- funcmode
30 -- OUT
31 -- Resultout
32 --
33 -- Update the old notifications to closed status for this document.
34 procedure Close_old_notif
35 (
36 p_itemtype in varchar2,
37 p_itemkey in varchar2,
38 p_actid in number,
39 p_funcmode in varchar2,
40 x_resultout out NOCOPY varchar2 );
41
42 procedure Set_Startup_Values( p_itemtype in varchar2,
43 p_itemkey in varchar2,
44 p_actid in number,
45 p_funcmode in varchar2,
46 x_resultout out NOCOPY varchar2 );
47
48 procedure update_workflow_info( p_itemtype in varchar2,
49 p_itemkey in varchar2,
50 p_actid in number,
51 p_funcmode in varchar2,
52 x_resultout out NOCOPY varchar2);
53
54 procedure Get_WC_Attributes( p_itemtype in varchar2,
55 p_itemkey in varchar2,
56 p_actid in number,
57 p_funcmode in varchar2,
58 x_resultout out NOCOPY varchar2);
59
60
61 procedure Ins_actionhist_submit(p_itemtype in varchar2,
62 p_itemkey in varchar2,
63 p_actid in number,
64 p_funcmode in varchar2,
65 x_resultout out NOCOPY varchar2);
66
67 procedure Get_Next_Approver(p_itemtype in varchar2,
68 p_itemkey in varchar2,
69 p_actid in number,
70 p_funcmode in varchar2,
71 x_resultout out NOCOPY varchar2);
72
73 procedure Insert_Action_History(p_itemtype in varchar2,
74 p_itemkey in varchar2,
75 p_actid in number,
76 p_funcmode in varchar2,
77 x_resultout out NOCOPY varchar2);
78
79
80 procedure Approve_shipment_lines(p_itemtype in varchar2,
81 p_itemkey in varchar2,
82 p_actid in number,
83 p_funcmode in varchar2,
84 x_resultout out NOCOPY varchar2);
85
86 procedure Reject_shipment_lines(p_itemtype in varchar2,
87 p_itemkey in varchar2,
88 p_actid in number,
89 p_funcmode in varchar2,
90 x_resultout out NOCOPY varchar2);
91
92 procedure Approve_OR_Reject(p_itemtype in varchar2,
93 p_itemkey in varchar2,
94 p_actid in number,
95 p_funcmode in varchar2,
96 x_resultout out NOCOPY varchar2);
97
98 procedure Update_Approval_List_Response
99 (p_itemtype in varchar2,
100 p_itemkey in varchar2,
101 p_actid in number,
102 p_funcmode in varchar2,
103 x_resultout out NOCOPY varchar2);
104
105
106 procedure Update_Action_History_Approve
107 (p_itemtype in varchar2,
108 p_itemkey in varchar2,
109 p_actid in number,
110 p_funcmode in varchar2,
111 x_resultout out NOCOPY varchar2);
112
113 procedure Update_Action_History_Reject
114 (p_itemtype in varchar2,
115 p_itemkey in varchar2,
116 p_actid in number,
117 p_funcmode in varchar2,
118 x_resultout out NOCOPY varchar2);
119
120 procedure Update_Action_History
121 (p_itemtype in varchar2,
122 p_itemkey in varchar2,
123 p_action_code in varchar2);
124
125 PROCEDURE UpdateActionHistory(p_more_info_id IN NUMBER,
126 p_original_recipient_id IN NUMBER,
127 p_responder_id IN NUMBER,
128 p_last_approver IN BOOLEAN,
129 p_action_code IN VARCHAR2,
130 p_comments IN VARCHAR2,
131 p_shipment_header_id IN NUMBER);
132
133
134 PROCEDURE get_user_name(p_orig_system IN Varchar2,
135 p_employee_id IN number,
136 x_username OUT NOCOPY varchar2,
137 x_user_display_name OUT NOCOPY varchar2);
138
139 PROCEDURE UpdatePOActionHistory (p_object_id IN NUMBER,
140 p_object_type_code IN VARCHAR2,
141 p_employee_id IN NUMBER,
142 p_action_code IN VARCHAR2,
143 p_note IN VARCHAR2,
144 p_user_id IN NUMBER,
145 p_login_id IN NUMBER);
146
147 PROCEDURE InsertPOActionHistory (p_object_id IN NUMBER,
148 p_object_type_code IN VARCHAR2,
149 p_object_sub_type_code IN VARCHAR2,
150 p_sequence_num IN NUMBER,
151 p_action_code IN VARCHAR2,
152 p_action_date IN DATE,
153 p_employee_id IN NUMBER,
154 p_approval_path_id IN NUMBER,
155 p_note IN VARCHAR2,
156 p_object_revision_num IN NUMBER,
157 p_offline_code IN VARCHAR2,
158 p_request_id IN NUMBER,
159 p_program_application_id IN NUMBER,
160 p_program_id IN NUMBER,
161 p_program_date IN DATE,
162 p_user_id IN NUMBER,
163 p_login_id IN NUMBER);
164
165 procedure reject_doc
166 (p_itemtype in varchar2,
167 p_itemkey in varchar2,
168 p_actid in number,
169 p_funcmode in varchar2,
170 x_resultout out NOCOPY varchar2) ;
171
172 procedure Approve_doc
173 (p_itemtype in varchar2,
174 p_itemkey in varchar2,
175 p_actid in number,
176 p_funcmode in varchar2,
177 x_resultout out NOCOPY varchar2) ;
178
179 procedure update_approval_status
180 (p_shipment_header_id in number,
181 p_note in varchar2,
182 p_approval_status in varchar2,
183 p_level in varchar2,
184 x_resultout out NOCOPY varchar2);
185
186 procedure insert_into_rti
187 (p_itemtype in varchar2,
188 p_itemkey in varchar2,
189 p_actid in number,
190 p_funcmode in varchar2,
191 x_resultout out NOCOPY varchar2);
192
193 procedure Launch_RTP_Immediate
194 (p_itemtype in varchar2,
195 p_itemkey in varchar2,
196 p_actid in number,
197 p_funcmode in varchar2,
198 x_resultout out NOCOPY varchar2);
199
200 PROCEDURE get_multiorg_context(p_document_id number,
201 x_orgid IN OUT NOCOPY number);
202
203
204 procedure post_approval_notif
205 (p_itemtype in varchar2,
206 p_itemkey in varchar2,
207 p_actid in number,
208 p_funcmode in varchar2,
209 x_resultout out NOCOPY varchar2);
210
211 /* Bug 8479430.
212 Added the procedure POWC_SELECTOR to set the user context properly before
213 launching the concurrent request */
214 PROCEDURE POWC_SELECTOR ( p_itemtype IN VARCHAR2,
215 p_itemkey IN VARCHAR2,
216 p_actid IN NUMBER,
217 p_funcmode IN VARCHAR2,
218 p_x_result IN OUT NOCOPY VARCHAR2);
219
220 FUNCTION Get_Approver_Name(p_approver_id IN NUMBER)
221 RETURN VARCHAR2;
222
223 FUNCTION Get_PoHeaderId(p_shipment_header_id IN NUMBER)
224 RETURN NUMBER;
225
226 PROCEDURE GenReceiptNum(
227 p_shipment_header_id IN number,
228 x_receipt_num IN OUT nocopy Varchar2);
229
230
231 FUNCTION GET_PAY_ITEM_PROGRESS (p_wc_id IN NUMBER,
232 p_wc_stage IN VARCHAR2)
233 RETURN NUMBER;
234
235 FUNCTION GET_AWARD_NUM (p_wc_id IN NUMBER)
236 RETURN VARCHAR2;
237
238 FUNCTION GET_DELIVER_TO_LOCATION (p_wc_id IN NUMBER)
239 RETURN VARCHAR2;
240
241 FUNCTION GET_ORDERED_AMOUNT (p_wc_id IN NUMBER)
242 RETURN NUMBER;
243
244 FUNCTION GET_ORDERED_QUANTITY (p_wc_id IN NUMBER)
245 RETURN NUMBER;
246
247 FUNCTION GET_PROJECT_NAME (p_wc_id IN NUMBER)
248 RETURN VARCHAR2;
249
250 FUNCTION GET_TASK_NAME (p_wc_id IN NUMBER)
251 RETURN VARCHAR2;
252
253 FUNCTION GET_CHARGE_ACCOUNT (p_wc_id IN NUMBER)
254 RETURN VARCHAR2;
255
256 FUNCTION GET_EXPENDITURE_ORG (p_wc_id IN NUMBER)
257 RETURN VARCHAR2;
258
259 END POS_WCAPPROVE_PVT;