DBA Data[Home] [Help]

APPS.ZX_SIM_RULES_PKG dependencies on ZX_SIM_RULES_TL

Line 346: delete from ZX_SIM_RULES_TL T

342: procedure ADD_LANGUAGE
343: is
344: begin
345:
346: delete from ZX_SIM_RULES_TL T
347: where not exists
348: (select NULL
349: from ZX_SIM_RULES_B B
350: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID);

Line 351: update ZX_SIM_RULES_TL T set (

347: where not exists
348: (select NULL
349: from ZX_SIM_RULES_B B
350: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID);
351: update ZX_SIM_RULES_TL T set (
352: TAX_RULE_NAME
353: ) = (select B.TAX_RULE_NAME
354: from ZX_SIM_RULES_TL B
355: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID

Line 354: from ZX_SIM_RULES_TL B

350: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID);
351: update ZX_SIM_RULES_TL T set (
352: TAX_RULE_NAME
353: ) = (select B.TAX_RULE_NAME
354: from ZX_SIM_RULES_TL B
355: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (T.SIM_TAX_RULE_ID, T.LANGUAGE) in
358: (select SUBT.SIM_TAX_RULE_ID,

Line 360: from ZX_SIM_RULES_TL SUBB, ZX_SIM_RULES_TL SUBT

356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (T.SIM_TAX_RULE_ID, T.LANGUAGE) in
358: (select SUBT.SIM_TAX_RULE_ID,
359: SUBT.LANGUAGE
360: from ZX_SIM_RULES_TL SUBB, ZX_SIM_RULES_TL SUBT
361: where SUBB.SIM_TAX_RULE_ID = SUBT.SIM_TAX_RULE_ID
362: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
363: and (SUBB.TAX_RULE_NAME <> SUBT.TAX_RULE_NAME
364: ));

Line 366: insert into ZX_SIM_RULES_TL (

362: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
363: and (SUBB.TAX_RULE_NAME <> SUBT.TAX_RULE_NAME
364: ));
365:
366: insert into ZX_SIM_RULES_TL (
367: SIM_TAX_RULE_ID,
368: TAX_RULE_NAME,
369: CREATION_DATE,
370: CREATED_BY,

Line 386: from ZX_SIM_RULES_TL B, FND_LANGUAGES L

382: B.LAST_UPDATED_BY,
383: B.LAST_UPDATE_LOGIN,
384: L.LANGUAGE_CODE,
385: B.SOURCE_LANG
386: from ZX_SIM_RULES_TL B, FND_LANGUAGES L
387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL

Line 391: from ZX_SIM_RULES_TL T

387: where L.INSTALLED_FLAG in ('I', 'B')
388: and B.LANGUAGE = userenv('LANG')
389: and not exists
390: (select NULL
391: from ZX_SIM_RULES_TL T
392: where T.SIM_TAX_RULE_ID = B.SIM_TAX_RULE_ID
393: and T.LANGUAGE = L.LANGUAGE_CODE);
394:
395: EXCEPTION