1 PACKAGE IEX_DELINQUENCY_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexpdels.pls 120.5 2005/01/26 16:21:47 acaraujo ship $ */
3
4 -- clchang updated 03/12/2003 to add score_value in delinquency_rec_type (11.5.9)
5 -- clchang updated 04/21/2003 to add customer_site_use_id in delinquency_rec_type (11.5.10)
6
7 TYPE DELINQUENCY_REC_TYPE IS RECORD
8 ( DELINQUENCY_ID NUMBER ,
9 LAST_UPDATE_DATE DATE ,
10 LAST_UPDATED_BY NUMBER ,
11 LAST_UPDATE_LOGIN NUMBER ,
12 CREATION_DATE DATE ,
13 CREATED_BY NUMBER ,
14 PROGRAM_ID NUMBER ,
15 OBJECT_VERSION_NUMBER NUMBER ,
16 PARTY_CUST_ID NUMBER ,
17 PARTY_CLIENT_ID NUMBER ,
18 CUST_ACCOUNT_ID NUMBER ,
19 CUSTOMER_SITE_USE_ID NUMBER ,
20 TRANSACTION_ID NUMBER ,
21 PAYMENT_SCHEDULE_ID NUMBER ,
22 AGING_BUCKET_LINE_ID NUMBER ,
23 CASE_ID NUMBER ,
24 RESOURCE_ID NUMBER ,
25 SCORE_VALUE NUMBER ,
26 DUNN_YN VARCHAR2(10) ,
27 AUTOASSIGN_YN VARCHAR2(10) ,
28 STATUS VARCHAR2(30) ,
29 CAMPAIGN_SCHED_ID NUMBER
30 );
31
32 G_MISS_DELINQUENCY_REC DELINQUENCY_REC_TYPE;
33
34 TYPE DELINQUENCY_TBL_TYPE IS TABLE OF DELINQUENCY_REC_TYPE
35 INDEX BY BINARY_INTEGER;
36
37 TYPE t_del_id is TABLE of IEX_DELINQUENCIES.delinquency_id%TYPE;
38 TYPE t_del_status is TABLE of IEX_DELINQUENCIES.status%TYPE;
39 TYPE t_buf_status is TABLE of IEX_DELINQUENCIES.status%TYPE;
40
41 G_MISS_DELINQUENCY_TBL DELINQUENCY_TBL_TYPE;
42 /*========================================================================+
43 | Copyright (c) 2002 Oracle Corporation |
44 | Redwood Shores, California, USA |
45 | All rights reserved. |
46 +=========================================================================+
47 | |
48 | FILENAME: |
49 | iexpdels.pls |
50 | DESCRIPTION: |
51 | Public API to create /update delinquencies |
52 | MODIFICATION HISTORY: |
53 +========================================================================*/
54
55 PROCEDURE CLEAR_DEL_BUFFERS(ERRBUF OUT NOCOPY VARCHAR2,
56 RETCODE OUT NOCOPY VARCHAR2);
57
58 PROCEDURE Close_Delinquencies(p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_payments_tbl IN IEX_PAYMENTS_BATCH_PUB.CL_INV_TBL_TYPE,
61 p_security_check IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2);
65
66 PROCEDURE MANAGE_DELINQUENCIES (ERRBUF OUT NOCOPY VARCHAR2,
67 RETCODE OUT NOCOPY VARCHAR2,
68 p_request_id IN Number);
69
70 procedure SCORE_DELINQUENCIES (ERRBUF OUT NOCOPY VARCHAR2,
71 RETCODE OUT NOCOPY VARCHAR2,
72 p_request_id Number);
73
74
75
76 /*------------------------------------------------------------------------
77
78 11.5.7 Independent Delinquency Creation Process
79
80 ------------------------------------------------------------------------ */
81 PROCEDURE Create_Ind_Delinquency
82 (p_api_version IN NUMBER ,
83 p_init_msg_list IN VARCHAR2,
84 p_commit IN VARCHAR2,
85 p_validation_level IN NUMBER ,
86 x_return_status OUT NOCOPY VARCHAR2 ,
87 x_msg_count OUT NOCOPY NUMBER ,
88 x_msg_data OUT NOCOPY VARCHAR2 ,
89 p_source_module IN VARCHAR2 ,
90 p_party_id IN Number ,
91 p_object_code IN Varchar2 ,
92 p_object_id_tbl IN IEX_UTILITIES.t_numbers,
93 x_del_id_tbl OUT NOCOPY IEX_UTILITIES.t_numbers);
94
95
96
97 PROCEDURE SHOW_IN_UWQ(
98 P_API_VERSION IN NUMBER,
99 P_INIT_MSG_LIST IN VARCHAR2,
100 P_COMMIT IN VARCHAR2,
101 P_VALIDATION_LEVEL IN NUMBER,
102 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
103 X_MSG_COUNT OUT NOCOPY NUMBER,
104 X_MSG_DATA OUT NOCOPY VARCHAR2,
105 P_DELINQUENCY_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
106 P_UWQ_STATUS IN VARCHAR2,
107 P_NO_DAYS IN NUMBER DEFAULT NULL);
108
109
110
111 PROCEDURE CLOSE_DUNNINGS(ERRBUF OUT NOCOPY VARCHAR2,
112 RETCODE OUT NOCOPY VARCHAR2,
113 DUNNING_LEVEL Varchar2) ;
114
115 --
116 -- Begin - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
117 --
118 /*
119 || Overview: Clean up delinquency_buffers table this will use the batch size profile and do one request or all table
120 ||
121 || Parameter: P_REQUEST is the request Id we need to delete, if it is -1 we delete the whole table
122 ||
123 || Source Tables: None
124 ||
125 || Target Tables: IEX_DEL_BUFFERS
126 ||
127 || Creation date: 01/25/05 3:29:PM
128 ||
129 || Major Modifications: when who what
130 || 01/25/05 acaraujo created
131 */
132 PROCEDURE CLEAR_BUFFERS2(P_REQUEST IN NUMBER);
133
134 --
135 -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
136 --
137
138 END IEX_DELINQUENCY_PUB;
139