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

Line 100: PROCEDURE reverse_single_dist_line(p_dist_rec IN ar_distributions%ROWTYPE);

96: FUNCTION find_exchanged_trx_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE) RETURN NUMBER;
97:
98: PROCEDURE reverse_exchanged_trx_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE);
99:
100: PROCEDURE reverse_single_dist_line(p_dist_rec IN ar_distributions%ROWTYPE);
101:
102: PROCEDURE reverse_old_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
103: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE);
104:

Line 107: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE);

103: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE);
104:
105: PROCEDURE find_rec_dist_record(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
106: p_sign IN NUMBER,
107: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE);
108:
109:
110: PROCEDURE find_prev_posted_hist_record(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
111: p_trh_rec OUT NOCOPY ar_transaction_history%ROWTYPE,

Line 385: | from the AR_DISTRIBUTIONS table.This routine deletes all records

Line 387: | (AR_DISTRIBUTIONS) be deleted first.

383: | DESCRIPTION
384: | Deletes accounting associated with a Transaction History id
385: | from the AR_DISTRIBUTIONS table.This routine deletes all records
386: | matching the input source_id. Note records from child table
387: | (AR_DISTRIBUTIONS) be deleted first.
388: | NOTE
389: | If this routine is called there must be accounting for the
390: | parent Transaction history id in the distributions table
391: | otherwise a NO_DATA_FOUND exception will be raised. In other

Line 427: DELETE FROM AR_DISTRIBUTIONS

423: | Delete all accounting for source id and source table combination |
424: | if valid candidate for deletion, if not then a NO_DATA_FOUND |
425: | exception will be raised by the above select statement. |
426: +-------------------------------------------------------------------*/
427: DELETE FROM AR_DISTRIBUTIONS
428: WHERE source_id = g_ae_doc_rec.source_id
429: AND source_table = C_TH
430: RETURNING line_id
431: BULK COLLECT INTO l_ar_dist_key_value_list;

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

436: +---------------------------------*/
437: --{BUG4301323
438: -- ar_mrc_engine.maintain_mrc_data(
439: -- p_event_mode => 'DELETE',
440: -- p_table_name => 'AR_DISTRIBUTIONS',
441: -- p_mode => 'BATCH',
442: -- p_key_value_list => l_ar_dist_key_value_list);
443: --}
444:

Line 471: | This procedure reverses the records in AR_DISTRIBUTIONS for a

Line 524: from ar_distributions ard

520: ard.from_amount_cr,
521: ard.from_acctd_amount_dr,
522: ard.from_acctd_amount_cr
523: --}
524: from ar_distributions ard
525: where NVL(g_ae_sys_rec.sob_type,'P') = 'P'
526: and ard.source_id = g_ae_doc_rec.source_id_old
527: and ard.source_table = g_ae_doc_rec.source_table
528: order by line_id ;

Line 581: l_ard_rec ar_distributions%ROWTYPE;

577: and ard.source_table = g_ae_doc_rec.source_table
578: order by line_id ;
579: */
580:
581: l_ard_rec ar_distributions%ROWTYPE;
582:
583: BEGIN
584:
585: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.Reverse_BR()+');

Line 1459: PROCEDURE reverse_single_dist_line(p_dist_rec ar_distributions%ROWTYPE) IS

1455: |
1456: | PARAMETERS
1457: | p_dist_rec Distribution record
1458: * ======================================================================*/
1459: PROCEDURE reverse_single_dist_line(p_dist_rec ar_distributions%ROWTYPE) IS
1460: l_ael_line_rec ae_line_rec_type;
1461: l_ael_empty_line_rec ae_line_rec_type;
1462: BEGIN
1463: IF PG_DEBUG in ('Y', 'C') THEN

Line 1575: l_ard_rec ar_distributions%ROWTYPE;

1571: --}
1572: from ar_payment_schedules ps
1573: where ps.payment_schedule_id = p_ps_id;
1574:
1575: l_ard_rec ar_distributions%ROWTYPE;
1576: l_prev_posted_trh_rec ar_transaction_history%ROWTYPE;
1577: l_ps_rec ps_cur%ROWTYPE;
1578:
1579: BEGIN

