APPS.AMS_VENUE_PVT dependencies on HZ_LOCATION_V2PUB

Line 146: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;

142: -- l_location_rec HZ_LOCATION_PUB.Location_Rec_Type;
143: -- l_org_rec HZ_Party_PUB.Organization_Rec_Type;
144: -- l_psite_rec HZ_Party_PUB.Party_Site_Rec_Type;
145:
146: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;
147: l_org_rec HZ_Party_V2PUB.Organization_Rec_Type;
148: l_psite_rec HZ_Party_Site_V2PUB.Party_Site_Rec_Type;
149:
150: l_sales_team_rec AS_ACCESS_PUB.sales_team_rec_type;

Line 224: HZ_LOCATION_V2PUB.Create_Location(

220: l_location_rec.ORIG_SYSTEM_REFERENCE := -1;
221: l_location_rec.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
222: l_location_rec.created_by_module := 'AMS_EVENT';
223:
224: HZ_LOCATION_V2PUB.Create_Location(
225: p_init_msg_list => p_init_msg_list
226: , p_location_rec => l_location_rec
227: , x_return_status => l_return_status
228: , x_msg_count => x_msg_count

Line 956: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;

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;
956: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;
957: l_location_id NUMBER;
958: l_address1 VARCHAR2(240);
959: l_address2 VARCHAR2(240);
960: l_city VARCHAR2(60);

Line 1068: HZ_LOCATION_V2PUB.Create_Location(

1064: l_location_rec.ORIG_SYSTEM_REFERENCE := -1;
1065: l_location_rec.CONTENT_SOURCE_TYPE := 'USER_ENTERED';
1066: l_location_rec.created_by_module := 'AMS_EVENT';
1067:
1068: HZ_LOCATION_V2PUB.Create_Location(
1069: p_init_msg_list => p_init_msg_list,
1070: p_location_rec => l_location_rec,
1071: x_return_status => l_return_status,
1072: x_msg_count => x_msg_count,

Line 1314: l_location_rec HZ_LOCATION_V2PUB.Location_Rec_Type;

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;
1315: l_location_id NUMBER;
1316: l_address1 VARCHAR2(240);
1317: l_address2 VARCHAR2(240);
1318: l_city VARCHAR2(60);