APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ORDER_TYPES_TL

Line 1054: insert into ENG_CHANGE_ORDER_TYPES_TL (

1050: X_XML_DATA_SOURCE_CODE,
1051: X_TYPE_INTERNAL_NAME
1052: );
1053:
1054: insert into ENG_CHANGE_ORDER_TYPES_TL (
1055: CHANGE_ORDER_TYPE_ID,
1056: TYPE_NAME,
1057: DESCRIPTION,
1058: TAB_TEXT,

Line 1082: from ENG_CHANGE_ORDER_TYPES_TL T

1078: from FND_LANGUAGES L
1079: where L.INSTALLED_FLAG in ('I', 'B')
1080: and not exists
1081: (select NULL
1082: from ENG_CHANGE_ORDER_TYPES_TL T
1083: where T.CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1084: and T.LANGUAGE = L.LANGUAGE_CODE);
1085:
1086: open c;

Line 1279: from ENG_CHANGE_ORDER_TYPES_TL

1275: TYPE_NAME,
1276: DESCRIPTION,
1277: TAB_TEXT,
1278: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1279: from ENG_CHANGE_ORDER_TYPES_TL
1280: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID
1281: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1282: for update of CHANGE_ORDER_TYPE_ID nowait;
1283: begin

Line 1496: update ENG_CHANGE_ORDER_TYPES_TL set

1492: if (sql%notfound) then
1493: raise no_data_found;
1494: end if;
1495:
1496: update ENG_CHANGE_ORDER_TYPES_TL set
1497: TYPE_NAME = X_TYPE_NAME,
1498: DESCRIPTION = X_DESCRIPTION,
1499: TAB_TEXT = X_TAB_TEXT,
1500: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 1516: delete from ENG_CHANGE_ORDER_TYPES_TL

1512: procedure DELETE_ROW (
1513: X_CHANGE_ORDER_TYPE_ID in NUMBER
1514: ) is
1515: begin
1516: delete from ENG_CHANGE_ORDER_TYPES_TL
1517: where CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1518:
1519: if (sql%notfound) then
1520: raise no_data_found;

Line 1534: delete from ENG_CHANGE_ORDER_TYPES_TL T

1530:
1531: procedure ADD_LANGUAGE
1532: is
1533: begin
1534: delete from ENG_CHANGE_ORDER_TYPES_TL T
1535: where not exists
1536: (select NULL
1537: from ENG_CHANGE_ORDER_TYPES B
1538: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID

Line 1541: update ENG_CHANGE_ORDER_TYPES_TL T set (

1537: from ENG_CHANGE_ORDER_TYPES B
1538: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1539: );
1540:
1541: update ENG_CHANGE_ORDER_TYPES_TL T set (
1542: TYPE_NAME,
1543: DESCRIPTION,
1544: TAB_TEXT
1545: ) = (select

Line 1549: from ENG_CHANGE_ORDER_TYPES_TL B

1545: ) = (select
1546: B.TYPE_NAME,
1547: B.DESCRIPTION,
1548: B.TAB_TEXT
1549: from ENG_CHANGE_ORDER_TYPES_TL B
1550: where B.CHANGE_ORDER_TYPE_ID = T.CHANGE_ORDER_TYPE_ID
1551: and B.LANGUAGE = T.SOURCE_LANG)
1552: where (
1553: T.CHANGE_ORDER_TYPE_ID,

Line 1558: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT

1554: T.LANGUAGE
1555: ) in (select
1556: SUBT.CHANGE_ORDER_TYPE_ID,
1557: SUBT.LANGUAGE
1558: from ENG_CHANGE_ORDER_TYPES_TL SUBB, ENG_CHANGE_ORDER_TYPES_TL SUBT
1559: where SUBB.CHANGE_ORDER_TYPE_ID = SUBT.CHANGE_ORDER_TYPE_ID
1560: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1561: and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
1562: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1570: insert into ENG_CHANGE_ORDER_TYPES_TL (

1566: or (SUBB.TAB_TEXT is null and SUBT.TAB_TEXT is not null)
1567: or (SUBB.TAB_TEXT is not null and SUBT.TAB_TEXT is null)
1568: ));
1569:
1570: insert into ENG_CHANGE_ORDER_TYPES_TL (
1571: CHANGE_ORDER_TYPE_ID,
1572: TYPE_NAME,
1573: DESCRIPTION,
1574: TAB_TEXT,

Line 1594: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L

1590: B.LAST_UPDATED_BY,
1591: B.LAST_UPDATE_LOGIN,
1592: L.LANGUAGE_CODE,
1593: B.SOURCE_LANG
1594: from ENG_CHANGE_ORDER_TYPES_TL B, FND_LANGUAGES L
1595: where L.INSTALLED_FLAG in ('I', 'B')
1596: and B.LANGUAGE = userenv('LANG')
1597: and not exists
1598: (select NULL

Line 1599: from ENG_CHANGE_ORDER_TYPES_TL T

1595: where L.INSTALLED_FLAG in ('I', 'B')
1596: and B.LANGUAGE = userenv('LANG')
1597: and not exists
1598: (select NULL
1599: from ENG_CHANGE_ORDER_TYPES_TL T
1600: where T.CHANGE_ORDER_TYPE_ID = B.CHANGE_ORDER_TYPE_ID
1601: and T.LANGUAGE = L.LANGUAGE_CODE);
1602: end ADD_LANGUAGE;
1603: