APPS.CE_999_PKG SQL Statements

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

Line: 23

  select rowid
  from ce_999_interface_v
  where rowid = X_trx_rowid
  for update of trx_id nowait;

Line: 104

  update ce_999_interface_v
  set status  			= X_status,
      gl_date 			= X_gl_date,
      cleared_amount		= X_cleared_amount,
      cleared_date		= X_cleared_date,
      charges_amount		= X_charges_amount,
      error_amount		= X_errors_amount,
      exchange_rate_date	= X_exchange_date,
      exchange_rate_type	= X_exchange_type,
      exchange_rate		= X_exchange_rate
  where trx_id = X_trx_id;

Line: 155

  update ce_999_interface_v
  set status 		 	= X_status,
      gl_date 			= NULL,
      cleared_amount		= NULL,
      cleared_date		= NULL,
      charges_amount		= NULL,
      error_amount		= NULL,
      exchange_rate_date	= NULL,
      exchange_rate_type	= NULL,
      exchange_rate		= NULL
  where trx_id = X_trx_id;