[Home] [Help]
276: RAISE FND_API.g_exc_unexpected_error;
277: END IF;
278:
279: -- dhsingh start
280: l_code_assignment_rec_type.owner_table_name := 'HZ_PARTIES';
281: l_code_assignment_rec_type.owner_table_id := l_party_id;
282: l_code_assignment_rec_type.class_category := 'BUSINESS_FUNCTION';
283: l_code_assignment_rec_type.class_code := 'EVENT_VENUE';
284: -- l_code_assignment_rec_type.created_by_module := 'Oracle Marketing';
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;
2132: WHERE venue_id = id_in;
2133:
2134: CURSOR c_location(p_party_id IN NUMBER) IS
2135: SELECT address1, address2, city, state, country
2136: FROM hz_parties
2137: WHERE party_id = p_party_id;
2138: --
2139: -- This is the only exception for using %ROWTYPE.
2140: -- We are selecting from the VL view, which may
2606: ----------------------- venue party_id ------------------------
2607: IF nvl(p_object_type, 'VENU') <> 'ROOM' THEN
2608: IF p_venue_rec.location_id <> FND_API.g_miss_num THEN
2609: IF AMS_Utility_PVT.check_fk_exists(
2610: 'hz_parties',
2611: 'party_id',
2612: p_venue_rec.party_id
2613: ) = FND_API.g_false
2614: THEN