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_DEPENDENCY_PUB dependencies on JTF_TASK_DEPENDS

Line 47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;

43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
51: x CHAR;

Line 48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;

44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
51: x CHAR;
52: BEGIN

Line 49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;

45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
51: x CHAR;
52: BEGIN
53: SAVEPOINT create_task_dependency_pub;

Line 50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;

46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
51: x CHAR;
52: BEGIN
53: SAVEPOINT create_task_dependency_pub;
54: x_return_status := fnd_api.g_ret_sts_success;

Line 292: jtf_task_depends_pkg.lock_row(

288: END IF;
289:
290: x_return_status := fnd_api.g_ret_sts_success;
291:
292: jtf_task_depends_pkg.lock_row(
293: x_dependency_id => p_dependency_id ,
294: x_object_version_number => p_object_version_number );
295:
296:

Line 361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;

357: )
358: IS
359: l_api_version CONSTANT NUMBER := 1.0;
360: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;

Line 365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;

361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;
369: x CHAR;

Line 366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;

362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;
369: x CHAR;
370:

Line 367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;

363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;
369: x CHAR;
370:
371: CURSOR c_jtf_task_depends

Line 368: l_template_flag jtf_task_depends.template_flag%TYPE;

364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;
369: x CHAR;
370:
371: CURSOR c_jtf_task_depends
372: IS

Line 371: CURSOR c_jtf_task_depends

367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;
369: x CHAR;
370:
371: CURSOR c_jtf_task_depends
372: IS
373: SELECT
374: DECODE (p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id,
375: DECODE (p_dependent_on_task_id, fnd_api.g_miss_num, dependent_on_task_id, p_dependent_on_task_id) dependent_on_task_id,

Line 396: FROM jtf_task_depends

392: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
393: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
394: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
395: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
396: FROM jtf_task_depends
397: WHERE dependency_id = p_dependency_id;
398:
399: task_depends c_jtf_task_depends%ROWTYPE;
400: BEGIN

Line 399: task_depends c_jtf_task_depends%ROWTYPE;

395: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
396: FROM jtf_task_depends
397: WHERE dependency_id = p_dependency_id;
398:
399: task_depends c_jtf_task_depends%ROWTYPE;
400: BEGIN
401:
402: SAVEPOINT update_task_dependency_pub;
403: x_return_status := fnd_api.g_ret_sts_success;

Line 424: OPEN c_jtf_task_depends;

420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: OPEN c_jtf_task_depends;
425: FETCH c_jtf_task_depends INTO task_depends;
426:
427: IF c_jtf_task_depends%NOTFOUND
428: THEN

Line 425: FETCH c_jtf_task_depends INTO task_depends;

421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: OPEN c_jtf_task_depends;
425: FETCH c_jtf_task_depends INTO task_depends;
426:
427: IF c_jtf_task_depends%NOTFOUND
428: THEN
429: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');

Line 427: IF c_jtf_task_depends%NOTFOUND

423:
424: OPEN c_jtf_task_depends;
425: FETCH c_jtf_task_depends INTO task_depends;
426:
427: IF c_jtf_task_depends%NOTFOUND
428: THEN
429: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
430: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
431: fnd_msg_pub.add;

Line 549: IF c_jtf_task_depends%ISOPEN

545: THEN
546: COMMIT WORK;
547: END IF;
548:
549: IF c_jtf_task_depends%ISOPEN
550: THEN
551: CLOSE c_jtf_task_depends;
552: END IF;
553:

Line 551: CLOSE c_jtf_task_depends;

547: END IF;
548:
549: IF c_jtf_task_depends%ISOPEN
550: THEN
551: CLOSE c_jtf_task_depends;
552: END IF;
553:
554: fnd_msg_pub.count_and_get (
555: p_count => x_msg_count,

Line 562: IF c_jtf_task_depends%ISOPEN

558: WHEN fnd_api.g_exc_unexpected_error
559: THEN
560: ROLLBACK TO update_task_dependency_pub;
561:
562: IF c_jtf_task_depends%ISOPEN
563: THEN
564: CLOSE c_jtf_task_depends;
565: END IF;
566:

Line 564: CLOSE c_jtf_task_depends;

560: ROLLBACK TO update_task_dependency_pub;
561:
562: IF c_jtf_task_depends%ISOPEN
563: THEN
564: CLOSE c_jtf_task_depends;
565: END IF;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 571: IF c_jtf_task_depends%ISOPEN

567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
569: WHEN OTHERS
570: THEN
571: IF c_jtf_task_depends%ISOPEN
572: THEN
573: CLOSE c_jtf_task_depends;
574: END IF;
575:

Line 573: CLOSE c_jtf_task_depends;

569: WHEN OTHERS
570: THEN
571: IF c_jtf_task_depends%ISOPEN
572: THEN
573: CLOSE c_jtf_task_depends;
574: END IF;
575:
576: ROLLBACK TO update_task_dependency_pub;
577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 599: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;

595: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_DEPENDENCY';
596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
597: l_msg_data VARCHAR2(2000);
598: l_msg_count NUMBER;
599: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
600:
601: CURSOR c_jtf_task_depends
602: IS
603: SELECT 1

Line 601: CURSOR c_jtf_task_depends

597: l_msg_data VARCHAR2(2000);
598: l_msg_count NUMBER;
599: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
600:
601: CURSOR c_jtf_task_depends
602: IS
603: SELECT 1
604: FROM jtf_task_depends
605: WHERE dependency_id = l_dependency_id;

Line 604: FROM jtf_task_depends

600:
601: CURSOR c_jtf_task_depends
602: IS
603: SELECT 1
604: FROM jtf_task_depends
605: WHERE dependency_id = l_dependency_id;
606:
607: x CHAR;
608: BEGIN

Line 636: OPEN c_jtf_task_depends;

632: RAISE fnd_api.g_exc_unexpected_error;
633: END IF;
634:
635: ---- if the dependency is NOT valid, then it is an error
636: OPEN c_jtf_task_depends;
637: FETCH c_jtf_task_depends INTO x;
638:
639: IF c_jtf_task_depends%NOTFOUND
640: THEN

Line 637: FETCH c_jtf_task_depends INTO x;

633: END IF;
634:
635: ---- if the dependency is NOT valid, then it is an error
636: OPEN c_jtf_task_depends;
637: FETCH c_jtf_task_depends INTO x;
638:
639: IF c_jtf_task_depends%NOTFOUND
640: THEN
641: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');

Line 639: IF c_jtf_task_depends%NOTFOUND

635: ---- if the dependency is NOT valid, then it is an error
636: OPEN c_jtf_task_depends;
637: FETCH c_jtf_task_depends INTO x;
638:
639: IF c_jtf_task_depends%NOTFOUND
640: THEN
641: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
642: fnd_message.set_token('P_DEPENDENCY_ID',P_DEPENDENCY_ID);
643: fnd_msg_pub.add;

Line 666: IF c_jtf_task_depends%ISOPEN

662: END IF;
663:
664: END IF;
665:
666: IF c_jtf_task_depends%ISOPEN
667: THEN
668: CLOSE c_jtf_task_depends;
669: END IF;
670:

Line 668: CLOSE c_jtf_task_depends;

664: END IF;
665:
666: IF c_jtf_task_depends%ISOPEN
667: THEN
668: CLOSE c_jtf_task_depends;
669: END IF;
670:
671: IF fnd_api.to_boolean (p_commit)
672: THEN

Line 684: IF c_jtf_task_depends%ISOPEN

680:
681:
682: ROLLBACK TO delete_task_dependency_pub;
683:
684: IF c_jtf_task_depends%ISOPEN
685: THEN
686: CLOSE c_jtf_task_depends;
687: END IF;
688:

Line 686: CLOSE c_jtf_task_depends;

682: ROLLBACK TO delete_task_dependency_pub;
683:
684: IF c_jtf_task_depends%ISOPEN
685: THEN
686: CLOSE c_jtf_task_depends;
687: END IF;
688:
689: x_return_status := fnd_api.g_ret_sts_error;
690: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 697: IF c_jtf_task_depends%ISOPEN

693:
694:
695: ROLLBACK TO delete_task_dependency_pub;
696:
697: IF c_jtf_task_depends%ISOPEN
698: THEN
699: CLOSE c_jtf_task_depends;
700: END IF;
701:

Line 699: CLOSE c_jtf_task_depends;

695: ROLLBACK TO delete_task_dependency_pub;
696:
697: IF c_jtf_task_depends%ISOPEN
698: THEN
699: CLOSE c_jtf_task_depends;
700: END IF;
701:
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 709: IF c_jtf_task_depends%ISOPEN

705: THEN
706:
707: ROLLBACK TO delete_task_dependency_pub;
708:
709: IF c_jtf_task_depends%ISOPEN
710: THEN
711: CLOSE c_jtf_task_depends;
712: END IF;
713:

Line 711: CLOSE c_jtf_task_depends;

707: ROLLBACK TO delete_task_dependency_pub;
708:
709: IF c_jtf_task_depends%ISOPEN
710: THEN
711: CLOSE c_jtf_task_depends;
712: END IF;
713:
714: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);