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_DISTRIBUTIONS_PKG dependencies on AR_DISTRIBUTIONS_S

Line 17: SELECT ar_distributions_s.nextval

13: IF PG_DEBUG in ('Y', 'C') THEN
14: arp_standard.debug( 'arp_distributions_pkg.insert_p()+' );
15: END IF;
16: --
17: SELECT ar_distributions_s.nextval
18: INTO l_line_id
19: FROM dual;
20: --
21: IF PG_DEBUG in ('Y', 'C') THEN

Line 181: UPDATE ar_distributions SET

177: IF PG_DEBUG in ('Y', 'C') THEN
178: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );
179: END IF;
180: --
181: UPDATE ar_distributions SET
182: source_id = p_dist_rec.source_id,
183: source_table = p_dist_rec.source_table,
184: source_type = p_dist_rec.source_type,
185: source_type_secondary = p_dist_rec.source_type_secondary,

Line 308: p_source_id IN ar_distributions.source_id%TYPE,

304: RAISE;
305: END fetch_p;
306: --
307: PROCEDURE fetch_pk(
308: p_source_id IN ar_distributions.source_id%TYPE,
309: p_source_table IN ar_distributions.source_table%TYPE,
310: p_source_type IN ar_distributions.source_type%TYPE,
311: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
312: BEGIN

Line 309: p_source_table IN ar_distributions.source_table%TYPE,

305: END fetch_p;
306: --
307: PROCEDURE fetch_pk(
308: p_source_id IN ar_distributions.source_id%TYPE,
309: p_source_table IN ar_distributions.source_table%TYPE,
310: p_source_type IN ar_distributions.source_type%TYPE,
311: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
312: BEGIN
313: IF PG_DEBUG in ('Y', 'C') THEN

Line 310: p_source_type IN ar_distributions.source_type%TYPE,

306: --
307: PROCEDURE fetch_pk(
308: p_source_id IN ar_distributions.source_id%TYPE,
309: p_source_table IN ar_distributions.source_table%TYPE,
310: p_source_type IN ar_distributions.source_type%TYPE,
311: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
312: BEGIN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );

Line 336: p_source_id IN ar_distributions.source_id%TYPE,

332: RAISE;
333: END fetch_pk;
334: --
335: PROCEDURE lock_fetch_pk(
336: p_source_id IN ar_distributions.source_id%TYPE,
337: p_source_table IN ar_distributions.source_table%TYPE,
338: p_source_type IN ar_distributions.source_type%TYPE,
339: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
340: BEGIN

Line 337: p_source_table IN ar_distributions.source_table%TYPE,

333: END fetch_pk;
334: --
335: PROCEDURE lock_fetch_pk(
336: p_source_id IN ar_distributions.source_id%TYPE,
337: p_source_table IN ar_distributions.source_table%TYPE,
338: p_source_type IN ar_distributions.source_type%TYPE,
339: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
340: BEGIN
341: IF PG_DEBUG in ('Y', 'C') THEN

Line 338: p_source_type IN ar_distributions.source_type%TYPE,

334: --
335: PROCEDURE lock_fetch_pk(
336: p_source_id IN ar_distributions.source_id%TYPE,
337: p_source_table IN ar_distributions.source_table%TYPE,
338: p_source_type IN ar_distributions.source_type%TYPE,
339: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
340: BEGIN
341: IF PG_DEBUG in ('Y', 'C') THEN
342: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );

Line 366: p_source_id IN ar_distributions.source_id%TYPE,

362: RAISE;
363: END lock_fetch_pk;
364: --
365: PROCEDURE nowaitlock_fetch_pk(
366: p_source_id IN ar_distributions.source_id%TYPE,
367: p_source_table IN ar_distributions.source_table%TYPE,
368: p_source_type IN ar_distributions.source_type%TYPE,
369: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
370: BEGIN

Line 367: p_source_table IN ar_distributions.source_table%TYPE,

363: END lock_fetch_pk;
364: --
365: PROCEDURE nowaitlock_fetch_pk(
366: p_source_id IN ar_distributions.source_id%TYPE,
367: p_source_table IN ar_distributions.source_table%TYPE,
368: p_source_type IN ar_distributions.source_type%TYPE,
369: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
370: BEGIN
371: IF PG_DEBUG in ('Y', 'C') THEN

Line 368: p_source_type IN ar_distributions.source_type%TYPE,

364: --
365: PROCEDURE nowaitlock_fetch_pk(
366: p_source_id IN ar_distributions.source_id%TYPE,
367: p_source_table IN ar_distributions.source_table%TYPE,
368: p_source_type IN ar_distributions.source_type%TYPE,
369: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
370: BEGIN
371: IF PG_DEBUG in ('Y', 'C') THEN
372: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );