[Home] [Help]
4403: --
4404:
4405:
4406: --
4407: DELETE FROM ar_distributions
4408: WHERE source_id in ( select adjustment_id
4409: from ar_adjustments
4410: where customer_trx_id = p_entity_id )
4411: AND source_table = 'ADJ';
4561: l_discount_amount NUMBER;
4562: BEGIN
4563: OPEN app_to_invoice( p_entity_id );
4564: --
4565: DELETE FROM ar_distributions
4566: WHERE source_id in ( SELECT receivable_application_id
4567: FROM ar_receivable_applications
4568: WHERE
4569: ( applied_customer_trx_id = p_entity_id OR
4698: /* bug1999155: Divided select stmt which lock all transactions
4699: records into the following stmts */
4700: cursor dist_crh_cur is
4701: select 'Found' record_found
4702: FROM ar_distributions dist,
4703: ar_cash_receipt_history crh
4704: where crh.cash_receipt_history_id = dist.source_id (+)
4705: AND crh.cash_receipt_id = p_entity_id
4706: FOR UPDATE OF crh.cash_receipt_id,
4729: /* bug1999155: Divided the following select stmt into
4730: some stmts. This cursor for loop is not used .
4731: FOR lock_rec IN (
4732: SELECT 'Found' record_found
4733: FROM ar_distributions dist,
4734: ar_payment_schedules ps,
4735: ar_receivable_applications ra,
4736: ar_cash_receipt_history crh,
4737: ar_cash_receipts cr
4970: -- WHERE cash_receipt_id = p_entity_id;
4971: ARP_CASH_RECEIPTS_PKG.DELETE_P(p_entity_id);
4972:
4973: --
4974: DELETE FROM ar_distributions
4975: WHERE source_id in
4976: (
4977: SELECT cash_receipt_history_id
4978: FROM ar_cash_receipt_history
5155: END IF;
5156: END LOOP;
5157: CLOSE app_from_receipt;
5158: --
5159: DELETE FROM ar_distributions
5160: WHERE source_id in ( SELECT receivable_application_id
5161: FROM ar_receivable_applications
5162: WHERE cash_receipt_id = p_entity_id
5163: AND status <> 'APP' )
5333: WHERE CASH_RECEIPT_ID=cr_id
5334: FOR UPDATE OF CASH_RECEIPT_ID NOWAIT;
5335:
5336: CURSOR c_ard( cr_id number) IS
5337: SELECT 'X' FROM ar_distributions
5338: WHERE source_id in
5339: (
5340: SELECT cash_receipt_history_id
5341: FROM ar_cash_receipt_history
5370: open c_ara(l_rcpt_id);
5371: close c_ara;
5372:
5373:
5374: DELETE FROM ar_distributions
5375: WHERE source_id in
5376: (
5377: SELECT cash_receipt_history_id
5378: FROM ar_cash_receipt_history
5386: +---------------------------------*/
5387: -- Commented as a fix to bug - 13653152
5388: /*ar_mrc_engine.maintain_mrc_data(
5389: p_event_mode => 'DELETE',
5390: p_table_name => 'AR_DISTRIBUTIONS',
5391: p_mode => 'BATCH',
5392: p_key_value_list => r_ar_dist_key_value_list);*/
5393:
5394: arp_cr_history_pkg.delete_p_cr(l_rcpt_id);