3:
4: send_pipe_exception EXCEPTION;
5: directive_exception EXCEPTION;
6: v_row wms_carousel_configuration%ROWTYPE;
7: v_directive wms_carousel_directive_queue%ROWTYPE;
8: v_msg_components wms_msg_components%ROWTYPE;
9: v_xml_msg NUMBER := 1;
10: v_msg_with_delimiter NUMBER := 2;
11: v_msg_without_delimiter NUMBER := 3;
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:
74:
75: --
76: --
77: FUNCTION get_dependency_id (
78: p_directive IN wms_carousel_directive_queue%ROWTYPE,
79: p_dir_dep_seg_id IN VARCHAR2,
80: p_dir_dep_seq_id IN NUMBER
81: )
82: RETURN NUMBER;