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_ASSIGN_PUB dependencies on JTF_TASKS_VL

Line 2655: p_task_id IN JTF_TASKS_VL.TASK_ID%TYPE,

2651: p_end_date IN DATE,
2652: p_territory_flag IN VARCHAR2,
2653: p_calendar_flag IN VARCHAR2,
2654: p_web_availability_flag IN VARCHAR2,
2655: p_task_id IN JTF_TASKS_VL.TASK_ID%TYPE,
2656: p_column_list IN VARCHAR2,
2657: p_business_process_id IN NUMBER,
2658: p_business_process_date IN DATE,
2659: p_filter_excluded_resource IN VARCHAR2,

Line 2678: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;

2674: l_planned_start_date DATE;
2675: l_planned_end_date DATE;
2676: l_effort_duration NUMBER;
2677: l_effort_uom VARCHAR2(30);
2678: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2679: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2680: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2681: l_contract_id NUMBER;
2682: l_cp_id NUMBER;

Line 2679: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

2675: l_planned_end_date DATE;
2676: l_effort_duration NUMBER;
2677: l_effort_uom VARCHAR2(30);
2678: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2679: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2680: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2681: l_contract_id NUMBER;
2682: l_cp_id NUMBER;
2683: l_contract_flag VARCHAR2(1) := 'N';

Line 2680: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

2676: l_effort_duration NUMBER;
2677: l_effort_uom VARCHAR2(30);
2678: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2679: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2680: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2681: l_contract_id NUMBER;
2682: l_cp_id NUMBER;
2683: l_contract_flag VARCHAR2(1) := 'N';
2684:

Line 2743: FROM jtf_tasks_vl

2739: planned_start_date,
2740: planned_end_date,
2741: planned_effort,
2742: planned_effort_uom
2743: FROM jtf_tasks_vl
2744: WHERE task_id = l_task_id;
2745: l_cur_task_id cur_task_id%ROWTYPE;
2746:
2747:

Line 9572: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

9568: l_planned_end_date DATE;
9569: l_effort_duration NUMBER;
9570: l_effort_uom VARCHAR2(30);
9571:
9572: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9573: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9574: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9575:
9576: l_territory_id NUMBER;

Line 9573: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

9569: l_effort_duration NUMBER;
9570: l_effort_uom VARCHAR2(30);
9571:
9572: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9573: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9574: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9575:
9576: l_territory_id NUMBER;
9577: l_esc_territory_id NUMBER;

Line 9626: FROM jtf_tasks_vl

9622: planned_start_date,
9623: planned_end_date,
9624: planned_effort,
9625: planned_effort_uom
9626: FROM jtf_tasks_vl
9627: WHERE task_id = l_esc_id;
9628: l_cur_esc_id cur_esc_id%ROWTYPE;
9629:
9630:

Line 9643: FROM jtf_tasks_vl

9639:
9640:
9641: CURSOR cur_source_task IS
9642: SELECT owner_territory_id
9643: FROM jtf_tasks_vl
9644: WHERE task_id = l_object_id;
9645:
9646:
9647: TYPE DYNAMIC_CUR_TYP IS REF CURSOR;

Line 12132: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

12128:
12129: l_sr_id NUMBER;
12130: l_task_id NUMBER;
12131: l_dr_id NUMBER;
12132: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
12133: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
12134:
12135: l_return_status VARCHAR2(10);
12136: l_msg_count NUMBER;

Line 12133: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

12129: l_sr_id NUMBER;
12130: l_task_id NUMBER;
12131: l_dr_id NUMBER;
12132: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
12133: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
12134:
12135: l_return_status VARCHAR2(10);
12136: l_msg_count NUMBER;
12137: l_msg_data VARCHAR2(2000);

Line 12152: FROM jtf_tasks_vl

12148: planned_start_date,
12149: planned_end_date,
12150: planned_effort,
12151: planned_effort_uom
12152: FROM jtf_tasks_vl
12153: WHERE task_id = l_task_id;
12154:
12155: l_cur_task_id cur_task_id%ROWTYPE;
12156: