APPS.BIS_OBJECT_EXTENSIONS_PVT dependencies on BIS_MEASURES_EXTENSION_TL

Line 13: REM | - BIS_MEASURES_EXTENSION_TL |

9: REM | BISVEXTB.pls |
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 |

Line 17: REM | 31-Jan-2005 rpenneru Modified for #4153331, BIS_MEASURES_EXTENSION_TL |

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 |
19: REM | are BIS_COMMON_UTILS.G_DEF_CHAR |
20: REM | 19-MAY-2005 visuri GSCC Issues bug 4363854 |
21: REM | 24-Aug-2005 hengliu bug#4572274: issue in loading seed data |

Line 634: INSERT INTO BIS_MEASURES_EXTENSION_TL

630: ,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
631: ,NVL(l_Meas_Extn_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
632: );
633:
634: INSERT INTO BIS_MEASURES_EXTENSION_TL
635: (
636: MEASURE_SHORT_NAME
637: ,NAME
638: ,DESCRIPTION

Line 663: FROM BIS_MEASURES_EXTENSION_TL T

659: WHERE L.INSTALLED_FLAG IN ('I', 'B')
660: AND NOT EXISTS
661: (
662: SELECT NULL
663: FROM BIS_MEASURES_EXTENSION_TL T
664: WHERE T.MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name
665: AND T.LANGUAGE = L.LANGUAGE_CODE
666: );
667: -- Commit if required

Line 861: UPDATE BIS_MEASURES_EXTENSION_TL B

857: l_Meas_Extn_Rec.Last_Update_Login := p_Meas_Extn_Rec.Last_Update_Login;
858: END IF;
859:
860: -- Update the trans table
861: UPDATE BIS_MEASURES_EXTENSION_TL B
862: SET
863: B.NAME = l_Meas_Extn_Rec.Name
864: , B.DESCRIPTION = l_Meas_Extn_Rec.Description
865: , B.LAST_UPDATED_BY = l_Meas_Extn_Rec.Last_Updated_By

Line 1060: DELETE FROM BIS_MEASURES_EXTENSION_TL

1056:
1057: DELETE FROM BIS_MEASURES_EXTENSION
1058: WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
1059:
1060: DELETE FROM BIS_MEASURES_EXTENSION_TL
1061: WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
1062:
1063:
1064: -- Commit if required

Line 1132: -- Add language for the BIS_MEASURES_EXTENSION_TL

1128: PROCEDURE Add_Language IS
1129: BEGIN
1130:
1131:
1132: -- Add language for the BIS_MEASURES_EXTENSION_TL
1133: BEGIN
1134: DELETE FROM BIS_MEASURES_EXTENSION_TL T
1135: WHERE NOT EXISTS
1136: (

Line 1134: DELETE FROM BIS_MEASURES_EXTENSION_TL T

1130:
1131:
1132: -- Add language for the BIS_MEASURES_EXTENSION_TL
1133: BEGIN
1134: DELETE FROM BIS_MEASURES_EXTENSION_TL T
1135: WHERE NOT EXISTS
1136: (
1137: SELECT NULL
1138: FROM BIS_MEASURES_EXTENSION B

Line 1142: UPDATE BIS_MEASURES_EXTENSION_TL T SET (

1138: FROM BIS_MEASURES_EXTENSION B
1139: WHERE B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
1140: );
1141:
1142: UPDATE BIS_MEASURES_EXTENSION_TL T SET (
1143: NAME,
1144: DESCRIPTION
1145: ) = (SELECT
1146: B.NAME,

Line 1148: FROM BIS_MEASURES_EXTENSION_TL B

1144: DESCRIPTION
1145: ) = (SELECT
1146: B.NAME,
1147: B.DESCRIPTION
1148: FROM BIS_MEASURES_EXTENSION_TL B
1149: WHERE B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
1150: AND B.LANGUAGE = T.SOURCE_LANG)
1151: WHERE (
1152: T.MEASURE_SHORT_NAME,

Line 1157: FROM BIS_MEASURES_EXTENSION_TL SUBB, BIS_MEASURES_EXTENSION_TL SUBT

1153: T.LANGUAGE
1154: ) IN (SELECT
1155: SUBT.MEASURE_SHORT_NAME,
1156: SUBT.LANGUAGE
1157: FROM BIS_MEASURES_EXTENSION_TL SUBB, BIS_MEASURES_EXTENSION_TL SUBT
1158: WHERE SUBB.MEASURE_SHORT_NAME = SUBT.MEASURE_SHORT_NAME
1159: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1160: AND (
1161: SUBB.NAME <> SUBT.NAME

Line 1166: INSERT INTO BIS_MEASURES_EXTENSION_TL

1162: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
1163: )
1164: );
1165:
1166: INSERT INTO BIS_MEASURES_EXTENSION_TL
1167: (
1168: MEASURE_SHORT_NAME
1169: ,NAME
1170: ,DESCRIPTION

Line 1190: FROM BIS_MEASURES_EXTENSION_TL B, FND_LANGUAGES L

1186: , B.CREATION_DATE
1187: , B.LAST_UPDATED_BY
1188: , B.LAST_UPDATE_DATE
1189: , B.LAST_UPDATE_LOGIN
1190: FROM BIS_MEASURES_EXTENSION_TL B, FND_LANGUAGES L
1191: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1192: AND B.LANGUAGE = USERENV('LANG')
1193: AND NOT EXISTS
1194: (

Line 1196: FROM BIS_MEASURES_EXTENSION_TL T

1192: AND B.LANGUAGE = USERENV('LANG')
1193: AND NOT EXISTS
1194: (
1195: SELECT NULL
1196: FROM BIS_MEASURES_EXTENSION_TL T
1197: WHERE UPPER(T.MEASURE_SHORT_NAME) = UPPER(B.MEASURE_SHORT_NAME)
1198: AND T.LANGUAGE = L.LANGUAGE_CODE
1199: );
1200: EXCEPTION

Line 1205: -- Add language for the BIS_MEASURES_EXTENSION_TL

1201: WHEN OTHERS THEN
1202: NULL;
1203: END;
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