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 4038: , task_id OUT NOCOPY jtf_varchar2_table_100

4034: , p_request_id IN VARCHAR2
4035: , x_return_status OUT NOCOPY VARCHAR2
4036: , x_msg_count OUT NOCOPY NUMBER
4037: , x_msg_data OUT NOCOPY VARCHAR2
4038: , task_id OUT NOCOPY jtf_varchar2_table_100
4039: , start_date OUT NOCOPY jtf_date_table
4040: , end_date OUT NOCOPY jtf_date_table
4041: , color OUT NOCOPY jtf_number_table
4042: , NAME OUT NOCOPY jtf_varchar2_table_100

Line 4042: , NAME OUT NOCOPY jtf_varchar2_table_100

4038: , task_id OUT NOCOPY jtf_varchar2_table_100
4039: , start_date OUT NOCOPY jtf_date_table
4040: , end_date OUT NOCOPY jtf_date_table
4041: , color OUT NOCOPY jtf_number_table
4042: , NAME OUT NOCOPY jtf_varchar2_table_100
4043: , tooltip OUT NOCOPY jtf_varchar2_table_2000
4044: , DURATION OUT NOCOPY jtf_number_table
4045: , task_type_id OUT NOCOPY jtf_number_table
4046: , resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 4083: task_id := jtf_varchar2_table_100();

4079: l_api_name CONSTANT VARCHAR2(30) := 'get_planned_task';
4080: l_return_status VARCHAR2(1);
4081:
4082: BEGIN
4083: task_id := jtf_varchar2_table_100();
4084: start_date := jtf_date_table();
4085: end_date := jtf_date_table();
4086: color := jtf_number_table();
4087: NAME := jtf_varchar2_table_100();

Line 4087: NAME := jtf_varchar2_table_100();

4083: task_id := jtf_varchar2_table_100();
4084: start_date := jtf_date_table();
4085: end_date := jtf_date_table();
4086: color := jtf_number_table();
4087: NAME := jtf_varchar2_table_100();
4088: tooltip := jtf_varchar2_table_2000();
4089: DURATION := jtf_number_table();
4090: task_type_id := jtf_number_table();
4091: resource_key := jtf_varchar2_table_2000();

Line 5005: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100

5001: , p_shift_start_date OUT NOCOPY jtf_date_table
5002: , p_shift_end_date OUT NOCOPY jtf_date_table
5003: , p_block_trip OUT NOCOPY jtf_number_table
5004: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
5005: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
5006: , p_vir_start_date OUT NOCOPY jtf_date_table
5007: , p_vir_end_date OUT NOCOPY jtf_date_table
5008: , p_vir_color OUT NOCOPY jtf_number_table
5009: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

Line 5009: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

5005: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
5006: , p_vir_start_date OUT NOCOPY jtf_date_table
5007: , p_vir_end_date OUT NOCOPY jtf_date_table
5008: , p_vir_color OUT NOCOPY jtf_number_table
5009: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
5010: , p_vir_duration OUT NOCOPY jtf_number_table
5011: , p_vir_task_type_id OUT NOCOPY jtf_number_table
5012: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
5013: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 5014: , real_task_id OUT NOCOPY jtf_varchar2_table_100

5010: , p_vir_duration OUT NOCOPY jtf_number_table
5011: , p_vir_task_type_id OUT NOCOPY jtf_number_table
5012: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
5013: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
5014: , real_task_id OUT NOCOPY jtf_varchar2_table_100
5015: , real_start_date OUT NOCOPY jtf_date_table
5016: , real_end_date OUT NOCOPY jtf_date_table
5017: , real_color OUT NOCOPY jtf_number_table
5018: , real_NAME OUT NOCOPY jtf_varchar2_table_2000

Line 5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

5019: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
5020: , real_DURATION OUT NOCOPY jtf_number_table
5021: , real_task_type_id OUT NOCOPY jtf_number_table
5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

5020: , real_DURATION OUT NOCOPY jtf_number_table
5021: , real_task_type_id OUT NOCOPY jtf_number_table
5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100

Line 5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

5021: , real_task_type_id OUT NOCOPY jtf_number_table
5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100
5029: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

Line 5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100
5029: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
5030: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'

Line 5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100
5029: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
5030: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
5031: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000

Line 5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100

5024: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
5025: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
5027: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
5028: , real_child_task OUT NOCOPY jtf_varchar2_table_100
5029: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
5030: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
5031: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000
5032: , p_contact OUT NOCOPY jtf_varchar2_table_2000

Line 5043: l_actual_effort_uom jtf_varchar2_table_100;

5039: l_planned_end_date jtf_date_table;
5040: l_actual_start_date jtf_date_table;
5041: l_actual_end_date jtf_date_table;
5042: l_actual_effort jtf_number_table;
5043: l_actual_effort_uom jtf_varchar2_table_100;
5044: l_planned_effort jtf_number_table;
5045: l_planned_effort_uom jtf_varchar2_table_100;
5046: l_escalated_task jtf_varchar2_table_100;
5047: l_scheduled_start_date jtf_date_table;

Line 5045: l_planned_effort_uom jtf_varchar2_table_100;

5041: l_actual_end_date jtf_date_table;
5042: l_actual_effort jtf_number_table;
5043: l_actual_effort_uom jtf_varchar2_table_100;
5044: l_planned_effort jtf_number_table;
5045: l_planned_effort_uom jtf_varchar2_table_100;
5046: l_escalated_task jtf_varchar2_table_100;
5047: l_scheduled_start_date jtf_date_table;
5048: l_scheduled_end_date jtf_date_table;
5049: l_availability_type jtf_varchar2_table_100;

Line 5046: l_escalated_task jtf_varchar2_table_100;

5042: l_actual_effort jtf_number_table;
5043: l_actual_effort_uom jtf_varchar2_table_100;
5044: l_planned_effort jtf_number_table;
5045: l_planned_effort_uom jtf_varchar2_table_100;
5046: l_escalated_task jtf_varchar2_table_100;
5047: l_scheduled_start_date jtf_date_table;
5048: l_scheduled_end_date jtf_date_table;
5049: l_availability_type jtf_varchar2_table_100;
5050:

Line 5049: l_availability_type jtf_varchar2_table_100;

5045: l_planned_effort_uom jtf_varchar2_table_100;
5046: l_escalated_task jtf_varchar2_table_100;
5047: l_scheduled_start_date jtf_date_table;
5048: l_scheduled_end_date jtf_date_table;
5049: l_availability_type jtf_varchar2_table_100;
5050:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;

Line 5051: l_task_customer_name jtf_varchar2_table_1000;

5047: l_scheduled_start_date jtf_date_table;
5048: l_scheduled_end_date jtf_date_table;
5049: l_availability_type jtf_varchar2_table_100;
5050:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;

Line 5052: l_task_number jtf_varchar2_table_100;

5048: l_scheduled_end_date jtf_date_table;
5049: l_availability_type jtf_varchar2_table_100;
5050:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;

Line 5053: l_Task_Name jtf_varchar2_table_1000;

5049: l_availability_type jtf_varchar2_table_100;
5050:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;
5057: l_task_Postal_Code jtf_varchar2_table_1000;

Line 5054: l_Task_Priority_Name jtf_varchar2_table_1000;

5050:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;
5057: l_task_Postal_Code jtf_varchar2_table_1000;
5058: l_task_attr_list VARCHAR2(1000);

Line 5055: l_task_City_name jtf_varchar2_table_1000;

5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;
5057: l_task_Postal_Code jtf_varchar2_table_1000;
5058: l_task_attr_list VARCHAR2(1000);
5059: l_task_attr_list_tmp VARCHAR2(1000);

Line 5056: l_task_Site_Name jtf_varchar2_table_1000;

5052: l_task_number jtf_varchar2_table_100;
5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;
5057: l_task_Postal_Code jtf_varchar2_table_1000;
5058: l_task_attr_list VARCHAR2(1000);
5059: l_task_attr_list_tmp VARCHAR2(1000);
5060: ---------------------------------------------------

Line 5057: l_task_Postal_Code jtf_varchar2_table_1000;

5053: l_Task_Name jtf_varchar2_table_1000;
5054: l_Task_Priority_Name jtf_varchar2_table_1000;
5055: l_task_City_name jtf_varchar2_table_1000;
5056: l_task_Site_Name jtf_varchar2_table_1000;
5057: l_task_Postal_Code jtf_varchar2_table_1000;
5058: l_task_attr_list VARCHAR2(1000);
5059: l_task_attr_list_tmp VARCHAR2(1000);
5060: ---------------------------------------------------
5061: --The below variables are used in color coding proc

Line 5071: p_vir_avail_key jtf_varchar2_table_100;

5067: p_color NUMBER(30);
5068: p_cur_color NUMBER(30);
5069: p_rule_id NUMBER(10);
5070:
5071: p_vir_avail_key jtf_varchar2_table_100;
5072:
5073: l_shift_reg varchar2(1);
5074: l_shift_std varchar2(1);
5075: l_shift_type varchar2(10);

Line 5243: l_actual_travel_duration_uom jtf_varchar2_table_100;

5239: --all the variable and cursor used for getting real task information
5240: --------------------------------------------------------------------
5241: l_task_depends varchar2(1);
5242: l_actual_travel_duration jtf_number_table;
5243: l_actual_travel_duration_uom jtf_varchar2_table_100;
5244: l_task_depend jtf_varchar2_table_100;
5245: l_csf_default_effort NUMBER;
5246: l_real_sched_end_date DATE;
5247: l_real_sched_start_date DATE;

Line 5244: l_task_depend jtf_varchar2_table_100;

5240: --------------------------------------------------------------------
5241: l_task_depends varchar2(1);
5242: l_actual_travel_duration jtf_number_table;
5243: l_actual_travel_duration_uom jtf_varchar2_table_100;
5244: l_task_depend jtf_varchar2_table_100;
5245: l_csf_default_effort NUMBER;
5246: l_real_sched_end_date DATE;
5247: l_real_sched_start_date DATE;
5248: l_real_end_date DATE;

Line 5690: p_vir_avail_key := jtf_varchar2_table_100() ;

5686: p_shift_start_date :=jtf_date_table();
5687: p_shift_end_date :=jtf_date_table();
5688: p_block_trip :=jtf_number_table();
5689: p_shift_res_key :=jtf_varchar2_table_2000();
5690: p_vir_avail_key := jtf_varchar2_table_100() ;
5691: ----------------------------------------------------------
5692: --tables used for getting virtual task information
5693: ----------------------------------------------------------
5694: p_vir_task_id := jtf_varchar2_table_100() ;

Line 5694: p_vir_task_id := jtf_varchar2_table_100() ;

5690: p_vir_avail_key := jtf_varchar2_table_100() ;
5691: ----------------------------------------------------------
5692: --tables used for getting virtual task information
5693: ----------------------------------------------------------
5694: p_vir_task_id := jtf_varchar2_table_100() ;
5695: p_vir_start_date := jtf_date_table();
5696: p_vir_end_date := jtf_date_table();
5697: p_vir_color := jtf_number_table();
5698: p_vir_name := jtf_varchar2_table_100();

Line 5698: p_vir_name := jtf_varchar2_table_100();

5694: p_vir_task_id := jtf_varchar2_table_100() ;
5695: p_vir_start_date := jtf_date_table();
5696: p_vir_end_date := jtf_date_table();
5697: p_vir_color := jtf_number_table();
5698: p_vir_name := jtf_varchar2_table_100();
5699: p_vir_duration := jtf_number_table();
5700: p_vir_task_type_id := jtf_number_table();
5701: p_vir_tooltip := jtf_varchar2_table_2000();
5702: p_vir_resource_key := jtf_varchar2_table_2000();

Line 5713: l_actual_effort_uom := jtf_varchar2_table_100();

5709: l_planned_end_date := jtf_date_table();
5710: l_actual_start_date := jtf_date_table();
5711: l_actual_end_date := jtf_date_table();
5712: l_actual_effort := jtf_number_table();
5713: l_actual_effort_uom := jtf_varchar2_table_100();
5714: l_planned_effort := jtf_number_table();
5715: l_planned_effort_uom := jtf_varchar2_table_100();
5716: l_escalated_task := jtf_varchar2_table_100();
5717: l_scheduled_start_date := jtf_date_table();

Line 5715: l_planned_effort_uom := jtf_varchar2_table_100();

5711: l_actual_end_date := jtf_date_table();
5712: l_actual_effort := jtf_number_table();
5713: l_actual_effort_uom := jtf_varchar2_table_100();
5714: l_planned_effort := jtf_number_table();
5715: l_planned_effort_uom := jtf_varchar2_table_100();
5716: l_escalated_task := jtf_varchar2_table_100();
5717: l_scheduled_start_date := jtf_date_table();
5718: l_scheduled_end_date := jtf_date_table();
5719: l_availability_type := jtf_varchar2_table_100();

Line 5716: l_escalated_task := jtf_varchar2_table_100();

5712: l_actual_effort := jtf_number_table();
5713: l_actual_effort_uom := jtf_varchar2_table_100();
5714: l_planned_effort := jtf_number_table();
5715: l_planned_effort_uom := jtf_varchar2_table_100();
5716: l_escalated_task := jtf_varchar2_table_100();
5717: l_scheduled_start_date := jtf_date_table();
5718: l_scheduled_end_date := jtf_date_table();
5719: l_availability_type := jtf_varchar2_table_100();
5720: -------------------------------------------------------

Line 5719: l_availability_type := jtf_varchar2_table_100();

5715: l_planned_effort_uom := jtf_varchar2_table_100();
5716: l_escalated_task := jtf_varchar2_table_100();
5717: l_scheduled_start_date := jtf_date_table();
5718: l_scheduled_end_date := jtf_date_table();
5719: l_availability_type := jtf_varchar2_table_100();
5720: -------------------------------------------------------
5721: --Tables for getting taskbar label information
5722: -------------------------------------------------------
5723: l_task_customer_name := jtf_varchar2_table_1000();

Line 5723: l_task_customer_name := jtf_varchar2_table_1000();

5719: l_availability_type := jtf_varchar2_table_100();
5720: -------------------------------------------------------
5721: --Tables for getting taskbar label information
5722: -------------------------------------------------------
5723: l_task_customer_name := jtf_varchar2_table_1000();
5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();

Line 5724: l_task_number :=jtf_varchar2_table_100();

5720: -------------------------------------------------------
5721: --Tables for getting taskbar label information
5722: -------------------------------------------------------
5723: l_task_customer_name := jtf_varchar2_table_1000();
5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();

Line 5725: l_Task_Name :=jtf_varchar2_table_1000();

5721: --Tables for getting taskbar label information
5722: -------------------------------------------------------
5723: l_task_customer_name := jtf_varchar2_table_1000();
5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();
5729: l_task_Postal_Code :=jtf_varchar2_table_1000();

Line 5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();

5722: -------------------------------------------------------
5723: l_task_customer_name := jtf_varchar2_table_1000();
5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();
5729: l_task_Postal_Code :=jtf_varchar2_table_1000();
5730:

Line 5727: l_task_City_name :=jtf_varchar2_table_1000();

5723: l_task_customer_name := jtf_varchar2_table_1000();
5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();
5729: l_task_Postal_Code :=jtf_varchar2_table_1000();
5730:
5731: -------------------------------------------------------

Line 5728: l_task_Site_Name :=jtf_varchar2_table_1000();

5724: l_task_number :=jtf_varchar2_table_100();
5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();
5729: l_task_Postal_Code :=jtf_varchar2_table_1000();
5730:
5731: -------------------------------------------------------
5732: --tables used for getting real task information

Line 5729: l_task_Postal_Code :=jtf_varchar2_table_1000();

5725: l_Task_Name :=jtf_varchar2_table_1000();
5726: l_Task_Priority_Name :=jtf_varchar2_table_1000();
5727: l_task_City_name :=jtf_varchar2_table_1000();
5728: l_task_Site_Name :=jtf_varchar2_table_1000();
5729: l_task_Postal_Code :=jtf_varchar2_table_1000();
5730:
5731: -------------------------------------------------------
5732: --tables used for getting real task information
5733: -------------------------------------------------------

Line 5734: real_task_id := jtf_varchar2_table_100();

5730:
5731: -------------------------------------------------------
5732: --tables used for getting real task information
5733: -------------------------------------------------------
5734: real_task_id := jtf_varchar2_table_100();
5735: real_start_date := jtf_date_table();
5736: real_end_date := jtf_date_table();
5737: real_color := jtf_number_table();
5738: real_name := jtf_varchar2_table_2000();

Line 5743: real_parts_required := jtf_varchar2_table_100();

5739: real_tooltip := jtf_varchar2_table_2000();
5740: real_duration := jtf_number_table();
5741: real_task_type_id := jtf_number_table();
5742: real_resource_key := jtf_varchar2_table_2000();
5743: real_parts_required := jtf_varchar2_table_100();
5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();

Line 5744: real_access_hours := jtf_varchar2_table_100();

5740: real_duration := jtf_number_table();
5741: real_task_type_id := jtf_number_table();
5742: real_resource_key := jtf_varchar2_table_2000();
5743: real_parts_required := jtf_varchar2_table_100();
5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();

Line 5745: real_after_hours := jtf_varchar2_table_100();

5741: real_task_type_id := jtf_number_table();
5742: real_resource_key := jtf_varchar2_table_2000();
5743: real_parts_required := jtf_varchar2_table_100();
5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();
5749:

Line 5746: real_customer_conf := jtf_varchar2_table_100();

5742: real_resource_key := jtf_varchar2_table_2000();
5743: real_parts_required := jtf_varchar2_table_100();
5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();
5749:
5750: l_actual_travel_duration := jtf_number_table();

Line 5747: real_task_depend := jtf_varchar2_table_100();

5743: real_parts_required := jtf_varchar2_table_100();
5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();
5749:
5750: l_actual_travel_duration := jtf_number_table();
5751: l_actual_travel_duration_uom := jtf_varchar2_table_100();

Line 5748: real_child_task := jtf_varchar2_table_100();

5744: real_access_hours := jtf_varchar2_table_100();
5745: real_after_hours := jtf_varchar2_table_100();
5746: real_customer_conf := jtf_varchar2_table_100();
5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();
5749:
5750: l_actual_travel_duration := jtf_number_table();
5751: l_actual_travel_duration_uom := jtf_varchar2_table_100();
5752: l_task_depend :=jtf_varchar2_table_100();

Line 5751: l_actual_travel_duration_uom := jtf_varchar2_table_100();

5747: real_task_depend := jtf_varchar2_table_100();
5748: real_child_task := jtf_varchar2_table_100();
5749:
5750: l_actual_travel_duration := jtf_number_table();
5751: l_actual_travel_duration_uom := jtf_varchar2_table_100();
5752: l_task_depend :=jtf_varchar2_table_100();
5753: --------------------------------------------------------------------------
5754: -- This was added because profile values were getting cached
5755: -- though we change profile values in application and re-login

Line 5752: l_task_depend :=jtf_varchar2_table_100();

5748: real_child_task := jtf_varchar2_table_100();
5749:
5750: l_actual_travel_duration := jtf_number_table();
5751: l_actual_travel_duration_uom := jtf_varchar2_table_100();
5752: l_task_depend :=jtf_varchar2_table_100();
5753: --------------------------------------------------------------------------
5754: -- This was added because profile values were getting cached
5755: -- though we change profile values in application and re-login
5756: -- we were not able to see the changed effects.so decided to

Line 6590: , plan_task_key OUT NOCOPY jtf_varchar2_table_100

6586: , start_date OUT NOCOPY jtf_date_table
6587: , end_date OUT NOCOPY jtf_date_table
6588: , block_trip OUT NOCOPY jtf_number_table
6589: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
6590: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
6591: , plan_start_date OUT NOCOPY jtf_date_table
6592: , plan_end_date OUT NOCOPY jtf_date_table
6593: , plan_color OUT NOCOPY jtf_number_table
6594: , plan_name OUT NOCOPY jtf_varchar2_table_2000

Line 6599: , real_task_key OUT NOCOPY jtf_varchar2_table_100

6595: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
6596: , plan_duration OUT NOCOPY jtf_number_table
6597: , plan_task_type_id OUT NOCOPY jtf_number_table
6598: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
6599: , real_task_key OUT NOCOPY jtf_varchar2_table_100
6600: , real_start_date OUT NOCOPY jtf_date_table
6601: , real_end_date OUT NOCOPY jtf_date_table
6602: , real_color OUT NOCOPY jtf_number_table
6603: , real_name OUT NOCOPY jtf_varchar2_table_2000

Line 6608: , child_task OUT Nocopy jtf_varchar2_table_100

6604: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
6605: , real_duration OUT NOCOPY jtf_number_table
6606: , real_task_type_id OUT NOCOPY jtf_number_table
6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
6608: , child_task OUT Nocopy jtf_varchar2_table_100
6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

6605: , real_duration OUT NOCOPY jtf_number_table
6606: , real_task_type_id OUT NOCOPY jtf_number_table
6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
6608: , child_task OUT Nocopy jtf_varchar2_table_100
6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

6606: , real_task_type_id OUT NOCOPY jtf_number_table
6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
6608: , child_task OUT Nocopy jtf_varchar2_table_100
6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100

Line 6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
6608: , child_task OUT Nocopy jtf_varchar2_table_100
6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
6615: , oth_real_start_date OUT Nocopy jtf_date_table

Line 6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

6608: , child_task OUT Nocopy jtf_varchar2_table_100
6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
6615: , oth_real_start_date OUT Nocopy jtf_date_table
6616: , oth_real_end_date OUT Nocopy jtf_date_table

Line 6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

6609: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
6615: , oth_real_start_date OUT Nocopy jtf_date_table
6616: , oth_real_end_date OUT Nocopy jtf_date_table
6617: , oth_real_color OUT Nocopy jtf_number_table

Line 6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100

6610: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
6612: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6613: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
6614: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
6615: , oth_real_start_date OUT Nocopy jtf_date_table
6616: , oth_real_end_date OUT Nocopy jtf_date_table
6617: , oth_real_color OUT Nocopy jtf_number_table
6618: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000

Line 6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100

6618: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000
6619: , oth_real_Duration OUT Nocopy jtf_number_table
6620: , oth_real_task_type_id OUT Nocopy jtf_number_table
6621: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100

6619: , oth_real_Duration OUT Nocopy jtf_number_table
6620: , oth_real_task_type_id OUT Nocopy jtf_number_table
6621: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100

6620: , oth_real_task_type_id OUT Nocopy jtf_number_table
6621: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
6628: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

Line 6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

6621: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
6628: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
6629: )

Line 6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
6628: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
6629: )
6630: IS

Line 6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

6623: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
6624: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
6626: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
6627: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
6628: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
6629: )
6630: IS
6631: L_RESOURCE_QUERY VARCHAR2(4000);

Line 6660: l_escalated_task jtf_varchar2_table_100;

6656:
6657: tmp_trip_id jtf_number_table;
6658: l_task_priority_id jtf_number_table;
6659: l_assignment_status_id jtf_number_table;
6660: l_escalated_task jtf_varchar2_table_100;
6661:
6662: l_planned_start_date jtf_date_table;
6663: l_planned_end_date jtf_date_table;
6664: l_actual_start_date jtf_date_table;

