11-20-2014, 07:42 AM
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
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