DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 6127: l_eventheader_rec ams_event_headers_vl%ROWTYPE;

6123: l_evo_rec ams_eventoffer_pvt.evo_rec_type := p_evo_rec;
6124:
6125: l_mesg_text VARCHAR2(2000);
6126: p_errmsg VARCHAR2(3000);
6127: l_eventheader_rec ams_event_headers_vl%ROWTYPE;
6128:
6129: l_lookup_meaning VARCHAR2(80);
6130: l_dummy VARCHAR2(1);
6131:

Line 6134: FROM ams_event_headers_vl

6130: l_dummy VARCHAR2(1);
6131:
6132: CURSOR c_get_header_info IS
6133: SELECT *
6134: FROM ams_event_headers_vl
6135: WHERE event_header_id = p_src_evh_id;
6136:
6137: CURSOR c_setup_resp(id_in IN NUMBER) IS
6138: SELECT 'x'

Line 6365: FROM ams_event_headers_vl

6361:
6362: CURSOR sub_eveh_cur
6363: IS
6364: SELECT event_header_id
6365: FROM ams_event_headers_vl
6366: WHERE parent_event_header_id = p_src_evh_id;
6367:
6368: CURSOR c_header_resp IS
6369: SELECT attribute_defined_flag