APPS.BEN_DM_UTILITY dependencies on BEN_DM_COLUMN_MAPPINGS

Line 1175: -- Description: Seeds Mapping into BEN_DM_COLUMN_MAPPINGS for given

1171: END get_table_id;
1172: --
1173:
1174: -- ------------------------- seed_column_mapping --------------------
1175: -- Description: Seeds Mapping into BEN_DM_COLUMN_MAPPINGS for given
1176: -- table
1177: --
1178: --
1179: -- Input Parameters

Line 1204: FROM BEN_DM_COLUMN_MAPPINGS d1

1200: AND table_name = p_table_name
1201: AND column_name not in ('REQUEST_ID','PROGRAM_APPLICATION_ID','PROGRAM_ID','PROGRAM_UPDATE_DATE')
1202: AND data_length < 2001
1203: AND not exists (SELECT null
1204: FROM BEN_DM_COLUMN_MAPPINGS d1
1205: WHERE d1.table_id in (select table_id from ben_dm_tables where table_name = cols1.table_name)
1206: AND column_name = cols1.column_name);
1207:
1208:

Line 1219: FROM ben_dm_column_mappings

1215: WHERE data_type = p_data_type
1216: AND table_name = 'BEN_DM_ENTITY_RESULTS'
1217: AND column_name not in ('ENTITY_RESULT_ID','MIGRATION_ID','TABLE_NAME','GROUP_ORDER')
1218: AND column_name not in (SELECT entity_result_column_name
1219: FROM ben_dm_column_mappings
1220: WHERE table_id = p_table_id)
1221: ORDER BY column_id asc;
1222:
1223:

Line 1243: INSERT into ben_dm_column_mappings

1239: OPEN csr_get_er_columns(column_list.data_type, l_table_id, column_list.column_name);
1240: FETCH csr_get_er_columns INTO l_er_column_name;
1241: CLOSE csr_get_er_columns;
1242:
1243: INSERT into ben_dm_column_mappings
1244: (column_mapping_id
1245: ,table_id
1246: ,column_name
1247: ,entity_result_column_name

Line 1254: (ben_dm_column_mappings_s.nextval

1250: ,last_update_login
1251: ,created_by
1252: ,creation_date)
1253: VALUES
1254: (ben_dm_column_mappings_s.nextval
1255: ,l_table_id
1256: ,column_list.column_name
1257: ,l_er_column_name
1258: ,sysdate