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_PROC_RCT_UTIL dependencies on AR_DISTRIBUTIONS

Line 378: --in ar_distributions. Note tax accounting must be created after a call

374: p_ra_id := l_ra_id;
375:
376: --
377: --Release 11.5 VAT changes, create receivable application accounting
378: --in ar_distributions. Note tax accounting must be created after a call
379: --to this function. It is due to this reason that the app id is returned
380: --as output to the parent procedure to enable a call to the tax accounting
381: --routine
382:

Line 412: | inserts ar_distributions record for a cash/misc receipt |

408: | PROCEDURE |
409: | insert_dist_rec |
410: | |
411: | DESCRIPTION |
412: | inserts ar_distributions record for a cash/misc receipt |
413: | |
414: | SCOPE - PRIVATE |
415: | |
416: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 439: p_source_type IN ar_distributions.source_type%TYPE,

435: p_amount IN ar_cash_receipts.amount%TYPE,
436: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
437: p_crh_id IN
438: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
439: p_source_type IN ar_distributions.source_type%TYPE,
440: p_ccid IN ar_distributions.code_combination_id%TYPE,
441: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
442: ) IS
443:

Line 440: p_ccid IN ar_distributions.code_combination_id%TYPE,

436: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
437: p_crh_id IN
438: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
439: p_source_type IN ar_distributions.source_type%TYPE,
440: p_ccid IN ar_distributions.code_combination_id%TYPE,
441: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
442: ) IS
443:
444: l_dist_rec ar_distributions%ROWTYPE;

Line 444: l_dist_rec ar_distributions%ROWTYPE;

440: p_ccid IN ar_distributions.code_combination_id%TYPE,
441: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
442: ) IS
443:
444: l_dist_rec ar_distributions%ROWTYPE;
445: l_source_type ar_distributions.source_type%TYPE;
446: l_ccid ar_distributions.code_combination_id%TYPE;
447: l_dummy ar_distributions.line_id%TYPE;
448: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 445: l_source_type ar_distributions.source_type%TYPE;

441: p_called_from IN VARCHAR2 DEFAULT NULL -- jrautiai BR project
442: ) IS
443:
444: l_dist_rec ar_distributions%ROWTYPE;
445: l_source_type ar_distributions.source_type%TYPE;
446: l_ccid ar_distributions.code_combination_id%TYPE;
447: l_dummy ar_distributions.line_id%TYPE;
448: l_cr_rec ar_cash_receipts%ROWTYPE;
449: l_crh_rec ar_cash_receipt_history%ROWTYPE;

Line 446: l_ccid ar_distributions.code_combination_id%TYPE;

442: ) IS
443:
444: l_dist_rec ar_distributions%ROWTYPE;
445: l_source_type ar_distributions.source_type%TYPE;
446: l_ccid ar_distributions.code_combination_id%TYPE;
447: l_dummy ar_distributions.line_id%TYPE;
448: l_cr_rec ar_cash_receipts%ROWTYPE;
449: l_crh_rec ar_cash_receipt_history%ROWTYPE;
450: --bug#2750340

Line 447: l_dummy ar_distributions.line_id%TYPE;

443:
444: l_dist_rec ar_distributions%ROWTYPE;
445: l_source_type ar_distributions.source_type%TYPE;
446: l_ccid ar_distributions.code_combination_id%TYPE;
447: l_dummy ar_distributions.line_id%TYPE;
448: l_cr_rec ar_cash_receipts%ROWTYPE;
449: l_crh_rec ar_cash_receipt_history%ROWTYPE;
450: --bug#2750340
451: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 513: -- p_table_name => 'AR_DISTRIBUTIONS',

509: mrc engine */
510: --{BUG4301323
511: -- ar_mrc_engine2.maintain_mrc_data2(
512: -- p_event_mode => 'INSERT',
513: -- p_table_name => 'AR_DISTRIBUTIONS',
514: -- p_mode => 'SINGLE',
515: -- p_key_value => l_dist_rec.line_id,
516: -- p_row_info => l_dist_rec);
517: --}

Line 862: Record is not created in ar_distributions table. Commented out NOCOPY the condition

858: -- 941243: insert distributions records
859: -- do not create ar_misc_cash_distributions if receipt amount = 0
860: /* Bug fix 2272461
861: When the MISC receipt amount is changed to zero, the MISCCASH accounting
862: Record is not created in ar_distributions table. Commented out NOCOPY the condition
863: which check for the receipt amount before creating the record.
864: IF (p_amount <> 0) THEN */
865:
866: create_mcd_recs(p_cash_receipt_id,

Line 933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE

929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
930: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
931: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
932: p_receipt_date_changed_flag IN BOOLEAN,
933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
934: ) IS
935:
936: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
937: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

Line 1034: Record is not created in ar_distributions table. Commented out NOCOPY the portion

1030: -- based on default account/distribution set
1031:
1032: /* Bug fix 2272461
1033: When the MISC receipt amount is changed to zero, the MISCCASH accounting
1034: Record is not created in ar_distributions table. Commented out NOCOPY the portion
1035: of the code which handles the zero receipt amount separately.
1036: IF (p_amount = 0) THEN
1037: --
1038: -- Handle case 8 right away:

Line 1051: FROM ar_distributions ard

1047: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1048: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
1049: AND mcd.posting_control_id = -3 --Not posted
1050: AND EXISTS (SELECT 'x'
1051: FROM ar_distributions ard
1052: WHERE ard.source_id = mcd.misc_cash_distribution_id
1053: AND ard.source_table = 'MCD');
1054:
1055: IF PG_DEBUG in ('Y', 'C') THEN

Line 1263: recreate accounting in AR_DISTRIBUTIONS for the new amounts.

1259: /* Bug 1792989. When only the receipt amount is changed with no change
1260: to receivable activity, then distribution accounting should not be
1261: affected and only the amounts should be updated in
1262: AR_MISC_CASH_DISTRIBUTIONS. Also Accounting engine is called to
1263: recreate accounting in AR_DISTRIBUTIONS for the new amounts.
1264: This is done by
1265: 1. Calling the Accounting engine to delete the MCD records
1266: from AR_DISTRIBUTIONS for the passed cash_receipt_id.
1267: 2. Update the amount in AR_MISC_CASH_DISTRIBUTIONS by calling

Line 1266: from AR_DISTRIBUTIONS for the passed cash_receipt_id.

1262: AR_MISC_CASH_DISTRIBUTIONS. Also Accounting engine is called to
1263: recreate accounting in AR_DISTRIBUTIONS for the new amounts.
1264: This is done by
1265: 1. Calling the Accounting engine to delete the MCD records
1266: from AR_DISTRIBUTIONS for the passed cash_receipt_id.
1267: 2. Update the amount in AR_MISC_CASH_DISTRIBUTIONS by calling
1268: procedure update_manual_dist.
1269: 3. Calling the Accounting engine to recreate the MCD records
1270: taking the new amount into consideration.

Line 1291: FROM ar_distributions ard

1287: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1288: AND mcd.reversal_gl_date IS NULL
1289: AND mcd.posting_control_id = -3
1290: AND EXISTS (SELECT 'x'
1291: FROM ar_distributions ard
1292: WHERE ard.source_id = mcd.misc_cash_distribution_id
1293: AND ard.source_table = 'MCD');
1294:
1295: l_ae_doc_rec.document_type := 'RECEIPT';

Line 1425: FROM ar_distributions ard

1421: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1422: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
1423: AND mcd.posting_control_id = -3 --Not posted
1424: AND EXISTS (SELECT 'x'
1425: FROM ar_distributions ard
1426: WHERE ard.source_id = mcd.misc_cash_distribution_id
1427: AND ard.source_table = 'MCD');
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN

Line 2235: | updates a record in AR_DISTRIBUTIONS table |

2231: | PROCEDURE |
2232: | update_dist_rec |
2233: | |
2234: | DESCRIPTION |
2235: | updates a record in AR_DISTRIBUTIONS table |
2236: | |
2237: | SCOPE - PRIVATE |
2238: | |
2239: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2255: p_source_type IN ar_distributions.source_type%TYPE,

2251: | 19-NOV-96 OSTEINME created |
2252: +===========================================================================*/
2253:
2254: PROCEDURE update_dist_rec( p_crh_id IN NUMBER,
2255: p_source_type IN ar_distributions.source_type%TYPE,
2256: p_amount IN NUMBER,
2257: p_acctd_amount IN NUMBER) IS
2258:
2259: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;

Line 2259: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;

2255: p_source_type IN ar_distributions.source_type%TYPE,
2256: p_amount IN NUMBER,
2257: p_acctd_amount IN NUMBER) IS
2258:
2259: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;
2260: l_amount number;
2261: l_acctd_amount number;
2262: BEGIN
2263:

Line 2344: p_table_name => 'AR_DISTRIBUTIONS',

2340: mrc engine */
2341: /*4301323
2342: ar_mrc_engine2.maintain_mrc_data2(
2343: p_event_mode => 'UPDATE',
2344: p_table_name => 'AR_DISTRIBUTIONS',
2345: p_mode => 'SINGLE',
2346: p_key_value => l_dist_rec.line_id,
2347: p_row_info => l_dist_rec);
2348: */