[Home] [Help]
PACKAGE: APPS.OKL_TQL_PVT
Source
1 Package OKL_TQL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTQLS.pls 120.3 2005/06/17 22:58:31 rmunjulu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tql_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 sty_id NUMBER := OKC_API.G_MISS_NUM,
9 kle_id NUMBER := OKC_API.G_MISS_NUM,
10 qlt_code OKL_TXL_QUOTE_LINES_B.QLT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 qte_id NUMBER := OKC_API.G_MISS_NUM,
12 line_number NUMBER := OKC_API.G_MISS_NUM,
13 amount NUMBER := OKC_API.G_MISS_NUM,
14 object_version_number NUMBER := OKC_API.G_MISS_NUM,
15 modified_yn OKL_TXL_QUOTE_LINES_B.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,
16 taxed_yn OKL_TXL_QUOTE_LINES_B.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,
17 defaulted_yn OKL_TXL_QUOTE_LINES_B.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,
18 org_id NUMBER := OKC_API.G_MISS_NUM,
19 request_id NUMBER := OKC_API.G_MISS_NUM,
20 program_application_id NUMBER := OKC_API.G_MISS_NUM,
21 program_id NUMBER := OKC_API.G_MISS_NUM,
22 program_update_date OKL_TXL_QUOTE_LINES_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23 attribute_category OKL_TXL_QUOTE_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24 attribute1 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25 attribute2 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26 attribute3 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27 attribute4 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28 attribute5 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29 attribute6 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30 attribute7 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31 attribute8 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32 attribute9 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33 attribute10 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34 attribute11 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35 attribute12 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36 attribute13 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37 attribute14 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38 attribute15 OKL_TXL_QUOTE_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39 created_by NUMBER := OKC_API.G_MISS_NUM,
40 creation_date OKL_TXL_QUOTE_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42 last_update_date OKL_TXL_QUOTE_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43 last_update_login NUMBER := OKC_API.G_MISS_NUM,
44 start_date OKL_TXL_QUOTE_LINES_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
45 period OKL_TXL_QUOTE_LINES_B.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
46 number_of_periods NUMBER := OKC_API.G_MISS_NUM,
47 lock_level_step OKL_TXL_QUOTE_LINES_B.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
48 advance_or_arrears OKL_TXL_QUOTE_LINES_B.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
49 yield_name OKL_TXL_QUOTE_LINES_B.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
50 yield_value NUMBER := OKC_API.G_MISS_NUM,
51 implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
52 asset_value NUMBER := OKC_API.G_MISS_NUM,
53 residual_value NUMBER := OKC_API.G_MISS_NUM,
54 unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
55 asset_quantity NUMBER := OKC_API.G_MISS_NUM,
56 quote_quantity NUMBER := OKC_API.G_MISS_NUM,
57 split_kle_id NUMBER := OKC_API.G_MISS_NUM,
58 split_kle_name OKL_TXL_QUOTE_LINES_B.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
59 -- BAKUCHIB 2667636 Start
60 currency_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
61 currency_conversion_code OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
62 currency_conversion_type OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63 currency_conversion_rate OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
64 currency_conversion_date OKL_TXL_QUOTE_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
65 -- BAKUCHIB 2667636 End
66 -- PAGARG 15-Feb-05 Bug 4161133 Start
67 -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
68 due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
69 -- PAGARG 15-Feb-05 Bug 4161133 End
70 --rmunjulu 23-May-05 Sales_Tax_Enhancements
71 try_id OKL_TXL_QUOTE_LINES_B.TRY_ID%TYPE := OKL_API.G_MISS_NUM);
72 g_miss_tql_rec tql_rec_type;
73 TYPE tql_tbl_type IS TABLE OF tql_rec_type
74 INDEX BY BINARY_INTEGER;
75 TYPE OklTxlQuoteLinesTlRecType IS RECORD (
76 id NUMBER := OKC_API.G_MISS_NUM,
77 language OKL_TXL_QUOTE_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
78 source_lang OKL_TXL_QUOTE_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
79 sfwt_flag OKL_TXL_QUOTE_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
80 description OKL_TXL_QUOTE_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81 created_by NUMBER := OKC_API.G_MISS_NUM,
82 creation_date OKL_TXL_QUOTE_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
84 last_update_date OKL_TXL_QUOTE_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
85 last_update_login NUMBER := OKC_API.G_MISS_NUM);
86 GMissOklTxlQuoteLinesTlRec OklTxlQuoteLinesTlRecType;
87 TYPE OklTxlQuoteLinesTlTblType IS TABLE OF OklTxlQuoteLinesTlRecType
88 INDEX BY BINARY_INTEGER;
89 TYPE tqlv_rec_type IS RECORD (
90 id NUMBER := OKC_API.G_MISS_NUM,
91 object_version_number NUMBER := OKC_API.G_MISS_NUM,
92 sfwt_flag OKL_TXL_QUOTE_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
93 qlt_code OKL_TXL_QUOTE_LINES_V.QLT_CODE%TYPE := OKC_API.G_MISS_CHAR,
94 kle_id NUMBER := OKC_API.G_MISS_NUM,
95 sty_id NUMBER := OKC_API.G_MISS_NUM,
96 qte_id NUMBER := OKC_API.G_MISS_NUM,
97 line_number NUMBER := OKC_API.G_MISS_NUM,
98 description OKL_TXL_QUOTE_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
99 amount NUMBER := OKC_API.G_MISS_NUM,
100 modified_yn OKL_TXL_QUOTE_LINES_V.MODIFIED_YN%TYPE := OKC_API.G_MISS_CHAR,
101 taxed_yn OKL_TXL_QUOTE_LINES_V.TAXED_YN%TYPE := OKC_API.G_MISS_CHAR,
102 defaulted_yn OKL_TXL_QUOTE_LINES_V.DEFAULTED_YN%TYPE := OKC_API.G_MISS_CHAR,
103 attribute_category OKL_TXL_QUOTE_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104 attribute1 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105 attribute2 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106 attribute3 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107 attribute4 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108 attribute5 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109 attribute6 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110 attribute7 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111 attribute8 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112 attribute9 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113 attribute10 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114 attribute11 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115 attribute12 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116 attribute13 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117 attribute14 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118 attribute15 OKL_TXL_QUOTE_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119 org_id NUMBER := OKC_API.G_MISS_NUM,
120 request_id NUMBER := OKC_API.G_MISS_NUM,
121 program_application_id NUMBER := OKC_API.G_MISS_NUM,
122 program_id NUMBER := OKC_API.G_MISS_NUM,
123 program_update_date OKL_TXL_QUOTE_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124 created_by NUMBER := OKC_API.G_MISS_NUM,
125 creation_date OKL_TXL_QUOTE_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
126 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
127 last_update_date OKL_TXL_QUOTE_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
128 last_update_login NUMBER := OKC_API.G_MISS_NUM,
129 start_date OKL_TXL_QUOTE_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
130 period OKL_TXL_QUOTE_LINES_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
131 number_of_periods NUMBER := OKC_API.G_MISS_NUM,
132 lock_level_step OKL_TXL_QUOTE_LINES_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
133 advance_or_arrears OKL_TXL_QUOTE_LINES_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
134 yield_name OKL_TXL_QUOTE_LINES_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
135 yield_value NUMBER := OKC_API.G_MISS_NUM,
136 implicit_interest_rate NUMBER := OKC_API.G_MISS_NUM,
137 asset_value NUMBER := OKC_API.G_MISS_NUM,
138 residual_value NUMBER := OKC_API.G_MISS_NUM,
139 unbilled_receivables NUMBER := OKC_API.G_MISS_NUM,
140 asset_quantity NUMBER := OKC_API.G_MISS_NUM,
141 quote_quantity NUMBER := OKC_API.G_MISS_NUM,
142 split_kle_id NUMBER := OKC_API.G_MISS_NUM,
143 split_kle_name OKL_TXL_QUOTE_LINES_V.SPLIT_KLE_NAME%TYPE := OKC_API.G_MISS_CHAR, -- RMUNJULU 2757312
144 -- BAKUCHIB 2667636 Start
145 currency_code OKL_TXL_QUOTE_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
146 currency_conversion_code OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
147 currency_conversion_type OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
148 currency_conversion_rate OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
149 currency_conversion_date OKL_TXL_QUOTE_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
150 -- BAKUCHIB 2667636 End
151 -- PAGARG 15-Feb-05 Bug 4161133 Start
152 -- Added new column DUE_DATE in OKL_TXL_QUOTE_LINES_B
153 due_date OKL_TXL_QUOTE_LINES_B.DUE_DATE%TYPE := OKL_API.G_MISS_DATE,
154 -- PAGARG 15-Feb-05 Bug 4161133 End
155 --rmunjulu 23-May-05 Sales_Tax_Enhancements
156 try_id OKL_TXL_QUOTE_LINES_V.TRY_ID%TYPE := OKL_API.G_MISS_NUM);
157 g_miss_tqlv_rec tqlv_rec_type;
158 TYPE tqlv_tbl_type IS TABLE OF tqlv_rec_type
159 INDEX BY BINARY_INTEGER;
160
161 -- PAGARG Bug 4299668 Declare table of records to define arrays used in bulk insert
162 -- **Start**
163 TYPE NumberTabTyp IS TABLE OF NUMBER
164 INDEX BY BINARY_INTEGER;
165 TYPE Number4TabTyp IS TABLE OF NUMBER(4)
166 INDEX BY BINARY_INTEGER;
167 TYPE Number9TabTyp IS TABLE OF NUMBER(9)
168 INDEX BY BINARY_INTEGER;
169 TYPE Number14p3TabTyp IS TABLE OF NUMBER(14,3)
170 INDEX BY BINARY_INTEGER;
171 TYPE Number15TabTyp IS TABLE OF NUMBER(15)
172 INDEX BY BINARY_INTEGER;
173 TYPE Number18p15TabTyp IS TABLE OF NUMBER(18,15)
174 INDEX BY BINARY_INTEGER;
175 TYPE DateTabTyp IS TABLE OF DATE
176 INDEX BY BINARY_INTEGER;
177 TYPE Var3TabTyp IS TABLE OF VARCHAR2(3)
178 INDEX BY BINARY_INTEGER;
179 TYPE Var10TabTyp IS TABLE OF VARCHAR2(10)
180 INDEX BY BINARY_INTEGER;
181 TYPE Var12TabTyp IS TABLE OF VARCHAR2(12)
182 INDEX BY BINARY_INTEGER;
183 TYPE Var15TabTyp IS TABLE OF VARCHAR2(15)
184 INDEX BY BINARY_INTEGER;
185 TYPE Var30TabTyp IS TABLE OF VARCHAR2(30)
186 INDEX BY BINARY_INTEGER;
187 TYPE Var90TabTyp IS TABLE OF VARCHAR2(90)
188 INDEX BY BINARY_INTEGER;
189 TYPE Var150TabTyp IS TABLE OF VARCHAR2(150)
190 INDEX BY BINARY_INTEGER;
191 TYPE Var450TabTyp IS TABLE OF VARCHAR2(450)
192 INDEX BY BINARY_INTEGER;
193 TYPE Var1995TabTyp IS TABLE OF VARCHAR2(1995)
194 INDEX BY BINARY_INTEGER;
195 -- PAGARG Bug 4299668 **End**
196
197 ---------------------------------------------------------------------------
198 -- GLOBAL MESSAGE CONSTANTS
199 ---------------------------------------------------------------------------
200 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
201 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
202 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
203 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
204 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
205 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
206 G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
207 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
208 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
209 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
210 G_YES CONSTANT VARCHAR2(3) := 'Y';
211 G_NO CONSTANT VARCHAR2(3) := 'N';
212 ---------------------------------------------------------------------------
213 -- GLOBAL VARIABLES
214 ---------------------------------------------------------------------------
215 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TQL_PVT';
216 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
217 ---------------------------------------------------------------------------
218 -- Procedures and Functions
219 ---------------------------------------------------------------------------
220
221 PROCEDURE qc;
222 PROCEDURE change_version;
223 PROCEDURE api_copy;
224 PROCEDURE add_language;
225 PROCEDURE insert_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_tqlv_rec IN tqlv_rec_type,
232 x_tqlv_rec OUT NOCOPY tqlv_rec_type);
233
234 PROCEDURE insert_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_tqlv_tbl IN tqlv_tbl_type,
241 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type);
242
243 PROCEDURE lock_row(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_tqlv_rec IN tqlv_rec_type);
250
251 PROCEDURE lock_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_tqlv_tbl IN tqlv_tbl_type);
258
259 PROCEDURE update_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_tqlv_rec IN tqlv_rec_type,
266 x_tqlv_rec OUT NOCOPY tqlv_rec_type);
267
268 PROCEDURE update_row(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_tqlv_tbl IN tqlv_tbl_type,
275 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type);
276
277 PROCEDURE delete_row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_tqlv_rec IN tqlv_rec_type);
284
285 PROCEDURE delete_row(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_tqlv_tbl IN tqlv_tbl_type);
292
293 PROCEDURE validate_row(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_tqlv_rec IN tqlv_rec_type);
300
301 PROCEDURE validate_row(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_tqlv_tbl IN tqlv_tbl_type);
308
309 -- PAGARG Bug 4299668 New Procedure for bulk insert
310 PROCEDURE insert_row_bulk(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_tqlv_tbl IN tqlv_tbl_type,
317 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type);
318
319 END OKL_TQL_PVT;