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.CSF_GANTT_DATA_PKG dependencies on JTF_DATE_TABLE

Line 1530: , start_date OUT NOCOPY jtf_date_table

1526: , x_return_status OUT NOCOPY VARCHAR2
1527: , x_msg_count OUT NOCOPY NUMBER
1528: , x_msg_data OUT NOCOPY VARCHAR2
1529: , task_id OUT NOCOPY jtf_varchar2_table_100
1530: , start_date OUT NOCOPY jtf_date_table
1531: , end_date OUT NOCOPY jtf_date_table
1532: , color OUT NOCOPY jtf_number_table
1533: , NAME OUT NOCOPY jtf_varchar2_table_100
1534: , tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 1531: , end_date OUT NOCOPY jtf_date_table

1527: , x_msg_count OUT NOCOPY NUMBER
1528: , x_msg_data OUT NOCOPY VARCHAR2
1529: , task_id OUT NOCOPY jtf_varchar2_table_100
1530: , start_date OUT NOCOPY jtf_date_table
1531: , end_date OUT NOCOPY jtf_date_table
1532: , color OUT NOCOPY jtf_number_table
1533: , NAME OUT NOCOPY jtf_varchar2_table_100
1534: , tooltip OUT NOCOPY jtf_varchar2_table_2000
1535: , DURATION OUT NOCOPY jtf_number_table

Line 1575: start_date := jtf_date_table();

1571: l_return_status VARCHAR2(1);
1572:
1573: BEGIN
1574: task_id := jtf_varchar2_table_100();
1575: start_date := jtf_date_table();
1576: end_date := jtf_date_table();
1577: color := jtf_number_table();
1578: NAME := jtf_varchar2_table_100();
1579: tooltip := jtf_varchar2_table_2000();

Line 1576: end_date := jtf_date_table();

1572:
1573: BEGIN
1574: task_id := jtf_varchar2_table_100();
1575: start_date := jtf_date_table();
1576: end_date := jtf_date_table();
1577: color := jtf_number_table();
1578: NAME := jtf_varchar2_table_100();
1579: tooltip := jtf_varchar2_table_2000();
1580: DURATION := jtf_number_table();

Line 2337: , p_shift_start_date OUT NOCOPY jtf_date_table

2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table
2338: , p_shift_end_date OUT NOCOPY jtf_date_table
2339: , p_block_trip OUT NOCOPY jtf_number_table
2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100

Line 2338: , p_shift_end_date OUT NOCOPY jtf_date_table

2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table
2338: , p_shift_end_date OUT NOCOPY jtf_date_table
2339: , p_block_trip OUT NOCOPY jtf_number_table
2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
2342: , p_vir_start_date OUT NOCOPY jtf_date_table

Line 2342: , p_vir_start_date OUT NOCOPY jtf_date_table

2338: , p_shift_end_date OUT NOCOPY jtf_date_table
2339: , p_block_trip OUT NOCOPY jtf_number_table
2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
2342: , p_vir_start_date OUT NOCOPY jtf_date_table
2343: , p_vir_end_date OUT NOCOPY jtf_date_table
2344: , p_vir_color OUT NOCOPY jtf_number_table
2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
2346: , p_vir_duration OUT NOCOPY jtf_number_table

Line 2343: , p_vir_end_date OUT NOCOPY jtf_date_table

2339: , p_block_trip OUT NOCOPY jtf_number_table
2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
2342: , p_vir_start_date OUT NOCOPY jtf_date_table
2343: , p_vir_end_date OUT NOCOPY jtf_date_table
2344: , p_vir_color OUT NOCOPY jtf_number_table
2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
2346: , p_vir_duration OUT NOCOPY jtf_number_table
2347: , p_vir_task_type_id OUT NOCOPY jtf_number_table

Line 2351: , real_start_date OUT NOCOPY jtf_date_table

2347: , p_vir_task_type_id OUT NOCOPY jtf_number_table
2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
2350: , real_task_id OUT NOCOPY jtf_varchar2_table_100
2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table
2353: , real_color OUT NOCOPY jtf_number_table
2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 2352: , real_end_date OUT NOCOPY jtf_date_table

2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
2350: , real_task_id OUT NOCOPY jtf_varchar2_table_100
2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table
2353: , real_color OUT NOCOPY jtf_number_table
2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
2356: , real_DURATION OUT NOCOPY jtf_number_table

Line 2371: l_planned_start_date jtf_date_table;

2367: IS
2368: l_assignment_id jtf_number_table;
2369: l_task_priority_id jtf_number_table;
2370: l_status_id jtf_number_table;
2371: l_planned_start_date jtf_date_table;
2372: l_planned_end_date jtf_date_table;
2373: l_actual_start_date jtf_date_table;
2374: l_actual_end_date jtf_date_table;
2375: l_actual_effort jtf_number_table;

Line 2372: l_planned_end_date jtf_date_table;

2368: l_assignment_id jtf_number_table;
2369: l_task_priority_id jtf_number_table;
2370: l_status_id jtf_number_table;
2371: l_planned_start_date jtf_date_table;
2372: l_planned_end_date jtf_date_table;
2373: l_actual_start_date jtf_date_table;
2374: l_actual_end_date jtf_date_table;
2375: l_actual_effort jtf_number_table;
2376: l_actual_effort_uom jtf_varchar2_table_100;

Line 2373: l_actual_start_date jtf_date_table;

2369: l_task_priority_id jtf_number_table;
2370: l_status_id jtf_number_table;
2371: l_planned_start_date jtf_date_table;
2372: l_planned_end_date jtf_date_table;
2373: l_actual_start_date jtf_date_table;
2374: l_actual_end_date jtf_date_table;
2375: l_actual_effort jtf_number_table;
2376: l_actual_effort_uom jtf_varchar2_table_100;
2377: l_planned_effort jtf_number_table;

Line 2374: l_actual_end_date jtf_date_table;

2370: l_status_id jtf_number_table;
2371: l_planned_start_date jtf_date_table;
2372: l_planned_end_date jtf_date_table;
2373: l_actual_start_date jtf_date_table;
2374: l_actual_end_date jtf_date_table;
2375: l_actual_effort jtf_number_table;
2376: l_actual_effort_uom jtf_varchar2_table_100;
2377: l_planned_effort jtf_number_table;
2378: l_planned_effort_uom jtf_varchar2_table_100;

Line 2380: l_scheduled_start_date jtf_date_table;

2376: l_actual_effort_uom jtf_varchar2_table_100;
2377: l_planned_effort jtf_number_table;
2378: l_planned_effort_uom jtf_varchar2_table_100;
2379: l_escalated_task jtf_varchar2_table_100;
2380: l_scheduled_start_date jtf_date_table;
2381: l_scheduled_end_date jtf_date_table;
2382: ---------------------------------------------------
2383: --The below variables are used in color coding proc
2384: ---------------------------------------------------

Line 2381: l_scheduled_end_date jtf_date_table;

2377: l_planned_effort jtf_number_table;
2378: l_planned_effort_uom jtf_varchar2_table_100;
2379: l_escalated_task jtf_varchar2_table_100;
2380: l_scheduled_start_date jtf_date_table;
2381: l_scheduled_end_date jtf_date_table;
2382: ---------------------------------------------------
2383: --The below variables are used in color coding proc
2384: ---------------------------------------------------
2385: p_cur_task_type_id NUMBER(10);

Line 2889: p_shift_start_date :=jtf_date_table();

2885: --------------------------------------
2886: --Tables for getting shift information
2887: --------------------------------------
2888: p_trip_id :=jtf_number_table();
2889: p_shift_start_date :=jtf_date_table();
2890: p_shift_end_date :=jtf_date_table();
2891: p_block_trip :=jtf_number_table();
2892: p_shift_res_key :=jtf_varchar2_table_2000();
2893: ----------------------------------------------------------

Line 2890: p_shift_end_date :=jtf_date_table();

2886: --Tables for getting shift information
2887: --------------------------------------
2888: p_trip_id :=jtf_number_table();
2889: p_shift_start_date :=jtf_date_table();
2890: p_shift_end_date :=jtf_date_table();
2891: p_block_trip :=jtf_number_table();
2892: p_shift_res_key :=jtf_varchar2_table_2000();
2893: ----------------------------------------------------------
2894: --tables used for getting virtual task information

Line 2897: p_vir_start_date := jtf_date_table();

