DBA Data[Home] [Help]

APPS.PA_AP_INTEGRATION dependencies on PA_BC_PACKETS

Line 95: --R12 need to update vendor ID on pa_bc_packets

91: And system_reference3 is not null;
92:
93: End If;
94:
95: --R12 need to update vendor ID on pa_bc_packets
96: x_stage := 'Updating Pa_Bc_Packets Table';
97: Update pa_bc_packets
98: set Vendor_Id = p_new_vendor_id
99: Where Vendor_Id = p_old_vendor_id

Line 96: x_stage := 'Updating Pa_Bc_Packets Table';

92:
93: End If;
94:
95: --R12 need to update vendor ID on pa_bc_packets
96: x_stage := 'Updating Pa_Bc_Packets Table';
97: Update pa_bc_packets
98: set Vendor_Id = p_new_vendor_id
99: Where Vendor_Id = p_old_vendor_id
100: And Status_Code = 'A';

Line 97: Update pa_bc_packets

93: End If;
94:
95: --R12 need to update vendor ID on pa_bc_packets
96: x_stage := 'Updating Pa_Bc_Packets Table';
97: Update pa_bc_packets
98: set Vendor_Id = p_new_vendor_id
99: Where Vendor_Id = p_old_vendor_id
100: And Status_Code = 'A';
101: