eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DATA_UTIL dependencies on BEN_DM_RESOLVE_MAPPINGS

Line 41: from ben_dm_resolve_mappings bdm

37: l_proc varchar2(75) ;
38:
39: cursor c1 is
40: select target_id
41: from ben_dm_resolve_mappings bdm
42: where resolve_mapping_id = p_resolve_mapping_id
43: ;
44: l_target_id number ;
45: begin

Line 92: from ben_dm_resolve_mappings bdm

88:
89:
90: cursor c1 is
91: select target_id
92: from ben_dm_resolve_mappings bdm
93: where table_name = p_table_name
94: and column_name = p_source_column
95: and source_id = p_source_id
96: ;

Line 234: from ben_dm_resolve_mappings

230: table_name,
231: source_id,
232: column_name,
233: business_group_name
234: from ben_dm_resolve_mappings
235: where target_id is not null
236: ;
237: Begin
238: l_proc := g_package||'create_fk_cache' ;

Line 262: -- p_table_name = ben_dm_resolve_mappings.table_name

258: -- p_resolve_mapping_id = resolve mapping table id
259: --
260: -- 2
261: --
262: -- p_table_name = ben_dm_resolve_mappings.table_name
263: -- p_column_name = ben_dm_resolve_mappings.column_name
264: -- p_source_id is not null = ben_dm_resolve_mappings.source_id
265: -- p_business_group_name = target instance business group name
266: --

Line 263: -- p_column_name = ben_dm_resolve_mappings.column_name

259: --
260: -- 2
261: --
262: -- p_table_name = ben_dm_resolve_mappings.table_name
263: -- p_column_name = ben_dm_resolve_mappings.column_name
264: -- p_source_id is not null = ben_dm_resolve_mappings.source_id
265: -- p_business_group_name = target instance business group name
266: --
267: -- 3

Line 264: -- p_source_id is not null = ben_dm_resolve_mappings.source_id

260: -- 2
261: --
262: -- p_table_name = ben_dm_resolve_mappings.table_name
263: -- p_column_name = ben_dm_resolve_mappings.column_name
264: -- p_source_id is not null = ben_dm_resolve_mappings.source_id
265: -- p_business_group_name = target instance business group name
266: --
267: -- 3
268: --

Line 269: -- p_source_id = ben_dm_resolve_mappings.source_id

265: -- p_business_group_name = target instance business group name
266: --
267: -- 3
268: --
269: -- p_source_id = ben_dm_resolve_mappings.source_id
270: -- p_source_column = ben_dm_hierarchies.column_name
271: -- p_business_group_name = target instance business group name
272: -- p_Table_id = ben_dm_hierarchies.table_id
273: --------------------------------------------------------------------------------

Line 289: from ben_dm_resolve_mappings brm

285: l_dummy varchar2(1) ;
286:
287: cursor c1 is
288: select target_id
289: from ben_dm_resolve_mappings brm
290: where brm.resolve_mapping_id = p_resolve_mapping_id
291: ;
292:
293:

Line 299: from ben_dm_resolve_mappings brm

295: cursor c2 (c_column_name varchar2 ,
296: c_table_name varchar2) is
297: select brm.resolve_mapping_id ,
298: brm.target_id
299: from ben_dm_resolve_mappings brm
300: where table_name = c_table_name
301: and source_id = p_source_id
302: and column_name = c_column_name
303: and business_group_name = p_business_group_name

Line 317: l_target_id ben_dm_resolve_mappings.target_id%type ;

313: and column_name = p_source_column
314: ;
315:
316:
317: l_target_id ben_dm_resolve_mappings.target_id%type ;
318: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type ;
319: l_column_name ben_dm_resolve_mappings.column_name%type ;
320: l_table_name ben_dm_resolve_mappings.table_name%type ;
321:

Line 318: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type ;

314: ;
315:
316:
317: l_target_id ben_dm_resolve_mappings.target_id%type ;
318: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type ;
319: l_column_name ben_dm_resolve_mappings.column_name%type ;
320: l_table_name ben_dm_resolve_mappings.table_name%type ;
321:
322: begin

Line 319: l_column_name ben_dm_resolve_mappings.column_name%type ;

315:
316:
317: l_target_id ben_dm_resolve_mappings.target_id%type ;
318: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type ;
319: l_column_name ben_dm_resolve_mappings.column_name%type ;
320: l_table_name ben_dm_resolve_mappings.table_name%type ;
321:
322: begin
323:

Line 320: l_table_name ben_dm_resolve_mappings.table_name%type ;

316:
317: l_target_id ben_dm_resolve_mappings.target_id%type ;
318: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type ;
319: l_column_name ben_dm_resolve_mappings.column_name%type ;
320: l_table_name ben_dm_resolve_mappings.table_name%type ;
321:
322: begin
323:
324: l_proc := g_package || 'update_pk_mapping' ;

Line 384: update ben_dm_resolve_mappings

380: end if ;
381:
382: if l_resolve_mapping_id is not null then
383:
384: update ben_dm_resolve_mappings
385: set target_id = p_target_id
386: where resolve_mapping_id = l_resolve_mapping_id ;
387: end if ;
388: end if ;

Line 400: --This procedure insert the data into table BEN_DM_RESOLVE_MAPPINGS

396: end update_pk_mapping ;
397:
398: ------------------------------------------------------------------------------
399: --create pk_mapping
400: --This procedure insert the data into table BEN_DM_RESOLVE_MAPPINGS
401: --if the parameter is the table id , convert them into name
402: -------------------------------------------------------------------------------
403: procedure create_pk_mapping(
404: p_resolve_mapping_id out nocopy NUMBER

Line 435: from ben_dm_resolve_mappings brm

431:
432:
433: cursor c2 (c_table_name varchar2) is
434: select resolve_mapping_id
435: from ben_dm_resolve_mappings brm
436: where brm.table_name = c_table_name
437: and brm.column_name = p_column_name
438: and brm.source_id = p_source_id
439: and brm.business_group_name = p_business_group_name

Line 500: select BEN_DM_RESOLVE_MAPPINGS_S.nextval

496: end if ;
497: close c2 ;
498: hr_utility.set_location(' Inserting the value :'||l_proc, 20);
499: -- get the pk key
500: select BEN_DM_RESOLVE_MAPPINGS_S.nextval
501: into p_resolve_mapping_id from dual ;
502:
503: --p_resolve_mapping_id := BEN_DM_RESOLVE_MAPPINGS_S.nextval ;
504: insert into ben_dm_resolve_mappings

Line 503: --p_resolve_mapping_id := BEN_DM_RESOLVE_MAPPINGS_S.nextval ;

499: -- get the pk key
500: select BEN_DM_RESOLVE_MAPPINGS_S.nextval
501: into p_resolve_mapping_id from dual ;
502:
503: --p_resolve_mapping_id := BEN_DM_RESOLVE_MAPPINGS_S.nextval ;
504: insert into ben_dm_resolve_mappings
505: ( resolve_mapping_id
506: ,table_name
507: ,column_name

Line 504: insert into ben_dm_resolve_mappings

500: select BEN_DM_RESOLVE_MAPPINGS_S.nextval
501: into p_resolve_mapping_id from dual ;
502:
503: --p_resolve_mapping_id := BEN_DM_RESOLVE_MAPPINGS_S.nextval ;
504: insert into ben_dm_resolve_mappings
505: ( resolve_mapping_id
506: ,table_name
507: ,column_name
508: ,source_id