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_TRIPS_PUB dependencies on CSF_RESOURCE_PUB

Line 103: l_resource_info csf_resource_pub.resource_rec_type;

99: END format_date;
100:
101: FUNCTION get_resource_info(p_resource_id NUMBER, p_resource_type VARCHAR2)
102: RETURN VARCHAR2 IS
103: l_resource_info csf_resource_pub.resource_rec_type;
104: BEGIN
105: l_resource_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
106:
107: RETURN l_resource_info.resource_name

Line 105: l_resource_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);

101: FUNCTION get_resource_info(p_resource_id NUMBER, p_resource_type VARCHAR2)
102: RETURN VARCHAR2 IS
103: l_resource_info csf_resource_pub.resource_rec_type;
104: BEGIN
105: l_resource_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
106:
107: RETURN l_resource_info.resource_name
108: || ' ('
109: || csf_resource_pub.get_resource_type_name(l_resource_info.resource_type)

Line 109: || csf_resource_pub.get_resource_type_name(l_resource_info.resource_type)

105: l_resource_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
106:
107: RETURN l_resource_info.resource_name
108: || ' ('
109: || csf_resource_pub.get_resource_type_name(l_resource_info.resource_type)
110: || ', '
111: || l_resource_info.resource_number
112: || ')';
113: END get_resource_info;

Line 115: FUNCTION time_overlaps(p_trip trip_rec_type, p_shift csf_resource_pub.shift_rec_type)

111: || l_resource_info.resource_number
112: || ')';
113: END get_resource_info;
114:
115: FUNCTION time_overlaps(p_trip trip_rec_type, p_shift csf_resource_pub.shift_rec_type)
116: RETURN BOOLEAN IS
117: BEGIN
118: RETURN p_trip.start_date_time < (p_shift.end_datetime + g_overtime)
119: AND (p_trip.end_date_time + g_overtime) > p_shift.start_datetime;

Line 176: , p_resource_tbl IN csf_resource_pub.resource_tbl_type

172: , p_action IN VARCHAR2
173: , p_trip_id IN NUMBER
174: , p_start_date IN DATE
175: , p_end_date IN DATE
176: , p_resource_tbl IN csf_resource_pub.resource_tbl_type
177: ) IS
178: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
179: l_success NUMBER;
180: l_failed NUMBER;

Line 262: l_res_name := csf_resource_pub.get_resource_name(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type);

258: FETCH c_action_name INTO l_action_name;
259: CLOSE c_action_name;
260:
261: IF p_resource_tbl.COUNT = 1 THEN
262: l_res_name := csf_resource_pub.get_resource_name(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type);
263: ELSE
264: l_res_name := '';
265: END IF;
266:

Line 343: p_resource_tbl IN csf_resource_pub.resource_tbl_type

339: END trip_has_active_tasks;
340:
341: -- Returns all the Trips which overlaps with the Passed Timings for the Resource
342: FUNCTION find_trips(
343: p_resource_tbl IN csf_resource_pub.resource_tbl_type
344: , p_start_date_time IN DATE
345: , p_end_date_time IN DATE
346: , p_overtime_flag IN VARCHAR2 DEFAULT NULL
347: ) RETURN trip_tbl_type IS

Line 448: l_address := csf_resource_pub.get_resource_party_address(

444: RETURN;
445: END IF;
446:
447: -- Get the Resource's Address for this Date
448: l_address := csf_resource_pub.get_resource_party_address(
449: p_res_id => p_resource_id
450: , p_res_type => p_resource_type
451: , p_date => p_start_date_time
452: );

Line 1570: , p_resource_tbl IN csf_resource_pub.resource_tbl_type

1566: PROCEDURE create_trips(
1567: x_return_status OUT NOCOPY VARCHAR2
1568: , x_msg_data OUT NOCOPY VARCHAR2
1569: , x_msg_count OUT NOCOPY NUMBER
1570: , p_resource_tbl IN csf_resource_pub.resource_tbl_type
1571: , p_start_date IN DATE
1572: , p_end_date IN DATE
1573: , p_delete_trips IN BOOLEAN DEFAULT FALSE
1574: ) IS

Line 1584: l_shifts csf_resource_pub.shift_tbl_type;

1580: l_res_type jtf_objects_b.object_code%TYPE;
1581: l_start DATE;
1582: l_end DATE;
1583:
1584: l_shifts csf_resource_pub.shift_tbl_type;
1585: l_shift_idx PLS_INTEGER;
1586:
1587: l_trip_idx PLS_INTEGER;
1588: l_new_trip trip_rec_type;

Line 1669: csf_resource_pub.get_resource_shifts(

1665: END IF;
1666: END IF;
1667:
1668: -- Get the Resource's Shifts
1669: csf_resource_pub.get_resource_shifts(
1670: p_api_version => 1.0
1671: , x_return_status => x_return_status
1672: , x_msg_count => x_msg_count
1673: , x_msg_data => x_msg_data

Line 2142: , p_resource_tbl IN csf_resource_pub.resource_tbl_type

2138: PROCEDURE upgrade_to_trips(
2139: x_return_status OUT NOCOPY VARCHAR2
2140: , x_msg_data OUT NOCOPY VARCHAR2
2141: , x_msg_count OUT NOCOPY NUMBER
2142: , p_resource_tbl IN csf_resource_pub.resource_tbl_type
2143: , p_start_date IN DATE
2144: , p_end_date IN DATE
2145: ) IS
2146: l_api_name CONSTANT VARCHAR2(30) := 'UPGRADE_TO_TRIPS';

Line 2382: l_resource csf_resource_pub.resource_tbl_type;

2378: l_api_version CONSTANT NUMBER := 1.0;
2379: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2380:
2381: l_trips trip_tbl_type;
2382: l_resource csf_resource_pub.resource_tbl_type;
2383: l_new_trip trip_rec_type;
2384:
2385: l_shift_tasks_exist VARCHAR2(1);
2386:

Line 2417: l_resource := csf_resource_pub.resource_tbl_type();

2413: || to_char(p_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' and '
2414: || to_char(p_end_date_time, 'DD-MON-YYYY HH24:MI:SS'), l_api_name, fnd_log.level_procedure);
2415: END IF;
2416:
2417: l_resource := csf_resource_pub.resource_tbl_type();
2418: l_resource.extend();
2419: l_resource(1).resource_id := p_resource_id;
2420: l_resource(1).resource_type := p_resource_type;
2421: l_trips := find_trips(l_resource, p_start_date_time, p_end_date_time);

Line 2870: l_resource_tbl csf_resource_pub.resource_tbl_type;

2866: ) IS
2867: l_api_name CONSTANT VARCHAR2(30) := 'FIND_TRIP';
2868: l_api_version CONSTANT NUMBER := 1.0;
2869: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
2870: l_resource_tbl csf_resource_pub.resource_tbl_type;
2871: l_trips trip_tbl_type;
2872: BEGIN
2873: -- Check for API Compatibility
2874: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2886: l_resource_tbl := csf_resource_pub.resource_tbl_type();

2882:
2883: -- Initialize Return Status
2884: x_return_status := fnd_api.g_ret_sts_success;
2885:
2886: l_resource_tbl := csf_resource_pub.resource_tbl_type();
2887: l_resource_tbl.extend();
2888: l_resource_tbl(1).resource_id := p_resource_id;
2889: l_resource_tbl(1).resource_type := p_resource_type;
2890:

Line 3000: , p_resource_tbl IN csf_resource_pub.resource_tbl_type

2996: , p_init_msg_list IN VARCHAR2
2997: , x_return_status OUT NOCOPY VARCHAR2
2998: , x_msg_data OUT NOCOPY VARCHAR2
2999: , x_msg_count OUT NOCOPY NUMBER
3000: , p_resource_tbl IN csf_resource_pub.resource_tbl_type
3001: , p_start_date_time IN DATE
3002: , p_end_date_time IN DATE
3003: , p_overtime_flag IN VARCHAR2
3004: , x_trips OUT NOCOPY trip_tbl_type

Line 3053: , p_resource_tbl IN csf_resource_pub.resource_tbl_type

3049: , x_msg_data OUT NOCOPY VARCHAR2
3050: , x_msg_count OUT NOCOPY NUMBER
3051: , p_action IN VARCHAR2
3052: , p_trip_id IN NUMBER
3053: , p_resource_tbl IN csf_resource_pub.resource_tbl_type
3054: , p_start_date IN DATE
3055: , p_end_date IN DATE
3056: ) IS
3057: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ACTION';

Line 3258: l_resource csf_resource_pub.resource_tbl_type;

3254: l_end_date DATE;
3255: l_num_days NUMBER;
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:

Line 3344: l_resource := csf_resource_pub.resource_tbl_type();

3340: /********************* Concurrent Program Execution *********************/
3341: l_resources_failed := 0;
3342: l_resources_success := 0;
3343: IF l_resource_id_tbl IS NOT NULL THEN
3344: l_resource := csf_resource_pub.resource_tbl_type();
3345: l_resource.extend(1);
3346:
3347: FOR i IN 1..l_resource_id_tbl.COUNT LOOP
3348: l_resource(1).resource_id := l_resource_id_tbl(i);