[Home] [Help]
41: -- We are not comparing the supplier name as this information
42: -- might not be reliable ( could have different spelling).
43: -- But the supplier number must be
44: -- reliable.
45: update fnd_registration_details
46: set field_value_string = l_new_vendor_name
47: , last_updated_by = 1, last_update_date = sysdate
48: where application_id = 177
49: and field_name = 'Supplier Name'
48: where application_id = 177
49: and field_name = 'Supplier Name'
50: and registration_id in
51: (select fr.registration_id from fnd_registrations fr,
52: fnd_registration_details frd
53: where registration_status IN ('INVITED', 'REGISTERED')
54: and frd.registration_id = fr.registration_id
55: and frd.field_name = 'Supplier Number'
56: and frd.field_value_number = p_dup_vendor_id
56: and frd.field_value_number = p_dup_vendor_id
57: and frd.application_id = 177
58: );
59:
60: update fnd_registration_details
61: set field_value_number = p_vendor_id
62: , last_update_date = sysdate, last_updated_by = 1
63: where field_value_number = p_dup_vendor_id
64: and application_id = 177
68: where registration_status IN ('INVITED', 'REGISTERED')
69: );
70: EXCEPTION
71: WHEN OTHERS THEN
72: x_exception_msg := 'POSVENDB.pls: Merging vendor data in Fnd_registration_details table:\n Error :'
73: ||x_exception_msg;
74: raise_application_error(-20001, x_exception_msg, true);
75: END merge_registration_details;
76: