[Home] [Help]
PACKAGE: APPS.IEX_BANKRUPTCIES_PVT
Source
1 PACKAGE IEX_BANKRUPTCIES_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvbkrs.pls 120.0 2004/01/24 03:24:45 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_BANKRUPTCIES_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:BANKRUPTCY_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- BANKRUPTCY_ID
19 -- CAS_ID
20 -- DELINQUENCY_ID
21 -- PARTY_ID
22 -- ACTIVE_FLAG
23 -- TRUSTEE_CONTACT_ID
24 -- COURT_ID
25 -- FIRM_CONTACT_ID
26 -- COUNSEL_CONTACT_ID
27 -- OBJECT_VERSION_NUMBER
28 -- CHAPTER_CODE
29 -- ASSET_AMOUNT
30 -- ASSET_CURRENCY_CODE
31 -- PAYOFF_AMOUNT
32 -- PAYOFF_CURRENCY_CODE
33 -- BANKRUPTCY_FILE_DATE
34 -- COURT_ORDER_DATE
35 -- FUNDING_DATE
36 -- OBJECT_BAR_DATE
37 -- REPOSSESSION_DATE
38 -- DISMISSAL_DATE
39 -- DATE_341A
40 -- DISCHARGE_DATE
41 -- WITHDRAW_DATE
42 -- CLOSE_DATE
43 -- PROCEDURE_CODE
44 -- MOTION_CODE
45 -- CHECKLIST_CODE
46 -- CEASE_COLLECTIONS_YN
47 -- TURN_OFF_INVOICING_YN
48 -- REQUEST_ID
49 -- PROGRAM_APPLICATION_ID
50 -- PROGRAM_ID
51 -- PROGRAM_UPDATE_DATE
52 -- ATTRIBUTE_CATEGORY
53 -- ATTRIBUTE1
54 -- ATTRIBUTE2
55 -- ATTRIBUTE3
56 -- ATTRIBUTE4
57 -- ATTRIBUTE5
58 -- ATTRIBUTE6
59 -- ATTRIBUTE7
60 -- ATTRIBUTE8
61 -- ATTRIBUTE9
62 -- ATTRIBUTE10
63 -- ATTRIBUTE11
64 -- ATTRIBUTE12
65 -- ATTRIBUTE13
66 -- ATTRIBUTE14
67 -- ATTRIBUTE15
68 -- CREATED_BY
69 -- CREATION_DATE
70 -- LAST_UPDATED_BY
71 -- LAST_UPDATE_DATE
72 -- LAST_UPDATE_LOGIN
73 -- CREDIT_HOLD_REQUEST_FLAG
74 -- CREDIT_HOLD_APPROVED_FLAG
75 -- SERVICE_HOLD_REQUEST_FLAG
76 -- SERVICE_HOLD_APPROVED_FLAG
77 --
78 -- Required:
79
80 --
81 -- End of Comments
82
83 TYPE bankruptcy_Rec_Type IS RECORD
84 (
85 BANKRUPTCY_ID NUMBER := FND_API.G_MISS_NUM,
86 CAS_ID NUMBER := FND_API.G_MISS_NUM,
87 DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
88 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
89 ACTIVE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
90 TRUSTEE_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
91 COURT_ID NUMBER := FND_API.G_MISS_NUM,
92 FIRM_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
93 COUNSEL_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
94 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
95 CHAPTER_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96 ASSET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
97 ASSET_CURRENCY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98 PAYOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
99 PAYOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
100 BANKRUPTCY_FILE_DATE DATE := FND_API.G_MISS_DATE,
101 COURT_ORDER_DATE DATE := FND_API.G_MISS_DATE,
102 FUNDING_DATE DATE := FND_API.G_MISS_DATE,
103 OBJECT_BAR_DATE DATE := FND_API.G_MISS_DATE,
104 REPOSSESSION_DATE DATE := FND_API.G_MISS_DATE,
105 DISMISSAL_DATE DATE := FND_API.G_MISS_DATE,
106 DATE_341A DATE := FND_API.G_MISS_DATE,
107 DISCHARGE_DATE DATE := FND_API.G_MISS_DATE,
108 WITHDRAW_DATE DATE := FND_API.G_MISS_DATE,
109 CLOSE_DATE DATE := FND_API.G_MISS_DATE,
110 PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
111 MOTION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
112 CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
113 CEASE_COLLECTIONS_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
114 TURN_OFF_INVOICING_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
115 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
116 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
117 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
118 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
119 ATTRIBUTE_CATEGORY VARCHAR2(90) := FND_API.G_MISS_CHAR,
120 ATTRIBUTE1 VARCHAR2(450) := FND_API.G_MISS_CHAR,
121 ATTRIBUTE2 VARCHAR2(450) := FND_API.G_MISS_CHAR,
122 ATTRIBUTE3 VARCHAR2(450) := FND_API.G_MISS_CHAR,
123 ATTRIBUTE4 VARCHAR2(450) := FND_API.G_MISS_CHAR,
124 ATTRIBUTE5 VARCHAR2(450) := FND_API.G_MISS_CHAR,
125 ATTRIBUTE6 VARCHAR2(450) := FND_API.G_MISS_CHAR,
126 ATTRIBUTE7 VARCHAR2(450) := FND_API.G_MISS_CHAR,
127 ATTRIBUTE8 VARCHAR2(450) := FND_API.G_MISS_CHAR,
128 ATTRIBUTE9 VARCHAR2(450) := FND_API.G_MISS_CHAR,
129 ATTRIBUTE10 VARCHAR2(450) := FND_API.G_MISS_CHAR,
130 ATTRIBUTE11 VARCHAR2(450) := FND_API.G_MISS_CHAR,
131 ATTRIBUTE12 VARCHAR2(450) := FND_API.G_MISS_CHAR,
132 ATTRIBUTE13 VARCHAR2(450) := FND_API.G_MISS_CHAR,
133 ATTRIBUTE14 VARCHAR2(450) := FND_API.G_MISS_CHAR,
134 ATTRIBUTE15 VARCHAR2(450) := FND_API.G_MISS_CHAR,
135 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
136 CREATION_DATE DATE := FND_API.G_MISS_DATE,
137 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
138 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
139 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
140 , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
141 , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
142 , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
143 , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
144 , DISPOSITION_CODE VARCHAR2(30):= FND_API.G_MISS_CHAR,
145 TURN_OFF_INVOICE_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
146 NOTICE_ASSIGNMENT_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
147 FILE_PROOF_CLAIM_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
148 REQUEST_REPURCHASE_YN VARCHAR2(1) := FND_API.G_MISS_CHAR,
149 FEE_PAID_DATE DATE := FND_API.G_MISS_DATE,
150 REAFFIRMATION_DATE DATE := FND_API.G_MISS_DATE,
151 RELIEF_STAY_DATE DATE := FND_API.G_MISS_DATE,
152 FILE_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
153 CASE_NUMBER VARCHAR2(100) := FND_API.G_MISS_CHAR
154 );
155
156 G_MISS_bankruptcy_REC bankruptcy_Rec_Type;
157 TYPE bankruptcy_Tbl_Type IS TABLE OF bankruptcy_Rec_Type
158 INDEX BY BINARY_INTEGER;
159 G_MISS_bankruptcy_TBL bankruptcy_Tbl_Type;
160
161 -- *******************************************************
162 -- Start of Comments
163 -- *******************************************************
164 -- API Name: Create_bankruptcy
165 -- Type : Private
166 -- Pre-Req :
167 -- Parameters:
168 -- IN
169 -- p_api_version_number IN NUMBER Required
170 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173 -- P_bankruptcy_Rec IN bankruptcy_Rec_Type Required
174 -- OUT:
175 -- x_return_status OUT NOCOPY VARCHAR2
176 -- x_msg_count OUT NOCOPY NUMBER
177 -- x_msg_data OUT NOCOPY VARCHAR2
178 -- Version : Current version 2.0
179 -- End of Comments
180 --
181 PROCEDURE Create_bankruptcy(
182 P_Api_Version_Number IN NUMBER,
183 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
184 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186 P_bankruptcy_Rec IN bankruptcy_Rec_Type := G_MISS_bankruptcy_REC,
187 X_BANKRUPTCY_ID OUT NOCOPY NUMBER,
188 X_Return_Status OUT NOCOPY VARCHAR2,
189 X_Msg_Count OUT NOCOPY NUMBER,
190 X_Msg_Data OUT NOCOPY VARCHAR2
191 );
192
193 -- *******************************************************
194 -- Start of Comments
195 -- *******************************************************
196 -- API Name: Update_bankruptcy
197 -- Type : Private
198 -- Pre-Req :
199 -- Parameters:
200 -- IN
201 -- p_api_version_number IN NUMBER Required
202 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
203 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
204 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
205 -- P_bankruptcy_Rec IN bankruptcy_Rec_Type Required
206 -- OUT:
207 -- x_return_status OUT NOCOPY VARCHAR2
208 -- x_msg_count OUT NOCOPY NUMBER
209 -- x_msg_data OUT NOCOPY VARCHAR2
210 -- xo_object_version_number OUT NOCOPY NUMBER
211 -- Version : Current version 2.0
212 -- End of Comments
213 --
214 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
215 PROCEDURE Update_bankruptcy(
216 P_Api_Version_Number IN NUMBER,
217 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220 P_bankruptcy_Rec IN bankruptcy_Rec_Type,
221 X_Return_Status OUT NOCOPY VARCHAR2,
222 X_Msg_Count OUT NOCOPY NUMBER,
223 X_Msg_Data OUT NOCOPY VARCHAR2,
224 xo_object_version_number OUT NOCOPY NUMBER
225 );
226
227 -- *******************************************************
228 -- Start of Comments
229 -- *******************************************************
230 -- API Name: Delete_bankruptcy
231 -- Type : Private
232 -- Pre-Req :
233 -- Parameters:
234 -- IN
235 -- p_api_version_number IN NUMBER Required
236 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
237 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
238 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
239 -- P_bankruptcy_Rec IN bankruptcy_Rec_Type Required
240 -- OUT:
241 -- x_return_status OUT NOCOPY VARCHAR2
242 -- x_msg_count OUT NOCOPY NUMBER
243 -- x_msg_data OUT NOCOPY VARCHAR2
244 -- Version : Current version 2.0
245 -- End of Comments
246 --
247 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
248 -- The Master delete procedure may not be needed depends on different business requirements.
249 PROCEDURE Delete_bankruptcy(
250 P_Api_Version_Number IN NUMBER,
251 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
252 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 P_bankruptcy_Id IN NUMBER,
255 X_Return_Status OUT NOCOPY VARCHAR2,
256 X_Msg_Count OUT NOCOPY NUMBER,
257 X_Msg_Data OUT NOCOPY VARCHAR2
258 );
259
260
261 End IEX_BANKRUPTCIES_PVT;