[Home] [Help]
7:
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,
23:
24: Procedure Create_Business_User(
25: p_username IN 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,
24: Procedure Create_Business_User(
25: p_username IN 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,
43: x_msg_data OUT NOCOPY VARCHAR2);
44:
45:
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,
58: x_msg_count OUT NOCOPY NUMBER,
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,
72: x_msg_count 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,
148: x_org_num IN OUT NOCOPY VARCHAR2,
149: x_org_name IN OUT NOCOPY VARCHAR2) return boolean;
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,
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,
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,