1 PACKAGE IEX_BANKRUPTCIES_PKG as
2 /* $Header: iextbkrs.pls 120.0 2004/01/24 03:21:13 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_BANKRUPTCIES_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_BANKRUPTCY_ID IN NUMBER,
13 p_CAS_ID IN NUMBER,
14 p_DELINQUENCY_ID IN NUMBER,
15 p_PARTY_ID IN NUMBER,
16 p_ACTIVE_FLAG IN VARCHAR2,
17 p_TRUSTEE_CONTACT_ID IN NUMBER,
18 p_COURT_ID IN NUMBER,
19 p_FIRM_CONTACT_ID IN NUMBER,
20 p_COUNSEL_CONTACT_ID IN NUMBER,
21 p_OBJECT_VERSION_NUMBER IN NUMBER,
22 p_CHAPTER_CODE IN VARCHAR2,
23 p_ASSET_AMOUNT IN NUMBER,
24 p_ASSET_CURRENCY_CODE IN VARCHAR2,
25 p_PAYOFF_AMOUNT IN NUMBER,
26 p_PAYOFF_CURRENCY_CODE IN VARCHAR2,
27 p_BANKRUPTCY_FILE_DATE IN DATE,
28 p_COURT_ORDER_DATE IN DATE,
29 p_FUNDING_DATE IN DATE,
30 p_OBJECT_BAR_DATE IN DATE,
31 p_REPOSSESSION_DATE IN DATE,
32 p_DISMISSAL_DATE IN DATE,
33 p_DATE_341A IN DATE,
34 p_DISCHARGE_DATE IN DATE,
35 p_WITHDRAW_DATE IN DATE,
36 p_CLOSE_DATE IN DATE,
37 p_PROCEDURE_CODE IN VARCHAR2,
38 p_MOTION_CODE IN VARCHAR2,
39 p_CHECKLIST_CODE IN VARCHAR2,
40 p_CEASE_COLLECTIONS_YN IN VARCHAR2,
41 p_TURN_OFF_INVOICING_YN IN VARCHAR2,
42 p_REQUEST_ID IN NUMBER,
43 p_PROGRAM_APPLICATION_ID IN NUMBER,
44 p_PROGRAM_ID IN NUMBER,
45 p_PROGRAM_UPDATE_DATE IN DATE,
46 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
47 p_ATTRIBUTE1 IN VARCHAR2,
48 p_ATTRIBUTE2 IN VARCHAR2,
49 p_ATTRIBUTE3 IN VARCHAR2,
50 p_ATTRIBUTE4 IN VARCHAR2,
51 p_ATTRIBUTE5 IN VARCHAR2,
52 p_ATTRIBUTE6 IN VARCHAR2,
53 p_ATTRIBUTE7 IN VARCHAR2,
54 p_ATTRIBUTE8 IN VARCHAR2,
55 p_ATTRIBUTE9 IN VARCHAR2,
56 p_ATTRIBUTE10 IN VARCHAR2,
57 p_ATTRIBUTE11 IN VARCHAR2,
58 p_ATTRIBUTE12 IN VARCHAR2,
59 p_ATTRIBUTE13 IN VARCHAR2,
60 p_ATTRIBUTE14 IN VARCHAR2,
61 p_ATTRIBUTE15 IN VARCHAR2,
62 p_CREATED_BY IN VARCHAR2,
63 p_CREATION_DATE IN DATE,
64 p_LAST_UPDATED_BY IN NUMBER,
65 p_LAST_UPDATE_DATE IN DATE,
66 p_LAST_UPDATE_LOGIN IN NUMBER
67 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
68 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
69 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
70 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
71 ,p_DISPOSITION_CODE IN VARCHAR2
72 ,p_TURN_OFF_INVOICE_YN IN VARCHAR2
73 ,p_NOTICE_ASSIGNMENT_YN IN VARCHAR2
74 ,p_FILE_PROOF_CLAIM_YN IN VARCHAR2
75 ,p_REQUEST_REPURCHASE_YN IN VARCHAR2
76 ,p_FEE_PAID_DATE IN DATE
77 ,p_REAFFIRMATION_DATE IN DATE
78 ,p_RELIEF_STAY_DATE IN DATE
79 ,p_FILE_CONTACT_ID IN NUMBER
80 ,p_CASE_NUMBER IN VARCHAR2
81 );
82
83
84 PROCEDURE Update_Row(
85 p_BANKRUPTCY_ID IN NUMBER,
86 p_CAS_ID IN NUMBER,
87 p_DELINQUENCY_ID IN NUMBER,
88 p_PARTY_ID IN NUMBER,
89 p_ACTIVE_FLAG IN VARCHAR2,
90 p_TRUSTEE_CONTACT_ID IN NUMBER,
91 p_COURT_ID IN NUMBER,
92 p_FIRM_CONTACT_ID IN NUMBER,
93 p_COUNSEL_CONTACT_ID IN NUMBER,
94 p_OBJECT_VERSION_NUMBER IN NUMBER,
95 p_CHAPTER_CODE IN VARCHAR2,
96 p_ASSET_AMOUNT IN NUMBER,
97 p_ASSET_CURRENCY_CODE IN VARCHAR2,
98 p_PAYOFF_AMOUNT IN NUMBER,
99 p_PAYOFF_CURRENCY_CODE IN VARCHAR2,
100 p_BANKRUPTCY_FILE_DATE IN DATE,
101 p_COURT_ORDER_DATE IN DATE,
102 p_FUNDING_DATE IN DATE,
103 p_OBJECT_BAR_DATE IN DATE,
104 p_REPOSSESSION_DATE IN DATE,
105 p_DISMISSAL_DATE IN DATE,
106 p_DATE_341A IN DATE,
107 p_DISCHARGE_DATE IN DATE,
108 p_WITHDRAW_DATE IN DATE,
109 p_CLOSE_DATE IN DATE,
110 p_PROCEDURE_CODE IN VARCHAR2,
111 p_MOTION_CODE IN VARCHAR2,
112 p_CHECKLIST_CODE IN VARCHAR2,
113 p_CEASE_COLLECTIONS_YN IN VARCHAR2,
114 p_TURN_OFF_INVOICING_YN IN VARCHAR2,
115 p_REQUEST_ID IN NUMBER,
116 p_PROGRAM_APPLICATION_ID IN NUMBER,
117 p_PROGRAM_ID IN NUMBER,
118 p_PROGRAM_UPDATE_DATE IN DATE,
119 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
120 p_ATTRIBUTE1 IN VARCHAR2,
121 p_ATTRIBUTE2 IN VARCHAR2,
122 p_ATTRIBUTE3 IN VARCHAR2,
123 p_ATTRIBUTE4 IN VARCHAR2,
124 p_ATTRIBUTE5 IN VARCHAR2,
125 p_ATTRIBUTE6 IN VARCHAR2,
126 p_ATTRIBUTE7 IN VARCHAR2,
127 p_ATTRIBUTE8 IN VARCHAR2,
128 p_ATTRIBUTE9 IN VARCHAR2,
129 p_ATTRIBUTE10 IN VARCHAR2,
130 p_ATTRIBUTE11 IN VARCHAR2,
131 p_ATTRIBUTE12 IN VARCHAR2,
132 p_ATTRIBUTE13 IN VARCHAR2,
133 p_ATTRIBUTE14 IN VARCHAR2,
134 p_ATTRIBUTE15 IN VARCHAR2,
135 p_LAST_UPDATED_BY IN NUMBER,
136 p_LAST_UPDATE_DATE IN DATE,
137 p_LAST_UPDATE_LOGIN IN NUMBER
138 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
139 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
140 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
141 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
142 ,p_DISPOSITION_CODE IN VARCHAR2
143 ,p_TURN_OFF_INVOICE_YN IN VARCHAR2
144 ,p_NOTICE_ASSIGNMENT_YN IN VARCHAR2
145 ,p_FILE_PROOF_CLAIM_YN IN VARCHAR2
146 ,p_REQUEST_REPURCHASE_YN IN VARCHAR2
147 ,p_FEE_PAID_DATE IN DATE
148 ,p_REAFFIRMATION_DATE IN DATE
149 ,p_RELIEF_STAY_DATE IN DATE
150 ,p_FILE_CONTACT_ID IN NUMBER
151 ,p_CASE_NUMBER IN VARCHAR2
152 );
153
154 procedure LOCK_ROW (
155 p_BANKRUPTCY_ID in NUMBER,
156 p_OBJECT_VERSION_NUMBER in NUMBER);
157
158
159 /*PROCEDURE Lock_Row(
160 p_BANKRUPTCY_ID IN NUMBER,
161 p_CAS_ID IN NUMBER,
162 p_DELINQUENCY_ID IN NUMBER,
163 p_PARTY_ID IN NUMBER,
164 p_ACTIVE_FLAG IN VARCHAR2,
165 p_TRUSTEE_CONTACT_ID IN NUMBER,
166 p_COURT_ID IN NUMBER,
167 p_FIRM_CONTACT_ID IN NUMBER,
168 p_COUNSEL_CONTACT_ID IN NUMBER,
169 p_OBJECT_VERSION_NUMBER IN NUMBER,
170 p_CHAPTER_CODE IN VARCHAR2,
171 p_ASSET_AMOUNT IN NUMBER,
172 p_ASSET_CURRENCY_CODE IN VARCHAR2,
173 p_PAYOFF_AMOUNT IN NUMBER,
174 p_PAYOFF_CURRENCY_CODE IN VARCHAR2,
175 p_BANKRUPTCY_FILE_DATE IN DATE,
176 p_COURT_ORDER_DATE IN DATE,
177 p_FUNDING_DATE IN DATE,
178 p_OBJECT_BAR_DATE IN DATE,
179 p_REPOSSESSION_DATE IN DATE,
180 p_DISMISSAL_DATE IN DATE,
181 p_DATE_341A IN DATE,
182 p_DISCHARGE_DATE IN DATE,
183 p_WITHDRAW_DATE IN DATE,
184 p_CLOSE_DATE IN DATE,
185 p_PROCEDURE_CODE IN VARCHAR2,
186 p_MOTION_CODE IN VARCHAR2,
187 p_CHECKLIST_CODE IN VARCHAR2,
188 p_CEASE_COLLECTIONS_YN IN VARCHAR2,
189 p_TURN_OFF_INVOICING_YN IN VARCHAR2,
190 p_REQUEST_ID IN NUMBER,
191 p_PROGRAM_APPLICATION_ID IN NUMBER,
192 p_PROGRAM_ID IN NUMBER,
193 p_PROGRAM_UPDATE_DATE IN DATE,
194 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
195 p_ATTRIBUTE1 IN VARCHAR2,
196 p_ATTRIBUTE2 IN VARCHAR2,
197 p_ATTRIBUTE3 IN VARCHAR2,
198 p_ATTRIBUTE4 IN VARCHAR2,
199 p_ATTRIBUTE5 IN VARCHAR2,
200 p_ATTRIBUTE6 IN VARCHAR2,
201 p_ATTRIBUTE7 IN VARCHAR2,
202 p_ATTRIBUTE8 IN VARCHAR2,
203 p_ATTRIBUTE9 IN VARCHAR2,
204 p_ATTRIBUTE10 IN VARCHAR2,
205 p_ATTRIBUTE11 IN VARCHAR2,
206 p_ATTRIBUTE12 IN VARCHAR2,
207 p_ATTRIBUTE13 IN VARCHAR2,
208 p_ATTRIBUTE14 IN VARCHAR2,
209 p_ATTRIBUTE15 IN VARCHAR2,
210 p_CREATED_BY IN VARCHAR2,
211 p_CREATION_DATE IN DATE,
212 p_LAST_UPDATED_BY IN NUMBER,
213 p_LAST_UPDATE_DATE IN DATE,
214 p_LAST_UPDATE_LOGIN IN NUMBER
215 ,p_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2
216 ,p_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2
217 ,p_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2
218 ,p_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2
219 ,p_DISPOSITION_CODE IN VARCHAR2
220 );
221 */
222 PROCEDURE Delete_Row(
223 p_BANKRUPTCY_ID NUMBER);
224 End IEX_BANKRUPTCIES_PKG;