1 package IBE_PARTY_V2PVT as
2 /* $Header: IBEVPARS.pls 120.1 2005/06/20 09:25:26 appldev ship $ */
3
4
5
6
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,
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,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2);
22
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,
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,
40 x_user_id OUT NOCOPY NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
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,
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,
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,
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,
71 x_return_status OUT NOCOPY VARCHAR2,
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,
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,
84 p_billto IN VARCHAR2 := FND_API.G_FALSE,
85 p_shipto IN VARCHAR2 := FND_API.G_FALSE,
86 p_default_primary IN VARCHAR2 := FND_API.G_FALSE,
87 p_created_by_module IN VARCHAR2,
88 p_account IN VARCHAR2 := FND_API.G_FALSE,
89 x_org_party_id OUT NOCOPY NUMBER,
90 x_account_id OUT NOCOPY NUMBER,
91 x_party_site_id OUT NOCOPY NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2);
95
96 PROCEDURE Update_Contact_Preference(
97 p_party_id IN NUMBER,
98 p_preference IN VARCHAR2,
99 p_object_version_number IN NUMBER,
100 p_created_by_module IN VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104
105 );
106
107 PROCEDURE Update_Person_Language(
108 p_party_id IN NUMBER,
109 p_language_name IN VARCHAR2,
110 p_created_by_module IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116 Procedure Create_Account(
117 p_party_id IN NUMBER, -- person_party_id or org_party_id
118 p_party_type IN VARCHAR2,
119 p_created_by_module IN VARCHAR2,
120 x_account_id OUT NOCOPY NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
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
132 p_created_by_module IN VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2);
136
137 Procedure Update_Party_Status(
138 p_party_id IN NUMBER,
139 p_party_status IN VARCHAR2,
140 p_change_org_status IN VARCHAR2 := FND_API.G_FALSE,
141 p_commit IN VARCHAR2 := FND_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2);
145
146 Function Find_Organization(
147 x_org_id IN OUT NOCOPY NUMBER, -- org_party_id
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,
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,
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,
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,
181 x_rel_party_id OUT NOCOPY NUMBER,
182 x_org_party_id OUT NOCOPY NUMBER,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2);
186
187
188 /*procedure gen_acct_num(
189 x_acct_num OUT VARCHAR2
190 );
191 */
192
193 end ibe_party_v2pvt;