DBA Data[Home] [Help]

APPS.OKC_XPRT_XRULE_VALUES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p4(t out nocopy okc_xprt_xrule_values_pvt.sys_var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy okc_xprt_xrule_values_pvt.sys_var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_2500
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin

Line 43: procedure rosetta_table_copy_out_p4(t okc_xprt_xrule_values_pvt.sys_var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p4;
43: procedure rosetta_table_copy_out_p4(t okc_xprt_xrule_values_pvt.sys_var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_VARCHAR2_TABLE_2500
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin

Line 49: a0 := JTF_VARCHAR2_TABLE_100();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_VARCHAR2_TABLE_2500();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_2500();

Line 52: a0 := JTF_VARCHAR2_TABLE_100();

48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_VARCHAR2_TABLE_2500();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_2500();
54: if t.count > 0 then
55: a0.extend(t.count);
56: a1.extend(t.count);

Line 158: procedure rosetta_table_copy_in_p7(t out nocopy okc_xprt_xrule_values_pvt.constant_tbl_type, a0 JTF_VARCHAR2_TABLE_100

154: end if;
155: end if;
156: end rosetta_table_copy_out_p6;
157:
158: procedure rosetta_table_copy_in_p7(t out nocopy okc_xprt_xrule_values_pvt.constant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_VARCHAR2_TABLE_100
160: ) as
161: ddindx binary_integer; indx binary_integer;
162: begin

Line 159: , a1 JTF_VARCHAR2_TABLE_100

155: end if;
156: end rosetta_table_copy_out_p6;
157:
158: procedure rosetta_table_copy_in_p7(t out nocopy okc_xprt_xrule_values_pvt.constant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_VARCHAR2_TABLE_100
160: ) as
161: ddindx binary_integer; indx binary_integer;
162: begin
163: if a0 is not null and a0.count > 0 then

Line 179: procedure rosetta_table_copy_out_p7(t okc_xprt_xrule_values_pvt.constant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

175: end loop;
176: end if;
177: end if;
178: end rosetta_table_copy_in_p7;
179: procedure rosetta_table_copy_out_p7(t okc_xprt_xrule_values_pvt.constant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
180: , a1 out nocopy JTF_VARCHAR2_TABLE_100
181: ) as
182: ddindx binary_integer; indx binary_integer;
183: begin

Line 180: , a1 out nocopy JTF_VARCHAR2_TABLE_100

176: end if;
177: end if;
178: end rosetta_table_copy_in_p7;
179: procedure rosetta_table_copy_out_p7(t okc_xprt_xrule_values_pvt.constant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
180: , a1 out nocopy JTF_VARCHAR2_TABLE_100
181: ) as
182: ddindx binary_integer; indx binary_integer;
183: begin
184: if t is null or t.count = 0 then

Line 185: a0 := JTF_VARCHAR2_TABLE_100();

181: ) as
182: ddindx binary_integer; indx binary_integer;
183: begin
184: if t is null or t.count = 0 then
185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_VARCHAR2_TABLE_100();
189: a1 := JTF_VARCHAR2_TABLE_100();

Line 186: a1 := JTF_VARCHAR2_TABLE_100();

182: ddindx binary_integer; indx binary_integer;
183: begin
184: if t is null or t.count = 0 then
185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_VARCHAR2_TABLE_100();
189: a1 := JTF_VARCHAR2_TABLE_100();
190: if t.count > 0 then

Line 188: a0 := JTF_VARCHAR2_TABLE_100();

184: if t is null or t.count = 0 then
185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_VARCHAR2_TABLE_100();
189: a1 := JTF_VARCHAR2_TABLE_100();
190: if t.count > 0 then
191: a0.extend(t.count);
192: a1.extend(t.count);

Line 189: a1 := JTF_VARCHAR2_TABLE_100();

185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_VARCHAR2_TABLE_100();
189: a1 := JTF_VARCHAR2_TABLE_100();
190: if t.count > 0 then
191: a0.extend(t.count);
192: a1.extend(t.count);
193: ddindx := t.first;

Line 209: , a1 JTF_VARCHAR2_TABLE_100

205: end if;
206: end rosetta_table_copy_out_p7;
207:
208: procedure rosetta_table_copy_in_p9(t out nocopy okc_xprt_xrule_values_pvt.line_sys_var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_300
209: , a1 JTF_VARCHAR2_TABLE_100
210: , a2 JTF_VARCHAR2_TABLE_2500
211: , a3 JTF_NUMBER_TABLE
212: , a4 JTF_NUMBER_TABLE
213: ) as

Line 236: , a1 out nocopy JTF_VARCHAR2_TABLE_100

232: end if;
233: end if;
234: end rosetta_table_copy_in_p9;
235: procedure rosetta_table_copy_out_p9(t okc_xprt_xrule_values_pvt.line_sys_var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
236: , a1 out nocopy JTF_VARCHAR2_TABLE_100
237: , a2 out nocopy JTF_VARCHAR2_TABLE_2500
238: , a3 out nocopy JTF_NUMBER_TABLE
239: , a4 out nocopy JTF_NUMBER_TABLE
240: ) as

Line 245: a1 := JTF_VARCHAR2_TABLE_100();

241: ddindx binary_integer; indx binary_integer;
242: begin
243: if t is null or t.count = 0 then
244: a0 := JTF_VARCHAR2_TABLE_300();
245: a1 := JTF_VARCHAR2_TABLE_100();
246: a2 := JTF_VARCHAR2_TABLE_2500();
247: a3 := JTF_NUMBER_TABLE();
248: a4 := JTF_NUMBER_TABLE();
249: else

Line 251: a1 := JTF_VARCHAR2_TABLE_100();

247: a3 := JTF_NUMBER_TABLE();
248: a4 := JTF_NUMBER_TABLE();
249: else
250: a0 := JTF_VARCHAR2_TABLE_300();
251: a1 := JTF_VARCHAR2_TABLE_100();
252: a2 := JTF_VARCHAR2_TABLE_2500();
253: a3 := JTF_NUMBER_TABLE();
254: a4 := JTF_NUMBER_TABLE();
255: if t.count > 0 then

Line 279: procedure rosetta_table_copy_in_p10(t out nocopy okc_xprt_xrule_values_pvt.udf_var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100

275: end if;
276: end if;
277: end rosetta_table_copy_out_p9;
278:
279: procedure rosetta_table_copy_in_p10(t out nocopy okc_xprt_xrule_values_pvt.udf_var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100
280: , a1 JTF_VARCHAR2_TABLE_2500
281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin

Line 300: procedure rosetta_table_copy_out_p10(t okc_xprt_xrule_values_pvt.udf_var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

296: end loop;
297: end if;
298: end if;
299: end rosetta_table_copy_in_p10;
300: procedure rosetta_table_copy_out_p10(t okc_xprt_xrule_values_pvt.udf_var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
301: , a1 out nocopy JTF_VARCHAR2_TABLE_2500
302: ) as
303: ddindx binary_integer; indx binary_integer;
304: begin

Line 306: a0 := JTF_VARCHAR2_TABLE_100();

302: ) as
303: ddindx binary_integer; indx binary_integer;
304: begin
305: if t is null or t.count = 0 then
306: a0 := JTF_VARCHAR2_TABLE_100();
307: a1 := JTF_VARCHAR2_TABLE_2500();
308: else
309: a0 := JTF_VARCHAR2_TABLE_100();
310: a1 := JTF_VARCHAR2_TABLE_2500();

Line 309: a0 := JTF_VARCHAR2_TABLE_100();

305: if t is null or t.count = 0 then
306: a0 := JTF_VARCHAR2_TABLE_100();
307: a1 := JTF_VARCHAR2_TABLE_2500();
308: else
309: a0 := JTF_VARCHAR2_TABLE_100();
310: a1 := JTF_VARCHAR2_TABLE_2500();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);

Line 329: procedure rosetta_table_copy_in_p11(t out nocopy okc_xprt_xrule_values_pvt.var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100

325: end if;
326: end if;
327: end rosetta_table_copy_out_p10;
328:
329: procedure rosetta_table_copy_in_p11(t out nocopy okc_xprt_xrule_values_pvt.var_value_tbl_type, a0 JTF_VARCHAR2_TABLE_100
330: , a1 JTF_VARCHAR2_TABLE_2500
331: ) as
332: ddindx binary_integer; indx binary_integer;
333: begin

Line 350: procedure rosetta_table_copy_out_p11(t okc_xprt_xrule_values_pvt.var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

346: end loop;
347: end if;
348: end if;
349: end rosetta_table_copy_in_p11;
350: procedure rosetta_table_copy_out_p11(t okc_xprt_xrule_values_pvt.var_value_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
351: , a1 out nocopy JTF_VARCHAR2_TABLE_2500
352: ) as
353: ddindx binary_integer; indx binary_integer;
354: begin

Line 356: a0 := JTF_VARCHAR2_TABLE_100();

352: ) as
353: ddindx binary_integer; indx binary_integer;
354: begin
355: if t is null or t.count = 0 then
356: a0 := JTF_VARCHAR2_TABLE_100();
357: a1 := JTF_VARCHAR2_TABLE_2500();
358: else
359: a0 := JTF_VARCHAR2_TABLE_100();
360: a1 := JTF_VARCHAR2_TABLE_2500();

Line 359: a0 := JTF_VARCHAR2_TABLE_100();

355: if t is null or t.count = 0 then
356: a0 := JTF_VARCHAR2_TABLE_100();
357: a1 := JTF_VARCHAR2_TABLE_2500();
358: else
359: a0 := JTF_VARCHAR2_TABLE_100();
360: a1 := JTF_VARCHAR2_TABLE_2500();
361: if t.count > 0 then
362: a0.extend(t.count);
363: a1.extend(t.count);

Line 387: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

383: , x_msg_count out nocopy NUMBER
384: , p_doc_type VARCHAR2
385: , p_doc_id NUMBER
386: , p_only_doc_variables VARCHAR2
387: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
388: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_2500
389: )
390:
391: as

Line 437: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

433: , p_intent VARCHAR2
434: , x_return_status out nocopy VARCHAR2
435: , x_msg_data out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER
437: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
439: )
440:
441: as

Line 438: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

434: , x_return_status out nocopy VARCHAR2
435: , x_msg_data out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER
437: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
439: )
440:
441: as
442: ddx_constant_tbl okc_xprt_xrule_values_pvt.constant_tbl_type;

Line 484: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

480: , x_return_status out nocopy VARCHAR2
481: , x_msg_data out nocopy VARCHAR2
482: , x_msg_count out nocopy NUMBER
483: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_300
484: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
485: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_2500
486: , p8_a3 out nocopy JTF_NUMBER_TABLE
487: , p8_a4 out nocopy JTF_NUMBER_TABLE
488: , x_line_count out nocopy NUMBER

Line 550: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

546: , p_intent VARCHAR2
547: , x_return_status out nocopy VARCHAR2
548: , x_msg_data out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
551: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_2500
552: )
553:
554: as

Line 604: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

600: , p_doc_id NUMBER
601: , x_return_status out nocopy VARCHAR2
602: , x_msg_data out nocopy VARCHAR2
603: , x_msg_count out nocopy NUMBER
604: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_2500
606: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_300
607: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_2500

Line 607: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

603: , x_msg_count out nocopy NUMBER
604: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_2500
606: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_300
607: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_2500
609: , p8_a3 out nocopy JTF_NUMBER_TABLE
610: , p8_a4 out nocopy JTF_NUMBER_TABLE
611: , x_line_count out nocopy NUMBER