18: Procedure create_person(
19: p_api_version number,
20: p_user_name varchar2,
21: p_first_name varchar2,
22: p_middle_name varchar2 default FND_API.G_MISS_CHAR,
23: p_last_name varchar2,
24: p_title varchar2 default FND_API.G_MISS_CHAR,
25: p_content_source_type varchar2,
26: x_party_id OUT NOCOPY /* file.sql.39 change */ number,
20: p_user_name varchar2,
21: p_first_name varchar2,
22: p_middle_name varchar2 default FND_API.G_MISS_CHAR,
23: p_last_name varchar2,
24: p_title varchar2 default FND_API.G_MISS_CHAR,
25: p_content_source_type varchar2,
26: x_party_id OUT NOCOPY /* file.sql.39 change */ number,
27: x_party_number OUT NOCOPY /* file.sql.39 change */ number,
28: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
34: Procedure create_location (
35: p_api_version number,
36: p_user_name varchar2,
37: p_address1 varchar2,
38: p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
35: p_api_version number,
36: p_user_name varchar2,
37: p_address1 varchar2,
38: p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
36: p_user_name varchar2,
37: p_address1 varchar2,
38: p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44: p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
37: p_address1 varchar2,
38: p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44: p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
45: p_country varchar2,
38: p_address2 varchar2 DEFAULT FND_API.G_MISS_CHAR,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44: p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
45: p_country varchar2,
46: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
39: p_address3 varchar2 DEFAULT FND_API.G_MISS_CHAR,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44: p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
45: p_country varchar2,
46: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
47: x_location_id OUT NOCOPY /* file.sql.39 change */ number,
40: p_address4 varchar2 DEFAULT FND_API.G_MISS_CHAR,
41: p_city varchar2 DEFAULT FND_API.G_MISS_CHAR,
42: p_postal_code varchar2 DEFAULT FND_API.G_MISS_CHAR,
43: p_province varchar2 DEFAULT FND_API.G_MISS_CHAR,
44: p_state varchar2 DEFAULT FND_API.G_MISS_CHAR,
45: p_country varchar2,
46: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
47: x_location_id OUT NOCOPY /* file.sql.39 change */ number,
48: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,