[Home] [Help]
PACKAGE BODY: APPS.ARP_AA_HISTORY_PKG
Source
4 /*===========================================================================+
1 PACKAGE BODY ARP_AA_HISTORY_PKG AS
2 /* $Header: ARCIAAHB.pls 120.5 2005/10/30 04:14:16 appldev ship $*/
3 --
5 | PROCEDURE |
6 | insert_p |
7 | |
8 | DESCRIPTION |
9 | This function inserts a row into AR_APPROVAL_ACTION_HISTORY table |
10 | |
11 | SCOPE - PUBLIC |
12 | |
13 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
14 | |
15 | ARGUMENTS : IN: |
16 | p_aah_rec - approval_action_history record structure |
17 | OUT: |
18 | p_adj_id - approval_action_history id of inserted row |
19 | |
20 | RETURNS : NONE |
21 | |
22 | NOTES |
23 | |
24 | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
25 | |
26 +===========================================================================*/
27 PROCEDURE insert_p( p_aah_rec IN ar_approval_action_history%ROWTYPE,
28 p_aah_id OUT NOCOPY ar_approval_action_history.approval_action_history_id%TYPE) IS
29 l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;
30 BEGIN
31 arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.insert_p' );
32 --
33 SELECT ar_approval_action_history_s.nextval
34 INTO l_aah_id
35 FROM dual;
36
37 --
38 INSERT INTO ar_approval_action_history (
39 approval_action_history_id,
40 created_by,
41 creation_date,
42 last_updated_by,
43 last_update_date,
44 last_update_login,
45 action_name,
46 adjustment_id,
47 action_date,
48 comments,
49 attribute_category,
50 attribute1,
51 attribute2,
52 attribute3,
53 attribute4,
54 attribute5,
55 attribute6,
56 attribute7,
57 attribute8,
58 attribute9,
59 attribute10,
60 attribute11,
61 attribute12,
62 attribute13,
63 attribute14,
64 attribute15
65 )
66 VALUES ( l_aah_id,
67 arp_standard.profile.user_id,
68 SYSDATE,
69 arp_standard.profile.user_id,
70 SYSDATE,
71 NVL( arp_standard.profile.last_update_login,
72 p_aah_rec.last_update_login ),
73 p_aah_rec.action_name,
74 p_aah_rec.adjustment_id,
75 p_aah_rec.action_date,
76 p_aah_rec.comments,
77 p_aah_rec.attribute_category,
78 p_aah_rec.attribute1,
79 p_aah_rec.attribute2,
80 p_aah_rec.attribute3,
81 p_aah_rec.attribute4,
82 p_aah_rec.attribute5,
83 p_aah_rec.attribute6,
84 p_aah_rec.attribute7,
85 p_aah_rec.attribute8,
86 p_aah_rec.attribute9,
87 p_aah_rec.attribute10,
88 p_aah_rec.attribute11,
89 p_aah_rec.attribute12,
90 p_aah_rec.attribute13,
91 p_aah_rec.attribute14,
92 p_aah_rec.attribute15
93 );
94 p_aah_id := l_aah_id;
95 --
96 arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.insert_p' );
97 EXCEPTION
98 WHEN OTHERS THEN
99 arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.insert_p' );
100 RAISE;
101 END;
102 --
103 /*===========================================================================+
104 | PROCEDURE |
105 | update_p |
109 | |
106 | |
107 | DESCRIPTION |
108 | This function updates a row into AR_APPROVAL_ACTION_HISTORY table |
110 | SCOPE - PUBLIC |
111 | |
112 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
113 | |
114 | ARGUMENTS : IN: |
115 | p_aah_rec - approval action history record structure |
116 | |
117 | RETURNS : NONE |
118 | |
119 | NOTES |
120 | |
121 | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
122 | |
123 +===========================================================================*/
124 PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%ROWTYPE ) IS
125 BEGIN
126 arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.update_p' );
127 --
128 UPDATE ar_approval_action_history SET
129 approval_action_history_id =
130 p_aah_rec.approval_action_history_id,
131 last_updated_by = arp_standard.profile.user_id,
132 last_update_date = SYSDATE,
133 last_update_login =
134 NVL( arp_standard.profile.last_update_login,
135 p_aah_rec.last_update_login ),
136 action_name = p_aah_rec.action_name,
137 adjustment_id = p_aah_rec.adjustment_id,
138 action_date = p_aah_rec.action_date,
139 comments = p_aah_rec.comments,
140 attribute_category = p_aah_rec.attribute_category,
141 attribute1 = p_aah_rec.attribute1,
142 attribute2 = p_aah_rec.attribute2,
143 attribute3 = p_aah_rec.attribute3,
144 attribute4 = p_aah_rec.attribute4,
145 attribute5 = p_aah_rec.attribute5,
146 attribute6 = p_aah_rec.attribute6,
147 attribute7 = p_aah_rec.attribute7,
148 attribute8 = p_aah_rec.attribute8,
149 attribute9 = p_aah_rec.attribute9,
150 attribute10 = p_aah_rec.attribute10,
151 attribute11 = p_aah_rec.attribute11,
152 attribute12 = p_aah_rec.attribute12,
153 attribute13 = p_aah_rec.attribute13,
154 attribute14 = p_aah_rec.attribute14,
155 attribute15 = p_aah_rec.attribute15
156 WHERE approval_action_history_id = p_aah_rec.approval_action_history_id;
157 --
158 arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.update_p' );
159 EXCEPTION
160 WHEN OTHERS THEN
161 arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.update_p' );
162 RAISE;
163 END;
164 --
165 /*===========================================================================+
166 | PROCEDURE |
167 | delete_p |
168 | |
169 | DESCRIPTION |
170 | This function deletes a row from AR_APPROVAL_ACTION_HISTORY table |
171 | |
172 | SCOPE - PUBLIC |
173 | |
174 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
175 | |
176 | ARGUMENTS : IN: |
177 | p_aah_id - approval action history id |
178 | |
179 | RETURNS : NONE |
180 | |
181 | NOTES |
182 | |
183 | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
184 | |
185 +===========================================================================*/
186 PROCEDURE delete_p(
187 p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS
188 BEGIN
189 arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.delete_p' );
190 DELETE FROM ar_approval_action_history
191 WHERE approval_action_history_id = p_aah_id;
192 --
193 arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.delete_p' );
194 EXCEPTION
195 WHEN OTHERS THEN
196 arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.delete_p' );
197 RAISE;
198 END;
199 --
200 /*===========================================================================+
201 | PROCEDURE |
202 | fetch_p |
203 | |
204 | DESCRIPTION |
205 | This function fetches a row from AR_APPROVAL_ACTION_HISTORY table |
206 | |
210 | |
207 | SCOPE - PUBLIC |
208 | |
209 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
211 | ARGUMENTS : IN: |
212 | p_aah_id - approval action history id |
213 | OUT: |
214 | p_aah_rec - approval action history record structure |
215 | |
216 | RETURNS : NONE |
217 | |
218 | NOTES |
219 | |
220 | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
221 | |
222 +===========================================================================*/
223 PROCEDURE fetch_p(
224 p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE,
225 p_aah_rec OUT NOCOPY ar_approval_action_history%ROWTYPE ) IS
226 BEGIN
227 arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.fetch_p' );
228 SELECT *
229 INTO p_aah_rec
230 FROM ar_approval_action_history
231 WHERE approval_action_history_id = p_aah_id;
232 arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.fetch_p' );
233 --
234 EXCEPTION
235 WHEN OTHERS THEN
236 arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.fetch_p' );
237 RAISE;
238 END;
239 --
240 /*===========================================================================+
241 | PROCEDURE |
242 | lock_p |
243 | |
244 | DESCRIPTION |
245 | This function locks a row in AR_APPROVAL_ACTION_HISTORY table |
246 | |
247 | SCOPE - PUBLIC |
248 | |
249 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
250 | |
251 | ARGUMENTS : IN: |
252 | p_aah_id - approval action history id of row to be |
253 | locked in AR_APPROVAL_ACTION_HISTORY table |
254 | |
255 | RETURNS : NONE |
256 | |
257 | NOTES |
258 | |
259 | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
260 | 24-Jun-1999 J.Gazmen-Dabir Bug 911364, modified update as STATUS |
261 | column does not exist in table. |
262 | |
263 +===========================================================================*/
264 PROCEDURE lock_p(
265 p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS
266 l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;
267 BEGIN
268 arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.lock_p' );
269 SELECT approval_action_history_id
270 INTO l_aah_id
271 FROM ar_approval_action_history
272 WHERE approval_action_history_id = p_aah_id
273 FOR UPDATE OF ACTION_NAME NOWAIT;
274 --
275 arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.lock_p' );
276 EXCEPTION
277 WHEN OTHERS THEN
278 arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.lock_p' );
279 RAISE;
280 END;
281
282 END ARP_AA_HISTORY_PKG;
283 --