APPS.JTF_FM_PARTY_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 93: last_update_date = hz_utility_pub.last_update_date,

89: IF (upper(p_entity_name) = 'JTF_FM_PREVIEWS_V')
90: THEN
91: update JTF_FM_PREVIEWS
92: set fm_party_id = p_to_fk_id,
93: last_update_date = hz_utility_pub.last_update_date,
94: last_updated_by = hz_utility_pub.user_id,
95: last_update_login = hz_utility_pub.last_update_login
96: where fm_party_id = p_from_fk_id;
97:

Line 94: last_updated_by = hz_utility_pub.user_id,

90: THEN
91: update JTF_FM_PREVIEWS
92: set fm_party_id = p_to_fk_id,
93: last_update_date = hz_utility_pub.last_update_date,
94: last_updated_by = hz_utility_pub.user_id,
95: last_update_login = hz_utility_pub.last_update_login
96: where fm_party_id = p_from_fk_id;
97:
98: ELSIF (upper(p_entity_name) = 'JTF_FM_PROCESSED_V')

Line 95: last_update_login = hz_utility_pub.last_update_login

91: update JTF_FM_PREVIEWS
92: set fm_party_id = p_to_fk_id,
93: last_update_date = hz_utility_pub.last_update_date,
94: last_updated_by = hz_utility_pub.user_id,
95: last_update_login = hz_utility_pub.last_update_login
96: where fm_party_id = p_from_fk_id;
97:
98: ELSIF (upper(p_entity_name) = 'JTF_FM_PROCESSED_V')
99: THEN

Line 103: last_update_date = hz_utility_pub.last_update_date,

99: THEN
100: update JTF_FM_PROCESSED
101: set party_id = p_to_fk_id,
102: party_name = l_party_name,
103: last_update_date = hz_utility_pub.last_update_date,
104: last_updated_by = hz_utility_pub.user_id,
105: last_update_login = hz_utility_pub.last_update_login
106: where party_id = p_from_fk_id;
107: ELSE

Line 104: last_updated_by = hz_utility_pub.user_id,

100: update JTF_FM_PROCESSED
101: set party_id = p_to_fk_id,
102: party_name = l_party_name,
103: last_update_date = hz_utility_pub.last_update_date,
104: last_updated_by = hz_utility_pub.user_id,
105: last_update_login = hz_utility_pub.last_update_login
106: where party_id = p_from_fk_id;
107: ELSE
108: update JTF_FM_CONTENT_HISTORY

Line 105: last_update_login = hz_utility_pub.last_update_login

101: set party_id = p_to_fk_id,
102: party_name = l_party_name,
103: last_update_date = hz_utility_pub.last_update_date,
104: last_updated_by = hz_utility_pub.user_id,
105: last_update_login = hz_utility_pub.last_update_login
106: where party_id = p_from_fk_id;
107: ELSE
108: update JTF_FM_CONTENT_HISTORY
109: set party_id = p_to_fk_id,

Line 111: last_update_date = hz_utility_pub.last_update_date,

107: ELSE
108: update JTF_FM_CONTENT_HISTORY
109: set party_id = p_to_fk_id,
110: party_name = l_party_name,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login
114: where party_id = p_from_fk_id;
115: END IF;

Line 112: last_updated_by = hz_utility_pub.user_id,

108: update JTF_FM_CONTENT_HISTORY
109: set party_id = p_to_fk_id,
110: party_name = l_party_name,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login
114: where party_id = p_from_fk_id;
115: END IF;
116:

Line 113: last_update_login = hz_utility_pub.last_update_login

109: set party_id = p_to_fk_id,
110: party_name = l_party_name,
111: last_update_date = hz_utility_pub.last_update_date,
112: last_updated_by = hz_utility_pub.user_id,
113: last_update_login = hz_utility_pub.last_update_login
114: where party_id = p_from_fk_id;
115: END IF;
116:
117: l_count := sql%rowcount;