DBA Data[Home] [Help]

APPS.ARP_ADJ_PKG dependencies on ARP_ADJ_PKG

Line 1: PACKAGE BODY ARP_ADJ_PKG AS

1: PACKAGE BODY ARP_ADJ_PKG AS
2: /* $Header: ARCIADJB.pls 120.7 2006/03/03 22:54:27 hyu ship $*/
3: --
4: /*===========================================================================+
5: | PROCEDURE |

Line 47: arp_standard.debug( '>>>>>>>> arp_adj_pkg.insert_p' );

43: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%ROWTYPE,
44: p_adj_id OUT NOCOPY ar_adjustments.adjustment_id%TYPE ) IS
45: l_adj_id ar_adjustments.adjustment_id%TYPE;
46: BEGIN
47: arp_standard.debug( '>>>>>>>> arp_adj_pkg.insert_p' );
48: --
49: SELECT ar_adjustments_s.nextval
50: INTO l_adj_id
51: FROM dual;

Line 211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );

207: -- p_mode => 'SINGLE',
208: -- p_key_value => l_adj_id);
209: --}
210: p_adj_id := l_adj_id;
211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );
212: EXCEPTION
213: WHEN OTHERS THEN
214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );
215: RAISE;

Line 214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );

210: p_adj_id := l_adj_id;
211: arp_standard.debug( '<<<<<<<< arp_adj_pkg.insert_p' );
212: EXCEPTION
213: WHEN OTHERS THEN
214: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.insert_p' );
215: RAISE;
216: END;
217: --
218: /*===========================================================================+

Line 250: arp_standard.debug( '>>>>>>>> arp_adj_pkg.update_p' );

246: | cons_inv_id into the table handlers. |
247: +===========================================================================*/
248: PROCEDURE update_p( p_adj_rec IN AR_ADJUSTMENTS%ROWTYPE ) IS
249: BEGIN
250: arp_standard.debug( '>>>>>>>> arp_adj_pkg.update_p' );
251: --
252: UPDATE ar_adjustments SET
253: acctd_amount = p_adj_rec.acctd_amount,
254: adjustment_type = p_adj_rec.adjustment_type,

Line 347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );

343: -- p_key_value => p_adj_rec.adjustment_id
344: -- );
345: --}
346: --
347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );
348: EXCEPTION
349: WHEN OTHERS THEN
350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );
351: RAISE;

Line 350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );

346: --
347: arp_standard.debug( '<<<<<<<< arp_adj_pkg.update_p' );
348: EXCEPTION
349: WHEN OTHERS THEN
350: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.update_p' );
351: RAISE;
352: END;
353: --
354: /*===========================================================================+

Line 378: arp_standard.debug( '>>>>>>>> arp_adj_pkg.delete_p' );

374: | |
375: +===========================================================================*/
376: PROCEDURE delete_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS
377: BEGIN
378: arp_standard.debug( '>>>>>>>> arp_adj_pkg.delete_p' );
379: --
380: DELETE FROM ar_adjustments
381: WHERE adjustment_id = p_adj_id;
382:

Line 395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );

391: -- p_mode => 'SINGLE',
392: -- p_key_value => p_adj_id);
393: --}
394: --
395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );
396: EXCEPTION
397: WHEN OTHERS THEN
398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );
399: RAISE;

Line 398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );

394: --
395: arp_standard.debug( '<<<<<<<< arp_adj_pkg.delete_p' );
396: EXCEPTION
397: WHEN OTHERS THEN
398: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.delete_p' );
399: RAISE;
400: END;
401: --
402: /*===========================================================================+

Line 427: arp_standard.debug( '>>>>>>>> arp_adj_pkg.lock_p' );

423: +===========================================================================*/
424: PROCEDURE lock_p( p_adj_id IN AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE ) IS
425: l_adj_id AR_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
426: BEGIN
427: arp_standard.debug( '>>>>>>>> arp_adj_pkg.lock_p' );
428: --
429: SELECT adjustment_id
430: INTO l_adj_id
431: FROM ar_adjustments

Line 435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );

431: FROM ar_adjustments
432: WHERE adjustment_id = p_adj_id
433: FOR UPDATE OF STATUS NOWAIT;
434: --
435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );
436: EXCEPTION
437: WHEN OTHERS THEN
438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );
439: RAISE;

Line 438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );

434: --
435: arp_standard.debug( '<<<<<<<< arp_adj_pkg.lock_p' );
436: EXCEPTION
437: WHEN OTHERS THEN
438: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.lock_p' );
439: RAISE;
440: END;
441: --
442: /*===========================================================================+

Line 469: arp_standard.debug( '>>>>>>>> arp_adj_pkg.fetch_p' );

465: +===========================================================================*/
466: PROCEDURE fetch_p( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
467: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ) IS
468: BEGIN
469: arp_standard.debug( '>>>>>>>> arp_adj_pkg.fetch_p' );
470: --
471: SELECT *
472: INTO p_adj_rec
473: FROM ar_adjustments

Line 476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );

472: INTO p_adj_rec
473: FROM ar_adjustments
474: WHERE adjustment_id = p_adj_id;
475: --
476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );
480: RAISE;

Line 479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );

475: --
476: arp_standard.debug( '<<<<<<<< arp_adj_pkg.fetch_p' );
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );
480: RAISE;
481: END;
482: --
483: END ARP_ADJ_PKG;

Line 483: END ARP_ADJ_PKG;

479: arp_standard.debug( 'EXCEPTION: arp_adj_pkg.fetch_p' );
480: RAISE;
481: END;
482: --
483: END ARP_ADJ_PKG;
484: --