697: END validate_app_id;
698:
699:
700: FUNCTION validate_territory
701: ( p_territory IN fnd_territories.territory_code%TYPE )
702: RETURN BOOLEAN
703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;
701: ( p_territory IN fnd_territories.territory_code%TYPE )
702: RETURN BOOLEAN
703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;
706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code
703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;
706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code
710: FROM fnd_territories
711: WHERE (territory_code = ci_code)
706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code
710: FROM fnd_territories
711: WHERE (territory_code = ci_code)
712: AND (NVL(obsolete_flag,'N') = 'N');
713:
714: BEGIN