2893: ----------------------------------------------------------
2894: --tables used for getting virtual task information
2895: ----------------------------------------------------------
2896: p_vir_task_id := jtf_varchar2_table_100() ;
2897: p_vir_start_date := jtf_date_table();
2898: p_vir_end_date := jtf_date_table();
2899: p_vir_color := jtf_number_table();
2900: p_vir_name := jtf_varchar2_table_100();
2901: p_vir_duration := jtf_number_table();

Line 2898: p_vir_end_date := jtf_date_table();

2894: --tables used for getting virtual task information
2895: ----------------------------------------------------------
2896: p_vir_task_id := jtf_varchar2_table_100() ;
2897: p_vir_start_date := jtf_date_table();
2898: p_vir_end_date := jtf_date_table();
2899: p_vir_color := jtf_number_table();
2900: p_vir_name := jtf_varchar2_table_100();
2901: p_vir_duration := jtf_number_table();
2902: p_vir_task_type_id := jtf_number_table();

Line 2909: l_planned_start_date := jtf_date_table();

2905:
2906: l_assignment_id := jtf_number_table();
2907: l_task_priority_id := jtf_number_table();
2908: l_status_id := jtf_number_table();
2909: l_planned_start_date := jtf_date_table();
2910: l_planned_end_date := jtf_date_table();
2911: l_actual_start_date := jtf_date_table();
2912: l_actual_end_date := jtf_date_table();
2913: l_actual_effort := jtf_number_table();

Line 2910: l_planned_end_date := jtf_date_table();

2906: l_assignment_id := jtf_number_table();
2907: l_task_priority_id := jtf_number_table();
2908: l_status_id := jtf_number_table();
2909: l_planned_start_date := jtf_date_table();
2910: l_planned_end_date := jtf_date_table();
2911: l_actual_start_date := jtf_date_table();
2912: l_actual_end_date := jtf_date_table();
2913: l_actual_effort := jtf_number_table();
2914: l_actual_effort_uom := jtf_varchar2_table_100();

Line 2911: l_actual_start_date := jtf_date_table();

2907: l_task_priority_id := jtf_number_table();
2908: l_status_id := jtf_number_table();
2909: l_planned_start_date := jtf_date_table();
2910: l_planned_end_date := jtf_date_table();
2911: l_actual_start_date := jtf_date_table();
2912: l_actual_end_date := jtf_date_table();
2913: l_actual_effort := jtf_number_table();
2914: l_actual_effort_uom := jtf_varchar2_table_100();
2915: l_planned_effort := jtf_number_table();

Line 2912: l_actual_end_date := jtf_date_table();

2908: l_status_id := jtf_number_table();
2909: l_planned_start_date := jtf_date_table();
2910: l_planned_end_date := jtf_date_table();
2911: l_actual_start_date := jtf_date_table();
2912: l_actual_end_date := jtf_date_table();
2913: l_actual_effort := jtf_number_table();
2914: l_actual_effort_uom := jtf_varchar2_table_100();
2915: l_planned_effort := jtf_number_table();
2916: l_planned_effort_uom := jtf_varchar2_table_100();

Line 2918: l_scheduled_start_date := jtf_date_table();

2914: l_actual_effort_uom := jtf_varchar2_table_100();
2915: l_planned_effort := jtf_number_table();
2916: l_planned_effort_uom := jtf_varchar2_table_100();
2917: l_escalated_task := jtf_varchar2_table_100();
2918: l_scheduled_start_date := jtf_date_table();
2919: l_scheduled_end_date := jtf_date_table();
2920: -------------------------------------------------------
2921: --tables used for getting real task information
2922: -------------------------------------------------------

Line 2919: l_scheduled_end_date := jtf_date_table();

2915: l_planned_effort := jtf_number_table();
2916: l_planned_effort_uom := jtf_varchar2_table_100();
2917: l_escalated_task := jtf_varchar2_table_100();
2918: l_scheduled_start_date := jtf_date_table();
2919: l_scheduled_end_date := jtf_date_table();
2920: -------------------------------------------------------
2921: --tables used for getting real task information
2922: -------------------------------------------------------
2923: real_task_id := jtf_varchar2_table_100();

Line 2924: real_start_date := jtf_date_table();

