APPS.WMS_DEVICES_PKG dependencies on WMS_DEVICES_B

Line 46: cursor C is select ROWID from WMS_DEVICES_B

42: x_locator_id IN number,
43: x_multi_sign_on IN VARCHAR2,
44: x_message_template_id IN NUMBER --MHP
45: ) is
46: cursor C is select ROWID from WMS_DEVICES_B
47: where DEVICE_ID = X_DEVICE_ID ;
48: begin
49: insert into WMS_DEVICES_B (
50: DEVICE_ID,

Line 49: insert into WMS_DEVICES_B (

45: ) is
46: cursor C is select ROWID from WMS_DEVICES_B
47: where DEVICE_ID = X_DEVICE_ID ;
48: begin
49: insert into WMS_DEVICES_B (
50: DEVICE_ID,
51: DEVICE_TYPE_ID,
52: ENABLED_FLAG,
53: LOT_SERIAL_CAPABLE,

Line 238: from WMS_DEVICES_B

234: force_sign_on_flag,
235: locator_id,
236: multi_sign_on,
237: message_template_id --MHP
238: from WMS_DEVICES_B
239: where DEVICE_ID = X_DEVICE_ID
240: for update of DEVICE_ID nowait;
241: recinfo c%rowtype;
242:

Line 386: update WMS_DEVICES_B set

382: x_multi_sign_on IN VARCHAR2,
383: x_message_template_id IN NUMBER --MHP
384: ) is
385: begin
386: update WMS_DEVICES_B set
387: DEVICE_TYPE_ID = X_DEVICE_TYPE_ID,
388: ENABLED_FLAG = X_ENABLED_FLAG,
389: LOT_SERIAL_CAPABLE = X_LOT_SERIAL_CAPABLE,
390: INPUT_METHOD_ID = X_INPUT_METHOD_ID,

Line 454: delete from WMS_DEVICES_B

450: if (sql%notfound) then
451: raise no_data_found;
452: end if;
453:
454: delete from WMS_DEVICES_B
455: where DEVICE_ID = X_DEVICE_ID;
456:
457: if (sql%notfound) then
458: raise no_data_found;

Line 468: from WMS_DEVICES_B B

464: begin
465: delete from WMS_DEVICES_TL T
466: where not exists
467: (select NULL
468: from WMS_DEVICES_B B
469: where B.DEVICE_ID = T.DEVICE_ID
470: );
471:
472: update WMS_DEVICES_TL T set (