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_NUMBER_TABLE

Line 1532: , color OUT NOCOPY jtf_number_table

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
1536: , task_type_id OUT NOCOPY jtf_number_table

Line 1535: , DURATION OUT NOCOPY jtf_number_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
1536: , task_type_id OUT NOCOPY jtf_number_table
1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000
1538: , sch_adv_tz In Varchar2
1539: ) IS

Line 1536: , task_type_id OUT NOCOPY jtf_number_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
1536: , task_type_id OUT NOCOPY jtf_number_table
1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000
1538: , sch_adv_tz In Varchar2
1539: ) IS
1540: l_rec tooltip_data_rec_type := NULL;

Line 1577: color := jtf_number_table();

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();
1581: task_type_id := jtf_number_table();

Line 1580: DURATION := jtf_number_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();
1581: task_type_id := jtf_number_table();
1582: resource_key := jtf_varchar2_table_2000();
1583:
1584: OPEN c_planned_task;

Line 1581: task_type_id := jtf_number_table();

1577: color := jtf_number_table();
1578: NAME := jtf_varchar2_table_100();
1579: tooltip := jtf_varchar2_table_2000();
1580: DURATION := jtf_number_table();
1581: task_type_id := jtf_number_table();
1582: resource_key := jtf_varchar2_table_2000();
1583:
1584: OPEN c_planned_task;
1585: FETCH c_planned_task

Line 2331: , p_res_id OUT NOCOPY jtf_number_table

2327: , x_msg_count OUT NOCOPY Number
2328: , x_msg_data OUT NOCOPY Varchar2
2329: , p_start_date_range IN DATE
2330: , p_end_date_range IN DATE
2331: , p_res_id OUT NOCOPY jtf_number_table
2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
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

Line 2336: , p_trip_id OUT NOCOPY jtf_number_table

2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
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

Line 2339: , p_block_trip OUT NOCOPY jtf_number_table

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
2343: , p_vir_end_date OUT NOCOPY jtf_date_table

Line 2344: , p_vir_color 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
2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 2346: , p_vir_duration OUT NOCOPY jtf_number_table

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
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

Line 2347: , p_vir_task_type_id OUT NOCOPY jtf_number_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
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

Line 2353: , real_color OUT NOCOPY jtf_number_table

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
2357: , real_task_type_id OUT NOCOPY jtf_number_table

Line 2356: , real_DURATION OUT NOCOPY jtf_number_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
2357: , real_task_type_id OUT NOCOPY jtf_number_table
2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
2359: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
2360: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

Line 2357: , real_task_type_id OUT NOCOPY jtf_number_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
2357: , real_task_type_id OUT NOCOPY jtf_number_table
2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
2359: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
2360: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
2361: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 2368: l_assignment_id jtf_number_table;

2364: , real_child_task OUT NOCOPY jtf_varchar2_table_100
2365: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
2366: )
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;

Line 2369: l_task_priority_id jtf_number_table;

2365: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
2366: )
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;

Line 2370: l_status_id jtf_number_table;

2366: )
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;

Line 2375: l_actual_effort 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;
2379: l_escalated_task jtf_varchar2_table_100;

Line 2377: l_planned_effort jtf_number_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;
2379: l_escalated_task jtf_varchar2_table_100;
2380: l_scheduled_start_date jtf_date_table;
2381: l_scheduled_end_date jtf_date_table;

Line 2496: l_actual_travel_duration jtf_number_table;

2492: --------------------------------------------------------------------
2493: --all the variable and cursor used for getting real task information
2494: --------------------------------------------------------------------
2495: l_task_depends varchar2(1);
2496: l_actual_travel_duration jtf_number_table;
2497: l_actual_travel_duration_uom jtf_varchar2_table_100;
2498: l_task_depend jtf_varchar2_table_100;
2499: l_csf_default_effort NUMBER;
2500:

Line 2880: p_res_id :=jtf_number_table();

2876: END LOOP;
2877: RETURN 0;
2878: END do_match;
2879: BEGIN
2880: p_res_id :=jtf_number_table();
2881: p_res_type :=jtf_varchar2_table_2000();
2882: p_res_name :=jtf_varchar2_table_2000();
2883: p_res_typ_name :=jtf_varchar2_table_2000();
2884: p_res_key :=jtf_varchar2_table_2000();

Line 2888: p_trip_id :=jtf_number_table();

2884: p_res_key :=jtf_varchar2_table_2000();
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();

Line 2891: p_block_trip :=jtf_number_table();

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
2895: ----------------------------------------------------------

Line 2899: p_vir_color := jtf_number_table();

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();
2903: p_vir_tooltip := jtf_varchar2_table_2000();

Line 2901: p_vir_duration := jtf_number_table();

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();
2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
2905:

Line 2902: p_vir_task_type_id := jtf_number_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();
2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
2905:
2906: l_assignment_id := jtf_number_table();

Line 2906: l_assignment_id := jtf_number_table();

2902: p_vir_task_type_id := jtf_number_table();
2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
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();

Line 2907: l_task_priority_id := jtf_number_table();

2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
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();

Line 2908: l_status_id := jtf_number_table();

2904: p_vir_resource_key := jtf_varchar2_table_2000();
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();

Line 2913: l_actual_effort := 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();
2917: l_escalated_task := jtf_varchar2_table_100();

Line 2915: l_planned_effort := jtf_number_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();
2917: l_escalated_task := jtf_varchar2_table_100();
2918: l_scheduled_start_date := jtf_date_table();
2919: l_scheduled_end_date := jtf_date_table();

Line 2926: real_color := jtf_number_table();

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();
2930: real_task_type_id := jtf_number_table();

Line 2929: real_duration := jtf_number_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();
2930: real_task_type_id := jtf_number_table();
2931: real_resource_key := jtf_varchar2_table_2000();
2932: real_parts_required := jtf_varchar2_table_100();
2933: real_access_hours := jtf_varchar2_table_100();

Line 2930: real_task_type_id := jtf_number_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();
2930: real_task_type_id := jtf_number_table();
2931: real_resource_key := jtf_varchar2_table_2000();
2932: real_parts_required := jtf_varchar2_table_100();
2933: real_access_hours := jtf_varchar2_table_100();
2934: real_after_hours := jtf_varchar2_table_100();

Line 2939: l_actual_travel_duration := jtf_number_table();

2935: real_customer_conf := jtf_varchar2_table_100();
2936: real_task_depend := jtf_varchar2_table_100();
2937: real_child_task := jtf_varchar2_table_100();
2938:
2939: l_actual_travel_duration := jtf_number_table();
2940: l_actual_travel_duration_uom := jtf_varchar2_table_100();
2941: l_task_depend :=jtf_varchar2_table_100();
2942: --------------------------------------------------------------------------
2943: -- This was added because profile values were getting cached

Line 3608: , p_res_id OUT NOCOPY jtf_number_table

3604: , p_resource_type IN VARCHAR2
3605: , p_req_id IN NUMBER
3606: , p_par_task IN NUMBER
3607: , p_task_id IN NUMBER
3608: , p_res_id OUT NOCOPY jtf_number_table
3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 3613: , p_cost OUT NOCOPY jtf_number_table

3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
3613: , p_cost OUT NOCOPY jtf_number_table
3614: , p_start_date IN DATE
3615: , p_end_date IN DATE
3616: , sch_adv_tz IN Varchar2
3617: , inc_tz_code IN Varchar2

Line 3618: , trip_id OUT NOCOPY jtf_number_table

3614: , p_start_date IN DATE
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

Line 3621: , block_trip OUT NOCOPY jtf_number_table

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
3625: , plan_end_date OUT NOCOPY jtf_date_table

