APPS.ARP_AUTO_ACCOUNTING_BR dependencies on AR_DISTRIBUTIONS

Line 1345: CRLF || ' FROM ar_distributions ard' ||

1341: l_receipt_batch_pred ||
1342: CRLF || '/* prevent duplicate records from being created */' ||
1343: CRLF || 'AND not exists' ||
1344: CRLF || ' (SELECT ''distribution exists''' ||
1345: CRLF || ' FROM ar_distributions ard' ||
1346: CRLF || ' WHERE ard.source_id = th.transaction_history_id' ||
1347: CRLF || ' AND ard.source_table = ''TH''' ||
1348: CRLF || ' AND ard.source_type = :account_class)';
1349: --{BUG#4301323

Line 3030: 'DELETE from ar_distributions ard' ||

3026: --
3027: -- Construct the Delete Statement
3028: --
3029: l_delete_stmt :=
3030: 'DELETE from ar_distributions ard' ||
3031: CRLF || 'WHERE ard.source_id in' ||
3032: CRLF || '(SELECT th.transaction_history_id' ||
3033: CRLF || 'FROM ar_transaction_history th' ||
3034: CRLF || 'WHERE th.customer_trx_id = '||p_customer_trx_id ||

Line 3112: l_ae_line_rec ar_distributions%ROWTYPE;

3108: l_amount_cr NUMBER;
3109: l_acctd_amount_cr NUMBER;
3110:
3111: /* Added for mrc trigger replacement */
3112: l_ae_line_rec ar_distributions%ROWTYPE;
3113: l_ae_line_rec_empty ar_distributions%ROWTYPE;
3114: l_dummy NUMBER;
3115:
3116: BEGIN

Line 3113: l_ae_line_rec_empty ar_distributions%ROWTYPE;

3109: l_acctd_amount_cr NUMBER;
3110:
3111: /* Added for mrc trigger replacement */
3112: l_ae_line_rec ar_distributions%ROWTYPE;
3113: l_ae_line_rec_empty ar_distributions%ROWTYPE;
3114: l_dummy NUMBER;
3115:
3116: BEGIN
3117: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()+' );

Line 3223: -- select ar_distributions_s.nextval

3219: -- IF (l_ae_line_rec.source_type = 'EXCH_GAIN' or
3220: -- l_ae_line_rec.source_type = 'EXCH_LOSS' or
3221: -- l_ae_line_rec.source_type = 'CURR_ROUND' ) THEN
3222:
3223: -- select ar_distributions_s.nextval
3224: -- into l_ae_line_rec.line_id
3225: -- from dual;
3226: -- ELSE
3227: -- select line_id

Line 3229: -- from ar_distributions

3225: -- from dual;
3226: -- ELSE
3227: -- select line_id
3228: -- into l_ae_line_rec.line_id
3229: -- from ar_distributions
3230: -- where source_id = l_ae_line_rec.source_id
3231: -- and source_table = l_ae_line_rec.source_table
3232: -- and source_type = l_ae_line_rec.source_type
3233: -- and source_type_secondary IS NULL;