APPS.MTH_EQUIPMENTS_EXT_PKG dependencies on MTH_EQUIPMENTS_EXT_TL

Line 298: insert into MTH_EQUIPMENTS_EXT_TL (

294: X_LAST_UPDATED_BY,
295: X_LAST_UPDATE_LOGIN
296: );
297:
298: insert into MTH_EQUIPMENTS_EXT_TL (
299: EXTENSION_ID,
300: ATTR_GROUP_ID,
301: EQUIPMENT_PK_KEY,
302: TL_EXT_ATTR1,

Line 384: from MTH_EQUIPMENTS_EXT_TL T

380: from FND_LANGUAGES L
381: where L.INSTALLED_FLAG in ('I', 'B')
382: and not exists
383: (select NULL
384: from MTH_EQUIPMENTS_EXT_TL T
385: where T.EXTENSION_ID = X_EXTENSION_ID
386: and T.LANGUAGE = L.LANGUAGE_CODE);
387:
388: open c;

Line 625: from MTH_EQUIPMENTS_EXT_TL

621: TL_EXT_ATTR28,
622: TL_EXT_ATTR29,
623: TL_EXT_ATTR30,
624: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
625: from MTH_EQUIPMENTS_EXT_TL
626: where EXTENSION_ID = X_EXTENSION_ID
627: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
628: for update of EXTENSION_ID nowait;
629: begin

Line 1077: update MTH_EQUIPMENTS_EXT_TL set

1073: if (sql%notfound) then
1074: raise no_data_found;
1075: end if;
1076:
1077: update MTH_EQUIPMENTS_EXT_TL set
1078: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1079: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1080: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1081: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1124: delete from MTH_EQUIPMENTS_EXT_TL

1120: procedure DELETE_ROW (
1121: X_EXTENSION_ID in NUMBER
1122: ) is
1123: begin
1124: delete from MTH_EQUIPMENTS_EXT_TL
1125: where EXTENSION_ID = X_EXTENSION_ID;
1126:
1127: if (sql%notfound) then
1128: raise no_data_found;

Line 1144: delete from MTH_EQUIPMENTS_EXT_TL T

1140:
1141: procedure ADD_LANGUAGE
1142: is
1143: begin
1144: delete from MTH_EQUIPMENTS_EXT_TL T
1145: where not exists
1146: (select NULL
1147: from MTH_EQUIPMENTS_EXT_B B
1148: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1151: update MTH_EQUIPMENTS_EXT_TL T set (

1147: from MTH_EQUIPMENTS_EXT_B B
1148: where B.EXTENSION_ID = T.EXTENSION_ID
1149: );
1150:
1151: update MTH_EQUIPMENTS_EXT_TL T set (
1152: TL_EXT_ATTR1,
1153: TL_EXT_ATTR2,
1154: TL_EXT_ATTR3,
1155: TL_EXT_ATTR4,

Line 1213: from MTH_EQUIPMENTS_EXT_TL B

1209: B.TL_EXT_ATTR27,
1210: B.TL_EXT_ATTR28,
1211: B.TL_EXT_ATTR29,
1212: B.TL_EXT_ATTR30
1213: from MTH_EQUIPMENTS_EXT_TL B
1214: where B.EXTENSION_ID = T.EXTENSION_ID
1215: and B.LANGUAGE = T.SOURCE_LANG)
1216: where (
1217: T.EXTENSION_ID,

Line 1222: from MTH_EQUIPMENTS_EXT_TL SUBB, MTH_EQUIPMENTS_EXT_TL SUBT

1218: T.LANGUAGE
1219: ) in (select
1220: SUBT.EXTENSION_ID,
1221: SUBT.LANGUAGE
1222: from MTH_EQUIPMENTS_EXT_TL SUBB, MTH_EQUIPMENTS_EXT_TL SUBT
1223: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1225: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1226: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1317: insert into MTH_EQUIPMENTS_EXT_TL (

1313: or (SUBB.TL_EXT_ATTR30 is null and SUBT.TL_EXT_ATTR30 is not null)
1314: or (SUBB.TL_EXT_ATTR30 is not null and SUBT.TL_EXT_ATTR30 is null)
1315: ));
1316:
1317: insert into MTH_EQUIPMENTS_EXT_TL (
1318: EXTENSION_ID,
1319: ATTR_GROUP_ID,
1320: EQUIPMENT_PK_KEY,
1321: TL_EXT_ATTR1,

Line 1399: from MTH_EQUIPMENTS_EXT_TL B, FND_LANGUAGES L

1395: B.CREATED_BY,
1396: B.CREATION_DATE,
1397: L.LANGUAGE_CODE,
1398: B.SOURCE_LANG
1399: from MTH_EQUIPMENTS_EXT_TL B, FND_LANGUAGES L
1400: where L.INSTALLED_FLAG in ('I', 'B')
1401: and B.LANGUAGE = userenv('LANG')
1402: and not exists
1403: (select NULL

Line 1404: from MTH_EQUIPMENTS_EXT_TL T

1400: where L.INSTALLED_FLAG in ('I', 'B')
1401: and B.LANGUAGE = userenv('LANG')
1402: and not exists
1403: (select NULL
1404: from MTH_EQUIPMENTS_EXT_TL T
1405: where T.EXTENSION_ID = B.EXTENSION_ID
1406: and T.LANGUAGE = L.LANGUAGE_CODE);
1407: end ADD_LANGUAGE;
1408: