APPS.JTF_TERR_LOOKUP_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: );

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p3(t jtf_terr_lookup_pub.org_name_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

Line 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p3(t jtf_terr_lookup_pub.org_name_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
29: , a1 OUT NOCOPY JTF_NUMBER_TABLE

Line 26: , a23 JTF_VARCHAR2_TABLE_100

22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p3(t jtf_terr_lookup_pub.org_name_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
29: , a1 OUT NOCOPY JTF_NUMBER_TABLE
30: , a2 OUT NOCOPY JTF_NUMBER_TABLE

Line 34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100

30: , a2 OUT NOCOPY JTF_NUMBER_TABLE
31: , a3 OUT NOCOPY JTF_NUMBER_TABLE
32: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
33: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100

31: , a3 OUT NOCOPY JTF_NUMBER_TABLE
32: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
33: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100

32: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
33: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100

33: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE

Line 38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

34: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

35: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

36: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
37: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

38: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

39: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

40: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100

41: , a13 OUT NOCOPY JTF_NUMBER_TABLE
42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

42: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

43: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

44: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: );

Line 49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

45: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: );
53:

Line 50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

46: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p5(t OUT NOCOPY jtf_terr_lookup_pub.win_rsc_tbl_type, a0 JTF_NUMBER_TABLE

Line 51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

47: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
48: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
50: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p5(t OUT NOCOPY jtf_terr_lookup_pub.win_rsc_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE

Line 83: procedure rosetta_table_copy_in_p7(t OUT NOCOPY jtf_terr_lookup_pub.winners_tbl_type, a0 JTF_VARCHAR2_TABLE_100

79: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_200
80: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_200
81: );
82:
83: procedure rosetta_table_copy_in_p7(t OUT NOCOPY jtf_terr_lookup_pub.winners_tbl_type, a0 JTF_VARCHAR2_TABLE_100
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_NUMBER_TABLE
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_NUMBER_TABLE

Line 122: procedure rosetta_table_copy_out_p7(t jtf_terr_lookup_pub.winners_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

118: , a35 JTF_VARCHAR2_TABLE_400
119: , a36 JTF_VARCHAR2_TABLE_400
120: , a37 JTF_VARCHAR2_TABLE_400
121: );
122: procedure rosetta_table_copy_out_p7(t jtf_terr_lookup_pub.winners_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
123: , a1 OUT NOCOPY JTF_NUMBER_TABLE
124: , a2 OUT NOCOPY JTF_NUMBER_TABLE
125: , a3 OUT NOCOPY JTF_NUMBER_TABLE
126: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100

186: , p22_a2 OUT NOCOPY JTF_NUMBER_TABLE
187: , p22_a3 OUT NOCOPY JTF_NUMBER_TABLE
188: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
189: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100

187: , p22_a3 OUT NOCOPY JTF_NUMBER_TABLE
188: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
189: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100

188: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
189: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100

189: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE

Line 194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

190: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

191: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

192: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
193: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

194: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

195: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

196: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100

197: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

198: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

199: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

200: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
208: );

Line 205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

201: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
208: );
209: procedure get_winners(p_api_version_number NUMBER

Line 206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

202: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
208: );
209: procedure get_winners(p_api_version_number NUMBER
210: , p_init_msg_list VARCHAR2

Line 207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

203: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
204: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
205: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
206: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
207: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
208: );
209: procedure get_winners(p_api_version_number NUMBER
210: , p_init_msg_list VARCHAR2
211: , p2_a0 VARCHAR2

Line 323: , p10_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

319: , p_role VARCHAR2
320: , x_return_status OUT NOCOPY VARCHAR2
321: , x_msg_count OUT NOCOPY NUMBER
322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p10_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
324: , p10_a1 OUT NOCOPY JTF_NUMBER_TABLE
325: , p10_a2 OUT NOCOPY JTF_NUMBER_TABLE
326: , p10_a3 OUT NOCOPY JTF_NUMBER_TABLE
327: , p10_a4 OUT NOCOPY JTF_NUMBER_TABLE