APPS.JTF_IH_PARTY_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 99: last_update_date = hz_utility_pub.last_update_date,

95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;
96: update jtf_ih_interactions
97: -- set party_id = decode(party_id, p_to_fk_id, p_to_fk_id, party_id),
98: set party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: -- Enh# 1846960
103: -- If Primary_Party_Id equals Party_Id then update it to new value.

Line 100: last_updated_by = hz_utility_pub.user_id,

96: update jtf_ih_interactions
97: -- set party_id = decode(party_id, p_to_fk_id, p_to_fk_id, party_id),
98: set party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: -- Enh# 1846960
103: -- If Primary_Party_Id equals Party_Id then update it to new value.
104: primary_party_id = decode(primary_party_id, party_id, p_to_fk_id,primary_party_id),

Line 101: last_update_login = hz_utility_pub.last_update_login,

97: -- set party_id = decode(party_id, p_to_fk_id, p_to_fk_id, party_id),
98: set party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: -- Enh# 1846960
103: -- If Primary_Party_Id equals Party_Id then update it to new value.
104: primary_party_id = decode(primary_party_id, party_id, p_to_fk_id,primary_party_id),
105: -- If Contact_Party_Id equals Primary_Party_ID and Primary_Party_ID is going to be

Line 110: request_id = hz_utility_pub.request_id,

106: -- not a person, then update Contact_Party_ID to NULL
107: contact_party_id = decode(nvl(contact_party_id,-1),-1,NULL,
108: decode(contact_party_id,primary_party_id,
109: (decode(s_Party_Type,'PERSON',p_to_fk_id,NULL)), contact_party_id)),
110: request_id = hz_utility_pub.request_id,
111: program_application_id = hz_utility_pub.program_application_id,
112: program_id = hz_utility_pub.program_id,
113: program_update_date = sysdate,
114: object_version_number = object_version_number + 1 -- Bug# 2295015

Line 111: program_application_id = hz_utility_pub.program_application_id,

107: contact_party_id = decode(nvl(contact_party_id,-1),-1,NULL,
108: decode(contact_party_id,primary_party_id,
109: (decode(s_Party_Type,'PERSON',p_to_fk_id,NULL)), contact_party_id)),
110: request_id = hz_utility_pub.request_id,
111: program_application_id = hz_utility_pub.program_application_id,
112: program_id = hz_utility_pub.program_id,
113: program_update_date = sysdate,
114: object_version_number = object_version_number + 1 -- Bug# 2295015
115: -- where interaction_id = p_from_id;

Line 112: program_id = hz_utility_pub.program_id,

108: decode(contact_party_id,primary_party_id,
109: (decode(s_Party_Type,'PERSON',p_to_fk_id,NULL)), contact_party_id)),
110: request_id = hz_utility_pub.request_id,
111: program_application_id = hz_utility_pub.program_application_id,
112: program_id = hz_utility_pub.program_id,
113: program_update_date = sysdate,
114: object_version_number = object_version_number + 1 -- Bug# 2295015
115: -- where interaction_id = p_from_id;
116: where party_id = p_from_fk_id; -- Bug 2295015