DBA Data[Home] [Help]

APPS.OKE_PARTY_MERGE_PKG dependencies on OKE_K_FUNDING_SOURCES

Line 54: -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES table

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 ,

Line 77: -- update OKE_K_FUNDING_SOURCES for the merge

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 ,

Line 78: UPDATE OKE_K_FUNDING_SOURCES

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

Line 99: -- Description: This routine takes care of the party merge for OKE_K_FUNDING_SOURCES_H table

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 ,

Line 122: -- update OKE_K_FUNDING_SOURCES_H for the merge

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 ,

Line 123: UPDATE OKE_K_FUNDING_SOURCES_H

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