eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_GANTT_DATA_PKG dependencies on JTF_NUMBER_TABLE

Line 465: l_task_tbl jtf_number_table;

461: l_off_time varchar2(200);
462: l_per_time varchar2(200);
463: l_planned_effort varchar2(200);
464: l_actual_effort varchar2(200);
465: l_task_tbl jtf_number_table;
466: l_capacity number;
467: i number;
468: j number;
469: l_first number;

Line 542: l_task_tbl := jtf_number_table();

538: debug(' Cursor c_task raised No Data Found exception', 'get_tooltip_data_gantt', fnd_log.level_statement);
539: END IF;
540: RAISE NO_DATA_FOUND;
541: END IF;
542: l_task_tbl := jtf_number_table();
543:
544: OPEN c_trip;
545: FETCH c_trip into l_capacity;
546: CLOSE c_trip;

Line 1604: l_task_tbl jtf_number_table;

1600: l_off_time varchar2(200);
1601: l_per_time varchar2(200);
1602: l_planned_effort varchar2(200);
1603: l_actual_effort varchar2(200);
1604: l_task_tbl jtf_number_table;
1605: l_capacity number;
1606: i number;
1607: j number;
1608: l_first number;

Line 1665: l_task_tbl := jtf_number_table();

1661: CLOSE c_task;
1662:
1663: RAISE NO_DATA_FOUND;
1664: END IF;
1665: l_task_tbl := jtf_number_table();
1666:
1667: OPEN c_trip;
1668: FETCH c_trip into l_capacity;
1669: CLOSE c_trip;

Line 4041: , color OUT NOCOPY jtf_number_table

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

Line 4044: , DURATION OUT NOCOPY jtf_number_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
4047: , sch_adv_tz In Varchar2
4048: ) IS

Line 4045: , task_type_id OUT NOCOPY jtf_number_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
4047: , sch_adv_tz In Varchar2
4048: ) IS
4049: l_rec tooltip_data_rec_type := NULL;

Line 4086: color := jtf_number_table();

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

Line 4089: DURATION := jtf_number_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();
4092:
4093: OPEN c_planned_task;

Line 4090: task_type_id := jtf_number_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();
4092:
4093: OPEN c_planned_task;
4094: FETCH c_planned_task

Line 4995: , p_res_id OUT NOCOPY jtf_number_table

4991: , x_msg_count OUT NOCOPY Number
4992: , x_msg_data OUT NOCOPY Varchar2
4993: , p_start_date_range IN DATE
4994: , p_end_date_range IN DATE
4995: , p_res_id OUT NOCOPY jtf_number_table
4996: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
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

Line 5000: , p_trip_id OUT NOCOPY jtf_number_table

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

Line 5003: , p_block_trip OUT NOCOPY jtf_number_table

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

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

Line 5010: , p_vir_duration OUT NOCOPY jtf_number_table

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
5014: , real_task_id OUT NOCOPY jtf_varchar2_table_100

Line 5011: , p_vir_task_type_id OUT NOCOPY jtf_number_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
5014: , real_task_id OUT NOCOPY jtf_varchar2_table_100
5015: , real_start_date OUT NOCOPY jtf_date_table

Line 5017: , real_color OUT NOCOPY jtf_number_table

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

Line 5020: , real_DURATION OUT NOCOPY jtf_number_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
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

Line 5021: , real_task_type_id OUT NOCOPY jtf_number_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
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

Line 5035: l_assignment_id jtf_number_table;

5031: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000
5032: , p_contact OUT NOCOPY jtf_varchar2_table_2000
5033: )
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;

Line 5036: l_task_priority_id jtf_number_table;

5032: , p_contact OUT NOCOPY jtf_varchar2_table_2000
5033: )
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;

Line 5037: l_status_id jtf_number_table;

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

Line 5042: l_actual_effort 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;
5046: l_escalated_task jtf_varchar2_table_100;

Line 5044: l_planned_effort jtf_number_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;
5048: l_scheduled_end_date jtf_date_table;

Line 5242: l_actual_travel_duration jtf_number_table;

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

Line 5675: p_res_id :=jtf_number_table();

5671:
5672:
5673: BEGIN
5674:
5675: p_res_id :=jtf_number_table();
5676: p_res_type :=jtf_varchar2_table_2000();
5677: p_res_name :=jtf_varchar2_table_2000();
5678: p_res_typ_name :=jtf_varchar2_table_2000();
5679: p_res_key :=jtf_varchar2_table_2000();

Line 5685: p_trip_id :=jtf_number_table();

5681: p_contact :=jtf_varchar2_table_2000();
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();

Line 5688: p_block_trip :=jtf_number_table();

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: ----------------------------------------------------------
5692: --tables used for getting virtual task information

Line 5697: p_vir_color := jtf_number_table();

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

Line 5699: p_vir_duration := jtf_number_table();

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();
5703: p_vir_avail_type := jtf_varchar2_table_2000();

Line 5700: p_vir_task_type_id := jtf_number_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();
5703: p_vir_avail_type := jtf_varchar2_table_2000();
5704:

Line 5705: l_assignment_id := jtf_number_table();

