Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
OLM APIs - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Human Resources (http://www.oraerp.com/forum-4.html)
+---- Thread: OLM APIs (/thread-71231.html)



OLM APIs - fanni339 - 11-20-2014

Course Creation API


ta_activity_version_api.create_activity_version

(p_validate => l_validate,
p_effective_date => i.start_date,
p_activity_id => l_activity_id,
p_version_name => initcap(i.course_name),
p_version_code => upper(i.course_code),
p_description => i.course_desc,
p_intended_audience => i.intended_audience,
p_objectives => i.objectives,
p_start_date => NVL
(i.start_date,
’01-JAN-1995′
),
p_business_group_id => p_business_group_id,
p_activity_version_id => l_activity_version_id,
p_object_version_number => l_object_version_number,
p_developer_organization_id => p_business_group_id
);


For Detailed Code, Click Here

Course Deletion API


[b]ota_activity_version_api.delete_activity_version (

p_activity_version_id => r.activity_version_id,
p_object_version_number => r.OBJECT_VERSION_NUMBER,
p_validate => FALSE
) ;

[/b]


For detailed code, Click Here