APPS.BEN_DM_DATA_UTIL dependencies on BEN_DM_TABLES

Line 428: ben_dm_tables bdt

424: ,p_creation_date in DATE DEFAULT NULL ) is
425:
426: cursor c1 is
427: select table_name from
428: ben_dm_tables bdt
429: where bdt.table_id = p_table_id
430: ;
431:
432:

Line 442: l_table_name ben_dm_tables.table_name%type ;

438: and brm.source_id = p_source_id
439: and brm.business_group_name = p_business_group_name
440: ;
441:
442: l_table_name ben_dm_tables.table_name%type ;
443: l_proc varchar2(75) ;
444: l_dummy varchar2(1) ;
445: l_resolve_mapping_id number(15) ;
446: l_count number;

Line 823: l_table_name ben_dm_tables.table_name%type ;

819: -- validtion migration
820:
821: l_text varchar2(32667);
822: l_delimiter varchar2(1) := fnd_global.local_chr(01);
823: l_table_name ben_dm_tables.table_name%type ;
824: l_proc varchar2(75) ;
825: l_dummy varchar2(1) ;
826: begin
827:

Line 1352: from ben_dm_tables

1348:
1349:
1350: cursor c1 is
1351: select table_id
1352: from ben_dm_tables
1353: where table_name = p_table_name ;
1354:
1355: l_table_id number ;
1356: l_proc varchar2(70) ;

Line 1365: update ben_dm_tables

1361: open c1 ;
1362: fetch c1 into l_table_id ;
1363: if c1%found then
1364: hr_utility.set_location(' Insert :'||p_table_name, 10);
1365: update ben_dm_tables
1366: set table_name = p_table_name
1367: ,upload_table_name = p_upload_table_name
1368: ,table_alias = p_table_alias
1369: ,datetrack = p_datetrack

Line 1381: insert into ben_dm_tables

1377: where table_id = l_table_id ;
1378:
1379: else
1380: hr_utility.set_location(' Update :'||p_table_name, 10);
1381: insert into ben_dm_tables
1382: ( table_id
1383: ,table_name
1384: ,upload_table_name
1385: ,table_alias

Line 1398: ben_dm_tables_s.nextval

1394: ,created_by
1395: ,creation_date
1396: ) values
1397: (
1398: ben_dm_tables_s.nextval
1399: ,p_table_name
1400: ,p_upload_table_name
1401: ,p_table_alias
1402: ,p_datetrack

Line 1434: from ben_dm_tables

1430:
1431:
1432: cursor c1 is
1433: select table_id
1434: from ben_dm_tables
1435: where table_name = p_table_name ;
1436:
1437: l_table_id number ;
1438:

Line 1519: from ben_dm_tables

1515: ) is
1516:
1517: cursor c1 is
1518: select table_id
1519: from ben_dm_tables
1520: where table_name = p_table_name ;
1521:
1522: l_table_id number ;
1523:

Line 1610: from ben_dm_tables

1606: ,p_entity_result_column_name in varchar2
1607: ) is
1608: cursor c1 is
1609: select table_id
1610: from ben_dm_tables
1611: where table_name = p_table_name ;
1612:
1613: l_table_id number ;
1614:

Line 1754: update ben_dm_tables

1750: Begin
1751: l_proc := g_package || 'update_gen_version' ;
1752: hr_utility.set_location('Entering :'||l_proc, 5);
1753:
1754: update ben_dm_tables
1755: set GENERATOR_VERSION = replace(replace (p_version,' $Header:',''),' - ',':')
1756: , LAST_GENERATED_DATE = sysdate
1757: where table_id = p_table_id ;
1758: