1 PACKAGE pay_us_tax_wf
2 /* $Header: pyustxwf.pkh 115.1 2004/01/13 06:29:47 rsethupa noship $ *
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 2000 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material AUTHID CURRENT_USER is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_tax_wf
21
22 Description : Contains workflow code for Tax Notification workflow
23
24 Uses :
25
26 Change List
27 -----------
28 Date Name Vers Description
29 ---- ---- ---- -----------
30 28-SEP-2000 dscully 115.0 Created.
31 13-JAN-2004 rsethupa 115.1 Added dbdrv command
32 Added NOCOPY after out
33 parameter in procedures.
34
35
36 *******************************************************************/
37 AS
38
39 gv_itemtype VARCHAR2(80) := 'PYUSTXNT';
40
41 PROCEDURE start_wf(p_transaction_id IN pay_stat_trans_audit.stat_trans_audit_id%TYPE,
42 p_process IN varchar2
43 );
44 /******************************************************************
45 **
46 ** Description:
47 ** initializes and starts workflow process
48 **
49 ** Access Status:
50 ** Public
51 **
52 ******************************************************************/
53
54
55 PROCEDURE init_tax_notifications(itemtype in varchar2
56 ,itemkey in varchar2
57 ,actid in number
58 ,funcmode in varchar2
59 ,result out NOCOPY varchar2
60 );
61 /******************************************************************
62 **
63 ** Description:
64 ** Initializes the item attributes as appropriate.
65 **
66 ** Access Status:
67 ** Public
68 **
69 ******************************************************************/
70
71 procedure check_final_notifier( itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 result out NOCOPY varchar2 );
76 /******************************************************************
77 **
78 ** Description:
79 ** Checks if current notifier is the final notifier by
80 ** calling custom code in hr_approvals custom.
81 **
82 ** Access Status:
83 ** Public
84 **
85 ******************************************************************/
86
87
88 PROCEDURE get_next_notifier(itemtype in varchar2
89 ,itemkey in varchar2
90 ,actid in number
91 ,funcmode in varchar2
92 ,result out NOCOPY varchar2
93 );
94 /******************************************************************
95 **
96 ** Description:
97 ** Gets the next payroll rep who needs to be notified and sets
98 ** the forward from/to item attributes as proper.
99 **
100 **
101 ** Access Status:
102 ** Public
103 **
104 ******************************************************************/
105
106 PROCEDURE check_for_notification(itemtype in varchar2
107 ,itemkey in varchar2
108 ,actid in number
109 ,funcmode in varchar2
110 ,result out NOCOPY varchar2
111 );
112 /******************************************************************
113 **
114 ** Description:
115 ** Checks to see if Submission needs to be forwarded to a
116 ** payroll manager.
117 **
118 **
119 **
120 ** Access Status:
121 ** Public
122 **
123 ******************************************************************/
124
125 END pay_us_tax_wf;