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_PUB 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_PUB';
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_group_id IN NUMBER DEFAULT NULL,
11: p_task_group_name IN VARCHAR2 DEFAULT NULL,

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_group_id IN NUMBER DEFAULT NULL,
11: p_task_group_name IN VARCHAR2 DEFAULT NULL,
12: p_task_name IN VARCHAR2,

Line 75: x_return_status := fnd_api.g_ret_sts_success;

71:
72:
73: BEGIN
74: SAVEPOINT create_task_pub1;
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: IF NOT fnd_api.compatible_api_call (
78: l_api_version,
79: p_api_version,

Line 77: IF NOT fnd_api.compatible_api_call (

73: BEGIN
74: SAVEPOINT create_task_pub1;
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: IF NOT fnd_api.compatible_api_call (
78: l_api_version,
79: p_api_version,
80: l_api_name,
81: g_pkg_name

Line 84: RAISE fnd_api.g_exc_unexpected_error;

80: l_api_name,
81: g_pkg_name
82: )
83: THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86:
87: IF fnd_api.to_boolean (p_init_msg_list)
88: THEN

Line 87: IF fnd_api.to_boolean (p_init_msg_list)

83: THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86:
87: IF fnd_api.to_boolean (p_init_msg_list)
88: THEN
89: fnd_msg_pub.initialize;
90: END IF;
91:

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

144: p_task_confirmation_status => 'N'
145:
146: );
147:
148: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
149: THEN
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;

Line 150: x_return_status := fnd_api.g_ret_sts_unexp_error;

146: );
147:
148: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
149: THEN
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: IF fnd_api.to_boolean (p_commit)

Line 151: RAISE fnd_api.g_exc_unexpected_error;

147:
148: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
149: THEN
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: IF fnd_api.to_boolean (p_commit)
155: THEN

Line 154: IF fnd_api.to_boolean (p_commit)

150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: IF fnd_api.to_boolean (p_commit)
155: THEN
156: COMMIT WORK;
157: END IF;
158:

Line 161: WHEN fnd_api.g_exc_unexpected_error

157: END IF;
158:
159: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
160: EXCEPTION
161: WHEN fnd_api.g_exc_unexpected_error
162: THEN
163: ROLLBACK TO create_task_pub1;
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: fnd_msg_pub.count_and_get (

Line 164: x_return_status := fnd_api.g_ret_sts_unexp_error;

160: EXCEPTION
161: WHEN fnd_api.g_exc_unexpected_error
162: THEN
163: ROLLBACK TO create_task_pub1;
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 174: x_return_status := fnd_api.g_ret_sts_unexp_error;

170: THEN
171: ROLLBACK TO create_task_pub1;
172: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
173: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: fnd_msg_pub.count_and_get (
176: p_count => x_msg_count,
177: p_data => x_msg_data
178: );

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

180:
181: -- Overloading for Simplex
182: PROCEDURE create_task (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
185: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
186: p_task_id IN NUMBER DEFAULT NULL,
187: p_task_group_id IN NUMBER default null,
188: p_task_group_name IN VARCHAR2 DEFAULT NULL,

Line 185: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

181: -- Overloading for Simplex
182: PROCEDURE create_task (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
185: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
186: p_task_id IN NUMBER DEFAULT NULL,
187: p_task_group_id IN NUMBER default null,
188: p_task_group_name IN VARCHAR2 DEFAULT NULL,
189: p_task_name IN VARCHAR2,

Line 269: x_return_status := fnd_api.g_ret_sts_success;

265: FROM jtf_task_templates_b
266: WHERE task_template_id = x_task_id;
267: BEGIN
268: SAVEPOINT create_task_pub;
269: x_return_status := fnd_api.g_ret_sts_success;
270:
271:
272: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
273: THEN

Line 272: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

268: SAVEPOINT create_task_pub;
269: x_return_status := fnd_api.g_ret_sts_success;
270:
271:
272: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
273: THEN
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;
276:

Line 274: RAISE fnd_api.g_exc_unexpected_error;

270:
271:
272: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
273: THEN
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;
276:
277: IF fnd_api.to_boolean (p_init_msg_list)
278: THEN

Line 277: IF fnd_api.to_boolean (p_init_msg_list)

273: THEN
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;
276:
277: IF fnd_api.to_boolean (p_init_msg_list)
278: THEN
279: fnd_msg_pub.initialize;
280: END IF;
281:

Line 296: RAISE fnd_api.g_exc_unexpected_error;

292: IF l_task_type_id IS NULL
293: THEN
294: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TYPE');
295: fnd_msg_pub.add;
296: RAISE fnd_api.g_exc_unexpected_error;
297: END IF;
298:
299: -------
300: ------- Validate Task Status

Line 320: RAISE fnd_api.g_exc_unexpected_error;

316: IF l_task_status_id IS NULL
317: THEN
318: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_STATUS');
319: fnd_msg_pub.add;
320: RAISE fnd_api.g_exc_unexpected_error;
321: END IF;
322:
323:
324: -------

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

342: p_effort => p_duration,
343: p_effort_uom => p_duration_uom
344: );
345:
346: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
347: THEN
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: RAISE fnd_api.g_exc_unexpected_error;
350: END IF;

Line 348: x_return_status := fnd_api.g_ret_sts_unexp_error;

344: );
345:
346: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
347: THEN
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: RAISE fnd_api.g_exc_unexpected_error;
350: END IF;
351:
352: -------

Line 349: RAISE fnd_api.g_exc_unexpected_error;

345:
346: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
347: THEN
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: RAISE fnd_api.g_exc_unexpected_error;
350: END IF;
351:
352: -------
353: ------- Validate Planned Effort

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

358: x_return_status => x_return_status,
359: p_effort => p_planned_effort,
360: p_effort_uom => p_planned_effort_uom);
361:
362: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
363: THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: RAISE fnd_api.g_exc_unexpected_error;
366: END IF;

Line 364: x_return_status := fnd_api.g_ret_sts_unexp_error;

360: p_effort_uom => p_planned_effort_uom);
361:
362: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
363: THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: RAISE fnd_api.g_exc_unexpected_error;
366: END IF;
367:
368: -------

Line 365: RAISE fnd_api.g_exc_unexpected_error;

361:
362: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
363: THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: RAISE fnd_api.g_exc_unexpected_error;
366: END IF;
367:
368: -------
369: ------- Call the private flag

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

369: ------- Call the private flag
370: -------
371: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Private Flag', p_flag_value => p_private_flag);
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;

Line 375: x_return_status := fnd_api.g_ret_sts_unexp_error;

371: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Private Flag', p_flag_value => p_private_flag);
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379:

Line 376: RAISE fnd_api.g_exc_unexpected_error;

372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379:
380:

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

382: ------- Call the publish flag
383: -------
384: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag);
385:
386: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
387: THEN
388: x_return_status := fnd_api.g_ret_sts_unexp_error;
389: RAISE fnd_api.g_exc_unexpected_error;
390: END IF;

Line 388: x_return_status := fnd_api.g_ret_sts_unexp_error;

384: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag);
385:
386: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
387: THEN
388: x_return_status := fnd_api.g_ret_sts_unexp_error;
389: RAISE fnd_api.g_exc_unexpected_error;
390: END IF;
391:
392: -------

Line 389: RAISE fnd_api.g_exc_unexpected_error;

385:
386: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
387: THEN
388: x_return_status := fnd_api.g_ret_sts_unexp_error;
389: RAISE fnd_api.g_exc_unexpected_error;
390: END IF;
391:
392: -------
393: ------- Call the Restrict closure flag

Line 397: p_init_msg_list => fnd_api.g_false,

393: ------- Call the Restrict closure flag
394: -------
395: jtf_task_utl.validate_flag (
396: p_api_name => l_api_name,
397: p_init_msg_list => fnd_api.g_false,
398: x_return_status => x_return_status,
399: p_flag_name => 'Restrict Closure Flag',
400: p_flag_value => p_restrict_closure_flag
401: );

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

399: p_flag_name => 'Restrict Closure Flag',
400: p_flag_value => p_restrict_closure_flag
401: );
402:
403: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
404: THEN
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406: RAISE fnd_api.g_exc_unexpected_error;
407: END IF;

Line 405: x_return_status := fnd_api.g_ret_sts_unexp_error;

401: );
402:
403: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
404: THEN
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406: RAISE fnd_api.g_exc_unexpected_error;
407: END IF;
408:
409: -------

Line 406: RAISE fnd_api.g_exc_unexpected_error;

402:
403: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
404: THEN
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406: RAISE fnd_api.g_exc_unexpected_error;
407: END IF;
408:
409: -------
410: ------- Call the Multi Booked flag

Line 414: p_init_msg_list => fnd_api.g_false,

410: ------- Call the Multi Booked flag
411: -------
412: jtf_task_utl.validate_flag (
413: p_api_name => l_api_name,
414: p_init_msg_list => fnd_api.g_false,
415: x_return_status => x_return_status,
416: p_flag_name => 'Multi Booked Flag',
417: p_flag_value => p_multi_booked_flag
418: );

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

416: p_flag_name => 'Multi Booked Flag',
417: p_flag_value => p_multi_booked_flag
418: );
419:
420: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
421: THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: RAISE fnd_api.g_exc_unexpected_error;
424: END IF;

Line 422: x_return_status := fnd_api.g_ret_sts_unexp_error;

418: );
419:
420: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
421: THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: RAISE fnd_api.g_exc_unexpected_error;
424: END IF;
425:
426: -------

Line 423: RAISE fnd_api.g_exc_unexpected_error;

419:
420: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
421: THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: RAISE fnd_api.g_exc_unexpected_error;
424: END IF;
425:
426: -------
427: ------- Call the milestone flag

Line 431: p_init_msg_list => fnd_api.g_false,

427: ------- Call the milestone flag
428: -------
429: jtf_task_utl.validate_flag (
430: p_api_name => l_api_name,
431: p_init_msg_list => fnd_api.g_false,
432: x_return_status => x_return_status,
433: p_flag_name => 'Milestone Flag',
434: p_flag_value => p_milestone_flag
435: );

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

433: p_flag_name => 'Milestone Flag',
434: p_flag_value => p_milestone_flag
435: );
436:
437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: );
436:
437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:
443: -------

Line 440: RAISE fnd_api.g_exc_unexpected_error;

436:
437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:
443: -------
444: ------- Call the Holiday Flag

Line 448: p_init_msg_list => fnd_api.g_false,

444: ------- Call the Holiday Flag
445: -------
446: jtf_task_utl.validate_flag (
447: p_api_name => l_api_name,
448: p_init_msg_list => fnd_api.g_false,
449: x_return_status => x_return_status,
450: p_flag_name => 'Holiday Flag',
451: p_flag_value => p_holiday_flag
452: );

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

450: p_flag_name => 'Holiday Flag',
451: p_flag_value => p_holiday_flag
452: );
453:
454: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
455: THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;

Line 456: x_return_status := fnd_api.g_ret_sts_unexp_error;

452: );
453:
454: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
455: THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:
460: -------

Line 457: RAISE fnd_api.g_exc_unexpected_error;

453:
454: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
455: THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:
460: -------
461: ------- Call the Billable Flag

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

461: ------- Call the Billable Flag
462: -------
463: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag);
464:
465: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
466: THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;

Line 467: x_return_status := fnd_api.g_ret_sts_unexp_error;

463: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag);
464:
465: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
466: THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;
470:
471: -------

Line 468: RAISE fnd_api.g_exc_unexpected_error;

464:
465: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
466: THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;
470:
471: -------
472: ------- Call the Validate Notification Parameters

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

477: p_notification_period_uom => p_notification_period_uom,
478: x_return_status => x_return_status
479: );
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;

Line 483: x_return_status := fnd_api.g_ret_sts_unexp_error;

479: );
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486:
487:

Line 484: RAISE fnd_api.g_exc_unexpected_error;

480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486:
487:
488: -------

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

493: p_task_template_group_name => p_task_group_name,
494: x_return_status => x_return_status ,
495: x_task_template_group_id => l_task_group_id );
496:
497: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
498: THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: RAISE fnd_api.g_exc_unexpected_error;
501: END IF;

Line 499: x_return_status := fnd_api.g_ret_sts_unexp_error;

495: x_task_template_group_id => l_task_group_id );
496:
497: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
498: THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: RAISE fnd_api.g_exc_unexpected_error;
501: END IF;
502:
503: if l_task_group_id is null then

Line 500: RAISE fnd_api.g_exc_unexpected_error;

496:
497: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
498: THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: RAISE fnd_api.g_exc_unexpected_error;
501: END IF;
502:
503: if l_task_group_id is null then
504: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_GROUP');

Line 506: x_return_status := fnd_api.g_ret_sts_unexp_error;

502:
503: if l_task_group_id is null then
504: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_GROUP');
505: fnd_msg_pub.add ;
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
507: RAISE fnd_api.g_exc_unexpected_error;
508: end if ;
509:
510:

Line 507: RAISE fnd_api.g_exc_unexpected_error;

503: if l_task_group_id is null then
504: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_GROUP');
505: fnd_msg_pub.add ;
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
507: RAISE fnd_api.g_exc_unexpected_error;
508: end if ;
509:
510:
511:

Line 514: p_init_msg_list => fnd_api.g_false,

510:
511:
512: jtf_task_templates_pvt.create_task (
513: p_api_version => 1.0,
514: p_init_msg_list => fnd_api.g_false,
515: p_commit => fnd_api.g_false,
516: p_task_id => l_task_id,
517: p_task_name => l_task_name,
518: p_task_group_id => l_task_group_id,

Line 515: p_commit => fnd_api.g_false,

511:
512: jtf_task_templates_pvt.create_task (
513: p_api_version => 1.0,
514: p_init_msg_list => fnd_api.g_false,
515: p_commit => fnd_api.g_false,
516: p_task_id => l_task_id,
517: p_task_name => l_task_name,
518: p_task_group_id => l_task_group_id,
519: p_task_type_id => l_task_type_id,

Line 577: x_return_status := fnd_api.g_ret_sts_unexp_error;

573: IF c_task_templates%NOTFOUND
574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATING_TEMP');
576: fnd_msg_pub.add;
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END IF;
580:
581: -------

Line 578: RAISE fnd_api.g_exc_unexpected_error;

574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATING_TEMP');
576: fnd_msg_pub.add;
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END IF;
580:
581: -------
582: -------

Line 597: p_init_msg_list => fnd_api.g_false,

593: LOOP
594:
595: jtf_task_dependency_pub.create_task_dependency (
596: p_api_version => 1.0,
597: p_init_msg_list => fnd_api.g_false,
598: p_commit => fnd_api.g_false,
599: p_validation_level => fnd_api.g_valid_level_full,
600: p_task_id => x_task_id,
601: p_dependent_on_task_id => p_task_depends_tbl (current_record).dependent_on_task_id,

Line 598: p_commit => fnd_api.g_false,

594:
595: jtf_task_dependency_pub.create_task_dependency (
596: p_api_version => 1.0,
597: p_init_msg_list => fnd_api.g_false,
598: p_commit => fnd_api.g_false,
599: p_validation_level => fnd_api.g_valid_level_full,
600: p_task_id => x_task_id,
601: p_dependent_on_task_id => p_task_depends_tbl (current_record).dependent_on_task_id,
602: p_dependent_on_task_number => p_task_depends_tbl (current_record).dependent_on_task_number,

Line 599: p_validation_level => fnd_api.g_valid_level_full,

595: jtf_task_dependency_pub.create_task_dependency (
596: p_api_version => 1.0,
597: p_init_msg_list => fnd_api.g_false,
598: p_commit => fnd_api.g_false,
599: p_validation_level => fnd_api.g_valid_level_full,
600: p_task_id => x_task_id,
601: p_dependent_on_task_id => p_task_depends_tbl (current_record).dependent_on_task_id,
602: p_dependent_on_task_number => p_task_depends_tbl (current_record).dependent_on_task_number,
603: p_dependency_type_code => p_task_depends_tbl (current_record).dependency_type_code,

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

611: x_msg_data => x_msg_data
612: );
613:
614:
615: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
616: THEN
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;

Line 617: x_return_status := fnd_api.g_ret_sts_unexp_error;

613:
614:
615: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
616: THEN
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620:
621: current_record := p_task_depends_tbl.NEXT (current_record);

Line 618: RAISE fnd_api.g_exc_unexpected_error;

614:
615: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
616: THEN
617: x_return_status := fnd_api.g_ret_sts_unexp_error;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620:
621: current_record := p_task_depends_tbl.NEXT (current_record);
622: END LOOP;

Line 643: p_init_msg_list => fnd_api.g_false,

639: OR p_task_recur_rec.end_date_active IS NOT NULL)
640: THEN
641: jtf_task_recurrences_pub.create_task_recurrence (
642: p_api_version => 1.0,
643: p_init_msg_list => fnd_api.g_false,
644: p_commit => fnd_api.g_false,
645: p_task_id => x_task_id,
646: p_occurs_which => p_task_recur_rec.occurs_which,
647: p_template_flag => jtf_task_utl.g_yes,

Line 644: p_commit => fnd_api.g_false,

640: THEN
641: jtf_task_recurrences_pub.create_task_recurrence (
642: p_api_version => 1.0,
643: p_init_msg_list => fnd_api.g_false,
644: p_commit => fnd_api.g_false,
645: p_task_id => x_task_id,
646: p_occurs_which => p_task_recur_rec.occurs_which,
647: p_template_flag => jtf_task_utl.g_yes,
648: p_day_of_week => p_task_recur_rec.day_of_week,

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

660: x_task_rec => l_task_rec,
661: x_reccurences_generated => l_reccurence_generated
662: );
663:
664: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
665: THEN
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: RAISE fnd_api.g_exc_unexpected_error;
668: END IF;

Line 666: x_return_status := fnd_api.g_ret_sts_unexp_error;

662: );
663:
664: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
665: THEN
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: RAISE fnd_api.g_exc_unexpected_error;
668: END IF;
669: END IF;
670:

Line 667: RAISE fnd_api.g_exc_unexpected_error;

663:
664: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
665: THEN
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: RAISE fnd_api.g_exc_unexpected_error;
668: END IF;
669: END IF;
670:
671:

Line 673: IF fnd_api.to_boolean (p_commit)

669: END IF;
670:
671:
672:
673: IF fnd_api.to_boolean (p_commit)
674: THEN
675: COMMIT WORK;
676: END IF;
677:

Line 680: WHEN fnd_api.g_exc_unexpected_error

676: END IF;
677:
678: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
679: EXCEPTION
680: WHEN fnd_api.g_exc_unexpected_error
681: THEN
682:
683:
684: ROLLBACK TO create_task_pub;

Line 685: x_return_status := fnd_api.g_ret_sts_unexp_error;

681: THEN
682:
683:
684: ROLLBACK TO create_task_pub;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS
688: THEN
689:

Line 693: x_return_status := fnd_api.g_ret_sts_unexp_error;

689:
690:
691:
692: ROLLBACK TO create_task_pub;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: END;
696:
697: PROCEDURE lock_task (

Line 699: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

695: END;
696:
697: PROCEDURE lock_task (
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
700: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
701: p_task_id IN NUMBER,
702: p_object_version_number IN NUMBER,
703: x_return_status OUT NOCOPY VARCHAR2,

Line 700: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

696:
697: PROCEDURE lock_task (
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
700: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
701: p_task_id IN NUMBER,
702: p_object_version_number IN NUMBER,
703: x_return_status OUT NOCOPY VARCHAR2,
704: x_msg_data OUT NOCOPY VARCHAR2,

Line 718: x_return_status := fnd_api.g_ret_sts_success;

714:
715: begin
716: SAVEPOINT lock_task_pub;
717:
718: x_return_status := fnd_api.g_ret_sts_success;
719:
720: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
721: THEN
722: RAISE fnd_api.g_exc_unexpected_error;

Line 720: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

716: SAVEPOINT lock_task_pub;
717:
718: x_return_status := fnd_api.g_ret_sts_success;
719:
720: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
721: THEN
722: RAISE fnd_api.g_exc_unexpected_error;
723: END IF;
724:

Line 722: RAISE fnd_api.g_exc_unexpected_error;

718: x_return_status := fnd_api.g_ret_sts_success;
719:
720: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
721: THEN
722: RAISE fnd_api.g_exc_unexpected_error;
723: END IF;
724:
725: IF fnd_api.to_boolean (p_init_msg_list)
726: THEN

Line 725: IF fnd_api.to_boolean (p_init_msg_list)

721: THEN
722: RAISE fnd_api.g_exc_unexpected_error;
723: END IF;
724:
725: IF fnd_api.to_boolean (p_init_msg_list)
726: THEN
727: fnd_msg_pub.initialize;
728: END IF;
729:

Line 730: x_return_status := fnd_api.g_ret_sts_success;

726: THEN
727: fnd_msg_pub.initialize;
728: END IF;
729:
730: x_return_status := fnd_api.g_ret_sts_success;
731:
732: jtf_task_templates_pkg.lock_row(
733: x_task_template_id => p_task_id ,
734: x_object_version_number => p_object_version_number );

Line 744: x_return_status := fnd_api.g_ret_sts_unexp_error;

740: WHEN Resource_Locked then
741: ROLLBACK TO lock_task_pub;
742: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
743: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
746:
747: WHEN fnd_api.g_exc_unexpected_error
748: THEN

Line 747: WHEN fnd_api.g_exc_unexpected_error

743: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
746:
747: WHEN fnd_api.g_exc_unexpected_error
748: THEN
749: ROLLBACK TO lock_task_pub;
750: x_return_status := fnd_api.g_ret_sts_unexp_error;
751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 750: x_return_status := fnd_api.g_ret_sts_unexp_error;

746:
747: WHEN fnd_api.g_exc_unexpected_error
748: THEN
749: ROLLBACK TO lock_task_pub;
750: x_return_status := fnd_api.g_ret_sts_unexp_error;
751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
752: WHEN OTHERS
753: THEN
754: ROLLBACK TO lock_task_pub;

Line 757: x_return_status := fnd_api.g_ret_sts_unexp_error;

753: THEN
754: ROLLBACK TO lock_task_pub;
755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
756: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
759: END;
760:
761:

Line 765: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

761:
762:
763: PROCEDURE update_task (
764: p_api_version IN NUMBER,
765: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

762:
763: PROCEDURE update_task (
764: p_api_version IN NUMBER,
765: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,

764: p_api_version IN NUMBER,
765: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

765: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,

766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

767: p_object_version_number IN OUT NOCOPY NUMBER ,
768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

768: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

769: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

770: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

771: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

772: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

773: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

774: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

775: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

776: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

777: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

778: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

779: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

780: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

781: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

782: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

783: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

784: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

785: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

786: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

787: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

788: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

789: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

790: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

791: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
799: x_return_status OUT NOCOPY VARCHAR2,

Line 796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

792: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_count OUT NOCOPY NUMBER,

Line 797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

793: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_count OUT NOCOPY NUMBER,
801: x_msg_data OUT NOCOPY VARCHAR2,

Line 798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

794: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
795: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
796: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
797: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_count OUT NOCOPY NUMBER,
801: x_msg_data OUT NOCOPY VARCHAR2,
802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,

856: CURSOR c_task_update (
857: l_task_id IN NUMBER
858: )
859: IS
860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,

Line 861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,

857: l_task_id IN NUMBER
858: )
859: IS
860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,

Line 862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,

858: )
859: IS
860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,

Line 863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,

859: IS
860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,

Line 864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,

860: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,

Line 865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,

861: DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,

Line 866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,

862: DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,

Line 867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,

863: DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,

Line 868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,

864: DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,

Line 869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,

865: DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,

Line 870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,

866: DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,

Line 871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,

867: DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,

Line 872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,

868: DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,

Line 873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,

869: DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,

Line 874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,

870: DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,

Line 875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,

871: DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,

Line 876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,

872: DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,

Line 877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,

873: DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,

Line 878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,

874: DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,

Line 879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,

875: DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,

Line 880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,

876: DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,

Line 881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,

877: DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,

Line 882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,

878: DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,

Line 883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,

879: DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

Line 884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,

880: DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,

Line 885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,

881: DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,

Line 886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,

882: DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,

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

883: DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

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

884: DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

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

885: DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

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

886: DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

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

887: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

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

888: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

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

889: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

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

890: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

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

891: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

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

892: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

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

893: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

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

894: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,

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

895: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)

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

896: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
904: task_confirmation_status

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

897: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
904: task_confirmation_status
905: FROM jtf_task_templates_vl

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

898: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
904: task_confirmation_status
905: FROM jtf_task_templates_vl
906: WHERE task_template_id = l_task_id;

Line 914: x_return_status := fnd_api.g_ret_sts_success;

910: BEGIN
911:
912: SAVEPOINT update_task_pub;
913:
914: x_return_status := fnd_api.g_ret_sts_success;
915:
916: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
917: THEN
918: RAISE fnd_api.g_exc_unexpected_error;

Line 916: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

912: SAVEPOINT update_task_pub;
913:
914: x_return_status := fnd_api.g_ret_sts_success;
915:
916: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
917: THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920:

Line 918: RAISE fnd_api.g_exc_unexpected_error;

914: x_return_status := fnd_api.g_ret_sts_success;
915:
916: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
917: THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920:
921: IF fnd_api.to_boolean (p_init_msg_list)
922: THEN

Line 921: IF fnd_api.to_boolean (p_init_msg_list)

917: THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920:
921: IF fnd_api.to_boolean (p_init_msg_list)
922: THEN
923: fnd_msg_pub.initialize;
924: END IF;
925:

Line 931: IF ( l_task_id = fnd_api.g_miss_num

927:
928: -----
929: ----- Validate Tasks
930: -----
931: IF ( l_task_id = fnd_api.g_miss_num
932: AND l_task_number = fnd_api.g_miss_char)
933: THEN
934: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
935: fnd_msg_pub.add;

Line 932: AND l_task_number = fnd_api.g_miss_char)

928: -----
929: ----- Validate Tasks
930: -----
931: IF ( l_task_id = fnd_api.g_miss_num
932: AND l_task_number = fnd_api.g_miss_char)
933: THEN
934: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
935: fnd_msg_pub.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 936: x_return_status := fnd_api.g_ret_sts_unexp_error;

932: AND l_task_number = fnd_api.g_miss_char)
933: THEN
934: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
935: fnd_msg_pub.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: RAISE fnd_api.g_exc_unexpected_error;
938: ELSE
939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
940: INTO l_task_id

Line 937: RAISE fnd_api.g_exc_unexpected_error;

933: THEN
934: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
935: fnd_msg_pub.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: RAISE fnd_api.g_exc_unexpected_error;
938: ELSE
939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
940: INTO l_task_id
941: FROM dual;

Line 939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)

935: fnd_msg_pub.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: RAISE fnd_api.g_exc_unexpected_error;
938: ELSE
939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
940: INTO l_task_id
941: FROM dual;
942: SELECT DECODE (l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
943: INTO l_task_number

Line 942: SELECT DECODE (l_task_number, fnd_api.g_miss_char, NULL, l_task_number)

938: ELSE
939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
940: INTO l_task_id
941: FROM dual;
942: SELECT DECODE (l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
943: INTO l_task_number
944: FROM dual;
945: jtf_task_utl.validate_task_template (
946: p_task_id => l_task_id,

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

950: );
951:
952:
953:
954: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
955: THEN
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;

Line 956: x_return_status := fnd_api.g_ret_sts_unexp_error;

952:
953:
954: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
955: THEN
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959:
960: IF l_task_id IS NULL

Line 957: RAISE fnd_api.g_exc_unexpected_error;

953:
954: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
955: THEN
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959:
960: IF l_task_id IS NULL
961: THEN

Line 964: x_return_status := fnd_api.g_ret_sts_unexp_error;

960: IF l_task_id IS NULL
961: THEN
962: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
963: fnd_msg_pub.add;
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967: END IF;
968:

Line 965: RAISE fnd_api.g_exc_unexpected_error;

961: THEN
962: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
963: fnd_msg_pub.add;
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967: END IF;
968:
969:

Line 978: x_return_status := fnd_api.g_ret_sts_unexp_error;

974: IF l_task_name IS NULL
975: THEN
976: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_NAME');
977: fnd_msg_pub.add;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: RAISE fnd_api.g_exc_unexpected_error;
980: END IF;
981:
982: -----

Line 979: RAISE fnd_api.g_exc_unexpected_error;

975: THEN
976: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_NAME');
977: fnd_msg_pub.add;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: RAISE fnd_api.g_exc_unexpected_error;
980: END IF;
981:
982: -----
983: ----- Task Description

Line 992: x_return_status := fnd_api.g_ret_sts_unexp_error;

988: IF c_task_update%NOTFOUND
989: THEN
990: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
991: fnd_msg_pub.add;
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
995:
996:

Line 993: RAISE fnd_api.g_exc_unexpected_error;

989: THEN
990: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
991: fnd_msg_pub.add;
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
995:
996:
997:

Line 1002: IF ( l_task_type_name = fnd_api.g_miss_char

998:
999: -----
1000: ----- Task Type
1001: -----
1002: IF ( l_task_type_name = fnd_api.g_miss_char
1003: AND l_task_type_id = fnd_api.g_miss_num)
1004: THEN
1005: l_task_type_id := task_rec.task_type_id;
1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char

Line 1003: AND l_task_type_id = fnd_api.g_miss_num)

999: -----
1000: ----- Task Type
1001: -----
1002: IF ( l_task_type_name = fnd_api.g_miss_char
1003: AND l_task_type_id = fnd_api.g_miss_num)
1004: THEN
1005: l_task_type_id := task_rec.task_type_id;
1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char
1007: AND l_task_type_id <> fnd_api.g_miss_num)

Line 1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char

1002: IF ( l_task_type_name = fnd_api.g_miss_char
1003: AND l_task_type_id = fnd_api.g_miss_num)
1004: THEN
1005: l_task_type_id := task_rec.task_type_id;
1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char
1007: AND l_task_type_id <> fnd_api.g_miss_num)
1008: THEN
1009: jtf_task_utl.validate_task_type (
1010: p_task_type_id => l_task_type_id,

Line 1007: AND l_task_type_id <> fnd_api.g_miss_num)

1003: AND l_task_type_id = fnd_api.g_miss_num)
1004: THEN
1005: l_task_type_id := task_rec.task_type_id;
1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char
1007: AND l_task_type_id <> fnd_api.g_miss_num)
1008: THEN
1009: jtf_task_utl.validate_task_type (
1010: p_task_type_id => l_task_type_id,
1011: p_task_type_name => NULL,

Line 1015: ELSIF ( l_task_type_name <> fnd_api.g_miss_char

1011: p_task_type_name => NULL,
1012: x_return_status => x_return_status,
1013: x_task_type_id => l_task_type_id
1014: );
1015: ELSIF ( l_task_type_name <> fnd_api.g_miss_char
1016: AND l_task_type_id = fnd_api.g_miss_num)
1017: THEN
1018: jtf_task_utl.validate_task_type (
1019: p_task_type_id => NULL,

Line 1016: AND l_task_type_id = fnd_api.g_miss_num)

1012: x_return_status => x_return_status,
1013: x_task_type_id => l_task_type_id
1014: );
1015: ELSIF ( l_task_type_name <> fnd_api.g_miss_char
1016: AND l_task_type_id = fnd_api.g_miss_num)
1017: THEN
1018: jtf_task_utl.validate_task_type (
1019: p_task_type_id => NULL,
1020: p_task_type_name => l_task_type_name,

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

1029: x_task_type_id => l_task_type_id
1030: );
1031: END IF;
1032:
1033: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1034: THEN
1035: x_return_status := fnd_api.g_ret_sts_unexp_error;
1036: RAISE fnd_api.g_exc_unexpected_error;
1037: END IF;

Line 1035: x_return_status := fnd_api.g_ret_sts_unexp_error;

1031: END IF;
1032:
1033: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1034: THEN
1035: x_return_status := fnd_api.g_ret_sts_unexp_error;
1036: RAISE fnd_api.g_exc_unexpected_error;
1037: END IF;
1038:
1039: IF l_task_type_id IS NULL

Line 1036: RAISE fnd_api.g_exc_unexpected_error;

1032:
1033: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1034: THEN
1035: x_return_status := fnd_api.g_ret_sts_unexp_error;
1036: RAISE fnd_api.g_exc_unexpected_error;
1037: END IF;
1038:
1039: IF l_task_type_id IS NULL
1040: THEN

Line 1043: RAISE fnd_api.g_exc_unexpected_error;

1039: IF l_task_type_id IS NULL
1040: THEN
1041: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TYPE');
1042: fnd_msg_pub.add;
1043: RAISE fnd_api.g_exc_unexpected_error;
1044: END IF;
1045:
1046:
1047:

Line 1057: IF ( l_task_status_name = fnd_api.g_miss_char

1053: else
1054: l_type := 'TASK';
1055: end if;
1056:
1057: IF ( l_task_status_name = fnd_api.g_miss_char
1058: AND l_task_status_id = fnd_api.g_miss_num)
1059: THEN
1060: l_task_status_id := task_rec.task_status_id;
1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char

Line 1058: AND l_task_status_id = fnd_api.g_miss_num)

1054: l_type := 'TASK';
1055: end if;
1056:
1057: IF ( l_task_status_name = fnd_api.g_miss_char
1058: AND l_task_status_id = fnd_api.g_miss_num)
1059: THEN
1060: l_task_status_id := task_rec.task_status_id;
1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char
1062: AND l_task_status_id <> fnd_api.g_miss_num)

Line 1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char

1057: IF ( l_task_status_name = fnd_api.g_miss_char
1058: AND l_task_status_id = fnd_api.g_miss_num)
1059: THEN
1060: l_task_status_id := task_rec.task_status_id;
1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char
1062: AND l_task_status_id <> fnd_api.g_miss_num)
1063: THEN
1064: jtf_task_utl.validate_task_status (
1065: p_task_status_id => l_task_status_id,

Line 1062: AND l_task_status_id <> fnd_api.g_miss_num)

1058: AND l_task_status_id = fnd_api.g_miss_num)
1059: THEN
1060: l_task_status_id := task_rec.task_status_id;
1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char
1062: AND l_task_status_id <> fnd_api.g_miss_num)
1063: THEN
1064: jtf_task_utl.validate_task_status (
1065: p_task_status_id => l_task_status_id,
1066: p_task_status_name => NULL,

Line 1071: ELSIF ( l_task_status_name <> fnd_api.g_miss_char

1067: p_validation_type => l_type,
1068: x_return_status => x_return_status,
1069: x_task_status_id => l_task_status_id
1070: );
1071: ELSIF ( l_task_status_name <> fnd_api.g_miss_char
1072: AND l_task_status_id = fnd_api.g_miss_num)
1073: THEN
1074: jtf_task_utl.validate_task_status (
1075: p_task_status_id => NULL,

Line 1072: AND l_task_status_id = fnd_api.g_miss_num)

1068: x_return_status => x_return_status,
1069: x_task_status_id => l_task_status_id
1070: );
1071: ELSIF ( l_task_status_name <> fnd_api.g_miss_char
1072: AND l_task_status_id = fnd_api.g_miss_num)
1073: THEN
1074: jtf_task_utl.validate_task_status (
1075: p_task_status_id => NULL,
1076: p_task_status_name => l_task_status_name,

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

1087: x_task_status_id => l_task_status_id
1088: );
1089: END IF;
1090:
1091: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1092: THEN
1093: x_return_status := fnd_api.g_ret_sts_unexp_error;
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;

Line 1093: x_return_status := fnd_api.g_ret_sts_unexp_error;

1089: END IF;
1090:
1091: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1092: THEN
1093: x_return_status := fnd_api.g_ret_sts_unexp_error;
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096:
1097: IF l_task_status_id IS NULL

Line 1094: RAISE fnd_api.g_exc_unexpected_error;

1090:
1091: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1092: THEN
1093: x_return_status := fnd_api.g_ret_sts_unexp_error;
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096:
1097: IF l_task_status_id IS NULL
1098: THEN

Line 1101: RAISE fnd_api.g_exc_unexpected_error;

1097: IF l_task_status_id IS NULL
1098: THEN
1099: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_STATUS');
1100: fnd_msg_pub.add;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;
1103:
1104:
1105:

Line 1109: IF ( l_task_priority_name = fnd_api.g_miss_char

1105:
1106: --------
1107: -------- Task Priority
1108: --------
1109: IF ( l_task_priority_name = fnd_api.g_miss_char
1110: AND l_task_priority_id = fnd_api.g_miss_num)
1111: THEN
1112: l_task_priority_id := task_rec.task_priority_id;
1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char

Line 1110: AND l_task_priority_id = fnd_api.g_miss_num)

1106: --------
1107: -------- Task Priority
1108: --------
1109: IF ( l_task_priority_name = fnd_api.g_miss_char
1110: AND l_task_priority_id = fnd_api.g_miss_num)
1111: THEN
1112: l_task_priority_id := task_rec.task_priority_id;
1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char
1114: AND l_task_priority_id <> fnd_api.g_miss_num)

Line 1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char

1109: IF ( l_task_priority_name = fnd_api.g_miss_char
1110: AND l_task_priority_id = fnd_api.g_miss_num)
1111: THEN
1112: l_task_priority_id := task_rec.task_priority_id;
1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char
1114: AND l_task_priority_id <> fnd_api.g_miss_num)
1115: THEN
1116: jtf_task_utl.validate_task_priority (
1117: p_task_priority_id => l_task_priority_id,

Line 1114: AND l_task_priority_id <> fnd_api.g_miss_num)

1110: AND l_task_priority_id = fnd_api.g_miss_num)
1111: THEN
1112: l_task_priority_id := task_rec.task_priority_id;
1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char
1114: AND l_task_priority_id <> fnd_api.g_miss_num)
1115: THEN
1116: jtf_task_utl.validate_task_priority (
1117: p_task_priority_id => l_task_priority_id,
1118: p_task_priority_name => NULL,

Line 1122: ELSIF ( l_task_priority_name <> fnd_api.g_miss_char

1118: p_task_priority_name => NULL,
1119: x_return_status => x_return_status,
1120: x_task_priority_id => l_task_priority_id
1121: );
1122: ELSIF ( l_task_priority_name <> fnd_api.g_miss_char
1123: AND l_task_priority_id = fnd_api.g_miss_num)
1124: THEN
1125: jtf_task_utl.validate_task_priority (
1126: p_task_priority_id => NULL,

Line 1123: AND l_task_priority_id = fnd_api.g_miss_num)

1119: x_return_status => x_return_status,
1120: x_task_priority_id => l_task_priority_id
1121: );
1122: ELSIF ( l_task_priority_name <> fnd_api.g_miss_char
1123: AND l_task_priority_id = fnd_api.g_miss_num)
1124: THEN
1125: jtf_task_utl.validate_task_priority (
1126: p_task_priority_id => NULL,
1127: p_task_priority_name => l_task_priority_name,

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

1136: x_task_priority_id => l_task_priority_id
1137: );
1138: END IF;
1139:
1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1141: THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;

Line 1142: x_return_status := fnd_api.g_ret_sts_unexp_error;

1138: END IF;
1139:
1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1141: THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;
1145:
1146: ----------

Line 1143: RAISE fnd_api.g_exc_unexpected_error;

1139:
1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1141: THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: END IF;
1145:
1146: ----------
1147: ---------- Validate duration

Line 1149: IF ( p_duration <> fnd_api.g_miss_num

1145:
1146: ----------
1147: ---------- Validate duration
1148: ----------
1149: IF ( p_duration <> fnd_api.g_miss_num
1150: OR p_duration_uom <> fnd_api.g_miss_char
1151: OR p_duration IS NULL
1152: OR p_duration_uom IS NULL)
1153: THEN

Line 1150: OR p_duration_uom <> fnd_api.g_miss_char

1146: ----------
1147: ---------- Validate duration
1148: ----------
1149: IF ( p_duration <> fnd_api.g_miss_num
1150: OR p_duration_uom <> fnd_api.g_miss_char
1151: OR p_duration IS NULL
1152: OR p_duration_uom IS NULL)
1153: THEN
1154: IF (p_duration <> fnd_api.g_miss_num)

Line 1154: IF (p_duration <> fnd_api.g_miss_num)

1150: OR p_duration_uom <> fnd_api.g_miss_char
1151: OR p_duration IS NULL
1152: OR p_duration_uom IS NULL)
1153: THEN
1154: IF (p_duration <> fnd_api.g_miss_num)
1155: OR (p_duration IS NULL)
1156: THEN
1157: l_duration := p_duration;
1158: ELSE

Line 1162: IF p_duration_uom <> fnd_api.g_miss_char

1158: ELSE
1159: l_duration := task_rec.duration;
1160: END IF;
1161:
1162: IF p_duration_uom <> fnd_api.g_miss_char
1163: OR (p_duration_uom IS NULL)
1164: THEN
1165: l_duration_uom := p_duration_uom;
1166: ELSE

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

1174: p_effort_uom => l_duration_uom,
1175: x_return_status => x_return_status
1176: );
1177:
1178: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1179: THEN
1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181: RAISE fnd_api.g_exc_unexpected_error;
1182: END IF;

Line 1180: x_return_status := fnd_api.g_ret_sts_unexp_error;

1176: );
1177:
1178: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1179: THEN
1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181: RAISE fnd_api.g_exc_unexpected_error;
1182: END IF;
1183: END IF;
1184:

Line 1181: RAISE fnd_api.g_exc_unexpected_error;

1177:
1178: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1179: THEN
1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181: RAISE fnd_api.g_exc_unexpected_error;
1182: END IF;
1183: END IF;
1184:
1185: ----------

Line 1192: IF ( p_planned_effort <> fnd_api.g_miss_num

1188:
1189: l_planned_effort := task_rec.planned_effort;
1190: l_planned_effort_uom := task_rec.planned_effort_uom ;
1191:
1192: IF ( p_planned_effort <> fnd_api.g_miss_num
1193: OR p_planned_effort_uom <> fnd_api.g_miss_char
1194: OR p_planned_effort IS NULL
1195: OR p_planned_effort_uom IS NULL)
1196: THEN

Line 1193: OR p_planned_effort_uom <> fnd_api.g_miss_char

1189: l_planned_effort := task_rec.planned_effort;
1190: l_planned_effort_uom := task_rec.planned_effort_uom ;
1191:
1192: IF ( p_planned_effort <> fnd_api.g_miss_num
1193: OR p_planned_effort_uom <> fnd_api.g_miss_char
1194: OR p_planned_effort IS NULL
1195: OR p_planned_effort_uom IS NULL)
1196: THEN
1197: /* IF (p_planned_effort <> fnd_api.g_miss_num)

Line 1197: /* IF (p_planned_effort <> fnd_api.g_miss_num)

1193: OR p_planned_effort_uom <> fnd_api.g_miss_char
1194: OR p_planned_effort IS NULL
1195: OR p_planned_effort_uom IS NULL)
1196: THEN
1197: /* IF (p_planned_effort <> fnd_api.g_miss_num)
1198: OR (p_planned_effort IS NULL)
1199: THEN
1200: l_planned_effort := p_planned_effort;
1201: ELSE

Line 1205: IF p_planned_effort_uom <> fnd_api.g_miss_char

1201: ELSE
1202: l_planned_effort := task_rec.planned_effort;
1203: END IF;
1204:
1205: IF p_planned_effort_uom <> fnd_api.g_miss_char
1206: OR (p_planned_effort_uom IS NULL)
1207: THEN
1208: l_planned_effort_uom := p_planned_effort_uom;
1209: ELSE

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

1219: p_effort_uom => l_planned_effort_uom,
1220: x_return_status => x_return_status
1221: );
1222:
1223: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1224: THEN
1225: x_return_status := fnd_api.g_ret_sts_unexp_error;
1226: RAISE fnd_api.g_exc_unexpected_error;
1227: END IF;

Line 1225: x_return_status := fnd_api.g_ret_sts_unexp_error;

1221: );
1222:
1223: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1224: THEN
1225: x_return_status := fnd_api.g_ret_sts_unexp_error;
1226: RAISE fnd_api.g_exc_unexpected_error;
1227: END IF;
1228: END IF;
1229:

Line 1226: RAISE fnd_api.g_exc_unexpected_error;

1222:
1223: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1224: THEN
1225: x_return_status := fnd_api.g_ret_sts_unexp_error;
1226: RAISE fnd_api.g_exc_unexpected_error;
1227: END IF;
1228: END IF;
1229:
1230: IF p_private_flag <> fnd_api.g_miss_char

Line 1230: IF p_private_flag <> fnd_api.g_miss_char

1226: RAISE fnd_api.g_exc_unexpected_error;
1227: END IF;
1228: END IF;
1229:
1230: IF p_private_flag <> fnd_api.g_miss_char
1231: THEN
1232: jtf_task_utl.validate_flag (p_flag_name => 'Private Flag', p_flag_value => p_private_flag, x_return_status => x_return_status);
1233:
1234: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

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

1230: IF p_private_flag <> fnd_api.g_miss_char
1231: THEN
1232: jtf_task_utl.validate_flag (p_flag_name => 'Private Flag', p_flag_value => p_private_flag, x_return_status => x_return_status);
1233:
1234: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1235: THEN
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;

Line 1236: x_return_status := fnd_api.g_ret_sts_unexp_error;

1232: jtf_task_utl.validate_flag (p_flag_name => 'Private Flag', p_flag_value => p_private_flag, x_return_status => x_return_status);
1233:
1234: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1235: THEN
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;
1239:
1240: l_private_flag := p_private_flag;

Line 1237: RAISE fnd_api.g_exc_unexpected_error;

1233:
1234: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1235: THEN
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;
1239:
1240: l_private_flag := p_private_flag;
1241: ELSE

Line 1248: IF p_publish_flag <> fnd_api.g_miss_char

1244:
1245: -------
1246: ------- Validate publish flag
1247: -------
1248: IF p_publish_flag <> fnd_api.g_miss_char
1249: OR p_publish_flag IS NULL
1250: THEN
1251: jtf_task_utl.validate_flag (p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag, x_return_status => x_return_status);
1252:

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

1249: OR p_publish_flag IS NULL
1250: THEN
1251: jtf_task_utl.validate_flag (p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag, x_return_status => x_return_status);
1252:
1253: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1254: THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: END IF;

Line 1255: x_return_status := fnd_api.g_ret_sts_unexp_error;

1251: jtf_task_utl.validate_flag (p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag, x_return_status => x_return_status);
1252:
1253: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1254: THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: END IF;
1258:
1259: l_publish_flag := p_publish_flag;

Line 1256: RAISE fnd_api.g_exc_unexpected_error;

1252:
1253: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1254: THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: END IF;
1258:
1259: l_publish_flag := p_publish_flag;
1260: ELSE

Line 1269: IF p_restrict_closure_flag <> fnd_api.g_miss_char

1265:
1266: -------
1267: ------- Validate restrict closure flag
1268: -------
1269: IF p_restrict_closure_flag <> fnd_api.g_miss_char
1270: OR p_restrict_closure_flag IS NULL
1271: THEN
1272: jtf_task_utl.validate_flag (
1273: p_flag_name => 'Restrict Closure Flag',

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

1274: p_flag_value => p_restrict_closure_flag,
1275: x_return_status => x_return_status
1276: );
1277:
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1279: THEN
1280: x_return_status := fnd_api.g_ret_sts_unexp_error;
1281: RAISE fnd_api.g_exc_unexpected_error;
1282: END IF;

Line 1280: x_return_status := fnd_api.g_ret_sts_unexp_error;

1276: );
1277:
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1279: THEN
1280: x_return_status := fnd_api.g_ret_sts_unexp_error;
1281: RAISE fnd_api.g_exc_unexpected_error;
1282: END IF;
1283:
1284: l_restrict_closure_flag := p_restrict_closure_flag;

Line 1281: RAISE fnd_api.g_exc_unexpected_error;

1277:
1278: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1279: THEN
1280: x_return_status := fnd_api.g_ret_sts_unexp_error;
1281: RAISE fnd_api.g_exc_unexpected_error;
1282: END IF;
1283:
1284: l_restrict_closure_flag := p_restrict_closure_flag;
1285: ELSE

Line 1292: IF p_multi_booked_flag <> fnd_api.g_miss_char

1288:
1289: -------
1290: ------- Validate multibooked flag
1291: -------
1292: IF p_multi_booked_flag <> fnd_api.g_miss_char
1293: OR p_multi_booked_flag IS NULL
1294: THEN
1295: jtf_task_utl.validate_flag (p_flag_name => 'Multi Booked Flag', p_flag_value => p_multi_booked_flag, x_return_status => x_return_status);
1296:

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

1293: OR p_multi_booked_flag IS NULL
1294: THEN
1295: jtf_task_utl.validate_flag (p_flag_name => 'Multi Booked Flag', p_flag_value => p_multi_booked_flag, x_return_status => x_return_status);
1296:
1297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1298: THEN
1299: x_return_status := fnd_api.g_ret_sts_unexp_error;
1300: RAISE fnd_api.g_exc_unexpected_error;
1301: END IF;

Line 1299: x_return_status := fnd_api.g_ret_sts_unexp_error;

1295: jtf_task_utl.validate_flag (p_flag_name => 'Multi Booked Flag', p_flag_value => p_multi_booked_flag, x_return_status => x_return_status);
1296:
1297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1298: THEN
1299: x_return_status := fnd_api.g_ret_sts_unexp_error;
1300: RAISE fnd_api.g_exc_unexpected_error;
1301: END IF;
1302:
1303: l_multi_booked_flag := p_multi_booked_flag;

Line 1300: RAISE fnd_api.g_exc_unexpected_error;

1296:
1297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1298: THEN
1299: x_return_status := fnd_api.g_ret_sts_unexp_error;
1300: RAISE fnd_api.g_exc_unexpected_error;
1301: END IF;
1302:
1303: l_multi_booked_flag := p_multi_booked_flag;
1304: ELSE

Line 1311: IF p_milestone_flag <> fnd_api.g_miss_char

1307:
1308: -------
1309: ------- Validate milestone flag
1310: -------
1311: IF p_milestone_flag <> fnd_api.g_miss_char
1312: OR p_milestone_flag IS NULL
1313: THEN
1314: jtf_task_utl.validate_flag (p_flag_name => 'Milestone Flag', p_flag_value => p_milestone_flag, x_return_status => x_return_status);
1315:

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

1312: OR p_milestone_flag IS NULL
1313: THEN
1314: jtf_task_utl.validate_flag (p_flag_name => 'Milestone Flag', p_flag_value => p_milestone_flag, x_return_status => x_return_status);
1315:
1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1317: THEN
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: RAISE fnd_api.g_exc_unexpected_error;
1320: END IF;

Line 1318: x_return_status := fnd_api.g_ret_sts_unexp_error;

1314: jtf_task_utl.validate_flag (p_flag_name => 'Milestone Flag', p_flag_value => p_milestone_flag, x_return_status => x_return_status);
1315:
1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1317: THEN
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: RAISE fnd_api.g_exc_unexpected_error;
1320: END IF;
1321:
1322: l_milestone_flag := p_milestone_flag;

Line 1319: RAISE fnd_api.g_exc_unexpected_error;

1315:
1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1317: THEN
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: RAISE fnd_api.g_exc_unexpected_error;
1320: END IF;
1321:
1322: l_milestone_flag := p_milestone_flag;
1323: ELSE

Line 1331: IF p_holiday_flag <> fnd_api.g_miss_char

1327: -------
1328: ------- Validate holiday flag
1329: -------
1330:
1331: IF p_holiday_flag <> fnd_api.g_miss_char
1332: OR p_holiday_flag IS NULL
1333: THEN
1334: jtf_task_utl.validate_flag (p_flag_name => 'Holiday Flag', p_flag_value => p_holiday_flag, x_return_status => x_return_status);
1335:

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

1332: OR p_holiday_flag IS NULL
1333: THEN
1334: jtf_task_utl.validate_flag (p_flag_name => 'Holiday Flag', p_flag_value => p_holiday_flag, x_return_status => x_return_status);
1335:
1336: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1337: THEN
1338: x_return_status := fnd_api.g_ret_sts_unexp_error;
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;

Line 1338: x_return_status := fnd_api.g_ret_sts_unexp_error;

1334: jtf_task_utl.validate_flag (p_flag_name => 'Holiday Flag', p_flag_value => p_holiday_flag, x_return_status => x_return_status);
1335:
1336: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1337: THEN
1338: x_return_status := fnd_api.g_ret_sts_unexp_error;
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341:
1342: l_holiday_flag := p_holiday_flag;

Line 1339: RAISE fnd_api.g_exc_unexpected_error;

1335:
1336: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1337: THEN
1338: x_return_status := fnd_api.g_ret_sts_unexp_error;
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341:
1342: l_holiday_flag := p_holiday_flag;
1343: ELSE

Line 1351: IF p_billable_flag <> fnd_api.g_miss_char

1347: -------
1348: ------- Validate billable flag
1349: -------
1350:
1351: IF p_billable_flag <> fnd_api.g_miss_char
1352: THEN
1353: jtf_task_utl.validate_flag (p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag, x_return_status => x_return_status);
1354:
1355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

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

1351: IF p_billable_flag <> fnd_api.g_miss_char
1352: THEN
1353: jtf_task_utl.validate_flag (p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag, x_return_status => x_return_status);
1354:
1355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1356: THEN
1357: x_return_status := fnd_api.g_ret_sts_unexp_error;
1358: RAISE fnd_api.g_exc_unexpected_error;
1359: END IF;

Line 1357: x_return_status := fnd_api.g_ret_sts_unexp_error;

1353: jtf_task_utl.validate_flag (p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag, x_return_status => x_return_status);
1354:
1355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1356: THEN
1357: x_return_status := fnd_api.g_ret_sts_unexp_error;
1358: RAISE fnd_api.g_exc_unexpected_error;
1359: END IF;
1360:
1361: l_billable_flag := p_billable_flag;

Line 1358: RAISE fnd_api.g_exc_unexpected_error;

1354:
1355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1356: THEN
1357: x_return_status := fnd_api.g_ret_sts_unexp_error;
1358: RAISE fnd_api.g_exc_unexpected_error;
1359: END IF;
1360:
1361: l_billable_flag := p_billable_flag;
1362: ELSE

Line 1370: IF ( p_alarm_start <> fnd_api.g_miss_num

1366: -----------
1367: ----------- Validate alarm
1368: -----------
1369:
1370: IF ( p_alarm_start <> fnd_api.g_miss_num
1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num

Line 1371: OR p_alarm_start_uom <> fnd_api.g_miss_char

1367: ----------- Validate alarm
1368: -----------
1369:
1370: IF ( p_alarm_start <> fnd_api.g_miss_num
1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num
1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char

Line 1372: OR p_alarm_on <> fnd_api.g_miss_char

1368: -----------
1369:
1370: IF ( p_alarm_start <> fnd_api.g_miss_num
1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num
1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char
1376: OR p_alarm_start IS NULL

Line 1373: OR p_alarm_count <> fnd_api.g_miss_num

1369:
1370: IF ( p_alarm_start <> fnd_api.g_miss_num
1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num
1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char
1376: OR p_alarm_start IS NULL
1377: OR p_alarm_start_uom IS NULL

Line 1374: OR p_alarm_interval <> fnd_api.g_miss_num

1370: IF ( p_alarm_start <> fnd_api.g_miss_num
1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num
1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char
1376: OR p_alarm_start IS NULL
1377: OR p_alarm_start_uom IS NULL
1378: OR p_alarm_on IS NULL

Line 1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char

1371: OR p_alarm_start_uom <> fnd_api.g_miss_char
1372: OR p_alarm_on <> fnd_api.g_miss_char
1373: OR p_alarm_count <> fnd_api.g_miss_num
1374: OR p_alarm_interval <> fnd_api.g_miss_num
1375: OR p_alarm_interval_uom <> fnd_api.g_miss_char
1376: OR p_alarm_start IS NULL
1377: OR p_alarm_start_uom IS NULL
1378: OR p_alarm_on IS NULL
1379: OR p_alarm_count IS NULL

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

1395: p_alarm_interval_uom => l_alarm_interval_uom,
1396: x_return_status => x_return_status
1397: );
1398:
1399: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1400: THEN
1401: x_return_status := fnd_api.g_ret_sts_unexp_error;
1402: RAISE fnd_api.g_exc_unexpected_error;
1403: END IF;

Line 1401: x_return_status := fnd_api.g_ret_sts_unexp_error;

1397: );
1398:
1399: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1400: THEN
1401: x_return_status := fnd_api.g_ret_sts_unexp_error;
1402: RAISE fnd_api.g_exc_unexpected_error;
1403: END IF;
1404:
1405: ELSE

Line 1402: RAISE fnd_api.g_exc_unexpected_error;

1398:
1399: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1400: THEN
1401: x_return_status := fnd_api.g_ret_sts_unexp_error;
1402: RAISE fnd_api.g_exc_unexpected_error;
1403: END IF;
1404:
1405: ELSE
1406: l_alarm_start := task_rec.alarm_start;

Line 1419: IF ( p_notification_period <> fnd_api.g_miss_num

1415:
1416: -------
1417: ------- Validate Notification
1418: -------
1419: IF ( p_notification_period <> fnd_api.g_miss_num
1420: OR p_notification_period IS NULL
1421: OR p_notification_period_uom <> fnd_api.g_miss_char
1422: OR p_notification_period_uom IS NULL
1423: OR p_notification_flag <> fnd_api.g_miss_char

Line 1421: OR p_notification_period_uom <> fnd_api.g_miss_char

1417: ------- Validate Notification
1418: -------
1419: IF ( p_notification_period <> fnd_api.g_miss_num
1420: OR p_notification_period IS NULL
1421: OR p_notification_period_uom <> fnd_api.g_miss_char
1422: OR p_notification_period_uom IS NULL
1423: OR p_notification_flag <> fnd_api.g_miss_char
1424: OR p_notification_flag IS NULL)
1425: THEN

Line 1423: OR p_notification_flag <> fnd_api.g_miss_char

1419: IF ( p_notification_period <> fnd_api.g_miss_num
1420: OR p_notification_period IS NULL
1421: OR p_notification_period_uom <> fnd_api.g_miss_char
1422: OR p_notification_period_uom IS NULL
1423: OR p_notification_flag <> fnd_api.g_miss_char
1424: OR p_notification_flag IS NULL)
1425: THEN
1426: l_notification_flag := task_rec.notification_flag;
1427: l_notification_period := task_rec.notification_period;

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

1433: x_return_status => x_return_status
1434: );
1435:
1436:
1437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1438: THEN
1439: x_return_status := fnd_api.g_ret_sts_unexp_error;
1440: RAISE fnd_api.g_exc_unexpected_error;
1441: END IF;

Line 1439: x_return_status := fnd_api.g_ret_sts_unexp_error;

1435:
1436:
1437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1438: THEN
1439: x_return_status := fnd_api.g_ret_sts_unexp_error;
1440: RAISE fnd_api.g_exc_unexpected_error;
1441: END IF;
1442:
1443:

Line 1440: RAISE fnd_api.g_exc_unexpected_error;

1436:
1437: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1438: THEN
1439: x_return_status := fnd_api.g_ret_sts_unexp_error;
1440: RAISE fnd_api.g_exc_unexpected_error;
1441: END IF;
1442:
1443:
1444: ELSE

Line 1453: p_init_msg_list => fnd_api.g_false,

1449:
1450:
1451: jtf_task_templates_pvt.update_task (
1452: p_api_version => 1.0,
1453: p_init_msg_list => fnd_api.g_false,
1454: p_commit => fnd_api.g_false,
1455: p_object_version_number => p_object_version_number,
1456: p_task_id => l_task_id,
1457: p_task_name => l_task_name,

Line 1454: p_commit => fnd_api.g_false,

1450:
1451: jtf_task_templates_pvt.update_task (
1452: p_api_version => 1.0,
1453: p_init_msg_list => fnd_api.g_false,
1454: p_commit => fnd_api.g_false,
1455: p_object_version_number => p_object_version_number,
1456: p_task_id => l_task_id,
1457: p_task_name => l_task_name,
1458: p_task_type_id => l_task_type_id,

Line 1504: WHEN fnd_api.g_exc_unexpected_error

1500: p_attribute_category => task_rec.attribute_category,
1501: p_task_confirmation_status => task_rec.task_confirmation_status
1502: );
1503: EXCEPTION
1504: WHEN fnd_api.g_exc_unexpected_error
1505: THEN
1506: ROLLBACK TO update_task_pub;
1507: x_return_status := fnd_api.g_ret_sts_unexp_error;
1508: WHEN NO_DATA_FOUND

Line 1507: x_return_status := fnd_api.g_ret_sts_unexp_error;

1503: EXCEPTION
1504: WHEN fnd_api.g_exc_unexpected_error
1505: THEN
1506: ROLLBACK TO update_task_pub;
1507: x_return_status := fnd_api.g_ret_sts_unexp_error;
1508: WHEN NO_DATA_FOUND
1509: THEN
1510: ROLLBACK TO update_task_pub;
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1511: x_return_status := fnd_api.g_ret_sts_unexp_error;

1507: x_return_status := fnd_api.g_ret_sts_unexp_error;
1508: WHEN NO_DATA_FOUND
1509: THEN
1510: ROLLBACK TO update_task_pub;
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512: WHEN OTHERS
1513: THEN
1514: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1515: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 1517: x_return_status := fnd_api.g_ret_sts_unexp_error;

1513: THEN
1514: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1515: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1516: ROLLBACK TO update_task_pub;
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518: END;
1519:
1520: PROCEDURE update_task (
1521: p_api_version IN NUMBER,

Line 1522: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1518: END;
1519:
1520: PROCEDURE update_task (
1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1519:
1520: PROCEDURE update_task (
1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,

1521: p_api_version IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1522: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,

1523: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1524: p_object_version_number IN OUT NOCOPY NUMBER ,
1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1525: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,

1526: p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1527: p_task_group_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1528: p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

1529: p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1530: p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

1531: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,

1532: p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1533: p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,

1534: p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1535: p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1536: p_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1537: p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1538: p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1539: p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1540: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1541: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1542: p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1543: p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,

1544: p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1545: p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,

1546: p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1547: p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1548: p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num,
1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1556: x_return_status OUT NOCOPY VARCHAR2,

Line 1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,

1549: p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,

Line 1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,

1550: p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,

Line 1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1551: p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1552: p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1553: p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num,
1554: p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num,
1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1581: x_return_status := fnd_api.g_ret_sts_success;

1577: l_api_version CONSTANT NUMBER := 1.0;
1578: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
1579: BEGIN
1580: SAVEPOINT update_task_pub1;
1581: x_return_status := fnd_api.g_ret_sts_success;
1582:
1583: IF NOT fnd_api.compatible_api_call (
1584: l_api_version,
1585: p_api_version,

Line 1583: IF NOT fnd_api.compatible_api_call (

1579: BEGIN
1580: SAVEPOINT update_task_pub1;
1581: x_return_status := fnd_api.g_ret_sts_success;
1582:
1583: IF NOT fnd_api.compatible_api_call (
1584: l_api_version,
1585: p_api_version,
1586: l_api_name,
1587: g_pkg_name

Line 1590: RAISE fnd_api.g_exc_unexpected_error;

1586: l_api_name,
1587: g_pkg_name
1588: )
1589: THEN
1590: RAISE fnd_api.g_exc_unexpected_error;
1591: END IF;
1592:
1593: IF fnd_api.to_boolean (p_init_msg_list)
1594: THEN

Line 1593: IF fnd_api.to_boolean (p_init_msg_list)

1589: THEN
1590: RAISE fnd_api.g_exc_unexpected_error;
1591: END IF;
1592:
1593: IF fnd_api.to_boolean (p_init_msg_list)
1594: THEN
1595: fnd_msg_pub.initialize;
1596: END IF;
1597:

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

1653: p_attribute_category => p_attribute_category,
1654: p_task_confirmation_status => 'N'
1655: );
1656:
1657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1658: THEN
1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1660: RAISE fnd_api.g_exc_unexpected_error;
1661: END IF;

Line 1659: x_return_status := fnd_api.g_ret_sts_unexp_error;

1655: );
1656:
1657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1658: THEN
1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1660: RAISE fnd_api.g_exc_unexpected_error;
1661: END IF;
1662:
1663: IF fnd_api.to_boolean (p_commit)

Line 1660: RAISE fnd_api.g_exc_unexpected_error;

1656:
1657: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1658: THEN
1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1660: RAISE fnd_api.g_exc_unexpected_error;
1661: END IF;
1662:
1663: IF fnd_api.to_boolean (p_commit)
1664: THEN

Line 1663: IF fnd_api.to_boolean (p_commit)

1659: x_return_status := fnd_api.g_ret_sts_unexp_error;
1660: RAISE fnd_api.g_exc_unexpected_error;
1661: END IF;
1662:
1663: IF fnd_api.to_boolean (p_commit)
1664: THEN
1665: COMMIT WORK;
1666: END IF;
1667:

Line 1670: WHEN fnd_api.g_exc_unexpected_error

1666: END IF;
1667:
1668: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_unexpected_error
1671: THEN
1672: ROLLBACK TO update_task_pub1;
1673: x_return_status := fnd_api.g_ret_sts_unexp_error;
1674: fnd_msg_pub.count_and_get (

Line 1673: x_return_status := fnd_api.g_ret_sts_unexp_error;

1669: EXCEPTION
1670: WHEN fnd_api.g_exc_unexpected_error
1671: THEN
1672: ROLLBACK TO update_task_pub1;
1673: x_return_status := fnd_api.g_ret_sts_unexp_error;
1674: fnd_msg_pub.count_and_get (
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );

Line 1683: x_return_status := fnd_api.g_ret_sts_unexp_error;

1679: THEN
1680: ROLLBACK TO update_task_pub1;
1681: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1682: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684: fnd_msg_pub.count_and_get (
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );

Line 1692: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1688: END;
1689:
1690: PROCEDURE delete_task (
1691: p_api_version IN NUMBER,
1692: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1693: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1694: p_object_version_number IN NUMBER ,
1695:
1696: p_task_id IN NUMBER DEFAULT NULL,

Line 1693: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1689:
1690: PROCEDURE delete_task (
1691: p_api_version IN NUMBER,
1692: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1693: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1694: p_object_version_number IN NUMBER ,
1695:
1696: p_task_id IN NUMBER DEFAULT NULL,
1697: p_task_number IN VARCHAR2 DEFAULT NULL,

Line 1711: x_return_status := fnd_api.g_ret_sts_success;

1707: BEGIN
1708:
1709: SAVEPOINT delete_task_pub;
1710:
1711: x_return_status := fnd_api.g_ret_sts_success;
1712:
1713: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1714: THEN
1715: RAISE fnd_api.g_exc_unexpected_error;

Line 1713: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1709: SAVEPOINT delete_task_pub;
1710:
1711: x_return_status := fnd_api.g_ret_sts_success;
1712:
1713: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1714: THEN
1715: RAISE fnd_api.g_exc_unexpected_error;
1716: END IF;
1717:

Line 1715: RAISE fnd_api.g_exc_unexpected_error;

1711: x_return_status := fnd_api.g_ret_sts_success;
1712:
1713: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1714: THEN
1715: RAISE fnd_api.g_exc_unexpected_error;
1716: END IF;
1717:
1718: IF fnd_api.to_boolean (p_init_msg_list)
1719: THEN

Line 1718: IF fnd_api.to_boolean (p_init_msg_list)

1714: THEN
1715: RAISE fnd_api.g_exc_unexpected_error;
1716: END IF;
1717:
1718: IF fnd_api.to_boolean (p_init_msg_list)
1719: THEN
1720: fnd_msg_pub.initialize;
1721: END IF;
1722:

Line 1728: x_return_status := fnd_api.g_ret_sts_unexp_error;

1724: AND l_task_number IS NULL)
1725: THEN
1726: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
1727: fnd_msg_pub.add;
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: RAISE fnd_api.g_exc_unexpected_error;
1730: ELSE
1731: jtf_task_utl.validate_task_template (
1732: p_task_id => l_task_id,

Line 1729: RAISE fnd_api.g_exc_unexpected_error;

1725: THEN
1726: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
1727: fnd_msg_pub.add;
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: RAISE fnd_api.g_exc_unexpected_error;
1730: ELSE
1731: jtf_task_utl.validate_task_template (
1732: p_task_id => l_task_id,
1733: p_task_number => l_task_number,

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

1734: x_task_id => l_task_id,
1735: x_return_status => x_return_status
1736: );
1737:
1738: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1739: THEN
1740: x_return_status := fnd_api.g_ret_sts_unexp_error;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;

Line 1740: x_return_status := fnd_api.g_ret_sts_unexp_error;

1736: );
1737:
1738: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1739: THEN
1740: x_return_status := fnd_api.g_ret_sts_unexp_error;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

Line 1741: RAISE fnd_api.g_exc_unexpected_error;

1737:
1738: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1739: THEN
1740: x_return_status := fnd_api.g_ret_sts_unexp_error;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1745: THEN

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

1740: x_return_status := fnd_api.g_ret_sts_unexp_error;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1745: THEN
1746: x_return_status := fnd_api.g_ret_sts_unexp_error;
1747: RAISE fnd_api.g_exc_unexpected_error;
1748: END IF;

Line 1746: x_return_status := fnd_api.g_ret_sts_unexp_error;

1742: END IF;
1743:
1744: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1745: THEN
1746: x_return_status := fnd_api.g_ret_sts_unexp_error;
1747: RAISE fnd_api.g_exc_unexpected_error;
1748: END IF;
1749: END IF;
1750:

Line 1747: RAISE fnd_api.g_exc_unexpected_error;

1743:
1744: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1745: THEN
1746: x_return_status := fnd_api.g_ret_sts_unexp_error;
1747: RAISE fnd_api.g_exc_unexpected_error;
1748: END IF;
1749: END IF;
1750:
1751: jtf_task_templates_pvt.delete_task (

Line 1753: p_init_msg_list => fnd_api.g_false,

1749: END IF;
1750:
1751: jtf_task_templates_pvt.delete_task (
1752: p_api_version => 1.0,
1753: p_init_msg_list => fnd_api.g_false,
1754: p_commit => fnd_api.g_false,
1755: p_object_version_number => p_object_version_number,
1756: p_task_id => l_task_id,
1757: x_return_status => x_return_status,

Line 1754: p_commit => fnd_api.g_false,

1750:
1751: jtf_task_templates_pvt.delete_task (
1752: p_api_version => 1.0,
1753: p_init_msg_list => fnd_api.g_false,
1754: p_commit => fnd_api.g_false,
1755: p_object_version_number => p_object_version_number,
1756: p_task_id => l_task_id,
1757: x_return_status => x_return_status,
1758: x_msg_count => x_msg_count,

Line 1762: IF fnd_api.to_boolean (p_commit)

1758: x_msg_count => x_msg_count,
1759: x_msg_data => x_msg_data
1760: );
1761:
1762: IF fnd_api.to_boolean (p_commit)
1763: THEN
1764: COMMIT WORK;
1765: END IF;
1766:

Line 1769: WHEN fnd_api.g_exc_unexpected_error

1765: END IF;
1766:
1767: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1768: EXCEPTION
1769: WHEN fnd_api.g_exc_unexpected_error
1770: THEN
1771: ROLLBACK TO delete_task_pub;
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1772: x_return_status := fnd_api.g_ret_sts_unexp_error;

1768: EXCEPTION
1769: WHEN fnd_api.g_exc_unexpected_error
1770: THEN
1771: ROLLBACK TO delete_task_pub;
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1774: WHEN OTHERS
1775: THEN
1776: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 1779: x_return_status := fnd_api.g_ret_sts_unexp_error;

1775: THEN
1776: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1777: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1778: ROLLBACK TO delete_task_pub;
1779: x_return_status := fnd_api.g_ret_sts_unexp_error;
1780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1781: END;
1782:
1783: