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 369: --in ar_distributions. Note tax accounting must be created after a call

365: p_ra_id := l_ra_id;
366:
367: --
368: --Release 11.5 VAT changes, create receivable application accounting
369: --in ar_distributions. Note tax accounting must be created after a call
370: --to this function. It is due to this reason that the app id is returned
371: --as output to the parent procedure to enable a call to the tax accounting
372: --routine
373:

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

397: | PROCEDURE |
398: | insert_dist_rec |
399: | |
400: | DESCRIPTION |
401: | inserts ar_distributions record for a cash/misc receipt |
402: | |
403: | SCOPE - PRIVATE |
404: | |
405: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 428: p_source_type IN ar_distributions.source_type%TYPE,

424: p_amount IN ar_cash_receipts.amount%TYPE,
425: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
426: p_crh_id IN
427: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
428: p_source_type IN ar_distributions.source_type%TYPE,
429: p_ccid IN ar_distributions.code_combination_id%TYPE
430: ) IS
431:
432: l_dist_rec ar_distributions%ROWTYPE;

Line 429: p_ccid IN ar_distributions.code_combination_id%TYPE

425: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
426: p_crh_id IN
427: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
428: p_source_type IN ar_distributions.source_type%TYPE,
429: p_ccid IN ar_distributions.code_combination_id%TYPE
430: ) IS
431:
432: l_dist_rec ar_distributions%ROWTYPE;
433: l_source_type ar_distributions.source_type%TYPE;

Line 432: l_dist_rec ar_distributions%ROWTYPE;

428: p_source_type IN ar_distributions.source_type%TYPE,
429: p_ccid IN ar_distributions.code_combination_id%TYPE
430: ) IS
431:
432: l_dist_rec ar_distributions%ROWTYPE;
433: l_source_type ar_distributions.source_type%TYPE;
434: l_ccid ar_distributions.code_combination_id%TYPE;
435: l_dummy ar_distributions.line_id%TYPE;
436: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 433: l_source_type ar_distributions.source_type%TYPE;

429: p_ccid IN ar_distributions.code_combination_id%TYPE
430: ) IS
431:
432: l_dist_rec ar_distributions%ROWTYPE;
433: l_source_type ar_distributions.source_type%TYPE;
434: l_ccid ar_distributions.code_combination_id%TYPE;
435: l_dummy ar_distributions.line_id%TYPE;
436: l_cr_rec ar_cash_receipts%ROWTYPE;
437: l_crh_rec ar_cash_receipt_history%ROWTYPE;

Line 434: l_ccid ar_distributions.code_combination_id%TYPE;

430: ) IS
431:
432: l_dist_rec ar_distributions%ROWTYPE;
433: l_source_type ar_distributions.source_type%TYPE;
434: l_ccid ar_distributions.code_combination_id%TYPE;
435: l_dummy ar_distributions.line_id%TYPE;
436: l_cr_rec ar_cash_receipts%ROWTYPE;
437: l_crh_rec ar_cash_receipt_history%ROWTYPE;
438: --bug#2750340

Line 435: l_dummy ar_distributions.line_id%TYPE;

431:
432: l_dist_rec ar_distributions%ROWTYPE;
433: l_source_type ar_distributions.source_type%TYPE;
434: l_ccid ar_distributions.code_combination_id%TYPE;
435: l_dummy ar_distributions.line_id%TYPE;
436: l_cr_rec ar_cash_receipts%ROWTYPE;
437: l_crh_rec ar_cash_receipt_history%ROWTYPE;
438: --bug#2750340
439: l_xla_ev_rec arp_xla_events.xla_events_type;

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

497: mrc engine */
498: --{BUG4301323
499: -- ar_mrc_engine2.maintain_mrc_data2(
500: -- p_event_mode => 'INSERT',
501: -- p_table_name => 'AR_DISTRIBUTIONS',
502: -- p_mode => 'SINGLE',
503: -- p_key_value => l_dist_rec.line_id,
504: -- p_row_info => l_dist_rec);
505: --}

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

843: -- 941243: insert distributions records
844: -- do not create ar_misc_cash_distributions if receipt amount = 0
845: /* Bug fix 2272461
846: When the MISC receipt amount is changed to zero, the MISCCASH accounting
847: Record is not created in ar_distributions table. Commented out NOCOPY the condition
848: which check for the receipt amount before creating the record.
849: IF (p_amount <> 0) THEN */
850:
851: create_mcd_recs(p_cash_receipt_id,

Line 918: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE

914: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
915: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
916: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
917: p_receipt_date_changed_flag IN BOOLEAN,
918: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
919: ) IS
920:
921: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
922: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

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

1015: -- based on default account/distribution set
1016:
1017: /* Bug fix 2272461
1018: When the MISC receipt amount is changed to zero, the MISCCASH accounting
1019: Record is not created in ar_distributions table. Commented out NOCOPY the portion
1020: of the code which handles the zero receipt amount separately.
1021: IF (p_amount = 0) THEN
1022: --
1023: -- Handle case 8 right away:

Line 1036: FROM ar_distributions ard

1032: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1033: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
1034: AND mcd.posting_control_id = -3 --Not posted
1035: AND EXISTS (SELECT 'x'
1036: FROM ar_distributions ard
1037: WHERE ard.source_id = mcd.misc_cash_distribution_id
1038: AND ard.source_table = 'MCD');
1039:
1040: IF PG_DEBUG in ('Y', 'C') THEN

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

1244: /* Bug 1792989. When only the receipt amount is changed with no change
1245: to receivable activity, then distribution accounting should not be
1246: affected and only the amounts should be updated in
1247: AR_MISC_CASH_DISTRIBUTIONS. Also Accounting engine is called to
1248: recreate accounting in AR_DISTRIBUTIONS for the new amounts.
1249: This is done by
1250: 1. Calling the Accounting engine to delete the MCD records
1251: from AR_DISTRIBUTIONS for the passed cash_receipt_id.
1252: 2. Update the amount in AR_MISC_CASH_DISTRIBUTIONS by calling

Line 1251: from AR_DISTRIBUTIONS for the passed cash_receipt_id.

1247: AR_MISC_CASH_DISTRIBUTIONS. Also Accounting engine is called to
1248: recreate accounting in AR_DISTRIBUTIONS for the new amounts.
1249: This is done by
1250: 1. Calling the Accounting engine to delete the MCD records
1251: from AR_DISTRIBUTIONS for the passed cash_receipt_id.
1252: 2. Update the amount in AR_MISC_CASH_DISTRIBUTIONS by calling
1253: procedure update_manual_dist.
1254: 3. Calling the Accounting engine to recreate the MCD records
1255: taking the new amount into consideration.

Line 1276: FROM ar_distributions ard

1272: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1273: AND mcd.reversal_gl_date IS NULL
1274: AND mcd.posting_control_id = -3
1275: AND EXISTS (SELECT 'x'
1276: FROM ar_distributions ard
1277: WHERE ard.source_id = mcd.misc_cash_distribution_id
1278: AND ard.source_table = 'MCD');
1279:
1280: l_ae_doc_rec.document_type := 'RECEIPT';

Line 1410: FROM ar_distributions ard

1406: WHERE mcd.cash_receipt_id = p_cash_receipt_id
1407: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
1408: AND mcd.posting_control_id = -3 --Not posted
1409: AND EXISTS (SELECT 'x'
1410: FROM ar_distributions ard
1411: WHERE ard.source_id = mcd.misc_cash_distribution_id
1412: AND ard.source_table = 'MCD');
1413:
1414: IF PG_DEBUG in ('Y', 'C') THEN

Line 2220: | updates a record in AR_DISTRIBUTIONS table |

2216: | PROCEDURE |
2217: | update_dist_rec |
2218: | |
2219: | DESCRIPTION |
2220: | updates a record in AR_DISTRIBUTIONS table |
2221: | |
2222: | SCOPE - PRIVATE |
2223: | |
2224: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2240: p_source_type IN ar_distributions.source_type%TYPE,

2236: | 19-NOV-96 OSTEINME created |
2237: +===========================================================================*/
2238:
2239: PROCEDURE update_dist_rec( p_crh_id IN NUMBER,
2240: p_source_type IN ar_distributions.source_type%TYPE,
2241: p_amount IN NUMBER,
2242: p_acctd_amount IN NUMBER) IS
2243:
2244: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;

Line 2244: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;

2240: p_source_type IN ar_distributions.source_type%TYPE,
2241: p_amount IN NUMBER,
2242: p_acctd_amount IN NUMBER) IS
2243:
2244: l_dist_rec AR_DISTRIBUTIONS%ROWTYPE;
2245: l_amount number;
2246: l_acctd_amount number;
2247: BEGIN
2248:

Line 2329: p_table_name => 'AR_DISTRIBUTIONS',

2325: mrc engine */
2326: /*4301323
2327: ar_mrc_engine2.maintain_mrc_data2(
2328: p_event_mode => 'UPDATE',
2329: p_table_name => 'AR_DISTRIBUTIONS',
2330: p_mode => 'SINGLE',
2331: p_key_value => l_dist_rec.line_id,
2332: p_row_info => l_dist_rec);
2333: */