[Home] [Help]
PACKAGE: APPS.ASO_PARTY_INT
Source
1 PACKAGE ASO_PARTY_INT as
2 /* $Header: asoiptys.pls 120.2 2006/03/07 14:47:34 skulkarn ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PARTY_INT
5 -- Purpose :
6 -- This package contains specification of pl/sql records/tables and the
7 -- private APIs for validation in Order Capture.
8 --
9 -- Record Type:
10 -- Party_Rec_Type
11 -- Location_Rec_Type
12 -- Party_Site_Rec_Type
13 -- Org_Contact_Rec_Type
14 --
15 -- History :
16
17 -- NOTE :
18 -- Change History : Made by Suyog Kulkarni 10/15/2002
19 --Removed the following procedures as they are no longer being used:
20 --1) Create_Org_Contact
21 --2) Create_Contact_Points
22 --3)Create_Contact_Restriction
23 --4) Update_Party_Site
24 --5) update_Org_Contact
25 --6) Update_Contact_Points
26 --7) Update_Contact_Restriction
27 -- End of Comments
28
29
30 TYPE Party_Rec_Type IS RECORD
31 (
32 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
33 PARTY_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
35 CURR_FY_POTENTIAL_REVENUE NUMBER := FND_API.G_MISS_NUM,
36 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
37 PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38 PERSON_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
40 PERSON_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 PERSON_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
42 DATE_OF_BIRTH DATE := FND_API.G_MISS_DATE,
43 PERSONAL_INCOME NUMBER := FND_API.G_MISS_NUM,
44 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45 TOTAL_NUM_OF_ORDERS NUMBER := FND_API.G_MISS_NUM
46 );
47 G_Miss_Party_Rec Party_Rec_Type;
48
49
50 TYPE Location_Rec_Type IS RECORD
51 (
52 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
53 ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
54 ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
55 ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
56 ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
57 COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
59 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
60 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
61 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
62 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
63 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
65
66 );
67 G_MISS_Location_Rec Location_Rec_Type;
68
69
70 TYPE Party_Site_Rec_Type IS RECORD
71 (
72 party_site_use_id NUMBER := FND_API.G_MISS_NUM,
73 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
74 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
75 PARTY_SITE_USE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
76 PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
77 LOCATION Location_Rec_Type := G_MISS_Location_Rec,
78 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79 party_site_last_update_Date DATE := FND_API.G_MISS_DATE
80
81 );
82 G_MISS_Party_Site_Rec Party_Site_Rec_Type;
83
84 TYPE Org_Contact_Rec_Type IS RECORD
85 (
86 CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
87 CONTACT_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
88 CONTACT_FIRST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 CONTACT_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
90 CONTACT_LAST_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 CONTACT_KNOWN_AS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92 CONTACT_ROLE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
93 job_title VARCHAR2(100) :=FND_API.G_MISS_CHAR,
94 job_title_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
95 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
96 SUBJECT_ID NUMBER := FND_API.G_MISS_NUM,
97 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
98 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
99 rel_last_update_Date date := FND_API.G_MISS_DATE,
100 org_cont_last_update_Date DATE := FND_API.G_MISS_DATE
101
102 );
103
104 TYPE Contact_Point_Rec_Type IS RECORD
105 (
106 contact_point_id NUMBER := FND_API.G_MISS_NUM,
107 telephone_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108 contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 status VARCHAR2(10) := FND_API.G_MISS_CHAR,
110 owner_table_name VARCHAR2(200):= FND_API.G_MISS_CHAR,
111 owner_table_id NUMBER := FND_API.G_MISS_NUM,
112 email_format VARCHAR2(30) := FND_API.G_MISS_CHAR,
113 email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
114 phone_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
115 phone_country_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
116 phone_number VARCHAR2(40) := FND_API.G_MISS_CHAR,
117 phone_extension VARCHAR2(20) := FND_API.G_MISS_CHAR,
118 phone_line_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
119 telex_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
120 url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
121 primary_flag VARCHAR2(10) := FND_API.G_MISS_CHAR,
122 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
123
124 );
125
126 TYPE Out_Contact_Point_Rec_Type IS RECORD
127 (
128 Contact_Point_Type VARCHAR2(30),
129 Contact_Point_Id NUMBER,
130 x_return_status VARCHAR2(1)
131 );
132 TYPE Out_Contact_Point_Tbl_Type IS TABLE OF Out_Contact_Point_Rec_Type
133 INDEX BY BINARY_INTEGER;
134
135 TYPE Contact_Restrictions_Rec_Type IS RECORD
136 (
137 Party_Id NUMBER,
138 Contact_Restriction_Id NUMBER,
139 Restriction_End_Date DATE,
140 Contact_Type VARCHAR2(30),
141 Subject_Table VARCHAR2(30),
142 Subject_ID NUMBER,
143 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
144
145 );
146
147 PROCEDURE Create_Party(
148 p_party_rec IN PARTY_REC_TYPE,
149 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
150 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
151 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
152 x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER);
153
154
155 PROCEDURE Create_Party_Site(
156 p_party_site_rec IN PARTY_SITE_REC_TYPE,
157 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
158 x_party_site_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
159 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
160 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
161
162 PROCEDURE Update_Party(
163 p_party_rec IN PARTY_REC_TYPE,
164 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
165 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
166 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
167
168
169 PROCEDURE Validate_CustAccount(
170 p_init_msg_list IN VARCHAR2,
171 p_party_id IN NUMBER,
172 p_cust_account_id IN NUMBER,
173 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
174 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
175 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
176
177 -- creates a customer account in hz_cust_accounts_all using a party id.
178 -- also uses the marketing source code id if passed.
179
180 PROCEDURE Create_Customer_Account(
181 p_api_version IN NUMBER
182 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
183 ,p_commit IN VARCHAR2 := FND_API.g_false
184 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
185 ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
186 ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
187 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
189 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190 ,x_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER
191 );
192
193
194 -- creates an account site
195 PROCEDURE Create_ACCT_SITE (
196 p_api_version IN NUMBER
197 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
198 ,p_commit IN VARCHAR2 := FND_API.g_false
199 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
200 ,p_Cust_Account_Id NUMBER
201 ,p_Party_Site_Id NUMBER
202 ,p_Acct_site VARCHAR2 := 'NONE'
203 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
204 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
205 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
206 ,x_customer_site_id OUT NOCOPY /* file.sql.39 change */ NUMBER
207 );
208
209
210 PROCEDURE Create_ACCT_SITE_USES (
211 p_api_version IN NUMBER
212 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
213 ,p_commit IN VARCHAR2 := FND_API.g_false
214 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
215 ,P_Cust_Account_Id IN NUMBER
216 ,P_Party_Site_Id IN NUMBER
217 ,P_cust_acct_site_id IN NUMBER := NULL
218 ,P_Acct_Site_type IN VARCHAR2 := 'NONE'
219 ,x_cust_acct_site_id OUT NOCOPY /* file.sql.39 change */ NUMBER
220 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
221 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
222 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
223 ,x_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER
224 );
225
226
227 PROCEDURE Create_Contact (
228 p_api_version IN NUMBER
229 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
230 ,p_commit IN VARCHAR2 := FND_API.g_false
231 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
232 ,p_party_id IN NUMBER := NULL -- this is the party id of the corresponding org contact
233 ,p_Org_Contact_Id IN NUMBER
234 ,p_Cust_account_id IN NUMBER
235 ,p_Role_type IN VARCHAR2 := 'CONTACT'
236 ,p_Begin_date IN DATE := sysdate
237 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
239 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
240 ,x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ NUMBER
241 );
242
243 PROCEDURE Create_ORG_CONTACT_ord (
244 p_api_version IN NUMBER
245 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
246 ,p_commit IN VARCHAR2 := FND_API.g_false
247 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
248 ,p_party_id NUMBER
249 ,p_header_Party_Id NUMBER := NULL
250 ,p_acct_id NUMBER := NULL
251 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
252 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
253 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254 ,x_org_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
255 ,x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER
256 ) ;
257 PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
258 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
259 ,p_commit IN VARCHAR2 := FND_API.g_false
260 ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
261 ,p_Cust_account_id IN NUMBER
262 ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
263 ,p_Role_type IN VARCHAR2 := 'CONTACT'
264 ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
265 ,p_Begin_date IN DATE := sysdate
266 ,p_role_id IN NUMBER := FND_API.G_MISS_NUM
267 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
269 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
270 ,x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ NUMBER
271 );
272
273 Procedure GET_ACCT_SITE_USES(
274 p_api_version IN NUMBER
275 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276 ,p_commit IN VARCHAR2 := FND_API.g_false
277 -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278 ,P_Cust_Account_Id IN NUMBER
279 ,P_Party_Site_Id IN NUMBER
280 ,P_Acct_Site_type IN VARCHAR2 := 'NONE'
281 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
283 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284 ,x_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER
285 );
286
287
288 PROCEDURE Create_Cust_Acct_Relationship(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291 p_commit IN VARCHAR2 := FND_API.g_false,
292 p_sold_to_cust_account IN NUMBER,
293 p_related_cust_account IN NUMBER,
294 p_relationship_type IN VARCHAR2,
295 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
296 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
297 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
298
299
300 PROCEDURE Create_Customer_Account(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303 p_commit IN VARCHAR2 := FND_API.g_false,
304 P_Party_id IN NUMBER,
305 P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
306 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
307 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
308 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
309 x_cust_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER);
310
311
312 PROCEDURE Create_Party_Site_Use(
313 p_api_version IN NUMBER,
314 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
315 p_commit IN VARCHAR2 := FND_API.g_false,
316 p_party_site_id IN NUMBER,
317 p_party_site_use_type IN VARCHAR2,
318 x_party_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
319 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
320 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
321 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
322
323 End ASO_PARTY_INT;