157:
158: /* Set the status to MERGED */
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
158: /* Set the status to MERGED */
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
166:
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
166:
167: fnd_file.put_line(fnd_file.log, 'Rowcount: ' || SQL%ROWCOUNT);
580: /* Set the status to MERGED */
581: UPDATE pos_sup_products_services
582: SET status = 'M',
583: last_update_date = SYSDATE,
584: last_updated_by = hz_utility_pub.user_id,
585: last_update_login = hz_utility_pub.last_update_login
586: WHERE vendor_id = l_from_vendor_id
587: AND classification_id = p_from_id;
588:
581: UPDATE pos_sup_products_services
582: SET status = 'M',
583: last_update_date = SYSDATE,
584: last_updated_by = hz_utility_pub.user_id,
585: last_update_login = hz_utility_pub.last_update_login
586: WHERE vendor_id = l_from_vendor_id
587: AND classification_id = p_from_id;
588:
589: DELETE FROM pos_supplier_mappings a