get_provider_group_list function

Related topics

Contained in package wwpro_api_progrp_registry.

Call this function to obtain a list of registered provider groups.

The provider_group_table returned contains those provider_group_records that have a 'name' that match the pattern specified in the p_name argument. The 'display_name' in the provider_group_records are translated into the language given in the p_language argument.

If required, the number of records returned can be restricted by specifying the p_start_row and p_row_count arguments.

Note: If no provider groups match the criteria specified, an empty provider_group_table is returned.

function get_provider_group_list
(

p_name in varchar2 default '%',
p_language in varchar2 default null,
p_start_row in integer default 1,
p_row_count in integer default 20

)
return provider_group_table;

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_name

The pattern to match against provider group names.

Datatype: in varchar2
Default: %

p_language

The NLS language to be used for any translatable text in the provider group records that are returned.

Datatype: in varchar2
Default: null

p_start_row

The first record to retrieve.

Datatype: in integer
Default: 1

p_row_count

The number of records to retrieve.

Datatype: in integer
Default: 20

Returns:

This function returns a provider_group_table of provider_group_records that match the criteria specified.

Exceptions:

This function raises no user-defined exceptions.

Example:

begin

wwpro_api_progrp_registry.get_provider_group_list
(

p_name => 'ProviderGroup0%'

)

end;

Version: Oracle9iAS Portal 9.0.2 or later
Parameters:
p_name	The pattern to match against provider group names. Datatype: in varchar2 Default: %
p_language	The NLS language to be used for any translatable text in the provider group records that are returned. Datatype: in varchar2 Default: null
p_start_row	The first record to retrieve. Datatype: in integer Default: 1
p_row_count	The number of records to retrieve. Datatype: in integer Default: 20
Returns: This function returns a provider_group_table of provider_group_records that match the criteria specified. Exceptions: This function raises no user-defined exceptions. Example: begin wwpro_api_progrp_registry.get_provider_group_list ( p_name => 'ProviderGroup0%' ) end;

Related topics
Provider group API package	PDK PL/SQL API Reference - Home