[Home] [Help]
PACKAGE: APPS.OKL_CRA_PVT
Source
1 PACKAGE OKL_CRA_PVT AS
2 /* $Header: OKLSCRAS.pls 120.2 2008/02/28 07:18:58 asawanka ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CURE_REPORT_AMOUNTS Record Spec
7 TYPE crav_rec_type IS RECORD (
8 cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
9 ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
10 ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
11 ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
12 ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
13 ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
14 ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
15 ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
16 ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
17 ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
18 ,times_cured NUMBER := OKL_API.G_MISS_NUM
19 ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
20 ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
21 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
22 ,org_id NUMBER := OKL_API.G_MISS_NUM
23 ,request_id NUMBER := OKL_API.G_MISS_NUM
24 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
25 ,program_id NUMBER := OKL_API.G_MISS_NUM
26 ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
27 ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
43 ,created_by NUMBER := OKL_API.G_MISS_NUM
44 ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
45 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
46 ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
47 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
48 G_MISS_crav_rec crav_rec_type;
49 TYPE crav_tbl_type IS TABLE OF crav_rec_type
50 INDEX BY BINARY_INTEGER;
51 -- OKL_CURE_REPORT_AMOUNTS Record Spec
52 TYPE cra_rec_type IS RECORD (
53 cure_report_amount_id NUMBER := OKL_API.G_MISS_NUM
54 ,cure_amount_id NUMBER := OKL_API.G_MISS_NUM
55 ,cure_report_id NUMBER := OKL_API.G_MISS_NUM
56 ,request_type OKL_CURE_REPORT_AMOUNTS.REQUEST_TYPE%TYPE := OKL_API.G_MISS_CHAR
57 ,cures_in_possession NUMBER := OKL_API.G_MISS_NUM
58 ,claimed_cure_amount NUMBER := OKL_API.G_MISS_NUM
59 ,past_due_amount NUMBER := OKL_API.G_MISS_NUM
60 ,eligible_cure_amount NUMBER := OKL_API.G_MISS_NUM
61 ,repurchase_amount NUMBER := OKL_API.G_MISS_NUM
62 ,outstanding_amount NUMBER := OKL_API.G_MISS_NUM
63 ,times_cured NUMBER := OKL_API.G_MISS_NUM
64 ,payments_remaining NUMBER := OKL_API.G_MISS_NUM
65 ,status OKL_CURE_REPORT_AMOUNTS.STATUS%TYPE := OKL_API.G_MISS_CHAR
66 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
67 ,org_id NUMBER := OKL_API.G_MISS_NUM
68 ,request_id NUMBER := OKL_API.G_MISS_NUM
69 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
70 ,program_id NUMBER := OKL_API.G_MISS_NUM
71 ,program_update_date OKL_CURE_REPORT_AMOUNTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
72 ,attribute_category OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
73 ,attribute1 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
74 ,attribute2 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
75 ,attribute3 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
76 ,attribute4 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
77 ,attribute5 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute6 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute7 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute8 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute9 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute10 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute11 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute12 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute13 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute14 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute15 OKL_CURE_REPORT_AMOUNTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
88 ,created_by NUMBER := OKL_API.G_MISS_NUM
89 ,creation_date OKL_CURE_REPORT_AMOUNTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
90 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
91 ,last_update_date OKL_CURE_REPORT_AMOUNTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
93 G_MISS_cra_rec cra_rec_type;
94 TYPE cra_tbl_type IS TABLE OF cra_rec_type
95 INDEX BY BINARY_INTEGER;
96 ---------------------------------------------------------------------------
97 -- GLOBAL MESSAGE CONSTANTS
98 ---------------------------------------------------------------------------
99 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
100 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
101 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
102 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
103 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
104 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
105 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
106 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
107 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
108 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
109 ---------------------------------------------------------------------------
110 -- GLOBAL EXCEPTIONS
111 ---------------------------------------------------------------------------
112 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
113
114 ---------------------------------------------------------------------------
115 -- GLOBAL VARIABLES
116 ---------------------------------------------------------------------------
117 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRA_PVT';
118 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
119 -------------------------------------------------------------------------------
120 --Post change to TAPI code
121 -------------------------------------------------------------------------------
122 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
123 G_CANNOT_UPDATE_REQUEST CONSTANT VARCHAR2(200) := 'OKL_CANNOT_UPDATE_REQUEST';
124 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
125 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
126 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
127 ---------------------------------------------------------------------------
128 -- GLOBAL MESSAGE CONSTANTS
129 --Post change to TAPI code
130 ---------------------------------------------------------------------------
131 -- Procedures and Functions
132 ---------------------------------------------------------------------------
133
134 PROCEDURE qc;
135 PROCEDURE change_version;
136 PROCEDURE api_copy;
137 PROCEDURE insert_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_crav_rec IN crav_rec_type,
144 x_crav_rec OUT NOCOPY crav_rec_type);
145 PROCEDURE insert_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_crav_tbl IN crav_tbl_type,
152 x_crav_tbl OUT NOCOPY crav_tbl_type,
153 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154 PROCEDURE insert_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_crav_tbl IN crav_tbl_type,
161 x_crav_tbl OUT NOCOPY crav_tbl_type);
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_crav_rec IN crav_rec_type);
169 PROCEDURE lock_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_crav_tbl IN crav_tbl_type,
176 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177 PROCEDURE lock_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_crav_tbl IN crav_tbl_type);
184 PROCEDURE update_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_crav_rec IN crav_rec_type,
191 x_crav_rec OUT NOCOPY crav_rec_type);
192 PROCEDURE update_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_crav_tbl IN crav_tbl_type,
199 x_crav_tbl OUT NOCOPY crav_tbl_type,
200 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
201 PROCEDURE update_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_crav_tbl IN crav_tbl_type,
208 x_crav_tbl OUT NOCOPY crav_tbl_type);
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_crav_rec IN crav_rec_type);
216 PROCEDURE delete_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_crav_tbl IN crav_tbl_type,
223 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
224 PROCEDURE delete_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_crav_tbl IN crav_tbl_type);
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_crav_rec IN crav_rec_type);
238 PROCEDURE validate_row(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_crav_tbl IN crav_tbl_type,
245 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
246 PROCEDURE validate_row(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_crav_tbl IN crav_tbl_type);
253 END OKL_CRA_PVT;