[Home] [Help]
PACKAGE: APPS.EAM_CLEARANCE_WORKFLOW_PVT
Source
1 PACKAGE EAM_CLEARANCE_WORKFLOW_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWCWS.pls 120.0 2011/02/23 13:57:26 vboddapa noship $ */
3
4 /***************************************************************************
5 --
6 -- Copyright (c) 2009 Oracle Corporation, Redwood Shores, CA, USA
7 -- All rights reserved.
8 --
9 -- FILENAME: EAMVWCWS.pls
10 --
11 -- DESCRIPTION: Spec of package EAM_CLEARANCE_WORKFLOW_PVT
12 --
13 -- NOTES
14 --
15 -- HISTORY
16 --
17 -- 10-FEB-2011 Venkateswarlu Boddapati Initial Creation
18 ***************************************************************************/
19
20 /********************************************************************
21 * Procedure : Launch_Workflow
22 * Purpose : Function called from subscription .This will in turn launch the workflow
23 *********************************************************************/
24 function Launch_Workflow
25 ( p_subscription_guid in raw
26 , p_event in out NOCOPY wf_event_t
27 ) return varchar2;
28
29
30
31 /********************************************************************
32 * Procedure : Update_Status_Approved
33 * Purpose : Procedure called from Work Clearance Release Approval when the workflow is approved
34 *********************************************************************/
35 PROCEDURE Update_Status_Approved
36 ( itemtype in varchar2
37 , itemkey in varchar2
38 , actid in number
39 , funcmode in varchar2
40 , resultout out NOCOPY varchar2
41 );
42
43
44
45 /********************************************************************
46 * Procedure : Update_Status_Rejected
47 * Purpose : Procedure called from Work Clearance Release Approval when the workflow is Rejected
48 *********************************************************************/
49 PROCEDURE Update_Status_Rejected
50 ( itemtype in varchar2
51 , itemkey in varchar2
52 , actid in number
53 , funcmode in varchar2
54 , resultout out NOCOPY varchar2
55 );
56
57
58
59 /********************************************************************
60 * Procedure : Get_Next_Approver
61 * Purpose : Procedure called from Work Clearance Release Approval to
62 find the next approver
63 *********************************************************************/
64 procedure Get_Next_Approver
65 ( itemtype in varchar2
66 , itemkey in varchar2
67 , actid in number
68 , funcmode in varchar2
69 , resultout out NOCOPY varchar2
70 ) ;
71
72
73
74 /********************************************************************
75 * Procedure : Update_AME_With_Response
76 * Purpose : Procedure called from Clearance Release Approval when an approver
77 responds to a notification
78 *********************************************************************/
79 procedure Update_AME_With_Response
80 (itemtype in varchar2
81 , itemkey in varchar2
82 , actid in number
83 , funcmode in varchar2
84 , resultout out NOCOPY varchar2);
85
86
87
88 /********************************************************************
89 * Procedure : Is_Approval_Required_Released
90 * Purpose : This procedure will check if the approval is required for
91 the work Clearance release
92 *********************************************************************/
93 PROCEDURE Is_Approval_Required_Released
94 ( p_old_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
95 , p_new_clearance_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
96 , x_approval_required OUT NOCOPY BOOLEAN
97 , x_workflow_name OUT NOCOPY VARCHAR2
98 , x_workflow_process OUT NOCOPY VARCHAR2
99 );
100
101
102 END EAM_CLEARANCE_WORKFLOW_PVT;