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_MISC_CASH_DIST_PKG dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 6: PROCEDURE insert_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE,

2: /*$Header: ARRIMCDB.pls 120.7 2006/06/09 16:25:49 hyu ship $*/
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE insert_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE,
7: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
8: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
9:
10: --5201086

Line 7: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS

3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE insert_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE,
7: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
8: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
9:
10: --5201086
11: CURSOR cu_crh(p_cr_id IN NUMBER) IS

Line 8: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE insert_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE,
7: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
8: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
9:
10: --5201086
11: CURSOR cu_crh(p_cr_id IN NUMBER) IS
12: SELECT cash_receipt_history_id

Line 24: SELECT ar_misc_cash_distributions_s.nextval

20: IF PG_DEBUG in ('Y', 'C') THEN
21: arp_standard.debug( 'arp_misc_cash_dist_pkg.insert_p()+' );
22: END IF;
23:
24: SELECT ar_misc_cash_distributions_s.nextval
25: INTO l_mcd_id
26: FROM dual;
27:
28: --5201086

Line 40: INSERT INTO ar_misc_cash_distributions (

36: l_crh_id := p_mcd_rec.cash_receipt_history_id;
37: END IF;
38:
39:
40: INSERT INTO ar_misc_cash_distributions (
41: misc_cash_distribution_id,
42: cash_receipt_id,
43: code_combination_id,
44: set_of_books_id,

Line 145: arp_standard.debug( 'after insert into ar_misc_cash_distributions');

141: arp_standard.debug( 'amount= ' || to_char(p_mcd_rec.amount));
142: arp_standard.debug( 'set_of_books id= ' || to_char(p_mcd_rec.set_of_books_id));
143: arp_standard.debug( 'created_from' || p_mcd_rec.created_from);
144: arp_standard.debug( '');
145: arp_standard.debug( 'after insert into ar_misc_cash_distributions');
146: END IF;
147:
148:
149: IF PG_DEBUG in ('Y', 'C') THEN

Line 160: PROCEDURE update_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE ) IS

156: END IF;
157: RAISE;
158: END insert_p;
159: --
160: PROCEDURE update_p( p_mcd_rec IN ar_misc_cash_distributions%ROWTYPE ) IS
161: --5201086
162: CURSOR cu_crh(p_cr_id IN NUMBER) IS
163: SELECT cash_receipt_history_id
164: FROM ar_cash_receipt_history

Line 184: UPDATE ar_misc_cash_distributions SET

180: ELSE
181: l_crh_id := p_mcd_rec.cash_receipt_history_id;
182: END IF;
183:
184: UPDATE ar_misc_cash_distributions SET
185: code_combination_id = p_mcd_rec.code_combination_id,
186: set_of_books_id = p_mcd_rec.set_of_books_id,
187: gl_date = p_mcd_rec.gl_date,
188: percent = p_mcd_rec.percent,

Line 249: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS

245: RAISE;
246: END update_p;
247: --
248: PROCEDURE delete_p(
249: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
250: BEGIN
251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()+' );
253: END IF;

Line 255: DELETE FROM ar_misc_cash_distributions

251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()+' );
253: END IF;
254: --
255: DELETE FROM ar_misc_cash_distributions
256: WHERE misc_cash_distribution_id = p_mcd_id;
257:
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_standard.debug( 'arp_misc_cash_dist_pkg.delete_p()-' );

Line 270: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS

266: RAISE;
267: END delete_p;
268:
269: PROCEDURE lock_p(
270: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
271: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
272: BEGIN
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()+' );

Line 271: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

267: END delete_p;
268:
269: PROCEDURE lock_p(
270: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE ) IS
271: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
272: BEGIN
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_standard.debug( 'arp_misc_cash_dist_pkg.lock_p()+' );
275: END IF;

Line 279: FROM ar_misc_cash_distributions

275: END IF;
276: --
277: SELECT misc_cash_distribution_id
278: INTO l_mcd_id
279: FROM ar_misc_cash_distributions
280: WHERE misc_cash_distribution_id = p_mcd_id
281: FOR UPDATE OF amount NOWAIT ;
282: --
283: IF PG_DEBUG in ('Y', 'C') THEN

Line 295: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

291: RAISE;
292: END lock_p;
293:
294: PROCEDURE fetch_p(
295: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
296: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
297: BEGIN
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()+' );

Line 296: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS

292: END lock_p;
293:
294: PROCEDURE fetch_p(
295: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
296: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
297: BEGIN
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()+' );
300: END IF;

Line 304: FROM ar_misc_cash_distributions

300: END IF;
301: --
302: SELECT *
303: INTO p_mcd_rec
304: FROM ar_misc_cash_distributions
305: WHERE misc_cash_distribution_id = p_mcd_id;
306: --
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_standard.debug( 'arp_misc_cash_dist_pkg.fetch_p()-' );

Line 320: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

316: RAISE;
317: END fetch_p;
318:
319: PROCEDURE nowaitlock_fetch_p(
320: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
321: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()+' );

Line 321: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS

317: END fetch_p;
318:
319: PROCEDURE nowaitlock_fetch_p(
320: p_mcd_id IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
321: p_mcd_rec OUT NOCOPY ar_misc_cash_distributions%ROWTYPE ) IS
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_standard.debug( 'arp_misc_cash_dist_pkg.nowaitlock_fetch_p()+' );
325: END IF;

Line 329: FROM ar_misc_cash_distributions

325: END IF;
326: --
327: SELECT *
328: INTO p_mcd_rec
329: FROM ar_misc_cash_distributions
330: WHERE misc_cash_distribution_id = p_mcd_id
331: FOR UPDATE OF amount NOWAIT;
332: --
333: IF PG_DEBUG in ('Y', 'C') THEN