1 PACKAGE IEU_UWQ_OA AUTHID CURRENT_USER AS
2 /* $Header: IEUUWQOAS.pls 120.1.12020000.1 2013/01/17 11:02:44 rgandhi noship $ */
3
4 /* TODO enter package declarations (types, exceptions, methods etc) here */
5 PROCEDURE DISTRIBUTE_AND_DELIVER_WR_ITEM(
6 p_api_version IN NUMBER,
7 p_resource_id IN NUMBER,
8 p_language IN VARCHAR2,
9 p_source_lang IN VARCHAR2,
10 p_dist_from_extra_where_clause IN VARCHAR2,
11 p_dist_to_extra_where_clause IN VARCHAR2,
12 p_bindvar_from_list IN VARCHAR2,
13 p_bindvar_to_list IN VARCHAR2,
14 x_uwqm_workitem_data OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2) ;
18
19
20
21 type string_array IS varray(100) OF VARCHAR2(200);
22
23
24 FUNCTION split_string(
25 str IN VARCHAR2,
26 delimiter IN CHAR DEFAULT ',')
27 RETURN string_array ;
28
29
30 PROCEDURE DISTRIBUTE_WR_ITEMS(
31 p_api_version IN NUMBER,
32 p_resource_id IN NUMBER,
33 p_language IN VARCHAR2,
34 p_source_lang IN VARCHAR2,
35 p_num_of_dist_items IN NUMBER, -- Number of Items Requested to be Distributed
36 p_extra_where_clause IN VARCHAR2,
37 p_bindvar_list IN VARCHAR2,
38 x_uwqm_workitem_data OUT NOCOPY VARCHAR2,
39 x_num_of_items_distributed OUT NOCOPY NUMBER, -- Number of Items finally Distributed
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44
45 PROCEDURE CALL_WORK_ACTIONS(
46 p_resource_id IN NUMBER,
47 p_langauge IN VARCHAR2,
48 p_source_lang IN VARCHAR2,
49 p_action_key IN VARCHAR2,
50 p_action_proc IN VARCHAR2,
51 p_work_action_data IN VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2);
55
56 END IEU_UWQ_OA;