eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_WORD_REPLACEMENT_PUB SQL Statements

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

Line: 14


procedure do_update_word_replacement(
        p_word_replacement_rec           IN      WORD_REPLACEMENT_REC_TYPE,
        p_last_update_date               IN OUT  NOCOPY DATE,
	x_return_status                  IN OUT  NOCOPY VARCHAR2
);

Line: 22


        create_update_flag               IN      VARCHAR2,
        x_return_status                  IN OUT  NOCOPY VARCHAR2
);

Line: 156


 |              update_word_replacement                                      |
 |                                                                           |
 | DESCRIPTION                                                               |
 |              Updates word replacement.	                             |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_api_version                                          |
 |                    p_init_msg_list                                        |
 |                    p_commit                                               |
 |                    p_word_replacement_rec                                 |
 |                    p_last_update_date           	                     |
 |              OUT:                                                         |
 |                    x_return_status                                        |
 |                    x_msg_count                                            |
 |                    x_msg_data                                             |
 |          IN/ OUT:                                                         |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |    Indrajit Sen   14-JUN-00  Created                                      |
 |                                                                           |
 +===========================================================================*/

procedure update_word_replacement (
	p_api_version	IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2:=FND_API.G_FALSE,
	p_commit		IN	VARCHAR2:=FND_API.G_FALSE,
	p_word_replacement_rec	IN	WORD_REPLACEMENT_REC_TYPE,
	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:= FND_API.G_VALID_LEVEL_FULL
) IS
	l_api_name              CONSTANT VARCHAR2(30) := 'update_word_replacement';

Line: 204


        SAVEPOINT update_word_replacement_pub;

Line: 231


        do_update_word_replacement(
                        l_word_replacement_rec,
                        p_last_update_date,
			x_return_status);

Line: 249


                ROLLBACK TO update_word_replacement_pub;

Line: 257


                ROLLBACK TO update_word_replacement_pub;

Line: 265


                ROLLBACK TO update_word_replacement_pub;

Line: 324


	HZ_WORD_REPLACEMENTS_PKG.INSERT_ROW(
        X_Rowid => l_Rowid,
        X_ORIGINAL_WORD => p_word_replacement_rec.ORIGINAL_WORD,
        X_REPLACEMENT_WORD => p_word_replacement_rec.REPLACEMENT_WORD,
        X_TYPE => p_word_replacement_rec.TYPE,
        X_COUNTRY_CODE => p_word_replacement_rec.COUNTRY_CODE,
        X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
        X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
        X_CREATED_BY => hz_utility_pub.CREATED_BY,
        X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
        X_ATTRIBUTE_CATEGORY => p_word_replacement_rec.ATTRIBUTE_CATEGORY,
        X_ATTRIBUTE1 => p_word_replacement_rec.ATTRIBUTE1,
        X_ATTRIBUTE2 => p_word_replacement_rec.ATTRIBUTE2,
        X_ATTRIBUTE3 => p_word_replacement_rec.ATTRIBUTE3,
        X_ATTRIBUTE4 => p_word_replacement_rec.ATTRIBUTE4,
        X_ATTRIBUTE5 => p_word_replacement_rec.ATTRIBUTE5,
        X_ATTRIBUTE6 => p_word_replacement_rec.ATTRIBUTE6,
        X_ATTRIBUTE7 => p_word_replacement_rec.ATTRIBUTE7,
        X_ATTRIBUTE8 => p_word_replacement_rec.ATTRIBUTE8,
        X_ATTRIBUTE9 => p_word_replacement_rec.ATTRIBUTE9,
        X_ATTRIBUTE10 => p_word_replacement_rec.ATTRIBUTE10,
        X_ATTRIBUTE11 => p_word_replacement_rec.ATTRIBUTE11,
        X_ATTRIBUTE12 => p_word_replacement_rec.ATTRIBUTE12,
        X_ATTRIBUTE13 => p_word_replacement_rec.ATTRIBUTE13,
	X_ATTRIBUTE14 => p_word_replacement_rec.ATTRIBUTE14,
        X_ATTRIBUTE15 => p_word_replacement_rec.ATTRIBUTE15
	);

