1 PACKAGE IEX_DUNNING_PUB AS
2 /* $Header: iexpduns.pls 120.8.12000000.2 2007/03/14 06:53:22 gnramasa ship $ */
3
4
5 -- clchang added new column XDO_TEMPLATE_ID for 11.5.11
6
7 TYPE AG_DN_XREF_REC_TYPE IS RECORD (
8 AG_DN_XREF_ID NUMBER ,
9 aging_bucket_id NUMBER ,
10 aging_bucket_line_id NUMBER ,
11 callback_flag VARCHAR2(1) ,
12 callback_days NUMBER ,
13 FM_METHOD VARCHAR2(10) ,
14 template_id NUMBER ,
15 xdo_template_id NUMBER ,
16 score_RANGE_LOW NUMBER ,
17 score_RANGE_HIGH NUMBER ,
18 DUNNING_LEVEL VARCHAR2(30) ,
19 OBJECT_VERSION_NUMBER NUMBER ,
20 LAST_UPDATE_DATE DATE ,
21 LAST_UPDATED_BY NUMBER ,
22 CREATION_DATE DATE ,
23 CREATED_BY NUMBER ,
24 LAST_UPDATE_LOGIN NUMBER );
25
26 TYPE AG_DN_XREF_TBL_TYPE is Table of AG_DN_XREF_REC_TYPE
27 index by binary_integer;
28
29
30 TYPE AG_DN_XREF_ID_TBL_TYPE is Table of NUMBER index by binary_integer;
31
32 G_MISS_AG_DN_XREF_REC IEX_DUNNING_PUB.AG_DN_XREF_REC_TYPE;
33 G_MISS_AG_DN_XREF_TBL IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE;
34 G_MISS_AG_DN_XREF_ID_TBL IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE;
35
36
37 -- clchang added new column XML_REQUEST_ID, XML_TEMPLATE_ID for 11.5.11
38 TYPE DUNNING_REC_TYPE IS RECORD (
39 DUNNING_ID NUMBER ,
40 TEMPLATE_ID NUMBER ,
41 callback_yn VARCHAR2(1) ,
42 callback_date DATE ,
43 STATUS VARCHAR2(240) ,
44 CAMPAIGN_SCHED_ID NUMBER ,
45 DELINQUENCY_ID NUMBER ,
46 FFM_REQUEST_ID NUMBER ,
47 XML_REQUEST_ID NUMBER ,
48 XML_TEMPLATE_ID NUMBER ,
49 OBJECT_ID NUMBER ,
50 OBJECT_TYPE VARCHAR2(30) ,
51 DUNNING_LEVEL VARCHAR2(30) ,
52 DUNNING_OBJECT_ID NUMBER ,
53 DUNNING_METHOD VARCHAR2(30) ,
54 AMOUNT_DUE_REMAINING NUMBER ,
55 CURRENCY_CODE VARCHAR2(15) ,
56 LAST_UPDATE_DATE DATE ,
57 LAST_UPDATED_BY NUMBER ,
58 CREATION_DATE DATE ,
59 CREATED_BY NUMBER ,
60 LAST_UPDATE_LOGIN NUMBER ,
61 FINANCIAL_CHARGE NUMBER ,
62 LETTER_NAME VARCHAR2(30) ,
63 INTEREST_AMT NUMBER ,
64 dunning_plan_id number ,
65 contact_destination varchar2(240) ,
66 contact_party_id number ,
67 REQUEST_ID NUMBER , -- added by gnramasa for bug 5661324 14-Mar-07
68 DELIVERY_STATUS VARCHAR2(30) , -- added by gnramasa for bug 5661324 14-Mar-07
69 PARENT_DUNNING_ID NUMBER -- added by gnramasa for bug 5661324 14-Mar-07
70 );
71
72 G_MISS_DUNNING_REC IEX_DUNNING_PUB.DUNNING_REC_TYPE;
73
74 TYPE DUNNING_TBL_TYPE is Table of DUNNING_REC_TYPE
75 index by binary_integer;
76
77 TYPE DelId_NumList is Table of Number;
78
79
80 Procedure Create_AG_DN_XREF
81 (p_api_version IN NUMBER := 1.0,
82 p_init_msg_list IN VARCHAR2 ,
83 p_commit IN VARCHAR2 ,
84 P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 x_AG_DN_XREF_ID_TBL OUT NOCOPY IEX_DUNNING_PUB.AG_DN_XREF_ID_TBL_TYPE);
89
90
91 Procedure Update_AG_DN_XREF
92 (p_api_version IN NUMBER := 1.0,
93 p_init_msg_list IN VARCHAR2 ,
94 p_commit IN VARCHAR2 ,
95 P_AG_DN_XREF_TBL IN IEX_DUNNING_PUB.AG_DN_XREF_TBL_TYPE ,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100
101
102 Procedure Delete_AG_DN_XREF
103 (p_api_version IN NUMBER := 1.0,
104 p_init_msg_list IN VARCHAR2 ,
105 p_commit IN VARCHAR2 ,
106 P_AG_DN_XREF_ID IN NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2);
110
111
112
113
114 Procedure Send_Dunning
115 (p_api_version IN NUMBER := 1.0,
116 p_init_msg_list IN VARCHAR2 ,
117 p_commit IN VARCHAR2 ,
118 p_running_level IN VARCHAR2,
119 p_previous_request_id IN NUMBER, -- added by gnramasa for bug 5661324 14-Mar-07
120 p_dunning_plan_id in number,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2);
124
125
126
127 /*=====================================================================
128 clchang updated 10/02/2002 - no CloseDunning in 115.9
129
130 PROCEDURE Close_Dunning
131 (p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 --p_delinquencies_tbl IN IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE
135 -- := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_TBL,
136 p_delinquencies_tbl IN DelId_NumList,
137 p_security_check IN VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2);
141 *======================================================================*/
142
143
144 Procedure Daily_Dunning
145 (p_api_version IN NUMBER :=1.0,
146 p_init_msg_list IN VARCHAR2 ,
147 p_commit IN VARCHAR2 ,
148 --p_dunning_tbl IN IEX_DUNNING_PUB.DUNNING_TBL_TYPE,
149 p_running_level IN VARCHAR2,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2);
153
154
155 PROCEDURE CALLBACK_CONCUR(
156 ERRBUF OUT NOCOPY VARCHAR2,
157 RETCODE OUT NOCOPY VARCHAR2,
158 P_ORG_ID IN NUMBER DEFAULT NULL); --Added for MOAC
159
160
161 PROCEDURE SEND_DUNNING_CONCUR(
162 ERRBUF OUT NOCOPY VARCHAR2,
163 RETCODE OUT NOCOPY VARCHAR2,
164 dunning_plan_id NUMBER,
165 p_previous_request_id IN NUMBER); -- added by gnramasa for bug 5661324 14-Mar-07
166
167
168 END IEX_DUNNING_PUB;