APPS.AMS_COPYACTIVITIES_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 1177: l_eventoffer_rec ams_event_offers_vl%ROWTYPE;

1173: -- l_new_camp_id NUMBER;
1174: l_eveo_rec ams_eventoffer_pvt.evo_rec_type;
1175: l_mesg_text VARCHAR2(2000);
1176: p_errmsg VARCHAR2(3000);
1177: l_eventoffer_rec ams_event_offers_vl%ROWTYPE;
1178: l_errcode VARCHAR2(80);
1179: l_errnum NUMBER;
1180: l_errmsg VARCHAR2(3000);
1181: l_eveo_elements_rec eveo_elements_rec_type;

Line 1183: l_new_eveo_name ams_event_offers_vl.event_offer_name%TYPE;

1179: l_errnum NUMBER;
1180: l_errmsg VARCHAR2(3000);
1181: l_eveo_elements_rec eveo_elements_rec_type;
1182: x_sub_eveo_id NUMBER;
1183: l_new_eveo_name ams_event_offers_vl.event_offer_name%TYPE;
1184: l_eveo_count NUMBER;
1185: l_lookup_meaning VARCHAR2(80);
1186: l_counter NUMBER;
1187: l_date_number NUMBER;

Line 1193: FROM ams_event_offers_vl

1189:
1190: CURSOR sub_eveo_cur
1191: IS
1192: SELECT event_offer_id
1193: FROM ams_event_offers_vl
1194: WHERE parent_event_offer_id = p_src_eveo_id;
1195:
1196: CURSOR c_eveo_name(l_eveo_name IN VARCHAR2)
1197: IS

Line 1200: -- FROM ams_event_offers_vl

1196: CURSOR c_eveo_name(l_eveo_name IN VARCHAR2)
1197: IS
1198: -- modified by dhsingh on 20.05.2004 for bug# 3631107
1199: -- SELECT COUNT(*)
1200: -- FROM ams_event_offers_vl
1201: -- WHERE event_offer_name = l_eveo_name;
1202: SELECT COUNT(*)
1203: FROM ams_event_offers_all_tl
1204: WHERE event_offer_name = l_eveo_name;

Line 1259: FROM ams_event_offers_vl

1255: l_msg_data := NULL;
1256: -- selects the event offers to copy
1257: SELECT *
1258: INTO l_eventoffer_rec
1259: FROM ams_event_offers_vl
1260: WHERE event_offer_id = p_src_eveo_id;
1261: l_eveo_rec.object_version_number := 2; -- Bug 5171873 cannot be 1
1262:
1263: l_eveo_rec.application_id := l_eventoffer_rec.application_id;

Line 1713: FROM ams_event_offers_vl

1709: -- end of modification by dhsingh
1710:
1711: CURSOR sub_eveo_cur IS
1712: SELECT event_offer_id
1713: FROM ams_event_offers_vl
1714: WHERE event_header_id = p_src_eveh_id;
1715:
1716: CURSOR c_obj_attr IS
1717: SELECT custom_setup_id