APPS.CSF_TRIPS_PUB dependencies on JTF_NUMBER_TABLE

Line 1711: l_del_trip_tbl jtf_number_table;

1707: l_old_trips_temp trip_tbl_type;
1708: l_trip_length NUMBER;
1709: l_prev_trip_id NUMBER;
1710: l_temp_trip_tbl number_tbl_type;
1711: l_del_trip_tbl jtf_number_table;
1712: l_old_new_trip_map number_tbl_type;
1713:
1714: l_msg_name fnd_new_messages.message_name%TYPE;
1715: l_reason fnd_new_messages.message_text%TYPE;

Line 1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc

1744: , csf_util_pvt.convert_to_minutes(
1745: ta.sched_travel_duration
1746: , ta.sched_travel_duration_uom
1747: ) travel_time
1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1749: , jtf_task_assignments ta
1750: , jtf_task_statuses_b ts
1751: , jtf_tasks_b t
1752: WHERE ta.object_capacity_id = oc.COLUMN_VALUE

Line 1884: l_del_trip_tbl := jtf_number_table();

1880: , l_api_name, fnd_log.level_statement);
1881: END LOOP;
1882: END IF;
1883:
1884: l_del_trip_tbl := jtf_number_table();
1885:
1886: -- Loop through each Shift to create a new Trip
1887: l_shift_idx := l_shifts.FIRST;
1888: WHILE l_shift_idx IS NOT NULL LOOP

Line 2394: l_dep_task_tbl jtf_number_table;

2390: ) IS
2391: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_TO_TRIPS';
2392: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2393:
2394: l_dep_task_tbl jtf_number_table;
2395: l_arr_task_tbl jtf_number_table;
2396: l_start_time_tbl jtf_date_table;
2397: l_end_time_tbl jtf_date_table;
2398: l_new_trip trip_rec_type;

Line 2395: l_arr_task_tbl jtf_number_table;

2391: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_TO_TRIPS';
2392: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2393:
2394: l_dep_task_tbl jtf_number_table;
2395: l_arr_task_tbl jtf_number_table;
2396: l_start_time_tbl jtf_date_table;
2397: l_end_time_tbl jtf_date_table;
2398: l_new_trip trip_rec_type;
2399:

Line 3543: l_resource_id_tbl jtf_number_table;

3539: l_resources_failed NUMBER;
3540: l_resources_success NUMBER;
3541: l_resource csf_resource_pub.resource_tbl_type;
3542: l_resource_info VARCHAR2(500);
3543: l_resource_id_tbl jtf_number_table;
3544: l_resource_type_tbl jtf_varchar2_table_100;
3545: l_shift_type VARCHAR2(100);
3546: l_shift_parameter varchar2(100);
3547: l_conv_end_date DATE;

Line 3661: l_resource_id_tbl := jtf_number_table();

3657: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3658: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3659:
3660: l_resource_info := fnd_message.get;
3661: l_resource_id_tbl := jtf_number_table();
3662: l_resource_id_tbl.extend(1);
3663: l_resource_id_tbl(1) := p_resource_id;
3664:
3665: l_resource_type_tbl := jtf_varchar2_table_100();