JDR_UTILS

+---------------------------------------+
|JDR_UTILS.LISTDOCUMENTS       |
+---------------------------------------+
Use this API to list of all OA Framework documents in the given path/module. 
It provides list of all the pages/extensions/personalizations.
Parameters:
1. Full/Partial path of MDS repository
2.  TRUE will direct the API to list all Child Documents underneath that tree path

Example:
DECLARE
BEGIN
jdr_utils.listdocuments('/oracle/apps/per/probation/', TRUE);
END;
/

+---------------------------------------+
|JDR_UTILS.LISTCUSTOMIZATIONS        |
+---------------------------------------+
Use this API to list all personalizations/Extensions/COntents of a specific Object.

Example:
DECLARE
BEGIN
jdr_utils.listcustomizations
(p_document => '/xxhr/oracle/apps/per/probation/webui/AddKpiPG');
END;
/

+---------------------------------------+
|JDR_UTILS.PRINTDOCUMENT  |
+---------------------------------------+
This procedure lists the contents of a specific object. 

For example, using below code, we can get all the components(items and page properties) of the page -> TrackPG

DECLARE
begin
  jdr_utils.printDocument('/xxhr/oracle/apps/per/probation/webui/TrackPG');
EXCEPTION
WHEN OTHERS THEN
  DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/

+---------------------------------------+
|JDR_UTILS.DELETEDOCUMENT          |
+---------------------------------------+
You can delete a page/personalization/extension by using command below. 

For example to delete the Application Module substitution, use command

DECLARE
BEGIN
jdr_utils.deletedocument(p_document => '/oracle/apps/per/probation/server/customizations/addTemplateAM');
END;
/