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