APPS.ARH_ADDR_PKG dependencies on FND_PROFILE

Line 121: l_fmt_bkwd_compatible := FND_PROFILE.VALUE('HZ_FMT_BKWD_COMPATIBLE');

117: l_msg_data VARCHAR2(2000);
118:
119: BEGIN
120:
121: l_fmt_bkwd_compatible := FND_PROFILE.VALUE('HZ_FMT_BKWD_COMPATIBLE');
122: IF l_fmt_bkwd_compatible = 'Y' THEN
123: return( arxtw_format_address( address_style,
124: address1,
125: address2,

Line 757: -- ( nvl ( fnd_profile.value('AR_ALT_NAME_SEARCH') , 'N' ) = 'Y' ) and

753: begin
754: --
755: --
756: if (
757: -- ( nvl ( fnd_profile.value('AR_ALT_NAME_SEARCH') , 'N' ) = 'Y' ) and
758: ( p_status = 'I')
759: ) then
760: --
761: select status