[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW (
X_ROWID IN OUT NOCOPY VARCHAR2,
X_EXTENSION_ID IN NUMBER,
X_N_EXT_ATTR14 IN NUMBER,
X_N_EXT_ATTR15 IN NUMBER,
X_N_EXT_ATTR16 IN NUMBER,
X_N_EXT_ATTR17 IN NUMBER,
X_N_EXT_ATTR18 IN NUMBER,
X_N_EXT_ATTR19 IN NUMBER,
X_N_EXT_ATTR20 IN NUMBER,
X_D_EXT_ATTR1 IN DATE,
X_D_EXT_ATTR2 IN DATE,
X_D_EXT_ATTR3 IN DATE,
X_D_EXT_ATTR4 IN DATE,
X_D_EXT_ATTR5 IN DATE,
X_D_EXT_ATTR6 IN DATE,
X_D_EXT_ATTR7 IN DATE,
X_D_EXT_ATTR8 IN DATE,
X_D_EXT_ATTR9 IN DATE,
X_D_EXT_ATTR10 IN DATE,
X_UOM_EXT_ATTR1 IN VARCHAR2,
X_UOM_EXT_ATTR2 IN VARCHAR2,
X_UOM_EXT_ATTR3 IN VARCHAR2,
X_UOM_EXT_ATTR4 IN VARCHAR2,
X_UOM_EXT_ATTR5 IN VARCHAR2,
X_UOM_EXT_ATTR6 IN VARCHAR2,
X_UOM_EXT_ATTR7 IN VARCHAR2,
X_UOM_EXT_ATTR8 IN VARCHAR2,
X_UOM_EXT_ATTR9 IN VARCHAR2,
X_UOM_EXT_ATTR10 IN VARCHAR2,
X_UOM_EXT_ATTR11 IN VARCHAR2,
X_UOM_EXT_ATTR12 IN VARCHAR2,
X_UOM_EXT_ATTR13 IN VARCHAR2,
X_UOM_EXT_ATTR14 IN VARCHAR2,
X_UOM_EXT_ATTR15 IN VARCHAR2,
X_UOM_EXT_ATTR16 IN VARCHAR2,
X_UOM_EXT_ATTR17 IN VARCHAR2,
X_UOM_EXT_ATTR18 IN VARCHAR2,
X_UOM_EXT_ATTR19 IN VARCHAR2,
X_UOM_EXT_ATTR20 IN VARCHAR2,
X_BILL_SEQUENCE_ID IN NUMBER,
X_COMPONENT_SEQUENCE_ID IN NUMBER,
X_STRUCTURE_TYPE_ID IN NUMBER,
X_ATTR_GROUP_ID IN NUMBER,
X_C_EXT_ATTR1 IN VARCHAR2,
X_C_EXT_ATTR2 IN VARCHAR2,
X_C_EXT_ATTR3 IN VARCHAR2,
X_C_EXT_ATTR4 IN VARCHAR2,
X_C_EXT_ATTR5 IN VARCHAR2,
X_C_EXT_ATTR6 IN VARCHAR2,
X_C_EXT_ATTR7 IN VARCHAR2,
X_C_EXT_ATTR8 IN VARCHAR2,
X_C_EXT_ATTR9 IN VARCHAR2,
X_C_EXT_ATTR10 IN VARCHAR2,
X_C_EXT_ATTR11 IN VARCHAR2,
X_C_EXT_ATTR12 IN VARCHAR2,
X_C_EXT_ATTR13 IN VARCHAR2,
X_C_EXT_ATTR14 IN VARCHAR2,
X_C_EXT_ATTR15 IN VARCHAR2,
X_C_EXT_ATTR16 IN VARCHAR2,
X_C_EXT_ATTR17 IN VARCHAR2,
X_C_EXT_ATTR18 IN VARCHAR2,
X_C_EXT_ATTR19 IN VARCHAR2,
X_C_EXT_ATTR20 IN VARCHAR2,
X_C_EXT_ATTR21 IN VARCHAR2,
X_C_EXT_ATTR22 IN VARCHAR2,
X_C_EXT_ATTR23 IN VARCHAR2,
X_C_EXT_ATTR24 IN VARCHAR2,
X_C_EXT_ATTR25 IN VARCHAR2,
X_C_EXT_ATTR26 IN VARCHAR2,
X_C_EXT_ATTR27 IN VARCHAR2,
X_C_EXT_ATTR28 IN VARCHAR2,
X_C_EXT_ATTR29 IN VARCHAR2,
X_C_EXT_ATTR30 IN VARCHAR2,
X_C_EXT_ATTR31 IN VARCHAR2,
X_C_EXT_ATTR32 IN VARCHAR2,
X_C_EXT_ATTR33 IN VARCHAR2,
X_C_EXT_ATTR34 IN VARCHAR2,
X_C_EXT_ATTR35 IN VARCHAR2,
X_C_EXT_ATTR36 IN VARCHAR2,
X_C_EXT_ATTR37 IN VARCHAR2,
X_C_EXT_ATTR38 IN VARCHAR2,
X_C_EXT_ATTR39 IN VARCHAR2,
X_C_EXT_ATTR40 IN VARCHAR2,
X_N_EXT_ATTR1 IN NUMBER,
X_N_EXT_ATTR2 IN NUMBER,
X_N_EXT_ATTR3 IN NUMBER,
X_N_EXT_ATTR4 IN NUMBER,
X_N_EXT_ATTR5 IN NUMBER,
X_N_EXT_ATTR6 IN NUMBER,
X_N_EXT_ATTR7 IN NUMBER,
X_N_EXT_ATTR8 IN NUMBER,
X_N_EXT_ATTR9 IN NUMBER,
X_N_EXT_ATTR10 IN NUMBER,
X_N_EXT_ATTR11 IN NUMBER,
X_N_EXT_ATTR12 IN NUMBER,
X_N_EXT_ATTR13 IN NUMBER,
X_TL_EXT_ATTR1 IN VARCHAR2,
X_TL_EXT_ATTR2 IN VARCHAR2,
X_TL_EXT_ATTR3 IN VARCHAR2,
X_TL_EXT_ATTR4 IN VARCHAR2,
X_TL_EXT_ATTR5 IN VARCHAR2,
X_TL_EXT_ATTR6 IN VARCHAR2,
X_TL_EXT_ATTR7 IN VARCHAR2,
X_TL_EXT_ATTR8 IN VARCHAR2,
X_TL_EXT_ATTR9 IN VARCHAR2,
X_TL_EXT_ATTR10 IN VARCHAR2,
X_TL_EXT_ATTR11 IN VARCHAR2,
X_TL_EXT_ATTR12 IN VARCHAR2,
X_TL_EXT_ATTR13 IN VARCHAR2,
X_TL_EXT_ATTR14 IN VARCHAR2,
X_TL_EXT_ATTR15 IN VARCHAR2,
X_TL_EXT_ATTR16 IN VARCHAR2,
X_TL_EXT_ATTR17 IN VARCHAR2,
X_TL_EXT_ATTR18 IN VARCHAR2,
X_TL_EXT_ATTR19 IN VARCHAR2,
X_TL_EXT_ATTR20 IN VARCHAR2,
X_TL_EXT_ATTR21 IN VARCHAR2,
X_TL_EXT_ATTR22 IN VARCHAR2,
X_TL_EXT_ATTR23 IN VARCHAR2,
X_TL_EXT_ATTR24 IN VARCHAR2,
X_TL_EXT_ATTR25 IN VARCHAR2,
X_TL_EXT_ATTR26 IN VARCHAR2,
X_TL_EXT_ATTR27 IN VARCHAR2,
X_TL_EXT_ATTR28 IN VARCHAR2,
X_TL_EXT_ATTR29 IN VARCHAR2,
X_TL_EXT_ATTR30 IN VARCHAR2,
X_TL_EXT_ATTR31 IN VARCHAR2,
X_TL_EXT_ATTR32 IN VARCHAR2,
X_TL_EXT_ATTR33 IN VARCHAR2,
X_TL_EXT_ATTR34 IN VARCHAR2,
X_TL_EXT_ATTR35 IN VARCHAR2,
X_TL_EXT_ATTR36 IN VARCHAR2,
X_TL_EXT_ATTR37 IN VARCHAR2,
X_TL_EXT_ATTR38 IN VARCHAR2,
X_TL_EXT_ATTR39 IN VARCHAR2,
X_TL_EXT_ATTR40 IN VARCHAR2,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER
) IS
CURSOR C IS SELECT ROWID FROM BOM_COMPONENTS_EXT_B
WHERE EXTENSION_ID = X_EXTENSION_ID
;
INSERT INTO BOM_COMPONENTS_EXT_B (
N_EXT_ATTR14,
N_EXT_ATTR15,
N_EXT_ATTR16,
N_EXT_ATTR17,
N_EXT_ATTR18,
N_EXT_ATTR19,
N_EXT_ATTR20,
D_EXT_ATTR1,
D_EXT_ATTR2,
D_EXT_ATTR3,
D_EXT_ATTR4,
D_EXT_ATTR5,
D_EXT_ATTR6,
D_EXT_ATTR7,
D_EXT_ATTR8,
D_EXT_ATTR9,
D_EXT_ATTR10,
UOM_EXT_ATTR1,
UOM_EXT_ATTR2,
UOM_EXT_ATTR3,
UOM_EXT_ATTR4,
UOM_EXT_ATTR5,
UOM_EXT_ATTR6,
UOM_EXT_ATTR7,
UOM_EXT_ATTR8,
UOM_EXT_ATTR9,
UOM_EXT_ATTR10,
UOM_EXT_ATTR11,
UOM_EXT_ATTR12,
UOM_EXT_ATTR13,
UOM_EXT_ATTR14,
UOM_EXT_ATTR15,
UOM_EXT_ATTR16,
UOM_EXT_ATTR17,
UOM_EXT_ATTR18,
UOM_EXT_ATTR19,
UOM_EXT_ATTR20,
BILL_SEQUENCE_ID,
EXTENSION_ID,
COMPONENT_SEQUENCE_ID,
STRUCTURE_TYPE_ID,
ATTR_GROUP_ID,
C_EXT_ATTR1,
C_EXT_ATTR2,
C_EXT_ATTR3,
C_EXT_ATTR4,
C_EXT_ATTR5,
C_EXT_ATTR6,
C_EXT_ATTR7,
C_EXT_ATTR8,
C_EXT_ATTR9,
C_EXT_ATTR10,
C_EXT_ATTR11,
C_EXT_ATTR12,
C_EXT_ATTR13,
C_EXT_ATTR14,
C_EXT_ATTR15,
C_EXT_ATTR16,
C_EXT_ATTR17,
C_EXT_ATTR18,
C_EXT_ATTR19,
C_EXT_ATTR20,
C_EXT_ATTR21,
C_EXT_ATTR22,
C_EXT_ATTR23,
C_EXT_ATTR24,
C_EXT_ATTR25,
C_EXT_ATTR26,
C_EXT_ATTR27,
C_EXT_ATTR28,
C_EXT_ATTR29,
C_EXT_ATTR30,
C_EXT_ATTR31,
C_EXT_ATTR32,
C_EXT_ATTR33,
C_EXT_ATTR34,
C_EXT_ATTR35,
C_EXT_ATTR36,
C_EXT_ATTR37,
C_EXT_ATTR38,
C_EXT_ATTR39,
C_EXT_ATTR40,
N_EXT_ATTR1,
N_EXT_ATTR2,
N_EXT_ATTR3,
N_EXT_ATTR4,
N_EXT_ATTR5,
N_EXT_ATTR6,
N_EXT_ATTR7,
N_EXT_ATTR8,
N_EXT_ATTR9,
N_EXT_ATTR10,
N_EXT_ATTR11,
N_EXT_ATTR12,
N_EXT_ATTR13,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) VALUES (
X_N_EXT_ATTR14,
X_N_EXT_ATTR15,
X_N_EXT_ATTR16,
X_N_EXT_ATTR17,
X_N_EXT_ATTR18,
X_N_EXT_ATTR19,
X_N_EXT_ATTR20,
X_D_EXT_ATTR1,
X_D_EXT_ATTR2,
X_D_EXT_ATTR3,
X_D_EXT_ATTR4,
X_D_EXT_ATTR5,
X_D_EXT_ATTR6,
X_D_EXT_ATTR7,
X_D_EXT_ATTR8,
X_D_EXT_ATTR9,
X_D_EXT_ATTR10,
X_UOM_EXT_ATTR1,
X_UOM_EXT_ATTR2,
X_UOM_EXT_ATTR3,
X_UOM_EXT_ATTR4,
X_UOM_EXT_ATTR5,
X_UOM_EXT_ATTR6,
X_UOM_EXT_ATTR7,
X_UOM_EXT_ATTR8,
X_UOM_EXT_ATTR9,
X_UOM_EXT_ATTR10,
X_UOM_EXT_ATTR11,
X_UOM_EXT_ATTR12,
X_UOM_EXT_ATTR13,
X_UOM_EXT_ATTR14,
X_UOM_EXT_ATTR15,
X_UOM_EXT_ATTR16,
X_UOM_EXT_ATTR17,
X_UOM_EXT_ATTR18,
X_UOM_EXT_ATTR19,
X_UOM_EXT_ATTR20,
X_BILL_SEQUENCE_ID,
X_EXTENSION_ID,
X_COMPONENT_SEQUENCE_ID,
X_STRUCTURE_TYPE_ID,
X_ATTR_GROUP_ID,
X_C_EXT_ATTR1,
X_C_EXT_ATTR2,
X_C_EXT_ATTR3,
X_C_EXT_ATTR4,
X_C_EXT_ATTR5,
X_C_EXT_ATTR6,
X_C_EXT_ATTR7,
X_C_EXT_ATTR8,
X_C_EXT_ATTR9,
X_C_EXT_ATTR10,
X_C_EXT_ATTR11,
X_C_EXT_ATTR12,
X_C_EXT_ATTR13,
X_C_EXT_ATTR14,
X_C_EXT_ATTR15,
X_C_EXT_ATTR16,
X_C_EXT_ATTR17,
X_C_EXT_ATTR18,
X_C_EXT_ATTR19,
X_C_EXT_ATTR20,
X_C_EXT_ATTR21,
X_C_EXT_ATTR22,
X_C_EXT_ATTR23,
X_C_EXT_ATTR24,
X_C_EXT_ATTR25,
X_C_EXT_ATTR26,
X_C_EXT_ATTR27,
X_C_EXT_ATTR28,
X_C_EXT_ATTR29,
X_C_EXT_ATTR30,
X_C_EXT_ATTR31,
X_C_EXT_ATTR32,
X_C_EXT_ATTR33,
X_C_EXT_ATTR34,
X_C_EXT_ATTR35,
X_C_EXT_ATTR36,
X_C_EXT_ATTR37,
X_C_EXT_ATTR38,
X_C_EXT_ATTR39,
X_C_EXT_ATTR40,
X_N_EXT_ATTR1,
X_N_EXT_ATTR2,
X_N_EXT_ATTR3,
X_N_EXT_ATTR4,
X_N_EXT_ATTR5,
X_N_EXT_ATTR6,
X_N_EXT_ATTR7,
X_N_EXT_ATTR8,
X_N_EXT_ATTR9,
X_N_EXT_ATTR10,
X_N_EXT_ATTR11,
X_N_EXT_ATTR12,
X_N_EXT_ATTR13,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
INSERT INTO BOM_COMPONENTS_EXT_TL (
EXTENSION_ID,
COMPONENT_SEQUENCE_ID,
STRUCTURE_TYPE_ID,
ATTR_GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATION_DATE,
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
BILL_SEQUENCE_ID,
LANGUAGE,
SOURCE_LANG
) SELECT
X_EXTENSION_ID,
X_COMPONENT_SEQUENCE_ID,
X_STRUCTURE_TYPE_ID,
X_ATTR_GROUP_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_CREATED_BY,
X_CREATION_DATE,
X_TL_EXT_ATTR1,
X_TL_EXT_ATTR2,
X_TL_EXT_ATTR3,
X_TL_EXT_ATTR4,
X_TL_EXT_ATTR5,
X_TL_EXT_ATTR6,
X_TL_EXT_ATTR7,
X_TL_EXT_ATTR8,
X_TL_EXT_ATTR9,
X_TL_EXT_ATTR10,
X_TL_EXT_ATTR11,
X_TL_EXT_ATTR12,
X_TL_EXT_ATTR13,
X_TL_EXT_ATTR14,
X_TL_EXT_ATTR15,
X_TL_EXT_ATTR16,
X_TL_EXT_ATTR17,
X_TL_EXT_ATTR18,
X_TL_EXT_ATTR19,
X_TL_EXT_ATTR20,
X_TL_EXT_ATTR21,
X_TL_EXT_ATTR22,
X_TL_EXT_ATTR23,
X_TL_EXT_ATTR24,
X_TL_EXT_ATTR25,
X_TL_EXT_ATTR26,
X_TL_EXT_ATTR27,
X_TL_EXT_ATTR28,
X_TL_EXT_ATTR29,
X_TL_EXT_ATTR30,
X_TL_EXT_ATTR31,
X_TL_EXT_ATTR32,
X_TL_EXT_ATTR33,
X_TL_EXT_ATTR34,
X_TL_EXT_ATTR35,
X_TL_EXT_ATTR36,
X_TL_EXT_ATTR37,
X_TL_EXT_ATTR38,
X_TL_EXT_ATTR39,
X_TL_EXT_ATTR40,
X_BILL_SEQUENCE_ID,
L.LANGUAGE_CODE,
USERENV('LANG')
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND NOT EXISTS
(SELECT NULL
FROM BOM_COMPONENTS_EXT_TL T
WHERE T.EXTENSION_ID = X_EXTENSION_ID
AND T.LANGUAGE = L.LANGUAGE_CODE);
END INSERT_ROW;
CURSOR c IS SELECT
N_EXT_ATTR14,
N_EXT_ATTR15,
N_EXT_ATTR16,
N_EXT_ATTR17,
N_EXT_ATTR18,
N_EXT_ATTR19,
N_EXT_ATTR20,
D_EXT_ATTR1,
D_EXT_ATTR2,
D_EXT_ATTR3,
D_EXT_ATTR4,
D_EXT_ATTR5,
D_EXT_ATTR6,
D_EXT_ATTR7,
D_EXT_ATTR8,
D_EXT_ATTR9,
D_EXT_ATTR10,
UOM_EXT_ATTR1,
UOM_EXT_ATTR2,
UOM_EXT_ATTR3,
UOM_EXT_ATTR4,
UOM_EXT_ATTR5,
UOM_EXT_ATTR6,
UOM_EXT_ATTR7,
UOM_EXT_ATTR8,
UOM_EXT_ATTR9,
UOM_EXT_ATTR10,
UOM_EXT_ATTR11,
UOM_EXT_ATTR12,
UOM_EXT_ATTR13,
UOM_EXT_ATTR14,
UOM_EXT_ATTR15,
UOM_EXT_ATTR16,
UOM_EXT_ATTR17,
UOM_EXT_ATTR18,
UOM_EXT_ATTR19,
UOM_EXT_ATTR20,
BILL_SEQUENCE_ID,
COMPONENT_SEQUENCE_ID,
STRUCTURE_TYPE_ID,
ATTR_GROUP_ID,
C_EXT_ATTR1,
C_EXT_ATTR2,
C_EXT_ATTR3,
C_EXT_ATTR4,
C_EXT_ATTR5,
C_EXT_ATTR6,
C_EXT_ATTR7,
C_EXT_ATTR8,
C_EXT_ATTR9,
C_EXT_ATTR10,
C_EXT_ATTR11,
C_EXT_ATTR12,
C_EXT_ATTR13,
C_EXT_ATTR14,
C_EXT_ATTR15,
C_EXT_ATTR16,
C_EXT_ATTR17,
C_EXT_ATTR18,
C_EXT_ATTR19,
C_EXT_ATTR20,
C_EXT_ATTR21,
C_EXT_ATTR22,
C_EXT_ATTR23,
C_EXT_ATTR24,
C_EXT_ATTR25,
C_EXT_ATTR26,
C_EXT_ATTR27,
C_EXT_ATTR28,
C_EXT_ATTR29,
C_EXT_ATTR30,
C_EXT_ATTR31,
C_EXT_ATTR32,
C_EXT_ATTR33,
C_EXT_ATTR34,
C_EXT_ATTR35,
C_EXT_ATTR36,
C_EXT_ATTR37,
C_EXT_ATTR38,
C_EXT_ATTR39,
C_EXT_ATTR40,
N_EXT_ATTR1,
N_EXT_ATTR2,
N_EXT_ATTR3,
N_EXT_ATTR4,
N_EXT_ATTR5,
N_EXT_ATTR6,
N_EXT_ATTR7,
N_EXT_ATTR8,
N_EXT_ATTR9,
N_EXT_ATTR10,
N_EXT_ATTR11,
N_EXT_ATTR12,
N_EXT_ATTR13
FROM BOM_COMPONENTS_EXT_B
WHERE EXTENSION_ID = X_EXTENSION_ID
FOR UPDATE OF EXTENSION_ID NOWAIT;
CURSOR c1 IS SELECT
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
FROM BOM_COMPONENTS_EXT_TL
WHERE EXTENSION_ID = X_EXTENSION_ID
AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
FOR UPDATE OF EXTENSION_ID NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE UPDATE_ROW (
X_EXTENSION_ID IN NUMBER,
X_N_EXT_ATTR14 IN NUMBER,
X_N_EXT_ATTR15 IN NUMBER,
X_N_EXT_ATTR16 IN NUMBER,
X_N_EXT_ATTR17 IN NUMBER,
X_N_EXT_ATTR18 IN NUMBER,
X_N_EXT_ATTR19 IN NUMBER,
X_N_EXT_ATTR20 IN NUMBER,
X_D_EXT_ATTR1 IN DATE,
X_D_EXT_ATTR2 IN DATE,
X_D_EXT_ATTR3 IN DATE,
X_D_EXT_ATTR4 IN DATE,
X_D_EXT_ATTR5 IN DATE,
X_D_EXT_ATTR6 IN DATE,
X_D_EXT_ATTR7 IN DATE,
X_D_EXT_ATTR8 IN DATE,
X_D_EXT_ATTR9 IN DATE,
X_D_EXT_ATTR10 IN DATE,
X_UOM_EXT_ATTR1 IN VARCHAR2,
X_UOM_EXT_ATTR2 IN VARCHAR2,
X_UOM_EXT_ATTR3 IN VARCHAR2,
X_UOM_EXT_ATTR4 IN VARCHAR2,
X_UOM_EXT_ATTR5 IN VARCHAR2,
X_UOM_EXT_ATTR6 IN VARCHAR2,
X_UOM_EXT_ATTR7 IN VARCHAR2,
X_UOM_EXT_ATTR8 IN VARCHAR2,
X_UOM_EXT_ATTR9 IN VARCHAR2,
X_UOM_EXT_ATTR10 IN VARCHAR2,
X_UOM_EXT_ATTR11 IN VARCHAR2,
X_UOM_EXT_ATTR12 IN VARCHAR2,
X_UOM_EXT_ATTR13 IN VARCHAR2,
X_UOM_EXT_ATTR14 IN VARCHAR2,
X_UOM_EXT_ATTR15 IN VARCHAR2,
X_UOM_EXT_ATTR16 IN VARCHAR2,
X_UOM_EXT_ATTR17 IN VARCHAR2,
X_UOM_EXT_ATTR18 IN VARCHAR2,
X_UOM_EXT_ATTR19 IN VARCHAR2,
X_UOM_EXT_ATTR20 IN VARCHAR2,
X_BILL_SEQUENCE_ID IN NUMBER,
X_COMPONENT_SEQUENCE_ID IN NUMBER,
X_STRUCTURE_TYPE_ID IN NUMBER,
X_ATTR_GROUP_ID IN NUMBER,
X_C_EXT_ATTR1 IN VARCHAR2,
X_C_EXT_ATTR2 IN VARCHAR2,
X_C_EXT_ATTR3 IN VARCHAR2,
X_C_EXT_ATTR4 IN VARCHAR2,
X_C_EXT_ATTR5 IN VARCHAR2,
X_C_EXT_ATTR6 IN VARCHAR2,
X_C_EXT_ATTR7 IN VARCHAR2,
X_C_EXT_ATTR8 IN VARCHAR2,
X_C_EXT_ATTR9 IN VARCHAR2,
X_C_EXT_ATTR10 IN VARCHAR2,
X_C_EXT_ATTR11 IN VARCHAR2,
X_C_EXT_ATTR12 IN VARCHAR2,
X_C_EXT_ATTR13 IN VARCHAR2,
X_C_EXT_ATTR14 IN VARCHAR2,
X_C_EXT_ATTR15 IN VARCHAR2,
X_C_EXT_ATTR16 IN VARCHAR2,
X_C_EXT_ATTR17 IN VARCHAR2,
X_C_EXT_ATTR18 IN VARCHAR2,
X_C_EXT_ATTR19 IN VARCHAR2,
X_C_EXT_ATTR20 IN VARCHAR2,
X_C_EXT_ATTR21 IN VARCHAR2,
X_C_EXT_ATTR22 IN VARCHAR2,
X_C_EXT_ATTR23 IN VARCHAR2,
X_C_EXT_ATTR24 IN VARCHAR2,
X_C_EXT_ATTR25 IN VARCHAR2,
X_C_EXT_ATTR26 IN VARCHAR2,
X_C_EXT_ATTR27 IN VARCHAR2,
X_C_EXT_ATTR28 IN VARCHAR2,
X_C_EXT_ATTR29 IN VARCHAR2,
X_C_EXT_ATTR30 IN VARCHAR2,
X_C_EXT_ATTR31 IN VARCHAR2,
X_C_EXT_ATTR32 IN VARCHAR2,
X_C_EXT_ATTR33 IN VARCHAR2,
X_C_EXT_ATTR34 IN VARCHAR2,
X_C_EXT_ATTR35 IN VARCHAR2,
X_C_EXT_ATTR36 IN VARCHAR2,
X_C_EXT_ATTR37 IN VARCHAR2,
X_C_EXT_ATTR38 IN VARCHAR2,
X_C_EXT_ATTR39 IN VARCHAR2,
X_C_EXT_ATTR40 IN VARCHAR2,
X_N_EXT_ATTR1 IN NUMBER,
X_N_EXT_ATTR2 IN NUMBER,
X_N_EXT_ATTR3 IN NUMBER,
X_N_EXT_ATTR4 IN NUMBER,
X_N_EXT_ATTR5 IN NUMBER,
X_N_EXT_ATTR6 IN NUMBER,
X_N_EXT_ATTR7 IN NUMBER,
X_N_EXT_ATTR8 IN NUMBER,
X_N_EXT_ATTR9 IN NUMBER,
X_N_EXT_ATTR10 IN NUMBER,
X_N_EXT_ATTR11 IN NUMBER,
X_N_EXT_ATTR12 IN NUMBER,
X_N_EXT_ATTR13 IN NUMBER,
X_TL_EXT_ATTR1 IN VARCHAR2,
X_TL_EXT_ATTR2 IN VARCHAR2,
X_TL_EXT_ATTR3 IN VARCHAR2,
X_TL_EXT_ATTR4 IN VARCHAR2,
X_TL_EXT_ATTR5 IN VARCHAR2,
X_TL_EXT_ATTR6 IN VARCHAR2,
X_TL_EXT_ATTR7 IN VARCHAR2,
X_TL_EXT_ATTR8 IN VARCHAR2,
X_TL_EXT_ATTR9 IN VARCHAR2,
X_TL_EXT_ATTR10 IN VARCHAR2,
X_TL_EXT_ATTR11 IN VARCHAR2,
X_TL_EXT_ATTR12 IN VARCHAR2,
X_TL_EXT_ATTR13 IN VARCHAR2,
X_TL_EXT_ATTR14 IN VARCHAR2,
X_TL_EXT_ATTR15 IN VARCHAR2,
X_TL_EXT_ATTR16 IN VARCHAR2,
X_TL_EXT_ATTR17 IN VARCHAR2,
X_TL_EXT_ATTR18 IN VARCHAR2,
X_TL_EXT_ATTR19 IN VARCHAR2,
X_TL_EXT_ATTR20 IN VARCHAR2,
X_TL_EXT_ATTR21 IN VARCHAR2,
X_TL_EXT_ATTR22 IN VARCHAR2,
X_TL_EXT_ATTR23 IN VARCHAR2,
X_TL_EXT_ATTR24 IN VARCHAR2,
X_TL_EXT_ATTR25 IN VARCHAR2,
X_TL_EXT_ATTR26 IN VARCHAR2,
X_TL_EXT_ATTR27 IN VARCHAR2,
X_TL_EXT_ATTR28 IN VARCHAR2,
X_TL_EXT_ATTR29 IN VARCHAR2,
X_TL_EXT_ATTR30 IN VARCHAR2,
X_TL_EXT_ATTR31 IN VARCHAR2,
X_TL_EXT_ATTR32 IN VARCHAR2,
X_TL_EXT_ATTR33 IN VARCHAR2,
X_TL_EXT_ATTR34 IN VARCHAR2,
X_TL_EXT_ATTR35 IN VARCHAR2,
X_TL_EXT_ATTR36 IN VARCHAR2,
X_TL_EXT_ATTR37 IN VARCHAR2,
X_TL_EXT_ATTR38 IN VARCHAR2,
X_TL_EXT_ATTR39 IN VARCHAR2,
X_TL_EXT_ATTR40 IN VARCHAR2,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER
) IS
BEGIN
UPDATE BOM_COMPONENTS_EXT_B SET
N_EXT_ATTR14 = X_N_EXT_ATTR14,
N_EXT_ATTR15 = X_N_EXT_ATTR15,
N_EXT_ATTR16 = X_N_EXT_ATTR16,
N_EXT_ATTR17 = X_N_EXT_ATTR17,
N_EXT_ATTR18 = X_N_EXT_ATTR18,
N_EXT_ATTR19 = X_N_EXT_ATTR19,
N_EXT_ATTR20 = X_N_EXT_ATTR20,
D_EXT_ATTR1 = X_D_EXT_ATTR1,
D_EXT_ATTR2 = X_D_EXT_ATTR2,
D_EXT_ATTR3 = X_D_EXT_ATTR3,
D_EXT_ATTR4 = X_D_EXT_ATTR4,
D_EXT_ATTR5 = X_D_EXT_ATTR5,
D_EXT_ATTR6 = X_D_EXT_ATTR6,
D_EXT_ATTR7 = X_D_EXT_ATTR7,
D_EXT_ATTR8 = X_D_EXT_ATTR8,
D_EXT_ATTR9 = X_D_EXT_ATTR9,
D_EXT_ATTR10 = X_D_EXT_ATTR10,
UOM_EXT_ATTR1 = X_UOM_EXT_ATTR1,
UOM_EXT_ATTR2 = X_UOM_EXT_ATTR2,
UOM_EXT_ATTR3 = X_UOM_EXT_ATTR3,
UOM_EXT_ATTR4 = X_UOM_EXT_ATTR4,
UOM_EXT_ATTR5 = X_UOM_EXT_ATTR5,
UOM_EXT_ATTR6 = X_UOM_EXT_ATTR6,
UOM_EXT_ATTR7 = X_UOM_EXT_ATTR7,
UOM_EXT_ATTR8 = X_UOM_EXT_ATTR8,
UOM_EXT_ATTR9 = X_UOM_EXT_ATTR9,
UOM_EXT_ATTR10 = X_UOM_EXT_ATTR10,
UOM_EXT_ATTR11 = X_UOM_EXT_ATTR11,
UOM_EXT_ATTR12 = X_UOM_EXT_ATTR12,
UOM_EXT_ATTR13 = X_UOM_EXT_ATTR13,
UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,
UOM_EXT_ATTR18 = X_UOM_EXT_ATTR18,
UOM_EXT_ATTR19 = X_UOM_EXT_ATTR19,
UOM_EXT_ATTR20 = X_UOM_EXT_ATTR20,
BILL_SEQUENCE_ID = X_BILL_SEQUENCE_ID,
COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID,
STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID,
ATTR_GROUP_ID = X_ATTR_GROUP_ID,
C_EXT_ATTR1 = X_C_EXT_ATTR1,
C_EXT_ATTR2 = X_C_EXT_ATTR2,
C_EXT_ATTR3 = X_C_EXT_ATTR3,
C_EXT_ATTR4 = X_C_EXT_ATTR4,
C_EXT_ATTR5 = X_C_EXT_ATTR5,
C_EXT_ATTR6 = X_C_EXT_ATTR6,
C_EXT_ATTR7 = X_C_EXT_ATTR7,
C_EXT_ATTR8 = X_C_EXT_ATTR8,
C_EXT_ATTR9 = X_C_EXT_ATTR9,
C_EXT_ATTR10 = X_C_EXT_ATTR10,
C_EXT_ATTR11 = X_C_EXT_ATTR11,
C_EXT_ATTR12 = X_C_EXT_ATTR12,
C_EXT_ATTR13 = X_C_EXT_ATTR13,
C_EXT_ATTR14 = X_C_EXT_ATTR14,
C_EXT_ATTR15 = X_C_EXT_ATTR15,
C_EXT_ATTR16 = X_C_EXT_ATTR16,
C_EXT_ATTR17 = X_C_EXT_ATTR17,
C_EXT_ATTR18 = X_C_EXT_ATTR18,
C_EXT_ATTR19 = X_C_EXT_ATTR19,
C_EXT_ATTR20 = X_C_EXT_ATTR20,
C_EXT_ATTR21 = X_C_EXT_ATTR21,
C_EXT_ATTR22 = X_C_EXT_ATTR22,
C_EXT_ATTR23 = X_C_EXT_ATTR23,
C_EXT_ATTR24 = X_C_EXT_ATTR24,
C_EXT_ATTR25 = X_C_EXT_ATTR25,
C_EXT_ATTR26 = X_C_EXT_ATTR26,
C_EXT_ATTR27 = X_C_EXT_ATTR27,
C_EXT_ATTR28 = X_C_EXT_ATTR28,
C_EXT_ATTR29 = X_C_EXT_ATTR29,
C_EXT_ATTR30 = X_C_EXT_ATTR30,
C_EXT_ATTR31 = X_C_EXT_ATTR31,
C_EXT_ATTR32 = X_C_EXT_ATTR32,
C_EXT_ATTR33 = X_C_EXT_ATTR33,
C_EXT_ATTR34 = X_C_EXT_ATTR34,
C_EXT_ATTR35 = X_C_EXT_ATTR35,
C_EXT_ATTR36 = X_C_EXT_ATTR36,
C_EXT_ATTR37 = X_C_EXT_ATTR37,
C_EXT_ATTR38 = X_C_EXT_ATTR38,
C_EXT_ATTR39 = X_C_EXT_ATTR39,
C_EXT_ATTR40 = X_C_EXT_ATTR40,
N_EXT_ATTR1 = X_N_EXT_ATTR1,
N_EXT_ATTR2 = X_N_EXT_ATTR2,
N_EXT_ATTR3 = X_N_EXT_ATTR3,
N_EXT_ATTR4 = X_N_EXT_ATTR4,
N_EXT_ATTR5 = X_N_EXT_ATTR5,
N_EXT_ATTR6 = X_N_EXT_ATTR6,
N_EXT_ATTR7 = X_N_EXT_ATTR7,
N_EXT_ATTR8 = X_N_EXT_ATTR8,
N_EXT_ATTR9 = X_N_EXT_ATTR9,
N_EXT_ATTR10 = X_N_EXT_ATTR10,
N_EXT_ATTR11 = X_N_EXT_ATTR11,
N_EXT_ATTR12 = X_N_EXT_ATTR12,
N_EXT_ATTR13 = X_N_EXT_ATTR13,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
WHERE EXTENSION_ID = X_EXTENSION_ID;
UPDATE BOM_COMPONENTS_EXT_TL SET
TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
TL_EXT_ATTR4 = X_TL_EXT_ATTR4,
TL_EXT_ATTR5 = X_TL_EXT_ATTR5,
TL_EXT_ATTR6 = X_TL_EXT_ATTR6,
TL_EXT_ATTR7 = X_TL_EXT_ATTR7,
TL_EXT_ATTR8 = X_TL_EXT_ATTR8,
TL_EXT_ATTR9 = X_TL_EXT_ATTR9,
TL_EXT_ATTR10 = X_TL_EXT_ATTR10,
TL_EXT_ATTR11 = X_TL_EXT_ATTR11,
TL_EXT_ATTR12 = X_TL_EXT_ATTR12,
TL_EXT_ATTR13 = X_TL_EXT_ATTR13,
TL_EXT_ATTR14 = X_TL_EXT_ATTR14,
TL_EXT_ATTR15 = X_TL_EXT_ATTR15,
TL_EXT_ATTR16 = X_TL_EXT_ATTR16,
TL_EXT_ATTR17 = X_TL_EXT_ATTR17,
TL_EXT_ATTR18 = X_TL_EXT_ATTR18,
TL_EXT_ATTR19 = X_TL_EXT_ATTR19,
TL_EXT_ATTR20 = X_TL_EXT_ATTR20,
TL_EXT_ATTR21 = X_TL_EXT_ATTR21,
TL_EXT_ATTR22 = X_TL_EXT_ATTR22,
TL_EXT_ATTR23 = X_TL_EXT_ATTR23,
TL_EXT_ATTR24 = X_TL_EXT_ATTR24,
TL_EXT_ATTR25 = X_TL_EXT_ATTR25,
TL_EXT_ATTR26 = X_TL_EXT_ATTR26,
TL_EXT_ATTR27 = X_TL_EXT_ATTR27,
TL_EXT_ATTR28 = X_TL_EXT_ATTR28,
TL_EXT_ATTR29 = X_TL_EXT_ATTR29,
TL_EXT_ATTR30 = X_TL_EXT_ATTR30,
TL_EXT_ATTR31 = X_TL_EXT_ATTR31,
TL_EXT_ATTR32 = X_TL_EXT_ATTR32,
TL_EXT_ATTR33 = X_TL_EXT_ATTR33,
TL_EXT_ATTR34 = X_TL_EXT_ATTR34,
TL_EXT_ATTR35 = X_TL_EXT_ATTR35,
TL_EXT_ATTR36 = X_TL_EXT_ATTR36,
TL_EXT_ATTR37 = X_TL_EXT_ATTR37,
TL_EXT_ATTR38 = X_TL_EXT_ATTR38,
TL_EXT_ATTR39 = X_TL_EXT_ATTR39,
TL_EXT_ATTR40 = X_TL_EXT_ATTR40,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SOURCE_LANG = USERENV('LANG')
WHERE EXTENSION_ID = X_EXTENSION_ID
AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
END UPDATE_ROW;
PROCEDURE DELETE_ROW (
X_EXTENSION_ID IN NUMBER
) IS
BEGIN
DELETE FROM BOM_COMPONENTS_EXT_TL
WHERE EXTENSION_ID = X_EXTENSION_ID;
DELETE FROM BOM_COMPONENTS_EXT_B
WHERE EXTENSION_ID = X_EXTENSION_ID;
END DELETE_ROW;
DELETE FROM BOM_COMPONENTS_EXT_TL T
WHERE NOT EXISTS
(SELECT NULL
FROM BOM_COMPONENTS_EXT_B B
WHERE B.EXTENSION_ID = T.EXTENSION_ID
);
UPDATE BOM_COMPONENTS_EXT_TL T SET (
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40
) = (SELECT
B.TL_EXT_ATTR1,
B.TL_EXT_ATTR2,
B.TL_EXT_ATTR3,
B.TL_EXT_ATTR4,
B.TL_EXT_ATTR5,
B.TL_EXT_ATTR6,
B.TL_EXT_ATTR7,
B.TL_EXT_ATTR8,
B.TL_EXT_ATTR9,
B.TL_EXT_ATTR10,
B.TL_EXT_ATTR11,
B.TL_EXT_ATTR12,
B.TL_EXT_ATTR13,
B.TL_EXT_ATTR14,
B.TL_EXT_ATTR15,
B.TL_EXT_ATTR16,
B.TL_EXT_ATTR17,
B.TL_EXT_ATTR18,
B.TL_EXT_ATTR19,
B.TL_EXT_ATTR20,
B.TL_EXT_ATTR21,
B.TL_EXT_ATTR22,
B.TL_EXT_ATTR23,
B.TL_EXT_ATTR24,
B.TL_EXT_ATTR25,
B.TL_EXT_ATTR26,
B.TL_EXT_ATTR27,
B.TL_EXT_ATTR28,
B.TL_EXT_ATTR29,
B.TL_EXT_ATTR30,
B.TL_EXT_ATTR31,
B.TL_EXT_ATTR32,
B.TL_EXT_ATTR33,
B.TL_EXT_ATTR34,
B.TL_EXT_ATTR35,
B.TL_EXT_ATTR36,
B.TL_EXT_ATTR37,
B.TL_EXT_ATTR38,
B.TL_EXT_ATTR39,
B.TL_EXT_ATTR40
FROM BOM_COMPONENTS_EXT_TL B
WHERE B.EXTENSION_ID = T.EXTENSION_ID
AND B.LANGUAGE = T.SOURCE_LANG)
WHERE (
T.EXTENSION_ID,
T.LANGUAGE
) IN (SELECT
SUBT.EXTENSION_ID,
SUBT.LANGUAGE
FROM BOM_COMPONENTS_EXT_TL SUBB, BOM_COMPONENTS_EXT_TL SUBT
WHERE SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
OR (SUBB.TL_EXT_ATTR1 IS NULL AND SUBT.TL_EXT_ATTR1 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR1 IS NOT NULL AND SUBT.TL_EXT_ATTR1 IS NULL)
OR SUBB.TL_EXT_ATTR2 <> SUBT.TL_EXT_ATTR2
OR (SUBB.TL_EXT_ATTR2 IS NULL AND SUBT.TL_EXT_ATTR2 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR2 IS NOT NULL AND SUBT.TL_EXT_ATTR2 IS NULL)
OR SUBB.TL_EXT_ATTR3 <> SUBT.TL_EXT_ATTR3
OR (SUBB.TL_EXT_ATTR3 IS NULL AND SUBT.TL_EXT_ATTR3 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR3 IS NOT NULL AND SUBT.TL_EXT_ATTR3 IS NULL)
OR SUBB.TL_EXT_ATTR4 <> SUBT.TL_EXT_ATTR4
OR (SUBB.TL_EXT_ATTR4 IS NULL AND SUBT.TL_EXT_ATTR4 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR4 IS NOT NULL AND SUBT.TL_EXT_ATTR4 IS NULL)
OR SUBB.TL_EXT_ATTR5 <> SUBT.TL_EXT_ATTR5
OR (SUBB.TL_EXT_ATTR5 IS NULL AND SUBT.TL_EXT_ATTR5 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR5 IS NOT NULL AND SUBT.TL_EXT_ATTR5 IS NULL)
OR SUBB.TL_EXT_ATTR6 <> SUBT.TL_EXT_ATTR6
OR (SUBB.TL_EXT_ATTR6 IS NULL AND SUBT.TL_EXT_ATTR6 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR6 IS NOT NULL AND SUBT.TL_EXT_ATTR6 IS NULL)
OR SUBB.TL_EXT_ATTR7 <> SUBT.TL_EXT_ATTR7
OR (SUBB.TL_EXT_ATTR7 IS NULL AND SUBT.TL_EXT_ATTR7 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR7 IS NOT NULL AND SUBT.TL_EXT_ATTR7 IS NULL)
OR SUBB.TL_EXT_ATTR8 <> SUBT.TL_EXT_ATTR8
OR (SUBB.TL_EXT_ATTR8 IS NULL AND SUBT.TL_EXT_ATTR8 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR8 IS NOT NULL AND SUBT.TL_EXT_ATTR8 IS NULL)
OR SUBB.TL_EXT_ATTR9 <> SUBT.TL_EXT_ATTR9
OR (SUBB.TL_EXT_ATTR9 IS NULL AND SUBT.TL_EXT_ATTR9 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR9 IS NOT NULL AND SUBT.TL_EXT_ATTR9 IS NULL)
OR SUBB.TL_EXT_ATTR10 <> SUBT.TL_EXT_ATTR10
OR (SUBB.TL_EXT_ATTR10 IS NULL AND SUBT.TL_EXT_ATTR10 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR10 IS NOT NULL AND SUBT.TL_EXT_ATTR10 IS NULL)
OR SUBB.TL_EXT_ATTR11 <> SUBT.TL_EXT_ATTR11
OR (SUBB.TL_EXT_ATTR11 IS NULL AND SUBT.TL_EXT_ATTR11 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR11 IS NOT NULL AND SUBT.TL_EXT_ATTR11 IS NULL)
OR SUBB.TL_EXT_ATTR12 <> SUBT.TL_EXT_ATTR12
OR (SUBB.TL_EXT_ATTR12 IS NULL AND SUBT.TL_EXT_ATTR12 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR12 IS NOT NULL AND SUBT.TL_EXT_ATTR12 IS NULL)
OR SUBB.TL_EXT_ATTR13 <> SUBT.TL_EXT_ATTR13
OR (SUBB.TL_EXT_ATTR13 IS NULL AND SUBT.TL_EXT_ATTR13 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR13 IS NOT NULL AND SUBT.TL_EXT_ATTR13 IS NULL)
OR SUBB.TL_EXT_ATTR14 <> SUBT.TL_EXT_ATTR14
OR (SUBB.TL_EXT_ATTR14 IS NULL AND SUBT.TL_EXT_ATTR14 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR14 IS NOT NULL AND SUBT.TL_EXT_ATTR14 IS NULL)
OR SUBB.TL_EXT_ATTR15 <> SUBT.TL_EXT_ATTR15
OR (SUBB.TL_EXT_ATTR15 IS NULL AND SUBT.TL_EXT_ATTR15 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR15 IS NOT NULL AND SUBT.TL_EXT_ATTR15 IS NULL)
OR SUBB.TL_EXT_ATTR16 <> SUBT.TL_EXT_ATTR16
OR (SUBB.TL_EXT_ATTR16 IS NULL AND SUBT.TL_EXT_ATTR16 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR16 IS NOT NULL AND SUBT.TL_EXT_ATTR16 IS NULL)
OR SUBB.TL_EXT_ATTR17 <> SUBT.TL_EXT_ATTR17
OR (SUBB.TL_EXT_ATTR17 IS NULL AND SUBT.TL_EXT_ATTR17 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR17 IS NOT NULL AND SUBT.TL_EXT_ATTR17 IS NULL)
OR SUBB.TL_EXT_ATTR18 <> SUBT.TL_EXT_ATTR18
OR (SUBB.TL_EXT_ATTR18 IS NULL AND SUBT.TL_EXT_ATTR18 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR18 IS NOT NULL AND SUBT.TL_EXT_ATTR18 IS NULL)
OR SUBB.TL_EXT_ATTR19 <> SUBT.TL_EXT_ATTR19
OR (SUBB.TL_EXT_ATTR19 IS NULL AND SUBT.TL_EXT_ATTR19 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR19 IS NOT NULL AND SUBT.TL_EXT_ATTR19 IS NULL)
OR SUBB.TL_EXT_ATTR20 <> SUBT.TL_EXT_ATTR20
OR (SUBB.TL_EXT_ATTR20 IS NULL AND SUBT.TL_EXT_ATTR20 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR20 IS NOT NULL AND SUBT.TL_EXT_ATTR20 IS NULL)
OR SUBB.TL_EXT_ATTR21 <> SUBT.TL_EXT_ATTR21
OR (SUBB.TL_EXT_ATTR21 IS NULL AND SUBT.TL_EXT_ATTR21 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR21 IS NOT NULL AND SUBT.TL_EXT_ATTR21 IS NULL)
OR SUBB.TL_EXT_ATTR22 <> SUBT.TL_EXT_ATTR22
OR (SUBB.TL_EXT_ATTR22 IS NULL AND SUBT.TL_EXT_ATTR22 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR22 IS NOT NULL AND SUBT.TL_EXT_ATTR22 IS NULL)
OR SUBB.TL_EXT_ATTR23 <> SUBT.TL_EXT_ATTR23
OR (SUBB.TL_EXT_ATTR23 IS NULL AND SUBT.TL_EXT_ATTR23 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR23 IS NOT NULL AND SUBT.TL_EXT_ATTR23 IS NULL)
OR SUBB.TL_EXT_ATTR24 <> SUBT.TL_EXT_ATTR24
OR (SUBB.TL_EXT_ATTR24 IS NULL AND SUBT.TL_EXT_ATTR24 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR24 IS NOT NULL AND SUBT.TL_EXT_ATTR24 IS NULL)
OR SUBB.TL_EXT_ATTR25 <> SUBT.TL_EXT_ATTR25
OR (SUBB.TL_EXT_ATTR25 IS NULL AND SUBT.TL_EXT_ATTR25 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR25 IS NOT NULL AND SUBT.TL_EXT_ATTR25 IS NULL)
OR SUBB.TL_EXT_ATTR26 <> SUBT.TL_EXT_ATTR26
OR (SUBB.TL_EXT_ATTR26 IS NULL AND SUBT.TL_EXT_ATTR26 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR26 IS NOT NULL AND SUBT.TL_EXT_ATTR26 IS NULL)
OR SUBB.TL_EXT_ATTR27 <> SUBT.TL_EXT_ATTR27
OR (SUBB.TL_EXT_ATTR27 IS NULL AND SUBT.TL_EXT_ATTR27 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR27 IS NOT NULL AND SUBT.TL_EXT_ATTR27 IS NULL)
OR SUBB.TL_EXT_ATTR28 <> SUBT.TL_EXT_ATTR28
OR (SUBB.TL_EXT_ATTR28 IS NULL AND SUBT.TL_EXT_ATTR28 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR28 IS NOT NULL AND SUBT.TL_EXT_ATTR28 IS NULL)
OR SUBB.TL_EXT_ATTR29 <> SUBT.TL_EXT_ATTR29
OR (SUBB.TL_EXT_ATTR29 IS NULL AND SUBT.TL_EXT_ATTR29 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR29 IS NOT NULL AND SUBT.TL_EXT_ATTR29 IS NULL)
OR SUBB.TL_EXT_ATTR30 <> SUBT.TL_EXT_ATTR30
OR (SUBB.TL_EXT_ATTR30 IS NULL AND SUBT.TL_EXT_ATTR30 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR30 IS NOT NULL AND SUBT.TL_EXT_ATTR30 IS NULL)
OR SUBB.TL_EXT_ATTR31 <> SUBT.TL_EXT_ATTR31
OR (SUBB.TL_EXT_ATTR31 IS NULL AND SUBT.TL_EXT_ATTR31 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR31 IS NOT NULL AND SUBT.TL_EXT_ATTR31 IS NULL)
OR SUBB.TL_EXT_ATTR32 <> SUBT.TL_EXT_ATTR32
OR (SUBB.TL_EXT_ATTR32 IS NULL AND SUBT.TL_EXT_ATTR32 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR32 IS NOT NULL AND SUBT.TL_EXT_ATTR32 IS NULL)
OR SUBB.TL_EXT_ATTR33 <> SUBT.TL_EXT_ATTR33
OR (SUBB.TL_EXT_ATTR33 IS NULL AND SUBT.TL_EXT_ATTR33 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR33 IS NOT NULL AND SUBT.TL_EXT_ATTR33 IS NULL)
OR SUBB.TL_EXT_ATTR34 <> SUBT.TL_EXT_ATTR34
OR (SUBB.TL_EXT_ATTR34 IS NULL AND SUBT.TL_EXT_ATTR34 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR34 IS NOT NULL AND SUBT.TL_EXT_ATTR34 IS NULL)
OR SUBB.TL_EXT_ATTR35 <> SUBT.TL_EXT_ATTR35
OR (SUBB.TL_EXT_ATTR35 IS NULL AND SUBT.TL_EXT_ATTR35 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR35 IS NOT NULL AND SUBT.TL_EXT_ATTR35 IS NULL)
OR SUBB.TL_EXT_ATTR36 <> SUBT.TL_EXT_ATTR36
OR (SUBB.TL_EXT_ATTR36 IS NULL AND SUBT.TL_EXT_ATTR36 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR36 IS NOT NULL AND SUBT.TL_EXT_ATTR36 IS NULL)
OR SUBB.TL_EXT_ATTR37 <> SUBT.TL_EXT_ATTR37
OR (SUBB.TL_EXT_ATTR37 IS NULL AND SUBT.TL_EXT_ATTR37 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR37 IS NOT NULL AND SUBT.TL_EXT_ATTR37 IS NULL)
OR SUBB.TL_EXT_ATTR38 <> SUBT.TL_EXT_ATTR38
OR (SUBB.TL_EXT_ATTR38 IS NULL AND SUBT.TL_EXT_ATTR38 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR38 IS NOT NULL AND SUBT.TL_EXT_ATTR38 IS NULL)
OR SUBB.TL_EXT_ATTR39 <> SUBT.TL_EXT_ATTR39
OR (SUBB.TL_EXT_ATTR39 IS NULL AND SUBT.TL_EXT_ATTR39 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR39 IS NOT NULL AND SUBT.TL_EXT_ATTR39 IS NULL)
OR SUBB.TL_EXT_ATTR40 <> SUBT.TL_EXT_ATTR40
OR (SUBB.TL_EXT_ATTR40 IS NULL AND SUBT.TL_EXT_ATTR40 IS NOT NULL)
OR (SUBB.TL_EXT_ATTR40 IS NOT NULL AND SUBT.TL_EXT_ATTR40 IS NULL)
));
INSERT INTO BOM_COMPONENTS_EXT_TL (
EXTENSION_ID,
COMPONENT_SEQUENCE_ID,
STRUCTURE_TYPE_ID,
ATTR_GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATION_DATE,
TL_EXT_ATTR1,
TL_EXT_ATTR2,
TL_EXT_ATTR3,
TL_EXT_ATTR4,
TL_EXT_ATTR5,
TL_EXT_ATTR6,
TL_EXT_ATTR7,
TL_EXT_ATTR8,
TL_EXT_ATTR9,
TL_EXT_ATTR10,
TL_EXT_ATTR11,
TL_EXT_ATTR12,
TL_EXT_ATTR13,
TL_EXT_ATTR14,
TL_EXT_ATTR15,
TL_EXT_ATTR16,
TL_EXT_ATTR17,
TL_EXT_ATTR18,
TL_EXT_ATTR19,
TL_EXT_ATTR20,
TL_EXT_ATTR21,
TL_EXT_ATTR22,
TL_EXT_ATTR23,
TL_EXT_ATTR24,
TL_EXT_ATTR25,
TL_EXT_ATTR26,
TL_EXT_ATTR27,
TL_EXT_ATTR28,
TL_EXT_ATTR29,
TL_EXT_ATTR30,
TL_EXT_ATTR31,
TL_EXT_ATTR32,
TL_EXT_ATTR33,
TL_EXT_ATTR34,
TL_EXT_ATTR35,
TL_EXT_ATTR36,
TL_EXT_ATTR37,
TL_EXT_ATTR38,
TL_EXT_ATTR39,
TL_EXT_ATTR40,
BILL_SEQUENCE_ID,
LANGUAGE,
SOURCE_LANG
) SELECT /*+ ORDERED */
B.EXTENSION_ID,
B.COMPONENT_SEQUENCE_ID,
B.STRUCTURE_TYPE_ID,
B.ATTR_GROUP_ID,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN,
B.CREATED_BY,
B.CREATION_DATE,
B.TL_EXT_ATTR1,
B.TL_EXT_ATTR2,
B.TL_EXT_ATTR3,
B.TL_EXT_ATTR4,
B.TL_EXT_ATTR5,
B.TL_EXT_ATTR6,
B.TL_EXT_ATTR7,
B.TL_EXT_ATTR8,
B.TL_EXT_ATTR9,
B.TL_EXT_ATTR10,
B.TL_EXT_ATTR11,
B.TL_EXT_ATTR12,
B.TL_EXT_ATTR13,
B.TL_EXT_ATTR14,
B.TL_EXT_ATTR15,
B.TL_EXT_ATTR16,
B.TL_EXT_ATTR17,
B.TL_EXT_ATTR18,
B.TL_EXT_ATTR19,
B.TL_EXT_ATTR20,
B.TL_EXT_ATTR21,
B.TL_EXT_ATTR22,
B.TL_EXT_ATTR23,
B.TL_EXT_ATTR24,
B.TL_EXT_ATTR25,
B.TL_EXT_ATTR26,
B.TL_EXT_ATTR27,
B.TL_EXT_ATTR28,
B.TL_EXT_ATTR29,
B.TL_EXT_ATTR30,
B.TL_EXT_ATTR31,
B.TL_EXT_ATTR32,
B.TL_EXT_ATTR33,
B.TL_EXT_ATTR34,
B.TL_EXT_ATTR35,
B.TL_EXT_ATTR36,
B.TL_EXT_ATTR37,
B.TL_EXT_ATTR38,
B.TL_EXT_ATTR39,
B.TL_EXT_ATTR40,
B.BILL_SEQUENCE_ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG
FROM BOM_COMPONENTS_EXT_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS
(SELECT NULL
FROM BOM_COMPONENTS_EXT_TL T
WHERE T.EXTENSION_ID = B.EXTENSION_ID
AND T.LANGUAGE = L.LANGUAGE_CODE);