Project and Portfolio Management Practitioners Forum
cancel

list of utilities and functions

Highlighted
riznad
Super Contributor.

list of utilities and functions

Hello;

Our data base administration blocked me to see list of utilities.

Is there any document list name and function of all function on data base utilities.

If you know how to get list of pool managers of a pool and list of project managers of a project from functions.

Could you share it with me?

Regards

 

3 REPLIES
Jason Nichols K
Acclaimed Contributor.

Re: list of utilities and functions

I don't know of any document that HP provides that would include all of the package definitions.  The Data Model Guide describes the tables, but not the packages.  However, I can tell you the functions you are looking for:

 

KRSC_UTILS

  FUNCTION get_pool_managers_list
  (rp_id IN NUMBER)
   RETURN VARCHAR2;

PM_UTILS

FUNCTION get_project_managers (p_project_id IN NUMBER)
   RETURN VARCHAR2;
FUNCTION get_project_manager_usernames (p_project_id IN NUMBER)
   RETURN VARCHAR2;
FUNCTION get_project_manager_name_list (p_project_id IN NUMBER)
   RETURN VARCHAR2;

 

I pulled these directly from the DDL of the package spec.  Each function returns a ';' delimited list.  The RP list is a First Last list as is the PM Name List.  The PM Username function returns usernames and the other one returns user IDs.  Hope this helps!

 

Jason

riznad
Super Contributor.

Re: list of utilities and functions

There might be a way like

(I am making up)

 

select * from all_dba_objects

where object_type = 'function'

 

TurboMan
Honored Contributor.

Re: list of utilities and functions

How about using the package PPM_DB_UTILS

It has some functions related to DB.