[Home] [Help]
PACKAGE: APPS.IEX_CNSLD_DELINQUENCY_PUB
Source
1 PACKAGE IEX_CNSLD_DELINQUENCY_PUB AS
2 /* $Header: iexpcods.pls 120.0 2004/01/24 03:19:12 appldev noship $ */
3
4 TYPE customer_delinquency_rec_type IS RECORD (
5 --
6 -- UWQ Data
7 --
8 IEU_OBJECT_FUNCTION VARCHAR2(30),
9 IEU_OBJECT_PARAMETERS VARCHAR2(2000),
10 IEU_MEDIA_TYPE_UUID VARCHAR2(200),
11 IEU_PARAM_PK_COL VARCHAR2(200),
12 IEU_PARAM_PK_VALUE VARCHAR2(40),
13 RESOURCE_ID NUMBER,
14 RESOURCE_TYPE VARCHAR2(200),
15 --
16 -- Standard Data
17 --
18 CU_DELINQUENCY_ID NUMBER,
19 CREATION_DATE DATE,
20 CREATED_BY NUMBER(15),
21 LAST_UPDATE_DATE DATE,
22 LAST_UPDATED_BY NUMBER(15),
23 LAST_UPDATE_LOGIN NUMBER(15),
24 ORG_ID NUMBER,
25 --
26 -- Main Data
27 --
28 CUST_ACCOUNT_ID NUMBER(15),
29 ACCOUNT_NUMBER VARCHAR2(30),
30 ACCOUNT_NAME VARCHAR2(240),
31 CUSTOMER_NAME VARCHAR2(360),
32 CUSTOMER_PARTY_ID NUMBER,
33 CUSTOMER_PARTY_NUMBER VARCHAR2(30),
34 NUMBER_OF_DELINQUENCIES NUMBER,
35 NET_BALANCE NUMBER,
36 COLLECTABLE_AMOUNT NUMBER,
37 DUE_DATE DATE,
38 COLLECTIONS_STATUS VARCHAR2(30),
39 COLLECTIONS_STATUS_MEANING VARCHAR2(80),
40 CONTACT_NAME VARCHAR2(360),
41 CONTACT_PHONE_NUMBER VARCHAR2(1000),
42 CUSTOMER_ADDRESS1 VARCHAR2(240),
43 CUSTOMER_STATE VARCHAR2(50),
44 CUSTOMER_CITY VARCHAR2(50),
45 CUSTOMER_COUNTY VARCHAR2(50),
46 CUSTOMER_POSTAL_CODE VARCHAR2(50),
47 CUSTOMER_COUNTRY VARCHAR2(50),
48 NUMBER_OF_ACCOUNTS NUMBER,
49 STRATEGY_ID NUMBER(15),
50 STRATEGY_NAME VARCHAR2(1000),
51 WORK_ITEM_ID NUMBER(15),
52 WORK_ITEM_NAME VARCHAR2(1000),
53 ASSIGNED_COLLECTOR_ID NUMBER,
54 ASSIGNED_COLLECTOR_NAME VARCHAR2(250),
55 CURRENCY VARCHAR2(3),
56 AGING_BUCKET_NAME VARCHAR2(20),
57 UNAPPLIED_CM_AMOUNT NUMBER,
58 UNAPPLIED_PAYMENT_AMOUNT NUMBER,
59 TOTAL_DISPUTE_AMOUNT NUMBER);
60
61 TYPE account_delinquency_rec_type IS RECORD (
62 --
63 -- UWQ Data
64 --
65 IEU_OBJECT_FUNCTION VARCHAR2(30),
66 IEU_OBJECT_PARAMETERS VARCHAR2(2000),
67 IEU_MEDIA_TYPE_UUID VARCHAR2(200),
68 IEU_PARAM_PK_COL VARCHAR2(200),
69 IEU_PARAM_PK_VALUE VARCHAR2(40),
70 RESOURCE_ID NUMBER,
71 RESOURCE_TYPE VARCHAR2(200),
72 --
73 -- Standard Data
74 --
75 ACC_DELINQUENCY_ID NUMBER,
76 CREATION_DATE DATE,
77 CREATED_BY NUMBER(15),
78 LAST_UPDATE_DATE DATE,
79 LAST_UPDATED_BY NUMBER(15),
80 LAST_UPDATE_LOGIN NUMBER(15),
81 ORG_ID NUMBER,
82 --
83 -- Main Data
84 --
85 CUST_ACCOUNT_ID NUMBER(15),
86 ACCOUNT_NUMBER VARCHAR2(30),
87 ACCOUNT_NAME VARCHAR2(240),
88 CUSTOMER_NAME VARCHAR2(360),
89 CUSTOMER_PARTY_ID NUMBER,
90 CUSTOMER_PARTY_NUMBER VARCHAR2(30),
91 NUMBER_OF_DELINQUENCIES NUMBER,
92 NET_BALANCE NUMBER,
93 COLLECTABLE_AMOUNT NUMBER,
94 DUE_DATE DATE,
95 COLLECTIONS_STATUS VARCHAR2(30),
96 COLLECTIONS_STATUS_MEANING VARCHAR2(80),
97 CONTACT_NAME VARCHAR2(360),
98 CONTACT_PHONE_NUMBER VARCHAR2(1000),
99 CUSTOMER_ADDRESS1 VARCHAR2(240),
100 CUSTOMER_STATE VARCHAR2(50),
101 CUSTOMER_CITY VARCHAR2(50),
102 CUSTOMER_COUNTY VARCHAR2(50),
103 CUSTOMER_POSTAL_CODE VARCHAR2(50),
104 CUSTOMER_COUNTRY VARCHAR2(50),
105 STRATEGY_ID NUMBER(15),
106 STRATEGY_NAME VARCHAR2(1000),
107 WORK_ITEM_NAME VARCHAR2(1000),
108 WORK_ITEM_ID NUMBER(15),
109 ASSIGNED_COLLECTOR_ID NUMBER,
110 ASSIGNED_COLLECTOR_NAME VARCHAR2(250),
111 CURRENCY VARCHAR2(3),
112 AGING_BUCKET_NAME VARCHAR2(20),
113 UNAPPLIED_CM_AMOUNT NUMBER,
114 UNAPPLIED_PAYMENT_AMOUNT NUMBER,
115 TOTAL_DISPUTE_AMOUNT NUMBER);
116
117 TYPE trx_delinquency_rec_type IS RECORD (
118 --
119 -- UWQ Data
120 --
121 IEU_OBJECT_FUNCTION VARCHAR2(30),
122 IEU_OBJECT_PARAMETERS VARCHAR2(2000),
123 IEU_MEDIA_TYPE_UUID VARCHAR2(200),
124 IEU_PARAM_PK_COL VARCHAR2(200),
125 IEU_PARAM_PK_VALUE VARCHAR2(40),
126 RESOURCE_ID NUMBER,
127 RESOURCE_TYPE VARCHAR2(200),
128 --
129 -- Standard Data
130 --
131 TRX_DELINQUENCY_ID NUMBER,
132 CREATION_DATE DATE,
133 CREATED_BY NUMBER(15),
134 LAST_UPDATE_DATE DATE,
135 LAST_UPDATED_BY NUMBER(15),
136 LAST_UPDATE_LOGIN NUMBER(15),
137 ORG_ID NUMBER,
138 --
139 -- Main Data
140 --
141 DELINQUENCY_ID NUMBER(15),
142 PAYMENT_SCHEDULE_ID NUMBER(15),
143 CUSTOMER_TRX_ID NUMBER(15),
144 TRX_NUMBER VARCHAR2(20),
145 TERMS_SEQUENCE_NUMBER NUMBER(15),
146 CASE_ID NUMBER(15),
147 CUST_ACCOUNT_ID NUMBER(15),
148 ACCOUNT_NUMBER VARCHAR2(30),
149 ACCOUNT_NAME VARCHAR2(240),
150 CUSTOMER_NAME VARCHAR2(360),
151 CUSTOMER_PARTY_ID NUMBER,
152 CUSTOMER_PARTY_NUMBER VARCHAR2(30),
153 COLLECTABLE_AMOUNT NUMBER,
154 AMOUNT_DUE_ORIGINAL NUMBER,
155 AMOUNT_DUE_REMAINING NUMBER,
156 INVOICE_CURRENCY_CODE VARCHAR2(3),
157 DUE_DATE DATE,
158 GL_DATE DATE,
159 DELINQUENCY_STATUS VARCHAR2(30),
160 DELINQUENCY_STATUS_MEANING VARCHAR2(80),
161 CONTACT_NAME VARCHAR2(360),
162 CONTACT_PHONE_NUMBER VARCHAR2(1000),
163 CUSTOMER_ADDRESS1 VARCHAR2(240),
164 CUSTOMER_STATE VARCHAR2(50),
165 CUSTOMER_CITY VARCHAR2(50),
166 CUSTOMER_COUNTY VARCHAR2(50),
167 CUSTOMER_POSTAL_CODE VARCHAR2(50),
168 CUSTOMER_COUNTRY VARCHAR2(50),
169 STRATEGY_ID NUMBER(15),
170 STRATEGY_NAME VARCHAR2(1000),
171 WORK_ITEM_ID NUMBER(15),
172 WORK_ITEM_NAME VARCHAR2(1000),
173 ASSIGNED_COLLECTOR_ID NUMBER,
174 ASSIGNED_COLLECTOR_NAME VARCHAR2(250),
175 AGING_BUCKET_LINE_ID NUMBER,
176 AGING_BUCKET_LINE_DSP VARCHAR2(100),
177 DLN_LAST_UPDATE_DATE DATE,
178 DLN_LAST_UPDATED_BY NUMBER(15),
179 DLN_LAST_UPDATED_NAME VARCHAR2(250),
180 DLN_CREATION_DATE DATE,
181 UWQ_STATUS VARCHAR2(30),
182 UWQ_STATUS_MEANING VARCHAR2(80),
183 UWQ_ACTIVE_DATE DATE,
184 UWQ_COMPLETE_DATE DATE);
185
186 -- this will be the outside wrapper for the concurrent program to call the "creation" in batch
187 PROCEDURE Consolidate_Delinquency_CONCUR(ERRBUF OUT NOCOPY VARCHAR2,
188 RETCODE OUT NOCOPY VARCHAR2,
189 p_list_name IN VARCHAR2 DEFAULT NULL);
190
191 PROCEDURE Consolidate_Customer
192 (p_api_version IN NUMBER := 1.0,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 x_consolidated_cnt OUT NOCOPY NUMBER);
200
201 PROCEDURE Consolidate_Account
202 (p_api_version IN NUMBER := 1.0,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 x_consolidated_cnt OUT NOCOPY NUMBER);
210
211 PROCEDURE Consolidate_Transaction
212 (p_api_version IN NUMBER := 1.0,
213 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214 p_commit IN VARCHAR2 := FND_API.G_FALSE,
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 x_consolidated_cnt OUT NOCOPY NUMBER);
220
221 END IEX_CNSLD_DELINQUENCY_PUB;