APPS.CS_SR_CUST_CONT_MAINT_PVT SQL Statements

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

Line: 181

/* wh_update_date is addded in the record. This is used as last update date  in
 Update address proc. Fix for bug #1567159 */

   l_location_rec.address1 := p_address_rec.address1;

Line: 234

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

   l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line: 280

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

Line: 292

 End Update_Address;