APPS.ZX_PARAMETERS_PKG dependencies on ZX_PARAMETERS_TL

Line 71: INSERT INTO zx_parameters_tl (

67: x_last_updated_by,
68: x_last_update_login
69: );
70:
71: INSERT INTO zx_parameters_tl (
72: tax_parameter_code,
73: tax_parameter_name,
74: creation_date,
75: created_by,

Line 96: FROM zx_parameters_tl t

92: FROM fnd_languages l
93: WHERE l.installed_flag IN ('I', 'B')
94: AND NOT EXISTS
95: (SELECT NULL
96: FROM zx_parameters_tl t
97: WHERE t.tax_parameter_code = x_tax_parameter_code
98: AND t.language = l.language_code);
99:
100: OPEN c;

Line 144: FROM zx_parameters_tl t, zx_parameters_b p

140:
141: BEGIN
142: SELECT decode (p.seeded_flag,'Y',1,0), t.last_update_date
143: INTO db_luby, db_ludate
144: FROM zx_parameters_tl t, zx_parameters_b p
145: WHERE t.tax_parameter_code = p.tax_parameter_code
146: AND t.tax_parameter_code = X_TAX_PARAMETER_CODE
147: AND t.language = userenv('LANG');
148:

Line 151: UPDATE zx_parameters_tl SET

147: AND t.language = userenv('LANG');
148:
149: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
150: db_ludate, x_custom_mode)) THEN
151: UPDATE zx_parameters_tl SET
152: tax_parameter_name = x_tax_parameter_name,
153: last_update_date = f_ludate,
154: last_updated_by = f_luby,
155: last_update_login = 0,

Line 262: delete from ZX_PARAMETERS_TL T

258:
259: procedure ADD_LANGUAGE
260: is
261: begin
262: delete from ZX_PARAMETERS_TL T
263: where not exists
264: (select NULL
265: from ZX_PARAMETERS_B B
266: where B.TAX_PARAMETER_CODE = T.TAX_PARAMETER_CODE

Line 269: update ZX_PARAMETERS_TL T set (

265: from ZX_PARAMETERS_B B
266: where B.TAX_PARAMETER_CODE = T.TAX_PARAMETER_CODE
267: );
268:
269: update ZX_PARAMETERS_TL T set (
270: TAX_PARAMETER_NAME
271: ) = (select
272: B.TAX_PARAMETER_NAME
273: from ZX_PARAMETERS_TL B

Line 273: from ZX_PARAMETERS_TL B

269: update ZX_PARAMETERS_TL T set (
270: TAX_PARAMETER_NAME
271: ) = (select
272: B.TAX_PARAMETER_NAME
273: from ZX_PARAMETERS_TL B
274: where B.TAX_PARAMETER_CODE = T.TAX_PARAMETER_CODE
275: and B.LANGUAGE = T.SOURCE_LANG)
276: where (
277: T.TAX_PARAMETER_CODE,

Line 282: from ZX_PARAMETERS_TL SUBB, ZX_PARAMETERS_TL SUBT

278: T.LANGUAGE
279: ) in (select
280: SUBT.TAX_PARAMETER_CODE,
281: SUBT.LANGUAGE
282: from ZX_PARAMETERS_TL SUBB, ZX_PARAMETERS_TL SUBT
283: where SUBB.TAX_PARAMETER_CODE = SUBT.TAX_PARAMETER_CODE
284: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
285: and (SUBB.TAX_PARAMETER_NAME <> SUBT.TAX_PARAMETER_NAME
286: ));

Line 288: insert into ZX_PARAMETERS_TL (

284: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
285: and (SUBB.TAX_PARAMETER_NAME <> SUBT.TAX_PARAMETER_NAME
286: ));
287:
288: insert into ZX_PARAMETERS_TL (
289: TAX_PARAMETER_CODE,
290: TAX_PARAMETER_NAME,
291: CREATION_DATE,
292: CREATED_BY,

Line 308: from ZX_PARAMETERS_TL B, FND_LANGUAGES L

304: B.LAST_UPDATED_BY,
305: B.LAST_UPDATE_LOGIN,
306: L.LANGUAGE_CODE,
307: B.SOURCE_LANG
308: from ZX_PARAMETERS_TL B, FND_LANGUAGES L
309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL

Line 313: from ZX_PARAMETERS_TL T

309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL
313: from ZX_PARAMETERS_TL T
314: where T.TAX_PARAMETER_CODE = B.TAX_PARAMETER_CODE
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317: end ZX_PARAMETERS_PKG;