1 PACKAGE WMS_TASK_ACTION_PVT AS
2 /* $Header: WMSTACPS.pls 120.0.12000000.1 2007/01/16 06:57:11 appldev ship $ */
3
4 TYPE query_type_table_type IS TABLE OF wms_saved_queries.query_type%TYPE INDEX BY BINARY_INTEGER;
5 TYPE field_name_table_type IS TABLE OF wms_saved_queries.field_name%TYPE INDEX BY BINARY_INTEGER;
6 TYPE field_value_table_type IS TABLE OF wms_saved_queries.field_value%TYPE INDEX BY BINARY_INTEGER;
7 TYPE organization_id_table_type IS TABLE OF wms_saved_queries.organization_id%TYPE INDEX BY BINARY_INTEGER;
8
9 PROCEDURE TASK_ACTION_CONC_PROG
10 (
11 errbuf OUT NOCOPY VARCHAR2,
12 retcode OUT NOCOPY VARCHAR2,
13 p_query_name IN VARCHAR2,
14 p_action IN VARCHAR2,
15 p_action_name IN VARCHAR2
16 );
17
18 PROCEDURE TASK_ACTION
19 (
20 p_query_name IN VARCHAR2,
21 p_action_name IN VARCHAR2,
22 p_action IN VARCHAR2,
23 p_online IN VARCHAR2,
24 x_rowcount OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_return_message OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE SUBMIT_REQUEST
30 (
31 p_query_name IN VARCHAR2,
32 p_action IN VARCHAR2,
33 p_action_name IN VARCHAR2,
34 x_request_id OUT NOCOPY NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_return_message OUT NOCOPY VARCHAR2
37 );
38
39 END WMS_TASK_ACTION_PVT;