133:
134: UPDATE pos_acct_addr_rel
135: SET vendor_id = p_new_vendor_id,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.user_id,
138: last_update_login = FND_GLOBAL.login_id
139: WHERE vendor_id = p_old_vendor_id;
140:
141:
134: UPDATE pos_acct_addr_rel
135: SET vendor_id = p_new_vendor_id,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.user_id,
138: last_update_login = FND_GLOBAL.login_id
139: WHERE vendor_id = p_old_vendor_id;
140:
141:
142: UPDATE pos_supplier_mappings
141:
142: UPDATE pos_supplier_mappings
143: SET vendor_id = p_new_vendor_id,
144: last_update_date = SYSDATE,
145: last_updated_by = FND_GLOBAL.user_id,
146: last_update_login = FND_GLOBAL.login_id
147: WHERE vendor_id = p_old_vendor_id;
148:
149: UPDATE pos_supplier_registrations
142: UPDATE pos_supplier_mappings
143: SET vendor_id = p_new_vendor_id,
144: last_update_date = SYSDATE,
145: last_updated_by = FND_GLOBAL.user_id,
146: last_update_login = FND_GLOBAL.login_id
147: WHERE vendor_id = p_old_vendor_id;
148:
149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,
148:
149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,
151: last_update_date = SYSDATE,
152: last_updated_by = FND_GLOBAL.user_id,
153: last_update_login = FND_GLOBAL.login_id
154: WHERE po_vendor_id = p_old_vendor_id;
155:
156: UPDATE pos_sup_bank_account_requests
149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,
151: last_update_date = SYSDATE,
152: last_updated_by = FND_GLOBAL.user_id,
153: last_update_login = FND_GLOBAL.login_id
154: WHERE po_vendor_id = p_old_vendor_id;
155:
156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,
155:
156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,
158: last_update_date = SYSDATE,
159: last_updated_by = FND_GLOBAL.user_id,
160: last_update_login = FND_GLOBAL.login_id
161: WHERE vendor_id = p_old_vendor_id;
162: */
163:
156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,
158: last_update_date = SYSDATE,
159: last_updated_by = FND_GLOBAL.user_id,
160: last_update_login = FND_GLOBAL.login_id
161: WHERE vendor_id = p_old_vendor_id;
162: */
163:
164: -- If it is the last site then merge supplier profile info
195: -- transfer classifications of the merged-from vendor to the merged-to vendor
196: UPDATE pos_sup_products_services
197: SET vendor_id = p_new_vendor_id,
198: last_update_date = SYSDATE,
199: last_updated_by = FND_GLOBAL.user_id,
200: last_update_login = FND_GLOBAL.login_id
201: WHERE vendor_id = p_old_vendor_id;
202: END IF;
203:
196: UPDATE pos_sup_products_services
197: SET vendor_id = p_new_vendor_id,
198: last_update_date = SYSDATE,
199: last_updated_by = FND_GLOBAL.user_id,
200: last_update_login = FND_GLOBAL.login_id
201: WHERE vendor_id = p_old_vendor_id;
202: END IF;
203:
204: ELSE