eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_LOOKUP_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_VARCHAR2_TABLE_100

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

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_400
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_VARCHAR2_TABLE_400
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100

Line 36: , a14 JTF_VARCHAR2_TABLE_100

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100

Line 37: , a15 JTF_VARCHAR2_TABLE_100

33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100

Line 38: , a16 JTF_VARCHAR2_TABLE_100

34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100

Line 39: , a17 JTF_VARCHAR2_TABLE_100

35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100

Line 40: , a18 JTF_VARCHAR2_TABLE_100

36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100

Line 41: , a19 JTF_VARCHAR2_TABLE_100

37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100

Line 42: , a20 JTF_VARCHAR2_TABLE_100

38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: ) as

Line 43: , a21 JTF_VARCHAR2_TABLE_100

39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;

Line 44: , a22 JTF_VARCHAR2_TABLE_100

40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin

Line 45: , a23 JTF_VARCHAR2_TABLE_100

41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100
45: , a23 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if a0 is not null and a0.count > 0 then

Line 93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100

89: , a2 OUT NOCOPY JTF_NUMBER_TABLE
90: , a3 OUT NOCOPY JTF_NUMBER_TABLE
91: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
92: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100

90: , a3 OUT NOCOPY JTF_NUMBER_TABLE
91: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
92: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100

91: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
92: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100

92: , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE

Line 97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

93: , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

94: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

95: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
96: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

97: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

98: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

99: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100

100: , a13 OUT NOCOPY JTF_NUMBER_TABLE
101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

101: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

102: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

103: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
111: ) as

Line 108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

104: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;

Line 109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

105: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin

Line 110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

106: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
107: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
109: , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
110: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then

Line 121: a6 := JTF_VARCHAR2_TABLE_100();

117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_400();
120: a5 := JTF_VARCHAR2_TABLE_300();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();

Line 122: a7 := JTF_VARCHAR2_TABLE_100();

118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_VARCHAR2_TABLE_400();
120: a5 := JTF_VARCHAR2_TABLE_300();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();

Line 123: a8 := JTF_VARCHAR2_TABLE_100();

119: a4 := JTF_VARCHAR2_TABLE_400();
120: a5 := JTF_VARCHAR2_TABLE_300();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();

Line 124: a9 := JTF_VARCHAR2_TABLE_100();

120: a5 := JTF_VARCHAR2_TABLE_300();
121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();

Line 125: a10 := JTF_VARCHAR2_TABLE_100();

121: a6 := JTF_VARCHAR2_TABLE_100();
122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();

Line 126: a11 := JTF_VARCHAR2_TABLE_100();

122: a7 := JTF_VARCHAR2_TABLE_100();
123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();

Line 127: a12 := JTF_VARCHAR2_TABLE_100();

123: a8 := JTF_VARCHAR2_TABLE_100();
124: a9 := JTF_VARCHAR2_TABLE_100();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();

Line 129: a14 := JTF_VARCHAR2_TABLE_100();

125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();

Line 130: a15 := JTF_VARCHAR2_TABLE_100();

126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();

Line 131: a16 := JTF_VARCHAR2_TABLE_100();

127: a12 := JTF_VARCHAR2_TABLE_100();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();

Line 132: a17 := JTF_VARCHAR2_TABLE_100();

128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();

Line 133: a18 := JTF_VARCHAR2_TABLE_100();

129: a14 := JTF_VARCHAR2_TABLE_100();
130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();

Line 134: a19 := JTF_VARCHAR2_TABLE_100();

130: a15 := JTF_VARCHAR2_TABLE_100();
131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();
138: a23 := JTF_VARCHAR2_TABLE_100();

Line 135: a20 := JTF_VARCHAR2_TABLE_100();

131: a16 := JTF_VARCHAR2_TABLE_100();
132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();
138: a23 := JTF_VARCHAR2_TABLE_100();
139: else

Line 136: a21 := JTF_VARCHAR2_TABLE_100();

132: a17 := JTF_VARCHAR2_TABLE_100();
133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();
138: a23 := JTF_VARCHAR2_TABLE_100();
139: else
140: a0 := JTF_NUMBER_TABLE();

Line 137: a22 := JTF_VARCHAR2_TABLE_100();

133: a18 := JTF_VARCHAR2_TABLE_100();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();
138: a23 := JTF_VARCHAR2_TABLE_100();
139: else
140: a0 := JTF_NUMBER_TABLE();
141: a1 := JTF_NUMBER_TABLE();

Line 138: a23 := JTF_VARCHAR2_TABLE_100();

134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_VARCHAR2_TABLE_100();
136: a21 := JTF_VARCHAR2_TABLE_100();
137: a22 := JTF_VARCHAR2_TABLE_100();
138: a23 := JTF_VARCHAR2_TABLE_100();
139: else
140: a0 := JTF_NUMBER_TABLE();
141: a1 := JTF_NUMBER_TABLE();
142: a2 := JTF_NUMBER_TABLE();

Line 146: a6 := JTF_VARCHAR2_TABLE_100();

142: a2 := JTF_NUMBER_TABLE();
143: a3 := JTF_NUMBER_TABLE();
144: a4 := JTF_VARCHAR2_TABLE_400();
145: a5 := JTF_VARCHAR2_TABLE_300();
146: a6 := JTF_VARCHAR2_TABLE_100();
147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();

Line 147: a7 := JTF_VARCHAR2_TABLE_100();

143: a3 := JTF_NUMBER_TABLE();
144: a4 := JTF_VARCHAR2_TABLE_400();
145: a5 := JTF_VARCHAR2_TABLE_300();
146: a6 := JTF_VARCHAR2_TABLE_100();
147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();

Line 148: a8 := JTF_VARCHAR2_TABLE_100();

144: a4 := JTF_VARCHAR2_TABLE_400();
145: a5 := JTF_VARCHAR2_TABLE_300();
146: a6 := JTF_VARCHAR2_TABLE_100();
147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();

Line 149: a9 := JTF_VARCHAR2_TABLE_100();

145: a5 := JTF_VARCHAR2_TABLE_300();
146: a6 := JTF_VARCHAR2_TABLE_100();
147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();

Line 150: a10 := JTF_VARCHAR2_TABLE_100();

146: a6 := JTF_VARCHAR2_TABLE_100();
147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();

Line 151: a11 := JTF_VARCHAR2_TABLE_100();

147: a7 := JTF_VARCHAR2_TABLE_100();
148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();

Line 152: a12 := JTF_VARCHAR2_TABLE_100();

148: a8 := JTF_VARCHAR2_TABLE_100();
149: a9 := JTF_VARCHAR2_TABLE_100();
150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();

Line 154: a14 := JTF_VARCHAR2_TABLE_100();

150: a10 := JTF_VARCHAR2_TABLE_100();
151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();

Line 155: a15 := JTF_VARCHAR2_TABLE_100();

151: a11 := JTF_VARCHAR2_TABLE_100();
152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();

Line 156: a16 := JTF_VARCHAR2_TABLE_100();

152: a12 := JTF_VARCHAR2_TABLE_100();
153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();

Line 157: a17 := JTF_VARCHAR2_TABLE_100();

153: a13 := JTF_NUMBER_TABLE();
154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();

Line 158: a18 := JTF_VARCHAR2_TABLE_100();

154: a14 := JTF_VARCHAR2_TABLE_100();
155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();

Line 159: a19 := JTF_VARCHAR2_TABLE_100();

155: a15 := JTF_VARCHAR2_TABLE_100();
156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();
163: a23 := JTF_VARCHAR2_TABLE_100();

Line 160: a20 := JTF_VARCHAR2_TABLE_100();

156: a16 := JTF_VARCHAR2_TABLE_100();
157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();
163: a23 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then

Line 161: a21 := JTF_VARCHAR2_TABLE_100();

157: a17 := JTF_VARCHAR2_TABLE_100();
158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();
163: a23 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);