Line 6667: l_actual_effort_uom jtf_varchar2_table_100;

6663: l_planned_end_date jtf_date_table;
6664: l_actual_start_date jtf_date_table;
6665: l_actual_end_date jtf_date_table;
6666: l_actual_effort jtf_number_table;
6667: l_actual_effort_uom jtf_varchar2_table_100;
6668: l_planned_effort jtf_number_table;
6669: l_planned_effort_uom jtf_varchar2_table_100;
6670: l_actual_travel_duration jtf_number_table;
6671: l_actual_travel_duration_uom jtf_varchar2_table_100;

Line 6669: l_planned_effort_uom jtf_varchar2_table_100;

6665: l_actual_end_date jtf_date_table;
6666: l_actual_effort jtf_number_table;
6667: l_actual_effort_uom jtf_varchar2_table_100;
6668: l_planned_effort jtf_number_table;
6669: l_planned_effort_uom jtf_varchar2_table_100;
6670: l_actual_travel_duration jtf_number_table;
6671: l_actual_travel_duration_uom jtf_varchar2_table_100;
6672: l_status_id jtf_number_table;
6673: l_csf_default_effort NUMBER;

Line 6671: l_actual_travel_duration_uom jtf_varchar2_table_100;

6667: l_actual_effort_uom jtf_varchar2_table_100;
6668: l_planned_effort jtf_number_table;
6669: l_planned_effort_uom jtf_varchar2_table_100;
6670: l_actual_travel_duration jtf_number_table;
6671: l_actual_travel_duration_uom jtf_varchar2_table_100;
6672: l_status_id jtf_number_table;
6673: l_csf_default_effort NUMBER;
6674: l_task_depends varchar2(1);
6675: l_task_depend jtf_varchar2_table_100;

Line 6675: l_task_depend jtf_varchar2_table_100;

6671: l_actual_travel_duration_uom jtf_varchar2_table_100;
6672: l_status_id jtf_number_table;
6673: l_csf_default_effort NUMBER;
6674: l_task_depends varchar2(1);
6675: l_task_depend jtf_varchar2_table_100;
6676: oth_real_tooltip jtf_varchar2_table_2000;
6677:
6678:
6679: l_task_customer_name jtf_varchar2_table_1000;

Line 6679: l_task_customer_name jtf_varchar2_table_1000;

6675: l_task_depend jtf_varchar2_table_100;
6676: oth_real_tooltip jtf_varchar2_table_2000;
6677:
6678:
6679: l_task_customer_name jtf_varchar2_table_1000;
6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;

Line 6680: l_task_number jtf_varchar2_table_100;

6676: oth_real_tooltip jtf_varchar2_table_2000;
6677:
6678:
6679: l_task_customer_name jtf_varchar2_table_1000;
6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;

Line 6681: l_Task_Name jtf_varchar2_table_1000;

6677:
6678:
6679: l_task_customer_name jtf_varchar2_table_1000;
6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;
6685: l_task_Postal_Code jtf_varchar2_table_1000;

Line 6682: l_Task_Priority_Name jtf_varchar2_table_1000;

6678:
6679: l_task_customer_name jtf_varchar2_table_1000;
6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;
6685: l_task_Postal_Code jtf_varchar2_table_1000;
6686: l_task_attr_list VARCHAR2(1000);

Line 6683: l_task_City_name jtf_varchar2_table_1000;

6679: l_task_customer_name jtf_varchar2_table_1000;
6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;
6685: l_task_Postal_Code jtf_varchar2_table_1000;
6686: l_task_attr_list VARCHAR2(1000);
6687: l_task_attr_list_tmp VARCHAR2(1000);

Line 6684: l_task_Site_Name jtf_varchar2_table_1000;

6680: l_task_number jtf_varchar2_table_100;
6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;
6685: l_task_Postal_Code jtf_varchar2_table_1000;
6686: l_task_attr_list VARCHAR2(1000);
6687: l_task_attr_list_tmp VARCHAR2(1000);
6688:

Line 6685: l_task_Postal_Code jtf_varchar2_table_1000;

6681: l_Task_Name jtf_varchar2_table_1000;
6682: l_Task_Priority_Name jtf_varchar2_table_1000;
6683: l_task_City_name jtf_varchar2_table_1000;
6684: l_task_Site_Name jtf_varchar2_table_1000;
6685: l_task_Postal_Code jtf_varchar2_table_1000;
6686: l_task_attr_list VARCHAR2(1000);
6687: l_task_attr_list_tmp VARCHAR2(1000);
6688:
6689:

Line 7486: plan_task_key := jtf_varchar2_table_100();

