eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_VENUE_PVT dependencies on DUAL

Line 632: FROM dual;

628: l_date DATE;
629:
630: CURSOR c_seq IS
631: SELECT ams_venues_b_s.NEXTVAL
632: FROM dual;
633:
634: CURSOR c_id_exists (x_id IN NUMBER) IS
635: SELECT 1
636: FROM dual

Line 636: FROM dual

632: FROM dual;
633:
634: CURSOR c_id_exists (x_id IN NUMBER) IS
635: SELECT 1
636: FROM dual
637: WHERE EXISTS (SELECT 1
638: FROM ams_venues_vl
639: WHERE venue_id = x_id);
640:

Line 643: FROM dual;

639: WHERE venue_id = x_id);
640:
641: CURSOR c_date IS
642: SELECT sysdate
643: FROM dual;
644:
645: BEGIN
646:
647: x_return_status := FND_API.g_ret_sts_success;

Line 2500: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl

2496: l_valid_flag VARCHAR2(1);
2497: l_dummy NUMBER;
2498: /*
2499: cursor c_vnu_name(vnu_name_in IN VARCHAR2) IS
2500: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl
2501: where VENUE_NAME = vnu_name_in);
2502: */
2503: cursor c_room_name(room_name_in IN VARCHAR2, venue_id_in IN NUMBER) IS
2504: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl

Line 2504: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl

2500: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl
2501: where VENUE_NAME = vnu_name_in);
2502: */
2503: cursor c_room_name(room_name_in IN VARCHAR2, venue_id_in IN NUMBER) IS
2504: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl
2505: where VENUE_NAME = room_name_in and parent_venue_id = venue_id_in);
2506: /*
2507: cursor c_vnu_name_up(vnu_name_in IN VARCHAR2, vnu_id_in in NUMBER) IS
2508: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl

Line 2508: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl

2504: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl
2505: where VENUE_NAME = room_name_in and parent_venue_id = venue_id_in);
2506: /*
2507: cursor c_vnu_name_up(vnu_name_in IN VARCHAR2, vnu_id_in in NUMBER) IS
2508: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_venues_vl
2509: where VENUE_NAME = vnu_name_in
2510: and VENUE_ID = vnu_id_in);
2511: */
2512: BEGIN