[Home] [Help]
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2
90: )
91: is
92: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
93: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
94: l_api_name CONSTANT VARCHAR2(30) := 'Validate Target Group Segment';
95: l_action_rec AMS_ListAction_PVT.action_rec_type ;
96: l_action_id NUMBER;
1920: x_return_status OUT NOCOPY VARCHAR2,
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;
1966: open c1;
1967: fetch c1 into l_count ;
1968: close c1;
1969: if l_count = 0 then
1970: ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
1971: l_list_header_rec.list_name := p_list_used_by_name ;
1972: l_list_header_rec.list_type := 'TARGET';
1973: l_list_header_rec.owner_user_id := p_owner_user_id;
1974: AMS_ListHeader_PVT.Create_Listheader
1970: ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
1971: l_list_header_rec.list_name := p_list_used_by_name ;
1972: l_list_header_rec.list_type := 'TARGET';
1973: l_list_header_rec.owner_user_id := p_owner_user_id;
1974: AMS_ListHeader_PVT.Create_Listheader
1975: ( p_api_version => 1.0,
1976: p_init_msg_list => p_init_msg_list,
1977: p_commit => p_commit,
1978: p_validation_level => p_validation_level ,
2557: x_return_status OUT NOCOPY VARCHAR2,
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;
3915: from ams_campaign_schedules_vl a
3916: where a.schedule_id = p_from_schedule_id ;
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);
3916: where a.schedule_id = p_from_schedule_id ;
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:
3995: OPEN c_new_schedule_details;
3996: FETCH c_new_schedule_details INTO l_sched_rec;
3997: CLOSE c_new_schedule_details;
3998:
3999: ams_listheader_pvt.init_listheader_rec(l_tmp_listheader_rec);
4000: l_tmp_listheader_rec.list_header_id := l_target_group_rec.list_header_id;
4001: l_old_list_header_id:=l_target_group_rec.list_header_id;
4002: l_query_temp_id := l_target_group_rec.query_template_id;
4003: l_purpose_code := l_target_group_rec.purpose_code;
4005: --vbhandar modified 05-13-2004 TO fix bug 3621786
4006: l_tmp_listheader_rec.APPLY_TRAFFIC_COP := l_target_group_rec.APPLY_TRAFFIC_COP;
4007:
4008:
4009: ams_listheader_pvt.complete_listheader_rec
4010: (p_listheader_rec =>l_tmp_listheader_rec,
4011: x_complete_rec =>l_listheader_rec);
4012: l_listheader_rec.list_header_id := fnd_api.g_miss_num;
4013: l_listheader_rec.list_name := l_sched_rec.list_name; -- Kiran changed to l_sched_rec.list_name
4065: l_listheader_rec.status_code_old := null;
4066:
4067:
4068: -- ckapoor R12 copy
4069: AMS_ListHeader_PVT.Create_Listheader
4070: ( p_api_version => 1.0,
4071: p_init_msg_list => FND_API.g_false,
4072: p_commit => FND_API.g_false,
4073: p_validation_level => FND_API.g_valid_level_full,