DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_RESOURCE_ADDRESS_PVT

Line 44: , address csf_resource_address_pvt.address_rec_type

40: resource_id NUMBER
41: , resource_type jtf_objects_b.object_code%TYPE
42: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
43: , resource_number jtf_rs_resource_extns.resource_number%TYPE
44: , address csf_resource_address_pvt.address_rec_type
45: );
46:
47: /**
48: * PLSQL Index By Table Type to contain information about many Resources

Line 742: l_address csf_resource_address_pvt.address_rec_type;

738: l_res_dist_tbl csf_resource_tbl;
739: i PLS_INTEGER;
740: j PLS_INTEGER;
741: l_pref_res_cnt PLS_INTEGER;
742: l_address csf_resource_address_pvt.address_rec_type;
743: l_geometry MDSYS.SDO_GEOMETRY;
744: l_task_lat NUMBER;
745: l_task_lon NUMBER;
746: l_res_lat NUMBER;

Line 1697: csf_resource_address_pvt.get_resource_address(

1693: IF l_res_cache_info.address.party_site_id IS NULL
1694: OR TRUNC(p_date) < l_res_cache_info.address.start_date_active
1695: OR TRUNC(p_date) > NVL(l_res_cache_info.address.end_date_active, p_date + 1)
1696: THEN
1697: csf_resource_address_pvt.get_resource_address(
1698: p_api_version => 1.0
1699: , x_return_status => l_return_status
1700: , x_msg_count => l_msg_count
1701: , x_msg_data => l_msg_data

Line 1775: RETURN csf_resource_address_pvt.address_rec_type IS

1771: p_res_id NUMBER
1772: , p_res_type VARCHAR2
1773: , p_date DATE
1774: )
1775: RETURN csf_resource_address_pvt.address_rec_type IS
1776: BEGIN
1777: RETURN get_resource_from_cache(p_res_id, p_res_type, TRUE, p_date).address;
1778: END get_resource_party_address;
1779: