APPS.AMS_LIST_GROUP_PVT dependencies on AMS_ACT_LIST_GROUPS

Line 47: SELECT AMS_ACT_LIST_GROUPS_s.NEXTVAL

43: l_ACT_LIST_GROUP_ID NUMBER;
44: l_dummy NUMBER;
45:
46: CURSOR c_id IS
47: SELECT AMS_ACT_LIST_GROUPS_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT 1

Line 52: FROM AMS_ACT_LIST_GROUPS

48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT 1
52: FROM AMS_ACT_LIST_GROUPS
53: WHERE ACT_LIST_GROUP_ID = l_id;
54:
55: BEGIN
56: -- Standard Start of API savepoint

Line 140: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Insert_Row)

136:
137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Insert_Row)
141: AMS_ACT_LIST_GROUPS_PKG.Insert_Row(
142: px_act_list_group_id => l_act_list_group_id,
143: p_act_list_used_by_id => p_list_group_rec.act_list_used_by_id,
144: p_arc_act_list_used_by => p_list_group_rec.arc_act_list_used_by,

Line 141: AMS_ACT_LIST_GROUPS_PKG.Insert_Row(

137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Insert_Row)
141: AMS_ACT_LIST_GROUPS_PKG.Insert_Row(
142: px_act_list_group_id => l_act_list_group_id,
143: p_act_list_used_by_id => p_list_group_rec.act_list_used_by_id,
144: p_arc_act_list_used_by => p_list_group_rec.arc_act_list_used_by,
145: p_group_code => p_list_group_rec.group_code,

Line 250: FROM AMS_ACT_LIST_GROUPS

246:
247: IS
248: CURSOR c_get_list_group(cur_act_list_group_id NUMBER) IS
249: SELECT *
250: FROM AMS_ACT_LIST_GROUPS
251: where act_list_group_id = cur_act_list_group_id ;
252: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Group';
253: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
254: -- Local Variables

Line 358: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Update_Row)

354:
355: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
356: END IF;
357:
358: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Update_Row)
359: AMS_ACT_LIST_GROUPS_PKG.Update_Row(
360: p_act_list_group_id => p_list_group_rec.act_list_group_id,
361: p_act_list_used_by_id => p_list_group_rec.act_list_used_by_id,
362: p_arc_act_list_used_by => p_list_group_rec.arc_act_list_used_by,

Line 359: AMS_ACT_LIST_GROUPS_PKG.Update_Row(

355: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
356: END IF;
357:
358: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Update_Row)
359: AMS_ACT_LIST_GROUPS_PKG.Update_Row(
360: p_act_list_group_id => p_list_group_rec.act_list_group_id,
361: p_act_list_used_by_id => p_list_group_rec.act_list_used_by_id,
362: p_arc_act_list_used_by => p_list_group_rec.arc_act_list_used_by,
363: p_group_code => p_list_group_rec.group_code,

Line 502: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Delete_Row)

498:
499: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
500: END IF;
501:
502: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Delete_Row)
503: AMS_ACT_LIST_GROUPS_PKG.Delete_Row(
504: p_ACT_LIST_GROUP_ID => p_ACT_LIST_GROUP_ID);
505: --
506: -- End of API body

Line 503: AMS_ACT_LIST_GROUPS_PKG.Delete_Row(

499: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
500: END IF;
501:
502: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Delete_Row)
503: AMS_ACT_LIST_GROUPS_PKG.Delete_Row(
504: p_ACT_LIST_GROUP_ID => p_ACT_LIST_GROUP_ID);
505: --
506: -- End of API body
507: --

Line 591: FROM AMS_ACT_LIST_GROUPS

587: l_ACT_LIST_GROUP_ID NUMBER;
588:
589: CURSOR c_List_Group IS
590: SELECT ACT_LIST_GROUP_ID
591: FROM AMS_ACT_LIST_GROUPS
592: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
593: AND object_version_number = p_object_version
594: FOR UPDATE NOWAIT;
595:

Line 710: 'AMS_ACT_LIST_GROUPS',

706: BEGIN
707: x_return_status := FND_API.g_ret_sts_success;
708: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
709: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
710: 'AMS_ACT_LIST_GROUPS',
711: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||''''
712: );
713: ELSE
714: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 715: 'AMS_ACT_LIST_GROUPS',

711: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||''''
712: );
713: ELSE
714: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
715: 'AMS_ACT_LIST_GROUPS',
716: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||
717: ''' AND ACT_LIST_GROUP_ID <> ' || p_list_group_rec.ACT_LIST_GROUP_ID
718: );
719: END IF;

Line 935: FROM ams_act_list_groups

931: l_return_status VARCHAR2(1);
932:
933: CURSOR c_complete IS
934: SELECT *
935: FROM ams_act_list_groups
936: WHERE act_list_group_id = p_list_group_rec.act_list_group_id;
937: l_list_group_rec c_complete%ROWTYPE;
938: BEGIN
939: x_complete_rec := p_list_group_rec;