Line: 358


 |              do_update_word_replacement                                   |
 |                                                                           |
 | DESCRIPTION                                                               |
 |              Updates word replacement. 	                             |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_word_replacement_rec                                 |
 |                    p_last_update_date           	                     |
 |              OUT:                                                         |
 |          IN/ OUT:                                                         |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |    Indrajit Sen   14-JUN-00  Created                                      |
 |                                                                           |
 +===========================================================================*/

procedure do_update_word_replacement(
        p_word_replacement_rec         IN      WORD_REPLACEMENT_REC_TYPE,
        p_last_update_date             IN OUT  NOCOPY DATE,
	x_return_status		       IN OUT  NOCOPY VARCHAR2
) IS
        l_last_update_date              DATE;

Line: 392


  IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE THEN

        FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

Line: 396


        FND_MESSAGE.SET_TOKEN('COLUMN', 'word replacement last update date');

Line: 411


	p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

Line: 414


        select rowid INTO l_rowid FROM hz_word_replacements
        WHERE original_word = p_word_replacement_rec.original_word
        AND   type = p_word_replacement_rec.type;

Line: 420


	HZ_WORD_REPLACEMENTS_PKG.UPDATE_ROW(
        X_Rowid => l_Rowid,
        X_ORIGINAL_WORD => p_word_replacement_rec.ORIGINAL_WORD,
        X_REPLACEMENT_WORD => p_word_replacement_rec.REPLACEMENT_WORD,
        X_TYPE => p_word_replacement_rec.TYPE,
        X_COUNTRY_CODE => p_word_replacement_rec.COUNTRY_CODE,
	X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
        X_CREATION_DATE => FND_API.G_MISS_DATE,
        X_CREATED_BY => FND_API.G_MISS_NUM,
        X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
        X_ATTRIBUTE_CATEGORY => p_word_replacement_rec.ATTRIBUTE_CATEGORY,
        X_ATTRIBUTE1 => p_word_replacement_rec.ATTRIBUTE1,
        X_ATTRIBUTE2 => p_word_replacement_rec.ATTRIBUTE2,
        X_ATTRIBUTE3 => p_word_replacement_rec.ATTRIBUTE3,
        X_ATTRIBUTE4 => p_word_replacement_rec.ATTRIBUTE4,
        X_ATTRIBUTE5 => p_word_replacement_rec.ATTRIBUTE5,
        X_ATTRIBUTE6 => p_word_replacement_rec.ATTRIBUTE6,
        X_ATTRIBUTE7 => p_word_replacement_rec.ATTRIBUTE7,
        X_ATTRIBUTE8 => p_word_replacement_rec.ATTRIBUTE8,
        X_ATTRIBUTE9 => p_word_replacement_rec.ATTRIBUTE9,
        X_ATTRIBUTE10 => p_word_replacement_rec.ATTRIBUTE10,
        X_ATTRIBUTE11 => p_word_replacement_rec.ATTRIBUTE11,
        X_ATTRIBUTE12 => p_word_replacement_rec.ATTRIBUTE12,
        X_ATTRIBUTE13 => p_word_replacement_rec.ATTRIBUTE13,
        X_ATTRIBUTE14 => p_word_replacement_rec.ATTRIBUTE14,
        X_ATTRIBUTE15 => p_word_replacement_rec.ATTRIBUTE15
	);

Line: 460


 |                      non-updateable fields                                |
 |                      foreign key validations                              |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                      p_word_replacement_rec                               |
 |                      create_update_flag                                   |
 |              OUT:                                                         |
 |          IN/ OUT:                                                         |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |    Rashmi Goyal   02-SEP-99  Created                                      |
 |                                                                           |
 +===========================================================================*/

