APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_LOCATION_V2PUB

Line 1844: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;

1840: x_return_status OUT NOCOPY VARCHAR2,
1841: x_msg_count OUT NOCOPY NUMBER,
1842: x_msg_data OUT NOCOPY VARCHAR2 )IS
1843:
1844: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1845: l_msg_count number;
1846: l_msg_data Varchar2(4000);
1847: l_return_status Varchar2(1);
1848: l_party_site_number VARCHAR2(360);

Line 2006: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;

2002: x_return_status OUT NOCOPY VARCHAR2,
2003: x_msg_count OUT NOCOPY NUMBER,
2004: x_msg_data OUT NOCOPY VARCHAR2 ) IS
2005:
2006: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
2007: l_msg_count number;
2008: l_msg_data Varchar2(4000);
2009: l_return_status Varchar2(1);
2010: l_party_site_number VARCHAR2(360);

Line 2178: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;

2174: SELECT party_site_id,location_id
2175: FROM hz_party_sites
2176: WHERE party_id = p_party_id;
2177:
2178: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
2179: l_return_status VARCHAR2(1);
2180: l_msg_count NUMBER;
2181: l_msg_data VARCHAR2(4000);
2182: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2200: HZ_LOCATION_V2PUB.get_location_rec(

2196: oe_debug_pub.add('Location_id :'||i.location_id);
2197: END IF;
2198:
2199:
2200: HZ_LOCATION_V2PUB.get_location_rec(
2201: p_init_msg_list => FND_API.G_TRUE,
2202: p_location_id => i.location_id,
2203: x_location_rec => l_location_rec,
2204: x_return_status => l_return_status,

Line 3128: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

3124: , x_return_status OUT NOCOPY VARCHAR2
3125: , x_msg_count OUT NOCOPY NUMBER
3126: , x_msg_data OUT NOCOPY VARCHAR2
3127: ) IS
3128: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
3129: l_location_id NUMBER;
3130: x_ver_number NUMBER;
3131: BEGIN
3132:

Line 3152: HZ_LOCATION_V2PUB.UPDATE_LOCATION (

3148: l_location_rec.country := p_address_rec.country;
3149:
3150: x_ver_number := Get_obj_version_number(p_location_id => l_location_id);
3151:
3152: HZ_LOCATION_V2PUB.UPDATE_LOCATION (
3153: p_init_msg_list => FND_API.G_TRUE,
3154: p_location_rec => l_location_rec,
3155: p_object_version_number => x_ver_number,
3156: x_return_status =>x_return_status,