APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_PROFILE

Line 1857: l_bgp_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

1853:
1854: l_generate BOOLEAN;
1855:
1856: l_effective_date DATE;
1857: l_bgp_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
1858: l_bgp_def BOOLEAN;
1859:
1860: l_ret_bg_id VARCHAR2(2000);
1861:

Line 1939: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',p_business_group_id);

1935: --
1936:
1937: if (p_business_group_id is not null) then
1938:
1939: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',p_business_group_id);
1940:
1941: else
1942:
1943: --

Line 1944: -- Is there a problem with fnd_profile caching?

1940:
1941: else
1942:
1943: --
1944: -- Is there a problem with fnd_profile caching?
1945: --
1946: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1947: if (l_bgp_def) then
1948: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);

Line 1946: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);

1942:
1943: --
1944: -- Is there a problem with fnd_profile caching?
1945: --
1946: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1947: if (l_bgp_def) then
1948: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1949: else
1950: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);

Line 1948: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);

1944: -- Is there a problem with fnd_profile caching?
1945: --
1946: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1947: if (l_bgp_def) then
1948: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1949: else
1950: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);
1951: end if;
1952:

Line 1950: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);

1946: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1947: if (l_bgp_def) then
1948: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1949: else
1950: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);
1951: end if;
1952:
1953: end if;
1954:

Line 1962: if (fnd_profile.value('HR_ABS_OTL_INTEGRATION') is null or

1958: Check for Profile Parameter mismatch
1959: */
1960:
1961: -- change start
1962: if (fnd_profile.value('HR_ABS_OTL_INTEGRATION') is null or
1963: fnd_profile.value('HR_ABS_OTL_INTEGRATION') <> 'Y') then
1964:
1965: if g_abs_incl_flag='Y' then
1966:

Line 1963: fnd_profile.value('HR_ABS_OTL_INTEGRATION') <> 'Y') then

1959: */
1960:
1961: -- change start
1962: if (fnd_profile.value('HR_ABS_OTL_INTEGRATION') is null or
1963: fnd_profile.value('HR_ABS_OTL_INTEGRATION') <> 'Y') then
1964:
1965: if g_abs_incl_flag='Y' then
1966:
1967: g_abs_incl_flag:= 'N';

Line 2154: -- l_ret_bg_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');

2150: l_an_dis_exists := 'N';
2151: END IF;
2152: close csr_chk_an_exists;
2153: --
2154: -- l_ret_bg_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
2155: -- dbms_output.put_line('Profile business group id is:'||l_ret_bg_id);
2156: --
2157:
2158: -- change parameters to create_alias_definitions