84: and p_vendor_id is not null Then
85:
86: SAVEPOINT jl_vendor_merge;
87:
88: -- Update JL_ZZ_AP_SUPP_AWT_TYPES - vendor_id
89: Update JL_ZZ_AP_SUPP_AWT_TYPES
90: set vendor_id = p_vendor_id
91: where vendor_id = p_dup_vendor_id;
92:
85:
86: SAVEPOINT jl_vendor_merge;
87:
88: -- Update JL_ZZ_AP_SUPP_AWT_TYPES - vendor_id
89: Update JL_ZZ_AP_SUPP_AWT_TYPES
90: set vendor_id = p_vendor_id
91: where vendor_id = p_dup_vendor_id;
92:
93: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id