Steps to Implement Zoom Functionality through Custom.PLL

By | August 15, 2016

Table of Contents

Business Requirenment
Solution concept
Find the form name and block name
Copy Custom.PLL from Server to your Development Machine
Modify Zoom function
Identify the Executables Function Name
Modify Event Procedure
Migrate and Compile the CUSTOM.PLL
Test the Form

Business Requirnment

It is a very common requirement to open a form from another form to see any further details of parent form. In this example we have selected similar business requirement in which we want to see the details of executable from concurrent program screen

Back to top

Solution Concept

Above mentioned requirement can be fulfilled by personalization. Personalization can be achieved either by using custom.pll or by using forms personalization. This document addresses the solution using CUSTOM.PLL. For personalization using oracle forms personalization, please refer our other solution named Personalization through oracle forms personalization.

For Personalization using CUSTOM.PLL, following are high level steps.

  • Find the form name and block name
  • Copy CUSTOM.PLL from server
  • Open CUSTOM.pll in Forms Developer
  • Modify Zoom function
  • Modify EVENT Procedure
  • Migrate and Compile the CUSTOM.PLL
  • Test the Personalization Impact

Back to top

Find the form name and block name

In implementing personalization through custom.pll, first thing is to identify the place (form name and block name) where you want to apply personalization, e.g in this example we want to open the executables form when we are on concurrent programs form. So it suggest us to find the name of concurrent program as well as its block name for which we want to enable the personalization.

To find the form name, switch to System Administrator Responsibility

ORACLE hrms oVERVIEW 01

Open the Concurrent program screen using the navigation shown below

Oracle HRMS Overview 02

Following screen will be displayed

Oracle HRMS Overview 03

Click on Help Menu option to know the form name

Oracle HRMS Overview 04

Following screen will be opened

Oracle HRMS Overview 05

Scroll down to find the form name as shown below

Oracle HRMS Overview 06

Next step is to find the block name on which we want the personalization to work. Now open the concurrent program screen and go to navigation as shown below

Oracle HRMS Overview 07

following form will be displayed

Oracle HRMS Overview 08




Note down the Block Name ‘CONC_PROG’. This block name we need to write in custom.pll so that our personalization logic could work.

Back to top

Copy Custom.PLL from Server to your Development Machine

Custom.PLL is a library which resides in resource folder under $AU_TOP. Following is the navigation for this library.

Oracle HRMS Overview 09

Copy this library into your development machine and open it in Oracle forms developer.

Oracle HRMS Overview 10

Click on Open menu

Oracle HRMS Overview 11

select the custom.pll

Oracle HRMS Overview 12

It will be opened like this

Oracle HRMS Overview 13

You should be able to see the program units and attached libraries in it as shown below

Oracle HRMS Overview 14

double click on CUSTOM (Package Body) to open the source code

Oracle HRMS Overview 15

Following source code will be visible

Oracle HRMS Overview 16

Modify Zoom function

Now we need to modify the zoom function. It return either TRUE of FALSE. Zoom function is responsible to enable or disable the zoom button available on Apps forms. Following is the zoom button which is available on oracle forms.

Oracle HRMS Overview 17

By default this button is disabled but it we enable it through custom.pll, it becomes enable. In order to make it enable, we simply need to return TRUE for our required form and block.
We had already noted down the form name and block name for which we want to enable the personalization.

Write the code in ZOOM function as shown below

Oracle HRMS Overview 18

By writing the above code, we have simply enabled the zoom button in Concurrent Program Screen.

Back to top

Identify the Executables Function Name

Switch to System Administrator Responsibility

Oracle HRMS Overview 18

Through System Administrator responsibility, open the Executable Form. Following is the navigation path as shown in the figure below

Oracle HRMS Overview 19

Click on Help->About Oracle Applications

Oracle HRMS Overview 20

From the current form section, Note down the Form Name. This is form that we shall call from concurrent program. As shown from figure below, we can notice its name is FNDCPMPE

Oracle HRMS Overview 21

Now go to Application Developer Responsibility and open the Form Screen through following navigation

Oracle HRMS Overview 22

and find the user form name ‘ Define Concurrent Program Executable

Oracle HRMS Overview 23

After this go to following navigation in same Application Developer Responsibility

Oracle HRMS Overview 24

and Query the User Form Name to find Form Function

Oracle HRMS Overview 25

Following result will be displayed

Oracle HRMS Overview 26

From above screen, we have reached to Form function (FND_FNDCPMPE) that we shall be using in the event procedure to call the Executable screen on zoom functionality.

Back to top

Modify Event Procedure

Now we need to write the piece of code that we want to execute upon pressing the zoom button.
Go to EVENT procedure

Oracle HRMS Overview 27

scroll down to the position where ZOOM event is written, Write the if condition for calling the form function under zoom event as shown below

Oracle HRMS Overview 28

In the above code executables screen is called by calling fnd_function.execute API and this code gets executed when zoom event fires. In this way, through concurrent program screen, executables form will be opened by clicking the zoom button.

we can pass the parameters as well to executables.

Back to top

Migrate and Compile the CUSTOM.PLL

Once you make the necessary modification in custom.pll. Simply save it and transfer to AU_TOP Folder on your server.

Oracle HRMS Overview 29

Connect through PUTTY

Oracle HRMS Overview 30

Run the Command

frmcmp_batch module=/d01/oracle/VIS/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.pll userid=apps/apps output_file=/d01/oracle/VIS/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.plx module_type=LIBRARY batch=no compile_all=special

In the above command, you need to modify the initial directory path.

Oracle HRMS Overview 31

Once compiled, it shows like this

Oracle HRMS Overview 32

Test the Form

Back to top

Go to System Administrator Responsibility and open the Concurrent Program screen from the following navigation

Oracle HRMS Overview 33

Concurrent Program screen will be opened

Oracle HRMS Overview 34

Click on Zoom Button

Oracle HRMS Overview 35

Following screen will be opened

Oracle HRMS Overview 36

Back to top




If you have liked the contents in this post and you think it can be helpful to others, please share it at least once in your circle, in this way, you will join me in my cause to Learn Share and Grow. Come on, Lets Grow Together.

Related Posts

Step by Step Guide for SQL Loader Based Conc Program
WISTU – Oracle Workflow Builder
Free Online Test
Solved Issued of Empty Email Notification
Steps for creating custom form in Oracle Apps
How to create backend logging mechanism
Useful Apps SQL Queries Pool
Top 10 Apps Technical Interview Questions