APPS.IEC_G_REP_REPORTS_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_PARAM_NAME in VARCHAR2,
  X_PARAM_VALUE in VARCHAR2,
  X_REPORT_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_REPORTS_VALS
    where
					VALUE_ID = X_VALUE_ID
			and PARAM_NAME = X_PARAM_NAME
			and PARAM_VALUE = X_PARAM_VALUE
			and REPORT_ID = X_REPORT_ID;

Line: 27

insert into iec_g_rep_reports_vals
			            (  VALUE_ID,
			               PARAM_NAME,
			               PARAM_VALUE,
			               REPORT_ID,
			               CREATED_BY,
			               CREATION_DATE,
			               LAST_UPDATED_BY,
			               LAST_UPDATE_DATE,
			               LAST_UPDATE_LOGIN,
			               OBJECT_VERSION_NUMBER)
	          values(  X_VALUE_ID,
	                   X_PARAM_NAME,
	                   X_PARAM_VALUE,
	                   X_REPORT_ID,
										 X_CREATED_BY,
										 X_CREATION_DATE,
										 X_LAST_UPDATED_BY,
										 X_LAST_UPDATE_DATE,
										 X_LAST_UPDATE_LOGIN,
										 X_OBJECT_VERSION_NUMBER);

Line: 57

end INSERT_ROW;

Line: 66

  cursor c is select
      PARAM_NAME,
      PARAM_VALUE,
      REPORT_ID,
      OBJECT_VERSION_NUMBER
    from iec_g_rep_reports_vals
    where VALUE_ID = X_VALUE_ID
    for update of PARAM_NAME, PARAM_VALUE, REPORT_ID, OBJECT_VERSION_NUMBER  nowait;

Line: 80

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

Line: 97

procedure UPDATE_ROW (
  X_VALUE_ID in NUMBER,
  X_PARAM_NAME in VARCHAR2,
  X_PARAM_VALUE in VARCHAR2,
  X_REPORT_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_reports_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,
      PARAM_NAME          	= X_PARAM_NAME,
      PARAM_VALUE         	= X_PARAM_VALUE,
      REPORT_ID           	= X_REPORT_ID
  where
			VALUE_ID = X_VALUE_ID;

Line: 124

end UPDATE_ROW;

Line: 126

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

Line: 136

end DELETE_ROW;

Line: 153

  UPDATE_ROW (X_VALUE_ID, X_PARAM_NAME, X_PARAM_VALUE, X_REPORT_ID, USER_ID, SYSDATE, USER_ID, 0);

Line: 157

    INSERT_ROW (ROW_ID, X_VALUE_ID, X_PARAM_NAME, X_PARAM_VALUE, X_REPORT_ID, 0, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);