[Home] [Help]
PACKAGE: APPS.DPP_APPROVAL_PVT
Source
1 PACKAGE DPP_APPROVAL_PVT AS
2 /* $Header: dppvapps.pls 120.4 2008/02/12 05:50:14 sdasan noship $ */
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 -- PROCEDURE
100 -- Add_Access
101 --
102 -- PURPOSE
103 -- adds approvers access to table
104 --
105 -- PARAMETERS
106 -- NOTES
107 ---------------------------------------------------------------------
108 PROCEDURE Add_Access(
109 p_api_version IN NUMBER
110 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
111 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
112 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
113
114 ,x_msg_data OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_return_status OUT NOCOPY VARCHAR2
117
118 ,p_approval_rec IN approval_rec_type
119 ,p_approvers IN approvers_tbl_type );
120 ---------------------------------------------------------------------
121 -- PROCEDURE
122 -- Revoke_Access
123 --
124 -- PURPOSE
125 -- Revokes access to current approvers
126 --
127 -- PARAMETERS
128 --
129 -- NOTES
130 ---------------------------------------------------------------------
131 PROCEDURE Revoke_Access (
132 p_api_version IN NUMBER
133 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140
141 ,p_object_type IN VARCHAR2
142 ,p_object_id IN NUMBER
143 );
144 ---------------------------------------------------------------------
145 -- PROCEDURE
146 -- Raise_Event
147 --
148 -- PURPOSE
149 -- Raise business event
150 --
151 -- PARAMETERS
152 --
153 -- NOTES
154 ---------------------------------------------------------------------
155 PROCEDURE Raise_Event (
156 x_return_status OUT NOCOPY VARCHAR2
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,p_event_name IN VARCHAR2
160 ,p_event_key IN VARCHAR2
161 ,p_approval_rec IN approval_rec_type);
162 ---------------------------------------------------------------------
163 -- PROCEDURE
164 -- Send_Notification
165 --
166 -- PURPOSE
167 -- Sends notifications to approvers
168 --
169 -- PARAMETERS
170 --
171 -- NOTES
172 ---------------------------------------------------------------------
173 PROCEDURE Send_Notification (
174 p_api_version IN NUMBER
175 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178
179 ,x_return_status OUT NOCOPY VARCHAR2
180 ,x_msg_data OUT NOCOPY VARCHAR2
181 ,x_msg_count OUT NOCOPY NUMBER
182
183 ,p_transaction_header_id IN NUMBER
184 ,p_msg_callback_api IN VARCHAR2
185 ,p_approval_rec IN approval_rec_type
186 );
187 ---------------------------------------------------------------------
188 -- PROCEDURE
189 -- Process_User_Action
190
191 --
192 -- PURPOSE
193 -- Handles the approvals and rejections of objects
194 --
195 -- PARAMETERS
196 --
197 -- NOTES
198 -- 1. object_version_number will be set to 1.
199 ---------------------------------------------------------------------
200 PROCEDURE Process_User_Action (
201 p_api_version IN NUMBER
202 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
203 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_data OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209
210 ,p_approval_rec IN approval_rec_type
211 ,p_approver_id IN NUMBER
212 ,x_final_approval_flag OUT NOCOPY VARCHAR2
213 );
214 ---------------------------------------------------------------------
215 END DPP_APPROVAL_PVT;