EBS update Bank address

-- Add by biao.chen@hand-china.com -- 10:15:56 PROCEDURE done (p_party_id NUMBER, p_contry VARCHAR2, 1_varchar2, p_provice VARCHAR2, p_city VARCHAR2, timed OUT VARCHAR2, x_msg_count out number, x_msg_data OUT VARCHAR2) IS wrongly formed; l_location_rec limit; l_location_id NUMBER; Allocation NUMBER; l_party_site_number VARCHAR2 (30); l_object_version_number VARCHAR2 (60): = 1;/* x_return_status VARCHAR2 (200 ); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); */l_country VARCHAR2 (60); BEGIN l_location_rec.address1: = p_address_line_1; values ('country 0', p_contry, l_country, userenv ('lang '), p_provice, p_city); begin select v. territory_code INTO l_country FROM fnd_territories_vl v WHERE v. condition = p_contry; exception when others then condition ('country lookup error: '| SQLERRM); l_country: = 'cn'; END; l_location_rec.country: = l_country; l_location_rec.province: = p_provice; rows: = p_city; rows: = 'cust _ interface'; rows (p_location_rec => l_location_rec, x_location_id => l_location_id, x_return_status => x_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data); l_location_rec.location_id: = l_location_id; region: = p_party_id; region: = l_location_id; region: = 'y'; condition: = 'cust _ interface '; values (rows => rows, rows => rows, rows => l_party_site_number, x_return_status => x_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data); values: = rows; values: = l_party_site_number; exception when others then x_msg_data: = SQLERRM; END add_branch_address;