7482:
7483: ---------------------------------------------------------
7484: --tables used for getting real/to be plan task parameters
7485: ---------------------------------------------------------
7486: plan_task_key := jtf_varchar2_table_100();
7487: plan_start_date := jtf_date_table();
7488: plan_end_date := jtf_date_table();
7489: plan_color := jtf_number_table();
7490: plan_name := jtf_varchar2_table_2000();

Line 7495: real_task_key := jtf_varchar2_table_100();

7491: plan_tooltip := jtf_varchar2_table_2000();
7492: plan_duration := jtf_number_table();
7493: plan_task_type_id := jtf_number_table();
7494: plan_resource_key := jtf_varchar2_table_2000();
7495: real_task_key := jtf_varchar2_table_100();
7496: real_start_date := jtf_date_table();
7497: real_end_date := jtf_date_table();
7498: real_color := jtf_number_table();
7499: real_name := jtf_varchar2_table_2000();

Line 7504: child_task := jtf_varchar2_table_100();

7500: real_tooltip := jtf_varchar2_table_2000();
7501: real_duration := jtf_number_table();
7502: real_task_type_id := jtf_number_table();
7503: real_resource_key := jtf_varchar2_table_2000();
7504: child_task := jtf_varchar2_table_100();
7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();

Line 7505: real_parts_required := jtf_varchar2_table_100();

7501: real_duration := jtf_number_table();
7502: real_task_type_id := jtf_number_table();
7503: real_resource_key := jtf_varchar2_table_2000();
7504: child_task := jtf_varchar2_table_100();
7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();

Line 7506: real_access_hours := jtf_varchar2_table_100();

7502: real_task_type_id := jtf_number_table();
7503: real_resource_key := jtf_varchar2_table_2000();
7504: child_task := jtf_varchar2_table_100();
7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();
7510: l_task_priority_id := jtf_number_table();

Line 7507: real_after_hours := jtf_varchar2_table_100();

7503: real_resource_key := jtf_varchar2_table_2000();
7504: child_task := jtf_varchar2_table_100();
7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();
7510: l_task_priority_id := jtf_number_table();
7511: l_assignment_status_id := jtf_number_table();

Line 7508: real_customer_conf := jtf_varchar2_table_100();

7504: child_task := jtf_varchar2_table_100();
7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();
7510: l_task_priority_id := jtf_number_table();
7511: l_assignment_status_id := jtf_number_table();
7512: l_escalated_task := jtf_varchar2_table_100();

Line 7509: real_task_depend := jtf_varchar2_table_100();

7505: real_parts_required := jtf_varchar2_table_100();
7506: real_access_hours := jtf_varchar2_table_100();
7507: real_after_hours := jtf_varchar2_table_100();
7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();
7510: l_task_priority_id := jtf_number_table();
7511: l_assignment_status_id := jtf_number_table();
7512: l_escalated_task := jtf_varchar2_table_100();
7513:

Line 7512: l_escalated_task := jtf_varchar2_table_100();

7508: real_customer_conf := jtf_varchar2_table_100();
7509: real_task_depend := jtf_varchar2_table_100();
7510: l_task_priority_id := jtf_number_table();
7511: l_assignment_status_id := jtf_number_table();
7512: l_escalated_task := jtf_varchar2_table_100();
7513:
7514: oth_real_task_id := jtf_varchar2_table_100();
7515: oth_real_start_date := jtf_date_table();
7516: oth_real_end_date := jtf_date_table();

Line 7514: oth_real_task_id := jtf_varchar2_table_100();

7510: l_task_priority_id := jtf_number_table();
7511: l_assignment_status_id := jtf_number_table();
7512: l_escalated_task := jtf_varchar2_table_100();
7513:
7514: oth_real_task_id := jtf_varchar2_table_100();
7515: oth_real_start_date := jtf_date_table();
7516: oth_real_end_date := jtf_date_table();
7517: oth_real_color := jtf_number_table();
7518: oth_real_NAME := jtf_varchar2_table_2000();

Line 7523: oth_real_child_task := jtf_varchar2_table_100();

7519: oth_real_tooltip := jtf_varchar2_table_2000();
7520: oth_real_DURATION := jtf_number_table();
7521: oth_real_task_type_id := jtf_number_table();
7522: oth_real_resource_key := jtf_varchar2_table_2000();
7523: oth_real_child_task := jtf_varchar2_table_100();
7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();

Line 7524: oth_real_parts_required := jtf_varchar2_table_100();

7520: oth_real_DURATION := jtf_number_table();
7521: oth_real_task_type_id := jtf_number_table();
7522: oth_real_resource_key := jtf_varchar2_table_2000();
7523: oth_real_child_task := jtf_varchar2_table_100();
7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();
7528: oth_real_task_depend := jtf_varchar2_table_100();

Line 7525: oth_real_access_hours := jtf_varchar2_table_100();

7521: oth_real_task_type_id := jtf_number_table();
7522: oth_real_resource_key := jtf_varchar2_table_2000();
7523: oth_real_child_task := jtf_varchar2_table_100();
7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();
7528: oth_real_task_depend := jtf_varchar2_table_100();
7529:

Line 7526: oth_real_after_hours := jtf_varchar2_table_100();

7522: oth_real_resource_key := jtf_varchar2_table_2000();
7523: oth_real_child_task := jtf_varchar2_table_100();
7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();
7528: oth_real_task_depend := jtf_varchar2_table_100();
7529:
7530: p_vir_avail_type := jtf_varchar2_table_2000();

Line 7527: oth_real_customer_conf := jtf_varchar2_table_100();

7523: oth_real_child_task := jtf_varchar2_table_100();
7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();
7528: oth_real_task_depend := jtf_varchar2_table_100();
7529:
7530: p_vir_avail_type := jtf_varchar2_table_2000();
7531:

Line 7528: oth_real_task_depend := jtf_varchar2_table_100();

7524: oth_real_parts_required := jtf_varchar2_table_100();
7525: oth_real_access_hours := jtf_varchar2_table_100();
7526: oth_real_after_hours := jtf_varchar2_table_100();
7527: oth_real_customer_conf := jtf_varchar2_table_100();
7528: oth_real_task_depend := jtf_varchar2_table_100();
7529:
7530: p_vir_avail_type := jtf_varchar2_table_2000();
7531:
7532: l_planned_start_date := jtf_date_table();

Line 7537: l_actual_effort_uom := jtf_varchar2_table_100();

7533: l_planned_end_date := jtf_date_table();
7534: l_actual_start_date := jtf_date_table();
7535: l_actual_end_date := jtf_date_table();
7536: l_actual_effort := jtf_number_table();
7537: l_actual_effort_uom := jtf_varchar2_table_100();
7538: l_planned_effort := jtf_number_table();
7539: l_planned_effort_uom := jtf_varchar2_table_100();
7540: l_actual_travel_duration := jtf_number_table();
7541: l_actual_travel_duration_uom :=jtf_varchar2_table_100();

Line 7539: l_planned_effort_uom := jtf_varchar2_table_100();

7535: l_actual_end_date := jtf_date_table();
7536: l_actual_effort := jtf_number_table();
7537: l_actual_effort_uom := jtf_varchar2_table_100();
7538: l_planned_effort := jtf_number_table();
7539: l_planned_effort_uom := jtf_varchar2_table_100();
7540: l_actual_travel_duration := jtf_number_table();
7541: l_actual_travel_duration_uom :=jtf_varchar2_table_100();
7542: l_status_id := jtf_number_table();
7543:

Line 7541: l_actual_travel_duration_uom :=jtf_varchar2_table_100();

7537: l_actual_effort_uom := jtf_varchar2_table_100();
7538: l_planned_effort := jtf_number_table();
7539: l_planned_effort_uom := jtf_varchar2_table_100();
7540: l_actual_travel_duration := jtf_number_table();
7541: l_actual_travel_duration_uom :=jtf_varchar2_table_100();
7542: l_status_id := jtf_number_table();
7543:
7544: -------------------------------------------------------
7545: --Tables for getting taskbar label information

Line 7547: l_task_customer_name := jtf_varchar2_table_1000();

7543:
7544: -------------------------------------------------------
7545: --Tables for getting taskbar label information
7546: -------------------------------------------------------
7547: l_task_customer_name := jtf_varchar2_table_1000();
7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();

Line 7548: l_task_number :=jtf_varchar2_table_100();

7544: -------------------------------------------------------
7545: --Tables for getting taskbar label information
7546: -------------------------------------------------------
7547: l_task_customer_name := jtf_varchar2_table_1000();
7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();

Line 7549: l_Task_Name :=jtf_varchar2_table_1000();

7545: --Tables for getting taskbar label information
7546: -------------------------------------------------------
7547: l_task_customer_name := jtf_varchar2_table_1000();
7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();

Line 7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();

7546: -------------------------------------------------------
7547: l_task_customer_name := jtf_varchar2_table_1000();
7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:

Line 7551: l_task_City_name :=jtf_varchar2_table_1000();

7547: l_task_customer_name := jtf_varchar2_table_1000();
7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';

Line 7552: l_task_Site_Name :=jtf_varchar2_table_1000();

7548: l_task_number :=jtf_varchar2_table_100();
7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
7556: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);

Line 7553: l_task_Postal_Code :=jtf_varchar2_table_1000();

7549: l_Task_Name :=jtf_varchar2_table_1000();
7550: l_Task_Priority_Name :=jtf_varchar2_table_1000();
7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
7556: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
7557: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);