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_GEN_UPLOAD dependencies on BEN_DM_DATA_UTIL

Line 415: l_cursor:= l_cursor||'l_pk_key := ben_dm_data_util.get_cache_target('||indent(l_indent);

411: hr_utility.set_location('datetrack : ' || p_table_info.DATETRACK , 5 ) ;
412: if p_table_info.DATETRACK = 'Y' or l_h_hierarcy = 'Y' then
413:
414: l_indent := 40 ;
415: l_cursor:= l_cursor||'l_pk_key := ben_dm_data_util.get_cache_target('||indent(l_indent);
416: l_cursor:= l_cursor||' p_table_name => '''||p_table_info.table_name||'''' || indent(l_indent) ;
417: l_cursor:= l_cursor||',p_source_id => l_fk_map_id '||indent(l_indent);
418: l_cursor:= l_cursor||',p_source_column => '''||p_table_info.SURROGATE_PK_COLUMN_NAME||'''' || indent(l_indent);
419: l_cursor:= l_cursor||',p_business_group_name => p_business_group_name ' || indent(l_indent);

Line 433: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent) ;

429:
430: -- update the prmiary key to mapping table
431: l_cursor := l_cursor || '-- update the primiary key to mapping table ' || indent(l_indent) ;
432: l_indent := 40 ;
433: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent) ;
434: l_cursor := l_cursor || ' p_target_id => l_rslt.PM_KEY ' || indent(l_indent) ;
435: l_cursor := l_cursor || ',p_table_name => '''||p_table_info.table_name||'''' || indent(l_indent) ;
436: l_cursor := l_cursor || ',p_source_id => l_fk_map_id' || indent(l_indent) ;
437: l_cursor := l_cursor || ',p_source_column => '''||p_table_info.SURROGATE_PK_COLUMN_NAME||'''' ||indent(l_indent);

Line 458: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent) ;

454:
455: -- update the prmiary key to mapping table
456: l_cursor := l_cursor || '-- update the prmiary key to mapping table ' || indent(l_indent) ;
457: l_indent := 40 ;
458: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent) ;
459: l_cursor := l_cursor || ' p_target_id => l_rslt.PM_KEY ' || indent(l_indent) ;
460: l_cursor := l_cursor || ',p_table_name => '''||p_table_info.table_name||'''' || indent(l_indent) ;
461: l_cursor := l_cursor || ',p_source_id => l_fk_map_id' || indent(l_indent) ;
462: l_cursor := l_cursor || ',p_source_column => '''||p_table_info.SURROGATE_PK_COLUMN_NAME||'''' ||indent(l_indent);

Line 510: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_mapping_target('||indent(l_indent+40);

506: close hier_type ;
507: hr_utility.set_location(' hierarchy_type e '|| l_hierarchy_type , 5 ) ;
508: if l_hierarchy_type is not null then
509: if l_hierarchy_type = 'S' then
510: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_mapping_target('||indent(l_indent+40);
511: else
512: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_cache_target('||indent(l_indent+40);
513: end if ;
514: l_cursor := l_cursor||' p_table_name => '''||l_parent_table_name||'''' || indent(l_indent+40) ;

Line 512: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_cache_target('||indent(l_indent+40);

508: if l_hierarchy_type is not null then
509: if l_hierarchy_type = 'S' then
510: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_mapping_target('||indent(l_indent+40);
511: else
512: l_cursor:=l_cursor||'l_rslt.'||l_pk_rec.column_name||':= ben_dm_data_util.get_cache_target('||indent(l_indent+40);
513: end if ;
514: l_cursor := l_cursor||' p_table_name => '''||l_parent_table_name||'''' || indent(l_indent+40) ;
515: l_cursor := l_cursor||',p_source_id => l_fk_map_id '||indent(l_indent+40);
516: l_cursor := l_cursor||',p_source_column => '''||l_parent_id_column_name||'''' || indent(l_indent+40);

Line 534: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent+9) ;

530: if l_hierarchy_type = 'H' then
531: l_cursor := l_cursor|| 'Begin ' || indent(l_indent+9);
532: l_cursor := l_cursor|| 'select '||p_table_info.SEQUENCE_NAME ||'.NEXTVAL into l_rslt.'|| l_pk_rec.column_name
533: ||' from dual ;'|| indent(l_indent+9);
534: l_cursor := l_cursor || 'ben_dm_data_util.create_pk_cache( ' || indent(l_indent+9) ;
535: l_cursor := l_cursor || ' p_target_id => l_rslt.'|| l_pk_rec.column_name || indent(l_indent+9) ;
536: l_cursor := l_cursor || ',p_table_name => '''||p_table_info.table_name||'''' || indent(l_indent+9) ;
537: l_cursor := l_cursor || ',p_source_id => l_fk_map_id ' || indent(l_indent+9) ;
538: l_cursor := l_cursor || ',p_source_column => '''||p_table_info.SURROGATE_PK_COLUMN_NAME||'''' ||indent(l_indent+9);

Line 606: l_cursor := l_cursor|| 'l_rslt.BKUP_TBL_ID '||':= ben_dm_data_util.get_cache_target('||indent(l_indent+40);

602: l_cursor := l_cursor|| 'hr_utility.set_location(''PK name '' || l_pk_column_name , 90); ' || indent(l_indent) ;
603: l_cursor := l_cursor|| 'hr_utility.set_location(''old value '' || l_rslt.BKUP_TBL_ID , 90);' || indent(l_indent) ;
604: l_cursor := l_cursor|| 'if l_pk_column_name is not null then ' || indent(l_indent+3) ;
605: l_cursor := l_cursor|| 'l_fk_map_id := l_rslt.BKUP_TBL_ID ; '||indent(l_indent+3);
606: l_cursor := l_cursor|| 'l_rslt.BKUP_TBL_ID '||':= ben_dm_data_util.get_cache_target('||indent(l_indent+40);
607: l_cursor := l_cursor|| ' p_table_name => l_table_name '||indent(l_indent+40) ;
608: l_cursor := l_cursor|| ',p_source_id => l_rslt.BKUP_TBL_ID '||indent(l_indent+40);
609: l_cursor := l_cursor|| ',p_source_column => l_pk_column_name ' || indent(l_indent+40);
610: l_cursor := l_cursor|| ',p_business_group_name => p_business_group_name ' || indent(l_indent+40);

Line 645: l_cursor := l_cursor|| 'l_curr_prtt_enrt_rslt_id := ben_dm_data_util.get_cache_target( '||indent(l_indent+12);

641: l_cursor := l_cursor|| 'l_prev_prtt_enrt_rslt_id := to_number(substr(l_rslt.cryfwd_elig_dpnt_cd,l_prev_rslt_id_at+1) );'||indent(l_indent+7);
642: l_cursor := l_cursor|| 'IF l_prev_prtt_enrt_rslt_id IS NOT NULL THEN '||indent(l_indent+9);
643: --
644: l_cursor := l_cursor|| 'l_fk_map_id := l_prev_prtt_enrt_rslt_id ; '||indent(l_indent+9);
645: l_cursor := l_cursor|| 'l_curr_prtt_enrt_rslt_id := ben_dm_data_util.get_cache_target( '||indent(l_indent+12);
646: l_cursor := l_cursor|| 'p_table_name => ''BEN_PRTT_ENRT_RSLT_F'' '||indent(l_indent+12);
647: l_cursor := l_cursor|| ',p_source_id => l_fk_map_id '||indent(l_indent+12);
648: l_cursor := l_cursor|| ',p_source_column => ''PRTT_ENRT_RSLT_ID'' '||indent(l_indent+12);
649: l_cursor := l_cursor|| ',p_business_group_name => p_business_group_name '||indent(l_indent+12);

Line 781: ben_dm_data_util.get_generator_version(p_generator_version => l_generator_version,

777: -- Get the version of the generator to be appended to the TUPS package
778: -- generated for a table. This will help in finding out which version
779: -- of Generator is used to generate the TUPS package.
780:
781: ben_dm_data_util.get_generator_version(p_generator_version => l_generator_version,
782: p_format_output => 'Y');
783:
784: -- Get the package version of this TDS package body.
785: hr_dm_library.get_package_version ( p_package_name => 'BEN_DM_GEN_UPLOAD',

Line 911: -- ben_dm_data_util.update_gen_version (p_table_id => l_tbl_rec.table_id

907: end;
908:
909: hr_utility.set_location( 'Uplaod complteed '|| l_tbl_rec.table_name , 99 ) ;
910: -- update the generated version number
911: -- ben_dm_data_util.update_gen_version (p_table_id => l_tbl_rec.table_id
912: -- ,p_version => l_generator_version
913: -- ) ;
914: --
915: