[Home] [Help]
PACKAGE: APPS.PO_APPROVAL_REMINDER_SV
Source
1 PACKAGE PO_APPROVAL_REMINDER_SV AUTHID CURRENT_USER AS
2 /* $Header: POXWARMS.pls 115.4 2003/09/26 01:41:16 tpoon ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_APPROVAL_REMINDER_SV
6
7 DESCRIPTION: PO Approval Workflow server procedures
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME PO_APPROVAL_WF_SV
12
13 OWNER: WLAU
14
15 PROCEDURES/FUNCTIONS:
16
17 ===========================================================================*/
18
19
20 /*===========================================================================
21 PROCEDURE NAME: Select_Unapprove_docs
22
23 DESCRIPTION: See the package body
24
25 PARAMETERS:
26
27 RETURN:
28
29 DESIGN REFERENCES:
30
31 ALGORITHM:
32
33 NOTES:
34
35 OPEN ISSUES:
36
37 CLOSED ISSUES:
38
39 CHANGE HISTORY: WLAU 7/15/1997 Created
40 ===========================================================================*/
41
42 PROCEDURE Select_Unapprove_docs;
43
44 PROCEDURE Process_unapprove_reqs;
45
46 PROCEDURE Process_unapprove_pos;
47
48 PROCEDURE Process_unapprove_releases;
49
50 PROCEDURE Process_po_acceptance;
51
52 PROCEDURE Process_rel_acceptance;
53
54 PROCEDURE Process_rfq_quote;
55
56
57 /*===========================================================================
58 PROCEDURE NAME: Start_Approval_Reminder
59
60 DESCRIPTION: See the package body
61
62 PARAMETERS:
63
64 RETURN:
65
66 DESIGN REFERENCES:
67
68
69 ALGORITHM:
70
71 NOTES:
72
73 OPEN ISSUES:
74
75 CLOSED ISSUES:
76
77 CHANGE HISTORY: WLAU 7/15/1997 Created
78 ===========================================================================*/
79
80 PROCEDURE Start_Approval_Reminder (p_doc_header_id IN NUMBER,
81 p_doc_number IN VARCHAR2,
82 p_doc_type IN VARCHAR2,
83 p_doc_subtype IN VARCHAR2,
84 p_release_num IN NUMBER,
85 p_agent_id IN NUMBER,
86 p_WF_ItemKey IN VARCHAR2);
87
88 /*===========================================================================
89 PROCEDURE NAME: Set_Doc_Type
90
91 DESCRIPTION: See the package body
92
93 PARAMETERS:
94
95 RETURN:
96
97 DESIGN REFERENCES:
98
99
100 ALGORITHM:
101
102 NOTES:
103
104 OPEN ISSUES:
105
106 CLOSED ISSUES:
107
108 CHANGE HISTORY: WLAU 7/15/1997 Created
109 ===========================================================================*/
110 PROCEDURE Set_Doc_Type ( itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funmode in varchar2,
114 result out NOCOPY varchar2 );
115
116 /*===========================================================================
117 PROCEDURE NAME: Start_Approval_WF
118
119 DESCRIPTION: See the package body
120
121 PARAMETERS:
122
123 RETURN:
124
125 DESIGN REFERENCES:
126
127
128 ALGORITHM:
129
130 NOTES:
131
132 OPEN ISSUES:
133
134 CLOSED ISSUES:
135
136 CHANGE HISTORY: WLAU 7/15/1997 Created
137 ===========================================================================*/
138
139 PROCEDURE Start_Doc_Approval ( itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funmode in varchar2,
143 result out NOCOPY varchar2 );
144
145
146
147 /*===========================================================================
148 PROCEDURE NAME: SetUpWorkFlow
149
150 DESCRIPTION: See the package body
151
152 PARAMETERS:
153
154 RETURN:
155
156 DESIGN REFERENCES:
157
158
159 ALGORITHM:
160
161 NOTES:
162
163 OPEN ISSUES:
164
165 CLOSED ISSUES:
166
167 CHANGE HISTORY: WLAU 7/15/1997 Created
168 ===========================================================================*/
169 PROCEDURE SetUpWorkFlow ( p_ActionOriginatedFrom IN varchar2,
170 p_DocumentID IN number,
171 p_DocumentNumber IN varchar2,
172 p_PreparerID IN number,
173 p_ResponsibilityID IN number,
174 p_ApplicationID IN number,
175 p_DocumentTypeCode IN varchar2,
176 p_DocumentSubtype IN varchar2,
177 p_RequestorAction IN varchar2,
178 p_forwardToID IN number default NULL,
179 p_forwardFromID IN number,
180 p_DefaultApprovalPathID IN number,
181 p_DocumentStatus IN varchar2,
182 p_Note IN varchar2 );
183
184
185
186 /*===========================================================================
187 PROCEDURE NAME: Is_Forward_To_Valid
188
189 DESCRIPTION: See the package body
190
191 PARAMETERS:
192
193 RETURN:
194
195 DESIGN REFERENCES:
196
197
198 ALGORITHM:
199
200 NOTES:
201
202 OPEN ISSUES:
203
204 CLOSED ISSUES:
205
206 CHANGE HISTORY: WLAU 7/15/1997 Created
207 ===========================================================================*/
208 PROCEDURE Is_Forward_To_Valid( itemtype IN varchar2,
209 itemkey IN varchar2,
210 actid IN number,
211 funcmode IN varchar2,
212 resultout OUT NOCOPY varchar2 );
213
214
215 /*===========================================================================
216 PROCEDURE NAME: Cancel_Notif
217
218 DESCRIPTION: See the package body
219
220 PARAMETERS:
221
222 RETURN:
223
224 DESIGN REFERENCES:
225
226
227 ALGORITHM:
228
229 NOTES:
230
231 OPEN ISSUES:
232
233 CLOSED ISSUES:
234
235 CHANGE HISTORY: WLAU 7/15/1997 Created
236 ===========================================================================*/
237 PROCEDURE Cancel_Notif ( p_DocumentTypeCode IN varchar2,
238 p_DocumentID IN number,
239 p_ReleaseFlag IN varchar2 default null);
240
241 /*===========================================================================
242 PROCEDURE NAME: stop_process
243
244 DESCRIPTION: See the package body
245
246 PARAMETERS:
247
248 RETURN:
249
250 DESIGN REFERENCES:
251
252
253 ALGORITHM:
254
255 NOTES:
256
257 OPEN ISSUES:
258
259 CLOSED ISSUES:
260
261 CHANGE HISTORY: WLAU 7/15/1997 Created
262 ===========================================================================*/
263 PROCEDURE Stop_Process ( item_type IN varchar2,
264 item_key IN varchar2);
265
266 FUNCTION is_active ( x_item_type IN varchar2,
267 x_item_key IN varchar2) RETURN BOOLEAN;
268
269
270
271 PROCEDURE item_exist ( p_ItemType IN VARCHAR2,
272 p_ItemKey IN VARCHAR2,
273 p_Item_exist OUT NOCOPY VARCHAR2,
274 p_Item_end_date OUT NOCOPY DATE);
275
276 -- <SVC_NOTIFICATIONS FPJ START>
277 -------------------------------------------------------------------------------
278 --Start of Comments
279 --Name: process_po_temp_labor_lines
280 --Function:
281 -- Starts the Reminder workflow to send notifications for Temp Labor lines
282 -- that match the reminder criteria (Amount Billed Exceeds Budget,
283 -- Contractor Assignment Nearing Completion).
284 --Notes:
285 -- See the package body for more comments.
286 --End of Comments
287 -------------------------------------------------------------------------------
288 PROCEDURE process_po_temp_labor_lines;
289
290 -------------------------------------------------------------------------------
291 --Start of Comments
292 --Name: start_po_line_reminder_wf
293 --Function:
294 -- Starts the Reminder workflow for the given PO line and line reminder type.
295 --Notes:
296 -- See the package body for more comments.
297 --End of Comments
298 -------------------------------------------------------------------------------
299 PROCEDURE start_po_line_reminder_wf (
300 p_po_line_id IN PO_LINES.po_line_id%TYPE,
301 p_line_reminder_type IN VARCHAR2,
302 p_requester_id IN NUMBER,
303 p_contractor_or_job IN VARCHAR2,
304 p_expiration_date IN DATE
305 );
306
307 -------------------------------------------------------------------------------
308 --Start of Comments
309 --Name: get_po_line_reminder_type
310 --Function:
311 -- Returns the value of the PO Line Reminder Type item attribute.
312 --Notes:
313 -- See the package body for more comments.
314 --End of Comments
315 -------------------------------------------------------------------------------
316 PROCEDURE get_po_line_reminder_type (
317 itemtype IN VARCHAR2,
318 itemkey IN VARCHAR2,
319 actid IN NUMBER,
320 funcmode IN VARCHAR2,
321 resultout OUT NOCOPY VARCHAR2
322 );
323 -- <SVC_NOTIFICATIONS FPJ END>
324
325 END PO_APPROVAL_REMINDER_SV;
326