[Home] [Help]
PACKAGE: APPS.OKL_CHD_PVT
Source
1 PACKAGE OKL_CHD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCHDS.pls 115.4 2003/04/19 20:21:32 pdevaraj noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CURE_REFUND_HEADERS_V Record Spec
7 TYPE chdv_rec_type IS RECORD (
8 cure_refund_header_id NUMBER := OKL_API.G_MISS_NUM
9 ,refund_header_number OKL_CURE_REFUND_HEADERS_V.REFUND_HEADER_NUMBER%TYPE := OKL_API.G_MISS_CHAR
10 ,refund_type OKL_CURE_REFUND_HEADERS_V.REFUND_TYPE%TYPE := OKL_API.G_MISS_CHAR
11 ,refund_due_date OKL_CURE_REFUND_HEADERS_V.REFUND_DUE_DATE%TYPE := OKL_API.G_MISS_DATE
15 ,RECEIVED_AMOUNT NUMBER := OKL_API.G_MISS_NUM
12 ,currency_code OKL_CURE_REFUND_HEADERS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
13 ,total_refund_due NUMBER := OKL_API.G_MISS_NUM
14 ,disbursement_amount NUMBER := OKL_API.G_MISS_NUM
16 ,OFFSET_AMOUNT NUMBER := OKL_API.G_MISS_NUM
17 ,NEGOTIATED_AMOUNT NUMBER := OKL_API.G_MISS_NUM
18 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
19 ,refund_status OKL_CURE_REFUND_HEADERS_V.REFUND_STATUS%TYPE := OKL_API.G_MISS_CHAR
20 ,payment_method OKL_CURE_REFUND_HEADERS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR
21 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
22 ,sfwt_flag OKL_CURE_REFUND_HEADERS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
23 ,description OKL_CURE_REFUND_HEADERS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
24 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
25 ,vendor_cure_due NUMBER := OKL_API.G_MISS_NUM
26 ,vendor_site_cure_due NUMBER := OKL_API.G_MISS_NUM
27 ,chr_id NUMBER := OKL_API.G_MISS_NUM
28 ,program_id NUMBER := OKL_API.G_MISS_NUM
29 ,request_id NUMBER := OKL_API.G_MISS_NUM
30 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
31 ,program_update_date OKL_CURE_REFUND_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32 ,attribute_category OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute1 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute2 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute3 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute4 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute5 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute6 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute7 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute8 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute9 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute10 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
43 ,attribute11 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
44 ,attribute12 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
45 ,attribute13 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute14 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute15 OKL_CURE_REFUND_HEADERS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
48 ,created_by NUMBER := OKL_API.G_MISS_NUM
49 ,creation_date OKL_CURE_REFUND_HEADERS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
50 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
51 ,last_update_date OKL_CURE_REFUND_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
52 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
53 G_MISS_chdv_rec chdv_rec_type;
54 TYPE chdv_tbl_type IS TABLE OF chdv_rec_type
55 INDEX BY BINARY_INTEGER;
56 -- OKL_CURE_REFUND_HEADERS_B Record Spec
57 TYPE chd_rec_type IS RECORD (
58 cure_refund_header_id NUMBER := OKL_API.G_MISS_NUM
59 ,refund_header_number OKL_CURE_REFUND_HEADERS_B.REFUND_HEADER_NUMBER%TYPE := OKL_API.G_MISS_CHAR
60 ,refund_type OKL_CURE_REFUND_HEADERS_B.REFUND_TYPE%TYPE := OKL_API.G_MISS_CHAR
61 ,refund_due_date OKL_CURE_REFUND_HEADERS_B.REFUND_DUE_DATE%TYPE := OKL_API.G_MISS_DATE
62 ,currency_code OKL_CURE_REFUND_HEADERS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
63 ,total_refund_due NUMBER := OKL_API.G_MISS_NUM
64 ,disbursement_amount NUMBER := OKL_API.G_MISS_NUM
65 ,RECEIVED_AMOUNT NUMBER := OKL_API.G_MISS_NUM
66 ,OFFSET_AMOUNT NUMBER := OKL_API.G_MISS_NUM
67 ,NEGOTIATED_AMOUNT NUMBER := OKL_API.G_MISS_NUM
68 ,vendor_site_id NUMBER := OKL_API.G_MISS_NUM
69 ,refund_status OKL_CURE_REFUND_HEADERS_B.REFUND_STATUS%TYPE := OKL_API.G_MISS_CHAR
70 ,payment_method OKL_CURE_REFUND_HEADERS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR
71 ,payment_term_id NUMBER := OKL_API.G_MISS_NUM
72 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
73 ,vendor_cure_due NUMBER := OKL_API.G_MISS_NUM
74 ,vendor_site_cure_due NUMBER := OKL_API.G_MISS_NUM
75 ,chr_id NUMBER := OKL_API.G_MISS_NUM
76 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
77 ,request_id NUMBER := OKL_API.G_MISS_NUM
78 ,program_id NUMBER := OKL_API.G_MISS_NUM
79 ,program_update_date OKL_CURE_REFUND_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
80 ,attribute_category OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
81 ,attribute1 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
82 ,attribute2 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
83 ,attribute3 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
87 ,attribute7 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
84 ,attribute4 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
85 ,attribute5 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
86 ,attribute6 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88 ,attribute8 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
89 ,attribute9 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
90 ,attribute10 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
91 ,attribute11 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
92 ,attribute12 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
93 ,attribute13 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
94 ,attribute14 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
95 ,attribute15 OKL_CURE_REFUND_HEADERS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
96 ,created_by NUMBER := OKL_API.G_MISS_NUM
97 ,creation_date OKL_CURE_REFUND_HEADERS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
98 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
99 ,last_update_date OKL_CURE_REFUND_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
101 G_MISS_chd_rec chd_rec_type;
102 TYPE chd_tbl_type IS TABLE OF chd_rec_type
103 INDEX BY BINARY_INTEGER;
104 -- OKL_CURE_REFUND_HEADERS_TL Record Spec
105 TYPE OklCureRefundHeadersTlRecType IS RECORD (
106 cure_refund_header_id NUMBER := OKL_API.G_MISS_NUM
107 ,language OKL_CURE_REFUND_HEADERS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
108 ,source_lang OKL_CURE_REFUND_HEADERS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
109 ,sfwt_flag OKL_CURE_REFUND_HEADERS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
110 ,description OKL_CURE_REFUND_HEADERS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
111 ,created_by NUMBER := OKL_API.G_MISS_NUM
112 ,creation_date OKL_CURE_REFUND_HEADERS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
113 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
114 ,last_update_date OKL_CURE_REFUND_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
115 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
116 GMissOklCureRefundHeadersTlRec OklCureRefundHeadersTlRecType;
117 TYPE OklCureRefundHeadersTlTblType IS TABLE OF OklCureRefundHeadersTlRecType
118 INDEX BY BINARY_INTEGER;
119 ---------------------------------------------------------------------------
120 -- GLOBAL MESSAGE CONSTANTS
121 ---------------------------------------------------------------------------
122 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
123 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
124 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
125 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
126 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
127 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
128 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
129 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
130 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
131 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
132 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
133 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
134 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
135
136 ---------------------------------------------------------------------------
137 -- GLOBAL EXCEPTIONS
138 ---------------------------------------------------------------------------
139 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
140
141 ---------------------------------------------------------------------------
142 -- GLOBAL VARIABLES
143 ---------------------------------------------------------------------------
144 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CHD_PVT';
145 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
146 ---------------------------------------------------------------------------
147 -- Procedures and Functions
148 ---------------------------------------------------------------------------
149
150 PROCEDURE qc;
151 PROCEDURE change_version;
152 PROCEDURE api_copy;
153 PROCEDURE add_language;
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_chdv_rec IN chdv_rec_type,
161 x_chdv_rec OUT NOCOPY chdv_rec_type);
162 PROCEDURE insert_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_chdv_tbl IN chdv_tbl_type,
169 x_chdv_tbl OUT NOCOPY chdv_tbl_type,
170 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
171 PROCEDURE insert_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_chdv_tbl IN chdv_tbl_type,
178 x_chdv_tbl OUT NOCOPY chdv_tbl_type);
179 PROCEDURE lock_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_chdv_rec IN chdv_rec_type);
186 PROCEDURE lock_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_chdv_tbl IN chdv_tbl_type,
193 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
194 PROCEDURE lock_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_chdv_tbl IN chdv_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_chdv_rec IN chdv_rec_type,
208 x_chdv_rec OUT NOCOPY chdv_rec_type);
209 PROCEDURE update_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_chdv_tbl IN chdv_tbl_type,
216 x_chdv_tbl OUT NOCOPY chdv_tbl_type,
217 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
218 PROCEDURE update_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_chdv_tbl IN chdv_tbl_type,
225 x_chdv_tbl OUT NOCOPY chdv_tbl_type);
226 PROCEDURE delete_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_chdv_rec IN chdv_rec_type);
233 PROCEDURE delete_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_chdv_tbl IN chdv_tbl_type,
240 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
241 PROCEDURE delete_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_chdv_tbl IN chdv_tbl_type);
248 PROCEDURE validate_row(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_chdv_rec IN chdv_rec_type);
255 PROCEDURE validate_row(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_chdv_tbl IN chdv_tbl_type,
262 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
263 PROCEDURE validate_row(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_chdv_tbl IN chdv_tbl_type);
270 END OKL_CHD_PVT;