APPS.IGS_GR_VENUE_ADDR_PKG dependencies on HZ_LOCATIONS

Line 124: IGS_PE_HZ_LOCATIONS_PKG.INSERT_ROW(

120: RETURN;
121: ELSIF l_return_status = 'S' THEN
122:
123:
124: IGS_PE_HZ_LOCATIONS_PKG.INSERT_ROW(
125: x_rowid => lv_rowid,
126: x_location_id => l_location_id,
127: x_other_details_1 => x_other_details_1,
128: x_other_details_2 => x_other_details_2,

Line 194: FROM hz_locations

190: tmp_var VARCHAR2(2000);
191:
192: CURSOR c_loc IS
193: SELECT OBJECT_VERSION_NUMBER
194: FROM hz_locations
195: WHERE location_id = x_location_id;
196:
197: loc_rec c_loc%ROWTYPE;
198:

Line 264: SELECT ROWID INTO lv_rowid FROM IGS_PE_HZ_LOCATIONS WHERE location_id = x_location_id;

260: END IF;
261: RETURN;
262: ELSIF l_return_status = 'S' THEN
263:
264: SELECT ROWID INTO lv_rowid FROM IGS_PE_HZ_LOCATIONS WHERE location_id = x_location_id;
265:
266: IGS_PE_HZ_LOCATIONS_PKG.UPDATE_ROW(
267: x_rowid => lv_rowid,
268: x_location_id => x_location_id,

Line 266: IGS_PE_HZ_LOCATIONS_PKG.UPDATE_ROW(

262: ELSIF l_return_status = 'S' THEN
263:
264: SELECT ROWID INTO lv_rowid FROM IGS_PE_HZ_LOCATIONS WHERE location_id = x_location_id;
265:
266: IGS_PE_HZ_LOCATIONS_PKG.UPDATE_ROW(
267: x_rowid => lv_rowid,
268: x_location_id => x_location_id,
269: x_other_details_1 => x_other_details_1,
270: x_other_details_2 => x_other_details_2,