APPS.HZ_WORD_REPLACEMENT_PUB_W SQL Statements

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

Line: 77

procedure update_word_replacement (
	p_api_version	IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2,
	p_commit		IN	VARCHAR2,
        p_original_word         IN      VARCHAR2,
        p_replacement_word      IN      VARCHAR2,
        p_type                  IN      VARCHAR2,
        p_country_code          IN      VARCHAR2 DEFAULT 'US',
        p_attribute_category    IN      VARCHAR2,
        p_attribute1            IN      VARCHAR2,
        p_attribute2            IN      VARCHAR2,
        p_attribute3            IN      VARCHAR2,
        p_attribute4            IN      VARCHAR2,
        p_attribute5            IN      VARCHAR2,
        p_attribute6            IN      VARCHAR2,
        p_attribute7            IN      VARCHAR2,
        p_attribute8            IN      VARCHAR2,
        p_attribute9            IN      VARCHAR2,
        p_attribute10           IN      VARCHAR2,
        p_attribute11           IN      VARCHAR2,
        p_attribute12           IN      VARCHAR2,
        p_attribute13           IN      VARCHAR2,
        p_attribute14           IN      VARCHAR2,
        p_attribute15           IN      VARCHAR2,
	p_last_update_date	IN OUT	NOCOPY DATE,
        x_return_status		OUT	NOCOPY VARCHAR2,
        x_msg_count		OUT	NOCOPY NUMBER,
	x_msg_data		OUT	NOCOPY VARCHAR2,
        p_validation_level      IN      NUMBER
)
is
  l_word_replacement_rec   HZ_WORD_REPLACEMENT_PUB.WORD_REPLACEMENT_REC_TYPE;

Line: 109

  l_last_update_date       date;

Line: 134

  hz_word_replacement_pub.update_word_replacement (
            p_api_version => p_api_version,
            p_init_msg_list => p_init_msg_list,
            p_commit => p_commit,
            p_word_replacement_rec => l_word_replacement_rec,
            p_last_update_date => p_last_update_date,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data,
            p_validation_level => p_validation_level);

Line: 145

end update_word_replacement;