APPS.WMS_DEVHIST_HANDLER_PKG dependencies on WMS_DEVICE_REQUESTS_HIST

Line 49: CURSOR C IS SELECT rowid FROM wms_device_requests_hist

45: X_REASON_ID IN NUMBER,
46: X_XFER_LPN_ID IN NUMBER
47: ) is
48:
49: CURSOR C IS SELECT rowid FROM wms_device_requests_hist
50: WHERE request_id = X_REQUEST_ID
51: AND task_id = X_TASK_ID
52: AND business_event_id = x_business_event_id
53: AND task_summary = x_task_summary

Line 61: insert into WMS_DEVICE_REQUESTS_HIST (

57: BEGIN
58: IF (l_debug = 1) THEN
59: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
60: END IF;
61: insert into WMS_DEVICE_REQUESTS_HIST (
62: REQUEST_ID ,
63: TASK_ID ,
64: RELATION_ID,
65: SEQUENCE_ID,

Line 231: FROM wms_device_requests_hist

227: program_update_date,*/
228: device_status,
229: reason_id,
230: XFER_LPN_ID
231: FROM wms_device_requests_hist
232: WHERE ROWID = x_rowid
233: for update OF request_id,task_id,business_event_id,organization_id nowait;
234:
235: recinfo c%rowtype;

Line 384: update wms_device_requests_hist set

380: END IF;
381:
382: */
383:
384: update wms_device_requests_hist set
385: REQUEST_ID = X_REQUEST_ID,
386: TASK_ID = X_TASK_ID ,
387: relation_id = x_RELATION_ID,
388: sequence_id = X_SEQUENCE_ID,

Line 448: delete from wms_device_requests_hist

444: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
445: END IF;
446: */
447:
448: delete from wms_device_requests_hist
449: WHERE ROWID=X_ROWID;
450:
451: if (sql%notfound) then
452: raise no_data_found;

Line 503: FROM wms_device_requests_hist

499: task_id,
500: relation_id,
501: sequence_id,
502: business_event_id
503: FROM wms_device_requests_hist
504: WHERE REQUEST_ID = X_REQUEST_ID
505: AND TASK_ID = X_TASK_ID
506: --AND relation_id = x_relation_id
507: AND Nvl(sequence_id,-1) = Nvl(x_sequence_id,-1)

Line 539: update wms_device_requests_hist set

535: ELSE
536: IF (l_debug = 1) THEN
537: inv_log_util.trace('updating the child rec','WMS_DEVHIST_HANDLER_PKG',9);
538: END IF;
539: update wms_device_requests_hist set
540: task_type_id = X_task_type_id,
541: organization_id = X_organization_id,
542: subinventory_code = X_subinventory_code,
543: locator_id = X_locator_id,

Line 609: delete from wms_device_requests_hist

605: IF (l_debug = 1) THEN
606: inv_log_util.trace('Inside delete_CHILD_RECORDS','WMS_DEVHIST_HANDLER_PKG',9);
607: END IF;
608: */
609: delete from wms_device_requests_hist
610: WHERE REQUEST_ID = X_REQUEST_ID
611: AND TASK_ID = X_TASK_ID
612: AND relation_id = x_RELATION_ID
613: AND Nvl(sequence_id,-1) = Nvl(x_sequence_id,-1)

Line 641: FROM wms_device_requests_hist

637: organization_id,
638: lot_number,
639: lot_qty,
640: serial_number
641: FROM wms_device_requests_hist
642: WHERE ROWID = x_rowid
643: for update OF lot_number,lot_qty,serial_number nowait;
644:
645: recinfo c%rowtype;