1 PACKAGE JTF_TASK_AUDITS_PVT AUTHID CURRENT_USER as
2 /* $Header: jtftktus.pls 120.2 2005/08/08 07:04:40 sbarat ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
5
6
7 PROCEDURE Process_task_audits
8 (P_api_version IN NUMBER ,
9 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
10 P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
11 P_Object_Version_Number IN NUMBER DEFAULT 1 ,
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 x_msg_count OUT NOCOPY NUMBER ,
14 x_msg_data OUT NOCOPY VARCHAR2 ,
15 P_OLD_BILLABLE_FLAG IN VARCHAR2 DEFAULT NULL ,
16 P_OLD_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL ,
17 P_OLD_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL ,
18 P_OLD_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL ,
19 P_OLD_ESC_FLAG IN VARCHAR2 DEFAULT NULL ,
20 P_OLD_HOLIDAY_FLAG IN VARCHAR2 DEFAULT NULL ,
21 P_OLD_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL ,
22 P_OLD_MILESTONE_FLAG IN VARCHAR2 DEFAULT NULL ,
23 P_OLD_MULTI_BOOKED_FLAG IN VARCHAR2 DEFAULT NULL ,
24 P_OLD_NOT_FLAG IN VARCHAR2 DEFAULT NULL ,
25 P_OLD_PALM_FLAG IN VARCHAR2 DEFAULT NULL ,
26 P_OLD_PRIVATE_FLAG IN VARCHAR2 DEFAULT NULL ,
27 P_OLD_PUBLISH_FLAG IN VARCHAR2 DEFAULT NULL ,
28 P_OLD_RESTRICT_CLOSURE_FLAG IN VARCHAR2 DEFAULT NULL ,
29 P_OLD_WINCE_FLAG IN VARCHAR2 DEFAULT NULL ,
30 P_OLD_SOFT_BOUND_FLAG IN VARCHAR2 DEFAULT NULL ,
31 P_NEW_BILLABLE_FLAG IN VARCHAR2 DEFAULT NULL ,
32 P_NEW_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL ,
33 P_NEW_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL ,
34 P_NEW_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL ,
35 P_NEW_ESC_FLAG IN VARCHAR2 DEFAULT NULL ,
36 P_NEW_HOLIDAY_FLAG IN VARCHAR2 DEFAULT NULL ,
37 P_NEW_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL ,
38 P_NEW_MILESTONE_FLAG IN VARCHAR2 DEFAULT NULL ,
39 P_NEW_MULTI_BOOKED_FLAG IN VARCHAR2 DEFAULT NULL ,
40 P_NEW_NOT_FLAG IN VARCHAR2 DEFAULT NULL ,
41 P_NEW_PALM_FLAG IN VARCHAR2 DEFAULT NULL ,
42 P_NEW_PRIVATE_FLAG IN VARCHAR2 DEFAULT NULL ,
43 P_NEW_PUBLISH_FLAG IN VARCHAR2 DEFAULT NULL ,
44 P_NEW_RESTRICT_CLOSURE_FLAG IN VARCHAR2 DEFAULT NULL ,
45 P_NEW_WINCE_FLAG IN VARCHAR2 DEFAULT NULL ,
46 P_NEW_SOFT_BOUND_FLAG IN VARCHAR2 DEFAULT NULL ,
47 P_NEW_ACTUAL_EFFORT IN NUMBER DEFAULT NULL ,
48 P_NEW_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
49 P_NEW_ACTUAL_END_DATE IN DATE DEFAULT NULL ,
50 P_NEW_ACTUAL_START_DATE IN DATE DEFAULT NULL ,
51 P_NEW_ADDRESS_ID IN NUMBER DEFAULT NULL ,
52 P_NEW_ASSIGNED_BY_ID IN NUMBER DEFAULT NULL ,
53 P_NEW_BOUND_MODE_CODE IN VARCHAR2 DEFAULT NULL ,
54 P_NEW_COSTS IN NUMBER DEFAULT NULL ,
55 P_NEW_CURRENCY_CODE IN VARCHAR2 DEFAULT NULL ,
56 P_NEW_CUSTOMER_ID IN NUMBER DEFAULT NULL ,
57 P_NEW_CUST_ACCOUNT_ID IN NUMBER DEFAULT NULL ,
58 P_NEW_DURATION IN NUMBER DEFAULT NULL ,
59 P_NEW_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
60 P_NEW_ESC_OWNER_ID IN NUMBER DEFAULT NULL ,
61 P_NEW_ESC_TERR_ID IN NUMBER DEFAULT NULL ,
62 P_NEW_NOT_PERIOD IN NUMBER DEFAULT NULL ,
63 P_NEW_NOT_PERIOD_UOM IN VARCHAR2 DEFAULT NULL ,
64 P_NEW_ORG_ID IN NUMBER DEFAULT NULL ,
65 P_NEW_OWNER_ID IN NUMBER DEFAULT NULL ,
66 P_NEW_OWNER_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
67 P_NEW_PARENT_TASK_ID IN NUMBER DEFAULT NULL ,
68 P_NEW_PER_COMPLETE IN NUMBER DEFAULT NULL ,
69 P_NEW_PLANNED_EFFORT IN NUMBER DEFAULT NULL ,
70 P_NEW_PLANNED_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
71 P_NEW_PLANNED_END_DATE IN DATE DEFAULT NULL ,
72 P_NEW_PLANNED_START_DATE IN DATE DEFAULT NULL ,
73 P_NEW_REASON_CODE IN VARCHAR2 DEFAULT NULL ,
74 P_NEW_RECURRENCE_RULE_ID IN NUMBER DEFAULT NULL ,
75 P_NEW_SCHED_END_DATE IN DATE DEFAULT NULL ,
76 P_NEW_SCHED_START_DATE IN DATE DEFAULT NULL ,
77 P_NEW_SRC_OBJ_ID IN NUMBER DEFAULT NULL ,
78 P_NEW_SRC_OBJ_NAME IN VARCHAR2 DEFAULT NULL ,
79 P_NEW_SRC_OBJ_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
80 P_NEW_TASK_PRIORITY_ID IN NUMBER DEFAULT NULL ,
81 P_NEW_TASK_STATUS_ID IN NUMBER DEFAULT NULL ,
82 P_NEW_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
83 P_NEW_TIMEZONE_ID IN NUMBER DEFAULT NULL ,
84 P_NEW_WORKFLOW_PROCESS_ID IN NUMBER DEFAULT NULL ,
85 P_NOT_CHAN_FLAG IN VARCHAR2 DEFAULT NULL ,
86 P_OLD_ACTUAL_EFFORT IN NUMBER DEFAULT NULL ,
87 P_OLD_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
88 P_OLD_ACTUAL_END_DATE IN DATE DEFAULT NULL ,
89 P_OLD_ACTUAL_START_DATE IN DATE DEFAULT NULL ,
90 P_OLD_ADDRESS_ID IN NUMBER DEFAULT NULL ,
91 P_OLD_ASSIGNED_BY_ID IN NUMBER DEFAULT NULL ,
92 P_OLD_BOUND_MODE_CODE IN VARCHAR2 DEFAULT NULL ,
93 P_OLD_COSTS IN NUMBER DEFAULT NULL ,
94 P_OLD_CURRENCY_CODE IN VARCHAR2 DEFAULT NULL ,
95 P_OLD_CUSTOMER_ID IN NUMBER DEFAULT NULL ,
96 P_OLD_CUST_ACCOUNT_ID IN NUMBER DEFAULT NULL ,
97 P_OLD_DURATION IN NUMBER DEFAULT NULL ,
98 P_OLD_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
99 P_OLD_ESC_OWNER_ID IN NUMBER DEFAULT NULL ,
100 P_OLD_ESC_TERR_ID IN NUMBER DEFAULT NULL ,
101 P_OLD_NOT_PERIOD IN NUMBER DEFAULT NULL ,
102 P_OLD_NOT_PERIOD_UOM IN VARCHAR2 DEFAULT NULL ,
103 P_OLD_ORG_ID IN NUMBER DEFAULT NULL ,
104 P_OLD_OWNER_ID IN NUMBER DEFAULT NULL ,
105 P_OLD_OWNER_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
106 P_OLD_PARENT_TASK_ID IN NUMBER DEFAULT NULL ,
107 P_OLD_PER_COMPLETE IN NUMBER DEFAULT NULL ,
108 P_OLD_PLANNED_EFFORT IN NUMBER DEFAULT NULL ,
109 P_OLD_PLANNED_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
110 P_OLD_PLANNED_END_DATE IN DATE DEFAULT NULL ,
111 P_OLD_PLANNED_START_DATE IN DATE DEFAULT NULL ,
112 P_OLD_REASON_CODE IN VARCHAR2 DEFAULT NULL ,
113 P_OLD_RECURRENCE_RULE_ID IN NUMBER DEFAULT NULL ,
114 P_OLD_SCHED_END_DATE IN DATE DEFAULT NULL ,
115 P_OLD_SCHED_START_DATE IN DATE DEFAULT NULL ,
116 P_OLD_SRC_OBJ_ID IN NUMBER DEFAULT NULL ,
117 P_OLD_SRC_OBJ_NAME IN VARCHAR2 DEFAULT NULL ,
118 P_OLD_SRC_OBJ_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
119 P_OLD_TASK_PRIORITY_ID IN NUMBER DEFAULT NULL ,
120 P_OLD_TASK_STATUS_ID IN NUMBER DEFAULT NULL ,
121 P_OLD_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
122 P_OLD_TIMEZONE_ID IN NUMBER DEFAULT NULL ,
123 P_OLD_WORKFLOW_PROCESS_ID IN NUMBER DEFAULT NULL ,
124 P_TASK_ID IN NUMBER ,
125 P_NEW_DESCRIPTION IN VARCHAR2 DEFAULT NULL ,
126 P_NEW_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
127 P_OLD_DESCRIPTION IN VARCHAR2 DEFAULT NULL ,
128 P_OLD_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
129 P_OLD_ESCALATION_LEVEL IN VARCHAR2 DEFAULT NULL ,
130 P_NEW_ESCALATION_LEVEL IN VARCHAR2 DEFAULT NULL ,
131 P_OLD_OWNER_TERRITORY_ID IN NUMBER DEFAULT NULL ,
132 P_NEW_OWNER_TERRITORY_ID IN NUMBER DEFAULT NULL ,
133 P_OLD_DATE_SELECTED IN VARCHAR2 DEFAULT NULL ,
134 P_NEW_DATE_SELECTED IN VARCHAR2 DEFAULT NULL ,
135 P_OLD_LOCATION_ID IN NUMBER DEFAULT NULL ,
136 P_NEW_LOCATION_ID IN NUMBER DEFAULT NULL ,
137 x_task_audit_id OUT NOCOPY NUMBER
138 ) ;
139
140
141
142 PROCEDURE create_task_audits
143 (P_api_version IN NUMBER ,
144 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
145 P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
146 P_Object_Version_Number IN NUMBER DEFAULT 1 ,
147 P_TASK_ID IN NUMBER ,
148 P_NEW_BILLABLE_FLAG IN VARCHAR2 DEFAULT NULL ,
149 P_NEW_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL ,
150 P_NEW_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL ,
151 P_NEW_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL ,
152 P_NEW_ESC_FLAG IN VARCHAR2 DEFAULT NULL ,
153 P_NEW_HOLIDAY_FLAG IN VARCHAR2 DEFAULT NULL ,
154 P_NEW_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL ,
155 P_NEW_MILESTONE_FLAG IN VARCHAR2 DEFAULT NULL ,
156 P_NEW_MULTI_BOOKED_FLAG IN VARCHAR2 DEFAULT NULL ,
157 P_NEW_NOT_FLAG IN VARCHAR2 DEFAULT NULL ,
158 P_NEW_PALM_FLAG IN VARCHAR2 DEFAULT NULL ,
159 P_NEW_PRIVATE_FLAG IN VARCHAR2 DEFAULT NULL ,
160 P_NEW_PUBLISH_FLAG IN VARCHAR2 DEFAULT NULL ,
161 P_NEW_RESTRICT_CLOSURE_FLAG IN VARCHAR2 DEFAULT NULL ,
162 P_NEW_WINCE_FLAG IN VARCHAR2 DEFAULT NULL ,
163 P_NEW_SOFT_BOUND_FLAG IN VARCHAR2 DEFAULT NULL ,
164 P_NEW_ACTUAL_EFFORT IN NUMBER DEFAULT NULL ,
165 P_NEW_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
166 P_NEW_ACTUAL_END_DATE IN DATE DEFAULT NULL ,
167 P_NEW_ACTUAL_START_DATE IN DATE DEFAULT NULL ,
168 P_NEW_ADDRESS_ID IN NUMBER DEFAULT NULL ,
169 P_NEW_ASSIGNED_BY_ID IN NUMBER DEFAULT NULL ,
170 P_NEW_BOUND_MODE_CODE IN VARCHAR2 DEFAULT NULL ,
171 P_NEW_COSTS IN NUMBER DEFAULT NULL ,
172 P_NEW_CURRENCY_CODE IN VARCHAR2 DEFAULT NULL ,
173 P_NEW_CUSTOMER_ID IN NUMBER DEFAULT NULL ,
174 P_NEW_CUST_ACCOUNT_ID IN NUMBER DEFAULT NULL ,
175 P_NEW_DURATION IN NUMBER DEFAULT NULL ,
176 P_NEW_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
177 P_NEW_ESC_OWNER_ID IN NUMBER DEFAULT NULL ,
178 P_NEW_ESC_TERR_ID IN NUMBER DEFAULT NULL ,
179 P_NEW_NOT_PERIOD IN NUMBER DEFAULT NULL ,
180 P_NEW_NOT_PERIOD_UOM IN VARCHAR2 DEFAULT NULL ,
181 P_NEW_ORG_ID IN NUMBER DEFAULT NULL ,
182 P_NEW_OWNER_ID IN NUMBER DEFAULT NULL ,
183 P_NEW_OWNER_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
184 P_NEW_PARENT_TASK_ID IN NUMBER DEFAULT NULL ,
185 P_NEW_PER_COMPLETE IN NUMBER DEFAULT NULL ,
186 P_NEW_PLANNED_EFFORT IN NUMBER DEFAULT NULL ,
187 P_NEW_PLANNED_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
188 P_NEW_PLANNED_END_DATE IN DATE DEFAULT NULL ,
189 P_NEW_PLANNED_START_DATE IN DATE DEFAULT NULL ,
190 P_NEW_REASON_CODE IN VARCHAR2 DEFAULT NULL ,
191 P_NEW_RECURRENCE_RULE_ID IN NUMBER DEFAULT NULL ,
192 P_NEW_SCHED_END_DATE IN DATE DEFAULT NULL ,
193 P_NEW_SCHED_START_DATE IN DATE DEFAULT NULL ,
194 P_NEW_SRC_OBJ_ID IN NUMBER DEFAULT NULL ,
195 P_NEW_SRC_OBJ_NAME IN VARCHAR2 DEFAULT NULL ,
196 P_NEW_SRC_OBJ_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
197 P_NEW_TASK_PRIORITY_ID IN NUMBER DEFAULT NULL ,
198 P_NEW_TASK_STATUS_ID IN NUMBER DEFAULT NULL ,
199 P_NEW_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
200 P_NEW_TIMEZONE_ID IN NUMBER DEFAULT NULL ,
201 P_NEW_WORKFLOW_PROCESS_ID IN NUMBER DEFAULT NULL ,
202 P_NOT_CHAN_FLAG IN VARCHAR2 DEFAULT NULL ,
203 P_NEW_DESCRIPTION IN VARCHAR2 DEFAULT NULL ,
204 P_NEW_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
205 P_NEW_ESCALATION_LEVEL IN VARCHAR2 DEFAULT NULL ,
206 P_NEW_OWNER_TERRITORY_ID IN NUMBER DEFAULT NULL ,
207 P_NEW_DATE_SELECTED IN VARCHAR2 DEFAULT NULL ,
208 P_NEW_LOCATION_ID IN NUMBER DEFAULT NULL ,
209 x_return_status OUT NOCOPY VARCHAR2 ,
210 x_msg_count OUT NOCOPY NUMBER ,
211 x_msg_data OUT NOCOPY VARCHAR2 ,
212 x_task_audit_id OUT NOCOPY NUMBER ) ;
213
214 procedure INSERT_ROW (
215 X_ROWID in out NOCOPY VARCHAR2,
216 X_TASK_AUDIT_ID in NUMBER,
217 X_NEW_NOTIFICATION_PERIOD in NUMBER,
218 X_OLD_NOTIFICATION_PERIOD_UOM in VARCHAR2,
219 X_NEW_NOTIFICATION_PERIOD_UOM in VARCHAR2,
220 X_OLD_PARENT_TASK_ID in NUMBER,
221 X_NEW_PARENT_TASK_ID in NUMBER,
222 X_OLD_RECURRENCE_RULE_ID in NUMBER,
223 X_NEW_RECURRENCE_RULE_ID in NUMBER,
224 X_PALM_CHANGED_FLAG in VARCHAR2,
225 X_WINCE_CHANGED_FLAG in VARCHAR2,
226 X_LAPTOP_CHANGED_FLAG in VARCHAR2,
227 X_DEVICE1_CHANGED_FLAG in VARCHAR2,
228 X_DEVICE2_CHANGED_FLAG in VARCHAR2,
229 X_DEVICE3_CHANGED_FLAG in VARCHAR2,
230 X_OLD_CURRENCY_CODE in VARCHAR2,
231 X_NEW_CURRENCY_CODE in VARCHAR2,
232 X_OLD_COSTS in NUMBER,
233 X_NEW_COSTS in NUMBER,
234 X_TASK_ID in NUMBER,
235 X_OLD_TASK_TYPE_ID in NUMBER,
236 X_NEW_TASK_TYPE_ID in NUMBER,
237 X_OLD_TASK_STATUS_ID in NUMBER,
238 X_NEW_TASK_STATUS_ID in NUMBER,
239 X_OLD_TASK_PRIORITY_ID in NUMBER,
240 X_NEW_TASK_PRIORITY_ID in NUMBER,
241 X_OLD_OWNER_ID in NUMBER,
242 X_NEW_OWNER_ID in NUMBER,
243 X_OLD_OWNER_TYPE_CODE in VARCHAR2,
244 X_NEW_OWNER_TYPE_CODE in VARCHAR2,
245 X_OLD_ASSIGNED_BY_ID in NUMBER,
246 X_NEW_ASSIGNED_BY_ID in NUMBER,
247 X_OLD_CUST_ACCOUNT_ID in NUMBER,
248 X_NEW_CUST_ACCOUNT_ID in NUMBER,
249 X_OLD_CUSTOMER_ID in NUMBER,
250 X_NEW_CUSTOMER_ID in NUMBER,
251 X_OLD_ADDRESS_ID in NUMBER,
252 X_NEW_ADDRESS_ID in NUMBER,
253 X_OLD_PLANNED_START_DATE in DATE,
254 X_NEW_PLANNED_START_DATE in DATE,
255 X_OLD_PLANNED_END_DATE in DATE,
256 X_NEW_PLANNED_END_DATE in DATE,
257 X_OLD_SCHEDULED_START_DATE in DATE,
258 X_NEW_SCHEDULED_START_DATE in DATE,
259 X_OLD_SCHEDULED_END_DATE in DATE,
260 X_NEW_SCHEDULED_END_DATE in DATE,
261 X_OLD_ACTUAL_START_DATE in DATE,
262 X_NEW_ACTUAL_START_DATE in DATE,
263 X_OLD_ACTUAL_END_DATE in DATE,
264 X_NEW_ACTUAL_END_DATE in DATE,
265 X_OLD_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
266 X_NEW_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
267 X_OLD_TIMEZONE_ID in NUMBER,
268 X_NEW_TIMEZONE_ID in NUMBER,
269 X_OLD_SOURCE_OBJECT_ID in NUMBER,
270 X_NEW_SOURCE_OBJECT_ID in NUMBER,
271 X_OLD_SOURCE_OBJECT_NAME in VARCHAR2,
272 X_NEW_SOURCE_OBJECT_NAME in VARCHAR2,
273 X_OLD_DURATION in NUMBER,
274 X_NEW_DURATION in NUMBER,
275 X_OLD_DURATION_UOM in VARCHAR2,
276 X_NEW_DURATION_UOM in VARCHAR2,
277 X_OLD_PLANNED_EFFORT in NUMBER,
278 X_NEW_PLANNED_EFFORT in NUMBER,
279 X_OLD_PLANNED_EFFORT_UOM in VARCHAR2,
280 X_NEW_PLANNED_EFFORT_UOM in VARCHAR2,
281 X_OLD_ACTUAL_EFFORT in NUMBER,
282 X_NEW_ACTUAL_EFFORT in NUMBER,
283 X_OLD_ACTUAL_EFFORT_UOM in VARCHAR2,
284 X_NEW_ACTUAL_EFFORT_UOM in VARCHAR2,
285 X_OLD_PERCENTAGE_COMPLETE in NUMBER,
286 X_NEW_PERCENTAGE_COMPLETE in NUMBER,
287 X_OLD_REASON_CODE in VARCHAR2,
288 X_NEW_REASON_CODE in VARCHAR2,
289 X_PRIVATE_CHANGED_FLAG in VARCHAR2,
290 X_PUBLISH_CHANGED_FLAG in VARCHAR2,
291 X_RESTRICT_CLOSURE_CHANGE_FLAG in VARCHAR2,
292 X_MULTI_BOOKED_CHANGED_FLAG in VARCHAR2,
293 X_MILESTONE_CHANGED_FLAG in VARCHAR2,
294 X_HOLIDAY_CHANGED_FLAG in VARCHAR2,
295 X_BILLABLE_CHANGED_FLAG in VARCHAR2,
296 X_OLD_BOUND_MODE_CODE in VARCHAR2,
297 X_NEW_BOUND_MODE_CODE in VARCHAR2,
298 X_SOFT_BOUND_CHANGED_FLAG in VARCHAR2,
299 X_OLD_WORKFLOW_PROCESS_ID in NUMBER,
300 X_NEW_WORKFLOW_PROCESS_ID in NUMBER,
301 X_NOTIFICATION_CHANGED_FLAG in VARCHAR2,
302 X_OLD_NOTIFICATION_PERIOD in NUMBER,
303 X_OLD_TASK_NAME in VARCHAR2,
304 X_NEW_TASK_NAME in VARCHAR2,
305 X_OLD_DESCRIPTION in VARCHAR2,
306 X_NEW_DESCRIPTION in VARCHAR2,
307 X_CREATION_DATE in DATE,
308 X_CREATED_BY in NUMBER,
309 X_LAST_UPDATE_DATE in DATE,
310 X_LAST_UPDATED_BY in NUMBER,
311 X_LAST_UPDATE_LOGIN in NUMBER,
312 X_OBJECT_VERSION_NUMBER in NUMBER,
313 X_OLD_OWNER_TERRITORY_ID in NUMBER,
314 X_NEW_OWNER_TERRITORY_ID in NUMBER,
315 X_NEW_ESCALATION_LEVEL in VARCHAR2,
316 X_OLD_ESCALATION_LEVEL in VARCHAR2,
317 X_OLD_DATE_SELECTED IN VARCHAR2,
318 X_NEW_DATE_SELECTED IN VARCHAR2,
319 X_OLD_LOCATION_ID IN NUMBER,
320 X_NEW_LOCATION_ID IN NUMBER
321 );
322
323 procedure ADD_LANGUAGE;
324
325 procedure translate_row(
326 x_task_audit_id in number,
327 x_old_task_name in varchar2,
328 x_new_task_name in varchar2,
329 x_old_description in varchar2,
330 x_new_description in varchar2,
331 x_owner in varchar2
332 );
333
334 END;
[Home] [Help]