[Home] [Help]
PACKAGE: APPS.OKL_TAX_PVT
Source
1 PACKAGE OKL_TAX_PVT AS
2 /* $Header: OKLSTAXS.pls 120.3 2006/07/11 10:31:36 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TAX_LINES_V Record Spec
7 TYPE OKL_TAX_LINES_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,khr_id NUMBER := OKC_API.G_MISS_NUM
10 ,kle_id NUMBER := OKC_API.G_MISS_NUM
11 ,asset_id NUMBER := OKC_API.G_MISS_NUM
12 ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13 ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14 ,sel_id NUMBER := OKC_API.G_MISS_NUM
15 ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,tax_type NUMBER := OKC_API.G_MISS_NUM
17 ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18 ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19 ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21 ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22 ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23 ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24 ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26 ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27 ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28 ,org_id NUMBER := OKC_API.G_MISS_NUM
29 ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30 ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31 ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32 ,trq_id NUMBER := OKC_API.G_MISS_NUM
33 ,program_id NUMBER := OKC_API.G_MISS_NUM
34 ,request_id NUMBER := OKC_API.G_MISS_NUM
35 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36 ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37 ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39 ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40 ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41 ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42 ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43 ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44 ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45 ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46 ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47 ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48 ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49 ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50 ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51 ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52 ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53 ,created_by NUMBER := OKC_API.G_MISS_NUM
54 ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56 ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
58 G_MISS_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
59 TYPE OKL_TAX_LINES_tbl_type IS TABLE OF OKL_TAX_LINES_rec_type
60 INDEX BY BINARY_INTEGER;
61 -- OKL_TAX_LINES Record Spec
62 TYPE tax_rec_type IS RECORD (
63 id NUMBER := OKC_API.G_MISS_NUM
64 ,khr_id NUMBER := OKC_API.G_MISS_NUM
65 ,kle_id NUMBER := OKC_API.G_MISS_NUM
66 ,asset_id NUMBER := OKC_API.G_MISS_NUM
67 ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68 ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69 ,sel_id NUMBER := OKC_API.G_MISS_NUM
70 ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71 ,tax_type NUMBER := OKC_API.G_MISS_NUM
72 ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73 ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74 ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75 ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76 ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77 ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78 ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79 ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80 ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81 ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82 ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83 ,org_id NUMBER := OKC_API.G_MISS_NUM
84 ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85 ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86 ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87 ,trq_id NUMBER := OKC_API.G_MISS_NUM
88 ,program_id NUMBER := OKC_API.G_MISS_NUM
89 ,request_id NUMBER := OKC_API.G_MISS_NUM
90 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91 ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92 ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93 ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94 ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95 ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96 ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97 ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98 ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99 ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100 ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101 ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102 ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103 ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104 ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105 ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106 ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107 ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108 ,created_by NUMBER := OKC_API.G_MISS_NUM
109 ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111 ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
113 G_MISS_tax_rec tax_rec_type;
114 TYPE tax_tbl_type IS TABLE OF tax_rec_type
115 INDEX BY BINARY_INTEGER;
116 ---------------------------------------------------------------------------
117 -- GLOBAL MESSAGE CONSTANTS
118 ---------------------------------------------------------------------------
119 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
129 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
130 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
131 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
132
133 ---------------------------------------------------------------------------
134 -- GLOBAL EXCEPTIONS
135 ---------------------------------------------------------------------------
136 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
137
138 ---------------------------------------------------------------------------
139 -- GLOBAL VARIABLES
140 ---------------------------------------------------------------------------
141 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAX_PVT';
142 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
143 ---------------------------------------------------------------------------
144 -- Procedures and Functions
145 ---------------------------------------------------------------------------
146
147 PROCEDURE qc;
148 PROCEDURE change_version;
149 PROCEDURE api_copy;
150 PROCEDURE insert_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
157 x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
158 PROCEDURE insert_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
165 x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
166 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
167 PROCEDURE insert_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
174 x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
175 PROCEDURE lock_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
182 PROCEDURE lock_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
189 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
190 PROCEDURE lock_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
197 PROCEDURE update_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
204 x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
205 PROCEDURE update_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
212 x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
213 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
214 PROCEDURE update_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
221 x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
222 PROCEDURE delete_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
229 PROCEDURE delete_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
236 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
237 PROCEDURE delete_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
244 PROCEDURE validate_row(
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
251 PROCEDURE validate_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
258 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
259 PROCEDURE validate_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
266 END OKL_TAX_PVT;