APPS.AR_PURGE dependencies on AR_DISTRIBUTIONS

Line 3519: DELETE FROM ar_distributions

3515: p_mode => 'BATCH',
3516: p_key_value_list => l_ra_batch_key_value_list);*/
3517:
3518: --
3519: DELETE FROM ar_distributions
3520: WHERE source_id in ( select adjustment_id
3521: from ar_adjustments
3522: where customer_trx_id = p_entity_id )
3523: AND source_table = 'ADJ'

Line 3534: p_table_name => 'AR_DISTRIBUTIONS',

3530: +---------------------------------*/
3531:
3532: /* ar_mrc_engine.maintain_mrc_data(
3533: p_event_mode => 'DELETE',
3534: p_table_name => 'AR_DISTRIBUTIONS',
3535: p_mode => 'BATCH',
3536: p_key_value_list => l_ar_dist_key_value_list);*/
3537:
3538: --

Line 3715: DELETE FROM ar_distributions

3711: l_rec_app_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3712: BEGIN
3713: OPEN app_to_invoice( p_entity_id );
3714: --
3715: DELETE FROM ar_distributions
3716: WHERE source_id in ( SELECT receivable_application_id
3717: FROM ar_receivable_applications
3718: WHERE
3719: ( applied_customer_trx_id = p_entity_id OR

Line 3735: p_table_name => 'AR_DISTRIBUTIONS',

3731: +---------------------------------*/
3732:
3733: /* ar_mrc_engine.maintain_mrc_data(
3734: p_event_mode => 'DELETE',
3735: p_table_name => 'AR_DISTRIBUTIONS',
3736: p_mode => 'BATCH',
3737: p_key_value_list => l_ar_dist_key_value_list);*/
3738:
3739: --

Line 3864: FROM ar_distributions dist,

3860: /* bug1999155: Divided select stmt which lock all transactions
3861: records into the following stmts */
3862: cursor dist_crh_cur is
3863: select 'Found' record_found
3864: FROM ar_distributions dist,
3865: ar_cash_receipt_history crh
3866: where crh.cash_receipt_history_id = dist.source_id (+)
3867: AND crh.cash_receipt_id = p_entity_id
3868: FOR UPDATE OF crh.cash_receipt_id,

Line 3895: FROM ar_distributions dist,

3891: /* bug1999155: Divided the following select stmt into
3892: some stmts. This cursor for loop is not used .
3893: FOR lock_rec IN (
3894: SELECT 'Found' record_found
3895: FROM ar_distributions dist,
3896: ar_payment_schedules ps,
3897: ar_receivable_applications ra,
3898: ar_cash_receipt_history crh,
3899: ar_cash_receipts cr

Line 4141: DELETE FROM ar_distributions

4137: -- WHERE cash_receipt_id = p_entity_id;
4138: ARP_CASH_RECEIPTS_PKG.DELETE_P(p_entity_id);
4139:
4140: --
4141: DELETE FROM ar_distributions
4142: WHERE source_id in
4143: (
4144: SELECT cash_receipt_history_id
4145: FROM ar_cash_receipt_history

Line 4159: p_table_name => 'AR_DISTRIBUTIONS',

4155: +---------------------------------*/
4156:
4157: /* ar_mrc_engine.maintain_mrc_data(
4158: p_event_mode => 'DELETE',
4159: p_table_name => 'AR_DISTRIBUTIONS',
4160: p_mode => 'BATCH',
4161: p_key_value_list => l_ar_dist_key_value_list);*/
4162:
4163:

Line 4391: DELETE FROM ar_distributions

4387: END IF;
4388: END LOOP;
4389: CLOSE app_from_receipt;
4390: --
4391: DELETE FROM ar_distributions
4392: WHERE source_id in ( SELECT receivable_application_id
4393: FROM ar_receivable_applications
4394: WHERE cash_receipt_id = p_entity_id
4395: AND status <> 'APP' )

Line 4409: p_table_name => 'AR_DISTRIBUTIONS',

4405: +---------------------------------*/
4406:
4407: /* ar_mrc_engine.maintain_mrc_data(
4408: p_event_mode => 'DELETE',
4409: p_table_name => 'AR_DISTRIBUTIONS',
4410: p_mode => 'BATCH',
4411: p_key_value_list => l_ar_dist_key_value_list);*/
4412:
4413: --