[Home] [Help]
1863: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1864: end;
1865:
1866: --
1867: -- DK Resolve For Table FND_ID_FLEX_STRUCTURES_VL
1868: --
1869: procedure get_dk_frm_fit is
1870: --
1871: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM
1867: -- DK Resolve For Table FND_ID_FLEX_STRUCTURES_VL
1868: --
1869: procedure get_dk_frm_fit is
1870: --
1871: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM
1872: --
1873: cursor csr_get_dk_fit (c_business_group_id number, c_source_key varchar2) is
1874: select id_flex_num
1875: from fnd_id_flex_structures_vl
1871: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM
1872: --
1873: cursor csr_get_dk_fit (c_business_group_id number, c_source_key varchar2) is
1874: select id_flex_num
1875: from fnd_id_flex_structures_vl
1876: where id_flex_structure_name = c_source_key
1877: ;
1878:
1879: cursor csr_get_all_fit is
1878:
1879: cursor csr_get_all_fit is
1880: select *
1881: from ben_dm_resolve_mappings
1882: where table_name = 'FND_ID_FLEX_STRUCTURES_VL'
1883: and target_id is null;
1884:
1885: -- Declare local variables
1886: l_proc varchar2(72) := g_package || 'get_dk_frm_fit';
1891:
1892: begin
1893:
1894: --
1895: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table FND_ID_FLEX_STRUCTURES_VL
1896: --
1897: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1898: for x in csr_get_all_fit loop
1899: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3198:
3199: -- DK Resolve for Table FF_FORMULAS_F
3200: get_dk_frm_fra;
3201:
3202: -- DK Resolve for Table FND_ID_FLEX_STRUCTURES_VL
3203: get_dk_frm_fit;
3204:
3205: -- DK Resolve for Table FND_USER
3206: get_dk_frm_fus;