Saturday Jun 09, 2012

Oracle HRMS API – Update Employee Address

API - hr_person_address_api.update_person_address

 

Example --

Consider Employee having Address Line1 -- "50 Main Street"

Lets Update Address Line1 -- "60 Main Street" using update address API

 

 

 

DECLARE
      ln_address_id                         PER_ADDRESSES.ADDRESS_ID%TYPE;
      ln_object_version_number  PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE := 1;

BEGIN
   -- Update Employee Address
   -- ----------------------------------------
    hr_person_address_api.update_person_address
    (    -- Input data elements
         -- -----------------------------
         p_effective_date                     => TO_DATE('10-JUN-2011'),
         p_address_id                          => 16406,
         p_address_line1                    => '60 Main Street',
         -- Output data elements
         -- --------------------------------
         p_object_version_number   => ln_object_version_number
    );
 
 COMMIT;


EXCEPTION
      WHEN OTHERS THEN
                 ROLLBACK;
                 dbms_output.put_line(SQLERRM);
END;
/

SHOW ERR;

 

 

 

About

Welcome to My Oracle World Puneet Rajkumar

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today