APPS.BEVENT_DEVICE_PKG dependencies on WMS_BUS_EVENT_DEVICES

Line 39: from wms_bus_event_devices

35: x_verification_required IN VARCHAR2
36: ) is
37: cursor get_row is
38: select ROWID
39: from wms_bus_event_devices
40: where BUSINESS_EVENT_ID = X_BUSINESS_EVENT_ID
41: and DEVICE_ID = X_DEVICE_ID
42: and LEVEL_VALUE = X_LEVEL_VALUE
43: and ORGANIZATION_ID = X_ORGANIZATION_ID;

Line 45: insert into wms_bus_event_devices (

41: and DEVICE_ID = X_DEVICE_ID
42: and LEVEL_VALUE = X_LEVEL_VALUE
43: and ORGANIZATION_ID = X_ORGANIZATION_ID;
44: begin
45: insert into wms_bus_event_devices (
46: BUSINESS_EVENT_ID,
47: DEVICE_ID,
48: LEVEL_TYPE,
49: LEVEL_VALUE,

Line 179: from wms_bus_event_devices

175: ATTRIBUTE13,
176: ATTRIBUTE14,
177: attribute15,
178: VERIFICATION_REQUIRED
179: from wms_bus_event_devices
180: where ROWID = X_ROWID
181: for update of DEVICE_ID nowait;
182: recinfo get_lock%rowtype;
183:

Line 287: update wms_bus_event_devices

283: X_ATTRIBUTE15 in VARCHAR2,
284: x_verification_required IN VARCHAR2
285: ) is
286: begin
287: update wms_bus_event_devices
288: set
289: LEVEL_TYPE = X_LEVEL_TYPE,
290: LEVEL_VALUE = X_LEVEL_VALUE,
291: ORGANIZATION_ID = X_ORGANIZATION_ID,

Line 340: delete from wms_bus_event_devices

336: X_LEVEL_VALUE in number,
337: X_SUBINVENTORY_CODE in varchar)
338: is
339: begin
340: delete from wms_bus_event_devices
341: where BUSINESS_EVENT_ID = X_BUSINESS_EVENT_ID
342: and DEVICE_ID = X_DEVICE_ID
343: and ORGANIZATION_ID = X_ORGANIZATION_ID
344: and LEVEL_TYPE = X_LEVEL_TYPE