DBA Data[Home] [Help]

APPS.OKL_AES_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_aes_pvt.aes_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE

Line 28: , a6 JTF_VARCHAR2_TABLE_2000

24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE

Line 68: , a1 out nocopy JTF_VARCHAR2_TABLE_200

64: end if;
65: end if;
66: end rosetta_table_copy_in_p2;
67: procedure rosetta_table_copy_out_p2(t okl_aes_pvt.aes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_VARCHAR2_TABLE_200
69: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a3 out nocopy JTF_DATE_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_DATE_TABLE

Line 73: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

69: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a3 out nocopy JTF_DATE_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_DATE_TABLE
73: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_NUMBER_TABLE
76: , a9 out nocopy JTF_DATE_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE

Line 86: a1 := JTF_VARCHAR2_TABLE_200();

82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_DATE_TABLE();

Line 91: a6 := JTF_VARCHAR2_TABLE_2000();

87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_2000();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_DATE_TABLE();
95: a10 := JTF_NUMBER_TABLE();

Line 101: a1 := JTF_VARCHAR2_TABLE_200();

97: a12 := JTF_NUMBER_TABLE();
98: a13 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_VARCHAR2_TABLE_200();
102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_DATE_TABLE();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_DATE_TABLE();

Line 106: a6 := JTF_VARCHAR2_TABLE_2000();

102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_DATE_TABLE();
104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_DATE_TABLE();
106: a6 := JTF_VARCHAR2_TABLE_2000();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_NUMBER_TABLE();
109: a9 := JTF_DATE_TABLE();
110: a10 := JTF_NUMBER_TABLE();

Line 158: , a2 JTF_VARCHAR2_TABLE_200

154: end rosetta_table_copy_out_p2;
155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_aes_pvt.aesv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_VARCHAR2_TABLE_200
159: , a3 JTF_VARCHAR2_TABLE_2000
160: , a4 JTF_VARCHAR2_TABLE_100
161: , a5 JTF_DATE_TABLE
162: , a6 JTF_DATE_TABLE

Line 159: , a3 JTF_VARCHAR2_TABLE_2000

155:
156: procedure rosetta_table_copy_in_p5(t out nocopy okl_aes_pvt.aesv_tbl_type, a0 JTF_NUMBER_TABLE
157: , a1 JTF_NUMBER_TABLE
158: , a2 JTF_VARCHAR2_TABLE_200
159: , a3 JTF_VARCHAR2_TABLE_2000
160: , a4 JTF_VARCHAR2_TABLE_100
161: , a5 JTF_DATE_TABLE
162: , a6 JTF_DATE_TABLE
163: , a7 JTF_NUMBER_TABLE

Line 203: , a2 out nocopy JTF_VARCHAR2_TABLE_200

199: end if;
200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_aes_pvt.aesv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_VARCHAR2_TABLE_200
204: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100
206: , a5 out nocopy JTF_DATE_TABLE
207: , a6 out nocopy JTF_DATE_TABLE

Line 204: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

200: end rosetta_table_copy_in_p5;
201: procedure rosetta_table_copy_out_p5(t okl_aes_pvt.aesv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202: , a1 out nocopy JTF_NUMBER_TABLE
203: , a2 out nocopy JTF_VARCHAR2_TABLE_200
204: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
205: , a4 out nocopy JTF_VARCHAR2_TABLE_100
206: , a5 out nocopy JTF_DATE_TABLE
207: , a6 out nocopy JTF_DATE_TABLE
208: , a7 out nocopy JTF_NUMBER_TABLE

Line 221: a2 := JTF_VARCHAR2_TABLE_200();

217: begin
218: if t is null or t.count = 0 then
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_VARCHAR2_TABLE_200();
222: a3 := JTF_VARCHAR2_TABLE_2000();
223: a4 := JTF_VARCHAR2_TABLE_100();
224: a5 := JTF_DATE_TABLE();
225: a6 := JTF_DATE_TABLE();

Line 222: a3 := JTF_VARCHAR2_TABLE_2000();

218: if t is null or t.count = 0 then
219: a0 := JTF_NUMBER_TABLE();
220: a1 := JTF_NUMBER_TABLE();
221: a2 := JTF_VARCHAR2_TABLE_200();
222: a3 := JTF_VARCHAR2_TABLE_2000();
223: a4 := JTF_VARCHAR2_TABLE_100();
224: a5 := JTF_DATE_TABLE();
225: a6 := JTF_DATE_TABLE();
226: a7 := JTF_NUMBER_TABLE();

Line 236: a2 := JTF_VARCHAR2_TABLE_200();

232: a13 := JTF_NUMBER_TABLE();
233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_VARCHAR2_TABLE_200();
237: a3 := JTF_VARCHAR2_TABLE_2000();
238: a4 := JTF_VARCHAR2_TABLE_100();
239: a5 := JTF_DATE_TABLE();
240: a6 := JTF_DATE_TABLE();

Line 237: a3 := JTF_VARCHAR2_TABLE_2000();

233: else
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_NUMBER_TABLE();
236: a2 := JTF_VARCHAR2_TABLE_200();
237: a3 := JTF_VARCHAR2_TABLE_2000();
238: a4 := JTF_VARCHAR2_TABLE_100();
239: a5 := JTF_DATE_TABLE();
240: a6 := JTF_DATE_TABLE();
241: a7 := JTF_NUMBER_TABLE();

Line 392: , p5_a2 JTF_VARCHAR2_TABLE_200

388: , x_msg_count out nocopy NUMBER
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_VARCHAR2_TABLE_200
393: , p5_a3 JTF_VARCHAR2_TABLE_2000
394: , p5_a4 JTF_VARCHAR2_TABLE_100
395: , p5_a5 JTF_DATE_TABLE
396: , p5_a6 JTF_DATE_TABLE

Line 393: , p5_a3 JTF_VARCHAR2_TABLE_2000

389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 JTF_NUMBER_TABLE
391: , p5_a1 JTF_NUMBER_TABLE
392: , p5_a2 JTF_VARCHAR2_TABLE_200
393: , p5_a3 JTF_VARCHAR2_TABLE_2000
394: , p5_a4 JTF_VARCHAR2_TABLE_100
395: , p5_a5 JTF_DATE_TABLE
396: , p5_a6 JTF_DATE_TABLE
397: , p5_a7 JTF_NUMBER_TABLE

Line 406: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

402: , p5_a12 JTF_NUMBER_TABLE
403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a5 out nocopy JTF_DATE_TABLE
410: , p6_a6 out nocopy JTF_DATE_TABLE

Line 407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

403: , p5_a13 JTF_NUMBER_TABLE
404: , p6_a0 out nocopy JTF_NUMBER_TABLE
405: , p6_a1 out nocopy JTF_NUMBER_TABLE
406: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
407: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
408: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a5 out nocopy JTF_DATE_TABLE
410: , p6_a6 out nocopy JTF_DATE_TABLE
411: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 552: , p5_a2 JTF_VARCHAR2_TABLE_200

548: , x_msg_count out nocopy NUMBER
549: , x_msg_data out nocopy VARCHAR2
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_VARCHAR2_TABLE_200
553: , p5_a3 JTF_VARCHAR2_TABLE_2000
554: , p5_a4 JTF_VARCHAR2_TABLE_100
555: , p5_a5 JTF_DATE_TABLE
556: , p5_a6 JTF_DATE_TABLE

Line 553: , p5_a3 JTF_VARCHAR2_TABLE_2000

549: , x_msg_data out nocopy VARCHAR2
550: , p5_a0 JTF_NUMBER_TABLE
551: , p5_a1 JTF_NUMBER_TABLE
552: , p5_a2 JTF_VARCHAR2_TABLE_200
553: , p5_a3 JTF_VARCHAR2_TABLE_2000
554: , p5_a4 JTF_VARCHAR2_TABLE_100
555: , p5_a5 JTF_DATE_TABLE
556: , p5_a6 JTF_DATE_TABLE
557: , p5_a7 JTF_NUMBER_TABLE

Line 711: , p5_a2 JTF_VARCHAR2_TABLE_200

707: , x_msg_count out nocopy NUMBER
708: , x_msg_data out nocopy VARCHAR2
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_VARCHAR2_TABLE_200
712: , p5_a3 JTF_VARCHAR2_TABLE_2000
713: , p5_a4 JTF_VARCHAR2_TABLE_100
714: , p5_a5 JTF_DATE_TABLE
715: , p5_a6 JTF_DATE_TABLE

Line 712: , p5_a3 JTF_VARCHAR2_TABLE_2000

708: , x_msg_data out nocopy VARCHAR2
709: , p5_a0 JTF_NUMBER_TABLE
710: , p5_a1 JTF_NUMBER_TABLE
711: , p5_a2 JTF_VARCHAR2_TABLE_200
712: , p5_a3 JTF_VARCHAR2_TABLE_2000
713: , p5_a4 JTF_VARCHAR2_TABLE_100
714: , p5_a5 JTF_DATE_TABLE
715: , p5_a6 JTF_DATE_TABLE
716: , p5_a7 JTF_NUMBER_TABLE

Line 725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

721: , p5_a12 JTF_NUMBER_TABLE
722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
727: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
728: , p6_a5 out nocopy JTF_DATE_TABLE
729: , p6_a6 out nocopy JTF_DATE_TABLE

Line 726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

722: , p5_a13 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
726: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
727: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
728: , p6_a5 out nocopy JTF_DATE_TABLE
729: , p6_a6 out nocopy JTF_DATE_TABLE
730: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 871: , p5_a2 JTF_VARCHAR2_TABLE_200

867: , x_msg_count out nocopy NUMBER
868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_VARCHAR2_TABLE_200
872: , p5_a3 JTF_VARCHAR2_TABLE_2000
873: , p5_a4 JTF_VARCHAR2_TABLE_100
874: , p5_a5 JTF_DATE_TABLE
875: , p5_a6 JTF_DATE_TABLE

Line 872: , p5_a3 JTF_VARCHAR2_TABLE_2000

868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_VARCHAR2_TABLE_200
872: , p5_a3 JTF_VARCHAR2_TABLE_2000
873: , p5_a4 JTF_VARCHAR2_TABLE_100
874: , p5_a5 JTF_DATE_TABLE
875: , p5_a6 JTF_DATE_TABLE
876: , p5_a7 JTF_NUMBER_TABLE

Line 998: , p5_a2 JTF_VARCHAR2_TABLE_200

994: , x_msg_count out nocopy NUMBER
995: , x_msg_data out nocopy VARCHAR2
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_VARCHAR2_TABLE_200
999: , p5_a3 JTF_VARCHAR2_TABLE_2000
1000: , p5_a4 JTF_VARCHAR2_TABLE_100
1001: , p5_a5 JTF_DATE_TABLE
1002: , p5_a6 JTF_DATE_TABLE

Line 999: , p5_a3 JTF_VARCHAR2_TABLE_2000

995: , x_msg_data out nocopy VARCHAR2
996: , p5_a0 JTF_NUMBER_TABLE
997: , p5_a1 JTF_NUMBER_TABLE
998: , p5_a2 JTF_VARCHAR2_TABLE_200
999: , p5_a3 JTF_VARCHAR2_TABLE_2000
1000: , p5_a4 JTF_VARCHAR2_TABLE_100
1001: , p5_a5 JTF_DATE_TABLE
1002: , p5_a6 JTF_DATE_TABLE
1003: , p5_a7 JTF_NUMBER_TABLE