APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_CONTENT_COLS_TL

Line 161: delete from BNE_CONTENT_COLS_TL T

157:
158: procedure ADD_CONTENT_COLS_LANGUAGE
159: is
160: begin
161: delete from BNE_CONTENT_COLS_TL T
162: where not exists
163: (select NULL
164: from BNE_CONTENT_COLS_B B
165: where B.APPLICATION_ID = T.APPLICATION_ID

Line 170: update BNE_CONTENT_COLS_TL T set (

166: and B.CONTENT_CODE = T.CONTENT_CODE
167: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
168: ) and t.application_id=274 and t.content_code not in ('FEM_BALANCES_CNT','FEM_DIM_MEMBER_CNT','FEM_HIERARCHY_CNT');
169:
170: update BNE_CONTENT_COLS_TL T set (
171: USER_NAME
172: ) = (select
173: B.USER_NAME
174: from BNE_CONTENT_COLS_TL B

Line 174: from BNE_CONTENT_COLS_TL B

170: update BNE_CONTENT_COLS_TL T set (
171: USER_NAME
172: ) = (select
173: B.USER_NAME
174: from BNE_CONTENT_COLS_TL B
175: where B.APPLICATION_ID = T.APPLICATION_ID
176: and B.CONTENT_CODE = T.CONTENT_CODE
177: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
178: and B.LANGUAGE = T.SOURCE_LANG)

Line 189: from BNE_CONTENT_COLS_TL SUBB, BNE_CONTENT_COLS_TL SUBT

185: SUBT.APPLICATION_ID,
186: SUBT.CONTENT_CODE,
187: SUBT.SEQUENCE_NUM,
188: SUBT.LANGUAGE
189: from BNE_CONTENT_COLS_TL SUBB, BNE_CONTENT_COLS_TL SUBT
190: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
191: and SUBB.CONTENT_CODE = SUBT.CONTENT_CODE
192: and SUBB.SEQUENCE_NUM = SUBT.SEQUENCE_NUM
193: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 197: insert into BNE_CONTENT_COLS_TL (

193: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
194: and (SUBB.USER_NAME <> SUBT.USER_NAME))
195: and t.application_id=274 and t.content_code not in ('FEM_BALANCES_CNT','FEM_DIM_MEMBER_CNT','FEM_HIERARCHY_CNT');
196:
197: insert into BNE_CONTENT_COLS_TL (
198: APPLICATION_ID,
199: CONTENT_CODE,
200: SEQUENCE_NUM,
201: USER_NAME,

Line 221: from BNE_CONTENT_COLS_TL B, FND_LANGUAGES L

217: B.LAST_UPDATE_LOGIN,
218: B.LAST_UPDATE_DATE,
219: L.LANGUAGE_CODE,
220: B.SOURCE_LANG
221: from BNE_CONTENT_COLS_TL B, FND_LANGUAGES L
222: where L.INSTALLED_FLAG in ('I', 'B')
223: and B.LANGUAGE = userenv('LANG')
224: and not exists
225: (select NULL

Line 226: from BNE_CONTENT_COLS_TL T

222: where L.INSTALLED_FLAG in ('I', 'B')
223: and B.LANGUAGE = userenv('LANG')
224: and not exists
225: (select NULL
226: from BNE_CONTENT_COLS_TL T
227: where T.APPLICATION_ID = B.APPLICATION_ID
228: and T.CONTENT_CODE = B.CONTENT_CODE
229: and T.SEQUENCE_NUM = B.SEQUENCE_NUM
230: and T.LANGUAGE = L.LANGUAGE_CODE) and b.application_id=274 and b.content_code not in ('FEM_BALANCES_CNT','FEM_DIM_MEMBER_CNT','FEM_HIERARCHY_CNT');

Line 2844: delete from bne_content_cols_tl where application_id = 274

2840:
2841: delete from bne_layout_blocks_b where application_id = 274
2842: and layout_code not in ('FEM_BALANCES_LAYOUT');
2843:
2844: delete from bne_content_cols_tl where application_id = 274
2845: and content_code not in ('FEM_BALANCES_CNT');
2846:
2847: delete from bne_content_cols_b where application_id = 274
2848: and content_code not in ('FEM_BALANCES_CNT');