[Home] [Help]
65:
66: -------------------------------- get_mapping_target ------------------------
67: -- this procedure called from upload package to find the target_id for
68: -- the foreign keys this procedure called with
69: -- p_table_name = ben_dm_hierarchies.parent_table_name
70: -- p_source_id = ben_dm_hierarchies.column_name value
71: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
72: -- p_business_group_name = target business group name
73: -- when the hierarchy type is 'S' this procedure is called
66: -------------------------------- get_mapping_target ------------------------
67: -- this procedure called from upload package to find the target_id for
68: -- the foreign keys this procedure called with
69: -- p_table_name = ben_dm_hierarchies.parent_table_name
70: -- p_source_id = ben_dm_hierarchies.column_name value
71: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
72: -- p_business_group_name = target business group name
73: -- when the hierarchy type is 'S' this procedure is called
74: ----------------------------------------------------------------------------
67: -- this procedure called from upload package to find the target_id for
68: -- the foreign keys this procedure called with
69: -- p_table_name = ben_dm_hierarchies.parent_table_name
70: -- p_source_id = ben_dm_hierarchies.column_name value
71: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
72: -- p_business_group_name = target business group name
73: -- when the hierarchy type is 'S' this procedure is called
74: ----------------------------------------------------------------------------
75: function get_mapping_target(p_table_name in varchar2
133:
134: -------------------------------- get_cache_target ------------------------
135: -- this procedure called from upload package to find the target_id for
136: -- the foreign keys this procedure called with
137: -- p_table_name = ben_dm_hierarchies.parent_table_name
138: -- p_source_id = ben_dm_hierarchies.column_name value
139: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
140: -- p_business_group_name = target business group name
141: -- when the hierarchy type is not 'S' and the key is not in cache dont error
134: -------------------------------- get_cache_target ------------------------
135: -- this procedure called from upload package to find the target_id for
136: -- the foreign keys this procedure called with
137: -- p_table_name = ben_dm_hierarchies.parent_table_name
138: -- p_source_id = ben_dm_hierarchies.column_name value
139: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
140: -- p_business_group_name = target business group name
141: -- when the hierarchy type is not 'S' and the key is not in cache dont error
142: -- the key may be created later - some special procedure will take care of it
135: -- this procedure called from upload package to find the target_id for
136: -- the foreign keys this procedure called with
137: -- p_table_name = ben_dm_hierarchies.parent_table_name
138: -- p_source_id = ben_dm_hierarchies.column_name value
139: -- p_source_column = ben_dm_hierarchies.parent_id_column_name
140: -- p_business_group_name = target business group name
141: -- when the hierarchy type is not 'S' and the key is not in cache dont error
142: -- the key may be created later - some special procedure will take care of it
143: ----------------------------------------------------------------------------
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: --------------------------------------------------------------------------------
274: procedure update_pk_mapping(
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: --------------------------------------------------------------------------------
274: procedure update_pk_mapping(
275: p_resolve_mapping_id in NUMBER DEFAULT null
276: ,p_target_id in NUMBER
307: -- the promary key of the tables
308: cursor c3 is
309: select parent_id_column_name, -- confirm with sarju
310: parent_table_name
311: from ben_dm_hierarchies
312: where table_id = p_table_id
313: and column_name = p_source_column
314: ;
315:
1522: l_table_id number ;
1523:
1524: cursor c2 is
1525: select hierarchy_id
1526: from ben_dm_hierarchies
1527: where table_id = l_table_id
1528: and column_name = p_column_name
1529: ;
1530: l_hierarchy_id number ;
1548: fetch c2 into l_hierarchy_id ;
1549: if c2%found then
1550:
1551: hr_utility.set_location(' Insert :'||p_table_name, 10);
1552: update ben_dm_hierarchies
1553: set parent_table_name = p_parent_table_name
1554: ,parent_column_name = p_parent_column_name
1555: ,parent_id_column_name = p_parent_id_column_name
1556: ,last_update_date = sysdate
1559: where hierarchy_id = l_hierarchy_id
1560: ;
1561: else
1562: hr_utility.set_location(' Update :'||p_table_name, 10);
1563: insert into ben_dm_hierarchies
1564: ( hierarchy_id
1565: ,hierarchy_type
1566: ,table_id
1567: ,column_name
1573: ,last_update_login
1574: ,created_by
1575: ,creation_date
1576: ) values
1577: ( ben_dm_hierarchies_s.nextval
1578: ,p_hierarchy_type
1579: ,l_table_id
1580: ,p_column_name
1581: ,p_parent_table_name