1 PACKAGE PA_SELF_SERVICE_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAXSSWFS.pls 120.1 2005/08/09 04:31:49 avajain noship $ */
3
4 -- Constant names for projects workflow
5
6 -----------------------------------------------------------------------------
7 PROCEDURE EmployeeEqualToPreparer(p_s_item_type IN VARCHAR2,
8 p_s_item_key IN VARCHAR2,
9 p_n_actid IN NUMBER,
10 p_s_funmode IN VARCHAR2,
11 p_s_result OUT NOCOPY VARCHAR2);
12 ----------------------------------------------------------------------
13 /**
14 Purpose: This procedure checks if the timecard can be autoapproved.
15
16 Input: This procedure is called from workflow activity - so it has
17 standard parameters for workflow function activity APIs
18 p_s_item_type - Internal Name of the workflow itemtype calling this
19 procedure.
20 p_s_item_key - Unique workflow instance identifier for the item type
21 calling this procedure.
22 p_n_actid - The ID number of the activity that this procedure is
23 called from.
24 p_s_funmode - The execution mode of the function activity.It could
25 be RUN/CANCEL/TIMEOUT.
26 Output:
27 p_s_result - If a result type is specified for the activity then
28 this parameter indicates the result returned when the
29 activity completes.
30 **/
31
32 PROCEDURE Autoapprove( p_s_item_type IN VARCHAR2,
33 p_s_item_key IN VARCHAR2,
34 p_n_actid IN NUMBER,
35 p_s_funmode IN VARCHAR2,
36 p_s_result OUT NOCOPY VARCHAR2);
37 -----------------------------------------------------------------------------
38 /**
39 Purpose: This procedure finds an approver. It calls client extensions to find
40 an approver setup by the user.
41
42 Input: This procedure is called from workflow activity - so it has
43 standard parameters for workflow function activity APIs.
44 The parameter descriptions are given for procedure 'Autoapprove'.
45 **/
46
47 PROCEDURE FindApprover( p_s_item_type IN VARCHAR2,
48 p_s_item_key IN VARCHAR2,
49 p_n_actid IN NUMBER,
50 p_s_funmode IN VARCHAR2,
51 p_s_result OUT NOCOPY VARCHAR2);
52 -----------------------------------------------------------------------------
53 /**
54 Purpose: This procedure checks if the timecard is routed to the FirstApprover.
55
56 Input: This procedure is called from workflow activity - so it has
57 standard parameters for workflow function activity APIs.
58 The parameter descriptions are given for procedure 'Autoapprove'.
59 **/
60 PROCEDURE FirstApprover( p_s_item_type IN VARCHAR2,
61 p_s_item_key IN VARCHAR2,
62 p_n_actid IN NUMBER,
63 p_s_funmode IN VARCHAR2,
64 p_s_result OUT NOCOPY VARCHAR2);
65 -----------------------------------------------------------------------------
66 /**
67 Purpose: This procedure checks if the timecard is routed to the Approver who
68 is not a first approver.
69
70 Input: This procedure is called from workflow activity - so it has
71 standard parameters for workflow function activity APIs.
72 The parameter descriptions are given for procedure 'Autoapprove'.
73 **/
74 PROCEDURE ApprovalForwarded( p_s_item_type IN VARCHAR2,
75 p_s_item_key IN VARCHAR2,
76 p_n_actid IN NUMBER,
77 p_s_funmode IN VARCHAR2,
78 p_s_result OUT NOCOPY VARCHAR2);
79 ----------------------------------------------------------------------------
80 /**
81 Purpose: This procedure checks if the approver is the direct manager of the
82 employee.
83
84 Input: This procedure is called from workflow activity - so it has
85 standard parameters for workflow function activity APIs.
86 The parameter descriptions are given for procedure 'Autoapprove'.
87 **/
88 PROCEDURE IsApproverManager( p_s_item_type IN VARCHAR2,
89 p_s_item_key IN VARCHAR2,
90 p_n_actid IN NUMBER,
91 p_s_funmode IN VARCHAR2,
92 p_s_result OUT NOCOPY VARCHAR2);
93 ----------------------------------------------------------------------------
94 /**
95 Purpose: This procedure records information about the previous approver
96 everytime the timecard is routed to another approver.
97
98 Input: This procedure is called from workflow activity - so it has
99 standard parameters for workflow function activity APIs.
100 The parameter descriptions are given for procedure 'Autoapprove'.
101 **/
102 PROCEDURE RecordForwardFromInfo(p_s_item_type IN VARCHAR2,
103 p_s_item_key IN VARCHAR2,
104 p_n_actid IN NUMBER,
105 p_s_funmode IN VARCHAR2,
106 p_s_result OUT NOCOPY VARCHAR2);
107 ----------------------------------------------------------------------------
108 /**
109 Purpose: This procedure calls client extension to check authority of the
110 approver.
111
112 Input: This procedure is called from workflow activity - so it has
113 standard parameters for workflow function activity APIs.
114 The parameter descriptions are given for procedure 'Autoapprove'.
115 **/
116 PROCEDURE VerifyAuthority( p_s_item_type IN VARCHAR2,
117 p_s_item_key IN VARCHAR2,
118 p_n_actid IN NUMBER,
119 p_s_funmode IN VARCHAR2,
120 p_s_result OUT NOCOPY VARCHAR2);
121 ---------------------------------------------------------------------------
122 /**
123 Purpose: This procedure updates the PA_EXPENDITURE_ALL table once timecard
124 is approved.
125
126 Input: This procedure is called from workflow activity - so it has
127 standard parameters for workflow function activity APIs.
128 The parameter descriptions are given for procedure 'Autoapprove'.
129 **/
130 PROCEDURE Approved( p_s_item_type IN VARCHAR2,
131 p_s_item_key IN VARCHAR2,
132 p_n_actid IN NUMBER,
133 p_s_funmode IN VARCHAR2,
134 p_s_result OUT NOCOPY VARCHAR2);
135 ---------------------------------------------------------------------------
136 /**
137 Purpose: This procedure sets the status to Rejected and reset workflow
138 attributes since the instance can be restarted.
139
140 Input: This procedure is called from workflow activity - so it has
141 standard parameters for workflow function activity APIs.
142 The parameter descriptions are given for procedure 'Autoapprove'.
143 **/
144 PROCEDURE Rejected( p_s_item_type IN VARCHAR2,
145 p_s_item_key IN VARCHAR2,
146 p_n_actid IN NUMBER,
147 p_s_funmode IN VARCHAR2,
148 p_s_result OUT NOCOPY VARCHAR2);
149 --------------------------------------------------------------------------
150 /**
151 Purpose: This procedure gets the manager of the employee .
152
153 Input: This procedure is called from StartTimecardProcess procedure - as
154 it sets the attribute value manager_id.
155 **/
156
157 PROCEDURE CallbackFunction( p_s_item_type IN VARCHAR2,
158 p_s_item_key IN VARCHAR2,
159 p_n_actid IN NUMBER,
160 p_s_command IN VARCHAR2,
161 p_s_result OUT NOCOPY VARCHAR2);
162
163
164 PROCEDURE GenerateTimecardLines(p_s_document_id IN VARCHAR2,
165 p_s_display_type IN VARCHAR2,
166 p_s_document IN OUT NOCOPY VARCHAR2,
167 p_s_document_type IN OUT NOCOPY VARCHAR2);
168 -------------------------------------------------------------------------------
169 PROCEDURE GenerateDocumentAttributeValue(p_s_document_id IN VARCHAR2,
170 p_s_display_type IN VARCHAR2,
171 p_s_document IN OUT NOCOPY VARCHAR2,
172 p_s_document_type IN OUT NOCOPY VARCHAR2);
173 ----------------------------------------------------------------------------------
174 PROCEDURE IsTimecardTransferred( p_s_item_type IN VARCHAR2,
175 p_s_item_key IN VARCHAR2,
176 p_n_actid IN NUMBER,
177 p_s_funmode IN VARCHAR2,
178 p_s_result OUT NOCOPY VARCHAR2);
179
180
181 -------------------------------------------------------------------------------------
182 PROCEDURE ClearTransferInfo( p_s_item_type IN VARCHAR2,
183 p_s_item_key IN VARCHAR2,
184 p_n_actid IN NUMBER,
185 p_s_funmode IN VARCHAR2,
186 p_s_result OUT NOCOPY VARCHAR2);
187
188 --------------------------------------------------------------------------------------
189 PROCEDURE SetTransferInfo( p_s_item_type IN VARCHAR2,
190 p_s_item_key IN VARCHAR2,
191 p_n_actid IN NUMBER,
192 p_s_funmode IN VARCHAR2,
193 p_s_result OUT NOCOPY VARCHAR2);
194
195 END PA_SELF_SERVICE_WF_PKG;