APPS.BOM_STRUCTURES_EXT_PKG dependencies on BOM_STRUCTURES_EXT_TL

Line 363: INSERT INTO BOM_STRUCTURES_EXT_TL (

359: X_LAST_UPDATED_BY,
360: X_LAST_UPDATE_LOGIN
361: );
362:
363: INSERT INTO BOM_STRUCTURES_EXT_TL (
364: EXTENSION_ID,
365: BILL_SEQUENCE_ID,
366: BILL_REVISION_ID,
367: STRUCTURE_TYPE_ID,

Line 477: FROM BOM_STRUCTURES_EXT_TL T

473: FROM FND_LANGUAGES L
474: WHERE L.INSTALLED_FLAG IN ('I', 'B')
475: AND NOT EXISTS
476: (SELECT NULL
477: FROM BOM_STRUCTURES_EXT_TL T
478: WHERE T.EXTENSION_ID = X_EXTENSION_ID
479: AND T.LANGUAGE = L.LANGUAGE_CODE);
480:
481: OPEN c;

Line 774: FROM BOM_STRUCTURES_EXT_TL

770: TL_EXT_ATTR38,
771: TL_EXT_ATTR39,
772: TL_EXT_ATTR40,
773: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
774: FROM BOM_STRUCTURES_EXT_TL
775: WHERE EXTENSION_ID = X_EXTENSION_ID
776: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
777: FOR UPDATE OF EXTENSION_ID NOWAIT;
778: BEGIN

Line 1325: UPDATE BOM_STRUCTURES_EXT_TL SET

1321: IF (SQL%NOTFOUND) THEN
1322: RAISE NO_DATA_FOUND;
1323: END IF;
1324:
1325: UPDATE BOM_STRUCTURES_EXT_TL SET
1326: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1327: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1328: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1329: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1382: DELETE FROM BOM_STRUCTURES_EXT_TL

1378: PROCEDURE DELETE_ROW (
1379: X_EXTENSION_ID IN NUMBER
1380: ) IS
1381: BEGIN
1382: DELETE FROM BOM_STRUCTURES_EXT_TL
1383: WHERE EXTENSION_ID = X_EXTENSION_ID;
1384:
1385: IF (SQL%NOTFOUND) THEN
1386: RAISE NO_DATA_FOUND;

Line 1400: DELETE FROM BOM_STRUCTURES_EXT_TL T

1396:
1397: PROCEDURE ADD_LANGUAGE
1398: IS
1399: BEGIN
1400: DELETE FROM BOM_STRUCTURES_EXT_TL T
1401: WHERE NOT EXISTS
1402: (SELECT NULL
1403: FROM BOM_STRUCTURES_EXT_B B
1404: WHERE B.EXTENSION_ID = T.EXTENSION_ID

Line 1407: UPDATE BOM_STRUCTURES_EXT_TL T SET (

1403: FROM BOM_STRUCTURES_EXT_B B
1404: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1405: );
1406:
1407: UPDATE BOM_STRUCTURES_EXT_TL T SET (
1408: TL_EXT_ATTR1,
1409: TL_EXT_ATTR2,
1410: TL_EXT_ATTR3,
1411: TL_EXT_ATTR4,

Line 1489: FROM BOM_STRUCTURES_EXT_TL B

1485: B.TL_EXT_ATTR37,
1486: B.TL_EXT_ATTR38,
1487: B.TL_EXT_ATTR39,
1488: B.TL_EXT_ATTR40
1489: FROM BOM_STRUCTURES_EXT_TL B
1490: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1491: AND B.LANGUAGE = T.SOURCE_LANG)
1492: WHERE (
1493: T.EXTENSION_ID,

Line 1498: FROM BOM_STRUCTURES_EXT_TL SUBB, BOM_STRUCTURES_EXT_TL SUBT

1494: T.LANGUAGE
1495: ) IN (SELECT
1496: SUBT.EXTENSION_ID,
1497: SUBT.LANGUAGE
1498: FROM BOM_STRUCTURES_EXT_TL SUBB, BOM_STRUCTURES_EXT_TL SUBT
1499: WHERE SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1500: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1501: AND (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1502: OR (SUBB.TL_EXT_ATTR1 IS NULL AND SUBT.TL_EXT_ATTR1 IS NOT NULL)

Line 1623: INSERT INTO BOM_STRUCTURES_EXT_TL (

1619: OR (SUBB.TL_EXT_ATTR40 IS NULL AND SUBT.TL_EXT_ATTR40 IS NOT NULL)
1620: OR (SUBB.TL_EXT_ATTR40 IS NOT NULL AND SUBT.TL_EXT_ATTR40 IS NULL)
1621: ));
1622:
1623: INSERT INTO BOM_STRUCTURES_EXT_TL (
1624: EXTENSION_ID,
1625: BILL_SEQUENCE_ID,
1626: BILL_REVISION_ID,
1627: STRUCTURE_TYPE_ID,

Line 1733: FROM BOM_STRUCTURES_EXT_TL B, FND_LANGUAGES L

1729: B.TL_EXT_ATTR39,
1730: B.TL_EXT_ATTR40,
1731: L.LANGUAGE_CODE,
1732: B.SOURCE_LANG
1733: FROM BOM_STRUCTURES_EXT_TL B, FND_LANGUAGES L
1734: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1735: AND B.LANGUAGE = USERENV('LANG')
1736: AND NOT EXISTS
1737: (SELECT NULL

Line 1738: FROM BOM_STRUCTURES_EXT_TL T

1734: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1735: AND B.LANGUAGE = USERENV('LANG')
1736: AND NOT EXISTS
1737: (SELECT NULL
1738: FROM BOM_STRUCTURES_EXT_TL T
1739: WHERE T.EXTENSION_ID = B.EXTENSION_ID
1740: AND T.LANGUAGE = L.LANGUAGE_CODE);
1741: END ADD_LANGUAGE;
1742: