APPS.HZ_WORD_LISTS_PKG dependencies on HZ_WORD_LISTS

Line 1: PACKAGE BODY HZ_WORD_LISTS_PKG AS

1: PACKAGE BODY HZ_WORD_LISTS_PKG AS
2: /* $Header: ARHDQWLB.pls 120.5 2005/06/16 21:11:22 jhuang noship $ */
3: PROCEDURE Insert_Row(
4: X_WORD_LIST_ID IN OUT NOCOPY NUMBER,
5: X_WORD_LIST_NAME VARCHAR2,

Line 23: FROM hz_word_lists

19: IF x_WORD_LIST_ID IS NOT NULL THEN
20: x_msg_count := 0;
21: /* Word List should be unique */
22: SELECT count(*) INTO l_count
23: FROM hz_word_lists
24: WHERE word_list_name = UPPER(X_WORD_LIST_NAME);
25:
26: IF l_count > 0 THEN
27: x_msg_count := x_msg_count +1;

Line 60: CURSOR C2 IS SELECT HZ_WORD_LISTS_s.nextval FROM sys.dual;

56: X_LAST_UPDATED_BY NUMBER,
57: X_OBJECT_VERSION_NUMBER NUMBER,
58: X_NON_DELIMITED_FLAG VARCHAR2 DEFAULT 'N')
59: IS
60: CURSOR C2 IS SELECT HZ_WORD_LISTS_s.nextval FROM sys.dual;
61: BEGIN
62: IF ( X_WORD_LIST_ID IS NULL) OR (X_WORD_LIST_ID = FND_API.G_MISS_NUM) THEN
63: OPEN C2;
64: FETCH C2 INTO X_WORD_LIST_ID;

Line 68: INSERT INTO HZ_WORD_LISTS(

64: FETCH C2 INTO X_WORD_LIST_ID;
65: CLOSE C2;
66: END IF;
67:
68: INSERT INTO HZ_WORD_LISTS(
69: WORD_LIST_ID,
70: WORD_LIST_NAME,
71: LANGUAGE,
72: SOURCE_NAME,

Line 126: FROM hz_word_lists

122: IF x_WORD_LIST_ID IS NOT NULL THEN
123: x_msg_count := 0;
124: /* Word List should be unique */
125: SELECT count(*) INTO l_count
126: FROM hz_word_lists
127: WHERE word_list_name = UPPER(x_WORD_LIST_name)
128: AND WORD_LIST_ID <> X_WORD_LIST_ID;
129:
130: IF l_count > 0 THEN

Line 171: UPDATE HZ_WORD_LISTS

167:
168: p_object_version_number := NVL(X_object_version_number, 1) + 1;
169:
170:
171: UPDATE HZ_WORD_LISTS
172: SET
173: WORD_LIST_NAME = decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, WORD_LIST_NAME,
174: UPPER(X_WORD_LIST_NAME)),
175: LANGUAGE = decode(X_LANGUAGE , FND_API.G_MISS_CHAR , LANGUAGE,

Line 211: DELETE FROM HZ_WORD_LISTS

207: BEGIN
208: --Delete all the word replacements
209: HZ_WORD_REPLACEMENTS1_PKG.Delete_Row(X_WORD_LIST_ID); --Bug No: 3868758.
210:
211: DELETE FROM HZ_WORD_LISTS
212: WHERE WORD_LIST_ID = X_WORD_LIST_ID;
213:
214: If (SQL%NOTFOUND) then
215: RAISE NO_DATA_FOUND;

Line 225: FROM HZ_WORD_LISTS

221: X_OBJECT_VERSION_NUMBER IN NUMBER)
222: IS
223: CURSOR C IS
224: SELECT OBJECT_VERSION_NUMBER
225: FROM HZ_WORD_LISTS
226: WHERE WORD_LIST_ID = X_WORD_LIST_ID
227: FOR UPDATE OF word_list_id NOWAIT;
228: Recinfo C%ROWTYPE;
229: BEGIN

Line 251: END HZ_WORD_LISTS_PKG;

247: app_exception.raise_exception;
248: end if;
249:
250: END Lock_Row;
251: END HZ_WORD_LISTS_PKG;