DBA Data[Home] [Help]

APPS.ARP_ADDS_MINUS99 dependencies on FND_PROFILE

Line 50: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

46: NULL_SEGMENT_QUALIFIER varchar2(60) := NULL;
47:
48: previous_territory_code fnd_territories.territory_code%TYPE := NULL;
49: previous_territory_short_name VARCHAR2(80) := NULL;
50: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
51: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
52:
53: /*-------------------------------------------------------------------------+
54: | PRIVATE CURSOR |

Line 51: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

47:
48: previous_territory_code fnd_territories.territory_code%TYPE := NULL;
49: previous_territory_short_name VARCHAR2(80) := NULL;
50: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
51: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
52:
53: /*-------------------------------------------------------------------------+
54: | PRIVATE CURSOR |
55: | ar_location_combations_s_c |

Line 2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

2273:
2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';
2275: ARP_ADDS_MINUS99.all_segment_qualifiers := 'STATE COUNTY CITY';
2276: ARP_ADDS_MINUS99.last_segment_qualifier := 'CITY';
2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2279:
2280: if arp_standard.sysparm.from_postal_code is null
2281: or arp_standard.sysparm.to_postal_code is null

Line 2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';
2275: ARP_ADDS_MINUS99.all_segment_qualifiers := 'STATE COUNTY CITY';
2276: ARP_ADDS_MINUS99.last_segment_qualifier := 'CITY';
2277: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
2278: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2279:
2280: if arp_standard.sysparm.from_postal_code is null
2281: or arp_standard.sysparm.to_postal_code is null
2282: or arp_standard.sysparm.from_postal_code > arp_standard.sysparm.to_postal_code