[Home] [Help]
PACKAGE: APPS.IEX_CUST_OVERVIEW_PVT
Source
1 PACKAGE IEX_CUST_OVERVIEW_PVT AS
2 /* $Header: iexvcuos.pls 120.5 2005/02/09 19:35:38 jypark ship $ */
3
4 TYPE Customer_Info_Rec_Type IS RECORD
5 (
6 PARTY_ID NUMBER,
7 IDENTIFICATION_ID VARCHAR2(100),
8 CUSTOMER_SINCE DATE,
9 COLLECTIONS_SCORE VARCHAR2(100),
10 NUMBER_OF_INVOICES NUMBER,
11 NUMBER_OF_DELINQUENCIES NUMBER,
12 INVOICES_OVERDUE NUMBER,
13 STATUS VARCHAR2(80), -- fix bug #2165553 added by jypark 02/18/2002
14 CASES_OVERDUE NUMBER,
15 NUMBER_OF_DEL_CASES NUMBER,
16 NUMBER_OF_OKL_INV NUMBER
17 );
18
19 TYPE Customer_OKL_Info_Rec_Type IS RECORD
20 (
21 CASES_OVERDUE NUMBER,
22 NUMBER_OF_DEL_CASES NUMBER,
23 NUMBER_OF_OKL_INV NUMBER
24 );
25
26 TYPE Object_Info_Rec_Type IS RECORD
27 (
28 OBJECT_ID NUMBER,
29 OBJECT_TYPE VARCHAR2(100),
30 OBJECT_NUMBER VARCHAR2(100),
31 AMOUNT_OVERDUE NUMBER,
32 AMOUNT_OVERDUE_CURR VARCHAR2(15),
33 CURRENT_BALANCE NUMBER,
34 CURRENT_BALANCE_CURR VARCHAR2(100),
35 DSO NUMBER,
36 LAST_PAYMENT_DATE DATE,
37 LAST_PAYMENT_DUE_DATE DATE,
38 LAST_PAYMENT_AMOUNT NUMBER,
39 LAST_PAYMENT_CURR VARCHAR2(100),
40 LAST_PAYMENT_STATUS VARCHAR2(80),
41 LAST_PAYMENT_RECEIPT_NUMBER VARCHAR2(30),
42 LAST_PAYMENT_ID NUMBER,
43 LAST_OKL_PAYMENT_DATE DATE,
44 LAST_OKL_PAYMENT_DUE_DATE DATE,
45 LAST_OKL_PAYMENT_AMOUNT NUMBER,
46 LAST_OKL_PAYMENT_CURR VARCHAR2(100),
47 LAST_OKL_PAYMENT_STATUS VARCHAR2(80),
48 LAST_OKL_PAYMENT_RECEIPT_NUM VARCHAR2(30),
49 LAST_OKL_PAYMENT_ID NUMBER
50 );
51
52 TYPE Last_Pmt_Info_Rec_Type IS RECORD
53 (
54 CASH_RECEIPT_ID NUMBER,
55 AMOUNT NUMBER,
56 RECEIPT_DATE DATE,
57 RECEIPT_NUMBER VARCHAR2(30),
58 DUE_DATE DATE,
59 STATUS VARCHAR2(80),
60 CURRENCY_CODE VARCHAR2(3)
61 );
62
63 TYPE Last_OKL_Pmt_Info_Rec_Type IS RECORD
64 (
65 APPLY_DATE DATE,
66 RECEIVABLE_APPLICATION_ID NUMBER,
67 DUE_DATE DATE,
68 CASH_RECEIPT_ID NUMBER,
69 RECEIPT_NUMBER VARCHAR2(30),
70 AMOUNT_APPLIED NUMBER,
71 CURRENCY_CODE VARCHAR2(3),
72 RECEIPT_STATUS VARCHAR2(80)
73 );
74
75 TYPE Contact_Point_Info_Rec_Type IS RECORD
76 (
77 PHONE_CONTACT_POINT_ID NUMBER,
78 PHONE_COUNTRY_CODE VARCHAR2(10),
79 PHONE_AREA_CODE VARCHAR2(10),
80 PHONE_NUMBER VARCHAR2(40),
81 PHONE_EXTENSION VARCHAR2(20),
82 PHONE_LINE_TYPE VARCHAR2(80),
83 PHONE_LINE_TYPE_MEANING VARCHAR2(80),
84 EMAIL_CONTACT_POINT_ID NUMBER,
85 EMAIL_ADDRESS VARCHAR2(2000)
86 );
87
88 TYPE Location_Info_Rec_Type IS RECORD
89 (
90 location_id NUMBER,
91 address2 VARCHAR2(240),
92 address3 VARCHAR2(240),
93 address4 VARCHAR2(240),
94 party_id NUMBER,
95 address_lines_phonetic VARCHAR2(560),
96 po_box_number VARCHAR2(50),
97 house_number VARCHAR2(50),
98 street_suffix VARCHAR2(50),
99 street VARCHAR2(50),
100 street_number VARCHAR2(50),
101 floor VARCHAR2(50),
102 suite VARCHAR2(50),
103 time_zone VARCHAR2(80),
104 time_zone_meaning VARCHAR2(80),
105 timezone_id NUMBER,
106 last_update_date DATE,
107 creation_date DATE,
108 created_by NUMBER,
109 last_updated_by NUMBER,
110 last_update_login NUMBER,
111 site_last_update_date DATE,
112 party_site_id NUMBER,
113 party_site_number VARCHAR2(30),
114 address1 VARCHAR2(240),
115 city VARCHAR2(60),
116 state VARCHAR2(60),
117 province VARCHAR2(60),
118 postal_code VARCHAR2(60),
119 county VARCHAR2(60),
120 country_name VARCHAR2(80),
121 country_code VARCHAR2(60),
122 object_version_number NUMBER,
123 site_object_version_number NUMBER,
124 created_by_module VARCHAR2(150),
125 application_id NUMBER);
126
127 PROCEDURE Get_Customer_Info
128 (p_api_version IN NUMBER := 1.0,
129 p_init_msg_list IN VARCHAR2,
130 p_commit IN VARCHAR2,
131 p_validation_level IN NUMBER,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_party_id IN NUMBER,
136 p_object_source IN VARCHAR2,
137 x_customer_info_rec OUT NOCOPY customer_info_rec_type);
138
139 PROCEDURE Get_Object_Info
140 (p_api_version IN NUMBER := 1.0,
141 p_init_msg_list IN VARCHAR2,
142 p_commit IN VARCHAR2,
143 p_validation_level IN NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_object_id IN NUMBER,
148 p_object_type IN VARCHAR2,
149 p_object_source IN VARCHAR2,
150 x_object_info_rec OUT NOCOPY object_info_rec_type);
151
152 PROCEDURE Get_Last_Payment_Info
153 (p_api_version IN NUMBER := 1.0,
154 p_init_msg_list IN VARCHAR2,
155 p_commit IN VARCHAR2,
156 p_validation_level IN NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_object_type IN VARCHAR2,
161 p_object_id IN NUMBER,
162 x_last_pmt_info_rec OUT NOCOPY last_pmt_info_rec_type);
163
164 PROCEDURE Get_Customer_OKL_Info
165 (p_api_version IN NUMBER := 1.0,
166 p_init_msg_list IN VARCHAR2,
167 p_commit IN VARCHAR2,
168 p_validation_level IN NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_party_id IN NUMBER,
173 x_customer_okl_info_rec OUT NOCOPY customer_okl_info_rec_type);
174
175 PROCEDURE Get_Last_OKL_Payment_Info
176 (p_api_version IN NUMBER := 1.0,
177 p_init_msg_list IN VARCHAR2,
178 p_commit IN VARCHAR2,
179 p_validation_level IN NUMBER,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_object_type IN VARCHAR2,
184 p_object_id IN NUMBER,
185 x_last_okl_pmt_info_rec OUT NOCOPY last_okl_pmt_info_rec_type);
186
187 PROCEDURE get_location_Info(
188 p_api_version IN NUMBER := 1.0,
189 p_init_msg_list IN VARCHAR2,
190 p_commit IN VARCHAR2,
191 p_validation_level IN NUMBER,
192 p_party_id IN NUMBER,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 x_location_info_rec OUT NOCOPY location_info_rec_type);
197
198 PROCEDURE get_contact_point_info(p_api_version IN NUMBER := 1.0,
199 p_init_msg_list IN VARCHAR2,
200 p_commit IN VARCHAR2,
201 p_validation_level IN NUMBER,
202 p_party_id IN NUMBER,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 x_contact_point_info_rec OUT NOCOPY contact_point_info_rec_type);
207
208 PROCEDURE Get_header_info
209 (p_api_version IN NUMBER := 1.0,
210 p_init_msg_list IN VARCHAR2,
211 p_commit IN VARCHAR2,
212 p_validation_level IN NUMBER,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_party_type IN VARCHAR2,
217 p_rel_party_id IN NUMBER,
218 p_org_party_id IN NUMBER,
219 p_person_party_id IN NUMBER,
220 p_object_type IN VARCHAR2,
221 p_object_id IN NUMBER,
222 p_object_source IN VARCHAR2,
223 x_customer_info_rec OUT NOCOPY customer_info_rec_type,
224 x_object_info_rec OUT NOCOPY object_info_rec_type,
225 x_contact_point_info_rec OUT NOCOPY contact_point_info_rec_type,
226 x_location_info_rec OUT NOCOPY location_info_rec_type);
227
228 PROCEDURE Create_Default_Contact
229 (p_api_version IN NUMBER := 1.0,
230 p_init_msg_list IN VARCHAR2,
231 p_commit IN VARCHAR2,
232 p_validation_level IN NUMBER,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_org_party_id IN NUMBER,
237 p_person_party_id IN NUMBER,
238 p_phone_contact_point_id IN NUMBER,
239 p_email_contact_point_id IN NUMBER,
240 p_type IN VARCHAR2,
241 p_location_id IN NUMBER,
242 x_relationship_id OUT NOCOPY NUMBER,
243 x_party_id OUT NOCOPY NUMBER);
244
245
246 END;