Human Capital Management - EBS (MOSC)

MOSC Banner

Unable to perform Date track update with update_gb_emp_asg API

edited Jul 13, 2011 11:49PM in Human Capital Management - EBS (MOSC) 4 commentsAnswered
Hi All,

I have a requirement to perform date track update on ass_attribute16 (Assignment DFF) for some 600 employees. 

I am using the below code to call the API to make the update. Requirement is to make the changes effective from 01-AUG-2010. So i need to get all the employees who were active as on 01-AUG-2010 as well as those who are active after the same date.

Please review the code and let me know your ideas.

SET serveroutput ON SIZE 1000000 FORMAT WRAPPED
SET verify OFF
SET feedback OFF

DECLARE

l_validate BOOLEAN:= TRUE;
l_effective_date DATE:= to_date('01-AUG-10');

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