APPS.BIS_OBJECT_EXTENSIONS_PVT dependencies on BIS_FORM_FUNCTION_EXTENSION_TL

Line 14: REM | - BIS_FORM_FUNCTION_EXTENSION_TL |

10: REM | |
11: REM | DESCRIPTION |
12: REM | Module: Wrapper for populating the extension tables |
13: REM | - BIS_MEASURES_EXTENSION_TL |
14: REM | - BIS_FORM_FUNCTION_EXTENSION_TL |
15: REM | NOTES |
16: REM | 24-NOV-2004 Krishna Created. |
17: REM | 31-Jan-2005 rpenneru Modified for #4153331, BIS_MEASURES_EXTENSION_TL |
18: REM | Name and Description should not be updated, if the values |

Line 90: INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL

86: , NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
87: , NVL(l_Form_Func_Extn_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
88: );
89:
90: INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL
91: (
92: OBJECT_NAME
93: , NAME
94: , DESCRIPTION

Line 119: FROM BIS_FORM_FUNCTION_EXTENSION_TL T

115: WHERE L.INSTALLED_FLAG IN ('I', 'B')
116: AND NOT EXISTS
117: (
118: SELECT NULL
119: FROM BIS_FORM_FUNCTION_EXTENSION_TL T
120: WHERE T.OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name
121: AND T.LANGUAGE = L.LANGUAGE_CODE
122: );
123:

Line 372: UPDATE BIS_FORM_FUNCTION_EXTENSION_TL

368: ELSE
369: l_Form_Func_Extn_Rec.Last_Update_Login := p_Form_Func_Extn_Rec.Last_Update_Login;
370: END IF;
371:
372: UPDATE BIS_FORM_FUNCTION_EXTENSION_TL
373: SET
374: NAME = l_Form_Func_Extn_Rec.Name
375: , DESCRIPTION = l_Form_Func_Extn_Rec.Description
376: , LAST_UPDATED_BY = l_Form_Func_Extn_Rec.Last_Updated_By

Line 382: ----dbms_output.put_line('after updating BIS_FORM_FUNCTION_EXTENSION_TL in tras');

378: , LAST_UPDATE_LOGIN = l_Form_Func_Extn_Rec.Last_Update_Login
379: , SOURCE_LANG = USERENV('LANG')
380: WHERE OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name
381: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
382: ----dbms_output.put_line('after updating BIS_FORM_FUNCTION_EXTENSION_TL in tras');
383:
384: IF (l_Commit = FND_API.G_TRUE) THEN
385: COMMIT;
386: END IF;

Line 532: DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL

528: -- Delete from base table
529: DELETE FROM BIS_FORM_FUNCTION_EXTENSION
530: WHERE OBJECT_NAME = TRIM(p_Form_Func_Extn_Rec.Object_Name);
531:
532: DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL
533: WHERE OBJECT_NAME = TRIM(p_Form_Func_Extn_Rec.Object_Name);
534:
535: IF (p_Commit = FND_API.G_TRUE) THEN
536: COMMIT;

Line 1208: DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL T

1204:
1205: -- Add language for the BIS_MEASURES_EXTENSION_TL
1206:
1207: BEGIN
1208: DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL T
1209: WHERE NOT EXISTS
1210: (
1211: SELECT NULL
1212: FROM BIS_FORM_FUNCTION_EXTENSION B

Line 1216: UPDATE BIS_FORM_FUNCTION_EXTENSION_TL T SET (

1212: FROM BIS_FORM_FUNCTION_EXTENSION B
1213: WHERE B.OBJECT_NAME = T.OBJECT_NAME
1214: );
1215:
1216: UPDATE BIS_FORM_FUNCTION_EXTENSION_TL T SET (
1217: NAME,
1218: DESCRIPTION
1219: ) = (SELECT
1220: B.NAME,

Line 1222: FROM BIS_FORM_FUNCTION_EXTENSION_TL B

1218: DESCRIPTION
1219: ) = (SELECT
1220: B.NAME,
1221: B.DESCRIPTION
1222: FROM BIS_FORM_FUNCTION_EXTENSION_TL B
1223: WHERE B.OBJECT_NAME = T.OBJECT_NAME
1224: AND B.LANGUAGE = T.SOURCE_LANG)
1225: WHERE (
1226: T.OBJECT_NAME,

Line 1231: FROM BIS_FORM_FUNCTION_EXTENSION_TL SUBB, BIS_FORM_FUNCTION_EXTENSION_TL SUBT

1227: T.LANGUAGE
1228: ) IN (SELECT
1229: SUBT.OBJECT_NAME,
1230: SUBT.LANGUAGE
1231: FROM BIS_FORM_FUNCTION_EXTENSION_TL SUBB, BIS_FORM_FUNCTION_EXTENSION_TL SUBT
1232: WHERE SUBB.OBJECT_NAME = SUBT.OBJECT_NAME
1233: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1234: AND (
1235: SUBB.NAME <> SUBT.NAME

Line 1240: INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL

1236: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1237: )
1238: );
1239:
1240: INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL
1241: (
1242: OBJECT_NAME
1243: ,NAME
1244: ,DESCRIPTION

Line 1264: FROM BIS_FORM_FUNCTION_EXTENSION_TL B, FND_LANGUAGES L

1260: , B.CREATION_DATE
1261: , B.LAST_UPDATED_BY
1262: , B.LAST_UPDATE_DATE
1263: , B.LAST_UPDATE_LOGIN
1264: FROM BIS_FORM_FUNCTION_EXTENSION_TL B, FND_LANGUAGES L
1265: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1266: AND B.LANGUAGE = USERENV('LANG')
1267: AND NOT EXISTS
1268: (

Line 1270: FROM BIS_FORM_FUNCTION_EXTENSION_TL T

1266: AND B.LANGUAGE = USERENV('LANG')
1267: AND NOT EXISTS
1268: (
1269: SELECT NULL
1270: FROM BIS_FORM_FUNCTION_EXTENSION_TL T
1271: WHERE T.OBJECT_NAME = B.OBJECT_NAME
1272: AND T.LANGUAGE = L.LANGUAGE_CODE
1273: );
1274: EXCEPTION