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_2000

Line 160: , p_message_text OUT NOCOPY jtf_varchar2_table_2000

156: , p_init_msg_list IN Varchar2 DEFAULT NULL
157: , x_return_status OUT NOCOPY Varchar2
158: , x_msg_count OUT NOCOPY Number
159: , x_msg_data OUT NOCOPY Varchar2
160: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
161: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
162: )
163: IS
164: Cursor c1

Line 161: , p_message_code OUT NOCOPY jtf_varchar2_table_2000

157: , x_return_status OUT NOCOPY Varchar2
158: , x_msg_count OUT NOCOPY Number
159: , x_msg_data OUT NOCOPY Varchar2
160: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
161: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
162: )
163: IS
164: Cursor c1
165: is

Line 175: p_message_text :=jtf_varchar2_table_2000();

171: and translate(substr(message_name,6,2),'0123456789','xxxxxxxxxx') ='xx'
172: order by message_name;
173:
174: BEGIN
175: p_message_text :=jtf_varchar2_table_2000();
176: p_message_code :=jtf_varchar2_table_2000();
177: OPEN c1;
178: FETCH c1
179: BULK COLLECT INTO p_message_text,p_message_code;

Line 176: p_message_code :=jtf_varchar2_table_2000();

172: order by message_name;
173:
174: BEGIN
175: p_message_text :=jtf_varchar2_table_2000();
176: p_message_code :=jtf_varchar2_table_2000();
177: OPEN c1;
178: FETCH c1
179: BULK COLLECT INTO p_message_text,p_message_code;
180: END get_message_text;

Line 4043: , tooltip OUT NOCOPY jtf_varchar2_table_2000

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
4047: , sch_adv_tz In Varchar2

Line 4046: , resource_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 4088: tooltip := jtf_varchar2_table_2000();

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

Line 4091: resource_key := jtf_varchar2_table_2000();

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
4095: BULK COLLECT INTO task_id

Line 4996: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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
5000: , p_trip_id OUT NOCOPY jtf_number_table

Line 4997: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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
5000: , p_trip_id OUT NOCOPY jtf_number_table
5001: , p_shift_start_date OUT NOCOPY jtf_date_table

Line 4998: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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

Line 4999: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 5004: , p_shift_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
5008: , p_vir_color OUT NOCOPY jtf_number_table

Line 5012: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
5016: , real_end_date OUT NOCOPY jtf_date_table

Line 5013: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
5016: , real_end_date OUT NOCOPY jtf_date_table
5017: , real_color OUT NOCOPY jtf_number_table

Line 5018: , real_NAME 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
5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 5019: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
5023: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

Line 5022: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
5026: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 5029: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

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

Line 5031: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000

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
5033: )
5034: IS
5035: l_assignment_id jtf_number_table;

Line 5032: , p_contact OUT NOCOPY jtf_varchar2_table_2000

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
5033: )
5034: IS
5035: l_assignment_id jtf_number_table;
5036: l_task_priority_id jtf_number_table;

Line 5161: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5157: , SUBSTR(column_value
5158: , INSTR(column_value, '-', 1, 1) + 1
5159: ,LENGTH(column_value)
5160: ) resource_type
5161: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5162: ) res_info
5163: WHERE ca.object_type = res_info.resource_type
5164: AND ca.object_id = res_info.resource_id
5165: AND TRUNC(ca.start_date_time) >= trunc(p_start_date -1)

Line 5211: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5207: , SUBSTR(column_value
5208: , INSTR(column_value, '-', 1, 1) + 1
5209: ,LENGTH(column_value)
5210: ) resource_type
5211: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5212: ) res_info
5213: , jtf_task_assignments a
5214: , jtf_tasks_b t
5215: , jtf_task_types_b tt

Line 5323: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5319: ,SUBSTR(column_value
5320: , INSTR(column_value, '-', 1, 1) + 1
5321: , LENGTH(column_value)
5322: ) resource_type
5323: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5324: ) res_info
5325: , jtf_task_assignments a
5326: , jtf_tasks_B t
5327: , jtf_tasks_tl tl

Line 5417: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5413: ,SUBSTR(column_value
5414: , INSTR(column_value, '-', 1, 1) + 1
5415: , LENGTH(column_value)
5416: ) resource_type
5417: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5418: ) res_info
5419: , jtf_task_assignments a
5420: , jtf_tasks_b t
5421: , jtf_tasks_tl tl

Line 5505: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5501: ,SUBSTR(column_value
5502: , INSTR(column_value, '-', 1, 1) + 1
5503: , LENGTH(column_value)
5504: ) resource_type
5505: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5506: ) res_info
5507: , jtf_task_assignments a
5508: , jtf_tasks_b t
5509: , jtf_task_types_b tt

Line 5578: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))

5574: ,SUBSTR(column_value
5575: , INSTR(column_value, '-', 1, 1) + 1
5576: , LENGTH(column_value)
5577: ) resource_type
5578: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5579: ) res_info
5580: , jtf_task_assignments a
5581: , jtf_tasks_b t
5582: , jtf_task_types_b tt

