722: END validate_app_id;
723:
724:
725: FUNCTION validate_territory
726: ( p_territory IN fnd_territories.territory_code%TYPE )
727: RETURN BOOLEAN
728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;
726: ( p_territory IN fnd_territories.territory_code%TYPE )
727: RETURN BOOLEAN
728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;
731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code
728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;
731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code
735: FROM fnd_territories
736: WHERE (territory_code = ci_code)
731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code
735: FROM fnd_territories
736: WHERE (territory_code = ci_code)
737: AND (NVL(obsolete_flag,'N') = 'N');
738:
739: BEGIN