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 2618: p_task_id IN JTF_TASKS_VL.TASK_ID%TYPE,

2614: p_end_date IN DATE,
2615: p_territory_flag IN VARCHAR2,
2616: p_calendar_flag IN VARCHAR2,
2617: p_web_availability_flag IN VARCHAR2,
2618: p_task_id IN JTF_TASKS_VL.TASK_ID%TYPE,
2619: p_column_list IN VARCHAR2,
2620: p_business_process_id IN NUMBER,
2621: p_business_process_date IN DATE,
2622: p_filter_excluded_resource IN VARCHAR2,

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

2637: l_planned_start_date DATE;
2638: l_planned_end_date DATE;
2639: l_effort_duration NUMBER;
2640: l_effort_uom VARCHAR2(30);
2641: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2642: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2643: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2644: l_contract_id NUMBER;
2645: l_cp_id NUMBER;

Line 2642: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

2638: l_planned_end_date DATE;
2639: l_effort_duration NUMBER;
2640: l_effort_uom VARCHAR2(30);
2641: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2642: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2643: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2644: l_contract_id NUMBER;
2645: l_cp_id NUMBER;
2646: l_contract_flag VARCHAR2(1) := 'N';

Line 2643: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

2639: l_effort_duration NUMBER;
2640: l_effort_uom VARCHAR2(30);
2641: l_task_id JTF_TASKS_VL.TASK_ID%TYPE := p_task_id;
2642: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
2643: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
2644: l_contract_id NUMBER;
2645: l_cp_id NUMBER;
2646: l_contract_flag VARCHAR2(1) := 'N';
2647:

Line 2706: FROM jtf_tasks_vl

2702: planned_start_date,
2703: planned_end_date,
2704: planned_effort,
2705: planned_effort_uom
2706: FROM jtf_tasks_vl
2707: WHERE task_id = l_task_id;
2708: l_cur_task_id cur_task_id%ROWTYPE;
2709:
2710:

Line 9508: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

9504: l_planned_end_date DATE;
9505: l_effort_duration NUMBER;
9506: l_effort_uom VARCHAR2(30);
9507:
9508: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9509: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9510: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9511:
9512: l_territory_id NUMBER;

Line 9509: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

9505: l_effort_duration NUMBER;
9506: l_effort_uom VARCHAR2(30);
9507:
9508: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9509: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9510: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9511:
9512: l_territory_id NUMBER;
9513: l_esc_territory_id NUMBER;

Line 9562: FROM jtf_tasks_vl

9558: planned_start_date,
9559: planned_end_date,
9560: planned_effort,
9561: planned_effort_uom
9562: FROM jtf_tasks_vl
9563: WHERE task_id = l_esc_id;
9564: l_cur_esc_id cur_esc_id%ROWTYPE;
9565:
9566:

Line 9579: FROM jtf_tasks_vl

9575:
9576:
9577: CURSOR cur_source_task IS
9578: SELECT owner_territory_id
9579: FROM jtf_tasks_vl
9580: WHERE task_id = l_object_id;
9581:
9582:
9583: TYPE DYNAMIC_CUR_TYP IS REF CURSOR;

Line 12054: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;

12050:
12051: l_sr_id NUMBER;
12052: l_task_id NUMBER;
12053: l_dr_id NUMBER;
12054: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
12055: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
12056:
12057: l_return_status VARCHAR2(10);
12058: l_msg_count NUMBER;

Line 12055: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;

12051: l_sr_id NUMBER;
12052: l_task_id NUMBER;
12053: l_dr_id NUMBER;
12054: l_task_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
12055: l_task_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
12056:
12057: l_return_status VARCHAR2(10);
12058: l_msg_count NUMBER;
12059: l_msg_data VARCHAR2(2000);

Line 12074: FROM jtf_tasks_vl

12070: planned_start_date,
12071: planned_end_date,
12072: planned_effort,
12073: planned_effort_uom
12074: FROM jtf_tasks_vl
12075: WHERE task_id = l_task_id;
12076:
12077: l_cur_task_id cur_task_id%ROWTYPE;
12078: