APPS.IEC_G_REP_CONF_VALIDATORS_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_VALIDATOR_ID in NUMBER,
  X_VALIDATOR_CLASS in VARCHAR2,
  X_FORMAT in VARCHAR2,
  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_vldtrs
    where
					VALIDATOR_ID = X_VALIDATOR_ID
			and VALIDATOR_CLASS = X_VALIDATOR_CLASS
			and FORMAT = X_FORMAT;

Line: 25

    insert into iec_g_rep_conf_vldtrs
           ( VALIDATOR_ID,
             VALIDATOR_CLASS,
             FORMAT,
             CREATED_BY,
             CREATION_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN,
             OBJECT_VERSION_NUMBER)
    values( X_VALIDATOR_ID,
            X_VALIDATOR_CLASS,
            X_FORMAT,
					  X_CREATED_BY,
					  X_CREATION_DATE,
					  X_LAST_UPDATED_BY,
					  X_LAST_UPDATE_DATE,
					  X_LAST_UPDATE_LOGIN,
					  X_OBJECT_VERSION_NUMBER);

Line: 53

end INSERT_ROW;

Line: 61

  cursor c is select
      VALIDATOR_CLASS,
      FORMAT,
      OBJECT_VERSION_NUMBER
    from iec_g_rep_conf_vldtrs
    where VALIDATOR_ID = X_VALIDATOR_ID
    for update of VALIDATOR_CLASS, FORMAT, OBJECT_VERSION_NUMBER  nowait;

Line: 74

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

Line: 90

procedure UPDATE_ROW (
  X_VALIDATOR_ID in NUMBER,
  X_VALIDATOR_CLASS in VARCHAR2,
  X_FORMAT in VARCHAR2,
  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_vldtrs
	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,
	    VALIDATOR_CLASS      	= X_VALIDATOR_CLASS,
	    FORMAT             		= X_FORMAT
	where VALIDATOR_ID = X_VALIDATOR_ID;

Line: 114

end UPDATE_ROW;

Line: 116

procedure DELETE_ROW (
  X_VALIDATOR_ID in NUMBER
) is
begin
  delete from iec_g_rep_conf_vldtrs
  where VALIDATOR_ID = X_VALIDATOR_ID;

Line: 126

end DELETE_ROW;

Line: 142

  UPDATE_ROW (X_VALIDATOR_ID, X_VALIDATOR_CLASS, X_FORMAT, USER_ID, SYSDATE, USER_ID, 0);

Line: 146

    INSERT_ROW (ROW_ID, X_VALIDATOR_ID, X_VALIDATOR_CLASS, X_FORMAT, USER_ID, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);