is_valid_territory function

Related topics

Contained in package wwnls_api.

Call this function to determine whether a given territory code is valid.

procedure is_valid_territory

(

p_territory varchar2

);

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_territory

A territory code.

Example: 'AMERICA'

Datatype: varchar2

Returns:

This function returns true if the code is valid, otherwise false.

Exceptions:

This function raises no user-defined exceptions.

Example:

if wwnls_api.is_valid_territory(

p_territory => 'AMERICA'

)

then

.
.
.

end if;

Version: Oracle9iAS Portal 9.0.2 or later
Parameters:
p_territory	A territory code. Example: 'AMERICA' Datatype: varchar2
Returns: This function returns true if the code is valid, otherwise false. Exceptions: This function raises no user-defined exceptions. Example: if wwnls_api.is_valid_territory( p_territory => 'AMERICA' ) then . . . end if;

Related topics
NLS API package	PDK PL/SQL API Reference - Home