APPS.BEN_DM_UTILITY dependencies on BEN_DM_HIERARCHIES

Line 1368: l_table_id ben_dm_hierarchies.table_id%type;

1364: p_parent_column_name varchar2 default null,
1365: p_parent_id_column_name varchar2 default null,
1366: p_hierarchy_type varchar2 default 'PC') is
1367:
1368: l_table_id ben_dm_hierarchies.table_id%type;
1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;

Line 1369: l_column_name ben_dm_hierarchies.column_name%type;

1365: p_parent_id_column_name varchar2 default null,
1366: p_hierarchy_type varchar2 default 'PC') is
1367:
1368: l_table_id ben_dm_hierarchies.table_id%type;
1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;
1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;

Line 1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;

1366: p_hierarchy_type varchar2 default 'PC') is
1367:
1368: l_table_id ben_dm_hierarchies.table_id%type;
1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;
1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;
1374:

Line 1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;

1367:
1368: l_table_id ben_dm_hierarchies.table_id%type;
1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;
1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;
1374:
1375: BEGIN

Line 1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;

1368: l_table_id ben_dm_hierarchies.table_id%type;
1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;
1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;
1374:
1375: BEGIN
1376:

Line 1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;

1369: l_column_name ben_dm_hierarchies.column_name%type;
1370: l_parent_table_name ben_dm_hierarchies.parent_table_name%type;
1371: l_parent_column_name ben_dm_hierarchies.parent_column_name%type;
1372: l_parent_id_column_name ben_dm_hierarchies.parent_id_column_name%type;
1373: l_hierarchy_type ben_dm_hierarchies.hierarchy_type%type;
1374:
1375: BEGIN
1376:
1377: l_table_id := get_table_id(p_table_name );

Line 1392: insert into ben_dm_hierarchies

1388:
1389: l_parent_id_column_name := p_parent_id_column_name;
1390:
1391: -- insert into hr_dm_hierarchy table.
1392: insert into ben_dm_hierarchies
1393: ( hierarchy_id
1394: ,hierarchy_type
1395: ,table_id
1396: ,column_name

Line 1405: select ben_dm_hierarchies_s.nextval

1401: ,last_updated_by
1402: ,last_update_login
1403: ,created_by
1404: ,creation_date )
1405: select ben_dm_hierarchies_s.nextval
1406: ,l_hierarchy_type
1407: ,l_table_id
1408: ,l_column_name
1409: ,l_parent_table_name

Line 1419: from ben_dm_hierarchies hir

1415: ,1
1416: ,sysdate
1417: from dual
1418: where not exists (select 'x'
1419: from ben_dm_hierarchies hir
1420: where hir.hierarchy_type = l_hierarchy_type
1421: and hir.table_id = l_table_id
1422: and nvl(hir.column_name,'X') = nvl(l_column_name,
1423: 'X')