PACKAGE BODY: APPS.ARP_CASH_REC

Source

1 PACKAGE BODY arp_cash_rec AS
2 /* $Header: ARPLCRXB.pls 120.2 2005/10/30 04:24:29 appldev ship $ */
3 
4 PROCEDURE upd_cash_receipts (p_exchange_date      DATE,
5                              p_exchange_rate      NUMBER,
6                              p_exchange_rate_type VARCHAR2,
7                              p_cash_receipt_id    NUMBER,
8 			     p_last_updated_by	  NUMBER,
9 			     p_last_update_date	  DATE,
10 			     p_last_update_login  NUMBER) IS
11 BEGIN
12 
13     UPDATE AR_CASH_RECEIPTS
14     SET EXCHANGE_DATE = p_exchange_date,
15         EXCHANGE_RATE = p_exchange_rate,
16         EXCHANGE_RATE_TYPE = p_exchange_rate_type,
17 	LAST_UPDATED_BY = p_last_updated_by,
18 	LAST_UPDATE_DATE = p_last_update_date,
19 	LAST_UPDATE_LOGIN = p_last_update_login
20     WHERE
21           CASH_RECEIPT_ID = p_cash_receipt_id;
22 
23     /*-----------------------------------+
24      | Calling Central MRC library for   |
25      | MRC integration.                  |
26      +-----------------------------------*/
27 
28      ar_mrc_engine.maintain_mrc_data(
29                      p_event_mode    => 'UPDATE',
30                      p_table_name    => 'AR_CASH_RECEIPTS',
31                      p_mode          => 'SINGLE',
32                      p_key_value     => p_cash_receipt_id);
33 
34 END upd_cash_receipts;
35 
36 
37 END arp_cash_rec;