98: SET vendor_id = p_vendor_id,
99:
100: vendor_site_id = p_vendor_site_id,
101:
102: last_update_date = hz_utility_pub.last_update_date,
103:
104: last_updated_by = hz_utility_pub.user_id,
105:
106: last_update_login = hz_utility_pub.last_update_login,
100: vendor_site_id = p_vendor_site_id,
101:
102: last_update_date = hz_utility_pub.last_update_date,
103:
104: last_updated_by = hz_utility_pub.user_id,
105:
106: last_update_login = hz_utility_pub.last_update_login,
107:
108: program_application_id = hz_utility_pub.program_application_id,
102: last_update_date = hz_utility_pub.last_update_date,
103:
104: last_updated_by = hz_utility_pub.user_id,
105:
106: last_update_login = hz_utility_pub.last_update_login,
107:
108: program_application_id = hz_utility_pub.program_application_id,
109:
110: program_id = hz_utility_pub.program_id,
104: last_updated_by = hz_utility_pub.user_id,
105:
106: last_update_login = hz_utility_pub.last_update_login,
107:
108: program_application_id = hz_utility_pub.program_application_id,
109:
110: program_id = hz_utility_pub.program_id,
111:
112: program_update_date = sysdate
106: last_update_login = hz_utility_pub.last_update_login,
107:
108: program_application_id = hz_utility_pub.program_application_id,
109:
110: program_id = hz_utility_pub.program_id,
111:
112: program_update_date = sysdate
113:
114: WHERE vendor_id = p_dup_vendor_id
158: SET vendor_id = p_vendor_id,
159:
160: vendor_site_id = p_vendor_site_id,
161:
162: last_update_date = hz_utility_pub.last_update_date,
163:
164: last_updated_by = hz_utility_pub.user_id,
165:
166: last_update_login = hz_utility_pub.last_update_login
160: vendor_site_id = p_vendor_site_id,
161:
162: last_update_date = hz_utility_pub.last_update_date,
163:
164: last_updated_by = hz_utility_pub.user_id,
165:
166: last_update_login = hz_utility_pub.last_update_login
167:
168: WHERE vendor_id = p_dup_vendor_id
162: last_update_date = hz_utility_pub.last_update_date,
163:
164: last_updated_by = hz_utility_pub.user_id,
165:
166: last_update_login = hz_utility_pub.last_update_login
167:
168: WHERE vendor_id = p_dup_vendor_id
169:
170: AND vendor_site_id = p_dup_vendor_site_id;
212: SET vendor_id = p_vendor_id,
213:
214: vendor_site_id = p_vendor_site_id,
215:
216: last_update_date = hz_utility_pub.last_update_date,
217:
218: last_updated_by = hz_utility_pub.user_id,
219:
220: last_update_login = hz_utility_pub.last_update_login,
214: vendor_site_id = p_vendor_site_id,
215:
216: last_update_date = hz_utility_pub.last_update_date,
217:
218: last_updated_by = hz_utility_pub.user_id,
219:
220: last_update_login = hz_utility_pub.last_update_login,
221:
222: program_application_id = hz_utility_pub.program_application_id,
216: last_update_date = hz_utility_pub.last_update_date,
217:
218: last_updated_by = hz_utility_pub.user_id,
219:
220: last_update_login = hz_utility_pub.last_update_login,
221:
222: program_application_id = hz_utility_pub.program_application_id,
223:
224: program_id = hz_utility_pub.program_id,
218: last_updated_by = hz_utility_pub.user_id,
219:
220: last_update_login = hz_utility_pub.last_update_login,
221:
222: program_application_id = hz_utility_pub.program_application_id,
223:
224: program_id = hz_utility_pub.program_id,
225:
226: program_update_date = sysdate
220: last_update_login = hz_utility_pub.last_update_login,
221:
222: program_application_id = hz_utility_pub.program_application_id,
223:
224: program_id = hz_utility_pub.program_id,
225:
226: program_update_date = sysdate
227:
228: WHERE vendor_id = p_dup_vendor_id