APPS.CSF_TRIPS_PUB dependencies on JTF_NUMBER_TABLE

Line 1595: l_del_trip_tbl jtf_number_table;

1591:
1592: l_trip_length NUMBER;
1593: l_prev_trip_id NUMBER;
1594: l_temp_trip_tbl number_tbl_type;
1595: l_del_trip_tbl jtf_number_table;
1596: l_old_new_trip_map number_tbl_type;
1597:
1598: l_msg_name fnd_new_messages.message_name%TYPE;
1599: l_reason fnd_new_messages.message_text%TYPE;

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

1625: , csf_util_pvt.convert_to_minutes(
1626: ta.sched_travel_duration
1627: , ta.sched_travel_duration_uom
1628: ) travel_time
1629: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1630: , jtf_task_assignments ta
1631: , jtf_task_statuses_b ts
1632: , jtf_tasks_b t
1633: WHERE ta.object_capacity_id = oc.COLUMN_VALUE

Line 1747: l_del_trip_tbl := jtf_number_table();

1743: , l_api_name, fnd_log.level_statement);
1744: END LOOP;
1745: END IF;
1746:
1747: l_del_trip_tbl := jtf_number_table();
1748:
1749: -- Loop through each Shift to create a new Trip
1750: l_shift_idx := l_shifts.FIRST;
1751: WHILE l_shift_idx IS NOT NULL LOOP

Line 2149: l_dep_task_tbl jtf_number_table;

2145: ) IS
2146: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_TO_TRIPS';
2147: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2148:
2149: l_dep_task_tbl jtf_number_table;
2150: l_arr_task_tbl jtf_number_table;
2151: l_start_time_tbl jtf_date_table;
2152: l_end_time_tbl jtf_date_table;
2153: l_new_trip trip_rec_type;

Line 2150: l_arr_task_tbl jtf_number_table;

2146: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_TO_TRIPS';
2147: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2148:
2149: l_dep_task_tbl jtf_number_table;
2150: l_arr_task_tbl jtf_number_table;
2151: l_start_time_tbl jtf_date_table;
2152: l_end_time_tbl jtf_date_table;
2153: l_new_trip trip_rec_type;
2154:

Line 3260: l_resource_id_tbl jtf_number_table;

3256: l_resources_failed NUMBER;
3257: l_resources_success NUMBER;
3258: l_resource csf_resource_pub.resource_tbl_type;
3259: l_resource_info VARCHAR2(500);
3260: l_resource_id_tbl jtf_number_table;
3261: l_resource_type_tbl jtf_varchar2_table_100;
3262:
3263: CURSOR c_resources IS
3264: SELECT resource_id, resource_type

Line 3318: l_resource_id_tbl := jtf_number_table();

3314: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3315: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3316:
3317: l_resource_info := fnd_message.get;
3318: l_resource_id_tbl := jtf_number_table();
3319: l_resource_id_tbl.extend(1);
3320: l_resource_id_tbl(1) := p_resource_id;
3321:
3322: l_resource_type_tbl := jtf_varchar2_table_100();