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_TASK_TEMPLATES_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASK_TEMPLATES_PVT';
4:
5: PROCEDURE create_task (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_task_id IN NUMBER DEFAULT NULL,
10: p_task_name IN VARCHAR2,
11: p_task_group_id IN NUMBER,

Line 8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: PROCEDURE create_task (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_task_id IN NUMBER DEFAULT NULL,
10: p_task_name IN VARCHAR2,
11: p_task_group_id IN NUMBER,
12: p_task_type_id IN NUMBER DEFAULT NULL,

Line 65: x_return_status := fnd_api.g_ret_sts_success;

61:
62:
63: BEGIN
64: SAVEPOINT create_task_pvt1;
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: IF NOT fnd_api.compatible_api_call (
68: l_api_version,
69: p_api_version,

Line 67: IF NOT fnd_api.compatible_api_call (

63: BEGIN
64: SAVEPOINT create_task_pvt1;
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: IF NOT fnd_api.compatible_api_call (
68: l_api_version,
69: p_api_version,
70: l_api_name,
71: g_pkg_name

Line 74: RAISE fnd_api.g_exc_unexpected_error;

70: l_api_name,
71: g_pkg_name
72: )
73: THEN
74: RAISE fnd_api.g_exc_unexpected_error;
75: END IF;
76:
77: IF fnd_api.to_boolean (p_init_msg_list)
78: THEN

Line 77: IF fnd_api.to_boolean (p_init_msg_list)

73: THEN
74: RAISE fnd_api.g_exc_unexpected_error;
75: END IF;
76:
77: IF fnd_api.to_boolean (p_init_msg_list)
78: THEN
79: fnd_msg_pub.initialize;
80: END IF;
81:

Line 138: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

134: p_task_confirmation_status => 'N'
135:
136: );
137:
138: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
139: THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;

Line 140: x_return_status := fnd_api.g_ret_sts_unexp_error;

136: );
137:
138: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
139: THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;
143:
144: IF fnd_api.to_boolean (p_commit)

Line 141: RAISE fnd_api.g_exc_unexpected_error;

137:
138: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
139: THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;
143:
144: IF fnd_api.to_boolean (p_commit)
145: THEN

Line 144: IF fnd_api.to_boolean (p_commit)

140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;
143:
144: IF fnd_api.to_boolean (p_commit)
145: THEN
146: COMMIT WORK;
147: END IF;
148:

Line 151: WHEN fnd_api.g_exc_unexpected_error

147: END IF;
148:
149: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO create_task_pvt1;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: fnd_msg_pub.count_and_get (

Line 154: x_return_status := fnd_api.g_ret_sts_unexp_error;

150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO create_task_pvt1;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: fnd_msg_pub.count_and_get (
156: p_count => x_msg_count,
157: p_data => x_msg_data
158: );

Line 164: x_return_status := fnd_api.g_ret_sts_unexp_error;

160: THEN
161: ROLLBACK TO create_task_pvt1;
162: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
163: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: fnd_msg_pub.count_and_get (
166: p_count => x_msg_count,
167: p_data => x_msg_data
168: );

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

169: END;
170: -- Overloading for Simplex.
171: PROCEDURE create_task (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
174: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
175: p_task_id IN NUMBER DEFAULT NULL,
176: p_task_name IN VARCHAR2,
177: p_task_group_id IN NUMBER,

Line 174: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

170: -- Overloading for Simplex.
171: PROCEDURE create_task (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
174: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
175: p_task_id IN NUMBER DEFAULT NULL,
176: p_task_name IN VARCHAR2,
177: p_task_group_id IN NUMBER,
178: p_task_type_id IN NUMBER DEFAULT NULL,

Line 261: x_return_status := fnd_api.g_ret_sts_success;

257:
258: null;
259:
260: SAVEPOINT create_task_pvt;
261: x_return_status := fnd_api.g_ret_sts_success;
262:
263: IF NOT fnd_api.compatible_api_call (
264: l_api_version,
265: p_api_version,

Line 263: IF NOT fnd_api.compatible_api_call (

259:
260: SAVEPOINT create_task_pvt;
261: x_return_status := fnd_api.g_ret_sts_success;
262:
263: IF NOT fnd_api.compatible_api_call (
264: l_api_version,
265: p_api_version,
266: l_api_name,
267: g_pkg_name

Line 270: RAISE fnd_api.g_exc_unexpected_error;

266: l_api_name,
267: g_pkg_name
268: )
269: THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: END IF;
272:
273: IF fnd_api.to_boolean (p_init_msg_list)
274: THEN

Line 273: IF fnd_api.to_boolean (p_init_msg_list)

269: THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: END IF;
272:
273: IF fnd_api.to_boolean (p_init_msg_list)
274: THEN
275: fnd_msg_pub.initialize;
276: END IF;
277:

Line 284: x_return_status := fnd_api.g_ret_sts_unexp_error;

280: IF l_task_id < 1e+12
281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_TEMP_OUT_OF_RANGE');
283: fnd_msg_pub.add;
284: x_return_status := fnd_api.g_ret_sts_unexp_error;
285: RAISE fnd_api.g_exc_unexpected_error;
286: END IF;
287:
288: SELECT jtf_task_template_number_s.nextval

Line 285: RAISE fnd_api.g_exc_unexpected_error;

281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_TEMP_OUT_OF_RANGE');
283: fnd_msg_pub.add;
284: x_return_status := fnd_api.g_ret_sts_unexp_error;
285: RAISE fnd_api.g_exc_unexpected_error;
286: END IF;
287:
288: SELECT jtf_task_template_number_s.nextval
289: INTO l_task_number

Line 312: x_return_status := fnd_api.g_ret_sts_unexp_error;

308: WHEN NO_DATA_FOUND
309: THEN
310: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
311: fnd_msg_pub.add;
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313: RAISE fnd_api.g_exc_unexpected_error;
314: WHEN TOO_MANY_ROWS
315: THEN
316: NULL;

Line 313: RAISE fnd_api.g_exc_unexpected_error;

309: THEN
310: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
311: fnd_msg_pub.add;
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313: RAISE fnd_api.g_exc_unexpected_error;
314: WHEN TOO_MANY_ROWS
315: THEN
316: NULL;
317: END;

Line 380: x_return_status := fnd_api.g_ret_sts_unexp_error;

376: FETCH c_jtf_tasks INTO x;
377:
378: IF c_jtf_tasks%NOTFOUND
379: THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATION_TEMP');
382: fnd_msg_pub.add;
383: RAISE fnd_api.g_exc_unexpected_error;
384: ELSE

Line 383: RAISE fnd_api.g_exc_unexpected_error;

379: THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATION_TEMP');
382: fnd_msg_pub.add;
383: RAISE fnd_api.g_exc_unexpected_error;
384: ELSE
385: x_task_id := l_task_id;
386: END IF;
387:

Line 388: IF fnd_api.to_boolean (p_commit)

384: ELSE
385: x_task_id := l_task_id;
386: END IF;
387:
388: IF fnd_api.to_boolean (p_commit)
389: THEN
390: COMMIT WORK;
391: END IF;
392:

Line 395: WHEN fnd_api.g_exc_unexpected_error

391: END IF;
392:
393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
394: EXCEPTION
395: WHEN fnd_api.g_exc_unexpected_error
396: THEN
397: ROLLBACK TO create_task_pvt;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_msg_pub.count_and_get (

Line 398: x_return_status := fnd_api.g_ret_sts_unexp_error;

394: EXCEPTION
395: WHEN fnd_api.g_exc_unexpected_error
396: THEN
397: ROLLBACK TO create_task_pvt;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_msg_pub.count_and_get (
400: p_count => x_msg_count,
401: p_data => x_msg_data
402: );

Line 408: x_return_status := fnd_api.g_ret_sts_unexp_error;

404: THEN
405: ROLLBACK TO create_task_pvt;
406: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
407: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409: fnd_msg_pub.count_and_get (
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );

Line 417: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

413: END;
414:
415: PROCEDURE update_task (
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
418: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_object_version_number IN OUT NOCOPY NUMBER,
420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
421: p_task_name IN VARCHAR2

Line 418: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

414:
415: PROCEDURE update_task (
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
418: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_object_version_number IN OUT NOCOPY NUMBER,
420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
421: p_task_name IN VARCHAR2
422: DEFAULT fnd_api.g_miss_char,

Line 420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,

416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
418: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_object_version_number IN OUT NOCOPY NUMBER,
420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
421: p_task_name IN VARCHAR2
422: DEFAULT fnd_api.g_miss_char,
423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,

Line 422: DEFAULT fnd_api.g_miss_char,

418: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_object_version_number IN OUT NOCOPY NUMBER,
420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
421: p_task_name IN VARCHAR2
422: DEFAULT fnd_api.g_miss_char,
423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 424: DEFAULT fnd_api.g_miss_char,

420: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
421: p_task_name IN VARCHAR2
422: DEFAULT fnd_api.g_miss_char,
423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

421: p_task_name IN VARCHAR2
422: DEFAULT fnd_api.g_miss_char,
423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2

Line 426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

422: DEFAULT fnd_api.g_miss_char,
423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,

Line 427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

423: p_description IN VARCHAR2
424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,
431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

424: DEFAULT fnd_api.g_miss_char,
425: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,
431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
432: p_planned_effort_uom IN VARCHAR2

Line 430: DEFAULT fnd_api.g_miss_char,

426: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,
431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
432: p_planned_effort_uom IN VARCHAR2
433: DEFAULT fnd_api.g_miss_char,
434: p_private_flag IN VARCHAR2

Line 431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

427: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
428: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,
431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
432: p_planned_effort_uom IN VARCHAR2
433: DEFAULT fnd_api.g_miss_char,
434: p_private_flag IN VARCHAR2
435: DEFAULT fnd_api.g_miss_char,

Line 433: DEFAULT fnd_api.g_miss_char,

429: p_duration_uom IN VARCHAR2
430: DEFAULT fnd_api.g_miss_char,
431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
432: p_planned_effort_uom IN VARCHAR2
433: DEFAULT fnd_api.g_miss_char,
434: p_private_flag IN VARCHAR2
435: DEFAULT fnd_api.g_miss_char,
436: p_publish_flag IN VARCHAR2
437: DEFAULT fnd_api.g_miss_char,

Line 435: DEFAULT fnd_api.g_miss_char,

431: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
432: p_planned_effort_uom IN VARCHAR2
433: DEFAULT fnd_api.g_miss_char,
434: p_private_flag IN VARCHAR2
435: DEFAULT fnd_api.g_miss_char,
436: p_publish_flag IN VARCHAR2
437: DEFAULT fnd_api.g_miss_char,
438: p_restrict_closure_flag IN VARCHAR2
439: DEFAULT fnd_api.g_miss_char,

Line 437: DEFAULT fnd_api.g_miss_char,

433: DEFAULT fnd_api.g_miss_char,
434: p_private_flag IN VARCHAR2
435: DEFAULT fnd_api.g_miss_char,
436: p_publish_flag IN VARCHAR2
437: DEFAULT fnd_api.g_miss_char,
438: p_restrict_closure_flag IN VARCHAR2
439: DEFAULT fnd_api.g_miss_char,
440: p_multi_booked_flag IN VARCHAR2
441: DEFAULT fnd_api.g_miss_char,

Line 439: DEFAULT fnd_api.g_miss_char,

435: DEFAULT fnd_api.g_miss_char,
436: p_publish_flag IN VARCHAR2
437: DEFAULT fnd_api.g_miss_char,
438: p_restrict_closure_flag IN VARCHAR2
439: DEFAULT fnd_api.g_miss_char,
440: p_multi_booked_flag IN VARCHAR2
441: DEFAULT fnd_api.g_miss_char,
442: p_milestone_flag IN VARCHAR2
443: DEFAULT fnd_api.g_miss_char,

Line 441: DEFAULT fnd_api.g_miss_char,

437: DEFAULT fnd_api.g_miss_char,
438: p_restrict_closure_flag IN VARCHAR2
439: DEFAULT fnd_api.g_miss_char,
440: p_multi_booked_flag IN VARCHAR2
441: DEFAULT fnd_api.g_miss_char,
442: p_milestone_flag IN VARCHAR2
443: DEFAULT fnd_api.g_miss_char,
444: p_holiday_flag IN VARCHAR2
445: DEFAULT fnd_api.g_miss_char,

Line 443: DEFAULT fnd_api.g_miss_char,

439: DEFAULT fnd_api.g_miss_char,
440: p_multi_booked_flag IN VARCHAR2
441: DEFAULT fnd_api.g_miss_char,
442: p_milestone_flag IN VARCHAR2
443: DEFAULT fnd_api.g_miss_char,
444: p_holiday_flag IN VARCHAR2
445: DEFAULT fnd_api.g_miss_char,
446: p_billable_flag IN VARCHAR2
447: DEFAULT fnd_api.g_miss_char,

Line 445: DEFAULT fnd_api.g_miss_char,

441: DEFAULT fnd_api.g_miss_char,
442: p_milestone_flag IN VARCHAR2
443: DEFAULT fnd_api.g_miss_char,
444: p_holiday_flag IN VARCHAR2
445: DEFAULT fnd_api.g_miss_char,
446: p_billable_flag IN VARCHAR2
447: DEFAULT fnd_api.g_miss_char,
448: p_notification_flag IN VARCHAR2
449: DEFAULT fnd_api.g_miss_char,

Line 447: DEFAULT fnd_api.g_miss_char,

443: DEFAULT fnd_api.g_miss_char,
444: p_holiday_flag IN VARCHAR2
445: DEFAULT fnd_api.g_miss_char,
446: p_billable_flag IN VARCHAR2
447: DEFAULT fnd_api.g_miss_char,
448: p_notification_flag IN VARCHAR2
449: DEFAULT fnd_api.g_miss_char,
450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
451: p_notification_period_uom IN VARCHAR2

Line 449: DEFAULT fnd_api.g_miss_char,

445: DEFAULT fnd_api.g_miss_char,
446: p_billable_flag IN VARCHAR2
447: DEFAULT fnd_api.g_miss_char,
448: p_notification_flag IN VARCHAR2
449: DEFAULT fnd_api.g_miss_char,
450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
451: p_notification_period_uom IN VARCHAR2
452: DEFAULT fnd_api.g_miss_char,
453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

446: p_billable_flag IN VARCHAR2
447: DEFAULT fnd_api.g_miss_char,
448: p_notification_flag IN VARCHAR2
449: DEFAULT fnd_api.g_miss_char,
450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
451: p_notification_period_uom IN VARCHAR2
452: DEFAULT fnd_api.g_miss_char,
453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
454: p_alarm_start_uom IN VARCHAR2

Line 452: DEFAULT fnd_api.g_miss_char,

448: p_notification_flag IN VARCHAR2
449: DEFAULT fnd_api.g_miss_char,
450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
451: p_notification_period_uom IN VARCHAR2
452: DEFAULT fnd_api.g_miss_char,
453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
454: p_alarm_start_uom IN VARCHAR2
455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2

Line 453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

449: DEFAULT fnd_api.g_miss_char,
450: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
451: p_notification_period_uom IN VARCHAR2
452: DEFAULT fnd_api.g_miss_char,
453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
454: p_alarm_start_uom IN VARCHAR2
455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,

Line 455: DEFAULT fnd_api.g_miss_char,

451: p_notification_period_uom IN VARCHAR2
452: DEFAULT fnd_api.g_miss_char,
453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
454: p_alarm_start_uom IN VARCHAR2
455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,
458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 457: DEFAULT fnd_api.g_miss_char,

453: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
454: p_alarm_start_uom IN VARCHAR2
455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,
458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
461: p_alarm_interval_uom IN VARCHAR2

Line 458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

454: p_alarm_start_uom IN VARCHAR2
455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,
458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
461: p_alarm_interval_uom IN VARCHAR2
462: DEFAULT fnd_api.g_miss_char,

Line 459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,

455: DEFAULT fnd_api.g_miss_char,
456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,
458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
461: p_alarm_interval_uom IN VARCHAR2
462: DEFAULT fnd_api.g_miss_char,
463: x_return_status OUT NOCOPY VARCHAR2,

Line 460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

456: p_alarm_on IN VARCHAR2
457: DEFAULT fnd_api.g_miss_char,
458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
461: p_alarm_interval_uom IN VARCHAR2
462: DEFAULT fnd_api.g_miss_char,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,

Line 462: DEFAULT fnd_api.g_miss_char,

458: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
459: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
460: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
461: p_alarm_interval_uom IN VARCHAR2
462: DEFAULT fnd_api.g_miss_char,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 488: x_return_status := fnd_api.g_ret_sts_success;

484: l_api_version CONSTANT NUMBER := 1.0;
485: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
486: BEGIN
487: SAVEPOINT update_task_pvt1;
488: x_return_status := fnd_api.g_ret_sts_success;
489:
490: IF NOT fnd_api.compatible_api_call (
491: l_api_version,
492: p_api_version,

Line 490: IF NOT fnd_api.compatible_api_call (

486: BEGIN
487: SAVEPOINT update_task_pvt1;
488: x_return_status := fnd_api.g_ret_sts_success;
489:
490: IF NOT fnd_api.compatible_api_call (
491: l_api_version,
492: p_api_version,
493: l_api_name,
494: g_pkg_name

Line 497: RAISE fnd_api.g_exc_unexpected_error;

493: l_api_name,
494: g_pkg_name
495: )
496: THEN
497: RAISE fnd_api.g_exc_unexpected_error;
498: END IF;
499:
500: IF fnd_api.to_boolean (p_init_msg_list)
501: THEN

Line 500: IF fnd_api.to_boolean (p_init_msg_list)

496: THEN
497: RAISE fnd_api.g_exc_unexpected_error;
498: END IF;
499:
500: IF fnd_api.to_boolean (p_init_msg_list)
501: THEN
502: fnd_msg_pub.initialize;
503: END IF;
504:

Line 559: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

555: p_attribute_category => p_attribute_category,
556: p_task_confirmation_status => 'N'
557: );
558:
559: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
560: THEN
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;

Line 561: x_return_status := fnd_api.g_ret_sts_unexp_error;

557: );
558:
559: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
560: THEN
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:
565: IF fnd_api.to_boolean (p_commit)

Line 562: RAISE fnd_api.g_exc_unexpected_error;

558:
559: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
560: THEN
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:
565: IF fnd_api.to_boolean (p_commit)
566: THEN

Line 565: IF fnd_api.to_boolean (p_commit)

561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:
565: IF fnd_api.to_boolean (p_commit)
566: THEN
567: COMMIT WORK;
568: END IF;
569:

Line 572: WHEN fnd_api.g_exc_unexpected_error

568: END IF;
569:
570: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571: EXCEPTION
572: WHEN fnd_api.g_exc_unexpected_error
573: THEN
574: ROLLBACK TO update_task_pvt1;
575: x_return_status := fnd_api.g_ret_sts_unexp_error;
576: fnd_msg_pub.count_and_get (

Line 575: x_return_status := fnd_api.g_ret_sts_unexp_error;

571: EXCEPTION
572: WHEN fnd_api.g_exc_unexpected_error
573: THEN
574: ROLLBACK TO update_task_pvt1;
575: x_return_status := fnd_api.g_ret_sts_unexp_error;
576: fnd_msg_pub.count_and_get (
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );

Line 585: x_return_status := fnd_api.g_ret_sts_unexp_error;

581: THEN
582: ROLLBACK TO update_task_pvt1;
583: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
584: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get (
587: p_count => x_msg_count,
588: p_data => x_msg_data
589: );

Line 594: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

590: END;
591:
592: PROCEDURE update_task (
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
595: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
596: p_object_version_number IN OUT NOCOPY NUMBER,
597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
598: p_task_name IN VARCHAR2

Line 595: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

591:
592: PROCEDURE update_task (
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
595: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
596: p_object_version_number IN OUT NOCOPY NUMBER,
597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
598: p_task_name IN VARCHAR2
599: DEFAULT fnd_api.g_miss_char,

Line 597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,

593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
595: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
596: p_object_version_number IN OUT NOCOPY NUMBER,
597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
598: p_task_name IN VARCHAR2
599: DEFAULT fnd_api.g_miss_char,
600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,

Line 599: DEFAULT fnd_api.g_miss_char,

595: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
596: p_object_version_number IN OUT NOCOPY NUMBER,
597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
598: p_task_name IN VARCHAR2
599: DEFAULT fnd_api.g_miss_char,
600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 601: DEFAULT fnd_api.g_miss_char,

597: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
598: p_task_name IN VARCHAR2
599: DEFAULT fnd_api.g_miss_char,
600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

598: p_task_name IN VARCHAR2
599: DEFAULT fnd_api.g_miss_char,
600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2

Line 603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

599: DEFAULT fnd_api.g_miss_char,
600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,

Line 604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

600: p_description IN VARCHAR2
601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,
608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

601: DEFAULT fnd_api.g_miss_char,
602: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,
608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
609: p_planned_effort_uom IN VARCHAR2

Line 607: DEFAULT fnd_api.g_miss_char,

603: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,
608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
609: p_planned_effort_uom IN VARCHAR2
610: DEFAULT fnd_api.g_miss_char,
611: p_private_flag IN VARCHAR2

Line 608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

604: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
605: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,
608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
609: p_planned_effort_uom IN VARCHAR2
610: DEFAULT fnd_api.g_miss_char,
611: p_private_flag IN VARCHAR2
612: DEFAULT fnd_api.g_miss_char,

Line 610: DEFAULT fnd_api.g_miss_char,

606: p_duration_uom IN VARCHAR2
607: DEFAULT fnd_api.g_miss_char,
608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
609: p_planned_effort_uom IN VARCHAR2
610: DEFAULT fnd_api.g_miss_char,
611: p_private_flag IN VARCHAR2
612: DEFAULT fnd_api.g_miss_char,
613: p_publish_flag IN VARCHAR2
614: DEFAULT fnd_api.g_miss_char,

Line 612: DEFAULT fnd_api.g_miss_char,

608: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
609: p_planned_effort_uom IN VARCHAR2
610: DEFAULT fnd_api.g_miss_char,
611: p_private_flag IN VARCHAR2
612: DEFAULT fnd_api.g_miss_char,
613: p_publish_flag IN VARCHAR2
614: DEFAULT fnd_api.g_miss_char,
615: p_restrict_closure_flag IN VARCHAR2
616: DEFAULT fnd_api.g_miss_char,

Line 614: DEFAULT fnd_api.g_miss_char,

610: DEFAULT fnd_api.g_miss_char,
611: p_private_flag IN VARCHAR2
612: DEFAULT fnd_api.g_miss_char,
613: p_publish_flag IN VARCHAR2
614: DEFAULT fnd_api.g_miss_char,
615: p_restrict_closure_flag IN VARCHAR2
616: DEFAULT fnd_api.g_miss_char,
617: p_multi_booked_flag IN VARCHAR2
618: DEFAULT fnd_api.g_miss_char,

Line 616: DEFAULT fnd_api.g_miss_char,

612: DEFAULT fnd_api.g_miss_char,
613: p_publish_flag IN VARCHAR2
614: DEFAULT fnd_api.g_miss_char,
615: p_restrict_closure_flag IN VARCHAR2
616: DEFAULT fnd_api.g_miss_char,
617: p_multi_booked_flag IN VARCHAR2
618: DEFAULT fnd_api.g_miss_char,
619: p_milestone_flag IN VARCHAR2
620: DEFAULT fnd_api.g_miss_char,

Line 618: DEFAULT fnd_api.g_miss_char,

614: DEFAULT fnd_api.g_miss_char,
615: p_restrict_closure_flag IN VARCHAR2
616: DEFAULT fnd_api.g_miss_char,
617: p_multi_booked_flag IN VARCHAR2
618: DEFAULT fnd_api.g_miss_char,
619: p_milestone_flag IN VARCHAR2
620: DEFAULT fnd_api.g_miss_char,
621: p_holiday_flag IN VARCHAR2
622: DEFAULT fnd_api.g_miss_char,

Line 620: DEFAULT fnd_api.g_miss_char,

616: DEFAULT fnd_api.g_miss_char,
617: p_multi_booked_flag IN VARCHAR2
618: DEFAULT fnd_api.g_miss_char,
619: p_milestone_flag IN VARCHAR2
620: DEFAULT fnd_api.g_miss_char,
621: p_holiday_flag IN VARCHAR2
622: DEFAULT fnd_api.g_miss_char,
623: p_billable_flag IN VARCHAR2
624: DEFAULT fnd_api.g_miss_char,

Line 622: DEFAULT fnd_api.g_miss_char,

618: DEFAULT fnd_api.g_miss_char,
619: p_milestone_flag IN VARCHAR2
620: DEFAULT fnd_api.g_miss_char,
621: p_holiday_flag IN VARCHAR2
622: DEFAULT fnd_api.g_miss_char,
623: p_billable_flag IN VARCHAR2
624: DEFAULT fnd_api.g_miss_char,
625: p_notification_flag IN VARCHAR2
626: DEFAULT fnd_api.g_miss_char,

Line 624: DEFAULT fnd_api.g_miss_char,

620: DEFAULT fnd_api.g_miss_char,
621: p_holiday_flag IN VARCHAR2
622: DEFAULT fnd_api.g_miss_char,
623: p_billable_flag IN VARCHAR2
624: DEFAULT fnd_api.g_miss_char,
625: p_notification_flag IN VARCHAR2
626: DEFAULT fnd_api.g_miss_char,
627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
628: p_notification_period_uom IN VARCHAR2

Line 626: DEFAULT fnd_api.g_miss_char,

622: DEFAULT fnd_api.g_miss_char,
623: p_billable_flag IN VARCHAR2
624: DEFAULT fnd_api.g_miss_char,
625: p_notification_flag IN VARCHAR2
626: DEFAULT fnd_api.g_miss_char,
627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
628: p_notification_period_uom IN VARCHAR2
629: DEFAULT fnd_api.g_miss_char,
630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

623: p_billable_flag IN VARCHAR2
624: DEFAULT fnd_api.g_miss_char,
625: p_notification_flag IN VARCHAR2
626: DEFAULT fnd_api.g_miss_char,
627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
628: p_notification_period_uom IN VARCHAR2
629: DEFAULT fnd_api.g_miss_char,
630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
631: p_alarm_start_uom IN VARCHAR2

Line 629: DEFAULT fnd_api.g_miss_char,

625: p_notification_flag IN VARCHAR2
626: DEFAULT fnd_api.g_miss_char,
627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
628: p_notification_period_uom IN VARCHAR2
629: DEFAULT fnd_api.g_miss_char,
630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
631: p_alarm_start_uom IN VARCHAR2
632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2

Line 630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

626: DEFAULT fnd_api.g_miss_char,
627: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
628: p_notification_period_uom IN VARCHAR2
629: DEFAULT fnd_api.g_miss_char,
630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
631: p_alarm_start_uom IN VARCHAR2
632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,

Line 632: DEFAULT fnd_api.g_miss_char,

628: p_notification_period_uom IN VARCHAR2
629: DEFAULT fnd_api.g_miss_char,
630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
631: p_alarm_start_uom IN VARCHAR2
632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,
635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 634: DEFAULT fnd_api.g_miss_char,

630: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
631: p_alarm_start_uom IN VARCHAR2
632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,
635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
638: p_alarm_interval_uom IN VARCHAR2

Line 635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

631: p_alarm_start_uom IN VARCHAR2
632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,
635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
638: p_alarm_interval_uom IN VARCHAR2
639: DEFAULT fnd_api.g_miss_char,

Line 636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,

632: DEFAULT fnd_api.g_miss_char,
633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,
635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
638: p_alarm_interval_uom IN VARCHAR2
639: DEFAULT fnd_api.g_miss_char,
640: x_return_status OUT NOCOPY VARCHAR2,

Line 637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

633: p_alarm_on IN VARCHAR2
634: DEFAULT fnd_api.g_miss_char,
635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
638: p_alarm_interval_uom IN VARCHAR2
639: DEFAULT fnd_api.g_miss_char,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,

Line 639: DEFAULT fnd_api.g_miss_char,

635: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
636: p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num,
637: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
638: p_alarm_interval_uom IN VARCHAR2
639: DEFAULT fnd_api.g_miss_char,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 699: fnd_api.g_miss_char, task_name,

695: recurrence_rule_id,
696: task_group_id,
697: DECODE (
698: p_task_name,
699: fnd_api.g_miss_char, task_name,
700: p_task_name
701: ) task_name,
702: DECODE (
703: p_task_type_id,

Line 704: fnd_api.g_miss_num, task_type_id,

700: p_task_name
701: ) task_name,
702: DECODE (
703: p_task_type_id,
704: fnd_api.g_miss_num, task_type_id,
705: p_task_type_id
706: ) task_type_id,
707: DECODE (
708: p_description,

Line 709: fnd_api.g_miss_char, description,

705: p_task_type_id
706: ) task_type_id,
707: DECODE (
708: p_description,
709: fnd_api.g_miss_char, description,
710: p_description
711: ) description,
712: DECODE (
713: p_task_status_id,

Line 714: fnd_api.g_miss_num, task_status_id,

710: p_description
711: ) description,
712: DECODE (
713: p_task_status_id,
714: fnd_api.g_miss_num, task_status_id,
715: p_task_status_id
716: ) task_status_id,
717: DECODE (
718: p_task_priority_id,

Line 719: fnd_api.g_miss_num, task_priority_id,

715: p_task_status_id
716: ) task_status_id,
717: DECODE (
718: p_task_priority_id,
719: fnd_api.g_miss_num, task_priority_id,
720: p_task_priority_id
721: ) task_priority_id,
722: DECODE (
723: p_duration,

Line 724: fnd_api.g_miss_num,

720: p_task_priority_id
721: ) task_priority_id,
722: DECODE (
723: p_duration,
724: fnd_api.g_miss_num,
725: duration,
726: p_duration
727: ) duration,
728: DECODE (

Line 730: fnd_api.g_miss_char,

726: p_duration
727: ) duration,
728: DECODE (
729: p_duration_uom,
730: fnd_api.g_miss_char,
731: duration_uom,
732: p_duration_uom
733: ) duration_uom,
734: DECODE (

Line 736: fnd_api.g_miss_num,

732: p_duration_uom
733: ) duration_uom,
734: DECODE (
735: p_planned_effort,
736: fnd_api.g_miss_num,
737: planned_effort,
738: p_planned_effort
739: ) planned_effort,
740: DECODE (

Line 742: fnd_api.g_miss_char,

738: p_planned_effort
739: ) planned_effort,
740: DECODE (
741: p_planned_effort_uom,
742: fnd_api.g_miss_char,
743: planned_effort_uom,
744: p_planned_effort_uom
745: ) planned_effort_uom,
746: DECODE (

Line 748: fnd_api.g_miss_char,

744: p_planned_effort_uom
745: ) planned_effort_uom,
746: DECODE (
747: p_private_flag,
748: fnd_api.g_miss_char,
749: private_flag,
750: p_private_flag
751: ) private_flag,
752: DECODE (

Line 754: fnd_api.g_miss_char,

750: p_private_flag
751: ) private_flag,
752: DECODE (
753: p_publish_flag,
754: fnd_api.g_miss_char,
755: publish_flag,
756: p_publish_flag
757: ) publish_flag,
758: DECODE (

Line 760: fnd_api.g_miss_char,

756: p_publish_flag
757: ) publish_flag,
758: DECODE (
759: p_restrict_closure_flag,
760: fnd_api.g_miss_char,
761: restrict_closure_flag,
762: p_restrict_closure_flag
763: ) restrict_closure_flag,
764: DECODE (

Line 766: fnd_api.g_miss_char,

762: p_restrict_closure_flag
763: ) restrict_closure_flag,
764: DECODE (
765: p_multi_booked_flag,
766: fnd_api.g_miss_char,
767: multi_booked_flag,
768: p_multi_booked_flag
769: ) multi_booked_flag,
770: DECODE (

Line 772: fnd_api.g_miss_char,

768: p_multi_booked_flag
769: ) multi_booked_flag,
770: DECODE (
771: p_milestone_flag,
772: fnd_api.g_miss_char,
773: milestone_flag,
774: p_milestone_flag
775: ) milestone_flag,
776: DECODE (

Line 778: fnd_api.g_miss_char,

774: p_milestone_flag
775: ) milestone_flag,
776: DECODE (
777: p_holiday_flag,
778: fnd_api.g_miss_char,
779: holiday_flag,
780: p_holiday_flag
781: ) holiday_flag,
782: DECODE (

Line 784: fnd_api.g_miss_char,

780: p_holiday_flag
781: ) holiday_flag,
782: DECODE (
783: p_billable_flag,
784: fnd_api.g_miss_char,
785: billable_flag,
786: p_billable_flag
787: ) billable_flag,
788: DECODE (

Line 790: fnd_api.g_miss_char,

786: p_billable_flag
787: ) billable_flag,
788: DECODE (
789: p_notification_flag,
790: fnd_api.g_miss_char,
791: notification_flag,
792: p_notification_flag
793: ) notification_flag,
794: DECODE (

Line 796: fnd_api.g_miss_num,

792: p_notification_flag
793: ) notification_flag,
794: DECODE (
795: p_notification_period,
796: fnd_api.g_miss_num,
797: notification_period,
798: p_notification_period
799: ) notification_period,
800: DECODE (

Line 802: fnd_api.g_miss_char,

798: p_notification_period
799: ) notification_period,
800: DECODE (
801: p_notification_period_uom,
802: fnd_api.g_miss_char,
803: notification_period_uom,
804: p_notification_period_uom
805: ) notification_period_uom,
806: DECODE (

Line 808: fnd_api.g_miss_num,

804: p_notification_period_uom
805: ) notification_period_uom,
806: DECODE (
807: p_alarm_start,
808: fnd_api.g_miss_num,
809: alarm_start,
810: p_alarm_start
811: ) alarm_start,
812: DECODE (

Line 814: fnd_api.g_miss_char,

810: p_alarm_start
811: ) alarm_start,
812: DECODE (
813: p_alarm_start_uom,
814: fnd_api.g_miss_char,
815: alarm_start_uom,
816: p_alarm_start_uom
817: ) alarm_start_uom,
818: DECODE (

Line 820: fnd_api.g_miss_char,

816: p_alarm_start_uom
817: ) alarm_start_uom,
818: DECODE (
819: p_alarm_on,
820: fnd_api.g_miss_char,
821: alarm_on,
822: p_alarm_on
823: ) alarm_on,
824: DECODE (

Line 826: fnd_api.g_miss_num,

822: p_alarm_on
823: ) alarm_on,
824: DECODE (
825: p_alarm_count,
826: fnd_api.g_miss_num,
827: alarm_count,
828: p_alarm_count
829: ) alarm_count,
830: DECODE (

Line 832: fnd_api.g_miss_num,

828: p_alarm_count
829: ) alarm_count,
830: DECODE (
831: p_alarm_interval,
832: fnd_api.g_miss_num,
833: alarm_interval,
834: p_alarm_interval
835: ) alarm_interval,
836: DECODE (

Line 838: fnd_api.g_miss_char,

834: p_alarm_interval
835: ) alarm_interval,
836: DECODE (
837: p_alarm_interval_uom,
838: fnd_api.g_miss_char,
839: alarm_interval_uom,
840: p_alarm_interval_uom
841: ) alarm_interval_uom,
842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

Line 842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

838: fnd_api.g_miss_char,
839: alarm_interval_uom,
840: p_alarm_interval_uom
841: ) alarm_interval_uom,
842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

Line 843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,

839: alarm_interval_uom,
840: p_alarm_interval_uom
841: ) alarm_interval_uom,
842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

Line 844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,

840: p_alarm_interval_uom
841: ) alarm_interval_uom,
842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

Line 845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,

841: ) alarm_interval_uom,
842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

Line 846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

842: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

Line 847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

843: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

Line 848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

844: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

Line 849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

845: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

Line 850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

846: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

Line 851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

847: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

Line 852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

848: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

Line 853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

849: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,

Line 854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

850: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
858: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)

Line 855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

851: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
858: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
859: task_confirmation_status

Line 856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

852: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
858: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
859: task_confirmation_status
860: FROM jtf_task_templates_vl

Line 857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,

853: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
858: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
859: task_confirmation_status
860: FROM jtf_task_templates_vl
861: WHERE task_template_id =

Line 874: x_return_status := fnd_api.g_ret_sts_unexp_error;

870: THEN
871: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
872: fnd_message.set_token ('JTF_TASK_INVALID_TEMP', p_task_id);
873: fnd_msg_pub.add;
874: x_return_status := fnd_api.g_ret_sts_unexp_error;
875: RAISE fnd_api.g_exc_unexpected_error;
876: END IF;
877:
878: l_task_id := p_task_id;

Line 875: RAISE fnd_api.g_exc_unexpected_error;

871: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
872: fnd_message.set_token ('JTF_TASK_INVALID_TEMP', p_task_id);
873: fnd_msg_pub.add;
874: x_return_status := fnd_api.g_ret_sts_unexp_error;
875: RAISE fnd_api.g_exc_unexpected_error;
876: END IF;
877:
878: l_task_id := p_task_id;
879: l_task_name := tasks.task_name;

Line 909: P_INIT_MSG_LIST => fnd_api.g_false ,

905: l_task_confirmation_status := tasks.task_confirmation_status;
906:
907: jtf_task_templates_pub.lock_task
908: ( P_API_VERSION => 1.0 ,
909: P_INIT_MSG_LIST => fnd_api.g_false ,
910: P_COMMIT => fnd_api.g_false ,
911: P_TASK_ID => l_task_id ,
912: P_OBJECT_VERSION_NUMBER => p_object_version_number,
913: X_RETURN_STATUS => x_return_status ,

Line 910: P_COMMIT => fnd_api.g_false ,

906:
907: jtf_task_templates_pub.lock_task
908: ( P_API_VERSION => 1.0 ,
909: P_INIT_MSG_LIST => fnd_api.g_false ,
910: P_COMMIT => fnd_api.g_false ,
911: P_TASK_ID => l_task_id ,
912: P_OBJECT_VERSION_NUMBER => p_object_version_number,
913: X_RETURN_STATUS => x_return_status ,
914: X_MSG_DATA => x_msg_data ,

Line 917: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

913: X_RETURN_STATUS => x_return_status ,
914: X_MSG_DATA => x_msg_data ,
915: X_MSG_COUNT => x_msg_count ) ;
916:
917: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
918: THEN
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END IF;

Line 919: x_return_status := fnd_api.g_ret_sts_unexp_error;

915: X_MSG_COUNT => x_msg_count ) ;
916:
917: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
918: THEN
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END IF;
922:
923: jtf_task_templates_pkg.update_row (

Line 920: RAISE fnd_api.g_exc_unexpected_error;

916:
917: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
918: THEN
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: RAISE fnd_api.g_exc_unexpected_error;
921: END IF;
922:
923: jtf_task_templates_pkg.update_row (
924: x_task_template_id => l_task_id,

Line 983: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

979: END;
980:
981: PROCEDURE delete_task (
982: p_api_version IN NUMBER,
983: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
984: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
985: p_object_version_number IN NUMBER,
986: p_task_id IN NUMBER,
987: x_return_status OUT NOCOPY VARCHAR2,

Line 984: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

980:
981: PROCEDURE delete_task (
982: p_api_version IN NUMBER,
983: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
984: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
985: p_object_version_number IN NUMBER,
986: p_task_id IN NUMBER,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,

Line 1003: x_return_status := fnd_api.g_ret_sts_success;

999: OR dependent_on_task_id = l_task_id)
1000: AND (template_flag = jtf_task_utl.g_yes);
1001: BEGIN
1002: SAVEPOINT delete_task_pvt;
1003: x_return_status := fnd_api.g_ret_sts_success;
1004:
1005: ---------------------------
1006: ---- delete dependencies
1007: ---------------------------

Line 1012: p_init_msg_list => fnd_api.g_false,

1008: FOR a IN c_dependencies
1009: LOOP
1010: jtf_task_dependency_pub.delete_task_dependency (
1011: p_api_version => 1.0,
1012: p_init_msg_list => fnd_api.g_false,
1013: p_commit => fnd_api.g_false,
1014: p_object_version_number => a.object_version_number,
1015: p_dependency_id => a.dependency_id,
1016: x_return_status => x_return_status,

Line 1013: p_commit => fnd_api.g_false,

1009: LOOP
1010: jtf_task_dependency_pub.delete_task_dependency (
1011: p_api_version => 1.0,
1012: p_init_msg_list => fnd_api.g_false,
1013: p_commit => fnd_api.g_false,
1014: p_object_version_number => a.object_version_number,
1015: p_dependency_id => a.dependency_id,
1016: x_return_status => x_return_status,
1017: x_msg_count => x_msg_count,

Line 1021: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1017: x_msg_count => x_msg_count,
1018: x_msg_data => x_msg_data
1019: );
1020:
1021: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1022: THEN
1023: x_return_status := fnd_api.g_ret_sts_unexp_error;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;

Line 1023: x_return_status := fnd_api.g_ret_sts_unexp_error;

1019: );
1020:
1021: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1022: THEN
1023: x_return_status := fnd_api.g_ret_sts_unexp_error;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END LOOP;
1027:

Line 1024: RAISE fnd_api.g_exc_unexpected_error;

1020:
1021: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1022: THEN
1023: x_return_status := fnd_api.g_ret_sts_unexp_error;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END LOOP;
1027:
1028: jtf_task_templates_pub.lock_task

Line 1030: P_INIT_MSG_LIST => fnd_api.g_false ,

1026: END LOOP;
1027:
1028: jtf_task_templates_pub.lock_task
1029: ( P_API_VERSION => 1.0 ,
1030: P_INIT_MSG_LIST => fnd_api.g_false ,
1031: P_COMMIT => fnd_api.g_false ,
1032: P_TASK_ID => l_task_id ,
1033: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1034: X_RETURN_STATUS => x_return_status ,

Line 1031: P_COMMIT => fnd_api.g_false ,

1027:
1028: jtf_task_templates_pub.lock_task
1029: ( P_API_VERSION => 1.0 ,
1030: P_INIT_MSG_LIST => fnd_api.g_false ,
1031: P_COMMIT => fnd_api.g_false ,
1032: P_TASK_ID => l_task_id ,
1033: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1034: X_RETURN_STATUS => x_return_status ,
1035: X_MSG_DATA => x_msg_data ,

Line 1038: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1034: X_RETURN_STATUS => x_return_status ,
1035: X_MSG_DATA => x_msg_data ,
1036: X_MSG_COUNT => x_msg_count ) ;
1037:
1038: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1039: THEN
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;

Line 1040: x_return_status := fnd_api.g_ret_sts_unexp_error;

1036: X_MSG_COUNT => x_msg_count ) ;
1037:
1038: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1039: THEN
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043:
1044: UPDATE jtf_task_templates_b

Line 1041: RAISE fnd_api.g_exc_unexpected_error;

1037:
1038: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1039: THEN
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043:
1044: UPDATE jtf_task_templates_b
1045: SET deleted_flag = 'Y'

Line 1052: x_return_status := fnd_api.g_ret_sts_unexp_error;

1048: IF SQL%NOTFOUND
1049: THEN
1050: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_DELETING_TEMP');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_unexp_error;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055:
1056: IF fnd_api.to_boolean (p_commit)

Line 1053: RAISE fnd_api.g_exc_unexpected_error;

1049: THEN
1050: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_DELETING_TEMP');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_unexp_error;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055:
1056: IF fnd_api.to_boolean (p_commit)
1057: THEN

Line 1056: IF fnd_api.to_boolean (p_commit)

1052: x_return_status := fnd_api.g_ret_sts_unexp_error;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055:
1056: IF fnd_api.to_boolean (p_commit)
1057: THEN
1058: COMMIT WORK;
1059: END IF;
1060:

Line 1063: WHEN fnd_api.g_exc_unexpected_error

1059: END IF;
1060:
1061: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1062: EXCEPTION
1063: WHEN fnd_api.g_exc_unexpected_error
1064: THEN
1065: ROLLBACK TO delete_task_pvt;
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067: fnd_msg_pub.count_and_get (

Line 1066: x_return_status := fnd_api.g_ret_sts_unexp_error;

1062: EXCEPTION
1063: WHEN fnd_api.g_exc_unexpected_error
1064: THEN
1065: ROLLBACK TO delete_task_pvt;
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067: fnd_msg_pub.count_and_get (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );

Line 1074: x_return_status := fnd_api.g_ret_sts_unexp_error;

1070: );
1071: WHEN OTHERS
1072: THEN
1073: ROLLBACK TO delete_task_pvt;
1074: x_return_status := fnd_api.g_ret_sts_unexp_error;
1075:
1076: fnd_msg_pub.count_and_get (
1077: p_count => x_msg_count,
1078: p_data => x_msg_data