How to check value(if it is null or not) in processFormRequest

if (pageContext.getParameter("ApplyBtn") != null){          OAViewObject voh = (OAViewObject)am.findViewObject("XxVO1");          try...

Creating Lookup and Lookup Values through API

DECLARE    err_code    VARCHAR2 (50);    err_msg     VARCHAR2 (1000);    ln_rowid    ROWID;    ln_rowid1 ...

Popup Regions in R12.1.2 for Jdeveloper 10g OAF

Our objective is when a user hover its mouse over Employee name field a popup window will open that shows the details of that employee. Step 1 For this we will create a query...

PO_UNIQUE_IDENTIFIER_CONT_ALL

PO_UNIQUE_IDENTIFIER_CONT_ALL stores information about the current, highest, system-generated numbers for the Oracle Purchasing tables that require special sequencing. You need one...

Registering Table through API in Oracle apps r12

BEGIN AD_DD.REGISTER_TABLE ('FND','XXCUST_KFF_DEMO','T'); END; / BEGIN AD_DD.REGISTER_COLUMN ('FND', 'XXCUST_KFF_DEMO','CODE_COMBINATION_ID', 1, 'NUMBER', 38, 'Y', 'N'); AD_DD.REGISTER_COLUMN...

PAY_ELEMENT_LINK_API.delete_element_link

DECLARE    l_effective_start_date   DATE;    l_effective_end_date     DATE;    l_entries_warning       ...

hr_sit_api.create_sit

DECLARE    err_code                         varchar2 (50);    err_msg       ...

hr_sit_api.delete_sit

DECLARE    CURSOR c1    IS       SELECT   PERSON_ANALYSIS_ID, OBJECT_VERSION_NUMBER         FROM   PER_PERSON_ANALYSES  ...

Introduction to Oracle 10g Pl/sql - Fundamentals 1

Introduction to Oracle 10g Pl/sql - Fundamentals 1- Author Nancy Greenberg https://drive.google.com/open?id=17j94S3CBU3ivmysYbmNMqu-3k7q-gL...

Kill Session

select s.sid,s.serial#, s.status,p.spid from v$session s,v$process p where s.username='USER_NAME' and p.addr(+)=s.paddr; alter system kill session '<sid>,<serial#>...

Create Person Phone in Oracle apps HRMS

Create Person Phone in Oracle apps HRMS: Sample code: DECLARE    err_code                  VARCHAR2 (50);    err_msg ...

Finding dates against day name in a specific month in Oracle Pl/sql

  SELECT   A.LEV, MONTH_DATE, DAY_NAME     FROM   (    SELECT   LEVEL LEV,              ...

Create Person Address (Temporary) in Oracle apps HRMS

Create Person Address (Temporary) in Oracle apps HRMS: Sample Code: DECLARE    err_code                   VARCHAR2 (50);  ...

Create Person Address (Permanent) in Oracle apps HRMS

Create Person Address (Permanent) in Oracle apps HRMS: Sample Code: DECLARE    err_code                   VARCHAR2 (50);  ...