APPS.MTH_ITEMS_EXT_PKG dependencies on MTH_ITEMS_EXT_TL

Line 281: insert into MTH_ITEMS_EXT_TL (

277: X_LAST_UPDATED_BY,
278: X_LAST_UPDATE_LOGIN
279: );
280:
281: insert into MTH_ITEMS_EXT_TL (
282: EXTENSION_ID,
283: ATTR_GROUP_ID,
284: ITEM_PK_KEY,
285: TL_EXT_ATTR1,

Line 367: from MTH_ITEMS_EXT_TL T

363: from FND_LANGUAGES L
364: where L.INSTALLED_FLAG in ('I', 'B')
365: and not exists
366: (select NULL
367: from MTH_ITEMS_EXT_TL T
368: where T.EXTENSION_ID = X_EXTENSION_ID
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370:
371: open c;

Line 596: from MTH_ITEMS_EXT_TL

592: TL_EXT_ATTR28,
593: TL_EXT_ATTR29,
594: TL_EXT_ATTR30,
595: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
596: from MTH_ITEMS_EXT_TL
597: where EXTENSION_ID = X_EXTENSION_ID
598: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
599: for update of EXTENSION_ID nowait;
600: begin

Line 1024: update MTH_ITEMS_EXT_TL set

1020: if (sql%notfound) then
1021: raise no_data_found;
1022: end if;
1023:
1024: update MTH_ITEMS_EXT_TL set
1025: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1026: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1027: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1028: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1071: delete from MTH_ITEMS_EXT_TL

1067: procedure DELETE_ROW (
1068: X_EXTENSION_ID in NUMBER
1069: ) is
1070: begin
1071: delete from MTH_ITEMS_EXT_TL
1072: where EXTENSION_ID = X_EXTENSION_ID;
1073:
1074: if (sql%notfound) then
1075: raise no_data_found;

Line 1091: delete from MTH_ITEMS_EXT_TL T

1087:
1088: procedure ADD_LANGUAGE
1089: is
1090: begin
1091: delete from MTH_ITEMS_EXT_TL T
1092: where not exists
1093: (select NULL
1094: from MTH_ITEMS_EXT_B B
1095: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1098: update MTH_ITEMS_EXT_TL T set (

1094: from MTH_ITEMS_EXT_B B
1095: where B.EXTENSION_ID = T.EXTENSION_ID
1096: );
1097:
1098: update MTH_ITEMS_EXT_TL T set (
1099: TL_EXT_ATTR1,
1100: TL_EXT_ATTR2,
1101: TL_EXT_ATTR3,
1102: TL_EXT_ATTR4,

Line 1160: from MTH_ITEMS_EXT_TL B

1156: B.TL_EXT_ATTR27,
1157: B.TL_EXT_ATTR28,
1158: B.TL_EXT_ATTR29,
1159: B.TL_EXT_ATTR30
1160: from MTH_ITEMS_EXT_TL B
1161: where B.EXTENSION_ID = T.EXTENSION_ID
1162: and B.LANGUAGE = T.SOURCE_LANG)
1163: where (
1164: T.EXTENSION_ID,

Line 1169: from MTH_ITEMS_EXT_TL SUBB, MTH_ITEMS_EXT_TL SUBT

1165: T.LANGUAGE
1166: ) in (select
1167: SUBT.EXTENSION_ID,
1168: SUBT.LANGUAGE
1169: from MTH_ITEMS_EXT_TL SUBB, MTH_ITEMS_EXT_TL SUBT
1170: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1171: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1172: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1173: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1264: insert into MTH_ITEMS_EXT_TL (

1260: or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
1261: or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
1262: ));
1263:
1264: insert into MTH_ITEMS_EXT_TL (
1265: EXTENSION_ID,
1266: ATTR_GROUP_ID,
1267: ITEM_PK_KEY,
1268: TL_EXT_ATTR1,

Line 1346: from MTH_ITEMS_EXT_TL B, FND_LANGUAGES L

1342: B.CREATED_BY,
1343: B.CREATION_DATE,
1344: L.LANGUAGE_CODE,
1345: B.SOURCE_LANG
1346: from MTH_ITEMS_EXT_TL B, FND_LANGUAGES L
1347: where L.INSTALLED_FLAG in ('I', 'B')
1348: and B.LANGUAGE = userenv('LANG')
1349: and not exists
1350: (select NULL

Line 1351: from MTH_ITEMS_EXT_TL T

1347: where L.INSTALLED_FLAG in ('I', 'B')
1348: and B.LANGUAGE = userenv('LANG')
1349: and not exists
1350: (select NULL
1351: from MTH_ITEMS_EXT_TL T
1352: where T.EXTENSION_ID = B.EXTENSION_ID
1353: and T.LANGUAGE = L.LANGUAGE_CODE);
1354: end ADD_LANGUAGE;
1355: