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 107: , p_message_text OUT NOCOPY jtf_varchar2_table_2000

103: , p_init_msg_list IN Varchar2 DEFAULT NULL
104: , x_return_status OUT NOCOPY Varchar2
105: , x_msg_count OUT NOCOPY Number
106: , x_msg_data OUT NOCOPY Varchar2
107: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
108: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
109: )
110: IS
111: Cursor c1

Line 108: , p_message_code OUT NOCOPY jtf_varchar2_table_2000

104: , x_return_status OUT NOCOPY Varchar2
105: , x_msg_count OUT NOCOPY Number
106: , x_msg_data OUT NOCOPY Varchar2
107: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
108: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
109: )
110: IS
111: Cursor c1
112: is

Line 122: p_message_text :=jtf_varchar2_table_2000();

118: and translate(substr(message_name,6,2),'0123456789','xxxxxxxxxx') ='xx'
119: order by message_name;
120:
121: BEGIN
122: p_message_text :=jtf_varchar2_table_2000();
123: p_message_code :=jtf_varchar2_table_2000();
124: OPEN c1;
125: FETCH c1
126: BULK COLLECT INTO p_message_text,p_message_code;

Line 123: p_message_code :=jtf_varchar2_table_2000();

119: order by message_name;
120:
121: BEGIN
122: p_message_text :=jtf_varchar2_table_2000();
123: p_message_code :=jtf_varchar2_table_2000();
124: OPEN c1;
125: FETCH c1
126: BULK COLLECT INTO p_message_text,p_message_code;
127: END get_message_text;

Line 1534: , tooltip OUT NOCOPY jtf_varchar2_table_2000

1530: , start_date OUT NOCOPY jtf_date_table
1531: , end_date OUT NOCOPY jtf_date_table
1532: , color OUT NOCOPY jtf_number_table
1533: , NAME OUT NOCOPY jtf_varchar2_table_100
1534: , tooltip OUT NOCOPY jtf_varchar2_table_2000
1535: , DURATION OUT NOCOPY jtf_number_table
1536: , task_type_id OUT NOCOPY jtf_number_table
1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000
1538: , sch_adv_tz In Varchar2

Line 1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000

1533: , NAME OUT NOCOPY jtf_varchar2_table_100
1534: , tooltip OUT NOCOPY jtf_varchar2_table_2000
1535: , DURATION OUT NOCOPY jtf_number_table
1536: , task_type_id OUT NOCOPY jtf_number_table
1537: , resource_key OUT NOCOPY jtf_varchar2_table_2000
1538: , sch_adv_tz In Varchar2
1539: ) IS
1540: l_rec tooltip_data_rec_type := NULL;
1541:

Line 1579: tooltip := jtf_varchar2_table_2000();

1575: start_date := jtf_date_table();
1576: end_date := jtf_date_table();
1577: color := jtf_number_table();
1578: NAME := jtf_varchar2_table_100();
1579: tooltip := jtf_varchar2_table_2000();
1580: DURATION := jtf_number_table();
1581: task_type_id := jtf_number_table();
1582: resource_key := jtf_varchar2_table_2000();
1583:

Line 1582: resource_key := jtf_varchar2_table_2000();

1578: NAME := jtf_varchar2_table_100();
1579: tooltip := jtf_varchar2_table_2000();
1580: DURATION := jtf_number_table();
1581: task_type_id := jtf_number_table();
1582: resource_key := jtf_varchar2_table_2000();
1583:
1584: OPEN c_planned_task;
1585: FETCH c_planned_task
1586: BULK COLLECT INTO task_id

Line 2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

2328: , x_msg_data OUT NOCOPY Varchar2
2329: , p_start_date_range IN DATE
2330: , p_end_date_range IN DATE
2331: , p_res_id OUT NOCOPY jtf_number_table
2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table

Line 2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

2329: , p_start_date_range IN DATE
2330: , p_end_date_range IN DATE
2331: , p_res_id OUT NOCOPY jtf_number_table
2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table

Line 2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

2330: , p_end_date_range IN DATE
2331: , p_res_id OUT NOCOPY jtf_number_table
2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table
2338: , p_shift_end_date OUT NOCOPY jtf_date_table

Line 2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

2331: , p_res_id OUT NOCOPY jtf_number_table
2332: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
2333: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
2334: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
2335: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table
2338: , p_shift_end_date OUT NOCOPY jtf_date_table
2339: , p_block_trip OUT NOCOPY jtf_number_table

