eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IEX_CUST_OVERVIEW_PVT

Source


1 PACKAGE IEX_CUST_OVERVIEW_PVT AUTHID CURRENT_USER 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;