APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on HZ_UTILITY_PUB

Line 185: -- last_update_date = hz_utility_pub.last_update_date,

181: --procedure
182: --UPDATE HZ_EMAIL_DOMAINS
183: --SET
184: -- STATUS = 'M',
185: -- last_update_date = hz_utility_pub.last_update_date,
186: -- last_updated_by = hz_utility_pub.user_id,
187: -- last_update_login = hz_utility_pub.last_update_login
188: --WHERE email_domain_id = p_from_id;
189: --ELSE

Line 186: -- last_updated_by = hz_utility_pub.user_id,

182: --UPDATE HZ_EMAIL_DOMAINS
183: --SET
184: -- STATUS = 'M',
185: -- last_update_date = hz_utility_pub.last_update_date,
186: -- last_updated_by = hz_utility_pub.user_id,
187: -- last_update_login = hz_utility_pub.last_update_login
188: --WHERE email_domain_id = p_from_id;
189: --ELSE
190: -- Update and set party_id = p_to_fk_id where pk = from_id

Line 187: -- last_update_login = hz_utility_pub.last_update_login

183: --SET
184: -- STATUS = 'M',
185: -- last_update_date = hz_utility_pub.last_update_date,
186: -- last_updated_by = hz_utility_pub.user_id,
187: -- last_update_login = hz_utility_pub.last_update_login
188: --WHERE email_domain_id = p_from_id;
189: --ELSE
190: -- Update and set party_id = p_to_fk_id where pk = from_id
191: UPDATE HZ_EMAIL_DOMAINS

Line 194: last_update_date = hz_utility_pub.last_update_date,

190: -- Update and set party_id = p_to_fk_id where pk = from_id
191: UPDATE HZ_EMAIL_DOMAINS
192: SET
193: party_id = p_to_fk_id,
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login
197: WHERE email_domain_id = p_from_id;
198:

Line 195: last_updated_by = hz_utility_pub.user_id,

191: UPDATE HZ_EMAIL_DOMAINS
192: SET
193: party_id = p_to_fk_id,
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login
197: WHERE email_domain_id = p_from_id;
198:
199: END IF;

Line 196: last_update_login = hz_utility_pub.last_update_login

192: SET
193: party_id = p_to_fk_id,
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,
196: last_update_login = hz_utility_pub.last_update_login
197: WHERE email_domain_id = p_from_id;
198:
199: END IF;
200: EXCEPTION

Line 540: last_update_date = hz_utility_pub.last_update_date,

536: ELSIF (l_dup_exists = FND_API.G_TRUE) THEN
537: UPDATE HZ_EMAIL_DOMAINS
538: SET
539: STATUS = 'M',
540: last_update_date = hz_utility_pub.last_update_date,
541: last_updated_by = hz_utility_pub.user_id,
542: last_update_login = hz_utility_pub.last_update_login
543: WHERE email_domain_id = p_from_id;
544: END IF;

Line 541: last_updated_by = hz_utility_pub.user_id,

537: UPDATE HZ_EMAIL_DOMAINS
538: SET
539: STATUS = 'M',
540: last_update_date = hz_utility_pub.last_update_date,
541: last_updated_by = hz_utility_pub.user_id,
542: last_update_login = hz_utility_pub.last_update_login
543: WHERE email_domain_id = p_from_id;
544: END IF;
545:

Line 542: last_update_login = hz_utility_pub.last_update_login

538: SET
539: STATUS = 'M',
540: last_update_date = hz_utility_pub.last_update_date,
541: last_updated_by = hz_utility_pub.user_id,
542: last_update_login = hz_utility_pub.last_update_login
543: WHERE email_domain_id = p_from_id;
544: END IF;
545:
546: x_to_id := l_to_id;