Line 2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000

2336: , p_trip_id OUT NOCOPY jtf_number_table
2337: , p_shift_start_date OUT NOCOPY jtf_date_table
2338: , p_shift_end_date OUT NOCOPY jtf_date_table
2339: , p_block_trip OUT NOCOPY jtf_number_table
2340: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
2341: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
2342: , p_vir_start_date OUT NOCOPY jtf_date_table
2343: , p_vir_end_date OUT NOCOPY jtf_date_table
2344: , p_vir_color OUT NOCOPY jtf_number_table

Line 2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000

2344: , p_vir_color OUT NOCOPY jtf_number_table
2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
2346: , p_vir_duration OUT NOCOPY jtf_number_table
2347: , p_vir_task_type_id OUT NOCOPY jtf_number_table
2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
2350: , real_task_id OUT NOCOPY jtf_varchar2_table_100
2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table

Line 2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

2345: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
2346: , p_vir_duration OUT NOCOPY jtf_number_table
2347: , p_vir_task_type_id OUT NOCOPY jtf_number_table
2348: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
2349: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
2350: , real_task_id OUT NOCOPY jtf_varchar2_table_100
2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table
2353: , real_color OUT NOCOPY jtf_number_table

Line 2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000

2350: , real_task_id OUT NOCOPY jtf_varchar2_table_100
2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table
2353: , real_color OUT NOCOPY jtf_number_table
2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
2356: , real_DURATION OUT NOCOPY jtf_number_table
2357: , real_task_type_id OUT NOCOPY jtf_number_table
2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

2351: , real_start_date OUT NOCOPY jtf_date_table
2352: , real_end_date OUT NOCOPY jtf_date_table
2353: , real_color OUT NOCOPY jtf_number_table
2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
2356: , real_DURATION OUT NOCOPY jtf_number_table
2357: , real_task_type_id OUT NOCOPY jtf_number_table
2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
2359: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

Line 2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

2354: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
2355: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
2356: , real_DURATION OUT NOCOPY jtf_number_table
2357: , real_task_type_id OUT NOCOPY jtf_number_table
2358: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
2359: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
2360: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
2361: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
2362: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

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

2414: , SUBSTR(column_value
2415: , INSTR(column_value, '-', 1, 1) + 1
2416: ,LENGTH(column_value)
2417: ) resource_type
2418: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2419: ) res_info
2420: WHERE ca.object_type = res_info.resource_type
2421: AND ca.object_id = res_info.resource_id
2422: AND TRUNC(ca.start_date_time) >= (p_start_date -1)

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

2463: , SUBSTR(column_value
2464: , INSTR(column_value, '-', 1, 1) + 1
2465: ,LENGTH(column_value)
2466: ) resource_type
2467: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2468: ) res_info
2469: , jtf_task_assignments a
2470: , jtf_tasks_b t
2471: , jtf_task_types_b tt

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

2550: ,SUBSTR(column_value
2551: , INSTR(column_value, '-', 1, 1) + 1
2552: , LENGTH(column_value)
2553: ) resource_type
2554: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2555: ) res_info
2556: , jtf_task_assignments a
2557: , jtf_tasks_b t
2558: , jtf_task_types_b tt

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

2627: ,SUBSTR(column_value
2628: , INSTR(column_value, '-', 1, 1) + 1
2629: , LENGTH(column_value)
2630: ) resource_type
2631: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2632: ) res_info
2633: , jtf_task_assignments a
2634: , jtf_tasks_b t
2635: , jtf_task_types_b tt

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

2705: ,SUBSTR(column_value
2706: , INSTR(column_value, '-', 1, 1) + 1
2707: , LENGTH(column_value)
2708: ) resource_type
2709: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2710: ) res_info
2711: , jtf_task_assignments a
2712: , jtf_tasks_b t
2713: , jtf_task_types_b tt

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

2780: ,SUBSTR(column_value
2781: , INSTR(column_value, '-', 1, 1) + 1
2782: , LENGTH(column_value)
2783: ) resource_type
2784: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
2785: ) res_info
2786: , jtf_task_assignments a
2787: , jtf_tasks_b t
2788: , jtf_task_types_b tt

Line 2881: p_res_type :=jtf_varchar2_table_2000();

2877: RETURN 0;
2878: END do_match;
2879: BEGIN
2880: p_res_id :=jtf_number_table();
2881: p_res_type :=jtf_varchar2_table_2000();
2882: p_res_name :=jtf_varchar2_table_2000();
2883: p_res_typ_name :=jtf_varchar2_table_2000();
2884: p_res_key :=jtf_varchar2_table_2000();
2885: --------------------------------------

Line 2882: p_res_name :=jtf_varchar2_table_2000();

2878: END do_match;
2879: BEGIN
2880: p_res_id :=jtf_number_table();
2881: p_res_type :=jtf_varchar2_table_2000();
2882: p_res_name :=jtf_varchar2_table_2000();
2883: p_res_typ_name :=jtf_varchar2_table_2000();
2884: p_res_key :=jtf_varchar2_table_2000();
2885: --------------------------------------
2886: --Tables for getting shift information

Line 2883: p_res_typ_name :=jtf_varchar2_table_2000();

2879: BEGIN
2880: p_res_id :=jtf_number_table();
2881: p_res_type :=jtf_varchar2_table_2000();
2882: p_res_name :=jtf_varchar2_table_2000();
2883: p_res_typ_name :=jtf_varchar2_table_2000();
2884: p_res_key :=jtf_varchar2_table_2000();
2885: --------------------------------------
2886: --Tables for getting shift information
2887: --------------------------------------

Line 2884: p_res_key :=jtf_varchar2_table_2000();

2880: p_res_id :=jtf_number_table();
2881: p_res_type :=jtf_varchar2_table_2000();
2882: p_res_name :=jtf_varchar2_table_2000();
2883: p_res_typ_name :=jtf_varchar2_table_2000();
2884: p_res_key :=jtf_varchar2_table_2000();
2885: --------------------------------------
2886: --Tables for getting shift information
2887: --------------------------------------
2888: p_trip_id :=jtf_number_table();

Line 2892: p_shift_res_key :=jtf_varchar2_table_2000();

2888: p_trip_id :=jtf_number_table();
2889: p_shift_start_date :=jtf_date_table();
2890: p_shift_end_date :=jtf_date_table();
2891: p_block_trip :=jtf_number_table();
2892: p_shift_res_key :=jtf_varchar2_table_2000();
2893: ----------------------------------------------------------
2894: --tables used for getting virtual task information
2895: ----------------------------------------------------------
2896: p_vir_task_id := jtf_varchar2_table_100() ;

Line 2903: p_vir_tooltip := jtf_varchar2_table_2000();

2899: p_vir_color := jtf_number_table();
2900: p_vir_name := jtf_varchar2_table_100();
2901: p_vir_duration := jtf_number_table();
2902: p_vir_task_type_id := jtf_number_table();
2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
2905:
2906: l_assignment_id := jtf_number_table();
2907: l_task_priority_id := jtf_number_table();

Line 2904: p_vir_resource_key := jtf_varchar2_table_2000();

2900: p_vir_name := jtf_varchar2_table_100();
2901: p_vir_duration := jtf_number_table();
2902: p_vir_task_type_id := jtf_number_table();
2903: p_vir_tooltip := jtf_varchar2_table_2000();
2904: p_vir_resource_key := jtf_varchar2_table_2000();
2905:
2906: l_assignment_id := jtf_number_table();
2907: l_task_priority_id := jtf_number_table();
2908: l_status_id := jtf_number_table();

Line 2927: real_name := jtf_varchar2_table_2000();

2923: real_task_id := jtf_varchar2_table_100();
2924: real_start_date := jtf_date_table();
2925: real_end_date := jtf_date_table();
2926: real_color := jtf_number_table();
2927: real_name := jtf_varchar2_table_2000();
2928: real_tooltip := jtf_varchar2_table_2000();
2929: real_duration := jtf_number_table();
2930: real_task_type_id := jtf_number_table();
2931: real_resource_key := jtf_varchar2_table_2000();

Line 2928: real_tooltip := jtf_varchar2_table_2000();

2924: real_start_date := jtf_date_table();
2925: real_end_date := jtf_date_table();
2926: real_color := jtf_number_table();
2927: real_name := jtf_varchar2_table_2000();
2928: real_tooltip := jtf_varchar2_table_2000();
2929: real_duration := jtf_number_table();
2930: real_task_type_id := jtf_number_table();
2931: real_resource_key := jtf_varchar2_table_2000();
2932: real_parts_required := jtf_varchar2_table_100();

Line 2931: real_resource_key := jtf_varchar2_table_2000();

