[Home] [Help]
PACKAGE: APPS.IEU_WPACTIONS_PVT
Source
1 PACKAGE IEU_WPACTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUTKWPS.pls 115.10 2003/10/08 16:48:08 fsuthar noship $ */
3
4
5 -- Define some constants for use in our procedure
6 G_PKG_NAME CONSTANT VARCHAR2(30):='IEU_WPACTIONS_PVT';
7 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
8 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10 G_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11 G_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
12 G_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
13 G_OPEN_SQBR CONSTANT VARCHAR2(1) :='[';
14 G_CLOSE_SQBR CONSTANT VARCHAR2(1) :=']';
15 G_YES CONSTANT VARCHAR2(1) := JTF_TASK_UTL.G_YES_CHAR;
16
17
18
19 -- methinks, only ID is sufficient;
20 TYPE task_rec IS RECORD (
21 ID jtf_tasks_b.task_id%TYPE,
22 TASK_NAME jtf_tasks_tl.task_name%TYPE,
23 TYPE_NAME jtf_task_types_tl.name%TYPE,
24 PRIORITY_NAME jtf_task_priorities_tl.name%TYPE,
25 STATUS_NAME jtf_task_statuses_tl.name%TYPE,
26 SOURCE_ID jtf_tasks_b.source_object_id%type,
27 SOURCE_TYPE_CODE jtf_tasks_b.source_object_type_code%type,
28 SCHED_START DATE,
29 SCHED_END DATE,
30 PLAN_START DATE,
31 PLAN_END DATE,
32 ACT_START DATE,
33 ACT_END DATE,
34 DESCR jtf_tasks_tl.description%TYPE,
35 OWNER_ID jtf_tasks_b.owner_id%TYPE,
36 OWNER_TYPE_CODE jtf_tasks_b.owner_type_code%TYPE,
37 OBJECT_VERSION_NUMBER jtf_tasks_b.object_version_number%TYPE
38 );
39
40 TYPE task_rec_tbl IS TABLE OF task_rec INDEX BY BINARY_INTEGER;
41
42
43 PROCEDURE WP_TASK
44 ( P_RESOURCE_ID IN NUMBER,
45 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
46 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
47 P_ACTION_KEY IN VARCHAR2,
48 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
49 P_ACTION_TYPE IN Varchar2,
50 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
51 X_MSG_COUNT OUT NOCOPY NUMBER,
52 X_MSG_DATA OUT NOCOPY VARCHAR2,
53 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
54
55 PROCEDURE UPDATE_TASK
56 ( P_RESOURCE_ID IN NUMBER,
57 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
58 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
59 P_ACTION_KEY IN VARCHAR2,
60 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
61 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 X_MSG_DATA OUT NOCOPY VARCHAR2,
64 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
65
66 PROCEDURE CLOSE_TASK
67 ( P_RESOURCE_ID IN NUMBER,
68 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
69 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
70 P_ACTION_KEY IN VARCHAR2,
71 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
72 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
73 X_MSG_COUNT OUT NOCOPY NUMBER,
74 X_MSG_DATA OUT NOCOPY VARCHAR2,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
76
77
78 PROCEDURE REASSIGN_TASK
79 ( P_RESOURCE_ID IN NUMBER,
80 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
81 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
82 P_ACTION_KEY IN VARCHAR2,
83 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
84 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2,
87 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
88
89 PROCEDURE RESCHEDULE_TASK
90 ( P_RESOURCE_ID IN NUMBER,
91 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
92 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
93 P_ACTION_KEY IN VARCHAR2,
94 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
95 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
96 X_MSG_COUNT OUT NOCOPY NUMBER,
97 X_MSG_DATA OUT NOCOPY VARCHAR2,
98 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
99
100 PROCEDURE TRANSFER_TASK_OWNER_TASK
101 ( P_RESOURCE_ID IN NUMBER,
102 P_LANGUAGE IN VARCHAR2 DEFAULT NULL,
103 P_SOURCE_LANG IN VARCHAR2 DEFAULT NULL,
104 P_ACTION_KEY IN VARCHAR2,
105 P_ACTION_INPUT_DATA IN SYSTEM.ACTION_INPUT_DATA_NST,
106 X_UWQ_ACTION_LIST OUT NOCOPY SYSTEM.IEU_UWQ_WORK_ACTIONS_NST,
107 X_MSG_COUNT OUT NOCOPY NUMBER,
108 X_MSG_DATA OUT NOCOPY VARCHAR2,
109 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
110
111
112 END IEU_WPACTIONS_PVT;