[Home] [Help]
PACKAGE: APPS.PQH_SS_WORKFLOW
Source
1 Package pqh_ss_workflow AUTHID CURRENT_USER as
2 /* $Header: pqwftswi.pkh 120.0.12020000.2 2013/01/22 15:25:52 ckondapi ship $*/
3
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 --
15 FUNCTION get_transaction_id (
16 p_itemType IN VARCHAR2
17 ,p_itemKey IN VARCHAR2 ) RETURN NUMBER ;
18 --
19 --
20 FUNCTION get_notified_activity (
21 p_itemType IN VARCHAR2
22 ,p_itemKey IN VARCHAR2
23 ,p_ntfId IN VARCHAR2
24 ) RETURN NUMBER ;
25 --
26 --
27 FUNCTION get_notified_activity (
28 p_itemType IN VARCHAR2
29 ,p_itemKey IN VARCHAR2
30 ) RETURN NUMBER;
31 --
32 --
33 PROCEDURE start_approval_wf (
34 itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 actid IN NUMBER,
37 funcmode IN VARCHAR2,
38 result OUT NOCOPY VARCHAR2 );
39 --
40 --
41 PROCEDURE complete_wf_activity (
42 p_itemType IN VARCHAR2,
43 p_itemKey IN VARCHAR2,
44 p_activity IN NUMBER,
45 p_otherAct IN VARCHAR2,
46 p_resultCode IN VARCHAR2,
47 p_commitFlag IN VARCHAR2 DEFAULT 'N' );
48 --
49 --
50 PROCEDURE get_transaction_info (
51 p_itemType IN VARCHAR2
52 ,p_itemKey IN VARCHAR2
53 ,p_loginPerson IN VARCHAR2
54 ,p_whatchecks IN VARCHAR2 DEFAULT 'EPIG'
55 ,p_calledFrom IN VARCHAR2 DEFAULT 'REQUEST'
56 ,p_personId OUT NOCOPY VARCHAR2
57 ,p_assignmentId OUT NOCOPY VARCHAR2
58 ,p_state OUT NOCOPY VARCHAR2
59 ,p_status OUT NOCOPY VARCHAR2
60 ,p_txnId OUT NOCOPY VARCHAR2
61 ,p_businessGrpId OUT NOCOPY VARCHAR2
62 ,p_editAllowed OUT NOCOPY VARCHAR2
63 ,p_futureChange OUT NOCOPY VARCHAR2
64 ,p_pendingTxn OUT NOCOPY VARCHAR2
65 ,p_interAction OUT NOCOPY VARCHAR2
66 ,p_effDateOption IN OUT NOCOPY VARCHAR2
67 ,p_effectiveDate IN OUT NOCOPY VARCHAR2
68 ,p_isPersonElig OUT NOCOPY VARCHAR2
69 ,p_rptgGrpId OUT NOCOPY VARCHAR2
70 ,p_planId OUT NOCOPY VARCHAR2
71 ,p_processName OUT NOCOPY VARCHAR2
72 ,p_dateParmExist OUT NOCOPY VARCHAR2
73 ,p_rateParmExist OUT NOCOPY VARCHAR2
74 ,p_slryParmExist OUT NOCOPY VARCHAR2
75 ,p_rateMessage OUT NOCOPY VARCHAR2
76 ,p_terminateFlag OUT NOCOPY VARCHAR2 );
77 --
78 --
79 PROCEDURE revert_to_last_save (
80 p_txnId IN NUMBER
81 ,p_itemType IN VARCHAR2
82 ,p_itemKey IN VARCHAR2
83 ,p_status IN VARCHAR2
84 ,p_state IN VARCHAR2
85 ,p_revertFlag IN VARCHAR2 ) ;
86 --
87 --
88 PROCEDURE get_url_for_edit (
89 p_itemType IN VARCHAR2
90 ,p_itemKey IN VARCHAR2
91 ,p_activityId OUT NOCOPY VARCHAR2
92 ,p_functionName OUT NOCOPY VARCHAR2
93 ,p_url OUT NOCOPY VARCHAR2 );
94 --
95 --
96 PROCEDURE reset_txn_current_values (
97 itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 actid IN NUMBER,
100 funcmode IN VARCHAR2,
101 result OUT NOCOPY VARCHAR2 ) ;
102 --
103 --
104 PROCEDURE return_for_correction (
105 p_itemType IN VARCHAR2
106 , p_itemKey IN VARCHAR2
107 , p_userId IN VARCHAR2
108 , p_userName IN VARCHAR2
109 , p_userDisplayName IN VARCHAR2
110 , p_ntfId IN VARCHAR2
111 , p_note IN VARCHAR2
112 , p_approverIndex IN NUMBER
113 , p_txnId IN VARCHAR2 );
114 --
115 --
116 PROCEDURE check_initial_save_for_later (
117 itemtype IN VARCHAR2,
118 itemkey IN VARCHAR2,
119 actid IN NUMBER,
120 funcmode IN VARCHAR2,
121 result OUT NOCOPY VARCHAR2 );
122 --
123 --
124 PROCEDURE set_transaction_status (
125 p_itemtype IN VARCHAR2,
126 p_itemkey IN VARCHAR2,
127 p_activityId IN VARCHAR2 DEFAULT NULL,
128 p_action IN VARCHAR2,
129 p_result OUT NOCOPY VARCHAR2 ) ;
130 --
131 --
132 PROCEDURE set_txn_submit_status (
133 itemtype IN VARCHAR2,
134 itemkey IN VARCHAR2,
135 actid IN NUMBER,
136 funcmode IN VARCHAR2,
137 result OUT NOCOPY VARCHAR2 );
138 --
139 --
140 PROCEDURE set_txn_approve_status (
141 itemtype IN VARCHAR2,
142 itemkey IN VARCHAR2,
143 actid IN NUMBER,
144 funcmode IN VARCHAR2,
145 result OUT NOCOPY VARCHAR2 );
146 --
147 --
148 PROCEDURE set_txn_rfc_status (
149 itemtype IN VARCHAR2,
150 itemkey IN VARCHAR2,
151 actid IN NUMBER,
152 funcmode IN VARCHAR2,
153 result OUT NOCOPY VARCHAR2 );
154 --
155 --
156 PROCEDURE set_txn_sfl_status (
157 itemtype IN VARCHAR2,
158 itemkey IN VARCHAR2,
159 actid IN NUMBER,
160 funcmode IN VARCHAR2,
161 result OUT NOCOPY VARCHAR2 ) ;
162 --
163 --
164 /* 22-May-2003:ns: commenting as it is no longer used
165 PROCEDURE check_eligibility (
166 itemtype IN VARCHAR2,
167 itemkey IN VARCHAR2,
168 actid IN NUMBER,
169 funcmode IN VARCHAR2,
170 result OUT NOCOPY VARCHAR2 ) ;
171 --
172 --
173 PROCEDURE apply_or_approve_only (
174 itemtype IN VARCHAR2,
175 itemkey IN VARCHAR2,
176 actid IN NUMBER,
177 funcmode IN VARCHAR2,
178 result OUT NOCOPY VARCHAR2 ) ;
179 */
180 --
181 --
182 PROCEDURE get_edit_link(
183 document_id IN VARCHAR2,
184 display_type IN VARCHAR2,
185 document IN OUT NOCOPY VARCHAR2,
186 document_type IN OUT NOCOPY VARCHAR2);
187 --
188 --
189 /*
190 procedure Notify_HR_Rep(
191 itemtype IN VARCHAR2,
192 itemkey IN VARCHAR2,
193 actid IN NUMBER,
194 funcmode IN VARCHAR2,
195 resultout IN OUT NOCOPY VARCHAR2) ;
196 --
197 */
198 --
199 PROCEDURE set_effective_date_and_option (
200 p_txnId IN VARCHAR2
201 ,p_effectiveDate IN DATE
202 ,p_effectiveDateOption IN VARCHAR2 );
203 --
204 --
205 PROCEDURE check_for_warning_error (
206 document_id IN VARCHAR2,
207 display_type IN VARCHAR2,
208 document IN OUT NOCOPY VARCHAR2,
209 document_type IN OUT NOCOPY VARCHAR2) ;
210 --
211 --
212 PROCEDURE set_date_if_as_of_approval (
213 itemtype IN VARCHAR2,
214 itemkey IN VARCHAR2,
215 actid IN NUMBER,
216 funcmode IN VARCHAR2,
217 result OUT NOCOPY VARCHAR2 );
218 --
219 --
220 FUNCTION is_notification_closed (
221 p_ntfId IN VARCHAR2 ) RETURN VARCHAR2;
222 --
223 --
224 FUNCTION complete_custom_rfc (
225 p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 ;
226 --
227 --
228 PROCEDURE validation_on_final_approval (
229 itemtype IN VARCHAR2,
230 itemkey IN VARCHAR2,
231 actid IN NUMBER,
232 funcmode IN VARCHAR2,
233 result OUT NOCOPY VARCHAR2 ) ;
234 --
235 --
236 FUNCTION get_errors_and_warnings (
237 p_itemType IN VARCHAR2,
238 p_itemKey IN VARCHAR2,
239 p_calledFrom IN VARCHAR2 DEFAULT NULL,
240 p_addToPub IN VARCHAR2 DEFAULT 'NO',
241 p_sendToHr OUT NOCOPY VARCHAR2,
242 p_hasErrors OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
243 --
244 --
245 procedure delete_txn_notification(
246 p_itemType IN VARCHAR2
247 ,p_itemKey IN VARCHAR2
248 ,p_transactionId IN VARCHAR2
249 );
250 --
251 --
252 PROCEDURE set_hr_rep_role (
253 itemtype IN VARCHAR2,
254 itemkey IN VARCHAR2,
255 actid IN NUMBER,
256 funcmode IN VARCHAR2,
257 result OUT NOCOPY VARCHAR2 );
258
259 --
260 --
261 procedure approval_block(itemtype in varchar2,
262 itemkey in varchar2,
263 actid in number,
264 funcmode in varchar2,
265 resultout in out nocopy varchar2);
266 --
267 --
268 PROCEDURE approval_history (
269 document_id in varchar2,
270 display_type in varchar2,
271 document in out nocopy varchar2,
272 document_type in out nocopy varchar2 );
273 --
274 --
275 PROCEDURE reset_process_section_attr (
276 itemtype IN VARCHAR2,
277 itemkey IN VARCHAR2,
278 actid IN NUMBER,
279 funcmode IN VARCHAR2,
280 result OUT NOCOPY VARCHAR2 );
281 --
282 --
283 PROCEDURE set_image_source (
284 itemtype IN VARCHAR2,
285 itemkey IN VARCHAR2,
286 actid IN NUMBER,
287 funcmode IN VARCHAR2,
288 result OUT NOCOPY VARCHAR2 ) ;
289 --
290 --
291 PROCEDURE get_item_type_and_key (
292 p_ntfId IN NUMBER
293 ,p_itemType OUT NOCOPY VARCHAR2
294 ,p_itemKey OUT NOCOPY VARCHAR2 ) ;
295 --
296 --
297 FUNCTION set_developer_ntf_msg (
298 p_itemType IN VARCHAR2
299 ,p_itemKey IN VARCHAR2) RETURN VARCHAR;
300 --
301 --
302 PROCEDURE get_curr_notified_activity (
303 p_itemType IN VARCHAR2
304 ,p_itemKey IN VARCHAR2
305 ,p_activityId OUT NOCOPY NUMBER );
306 --
307 --
308 END; -- Package Specification PQH_SS_WORKFLOW