DBA Data[Home] [Help]

APPS.OKL_PTQ_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptq_pvt.ptq_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_2000

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptq_pvt.ptq_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE

Line 62: , a1 out nocopy JTF_VARCHAR2_TABLE_200

58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_ptq_pvt.ptq_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_200
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_DATE_TABLE

Line 64: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_ptq_pvt.ptq_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_200
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_DATE_TABLE
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE

Line 77: a1 := JTF_VARCHAR2_TABLE_200();

73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_2000();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_DATE_TABLE();

Line 79: a3 := JTF_VARCHAR2_TABLE_2000();

75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_VARCHAR2_TABLE_2000();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_DATE_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();

Line 89: a1 := JTF_VARCHAR2_TABLE_200();

85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_200();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_2000();
92: a4 := JTF_DATE_TABLE();
93: a5 := JTF_DATE_TABLE();

Line 91: a3 := JTF_VARCHAR2_TABLE_2000();

87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_200();
90: a2 := JTF_NUMBER_TABLE();
91: a3 := JTF_VARCHAR2_TABLE_2000();
92: a4 := JTF_DATE_TABLE();
93: a5 := JTF_DATE_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();

Line 137: , a2 JTF_VARCHAR2_TABLE_200

133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptq_pvt.ptqv_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_200
138: , a3 JTF_VARCHAR2_TABLE_2000
139: , a4 JTF_DATE_TABLE
140: , a5 JTF_DATE_TABLE
141: , a6 JTF_NUMBER_TABLE

Line 138: , a3 JTF_VARCHAR2_TABLE_2000

134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptq_pvt.ptqv_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_200
138: , a3 JTF_VARCHAR2_TABLE_2000
139: , a4 JTF_DATE_TABLE
140: , a5 JTF_DATE_TABLE
141: , a6 JTF_NUMBER_TABLE
142: , a7 JTF_DATE_TABLE

Line 176: , a2 out nocopy JTF_VARCHAR2_TABLE_200

172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_ptq_pvt.ptqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_NUMBER_TABLE
176: , a2 out nocopy JTF_VARCHAR2_TABLE_200
177: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
178: , a4 out nocopy JTF_DATE_TABLE
179: , a5 out nocopy JTF_DATE_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE

Line 177: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_ptq_pvt.ptqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_NUMBER_TABLE
176: , a2 out nocopy JTF_VARCHAR2_TABLE_200
177: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
178: , a4 out nocopy JTF_DATE_TABLE
179: , a5 out nocopy JTF_DATE_TABLE
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_DATE_TABLE

Line 191: a2 := JTF_VARCHAR2_TABLE_200();

187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_NUMBER_TABLE();
191: a2 := JTF_VARCHAR2_TABLE_200();
192: a3 := JTF_VARCHAR2_TABLE_2000();
193: a4 := JTF_DATE_TABLE();
194: a5 := JTF_DATE_TABLE();
195: a6 := JTF_NUMBER_TABLE();

Line 192: a3 := JTF_VARCHAR2_TABLE_2000();

188: if t is null or t.count = 0 then
189: a0 := JTF_NUMBER_TABLE();
190: a1 := JTF_NUMBER_TABLE();
191: a2 := JTF_VARCHAR2_TABLE_200();
192: a3 := JTF_VARCHAR2_TABLE_2000();
193: a4 := JTF_DATE_TABLE();
194: a5 := JTF_DATE_TABLE();
195: a6 := JTF_NUMBER_TABLE();
196: a7 := JTF_DATE_TABLE();

Line 203: a2 := JTF_VARCHAR2_TABLE_200();

199: a10 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_200();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_DATE_TABLE();
206: a5 := JTF_DATE_TABLE();
207: a6 := JTF_NUMBER_TABLE();

Line 204: a3 := JTF_VARCHAR2_TABLE_2000();

200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_200();
204: a3 := JTF_VARCHAR2_TABLE_2000();
205: a4 := JTF_DATE_TABLE();
206: a5 := JTF_DATE_TABLE();
207: a6 := JTF_NUMBER_TABLE();
208: a7 := JTF_DATE_TABLE();

Line 338: , p5_a2 JTF_VARCHAR2_TABLE_200

334: , x_msg_count out nocopy NUMBER
335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_NUMBER_TABLE
338: , p5_a2 JTF_VARCHAR2_TABLE_200
339: , p5_a3 JTF_VARCHAR2_TABLE_2000
340: , p5_a4 JTF_DATE_TABLE
341: , p5_a5 JTF_DATE_TABLE
342: , p5_a6 JTF_NUMBER_TABLE

Line 339: , p5_a3 JTF_VARCHAR2_TABLE_2000

335: , x_msg_data out nocopy VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_NUMBER_TABLE
338: , p5_a2 JTF_VARCHAR2_TABLE_200
339: , p5_a3 JTF_VARCHAR2_TABLE_2000
340: , p5_a4 JTF_DATE_TABLE
341: , p5_a5 JTF_DATE_TABLE
342: , p5_a6 JTF_NUMBER_TABLE
343: , p5_a7 JTF_DATE_TABLE

Line 349: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

345: , p5_a9 JTF_DATE_TABLE
346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_NUMBER_TABLE
349: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
351: , p6_a4 out nocopy JTF_DATE_TABLE
352: , p6_a5 out nocopy JTF_DATE_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

346: , p5_a10 JTF_NUMBER_TABLE
347: , p6_a0 out nocopy JTF_NUMBER_TABLE
348: , p6_a1 out nocopy JTF_NUMBER_TABLE
349: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
350: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
351: , p6_a4 out nocopy JTF_DATE_TABLE
352: , p6_a5 out nocopy JTF_DATE_TABLE
353: , p6_a6 out nocopy JTF_NUMBER_TABLE
354: , p6_a7 out nocopy JTF_DATE_TABLE

Line 480: , p5_a2 JTF_VARCHAR2_TABLE_200

476: , x_msg_count out nocopy NUMBER
477: , x_msg_data out nocopy VARCHAR2
478: , p5_a0 JTF_NUMBER_TABLE
479: , p5_a1 JTF_NUMBER_TABLE
480: , p5_a2 JTF_VARCHAR2_TABLE_200
481: , p5_a3 JTF_VARCHAR2_TABLE_2000
482: , p5_a4 JTF_DATE_TABLE
483: , p5_a5 JTF_DATE_TABLE
484: , p5_a6 JTF_NUMBER_TABLE

Line 481: , p5_a3 JTF_VARCHAR2_TABLE_2000

477: , x_msg_data out nocopy VARCHAR2
478: , p5_a0 JTF_NUMBER_TABLE
479: , p5_a1 JTF_NUMBER_TABLE
480: , p5_a2 JTF_VARCHAR2_TABLE_200
481: , p5_a3 JTF_VARCHAR2_TABLE_2000
482: , p5_a4 JTF_DATE_TABLE
483: , p5_a5 JTF_DATE_TABLE
484: , p5_a6 JTF_NUMBER_TABLE
485: , p5_a7 JTF_DATE_TABLE

Line 621: , p5_a2 JTF_VARCHAR2_TABLE_200

617: , x_msg_count out nocopy NUMBER
618: , x_msg_data out nocopy VARCHAR2
619: , p5_a0 JTF_NUMBER_TABLE
620: , p5_a1 JTF_NUMBER_TABLE
621: , p5_a2 JTF_VARCHAR2_TABLE_200
622: , p5_a3 JTF_VARCHAR2_TABLE_2000
623: , p5_a4 JTF_DATE_TABLE
624: , p5_a5 JTF_DATE_TABLE
625: , p5_a6 JTF_NUMBER_TABLE

Line 622: , p5_a3 JTF_VARCHAR2_TABLE_2000

618: , x_msg_data out nocopy VARCHAR2
619: , p5_a0 JTF_NUMBER_TABLE
620: , p5_a1 JTF_NUMBER_TABLE
621: , p5_a2 JTF_VARCHAR2_TABLE_200
622: , p5_a3 JTF_VARCHAR2_TABLE_2000
623: , p5_a4 JTF_DATE_TABLE
624: , p5_a5 JTF_DATE_TABLE
625: , p5_a6 JTF_NUMBER_TABLE
626: , p5_a7 JTF_DATE_TABLE

Line 632: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

628: , p5_a9 JTF_DATE_TABLE
629: , p5_a10 JTF_NUMBER_TABLE
630: , p6_a0 out nocopy JTF_NUMBER_TABLE
631: , p6_a1 out nocopy JTF_NUMBER_TABLE
632: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
633: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
634: , p6_a4 out nocopy JTF_DATE_TABLE
635: , p6_a5 out nocopy JTF_DATE_TABLE
636: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 633: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

629: , p5_a10 JTF_NUMBER_TABLE
630: , p6_a0 out nocopy JTF_NUMBER_TABLE
631: , p6_a1 out nocopy JTF_NUMBER_TABLE
632: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
633: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
634: , p6_a4 out nocopy JTF_DATE_TABLE
635: , p6_a5 out nocopy JTF_DATE_TABLE
636: , p6_a6 out nocopy JTF_NUMBER_TABLE
637: , p6_a7 out nocopy JTF_DATE_TABLE

Line 763: , p5_a2 JTF_VARCHAR2_TABLE_200

759: , x_msg_count out nocopy NUMBER
760: , x_msg_data out nocopy VARCHAR2
761: , p5_a0 JTF_NUMBER_TABLE
762: , p5_a1 JTF_NUMBER_TABLE
763: , p5_a2 JTF_VARCHAR2_TABLE_200
764: , p5_a3 JTF_VARCHAR2_TABLE_2000
765: , p5_a4 JTF_DATE_TABLE
766: , p5_a5 JTF_DATE_TABLE
767: , p5_a6 JTF_NUMBER_TABLE

Line 764: , p5_a3 JTF_VARCHAR2_TABLE_2000

760: , x_msg_data out nocopy VARCHAR2
761: , p5_a0 JTF_NUMBER_TABLE
762: , p5_a1 JTF_NUMBER_TABLE
763: , p5_a2 JTF_VARCHAR2_TABLE_200
764: , p5_a3 JTF_VARCHAR2_TABLE_2000
765: , p5_a4 JTF_DATE_TABLE
766: , p5_a5 JTF_DATE_TABLE
767: , p5_a6 JTF_NUMBER_TABLE
768: , p5_a7 JTF_DATE_TABLE

Line 878: , p5_a2 JTF_VARCHAR2_TABLE_200

874: , x_msg_count out nocopy NUMBER
875: , x_msg_data out nocopy VARCHAR2
876: , p5_a0 JTF_NUMBER_TABLE
877: , p5_a1 JTF_NUMBER_TABLE
878: , p5_a2 JTF_VARCHAR2_TABLE_200
879: , p5_a3 JTF_VARCHAR2_TABLE_2000
880: , p5_a4 JTF_DATE_TABLE
881: , p5_a5 JTF_DATE_TABLE
882: , p5_a6 JTF_NUMBER_TABLE

Line 879: , p5_a3 JTF_VARCHAR2_TABLE_2000

875: , x_msg_data out nocopy VARCHAR2
876: , p5_a0 JTF_NUMBER_TABLE
877: , p5_a1 JTF_NUMBER_TABLE
878: , p5_a2 JTF_VARCHAR2_TABLE_200
879: , p5_a3 JTF_VARCHAR2_TABLE_2000
880: , p5_a4 JTF_DATE_TABLE
881: , p5_a5 JTF_DATE_TABLE
882: , p5_a6 JTF_NUMBER_TABLE
883: , p5_a7 JTF_DATE_TABLE