145:
146: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
147: END IF;
148:
149: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Insert_Row)
150: AMS_CAT_ACTIVITIES_PKG.Insert_Row(
151: px_cat_activity_id => l_cat_activity_id,
152: px_object_version_number => l_object_version_number,
153: p_category_id => p_cat_activity_rec.category_id,
146: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
147: END IF;
148:
149: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Insert_Row)
150: AMS_CAT_ACTIVITIES_PKG.Insert_Row(
151: px_cat_activity_id => l_cat_activity_id,
152: px_object_version_number => l_object_version_number,
153: p_category_id => p_cat_activity_rec.category_id,
154: p_activity_id => p_cat_activity_rec.activity_id,
364:
365:
366: -- Debug Message
367:
368: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Update_Row)
369: AMS_CAT_ACTIVITIES_PKG.Update_Row(
370: p_cat_activity_id => p_cat_activity_rec.cat_activity_id,
371: p_object_version_number => p_cat_activity_rec.object_version_number+1,
372: p_category_id => p_cat_activity_rec.category_id,
365:
366: -- Debug Message
367:
368: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Update_Row)
369: AMS_CAT_ACTIVITIES_PKG.Update_Row(
370: p_cat_activity_id => p_cat_activity_rec.cat_activity_id,
371: p_object_version_number => p_cat_activity_rec.object_version_number+1,
372: p_category_id => p_cat_activity_rec.category_id,
373: p_activity_id => p_cat_activity_rec.activity_id,
511:
512: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
513: END IF;
514:
515: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Delete_Row)
516: AMS_CAT_ACTIVITIES_PKG.Delete_Row(
517: p_CAT_ACTIVITY_ID => p_CAT_ACTIVITY_ID,
518: p_object_version_number => p_object_version_number);
519: --
512: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
513: END IF;
514:
515: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Delete_Row)
516: AMS_CAT_ACTIVITIES_PKG.Delete_Row(
517: p_CAT_ACTIVITY_ID => p_CAT_ACTIVITY_ID,
518: p_object_version_number => p_object_version_number);
519: --
520: -- End of API body