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_ENTRIES_PVT dependencies on AMS_LIST_ENTRIES

Line 1: PACKAGE BODY AMS_List_Entries_PVT as

1: PACKAGE BODY AMS_List_Entries_PVT as
2: /* $Header: amsvlieb.pls 120.0.12010000.2 2008/08/11 09:02:30 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_List_Entries_PVT

2: /* $Header: amsvlieb.pls 120.0.12010000.2 2008/08/11 09:02:30 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_List_Entries_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Entries_PVT';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Entries_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvlieb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 420: FROM ams_list_entries

416: RESOURCE_ID ,
417: LOCATION_ID ,
418: CONTACT_POINT_ID ,
419: last_contacted_date
420: FROM ams_list_entries
421: WHERE list_entry_id = p_list_entries_rec.list_entry_id;
422:
423: l_listentries_rec list_entries_rec_type;
424:

Line 1878: SELECT AMS_LIST_ENTRIES_s.NEXTVAL

1874:
1875: l_created_by NUMBER; --batoleti added this var. For bug# 6688996
1876:
1877: CURSOR c_id IS
1878: SELECT AMS_LIST_ENTRIES_s.NEXTVAL
1879: FROM dual;
1880:
1881: CURSOR c_id_exists (l_id IN NUMBER) IS
1882: SELECT 1 FROM dual

Line 1883: WHERE EXISTS (SELECT 1 FROM AMS_LIST_ENTRIES

1879: FROM dual;
1880:
1881: CURSOR c_id_exists (l_id IN NUMBER) IS
1882: SELECT 1 FROM dual
1883: WHERE EXISTS (SELECT 1 FROM AMS_LIST_ENTRIES
1884: WHERE LIST_ENTRY_ID = l_id);
1885:
1886: /* batoleti. Bug# 6688996. Added the below cursor */
1887: CURSOR cur_get_created_by (x_list_header_id IN NUMBER) IS

Line 2001: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Insert_Row)

1997:
1998: -- batoleti coding ends for bug# 6688996
1999:
2000:
2001: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Insert_Row)
2002: AMS_LIST_ENTRIES_PKG.Insert_Row(
2003: px_list_entry_id => l_list_entry_id,
2004: p_list_header_id => p_list_entries_rec.list_header_id,
2005: p_last_update_date => SYSDATE,

Line 2002: AMS_LIST_ENTRIES_PKG.Insert_Row(

1998: -- batoleti coding ends for bug# 6688996
1999:
2000:
2001: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Insert_Row)
2002: AMS_LIST_ENTRIES_PKG.Insert_Row(
2003: px_list_entry_id => l_list_entry_id,
2004: p_list_header_id => p_list_entries_rec.list_header_id,
2005: p_last_update_date => SYSDATE,
2006: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 2463: FROM AMS_LIST_ENTRIES

2459: x_object_version_number OUT NOCOPY NUMBER
2460: ) IS
2461: CURSOR c_get_list_entries(lc_list_entry_id NUMBER) IS
2462: SELECT *
2463: FROM AMS_LIST_ENTRIES
2464: WHERE list_entry_id = lc_list_entry_id ;
2465: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_List_Entries';
2466: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2467: -- Local Variables

Line 2471: l_tar_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type := P_list_entries_rec;

2467: -- Local Variables
2468: l_object_version_number NUMBER;
2469: l_LIST_ENTRY_ID NUMBER;
2470: l_ref_list_entries_rec c_get_List_Entries%ROWTYPE ;
2471: l_tar_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type := P_list_entries_rec;
2472: l_rowid ROWID;
2473: x_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type ;
2474:
2475: l_created_by NUMBER; --batoleti added this var. For bug# 6688996

Line 2473: x_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type ;

2469: l_LIST_ENTRY_ID NUMBER;
2470: l_ref_list_entries_rec c_get_List_Entries%ROWTYPE ;
2471: l_tar_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type := P_list_entries_rec;
2472: l_rowid ROWID;
2473: x_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type ;
2474:
2475: l_created_by NUMBER; --batoleti added this var. For bug# 6688996
2476:
2477: /* batoleti. Bug# 6688996. Added the below cursor */

Line 2591: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Update_Row)

2587:
2588: -- batoleti coding ends for bug# 6688996
2589:
2590:
2591: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Update_Row)
2592: AMS_LIST_ENTRIES_PKG.Update_Row(
2593: p_list_entry_id => x_list_entries_rec.list_entry_id,
2594: p_list_header_id => x_list_entries_rec.list_header_id,
2595: p_last_update_date => SYSDATE,

Line 2592: AMS_LIST_ENTRIES_PKG.Update_Row(

2588: -- batoleti coding ends for bug# 6688996
2589:
2590:
2591: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Update_Row)
2592: AMS_LIST_ENTRIES_PKG.Update_Row(
2593: p_list_entry_id => x_list_entries_rec.list_entry_id,
2594: p_list_header_id => x_list_entries_rec.list_header_id,
2595: p_last_update_date => SYSDATE,
2596: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 3094: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Delete_Row)

3090:
3091: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
3092: END IF;
3093:
3094: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Delete_Row)
3095: AMS_LIST_ENTRIES_PKG.Delete_Row(
3096: p_LIST_ENTRY_ID => p_LIST_ENTRY_ID);
3097: --
3098: -- End of API body

Line 3095: AMS_LIST_ENTRIES_PKG.Delete_Row(

3091: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
3092: END IF;
3093:
3094: -- Invoke table handler(AMS_LIST_ENTRIES_PKG.Delete_Row)
3095: AMS_LIST_ENTRIES_PKG.Delete_Row(
3096: p_LIST_ENTRY_ID => p_LIST_ENTRY_ID);
3097: --
3098: -- End of API body
3099: --

Line 3183: FROM AMS_LIST_ENTRIES

3179: l_LIST_ENTRY_ID NUMBER;
3180:
3181: CURSOR c_List_Entries IS
3182: SELECT LIST_ENTRY_ID
3183: FROM AMS_LIST_ENTRIES
3184: WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID
3185: AND object_version_number = p_object_version
3186: FOR UPDATE NOWAIT;
3187:

Line 3302: 'AMS_LIST_ENTRIES',

3298: BEGIN
3299: x_return_status := FND_API.g_ret_sts_success;
3300: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3301: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
3302: 'AMS_LIST_ENTRIES',
3303: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||''''
3304: );
3305: ELSE
3306: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 3307: 'AMS_LIST_ENTRIES',

3303: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||''''
3304: );
3305: ELSE
3306: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
3307: 'AMS_LIST_ENTRIES',
3308: 'LIST_ENTRY_ID = ''' || p_list_entries_rec.LIST_ENTRY_ID ||
3309: ''' AND LIST_ENTRY_ID <> ' || p_list_entries_rec.LIST_ENTRY_ID
3310: );
3311: END IF;

Line 3825: l_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type;

3821: IS
3822: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_List_Entries';
3823: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
3824: l_object_version_number NUMBER;
3825: l_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type;
3826:
3827: BEGIN
3828: -- Standard Start of API savepoint
3829: SAVEPOINT VALIDATE_List_Entries_;

Line 4443: INSERT INTO AMS_lIST_ENTRIES(list_entry_id ,

4439:
4440: -- Initialize API return status to success
4441: x_return_status := FND_API.G_RET_STS_SUCCESS;
4442:
4443: INSERT INTO AMS_lIST_ENTRIES(list_entry_id ,
4444: list_header_id ,
4445: last_update_date ,
4446: last_updated_by ,
4447: creation_date ,

Line 4811: select ams_list_entries_s.nextval ,

4807: outcome_id ,
4808: result_id ,
4809: reason_id
4810: )
4811: select ams_list_entries_s.nextval ,
4812: p_new_list_header_id ,
4813: SYSDATE ,
4814: FND_GLOBAL.user_id ,
4815: SYSDATE ,

Line 4825: ams_list_entries_s.currval ,

4821: list_select_action_from_name ,
4822: 'NONE' ,
4823: 'NONE' ,
4824: 0 ,
4825: ams_list_entries_s.currval ,
4826: list_entry_source_system_id ,
4827: list_entry_source_system_type ,
4828: view_application_id ,
4829: manually_entered_flag ,

Line 5178: FROM ams_list_entries

5174: newly_updated_flag ,
5175: outcome_id ,
5176: result_id ,
5177: reason_id
5178: FROM ams_list_entries
5179: WHERE list_header_id = p_list_header_id ;
5180:
5181:
5182:

Line 5256: END AMS_List_Entries_PVT;

5252:
5253: END Copy_List_Entries;
5254:
5255:
5256: END AMS_List_Entries_PVT;