APPS.ARP_ADDS_MINUS99 dependencies on FND_TERRITORIES

Line 48: previous_territory_code fnd_territories.territory_code%TYPE := NULL;

44: +-------------------------------------------------------------------------*/
45:
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:

Line 1980: | territory_code FK to FND_TERRITORIES.TERRITORY_CODE |

1976: | Given a territory code, this function returns the description for that |
1977: | territory. |
1978: | |
1979: | REQUIRES |
1980: | territory_code FK to FND_TERRITORIES.TERRITORY_CODE |
1981: | |
1982: | RETURNS |
1983: | Description FND_TERRITORIES.DESCRIPTION |
1984: | |

Line 1983: | Description FND_TERRITORIES.DESCRIPTION |

1979: | REQUIRES |
1980: | territory_code FK to FND_TERRITORIES.TERRITORY_CODE |
1981: | |
1982: | RETURNS |
1983: | Description FND_TERRITORIES.DESCRIPTION |
1984: | |
1985: | EXCEPTIONS RAISED |
1986: | NO_DATA_FOUND If the FK is in error |
1987: | |

Line 2010: select territory_short_name into short_name from fnd_territories_vl

2006: if territory_code = previous_territory_code
2007: then return( previous_territory_short_name );
2008: else
2009:
2010: select territory_short_name into short_name from fnd_territories_vl
2011: where territory_code = terr_short_name.territory_code;
2012:
2013: previous_territory_code := territory_code;
2014: previous_territory_short_name := short_name;