APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT dependencies on FEM_TAB_COLUMNS_B

Line 297: and (not exists (select 1 from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and

293: 'LAST_UPDATED_BY_OBJECT_ID',
294: 'CREATION_ROW_SEQUENCE',
295: 'DATASET_CODE',
296: 'CAL_PERIOD_ID')
297: and (not exists (select 1 from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and
298: ftc.column_name = fcp.column_name) or
299: fcp.column_name in(select column_name from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and
300: ftc.column_name = fcp.column_name and interface_column_name is null))
301: UNION

Line 299: fcp.column_name in(select column_name from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and

295: 'DATASET_CODE',
296: 'CAL_PERIOD_ID')
297: and (not exists (select 1 from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and
298: ftc.column_name = fcp.column_name) or
299: fcp.column_name in(select column_name from fem_tab_columns_b ftc where table_name = 'FEM_BALANCES' and
300: ftc.column_name = fcp.column_name and interface_column_name is null))
301: UNION
302: select column_name from dba_tab_columns M
303: where owner = 'FEM' and table_name = 'FEM_BAL_INTERFACE_T'

Line 310: and not exists (SELECT 1 FROM FEM_TAB_COLUMNS_B T WHERE TABLE_NAME = 'FEM_BALANCES' AND T.INTERFACE_COLUMN_NAME = M.COLUMN_NAME));

306: and column_name not in ('LOAD_SET_ID','LOAD_METHOD_CODE','BAL_POST_TYPE_CODE',
307: 'DS_BALANCE_TYPE_CODE','CAL_PER_DIM_GRP_DISPLAY_CODE','CAL_PERIOD_NUMBER','CAL_PERIOD_END_DATE',
308: 'XTD_BALANCE_E','XTD_BALANCE_F','YTD_BALANCE_E','YTD_BALANCE_F','QTD_BALANCE_E','QTD_BALANCE_F',
309: 'PTD_DEBIT_BALANCE_E','PTD_CREDIT_BALANCE_E','YTD_DEBIT_BALANCE_E','YTD_CREDIT_BALANCE_E')
310: and not exists (SELECT 1 FROM FEM_TAB_COLUMNS_B T WHERE TABLE_NAME = 'FEM_BALANCES' AND T.INTERFACE_COLUMN_NAME = M.COLUMN_NAME));
311: exception
312: when NO_DATA_FOUND then
313: x_error_flag := 'N';
314: end;

Line 350: select fem_data_type_code into l_fem_type from fem_tab_columns_b

346:
347: loop
348:
349: begin
350: select fem_data_type_code into l_fem_type from fem_tab_columns_b
351: where table_name = 'FEM_BALANCES'
352: and interface_column_name = interface_cols.column_name;
353: exception
354: when NO_DATA_FOUND then

Line 408: and column_name in (select ftc.interface_column_name interface_column_name from fem_tab_columns_b ftc,fem_tab_column_prop fcp

404: for key_recs in
405: (select table_name,column_name,data_type,nullable from dba_tab_columns
406: where owner = 'FEM'
407: and table_name = 'FEM_BAL_INTERFACE_T'
408: and column_name in (select ftc.interface_column_name interface_column_name from fem_tab_columns_b ftc,fem_tab_column_prop fcp
409: where ftc.table_name = fcp.table_name
410: and ftc.column_name = fcp.column_name
411: and ftc.table_name = 'FEM_BALANCES'
412: and fcp.column_property_code = 'PROCESSING_KEY'

Line 423: select fem_data_type_code into l_fem_type from fem_tab_columns_b

419:
420: loop
421:
422: begin
423: select fem_data_type_code into l_fem_type from fem_tab_columns_b
424: where table_name = 'FEM_BALANCES'
425: and interface_column_name = key_recs.column_name;
426: exception
427: when NO_DATA_FOUND then