1 PACKAGE IEX_WRITEOFFS_PKG as
2 /* $Header: iextwros.pls 120.1 2007/10/31 13:00:09 ehuh ship $ */
3 -- Start of Comments
4 -- Package name : IEX_WRITEOFFS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 X_ROWID IN out NOCOPY VARCHAR2,
12 p_WRITEOFF_ID IN NUMBER,
13 p_PARTY_ID IN NUMBER,
14 p_DELINQUENCY_ID IN NUMBER,
15 p_CAS_ID IN NUMBER,
16 p_CUST_ACCOUNT_ID IN NUMBER,
17 p_DISPOSITION_CODE IN VARCHAR2,
18 p_OBJECT_ID IN NUMBER,
19 p_OBJECT_CODE IN VARCHAR2,
20 p_WRITEOFF_TYPE IN VARCHAR2,
21 p_ACTIVE_FLAG IN VARCHAR2,
22 p_OBJECT_VERSION_NUMBER IN NUMBER,
23 p_WRITEOFF_REASON IN VARCHAR2,
24 p_WRITEOFF_AMOUNT IN NUMBER,
25 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
26 p_WRITEOFF_DATE IN DATE,
27 p_WRITEOFF_REQUEST_DATE IN DATE,
28 p_WRITEOFF_PROCESS IN VARCHAR2,
29 p_WRITEOFF_SCORE IN VARCHAR2,
30 p_BAD_DEBT_REASON IN VARCHAR2,
31 p_LEASING_CODE IN VARCHAR2,
32 p_REPOSSES_SCH_DATE IN DATE,
33 p_REPOSSES_COMP_DATE IN DATE,
34 p_CREDIT_HOLD_YN IN VARCHAR2,
35 p_APPROVER_ID IN VARCHAR2,
36 p_EXTERNAL_AGENT_ID IN VARCHAR2,
37 p_PROCEDURE_CODE IN VARCHAR2,
38 p_CHECKLIST_CODE IN VARCHAR2,
39 p_REQUEST_ID IN NUMBER,
40 p_PROGRAM_APPLICATION_ID IN NUMBER,
41 p_PROGRAM_ID IN NUMBER,
42 p_PROGRAM_UPDATE_DATE IN DATE,
43 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
44 p_ATTRIBUTE1 IN VARCHAR2,
45 p_ATTRIBUTE2 IN VARCHAR2,
46 p_ATTRIBUTE3 IN VARCHAR2,
47 p_ATTRIBUTE4 IN VARCHAR2,
48 p_ATTRIBUTE5 IN VARCHAR2,
49 p_ATTRIBUTE6 IN VARCHAR2,
50 p_ATTRIBUTE7 IN VARCHAR2,
51 p_ATTRIBUTE8 IN VARCHAR2,
52 p_ATTRIBUTE9 IN VARCHAR2,
53 p_ATTRIBUTE10 IN VARCHAR2,
54 p_ATTRIBUTE11 IN VARCHAR2,
55 p_ATTRIBUTE12 IN VARCHAR2,
56 p_ATTRIBUTE13 IN VARCHAR2,
57 p_ATTRIBUTE14 IN VARCHAR2,
58 p_ATTRIBUTE15 IN VARCHAR2,
59 p_CREATED_BY IN VARCHAR2,
60 p_CREATION_DATE IN DATE,
61 p_LAST_UPDATED_BY IN NUMBER,
62 p_LAST_UPDATE_DATE IN DATE,
63 p_LAST_UPDATE_LOGIN IN NUMBER
64 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
65 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
66 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
67 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
68 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2
69 ,p_CUSTOMER_SITE_USE_ID IN NUMBER
70 ,p_ORG_ID IN NUMBER
71 ,p_CONTRACT_ID IN NUMBER
72 ,p_CONTRACT_NUMBER IN VARCHAR2
73 );
74
75 PROCEDURE Update_Row(
76 p_WRITEOFF_ID IN NUMBER,
77 p_PARTY_ID IN NUMBER,
78 p_DELINQUENCY_ID IN NUMBER,
79 p_CAS_ID IN NUMBER,
80 p_CUST_ACCOUNT_ID IN NUMBER,
81 p_DISPOSITION_CODE IN VARCHAR2,
82 p_OBJECT_ID IN NUMBER,
83 p_OBJECT_CODE IN VARCHAR2,
84 p_WRITEOFF_TYPE IN VARCHAR2,
85 p_ACTIVE_FLAG IN VARCHAR2,
86 p_OBJECT_VERSION_NUMBER IN NUMBER,
87 p_WRITEOFF_REASON IN VARCHAR2,
88 p_WRITEOFF_AMOUNT IN NUMBER,
89 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
90 p_WRITEOFF_DATE IN DATE,
91 p_WRITEOFF_REQUEST_DATE IN DATE,
92 p_WRITEOFF_PROCESS IN VARCHAR2,
93 p_WRITEOFF_SCORE IN VARCHAR2,
94 p_BAD_DEBT_REASON IN VARCHAR2,
95 p_LEASING_CODE IN VARCHAR2,
96 p_REPOSSES_SCH_DATE IN DATE,
97 p_REPOSSES_COMP_DATE IN DATE,
98 p_CREDIT_HOLD_YN IN VARCHAR2,
99 p_APPROVER_ID IN VARCHAR2,
100 p_EXTERNAL_AGENT_ID IN VARCHAR2,
101 p_PROCEDURE_CODE IN VARCHAR2,
102 p_CHECKLIST_CODE IN VARCHAR2,
103 p_REQUEST_ID IN NUMBER,
104 p_PROGRAM_APPLICATION_ID IN NUMBER,
105 p_PROGRAM_ID IN NUMBER,
106 p_PROGRAM_UPDATE_DATE IN DATE,
107 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
108 p_ATTRIBUTE1 IN VARCHAR2,
109 p_ATTRIBUTE2 IN VARCHAR2,
110 p_ATTRIBUTE3 IN VARCHAR2,
111 p_ATTRIBUTE4 IN VARCHAR2,
112 p_ATTRIBUTE5 IN VARCHAR2,
113 p_ATTRIBUTE6 IN VARCHAR2,
114 p_ATTRIBUTE7 IN VARCHAR2,
115 p_ATTRIBUTE8 IN VARCHAR2,
116 p_ATTRIBUTE9 IN VARCHAR2,
117 p_ATTRIBUTE10 IN VARCHAR2,
118 p_ATTRIBUTE11 IN VARCHAR2,
119 p_ATTRIBUTE12 IN VARCHAR2,
120 p_ATTRIBUTE13 IN VARCHAR2,
121 p_ATTRIBUTE14 IN VARCHAR2,
122 p_ATTRIBUTE15 IN VARCHAR2,
123 p_LAST_UPDATED_BY IN NUMBER,
124 p_LAST_UPDATE_DATE IN DATE,
125 p_LAST_UPDATE_LOGIN IN NUMBER
126 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
127 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
128 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
129 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
130 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2
131 ,p_CUSTOMER_SITE_USE_ID IN NUMBER
132 ,p_ORG_ID IN NUMBER
133 ,p_CONTRACT_ID IN NUMBER
134 ,p_CONTRACT_NUMBER IN VARCHAR2
135 );
136
137
138 procedure LOCK_ROW (
139 p_WRITEOFF_ID in NUMBER,
140 p_OBJECT_VERSION_NUMBER in NUMBER);
141
142 /*
143
144 PROCEDURE Lock_Row(
145 p_WRITEOFF_ID IN NUMBER,
146 p_PARTY_ID IN NUMBER,
147 p_DELINQUENCY_ID IN NUMBER,
148 p_CAS_ID IN NUMBER,
149 p_OBJECT_ID IN NUMBER,
150 p_CUST_ACCOUNT_ID IN NUMBER,
151 p_DISPOSITION_CODE IN VARCHAR2,
152 p_OBJECT_CODE IN VARCHAR2,
153 p_WRITEOFF_TYPE IN VARCHAR2,
154 p_ACTIVE_FLAG IN VARCHAR2,
155 p_OBJECT_VERSION_NUMBER IN NUMBER,
156 p_WRITEOFF_REASON IN VARCHAR2,
157 p_WRITEOFF_AMOUNT IN NUMBER,
158 p_WRITEOFF_CURRENCY_CODE IN VARCHAR2,
159 p_WRITEOFF_DATE IN DATE,
160 p_WRITEOFF_REQUEST_DATE IN DATE,
161 p_WRITEOFF_PROCESS IN VARCHAR2,
162 p_WRITEOFF_SCORE IN VARCHAR2,
163 p_BAD_DEBT_REASON IN VARCHAR2,
164 p_LEASING_CODE IN VARCHAR2,
165 p_REPOSSES_SCH_DATE IN DATE,
166 p_REPOSSES_COMP_DATE IN DATE,
167 p_CREDIT_HOLD_YN IN VARCHAR2,
168 p_APPROVER_ID IN VARCHAR2,
169 p_EXTERNAL_AGENT_ID IN VARCHAR2,
170 p_PROCEDURE_CODE IN VARCHAR2,
171 p_CHECKLIST_CODE IN VARCHAR2,
172 p_REQUEST_ID IN NUMBER,
173 p_PROGRAM_APPLICATION_ID IN NUMBER,
174 p_PROGRAM_ID IN NUMBER,
175 p_PROGRAM_UPDATE_DATE IN DATE,
176 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
177 p_ATTRIBUTE1 IN VARCHAR2,
178 p_ATTRIBUTE2 IN VARCHAR2,
179 p_ATTRIBUTE3 IN VARCHAR2,
180 p_ATTRIBUTE4 IN VARCHAR2,
181 p_ATTRIBUTE5 IN VARCHAR2,
182 p_ATTRIBUTE6 IN VARCHAR2,
183 p_ATTRIBUTE7 IN VARCHAR2,
184 p_ATTRIBUTE8 IN VARCHAR2,
185 p_ATTRIBUTE9 IN VARCHAR2,
186 p_ATTRIBUTE10 IN VARCHAR2,
187 p_ATTRIBUTE11 IN VARCHAR2,
188 p_ATTRIBUTE12 IN VARCHAR2,
189 p_ATTRIBUTE13 IN VARCHAR2,
190 p_ATTRIBUTE14 IN VARCHAR2,
191 p_ATTRIBUTE15 IN VARCHAR2,
192 p_CREATED_BY IN VARCHAR2,
193 p_CREATION_DATE IN DATE,
194 p_LAST_UPDATED_BY IN NUMBER,
195 p_LAST_UPDATE_DATE IN DATE,
196 p_LAST_UPDATE_LOGIN IN NUMBER
197 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
198 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
199 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
200 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
201 ,p_SUGGESTION_APPROVED_FLAG IN VARCHAR2);
202
203 */
204
205 PROCEDURE Delete_Row(
206 p_WRITEOFF_ID NUMBER);
207 End IEX_WRITEOFFS_PKG;