PL/SQL (MOSC)

MOSC Banner

update employee API

edited Nov 12, 2015 2:27AM in PL/SQL (MOSC) 3 commentsAnswered

if i want to update any field in the per_all_people_f table can i add them like this:

hr_person_api.update_person

( -- Input Data Elements

-- ------------------------------

p_effective_date           =>TO_DATE(sysdate),

p_datetrack_update_mode    => lc_dt_ud_mode,

p_person_id                => lc_person_id,

p_middle_names             => 'TEST',

p_middle_names           => 'TEST',

p_marital_status         => 'M',

PER_INFORMATION12          => 'MEA',

PER_INFORMATION16          => 'IT APPLICATION',

PER_INFORMATION13          => 'testt',

PER_INFORMATION14         =>XXX

PER_INFORMATION18          =>XXX

-- Output Data Elements

-- ----------------------------------

p_employee_number          => lc_employee_number,

p_object_version_number    => ln_object_version_number,

p_effective_start_date     => ld_effective_start_date,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center