APPS.ZX_EVENT_CLASSES_PKG dependencies on ZX_EVENT_CLASSES_TL

Line 59: INSERT INTO zx_event_classes_tl (

55: x_last_updated_by,
56: x_last_update_login
57: );
58:
59: INSERT INTO zx_event_classes_tl (
60: tax_event_class_code,
61: tax_event_class_name,
62: creation_date,
63: created_by,

Line 84: FROM zx_event_classes_tl cls

80: FROM fnd_languages l
81: WHERE l.installed_flag IN ('I', 'B')
82: AND NOT EXISTS
83: (SELECT null
84: FROM zx_event_classes_tl cls
85: WHERE cls.tax_event_class_code = x_tax_event_class_code
86: AND cls.language = l.language_code);
87:
88: OPEN c;

Line 131: FROM zx_event_classes_tl

127:
128: BEGIN
129: SELECT decode (last_updated_by,1,1,0), last_update_date
130: INTO db_luby, db_ludate
131: FROM zx_event_classes_tl
132: WHERE tax_event_class_code = x_tax_event_class_code
133: AND language = userenv('LANG');
134:
135: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 137: UPDATE zx_event_classes_tl SET

133: AND language = userenv('LANG');
134:
135: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
136: db_ludate, x_custom_mode)) THEN
137: UPDATE zx_event_classes_tl SET
138: tax_event_class_name = x_tax_event_class_name,
139: last_update_date = f_ludate,
140: last_updated_by = f_luby,
141: last_update_login = 0,

Line 155: 'Insert into ZX_EVENT_CLASSES_TL (-)');

151:
152: IF (g_level_procedure >= g_current_runtime_level ) THEN
153: FND_LOG.STRING(g_level_procedure,
154: 'ZX_EVENT_CLASSES_PKG.Translate_row',
155: 'Insert into ZX_EVENT_CLASSES_TL (-)');
156: END IF;
157: END translate_row;
158:
159:

Line 229: DELETE FROM zx_event_classes_tl T

225:
226: PROCEDURE add_language
227: IS
228: BEGIN
229: DELETE FROM zx_event_classes_tl T
230: WHERE NOT EXISTS
231: (SELECT null
232: FROM ZX_EVENT_CLASSES_B B
233: WHERE B.tax_event_class_code = T.tax_event_class_code

Line 236: UPDATE ZX_EVENT_CLASSES_TL T SET (

232: FROM ZX_EVENT_CLASSES_B B
233: WHERE B.tax_event_class_code = T.tax_event_class_code
234: );
235:
236: UPDATE ZX_EVENT_CLASSES_TL T SET (
237: TAX_EVENT_CLASS_NAME
238: ) = (select
239: B.TAX_EVENT_CLASS_NAME
240: from ZX_EVENT_CLASSES_TL B

Line 240: from ZX_EVENT_CLASSES_TL B

236: UPDATE ZX_EVENT_CLASSES_TL T SET (
237: TAX_EVENT_CLASS_NAME
238: ) = (select
239: B.TAX_EVENT_CLASS_NAME
240: from ZX_EVENT_CLASSES_TL B
241: where B.TAX_EVENT_CLASS_CODE = T.TAX_EVENT_CLASS_CODE
242: and B.LANGUAGE = T.SOURCE_LANG)
243: where (
244: T.TAX_EVENT_CLASS_CODE,

Line 249: from ZX_EVENT_CLASSES_TL SUBB, ZX_EVENT_CLASSES_TL SUBT

245: T.LANGUAGE
246: ) in (select
247: SUBT.TAX_EVENT_CLASS_CODE,
248: SUBT.LANGUAGE
249: from ZX_EVENT_CLASSES_TL SUBB, ZX_EVENT_CLASSES_TL SUBT
250: where SUBB.TAX_EVENT_CLASS_CODE = SUBT.TAX_EVENT_CLASS_CODE
251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.TAX_EVENT_CLASS_NAME <> SUBT.TAX_EVENT_CLASS_NAME
253: ));

Line 255: insert into ZX_EVENT_CLASSES_TL (

251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.TAX_EVENT_CLASS_NAME <> SUBT.TAX_EVENT_CLASS_NAME
253: ));
254:
255: insert into ZX_EVENT_CLASSES_TL (
256: TAX_EVENT_CLASS_CODE,
257: TAX_EVENT_CLASS_NAME,
258: CREATION_DATE,
259: CREATED_BY,

Line 275: from ZX_EVENT_CLASSES_TL B, FND_LANGUAGES L

271: B.LAST_UPDATED_BY,
272: B.LAST_UPDATE_LOGIN,
273: L.LANGUAGE_CODE,
274: B.SOURCE_LANG
275: from ZX_EVENT_CLASSES_TL B, FND_LANGUAGES L
276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL

Line 280: from ZX_EVENT_CLASSES_TL T

276: where L.INSTALLED_FLAG in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select NULL
280: from ZX_EVENT_CLASSES_TL T
281: where T.TAX_EVENT_CLASS_CODE = B.TAX_EVENT_CLASS_CODE
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end add_language;
284: