APPS.MTH_OTHERS_EXT_PKG dependencies on MTH_OTHERS_EXT_TL

Line 280: insert into MTH_OTHERS_EXT_TL (

276: X_LAST_UPDATED_BY,
277: X_LAST_UPDATE_LOGIN
278: );
279:
280: insert into MTH_OTHERS_EXT_TL (
281: EXTENSION_ID,
282: ATTR_GROUP_ID,
283: OTHER_PK_KEY,
284: TL_EXT_ATTR1,

Line 366: from MTH_OTHERS_EXT_TL T

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

Line 595: from MTH_OTHERS_EXT_TL

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

Line 1023: update MTH_OTHERS_EXT_TL set

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

Line 1070: delete from MTH_OTHERS_EXT_TL

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

Line 1090: delete from MTH_OTHERS_EXT_TL T

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

Line 1097: update MTH_OTHERS_EXT_TL T set (

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

Line 1159: from MTH_OTHERS_EXT_TL B

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

Line 1168: from MTH_OTHERS_EXT_TL SUBB, MTH_OTHERS_EXT_TL SUBT

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

Line 1263: insert into MTH_OTHERS_EXT_TL (

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

Line 1345: from MTH_OTHERS_EXT_TL B, FND_LANGUAGES L

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

Line 1350: from MTH_OTHERS_EXT_TL T

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