APPS.BEVENT_DEVICE_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID 			         IN OUT NOCOPY VARCHAR2,
  X_BUSINESS_EVENT_ID  			in NUMBER,
  X_DEVICE_ID	 			in NUMBER,
  X_LEVEL_TYPE		 		in NUMBER,
  X_LEVEL_VALUE			 	in NUMBER,
  X_ORGANIZATION_ID 			in NUMBER,
  X_SUBINVENTORY_CODE			in VARCHAR2,
  X_AUTO_ENABLED_FLAG                   in VARCHAR2,
  X_COMMENTS                            in VARCHAR2,
  X_ENABLED_FLAG                        in VARCHAR2,
  X_CREATION_DATE 			in DATE,
  X_CREATED_BY 				in NUMBER,
  X_LAST_UPDATE_DATE 			in DATE,
  X_LAST_UPDATED_BY 			in NUMBER,
  X_LAST_UPDATE_LOGIN 			in NUMBER,
  X_ATTRIBUTE_CATEGORY 			in VARCHAR2,
  X_ATTRIBUTE1 				in VARCHAR2,
  X_ATTRIBUTE2 				in VARCHAR2,
  X_ATTRIBUTE3 				in VARCHAR2,
  X_ATTRIBUTE4 				in VARCHAR2,
  X_ATTRIBUTE5 				in VARCHAR2,
  X_ATTRIBUTE6 				in VARCHAR2,
  X_ATTRIBUTE7 				in VARCHAR2,
  X_ATTRIBUTE8 				in VARCHAR2,
  X_ATTRIBUTE9 				in VARCHAR2,
  X_ATTRIBUTE10 			in VARCHAR2,
  X_ATTRIBUTE11 			in VARCHAR2,
  X_ATTRIBUTE12 			in VARCHAR2,
  X_ATTRIBUTE13 			in VARCHAR2,
  X_ATTRIBUTE14 			in VARCHAR2,
  X_ATTRIBUTE15 			in VARCHAR2,
  x_verification_required               IN VARCHAR2
) is
  cursor get_row is
    select ROWID
    from  wms_bus_event_devices
    where BUSINESS_EVENT_ID 	= X_BUSINESS_EVENT_ID
    and   DEVICE_ID 		= X_DEVICE_ID
    and   LEVEL_VALUE 		= X_LEVEL_VALUE
    and   ORGANIZATION_ID 	= X_ORGANIZATION_ID;

Line: 45

  insert into wms_bus_event_devices (
    BUSINESS_EVENT_ID,
    DEVICE_ID,
    LEVEL_TYPE,
    LEVEL_VALUE,
    ORGANIZATION_ID,
    SUBINVENTORY_CODE,
    AUTO_ENABLED_FLAG,
    COMMENTS,
    ENABLED_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    attribute15,
    VERIFICATION_REQUIRED)
values (
    X_BUSINESS_EVENT_ID,
    X_DEVICE_ID,
    X_LEVEL_TYPE,
    X_LEVEL_VALUE,
    X_ORGANIZATION_ID,
    X_SUBINVENTORY_CODE,
    X_AUTO_ENABLED_FLAG,
    X_COMMENTS,
    X_ENABLED_FLAG,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    x_attribute15,
    X_VERIFICATION_REQUIRED );

Line: 117

end insert_row;

Line: 152

  select
   	BUSINESS_EVENT_ID,
  	DEVICE_ID,
  	LEVEL_TYPE,
  	LEVEL_VALUE,
  	ORGANIZATION_ID,
  	SUBINVENTORY_CODE,
  	AUTO_ENABLED_FLAG,
  	COMMENTS,
  	ENABLED_FLAG,
  	ATTRIBUTE_CATEGORY,
  	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
        attribute15,
        VERIFICATION_REQUIRED
 from wms_bus_event_devices
 where ROWID = X_ROWID
 for update of DEVICE_ID nowait;

Line: 189

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

Line: 255

procedure UPDATE_ROW (
  X_BUSINESS_EVENT_ID  			in NUMBER,
  X_DEVICE_ID	 			in NUMBER,
  X_LEVEL_TYPE		 		in NUMBER,
  X_LEVEL_VALUE			 	in NUMBER,
  X_ORGANIZATION_ID 			in NUMBER,
  X_SUBINVENTORY_CODE			in VARCHAR2,
  X_AUTO_ENABLED_FLAG                   in VARCHAR2,
  X_COMMENTS                            in VARCHAR2,
  X_ENABLED_FLAG                        in VARCHAR2,
  X_LAST_UPDATE_DATE 			in DATE,
  X_LAST_UPDATED_BY 			in NUMBER,
  X_LAST_UPDATE_LOGIN 			in NUMBER,
  X_ATTRIBUTE_CATEGORY 			in VARCHAR2,
  X_ATTRIBUTE1 				in VARCHAR2,
  X_ATTRIBUTE2 				in VARCHAR2,
  X_ATTRIBUTE3 				in VARCHAR2,
  X_ATTRIBUTE4 				in VARCHAR2,
  X_ATTRIBUTE5 				in VARCHAR2,
  X_ATTRIBUTE6 				in VARCHAR2,
  X_ATTRIBUTE7 				in VARCHAR2,
  X_ATTRIBUTE8 				in VARCHAR2,
  X_ATTRIBUTE9 				in VARCHAR2,
  X_ATTRIBUTE10 			in VARCHAR2,
  X_ATTRIBUTE11 			in VARCHAR2,
  X_ATTRIBUTE12 			in VARCHAR2,
  X_ATTRIBUTE13 			in VARCHAR2,
  X_ATTRIBUTE14 			in VARCHAR2,
  X_ATTRIBUTE15 			in VARCHAR2,
  x_verification_required               IN VARCHAR2
) is
begin
update wms_bus_event_devices
set
  LEVEL_TYPE		= X_LEVEL_TYPE,
  LEVEL_VALUE		= X_LEVEL_VALUE,
  ORGANIZATION_ID 	= X_ORGANIZATION_ID,
  SUBINVENTORY_CODE	= X_SUBINVENTORY_CODE,
  AUTO_ENABLED_FLAG     = X_AUTO_ENABLED_FLAG,
  COMMENTS              = X_COMMENTS,
  ENABLED_FLAG          = X_ENABLED_FLAG,
  LAST_UPDATE_DATE 	= X_LAST_UPDATE_DATE,
  LAST_UPDATED_BY 	= X_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN 	= X_LAST_UPDATE_LOGIN,
  ATTRIBUTE_CATEGORY 	= X_ATTRIBUTE_CATEGORY,
  ATTRIBUTE1 		= X_ATTRIBUTE1,
  ATTRIBUTE2 		= X_ATTRIBUTE2,
  ATTRIBUTE3 		= X_ATTRIBUTE3,
  ATTRIBUTE4 		= X_ATTRIBUTE4,
  ATTRIBUTE5 		= X_ATTRIBUTE5,
  ATTRIBUTE6 		= X_ATTRIBUTE6,
  ATTRIBUTE7 		= X_ATTRIBUTE7,
  ATTRIBUTE8 		= X_ATTRIBUTE8,
  ATTRIBUTE9 		= X_ATTRIBUTE9,
  ATTRIBUTE10 		= X_ATTRIBUTE10,
  ATTRIBUTE11 		= X_ATTRIBUTE11,
  ATTRIBUTE12 		= X_ATTRIBUTE12,
  ATTRIBUTE13 		= X_ATTRIBUTE13,
  ATTRIBUTE14 		= X_ATTRIBUTE14,
  ATTRIBUTE15 		= x_attribute15,
  verification_required = x_VERIFICATION_REQUIRED
where BUSINESS_EVENT_ID = X_BUSINESS_EVENT_ID
  and DEVICE_ID 	= X_DEVICE_ID
  and ORGANIZATION_ID 	= X_ORGANIZATION_ID;

Line: 327

end UPDATE_ROW;

Line: 331

procedure DELETE_ROW (
  X_BUSINESS_EVENT_ID 			in NUMBER,
  X_DEVICE_ID 				in NUMBER,
  X_ORGANIZATION_ID 			in NUMBER,
  X_LEVEL_TYPE				in number,
  X_LEVEL_VALUE				in number,
  X_SUBINVENTORY_CODE			in varchar)
is
begin
  delete from wms_bus_event_devices
  where BUSINESS_EVENT_ID 		= X_BUSINESS_EVENT_ID
  and DEVICE_ID 			= X_DEVICE_ID
  and ORGANIZATION_ID 			= X_ORGANIZATION_ID
  and LEVEL_TYPE			= X_LEVEL_TYPE
  and LEVEL_VALUE			= X_LEVEL_VALUE
  and nvl(SUBINVENTORY_CODE,'aaa') 	= nvl(X_SUBINVENTORY_CODE,'aaa');

Line: 353

end DELETE_ROW;