eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JTF_TASKS_PKG

Source


1 PACKAGE JTF_TASKS_PKG  as
2 /* $Header: jtftktas.pls 120.2 2005/08/04 13:31:48 sbarat ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_TASK_ID in NUMBER,
7   X_ATTRIBUTE4 in VARCHAR2,
8   X_ATTRIBUTE5 in VARCHAR2,
9   X_ATTRIBUTE6 in VARCHAR2,
10   X_ATTRIBUTE7 in VARCHAR2,
11   X_ATTRIBUTE8 in VARCHAR2,
12   X_ATTRIBUTE9 in VARCHAR2,
13   X_ATTRIBUTE10 in VARCHAR2,
14   X_ATTRIBUTE11 in VARCHAR2,
15   X_ATTRIBUTE12 in VARCHAR2,
16   X_ATTRIBUTE13 in VARCHAR2,
17   X_ATTRIBUTE14 in VARCHAR2,
18   X_ATTRIBUTE15 in VARCHAR2,
19   X_ATTRIBUTE_CATEGORY in VARCHAR2,
20   X_TASK_NUMBER in VARCHAR2,
21   X_TASK_TYPE_ID in NUMBER,
22   X_TASK_STATUS_ID in NUMBER,
23   X_TASK_PRIORITY_ID in NUMBER,
24   X_OWNER_ID in NUMBER,
25   X_OWNER_TYPE_CODE in VARCHAR2,
26   X_ASSIGNED_BY_ID in NUMBER,
27   X_CUST_ACCOUNT_ID in NUMBER,
28   X_CUSTOMER_ID in NUMBER,
29   X_ADDRESS_ID in NUMBER,
30   X_PLANNED_START_DATE in DATE,
31   X_PALM_FLAG in VARCHAR2,
32   X_WINCE_FLAG in VARCHAR2,
33   X_LAPTOP_FLAG in VARCHAR2,
34   X_DEVICE1_FLAG in VARCHAR2,
35   X_DEVICE2_FLAG in VARCHAR2,
36   X_DEVICE3_FLAG in VARCHAR2,
37   X_COSTS in NUMBER,
38   X_CURRENCY_CODE in VARCHAR2,
39   X_ATTRIBUTE1 in VARCHAR2,
40   X_ATTRIBUTE2 in VARCHAR2,
41   X_ATTRIBUTE3 in VARCHAR2,
42   X_NOTIFICATION_PERIOD in NUMBER,
43   X_NOTIFICATION_PERIOD_UOM in VARCHAR2,
44   X_PARENT_TASK_ID in NUMBER,
45   X_RECURRENCE_RULE_ID in NUMBER,
46   X_ALARM_START in NUMBER,
47   X_ALARM_START_UOM in VARCHAR2,
48   X_ALARM_ON in VARCHAR2,
49   X_ALARM_COUNT in NUMBER,
50   X_ALARM_FIRED_COUNT in NUMBER,
51   X_ALARM_INTERVAL in NUMBER,
52   X_ALARM_INTERVAL_UOM in VARCHAR2,
53   X_DELETED_FLAG in VARCHAR2,
54   X_ACTUAL_START_DATE in DATE,
55   X_ACTUAL_END_DATE in DATE,
56   X_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
57   X_TIMEZONE_ID in NUMBER,
58   X_SOURCE_OBJECT_ID in NUMBER,
59   X_SOURCE_OBJECT_NAME in VARCHAR2,
60   X_DURATION in NUMBER,
61   X_DURATION_UOM in VARCHAR2,
62   X_PLANNED_EFFORT in NUMBER,
63   X_PLANNED_EFFORT_UOM in VARCHAR2,
64   X_ACTUAL_EFFORT in NUMBER,
65   X_ACTUAL_EFFORT_UOM in VARCHAR2,
66   X_PERCENTAGE_COMPLETE in NUMBER,
67   X_REASON_CODE in VARCHAR2,
68   X_PRIVATE_FLAG in VARCHAR2,
69   X_PUBLISH_FLAG in VARCHAR2,
70   X_RESTRICT_CLOSURE_FLAG in VARCHAR2,
71   X_MULTI_BOOKED_FLAG in VARCHAR2,
72   X_MILESTONE_FLAG in VARCHAR2,
73   X_HOLIDAY_FLAG in VARCHAR2,
74   X_BILLABLE_FLAG in VARCHAR2,
75   X_BOUND_MODE_CODE in VARCHAR2,
76   X_SOFT_BOUND_FLAG in VARCHAR2,
77   X_WORKFLOW_PROCESS_ID in NUMBER,
78   X_NOTIFICATION_FLAG in VARCHAR2,
79   X_PLANNED_END_DATE in DATE,
80   X_SCHEDULED_START_DATE in DATE,
81   X_SCHEDULED_END_DATE in DATE,
82   X_TASK_NAME in VARCHAR2,
83   X_DESCRIPTION in VARCHAR2,
84   X_CREATION_DATE in DATE,
85   X_CREATED_BY in NUMBER,
86   X_LAST_UPDATE_DATE in DATE,
87   X_LAST_UPDATED_BY in NUMBER,
88   X_LAST_UPDATE_LOGIN in NUMBER,
89   X_OWNER_TERRITORY_ID in NUMBER,
90   X_ESCALATION_LEVEL in VARCHAR2,
91   x_calendar_start_date       IN       DATE default null ,
92   x_calendar_end_date         IN       DATE default null ,
93   x_date_selected         IN       VARCHAR2 default null,
94   x_template_id           IN       NUMBER default null,
95   x_template_group_id         IN       NUMBER default null,
96   x_open_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_yes,
97   x_entity    IN VARCHAR2,
98   x_task_confirmation_status IN	 VARCHAR2,
99   x_task_confirmation_counter IN  NUMBER,
100   x_task_split_flag IN VARCHAR2,
101   x_child_position  IN VARCHAR2,
102   x_child_sequence_num IN  NUMBER,
103   x_location_id  IN NUMBER
104    );
105 procedure LOCK_ROW (
106   X_TASK_ID in NUMBER,
107     X_OBJECT_VERSION_NUMBER in NUMBER);
108 
109 -- old version
110 procedure UPDATE_ROW (
111   X_TASK_ID in NUMBER,
112   X_OBJECT_VERSION_NUMBER in NUMBER,
113   X_ATTRIBUTE4 in VARCHAR2,
114   X_ATTRIBUTE5 in VARCHAR2,
115   X_ATTRIBUTE6 in VARCHAR2,
116   X_ATTRIBUTE7 in VARCHAR2,
117   X_ATTRIBUTE8 in VARCHAR2,
118   X_ATTRIBUTE9 in VARCHAR2,
119   X_ATTRIBUTE10 in VARCHAR2,
120   X_ATTRIBUTE11 in VARCHAR2,
121   X_ATTRIBUTE12 in VARCHAR2,
122   X_ATTRIBUTE13 in VARCHAR2,
123   X_ATTRIBUTE14 in VARCHAR2,
124   X_ATTRIBUTE15 in VARCHAR2,
125   X_ATTRIBUTE_CATEGORY in VARCHAR2,
126   X_TASK_NUMBER in VARCHAR2,
127   X_TASK_TYPE_ID in NUMBER,
128   X_TASK_STATUS_ID in NUMBER,
129   X_TASK_PRIORITY_ID in NUMBER,
130   X_OWNER_ID in NUMBER,
131   X_OWNER_TYPE_CODE in VARCHAR2,
132   X_ASSIGNED_BY_ID in NUMBER,
133   X_CUST_ACCOUNT_ID in NUMBER,
134   X_CUSTOMER_ID in NUMBER,
135   X_ADDRESS_ID in NUMBER,
136   X_PLANNED_START_DATE in DATE,
137   X_PALM_FLAG in VARCHAR2,
138   X_WINCE_FLAG in VARCHAR2,
139   X_LAPTOP_FLAG in VARCHAR2,
140   X_DEVICE1_FLAG in VARCHAR2,
141   X_DEVICE2_FLAG in VARCHAR2,
142   X_DEVICE3_FLAG in VARCHAR2,
143   X_COSTS in NUMBER,
144   X_CURRENCY_CODE in VARCHAR2,
145   X_ATTRIBUTE1 in VARCHAR2,
146   X_ATTRIBUTE2 in VARCHAR2,
147   X_ATTRIBUTE3 in VARCHAR2,
148   X_NOTIFICATION_PERIOD in NUMBER,
149   X_NOTIFICATION_PERIOD_UOM in VARCHAR2,
150   X_PARENT_TASK_ID in NUMBER,
151   X_RECURRENCE_RULE_ID in NUMBER,
152   X_ALARM_START in NUMBER,
153   X_ALARM_START_UOM in VARCHAR2,
154   X_ALARM_ON in VARCHAR2,
155   X_ALARM_COUNT in NUMBER,
156   X_ALARM_FIRED_COUNT in NUMBER,
157   X_ALARM_INTERVAL in NUMBER,
158   X_ALARM_INTERVAL_UOM in VARCHAR2,
159   X_DELETED_FLAG in VARCHAR2,
160   X_ACTUAL_START_DATE in DATE,
161   X_ACTUAL_END_DATE in DATE,
162   X_SOURCE_OBJECT_TYPE_CODE in VARCHAR2,
163   X_TIMEZONE_ID in NUMBER,
164   X_SOURCE_OBJECT_ID in NUMBER,
165   X_SOURCE_OBJECT_NAME in VARCHAR2,
166   X_DURATION in NUMBER,
167   X_DURATION_UOM in VARCHAR2,
168   X_PLANNED_EFFORT in NUMBER,
169   X_PLANNED_EFFORT_UOM in VARCHAR2,
170   X_ACTUAL_EFFORT in NUMBER,
171   X_ACTUAL_EFFORT_UOM in VARCHAR2,
172   X_PERCENTAGE_COMPLETE in NUMBER,
173   X_REASON_CODE in VARCHAR2,
174   X_PRIVATE_FLAG in VARCHAR2,
175   X_PUBLISH_FLAG in VARCHAR2,
176   X_RESTRICT_CLOSURE_FLAG in VARCHAR2,
177   X_MULTI_BOOKED_FLAG in VARCHAR2,
178   X_MILESTONE_FLAG in VARCHAR2,
179   X_HOLIDAY_FLAG in VARCHAR2,
180   X_BILLABLE_FLAG in VARCHAR2,
181   X_BOUND_MODE_CODE in VARCHAR2,
182   X_SOFT_BOUND_FLAG in VARCHAR2,
183   X_WORKFLOW_PROCESS_ID in NUMBER,
184   X_NOTIFICATION_FLAG in VARCHAR2,
185   X_PLANNED_END_DATE in DATE,
186   X_SCHEDULED_START_DATE in DATE,
187   X_SCHEDULED_END_DATE in DATE,
188   X_TASK_NAME in VARCHAR2,
189   X_DESCRIPTION in VARCHAR2,
190   X_LAST_UPDATE_DATE in DATE,
191   X_LAST_UPDATED_BY in NUMBER,
192   X_LAST_UPDATE_LOGIN in NUMBER,
193   X_OWNER_TERRITORY_ID in NUMBER,
194   X_ESCALATION_LEVEL in VARCHAR2,
195   x_calendar_start_date       IN       DATE default jtf_task_utl.g_miss_date ,
196   x_calendar_end_date         IN       DATE default jtf_task_utl.g_miss_date ,
197   x_date_selected         IN       VARCHAR2 default jtf_task_utl.g_miss_char,
198   x_open_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_yes,
199   x_task_confirmation_status IN	 VARCHAR2,
200   x_task_confirmation_counter IN  NUMBER,
201   x_task_split_flag IN VARCHAR2,
202   x_child_position  IN VARCHAR2,
203   x_child_sequence_num IN  NUMBER,
204   x_location_id IN NUMBER default NULL
205   );
206 
207 --BES
208 
209 TYPE Task_Upd_Rec IS RECORD (
210   TASK_ID 	JTF_TASKS_B.TASK_ID%TYPE,
211   OBJECT_VERSION_NUMBER JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE,
212   ATTRIBUTE4 		JTF_TASKS_B.ATTRIBUTE4%TYPE,
213   ATTRIBUTE5 		JTF_TASKS_B.ATTRIBUTE5%TYPE,
214   ATTRIBUTE6 		JTF_TASKS_B.ATTRIBUTE6%TYPE,
215   ATTRIBUTE7 		JTF_TASKS_B.ATTRIBUTE7%TYPE,
216   ATTRIBUTE8 		JTF_TASKS_B.ATTRIBUTE8%TYPE,
217   ATTRIBUTE9 		JTF_TASKS_B.ATTRIBUTE9%TYPE,
218   ATTRIBUTE10 		JTF_TASKS_B.ATTRIBUTE10%TYPE,
219   ATTRIBUTE11 		JTF_TASKS_B.ATTRIBUTE11%TYPE,
220   ATTRIBUTE12 		JTF_TASKS_B.ATTRIBUTE12%TYPE,
221   ATTRIBUTE13 		JTF_TASKS_B.ATTRIBUTE13%TYPE,
222   ATTRIBUTE14 		JTF_TASKS_B.ATTRIBUTE14%TYPE,
223   ATTRIBUTE15 		JTF_TASKS_B.ATTRIBUTE15%TYPE,
224   ATTRIBUTE_CATEGORY 	JTF_TASKS_B.ATTRIBUTE_CATEGORY%TYPE,
225   TASK_NUMBER 		JTF_TASKS_B.TASK_NUMBER%TYPE,
226   TASK_TYPE_ID 		JTF_TASKS_B.TASK_TYPE_ID%TYPE ,
227   TASK_STATUS_ID 	JTF_TASKS_B.TASK_STATUS_ID%TYPE,
228   TASK_PRIORITY_ID 	JTF_TASKS_B.TASK_PRIORITY_ID%TYPE,
229   OWNER_ID 		JTF_TASKS_B.OWNER_ID%TYPE,
230   OWNER_TYPE_CODE 	JTF_TASKS_B.OWNER_TYPE_CODE%TYPE,
231   ASSIGNED_BY_ID 	JTF_TASKS_B.ASSIGNED_BY_ID%TYPE,
232   CUST_ACCOUNT_ID 	JTF_TASKS_B.CUST_ACCOUNT_ID%TYPE,
233   CUSTOMER_ID 		JTF_TASKS_B.CUSTOMER_ID%TYPE,
234   ADDRESS_ID 		JTF_TASKS_B.ADDRESS_ID%TYPE,
235   PLANNED_START_DATE 	JTF_TASKS_B.PLANNED_START_DATE%TYPE,
236   PALM_FLAG 		JTF_TASKS_B.PALM_FLAG%TYPE,
237   WINCE_FLAG 		JTF_TASKS_B.WINCE_FLAG%TYPE,
238   LAPTOP_FLAG 		JTF_TASKS_B.LAPTOP_FLAG%TYPE,
239   DEVICE1_FLAG 		JTF_TASKS_B.DEVICE1_FLAG%TYPE,
240   DEVICE2_FLAG 		JTF_TASKS_B.DEVICE2_FLAG%TYPE,
241   DEVICE3_FLAG 		JTF_TASKS_B.DEVICE3_FLAG%TYPE,
242   COSTS 		JTF_TASKS_B.costs%TYPE,
243   CURRENCY_CODE 	JTF_TASKS_B.CURRENCY_CODE%TYPE,
244   ATTRIBUTE1 		JTF_TASKS_B.ATTRIBUTE1%TYPE,
245   ATTRIBUTE2 		JTF_TASKS_B.ATTRIBUTE2%TYPE,
246   ATTRIBUTE3 		JTF_TASKS_B.ATTRIBUTE3%TYPE,
247   NOTIFICATION_PERIOD 	JTF_TASKS_B.NOTIFICATION_PERIOD%TYPE,
248   NOTIFICATION_PERIOD_UOM 	JTF_TASKS_B.NOTIFICATION_PERIOD_UOM%TYPE,
249   PARENT_TASK_ID 	JTF_TASKS_B.PARENT_TASK_ID%TYPE,
250   RECURRENCE_RULE_ID 	JTF_TASKS_B.RECURRENCE_RULE_ID%TYPE,
251   ALARM_START 		JTF_TASKS_B.ALARM_START%TYPE,
252   ALARM_START_UOM 	JTF_TASKS_B.ALARM_START_UOM%TYPE,
253   ALARM_ON 		JTF_TASKS_B.ALARM_ON%TYPE,
254   ALARM_COUNT 		JTF_TASKS_B.ALARM_COUNT%TYPE,
255   ALARM_FIRED_COUNT 	JTF_TASKS_B.ALARM_FIRED_COUNT%TYPE,
256   ALARM_INTERVAL 	JTF_TASKS_B.ALARM_INTERVAL%TYPE,
257   ALARM_INTERVAL_UOM 	JTF_TASKS_B.ALARM_INTERVAL_UOM%TYPE,
258   DELETED_FLAG 		JTF_TASKS_B.DELETED_FLAG%TYPE,
259   ACTUAL_START_DATE 	JTF_TASKS_B.ACTUAL_START_DATE%TYPE,
260   ACTUAL_END_DATE 	JTF_TASKS_B.ACTUAL_END_DATE%TYPE,
261   SOURCE_OBJECT_TYPE_CODE 	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE%TYPE,
262   TIMEZONE_ID 		JTF_TASKS_B.TIMEZONE_ID%TYPE,
263   SOURCE_OBJECT_ID 	JTF_TASKS_B.SOURCE_OBJECT_ID%TYPE,
264   SOURCE_OBJECT_NAME 	JTF_TASKS_B.SOURCE_OBJECT_NAME%TYPE,
265   DURATION 		JTF_TASKS_B.DURATION%TYPE,
266   DURATION_UOM 		JTF_TASKS_B.DURATION_UOM%TYPE,
267   PLANNED_EFFORT 	JTF_TASKS_B.PLANNED_EFFORT%TYPE,
268   PLANNED_EFFORT_UOM 	JTF_TASKS_B.PLANNED_EFFORT_UOM%TYPE,
269   ACTUAL_EFFORT 	JTF_TASKS_B.ACTUAL_EFFORT%TYPE,
270   ACTUAL_EFFORT_UOM 	JTF_TASKS_B.ACTUAL_EFFORT_UOM%TYPE,
271   PERCENTAGE_COMPLETE 	JTF_TASKS_B.PERCENTAGE_COMPLETE%TYPE,
272   REASON_CODE 		JTF_TASKS_B.REASON_CODE%TYPE,
273   PRIVATE_FLAG 		JTF_TASKS_B.PRIVATE_FLAG%TYPE,
274   PUBLISH_FLAG 		JTF_TASKS_B.PUBLISH_FLAG%TYPE,
275   RESTRICT_CLOSURE_FLAG JTF_TASKS_B.RESTRICT_CLOSURE_FLAG%TYPE,
276   MULTI_BOOKED_FLAG 	JTF_TASKS_B.MULTI_BOOKED_FLAG%TYPE,
277   MILESTONE_FLAG 	JTF_TASKS_B.MILESTONE_FLAG%TYPE,
278   HOLIDAY_FLAG 		JTF_TASKS_B.HOLIDAY_FLAG%TYPE,
279   BILLABLE_FLAG 	JTF_TASKS_B.BILLABLE_FLAG%TYPE,
280   BOUND_MODE_CODE 	JTF_TASKS_B.BOUND_MODE_CODE%TYPE,
281   SOFT_BOUND_FLAG 	JTF_TASKS_B.SOFT_BOUND_FLAG%TYPE,
282   WORKFLOW_PROCESS_ID 	JTF_TASKS_B.WORKFLOW_PROCESS_ID%TYPE,
283   NOTIFICATION_FLAG 	JTF_TASKS_B.NOTIFICATION_FLAG%TYPE,
284   PLANNED_END_DATE 	JTF_TASKS_B.PLANNED_END_DATE%TYPE,
285   SCHEDULED_START_DATE 	JTF_TASKS_B.SCHEDULED_START_DATE%TYPE,
286   SCHEDULED_END_DATE 	JTF_TASKS_B.SCHEDULED_END_DATE%TYPE,
287   TASK_NAME 		JTF_TASKS_TL.TASK_NAME%TYPE,
288   DESCRIPTION 		JTF_TASKS_TL.DESCRIPTION%TYPE,
289   LAST_UPDATE_DATE 	JTF_TASKS_B.LAST_UPDATE_DATE%TYPE,
290   LAST_UPDATED_BY 	JTF_TASKS_B.LAST_UPDATED_BY%TYPE,
291   LAST_UPDATE_LOGIN 	JTF_TASKS_B.LAST_UPDATE_LOGIN%TYPE,
292   OWNER_TERRITORY_ID 	JTF_TASKS_B.OWNER_TERRITORY_ID%TYPE,
293   ESCALATION_LEVEL 	JTF_TASKS_B.ESCALATION_LEVEL%TYPE,
294   calendar_start_date 	JTF_TASKS_B.calendar_start_date%TYPE,
295   calendar_end_date 	JTF_TASKS_B.calendar_end_date%TYPE,
296   date_selected 	JTF_TASKS_B.date_selected%TYPE,
297   open_flag 		JTF_TASKS_B.open_flag%TYPE := jtf_task_utl.g_yes,
298   task_audit_id  	jtf_task_audits_b.TASK_AUDIT_ID%TYPE,
299   TASK_CONFIRMATION_STATUS   JTF_TASKS_B.TASK_CONFIRMATION_STATUS%TYPE,
300   TASK_CONFIRMATION_COUNTER  JTF_TASKS_B.TASK_CONFIRMATION_COUNTER%TYPE,
301   TASK_SPLIT_FLAG            JTF_TASKS_B.TASK_SPLIT_FLAG%TYPE,
302   CHILD_POSITION             JTF_TASKS_B.CHILD_POSITION%TYPE,
303   CHILD_SEQUENCE_NUM         JTF_TASKS_B.CHILD_SEQUENCE_NUM%TYPE,
304   LOCATION_ID		     JTF_TASKS_B.LOCATION_ID%TYPE
305   );
306 
307 
308 -- The overloaded version which to add p_task_audit_id
309 procedure UPDATE_ROW (
310   p_Task_Upd_Rec	IN 	JTF_TASKS_PKG.Task_Upd_Rec,
311   p_Task_Audit_Id	OUT NOCOPY JTF_TASK_AUDITS_B.TASK_AUDIT_ID%TYPE
312   );
313 
314 --BES end
315 
316 procedure DELETE_ROW (
317   X_TASK_ID in NUMBER );
318 procedure ADD_LANGUAGE;
319 
320 procedure translate_row(
321    x_task_id in number,
322    x_task_name in varchar2,
323    x_description  in varchar2,
324    x_owner in varchar2 );
325 
326 end JTF_TASKS_PKG;