APPS.HZ_WORD_REPLACEMENTS_PKG dependencies on HZ_WORD_REPLACEMENTS

Line 1: PACKAGE BODY HZ_WORD_REPLACEMENTS_PKG as

1: PACKAGE BODY HZ_WORD_REPLACEMENTS_PKG as
2: /*$Header: ARHWRSTB.pls 120.4 2005/10/30 04:23:21 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 33: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS

29: x_ATTRIBUTE13 VARCHAR2,
30: x_ATTRIBUTE14 VARCHAR2,
31: x_ATTRIBUTE15 VARCHAR2
32: ) IS
33: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS
34: WHERE TYPE = x_TYPE
35: AND ORIGINAL_WORD = x_ORIGINAL_WORD;
36: BEGIN
37: INSERT INTO HZ_WORD_REPLACEMENTS(

Line 37: INSERT INTO HZ_WORD_REPLACEMENTS(

33: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS
34: WHERE TYPE = x_TYPE
35: AND ORIGINAL_WORD = x_ORIGINAL_WORD;
36: BEGIN
37: INSERT INTO HZ_WORD_REPLACEMENTS(
38: ORIGINAL_WORD,
39: REPLACEMENT_WORD,
40: TYPE,
41: COUNTRY_CODE,

Line 107: DELETE FROM HZ_WORD_REPLACEMENTS

103: x_TYPE VARCHAR2,
104: x_ORIGINAL_WORD VARCHAR2
105: ) IS
106: BEGIN
107: DELETE FROM HZ_WORD_REPLACEMENTS
108: WHERE type = x_TYPE
109: AND original_word = x_ORIGINAL_WORD;
110: If (SQL%NOTFOUND) then
111: RAISE NO_DATA_FOUND;

Line 146: Update HZ_WORD_REPLACEMENTS

142: x_ATTRIBUTE15 VARCHAR2
143: ) IS
144:
145: BEGIN
146: Update HZ_WORD_REPLACEMENTS
147: SET
148: ORIGINAL_WORD = decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, x_ORIGINAL_WORD),
149: REPLACEMENT_WORD = decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, x_REPLACEMENT_WORD),
150: TYPE = decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),

Line 216: FROM HZ_WORD_REPLACEMENTS

212: ) IS
213:
214: CURSOR C IS
215: SELECT *
216: FROM HZ_WORD_REPLACEMENTS
217: WHERE rowid = x_Rowid
218: FOR UPDATE of ORIGINAL_WORD NOWAIT;
219: Recinfo C%ROWTYPE;
220: BEGIN

Line 313: END HZ_WORD_REPLACEMENTS_PKG;

309: APP_EXCEPTION.RAISE_EXCEPTION;
310: End If;
311: END Lock_Row;
312:
313: END HZ_WORD_REPLACEMENTS_PKG;