DBA Data[Home] [Help]

APPS.ARP_RATE_ADJUSTMENTS_PKG dependencies on AR_RATE_ADJUSTMENTS

Line 8: p_radj_rec IN ar_rate_adjustments%ROWTYPE,

4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: PROCEDURE insert_p(
8: p_radj_rec IN ar_rate_adjustments%ROWTYPE,
9: p_radj_id OUT NOCOPY ar_rate_adjustments.rate_adjustment_id%TYPE ) IS
10: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
11: BEGIN
12: IF PG_DEBUG in ('Y', 'C') THEN

Line 9: p_radj_id OUT NOCOPY ar_rate_adjustments.rate_adjustment_id%TYPE ) IS

5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: PROCEDURE insert_p(
8: p_radj_rec IN ar_rate_adjustments%ROWTYPE,
9: p_radj_id OUT NOCOPY ar_rate_adjustments.rate_adjustment_id%TYPE ) IS
10: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
11: BEGIN
12: IF PG_DEBUG in ('Y', 'C') THEN
13: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );

Line 10: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;

6:
7: PROCEDURE insert_p(
8: p_radj_rec IN ar_rate_adjustments%ROWTYPE,
9: p_radj_id OUT NOCOPY ar_rate_adjustments.rate_adjustment_id%TYPE ) IS
10: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
11: BEGIN
12: IF PG_DEBUG in ('Y', 'C') THEN
13: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );
14: END IF;

Line 16: SELECT AR_RATE_ADJUSTMENTS_s.nextval

12: IF PG_DEBUG in ('Y', 'C') THEN
13: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );
14: END IF;
15: --
16: SELECT AR_RATE_ADJUSTMENTS_s.nextval
17: INTO l_radj_id
18: FROM dual;
19: --
20: INSERT INTO AR_RATE_ADJUSTMENTS (

Line 20: INSERT INTO AR_RATE_ADJUSTMENTS (

16: SELECT AR_RATE_ADJUSTMENTS_s.nextval
17: INTO l_radj_id
18: FROM dual;
19: --
20: INSERT INTO AR_RATE_ADJUSTMENTS (
21: rate_adjustment_id,
22: cash_receipt_id,
23: gain_loss,
24: gl_date,

Line 116: p_table_name => 'AR_RATE_ADJUSTMENTS',

112: +---------------------------------*/
113:
114: ar_mrc_engine.maintain_mrc_data(
115: p_event_mode => 'INSERT',
116: p_table_name => 'AR_RATE_ADJUSTMENTS',
117: p_mode => 'SINGLE',
118: p_key_value => l_radj_id
119: );
120: