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_PVT dependencies on JTF_TASKS_B

Line 20: from jtf_tasks_b

16: -- Cursor for getting scheduled_start_date and scheduled_end_date
17: cursor c_task_dates(l_task_id in number)
18: is
19: select scheduled_start_date ssd, scheduled_end_date sed
20: from jtf_tasks_b
21: where task_id = l_task_id;
22:
23: l_child_start_date date;
24: l_master_start_date date;

Line 147: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

143: p_template_flag in varchar2)
144: return varchar2
145: is
146: x char;
147: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
148: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
149:
150: -- Cursor for checking if there is a duplicate dependency
151: cursor c_check_dup_temp_y (l_task_id in number,

Line 148: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

144: return varchar2
145: is
146: x char;
147: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
148: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
149:
150: -- Cursor for checking if there is a duplicate dependency
151: cursor c_check_dup_temp_y (l_task_id in number,
152: l_dependent_on_task_id in number,

Line 497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

493: l_api_version CONSTANT NUMBER := 1.0;
494: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
495: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
496: l_rowid ROWID;
497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
500: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
501:

Line 498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;

494: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
495: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
496: l_rowid ROWID;
497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
500: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
501:
502: BEGIN

Line 499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

495: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
496: l_rowid ROWID;
497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
500: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
501:
502: BEGIN
503: SAVEPOINT create_task_dependency_pvt;

Line 500: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

496: l_rowid ROWID;
497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
500: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
501:
502: BEGIN
503: SAVEPOINT create_task_dependency_pvt;
504:

Line 724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

720: )
721: IS
722: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
723:
724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;

Line 725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

721: IS
722: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
723:
724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;

Line 726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

722: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
723:
724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;

Line 727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;

723:
724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;