APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_INTEGRATORS_TL

Line 9: delete from BNE_INTEGRATORS_TL T

5:
6: procedure ADD_INTEGRATOR_LANGUAGE
7: is
8: begin
9: delete from BNE_INTEGRATORS_TL T
10: where not exists
11: (select NULL
12: from BNE_INTEGRATORS_B B
13: where B.APPLICATION_ID = T.APPLICATION_ID

Line 17: update BNE_INTEGRATORS_TL T set (

13: where B.APPLICATION_ID = T.APPLICATION_ID
14: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
15: ) and t.application_id=274 and t.integrator_code not in ('FEM_BALANCES_INTG','FEM_DIM_MEMBER_INTG','FEM_HIERARCHY_INTG');
16:
17: update BNE_INTEGRATORS_TL T set (
18: USER_NAME,
19: UPLOAD_TITLE_BAR,
20: UPLOAD_HEADER
21: ) = (select

Line 25: from BNE_INTEGRATORS_TL B

21: ) = (select
22: B.USER_NAME,
23: B.UPLOAD_TITLE_BAR,
24: B.UPLOAD_HEADER
25: from BNE_INTEGRATORS_TL B
26: where B.APPLICATION_ID = T.APPLICATION_ID
27: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
28: and B.LANGUAGE = T.SOURCE_LANG)
29: where (

Line 37: from BNE_INTEGRATORS_TL SUBB, BNE_INTEGRATORS_TL SUBT

33: ) in (select
34: SUBT.APPLICATION_ID,
35: SUBT.INTEGRATOR_CODE,
36: SUBT.LANGUAGE
37: from BNE_INTEGRATORS_TL SUBB, BNE_INTEGRATORS_TL SUBT
38: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
39: and SUBB.INTEGRATOR_CODE = SUBT.INTEGRATOR_CODE
40: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
41: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 50: insert into BNE_INTEGRATORS_TL (

46: or (SUBB.UPLOAD_HEADER is null and SUBT.UPLOAD_HEADER is not null)
47: or (SUBB.UPLOAD_HEADER is not null and SUBT.UPLOAD_HEADER is null)
48: )) and t.application_id = 274 and t.integrator_code not in ('FEM_BALANCES_INTG','FEM_DIM_MEMBER_INTG','FEM_HIERARCHY_INTG') ;
49:
50: insert into BNE_INTEGRATORS_TL (
51: APPLICATION_ID,
52: INTEGRATOR_CODE,
53: USER_NAME,
54: UPLOAD_HEADER,

Line 76: from BNE_INTEGRATORS_TL B, FND_LANGUAGES L

72: B.LAST_UPDATE_LOGIN,
73: B.LAST_UPDATE_DATE,
74: L.LANGUAGE_CODE,
75: B.SOURCE_LANG
76: from BNE_INTEGRATORS_TL B, FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and B.LANGUAGE = userenv('LANG')
79: and not exists
80: (select NULL

Line 81: from BNE_INTEGRATORS_TL T

77: where L.INSTALLED_FLAG in ('I', 'B')
78: and B.LANGUAGE = userenv('LANG')
79: and not exists
80: (select NULL
81: from BNE_INTEGRATORS_TL T
82: where T.APPLICATION_ID = B.APPLICATION_ID
83: and T.INTEGRATOR_CODE = B.INTEGRATOR_CODE
84: and T.LANGUAGE = L.LANGUAGE_CODE) and b.application_id=274 and b.integrator_code not in ('FEM_BALANCES_INTG','FEM_DIM_MEMBER_INTG','FEM_HIERARCHY_INTG');
85: end ADD_INTEGRATOR_LANGUAGE;

Line 2877: delete from bne_integrators_tl where application_id = 274

2873:
2874: delete from bne_interface_cols_tl where application_id = 274
2875: and interface_code not in ('FEM_BALANCES_INTF');
2876:
2877: delete from bne_integrators_tl where application_id = 274
2878: and integrator_code not in ('FEM_BALANCES_INTG');
2879:
2880: delete from bne_integrators_b where application_id = 274
2881: and integrator_code not in ('FEM_BALANCES_INTG');