procedure validate_word_replacement(
        p_word_replacement_rec 	IN      word_replacement_rec_type,
        create_update_flag      IN      VARCHAR2,
	x_return_status		IN OUT	NOCOPY VARCHAR2
) IS
  CURSOR c_dup_rec (X_Original_Word IN VARCHAR2,
                    X_Type          IN VARCHAR2
                   )
  IS
    SELECT 1
    FROM   hz_word_replacements
    WHERE  original_word = X_Original_Word
    AND    type = X_Type;

Line: 500


  IF (create_update_flag = 'C' AND (p_word_replacement_rec.original_word = FND_API.G_MISS_CHAR OR
  p_word_replacement_rec.original_word IS NULL)) OR (create_update_flag = 'U' AND
  p_word_replacement_rec.original_word IS NULL) THEN
        FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

Line: 509


  IF (create_update_flag = 'C' AND (p_word_replacement_rec.type = FND_API.G_MISS_CHAR OR
  p_word_replacement_rec.type IS NULL)) OR (create_update_flag = 'U' AND
  p_word_replacement_rec.type IS NULL) THEN
        FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

Line: 520


  SELECT COUNT(*) INTO l_count
  FROM   ar_lookups
  WHERE  lookup_type = 'HZ_WORD_REPLACEMENT_TYPE'
  AND    lookup_code = p_word_replacement_rec.type;

Line: 537


      SELECT COUNT(*) INTO l_count
      FROM fnd_territories
      WHERE territory_code = p_word_replacement_rec.country_code;

Line: 552


    IF create_update_flag = 'C'
    THEN
      open c_dup_rec (p_word_replacement_rec.original_word, p_word_replacement_rec.type);

Line: 596


                LAST_UPDATE_DATE        DATE;

Line: 597


                LAST_UPDATED_BY         NUMBER;

Line: 600


                LAST_UPDATE_LOGIN       NUMBER;

Line: 604


  SELECT
   ORIGINAL_WORD,
   REPLACEMENT_WORD,
   TYPE,
   COUNTRY_CODE,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_LOGIN,
   ATTRIBUTE_CATEGORY,
   ATTRIBUTE1,
   ATTRIBUTE2,
   ATTRIBUTE3,
   ATTRIBUTE4,
   ATTRIBUTE5,
   ATTRIBUTE6,
   ATTRIBUTE7,
   ATTRIBUTE8,
   ATTRIBUTE9,
   ATTRIBUTE10,
   ATTRIBUTE11,
   ATTRIBUTE12,
   ATTRIBUTE13,
   ATTRIBUTE14,
   ATTRIBUTE15
  INTO
   x_word_replacement_rec.ORIGINAL_WORD,
   x_word_replacement_rec.REPLACEMENT_WORD,
   x_word_replacement_rec.TYPE,
   x_word_replacement_rec.COUNTRY_CODE,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_LOGIN,
   x_word_replacement_rec.ATTRIBUTE_CATEGORY,
   x_word_replacement_rec.ATTRIBUTE1,
   x_word_replacement_rec.ATTRIBUTE2,
   x_word_replacement_rec.ATTRIBUTE3,
   x_word_replacement_rec.ATTRIBUTE4,
   x_word_replacement_rec.ATTRIBUTE5,
   x_word_replacement_rec.ATTRIBUTE6,
   x_word_replacement_rec.ATTRIBUTE7,
   x_word_replacement_rec.ATTRIBUTE8,
   x_word_replacement_rec.ATTRIBUTE9,
   x_word_replacement_rec.ATTRIBUTE10,
   x_word_replacement_rec.ATTRIBUTE11,
   x_word_replacement_rec.ATTRIBUTE12,
   x_word_replacement_rec.ATTRIBUTE13,
   x_word_replacement_rec.ATTRIBUTE14,
   x_word_replacement_rec.ATTRIBUTE15
  FROM hz_word_replacements
  WHERE original_word = p_original_word
  AND   type = p_type;