2927: real_name := jtf_varchar2_table_2000();
2928: real_tooltip := jtf_varchar2_table_2000();
2929: real_duration := jtf_number_table();
2930: real_task_type_id := jtf_number_table();
2931: real_resource_key := jtf_varchar2_table_2000();
2932: real_parts_required := jtf_varchar2_table_100();
2933: real_access_hours := jtf_varchar2_table_100();
2934: real_after_hours := jtf_varchar2_table_100();
2935: real_customer_conf := jtf_varchar2_table_100();

Line 3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

3605: , p_req_id IN NUMBER
3606: , p_par_task IN NUMBER
3607: , p_task_id IN NUMBER
3608: , p_res_id OUT NOCOPY jtf_number_table
3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
3613: , p_cost OUT NOCOPY jtf_number_table

Line 3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

3606: , p_par_task IN NUMBER
3607: , p_task_id IN NUMBER
3608: , p_res_id OUT NOCOPY jtf_number_table
3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
3613: , p_cost OUT NOCOPY jtf_number_table
3614: , p_start_date IN DATE

Line 3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

3607: , p_task_id IN NUMBER
3608: , p_res_id OUT NOCOPY jtf_number_table
3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
3613: , p_cost OUT NOCOPY jtf_number_table
3614: , p_start_date IN DATE
3615: , p_end_date IN DATE

Line 3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

3608: , p_res_id OUT NOCOPY jtf_number_table
3609: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
3610: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
3611: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
3612: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
3613: , p_cost OUT NOCOPY jtf_number_table
3614: , p_start_date IN DATE
3615: , p_end_date IN DATE
3616: , sch_adv_tz IN Varchar2

Line 3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000

3618: , trip_id OUT NOCOPY jtf_number_table
3619: , start_date OUT NOCOPY jtf_date_table
3620: , end_date OUT NOCOPY jtf_date_table
3621: , block_trip OUT NOCOPY jtf_number_table
3622: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
3624: , plan_start_date OUT NOCOPY jtf_date_table
3625: , plan_end_date OUT NOCOPY jtf_date_table
3626: , plan_color OUT NOCOPY jtf_number_table

Line 3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000

3623: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
3624: , plan_start_date OUT NOCOPY jtf_date_table
3625: , plan_end_date OUT NOCOPY jtf_date_table
3626: , plan_color OUT NOCOPY jtf_number_table
3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000
3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
3629: , plan_duration OUT NOCOPY jtf_number_table
3630: , plan_task_type_id OUT NOCOPY jtf_number_table
3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

3624: , plan_start_date OUT NOCOPY jtf_date_table
3625: , plan_end_date OUT NOCOPY jtf_date_table
3626: , plan_color OUT NOCOPY jtf_number_table
3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000
3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
3629: , plan_duration OUT NOCOPY jtf_number_table
3630: , plan_task_type_id OUT NOCOPY jtf_number_table
3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100

Line 3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

3627: , plan_name OUT NOCOPY jtf_varchar2_table_2000
3628: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
3629: , plan_duration OUT NOCOPY jtf_number_table
3630: , plan_task_type_id OUT NOCOPY jtf_number_table
3631: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100
3633: , real_start_date OUT NOCOPY jtf_date_table
3634: , real_end_date OUT NOCOPY jtf_date_table
3635: , real_color OUT NOCOPY jtf_number_table

Line 3636: , real_name OUT NOCOPY jtf_varchar2_table_2000

3632: , real_task_key OUT NOCOPY jtf_varchar2_table_100
3633: , real_start_date OUT NOCOPY jtf_date_table
3634: , real_end_date OUT NOCOPY jtf_date_table
3635: , real_color OUT NOCOPY jtf_number_table
3636: , real_name OUT NOCOPY jtf_varchar2_table_2000
3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
3638: , real_duration OUT NOCOPY jtf_number_table
3639: , real_task_type_id OUT NOCOPY jtf_number_table
3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

3633: , real_start_date OUT NOCOPY jtf_date_table
3634: , real_end_date OUT NOCOPY jtf_date_table
3635: , real_color OUT NOCOPY jtf_number_table
3636: , real_name OUT NOCOPY jtf_varchar2_table_2000
3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
3638: , real_duration OUT NOCOPY jtf_number_table
3639: , real_task_type_id OUT NOCOPY jtf_number_table
3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
3641: , child_task OUT Nocopy jtf_varchar2_table_100

