DBA Data[Home] [Help]

APPS.OKL_EVE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_eve_pvt_w as
2: /* $Header: OKLIEVEB.pls 120.0 2005/07/07 10:39:26 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eve_pvt.okl_eve_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500

Line 78: , a2 out nocopy JTF_VARCHAR2_TABLE_100

74: end if;
75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE

Line 81: , a5 out nocopy JTF_VARCHAR2_TABLE_100

77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_VARCHAR2_TABLE_500
85: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 83: , a7 out nocopy JTF_VARCHAR2_TABLE_100

79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_VARCHAR2_TABLE_500
85: , a9 out nocopy JTF_VARCHAR2_TABLE_500
86: , a10 out nocopy JTF_VARCHAR2_TABLE_500
87: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 110: a2 := JTF_VARCHAR2_TABLE_100();

106: begin
107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();

Line 113: a5 := JTF_VARCHAR2_TABLE_100();

109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_500();
117: a9 := JTF_VARCHAR2_TABLE_500();

Line 115: a7 := JTF_VARCHAR2_TABLE_100();

111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_500();
117: a9 := JTF_VARCHAR2_TABLE_500();
118: a10 := JTF_VARCHAR2_TABLE_500();
119: a11 := JTF_VARCHAR2_TABLE_500();

Line 139: a2 := JTF_VARCHAR2_TABLE_100();

135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();

Line 142: a5 := JTF_VARCHAR2_TABLE_100();

138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_VARCHAR2_TABLE_500();
146: a9 := JTF_VARCHAR2_TABLE_500();

Line 144: a7 := JTF_VARCHAR2_TABLE_100();

140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_VARCHAR2_TABLE_500();
146: a9 := JTF_VARCHAR2_TABLE_500();
147: a10 := JTF_VARCHAR2_TABLE_500();
148: a11 := JTF_VARCHAR2_TABLE_500();

Line 393: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 396: , p5_a5 JTF_VARCHAR2_TABLE_100

392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100
399: , p5_a8 JTF_VARCHAR2_TABLE_500
400: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 398: , p5_a7 JTF_VARCHAR2_TABLE_100

394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100
399: , p5_a8 JTF_VARCHAR2_TABLE_500
400: , p5_a9 JTF_VARCHAR2_TABLE_500
401: , p5_a10 JTF_VARCHAR2_TABLE_500
402: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

417: , p5_a26 JTF_DATE_TABLE
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
428: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
428: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
429: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 697: , p5_a2 JTF_VARCHAR2_TABLE_100

693: , x_msg_count out nocopy NUMBER
694: , x_msg_data out nocopy VARCHAR2
695: , p5_a0 JTF_NUMBER_TABLE
696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE

Line 700: , p5_a5 JTF_VARCHAR2_TABLE_100

696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100
703: , p5_a8 JTF_VARCHAR2_TABLE_500
704: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 702: , p5_a7 JTF_VARCHAR2_TABLE_100

698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100
703: , p5_a8 JTF_VARCHAR2_TABLE_500
704: , p5_a9 JTF_VARCHAR2_TABLE_500
705: , p5_a10 JTF_VARCHAR2_TABLE_500
706: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

721: , p5_a26 JTF_DATE_TABLE
722: , p5_a27 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_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
731: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
732: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
731: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
732: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
733: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
734: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 941: , p5_a2 JTF_VARCHAR2_TABLE_100

937: , x_msg_count out nocopy NUMBER
938: , x_msg_data out nocopy VARCHAR2
939: , p5_a0 JTF_NUMBER_TABLE
940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE

Line 944: , p5_a5 JTF_VARCHAR2_TABLE_100

940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100
947: , p5_a8 JTF_VARCHAR2_TABLE_500
948: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 946: , p5_a7 JTF_VARCHAR2_TABLE_100

942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100
947: , p5_a8 JTF_VARCHAR2_TABLE_500
948: , p5_a9 JTF_VARCHAR2_TABLE_500
949: , p5_a10 JTF_VARCHAR2_TABLE_500
950: , p5_a11 JTF_VARCHAR2_TABLE_500