2920: -------------------------------------------------------
2921: --tables used for getting real task information
2922: -------------------------------------------------------
2923: real_task_id := jtf_varchar2_table_100();
2924: real_start_date := jtf_date_table();
2925: real_end_date := jtf_date_table();
2926: real_color := jtf_number_table();
2927: real_name := jtf_varchar2_table_2000();
2928: real_tooltip := jtf_varchar2_table_2000();

Line 2925: real_end_date := jtf_date_table();

2921: --tables used for getting real task information
2922: -------------------------------------------------------
2923: real_task_id := jtf_varchar2_table_100();
2924: real_start_date := jtf_date_table();
2925: real_end_date := jtf_date_table();
2926: real_color := jtf_number_table();
2927: real_name := jtf_varchar2_table_2000();
2928: real_tooltip := jtf_varchar2_table_2000();
2929: real_duration := jtf_number_table();

Line 3619: , start_date OUT NOCOPY jtf_date_table

3615: , p_end_date IN DATE
3616: , sch_adv_tz IN Varchar2
3617: , inc_tz_code IN Varchar2
3618: , trip_id OUT NOCOPY jtf_number_table
3619: , start_date OUT NOCOPY jtf_date_table
3620: , end_date OUT NOCOPY jtf_date_table
3621: , block_trip OUT NOCOPY jtf_number_table
3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100

Line 3620: , end_date OUT NOCOPY jtf_date_table

3616: , sch_adv_tz IN Varchar2
3617: , inc_tz_code IN Varchar2
3618: , trip_id OUT NOCOPY jtf_number_table
3619: , start_date OUT NOCOPY jtf_date_table
3620: , end_date OUT NOCOPY jtf_date_table
3621: , block_trip OUT NOCOPY jtf_number_table
3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
3624: , plan_start_date OUT NOCOPY jtf_date_table

Line 3624: , plan_start_date OUT NOCOPY jtf_date_table

3620: , end_date OUT NOCOPY jtf_date_table
3621: , block_trip OUT NOCOPY jtf_number_table
3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
3624: , plan_start_date OUT NOCOPY jtf_date_table
3625: , plan_end_date OUT NOCOPY jtf_date_table
3626: , plan_color OUT NOCOPY jtf_number_table
3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000
3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 3625: , plan_end_date OUT NOCOPY jtf_date_table

3621: , block_trip OUT NOCOPY jtf_number_table
3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
3624: , plan_start_date OUT NOCOPY jtf_date_table
3625: , plan_end_date OUT NOCOPY jtf_date_table
3626: , plan_color OUT NOCOPY jtf_number_table
3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000
3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
3629: , plan_duration OUT NOCOPY jtf_number_table

Line 3633: , real_start_date OUT NOCOPY jtf_date_table

3629: , plan_duration OUT NOCOPY jtf_number_table
3630: , plan_task_type_id OUT NOCOPY jtf_number_table
3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100
3633: , real_start_date OUT NOCOPY jtf_date_table
3634: , real_end_date OUT NOCOPY jtf_date_table
3635: , real_color OUT NOCOPY jtf_number_table
3636: , real_name OUT NOCOPY jtf_varchar2_table_2000
3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 3634: , real_end_date OUT NOCOPY jtf_date_table

3630: , plan_task_type_id OUT NOCOPY jtf_number_table
3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100
3633: , real_start_date OUT NOCOPY jtf_date_table
3634: , real_end_date OUT NOCOPY jtf_date_table
3635: , real_color OUT NOCOPY jtf_number_table
3636: , real_name OUT NOCOPY jtf_varchar2_table_2000
3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
3638: , real_duration OUT NOCOPY jtf_number_table

Line 3648: , oth_real_start_date OUT Nocopy jtf_date_table

3644: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
3645: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3646: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
3647: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
3648: , oth_real_start_date OUT Nocopy jtf_date_table
3649: , oth_real_end_date OUT Nocopy jtf_date_table
3650: , oth_real_color OUT Nocopy jtf_number_table
3651: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000
3652: , oth_real_Duration OUT Nocopy jtf_number_table

Line 3649: , oth_real_end_date OUT Nocopy jtf_date_table

3645: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3646: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
3647: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
3648: , oth_real_start_date OUT Nocopy jtf_date_table
3649: , oth_real_end_date OUT Nocopy jtf_date_table
3650: , oth_real_color OUT Nocopy jtf_number_table
3651: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000
3652: , oth_real_Duration OUT Nocopy jtf_number_table
3653: , oth_real_task_type_id OUT Nocopy jtf_number_table

Line 3694: l_planned_start_date jtf_date_table;

3690: l_task_priority_id jtf_number_table;
3691: l_assignment_status_id jtf_number_table;
3692: l_escalated_task jtf_varchar2_table_100;
3693:
3694: l_planned_start_date jtf_date_table;
3695: l_planned_end_date jtf_date_table;
3696: l_actual_start_date jtf_date_table;
3697: l_actual_end_date jtf_date_table;
3698: l_actual_effort jtf_number_table;

Line 3695: l_planned_end_date jtf_date_table;

3691: l_assignment_status_id jtf_number_table;
3692: l_escalated_task jtf_varchar2_table_100;
3693:
3694: l_planned_start_date jtf_date_table;
3695: l_planned_end_date jtf_date_table;
3696: l_actual_start_date jtf_date_table;
3697: l_actual_end_date jtf_date_table;
3698: l_actual_effort jtf_number_table;
3699: l_actual_effort_uom jtf_varchar2_table_100;

Line 3696: l_actual_start_date jtf_date_table;

3692: l_escalated_task jtf_varchar2_table_100;
3693:
3694: l_planned_start_date jtf_date_table;
3695: l_planned_end_date jtf_date_table;
3696: l_actual_start_date jtf_date_table;
3697: l_actual_end_date jtf_date_table;
3698: l_actual_effort jtf_number_table;
3699: l_actual_effort_uom jtf_varchar2_table_100;
3700: l_planned_effort jtf_number_table;

Line 3697: l_actual_end_date jtf_date_table;

3693:
3694: l_planned_start_date jtf_date_table;
3695: l_planned_end_date jtf_date_table;
3696: l_actual_start_date jtf_date_table;
3697: l_actual_end_date jtf_date_table;
3698: l_actual_effort jtf_number_table;
3699: l_actual_effort_uom jtf_varchar2_table_100;
3700: l_planned_effort jtf_number_table;
3701: l_planned_effort_uom jtf_varchar2_table_100;

Line 4398: start_date := jtf_date_table();

4394: p_res_key := jtf_varchar2_table_2000();
4395: p_cost := jtf_number_table();
4396:
4397: trip_id := jtf_number_table();
4398: start_date := jtf_date_table();
4399: end_date := jtf_date_table();
4400: block_trip := jtf_number_table();
4401: tmp_trip_id := jtf_number_table();
4402: p_bck_res_key := jtf_varchar2_table_2000();

Line 4399: end_date := jtf_date_table();

4395: p_cost := jtf_number_table();
4396:
4397: trip_id := jtf_number_table();
4398: start_date := jtf_date_table();
4399: end_date := jtf_date_table();
4400: block_trip := jtf_number_table();
4401: tmp_trip_id := jtf_number_table();
4402: p_bck_res_key := jtf_varchar2_table_2000();
4403:

Line 4408: plan_start_date := jtf_date_table();

4404: ---------------------------------------------------------
4405: --tables used for getting real/to be plan task parameters
4406: ---------------------------------------------------------
4407: plan_task_key := jtf_varchar2_table_100();
4408: plan_start_date := jtf_date_table();
4409: plan_end_date := jtf_date_table();
4410: plan_color := jtf_number_table();
4411: plan_name := jtf_varchar2_table_2000();
4412: plan_tooltip := jtf_varchar2_table_2000();

Line 4409: plan_end_date := jtf_date_table();

4405: --tables used for getting real/to be plan task parameters
4406: ---------------------------------------------------------
4407: plan_task_key := jtf_varchar2_table_100();
4408: plan_start_date := jtf_date_table();
4409: plan_end_date := jtf_date_table();
4410: plan_color := jtf_number_table();
4411: plan_name := jtf_varchar2_table_2000();
4412: plan_tooltip := jtf_varchar2_table_2000();
4413: plan_duration := jtf_number_table();

Line 4417: real_start_date := jtf_date_table();

4413: plan_duration := jtf_number_table();
4414: plan_task_type_id := jtf_number_table();
4415: plan_resource_key := jtf_varchar2_table_2000();
4416: real_task_key := jtf_varchar2_table_100();
4417: real_start_date := jtf_date_table();
4418: real_end_date := jtf_date_table();
4419: real_color := jtf_number_table();
4420: real_name := jtf_varchar2_table_2000();
4421: real_tooltip := jtf_varchar2_table_2000();

Line 4418: real_end_date := jtf_date_table();

4414: plan_task_type_id := jtf_number_table();
4415: plan_resource_key := jtf_varchar2_table_2000();
4416: real_task_key := jtf_varchar2_table_100();
4417: real_start_date := jtf_date_table();
4418: real_end_date := jtf_date_table();
4419: real_color := jtf_number_table();
4420: real_name := jtf_varchar2_table_2000();
4421: real_tooltip := jtf_varchar2_table_2000();
4422: real_duration := jtf_number_table();

Line 4436: oth_real_start_date := jtf_date_table();

4432: l_assignment_status_id := jtf_number_table();
4433: l_escalated_task := jtf_varchar2_table_100();
4434:
4435: oth_real_task_id := jtf_varchar2_table_100();
4436: oth_real_start_date := jtf_date_table();
4437: oth_real_end_date := jtf_date_table();
4438: oth_real_color := jtf_number_table();
4439: oth_real_NAME := jtf_varchar2_table_2000();
4440: oth_real_tooltip := jtf_varchar2_table_2000();

Line 4437: oth_real_end_date := jtf_date_table();

4433: l_escalated_task := jtf_varchar2_table_100();
4434:
4435: oth_real_task_id := jtf_varchar2_table_100();
4436: oth_real_start_date := jtf_date_table();
4437: oth_real_end_date := jtf_date_table();
4438: oth_real_color := jtf_number_table();
4439: oth_real_NAME := jtf_varchar2_table_2000();
4440: oth_real_tooltip := jtf_varchar2_table_2000();
4441: oth_real_DURATION := jtf_number_table();

Line 4451: l_planned_start_date := jtf_date_table();

4447: oth_real_after_hours := jtf_varchar2_table_100();
4448: oth_real_customer_conf := jtf_varchar2_table_100();
4449: oth_real_task_depend := jtf_varchar2_table_100();
4450:
4451: l_planned_start_date := jtf_date_table();
4452: l_planned_end_date := jtf_date_table();
4453: l_actual_start_date := jtf_date_table();
4454: l_actual_end_date := jtf_date_table();
4455: l_actual_effort := jtf_number_table();

Line 4452: l_planned_end_date := jtf_date_table();

4448: oth_real_customer_conf := jtf_varchar2_table_100();
4449: oth_real_task_depend := jtf_varchar2_table_100();
4450:
4451: l_planned_start_date := jtf_date_table();
4452: l_planned_end_date := jtf_date_table();
4453: l_actual_start_date := jtf_date_table();
4454: l_actual_end_date := jtf_date_table();
4455: l_actual_effort := jtf_number_table();
4456: l_actual_effort_uom := jtf_varchar2_table_100();

Line 4453: l_actual_start_date := jtf_date_table();

4449: oth_real_task_depend := jtf_varchar2_table_100();
4450:
4451: l_planned_start_date := jtf_date_table();
4452: l_planned_end_date := jtf_date_table();
4453: l_actual_start_date := jtf_date_table();
4454: l_actual_end_date := jtf_date_table();
4455: l_actual_effort := jtf_number_table();
4456: l_actual_effort_uom := jtf_varchar2_table_100();
4457: l_planned_effort := jtf_number_table();

Line 4454: l_actual_end_date := jtf_date_table();

4450:
4451: l_planned_start_date := jtf_date_table();
4452: l_planned_end_date := jtf_date_table();
4453: l_actual_start_date := jtf_date_table();
4454: l_actual_end_date := jtf_date_table();
4455: l_actual_effort := jtf_number_table();
4456: l_actual_effort_uom := jtf_varchar2_table_100();
4457: l_planned_effort := jtf_number_table();
4458: l_planned_effort_uom := jtf_varchar2_table_100();