8: Procedure Create_Individual_User(
9: p_username IN VARCHAR2,
10: p_password IN VARCHAR2,
11: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
12: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
13: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
14: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
15: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
16: p_contact_preference IN VARCHAR2,
9: p_username IN VARCHAR2,
10: p_password IN VARCHAR2,
11: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
12: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
13: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
14: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
15: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
16: p_contact_preference IN VARCHAR2,
17: x_person_party_id OUT NOCOPY NUMBER,
10: p_password IN VARCHAR2,
11: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
12: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
13: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
14: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
15: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
16: p_contact_preference IN VARCHAR2,
17: x_person_party_id OUT NOCOPY NUMBER,
18: x_user_id OUT NOCOPY NUMBER,
11: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
12: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
13: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
14: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
15: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
16: p_contact_preference IN VARCHAR2,
17: x_person_party_id OUT NOCOPY NUMBER,
18: x_user_id OUT NOCOPY NUMBER,
19: x_return_status OUT NOCOPY VARCHAR2,
26: p_password IN VARCHAR2,
27: p_person_rec IN HZ_PARTY_V2PUB.Person_Rec_type,
28: p_organization_rec IN HZ_PARTY_V2PUB.Organization_rec_type,
29: p_location_rec IN HZ_LOCATION_V2PUB.Location_rec_type,
30: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
27: p_person_rec IN HZ_PARTY_V2PUB.Person_Rec_type,
28: p_organization_rec IN HZ_PARTY_V2PUB.Organization_rec_type,
29: p_location_rec IN HZ_LOCATION_V2PUB.Location_rec_type,
30: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
35: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
28: p_organization_rec IN HZ_PARTY_V2PUB.Organization_rec_type,
29: p_location_rec IN HZ_LOCATION_V2PUB.Location_rec_type,
30: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
35: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
36: p_rel_contact_preference IN VARCHAR2,
29: p_location_rec IN HZ_LOCATION_V2PUB.Location_rec_type,
30: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
35: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
36: p_rel_contact_preference IN VARCHAR2,
37: x_person_party_id OUT NOCOPY NUMBER,
30: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
35: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
36: p_rel_contact_preference IN VARCHAR2,
37: x_person_party_id OUT NOCOPY NUMBER,
38: x_rel_party_id OUT NOCOPY NUMBER,
31: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
32: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
33: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
34: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
35: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
36: p_rel_contact_preference IN VARCHAR2,
37: x_person_party_id OUT NOCOPY NUMBER,
38: x_rel_party_id OUT NOCOPY NUMBER,
39: x_org_party_id OUT NOCOPY NUMBER,
46: Procedure Create_Org_Contact(
47: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
48: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
49: p_org_party_id IN NUMBER,
50: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
51: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
52: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
53: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
54: p_created_by_module IN VARCHAR2,
47: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
48: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
49: p_org_party_id IN NUMBER,
50: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
51: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
52: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
53: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
54: p_created_by_module IN VARCHAR2,
55: x_person_party_id OUT NOCOPY NUMBER,
48: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
49: p_org_party_id IN NUMBER,
50: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
51: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
52: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
53: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
54: p_created_by_module IN VARCHAR2,
55: x_person_party_id OUT NOCOPY NUMBER,
56: x_rel_party_id OUT NOCOPY NUMBER,
49: p_org_party_id IN NUMBER,
50: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
51: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
52: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
53: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
54: p_created_by_module IN VARCHAR2,
55: x_person_party_id OUT NOCOPY NUMBER,
56: x_rel_party_id OUT NOCOPY NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_data OUT NOCOPY VARCHAR2);
60:
61: Procedure Create_Person(
62: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
63: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
64: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
65: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
66: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
67: p_created_by_module IN VARCHAR2,
60:
61: Procedure Create_Person(
62: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
63: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
64: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
65: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
66: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
67: p_created_by_module IN VARCHAR2,
68: p_account IN VARCHAR2 := FND_API.G_FALSE,
61: Procedure Create_Person(
62: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
63: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
64: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
65: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
66: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
67: p_created_by_module IN VARCHAR2,
68: p_account IN VARCHAR2 := FND_API.G_FALSE,
69: x_person_party_id OUT NOCOPY NUMBER,
62: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
63: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
64: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
65: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
66: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
67: p_created_by_module IN VARCHAR2,
68: p_account IN VARCHAR2 := FND_API.G_FALSE,
69: x_person_party_id OUT NOCOPY NUMBER,
70: x_account_id OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2);
74:
75: Procedure Create_Organization(
76: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
77: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
78: /*p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,*/
79: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
80: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
81: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type,
74:
75: Procedure Create_Organization(
76: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
77: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
78: /*p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,*/
79: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
80: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
81: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type,
82: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
75: Procedure Create_Organization(
76: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
77: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
78: /*p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,*/
79: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
80: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
81: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type,
82: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
83: p_primary_shipto IN VARCHAR2 := FND_API.G_FALSE,
123: x_msg_data OUT NOCOPY VARCHAR2);
124:
125: Procedure Create_Contact_Points(
126: p_owner_table_id IN NUMBER,
127: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
128: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
129: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
130: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
131: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
124:
125: Procedure Create_Contact_Points(
126: p_owner_table_id IN NUMBER,
127: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
128: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
129: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
130: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
131: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
132: p_created_by_module IN VARCHAR2,
125: Procedure Create_Contact_Points(
126: p_owner_table_id IN NUMBER,
127: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
128: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
129: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
130: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
131: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
132: p_created_by_module IN VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2,
126: p_owner_table_id IN NUMBER,
127: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
128: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
129: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
130: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
131: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
132: p_created_by_module IN VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
150:
151: Procedure Save_Tca_Entities(
152: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
153: p_person_object_version_number IN NUMBER,
154: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
155: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
156: p_email_object_version_number IN NUMBER,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
151: Procedure Save_Tca_Entities(
152: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
153: p_person_object_version_number IN NUMBER,
154: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
155: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
156: p_email_object_version_number IN NUMBER,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
159: p_workph_object_version_number IN NUMBER,
153: p_person_object_version_number IN NUMBER,
154: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
155: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
156: p_email_object_version_number IN NUMBER,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
159: p_workph_object_version_number IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
154: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
155: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
156: p_email_object_version_number IN NUMBER,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
159: p_workph_object_version_number IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
162: p_homeph_object_version_number IN NUMBER,
156: p_email_object_version_number IN NUMBER,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
159: p_workph_object_version_number IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
162: p_homeph_object_version_number IN NUMBER,
163: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
164: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
157: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
158: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
159: p_workph_object_version_number IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
162: p_homeph_object_version_number IN NUMBER,
163: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
164: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
165: p_fax_object_version_number IN NUMBER,
159: p_workph_object_version_number IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
162: p_homeph_object_version_number IN NUMBER,
163: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
164: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
165: p_fax_object_version_number IN NUMBER,
166: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
167: p_cntct_pref_object_ver_num IN NUMBER,
160: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
161: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
162: p_homeph_object_version_number IN NUMBER,
163: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
164: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
165: p_fax_object_version_number IN NUMBER,
166: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
167: p_cntct_pref_object_ver_num IN NUMBER,
168: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
168: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
169: p_org_object_version_number IN NUMBER,
170: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
171: p_loc_object_version_number IN NUMBER,
172: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
173: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
174: p_orgph_object_version_number IN NUMBER,
175: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
176: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
169: p_org_object_version_number IN NUMBER,
170: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
171: p_loc_object_version_number IN NUMBER,
172: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
173: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
174: p_orgph_object_version_number IN NUMBER,
175: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
176: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
177: p_orgfax_object_version_number IN NUMBER,
171: p_loc_object_version_number IN NUMBER,
172: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
173: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
174: p_orgph_object_version_number IN NUMBER,
175: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
176: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
177: p_orgfax_object_version_number IN NUMBER,
178: p_create_party_rel IN VARCHAR2,
179: p_created_by_module IN VARCHAR2,
172: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
173: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
174: p_orgph_object_version_number IN NUMBER,
175: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
176: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
177: p_orgfax_object_version_number IN NUMBER,
178: p_create_party_rel IN VARCHAR2,
179: p_created_by_module IN VARCHAR2,
180: x_person_party_id OUT NOCOPY NUMBER,