Line 3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

3636: , real_name OUT NOCOPY jtf_varchar2_table_2000
3637: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
3638: , real_duration OUT NOCOPY jtf_number_table
3639: , real_task_type_id OUT NOCOPY jtf_number_table
3640: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
3641: , child_task OUT Nocopy jtf_varchar2_table_100
3642: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
3643: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
3644: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 3651: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000

3647: , oth_real_task_id OUT Nocopy jtf_varchar2_table_100
3648: , oth_real_start_date OUT Nocopy jtf_date_table
3649: , oth_real_end_date OUT Nocopy jtf_date_table
3650: , oth_real_color OUT Nocopy jtf_number_table
3651: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000
3652: , oth_real_Duration OUT Nocopy jtf_number_table
3653: , oth_real_task_type_id OUT Nocopy jtf_number_table
3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
3655: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100

Line 3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000

3650: , oth_real_color OUT Nocopy jtf_number_table
3651: , oth_real_Name OUT Nocopy jtf_varchar2_table_2000
3652: , oth_real_Duration OUT Nocopy jtf_number_table
3653: , oth_real_task_type_id OUT Nocopy jtf_number_table
3654: , oth_real_resource_key OUT Nocopy jtf_varchar2_table_2000
3655: , oth_real_child_task OUT Nocopy jtf_varchar2_table_100
3656: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
3657: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
3658: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 3708: oth_real_tooltip jtf_varchar2_table_2000;

3704: l_status_id jtf_number_table;
3705: l_csf_default_effort NUMBER;
3706: l_task_depends varchar2(1);
3707: l_task_depend jtf_varchar2_table_100;
3708: oth_real_tooltip jtf_varchar2_table_2000;
3709:
3710: CURSOR c_icon_setup
3711: IS
3712: SELECT active

Line 4391: p_res_type := jtf_varchar2_table_2000();

4387: END do_match;
4388:
4389: BEGIN
4390: p_res_id := jtf_number_table();
4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
4394: p_res_key := jtf_varchar2_table_2000();
4395: p_cost := jtf_number_table();

Line 4392: p_res_name := jtf_varchar2_table_2000();

4388:
4389: BEGIN
4390: p_res_id := jtf_number_table();
4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
4394: p_res_key := jtf_varchar2_table_2000();
4395: p_cost := jtf_number_table();
4396:

Line 4393: p_res_typ_name := jtf_varchar2_table_2000();

4389: BEGIN
4390: p_res_id := jtf_number_table();
4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
4394: p_res_key := jtf_varchar2_table_2000();
4395: p_cost := jtf_number_table();
4396:
4397: trip_id := jtf_number_table();

Line 4394: p_res_key := jtf_varchar2_table_2000();

4390: p_res_id := jtf_number_table();
4391: p_res_type := jtf_varchar2_table_2000();
4392: p_res_name := jtf_varchar2_table_2000();
4393: p_res_typ_name := jtf_varchar2_table_2000();
4394: p_res_key := jtf_varchar2_table_2000();
4395: p_cost := jtf_number_table();
4396:
4397: trip_id := jtf_number_table();
4398: start_date := jtf_date_table();

Line 4402: p_bck_res_key := jtf_varchar2_table_2000();

4398: start_date := jtf_date_table();
4399: end_date := jtf_date_table();
4400: block_trip := jtf_number_table();
4401: tmp_trip_id := jtf_number_table();
4402: p_bck_res_key := jtf_varchar2_table_2000();
4403:
4404: ---------------------------------------------------------
4405: --tables used for getting real/to be plan task parameters
4406: ---------------------------------------------------------

Line 4411: plan_name := jtf_varchar2_table_2000();

4407: plan_task_key := jtf_varchar2_table_100();
4408: plan_start_date := jtf_date_table();
4409: plan_end_date := jtf_date_table();
4410: plan_color := jtf_number_table();
4411: plan_name := jtf_varchar2_table_2000();
4412: plan_tooltip := jtf_varchar2_table_2000();
4413: plan_duration := jtf_number_table();
4414: plan_task_type_id := jtf_number_table();
4415: plan_resource_key := jtf_varchar2_table_2000();

Line 4412: plan_tooltip := jtf_varchar2_table_2000();

4408: plan_start_date := jtf_date_table();
4409: plan_end_date := jtf_date_table();
4410: plan_color := jtf_number_table();
4411: plan_name := jtf_varchar2_table_2000();
4412: plan_tooltip := jtf_varchar2_table_2000();
4413: plan_duration := jtf_number_table();
4414: plan_task_type_id := jtf_number_table();
4415: plan_resource_key := jtf_varchar2_table_2000();
4416: real_task_key := jtf_varchar2_table_100();

Line 4415: plan_resource_key := jtf_varchar2_table_2000();

4411: plan_name := jtf_varchar2_table_2000();
4412: plan_tooltip := jtf_varchar2_table_2000();
4413: plan_duration := jtf_number_table();
4414: plan_task_type_id := jtf_number_table();
4415: plan_resource_key := jtf_varchar2_table_2000();
4416: real_task_key := jtf_varchar2_table_100();
4417: real_start_date := jtf_date_table();
4418: real_end_date := jtf_date_table();
4419: real_color := jtf_number_table();

Line 4420: real_name := jtf_varchar2_table_2000();

4416: real_task_key := jtf_varchar2_table_100();
4417: real_start_date := jtf_date_table();
4418: real_end_date := jtf_date_table();
4419: real_color := jtf_number_table();
4420: real_name := jtf_varchar2_table_2000();
4421: real_tooltip := jtf_varchar2_table_2000();
4422: real_duration := jtf_number_table();
4423: real_task_type_id := jtf_number_table();
4424: real_resource_key := jtf_varchar2_table_2000();

Line 4421: real_tooltip := jtf_varchar2_table_2000();

4417: real_start_date := jtf_date_table();
4418: real_end_date := jtf_date_table();
4419: real_color := jtf_number_table();
4420: real_name := jtf_varchar2_table_2000();
4421: real_tooltip := jtf_varchar2_table_2000();
4422: real_duration := jtf_number_table();
4423: real_task_type_id := jtf_number_table();
4424: real_resource_key := jtf_varchar2_table_2000();
4425: child_task := jtf_varchar2_table_100();

Line 4424: real_resource_key := jtf_varchar2_table_2000();

4420: real_name := jtf_varchar2_table_2000();
4421: real_tooltip := jtf_varchar2_table_2000();
4422: real_duration := jtf_number_table();
4423: real_task_type_id := jtf_number_table();
4424: real_resource_key := jtf_varchar2_table_2000();
4425: child_task := jtf_varchar2_table_100();
4426: real_parts_required := jtf_varchar2_table_100();
4427: real_access_hours := jtf_varchar2_table_100();
4428: real_after_hours := jtf_varchar2_table_100();

Line 4439: oth_real_NAME := jtf_varchar2_table_2000();

4435: oth_real_task_id := jtf_varchar2_table_100();
4436: oth_real_start_date := jtf_date_table();
4437: oth_real_end_date := jtf_date_table();
4438: oth_real_color := jtf_number_table();
4439: oth_real_NAME := jtf_varchar2_table_2000();
4440: oth_real_tooltip := jtf_varchar2_table_2000();
4441: oth_real_DURATION := jtf_number_table();
4442: oth_real_task_type_id := jtf_number_table();
4443: oth_real_resource_key := jtf_varchar2_table_2000();

Line 4440: oth_real_tooltip := jtf_varchar2_table_2000();

4436: oth_real_start_date := jtf_date_table();
4437: oth_real_end_date := jtf_date_table();
4438: oth_real_color := jtf_number_table();
4439: oth_real_NAME := jtf_varchar2_table_2000();
4440: oth_real_tooltip := jtf_varchar2_table_2000();
4441: oth_real_DURATION := jtf_number_table();
4442: oth_real_task_type_id := jtf_number_table();
4443: oth_real_resource_key := jtf_varchar2_table_2000();
4444: oth_real_child_task := jtf_varchar2_table_100();

Line 4443: oth_real_resource_key := jtf_varchar2_table_2000();

4439: oth_real_NAME := jtf_varchar2_table_2000();
4440: oth_real_tooltip := jtf_varchar2_table_2000();
4441: oth_real_DURATION := jtf_number_table();
4442: oth_real_task_type_id := jtf_number_table();
4443: oth_real_resource_key := jtf_varchar2_table_2000();
4444: oth_real_child_task := jtf_varchar2_table_100();
4445: oth_real_parts_required := jtf_varchar2_table_100();
4446: oth_real_access_hours := jtf_varchar2_table_100();
4447: oth_real_after_hours := jtf_varchar2_table_100();