DBA Data[Home] [Help]

APPS.ARP_CASH_REC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

			     p_last_updated_by	  NUMBER,
			     p_last_update_date	  DATE,
			     p_last_update_login  NUMBER) IS
BEGIN

    UPDATE AR_CASH_RECEIPTS
    SET EXCHANGE_DATE = p_exchange_date,
        EXCHANGE_RATE = p_exchange_rate,
        EXCHANGE_RATE_TYPE = p_exchange_rate_type,
	LAST_UPDATED_BY = p_last_updated_by,
	LAST_UPDATE_DATE = p_last_update_date,
	LAST_UPDATE_LOGIN = p_last_update_login
    WHERE
          CASH_RECEIPT_ID = p_cash_receipt_id;
Line: 29

                     p_event_mode    => 'UPDATE',
                     p_table_name    => 'AR_CASH_RECEIPTS',
                     p_mode          => 'SINGLE',
                     p_key_value     => p_cash_receipt_id);