APPS.OKE_PARTY_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 35: last_update_date = hz_utility_pub.last_update_date ,

31:
32: -- update OKE_POOL_PARTIES for the merge
33: UPDATE OKE_POOL_PARTIES
34: SET party_id = p_to_fk_id ,
35: last_update_date = hz_utility_pub.last_update_date ,
36: last_updated_by = hz_utility_pub.user_id ,
37: last_update_login = hz_utility_pub.last_update_login
38: WHERE party_id = p_from_fk_id;
39:

Line 36: last_updated_by = hz_utility_pub.user_id ,

32: -- update OKE_POOL_PARTIES for the merge
33: UPDATE OKE_POOL_PARTIES
34: SET party_id = p_to_fk_id ,
35: last_update_date = hz_utility_pub.last_update_date ,
36: last_updated_by = hz_utility_pub.user_id ,
37: last_update_login = hz_utility_pub.last_update_login
38: WHERE party_id = p_from_fk_id;
39:
40: EXCEPTION

Line 37: last_update_login = hz_utility_pub.last_update_login

33: UPDATE OKE_POOL_PARTIES
34: SET party_id = p_to_fk_id ,
35: last_update_date = hz_utility_pub.last_update_date ,
36: last_updated_by = hz_utility_pub.user_id ,
37: last_update_login = hz_utility_pub.last_update_login
38: WHERE party_id = p_from_fk_id;
39:
40: EXCEPTION
41: WHEN OTHERS THEN

Line 80: last_update_date = hz_utility_pub.last_update_date ,

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
83: WHERE k_party_id = p_from_fk_id;
84:

Line 81: last_updated_by = hz_utility_pub.user_id ,

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
83: WHERE k_party_id = p_from_fk_id;
84:
85: EXCEPTION

Line 82: last_update_login = hz_utility_pub.last_update_login

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
83: WHERE k_party_id = p_from_fk_id;
84:
85: EXCEPTION
86: WHEN OTHERS THEN

Line 125: last_update_date = hz_utility_pub.last_update_date ,

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
128: WHERE k_party_id = p_from_fk_id;
129:

Line 126: last_updated_by = hz_utility_pub.user_id ,

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
128: WHERE k_party_id = p_from_fk_id;
129:
130: EXCEPTION

Line 127: last_update_login = hz_utility_pub.last_update_login

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
128: WHERE k_party_id = p_from_fk_id;
129:
130: EXCEPTION
131: WHEN OTHERS THEN