Line 3626: , plan_color 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
3630: , plan_task_type_id OUT NOCOPY jtf_number_table

Line 3629: , plan_duration OUT NOCOPY jtf_number_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
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

Line 3630: , plan_task_type_id OUT NOCOPY jtf_number_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
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

Line 3635: , real_color 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
3639: , real_task_type_id OUT NOCOPY jtf_number_table

Line 3638: , real_duration OUT NOCOPY jtf_number_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
3639: , real_task_type_id OUT NOCOPY jtf_number_table
3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
3641: , child_task OUT Nocopy jtf_varchar2_table_100
3642: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

Line 3639: , real_task_type_id OUT NOCOPY jtf_number_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
3639: , real_task_type_id OUT NOCOPY jtf_number_table
3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
3641: , child_task OUT Nocopy jtf_varchar2_table_100
3642: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
3643: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

Line 3650: , oth_real_color OUT Nocopy jtf_number_table

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
3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000

Line 3652: , oth_real_Duration OUT Nocopy jtf_number_table

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
3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
3655: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
3656: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100

Line 3653: , oth_real_task_type_id OUT Nocopy jtf_number_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
3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
3655: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
3656: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
3657: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100

Line 3689: tmp_trip_id jtf_number_table;

3685:
3686: TYPE SchResType IS REF CURSOR;
3687: ResInfo SchResType;
3688:
3689: tmp_trip_id jtf_number_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:

Line 3690: l_task_priority_id jtf_number_table;

3686: TYPE SchResType IS REF CURSOR;
3687: ResInfo SchResType;
3688:
3689: tmp_trip_id jtf_number_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;

Line 3691: l_assignment_status_id jtf_number_table;

3687: ResInfo SchResType;
3688:
3689: tmp_trip_id jtf_number_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;

Line 3698: l_actual_effort jtf_number_table;

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;
3702: l_actual_travel_duration jtf_number_table;

Line 3700: l_planned_effort jtf_number_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;
3702: l_actual_travel_duration jtf_number_table;
3703: l_actual_travel_duration_uom jtf_varchar2_table_100;
3704: l_status_id jtf_number_table;

Line 3702: l_actual_travel_duration jtf_number_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;
3702: l_actual_travel_duration jtf_number_table;
3703: l_actual_travel_duration_uom jtf_varchar2_table_100;
3704: l_status_id jtf_number_table;
3705: l_csf_default_effort NUMBER;
3706: l_task_depends varchar2(1);

Line 3704: l_status_id jtf_number_table;

3700: l_planned_effort jtf_number_table;
3701: l_planned_effort_uom jtf_varchar2_table_100;
3702: l_actual_travel_duration jtf_number_table;
3703: l_actual_travel_duration_uom jtf_varchar2_table_100;
3704: l_status_id jtf_number_table;
3705: l_csf_default_effort NUMBER;
3706: l_task_depends varchar2(1);
3707: l_task_depend jtf_varchar2_table_100;
3708: oth_real_tooltip jtf_varchar2_table_2000;

Line 4390: p_res_id := jtf_number_table();

4386: RETURN 0;
4387: END do_match;
4388:
4389: BEGIN
4390: p_res_id := jtf_number_table();
4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
4394: p_res_key := jtf_varchar2_table_2000();

Line 4395: p_cost := jtf_number_table();

4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
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();

Line 4397: trip_id := jtf_number_table();

4393: p_res_typ_name := jtf_varchar2_table_2000();
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();

Line 4400: block_trip := 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:
4404: ---------------------------------------------------------

Line 4401: tmp_trip_id := jtf_number_table();

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:
4404: ---------------------------------------------------------
4405: --tables used for getting real/to be plan task parameters

Line 4410: plan_color := jtf_number_table();

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();
4414: plan_task_type_id := jtf_number_table();

Line 4413: plan_duration := jtf_number_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();
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();

Line 4414: plan_task_type_id := jtf_number_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();
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();

