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_VARCHAR2_TABLE_100

Line 1529: , task_id OUT NOCOPY jtf_varchar2_table_100

1525: , p_request_id IN VARCHAR2
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

Line 1533: , NAME OUT NOCOPY jtf_varchar2_table_100

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
1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 1574: task_id := jtf_varchar2_table_100();

1570: l_api_name CONSTANT VARCHAR2(30) := 'get_planned_task';
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();

Line 1578: NAME := jtf_varchar2_table_100();

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();
1582: resource_key := jtf_varchar2_table_2000();

Line 2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100

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
2344: , p_vir_color OUT NOCOPY jtf_number_table
2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

Line 2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

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
2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 2350: , real_task_id 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
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

Line 2359: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

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
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 2360: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

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
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
2364: , real_child_task OUT NOCOPY jtf_varchar2_table_100

Line 2361: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

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
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
2364: , real_child_task OUT NOCOPY jtf_varchar2_table_100
2365: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'

Line 2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

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

Line 2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

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
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
2364: , real_child_task OUT NOCOPY jtf_varchar2_table_100
2365: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
2366: )
2367: IS

Line 2364: , real_child_task 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
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
2363: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
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;

Line 2376: l_actual_effort_uom jtf_varchar2_table_100;

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;
2380: l_scheduled_start_date jtf_date_table;

Line 2378: l_planned_effort_uom jtf_varchar2_table_100;

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;
2382: ---------------------------------------------------

Line 2379: l_escalated_task jtf_varchar2_table_100;

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;
2382: ---------------------------------------------------
2383: --The below variables are used in color coding proc

Line 2497: l_actual_travel_duration_uom jtf_varchar2_table_100;

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:
2501: CURSOR c_icon_setup

Line 2498: l_task_depend jtf_varchar2_table_100;

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:
2501: CURSOR c_icon_setup
2502: IS

Line 2896: p_vir_task_id := jtf_varchar2_table_100() ;

2892: p_shift_res_key :=jtf_varchar2_table_2000();
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();

Line 2900: p_vir_name := jtf_varchar2_table_100();

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

Line 2914: l_actual_effort_uom := jtf_varchar2_table_100();

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();
2918: l_scheduled_start_date := jtf_date_table();

Line 2916: l_planned_effort_uom := jtf_varchar2_table_100();

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();
2920: -------------------------------------------------------

Line 2917: l_escalated_task := jtf_varchar2_table_100();

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();
2920: -------------------------------------------------------
2921: --tables used for getting real task information

Line 2923: real_task_id := jtf_varchar2_table_100();

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();
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();

Line 2932: real_parts_required := jtf_varchar2_table_100();

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();
2935: real_customer_conf := jtf_varchar2_table_100();
2936: real_task_depend := jtf_varchar2_table_100();

Line 2933: real_access_hours := jtf_varchar2_table_100();

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();
2935: real_customer_conf := jtf_varchar2_table_100();
2936: real_task_depend := jtf_varchar2_table_100();
2937: real_child_task := jtf_varchar2_table_100();

Line 2934: real_after_hours := jtf_varchar2_table_100();

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

Line 2935: real_customer_conf := jtf_varchar2_table_100();

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();
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();

Line 2936: real_task_depend := jtf_varchar2_table_100();

2932: real_parts_required := jtf_varchar2_table_100();
2933: real_access_hours := jtf_varchar2_table_100();
2934: real_after_hours := jtf_varchar2_table_100();
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();

Line 2937: real_child_task := jtf_varchar2_table_100();

2933: real_access_hours := jtf_varchar2_table_100();
2934: real_after_hours := jtf_varchar2_table_100();
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();

Line 2940: l_actual_travel_duration_uom := 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
2944: -- though we change profile values in application and re-login

Line 2941: l_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
2944: -- though we change profile values in application and re-login
2945: -- we were not able to see the changed effects.so decided to

Line 3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100

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
3626: , plan_color OUT NOCOPY jtf_number_table
3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000

Line 3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100

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
3635: , real_color OUT NOCOPY jtf_number_table
3636: , real_name OUT NOCOPY jtf_varchar2_table_2000

Line 3641: , child_task OUT Nocopy jtf_varchar2_table_100

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
3644: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
3645: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 3642: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

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

Line 3643: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

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

Line 3644: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

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

Line 3645: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

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

Line 3646: , real_task_depend 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
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

Line 3647: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100

3643: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
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

Line 3655: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100

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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 3656: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100

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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3660: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 3657: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100

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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3660: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
3661: )

Line 3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3660: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
3661: )
3662: IS

Line 3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3660: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
3661: )
3662: IS
3663: L_RESOURCE_QUERY VARCHAR2(4000);

Line 3660: , oth_real_task_depend 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
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
3659: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
3660: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
3661: )
3662: IS
3663: L_RESOURCE_QUERY VARCHAR2(4000);
3664: L_COMMON_WHERE_RESOURCE_QUERY VARCHAR2(4000);

Line 3692: l_escalated_task jtf_varchar2_table_100;

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;
3696: l_actual_start_date jtf_date_table;

Line 3699: l_actual_effort_uom jtf_varchar2_table_100;

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;
3703: l_actual_travel_duration_uom jtf_varchar2_table_100;

Line 3701: l_planned_effort_uom jtf_varchar2_table_100;

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;
3705: l_csf_default_effort NUMBER;

Line 3703: l_actual_travel_duration_uom jtf_varchar2_table_100;

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);
3707: l_task_depend jtf_varchar2_table_100;

Line 3707: l_task_depend jtf_varchar2_table_100;

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;
3709:
3710: CURSOR c_icon_setup
3711: IS

Line 4407: plan_task_key := jtf_varchar2_table_100();

4403:
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();

Line 4416: real_task_key := jtf_varchar2_table_100();

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();
4419: real_color := jtf_number_table();
4420: real_name := jtf_varchar2_table_2000();

Line 4425: child_task := jtf_varchar2_table_100();

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();
4428: real_after_hours := jtf_varchar2_table_100();
4429: real_customer_conf := jtf_varchar2_table_100();

Line 4426: real_parts_required := jtf_varchar2_table_100();

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

Line 4427: real_access_hours := jtf_varchar2_table_100();

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();
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();

Line 4428: real_after_hours := jtf_varchar2_table_100();

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();
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();

Line 4429: real_customer_conf := jtf_varchar2_table_100();

4425: child_task := jtf_varchar2_table_100();
4426: real_parts_required := jtf_varchar2_table_100();
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();

Line 4430: real_task_depend := jtf_varchar2_table_100();

4426: real_parts_required := jtf_varchar2_table_100();
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:

Line 4433: l_escalated_task := 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();
4437: oth_real_end_date := jtf_date_table();

Line 4435: oth_real_task_id := 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();
4437: oth_real_end_date := jtf_date_table();
4438: oth_real_color := jtf_number_table();
4439: oth_real_NAME := jtf_varchar2_table_2000();

Line 4444: oth_real_child_task := jtf_varchar2_table_100();

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();
4447: oth_real_after_hours := jtf_varchar2_table_100();
4448: oth_real_customer_conf := jtf_varchar2_table_100();

Line 4445: oth_real_parts_required := jtf_varchar2_table_100();

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();
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();

Line 4446: oth_real_access_hours := jtf_varchar2_table_100();

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

Line 4447: oth_real_after_hours := jtf_varchar2_table_100();

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();
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();

Line 4448: oth_real_customer_conf := jtf_varchar2_table_100();

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();
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();

Line 4449: oth_real_task_depend := jtf_varchar2_table_100();

4445: oth_real_parts_required := jtf_varchar2_table_100();
4446: oth_real_access_hours := jtf_varchar2_table_100();
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();

Line 4456: l_actual_effort_uom := jtf_varchar2_table_100();

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();
4460: l_actual_travel_duration_uom :=jtf_varchar2_table_100();

Line 4458: l_planned_effort_uom := jtf_varchar2_table_100();

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();
4462:

Line 4460: l_actual_travel_duration_uom :=jtf_varchar2_table_100();

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)';
4464: L_COMMON_WHERE_RESOURCE_QUERY := ' AND (NVL(PT.TASK_ID,0)= :2 OR NVL(PT.TASK_ID,0) = -1) ';