APPS.IEC_G_REP_CONF_PARAMS_VALS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_VALUE_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_VALUE in VARCHAR2,
  X_PARAM_ID in NUMBER,
  X_CREATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
  cursor C is select ROWID
		from 	IEC_G_REP_CONF_PARAMS_VALS
    where
					VALUE_ID = X_VALUE_ID
			and NAME = X_NAME
			and VALUE = X_VALUE
			and PARAM_ID = X_PARAM_ID;

Line: 26

    insert into iec_g_rep_conf_params_vals
          (  VALUE_ID,
             NAME,
             VALUE,
             PARAM_ID,
             CREATED_BY,
             CREATION_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN,
             OBJECT_VERSION_NUMBER)
    values( X_VALUE_ID,
            X_NAME,
            X_VALUE,
            X_PARAM_ID,
					  X_CREATED_BY,
					  X_CREATION_DATE,
					  X_LAST_UPDATED_BY,
					  X_LAST_UPDATE_DATE,
					  X_LAST_UPDATE_LOGIN,
					  X_OBJECT_VERSION_NUMBER);

Line: 56

end INSERT_ROW;

Line: 65

  cursor c is select
      NAME,
      VALUE,
      PARAM_ID,
      OBJECT_VERSION_NUMBER
    from IEC_G_REP_CONF_PARAMS_VALS
    where VALUE_ID = X_VALUE_ID
    for update of NAME, VALUE, PARAM_ID,OBJECT_VERSION_NUMBER  nowait;

Line: 79

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 96

procedure UPDATE_ROW (
  X_VALUE_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_VALUE in VARCHAR2,
  X_PARAM_ID in NUMBER,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
begin

	update iec_g_rep_conf_params_vals
	set LAST_UPDATED_BY     	= X_LAST_UPDATED_BY,
	    LAST_UPDATE_DATE    	= X_LAST_UPDATE_DATE,
	    LAST_UPDATE_LOGIN   	= X_LAST_UPDATE_LOGIN,
      OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
	    NAME                	= X_NAME,
	    VALUE               	= X_VALUE,
	    PARAM_ID            	= X_PARAM_ID
	where VALUE_ID = X_VALUE_ID;

Line: 122

end UPDATE_ROW;

Line: 124

procedure DELETE_ROW (
  X_VALUE_ID in NUMBER
) is
begin
  delete from iec_g_rep_conf_params_vals
  where VALUE_ID = X_VALUE_ID;

Line: 134

end DELETE_ROW;

Line: 151

  UPDATE_ROW (X_VALUE_ID, X_NAME, X_VALUE, X_PARAM_ID, USER_ID, SYSDATE, USER_ID, 0);

Line: 155

    INSERT_ROW (ROW_ID, X_VALUE_ID, X_NAME, X_VALUE, X_PARAM_ID, 0, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);