The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure csp_update_location (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_commit IN VARCHAR2:= FND_API.G_FALSE,
x_location_id NUMBER,
x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
x_CITY VARCHAR2:= FND_API.G_FALSE,
x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
x_STATE VARCHAR2:= FND_API.G_FALSE,
x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
x_COUNTY VARCHAR2:= FND_API.G_FALSE,
x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
) Is
l_return_status VARCHAR2(1):='S';
l_last_update_date DATE := trunc(sysdate);
/* hz_location_pub.update_location (
p_api_version,
p_init_msg_list,
p_commit,
p_location_rec,
l_last_update_date,
l_return_status,
l_msg_count,
l_msg_data,
p_validation_level
);*/
hz_location_v2pub.update_location (p_init_msg_list,
p_location_rec,
p_object_version_number,
l_return_status,
l_msg_count,
l_msg_data);