Line 162: a22 := JTF_VARCHAR2_TABLE_100();

158: a18 := JTF_VARCHAR2_TABLE_100();
159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();
163: a23 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);

Line 163: a23 := JTF_VARCHAR2_TABLE_100();

159: a19 := JTF_VARCHAR2_TABLE_100();
160: a20 := JTF_VARCHAR2_TABLE_100();
161: a21 := JTF_VARCHAR2_TABLE_100();
162: a22 := JTF_VARCHAR2_TABLE_100();
163: a23 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);
167: a2.extend(t.count);

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

349: end if;
350: end if;
351: end rosetta_table_copy_out_p5;
352:
353: procedure rosetta_table_copy_in_p7(t OUT NOCOPY jtf_terr_lookup_pub.winners_tbl_type, a0 JTF_VARCHAR2_TABLE_100
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_NUMBER_TABLE
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_NUMBER_TABLE

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

442: end loop;
443: end if;
444: end if;
445: end rosetta_table_copy_in_p7;
446: procedure rosetta_table_copy_out_p7(t jtf_terr_lookup_pub.winners_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
447: , a1 OUT NOCOPY JTF_NUMBER_TABLE
448: , a2 OUT NOCOPY JTF_NUMBER_TABLE
449: , a3 OUT NOCOPY JTF_NUMBER_TABLE
450: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 488: a0 := JTF_VARCHAR2_TABLE_100();

484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
488: a0 := JTF_VARCHAR2_TABLE_100();
489: a1 := JTF_NUMBER_TABLE();
490: a2 := JTF_NUMBER_TABLE();
491: a3 := JTF_NUMBER_TABLE();
492: a4 := JTF_NUMBER_TABLE();

Line 527: a0 := JTF_VARCHAR2_TABLE_100();

523: a35 := JTF_VARCHAR2_TABLE_400();
524: a36 := JTF_VARCHAR2_TABLE_400();
525: a37 := JTF_VARCHAR2_TABLE_400();
526: else
527: a0 := JTF_VARCHAR2_TABLE_100();
528: a1 := JTF_NUMBER_TABLE();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_NUMBER_TABLE();

Line 683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100

679: , p22_a2 OUT NOCOPY JTF_NUMBER_TABLE
680: , p22_a3 OUT NOCOPY JTF_NUMBER_TABLE
681: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
682: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100

680: , p22_a3 OUT NOCOPY JTF_NUMBER_TABLE
681: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
682: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100

681: , p22_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_400
682: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100

682: , p22_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_300
683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE

Line 687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

683: , p22_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100

684: , p22_a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

685: , p22_a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
686: , p22_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

687: , p22_a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100

688: , p22_a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

689: , p22_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100

690: , p22_a13 OUT NOCOPY JTF_NUMBER_TABLE
691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100

691: , p22_a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100

692: , p22_a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100

693: , p22_a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
701: )

Line 698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100

694: , p22_a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
701: )
702: as

Line 699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100

695: , p22_a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
701: )
702: as
703: ddx_result_tbl jtf_terr_lookup_pub.org_name_tbl_type;

Line 700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100

696: , p22_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
697: , p22_a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
698: , p22_a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
699: , p22_a22 OUT NOCOPY JTF_VARCHAR2_TABLE_100
700: , p22_a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
701: )
702: as
703: ddx_result_tbl jtf_terr_lookup_pub.org_name_tbl_type;
704: ddindx binary_integer; indx binary_integer;

Line 920: , p10_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

916: , p_role VARCHAR2
917: , x_return_status OUT NOCOPY VARCHAR2
918: , x_msg_count OUT NOCOPY NUMBER
919: , x_msg_data OUT NOCOPY VARCHAR2
920: , p10_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
921: , p10_a1 OUT NOCOPY JTF_NUMBER_TABLE
922: , p10_a2 OUT NOCOPY JTF_NUMBER_TABLE
923: , p10_a3 OUT NOCOPY JTF_NUMBER_TABLE
924: , p10_a4 OUT NOCOPY JTF_NUMBER_TABLE