APPS.AMS_CAT_ACTIVITY_PVT dependencies on AMS_CAT_ACTIVITIES

Line 53: SELECT AMS_CAT_ACTIVITIES_s.NEXTVAL

49: l_CAT_ACTIVITY_ID NUMBER;
50: l_dummy NUMBER;
51:
52: CURSOR c_id IS
53: SELECT AMS_CAT_ACTIVITIES_s.NEXTVAL
54: FROM dual;
55:
56: CURSOR c_id_exists (l_id IN NUMBER) IS
57: SELECT 1 FROM dual

Line 58: WHERE EXISTS (SELECT 1 FROM AMS_CAT_ACTIVITIES

54: FROM dual;
55:
56: CURSOR c_id_exists (l_id IN NUMBER) IS
57: SELECT 1 FROM dual
58: WHERE EXISTS (SELECT 1 FROM AMS_CAT_ACTIVITIES
59: WHERE CAT_ACTIVITY_ID = l_id);
60:
61: BEGIN
62: -- Standard Start of API savepoint

Line 149: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Insert_Row)

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,

Line 150: AMS_CAT_ACTIVITIES_PKG.Insert_Row(

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,

Line 265: FROM AMS_CAT_ACTIVITIES

261: IS
262:
263: CURSOR c_get_cat_activity(cat_act_id NUMBER) IS
264: SELECT *
265: FROM AMS_CAT_ACTIVITIES
266: WHERE cat_activity_id = cat_act_id;
267:
268: -- Hint: Developer need to provide Where clause
269:

Line 368: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Update_Row)

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,

Line 369: AMS_CAT_ACTIVITIES_PKG.Update_Row(

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,

Line 515: -- Invoke table handler(AMS_CAT_ACTIVITIES_PKG.Delete_Row)

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: --

Line 516: AMS_CAT_ACTIVITIES_PKG.Delete_Row(

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

Line 605: FROM AMS_CAT_ACTIVITIES

601: l_CAT_ACTIVITY_ID NUMBER;
602:
603: CURSOR c_Cat_Activity IS
604: SELECT CAT_ACTIVITY_ID
605: FROM AMS_CAT_ACTIVITIES
606: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
607: AND object_version_number = p_object_version
608: FOR UPDATE NOWAIT;
609:

Line 725: 'AMS_CAT_ACTIVITIES',

721: x_return_status := FND_API.g_ret_sts_success;
722: /****
723: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
724: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
725: 'AMS_CAT_ACTIVITIES',
726: 'CAT_ACTIVITY_ID = ''' || p_cat_activity_rec.CAT_ACTIVITY_ID ||''''
727: );
728: ELSE
729: ****/

Line 731: 'AMS_CAT_ACTIVITIES',

727: );
728: ELSE
729: ****/
730: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
731: 'AMS_CAT_ACTIVITIES',
732: 'ACTIVITY_ID = ''' || p_cat_activity_rec.ACTIVITY_ID ||
733: ''' AND CATEGORY_ID = ' || p_cat_activity_rec.CATEGORY_ID
734: );
735: -- END IF;