Line 4419: real_color := 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();
4423: real_task_type_id := jtf_number_table();

Line 4422: real_duration := jtf_number_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();
4423: real_task_type_id := jtf_number_table();
4424: real_resource_key := jtf_varchar2_table_2000();
4425: child_task := jtf_varchar2_table_100();
4426: real_parts_required := jtf_varchar2_table_100();

Line 4423: real_task_type_id := jtf_number_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();
4423: real_task_type_id := jtf_number_table();
4424: real_resource_key := jtf_varchar2_table_2000();
4425: child_task := jtf_varchar2_table_100();
4426: real_parts_required := jtf_varchar2_table_100();
4427: real_access_hours := jtf_varchar2_table_100();

Line 4431: l_task_priority_id := jtf_number_table();

4427: real_access_hours := jtf_varchar2_table_100();
4428: real_after_hours := jtf_varchar2_table_100();
4429: real_customer_conf := jtf_varchar2_table_100();
4430: real_task_depend := jtf_varchar2_table_100();
4431: l_task_priority_id := jtf_number_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();

Line 4432: l_assignment_status_id := jtf_number_table();

4428: real_after_hours := jtf_varchar2_table_100();
4429: real_customer_conf := jtf_varchar2_table_100();
4430: real_task_depend := jtf_varchar2_table_100();
4431: l_task_priority_id := jtf_number_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();

Line 4438: oth_real_color := jtf_number_table();

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();
4442: oth_real_task_type_id := jtf_number_table();

Line 4441: oth_real_DURATION := jtf_number_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();
4442: oth_real_task_type_id := jtf_number_table();
4443: oth_real_resource_key := jtf_varchar2_table_2000();
4444: oth_real_child_task := jtf_varchar2_table_100();
4445: oth_real_parts_required := jtf_varchar2_table_100();

Line 4442: oth_real_task_type_id := jtf_number_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();
4442: oth_real_task_type_id := jtf_number_table();
4443: oth_real_resource_key := jtf_varchar2_table_2000();
4444: oth_real_child_task := jtf_varchar2_table_100();
4445: oth_real_parts_required := jtf_varchar2_table_100();
4446: oth_real_access_hours := jtf_varchar2_table_100();

Line 4455: l_actual_effort := jtf_number_table();

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();
4459: l_actual_travel_duration := jtf_number_table();

Line 4457: l_planned_effort := jtf_number_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();
4459: l_actual_travel_duration := jtf_number_table();
4460: l_actual_travel_duration_uom :=jtf_varchar2_table_100();
4461: l_status_id := jtf_number_table();

Line 4459: l_actual_travel_duration := jtf_number_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();
4459: l_actual_travel_duration := jtf_number_table();
4460: l_actual_travel_duration_uom :=jtf_varchar2_table_100();
4461: l_status_id := jtf_number_table();
4462:
4463: L_COMMON_WHERE_RESOURCE_SINGLE:= ' AND (NVL(PT.TASK_ID,0)= :4 OR NVL(PT.TASK_ID,0) = -1)';

Line 4461: l_status_id := jtf_number_table();

4457: l_planned_effort := jtf_number_table();
4458: l_planned_effort_uom := jtf_varchar2_table_100();
4459: l_actual_travel_duration := jtf_number_table();
4460: l_actual_travel_duration_uom :=jtf_varchar2_table_100();
4461: l_status_id := jtf_number_table();
4462:
4463: L_COMMON_WHERE_RESOURCE_SINGLE:= ' AND (NVL(PT.TASK_ID,0)= :4 OR NVL(PT.TASK_ID,0) = -1)';
4464: L_COMMON_WHERE_RESOURCE_QUERY := ' AND (NVL(PT.TASK_ID,0)= :2 OR NVL(PT.TASK_ID,0) = -1) ';
4465: L_COMMON_WHERE_PARENT := ' AND NVL(PT.TASK_ID,0) = -1 ';