[Home] [Help]
PACKAGE: APPS.OKL_TIL_PVT
Source
1 PACKAGE Okl_Til_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSTILS.pls 120.7 2008/05/15 18:19:19 sechawla ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE til_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9 tai_id NUMBER := Okl_Api.G_MISS_NUM,
10 kle_id NUMBER := Okl_Api.G_MISS_NUM,
11 tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12 sty_id NUMBER := Okl_Api.G_MISS_NUM,
13 acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14 til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15 line_number NUMBER := Okl_Api.G_MISS_NUM,
16 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17 amount NUMBER := Okl_Api.G_MISS_NUM,
18 quantity NUMBER := Okl_Api.G_MISS_NUM,
19 receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21 date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22 date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
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_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27 org_id NUMBER := Okl_Api.G_MISS_NUM,
28 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29 isl_id NUMBER := Okl_Api.G_MISS_NUM,
30 ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31 LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32 CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33 -- Start changes on remarketing by fmiao on 10/18/04 --
34 inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35 -- End changes on remarketing by fmiao on 10/18/04 --
36 qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
37 txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38 -- Start Bug 4673593
39 bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40 -- End Bug 4673593
41 attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57 created_by NUMBER := Okl_Api.G_MISS_NUM,
58 creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60 last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62
63 -- start: 30-Jan-07 cklee Billing R12 project |
64 TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
65 TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM ,
66 -- end: 30-Jan-07 cklee Billing R12 project |
67 TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311
68 );
69
70 g_miss_til_rec til_rec_type;
71 TYPE til_tbl_type IS TABLE OF til_rec_type
72 INDEX BY BINARY_INTEGER;
73 TYPE okl_txl_ar_inv_lns_tl_rec_type IS RECORD (
74 id NUMBER := Okl_Api.G_MISS_NUM,
75 LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76 source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77 ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78 sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79 description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80 created_by NUMBER := Okl_Api.G_MISS_NUM,
81 creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83 last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
85 GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
86 TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
87 INDEX BY BINARY_INTEGER;
88 TYPE tilv_rec_type IS RECORD (
89 id NUMBER := Okl_Api.G_MISS_NUM,
90 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91 ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92 sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93 kle_id NUMBER := Okl_Api.G_MISS_NUM,
94 tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95 til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96 inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97 sty_id NUMBER := Okl_Api.G_MISS_NUM,
98 tai_id NUMBER := Okl_Api.G_MISS_NUM,
99 acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100 amount NUMBER := Okl_Api.G_MISS_NUM,
101 line_number NUMBER := Okl_Api.G_MISS_NUM,
102 quantity NUMBER := Okl_Api.G_MISS_NUM,
103 description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104 receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105 date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107 date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108 isl_id NUMBER := Okl_Api.G_MISS_NUM,
109 ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110 LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111 CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112 -- Start changes on remarketing by fmiao on 10/18/04 --
113 inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114 -- End changes on remarketing by fmiao on 10/18/04 --
115 qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
116 txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117 -- Start Bug 4594310
118 bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119 -- End Bug 4594310
120 attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121 attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122 attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123 attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124 attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125 attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126 attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127 attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128 attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129 attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130 attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131 attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132 attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133 attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134 attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135 attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136 request_id NUMBER := Okl_Api.G_MISS_NUM,
137 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138 program_id NUMBER := Okl_Api.G_MISS_NUM,
139 program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140 org_id NUMBER := Okl_Api.G_MISS_NUM,
141 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142 created_by NUMBER := Okl_Api.G_MISS_NUM,
143 creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145 last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147
148 -- start: 30-Jan-07 cklee Billing R12 project |
149 TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
150 TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM,
151 -- end: 30-Jan-07 cklee Billing R12 project
152 TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311 |
153 );
154 g_miss_tilv_rec tilv_rec_type;
155 TYPE tilv_tbl_type IS TABLE OF tilv_rec_type
156 INDEX BY BINARY_INTEGER;
157 ---------------------------------------------------------------------------
158 -- GLOBAL MESSAGE CONSTANTS
159 ---------------------------------------------------------------------------
160 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
170 ---------------------------------------------------------------------------
171 -- GLOBAL VARIABLES
172 ---------------------------------------------------------------------------
173 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TIL_PVT';
174 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
175
176 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
177 --GLOBAL MESSAGES
178 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
179 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
180 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
181 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
182 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
183
184
185 --GLOBAL VARIABLES
186 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
187 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
188
189 ---------------------------------------------------------------------------
190 -- validation Procedures and Functions
191 ---------------------------------------------------------------------------
192 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
193 -- x_return_status OUT NOCOPY VARCHAR2);
194
195 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001)**************/
196
197 ---------------------------------------------------------------------------
198 -- Procedures and Functions
199 ---------------------------------------------------------------------------
200
201 PROCEDURE qc;
202 PROCEDURE change_version;
203 PROCEDURE api_copy;
204 PROCEDURE add_language;
205 PROCEDURE insert_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_tilv_rec IN tilv_rec_type,
212 x_tilv_rec OUT NOCOPY tilv_rec_type);
213
214 PROCEDURE insert_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_tilv_tbl IN tilv_tbl_type,
221 x_tilv_tbl OUT NOCOPY tilv_tbl_type);
222
223 PROCEDURE lock_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_tilv_rec IN tilv_rec_type);
230
231 PROCEDURE lock_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_tilv_tbl IN tilv_tbl_type);
238
239 PROCEDURE update_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_tilv_rec IN tilv_rec_type,
246 x_tilv_rec OUT NOCOPY tilv_rec_type);
247
248 PROCEDURE update_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_tilv_tbl IN tilv_tbl_type,
255 x_tilv_tbl OUT NOCOPY tilv_tbl_type);
256
257 PROCEDURE delete_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_tilv_rec IN tilv_rec_type);
264
265 PROCEDURE delete_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_tilv_tbl IN tilv_tbl_type);
272
273 PROCEDURE validate_row(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_tilv_rec IN tilv_rec_type);
280
281 PROCEDURE validate_row(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_tilv_tbl IN tilv_tbl_type);
288
289 END Okl_Til_Pvt;