| per_events_api [message #415763] |
Wed, 29 July 2009 03:31  |
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
|
Senior Member |
|
|
Hi All,
I am facing problem in per_events_api.create_event.
My sample procedure is
CREATE OR REPLACE procedure person_testing(errbuf OUT Varchar2, retcode OUT Varchar2)
IS
n_event_id NUMBER;
n_object_version_number NUMBER;
BEGIN
n_object_version_number :=NULL;
n_event_id :=NULL;
per_events_api.create_event(
p_validate =>FALSE
,p_date_start =>'29-Jul-2009'
,p_type =>'Campus Event'
,p_business_group_id =>205
,p_location_id =>485
--,p_organization_run_by_id =>241
,p_emp_or_apl =>'A'
,p_event_or_interview =>'E'
,p_event_id =>n_event_id
,p_object_version_number =>n_object_version_number
);
END;
data is getting loaded in the per_events table but we are not able to get the data in the front end.
If anybody has any idea on it then please let me know.
Thanks,
Monika
|
|
|
|
|
|
| Re: per_events_api [message #415813 is a reply to message #415785] |
Wed, 29 July 2009 06:55  |
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
|
Senior Member |
|
|
Hi All,
The problem with that create event Api was that for events and booking screen PER_EVENTS_V2 view is used and in that view they are validating type from per_events table to to lookup_code from hr_lookup tables.
So for the parameter p_type we have to check if it exists in hr_lookup tables or not.
Best Regards,
Monika
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
