APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_INTERFACE_COLS_TL

Line 1426: ----------------- For bne_interface_cols_tl

1422: --'oracle.apps.fem.integrator.dimension.validators.FemAttributeNumericTypeValidator',
1423: NULL)) -- variable data type class
1424: );
1425:
1426: ----------------- For bne_interface_cols_tl
1427:
1428: if(new_rec.fem_data_type = 'DIMENSION') then
1429:
1430: INSERT INTO BNE_INTERFACE_COLS_TL

Line 1430: INSERT INTO BNE_INTERFACE_COLS_TL

1426: ----------------- For bne_interface_cols_tl
1427:
1428: if(new_rec.fem_data_type = 'DIMENSION') then
1429:
1430: INSERT INTO BNE_INTERFACE_COLS_TL
1431: (
1432: CREATED_BY,
1433: CREATION_DATE,
1434: LAST_UPDATED_BY,

Line 1478: INSERT INTO BNE_INTERFACE_COLS_TL

1474: AND M.LANGUAGE_CODE (+) = L.LANGUAGE_CODE;
1475:
1476: else
1477:
1478: INSERT INTO BNE_INTERFACE_COLS_TL
1479: (
1480: CREATED_BY,
1481: CREATION_DATE,
1482: LAST_UPDATED_BY,

Line 1543: -- A row in the bne_interface_cols_tl only, ensures that the interface column info is fine.

1539: -- end if;
1540:
1541: end loop; -- Ending loop for inseting into bne_interface_cols tables.
1542:
1543: -- A row in the bne_interface_cols_tl only, ensures that the interface column info is fine.
1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.
1545: -- and disable any ledger, source_system, cal_period, dataset, cal period number, cal period grp display code, cal period end date.
1546:
1547: update bne_interface_cols_b

Line 1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.

1540:
1541: end loop; -- Ending loop for inseting into bne_interface_cols tables.
1542:
1543: -- A row in the bne_interface_cols_tl only, ensures that the interface column info is fine.
1544: -- now disable the columns in bne_interface_cols_b for which there is no entry in bne_interface_cols_tl.
1545: -- and disable any ledger, source_system, cal_period, dataset, cal period number, cal period grp display code, cal period end date.
1546:
1547: update bne_interface_cols_b
1548: set enabled_flag = 'N',

Line 1644: delete from bne_interface_cols_tl

1640: begin
1641: delete from bne_interface_cols_b
1642: where interface_code = p_interface_code;
1643:
1644: delete from bne_interface_cols_tl
1645: where interface_code = p_interface_code;
1646:
1647: select display_name into l_table_display_name from fem_tables_vl
1648: where table_name = l_table_name;

Line 1835: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL

1831: l_interface_cols_tbl(6).FND_MESSAGE_NAME := 'FEM_ADI_SOURCE_SYSTEM_NAME';
1832: l_interface_cols_tbl(6).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1833:
1834: -----------------------------------------------------------------------------
1835: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL
1836: -----------------------------------------------------------------------------
1837: FOR i IN l_interface_cols_tbl.FIRST .. l_interface_cols_tbl.LAST
1838: LOOP
1839: INSERT INTO BNE_INTERFACE_COLS_B (

Line 1928: INSERT INTO BNE_INTERFACE_COLS_TL (

1924: l_login_id,
1925: NULL
1926: );
1927:
1928: INSERT INTO BNE_INTERFACE_COLS_TL (
1929: CREATED_BY,
1930: CREATION_DATE,
1931: LAST_UPDATED_BY,
1932: LAST_UPDATE_LOGIN,

Line 2874: delete from bne_interface_cols_tl where application_id = 274

2870:
2871: delete from bne_interface_cols_b where application_id = 274
2872: and interface_code not in ('FEM_BALANCES_INTF');
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');