APPS.AMS_VENUE_PVT dependencies on AMS_VENUES_VL

Line 9: -- AMS_VENUES_VL:

5: -- PACKAGE
6: -- AMS_Venue_PVT
7: --
8: -- PROCEDURES
9: -- AMS_VENUES_VL:
10: -- Check_Venue_Req_Items
11: -- Check_Venue_UK_Items
12: -- Check_Venue_FK_Items
13: -- Check_Venue_Lookup_Items

Line 638: FROM ams_venues_vl

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:
641: CURSOR c_date IS
642: SELECT sysdate

Line 951: FROM hz_parties loc, ams_venues_vl ven

947: IS
948:
949: CURSOR c_location(ven_id IN NUMBER) IS
950: SELECT loc.address1, loc.address2, loc.city, loc.state, loc.country
951: FROM hz_parties loc, ams_venues_vl ven
952: WHERE loc.party_id = ven.party_id
953: and ven.venue_id = ven_id;
954:
955: -- l_location_rec HZ_LOCATION_PUB.Location_Rec_Type;

Line 1310: FROM hz_locations loc, ams_venues_vl ven

1306: IS
1307: /*
1308: CURSOR c_location(ven_id IN NUMBER) IS
1309: SELECT loc.address1, loc.address2, loc.city, loc.state, loc.country
1310: FROM hz_locations loc, ams_venues_vl ven
1311: WHERE loc.location_id = ven.location_id
1312: and ven.venue_id = ven_id;
1313: -- l_location_rec HZ_LOCATION_PUB.Location_Rec_Type;
1314: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;

Line 1678: FROM ams_venues_vl

1674: -- and perform comparison in the body and raise the
1675: -- exception there.
1676: CURSOR c_lock IS
1677: SELECT object_version_number
1678: FROM ams_venues_vl
1679: WHERE venue_id = p_venue_id
1680: AND object_version_number = p_object_version
1681: FOR UPDATE NOWAIT;
1682: BEGIN

Line 2131: FROM ams_venues_vl

2127: )
2128: IS
2129: CURSOR c_venue (id_in IN NUMBER) IS
2130: SELECT *
2131: FROM ams_venues_vl
2132: WHERE venue_id = id_in;
2133:
2134: CURSOR c_location(p_party_id IN NUMBER) IS
2135: SELECT address1, address2, city, state, country

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

Line 2522: 'ams_venues_vl',

2518: IF p_validation_mode = JTF_PLSQL_API.g_create
2519: AND p_venue_rec.venue_id IS NOT NULL
2520: THEN
2521: IF AMS_Utility_PVT.check_uniqueness(
2522: 'ams_venues_vl',
2523: 'venue_id = ' || p_venue_rec.venue_id
2524: ) = FND_API.g_false
2525: THEN
2526: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 2545: 'ams_venues_vl',

2541: fetch c_vnu_name_crt into l_dummy;
2542: close c_vnu_name_crt;
2543: bug # 1490374
2544: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2545: 'ams_venues_vl',
2546: 'venue_name = ''' || p_venue_rec.venue_name || ''''
2547: );
2548:
2549: ELSE

Line 2555: 'ams_venues_vl',

2551: fetch c_vnu_name_up into l_dummy;
2552: close c_vnu_name_up;
2553: bug # 1490374
2554: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2555: 'ams_venues_vl',
2556: 'venue_name = ''' || p_venue_rec.venue_name ||
2557: ''' AND venue_id <> ' || p_venue_rec.venue_id
2558: );
2559: