[Home] [Help]
PACKAGE: APPS.IEX_WRITEOFFS_PVT
Source
1 PACKAGE IEX_WRITEOFFS_PVT as
2 /* $Header: iexvwros.pls 120.1 2007/10/31 14:45:25 ehuh ship $ */
3 -- Start of Comments
4 -- Package name : IEX_writeoffs_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:writeoffs_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- WRITEOFF_ID
19 -- PARTY_ID
20 -- DELINQUENCY_ID
21 -- CAS_ID
22 -- CUST_ACCOUNT_ID
23 -- DISPOSITION_CODE
24 -- OBJECT_ID
25 -- OBJECT_CODE
26 -- WRITEOFF_TYPE
27 -- ACTIVE_FLAG
28 -- OBJECT_VERSION_NUMBER
29 -- WRITEOFF_REASON
30 -- WRITEOFF_AMOUNT
31 -- WRITEOFF_CURRENCY_CODE
32 -- WRITEOFF_DATE
33 -- WRITEOFF_REQUEST_DATE
34 -- WRITEOFF_PROCESS
35 -- WRITEOFF_SCORE
36 -- BAD_DEBT_REASON
37 -- LEASING_CODE
38 -- REPOSSES_SCH_DATE
39 -- REPOSSES_COMP_DATE
40 -- CREDIT_HOLD_YN
41 -- APPROVER_ID
42 -- EXTERNAL_AGENT_ID
43 -- PROCEDURE_CODE
44 -- CHECKLIST_CODE
45 -- REQUEST_ID
46 -- PROGRAM_APPLICATION_ID
47 -- PROGRAM_ID
48 -- PROGRAM_UPDATE_DATE
49 -- ATTRIBUTE_CATEGORY
50 -- ATTRIBUTE1
51 -- ATTRIBUTE2
52 -- ATTRIBUTE3
53 -- ATTRIBUTE4
54 -- ATTRIBUTE5
55 -- ATTRIBUTE6
56 -- ATTRIBUTE7
57 -- ATTRIBUTE8
58 -- ATTRIBUTE9
59 -- ATTRIBUTE10
60 -- ATTRIBUTE11
61 -- ATTRIBUTE12
62 -- ATTRIBUTE13
63 -- ATTRIBUTE14
64 -- ATTRIBUTE15
65 -- CREATED_BY
66 -- CREATION_DATE
67 -- LAST_UPDATED_BY
68 -- LAST_UPDATE_DATE
69 -- LAST_UPDATE_LOGIN
70 -- CREDIT_HOLD_REQUEST_FLAG
71 -- CREDIT_HOLD_APPROVED_FLAG
72 -- SERVICE_HOLD_REQUEST_FLAG
73 -- SERVICE_HOLD_APPROVED_FLAG
74 -- SUGGESTION_APPROVED_FLAG
75 --
76 --
77 -- End of Comments
78
79 TYPE writeoffs_Rec_Type IS RECORD
80 (
81 WRITEOFF_ID NUMBER := FND_API.G_MISS_NUM,
82 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
83 DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
84 CAS_ID NUMBER := FND_API.G_MISS_NUM,
85 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
86 DISPOSITION_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
88 OBJECT_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
89 WRITEOFF_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
90 ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
91 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
92 WRITEOFF_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
93 WRITEOFF_AMOUNT NUMBER := FND_API.G_MISS_NUM,
94 WRITEOFF_CURRENCY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
95 WRITEOFF_DATE DATE := FND_API.G_MISS_DATE,
96 WRITEOFF_REQUEST_DATE DATE := FND_API.G_MISS_DATE,
97 WRITEOFF_PROCESS VARCHAR2(240) := FND_API.G_MISS_CHAR,
98 WRITEOFF_SCORE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99 BAD_DEBT_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
100 LEASING_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 REPOSSES_SCH_DATE DATE := FND_API.G_MISS_DATE,
102 REPOSSES_COMP_DATE DATE := FND_API.G_MISS_DATE,
103 CREDIT_HOLD_YN VARCHAR2(240) := FND_API.G_MISS_CHAR,
104 APPROVER_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
105 EXTERNAL_AGENT_ID VARCHAR2(240) := FND_API.G_MISS_CHAR,
106 PROCEDURE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
107 CHECKLIST_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
108 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
109 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
110 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
111 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
112 ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
113 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
114 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
115 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
116 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
117 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
118 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
119 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
120 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
121 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
122 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
123 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
129 CREATION_DATE DATE := FND_API.G_MISS_DATE,
130 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
131 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
132 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
133 , CREDIT_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
134 , CREDIT_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
135 , SERVICE_HOLD_REQUEST_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
136 , SERVICE_HOLD_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
137 , SUGGESTION_APPROVED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
138 , CUSTOMER_SITE_USE_ID NUMBER := FND_API.G_MISS_NUM
139 , ORG_ID NUMBER := FND_API.G_MISS_NUM
140 , CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
141 , CONTRACT_NUMBER VARCHAR2(250) := FND_API.G_MISS_CHAR
142 );
143
144 G_MISS_writeoffs_REC writeoffs_Rec_Type;
145 TYPE writeoffs_Tbl_Type IS TABLE OF writeoffs_Rec_Type
146 INDEX BY BINARY_INTEGER;
147 G_MISS_writeoffs_TBL writeoffs_Tbl_Type;
148
149 -- *******************************************************
150 -- Start of Comments
151 -- *******************************************************
152 -- API Name: Create_writeoffs
153 -- Type : Private
154 -- Pre-Req :
155 -- Parameters:
156 -- IN
157 -- p_api_version_number IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161 -- P_writeoffs_Rec IN writeoffs_Rec_Type Required
162 --
163 -- OUT:
164 -- x_return_status OUT NOCOPY VARCHAR2
165 -- x_msg_count OUT NOCOPY NUMBER
166 -- x_msg_data OUT NOCOPY VARCHAR2
167 -- Version : Current version 2.0
168 -- End of Comments
169 --
170 PROCEDURE Create_writeoffs(
171 P_Api_Version_Number IN NUMBER,
172 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 P_writeoffs_Rec IN writeoffs_Rec_Type := G_MISS_writeoffs_REC,
176 X_WRITEOFF_ID OUT NOCOPY NUMBER,
177 X_Return_Status OUT NOCOPY VARCHAR2,
178 X_Msg_Count OUT NOCOPY NUMBER,
179 X_Msg_Data OUT NOCOPY VARCHAR2
180 );
181
182 -- *******************************************************
183 -- Start of Comments
184 -- *******************************************************
185 -- API Name: Update_writeoffs
186 -- Type : Private
187 -- Pre-Req :
188 -- Parameters:
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194 -- P_writeoffs_Rec IN writeoffs_Rec_Type Required
195 --
196 -- OUT:
197 -- x_return_status OUT NOCOPY VARCHAR2
198 -- x_msg_count OUT NOCOPY NUMBER
199 -- x_msg_data OUT NOCOPY VARCHAR2
200 -- Version : Current version 2.0
201 --
202 -- End of Comments
203 --
204 PROCEDURE Update_writeoffs(
205 P_Api_Version_Number IN NUMBER,
206 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 P_writeoffs_Rec IN writeoffs_Rec_Type,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2,
213 xo_object_version_number OUT NOCOPY NUMBER
214 );
215
216 -- *******************************************************
217 -- Start of Comments
218 -- *******************************************************
219 -- API Name: Delete_writeoffs
220 -- Type : Private
221 -- Pre-Req :
222 -- Parameters:
223 -- IN
224 -- p_api_version_number IN NUMBER Required
225 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228 -- P_writeoff_id IN NUMBER required
229 --
230 -- OUT:
231 -- x_return_status OUT NOCOPY VARCHAR2
232 -- x_msg_count OUT NOCOPY NUMBER
233 -- x_msg_data OUT NOCOPY VARCHAR2
234 -- Version : Current version 2.0
235 --
236 -- End of Comments
237 --
238 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
239 -- The Master delete procedure may not be needed depends on different business requirements.
240 PROCEDURE Delete_writeoffs(
241 P_Api_Version_Number IN NUMBER,
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 P_writeoff_id IN NUMBER,
246 X_Return_Status OUT NOCOPY VARCHAR2,
247 X_Msg_Count OUT NOCOPY NUMBER,
248 X_Msg_Data OUT NOCOPY VARCHAR2
249 );
250
251
252 End IEX_WRITEOFFS_PVT;