[Home] [Help]
PACKAGE: APPS.DPP_APPROVAL_PVT
Source
1 PACKAGE DPP_APPROVAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvapps.pls 120.4.12010000.2 2009/10/27 11:22:49 rvkondur ship $ */
3
4 TYPE approval_rec_type IS RECORD (
5 OBJECT_TYPE VARCHAR2(30)
6 ,OBJECT_ID NUMBER
7 ,STATUS_CODE VARCHAR2(30)
8 ,ACTION_CODE VARCHAR2(30)
9 ,ACTION_PERFORMED_BY NUMBER -- fnd user_id
10 );
11
12 TYPE approvers_rec_type IS RECORD (
13 APPROVER_TYPE VARCHAR2(30) -- USER
14 ,APPROVER_ID NUMBER -- fnd user_id
15 ,APPROVER_LEVEL NUMBER
16 );
17
18 TYPE approvers_tbl_type is TABLE OF approvers_rec_type;
19
20 TYPE approverRecord is record(
21 user_id number,
22 person_id number,
23 first_name varchar2(150),
24 last_name varchar2(150),
25 api_insertion varchar2(1),
26 authority varchar2(1),
27 approval_status varchar2(50),
28 approval_type_id number,
29 group_or_chain_id number,
30 occurrence number,
31 source varchar2(500),
32 approver_sequence number,
33 approver_email varchar2(240),
34 approver_group_name varchar2(50)
35 );
36
37 TYPE approversTable is table of approverRecord index by binary_integer;
38 ---------------------------------------------------------------------
39 -- PROCEDURE
40 -- Update_User_Action
41 --
42 -- PURPOSE
43 -- PARAMETERS
44 -- NOTES
45 ---------------------------------------------------------------------
46 PROCEDURE Update_User_Action(
47 p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
49 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
50
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54
55 ,p_approval_rec IN approval_rec_type
56 );
57 ---------------------------------------------------------------------
58 -- PROCEDURE
59 -- Get_Approvers
60 --
61 -- PURPOSE
62 -- PARAMETERS
63 -- NOTES
64 ---------------------------------------------------------------------
65 PROCEDURE Get_Approvers(
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73
74 ,p_approval_rec IN approval_rec_type
75 ,x_approvers OUT NOCOPY approvers_tbl_type
76 ,x_final_approval_flag OUT NOCOPY VARCHAR2
77 );
78 ---------------------------------------------------------------------
79 -- PROCEDURE
80 -- Get_AllApprovers
81 --
82 -- PURPOSE
83 -- PARAMETERS
84 -- NOTES
85 ---------------------------------------------------------------------
86 PROCEDURE Get_AllApprovers(
87 p_api_version IN NUMBER
88 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
89 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
90
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94
95 ,p_approval_rec IN approval_rec_type
96 ,p_approversOut OUT NOCOPY approversTable
97 );
98
99 ---------------------------------------------------------------------
100 -- PROCEDURE
101 -- Clear_All_Approvals
102 --
103 -- PURPOSE
104 -- Clears all the approvals
105 --
106 -- PARAMETERS
107 -- NOTES
108 ---------------------------------------------------------------------
109 PROCEDURE Clear_All_Approvals (
110 p_api_version IN NUMBER
111 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
112 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
114
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2
118
119 ,p_txn_hdr_id IN NUMBER
120 );
121
122 ---------------------------------------------------------------------
123 -- PROCEDURE
124 -- Add_Access
125 --
126 -- PURPOSE
127 -- adds approvers access to table
128 --
129 -- PARAMETERS
130 -- NOTES
131 ---------------------------------------------------------------------
132 PROCEDURE Add_Access(
133 p_api_version IN NUMBER
134 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
135 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
136 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
137
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_return_status OUT NOCOPY VARCHAR2
141
142 ,p_approval_rec IN approval_rec_type
143 ,p_approvers IN approvers_tbl_type );
144 ---------------------------------------------------------------------
145 -- PROCEDURE
146 -- Revoke_Access
147 --
148 -- PURPOSE
149 -- Revokes access to current approvers
150 --
151 -- PARAMETERS
152 --
153 -- NOTES
154 ---------------------------------------------------------------------
155 PROCEDURE Revoke_Access (
156 p_api_version IN NUMBER
157 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160
161 ,x_return_status OUT NOCOPY VARCHAR2
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164
165 ,p_object_type IN VARCHAR2
166 ,p_object_id IN NUMBER
167 );
168 ---------------------------------------------------------------------
169 -- PROCEDURE
170 -- Raise_Event
171 --
172 -- PURPOSE
173 -- Raise business event
174 --
175 -- PARAMETERS
176 --
177 -- NOTES
178 ---------------------------------------------------------------------
179 PROCEDURE Raise_Event (
180 x_return_status OUT NOCOPY VARCHAR2
181 ,x_msg_data OUT NOCOPY VARCHAR2
182 ,x_msg_count OUT NOCOPY NUMBER
183 ,p_event_name IN VARCHAR2
184 ,p_event_key IN VARCHAR2
185 ,p_approval_rec IN approval_rec_type);
186 ---------------------------------------------------------------------
187 -- PROCEDURE
188 -- Send_Notification
189 --
190 -- PURPOSE
191 -- Sends notifications to approvers
192 --
193 -- PARAMETERS
194 --
195 -- NOTES
196 ---------------------------------------------------------------------
197 PROCEDURE Send_Notification (
198 p_api_version IN NUMBER
199 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
202
203 ,x_return_status OUT NOCOPY VARCHAR2
204 ,x_msg_data OUT NOCOPY VARCHAR2
205 ,x_msg_count OUT NOCOPY NUMBER
206
207 ,p_transaction_header_id IN NUMBER
208 ,p_msg_callback_api IN VARCHAR2
209 ,p_approval_rec IN approval_rec_type
210 );
211 ---------------------------------------------------------------------
212 -- PROCEDURE
213 -- Process_User_Action
214
215 --
216 -- PURPOSE
217 -- Handles the approvals and rejections of objects
218 --
219 -- PARAMETERS
220 --
221 -- NOTES
222 -- 1. object_version_number will be set to 1.
223 ---------------------------------------------------------------------
224 PROCEDURE Process_User_Action (
225 p_api_version IN NUMBER
226 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
227 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
228 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
229
230 ,x_return_status OUT NOCOPY VARCHAR2
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 ,x_msg_count OUT NOCOPY NUMBER
233
234 ,p_approval_rec IN approval_rec_type
235 ,p_approver_id IN NUMBER
236 ,x_final_approval_flag OUT NOCOPY VARCHAR2
237 );
238 ---------------------------------------------------------------------
239 END DPP_APPROVAL_PVT;