47:
48: if p_parent_entity_name = 'HZ_PARTIES' then
49: -- Update the table with the new party_id
50: update umx_reg_requests set requested_for_party_id = p_To_FK_id,
51: last_update_date = hz_utility_pub.last_update_date,
52: last_updated_by = hz_utility_pub.user_id,
53: last_update_login = hz_utility_pub.last_update_login
54: where requested_for_party_id = p_From_FK_id;
55: return;
48: if p_parent_entity_name = 'HZ_PARTIES' then
49: -- Update the table with the new party_id
50: update umx_reg_requests set requested_for_party_id = p_To_FK_id,
51: last_update_date = hz_utility_pub.last_update_date,
52: last_updated_by = hz_utility_pub.user_id,
53: last_update_login = hz_utility_pub.last_update_login
54: where requested_for_party_id = p_From_FK_id;
55: return;
56: end if;
49: -- Update the table with the new party_id
50: update umx_reg_requests set requested_for_party_id = p_To_FK_id,
51: last_update_date = hz_utility_pub.last_update_date,
52: last_updated_by = hz_utility_pub.user_id,
53: last_update_login = hz_utility_pub.last_update_login
54: where requested_for_party_id = p_From_FK_id;
55: return;
56: end if;
57: end if;