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_REPLACEMENTS1_PKG dependencies on HZ_WORD_REPLACEMENTS

Line 1: PACKAGE BODY HZ_WORD_REPLACEMENTS1_PKG as

1: PACKAGE BODY HZ_WORD_REPLACEMENTS1_PKG as
2: /*$Header: ARHDQWRB.pls 120.12 2006/06/29 13:45:06 rarajend noship $ */
3:
4: PROCEDURE Insert_Row(
5: x_Rowid IN OUT NOCOPY VARCHAR2,

Line 37: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS

33: x_msg_count IN OUT NOCOPY NUMBER,
34: x_condition_id NUMBER DEFAULT NULL,
35: x_user_spec_cond_value VARCHAR2 DEFAULT NULL
36: ) IS
37: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS
38: WHERE WORD_LIST_ID = x_WORD_LIST_ID
39: AND ORIGINAL_WORD = UPPER(x_ORIGINAL_WORD);
40: OAERR EXCEPTION;
41: l_count NUMBER;

Line 49: FROM hz_word_replacements

45: IF x_WORD_LIST_ID IS NOT NULL THEN
46: x_msg_count := 0;
47: /* Original Word is unique for a word list */
48: SELECT count(*) INTO l_count
49: FROM hz_word_replacements
50: WHERE word_list_id = x_WORD_LIST_ID
51: AND delete_flag = 'N'
52: AND original_word = UPPER(x_ORIGINAL_WORD)
53: AND (condition_id IS NULL

Line 73: FROM hz_word_replacements

69: FND_MSG_PUB.ADD;
70: END IF;
71: /* No Cyclic Pairs */
72: SELECT count(*) INTO l_count
73: FROM hz_word_replacements
74: WHERE word_list_id = x_WORD_LIST_ID
75: AND delete_flag = 'N'
76: AND (original_word = UPPER(x_REPLACEMENT_WORD) OR
77: replacement_word = UPPER(x_ORIGINAL_WORD));

Line 173: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS

169: x_object_version_number IN OUT NOCOPY NUMBER,
170: x_condition_id NUMBER DEFAULT NULL,
171: x_user_spec_cond_value VARCHAR2 DEFAULT NULL
172: ) IS
173: CURSOR C IS SELECT rowid FROM HZ_WORD_REPLACEMENTS
174: WHERE WORD_LIST_ID = x_WORD_LIST_ID
175: AND ORIGINAL_WORD = UPPER(x_ORIGINAL_WORD);
176:
177: BEGIN

Line 178: INSERT INTO HZ_WORD_REPLACEMENTS(

174: WHERE WORD_LIST_ID = x_WORD_LIST_ID
175: AND ORIGINAL_WORD = UPPER(x_ORIGINAL_WORD);
176:
177: BEGIN
178: INSERT INTO HZ_WORD_REPLACEMENTS(
179: WORD_LIST_ID,
180: ORIGINAL_WORD,
181: REPLACEMENT_WORD,
182: TYPE,

Line 259: DELETE FROM HZ_WORD_REPLACEMENTS

255: End Insert_Row;
256:
257: PROCEDURE Delete_Row(X_WORD_LIST_ID IN NUMBER) IS
258: BEGIN
259: DELETE FROM HZ_WORD_REPLACEMENTS
260: WHERE WORD_LIST_ID = X_WORD_LIST_ID;
261: END;
262:
263: PROCEDURE Delete_Row( x_WORD_LIST_ID IN NUMBER, X_ORIGINAL_WORD IN VARCHAR2,X_CONDITION_ID IN NUMBER,x_user_spec_cond_value IN VARCHAR2)

Line 265: CURSOR C IS SELECT STAGED_FLAG FROM HZ_WORD_REPLACEMENTS

261: END;
262:
263: PROCEDURE Delete_Row( x_WORD_LIST_ID IN NUMBER, X_ORIGINAL_WORD IN VARCHAR2,X_CONDITION_ID IN NUMBER,x_user_spec_cond_value IN VARCHAR2)
264: IS
265: CURSOR C IS SELECT STAGED_FLAG FROM HZ_WORD_REPLACEMENTS
266: WHERE WORD_LIST_ID = x_WORD_LIST_ID
267: AND ORIGINAL_WORD = x_ORIGINAL_WORD
268: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)
269: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)

Line 281: DELETE FROM HZ_WORD_REPLACEMENTS

277: RAISE NO_DATA_FOUND;
278: End If;*/
279: CLOSE C;
280: IF(l_staged_flag = 'N') then
281: DELETE FROM HZ_WORD_REPLACEMENTS
282: WHERE WORD_LIST_ID = x_WORD_LIST_ID
283: AND ORIGINAL_WORD = x_ORIGINAL_WORD
284: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)
285: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)

Line 289: UPDATE HZ_WORD_REPLACEMENTS

285: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)
286: AND DELETE_FLAG = 'N'
287: AND STAGED_FLAG = 'N';
288: ELSE
289: UPDATE HZ_WORD_REPLACEMENTS
290: SET DELETE_FLAG = 'Y'
291: WHERE WORD_LIST_ID = x_WORD_LIST_ID
292: AND ORIGINAL_WORD = x_ORIGINAL_WORD
293: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)

Line 352: FROM hz_word_replacements

348: END IF;
349:
350: /* Original Word is unique for a word list */
351: SELECT count(*) INTO l_count
352: FROM hz_word_replacements
353: WHERE word_list_id = x_WORD_LIST_ID
354: AND delete_flag = 'N'
355: AND original_word = UPPER(x_ORIGINAL_WORD)
356: AND (condition_id IS NULL

Line 378: FROM hz_word_replacements

374: END IF;
375:
376: /* No Cyclic Pairs */
377: SELECT count(*) INTO l_count
378: FROM hz_word_replacements
379: WHERE word_list_id = x_WORD_LIST_ID
380: AND delete_flag = 'N'
381: AND (original_word = UPPER(x_REPLACEMENT_WORD) OR
382: replacement_word = UPPER(x_ORIGINAL_WORD))

Line 467: Update HZ_WORD_REPLACEMENTS

463:
464: BEGIN
465: p_object_version_number := NVL(X_object_version_number, 1) + 1;
466:
467: Update HZ_WORD_REPLACEMENTS
468: SET
469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),

Line 518: FROM HZ_WORD_REPLACEMENTS

514: ) IS
515:
516: CURSOR C IS
517: SELECT object_version_number
518: FROM HZ_WORD_REPLACEMENTS
519: WHERE rowid = X_rowid
520: FOR UPDATE of ORIGINAL_WORD NOWAIT;
521: Recinfo C%ROWTYPE;
522: BEGIN

Line 546: END HZ_WORD_REPLACEMENTS1_PKG;

542: end if;
543:
544: END Lock_Row;
545:
546: END HZ_WORD_REPLACEMENTS1_PKG;