1 PACKAGE IEU_UWQ_WORK_PANEL_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUVUWPS.pls 120.1 2011/08/01 10:57:45 spamujul ship $ */
3
4 PROCEDURE GET_UWQ_ACTION_DATA
5 (P_UWQ_ACTION_DATA IN VARCHAR2,
6 X_UWQ_ACTION_DATA_LIST OUT NOCOPY IEU_UWQ_WORK_PANEL_PUB.UWQ_ACTION_DATA_REC_LIST);
7
8 PROCEDURE CALL_WORK_ACTIONS
9 (p_resource_id IN NUMBER,
10 p_langauge IN VARCHAR2,
11 p_source_lang IN VARCHAR2,
12 p_action_key IN VARCHAR2,
13 p_action_proc IN VARCHAR2,
14 p_work_action_data IN IEU_UWQ_WORK_PANEL_PUB.uwq_action_data_rec_list,
15 x_uwq_action_list OUT NOCOPY IEU_UWQ_WORK_PANEL_PUB.uwq_action_rec_list,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 x_return_status OUT NOCOPY VARCHAR2);
19
20 TYPE v_work_notes_long_data IS RECORD (
21 REC_ID NUMBER(5), -- Increased the precision for Bug 12810201
22 NOTES_HEAD VARCHAR2(4000),
23 NOTES_DET LONG);
24 TYPE t_work_notes_long_data IS TABLE of v_work_notes_long_data
25 INDEX BY BINARY_INTEGER;
26
27 PROCEDURE CALL_INFO_ACTIONS (
28 p_resource_id IN NUMBER,
29 p_language IN VARCHAR2,
30 p_source_lang IN VARCHAR2,
31 p_action_key IN VARCHAR2,
32 p_exec_proc IN VARCHAR2,
33 p_workitem_data_list IN IEU_UWQ_WORK_PANEL_PUB.uwq_action_data_rec_list,
34 x_work_notes_long_list OUT NOCOPY IEU_UWQ_WORK_PANEL_PVT.t_work_notes_long_data,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE CALL_MESG_ACTIONS (
41 p_resource_id IN NUMBER,
42 p_language IN VARCHAR2,
43 p_source_lang IN VARCHAR2,
44 p_action_key IN VARCHAR2,
45 p_exec_proc IN VARCHAR2,
46 p_workitem_data_list IN IEU_UWQ_WORK_PANEL_PUB.uwq_action_data_rec_list,
47 x_work_mesg OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 END IEU_UWQ_WORK_PANEL_PVT;