APPS.AMS_ST_ASSOC_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 49: SELECT AMS_LIST_SRC_TYPE_ASSOCS_s.NEXTVAL

45: l_LIST_SOURCE_TYPE_ASSOC_ID NUMBER;
46: l_dummy NUMBER;
47:
48: CURSOR c_id IS
49: SELECT AMS_LIST_SRC_TYPE_ASSOCS_s.NEXTVAL
50: FROM dual;
51:
52: CURSOR c_id_exists (l_id IN NUMBER) IS
53: SELECT 1

Line 54: FROM AMS_LIST_SRC_TYPE_ASSOCS

50: FROM dual;
51:
52: CURSOR c_id_exists (l_id IN NUMBER) IS
53: SELECT 1
54: FROM AMS_LIST_SRC_TYPE_ASSOCS
55: WHERE LIST_SOURCE_TYPE_ASSOC_ID = l_id;
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_St_Assoc_PVT;

Line 140: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_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_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row)
141: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(
142: px_list_source_type_assoc_id => l_list_source_type_assoc_id,
143: p_last_update_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 141: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(

137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row)
141: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(
142: px_list_source_type_assoc_id => l_list_source_type_assoc_id,
143: p_last_update_date => SYSDATE,
144: p_last_updated_by => FND_GLOBAL.USER_ID,
145: p_creation_date => SYSDATE,

Line 244: FROM AMS_LIST_SRC_TYPE_ASSOCS;

240: IS
241:
242: CURSOR c_get_st_assoc(list_source_type_assoc_id NUMBER) IS
243: SELECT *
244: FROM AMS_LIST_SRC_TYPE_ASSOCS;
245: -- Hint: Developer need to provide Where clause
246:
247: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_St_Assoc';
248: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 355: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row)

351: -- Debug Message
352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
353: --this above statement cause problem of char to number conversion error
354:
355: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row)
356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(
357: p_list_source_type_assoc_id =>
358: p_st_assoc_rec.list_source_type_assoc_id,
359: p_last_update_date => SYSDATE,

Line 356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(

352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
353: --this above statement cause problem of char to number conversion error
354:
355: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row)
356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(
357: p_list_source_type_assoc_id =>
358: p_st_assoc_rec.list_source_type_assoc_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 492: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row)

488:
489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row)
493: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row(
494: p_LIST_SOURCE_TYPE_ASSOC_ID => p_LIST_SOURCE_TYPE_ASSOC_ID);
495: --
496: -- End of API body

Line 493: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row(

489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row)
493: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row(
494: p_LIST_SOURCE_TYPE_ASSOC_ID => p_LIST_SOURCE_TYPE_ASSOC_ID);
495: --
496: -- End of API body
497: --

Line 581: FROM AMS_LIST_SRC_TYPE_ASSOCS

577: l_LIST_SOURCE_TYPE_ASSOC_ID NUMBER;
578:
579: CURSOR c_St_Assoc IS
580: SELECT LIST_SOURCE_TYPE_ASSOC_ID
581: FROM AMS_LIST_SRC_TYPE_ASSOCS
582: WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
583: AND object_version_number = p_object_version
584: FOR UPDATE NOWAIT;
585:

Line 700: 'AMS_LIST_SRC_TYPE_ASSOCS',

696: BEGIN
697: x_return_status := FND_API.g_ret_sts_success;
698: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
699: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
700: 'AMS_LIST_SRC_TYPE_ASSOCS',
701: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||''''
702: );
703: ELSE
704: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 705: 'AMS_LIST_SRC_TYPE_ASSOCS',

701: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||''''
702: );
703: ELSE
704: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
705: 'AMS_LIST_SRC_TYPE_ASSOCS',
706: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||
707: ''' AND LIST_SOURCE_TYPE_ASSOC_ID <> ' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID
708: );
709: END IF;

Line 974: FROM ams_list_src_type_assocs

970: l_return_status VARCHAR2(1);
971:
972: CURSOR c_complete IS
973: SELECT *
974: FROM ams_list_src_type_assocs
975: WHERE list_source_type_assoc_id = p_st_assoc_rec.list_source_type_assoc_id;
976: l_st_assoc_rec c_complete%ROWTYPE;
977: BEGIN
978: x_complete_rec := p_st_assoc_rec;