APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_PROFILE

Line 1577: l_bgp_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

1573:
1574: l_generate BOOLEAN;
1575:
1576: l_effective_date DATE;
1577: l_bgp_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
1578: l_bgp_def BOOLEAN;
1579:
1580: l_ret_bg_id VARCHAR2(2000);
1581:

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

1612: --
1613:
1614: if (p_business_group_id is not null) then
1615:
1616: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',p_business_group_id);
1617:
1618: else
1619:
1620: --

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

1617:
1618: else
1619:
1620: --
1621: -- Is there a problem with fnd_profile caching?
1622: --
1623: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1624: if (l_bgp_def) then
1625: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);

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

1619:
1620: --
1621: -- Is there a problem with fnd_profile caching?
1622: --
1623: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1624: if (l_bgp_def) then
1625: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1626: else
1627: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);

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

1621: -- Is there a problem with fnd_profile caching?
1622: --
1623: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1624: if (l_bgp_def) then
1625: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1626: else
1627: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);
1628: end if;
1629:

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

1623: FND_PROFILE.GET_SPECIFIC('PER_BUSINESS_GROUP_ID',null,null,null,l_bgp_id,l_bgp_def);
1624: if (l_bgp_def) then
1625: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',l_bg_id);
1626: else
1627: FND_PROFILE.PUT('PER_BUSINESS_GROUP_ID',null);
1628: end if;
1629:
1630: end if;
1631:

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

1709: l_an_dis_exists := 'N';
1710: END IF;
1711: close csr_chk_an_exists;
1712: --
1713: -- l_ret_bg_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1714: -- dbms_output.put_line('Profile business group id is:'||l_ret_bg_id);
1715: --
1716:
1717: -- change parameters to create_alias_definitions