eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_CASHFLOW_PKG SQL Statements

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

Line: 9


|       update_ce_cashflows
|  DESCRIPTION                                                          |
|       update records in CE_CASHFLOWS					|
|  CALLED BY                                                            |
|       clear_cashflow
 --------------------------------------------------------------------- */
PROCEDURE update_ce_cashflows(
    	X_CASHFLOW_ID   		number,
	X_TRX_STATUS			varchar2,
        X_actual_value_date  		date,
        X_CLEARED_DATE          	date,
        X_CLEARED_AMOUNT    		number,
        X_CLEARED_ERROR_AMOUNT          number,
        X_CLEARED_CHARGE_AMOUNT         number,
        X_CLEARED_EXCHANGE_RATE_TYPE    varchar2,
        X_CLEARED_EXCHANGE_RATE_DATE    date,
        X_CLEARED_EXCHANGE_RATE         number,
	X_NEW_TRX_STATUS		varchar2,
	X_CLEARED_BY_FLAG		VARCHAR2 ,
        X_LAST_UPDATE_DATE      	date,
        X_LAST_UPDATED_BY       	number,
        X_LAST_UPDATE_LOGIN     	number,
	X_STATEMENT_LINE_ID  		number,
	X_PASSIN_MODE			varchar2
	)   IS
BEGIN
  IF l_DEBUG in ('Y', 'C') THEN
  	cep_standard.debug('>>CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

Line: 53


    UPDATE CE_CASHFLOWS
    SET CASHFLOW_STATUS_CODE 		= X_NEW_TRX_STATUS,
 	  CLEARED_BY_FLAG 		= X_CLEARED_BY_FLAG,
          LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY       	= X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN     	= X_LAST_UPDATE_LOGIN,
	  STATEMENT_LINE_ID		= X_STATEMENT_LINE_ID
    WHERE CASHFLOW_ID = X_CASHFLOW_ID;

Line: 66


    UPDATE CE_CASHFLOWS
    SET CASHFLOW_STATUS_CODE 		= X_NEW_TRX_STATUS,
          ACTUAL_VALUE_DATE		= X_actual_value_date,
	  CLEARED_DATE 			= X_CLEARED_DATE ,
	  CLEARED_AMOUNT 		= abs(X_CLEARED_AMOUNT),
	  CLEARED_EXCHANGE_RATE		= X_CLEARED_EXCHANGE_RATE,
	  CLEARED_EXCHANGE_DATE		= X_CLEARED_EXCHANGE_RATE_DATE,
	  CLEARED_EXCHANGE_RATE_TYPE	= X_CLEARED_EXCHANGE_RATE_TYPE ,
	  CLEARING_CHARGES_AMOUNT	= X_CLEARED_CHARGE_AMOUNT,
	  CLEARING_ERROR_AMOUNT		= X_CLEARED_ERROR_AMOUNT,
 	  CLEARED_BY_FLAG 		= X_CLEARED_BY_FLAG,
          LAST_UPDATE_DATE      	= X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY       	= X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN     	= X_LAST_UPDATE_LOGIN,
	  STATEMENT_LINE_ID		= X_STATEMENT_LINE_ID
    WHERE CASHFLOW_ID = X_CASHFLOW_ID;

Line: 86


  	cep_standard.debug('<


Line: 92

    	cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

Line: 95

END UPDATE_CE_CASHFLOWS;

Line: 144

|       update_ce_cashflows                                             |
|  CALLED BY                                                            |
|       CE_AUTO_BANK_CLEAR1.reconcile_trx                               |
|       CE_AUTO_BANK_CLEAR1.unclear_process                             |
 --------------------------------------------------------------------- */
PROCEDURE clear_cashflow (
        x_cashflow_id                NUMBER,
        x_trx_status                 VARCHAR2,
        x_actual_value_date          DATE,
        x_accounting_date            DATE,
        x_cleared_date               DATE,
        x_cleared_amount             NUMBER,
        x_cleared_error_amount       NUMBER,
        x_cleared_charge_amount      NUMBER,
        x_cleared_exchange_rate_type VARCHAR2,
        x_cleared_exchange_rate_date DATE,
        x_cleared_exchange_rate      NUMBER,
        x_passin_mode                VARCHAR2,
        x_statement_line_id          NUMBER,
        x_statement_line_type        VARCHAR2
        )   IS

    x_cleared_by_flag         VARCHAR2(1);

Line: 188

  SELECT SOURCE_TRXN_TYPE,
         STATEMENT_LINE_ID,
         CASHFLOW_STATUS_CODE,
         cleared_by_flag
    INTO x_source_trxn_type,
         x_trx_stmt_ln_id,
         x_cashflow_status_code,
         x_current_cleared_by_flag
    FROM ce_cashflows
   WHERE cashflow_id = X_CASHFLOW_ID;

Line: 203

  SELECT COUNT(*) into l_err
					FROM ce_cashflows
				WHERE cashflow_status_code='CANCELED'
				AND cashflow_id =X_CASHFLOW_ID;

Line: 276

    update_ce_cashflows(
    	X_CASHFLOW_ID   		=> X_CASHFLOW_ID,
	X_TRX_STATUS			=> X_CF_TRX_STATUS,
        X_actual_value_date  		=> X_actual_value_date,
        X_CLEARED_DATE          	=> X_CLEARED_DATE ,
        X_CLEARED_AMOUNT    		=> abs(X_CLEARED_AMOUNT),
        X_CLEARED_ERROR_AMOUNT          => X_CLEARED_ERROR_AMOUNT,
        X_CLEARED_CHARGE_AMOUNT         => X_CLEARED_CHARGE_AMOUNT,
        X_CLEARED_EXCHANGE_RATE_TYPE    => X_CLEARED_EXCHANGE_RATE_TYPE ,
        X_CLEARED_EXCHANGE_RATE_DATE    => X_CLEARED_EXCHANGE_RATE_DATE,
        X_CLEARED_EXCHANGE_RATE         => X_CLEARED_EXCHANGE_RATE,
	X_NEW_TRX_STATUS		=> X_NEW_TRX_STATUS,
	X_CLEARED_BY_FLAG		=> X_CLEARED_BY_FLAG,
        X_LAST_UPDATE_DATE      	=> sysdate,
        X_LAST_UPDATED_BY       	=> NVL(FND_GLOBAL.user_id,-1),
        X_LAST_UPDATE_LOGIN     	=> NVL(FND_GLOBAL.user_id,-1),
	X_STATEMENT_LINE_ID		=> x_new_stmt_ln_id,
	X_PASSIN_MODE 			=> X_PASSIN_MODE
        );

Line: 322

	select trx_type
	into X_NEW_STATEMENT_LINE_TYPE
	from ce_statement_lines
	where statement_line_id = X_NEW_STMT_LN_ID;

Line: 335

      update_ce_cashflows(
    	X_CASHFLOW_ID   		=> X_CASHFLOW_ID,
	X_TRX_STATUS			=> X_CF_TRX_STATUS,
        X_actual_value_date  		=> null,
        X_CLEARED_DATE          	=> null,
        X_CLEARED_AMOUNT    		=> null,
        X_CLEARED_ERROR_AMOUNT          => null,
        X_CLEARED_CHARGE_AMOUNT         => null,
        X_CLEARED_EXCHANGE_RATE_TYPE    => null,
        X_CLEARED_EXCHANGE_RATE_DATE    => null,
        X_CLEARED_EXCHANGE_RATE         => null,
	X_NEW_TRX_STATUS		=> X_NEW_TRX_STATUS,
	X_CLEARED_BY_FLAG		=> X_CLEARED_BY_FLAG ,
        X_LAST_UPDATE_DATE      	=> sysdate,
        X_LAST_UPDATED_BY       	=> NVL(FND_GLOBAL.user_id,-1),
        X_LAST_UPDATE_LOGIN     	=> NVL(FND_GLOBAL.user_id,-1),
	X_STATEMENT_LINE_ID		=> x_new_stmt_ln_id,
	X_PASSIN_MODE 			=> X_PASSIN_MODE
        );

Line: 358

      update_ce_cashflows(
    	X_CASHFLOW_ID   		=> X_CASHFLOW_ID,
	X_TRX_STATUS			=> X_CF_TRX_STATUS,
        X_actual_value_date  		=> X_actual_value_date,
        X_CLEARED_DATE          	=> X_CLEARED_DATE ,
        X_CLEARED_AMOUNT    		=> abs(X_CLEARED_AMOUNT),
        X_CLEARED_ERROR_AMOUNT          => X_CLEARED_ERROR_AMOUNT,
        X_CLEARED_CHARGE_AMOUNT         => X_CLEARED_CHARGE_AMOUNT,
        X_CLEARED_EXCHANGE_RATE_TYPE    => X_CLEARED_EXCHANGE_RATE_TYPE ,
        X_CLEARED_EXCHANGE_RATE_DATE    => X_CLEARED_EXCHANGE_RATE_DATE,
        X_CLEARED_EXCHANGE_RATE         => X_CLEARED_EXCHANGE_RATE,
	X_NEW_TRX_STATUS		=> X_NEW_TRX_STATUS,
	X_CLEARED_BY_FLAG		=> X_CLEARED_BY_FLAG ,
        X_LAST_UPDATE_DATE      	=> sysdate,
        X_LAST_UPDATED_BY       	=> NVL(FND_GLOBAL.user_id,-1),
        X_LAST_UPDATE_LOGIN     	=> NVL(FND_GLOBAL.user_id,-1),
	X_STATEMENT_LINE_ID		=> x_new_stmt_ln_id,
	X_PASSIN_MODE 			=> X_PASSIN_MODE
        );

Line: 414

|       update_user_lines                                               |
|  DESCRIPTION                                                          |
|       To insert/update user defined inflows/outflows                  |
|    CALLED BY                                                          |
|       CashPositionAMImpl.java                                         |
 --------------------------------------------------------------------- */
PROCEDURE UPDATE_USER_LINES
(
 X_WORKSHEET_HEADER_ID  IN NUMBER,
 X_WORKSHEET_LINE_ID    IN NUMBER,
 X_LINE_DESCRIPTION     IN VARCHAR2,
 X_SOURCE_TYPE          IN VARCHAR2,
 X_BANK_ACCOUNT_ID      IN NUMBER,
 X_AS_OF_DATE           IN DATE,
 X_AMOUNT               IN NUMBER
) IS
l_amount NUMBER;

Line: 433

        cep_standard.debug('>>CE_CASHFLOW_PKG.update_user_lines');

Line: 442

      INSERT INTO
      CE_CP_WORKSHEET_USER_LINES
      (
      WORKSHEET_HEADER_ID,
      WORKSHEET_LINE_ID,
      LINE_DESCRIPTION,
      SOURCE_TYPE,
      BANK_ACCOUNT_ID,
      AS_OF_DATE,
      AMOUNT
      )
      VALUES
      (
      X_WORKSHEET_HEADER_ID,
      X_WORKSHEET_LINE_ID,
      X_LINE_DESCRIPTION,
      X_SOURCE_TYPE,
      X_BANK_ACCOUNT_ID,
      Trunc(X_AS_OF_DATE),
      l_amount
    );

Line: 464

        cep_standard.debug('<

Line: 471

      UPDATE CE_CP_WORKSHEET_USER_LINES
      SET
            SOURCE_TYPE = X_SOURCE_TYPE,
            AMOUNT = l_amount
      WHERE WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
      AND   WORKSHEET_LINE_ID   = X_WORKSHEET_LINE_ID
      AND   BANK_ACCOUNT_ID     = X_BANK_ACCOUNT_ID
      AND   Trunc(AS_OF_DATE)   = Trunc(X_AS_OF_DATE);

Line: 480

      UPDATE CE_CP_WORKSHEET_USER_LINES
      SET
            LINE_DESCRIPTION = X_LINE_DESCRIPTION
      WHERE WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
      AND   WORKSHEET_LINE_ID   = X_WORKSHEET_LINE_ID
      AND   Trunc(AS_OF_DATE)   = Trunc(X_AS_OF_DATE);

Line: 487

        cep_standard.debug('<

Line: 491

    	    cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.update_user_lines');

Line: 494

END UPDATE_USER_LINES;