[Home] [Help]
PACKAGE: APPS.ENG_WORKFLOW_UTIL
Source
1 PACKAGE Eng_Workflow_Util AS
2 /* $Header: ENGUWKFS.pls 120.5 2006/04/11 17:57:28 mkimizuk noship $ */
3 --
4 -- Constant Variables : GetWorkflowMonitorURL
5 --
6
7 -- Api Caller WF
8 G_WF_CALL VARCHAR2(30) := 'WF' ;
9
10 -- None Return Status
11 G_RET_STS_NONE CONSTANT VARCHAR2(1) := 'N';
12
13 -- Seeded Eng Worklfow Item Type
14 G_STD_ITEM_TYPE CONSTANT VARCHAR2(8) := 'ENGWFSTD';
15 G_CHANGE_ACTION_ITEM_TYPE CONSTANT VARCHAR2(8) := 'ENGCACT';
16 G_CHANGE_LINE_ACTION_ITEM_TYPE CONSTANT VARCHAR2(8) := 'ENGCLACT';
17 G_CHANGE_ROUTE_ITEM_TYPE CONSTANT VARCHAR2(8) := 'ENGCRT' ;
18 G_CHANGE_ROUTE_STEP_ITEM_TYPE CONSTANT VARCHAR2(8) := 'ENGCSTEP' ;
19 G_CHANGE_ROUTE_DOC_STEP_TYPE CONSTANT VARCHAR2(8) := 'ENGDSTEP' ;
20 G_CHANGE_ROUTE_LINE_STEP_TYPE CONSTANT VARCHAR2(8) := 'ENGLSTEP' ;
21
22
23 -- Seeded Eng Worklfow Process
24 G_CL_INITIATE_CHANGE_PROC CONSTANT VARCHAR2(30) := 'INITIATE_CHANGE';
25 G_RESPONSE_FYI_PROC CONSTANT VARCHAR2(30) := 'RESPONSE_FYI';
26 G_APPROVAL_STATUS_CHANGE_PROC CONSTANT VARCHAR2(30) := 'APPROVAL_STATUS_CHANGE' ;
27 G_VALIDATE_DEFINITION_PROC CONSTANT VARCHAR2(30) := 'VALIDATE_DEFINITION' ;
28 G_STATUS_CHANGE_PROC CONSTANT VARCHAR2(30) := 'STATUS_CHANGE' ;
29 G_ROUTE_AGENT_PROC CONSTANT VARCHAR2(30) := 'ROUTE_AGENT' ;
30
31
32 -- Seeded Eng Worklfow Block Abort Activity
33 G_BLOCK_ABORT_ACTIVITY CONSTANT VARCHAR2(30) := 'BLOCK_ABORT';
34
35
36 -- Eng Change Object Name
37 G_ENG_CHANGE CONSTANT VARCHAR2(30) := 'ENG_CHANGE' ;
38 G_ENG_CHANGE_LINE CONSTANT VARCHAR2(30) := 'ENG_CHANGE_LINE' ;
39
40
41 -- R12B DOM Document Support
42 G_OCS_FILE CONSTANT VARCHAR2(30) := ENG_DOCUMENT_UTIL.G_OCS_FILE;
43 G_DOM_DOCUMENT_REVISION CONSTANT VARCHAR2(30) := ENG_DOCUMENT_UTIL.G_DOM_DOCUMENT_REVISION;
44
45
46 -- Workflow Adhoc Role Pre-Fix
47 -- ':', '#' or '/' should not be included
48 --
49 G_ADHOC_PARTY_ROLE CONSTANT VARCHAR2(20) := 'ENG_ADHOC,';
50 G_REV_ROLE CONSTANT VARCHAR2(20) := 'ENG_REV,';
51 G_ASSIGNEE_ROLE CONSTANT VARCHAR2(20) := 'ENG_ASSIGNEE,';
52 G_LINE_REV_ROLE CONSTANT VARCHAR2(20) := 'ENG_LINE_REV,';
53 G_LINE_ASSIGNEE_ROLE CONSTANT VARCHAR2(20) := 'ENG_LINE_ASSIGNEE,';
54 G_OWNER_ROLE CONSTANT VARCHAR2(20) := 'ENG_OWNER,';
55 G_ROUTE_PEOPLE_ROLE CONSTANT VARCHAR2(20) := 'ENG_ROUTE_PEOPLE,' ;
56 G_STEP_PEOPLE_ROLE CONSTANT VARCHAR2(20) := 'ENG_STEP_PEOPLE,';
57
58 -- Action Types
59 G_ACT_COMMENT CONSTANT VARCHAR2(30) := 'COMMENT' ;
60 G_ACT_REPLIED CONSTANT VARCHAR2(30) := 'REPLIED' ; -- user response
61 G_ACT_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED' ; -- user response
62 G_ACT_COMPLETED CONSTANT VARCHAR2(30) := 'COMPLETED' ; -- user response
63 G_ACT_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED' ; -- user response
64 G_ACT_PROMOTE CONSTANT VARCHAR2(30) := 'PROMOTE' ;
65 G_ACT_DEMOTE CONSTANT VARCHAR2(30) := 'DEMOTE' ;
66
67 G_ACT_DELEGATED CONSTANT VARCHAR2(30) := 'DELEGATED' ; -- user response for ntf proxy
68 G_ACT_TRANSFERRED CONSTANT VARCHAR2(30) := 'TRANSFERRED' ; -- user response for ntf proxy
69
70 G_ACT_WF_STARTED CONSTANT VARCHAR2(30) := 'WF_STARTED' ; -- Wf started
71 G_ACT_WF_COMPLETED CONSTANT VARCHAR2(30) := 'WF_COMPLETED' ; -- wf completed
72 G_ACT_WF_APPROVED CONSTANT VARCHAR2(30) := 'WF_APPROVED' ; -- wf approved
73 G_ACT_WF_REJECTED CONSTANT VARCHAR2(30) := 'WF_REJECTED' ; -- wf rejected
74 G_ACT_WF_ABORTED CONSTANT VARCHAR2(30) := 'WF_ABORTED' ; -- wf aborted
75 G_ACT_WF_TIME_OUT CONSTANT VARCHAR2(30) := 'WF_TIME_OUT' ; -- wf timed out
76 G_ACT_WF_PROCESS_ERROR CONSTANT VARCHAR2(30) := 'WF_PROCESS_ERROR' ; -- wf process error
77
78 G_ACT_ABORTED CONSTANT VARCHAR2(30) := 'ABORTED' ; -- obsolete in 115.10
79 G_ACT_REQUEST_APPROVAL CONSTANT VARCHAR2(30) := 'REQUEST_APPROVAL' ; -- obsolete in 115.10
80 G_ACT_TIMEOUT_WF CONSTANT VARCHAR2(30) := 'TIMEOUT_WF' ; -- obsolete in 115.10
81
82 -- R12B
83 G_LINE_ACT_CHG_STATUS CONSTANT VARCHAR2(30) := 'CHANGE_STATUS' ; -- Line Status Change Action
84 G_ACT_DECLINED CONSTANT VARCHAR2(30) := 'DECLINED' ; -- obsolete in 115.10
85 G_ACT_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIVED' ; -- obsolete in 115.10
86
87 -- Action System Party ID
88 G_ACT_SYSTEM_USER_ID CONSTANT NUMBER := -10000 ;
89
90 -- Workflow Seeded Internal Status
91 G_WF_NOTIFIED CONSTANT VARCHAR2(8) := 'NOTIFIED' ;
92 G_WF_ACTIVIE CONSTANT VARCHAR2(8) := 'ACTIVE' ;
93 G_WF_COMPLETE CONSTANT VARCHAR2(8) := 'COMPLETE' ;
94 G_WF_ERROR CONSTANT VARCHAR2(8) := 'ERROR' ;
95 G_WF_SUSPEND CONSTANT VARCHAR2(8) := 'SUSPEND' ;
96 G_WF_DEFERRED CONSTANT VARCHAR2(8) := 'DEFERRED' ;
97 G_WF_WAITING CONSTANT VARCHAR2(8) := 'WAITING' ;
98 G_WF_TRANSFER CONSTANT VARCHAR2(8) := 'TRANSFER' ;
99 G_WF_FORWARD CONSTANT VARCHAR2(8) := 'FORWARD' ;
100
101 -- MFG Lookup Type: ENG_ECN_APPROVAL_STATUS
102 -- Used for Change Object's Approval Status
103 -- ENG_ENGINEERING_CHANGES.APPROVAL_STATUS_TYPE
104 G_NOT_SUBMITTED CONSTANT NUMBER := 1 ; -- Not submitted for approval
105 G_READY CONSTANT NUMBER := 2 ; -- Ready to approve
106 G_REQUESTED CONSTANT NUMBER := 3 ; -- Approval requested
107 G_REJECTED CONSTANT NUMBER := 4 ; -- Rejected
108 G_APPROVED CONSTANT NUMBER := 5 ; -- Approved
109 G_NO_APPR_NEEDED CONSTANT NUMBER := 6 ; -- No approval needed
110 G_ERROR CONSTANT NUMBER := 7 ; -- Processing error
111 G_TIME_OUT CONSTANT NUMBER := 8 ; -- Time out
112
113
114 -- Old MFG Lookup Type: ECG_ECN_STATUS
115 -- New status table : ENG_CHANGE_STATUSES
116 -- Used for Change Object's Status Type
117 -- ENG_ENGINEERING_CHANGES.STATUS_TYPE
118 G_CHG_OPEN CONSTANT NUMBER := 1 ; -- Open
119 G_CHG_HOLD CONSTANT NUMBER := 2 ; -- Hold
120 G_CHG_SCHEDULED CONSTANT NUMBER := 4 ; -- Scheduled
121 G_CHG_CANCELLED CONSTANT NUMBER := 5 ; -- Cancelled
122 G_CHG_IMPLEMENTED CONSTANT NUMBER := 6 ; -- Implemented
123 G_CHG_RELEASED CONSTANT NUMBER := 7 ; -- Released
124 G_CHG_ANALYSIS CONSTANT NUMBER := 8 ; -- Analysis
125 G_CHG_PENDING CONSTANT NUMBER := 9 ; -- Pending Response
126 G_CHG_IN_PROGRESS CONSTANT NUMBER := 10 ; -- In Progress
127 G_CHG_COMPLETED CONSTANT NUMBER := 11 ; -- Completed
128
129
130 -- Fnd Lookup Type: ENG_CHANGE_LINE_STATUSES
131 -- Used for Chagne Line Object's Status Code
132 -- ENG_CHANGE_LINES.STATUS_CODE
133 --
134 G_CL_OPEN CONSTANT VARCHAR2(30) := '1' ; -- Open
135 G_CL_CANCELLED CONSTANT VARCHAR2(30) := '5' ; -- Cancelled
136 G_CL_COMPLETED CONSTANT VARCHAR2(30) := '11'; -- Completed
137
138 -- Fnd Lookup Type: ENG_DIST_LINE_STATUSES
139 -- Used for Chagne Distribution Line Object's Status Code
140 -- if "Notification" type Line Workflow is attached on the Line
141 -- ENG_CHANGE_LINES.STATUS_CODE
142 --
143 G_DIST_CL_NOT_DISTRIBUTED CONSTANT VARCHAR2(30) := '1'; -- Not Distributed
144 G_DIST_CL_CANCELLED CONSTANT VARCHAR2(30) := '5'; -- Cancelled
145 G_DIST_CL_DIST_IN_PROGRESS CONSTANT VARCHAR2(30) := '9'; -- Distribution in Progress
146 G_DIST_CL_DISTRIBUTED CONSTANT VARCHAR2(30) := '11'; -- Distributed
147
148
149 -- Route Template Flag Internal Code
150 G_RT_INSTANCE CONSTANT VARCHAR2(1) := 'N' ; -- Instance
151 G_RT_TEMPLATE CONSTANT VARCHAR2(1) := 'Y' ; -- Template
152 G_RT_HISTORY CONSTANT VARCHAR2(1) := 'H' ; -- History
153
154 -- FND Lookup Type: ENG_CHANGE_ROUTE_STATUSES
155 -- Used for Change Route's Status
156 -- ENG_CHANGE_ROUTES.STATUS_CODE
157 -- Used for Change Route's Status
158 -- ENG_CHANGE_ROUTE_STEPS.STEP_STATUS_CODE
159 -- Used for Change Route People's Response Code
160 -- ENG_CHANGE_ROUTE_PEOPLE.RESPONSE_CODE
161 --
162 G_RT_NOT_STARTED CONSTANT VARCHAR2(30) := 'NOT_STARTED' ; -- Not Started
163 G_RT_IN_PROGRESS CONSTANT VARCHAR2(30) := 'IN_PROGRESS' ; -- In Progress
164 G_RT_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED' ; -- Approved
165 G_RT_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED' ; -- Rejected
166 G_RT_TIME_OUT CONSTANT VARCHAR2(30) := 'TIME_OUT' ; -- Time Out
167 G_RT_ABORTED CONSTANT VARCHAR2(30) := 'ABORTED' ; -- Aborted
168 G_RT_COMPLETED CONSTANT VARCHAR2(30) := 'COMPLETED' ; -- Completed
169 G_RT_REPLIED CONSTANT VARCHAR2(30) := 'REPLIED' ; -- Replied
170 G_RT_ERROR CONSTANT VARCHAR2(30) := 'ERROR' ; -- Failed (Future)
171 G_RT_SUBMITTED CONSTANT VARCHAR2(30) := 'SUBMITTED' ; -- Submitted
172 G_RT_TRANSFERRED CONSTANT VARCHAR2(30) := 'TRANSFERED' ; -- Transferred
173 G_RT_FORWARDED CONSTANT VARCHAR2(30) := 'FORWARDED' ; -- Forwarded
174
175 -- R12B Line Workflow Specific Status
176 G_RT_RECEIVED CONSTANT VARCHAR2(30) := 'RECEIVED' ; -- Received
177 G_RT_DECLINED CONSTANT VARCHAR2(30) := 'DECLINED' ; -- Declined
178 G_RT_NOT_RECEIVED CONSTANT VARCHAR2(30) := 'NOT_RECEIVED' ; -- Not Received
179
180
181 -- FND Lookup Type: ENG_ROUTE_ASSIGNEE_TYPES
182 -- Used for Change Route People's Assignee Type
183 -- ENG_CHANGE_ROUTE_PEOPLE.ASSIGNEE_TYPE_CODE
184 G_PERSON CONSTANT VARCHAR2(30) := 'PERSON' ; -- Person
185 G_GROUP CONSTANT VARCHAR2(30) := 'GROUP' ; -- Group
186 G_ROLE CONSTANT VARCHAR2(30) := 'ROLE' ; -- Role
187
188
189 -- FND Lookup Type: ENG_CHANGE_ROUTE_CONDITIONS
190 -- Used for Change Route Step's Condition
191 -- ENG_CHANGE_ROUTE_STEPS.STEP_STATUS_CODE
192 G_ONE CONSTANT VARCHAR2(30) := 'ONE' ; -- One Can Approve
193 G_ALL CONSTANT VARCHAR2(30) := 'ALL' ; -- All Must Approve
194 G_PEOPLE CONSTANT VARCHAR2(30) := 'PEOPLE' ; -- Assignee Level
195
196 -- FND Lookup Type: ENG_ROUTE_RESP_CONDITIONS
197 -- Used for Change Route Step Assignee's Response Condition
198 -- ENG_CHANGE_ROUTE_STEPS.STEP_STATUS_CODE
199 G_MANDATORY CONSTANT VARCHAR2(30) := 'MANDATORY' ; -- Mandatory
200 G_OPTIONAL CONSTANT VARCHAR2(30) := 'OPTIONAL' ; -- Optional
201
202 -- FND Lookup Type: ENG_ROUTE_TYPE_CODES
203 -- Used for Change Route TYpe Codes
204 -- ENG_CHANGE_ROUTES.ROUTE_TYPE_CODE
205 G_RT_TYPE_APPROVAL CONSTANT VARCHAR2(30) := 'APPROVAL' ;
206 G_RT_TYPE_DEFINITION CONSTANT VARCHAR2(30) := 'DEFINITION' ;
207 G_RT_TYPE_DEFINITION_APPROVAL CONSTANT VARCHAR2(30) := 'DEFINITION_APPROVAL' ;
208 G_RT_TYPE_GENERIC CONSTANT VARCHAR2(30) := 'GENERIC' ;
209
210
211
212 -- FND Lookup Type: ENG_LINE_ROUTE_TYPE_CODES
213 -- Used for Change Route TYpe Codes
214 -- ENG_CHANGE_ROUTES.ROUTE_TYPE_CODE
215 G_LINE_RT_TYPE_NOTIFICATION CONSTANT VARCHAR2(30) := 'NOTIFICATION' ;
216 G_LINE_RT_TYPE_GENERIC CONSTANT VARCHAR2(30) := 'GENERIC' ;
217
218
219 -- FND Lookup Type: ENG_DOC_ROUTE_TYPE_CODES
220 -- Used for Change Route TYpe Codes
221 -- ENG_CHANGE_ROUTES.ROUTE_TYPE_CODE
222 G_DOC_RT_TYPE_APPROVAL CONSTANT VARCHAR2(30) := 'APPROVAL' ;
223 G_DOC_RT_TYPE_GENERIC CONSTANT VARCHAR2(30) := 'GENERIC' ;
224
225
226
227 -- WFSTD_VOTING_OPTION: Standard Voting Option Lookup Codes
228 G_WAIT_FOR_ALL_VOTES CONSTANT VARCHAR2(30) := 'WAIT_FOR_ALL_VOTES' ;
229 G_REQUIRE_ALL_VOTES CONSTANT VARCHAR2(30) := 'REQUIRE_ALL_VOTES' ;
230 G_TALLY_ON_EVERY_VOTE CONSTANT VARCHAR2(30) := 'TALLY_ON_EVERY_VOTE' ;
231
232
233 -- WFSTD_SIGNATURE_POLICY: Signature Policy Lookup Codes
234 G_SIG_POLICY_DEFAULT CONSTANT VARCHAR2(30) := 'DEFAULT' ;
235 G_SIG_POLICY_PSIG_ONLY CONSTANT VARCHAR2(30) := 'PSIG_ONLY' ;
236 G_SIG_POLICY_PKCS7X509_ONLY CONSTANT VARCHAR2(30) := 'PKCS7X509_ONLY' ;
237
238 -- Monitor URL Types for GetWorkflowMonitorURL
239 G_MONITOR_ACCESSKEY CONSTANT VARCHAR2(15) := 'ACCESSKEY';
240 G_MONITOR_DIAGRAM CONSTANT VARCHAR2(15) := 'DIAGRAM';
241 G_MONITOR_ENVELOPE CONSTANT VARCHAR2(15) := 'ENVELOPE';
242 G_MONITOR_ADVANCED_ENVELOPE CONSTANT VARCHAR2(20) := 'ADVANCED_ENVELOPE';
243
244
245 -- ENGWFSTD_REQ_COMMENT_RESULT: Eng Request Comment Result Lookup Codes
246 G_REPLY CONSTANT VARCHAR2(30) := 'REPLY' ;
247
248 --
249 -- R12B
250 -- Grant/Revoke API Options
251 --
252 G_REVOKE_ALL CONSTANT VARCHAR2(30) := 'REVOKE_ALL' ;
253 G_REVOKE_HEADER CONSTANT VARCHAR2(30) := 'REVOKE_HEADER' ;
254 G_REVOKE_LINE CONSTANT VARCHAR2(30) := 'REVOKE_LINE' ;
255
256 --
257 -- R12B
258 -- Reserved Attribute Name used for the special logic
259 --
260 G_ATTR_AUTO_REVOKE_RESPONSE CONSTANT VARCHAR2(30) := 'AUTO_REVOKE_RESPONSE' ;
261
262
263 --
264 -- R12B
265 -- Notification Mandatory Response: Special Case
266 --
267 G_MANDATORY_RESP_ANY CONSTANT VARCHAR2(30) := 'ANY' ;
268
269 -- Bug5136260 Support
270 G_MRP_FLAG_YES CONSTANT NUMBER := 1 ; -- Yes: Active
271 G_MRP_FLAG_NO CONSTANT NUMBER := 2 ; -- No: Inactive
272
273
274
275
276
277
278 /********************************************************************
279 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
280 * Write_Debug
281 * Parameters IN :
282 * Parameters OUT:
283 * Purpose : These procedures are for test and debug
284 *********************************************************************/
285 -- Open_Debug_Session
286 PROCEDURE Open_Debug_Session
287 ( p_output_dir IN VARCHAR2 := NULL
288 , p_file_name IN VARCHAR2 := NULL
289 );
290
291 -- Close Debug_Session
292 PROCEDURE Close_Debug_Session ;
293
294 -- Write Debug Message
295 PROCEDURE Write_Debug
296 ( p_debug_message IN VARCHAR2 ) ;
297
298 -- Write Debug Mode from Workflow Function Activities
299 PROCEDURE Get_Debug_Mode
300 ( p_item_type IN VARCHAR2
301 , p_item_key IN VARCHAR2
302 , x_debug_flag OUT NOCOPY BOOLEAN
303 , x_output_dir OUT NOCOPY VARCHAR2
304 , x_debug_filename OUT NOCOPY VARCHAR2
305 );
306
307 /********************************************************************
308 * API Type : Private APIs
309 * Purpose : Those APIs are private
310 *********************************************************************/
311 FUNCTION GetBaseChangeMgmtTypeCode
312 ( p_change_id IN NUMBER)
313 RETURN VARCHAR2 ;
314
315
316 FUNCTION GetNewItemKey
317 RETURN VARCHAR2 ;
318
319
320 PROCEDURE GetChangeObject
321 ( p_item_type IN VARCHAR2
322 , p_item_key IN VARCHAR2
323 , x_change_id OUT NOCOPY NUMBER
324 ) ;
325
326 PROCEDURE GetChangeObject
327 ( p_item_type IN VARCHAR2
328 , p_item_key IN VARCHAR2
329 , x_change_id OUT NOCOPY NUMBER
330 , x_change_notice OUT NOCOPY VARCHAR2
331 , x_organization_id OUT NOCOPY NUMBER
332 ) ;
333
334 -- Get Organization Info
335 PROCEDURE GetOrgInfo
336 ( p_organization_id IN NUMBER
337 , x_organization_code OUT NOCOPY VARCHAR2
338 , x_organization_name OUT NOCOPY VARCHAR2
339 ) ;
340
341 PROCEDURE GetChangeLineObject
342 ( p_item_type IN VARCHAR2
343 , p_item_key IN VARCHAR2
344 , x_change_line_id OUT NOCOPY NUMBER
345 ) ;
346
347 -- Get Change Object Item Subject Info
348 PROCEDURE GetChangeItemSubjectInfo
349 ( p_change_id IN NUMBER
350 , x_organization_id OUT NOCOPY NUMBER
351 , x_item_id OUT NOCOPY NUMBER
352 , x_item_name OUT NOCOPY VARCHAR2
353 , x_item_revision_id OUT NOCOPY NUMBER
354 , x_item_revision OUT NOCOPY VARCHAR2
355 , x_item_revision_label OUT NOCOPY VARCHAR2
356 ) ;
357
358 -- Get Change Line Item Subject Info
359 PROCEDURE GetChangeLineItemSubjectInfo
360 ( p_change_id IN NUMBER
361 , p_change_line_id IN NUMBER
362 , x_organization_id OUT NOCOPY NUMBER
363 , x_item_id OUT NOCOPY NUMBER
364 , x_item_name OUT NOCOPY VARCHAR2
365 , x_item_revision_id OUT NOCOPY NUMBER
366 , x_item_revision OUT NOCOPY VARCHAR2
367 , x_item_revision_label OUT NOCOPY VARCHAR2
368 ) ;
369
370
371 PROCEDURE GetHostURL
372 ( p_item_type IN VARCHAR2
373 , p_item_key IN VARCHAR2
374 , x_host_url OUT NOCOPY VARCHAR2
375 ) ;
376
377 FUNCTION GetFrameWorkAgentURL
378 RETURN VARCHAR2 ;
379
380
381
382 PROCEDURE GetStyleSheet
383 ( p_item_type IN VARCHAR2
384 , p_item_key IN VARCHAR2
385 , x_style_sheet OUT NOCOPY VARCHAR2
386 ) ;
387
388 PROCEDURE GetActionId
389 ( p_item_type IN VARCHAR2
390 , p_item_key IN VARCHAR2
391 , x_action_id OUT NOCOPY NUMBER
392 ) ;
393
394 PROCEDURE GetWFUserId
395 ( p_item_type IN VARCHAR2
396 , p_item_key IN VARCHAR2
397 , x_wf_user_id OUT NOCOPY NUMBER
398 ) ;
399
400 PROCEDURE GetRouteId
401 ( p_item_type IN VARCHAR2
402 , p_item_key IN VARCHAR2
403 , x_route_id OUT NOCOPY NUMBER
404 ) ;
405
406
407 PROCEDURE GetRouteObject
408 ( p_item_type IN VARCHAR2
409 , p_item_key IN VARCHAR2
410 , x_route_object OUT NOCOPY VARCHAR2
411 ) ;
412
413 PROCEDURE GetRouteTypeCode
414 ( p_route_id IN NUMBER
415 , x_route_type_code OUT NOCOPY VARCHAR2
416 ) ;
417
418
419 PROCEDURE GetRouteComplStatusCode
420 ( p_route_id IN NUMBER
421 , p_route_type_code IN VARCHAR2 := NULL
422 , x_route_compl_status_code OUT NOCOPY VARCHAR2
423 ) ;
424
425
426 PROCEDURE GetRouteStepId
427 ( p_item_type IN VARCHAR2
428 , p_item_key IN VARCHAR2
429 , x_route_step_id OUT NOCOPY NUMBER
430 ) ;
431
432 PROCEDURE SetRouteStepId
433 ( p_item_type IN VARCHAR2
434 , p_item_key IN VARCHAR2
435 , p_route_step_id IN NUMBER
436 ) ;
437
438
439 PROCEDURE GetNtfResponseTimeOut
440 ( p_item_type IN VARCHAR2
441 , p_item_key IN VARCHAR2
442 , x_timeout_min OUT NOCOPY NUMBER
443 ) ;
444
445
446 PROCEDURE SetNtfResponseTimeOut
447 ( p_item_type IN VARCHAR2
448 , p_item_key IN VARCHAR2
449 , p_response_by_date IN DATE
450 ) ;
451
452 PROCEDURE SetNtfResponseTimeOut
453 ( p_item_type IN VARCHAR2
454 , p_item_key IN VARCHAR2
455 , p_required_relative_days IN NUMBER
456 ) ;
457
458 PROCEDURE SetStepActVotingOption
459 ( p_item_type IN VARCHAR2
460 , p_item_key IN VARCHAR2
461 , p_condition_type_code IN VARCHAR2
462 ) ;
463
464
465 /*
466 -- OBSOLETE in 115.10
467 PROCEDURE SetChangeApprovalStatus
468 ( x_return_status OUT NOCOPY VARCHAR2
469 , x_msg_count OUT NOCOPY NUMBER
470 , x_msg_data OUT NOCOPY VARCHAR2
471 , p_item_type IN VARCHAR2 := NULL
472 , p_item_key IN VARCHAR2 := NULL
473 , p_change_id IN NUMBER
474 , p_change_line_id IN NUMBER := NULL
475 , p_sync_lines IN NUMBER := NULL -- Yes: greater than 0
476 , p_wf_user_id IN NUMBER
477 , p_new_appr_status_type IN NUMBER
478 ) ;
479 */
480
481 /*
482 -- OBSOLETE in 115.10
483 PROCEDURE SyncLineApprovalStatus
484 ( x_return_status OUT NOCOPY VARCHAR2
485 , x_msg_count OUT NOCOPY NUMBER
486 , x_msg_data OUT NOCOPY VARCHAR2
487 , p_change_id IN NUMBER
488 , p_wf_user_id IN NUMBER
489 , p_header_appr_status_type IN NUMBER
490 ) ;
491 */
492
493
494 PROCEDURE SetRouteStatus
495 ( p_item_type IN VARCHAR2
496 , p_item_key IN VARCHAR2
497 , p_wf_user_id IN NUMBER
498 , p_route_id IN NUMBER
499 , p_new_status_code IN VARCHAR2
500 , p_init_route IN VARCHAR2 := FND_API.G_FALSE
501 , p_change_id IN NUMBER := NULL
502 , p_change_line_id IN NUMBER := NULL -- R12B. Added
503
504 ) ;
505
506 PROCEDURE SetRouteStepStatus
507 ( p_item_type IN VARCHAR2
508 , p_item_key IN VARCHAR2
509 , p_wf_user_id IN NUMBER
510 , p_route_id IN NUMBER
511 , p_route_step_id IN NUMBER
512 , p_new_status_code IN VARCHAR2
513 ) ;
514
515
516 PROCEDURE GetRouteStepStatus
517 ( p_item_type IN VARCHAR2
518 , p_item_key IN VARCHAR2
519 , p_route_step_id IN NUMBER
520 , x_status_code OUT NOCOPY VARCHAR2
521 ) ;
522
523
524 -- Get Change Object Info
525 PROCEDURE GetChangeObjectInfo
526 ( p_change_id IN NUMBER
527 , x_change_notice OUT NOCOPY VARCHAR2
528 , x_organization_id OUT NOCOPY NUMBER
529 , x_change_name OUT NOCOPY VARCHAR2
530 , x_description OUT NOCOPY VARCHAR2
531 , x_change_status OUT NOCOPY VARCHAR2
532 , x_change_lc_phase OUT NOCOPY VARCHAR2
533 , x_approval_status OUT NOCOPY VARCHAR2
534 , x_priority OUT NOCOPY VARCHAR2
535 , x_reason OUT NOCOPY VARCHAR2
536 , x_change_managemtent_type OUT NOCOPY VARCHAR2
537 , x_change_order_type OUT NOCOPY VARCHAR2
538 , x_eco_department OUT NOCOPY VARCHAR2
539 , x_assignee OUT NOCOPY VARCHAR2
540 , x_assignee_company OUT NOCOPY VARCHAR2
541 ) ;
542
543 -- Get Change Line Object Info
544 PROCEDURE GetChangeLineObjectInfo
545 ( p_change_line_id IN NUMBER
546 , x_change_id OUT NOCOPY NUMBER
547 , x_line_sequence_number OUT NOCOPY NUMBER
548 , x_line_name OUT NOCOPY VARCHAR2
549 , x_line_description OUT NOCOPY VARCHAR2
550 , x_line_status OUT NOCOPY VARCHAR2
551 , x_line_approval_status OUT NOCOPY VARCHAR2
552 , x_line_assignee OUT NOCOPY VARCHAR2
553 , x_line_assignee_company OUT NOCOPY VARCHAR2
554 ) ;
555
556
557 -- Get Workflow Change Object Info
558 PROCEDURE GetWFChangeObjectInfo
559 ( p_item_type IN VARCHAR2
560 , p_item_key IN VARCHAR2
561 , x_change_name OUT NOCOPY VARCHAR2
562 , x_description OUT NOCOPY VARCHAR2
563 , x_change_status OUT NOCOPY VARCHAR2
564 , x_approval_status OUT NOCOPY VARCHAR2
565 , x_priority OUT NOCOPY VARCHAR2
566 , x_reason OUT NOCOPY VARCHAR2
567 , x_change_managemtent_type OUT NOCOPY VARCHAR2
568 , x_change_order_type OUT NOCOPY VARCHAR2
569 , x_eco_department OUT NOCOPY VARCHAR2
570 , x_assignee OUT NOCOPY VARCHAR2
571 , x_assignee_company OUT NOCOPY VARCHAR2
572 ) ;
573
574 PROCEDURE GetWFChangeLineObjectInfo
575 ( p_item_type IN VARCHAR2
576 , p_item_key IN VARCHAR2
577 , x_line_sequence_number OUT NOCOPY NUMBER
578 , x_line_name OUT NOCOPY VARCHAR2
579 , x_line_description OUT NOCOPY VARCHAR2
580 , x_line_status OUT NOCOPY VARCHAR2
581 , x_line_assignee OUT NOCOPY VARCHAR2
582 , x_line_assignee_company OUT NOCOPY VARCHAR2
583 ) ;
584
585
586 PROCEDURE GetActionInfo
587 ( p_action_id IN NUMBER
588 , x_action_desc OUT NOCOPY VARCHAR2
589 , x_action_party_id OUT NOCOPY VARCHAR2
590 , x_action_party_name OUT NOCOPY VARCHAR2
591 , x_action_party_company_name OUT NOCOPY VARCHAR2
592 ) ;
593
594
595 PROCEDURE GetRouteStepInfo
596 ( p_route_step_id IN NUMBER
597 , x_step_seq_num OUT NOCOPY NUMBER
598 , x_required_date OUT NOCOPY DATE
599 , x_condition_type OUT NOCOPY VARCHAR2
600 , x_step_instrunction OUT NOCOPY VARCHAR2
601 ) ;
602
603
604 PROCEDURE ValidateProcess
605 ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
606 , x_return_status OUT NOCOPY VARCHAR2
607 , x_msg_count OUT NOCOPY NUMBER
608 , x_msg_data OUT NOCOPY VARCHAR2
609 , p_item_type IN VARCHAR2
610 , p_process_name IN VARCHAR2
611 , p_change_id IN NUMBER := NULL
612 , p_change_line_id IN NUMBER := NULL
613 , p_wf_user_id IN NUMBER
614 , p_host_url IN VARCHAR2
615 , p_action_id IN NUMBER := NULL
616 , p_adhoc_party_list IN VARCHAR2 := NULL
617 , p_route_id IN NUMBER := NULL
618 , p_route_step_id IN NUMBER := NULL
619 , p_parent_item_type IN VARCHAR2 := NULL
620 , p_parent_item_key IN VARCHAR2 := NULL
621 , p_object_name IN VARCHAR2 := NULL
622 , p_object_id1 IN NUMBER := NULL
623 , p_object_id2 IN NUMBER := NULL
624 , p_object_id3 IN NUMBER := NULL
625 , p_object_id4 IN NUMBER := NULL
626 , p_object_id5 IN NUMBER := NULL
627 , p_parent_object_name IN VARCHAR2 := NULL
628 , p_parent_object_id1 IN NUMBER := NULL
629 ) ;
630
631 PROCEDURE SetAttributes
632 ( x_return_status OUT NOCOPY VARCHAR2
633 , x_msg_count OUT NOCOPY NUMBER
634 , x_msg_data OUT NOCOPY VARCHAR2
635 , p_item_type IN VARCHAR2
636 , p_item_key IN VARCHAR2
637 , p_process_name IN VARCHAR2
638 , p_change_id IN OUT NOCOPY NUMBER
639 , p_change_line_id IN NUMBER := NULL
640 , p_wf_user_id IN NUMBER
641 , p_wf_user_role IN VARCHAR2 := NULL
642 , p_host_url IN VARCHAR2
643 , p_action_id IN NUMBER := NULL
644 , p_adhoc_party_list IN VARCHAR2 := NULL
645 , p_route_id IN NUMBER := NULL
646 , p_route_step_id IN NUMBER := NULL
647 , p_parent_item_type IN VARCHAR2 := NULL
648 , p_parent_item_key IN VARCHAR2 := NULL
649 , p_object_name IN VARCHAR2 := NULL
650 , p_object_id1 IN NUMBER := NULL
651 , p_object_id2 IN NUMBER := NULL
652 , p_object_id3 IN NUMBER := NULL
653 , p_object_id4 IN NUMBER := NULL
654 , p_object_id5 IN NUMBER := NULL
655 , p_parent_object_name IN VARCHAR2 := NULL
656 , p_parent_object_id1 IN NUMBER := NULL
657 ) ;
658
659
660
661 PROCEDURE SetAdhocPartyRole
662 ( x_return_status OUT NOCOPY VARCHAR2
663 , x_msg_count OUT NOCOPY NUMBER
664 , x_msg_data OUT NOCOPY VARCHAR2
665 , p_item_type IN VARCHAR2
666 , p_item_key IN VARCHAR2
667 , p_adhoc_party_list IN VARCHAR2
668 ) ;
669
670
671 -- API name : SetAssigneeRole
672 -- Type : Private
673 -- Pre-reqs : None.
674 -- Function : Set Assignee Role
675 PROCEDURE SetAssigneeRole
676 ( x_return_status OUT NOCOPY VARCHAR2
677 , x_msg_count OUT NOCOPY NUMBER
678 , x_msg_data OUT NOCOPY VARCHAR2
679 , p_item_type IN VARCHAR2
680 , p_item_key IN VARCHAR2
681 ) ;
682
683
684 -- API name : SetReviewersRole
685 -- Type : Private
686 -- Pre-reqs : None.
687 -- Function : Set Reviewers Role
688 -- Parameters : p_reviewer_type IN VARCHAR2 Optional
689 -- Default = STD
690 -- In case that you don't want to
691 -- inlcude Assingee to Reviewers
692 -- Role, set 'NO_ASSIGNEE'
693 PROCEDURE SetReviewersRole
694 ( x_return_status OUT NOCOPY VARCHAR2
695 , x_msg_count OUT NOCOPY NUMBER
696 , x_msg_data OUT NOCOPY VARCHAR2
697 , p_item_type IN VARCHAR2
698 , p_item_key IN VARCHAR2
699 , p_reviewer_type IN VARCHAR2 := 'STD'
700 ) ;
701
702 -- API name : StartAllLineWorkflows
703 -- Type : Private
704 -- Pre-reqs : None.
705 -- Function : Start p_line_item, p_line_process Workflows
706 -- for the Lines
707 -- Parameters : p_item_type IN VARCHAR2 Required
708 -- p_item_key IN VARCHAR2 Required
709 -- p_change_id IN NUMBER Required
710 -- p_wf_user_id IN NUMBER Required
711 -- p_host_url IN VARCHAR2 Optional
712 -- p_line_item_type IN VARCHAR2 Required
713 -- p_line_process_name IN VARCHAR2 Required
714 --
715 --
716 PROCEDURE StartAllLineWorkflows
717 ( x_return_status OUT NOCOPY VARCHAR2
718 , x_msg_count OUT NOCOPY NUMBER
719 , x_msg_data OUT NOCOPY VARCHAR2
720 , p_item_type IN VARCHAR2
721 , p_item_key IN VARCHAR2
722 , p_change_id IN NUMBER
723 , p_wf_user_id IN NUMBER
724 , p_host_url IN VARCHAR2 := NULL
725 , p_line_item_type IN VARCHAR2
726 , p_line_process_name IN VARCHAR2
727 ) ;
728
729
730
731 -- API name : SetLineAssigneeRole
732 -- Type : Private
733 -- Pre-reqs : None.
734 -- Function : Set Line Assignee Role
735 PROCEDURE SetLineAssigneeRole
736 ( x_return_status OUT NOCOPY VARCHAR2
737 , x_msg_count OUT NOCOPY NUMBER
738 , x_msg_data OUT NOCOPY VARCHAR2
739 , p_item_type IN VARCHAR2
740 , p_item_key IN VARCHAR2
741 ) ;
742
743
744 -- API name : SetLineReviewersRole
745 -- Type : Private
746 -- Pre-reqs : None.
747 -- Function : Set Line Reviewers Role
748 -- Parameters : p_reviewer_type IN VARCHAR2 Optional
749 -- Default = STD
750 -- In case that you don't want to
751 -- inlcude Line Assingee to Reviewers
752 -- Role, set 'NO_ASSIGNEE'
753 PROCEDURE SetLineReviewersRole
754 ( x_return_status OUT NOCOPY VARCHAR2
755 , x_msg_count OUT NOCOPY NUMBER
756 , x_msg_data OUT NOCOPY VARCHAR2
757 , p_item_type IN VARCHAR2
758 , p_item_key IN VARCHAR2
759 , p_reviewer_type IN VARCHAR2 := 'STD'
760 ) ;
761
762 -- API name : SetRoutePeopleRole
763 -- Type : Private
764 -- Pre-reqs : None.
765 -- Function : Set Assignee Role
766 PROCEDURE SetRoutePeopleRole
767 ( x_return_status OUT NOCOPY VARCHAR2
768 , x_msg_count OUT NOCOPY NUMBER
769 , x_msg_data OUT NOCOPY VARCHAR2
770 , p_item_type IN VARCHAR2
771 , p_item_key IN VARCHAR2
772 , p_option IN VARCHAR2 := NULL
773 ) ;
774
775
776
777 -- API name : SetStepPeopleRole
778 -- Type : Private
779 -- Pre-reqs : None.
780 -- Function : Set Assignee Role
781 PROCEDURE SetStepPeopleRole
782 ( x_return_status OUT NOCOPY VARCHAR2
783 , x_msg_count OUT NOCOPY NUMBER
784 , x_msg_data OUT NOCOPY VARCHAR2
785 , p_item_type IN VARCHAR2
786 , p_item_key IN VARCHAR2
787 ) ;
788
789
790 PROCEDURE DeleteAdhocRolesAndUsers
791 ( x_return_status OUT NOCOPY VARCHAR2
792 , x_msg_count OUT NOCOPY NUMBER
793 , x_msg_data OUT NOCOPY VARCHAR2
794 , p_item_type IN VARCHAR2
795 , p_item_key IN VARCHAR2
796 ) ;
797
798
799 PROCEDURE CreateAction
800 ( x_return_status OUT NOCOPY VARCHAR2
801 , x_msg_count OUT NOCOPY NUMBER
802 , x_msg_data OUT NOCOPY VARCHAR2
803 , p_item_type IN VARCHAR2
804 , p_item_key IN VARCHAR2
805 , p_notification_id IN NUMBER
806 , p_action_type IN VARCHAR2
807 , p_comment IN VARCHAR2 := NULL
808 , x_action_id OUT NOCOPY NUMBER
809 , p_assignee_id IN NUMBER :=NULL
810 , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
811 ) ;
812
813 PROCEDURE CreateRouteAction
814 ( x_return_status OUT NOCOPY VARCHAR2
815 , x_msg_count OUT NOCOPY NUMBER
816 , x_msg_data OUT NOCOPY VARCHAR2
817 , p_change_id IN NUMBER := NULL
818 , p_change_line_id IN NUMBER := NULL
819 , p_action_type IN VARCHAR2
820 , p_user_id IN NUMBER
821 , p_parent_action_id IN NUMBER := NULL
822 , p_route_id IN NUMBER := NULL
823 , p_comment IN VARCHAR2 := NULL
824 , x_action_id OUT NOCOPY NUMBER
825 , p_object_name IN VARCHAR2 := NULL
826 , p_object_id1 IN NUMBER := NULL
827 , p_object_id2 IN NUMBER := NULL
828 , p_object_id3 IN NUMBER := NULL
829 , p_object_id4 IN NUMBER := NULL
830 , p_object_id5 IN NUMBER := NULL
831 , p_parent_object_name IN VARCHAR2 := NULL
832 , p_parent_object_id1 IN NUMBER := NULL
833 , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
834 ) ;
835
836
837 PROCEDURE SyncChangeLCPhase
838 ( x_return_status OUT NOCOPY VARCHAR2
839 , x_msg_count OUT NOCOPY NUMBER
840 , x_msg_data OUT NOCOPY VARCHAR2
841 , p_route_id IN NUMBER
842 , p_api_caller IN VARCHAR2 := NULL -- or G_WF_CALL:'WF'
843 ) ;
844
845
846 PROCEDURE SetRouteResponse
847 ( x_return_status OUT NOCOPY VARCHAR2
848 , x_msg_count OUT NOCOPY NUMBER
849 , x_msg_data OUT NOCOPY VARCHAR2
850 , p_item_type IN VARCHAR2
851 , p_item_key IN VARCHAR2
852 , p_notification_id IN NUMBER
853 , p_response_code IN VARCHAR2
854 , p_comment IN VARCHAR2 := NULL
855 , p_actid IN NUMBER := NULL -- added in R12B
856 , p_funcmode IN VARCHAR2 := NULL -- added in R12B
857 ) ;
858
859
860 PROCEDURE FindNextRouteStep
861 ( x_return_status OUT NOCOPY VARCHAR2
862 , x_msg_count OUT NOCOPY NUMBER
863 , x_msg_data OUT NOCOPY VARCHAR2
864 , p_route_id IN NUMBER
865 , x_step_id OUT NOCOPY NUMBER
866 , x_step_item_type OUT NOCOPY VARCHAR2
867 , x_step_process_name OUT NOCOPY VARCHAR2
868 ) ;
869
870
871 PROCEDURE StartNextRouteStep
872 ( x_return_status OUT NOCOPY VARCHAR2
873 , x_msg_count OUT NOCOPY NUMBER
874 , x_msg_data OUT NOCOPY VARCHAR2
875 , p_route_item_type IN VARCHAR2
876 , p_route_item_key IN VARCHAR2
877 , p_route_id IN NUMBER
878 , p_change_id IN NUMBER := NULL
879 , p_change_line_id IN NUMBER := NULL
880 , p_wf_user_id IN NUMBER
881 , p_host_url IN VARCHAR2
882 , x_step_id OUT NOCOPY NUMBER
883 , x_step_item_type OUT NOCOPY VARCHAR2
884 , x_step_item_key OUT NOCOPY VARCHAR2
885 , p_object_name IN VARCHAR2 := NULL
886 , p_object_id1 IN NUMBER := NULL
887 , p_object_id2 IN NUMBER := NULL
888 , p_object_id3 IN NUMBER := NULL
889 , p_object_id4 IN NUMBER := NULL
890 , p_object_id5 IN NUMBER := NULL
891 , p_parent_object_name IN VARCHAR2 := NULL
892 , p_parent_object_id1 IN NUMBER := NULL
893 , p_route_action_id IN NUMBER := NULL
894 ) ;
895
896
897 PROCEDURE GrantChangeRoleToParty
898 ( x_return_status OUT NOCOPY VARCHAR2
899 , x_msg_count OUT NOCOPY NUMBER
900 , x_msg_data OUT NOCOPY VARCHAR2
901 , p_role_name IN VARCHAR2
902 , p_change_id IN NUMBER
903 , p_party_id IN NUMBER
904 , p_start_date IN DATE
905 , p_end_date IN DATE := NULL
906 ) ;
907
908
909
910 PROCEDURE GrantChangeRoleToStepPeople
911 ( x_return_status OUT NOCOPY VARCHAR2
912 , x_msg_count OUT NOCOPY NUMBER
913 , x_msg_data OUT NOCOPY VARCHAR2
914 , p_item_type IN VARCHAR2
915 , p_item_key IN VARCHAR2
916 , p_change_id IN NUMBER
917 , p_step_id IN NUMBER
918 ) ;
919
920 PROCEDURE StartLineRoutes
921 ( x_return_status OUT NOCOPY VARCHAR2
922 , x_msg_count OUT NOCOPY NUMBER
923 , x_msg_data OUT NOCOPY VARCHAR2
924 , p_item_type IN VARCHAR2
925 , p_item_key IN VARCHAR2
926 , p_change_id IN NUMBER
927 , p_wf_user_id IN NUMBER
928 , p_host_url IN VARCHAR2 := NULL
929 ) ;
930
931 PROCEDURE CheckAllLineApproved
932 ( x_return_status OUT NOCOPY VARCHAR2
933 , x_msg_count OUT NOCOPY NUMBER
934 , x_msg_data OUT NOCOPY VARCHAR2
935 , p_change_id IN NUMBER
936 , x_line_approval_status OUT NOCOPY NUMBER
937 ) ;
938
939 FUNCTION GetFunctionWebHTMLCall(p_function_name IN VARCHAR2)
940 RETURN VARCHAR2 ;
941
942
943 FUNCTION CheckRouteStepRequiredDate(p_route_id IN NUMBER )
944 RETURN BOOLEAN ;
945
946 PROCEDURE RouteStepVoteForResultType
947 ( itemtype in varchar2,
948 itemkey in varchar2,
949 actid in number,
950 funcmode in varchar2,
951 resultout in out NOCOPY varchar2) ;
952
953
954 PROCEDURE ContinueHeaderRoute
955 ( x_return_status OUT NOCOPY VARCHAR2
956 , x_msg_count OUT NOCOPY NUMBER
957 , x_msg_data OUT NOCOPY VARCHAR2
958 , p_item_type IN VARCHAR2
959 , p_item_key IN VARCHAR2
960 , p_actid IN NUMBER
961 , p_waiting_activity IN VARCHAR2
962 , p_waiting_flow_type IN VARCHAR2
963 , x_resultout IN OUT NOCOPY VARCHAR2
964 ) ;
965
966
967
968 PROCEDURE WaitForLineRoute
969 ( x_return_status OUT NOCOPY VARCHAR2
970 , x_msg_count OUT NOCOPY NUMBER
971 , x_msg_data OUT NOCOPY VARCHAR2
972 , p_item_type IN VARCHAR2
973 , p_item_key IN VARCHAR2
974 , p_actid IN NUMBER
975 , p_continuation_activity IN VARCHAR2
976 , p_continuation_flow_type IN VARCHAR2
977 , x_resultout IN OUT NOCOPY VARCHAR2
978 ) ;
979
980
981 -- API name : START_RESPONSE_FYI_PROCESS
982 -- Type : Private
983 -- Pre-reqs : None.
984 -- Function : START RESPONSE FYI PROCESS
985 -- Parameters :p_itemtype IN VARCHAR2 Item type of the Request Process
986 -- p_itemkey IN VARCHAR2 Item Key for the Request Process
987 -- p_orig_response_option IN VARCHAR2 := NULL -- ALL or ONE
988 -- p_responded_ntf_id IN NUMBER The notification id for the request notification
989 -- p_responded_comment_id IN NUMBER := NULL The created Action id while responding
990 -- x_msg_count OUT NUMBER
991 -- x_msg_data OUT VARCHAR2
992 -- x_return_status OUT VARCHAR2
993 --
994
995 PROCEDURE START_RESPONSE_FYI_PROCESS
996 ( p_itemtype IN VARCHAR2
997 , p_itemkey IN VARCHAR2
998 , p_orig_response_option IN VARCHAR2 := NULL -- ALL or ONE
999 , p_responded_ntf_id IN NUMBER
1000 , p_responded_comment_id IN NUMBER := NULL
1001 , x_msg_count OUT NOCOPY NUMBER
1002 , x_msg_data OUT NOCOPY VARCHAR2
1003 , x_return_status OUT NOCOPY VARCHAR2
1004 ) ;
1005
1006
1007 --
1008 -- API name : StartValidateDefProcess
1009 -- Type : Private
1010 -- Pre-reqs : None.
1011 -- Function : Start Validate Definition Process
1012 -- Parameters :p_step_item_type IN VARCHAR2 Item type of the Step Process
1013 -- p_step_item_key IN VARCHAR2 Item Key for the Step Process
1014 -- p_responded_ntf_id IN NUMBER The notification id for the request notification
1015 -- p_route_id IN NUMBER Route Id
1016 -- p_route_step_id IN NUMBER Route Step Id
1017 -- p_val_def_item_type IN VARCHAR2 Validate Definition WF Item Type
1018 -- p_val_def_process_name IN VARCHAR2 Validate Definition WF Process Name
1019 -- p_orig_response IN VARCHAR2 := NULL Original Response Code for Definition Request
1020 -- p_host_url IN VARCHAR2 := NULL Host URL
1021 -- x_msg_count OUT NUMBER
1022 -- x_msg_data OUT VARCHAR2
1023 -- x_return_status OUT VARCHAR2
1024 -- x_val_def_item_key OUT NOCOPY VARCHAR2 Start Definition WF Item Key
1025 --
1026 PROCEDURE StartValidateDefProcess
1027 ( x_msg_count OUT NOCOPY NUMBER
1028 , x_msg_data OUT NOCOPY VARCHAR2
1029 , x_return_status OUT NOCOPY VARCHAR2
1030 , x_val_def_item_key OUT NOCOPY VARCHAR2
1031 , p_step_item_type IN VARCHAR2
1032 , p_step_item_key IN VARCHAR2
1033 , p_responded_ntf_id IN NUMBER
1034 , p_route_id IN NUMBER
1035 , p_route_step_id IN NUMBER
1036 , p_val_def_item_type IN VARCHAR2
1037 , p_val_def_process_name IN VARCHAR2
1038 , p_orig_response IN VARCHAR2 := NULL
1039 , p_host_url IN VARCHAR2 := NULL
1040 ) ;
1041
1042
1043
1044 FUNCTION ConvertRouteStatusToActionType
1045 ( p_route_status_code IN VARCHAR2
1046 , p_convert_type IN VARCHAR2 := 'RESPONSE' -- 'RESPONSE' or 'WF_PROCESS'
1047 )
1048 RETURN VARCHAR2 ;
1049
1050 -- R12B. Added
1051 FUNCTION ConvNtfWFStatToDistLNStat
1052 ( p_route_status_code IN VARCHAR2
1053 , p_convert_type IN VARCHAR2 := NULL -- Future use, 'WF_PROCESS'
1054 )
1055 RETURN VARCHAR2 ;
1056
1057
1058
1059 PROCEDURE reassignRoutePeople( x_return_status OUT NOCOPY VARCHAR2
1060 , x_msg_count OUT NOCOPY NUMBER
1061 , x_msg_data OUT NOCOPY VARCHAR2
1062 , p_item_type IN VARCHAR2
1063 , p_item_key IN VARCHAR2
1064 , p_notification_id IN NUMBER
1065 , p_reassign_mode IN VARCHAR2) ;
1066
1067
1068
1069
1070 --
1071 -- API name : RespondToActReqCommentFromUI
1072 -- Type : Private
1073 -- Pre-reqs : None.
1074 -- Function : Respond to Action Reqeust Comment from other UI
1075 -- e.g Change Action Reply Page other than Ntf Detal Page
1076 -- Parameters :
1077 -- x_return_status OUT VARCHAR2
1078 -- x_msg_count OUT NUMBER
1079 -- x_msg_data OUT VARCHAR2
1080 -- x_processed_ntf_id OUT NUMBER processed notification id -- if there is no ntf processed, return 0
1081 -- p_item_type IN VARCHAR2 Item Type for the Action Workflow
1082 -- p_item_key IN VARCHAR2 Item Key for the Action Workflow
1083 -- p_responder IN VARCHAR2 Responder: FND_USER name
1084 -- p_response_comment IN VARCHAR2 Response Comment := NULL
1085 -- p_action_source IN VARCHAR2 For future use: one of the params
1086 -- in WF_NOTIFICATION.RESPOND API
1087 --
1088 PROCEDURE RespondToActReqCommentFromUI
1089 ( x_return_status OUT NOCOPY VARCHAR2
1090 , x_msg_count OUT NOCOPY NUMBER
1091 , x_msg_data OUT NOCOPY VARCHAR2
1092 , x_processed_ntf_id OUT NOCOPY NUMBER
1093 , p_item_type IN VARCHAR2
1094 , p_item_key IN VARCHAR2
1095 , p_responder IN VARCHAR2
1096 , p_response_comment IN VARCHAR2 := NULL
1097 , p_action_source IN VARCHAR2 := NULL
1098 ) ;
1099
1100
1101 --
1102 -- R12B
1103 -- API name : GrantObjectRoles
1104 -- Type : Private
1105 -- Pre-reqs : None.
1106 -- Function : Grant Change Header/Line Subject Object Roles
1107 -- and OFO Roles on Attachment for Header/Line to WF Assignees
1108 -- Parameters :
1109 -- x_return_status OUT VARCHAR2
1110 -- x_msg_count OUT NUMBER
1111 -- x_msg_data OUT VARCHAR2
1112 --
1113 PROCEDURE GrantObjectRoles
1114 ( p_api_version IN NUMBER
1115 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1116 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1117 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1118 , p_debug IN VARCHAR2 := FND_API.G_FALSE
1119 , p_output_dir IN VARCHAR2 := NULL
1120 , p_debug_filename IN VARCHAR2 := NULL
1121 , x_return_status OUT NOCOPY VARCHAR2
1122 , x_msg_count OUT NOCOPY NUMBER
1123 , x_msg_data OUT NOCOPY VARCHAR2
1124 , p_change_id IN NUMBER
1125 , p_change_line_id IN NUMBER
1126 , p_route_id IN NUMBER
1127 , p_step_id IN NUMBER
1128 , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
1129 , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
1130 , p_api_caller IN VARCHAR2 := NULL
1131 , p_grant_option IN VARCHAR2 := NULL -- Optionnal
1132 ) ;
1133
1134
1135 --
1136 -- R12B
1137 -- API name : RevokeObjectRoles
1138 -- Type : Private
1139 -- Pre-reqs : None.
1140 -- Function : Revoke Change Header/Line Subject Object Roles
1141 -- and OFO Roles on Attachment for Header/Line from WF Assignees
1142 -- Parameters :
1143 -- x_return_status OUT VARCHAR2
1144 -- x_msg_count OUT NUMBER
1145 -- x_msg_data OUT VARCHAR2
1146 --
1147 -- p_revoke_option G_REVOKE_ALL will reovked object roles for Header and Lines
1148 -- G_REVOKE_HEADER will reovked object roles for Header
1149 -- G_REVOKE_LINE will reovked object roles for Line
1150 -- p_revoke_option default G_REVOKE_LINE
1151 --
1152 PROCEDURE RevokeObjectRoles
1153 ( p_api_version IN NUMBER --
1154 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1155 , p_commit IN VARCHAR2 := FND_API.G_FALSE --
1156 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1157 , p_debug IN VARCHAR2 := FND_API.G_FALSE --
1158 , p_output_dir IN VARCHAR2 := NULL
1159 , p_debug_filename IN VARCHAR2 := NULL
1160 , x_return_status OUT NOCOPY VARCHAR2 --
1161 , x_msg_count OUT NOCOPY NUMBER --
1162 , x_msg_data OUT NOCOPY VARCHAR2 --
1163 , p_change_id IN NUMBER -- Change Id
1164 , p_change_line_id IN NUMBER -- Change Line Id
1165 , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
1166 , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
1167 , p_api_caller IN VARCHAR2 := NULL
1168 , p_revoke_option IN VARCHAR2 := NULL -- Optionnal: G_REVOKE_ALL
1169 ) ;
1170
1171
1172 PROCEDURE RevokeObjectRoles
1173 ( p_api_version IN NUMBER --
1174 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1175 , p_commit IN VARCHAR2 := FND_API.G_FALSE --
1176 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1177 , p_debug IN VARCHAR2 := FND_API.G_FALSE --
1178 , p_output_dir IN VARCHAR2 := NULL
1179 , p_debug_filename IN VARCHAR2 := NULL
1180 , x_return_status OUT NOCOPY VARCHAR2 --
1181 , x_msg_count OUT NOCOPY NUMBER --
1182 , x_msg_data OUT NOCOPY VARCHAR2 --
1183 , p_change_id IN NUMBER -- Change Id
1184 , p_change_line_id IN NUMBER -- Change Line Id
1185 , p_route_id IN NUMBER
1186 , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
1187 , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
1188 , p_api_caller IN VARCHAR2 := NULL
1189 , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
1190 ) ;
1191
1192 --
1193 -- R12B
1194 -- API name : RevokeObjectRoles
1195 -- Type : Private
1196 -- Pre-reqs : None.
1197 -- Function : Revoke Change Header/Line Subject Object Roles
1198 -- and OFO Roles on Attachment for Header/Line from WF Assignees
1199 -- Parameters :
1200 -- x_return_status OUT VARCHAR2
1201 -- x_msg_count OUT NUMBER
1202 -- x_msg_data OUT VARCHAR2
1203 --
1204 PROCEDURE RevokeObjectRoles
1205 ( p_api_version IN NUMBER --
1206 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1207 , p_commit IN VARCHAR2 := FND_API.G_FALSE --
1208 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1209 , p_debug IN VARCHAR2 := FND_API.G_FALSE --
1210 , p_output_dir IN VARCHAR2 := NULL
1211 , p_debug_filename IN VARCHAR2 := NULL
1212 , x_return_status OUT NOCOPY VARCHAR2 --
1213 , x_msg_count OUT NOCOPY NUMBER --
1214 , x_msg_data OUT NOCOPY VARCHAR2 --
1215 , p_change_id IN NUMBER -- Change Id
1216 , p_change_line_id IN NUMBER -- Change Line Id
1217 , p_route_id IN NUMBER
1218 , p_step_id IN NUMBER
1219 , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
1220 , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
1221 , p_api_caller IN VARCHAR2 := NULL
1222 , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
1223 ) ;
1224
1225
1226 --
1227 -- Bug5136260
1228 -- API name : SetChangeOrderMRPFlag
1229 -- Type : Private
1230 -- Pre-reqs : None.
1231 -- Function : Set Change Order MFP Flag
1232 -- Parameters :p_change_id IN NUMBER Change Id
1233 -- p_mrp_flag IN NUMBER 1: Yes G_MRP_FLAG_YES
1234 -- 2: No G_MRP_FLAG_NO
1235 -- p_wf_user_id IN NUMBER := NULL
1236 -- p_api_caller IN VARCHAR2 := NULL -- or G_WF_CALL:'WF'
1237 -- x_msg_count OUT NUMBER
1238 -- x_msg_data OUT VARCHAR2
1239 -- x_return_status OUT VARCHAR2
1240 --
1241 PROCEDURE SetChangeOrderMRPFlag
1242 ( x_return_status OUT NOCOPY VARCHAR2
1243 , x_msg_count OUT NOCOPY NUMBER
1244 , x_msg_data OUT NOCOPY VARCHAR2
1245 , p_change_id IN NUMBER
1246 , p_mrp_flag IN NUMBER
1247 , p_wf_user_id IN NUMBER := NULL
1248 , p_api_caller IN VARCHAR2 := NULL -- or G_WF_CALL:'WF'
1249 ) ;
1250
1251
1252
1253
1254 /********************************************************************
1255 * API Type : Public APIs
1256 * Purpose : Those APIs are public
1257 *********************************************************************/
1258 -- API name : GetWorkflowMonitorURL
1259 -- Type : Public
1260 -- Pre-reqs : None.
1261 -- Function : Get Workflow Monitor URL based on given p_url_type
1262 -- Parameters :
1263 -- IN : p_api_version IN NUMBER Required
1264 -- p_init_msg_list IN VARCHAR2 Optional
1265 -- Default = FND_API.G_FALSE
1266 -- p_commit IN VARCHAR2 Optional
1267 -- Default = FND_API.G_FALSE
1268 -- p_validation_level IN NUMBER Optional
1269 -- Default = FND_API.G_VALID_LEVEL_FULL
1270 -- Values:
1271 -- FND_API.G_VALID_LEVEL_NONE 0
1272 -- FND_API.G_VALID_LEVEL_FULL 100
1273 -- p_item_type IN VARCHAR2 Required
1274 -- Identifies workflow item type
1275 -- p_item_key IN VARCHAR2 Required
1276 -- Identifies workflow item key
1277 -- p_url_type IN VARCHAR2 Optional
1278 -- Default = Eng_Workflow_Util.G_MONITOR_DIAGRAM
1279 -- Identifies workflow monitor url type
1280 -- refer to Monitor URL Type constant variables
1281 -- p_admin_mode IN VARCHAR2 Optional
1282 -- Default = FND_API.G_FALSE
1283 -- Identifies workflow monitor url is 'ADMIN' or
1284 -- 'USER' mode
1285 -- p_option IN VARCHAR2 Optional
1286 -- Default = Null
1287 -- In case of p_url_type with G_MONITOR_ADVANCED_ENVELOPE
1288 -- Specify 'All' if you wish to return a URL that
1289 -- displays the Activities List with all filtering options
1290 -- displays checked. If you leave this argument null, then a
1291 -- displays URL that displays the Activities List with no
1292 -- displays filtering options checked, is returned. This allows
1293 -- displays you to append any specific options if you wish.
1294 -- displays The default is null.
1295 --
1296 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
1297 -- x_msg_count OUT NOCOPY NUMBER
1298 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1299 -- x_url OUT NOCOPY VARCHAR2(2000)
1300 -- Version : Current version 1.0 Initial Creation
1301 -- Initial version 1.0
1302 --
1303 -- Notes : Note text
1304 --
1305 PROCEDURE GetWorkflowMonitorURL
1306 ( p_api_version IN NUMBER
1307 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1308 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1309 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1310 , x_return_status OUT NOCOPY VARCHAR2
1311 , x_msg_count OUT NOCOPY NUMBER
1312 , x_msg_data OUT NOCOPY VARCHAR2
1313 , p_item_type IN VARCHAR2
1314 , p_item_key IN VARCHAR2
1315 , p_url_type IN VARCHAR2 := Eng_Workflow_Util.G_MONITOR_DIAGRAM
1316 , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE
1317 , p_option IN VARCHAR2 := NULL
1318 , x_url OUT NOCOPY VARCHAR2
1319 ) ;
1320
1321
1322 -- API name : StartWorkflow
1323 -- Type : Public
1324 -- Pre-reqs : None.
1325 -- Function : Create and Start Workflow Process
1326 -- Parameters :
1327 -- IN : p_api_version IN NUMBER Required
1328 -- p_init_msg_list IN VARCHAR2 Optional
1329 -- Default = FND_API.G_FALSE
1330 -- p_commit IN VARCHAR2 Optional
1331 -- Default = FND_API.G_FALSE
1332 -- p_validation_level IN NUMBER Optional
1333 -- Default = FND_API.G_VALID_LEVEL_FULL
1334 -- Values:
1335 -- FND_API.G_VALID_LEVEL_NONE 0
1336 -- FND_API.G_VALID_LEVEL_FULL 100
1337 -- p_item_type IN VARCHAR2 Required
1338 -- Identifies workflow item type
1339 -- p_process_name IN VARCHAR2 Required
1340 -- Identifies workflow process name
1341 -- p_change_id IN NUMBER Required
1342 -- Identifies Change Object
1343 -- p_change_line_id IN NUMBER Conditionally Required
1344 -- Identifies Change Line Object
1345 -- (seeded p_item_type except 'ENGCLACT' )
1346 -- p_wf_user_id IN NUMBER Conditionally Required
1347 -- Identifies Workflow Owner
1348 -- p_host_url IN VARCHAR2 Optional
1349 -- Identifies Host URL for OA Page
1350 -- p_action_id IN NUMBER Optional
1351 -- Identifies Action for Workflow
1352 -- p_adhoc_party_list IN VARCHAR2 Optional
1353 -- Identifies paties being assigned to a task for Workflow
1354 -- e.g Comment Request wf process will send request ntf to them
1355 -- p_route_id IN NUMBER Optional
1356 -- Identifies Route for Approval Routing
1357 -- p_route_step_id IN NUMBER Optional
1358 -- Identifies Route Step for Approval Routing
1359 --
1360 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
1361 -- x_msg_count OUT NOCOPY NUMBER
1362 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1363 -- IN OUT :
1364 -- x_item_key IN OUT NOCOPY VARCHAR2
1365 -- Identifies workflow item key
1366 -- Version : Current version 1.0 Initial Creation
1367 -- Initial version 1.0
1368 --
1369 -- Notes : Note text
1370 --
1371 PROCEDURE StartWorkflow
1372 ( p_api_version IN NUMBER
1373 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1374 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1375 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1376 , x_return_status OUT NOCOPY VARCHAR2
1377 , x_msg_count OUT NOCOPY NUMBER
1378 , x_msg_data OUT NOCOPY VARCHAR2
1379 , p_item_type IN VARCHAR2
1380 , x_item_key IN OUT NOCOPY VARCHAR2
1381 , p_process_name IN VARCHAR2
1382 , p_change_id IN NUMBER := NULL
1383 , p_change_line_id IN NUMBER := NULL
1384 , p_wf_user_id IN NUMBER
1385 , p_host_url IN VARCHAR2 := NULL
1386 , p_action_id IN NUMBER := NULL
1387 , p_adhoc_party_list IN VARCHAR2 := NULL
1388 , p_route_id IN NUMBER := NULL
1389 , p_route_step_id IN NUMBER := NULL
1390 , p_parent_item_type IN VARCHAR2 := NULL
1391 , p_parent_item_key IN VARCHAR2 := NULL
1392 , p_debug IN VARCHAR2 := FND_API.G_FALSE
1393 , p_output_dir IN VARCHAR2 := NULL
1394 , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
1395 ) ;
1396
1397 -- API name : StartWorkflow
1398 -- Type : Public
1399 -- Pre-reqs : None.
1400 -- Function : Create and Start Workflow Process
1401 -- Parameters :
1402 -- IN : p_api_version IN NUMBER Required
1403 -- p_init_msg_list IN VARCHAR2 Optional
1404 -- Default = FND_API.G_FALSE
1405 -- p_commit IN VARCHAR2 Optional
1406 -- Default = FND_API.G_FALSE
1407 -- p_validation_level IN NUMBER Optional
1408 -- Default = FND_API.G_VALID_LEVEL_FULL
1409 -- Values:
1410 -- FND_API.G_VALID_LEVEL_NONE 0
1411 -- FND_API.G_VALID_LEVEL_FULL 100
1412 -- p_item_type IN VARCHAR2 Required
1413 -- Identifies workflow item type
1414 -- p_process_name IN VARCHAR2 Required
1415 -- Identifies workflow process name
1416 -- p_object_name IN VARCHAR2 Required
1417 -- Identifies Object Name
1418 -- p_object_id1 IN NUMBER Required
1419 -- Identifies Object
1420 -- p_object_id2 IN NUMBER Optional
1421 -- Identifies Object
1422 -- p_object_id3 IN NUMBER Optional
1423 -- Identifies Object
1424 -- p_object_id4 IN NUMBER Optional
1425 -- Identifies Object
1426 -- p_object_id5 IN NUMBER Optional
1427 -- Identifies Object
1428 -- p_parent_object_name IN VARCHAR2 Optional
1429 -- Identifies Parent Object Name
1430 -- p_parent_object_id1 IN NUMBER Optional
1431 -- Identifies Parent Object
1432 -- p_wf_user_id IN NUMBER Conditionally Required
1433 -- Identifies Workflow Owner
1434 -- p_host_url IN VARCHAR2 Optional
1435 -- Identifies Host URL for OA Page
1436 -- p_action_id IN NUMBER Optional
1437 -- Identifies Action for Workflow
1438 -- p_adhoc_party_list IN VARCHAR2 Optional
1439 -- Identifies paties being assigned to a task for Workflow
1440 -- e.g Comment Request wf process will send request ntf to them
1441 -- p_route_id IN NUMBER Optional
1442 -- Identifies Route for Approval Routing
1443 -- p_route_step_id IN NUMBER Optional
1444 -- Identifies Route Step for Approval Routing
1445 --
1446 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
1447 -- x_msg_count OUT NOCOPY NUMBER
1448 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1449 -- IN OUT :
1450 -- x_item_key IN OUT NOCOPY VARCHAR2
1451 -- Identifies workflow item key
1452 -- Version : Current version 1.0 Initial Creation
1453 -- Initial version 1.0
1454 --
1455 -- Notes : Note text
1456 --
1457 PROCEDURE StartWorkflow
1458 ( p_api_version IN NUMBER
1459 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1460 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1461 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1462 , x_return_status OUT NOCOPY VARCHAR2
1463 , x_msg_count OUT NOCOPY NUMBER
1464 , x_msg_data OUT NOCOPY VARCHAR2
1465 , p_item_type IN VARCHAR2
1466 , x_item_key IN OUT NOCOPY VARCHAR2
1467 , p_process_name IN VARCHAR2
1468 , p_object_name IN VARCHAR2
1469 , p_object_id1 IN NUMBER
1470 , p_object_id2 IN NUMBER := NULL
1471 , p_object_id3 IN NUMBER := NULL
1472 , p_object_id4 IN NUMBER := NULL
1473 , p_object_id5 IN NUMBER := NULL
1474 , p_parent_object_name IN VARCHAR2 := NULL
1475 , p_parent_object_id1 IN NUMBER := NULL
1476 , p_wf_user_id IN NUMBER
1477 , p_host_url IN VARCHAR2 := NULL
1478 , p_action_id IN NUMBER := NULL
1479 , p_adhoc_party_list IN VARCHAR2 := NULL
1480 , p_route_id IN NUMBER := NULL
1481 , p_route_step_id IN NUMBER := NULL
1482 , p_parent_item_type IN VARCHAR2 := NULL
1483 , p_parent_item_key IN VARCHAR2 := NULL
1484 , p_debug IN VARCHAR2 := FND_API.G_FALSE
1485 , p_output_dir IN VARCHAR2 := NULL
1486 , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
1487 ) ;
1488
1489
1490 -- API name : AbortWorkflow
1491 -- Type : Public
1492 -- Pre-reqs : None.
1493 -- Function : Abort Workflow Process
1494 -- Parameters :
1495 -- IN : p_api_version IN NUMBER Required
1496
1497 -- API name : AbortWorkflow
1498 -- Type : Public
1499 -- Pre-reqs : None.
1500 -- Function : Abort Workflow Process
1501 -- Parameters :
1502 -- IN : p_api_version IN NUMBER Required
1503 -- p_init_msg_list IN VARCHAR2 Optional
1504 -- Default = FND_API.G_FALSE
1505 -- p_commit IN VARCHAR2 Optional
1506 -- Default = FND_API.G_FALSE
1507 -- p_validation_level IN NUMBER Optional
1508 -- Default = FND_API.G_VALID_LEVEL_FULL
1509 -- Values:
1510 -- FND_API.G_VALID_LEVEL_NONE 0
1511 -- FND_API.G_VALID_LEVEL_FULL 100
1512 -- p_item_type IN VARCHAR2 Required
1513 -- Identifies workflow item type
1514 -- p_item_key IN VARCHAR2 Required
1515 -- Identifies workflow item key
1516 -- p_process_name IN VARCHAR2 Optional
1517 -- Identifies workflow process name
1518 -- p_wf_user_id IN NUMBER Required
1519 -- Identifies Workflow Owner
1520 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
1521 -- x_msg_count OUT NOCOPY NUMBER
1522 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1523 -- Version : Current version 1.0 Initial Creation
1524 -- Initial version 1.0
1525 --
1526 -- Notes : Note text
1527 --
1528 PROCEDURE AbortWorkflow
1529 ( p_api_version IN NUMBER
1530 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1531 , p_commit IN VARCHAR2 := FND_API.G_FALSE
1532 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1533 , x_return_status OUT NOCOPY VARCHAR2
1534 , x_msg_count OUT NOCOPY NUMBER
1535 , x_msg_data OUT NOCOPY VARCHAR2
1536 , p_item_type IN VARCHAR2
1537 , p_item_key IN VARCHAR2
1538 , p_process_name IN VARCHAR2 := NULL
1539 , p_wf_user_id IN NUMBER
1540 , p_debug IN VARCHAR2 := FND_API.G_FALSE
1541 , p_output_dir IN VARCHAR2 := NULL
1542 , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Abort.log'
1543 ) ;
1544
1545
1546
1547 END Eng_Workflow_Util ;