DBA Data[Home] [Help]

APPS.OKL_GTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 27: , a2 JTF_VARCHAR2_TABLE_200

23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_gts_pvt.gts_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100

Line 28: , a3 JTF_VARCHAR2_TABLE_2000

24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_gts_pvt.gts_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100

Line 82: , a2 out nocopy JTF_VARCHAR2_TABLE_200

78: end if;
79: end rosetta_table_copy_in_p2;
80: procedure rosetta_table_copy_out_p2(t okl_gts_pvt.gts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

79: end rosetta_table_copy_in_p2;
80: procedure rosetta_table_copy_out_p2(t okl_gts_pvt.gts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 105: a2 := JTF_VARCHAR2_TABLE_200();

101: begin
102: if t is null or t.count = 0 then
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_NUMBER_TABLE();
105: a2 := JTF_VARCHAR2_TABLE_200();
106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();

Line 106: a3 := JTF_VARCHAR2_TABLE_2000();

102: if t is null or t.count = 0 then
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_NUMBER_TABLE();
105: a2 := JTF_VARCHAR2_TABLE_200();
106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();
110: a7 := JTF_VARCHAR2_TABLE_100();

Line 125: a2 := JTF_VARCHAR2_TABLE_200();

121: a18 := JTF_VARCHAR2_TABLE_100();
122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_200();
126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();

Line 126: a3 := JTF_VARCHAR2_TABLE_2000();

122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_200();
126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();
130: a7 := JTF_VARCHAR2_TABLE_100();

Line 196: , a2 JTF_VARCHAR2_TABLE_200

192: end rosetta_table_copy_out_p2;
193:
194: procedure rosetta_table_copy_in_p5(t out nocopy okl_gts_pvt.gtsv_tbl_type, a0 JTF_NUMBER_TABLE
195: , a1 JTF_NUMBER_TABLE
196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100
199: , a5 JTF_VARCHAR2_TABLE_100
200: , a6 JTF_VARCHAR2_TABLE_100

Line 197: , a3 JTF_VARCHAR2_TABLE_2000

193:
194: procedure rosetta_table_copy_in_p5(t out nocopy okl_gts_pvt.gtsv_tbl_type, a0 JTF_NUMBER_TABLE
195: , a1 JTF_NUMBER_TABLE
196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100
199: , a5 JTF_VARCHAR2_TABLE_100
200: , a6 JTF_VARCHAR2_TABLE_100
201: , a7 JTF_VARCHAR2_TABLE_100

Line 251: , a2 out nocopy JTF_VARCHAR2_TABLE_200

247: end if;
248: end rosetta_table_copy_in_p5;
249: procedure rosetta_table_copy_out_p5(t okl_gts_pvt.gtsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

248: end rosetta_table_copy_in_p5;
249: procedure rosetta_table_copy_out_p5(t okl_gts_pvt.gtsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 274: a2 := JTF_VARCHAR2_TABLE_200();

270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();

Line 275: a3 := JTF_VARCHAR2_TABLE_2000();

271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();

Line 294: a2 := JTF_VARCHAR2_TABLE_200();

290: a18 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_200();
295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();

Line 295: a3 := JTF_VARCHAR2_TABLE_2000();

291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_200();
295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_VARCHAR2_TABLE_100();

Line 485: , p5_a2 JTF_VARCHAR2_TABLE_200

481: , x_msg_count out nocopy NUMBER
482: , x_msg_data out nocopy VARCHAR2
483: , p5_a0 JTF_NUMBER_TABLE
484: , p5_a1 JTF_NUMBER_TABLE
485: , p5_a2 JTF_VARCHAR2_TABLE_200
486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 486: , p5_a3 JTF_VARCHAR2_TABLE_2000

482: , x_msg_data out nocopy VARCHAR2
483: , p5_a0 JTF_NUMBER_TABLE
484: , p5_a1 JTF_NUMBER_TABLE
485: , p5_a2 JTF_VARCHAR2_TABLE_200
486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100
490: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 717: , p5_a2 JTF_VARCHAR2_TABLE_200

713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_VARCHAR2_TABLE_200
718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 718: , p5_a3 JTF_VARCHAR2_TABLE_2000

714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_VARCHAR2_TABLE_200
718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 907: , p5_a2 JTF_VARCHAR2_TABLE_200

903: , x_msg_count out nocopy NUMBER
904: , x_msg_data out nocopy VARCHAR2
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_NUMBER_TABLE
907: , p5_a2 JTF_VARCHAR2_TABLE_200
908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 908: , p5_a3 JTF_VARCHAR2_TABLE_2000

904: , x_msg_data out nocopy VARCHAR2
905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_NUMBER_TABLE
907: , p5_a2 JTF_VARCHAR2_TABLE_200
908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_VARCHAR2_TABLE_100