Oracle E-Business Suite R12 | How to get Customization, Extension and Personalization details

There is a standard package JDR_UTILS. using this package we can, 
  - Get the customization details
  - Get the list of customization in particular package
  - Delete the existing customization
  - Print the xml of page or region
  - Print translation
  - Export document etc

This package includes procedures and function like,

• JDR_UTILS.listDocuments
• JDR_UTILS.listCustomizations
• JDR_UTILS.printDocument
• JDR_UTILS.deleteDocument
• JDR_UTILS.printTranslations

JDR_UTILS.listDocuments

This is used to list of all OA Framework documents in the given path/module. It provides list of all the pages/extensions/personalizations. It takes two parameters: 1. Full/Partial path of MDS repository 2. TRUE will direct the API to list all Child Documents underneath that tree path
Example: Begin
  JDR_UTILS.listContents (p_path => '/oracle/apps/per/selfservice/',
                                      p_recursive => TRUE);
End;
/

JDR_UTILS.listCustomizations

To list all Extensions/Personalizations/Contents of a specific Object (i.e. Page or Region).
Example: Begin
  JDR_UTILS.listCustomizations(p_document => '/xxhr/oracle/apps/per/selfservice/test/webui/XXEmpQueryPG');
End;
 /

JDR_UTILS.printDocument

To print the contents/xml of a specific object (i.e. Page or Region). 

Example: Begin
  JDR_UTILS.printDocument(p_document => 'xxhr/oracle/apps/per/selfservice/test/webui/XXEmpQueryPG'); End;
/

Using above example code we can print the XML of given Page or Region.

JDR_UTILS.deleteDocument

Using this we can delete a Page, Personalization and Extension. 
Example:
Begin    JDR_UTILS.deletedocument(p_document => '/oracle/apps/icx/por/server/customizations/InvoiceHeaderVO');
End;
/

Above example is to delete the VO extension.

JDR_UTILS.printTranslations

To print the translations for the document in XLIFF format

Example:
Begin 
  JDR_UTILS.printTranslations (p_document => 'xxhr/oracle/apps/per/selfservice/test/webui/XXEmpQueryPG', p_language => 'AR');
End;
/

There are few more procedures that can also be useful like,
JDR_UTILS.exportDocument : Export the XML for a document
JDR_UTILS.saveTranslations : Saves the specified translations for the specified document.