DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 682: x_table_name := 'AMS_EVENT_HEADERS_VL';

678: ELSIF (p_sys_qual ='EONE') THEN
679: x_table_name := 'AMS_EVENT_OFFERS_VL';
680: x_pk_name := 'EVENT_OFFER_ID';
681: ELSIF (p_sys_qual ='EVEH') THEN
682: x_table_name := 'AMS_EVENT_HEADERS_VL';
683: x_pk_name := 'EVENT_HEADER_ID';
684: ELSIF (p_sys_qual ='DELV') THEN
685: x_table_name := 'AMS_DELIVERABLES_VL';
686: x_pk_name := 'DELIVERABLE_ID';

Line 800: -- to ams_event_headers_vl.

796: -- 11/03/99 mpande inserted deliverable,event
797: -- 11/16/99 tdonohoe inserted campaign schedule.
798: -- 09-Dec-1999 choang Changed references of ams_event_offers_all_vl to
799: -- ams_event_offers_vl and ams_event_headers_all_vl
800: -- to ams_event_headers_vl.
801: -- 24-Aug-2000 choang Added FUND
802: -- 28-Sep-2000 choang Added PRTN
803: -- 13-Jun-2001 ptendulk Added EONE
804: -- 15-Jun-2001 choang changed PRNT to PTNR

Line 835: FROM ams_event_headers_vl

831: WHERE deliverable_id = p_object_id;
832:
833: CURSOR c_event_header(p_object_id IN NUMBER) IS
834: SELECT event_header_name
835: FROM ams_event_headers_vl
836: WHERE event_header_id = p_object_id;
837:
838: CURSOR c_event_offer(p_object_id IN NUMBER) IS
839: SELECT event_offer_name