[Home] [Help]
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'
304: and nullable = 'N' and column_name in (select substr(interface_col_name,3) from
305: bne_interface_cols_b where interface_code = 'FEM_BALANCES_INTF')
306: and column_name not in ('LOAD_SET_ID','LOAD_METHOD_CODE','BAL_POST_TYPE_CODE',
337: l_date_field := FND_MESSAGE.GET;
338:
339: --------------------------- Initially setting interface columns ----------------------------------
340: for interface_cols in
341: (select table_name,column_name,data_type,nullable from dba_tab_columns
342: where owner = 'FEM'
343: and table_name = 'FEM_BAL_INTERFACE_T'
344: and column_name in (select substr(interface_col_name,3) from
345: bne_interface_cols_b where interface_code = 'FEM_BALANCES_INTF'))
401:
402:
403: ----------------------- Setting property for processing key cols ----------------------------------
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