15: -- Cursor for all tasks of the request
16: CURSOR c_request_tasks (p_request_id IN NUMBER)
17: IS
18: SELECT *
19: FROM wms_device_requests_wcsv
20: WHERE request_id = p_request_id
21: ORDER BY sequence_id;
22:
23: --
48:
49: --
50: --
51: PROCEDURE get_directive_config (
52: p_task IN wms_device_requests_wcsv%ROWTYPE,
53: p_directive IN OUT NOCOPY wms_carousel_directive_queue%ROWTYPE,
54: p_dir_dep_seg_id OUT NOCOPY VARCHAR2,
55: p_dir_dep_seq_id OUT NOCOPY NUMBER
56: );
57:
58: --
59: --
60: PROCEDURE add_directive_to_queue (
61: p_task IN wms_device_requests_wcsv%ROWTYPE,
62: p_directive IN OUT NOCOPY wms_carousel_directive_queue%ROWTYPE,
63: p_dir_dep_seg_id IN VARCHAR2,
64: p_dir_dep_seq_id IN NUMBER
65: );
66:
67: --
68: --
69: PROCEDURE build_directive_string (
70: p_task IN wms_device_requests_wcsv%ROWTYPE,
71: p_query IN VARCHAR2,
72: p_result OUT NOCOPY VARCHAR2
73: );
74: