APPS.AMS_COPYACTIVITIES_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 1681: l_eventheader_rec ams_event_headers_vl%ROWTYPE;

1677: -- l_new_camp_id NUMBER;
1678: l_eveh_rec ams_eventheader_pvt.evh_rec_type;
1679: l_mesg_text VARCHAR2(2000);
1680: p_errmsg VARCHAR2(3000);
1681: l_eventheader_rec ams_event_headers_vl%ROWTYPE;
1682: l_errcode VARCHAR2(80);
1683: l_errnum NUMBER;
1684: l_errmsg VARCHAR2(3000);
1685: l_eveh_elements_rec eveh_elements_rec_type;

Line 1688: l_new_eveh_name ams_event_headers_vl.event_header_name%TYPE;

1684: l_errmsg VARCHAR2(3000);
1685: l_eveh_elements_rec eveh_elements_rec_type;
1686: l_eveo_elements_rec eveo_elements_rec_type;
1687: x_sub_eveh_id NUMBER;
1688: l_new_eveh_name ams_event_headers_vl.event_header_name%TYPE;
1689: l_eveh_count NUMBER;
1690: l_lookup_meaning VARCHAR2(80);
1691: x_eventoffer_id NUMBER;
1692: l_counter NUMBER;

Line 1698: FROM ams_event_headers_vl

1694: l_custom_setup_id NUMBER;
1695:
1696: CURSOR sub_eveh_cur IS
1697: SELECT event_header_id
1698: FROM ams_event_headers_vl
1699: WHERE parent_event_header_id = p_src_eveh_id;
1700:
1701: CURSOR c_eveh_name(l_eveh_name IN VARCHAR2) IS
1702: -- modified by dhsingh on 20.05.2004 for bug# 3631107

Line 1704: -- FROM ams_event_headers_vl

1700:
1701: CURSOR c_eveh_name(l_eveh_name IN VARCHAR2) IS
1702: -- modified by dhsingh on 20.05.2004 for bug# 3631107
1703: -- SELECT COUNT(*)
1704: -- FROM ams_event_headers_vl
1705: -- WHERE event_header_name = l_eveh_name;
1706: SELECT COUNT(*)
1707: FROM ams_event_headers_all_tl
1708: WHERE event_header_name = l_eveh_name ;

Line 1769: FROM ams_event_headers_vl

1765: l_msg_data := NULL;
1766: -- selects the event offers to copy
1767: SELECT *
1768: INTO l_eventheader_rec
1769: FROM ams_event_headers_vl
1770: WHERE event_header_id = p_src_eveh_id;
1771: l_eveh_rec.object_version_number := 2; -- Bug 5171873 cannot be 1
1772:
1773: l_eveh_rec.application_id := l_eventheader_rec.application_id;