The following lines contain the word 'select', 'insert', 'update' or 'delete':
REM | Name and Description should not be updated, if the values |
REM | are BIS_COMMON_UTILS.G_DEF_CHAR |
REM | 19-MAY-2005 visuri GSCC Issues bug 4363854 |
REM | 24-Aug-2005 hengliu bug#4572274: issue in loading seed data |
REM +=======================================================================+
*/
G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PVT';
INSERT INTO BIS_FORM_FUNCTION_EXTENSION
(
OBJECT_TYPE
, OBJECT_NAME
, APPLICATION_ID
, FUNCTIONAL_AREA_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
)
VALUES
(
l_Form_Func_Extn_Rec.Object_Type
, TRIM(l_Form_Func_Extn_Rec.Object_Name)
, l_Form_Func_Extn_Rec.Application_Id
, l_Form_Func_Extn_Rec.Func_Area_Id
, NVL(l_Form_Func_Extn_Rec.Created_By,FND_GLOBAL.USER_ID)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
, NVL(l_Form_Func_Extn_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
);
INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL
(
OBJECT_NAME
, NAME
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
)
SELECT
l_Form_Func_Extn_Rec.Object_Name
, l_Form_Func_Extn_Rec.Name
, l_Form_Func_Extn_Rec.Description
, L.LANGUAGE_CODE
, USERENV('LANG')
, NVL(l_Form_Func_Extn_Rec.Created_By,FND_GLOBAL.USER_ID)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
, NVL(l_Form_Func_Extn_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
, NVL(l_Form_Func_Extn_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND NOT EXISTS
(
SELECT NULL
FROM BIS_FORM_FUNCTION_EXTENSION_TL T
WHERE T.OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name
AND T.LANGUAGE = L.LANGUAGE_CODE
);
FUNCTION Name :- Update_Form_Func_Extension
PARAMETERS :-
p_Form_Func_Extn_Rec :- The Details of form function sent from UI for update
DESCRIPTION :- This basically updates the properties for form functions
This can be called from UI also
AUTHOR :- KRISHNA
*********************************************************************************************/
PROCEDURE Update_Form_Func_Extension(
p_Api_Version IN NUMBER
,p_Commit IN VARCHAR2
,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
,x_Return_Status OUT NOCOPY VARCHAR2
,x_Msg_Count OUT NOCOPY NUMBER
,x_Msg_Data OUT NOCOPY VARCHAR2
)IS
l_Commit VARCHAR2(30);
SAVEPOINT UpdateFormFuncSP;
IF(p_Form_Func_Extn_Rec.Last_Update_Date IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Update_Date := SYSDATE;
l_Form_Func_Extn_Rec.Last_Update_Date := p_Form_Func_Extn_Rec.Last_Update_Date;
IF (p_Form_Func_Extn_Rec.Last_Updated_By IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
l_Form_Func_Extn_Rec.Last_Updated_By := p_Form_Func_Extn_Rec.Last_Updated_By;
IF (p_Form_Func_Extn_Rec.Last_Update_Login IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
l_Form_Func_Extn_Rec.Last_Update_Login := p_Form_Func_Extn_Rec.Last_Update_Login;
UPDATE BIS_FORM_FUNCTION_EXTENSION
SET
APPLICATION_ID = l_Form_Func_Extn_Rec.Application_id
, FUNCTIONAL_AREA_ID = l_Form_Func_Extn_Rec.Func_Area_Id
, LAST_UPDATED_BY = l_Form_Func_Extn_Rec.Last_Updated_By
, LAST_UPDATE_DATE = l_Form_Func_Extn_Rec.Last_Update_Date
, LAST_UPDATE_LOGIN = l_Form_Func_Extn_Rec.Last_Update_Login
WHERE OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name;
ROLLBACK TO UpdateFormFuncSP;
ROLLBACK TO UpdateFormFuncSP;
ROLLBACK TO UpdateFormFuncSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
ROLLBACK TO UpdateFormFuncSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
END Update_Form_Func_Extension;
DESCRIPTION :- This basically updates the properties for form functions
This can be called from UI directly also
AUTHOR :- KRISHNA
*********************************************************************************************/
PROCEDURE Translate_Form_Func_Extension(
p_Api_Version IN NUMBER
,p_Commit IN VARCHAR2
,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
,x_Return_Status OUT NOCOPY VARCHAR2
,x_Msg_Count OUT NOCOPY NUMBER
,x_Msg_Data OUT NOCOPY VARCHAR2
)IS
l_Commit VARCHAR2(30);
IF(p_Form_Func_Extn_Rec.Last_Update_Date IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Update_Date := SYSDATE;
l_Form_Func_Extn_Rec.Last_Update_Date := p_Form_Func_Extn_Rec.Last_Update_Date;
IF (p_Form_Func_Extn_Rec.Last_Updated_By IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
l_Form_Func_Extn_Rec.Last_Updated_By := p_Form_Func_Extn_Rec.Last_Updated_By;
IF (p_Form_Func_Extn_Rec.Last_Update_Login IS NULL) THEN
l_Form_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
l_Form_Func_Extn_Rec.Last_Update_Login := p_Form_Func_Extn_Rec.Last_Update_Login;
UPDATE BIS_FORM_FUNCTION_EXTENSION_TL
SET
NAME = l_Form_Func_Extn_Rec.Name
, DESCRIPTION = l_Form_Func_Extn_Rec.Description
, LAST_UPDATED_BY = l_Form_Func_Extn_Rec.Last_Updated_By
, LAST_UPDATE_DATE = l_Form_Func_Extn_Rec.Last_Update_Date
, LAST_UPDATE_LOGIN = l_Form_Func_Extn_Rec.Last_Update_Login
, SOURCE_LANG = USERENV('LANG')
WHERE OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name
AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
SELECT F.OBJECT_TYPE
,F.OBJECT_NAME
,F.NAME
,F.DESCRIPTION
,F.APPLICATION_ID
,F.FUNCTIONAL_AREA_ID
,F.CREATED_BY
,F.CREATION_DATE
,F.LAST_UPDATED_BY
,F.LAST_UPDATE_DATE
,F.LAST_UPDATE_LOGIN
INTO x_Form_Func_Extn_Rec.Object_Type
,x_Form_Func_Extn_Rec.Object_Name
,x_Form_Func_Extn_Rec.Name
,x_Form_Func_Extn_Rec.Description
,x_Form_Func_Extn_Rec.Application_Id
,x_Form_Func_Extn_Rec.Func_Area_Id
,x_Form_Func_Extn_Rec.Created_By
,x_Form_Func_Extn_Rec.Creation_Date
,x_Form_Func_Extn_Rec.Last_Updated_By
,x_Form_Func_Extn_Rec.Last_Update_Date
,x_Form_Func_Extn_Rec.Last_Update_Login
FROM BIS_FORM_FUNCTION_EXTENSION_VL F
WHERE F.OBJECT_NAME = trim(p_Form_Func_Extn_Rec.Object_Name);
DESCRIPTION :- This delete the record in BIS_FORM_FUNCTION_EXTENSION table
AUTHOR :- KRISHNA
*********************************************************************************************/
PROCEDURE Delete_Form_Func_Extension(
p_Api_Version IN NUMBER
, p_Commit IN VARCHAR2
, p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
, x_Return_Status OUT NOCOPY VARCHAR2
, x_Msg_Count OUT NOCOPY NUMBER
, x_Msg_Data OUT NOCOPY VARCHAR2
)IS
BEGIN
SAVEPOINT DeleteFormFuncSP_Pvt;
DELETE FROM BIS_FORM_FUNCTION_EXTENSION
WHERE OBJECT_NAME = TRIM(p_Form_Func_Extn_Rec.Object_Name);
DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL
WHERE OBJECT_NAME = TRIM(p_Form_Func_Extn_Rec.Object_Name);
ROLLBACK TO DeleteFormFuncSP_Pvt;
ROLLBACK TO DeleteFormFuncSP_Pvt;
ROLLBACK TO DeleteFormFuncSP_Pvt;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
ROLLBACK TO DeleteFormFuncSP_Pvt;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
END Delete_Form_Func_Extension;
INSERT INTO BIS_MEASURES_EXTENSION
(
MEASURE_SHORT_NAME
,FUNCTIONAL_AREA_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
)
VALUES
(
TRIM(l_Meas_Extn_Rec.Measure_Short_Name)
,l_Meas_Extn_Rec.Functional_Area_Id
,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
,NVL(l_Meas_Extn_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
);
INSERT INTO BIS_MEASURES_EXTENSION_TL
(
MEASURE_SHORT_NAME
,NAME
,DESCRIPTION
,LANGUAGE
,SOURCE_LANG
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
)
SELECT
l_Meas_Extn_Rec.Measure_Short_Name
,l_Meas_Extn_Rec.Name
,l_Meas_Extn_Rec.Description
,L.LANGUAGE_CODE
,USERENV('LANG')
,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
,NVL(l_Meas_Extn_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND NOT EXISTS
(
SELECT NULL
FROM BIS_MEASURES_EXTENSION_TL T
WHERE T.MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name
AND T.LANGUAGE = L.LANGUAGE_CODE
);
SELECT B.MEASURE_SHORT_NAME
,B.NAME
,B.DESCRIPTION
,B.FUNCTIONAL_AREA_ID
,B.CREATED_BY
,B.CREATION_DATE
,B.LAST_UPDATED_BY
,B.LAST_UPDATE_DATE
,B.LAST_UPDATE_LOGIN
FROM BIS_MEASURES_EXTENSION_VL B
WHERE B.MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
x_Meas_Extn_Rec.Last_Updated_By := cME.LAST_UPDATED_BY;
x_Meas_Extn_Rec.Last_Update_Date := cME.LAST_UPDATE_DATE;
x_Meas_Extn_Rec.Last_Update_Login := cME.LAST_UPDATE_LOGIN;
IF(p_Meas_Extn_Rec.Last_Update_Date IS NULL ) THEN
l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
l_Meas_Extn_Rec.Last_Update_Date := p_Meas_Extn_Rec.Last_Update_Date;
IF (p_Meas_Extn_Rec.Last_Updated_By IS NULL) THEN
l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
l_Meas_Extn_Rec.Last_Updated_By := p_Meas_Extn_Rec.Last_Updated_By;
IF (p_Meas_Extn_Rec.Last_Update_Login IS NULL) THEN
l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
l_Meas_Extn_Rec.Last_Update_Login := p_Meas_Extn_Rec.Last_Update_Login;
UPDATE BIS_MEASURES_EXTENSION_TL B
SET
B.NAME = l_Meas_Extn_Rec.Name
, B.DESCRIPTION = l_Meas_Extn_Rec.Description
, B.LAST_UPDATED_BY = l_Meas_Extn_Rec.Last_Updated_By
, B.LAST_UPDATE_DATE = l_Meas_Extn_Rec.Last_Update_Date
, B.LAST_UPDATE_LOGIN = l_Meas_Extn_Rec.Last_Update_Login
, B.SOURCE_LANG = USERENV('LANG')
WHERE
B.MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name
AND USERENV('LANG') IN (B.LANGUAGE, B.SOURCE_LANG);
PROCEDURE Update_Measure_Extension(
p_Api_Version IN NUMBER
,p_Commit IN VARCHAR2
,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
,x_Return_Status OUT NOCOPY VARCHAR2
,x_Msg_Count OUT NOCOPY NUMBER
,x_Msg_Data OUT NOCOPY VARCHAR2
) IS
l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
SAVEPOINT UpdateMeasExtnSP;
IF(p_Meas_Extn_Rec.Last_Update_Date IS NULL ) THEN
l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
l_Meas_Extn_Rec.Last_Update_Date := p_Meas_Extn_Rec.Last_Update_Date;
IF (p_Meas_Extn_Rec.Last_Updated_By IS NULL) THEN
l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
l_Meas_Extn_Rec.Last_Updated_By := p_Meas_Extn_Rec.Last_Updated_By;
IF (p_Meas_Extn_Rec.Last_Update_Login IS NULL) THEN
l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
l_Meas_Extn_Rec.Last_Update_Login := p_Meas_Extn_Rec.Last_Update_Login;
UPDATE BIS_MEASURES_EXTENSION
SET
FUNCTIONAL_AREA_ID = l_Meas_Extn_Rec.Functional_Area_Id
, LAST_UPDATED_BY = l_Meas_Extn_Rec.Last_Updated_By
, LAST_UPDATE_DATE = l_Meas_Extn_Rec.Last_Update_Date
, LAST_UPDATE_LOGIN = l_Meas_Extn_Rec.Last_Update_Login
WHERE
MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name;
ROLLBACK TO UpdateMeasExtnSP;
ROLLBACK TO UpdateMeasExtnSP;
ROLLBACK TO UpdateMeasExtnSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
ROLLBACK TO UpdateMeasExtnSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
END Update_Measure_Extension;
DESCRIPTION :- This delete the record in BIS_MEASURES_EXTENSION table
AUTHOR :- KRISHNA
*********************************************************************************************/
PROCEDURE Delete_Measure_Extension(
p_Api_Version IN NUMBER
,p_Commit IN VARCHAR2
,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
,x_Return_Status OUT NOCOPY VARCHAR2
,x_Msg_Count OUT NOCOPY NUMBER
,x_Msg_Data OUT NOCOPY VARCHAR2
) IS
BEGIN
SAVEPOINT DeleteMeasExtnSP;
DELETE FROM BIS_MEASURES_EXTENSION
WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
DELETE FROM BIS_MEASURES_EXTENSION_TL
WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
ROLLBACK TO DeleteMeasExtnSP;
ROLLBACK TO DeleteMeasExtnSP;
ROLLBACK TO DeleteMeasExtnSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
ROLLBACK TO DeleteMeasExtnSP;
x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
END Delete_Measure_Extension;
SELECT FUNCTIONAL_AREA_ID
INTO l_FA_Id
FROM BIS_FUNCTIONAL_AREAS
WHERE UPPER(SHORT_NAME) = UPPER(Trim(p_Functional_Area_Short_Name));
DELETE FROM BIS_MEASURES_EXTENSION_TL T
WHERE NOT EXISTS
(
SELECT NULL
FROM BIS_MEASURES_EXTENSION B
WHERE B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
);
UPDATE BIS_MEASURES_EXTENSION_TL T SET (
NAME,
DESCRIPTION
) = (SELECT
B.NAME,
B.DESCRIPTION
FROM BIS_MEASURES_EXTENSION_TL B
WHERE B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
AND B.LANGUAGE = T.SOURCE_LANG)
WHERE (
T.MEASURE_SHORT_NAME,
T.LANGUAGE
) IN (SELECT
SUBT.MEASURE_SHORT_NAME,
SUBT.LANGUAGE
FROM BIS_MEASURES_EXTENSION_TL SUBB, BIS_MEASURES_EXTENSION_TL SUBT
WHERE SUBB.MEASURE_SHORT_NAME = SUBT.MEASURE_SHORT_NAME
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (
SUBB.NAME <> SUBT.NAME
OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
)
);
INSERT INTO BIS_MEASURES_EXTENSION_TL
(
MEASURE_SHORT_NAME
,NAME
,DESCRIPTION
,LANGUAGE
,SOURCE_LANG
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
)
SELECT
B.MEASURE_SHORT_NAME
, B.NAME
, B.DESCRIPTION
, L.LANGUAGE_CODE
, B.SOURCE_LANG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BIS_MEASURES_EXTENSION_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS
(
SELECT NULL
FROM BIS_MEASURES_EXTENSION_TL T
WHERE UPPER(T.MEASURE_SHORT_NAME) = UPPER(B.MEASURE_SHORT_NAME)
AND T.LANGUAGE = L.LANGUAGE_CODE
);
DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL T
WHERE NOT EXISTS
(
SELECT NULL
FROM BIS_FORM_FUNCTION_EXTENSION B
WHERE B.OBJECT_NAME = T.OBJECT_NAME
);
UPDATE BIS_FORM_FUNCTION_EXTENSION_TL T SET (
NAME,
DESCRIPTION
) = (SELECT
B.NAME,
B.DESCRIPTION
FROM BIS_FORM_FUNCTION_EXTENSION_TL B
WHERE B.OBJECT_NAME = T.OBJECT_NAME
AND B.LANGUAGE = T.SOURCE_LANG)
WHERE (
T.OBJECT_NAME,
T.LANGUAGE
) IN (SELECT
SUBT.OBJECT_NAME,
SUBT.LANGUAGE
FROM BIS_FORM_FUNCTION_EXTENSION_TL SUBB, BIS_FORM_FUNCTION_EXTENSION_TL SUBT
WHERE SUBB.OBJECT_NAME = SUBT.OBJECT_NAME
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (
SUBB.NAME <> SUBT.NAME
OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
)
);
INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL
(
OBJECT_NAME
,NAME
,DESCRIPTION
,LANGUAGE
,SOURCE_LANG
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
)
SELECT
B.OBJECT_NAME
, B.NAME
, B.DESCRIPTION
, L.LANGUAGE_CODE
, B.SOURCE_LANG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM BIS_FORM_FUNCTION_EXTENSION_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS
(
SELECT NULL
FROM BIS_FORM_FUNCTION_EXTENSION_TL T
WHERE T.OBJECT_NAME = B.OBJECT_NAME
AND T.LANGUAGE = L.LANGUAGE_CODE
);