5701: p_vir_tooltip := jtf_varchar2_table_2000();
5702: p_vir_resource_key := jtf_varchar2_table_2000();
5703: p_vir_avail_type := jtf_varchar2_table_2000();
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();

Line 5706: l_task_priority_id := jtf_number_table();

5702: p_vir_resource_key := jtf_varchar2_table_2000();
5703: p_vir_avail_type := jtf_varchar2_table_2000();
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();

Line 5707: l_status_id := jtf_number_table();

5703: p_vir_avail_type := jtf_varchar2_table_2000();
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();

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

Line 5714: l_planned_effort := jtf_number_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();
5718: l_scheduled_end_date := jtf_date_table();

Line 5737: real_color := jtf_number_table();

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

Line 5740: real_duration := jtf_number_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();
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();

Line 5741: real_task_type_id := jtf_number_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();
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();

Line 5750: l_actual_travel_duration := jtf_number_table();

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();
5753: --------------------------------------------------------------------------
5754: -- This was added because profile values were getting cached

Line 6575: , p_res_id OUT NOCOPY jtf_number_table

6571: , p_resource_type IN VARCHAR2
6572: , p_req_id IN NUMBER
6573: , p_par_task IN NUMBER
6574: , p_task_id IN NUMBER
6575: , p_res_id OUT NOCOPY jtf_number_table
6576: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
6577: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
6578: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
6579: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 6580: , p_cost OUT NOCOPY jtf_number_table

6576: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
6577: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
6578: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
6579: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
6580: , p_cost OUT NOCOPY jtf_number_table
6581: , p_start_date IN DATE
6582: , p_end_date IN DATE
6583: , sch_adv_tz IN Varchar2
6584: , inc_tz_code IN Varchar2

Line 6585: , trip_id OUT NOCOPY jtf_number_table

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

Line 6588: , block_trip OUT NOCOPY jtf_number_table

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

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

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

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

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

Line 6605: , real_duration OUT NOCOPY jtf_number_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
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

Line 6606: , real_task_type_id OUT NOCOPY jtf_number_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
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

Line 6617: , oth_real_color OUT Nocopy jtf_number_table

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

Line 6619: , oth_real_Duration OUT Nocopy jtf_number_table

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

Line 6620: , oth_real_task_type_id OUT Nocopy jtf_number_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
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

Line 6657: tmp_trip_id jtf_number_table;

6653:
6654: TYPE SchResType IS REF CURSOR;
6655: ResInfo SchResType;
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:

Line 6658: l_task_priority_id jtf_number_table;

6654: TYPE SchResType IS REF CURSOR;
6655: ResInfo SchResType;
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;

Line 6659: l_assignment_status_id jtf_number_table;

6655: ResInfo SchResType;
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;

Line 6666: l_actual_effort jtf_number_table;

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

Line 6668: l_planned_effort jtf_number_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;
6672: l_status_id jtf_number_table;

Line 6670: l_actual_travel_duration jtf_number_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;
6674: l_task_depends varchar2(1);

Line 6672: l_status_id jtf_number_table;

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;
6676: oth_real_tooltip jtf_varchar2_table_2000;

Line 7469: p_res_id := jtf_number_table();

7465: --- Fix for bug 7282611 forward ported.
7466: g_server_tz := fnd_timezones.get_server_timezone_code;
7467: g_client_tz := fnd_timezones.get_client_timezone_code;
7468: --- end of fix for bug 7282611
7469: p_res_id := jtf_number_table();
7470: p_res_type := jtf_varchar2_table_2000();
7471: p_res_name := jtf_varchar2_table_2000();
7472: p_res_typ_name := jtf_varchar2_table_2000();
7473: p_res_key := jtf_varchar2_table_2000();

Line 7474: p_cost := jtf_number_table();

7470: p_res_type := jtf_varchar2_table_2000();
7471: p_res_name := jtf_varchar2_table_2000();
7472: p_res_typ_name := jtf_varchar2_table_2000();
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();

Line 7476: trip_id := jtf_number_table();

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

Line 7479: block_trip := 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:
7483: ---------------------------------------------------------

Line 7480: tmp_trip_id := jtf_number_table();

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

Line 7489: plan_color := jtf_number_table();

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

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

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

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

Line 7501: real_duration := jtf_number_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();
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();

Line 7502: real_task_type_id := jtf_number_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();
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();

Line 7510: l_task_priority_id := jtf_number_table();

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:
7514: oth_real_task_id := jtf_varchar2_table_100();

Line 7511: l_assignment_status_id := jtf_number_table();

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:
7514: oth_real_task_id := jtf_varchar2_table_100();
7515: oth_real_start_date := jtf_date_table();

Line 7517: oth_real_color := jtf_number_table();

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

Line 7520: oth_real_DURATION := jtf_number_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();
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();

Line 7521: oth_real_task_type_id := jtf_number_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();
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();

Line 7536: l_actual_effort := jtf_number_table();

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

Line 7538: l_planned_effort := jtf_number_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();
7542: l_status_id := jtf_number_table();

Line 7540: l_actual_travel_duration := jtf_number_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:
7544: -------------------------------------------------------

Line 7542: l_status_id := jtf_number_table();

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