APPS.IGW_PARTY_MERGE_PUB dependencies on IGW_PERSON_BIOSKETCH

Line 110: from igw_person_biosketch

106: IS
107:
108: cursor from_party_cur(l_person_biosketch_id number) is
109: select *
110: from igw_person_biosketch
111: where person_biosketch_id = l_person_biosketch_id;
112:
113: from_party_rec from_party_cur%rowtype;
114:

Line 117: from igw_person_biosketch

113: from_party_rec from_party_cur%rowtype;
114:
115: cursor to_party_cur(l_party_id number,l_biosketch_type varchar2,l_line_description varchar2) is
116: select *
117: from igw_person_biosketch
118: where party_id = l_party_id and
119: biosketch_type = l_biosketch_type and line_description = l_line_description;
120:
121: to_party_rec to_party_cur%rowtype;

Line 131: if (p_entity_name <> 'IGW_PERSON_BIOSKETCH')

127: savepoint party_merge_sp;
128:
129: x_return_status := fnd_api.g_ret_sts_success;
130:
131: if (p_entity_name <> 'IGW_PERSON_BIOSKETCH')
132: or (p_parent_entity_name <> 'HZ_PARTIES') then
133: fnd_message.set_name ('IGW', 'IGW_MRG_ENTITY_NAME_ERR');
134: fnd_message.set_token('P_ENTITY',p_entity_name);
135: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 156: update igw_person_biosketch

152: RAISE fnd_api.g_exc_error;
153:
154: else
155: --update from record with new party id
156: update igw_person_biosketch
157: set party_id = p_to_fk_id
158: where person_biosketch_id = p_from_id;
159:
160: x_to_id := p_from_id;