[Home] [Help]
PACKAGE: APPS.OKL_CRF_PVT
Source
1 PACKAGE OKL_CRF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCRFS.pls 120.2 2006/07/11 10:18:06 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CURE_REFUNDS_V Record Spec
7 TYPE crfv_rec_type IS RECORD (
8 cure_refund_id NUMBER := OKL_API.G_MISS_NUM
9 ,refund_number OKL_CURE_REFUNDS.REFUND_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10 ,status OKL_CURE_REFUNDS.STATUS%TYPE := OKL_API.G_MISS_CHAR
11 ,amount NUMBER := OKL_API.G_MISS_NUM
12 ,balance NUMBER := OKL_API.G_MISS_NUM
13 ,tap_id NUMBER := OKL_API.G_MISS_NUM
14 ,tai_id NUMBER := OKL_API.G_MISS_NUM
15 ,CURE_REFUND_STAGE_ID NUMBER := OKL_API.G_MISS_NUM
16 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
17 ,chr_id NUMBER := OKL_API.G_MISS_NUM
18 ,disbursement_amount NUMBER := OKL_API.G_MISS_NUM
19 ,offset_amount NUMBER := OKL_API.G_MISS_NUM
20 ,offset_contract NUMBER := OKL_API.G_MISS_NUM
21 ,total_refund_due NUMBER := OKL_API.G_MISS_NUM
22 ,refund_date OKL_CURE_REFUNDS.REFUND_DATE%TYPE := OKL_API.G_MISS_DATE
23 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24 ,program_id NUMBER := OKL_API.G_MISS_NUM
25 ,request_id NUMBER := OKL_API.G_MISS_NUM
26 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
27 ,program_update_date OKL_CURE_REFUNDS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
28 ,attribute_category OKL_CURE_REFUNDS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute1 OKL_CURE_REFUNDS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute2 OKL_CURE_REFUNDS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute3 OKL_CURE_REFUNDS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute4 OKL_CURE_REFUNDS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute5 OKL_CURE_REFUNDS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute6 OKL_CURE_REFUNDS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute7 OKL_CURE_REFUNDS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute8 OKL_CURE_REFUNDS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute9 OKL_CURE_REFUNDS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute10 OKL_CURE_REFUNDS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute11 OKL_CURE_REFUNDS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute12 OKL_CURE_REFUNDS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute13 OKL_CURE_REFUNDS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute14 OKL_CURE_REFUNDS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
43 ,attribute15 OKL_CURE_REFUNDS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
44 ,created_by NUMBER := OKL_API.G_MISS_NUM
45 ,creation_date OKL_CURE_REFUNDS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
46 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
47 ,last_update_date OKL_CURE_REFUNDS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
48 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
49 ,cure_refund_header_id NUMBER := OKL_API.G_MISS_NUM
50 ,received_amount NUMBER := OKL_API.G_MISS_NUM
51 );
52 G_MISS_crfv_rec crfv_rec_type;
53 TYPE crfv_tbl_type IS TABLE OF crfv_rec_type
54 INDEX BY BINARY_INTEGER;
55 -- OKL_CURE_REFUNDS Record Spec
56 TYPE crf_rec_type IS RECORD (
57 cure_refund_id NUMBER := OKL_API.G_MISS_NUM
58 ,refund_number OKL_CURE_REFUNDS.REFUND_NUMBER%TYPE := OKL_API.G_MISS_CHAR
59 ,status OKL_CURE_REFUNDS.STATUS%TYPE := OKL_API.G_MISS_CHAR
60 ,amount NUMBER := OKL_API.G_MISS_NUM
61 ,balance NUMBER := OKL_API.G_MISS_NUM
62 ,tap_id NUMBER := OKL_API.G_MISS_NUM
63 ,tai_id NUMBER := OKL_API.G_MISS_NUM
64 ,CURE_REFUND_STAGE_ID NUMBER := OKL_API.G_MISS_NUM
65 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
66 ,chr_id NUMBER := OKL_API.G_MISS_NUM
67 ,disbursement_amount NUMBER := OKL_API.G_MISS_NUM
68 ,offset_amount NUMBER := OKL_API.G_MISS_NUM
69 ,offset_contract NUMBER := OKL_API.G_MISS_NUM
70 ,total_refund_due NUMBER := OKL_API.G_MISS_NUM
71 ,refund_date OKL_CURE_REFUNDS.REFUND_DATE%TYPE := OKL_API.G_MISS_DATE
72 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
73 ,request_id NUMBER := OKL_API.G_MISS_NUM
74 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
75 ,program_id NUMBER := OKL_API.G_MISS_NUM
76 ,program_update_date OKL_CURE_REFUNDS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
77 ,attribute_category OKL_CURE_REFUNDS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
78 ,attribute1 OKL_CURE_REFUNDS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
79 ,attribute2 OKL_CURE_REFUNDS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
80 ,attribute3 OKL_CURE_REFUNDS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute4 OKL_CURE_REFUNDS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute5 OKL_CURE_REFUNDS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute6 OKL_CURE_REFUNDS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute7 OKL_CURE_REFUNDS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute8 OKL_CURE_REFUNDS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute9 OKL_CURE_REFUNDS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute10 OKL_CURE_REFUNDS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
88 ,attribute11 OKL_CURE_REFUNDS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
89 ,attribute12 OKL_CURE_REFUNDS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
90 ,attribute13 OKL_CURE_REFUNDS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
91 ,attribute14 OKL_CURE_REFUNDS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
92 ,attribute15 OKL_CURE_REFUNDS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
93 ,created_by NUMBER := OKL_API.G_MISS_NUM
94 ,creation_date OKL_CURE_REFUNDS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
95 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
96 ,last_update_date OKL_CURE_REFUNDS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
97 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
98 ,cure_refund_header_id NUMBER := OKL_API.G_MISS_NUM
99 ,received_amount NUMBER := OKL_API.G_MISS_NUM);
100 G_MISS_crf_rec crf_rec_type;
101 TYPE crf_tbl_type IS TABLE OF crf_rec_type
102 INDEX BY BINARY_INTEGER;
103 ---------------------------------------------------------------------------
104 -- GLOBAL MESSAGE CONSTANTS
105 ---------------------------------------------------------------------------
106 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
107 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
108 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
109 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
110 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
111 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
112 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
113 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
114 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
115 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
116 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
117 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
118 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
119
120 ---------------------------------------------------------------------------
121 -- GLOBAL EXCEPTIONS
122 ---------------------------------------------------------------------------
123 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
124
125 ---------------------------------------------------------------------------
126 -- GLOBAL VARIABLES
127 ---------------------------------------------------------------------------
128 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRF_PVT';
129 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
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_crfv_rec IN crfv_rec_type,
144 x_crfv_rec OUT NOCOPY crfv_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_crfv_tbl IN crfv_tbl_type,
152 x_crfv_tbl OUT NOCOPY crfv_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_crfv_tbl IN crfv_tbl_type,
161 x_crfv_tbl OUT NOCOPY crfv_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_crfv_rec IN crfv_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_crfv_tbl IN crfv_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_crfv_tbl IN crfv_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_crfv_rec IN crfv_rec_type,
191 x_crfv_rec OUT NOCOPY crfv_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_crfv_tbl IN crfv_tbl_type,
199 x_crfv_tbl OUT NOCOPY crfv_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_crfv_tbl IN crfv_tbl_type,
208 x_crfv_tbl OUT NOCOPY crfv_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_crfv_rec IN crfv_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_crfv_tbl IN crfv_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_crfv_tbl IN crfv_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_crfv_rec IN crfv_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_crfv_tbl IN crfv_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_crfv_tbl IN crfv_tbl_type);
253 END OKL_CRF_PVT;