Line 1773: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE) IS

1769: | p_dist_rec Distribution record
1770: * ======================================================================*/
1771: PROCEDURE find_rec_dist_record(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
1772: p_sign IN NUMBER,
1773: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE) IS
1774:
1775: /*-----------------------------------------------------+
1776: | Cursor to return the accounting record for |
1777: | given transaction history record. This is used to |

Line 1827: from ar_distributions

1823: from_amount_cr,
1824: from_acctd_amount_dr,
1825: from_acctd_amount_cr
1826: --}
1827: from ar_distributions
1828: where NVL(g_ae_sys_rec.sob_type,'P') = 'P'
1829: and source_id = p_transaction_history_id
1830: and source_table = C_TH
1831: and source_type in (C_REC,C_FACTOR,C_REMITTANCE,C_UNPAIDREC)

Line 1903: distribution_rec ar_distributions%ROWTYPE;

1899: and ((nvl(AMOUNT_CR,0) <> 0) OR (nvl(ACCTD_AMOUNT_CR,0) <> 0))
1900: and (nvl(AMOUNT_DR,0) = 0) and (nvl(ACCTD_AMOUNT_DR,0) = 0)))
1901: order by line_id desc;
1902: */
1903: distribution_rec ar_distributions%ROWTYPE;
1904:
1905: BEGIN
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_standard.debug( 'ARP_BILLS_RECEIVABLE_MAIN.find_rec_dist_record()+');

Line 2128: FROM ar_distributions

2124: from_amount_cr,
2125: from_acctd_amount_dr,
2126: from_acctd_amount_cr
2127: --}
2128: FROM ar_distributions
2129: WHERE NVL(g_ae_sys_rec.sob_type,'P') = 'P'
2130: AND source_id = l_transaction_history_id
2131: AND source_table = C_TH
2132: AND source_type = C_REC

Line 2192: last_exchange_accounting_rec ar_distributions%ROWTYPE;

2188: AND source_table_secondary = C_CTL
2189: AND source_type_secondary = C_ASSIGNMENT
2190: ORDER BY line_id ASC;
2191: */
2192: last_exchange_accounting_rec ar_distributions%ROWTYPE;
2193: l_last_exchanged_history_id ar_transaction_history.transaction_history_id%TYPE;
2194:
2195: BEGIN
2196: IF PG_DEBUG in ('Y', 'C') THEN

Line 2394: BR_dist_rec ar_distributions%ROWTYPE;

2390:
2391: all_exchanges_rec all_exchanges_cur%ROWTYPE;
2392: TRX_exchange_rec TRX_exchange_cur%ROWTYPE;
2393: BR_exchange_rec BR_exchange_cur%ROWTYPE;
2394: BR_dist_rec ar_distributions%ROWTYPE;
2395:
2396: l_ael_line_rec ae_line_rec_type;
2397: l_ael_empty_line_rec ae_line_rec_type;
2398: --{HYUDETDIST

Line 2642: FROM ar_distributions

2638: from_amount_cr,
2639: from_acctd_amount_dr,
2640: from_acctd_amount_cr
2641: --}
2642: FROM ar_distributions
2643: WHERE NVL(g_ae_sys_rec.sob_type,'P') = 'P'
2644: AND source_id = l_transaction_history_id
2645: AND source_table = C_TH
2646: AND source_type in (C_DEFERRED_TAX,C_TAX)

Line 2700: tax_accounting_rec ar_distributions%ROWTYPE;

2696: AND source_table = C_TH
2697: AND source_type in (C_DEFERRED_TAX,C_TAX)
2698: ORDER BY line_id ASC;
2699: */
2700: tax_accounting_rec ar_distributions%ROWTYPE;
2701: l_prev_posted_trh_rec ar_transaction_history%ROWTYPE;
2702:
2703: BEGIN
2704: IF PG_DEBUG in ('Y', 'C') THEN