155:
156:
157: End If; for bug 8845025*/
158:
159: --R12 need to update vendor ID on pa_bc_packets
160: x_stage := 'Updating Pa_Bc_Packets Table';
161: Update pa_bc_packets
162: set Vendor_Id = p_new_vendor_id
163: Where Vendor_Id = p_old_vendor_id
156:
157: End If; for bug 8845025*/
158:
159: --R12 need to update vendor ID on pa_bc_packets
160: x_stage := 'Updating Pa_Bc_Packets Table';
161: Update pa_bc_packets
162: set Vendor_Id = p_new_vendor_id
163: Where Vendor_Id = p_old_vendor_id
164: And Status_Code = 'A';
157: End If; for bug 8845025*/
158:
159: --R12 need to update vendor ID on pa_bc_packets
160: x_stage := 'Updating Pa_Bc_Packets Table';
161: Update pa_bc_packets
162: set Vendor_Id = p_new_vendor_id
163: Where Vendor_Id = p_old_vendor_id
164: And Status_Code = 'A';
165: