APPS.AMS_COPYACTIVITIES_PVT dependencies on AMS_CAMPAIGNS_VL

Line 263: SELECT * FROM ams_campaigns_vl

259: l_str_schedule_id VARCHAR(20);
260: -- end change 08/31/01
261:
262: CURSOR fetch_camp_details (camp_id NUMBER) IS
263: SELECT * FROM ams_campaigns_vl
264: WHERE campaign_id = camp_id ;
265:
266: l_reference_rec fetch_camp_details%ROWTYPE;
267: l_camp_rec ams_campaign_pvt.camp_rec_type;

Line 2168: l_campaign_rec ams_campaigns_vl%ROWTYPE;

2164: -- Stores the resource Id
2165: l_owner_user_id NUMBER := FND_API.G_MISS_NUM;
2166: l_mesg_text VARCHAR2(2000);
2167:
2168: l_campaign_rec ams_campaigns_vl%ROWTYPE;
2169: l_user_status_id number;
2170: l_camp_count number;
2171: l_camp_rec ams_campaign_pvt.camp_rec_type;
2172: l_date_number NUMBER := 0;

Line 2185: FROM ams_campaigns_vl

2181: l_camp_elements_rec camp_elements_rec_type;
2182:
2183: CURSOR cur_get_campaign IS
2184: SELECT *
2185: FROM ams_campaigns_vl
2186: WHERE campaign_id = p_src_camp_id;
2187:
2188: CURSOR cur_get_default_status IS
2189: SELECT user_status_id

Line 2200: FROM ams_campaigns_vl

2196:
2197: -- Used to bump up the version number if the name is same for the campaign
2198: CURSOR c_camp_name(l_campaign_name IN VARCHAR2) IS
2199: SELECT MAX(version_no)
2200: FROM ams_campaigns_vl
2201: WHERE campaign_name = l_campaign_name;
2202:
2203: CURSOR c_camp_sche(src_campaign_id IN NUMBER) IS
2204: SELECT schedule_id

Line 2217: FROM ams_campaigns_vl

2213:
2214: CURSOR sub_camp_cur IS
2215: SELECT campaign_id,
2216: campaign_name
2217: FROM ams_campaigns_vl
2218: WHERE parent_campaign_id = p_src_camp_id;
2219:
2220: BEGIN
2221: x_return_status := fnd_api.g_ret_sts_success;