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_ACT_LIST_PVT dependencies on AMS_ACT_LIST_PVT

Line 1: PACKAGE BODY AMS_Act_List_PVT as

1: PACKAGE BODY AMS_Act_List_PVT as
2: /* $Header: amsvalsb.pls 120.10.12010000.2 2008/08/11 08:34:12 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_ACT_LIST_PVT

2: /* $Header: amsvalsb.pls 120.10.12010000.2 2008/08/11 08:34:12 amlal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_ACT_LIST_PVT
7: -- Purpose
8: -- History
9: -- NOTE added fix for bug 3817224 on 08/06
10: -- 19-apr-2005 ndadwal code inclusions for Target Group Locking on ScheduleStatus change.

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';

12: -- End of Comments
13: -- ===============================================================
14:
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvalsb.pls';
18: g_list_header_id number;
19: g_count NUMBER := 1;
20: g_remote_list VARCHAR2(1) := 'N';

Line 838: l_tar_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;

834: -- Local Variables
835: l_object_version_number NUMBER;
836: l_ACT_LIST_HEADER_ID NUMBER;
837: l_ref_act_list_rec c_get_Act_List%ROWTYPE ;
838: l_tar_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;
839: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;
840: l_rowid ROWID;
841: l_act_list_group_id number;
842:

Line 839: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;

835: l_object_version_number NUMBER;
836: l_ACT_LIST_HEADER_ID NUMBER;
837: l_ref_act_list_rec c_get_Act_List%ROWTYPE ;
838: l_tar_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;
839: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type := P_act_list_rec;
840: l_rowid ROWID;
841: l_act_list_group_id number;
842:
843: l_list_group_rec AMS_List_Group_PVT.list_group_rec_type;

Line 1763: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type;

1759: IS
1760: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Act_List';
1761: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1762: l_object_version_number NUMBER;
1763: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type;
1764:
1765: BEGIN
1766: -- Standard Start of API savepoint
1767: SAVEPOINT VALIDATE_Act_List_;

Line 1925: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type ;

1921: x_msg_count OUT NOCOPY NUMBER,
1922: x_msg_data OUT NOCOPY VARCHAR2,
1923: x_list_header_id OUT NOCOPY NUMBER ) IS
1924: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
1925: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type ;
1926: l_api_name constant varchar2(30) := 'Create_List';
1927: l_api_version CONSTANT NUMBER := 1.0;
1928: l_act_list_header_id number;
1929: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';

Line 1929: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';

1925: l_act_list_rec AMS_Act_List_PVT.act_list_rec_type ;
1926: l_api_name constant varchar2(30) := 'Create_List';
1927: l_api_version CONSTANT NUMBER := 1.0;
1928: l_act_list_header_id number;
1929: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Act_List_PVT';
1930: l_count number;
1931: cursor c1 is
1932: select count(1)
1933: from ams_act_lists

Line 1991: AMS_Act_List_PVT.Create_Act_List(

1987: l_act_list_rec.list_used_by := p_list_used_by;
1988: l_act_list_rec.list_used_by_id := p_list_used_by_id;
1989: l_act_list_rec.list_act_type := 'TARGET';
1990:
1991: AMS_Act_List_PVT.Create_Act_List(
1992: p_api_version_number => p_api_version,
1993: p_init_msg_list => p_init_msg_list,
1994: p_commit => p_commit,
1995: p_validation_level => p_validation_level,

Line 2562: l_act_list_rec AMS_ACT_LIST_PVT.act_list_rec_type ;

2558: x_msg_count OUT NOCOPY NUMBER,
2559: x_msg_data OUT NOCOPY VARCHAR2
2560: ) is
2561: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
2562: l_act_list_rec AMS_ACT_LIST_PVT.act_list_rec_type ;
2563: l_api_name constant varchar2(30) := 'gen_target_group_old';
2564: l_api_version CONSTANT NUMBER := 1.0;
2565: l_act_list_header_id number;
2566: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ACT_LIST_PVT';

Line 2566: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ACT_LIST_PVT';

2562: l_act_list_rec AMS_ACT_LIST_PVT.act_list_rec_type ;
2563: l_api_name constant varchar2(30) := 'gen_target_group_old';
2564: l_api_version CONSTANT NUMBER := 1.0;
2565: l_act_list_header_id number;
2566: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ACT_LIST_PVT';
2567: l_count number;
2568: cursor c1 is
2569: select al.list_header_id,
2570: al.ctrl_random_pct_row_selection,

Line 3921: l_act_list_rec AMS_ACT_LIST_PVT.act_list_rec_type ;

3917: l_target_group_rec c_get_target_group%rowtype;
3918:
3919: l_listheader_rec ams_listheader_pvt.list_header_rec_type;
3920: l_tmp_listheader_rec ams_listheader_pvt.list_header_rec_type;
3921: l_act_list_rec AMS_ACT_LIST_PVT.act_list_rec_type ;
3922: l_last_order_number number ;
3923: l_exclude_flag varchar2(1);
3924:
3925: l_return_status VARCHAR2(1);

Line 3974: AMS_Utility_PVT.debug_message('Private API:AMS_Act_List_PVT.copy_target_group '||p_from_schedule_id||':::::'||p_to_schedule_id);

3970: begin
3971: SAVEPOINT copy_target_group_pvt;
3972:
3973: IF (AMS_DEBUG_HIGH_ON) THEN
3974: AMS_Utility_PVT.debug_message('Private API:AMS_Act_List_PVT.copy_target_group '||p_from_schedule_id||':::::'||p_to_schedule_id);
3975: END IF;
3976:
3977: open c_get_target_group;
3978: fetch c_get_target_group into l_target_group_rec ;

Line 4208: AMS_ACT_LIST_PVT.Create_Act_List(

4204: l_act_list_rec.list_used_by := p_list_used_by ;
4205: l_act_list_rec.list_used_by_id := p_to_schedule_id ;
4206: l_act_list_rec.list_act_type := 'TARGET';
4207:
4208: AMS_ACT_LIST_PVT.Create_Act_List(
4209: p_api_version_number => 1.0,
4210: p_init_msg_list => FND_API.g_false,
4211: p_commit => FND_API.g_false,
4212: p_validation_level => FND_API.g_valid_level_full,

Line 4264: AMS_ACT_LIST_PVT.Create_Act_List(

4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );
4262: END IF;
4263:
4264: AMS_ACT_LIST_PVT.Create_Act_List(
4265: p_api_version_number => 1.0,
4266: p_init_msg_list => FND_API.g_false,
4267: p_commit => FND_API.g_false,
4268: p_validation_level => FND_API.G_VALID_LEVEL_FULL, --here

Line 4313: AMS_ACT_LIST_PVT.Create_Act_List(

4309: l_act_list_rec.list_act_type := 'LIST';
4310: l_act_list_rec.list_action_type := 'EXCLUDE' ;
4311: l_act_list_rec.order_number := l_last_order_number +5 ;
4312: l_act_list_rec.group_code := l_target_group_rec.group_code ;
4313: AMS_ACT_LIST_PVT.Create_Act_List(
4314: p_api_version_number => 1.0,
4315: p_init_msg_list => FND_API.g_false,
4316: p_commit => FND_API.g_false,
4317: p_validation_level => FND_API.g_valid_level_full,

Line 5103: WF_CORE.CONTEXT('AMS_Act_List_PVT', 'INVOKE_TARGET_GROUP_LOCK', p_event.getEventName( ), p_subscription_guid);

5099: EXCEPTION
5100:
5101: WHEN OTHERS THEN
5102:
5103: WF_CORE.CONTEXT('AMS_Act_List_PVT', 'INVOKE_TARGET_GROUP_LOCK', p_event.getEventName( ), p_subscription_guid);
5104: WF_EVENT.setErrorInfo(p_event, 'ERROR');
5105:
5106: END INVOKE_TARGET_GROUP_LOCK;
5107:

Line 5200: END AMS_Act_List_PVT;

5196: --------------------------Procedure to UPDATE LIST STATUS TO LOCKED Ends here--------------------
5197: -------------------------------------------------------------------------------------------------
5198:
5199:
5200: END AMS_Act_List_PVT;