-- You are downloading this API from www.erpschools.com

 

PROCEDURE ERPSCHOOLS_Location (x_location_id OUT NUMBER)

 AS

--DECLARE

p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

--x_location_id NUMBER;

x_return_status VARCHAR2(2000);

x_msg_count NUMBER;

x_msg_data VARCHAR2(2000);

 

BEGIN p_location_rec.country := 'US';

p_location_rec.address1 := 'GaryVille';

p_location_rec.city := 'Gary City';

p_location_rec.postal_code := '12232';

p_location_rec.state := 'CA';

--p_location_rec.county:='County';

p_location_rec.created_by_module :='API_EXAMPLE';

hz_location_v2pub.create_location (

                                                        'T',

                                                        p_location_rec,

                                                        x_location_id,

                                                        x_return_status,

                                                        x_msg_count,

                                                        x_msg_data

                                                    );

 

dbms_output.put_line('x_location_id: '||x_location_id);

dbms_output.put_line('x_return_status: '||x_return_status);

dbms_output.put_line('x_msg_count: '||x_msg_count);

dbms_output.put_line('x_msg_data: '||x_msg_data);

END;