APPS.MTH_PROD_SEGMENTS_EXT_PKG dependencies on MTH_PRODUCTION_SEGMENTS_EXT_TL

Line 292: insert into MTH_PRODUCTION_SEGMENTS_EXT_TL (

288: X_LAST_UPDATED_BY,
289: X_LAST_UPDATE_LOGIN
290: );
291:
292: insert into MTH_PRODUCTION_SEGMENTS_EXT_TL (
293: EXTENSION_ID,
294: ATTR_GROUP_ID,
295: SEGMENT_PK_KEY,
296: TL_EXT_ATTR1,

Line 378: from MTH_PRODUCTION_SEGMENTS_EXT_TL T

374: from FND_LANGUAGES L
375: where L.INSTALLED_FLAG in ('I', 'B')
376: and not exists
377: (select NULL
378: from MTH_PRODUCTION_SEGMENTS_EXT_TL T
379: where T.EXTENSION_ID = X_EXTENSION_ID
380: and T.LANGUAGE = L.LANGUAGE_CODE);
381:
382: open c;

Line 615: from MTH_PRODUCTION_SEGMENTS_EXT_TL

611: TL_EXT_ATTR28,
612: TL_EXT_ATTR29,
613: TL_EXT_ATTR30,
614: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
615: from MTH_PRODUCTION_SEGMENTS_EXT_TL
616: where EXTENSION_ID = X_EXTENSION_ID
617: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
618: for update of EXTENSION_ID nowait;
619: begin

Line 1059: update MTH_PRODUCTION_SEGMENTS_EXT_TL set

1055: if (sql%notfound) then
1056: raise no_data_found;
1057: end if;
1058:
1059: update MTH_PRODUCTION_SEGMENTS_EXT_TL set
1060: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1061: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1062: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1063: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1106: delete from MTH_PRODUCTION_SEGMENTS_EXT_TL

1102: procedure DELETE_ROW (
1103: X_EXTENSION_ID in NUMBER
1104: ) is
1105: begin
1106: delete from MTH_PRODUCTION_SEGMENTS_EXT_TL
1107: where EXTENSION_ID = X_EXTENSION_ID;
1108:
1109: if (sql%notfound) then
1110: raise no_data_found;

Line 1126: delete from MTH_PRODUCTION_SEGMENTS_EXT_TL T

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

Line 1133: update MTH_PRODUCTION_SEGMENTS_EXT_TL T set (

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

Line 1195: from MTH_PRODUCTION_SEGMENTS_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_PRODUCTION_SEGMENTS_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_PRODUCTION_SEGMENTS_EXT_TL SUBB, MTH_PRODUCTION_SEGMENTS_EXT_TL SUBT

1200: T.LANGUAGE
1201: ) in (select
1202: SUBT.EXTENSION_ID,
1203: SUBT.LANGUAGE
1204: from MTH_PRODUCTION_SEGMENTS_EXT_TL SUBB, MTH_PRODUCTION_SEGMENTS_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_PRODUCTION_SEGMENTS_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_PRODUCTION_SEGMENTS_EXT_TL (
1300: EXTENSION_ID,
1301: ATTR_GROUP_ID,
1302: SEGMENT_PK_KEY,
1303: TL_EXT_ATTR1,

Line 1381: from MTH_PRODUCTION_SEGMENTS_EXT_TL B, FND_LANGUAGES L

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

Line 1386: from MTH_PRODUCTION_SEGMENTS_EXT_TL T

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