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.CZ_LOOKUP_VALUES_PKG dependencies on CZ_LOOKUP_VALUES

Line 1: package body CZ_LOOKUP_VALUES_PKG as

1: package body CZ_LOOKUP_VALUES_PKG as
2: /* $Header: czilkvlb.pls 120.0 2005/05/25 05:51:13 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LIST_NAME in VARCHAR2,

Line 19: cursor C is select ROWID from CZ_LOOKUP_VALUES_TL

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from CZ_LOOKUP_VALUES_TL
20: where LIST_NAME = X_LIST_NAME
21: and DATA_VALUE = X_DATA_VALUE
22: and language = userenv('LANG');
23: begin

Line 24: insert into CZ_LOOKUP_VALUES_TL (

20: where LIST_NAME = X_LIST_NAME
21: and DATA_VALUE = X_DATA_VALUE
22: and language = userenv('LANG');
23: begin
24: insert into CZ_LOOKUP_VALUES_TL (
25: LIST_NAME,
26: DATA_VALUE,
27: NULL_VALUE_FLAG,
28: VALUE_LABEL,

Line 60: from CZ_LOOKUP_VALUES_TL T

56: from FND_LANGUAGES L
57: where L.INSTALLED_FLAG in ('I', 'B')
58: and not exists
59: (select NULL
60: from CZ_LOOKUP_VALUES_TL T
61: where T.LIST_NAME = X_LIST_NAME
62: and T.DATA_VALUE = X_DATA_VALUE);
63:
64: open c;

Line 103: update CZ_LOOKUP_VALUES_TL set

99: X_LAST_UPDATED_BY in NUMBER,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update CZ_LOOKUP_VALUES_TL set
104: LIST_NAME = X_LIST_NAME,
105: DATA_VALUE = X_DATA_VALUE,
106: NULL_VALUE_FLAG = X_NULL_VALUE_FLAG,
107: DELETED_FLAG = X_DELETED_FLAG,

Line 128: delete from CZ_LOOKUP_VALUES_TL

124: X_LIST_NAME in VARCHAR2,
125: X_DATA_VALUE in VARCHAR2
126: ) is
127: begin
128: delete from CZ_LOOKUP_VALUES_TL
129: where LIST_NAME = X_LIST_NAME
130: and DATA_VALUE = X_DATA_VALUE
131: and language = userenv('LANG');
132:

Line 143: insert into CZ_LOOKUP_VALUES_TL (

139: procedure ADD_LANGUAGE
140: is
141: begin
142:
143: insert into CZ_LOOKUP_VALUES_TL (
144: LIST_NAME,
145: DATA_VALUE,
146: NULL_VALUE_FLAG,
147: VALUE_LABEL,

Line 175: from CZ_LOOKUP_VALUES_TL B, FND_LANGUAGES L

171: B.DELETED_FLAG,
172: B.NUMERIC_ID_VALUE,
173: B.SEEDED_FLAG,
174: B.SOURCE_LANG
175: from CZ_LOOKUP_VALUES_TL B, FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and B.LANGUAGE = userenv('LANG')
178: and not exists
179: (select NULL

Line 180: from CZ_LOOKUP_VALUES_TL T

176: where L.INSTALLED_FLAG in ('I', 'B')
177: and B.LANGUAGE = userenv('LANG')
178: and not exists
179: (select NULL
180: from CZ_LOOKUP_VALUES_TL T
181: where T.LIST_NAME = B.LIST_NAME
182: and T.DATA_VALUE = B.DATA_VALUE
183: and T.LANGUAGE = L.LANGUAGE_CODE);
184: end ADD_LANGUAGE;

Line 213: UPDATE CZ_LOOKUP_VALUES_TL

209:
210: -- Translate owner to file_last_updated_by
211: f_luby := fnd_load_util.owner_id(X_OWNER);
212:
213: UPDATE CZ_LOOKUP_VALUES_TL
214: SET value_label = NVL(x_value_label, value_label)
215: , value_description = NVL(x_value_description, value_description)
216: , last_update_date = SYSDATE
217: , last_updated_by = f_luby

Line 239: s_lname cz_lookup_values.list_name%type; -- entity list_name

235: X_OWNER IN VARCHAR2,
236: X_LAST_UPDATE_DATE in VARCHAR2,
237: X_SEEDED_FLAG IN VARCHAR2)
238: IS
239: s_lname cz_lookup_values.list_name%type; -- entity list_name
240: s_dvalue cz_lookup_values.data_value%type; -- entity data_value
241: f_luby number; -- entity owner in file
242: f_ludate date; -- entity update date in file
243: db_luby number; -- entity owner in db

Line 240: s_dvalue cz_lookup_values.data_value%type; -- entity data_value

236: X_LAST_UPDATE_DATE in VARCHAR2,
237: X_SEEDED_FLAG IN VARCHAR2)
238: IS
239: s_lname cz_lookup_values.list_name%type; -- entity list_name
240: s_dvalue cz_lookup_values.data_value%type; -- entity data_value
241: f_luby number; -- entity owner in file
242: f_ludate date; -- entity update date in file
243: db_luby number; -- entity owner in db
244: db_ludate date; -- entity update date in db

Line 250: from cz_lookup_values_tl

246:
247:
248: cursor c_lvals is
249: select list_name, data_value
250: from cz_lookup_values_tl
251: where list_name = x_list_name
252: and data_value = x_data_value
253: and language = userenv('LANG');
254:

Line 268: CZ_LOOKUP_VALUES_PKG.INSERT_ROW(

264: fetch c_lvals into s_lname, s_dvalue;
265:
266: if (c_lvals%notfound) then
267: -- No matching rows
268: CZ_LOOKUP_VALUES_PKG.INSERT_ROW(
269: X_ROWID => row_id,
270: X_LIST_NAME => X_LIST_NAME,
271: X_DATA_VALUE => X_DATA_VALUE,
272: X_NULL_VALUE_FLAG => X_NULL_VALUE_FLAG,

Line 288: from cz_lookup_values_tl

284: else
285: loop
286: select LAST_UPDATED_BY, LAST_UPDATE_DATE
287: into db_luby, db_ludate
288: from cz_lookup_values_tl
289: where list_name = x_list_name
290: and data_value = x_data_value
291: and language = userenv('LANG');
292: -- Update row in all matching lookups

Line 293: CZ_LOOKUP_VALUES_PKG.UPDATE_ROW (

289: where list_name = x_list_name
290: and data_value = x_data_value
291: and language = userenv('LANG');
292: -- Update row in all matching lookups
293: CZ_LOOKUP_VALUES_PKG.UPDATE_ROW (
294: X_LIST_NAME => X_LIST_NAME,
295: X_DATA_VALUE => X_DATA_VALUE,
296: X_NULL_VALUE_FLAG => X_NULL_VALUE_FLAG,
297: X_DELETED_FLAG => X_DELETED_FLAG,

Line 314: end CZ_LOOKUP_VALUES_PKG;

310: close c_lvals;
311:
312: end LOAD_ROW;
313:
314: end CZ_LOOKUP_VALUES_PKG;