APPS.BOM_COMPONENTS_EXT_PKG dependencies on BOM_COMPONENTS_EXT_TL

Line 357: INSERT INTO BOM_COMPONENTS_EXT_TL (

353: X_LAST_UPDATED_BY,
354: X_LAST_UPDATE_LOGIN
355: );
356:
357: INSERT INTO BOM_COMPONENTS_EXT_TL (
358: EXTENSION_ID,
359: COMPONENT_SEQUENCE_ID,
360: STRUCTURE_TYPE_ID,
361: ATTR_GROUP_ID,

Line 467: FROM BOM_COMPONENTS_EXT_TL T

463: FROM FND_LANGUAGES L
464: WHERE L.INSTALLED_FLAG IN ('I', 'B')
465: AND NOT EXISTS
466: (SELECT NULL
467: FROM BOM_COMPONENTS_EXT_TL T
468: WHERE T.EXTENSION_ID = X_EXTENSION_ID
469: AND T.LANGUAGE = L.LANGUAGE_CODE);
470:
471: OPEN c;

Line 760: FROM BOM_COMPONENTS_EXT_TL

756: TL_EXT_ATTR38,
757: TL_EXT_ATTR39,
758: TL_EXT_ATTR40,
759: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
760: FROM BOM_COMPONENTS_EXT_TL
761: WHERE EXTENSION_ID = X_EXTENSION_ID
762: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
763: FOR UPDATE OF EXTENSION_ID NOWAIT;
764: BEGIN

Line 1303: UPDATE BOM_COMPONENTS_EXT_TL SET

1299: IF (SQL%NOTFOUND) THEN
1300: RAISE NO_DATA_FOUND;
1301: END IF;
1302:
1303: UPDATE BOM_COMPONENTS_EXT_TL SET
1304: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1305: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1306: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1307: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1360: DELETE FROM BOM_COMPONENTS_EXT_TL

1356: PROCEDURE DELETE_ROW (
1357: X_EXTENSION_ID IN NUMBER
1358: ) IS
1359: BEGIN
1360: DELETE FROM BOM_COMPONENTS_EXT_TL
1361: WHERE EXTENSION_ID = X_EXTENSION_ID;
1362:
1363: IF (SQL%NOTFOUND) THEN
1364: RAISE NO_DATA_FOUND;

Line 1378: DELETE FROM BOM_COMPONENTS_EXT_TL T

1374:
1375: PROCEDURE ADD_LANGUAGE
1376: IS
1377: BEGIN
1378: DELETE FROM BOM_COMPONENTS_EXT_TL T
1379: WHERE NOT EXISTS
1380: (SELECT NULL
1381: FROM BOM_COMPONENTS_EXT_B B
1382: WHERE B.EXTENSION_ID = T.EXTENSION_ID

Line 1385: UPDATE BOM_COMPONENTS_EXT_TL T SET (

1381: FROM BOM_COMPONENTS_EXT_B B
1382: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1383: );
1384:
1385: UPDATE BOM_COMPONENTS_EXT_TL T SET (
1386: TL_EXT_ATTR1,
1387: TL_EXT_ATTR2,
1388: TL_EXT_ATTR3,
1389: TL_EXT_ATTR4,

Line 1467: FROM BOM_COMPONENTS_EXT_TL B

1463: B.TL_EXT_ATTR37,
1464: B.TL_EXT_ATTR38,
1465: B.TL_EXT_ATTR39,
1466: B.TL_EXT_ATTR40
1467: FROM BOM_COMPONENTS_EXT_TL B
1468: WHERE B.EXTENSION_ID = T.EXTENSION_ID
1469: AND B.LANGUAGE = T.SOURCE_LANG)
1470: WHERE (
1471: T.EXTENSION_ID,

Line 1476: FROM BOM_COMPONENTS_EXT_TL SUBB, BOM_COMPONENTS_EXT_TL SUBT

1472: T.LANGUAGE
1473: ) IN (SELECT
1474: SUBT.EXTENSION_ID,
1475: SUBT.LANGUAGE
1476: FROM BOM_COMPONENTS_EXT_TL SUBB, BOM_COMPONENTS_EXT_TL SUBT
1477: WHERE SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1478: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1479: AND (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1480: OR (SUBB.TL_EXT_ATTR1 IS NULL AND SUBT.TL_EXT_ATTR1 IS NOT NULL)

Line 1601: INSERT INTO BOM_COMPONENTS_EXT_TL (

1597: OR (SUBB.TL_EXT_ATTR40 IS NULL AND SUBT.TL_EXT_ATTR40 IS NOT NULL)
1598: OR (SUBB.TL_EXT_ATTR40 IS NOT NULL AND SUBT.TL_EXT_ATTR40 IS NULL)
1599: ));
1600:
1601: INSERT INTO BOM_COMPONENTS_EXT_TL (
1602: EXTENSION_ID,
1603: COMPONENT_SEQUENCE_ID,
1604: STRUCTURE_TYPE_ID,
1605: ATTR_GROUP_ID,

Line 1707: FROM BOM_COMPONENTS_EXT_TL B, FND_LANGUAGES L

1703: B.TL_EXT_ATTR40,
1704: B.BILL_SEQUENCE_ID,
1705: L.LANGUAGE_CODE,
1706: B.SOURCE_LANG
1707: FROM BOM_COMPONENTS_EXT_TL B, FND_LANGUAGES L
1708: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1709: AND B.LANGUAGE = USERENV('LANG')
1710: AND NOT EXISTS
1711: (SELECT NULL

Line 1712: FROM BOM_COMPONENTS_EXT_TL T

1708: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1709: AND B.LANGUAGE = USERENV('LANG')
1710: AND NOT EXISTS
1711: (SELECT NULL
1712: FROM BOM_COMPONENTS_EXT_TL T
1713: WHERE T.EXTENSION_ID = B.EXTENSION_ID
1714: AND T.LANGUAGE = L.LANGUAGE_CODE);
1715: END ADD_LANGUAGE;
1716: