eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AA_HISTORY_PKG dependencies on AR_APPROVAL_ACTION_HISTORY

Line 9: | This function inserts a row into AR_APPROVAL_ACTION_HISTORY table |

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 |

Line 27: PROCEDURE insert_p( p_aah_rec IN ar_approval_action_history%ROWTYPE,

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' );

Line 28: p_aah_id OUT NOCOPY ar_approval_action_history.approval_action_history_id%TYPE) IS

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: --

Line 29: l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;

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

Line 33: SELECT ar_approval_action_history_s.nextval

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: --

Line 38: INSERT INTO ar_approval_action_history (

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,

Line 108: | This function updates a row into AR_APPROVAL_ACTION_HISTORY table |

104: | PROCEDURE |
105: | update_p |
106: | |
107: | DESCRIPTION |
108: | This function updates a row into AR_APPROVAL_ACTION_HISTORY table |
109: | |
110: | SCOPE - PUBLIC |
111: | |
112: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 124: PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%ROWTYPE ) IS

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

Line 128: UPDATE ar_approval_action_history SET

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,

Line 170: | This function deletes a row from AR_APPROVAL_ACTION_HISTORY table |

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 |

Line 187: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS

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;

Line 190: DELETE FROM ar_approval_action_history

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

Line 205: | This function fetches a row from AR_APPROVAL_ACTION_HISTORY table |

201: | PROCEDURE |
202: | fetch_p |
203: | |
204: | DESCRIPTION |
205: | This function fetches a row from AR_APPROVAL_ACTION_HISTORY table |
206: | |
207: | SCOPE - PUBLIC |
208: | |
209: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 224: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE,

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 *

Line 225: p_aah_rec OUT NOCOPY ar_approval_action_history%ROWTYPE ) IS

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

Line 230: FROM ar_approval_action_history

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

Line 245: | This function locks a row in AR_APPROVAL_ACTION_HISTORY table |

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 |

Line 253: | locked in AR_APPROVAL_ACTION_HISTORY table |

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 |

Line 265: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS

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

Line 266: l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;

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

Line 271: FROM ar_approval_action_history

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' );