eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_ASSOC_PVT dependencies on AMS_LIST_CONT_RESTRICTIONS

Line 50: SELECT AMS_LIST_CONT_RESTRICTIONS_s.NEXTVAL

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

Line 55: FROM AMS_LIST_CONT_RESTRICTIONS

51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1
55: FROM AMS_LIST_CONT_RESTRICTIONS
56: WHERE LIST_CONTACT_RESTRICTIONs_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint

Line 148: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row)

144:
145: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
146: END IF;
147:
148: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row)
149: AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row(
150: px_list_cont_restrictions_id => l_list_cont_restrictions_id,
151: p_list_header_id => p_list_assoc_rec.list_header_id,
152: p_last_update_date => SYSDATE,

Line 149: AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row(

145: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
146: END IF;
147:
148: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row)
149: AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row(
150: px_list_cont_restrictions_id => l_list_cont_restrictions_id,
151: p_list_header_id => p_list_assoc_rec.list_header_id,
152: p_last_update_date => SYSDATE,
153: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 248: FROM AMS_LIST_CONT_RESTRICTIONS;

244: IS
245:
246: CURSOR c_get_list_assoc(list_cont_restrictions_id NUMBER) IS
247: SELECT *
248: FROM AMS_LIST_CONT_RESTRICTIONS;
249: -- Hint: Developer need to provide Where clause
250:
251: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Assoc';
252: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 361: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row)

357:
358: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
359: END IF;
360:
361: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row)
362: AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row(
363: p_list_cont_restrictions_id => p_list_assoc_rec.list_cont_restrictions_id,
364: p_list_header_id => p_list_assoc_rec.list_header_id,
365: p_last_update_date => SYSDATE,

Line 362: AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row(

358: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
359: END IF;
360:
361: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row)
362: AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row(
363: p_list_cont_restrictions_id => p_list_assoc_rec.list_cont_restrictions_id,
364: p_list_header_id => p_list_assoc_rec.list_header_id,
365: p_last_update_date => SYSDATE,
366: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 495: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row)

491:
492: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
493: END IF;
494:
495: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row)
496: AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row(
497: p_LIST_CONT_RESTRICTIONs_ID => p_LIST_CONT_RESTRICTIONs_ID);
498: --
499: -- End of API body

Line 496: AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row(

492: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
493: END IF;
494:
495: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row)
496: AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row(
497: p_LIST_CONT_RESTRICTIONs_ID => p_LIST_CONT_RESTRICTIONs_ID);
498: --
499: -- End of API body
500: --

Line 584: FROM AMS_LIST_CONT_RESTRICTIONS

580: l_LIST_CONT_RESTRICTIONs_ID NUMBER;
581:
582: CURSOR c_List_Assoc IS
583: SELECT LIST_CONTACT_RESTRICTIONs_ID
584: FROM AMS_LIST_CONT_RESTRICTIONS
585: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
586: AND object_version_number = p_object_version
587: FOR UPDATE NOWAIT;
588:

Line 704: 'AMS_LIST_CONT_RESTRICTIONS',

700: BEGIN
701: x_return_status := FND_API.g_ret_sts_success;
702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
703: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
704: 'AMS_LIST_CONT_RESTRICTIONS',
705: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||''''
706: );
707: ELSE
708: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 709: 'AMS_LIST_CONT_RESTRICTIONS',

705: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||''''
706: );
707: ELSE
708: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
709: 'AMS_LIST_CONT_RESTRICTIONS',
710: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||
711: ''' AND LIST_CONTACT_RESTRICTIONs_ID <> ' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID
712: );
713: END IF;

Line 974: FROM ams_list_cont_restrictions

970: l_return_status VARCHAR2(1);
971:
972: CURSOR c_complete IS
973: SELECT *
974: FROM ams_list_cont_restrictions
975: WHERE list_contact_restrictions_id = p_list_assoc_rec.list_cont_restrictions_id;
976: l_list_assoc_rec c_complete%ROWTYPE;
977: BEGIN
978: x_complete_rec := p_list_assoc_rec;