APPS.MTH_USER_ENTITIES_EXT_PKG dependencies on MTH_USER_ENTITIES_EXT_TL

Line 1126: delete from MTH_USER_ENTITIES_EXT_TL T

1122:
1123: procedure ADD_LANGUAGE
1124: is
1125: begin
1126: delete from MTH_USER_ENTITIES_EXT_TL T
1127: where not exists
1128: (select NULL
1129: from MTH_USER_ENTITIES_EXT_TL B
1130: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1129: from MTH_USER_ENTITIES_EXT_TL B

1125: begin
1126: delete from MTH_USER_ENTITIES_EXT_TL T
1127: where not exists
1128: (select NULL
1129: from MTH_USER_ENTITIES_EXT_TL B
1130: where B.EXTENSION_ID = T.EXTENSION_ID
1131: );
1132:
1133: update MTH_USER_ENTITIES_EXT_TL T set (

Line 1133: update MTH_USER_ENTITIES_EXT_TL T set (

1129: from MTH_USER_ENTITIES_EXT_TL B
1130: where B.EXTENSION_ID = T.EXTENSION_ID
1131: );
1132:
1133: update MTH_USER_ENTITIES_EXT_TL T set (
1134: TL_EXT_ATTR1,
1135: TL_EXT_ATTR2,
1136: TL_EXT_ATTR3,
1137: TL_EXT_ATTR4,

Line 1195: from MTH_USER_ENTITIES_EXT_TL B

1191: B.TL_EXT_ATTR27,
1192: B.TL_EXT_ATTR28,
1193: B.TL_EXT_ATTR29,
1194: B.TL_EXT_ATTR30
1195: from MTH_USER_ENTITIES_EXT_TL B
1196: where B.EXTENSION_ID = T.EXTENSION_ID
1197: and B.LANGUAGE = T.SOURCE_LANG)
1198: where (
1199: T.EXTENSION_ID,

Line 1204: from MTH_USER_ENTITIES_EXT_TL SUBB, MTH_USER_ENTITIES_EXT_TL SUBT

1200: T.LANGUAGE
1201: ) in (select
1202: SUBT.EXTENSION_ID,
1203: SUBT.LANGUAGE
1204: from MTH_USER_ENTITIES_EXT_TL SUBB, MTH_USER_ENTITIES_EXT_TL SUBT
1205: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1206: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1207: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1208: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1299: insert into MTH_USER_ENTITIES_EXT_TL (

1295: or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
1296: or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
1297: ));
1298:
1299: insert into MTH_USER_ENTITIES_EXT_TL (
1300: EXTENSION_ID,
1301: ATTR_GROUP_ID,
1302: ENTITY_PK_KEY,
1303: ENTITY_TYPE,

Line 1383: from MTH_USER_ENTITIES_EXT_TL B, FND_LANGUAGES L

1379: B.CREATED_BY,
1380: B.CREATION_DATE,
1381: L.LANGUAGE_CODE,
1382: B.SOURCE_LANG
1383: from MTH_USER_ENTITIES_EXT_TL B, FND_LANGUAGES L
1384: where L.INSTALLED_FLAG in ('I', 'B')
1385: and B.LANGUAGE = userenv('LANG')
1386: and not exists
1387: (select NULL

Line 1388: from MTH_USER_ENTITIES_EXT_TL T

1384: where L.INSTALLED_FLAG in ('I', 'B')
1385: and B.LANGUAGE = userenv('LANG')
1386: and not exists
1387: (select NULL
1388: from MTH_USER_ENTITIES_EXT_TL T
1389: where T.EXTENSION_ID = B.EXTENSION_ID
1390: and T.LANGUAGE = L.LANGUAGE_CODE);
1391: end ADD_LANGUAGE;
1392: