APPS.CSP_LOCATION_PKG SQL Statements

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

Line: 76

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';

Line: 103

    l_last_update_date DATE := trunc(sysdate);

Line: 121

 /* 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
);*/

Line: 132

 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);