APPS.CZ_LOOKUP_VALUES_PKG dependencies on CZ_LOOKUP_VALUES_TL

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 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 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