APPS.AMS_VENUE_PVT dependencies on AMS_VENUES_B

Line 631: SELECT ams_venues_b_s.NEXTVAL

627: x_resource_number VARCHAR2(30);
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

Line 708: INSERT INTO ams_venues_b (

704:
705: --
706: -- Insert into mutli-language supported table.
707: --
708: INSERT INTO ams_venues_b (
709: VENUE_ID,
710: CUSTOM_SETUP_ID,
711: LAST_UPDATE_DATE,
712: LAST_UPDATED_BY,

Line 1396: UPDATE ams_venues_b

1392:
1393: AMS_Utility_PVT.debug_message (l_full_name || ': Update');
1394: END IF;
1395:
1396: UPDATE ams_venues_b
1397: SET
1398: last_update_date = SYSDATE,
1399: last_updated_by = FND_GLOBAL.User_Id,
1400: last_update_login = FND_GLOBAL.Conc_Login_Id,

Line 1588: DELETE FROM ams_venues_b

1584: END IF;
1585: RAISE FND_API.g_exc_error;
1586: END IF;
1587:
1588: DELETE FROM ams_venues_b
1589: WHERE venue_id = p_venue_id
1590: AND object_version_number = p_object_version;
1591:
1592: -------------------- finish --------------------------

Line 2628: 'ams_venues_b',

2624: END IF;
2625: ELSE
2626: IF p_venue_rec.parent_venue_id <> FND_API.g_miss_num THEN
2627: IF AMS_Utility_PVT.check_fk_exists(
2628: 'ams_venues_b',
2629: 'venue_id',
2630: p_venue_rec.parent_venue_id
2631: ) = FND_API.g_false
2632: THEN