APPS.CSF_RESOURCE_PUB dependencies on CSF_RESOURCE_ADDRESS_PVT

Line 49: , address csf_resource_address_pvt.address_rec_type

45: resource_id NUMBER
46: , resource_type jtf_objects_b.object_code%TYPE
47: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
48: , resource_number jtf_rs_resource_extns.resource_number%TYPE
49: , address csf_resource_address_pvt.address_rec_type
50: );
51:
52: /**
53: * PLSQL Index By Table Type to contain information about many Resources

Line 905: l_address csf_resource_address_pvt.address_rec_type;

901: l_res_dist_tbl csf_resource_tbl;
902: i PLS_INTEGER;
903: j PLS_INTEGER;
904: l_pref_res_cnt PLS_INTEGER;
905: l_address csf_resource_address_pvt.address_rec_type;
906: l_geometry MDSYS.SDO_GEOMETRY;
907: l_task_lat NUMBER;
908: l_task_lon NUMBER;
909: l_res_lat NUMBER;

Line 2237: csf_resource_address_pvt.get_resource_address(

2233: IF l_res_cache_info.address.party_site_id IS NULL
2234: OR TRUNC(p_date) < l_res_cache_info.address.start_date_active
2235: OR TRUNC(p_date) > NVL(l_res_cache_info.address.end_date_active, p_date + 1)
2236: THEN
2237: csf_resource_address_pvt.get_resource_address(
2238: p_api_version => 1.0
2239: , x_return_status => l_return_status
2240: , x_msg_count => l_msg_count
2241: , x_msg_data => l_msg_data

Line 2317: RETURN csf_resource_address_pvt.address_rec_type IS

2313: , p_res_type VARCHAR2
2314: , p_date DATE
2315: , p_res_shift_add VARCHAR2 DEFAULT NULL
2316: )
2317: RETURN csf_resource_address_pvt.address_rec_type IS
2318: BEGIN
2319: G_RES_ADD_PROF := p_res_shift_add;
2320:
2321: RETURN get_resource_from_cache(p_res_id, p_res_type, TRUE, p_date).address;

Line 2620: l_address csf_resource_address_pvt.address_rec_type;

2616: , x_address OUT NOCOPY VARCHAR2
2617: , x_device_tag OUT NOCOPY VARCHAR2
2618: , x_status_code_meaning OUT NOCOPY VARCHAR2
2619: ) IS
2620: l_address csf_resource_address_pvt.address_rec_type;
2621: l_geometry MDSYS.SDO_GEOMETRY;
2622: l_res_lat NUMBER;
2623: l_res_lon NUMBER;
2624: l_valid_geo VARCHAR2(5);