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.

APPS.JTF_TASKS_PUB dependencies on JTF_TASKS_V

Line 276: task_id jtf_tasks_v.task_id%TYPE

272:
273: p_task_user_hooks task_user_hooks;
274:
275: TYPE task_rec IS RECORD(
276: task_id jtf_tasks_v.task_id%TYPE
277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE

Line 277: , task_number jtf_tasks_v.task_number%TYPE

273: p_task_user_hooks task_user_hooks;
274:
275: TYPE task_rec IS RECORD(
276: task_id jtf_tasks_v.task_id%TYPE
277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE

Line 278: , task_name jtf_tasks_v.task_name%TYPE

274:
275: TYPE task_rec IS RECORD(
276: task_id jtf_tasks_v.task_id%TYPE
277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE

Line 279: , description jtf_tasks_v.description%TYPE

275: TYPE task_rec IS RECORD(
276: task_id jtf_tasks_v.task_id%TYPE
277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE

Line 280: , task_type_id jtf_tasks_v.task_type_id%TYPE

276: task_id jtf_tasks_v.task_id%TYPE
277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE

Line 281: , task_type jtf_tasks_v.task_type%TYPE

277: , task_number jtf_tasks_v.task_number%TYPE
278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE

Line 282: , task_status_id jtf_tasks_v.task_status_id%TYPE

278: , task_name jtf_tasks_v.task_name%TYPE
279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE

Line 283: , task_status jtf_tasks_v.task_status%TYPE

279: , description jtf_tasks_v.description%TYPE
280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE

Line 284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE

280: , task_type_id jtf_tasks_v.task_type_id%TYPE
281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE

Line 285: , task_priority jtf_tasks_v.task_priority%TYPE

281: , task_type jtf_tasks_v.task_type%TYPE
282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE

Line 286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE

282: , task_status_id jtf_tasks_v.task_status_id%TYPE
283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE

Line 287: , owner_id jtf_tasks_v.owner_id%TYPE

283: , task_status jtf_tasks_v.task_status%TYPE
284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE

Line 288: , owner jtf_tasks_v.owner%TYPE

284: , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE

Line 289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE

285: , task_priority jtf_tasks_v.task_priority%TYPE
286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE

Line 290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE

286: , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE

Line 291: , customer_id jtf_tasks_v.customer_id%TYPE

287: , owner_id jtf_tasks_v.owner_id%TYPE
288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE

Line 292: , customer_name jtf_tasks_v.customer_name%TYPE

288: , owner jtf_tasks_v.owner%TYPE
289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE

Line 293: , customer_number jtf_tasks_v.customer_number%TYPE

289: , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE

Line 294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE

290: , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE

Line 295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE

291: , customer_id jtf_tasks_v.customer_id%TYPE
292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE

Line 296: , address_id jtf_tasks_v.address_id%TYPE

292: , customer_name jtf_tasks_v.customer_name%TYPE
293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE

Line 297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE

293: , customer_number jtf_tasks_v.customer_number%TYPE
294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE

Line 298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE

294: , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE

Line 299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE

295: , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE

Line 300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE

296: , address_id jtf_tasks_v.address_id%TYPE
297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE

Line 301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE

297: , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE

Line 302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE

298: , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE

Line 303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE

299: , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE

Line 304: , object_id jtf_tasks_v.source_object_id%TYPE

300: , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE

Line 305: , obect_name jtf_tasks_v.source_object_name%TYPE

301: , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE

Line 306: , DURATION jtf_tasks_v.DURATION%TYPE

302: , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE

Line 307: , duration_uom jtf_tasks_v.duration_uom%TYPE

303: , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE

Line 308: , planned_effort jtf_tasks_v.planned_effort%TYPE

304: , object_id jtf_tasks_v.source_object_id%TYPE
305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE

Line 309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE

305: , obect_name jtf_tasks_v.source_object_name%TYPE
306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE

Line 310: , actual_effort jtf_tasks_v.actual_effort%TYPE

306: , DURATION jtf_tasks_v.DURATION%TYPE
307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE

Line 311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE

307: , duration_uom jtf_tasks_v.duration_uom%TYPE
308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE

Line 312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE

308: , planned_effort jtf_tasks_v.planned_effort%TYPE
309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE

Line 313: , reason_code jtf_tasks_v.reason_code%TYPE

309: , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE

Line 314: , private_flag jtf_tasks_v.private_flag%TYPE

310: , actual_effort jtf_tasks_v.actual_effort%TYPE
311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE

Line 315: , publish_flag jtf_tasks_v.publish_flag%TYPE

311: , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE

Line 316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE

312: , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE

Line 317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE

313: , reason_code jtf_tasks_v.reason_code%TYPE
314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE

Line 318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE

314: , private_flag jtf_tasks_v.private_flag%TYPE
315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE

Line 319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE

315: , publish_flag jtf_tasks_v.publish_flag%TYPE
316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE

Line 320: , notification_flag jtf_tasks_v.notification_flag%TYPE

316: , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE

Line 321: , notification_period jtf_tasks_v.notification_period%TYPE

317: , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE

Line 322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE

318: , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE

Line 323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE

319: , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE

Line 324: , alarm_start jtf_tasks_v.alarm_start%TYPE

320: , notification_flag jtf_tasks_v.notification_flag%TYPE
321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE

Line 325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE

321: , notification_period jtf_tasks_v.notification_period%TYPE
322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE

Line 326: , alarm_on jtf_tasks_v.alarm_on%TYPE

322: , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE

Line 327: , alarm_count jtf_tasks_v.alarm_count%TYPE

323: , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE

Line 328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE

324: , alarm_start jtf_tasks_v.alarm_start%TYPE
325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE

Line 329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE

325: , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE

Line 330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE

326: , alarm_on jtf_tasks_v.alarm_on%TYPE
327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE

Line 331: , attribute1 jtf_tasks_v.attribute1%TYPE

327: , alarm_count jtf_tasks_v.alarm_count%TYPE
328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE

Line 332: , attribute2 jtf_tasks_v.attribute2%TYPE

328: , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE

Line 333: , attribute3 jtf_tasks_v.attribute3%TYPE

329: , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE

Line 334: , attribute4 jtf_tasks_v.attribute4%TYPE

330: , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE

Line 335: , attribute5 jtf_tasks_v.attribute5%TYPE

331: , attribute1 jtf_tasks_v.attribute1%TYPE
332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE

Line 336: , attribute6 jtf_tasks_v.attribute6%TYPE

332: , attribute2 jtf_tasks_v.attribute2%TYPE
333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE

Line 337: , attribute7 jtf_tasks_v.attribute7%TYPE

333: , attribute3 jtf_tasks_v.attribute3%TYPE
334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE

Line 338: , attribute8 jtf_tasks_v.attribute8%TYPE

334: , attribute4 jtf_tasks_v.attribute4%TYPE
335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE

Line 339: , attribute9 jtf_tasks_v.attribute9%TYPE

335: , attribute5 jtf_tasks_v.attribute5%TYPE
336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE

Line 340: , attribute10 jtf_tasks_v.attribute10%TYPE

336: , attribute6 jtf_tasks_v.attribute6%TYPE
337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE

Line 341: , attribute11 jtf_tasks_v.attribute11%TYPE

337: , attribute7 jtf_tasks_v.attribute7%TYPE
338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE

Line 342: , attribute12 jtf_tasks_v.attribute12%TYPE

338: , attribute8 jtf_tasks_v.attribute8%TYPE
339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE

Line 343: , attribute13 jtf_tasks_v.attribute13%TYPE

339: , attribute9 jtf_tasks_v.attribute9%TYPE
340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE

Line 344: , attribute14 jtf_tasks_v.attribute14%TYPE

340: , attribute10 jtf_tasks_v.attribute10%TYPE
341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE

Line 345: , attribute15 jtf_tasks_v.attribute15%TYPE

341: , attribute11 jtf_tasks_v.attribute11%TYPE
342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE

Line 346: , attribute_category jtf_tasks_v.attribute_category%TYPE

342: , attribute12 jtf_tasks_v.attribute12%TYPE
343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE
350: , object_version_number jtf_tasks_v.object_version_number%TYPE

Line 347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE

343: , attribute13 jtf_tasks_v.attribute13%TYPE
344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE
350: , object_version_number jtf_tasks_v.object_version_number%TYPE
351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE

Line 348: , creation_date jtf_tasks_v.creation_date%TYPE

344: , attribute14 jtf_tasks_v.attribute14%TYPE
345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE
350: , object_version_number jtf_tasks_v.object_version_number%TYPE
351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE

Line 349: , escalation_level jtf_tasks_v.escalation_level%TYPE

345: , attribute15 jtf_tasks_v.attribute15%TYPE
346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE
350: , object_version_number jtf_tasks_v.object_version_number%TYPE
351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353: , date_selected jtf_tasks_b.date_selected%TYPE

Line 350: , object_version_number jtf_tasks_v.object_version_number%TYPE

346: , attribute_category jtf_tasks_v.attribute_category%TYPE
347: , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348: , creation_date jtf_tasks_v.creation_date%TYPE
349: , escalation_level jtf_tasks_v.escalation_level%TYPE
350: , object_version_number jtf_tasks_v.object_version_number%TYPE
351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353: , date_selected jtf_tasks_b.date_selected%TYPE
354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE

Line 354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE

350: , object_version_number jtf_tasks_v.object_version_number%TYPE
351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353: , date_selected jtf_tasks_b.date_selected%TYPE
354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE
355: , child_position jtf_tasks_vl.child_position%TYPE
356: , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE
357: , location_id jtf_tasks_vl.location_id%TYPE
358: );

Line 355: , child_position jtf_tasks_vl.child_position%TYPE

351: , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353: , date_selected jtf_tasks_b.date_selected%TYPE
354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE
355: , child_position jtf_tasks_vl.child_position%TYPE
356: , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE
357: , location_id jtf_tasks_vl.location_id%TYPE
358: );
359:

Line 356: , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE

352: , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353: , date_selected jtf_tasks_b.date_selected%TYPE
354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE
355: , child_position jtf_tasks_vl.child_position%TYPE
356: , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE
357: , location_id jtf_tasks_vl.location_id%TYPE
358: );
359:
360: TYPE task_table_type IS TABLE OF task_rec

Line 357: , location_id jtf_tasks_vl.location_id%TYPE

353: , date_selected jtf_tasks_b.date_selected%TYPE
354: , task_split_flag jtf_tasks_v.task_split_flag%TYPE
355: , child_position jtf_tasks_vl.child_position%TYPE
356: , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE
357: , location_id jtf_tasks_vl.location_id%TYPE
358: );
359:
360: TYPE task_table_type IS TABLE OF task_rec
361: INDEX BY BINARY_INTEGER;

Line 1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

1739: p_api_version IN NUMBER
1740: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1741: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1742: , p_file_name IN VARCHAR2
1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

1740: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1741: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1742: , p_file_name IN VARCHAR2
1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

1741: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1742: , p_file_name IN VARCHAR2
1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

1742: , p_file_name IN VARCHAR2
1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

1743: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

1744: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

1745: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

1746: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

1747: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

1748: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

Line 1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

1749: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

Line 1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

1750: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

1751: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

1752: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

1753: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

Line 1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

1754: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

Line 1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

1755: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

1756: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

1757: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

1758: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

Line 1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

1759: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

1760: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

1761: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

1762: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

1763: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

1764: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

1765: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

1766: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

1767: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

1768: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

1769: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

1770: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

1771: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

1772: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

1773: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

1774: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

1775: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

1776: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

1777: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

1778: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1786: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

1779: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1786: , p_ref_object_id IN NUMBER DEFAULT NULL
1787: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

1780: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1786: , p_ref_object_id IN NUMBER DEFAULT NULL
1787: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1788: , p_sort_data IN sort_data

Line 1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

1781: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1786: , p_ref_object_id IN NUMBER DEFAULT NULL
1787: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1788: , p_sort_data IN sort_data
1789: , p_start_pointer IN NUMBER

Line 1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

1804: p_api_version IN NUMBER
1805: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1806: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1807: , p_file_name IN VARCHAR2
1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

1805: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1806: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1807: , p_file_name IN VARCHAR2
1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

1806: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1807: , p_file_name IN VARCHAR2
1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

1807: , p_file_name IN VARCHAR2
1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

1808: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

1809: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

1810: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

1811: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

1812: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

1813: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

Line 1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

1814: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

Line 1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

1815: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

1816: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

1817: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

1818: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

Line 1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

1819: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

Line 1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

1820: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

1821: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

1822: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

1823: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

Line 1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

1824: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

1825: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

1826: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

1827: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

1828: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

1829: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

1830: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

1831: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

1832: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

1833: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

1834: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

1835: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

1836: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

1837: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

1838: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

1839: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

1840: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

1841: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

1842: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

1843: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1851: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

1844: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1851: , p_ref_object_id IN NUMBER DEFAULT NULL
1852: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

1845: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1851: , p_ref_object_id IN NUMBER DEFAULT NULL
1852: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1853: , p_sort_data IN sort_data

Line 1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

1846: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1851: , p_ref_object_id IN NUMBER DEFAULT NULL
1852: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1853: , p_sort_data IN sort_data
1854: , p_start_pointer IN NUMBER

Line 1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

1947: PROCEDURE query_task(
1948: p_api_version IN NUMBER
1949: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1950: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

1948: p_api_version IN NUMBER
1949: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1950: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

1949: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1950: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

1950: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

1951: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

1952: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

1953: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

1954: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

1955: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

1956: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

Line 1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

1957: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

Line 1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

1958: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

1959: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

1960: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

1961: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

Line 1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

1962: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

Line 1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

1963: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

1964: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

1965: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

1966: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

Line 1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

1967: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

1968: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

1969: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

1970: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

1971: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

1972: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

1973: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

1974: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

1975: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

1976: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

1977: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

1978: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

1979: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

1980: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

1981: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

1982: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

1983: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

1984: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

1985: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

1986: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1994: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

1987: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1994: , p_ref_object_id IN NUMBER DEFAULT NULL
1995: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

1988: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1994: , p_ref_object_id IN NUMBER DEFAULT NULL
1995: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1996: , p_sort_data IN sort_data

Line 1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

1989: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1994: , p_ref_object_id IN NUMBER DEFAULT NULL
1995: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1996: , p_sort_data IN sort_data
1997: , p_start_pointer IN NUMBER

Line 2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

2011: PROCEDURE query_task(
2012: p_api_version IN NUMBER
2013: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2014: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

2012: p_api_version IN NUMBER
2013: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2014: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

2013: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2014: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

2014: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

2015: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

2016: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

2017: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

2018: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

2019: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

2020: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

Line 2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

2021: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

Line 2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

2022: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

2023: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

2024: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

2025: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

Line 2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

2026: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

Line 2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

2027: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

2028: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

2029: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

2030: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

Line 2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

2031: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

2032: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

2033: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

2034: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

2035: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

2036: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

2037: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

2038: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

2039: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

2040: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

2041: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

2042: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

2043: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

2044: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

2045: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

2046: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

2047: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

2048: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

2049: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

2050: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
2058: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

2051: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
2058: , p_ref_object_id IN NUMBER DEFAULT NULL
2059: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

2052: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
2058: , p_ref_object_id IN NUMBER DEFAULT NULL
2059: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
2060: , p_sort_data IN sort_data

Line 2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

2053: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
2058: , p_ref_object_id IN NUMBER DEFAULT NULL
2059: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
2060: , p_sort_data IN sort_data
2061: , p_start_pointer IN NUMBER

Line 2120: , p_task_id IN jtf_tasks_v.task_id%TYPE

2116: PROCEDURE query_next_task(
2117: p_api_version IN NUMBER
2118: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2119: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2120: , p_task_id IN jtf_tasks_v.task_id%TYPE
2121: , -- current task id
2122: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
2123: , -- values Dependency or Date
2124: p_date_type IN VARCHAR2 DEFAULT NULL

Line 2126: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

2122: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
2123: , -- values Dependency or Date
2124: p_date_type IN VARCHAR2 DEFAULT NULL
2125: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
2126: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2127: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2128: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2129: , p_sort_data IN sort_data
2130: , p_start_pointer IN NUMBER

Line 2127: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

2123: , -- values Dependency or Date
2124: p_date_type IN VARCHAR2 DEFAULT NULL
2125: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
2126: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2127: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2128: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2129: , p_sort_data IN sort_data
2130: , p_start_pointer IN NUMBER
2131: , p_rec_wanted IN NUMBER

Line 2128: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

2124: p_date_type IN VARCHAR2 DEFAULT NULL
2125: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
2126: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2127: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2128: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2129: , p_sort_data IN sort_data
2130: , p_start_pointer IN NUMBER
2131: , p_rec_wanted IN NUMBER
2132: , p_show_all IN VARCHAR2 DEFAULT 'Y'