50:
51: --
52: -- Procedure: funding_party_merge
53: --
54: -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES table
55: --
56:
57: PROCEDURE funding_party_merge(p_merge_name IN VARCHAR2 ,
58: p_from_id IN NUMBER ,
73: p_to_id := p_from_id;
74: return;
75: END IF;
76:
77: -- update OKE_K_FUNDING_SOURCES for the merge
78: UPDATE OKE_K_FUNDING_SOURCES
79: SET k_party_id = p_to_fk_id ,
80: last_update_date = hz_utility_pub.last_update_date ,
81: last_updated_by = hz_utility_pub.user_id ,
74: return;
75: END IF;
76:
77: -- update OKE_K_FUNDING_SOURCES for the merge
78: UPDATE OKE_K_FUNDING_SOURCES
79: SET k_party_id = p_to_fk_id ,
80: last_update_date = hz_utility_pub.last_update_date ,
81: last_updated_by = hz_utility_pub.user_id ,
82: last_update_login = hz_utility_pub.last_update_login
95:
96: --
97: -- Procedure: funding_party_h_merge
98: --
99: -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES_H table
100: --
101:
102: PROCEDURE funding_party_h_merge(p_merge_name IN VARCHAR2 ,
103: p_from_id IN NUMBER ,
118: p_to_id := p_from_id;
119: return;
120: END IF;
121:
122: -- update OKE_K_FUNDING_SOURCES_H for the merge
123: UPDATE OKE_K_FUNDING_SOURCES_H
124: SET k_party_id = p_to_fk_id ,
125: last_update_date = hz_utility_pub.last_update_date ,
126: last_updated_by = hz_utility_pub.user_id ,
119: return;
120: END IF;
121:
122: -- update OKE_K_FUNDING_SOURCES_H for the merge
123: UPDATE OKE_K_FUNDING_SOURCES_H
124: SET k_party_id = p_to_fk_id ,
125: last_update_date = hz_utility_pub.last_update_date ,
126: last_updated_by = hz_utility_pub.user_id ,
127: last_update_login = hz_utility_pub.last_update_login