APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ORDER_TYPES_TL

Line 1017: insert into ENG_CHANGE_ORDER_TYPES_TL (

1013: X_XML_DATA_SOURCE_CODE,
1014: X_TYPE_INTERNAL_NAME
1015: );
1016:
1017: insert into ENG_CHANGE_ORDER_TYPES_TL (
1018: CHANGE_ORDER_TYPE_ID,
1019: TYPE_NAME,
1020: DESCRIPTION,
1021: TAB_TEXT,

Line 1045: from ENG_CHANGE_ORDER_TYPES_TL T

1041: from FND_LANGUAGES L
1042: where L.INSTALLED_FLAG in ('I', 'B')
1043: and not exists
1044: (select NULL
1045: from ENG_CHANGE_ORDER_TYPES_TL T
1046: where T.CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1047: and T.LANGUAGE = L.LANGUAGE_CODE);
1048:
1049: open c;

Line 1242: from ENG_CHANGE_ORDER_TYPES_TL

1238: TYPE_NAME,
1239: DESCRIPTION,
1240: TAB_TEXT,
1241: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1242: from ENG_CHANGE_ORDER_TYPES_TL
1243: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1244: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1245: for update of CHANGE_ORDER_TYPE_ID nowait;
1246: begin

Line 1459: update ENG_CHANGE_ORDER_TYPES_TL set

1455: if (sql%notfound) then
1456: raise no_data_found;
1457: end if;
1458:
1459: update ENG_CHANGE_ORDER_TYPES_TL set
1460: TYPE_NAME = X_TYPE_NAME,
1461: DESCRIPTION = X_DESCRIPTION,
1462: TAB_TEXT = X_TAB_TEXT,
1463: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 1479: delete from ENG_CHANGE_ORDER_TYPES_TL

1475: procedure DELETE_ROW (
1476: X_CHANGE_ORDER_TYPE_ID in NUMBER
1477: ) is
1478: begin
1479: delete from ENG_CHANGE_ORDER_TYPES_TL
1480: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1481:
1482: if (sql%notfound) then
1483: raise no_data_found;

Line 1497: delete from ENG_CHANGE_ORDER_TYPES_TL T

1493:
1494: procedure ADD_LANGUAGE
1495: is
1496: begin
1497: delete from ENG_CHANGE_ORDER_TYPES_TL T
1498: where not exists
1499: (select NULL
1500: from ENG_CHANGE_ORDER_TYPES B
1501: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID

Line 1504: update ENG_CHANGE_ORDER_TYPES_TL T set (

1500: from ENG_CHANGE_ORDER_TYPES B
1501: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1502: );
1503:
1504: update ENG_CHANGE_ORDER_TYPES_TL T set (
1505: TYPE_NAME,
1506: DESCRIPTION,
1507: TAB_TEXT
1508: ) = (select

Line 1512: from ENG_CHANGE_ORDER_TYPES_TL B

1508: ) = (select
1509: B.TYPE_NAME,
1510: B.DESCRIPTION,
1511: B.TAB_TEXT
1512: from ENG_CHANGE_ORDER_TYPES_TL B
1513: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1514: and B.LANGUAGE = T.SOURCE_LANG)
1515: where (
1516: T.CHANGE_ORDER_TYPE_ID,

Line 1521: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT

1517: T.LANGUAGE
1518: ) in (select
1519: SUBT.CHANGE_ORDER_TYPE_ID,
1520: SUBT.LANGUAGE
1521: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT
1522: where SUBB.CHANGE_ORDER_TYPE_ID = SUBT.CHANGE_ORDER_TYPE_ID
1523: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1524: and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
1525: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1533: insert into ENG_CHANGE_ORDER_TYPES_TL (

1529: or (SUBB.TAB_TEXT is null and SUBT.TAB_TEXT is not null)
1530: or (SUBB.TAB_TEXT is not null and SUBT.TAB_TEXT is null)
1531: ));
1532:
1533: insert into ENG_CHANGE_ORDER_TYPES_TL (
1534: CHANGE_ORDER_TYPE_ID,
1535: TYPE_NAME,
1536: DESCRIPTION,
1537: TAB_TEXT,

Line 1557: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L

1553: B.LAST_UPDATED_BY,
1554: B.LAST_UPDATE_LOGIN,
1555: L.LANGUAGE_CODE,
1556: B.SOURCE_LANG
1557: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L
1558: where L.INSTALLED_FLAG in ('I', 'B')
1559: and B.LANGUAGE = userenv('LANG')
1560: and not exists
1561: (select NULL

Line 1562: from ENG_CHANGE_ORDER_TYPES_TL T

1558: where L.INSTALLED_FLAG in ('I', 'B')
1559: and B.LANGUAGE = userenv('LANG')
1560: and not exists
1561: (select NULL
1562: from ENG_CHANGE_ORDER_TYPES_TL T
1563: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1564: and T.LANGUAGE = L.LANGUAGE_CODE);
1565: end ADD_LANGUAGE;
1566: