1 PACKAGE ams_task_pvt AUTHID CURRENT_USER AS
2 /* $Header: amsvtsks.pls 115.20 2002/11/22 02:26:49 jieli ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_TASK_PVT';
5 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
6 G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
7 G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
8
9
10 PROCEDURE create_task (
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
13 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
14 p_task_id IN NUMBER DEFAULT NULL,
15 p_task_name IN VARCHAR2,
16 p_task_type_id IN NUMBER DEFAULT NULL,
17 p_task_status_id IN NUMBER DEFAULT NULL,
18 p_task_priority_id IN NUMBER DEFAULT NULL,
19 p_owner_id IN NUMBER DEFAULT NULL,
20 p_owner_type_code IN VARCHAR2 DEFAULT NULL,
21 p_private_flag IN VARCHAR2 DEFAULT NULL,
22 p_planned_start_date IN DATE DEFAULT NULL,
23 p_planned_end_date IN DATE DEFAULT NULL,
24 p_actual_start_date IN DATE DEFAULT NULL,
25 p_actual_end_date IN DATE DEFAULT NULL,
26 p_source_object_type_code IN VARCHAR2 DEFAULT NULL,
27 p_source_object_id IN NUMBER DEFAULT NULL,
28 p_source_object_name IN VARCHAR2 DEFAULT NULL,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_task_id OUT NOCOPY NUMBER
33 );
34
35 PROCEDURE update_task (
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
38 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
39 p_object_version_number IN NUMBER ,
40 p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
41 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
42 p_task_type_id IN NUMBER DEFAULT NULL,
43 p_task_status_id IN NUMBER DEFAULT NULL,
44 p_task_priority_id IN NUMBER DEFAULT NULL,
45 p_owner_id IN NUMBER DEFAULT NULL,
46 p_private_flag IN VARCHAR2 DEFAULT NULL,
47 p_planned_start_date IN DATE DEFAULT NULL,
48 p_planned_end_date IN DATE DEFAULT NULL,
49 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
50 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
51 p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
52 p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
53 p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60
61 PROCEDURE delete_task (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
64 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
65 p_object_version_number IN NUMBER ,
66 p_task_id IN NUMBER DEFAULT NULL,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72
73 Procedure Create_Task_Assignment (
74 P_API_VERSION IN NUMBER ,
75 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
76 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
77 P_TASK_ID IN NUMBER ,
78 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
79 P_RESOURCE_ID IN NUMBER ,
80 P_ASSIGNMENT_STATUS_ID IN NUMBER ,
81 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
82 X_MSG_COUNT OUT NOCOPY NUMBER ,
83 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
84 X_TASK_ASSIGNMENT_ID OUT NOCOPY NUMBER ) ;
85
86
87 --Procedure to Delete Task Assignment
88
89
90 Procedure Delete_Task_Assignment
91 (P_API_VERSION IN NUMBER ,
92 P_INIT_MSG_LIST IN VARCHAR2 ,
93 P_COMMIT IN VARCHAR2 ,
94 p_object_version_number IN NUMBER ,
95 P_TASK_ASSIGNMENT_ID IN NUMBER ,
96 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97 X_MSG_COUNT OUT NOCOPY NUMBER ,
98 X_MSG_DATA OUT NOCOPY VARCHAR2 ) ;
99
100
101
102 --Procedure to Update Task Assignment
103
104
105 Procedure Update_Task_Assignment(
106 P_API_VERSION IN NUMBER ,
107 p_object_version_number IN NUMBER,
108 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT G_FALSE,
109 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE ,
110 P_TASK_ASSIGNMENT_ID IN NUMBER ,
111 P_TASK_ID IN NUMBER default fnd_api.g_miss_num,
112 P_RESOURCE_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
113 P_RESOURCE_ID IN NUMBER,
114 P_ASSIGNMENT_STATUS_ID IN NUMBER ,
115 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
116 X_MSG_COUNT OUT NOCOPY NUMBER ,
117 X_MSG_DATA OUT NOCOPY VARCHAR2) ;
118
119
120
121
122 -- Wrapper on JTF Workflow API
123
124 PROCEDURE start_task_workflow (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
127 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
128 p_task_id IN NUMBER,
129 p_old_assignee_code IN VARCHAR2 DEFAULT NULL,
130 p_old_assignee_id IN NUMBER DEFAULT NULL,
131 p_new_assignee_code IN VARCHAR2 DEFAULT NULL,
132 p_new_assignee_id IN NUMBER DEFAULT NULL,
133 p_old_owner_code IN VARCHAR2 DEFAULT NULL,
134 p_old_owner_id IN NUMBER DEFAULT NULL,
135 p_new_owner_code IN VARCHAR2 DEFAULT NULL,
136 p_new_owner_id IN NUMBER DEFAULT NULL,
137 p_task_attribute IN VARCHAR2 DEFAULT NULL,
138 p_old_value IN VARCHAR2 DEFAULT NULL,
139 p_new_value IN VARCHAR2 DEFAULT NULL,
140 p_event IN VARCHAR2,
141 p_wf_display_name IN VARCHAR2 DEFAULT NULL,
142 p_wf_process IN VARCHAR2
143 DEFAULT jtf_task_workflow_pkg.jtf_task_default_process,
144 p_wf_item_type IN VARCHAR2
145 DEFAULT jtf_task_workflow_pkg.jtf_task_item_type,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2 );
149
150 END ams_task_pvt; -- Package spec