APPS.AR_PURGE dependencies on RA_BATCHES

Line 728: ra_batches batch,

724: ra_rules rule,
725: ra_cust_trx_types ctt_prev,
726: ra_cust_trx_types ctt,
727: ra_batch_sources bs,
728: ra_batches batch,
729: fnd_document_sequences doc,
730: gl_sets_of_books sob,
731: hz_cust_accounts cust_bill,
732: hz_parties bill_party,

Line 3439: FROM ra_batches bat,

3435: END IF ;
3436: --
3437: SELECT bat.batch_id
3438: INTO l_batch_id
3439: FROM ra_batches bat,
3440: ra_customer_trx trx
3441: WHERE trx.customer_trx_id = p_entity_id
3442: AND trx.batch_id = bat.batch_id (+)
3443: FOR UPDATE OF bat.batch_id NOWAIT ;

Line 3490: DELETE FROM ra_batches

3486: -- ra_customer_Trx
3487:
3488: arp_ct_pkg.delete_p(p_entity_id);
3489:
3490: DELETE FROM ra_batches
3491: WHERE batch_id = l_batch_id
3492: AND NOT EXISTS ( SELECT 'x'
3493: FROM ra_customer_trx t
3494: WHERE t.batch_id = l_batch_id )

Line 3501: UPDATE ra_batches batch

3497:
3498: -- bug3283678 this must be done after above delete stmt.
3499: IF SQL%ROWCOUNT = 0
3500: THEN
3501: UPDATE ra_batches batch
3502: SET batch.purged_children_flag = 'Y'
3503: WHERE batch.batch_id = l_batch_id ;
3504: END IF ;
3505: --

Line 3514: p_table_name => 'RA_BATCHES',

3510: +---------------------------------*/
3511:
3512: /* ar_mrc_engine.maintain_mrc_data(
3513: p_event_mode => 'DELETE',
3514: p_table_name => 'RA_BATCHES',
3515: p_mode => 'BATCH',
3516: p_key_value_list => l_ra_batch_key_value_list);*/
3517:
3518: --