APPS.MTH_PROD_SCH_EXT_PKG dependencies on MTH_PRODUCTION_SCHEDULE_EXT_TL

Line 281: insert into MTH_PRODUCTION_SCHEDULE_EXT_TL (

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

Line 367: from MTH_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_EXT_TL set

1020: if (sql%notfound) then
1021: raise no_data_found;
1022: end if;
1023:
1024: update MTH_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_EXT_TL

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

Line 1090: delete from MTH_PRODUCTION_SCHEDULE_EXT_TL T

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

Line 1097: update MTH_PRODUCTION_SCHEDULE_EXT_TL T set (

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

Line 1159: from MTH_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_EXT_TL SUBB, MTH_PRODUCTION_SCHEDULE_EXT_TL SUBT

1164: T.LANGUAGE
1165: ) in (select
1166: SUBT.EXTENSION_ID,
1167: SUBT.LANGUAGE
1168: from MTH_PRODUCTION_SCHEDULE_EXT_TL SUBB, MTH_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_EXT_TL (
1264: EXTENSION_ID,
1265: ATTR_GROUP_ID,
1266: WORKORDER_PK_KEY,
1267: TL_EXT_ATTR1,

Line 1345: from MTH_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_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_PRODUCTION_SCHEDULE_EXT_TL T
1351: where T.EXTENSION_ID = B.EXTENSION_ID
1352: and T.LANGUAGE = L.LANGUAGE_CODE);
1353: end ADD_LANGUAGE;
1354: