APPS.AST_PARTY_LOCATIONS_V2PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 107

 PROCEDURE Update_Address (
     p_address_rec           IN     AST_API_RECORDS_V2PKG.ADDRESS_REC_TYPE,
     p_object_version_number IN OUT NOCOPY NUMBER,
     x_msg_count                OUT NOCOPY NUMBER,
     x_msg_data                 OUT NOCOPY VARCHAR2,
     x_return_status            OUT NOCOPY VARCHAR2) Is

   l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line: 174

     HZ_LOCATION_V2PUB.update_location (
     p_init_msg_list         => FND_API.G_FALSE,
     p_location_rec          => l_location_rec,
     p_object_version_number => p_object_version_number,
     x_return_status         => l_return_status,
     x_msg_count             => l_msg_count,
     x_msg_data              => l_msg_data
	);

Line: 203

End Update_Address;