APPS.CS_SR_CUST_CONT_MAINT_PVT SQL Statements

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

Line: 187

/* 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: 246

 PROCEDURE Update_Address (
   p_address_rec       IN	             ADDRESS_REC_TYPE,
   p_do_addr_val       IN      VARCHAR2,  -- 12.1.2 Address Validation
   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,
   x_addr_val_status     OUT    NOCOPY VARCHAR2, -- 12.1.2 Address Validation
   x_addr_warn_msg       OUT    NOCOPY VARCHAR2) Is -- 12.1.2 Address Validation

   l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line: 299

     HZ_LOCATION_V2PUB.update_location (
        p_init_msg_list          => FND_API.G_FALSE,
        p_location_rec           => l_location_rec,
	p_do_addr_val       => p_do_addr_val,  -- 12.1.2 Address Validation
        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,
	x_addr_val_status        => l_addr_val_status,  -- 12.1.2 Address Validation
	x_addr_warn_msg          => l_addr_warn_msg); -- 12.1.2 Address Validation

Line: 316

 End Update_Address;