DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on JTF_DATE_TABLE

Line 4039: , start_date OUT NOCOPY jtf_date_table

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
4043: , tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 4040: , end_date OUT NOCOPY jtf_date_table

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
4043: , tooltip OUT NOCOPY jtf_varchar2_table_2000
4044: , DURATION OUT NOCOPY jtf_number_table

Line 4084: start_date := jtf_date_table();

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();
4088: tooltip := jtf_varchar2_table_2000();

Line 4085: end_date := jtf_date_table();

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();
4088: tooltip := jtf_varchar2_table_2000();
4089: DURATION := jtf_number_table();

Line 5001: , p_shift_start_date OUT NOCOPY jtf_date_table

4997: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
4998: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
4999: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
5000: , p_trip_id OUT NOCOPY jtf_number_table
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

Line 5002: , p_shift_end_date OUT NOCOPY jtf_date_table

4998: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
4999: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
5000: , p_trip_id OUT NOCOPY jtf_number_table
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

Line 5006: , p_vir_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
5010: , p_vir_duration OUT NOCOPY jtf_number_table

Line 5007: , p_vir_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
5010: , p_vir_duration OUT NOCOPY jtf_number_table
5011: , p_vir_task_type_id OUT NOCOPY jtf_number_table

Line 5015: , real_start_date OUT NOCOPY jtf_date_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
5019: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 5016: , real_end_date OUT NOCOPY jtf_date_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
5019: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
5020: , real_DURATION OUT NOCOPY jtf_number_table

Line 5038: l_planned_start_date jtf_date_table;

5034: IS
5035: l_assignment_id jtf_number_table;
5036: l_task_priority_id jtf_number_table;
5037: l_status_id jtf_number_table;
5038: l_planned_start_date jtf_date_table;
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;

Line 5039: l_planned_end_date jtf_date_table;

5035: l_assignment_id jtf_number_table;
5036: l_task_priority_id jtf_number_table;
5037: l_status_id jtf_number_table;
5038: l_planned_start_date jtf_date_table;
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;

Line 5040: l_actual_start_date jtf_date_table;

5036: l_task_priority_id jtf_number_table;
5037: l_status_id jtf_number_table;
5038: l_planned_start_date jtf_date_table;
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;

Line 5041: l_actual_end_date jtf_date_table;

5037: l_status_id jtf_number_table;
5038: l_planned_start_date jtf_date_table;
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;

Line 5047: l_scheduled_start_date jtf_date_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:
5051: l_task_customer_name jtf_varchar2_table_1000;

Line 5048: l_scheduled_end_date jtf_date_table;

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:
5051: l_task_customer_name jtf_varchar2_table_1000;
5052: l_task_number jtf_varchar2_table_100;

Line 5686: p_shift_start_date :=jtf_date_table();

5682: --------------------------------------
5683: --Tables for getting shift information
5684: --------------------------------------
5685: p_trip_id :=jtf_number_table();
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() ;

Line 5687: p_shift_end_date :=jtf_date_table();

5683: --Tables for getting shift information
5684: --------------------------------------
5685: p_trip_id :=jtf_number_table();
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: ----------------------------------------------------------

Line 5695: p_vir_start_date := jtf_date_table();

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();
5699: p_vir_duration := jtf_number_table();

Line 5696: p_vir_end_date := jtf_date_table();

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();
5699: p_vir_duration := jtf_number_table();
5700: p_vir_task_type_id := jtf_number_table();

Line 5708: l_planned_start_date := jtf_date_table();

5704:
5705: l_assignment_id := jtf_number_table();
5706: l_task_priority_id := jtf_number_table();
5707: l_status_id := jtf_number_table();
5708: l_planned_start_date := jtf_date_table();
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();

Line 5709: l_planned_end_date := jtf_date_table();

5705: l_assignment_id := jtf_number_table();
5706: l_task_priority_id := jtf_number_table();
5707: l_status_id := jtf_number_table();
5708: l_planned_start_date := jtf_date_table();
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();

Line 5710: l_actual_start_date := jtf_date_table();

5706: l_task_priority_id := jtf_number_table();
5707: l_status_id := jtf_number_table();
5708: l_planned_start_date := jtf_date_table();
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();

Line 5711: l_actual_end_date := jtf_date_table();

5707: l_status_id := jtf_number_table();
5708: l_planned_start_date := jtf_date_table();
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();

Line 5717: l_scheduled_start_date := jtf_date_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: -------------------------------------------------------
5721: --Tables for getting taskbar label information