Line 5676: p_res_type :=jtf_varchar2_table_2000();

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();
5680: p_terr_name :=jtf_varchar2_table_2000();

Line 5677: p_res_name :=jtf_varchar2_table_2000();

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

Line 5678: p_res_typ_name :=jtf_varchar2_table_2000();

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

Line 5679: p_res_key :=jtf_varchar2_table_2000();

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();
5680: p_terr_name :=jtf_varchar2_table_2000();
5681: p_contact :=jtf_varchar2_table_2000();
5682: --------------------------------------
5683: --Tables for getting shift information

Line 5680: p_terr_name :=jtf_varchar2_table_2000();

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();
5680: p_terr_name :=jtf_varchar2_table_2000();
5681: p_contact :=jtf_varchar2_table_2000();
5682: --------------------------------------
5683: --Tables for getting shift information
5684: --------------------------------------

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

Line 5689: p_shift_res_key :=jtf_varchar2_table_2000();

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

Line 5701: p_vir_tooltip := jtf_varchar2_table_2000();

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:
5705: l_assignment_id := jtf_number_table();

Line 5702: p_vir_resource_key := jtf_varchar2_table_2000();

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:
5705: l_assignment_id := jtf_number_table();
5706: l_task_priority_id := jtf_number_table();

Line 5703: p_vir_avail_type := jtf_varchar2_table_2000();

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

Line 5738: real_name := jtf_varchar2_table_2000();

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();
5742: real_resource_key := jtf_varchar2_table_2000();

Line 5739: real_tooltip := jtf_varchar2_table_2000();

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();
5742: real_resource_key := jtf_varchar2_table_2000();
5743: real_parts_required := jtf_varchar2_table_100();

Line 5742: real_resource_key := jtf_varchar2_table_2000();

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();
5746: real_customer_conf := jtf_varchar2_table_100();

Line 6576: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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
6580: , p_cost OUT NOCOPY jtf_number_table

Line 6577: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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
6580: , p_cost OUT NOCOPY jtf_number_table
6581: , p_start_date IN DATE

Line 6578: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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
6580: , p_cost OUT NOCOPY jtf_number_table
6581: , p_start_date IN DATE
6582: , p_end_date IN DATE

Line 6579: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 6589: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 6594: , plan_name 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
6598: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 6595: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
6598: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
6599: , real_task_key OUT NOCOPY jtf_varchar2_table_100

Line 6598: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 6603: , real_name 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
6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 6604: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
6608: , child_task OUT Nocopy jtf_varchar2_table_100

Line 6607: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
6611: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 6618: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000

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
6622: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100

Line 6621: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000

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
6625: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 6628: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

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);
6632: L_COMMON_WHERE_RESOURCE_QUERY VARCHAR2(4000);

Line 6676: oth_real_tooltip jtf_varchar2_table_2000;

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;
6680: l_task_number jtf_varchar2_table_100;

Line 7470: p_res_type := jtf_varchar2_table_2000();

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();
7474: p_cost := jtf_number_table();

Line 7471: p_res_name := jtf_varchar2_table_2000();

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();
7474: p_cost := jtf_number_table();
7475:

Line 7472: p_res_typ_name := jtf_varchar2_table_2000();

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();
7474: p_cost := jtf_number_table();
7475:
7476: trip_id := jtf_number_table();

Line 7473: p_res_key := jtf_varchar2_table_2000();

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();
7474: p_cost := jtf_number_table();
7475:
7476: trip_id := jtf_number_table();
7477: start_date := jtf_date_table();

Line 7481: p_bck_res_key := jtf_varchar2_table_2000();

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

Line 7490: plan_name := jtf_varchar2_table_2000();

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();
7494: plan_resource_key := jtf_varchar2_table_2000();

Line 7491: plan_tooltip := jtf_varchar2_table_2000();

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();
7494: plan_resource_key := jtf_varchar2_table_2000();
7495: real_task_key := jtf_varchar2_table_100();

Line 7494: plan_resource_key := jtf_varchar2_table_2000();

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

Line 7499: real_name := 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();
7503: real_resource_key := jtf_varchar2_table_2000();

Line 7500: real_tooltip := jtf_varchar2_table_2000();

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();
7503: real_resource_key := jtf_varchar2_table_2000();
7504: child_task := jtf_varchar2_table_100();

Line 7503: real_resource_key := jtf_varchar2_table_2000();

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();
7507: real_after_hours := jtf_varchar2_table_100();

Line 7518: oth_real_NAME := jtf_varchar2_table_2000();

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();
7522: oth_real_resource_key := jtf_varchar2_table_2000();

Line 7519: oth_real_tooltip := jtf_varchar2_table_2000();

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();
7522: oth_real_resource_key := jtf_varchar2_table_2000();
7523: oth_real_child_task := jtf_varchar2_table_100();

Line 7522: oth_real_resource_key := jtf_varchar2_table_2000();

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();
7526: oth_real_after_hours := jtf_varchar2_table_100();

Line 7530: p_vir_avail_type := jtf_varchar2_table_2000();

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();
7533: l_planned_end_date := jtf_date_table();
7534: l_actual_start_date := jtf_date_table();