1 PACKAGE okl_vp_oa_wf AS
2 /* $Header: OKLROAWS.pls 120.0 2005/07/28 11:45:57 sjalasut noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_OA_WF';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
9
10 -------------------------------------------------------------------------------
11 -- PROCEDURE raise_oa_event_approval
12 -------------------------------------------------------------------------------
13 -- Start of comments
14 --
15 -- Procedure Name : raise_oa_event_approval
16 -- Description : procedure raises business event for operating agreement approval
17 -- : business event name oracle.apps.okl.la.vp.approve_operating_agreement
18 -- Parameters : IN p_chr_id agreement id
19 -- Version : 1.0
20 -- History : May 18, 05 SJALASUT created
21 -- End of comments
22 PROCEDURE raise_oa_event_approval(p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_chr_id IN okc_k_headers_b.id%TYPE
28 );
29 -------------------------------------------------------------------------------
30 -- PROCEDURE check_approval_process
31 -------------------------------------------------------------------------------
32 -- Start of comments
33 --
34 -- Procedure Name : check_approval_process
35 -- Description : procedure that checks the approval configured in the profile
36 -- : OKL: Operating Agreement Approval Process
37 -- Parameters : default wf parameters
38 -- Version : 1.0
39 -- History : May 18, 05 SJALASUT created
40 -- End of comments
41 PROCEDURE check_approval_process(itemtype IN VARCHAR2
42 ,itemkey IN VARCHAR2
43 ,actid IN NUMBER
44 ,funcmode IN VARCHAR2
45 ,resultout OUT NOCOPY VARCHAR2);
46
47 -------------------------------------------------------------------------------
48 -- PROCEDURE get_agrmnt_approver
49 -------------------------------------------------------------------------------
50 -- Start of comments
51 --
52 -- Procedure Name : get_agrmnt_approver
53 -- Description : procedure that gets the approver for workflow based approval
54 -- : the logic first finds if requester has a role to send,
55 -- if not found, the requisition goes to sysadmin
56 -- Parameters : default wf parameters
57 -- Version : 1.0
58 -- History : May 18, 05 SJALASUT created
59 -- End of comments
60 PROCEDURE get_agrmnt_approver(itemtype IN VARCHAR2
61 ,itemkey IN VARCHAR2
62 ,actid IN NUMBER
63 ,funcmode IN VARCHAR2
64 ,resultout OUT NOCOPY VARCHAR2);
65
66 -------------------------------------------------------------------------------
67 -- PROCEDURE get_msg_doc
68 -------------------------------------------------------------------------------
69 -- Start of comments
70 --
71 -- Procedure Name : get_msg_doc
72 -- Description : get_msg_doc constructs a sample summary of information that is
73 -- : displayed in the notification for approval, rejection and approved
74 -- operating agreements
75 -- Parameters : default wf parameters
76 -- Version : 1.0
77 -- History : May 18, 05 SJALASUT created
78 -- End of comments
79 PROCEDURE get_msg_doc(document_id IN VARCHAR2
80 ,display_type IN VARCHAR2
81 ,document IN OUT nocopy VARCHAR2
82 ,document_type IN OUT nocopy VARCHAR2
83 );
84
85 -------------------------------------------------------------------------------
86 -- PROCEDURE update_agrmnt_status
87 -------------------------------------------------------------------------------
88 -- Start of comments
89 --
90 -- Procedure Name : update_agrmnt_status
91 -- Description : updates agreement status based on the approval outcome
92 -- via workflow or AME
93 -- Parameters : default wf parameters
94 -- Version : 1.0
95 -- History : May 18, 05 SJALASUT created
96 -- End of comments
97 PROCEDURE update_agrmnt_status(itemtype IN VARCHAR2
98 ,itemkey IN VARCHAR2
99 ,actid IN NUMBER
100 ,funcmode IN VARCHAR2
101 ,resultout OUT NOCOPY VARCHAR2);
102
103 -------------------------------------------------------------------------------
104 -- PROCEDURE process_oa_for_ame
105 -------------------------------------------------------------------------------
106 -- Start of comments
107 --
108 -- Procedure Name : process_oa_for_ame
109 -- Description : procedure that sets the message subjects, transaction context
110 -- : for Oracle Approvals Managment to handle the operating agreement
111 -- approval process
112 -- Parameters : default wf parameters
113 -- Version : 1.0
114 -- History : May 18, 05 SJALASUT created
115 -- End of comments
116 PROCEDURE process_oa_for_ame(itemtype IN VARCHAR2
117 ,itemkey IN VARCHAR2
118 ,actid IN NUMBER
119 ,funcmode IN VARCHAR2
120 ,resultout OUT NOCOPY VARCHAR2);
121
122 -------------------------------------------------------------------------------
123 -- PROCEDURE set_msg_attributes
124 -------------------------------------------------------------------------------
125 -- Start of comments
126 --
127 -- Procedure Name : set_msg_attributes
128 -- Description : set_msg_attributes sets the notification contents based on the
129 -- : outcome of the approval process via workflow
130 -- Parameters : default wf parameters
131 -- Version : 1.0
132 -- History : May 18, 05 SJALASUT created
133 -- End of comments
134 PROCEDURE set_msg_attributes(itemtype IN VARCHAR2
135 ,itemkey IN VARCHAR2
136 ,actid IN NUMBER
137 ,funcmode IN VARCHAR2
138 ,resultout OUT NOCOPY VARCHAR2);
139 END okl_vp_oa_wf;