Line 5718: l_scheduled_end_date := jtf_date_table();

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: -------------------------------------------------------
5721: --Tables for getting taskbar label information
5722: -------------------------------------------------------

Line 5735: real_start_date := jtf_date_table();

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();
5739: real_tooltip := jtf_varchar2_table_2000();

Line 5736: real_end_date := jtf_date_table();

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();
5739: real_tooltip := jtf_varchar2_table_2000();
5740: real_duration := jtf_number_table();

Line 6586: , start_date OUT NOCOPY jtf_date_table

6582: , p_end_date IN DATE
6583: , sch_adv_tz IN Varchar2
6584: , inc_tz_code IN Varchar2
6585: , trip_id OUT NOCOPY jtf_number_table
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

Line 6587: , end_date OUT NOCOPY jtf_date_table

6583: , sch_adv_tz IN Varchar2
6584: , inc_tz_code IN Varchar2
6585: , trip_id OUT NOCOPY jtf_number_table
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

Line 6591: , plan_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
6595: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 6592: , plan_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
6595: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
6596: , plan_duration OUT NOCOPY jtf_number_table

Line 6600: , real_start_date OUT NOCOPY jtf_date_table

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
6604: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

Line 6601: , real_end_date OUT NOCOPY jtf_date_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
6604: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
6605: , real_duration OUT NOCOPY jtf_number_table

Line 6615: , oth_real_start_date OUT Nocopy jtf_date_table

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
6619: , oth_real_Duration OUT Nocopy jtf_number_table

Line 6616: , oth_real_end_date OUT Nocopy jtf_date_table

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
6619: , oth_real_Duration OUT Nocopy jtf_number_table
6620: , oth_real_task_type_id OUT Nocopy jtf_number_table

Line 6662: l_planned_start_date jtf_date_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;
6665: l_actual_end_date jtf_date_table;
6666: l_actual_effort jtf_number_table;

Line 6663: l_planned_end_date jtf_date_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;
6665: l_actual_end_date jtf_date_table;
6666: l_actual_effort jtf_number_table;
6667: l_actual_effort_uom jtf_varchar2_table_100;

Line 6664: l_actual_start_date jtf_date_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;
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;

Line 6665: l_actual_end_date jtf_date_table;

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

Line 7477: start_date := jtf_date_table();

7473: p_res_key := jtf_varchar2_table_2000();
7474: p_cost := jtf_number_table();
7475:
7476: trip_id := jtf_number_table();
7477: start_date := jtf_date_table();
7478: end_date := jtf_date_table();
7479: block_trip := jtf_number_table();
7480: tmp_trip_id := jtf_number_table();
7481: p_bck_res_key := jtf_varchar2_table_2000();

Line 7478: end_date := jtf_date_table();

7474: p_cost := jtf_number_table();
7475:
7476: trip_id := jtf_number_table();
7477: start_date := jtf_date_table();
7478: end_date := jtf_date_table();
7479: block_trip := jtf_number_table();
7480: tmp_trip_id := jtf_number_table();
7481: p_bck_res_key := jtf_varchar2_table_2000();
7482:

Line 7487: plan_start_date := jtf_date_table();

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();
7491: plan_tooltip := jtf_varchar2_table_2000();

Line 7488: plan_end_date := jtf_date_table();

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();
7491: plan_tooltip := jtf_varchar2_table_2000();
7492: plan_duration := jtf_number_table();

Line 7496: real_start_date := jtf_date_table();

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();
7500: real_tooltip := jtf_varchar2_table_2000();

Line 7497: real_end_date := jtf_date_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();
7500: real_tooltip := jtf_varchar2_table_2000();
7501: real_duration := jtf_number_table();

Line 7515: oth_real_start_date := jtf_date_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();
7519: oth_real_tooltip := jtf_varchar2_table_2000();

Line 7516: oth_real_end_date := jtf_date_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();
7519: oth_real_tooltip := jtf_varchar2_table_2000();
7520: oth_real_DURATION := jtf_number_table();

Line 7532: l_planned_start_date := jtf_date_table();

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

Line 7533: l_planned_end_date := jtf_date_table();

7529:
7530: p_vir_avail_type := jtf_varchar2_table_2000();
7531:
7532: l_planned_start_date := jtf_date_table();
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();

Line 7534: l_actual_start_date := jtf_date_table();

7530: p_vir_avail_type := jtf_varchar2_table_2000();
7531:
7532: l_planned_start_date := jtf_date_table();
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();

Line 7535: l_actual_end_date := jtf_date_table();

7531:
7532: l_planned_start_date := jtf_date_table();
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();