APPS.IGW_PARTY_MERGE_PUB dependencies on IGW_PROP_LOCATIONS

Line 200: from igw_prop_locations

196: IS
197:
198: cursor from_party_cur(l_prop_locations_id number) is
199: select *
200: from igw_prop_locations
201: where prop_location_id = l_prop_locations_id;
202:
203: from_party_rec from_party_cur%rowtype;
204:

Line 207: from igw_prop_locations

203: from_party_rec from_party_cur%rowtype;
204:
205: cursor to_party_cur(l_party_id number,l_proposal_id number) is
206: select *
207: from igw_prop_locations
208: where proposal_id = l_proposal_id and
209: party_id = l_party_id;
210:
211: to_party_rec to_party_cur%rowtype;

Line 221: if (p_entity_name <> 'IGW_PROP_LOCATIONS')

217: savepoint party_merge_sp;
218:
219: x_return_status := fnd_api.g_ret_sts_success;
220:
221: if (p_entity_name <> 'IGW_PROP_LOCATIONS')
222: or (p_parent_entity_name <> 'HZ_PARTIES') then
223: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
224: fnd_message.set_token('P_ENTITY',p_entity_name);
225: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 246: update igw_prop_locations

242: RAISE fnd_api.g_exc_error;
243:
244: else
245: --update from record with new party id
246: update igw_prop_locations
247: set party_id = p_to_fk_id
248: where prop_location_id = p_from_id;
249:
250: x_to_id := p_from_id;