22: o_addressid out nocopy hz_locations.location_id%type)
23: is
24:
25: p_api_version NUMBER := 1;
26: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
27: p_commit VARCHAR2(1) := fnd_api.G_FALSE;
28: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
29: --location_rec hz_location_pub.location_rec_type;
30: l_location_id number;
23: is
24:
25: p_api_version NUMBER := 1;
26: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
27: p_commit VARCHAR2(1) := fnd_api.G_FALSE;
28: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
29: --location_rec hz_location_pub.location_rec_type;
30: l_location_id number;
31: msg_txt varchar2(2000);
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)
119: is
120: p_api_version NUMBER := 1;
121: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
122: p_commit VARCHAR2(1) := fnd_api.G_FALSE;
123: -- location_rec hz_location_pub.location_rec_type;
124: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
125: l_ovn NUMBER;
118: i_postalcode hz_locations.postal_code%type)
119: is
120: p_api_version NUMBER := 1;
121: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
122: p_commit VARCHAR2(1) := fnd_api.G_FALSE;
123: -- location_rec hz_location_pub.location_rec_type;
124: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
125: l_ovn NUMBER;
126: l_location_id number;