DBA Data[Home] [Help]

APPS.OKL_AET_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 28: , a6 JTF_NUMBER_TABLE

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

Line 30: , a8 JTF_NUMBER_TABLE

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

Line 31: , a9 JTF_NUMBER_TABLE

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

Line 32: , a10 JTF_NUMBER_TABLE

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

Line 34: , a12 JTF_NUMBER_TABLE

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

Line 35: , a13 JTF_NUMBER_TABLE

31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE

Line 37: , a15 JTF_NUMBER_TABLE

33: , a11 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;

Line 39: , a17 JTF_NUMBER_TABLE

35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then

Line 75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

71: end loop;
72: end if;
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE

Line 76: , a1 out nocopy JTF_NUMBER_TABLE

72: end if;
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 79: , a4 out nocopy JTF_NUMBER_TABLE

75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE

Line 81: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 83: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 84: , a9 out nocopy JTF_NUMBER_TABLE

80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE

Line 85: , a10 out nocopy JTF_NUMBER_TABLE

81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE

Line 87: , a12 out nocopy JTF_NUMBER_TABLE

83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE

Line 88: , a13 out nocopy JTF_NUMBER_TABLE

84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE

Line 90: , a15 out nocopy JTF_NUMBER_TABLE

86: , a11 out nocopy JTF_DATE_TABLE
87: , a12 out nocopy JTF_NUMBER_TABLE
88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;

Line 92: , a17 out nocopy JTF_NUMBER_TABLE

88: , a13 out nocopy JTF_NUMBER_TABLE
89: , a14 out nocopy JTF_DATE_TABLE
90: , a15 out nocopy JTF_NUMBER_TABLE
91: , a16 out nocopy JTF_DATE_TABLE
92: , a17 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then

Line 97: a0 := JTF_NUMBER_TABLE();

93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();

Line 98: a1 := JTF_NUMBER_TABLE();

94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();

Line 101: a4 := JTF_NUMBER_TABLE();

97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();

Line 103: a6 := JTF_NUMBER_TABLE();

99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();

Line 105: a8 := JTF_NUMBER_TABLE();

101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();

Line 106: a9 := JTF_NUMBER_TABLE();

102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();

Line 107: a10 := JTF_NUMBER_TABLE();

103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();

Line 109: a12 := JTF_NUMBER_TABLE();

105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();

Line 110: a13 := JTF_NUMBER_TABLE();

106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();

Line 112: a15 := JTF_NUMBER_TABLE();

108: a11 := JTF_DATE_TABLE();
109: a12 := JTF_NUMBER_TABLE();
110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();

Line 114: a17 := JTF_NUMBER_TABLE();

110: a13 := JTF_NUMBER_TABLE();
111: a14 := JTF_DATE_TABLE();
112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();

Line 116: a0 := JTF_NUMBER_TABLE();

112: a15 := JTF_NUMBER_TABLE();
113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();

Line 117: a1 := JTF_NUMBER_TABLE();

113: a16 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();

Line 120: a4 := JTF_NUMBER_TABLE();

116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();

Line 122: a6 := JTF_NUMBER_TABLE();

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

Line 124: a8 := JTF_NUMBER_TABLE();

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

Line 125: a9 := JTF_NUMBER_TABLE();

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

Line 126: a10 := JTF_NUMBER_TABLE();

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

Line 128: a12 := JTF_NUMBER_TABLE();

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

Line 129: a13 := JTF_NUMBER_TABLE();

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

Line 131: a15 := JTF_NUMBER_TABLE();

127: a11 := JTF_DATE_TABLE();
128: a12 := JTF_NUMBER_TABLE();
129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
133: a17 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);

Line 133: a17 := JTF_NUMBER_TABLE();

129: a13 := JTF_NUMBER_TABLE();
130: a14 := JTF_DATE_TABLE();
131: a15 := JTF_NUMBER_TABLE();
132: a16 := JTF_DATE_TABLE();
133: a17 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
136: a1.extend(t.count);
137: a2.extend(t.count);

Line 184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE

180: end if;
181: end if;
182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE

Line 185: , a1 JTF_NUMBER_TABLE

181: end if;
182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE

Line 186: , a2 JTF_NUMBER_TABLE

182: end rosetta_table_copy_out_p2;
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100

Line 189: , a5 JTF_NUMBER_TABLE

185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE

Line 191: , a7 JTF_NUMBER_TABLE

187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE

Line 193: , a9 JTF_NUMBER_TABLE

189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE

Line 194: , a10 JTF_NUMBER_TABLE

190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE

Line 196: , a12 JTF_NUMBER_TABLE

192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE

Line 197: , a13 JTF_NUMBER_TABLE

193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE

Line 199: , a15 JTF_NUMBER_TABLE

195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;

Line 201: , a17 JTF_NUMBER_TABLE

197: , a13 JTF_NUMBER_TABLE
198: , a14 JTF_DATE_TABLE
199: , a15 JTF_NUMBER_TABLE
200: , a16 JTF_DATE_TABLE
201: , a17 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin
205: if a0 is not null and a0.count > 0 then

Line 237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE

Line 238: , a1 out nocopy JTF_NUMBER_TABLE

234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE

Line 239: , a2 out nocopy JTF_NUMBER_TABLE

235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 242: , a5 out nocopy JTF_NUMBER_TABLE

238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE

Line 244: , a7 out nocopy JTF_NUMBER_TABLE

240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE

Line 246: , a9 out nocopy JTF_NUMBER_TABLE

242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE

Line 247: , a10 out nocopy JTF_NUMBER_TABLE

243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE

Line 249: , a12 out nocopy JTF_NUMBER_TABLE

245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE

Line 250: , a13 out nocopy JTF_NUMBER_TABLE

246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE

Line 252: , a15 out nocopy JTF_NUMBER_TABLE

248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE
255: ) as
256: ddindx binary_integer; indx binary_integer;

Line 254: , a17 out nocopy JTF_NUMBER_TABLE

250: , a13 out nocopy JTF_NUMBER_TABLE
251: , a14 out nocopy JTF_DATE_TABLE
252: , a15 out nocopy JTF_NUMBER_TABLE
253: , a16 out nocopy JTF_DATE_TABLE
254: , a17 out nocopy JTF_NUMBER_TABLE
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then

Line 259: a0 := JTF_NUMBER_TABLE();

255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();

Line 260: a1 := JTF_NUMBER_TABLE();

256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();

Line 261: a2 := JTF_NUMBER_TABLE();

257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();

Line 264: a5 := JTF_NUMBER_TABLE();

260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();

Line 266: a7 := JTF_NUMBER_TABLE();

262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();

Line 268: a9 := JTF_NUMBER_TABLE();

264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();

Line 269: a10 := JTF_NUMBER_TABLE();

265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();

Line 271: a12 := JTF_NUMBER_TABLE();

267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();

Line 272: a13 := JTF_NUMBER_TABLE();

268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();

Line 274: a15 := JTF_NUMBER_TABLE();

270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();

Line 276: a17 := JTF_NUMBER_TABLE();

272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_DATE_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();

Line 278: a0 := JTF_NUMBER_TABLE();

274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();

Line 279: a1 := JTF_NUMBER_TABLE();

275: a16 := JTF_DATE_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();

Line 280: a2 := JTF_NUMBER_TABLE();

276: a17 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();

Line 283: a5 := JTF_NUMBER_TABLE();

279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();

Line 285: a7 := JTF_NUMBER_TABLE();

281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();

Line 287: a9 := JTF_NUMBER_TABLE();

283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();

Line 288: a10 := JTF_NUMBER_TABLE();

284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();

Line 290: a12 := JTF_NUMBER_TABLE();

286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();

Line 291: a13 := JTF_NUMBER_TABLE();

287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();

Line 293: a15 := JTF_NUMBER_TABLE();

289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();
296: if t.count > 0 then
297: a0.extend(t.count);

Line 295: a17 := JTF_NUMBER_TABLE();

291: a13 := JTF_NUMBER_TABLE();
292: a14 := JTF_DATE_TABLE();
293: a15 := JTF_NUMBER_TABLE();
294: a16 := JTF_DATE_TABLE();
295: a17 := JTF_NUMBER_TABLE();
296: if t.count > 0 then
297: a0.extend(t.count);
298: a1.extend(t.count);
299: a2.extend(t.count);

Line 462: , p5_a0 JTF_NUMBER_TABLE

458: , p_init_msg_list VARCHAR2
459: , x_return_status out nocopy VARCHAR2
460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE

Line 463: , p5_a1 JTF_NUMBER_TABLE

459: , x_return_status out nocopy VARCHAR2
460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE

Line 464: , p5_a2 JTF_NUMBER_TABLE

460: , x_msg_count out nocopy NUMBER
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 467: , p5_a5 JTF_NUMBER_TABLE

463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE

Line 469: , p5_a7 JTF_NUMBER_TABLE

465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE

Line 471: , p5_a9 JTF_NUMBER_TABLE

467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE

Line 472: , p5_a10 JTF_NUMBER_TABLE

468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE

Line 474: , p5_a12 JTF_NUMBER_TABLE

470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE

Line 475: , p5_a13 JTF_NUMBER_TABLE

471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE

Line 477: , p5_a15 JTF_NUMBER_TABLE

473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 479: , p5_a17 JTF_NUMBER_TABLE

475: , p5_a13 JTF_NUMBER_TABLE
476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 480: , p6_a0 out nocopy JTF_NUMBER_TABLE

476: , p5_a14 JTF_DATE_TABLE
477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE

Line 481: , p6_a1 out nocopy JTF_NUMBER_TABLE

477: , p5_a15 JTF_NUMBER_TABLE
478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 482: , p6_a2 out nocopy JTF_NUMBER_TABLE

478: , p5_a16 JTF_DATE_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 485: , p6_a5 out nocopy JTF_NUMBER_TABLE

481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 487: , p6_a7 out nocopy JTF_NUMBER_TABLE

483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE

Line 489: , p6_a9 out nocopy JTF_NUMBER_TABLE

485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 490: , p6_a10 out nocopy JTF_NUMBER_TABLE

486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE

Line 492: , p6_a12 out nocopy JTF_NUMBER_TABLE

488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE

Line 493: , p6_a13 out nocopy JTF_NUMBER_TABLE

489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 495: , p6_a15 out nocopy JTF_NUMBER_TABLE

491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE
498: )
499:

Line 497: , p6_a17 out nocopy JTF_NUMBER_TABLE

493: , p6_a13 out nocopy JTF_NUMBER_TABLE
494: , p6_a14 out nocopy JTF_DATE_TABLE
495: , p6_a15 out nocopy JTF_NUMBER_TABLE
496: , p6_a16 out nocopy JTF_DATE_TABLE
497: , p6_a17 out nocopy JTF_NUMBER_TABLE
498: )
499:
500: as
501: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;

Line 646: , p5_a0 JTF_NUMBER_TABLE

642: , p_init_msg_list VARCHAR2
643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE

Line 647: , p5_a1 JTF_NUMBER_TABLE

643: , x_return_status out nocopy VARCHAR2
644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE

Line 648: , p5_a2 JTF_NUMBER_TABLE

644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 651: , p5_a5 JTF_NUMBER_TABLE

647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE

Line 653: , p5_a7 JTF_NUMBER_TABLE

649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE

Line 655: , p5_a9 JTF_NUMBER_TABLE

651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE

Line 656: , p5_a10 JTF_NUMBER_TABLE

652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE

Line 658: , p5_a12 JTF_NUMBER_TABLE

654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE

Line 659: , p5_a13 JTF_NUMBER_TABLE

655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE

Line 661: , p5_a15 JTF_NUMBER_TABLE

657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE
664: )
665:

Line 663: , p5_a17 JTF_NUMBER_TABLE

659: , p5_a13 JTF_NUMBER_TABLE
660: , p5_a14 JTF_DATE_TABLE
661: , p5_a15 JTF_NUMBER_TABLE
662: , p5_a16 JTF_DATE_TABLE
663: , p5_a17 JTF_NUMBER_TABLE
664: )
665:
666: as
667: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;

Line 829: , p5_a0 JTF_NUMBER_TABLE

825: , p_init_msg_list VARCHAR2
826: , x_return_status out nocopy VARCHAR2
827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE

Line 830: , p5_a1 JTF_NUMBER_TABLE

826: , x_return_status out nocopy VARCHAR2
827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE

Line 831: , p5_a2 JTF_NUMBER_TABLE

827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 834: , p5_a5 JTF_NUMBER_TABLE

830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE

Line 836: , p5_a7 JTF_NUMBER_TABLE

832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE

Line 838: , p5_a9 JTF_NUMBER_TABLE

834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE

Line 839: , p5_a10 JTF_NUMBER_TABLE

835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE

Line 841: , p5_a12 JTF_NUMBER_TABLE

837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE

Line 842: , p5_a13 JTF_NUMBER_TABLE

838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE

Line 844: , p5_a15 JTF_NUMBER_TABLE

840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 846: , p5_a17 JTF_NUMBER_TABLE

842: , p5_a13 JTF_NUMBER_TABLE
843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 847: , p6_a0 out nocopy JTF_NUMBER_TABLE

843: , p5_a14 JTF_DATE_TABLE
844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE

Line 848: , p6_a1 out nocopy JTF_NUMBER_TABLE

844: , p5_a15 JTF_NUMBER_TABLE
845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 849: , p6_a2 out nocopy JTF_NUMBER_TABLE

845: , p5_a16 JTF_DATE_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 852: , p6_a5 out nocopy JTF_NUMBER_TABLE

848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 854: , p6_a7 out nocopy JTF_NUMBER_TABLE

850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE

Line 856: , p6_a9 out nocopy JTF_NUMBER_TABLE

852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 857: , p6_a10 out nocopy JTF_NUMBER_TABLE

853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE

Line 859: , p6_a12 out nocopy JTF_NUMBER_TABLE

855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE

Line 860: , p6_a13 out nocopy JTF_NUMBER_TABLE

856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 862: , p6_a15 out nocopy JTF_NUMBER_TABLE

858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE
865: )
866:

Line 864: , p6_a17 out nocopy JTF_NUMBER_TABLE

860: , p6_a13 out nocopy JTF_NUMBER_TABLE
861: , p6_a14 out nocopy JTF_DATE_TABLE
862: , p6_a15 out nocopy JTF_NUMBER_TABLE
863: , p6_a16 out nocopy JTF_DATE_TABLE
864: , p6_a17 out nocopy JTF_NUMBER_TABLE
865: )
866:
867: as
868: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;

Line 1013: , p5_a0 JTF_NUMBER_TABLE

1009: , p_init_msg_list VARCHAR2
1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE

Line 1014: , p5_a1 JTF_NUMBER_TABLE

1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE

Line 1015: , p5_a2 JTF_NUMBER_TABLE

1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1018: , p5_a5 JTF_NUMBER_TABLE

1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE

Line 1020: , p5_a7 JTF_NUMBER_TABLE

1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE

Line 1022: , p5_a9 JTF_NUMBER_TABLE

1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE

Line 1023: , p5_a10 JTF_NUMBER_TABLE

1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE

Line 1025: , p5_a12 JTF_NUMBER_TABLE

1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE

Line 1026: , p5_a13 JTF_NUMBER_TABLE

1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE

Line 1028: , p5_a15 JTF_NUMBER_TABLE

1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE
1031: )
1032:

Line 1030: , p5_a17 JTF_NUMBER_TABLE

1026: , p5_a13 JTF_NUMBER_TABLE
1027: , p5_a14 JTF_DATE_TABLE
1028: , p5_a15 JTF_NUMBER_TABLE
1029: , p5_a16 JTF_DATE_TABLE
1030: , p5_a17 JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1034: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;

Line 1156: , p5_a0 JTF_NUMBER_TABLE

1152: , p_init_msg_list VARCHAR2
1153: , x_return_status out nocopy VARCHAR2
1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE

Line 1157: , p5_a1 JTF_NUMBER_TABLE

1153: , x_return_status out nocopy VARCHAR2
1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE

Line 1158: , p5_a2 JTF_NUMBER_TABLE

1154: , x_msg_count out nocopy NUMBER
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1161: , p5_a5 JTF_NUMBER_TABLE

1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE

Line 1163: , p5_a7 JTF_NUMBER_TABLE

1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE

Line 1165: , p5_a9 JTF_NUMBER_TABLE

1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE

Line 1166: , p5_a10 JTF_NUMBER_TABLE

1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE

Line 1168: , p5_a12 JTF_NUMBER_TABLE

1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE

Line 1169: , p5_a13 JTF_NUMBER_TABLE

1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE

Line 1171: , p5_a15 JTF_NUMBER_TABLE

1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE
1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE
1174: )
1175:

Line 1173: , p5_a17 JTF_NUMBER_TABLE

1169: , p5_a13 JTF_NUMBER_TABLE
1170: , p5_a14 JTF_DATE_TABLE
1171: , p5_a15 JTF_NUMBER_TABLE
1172: , p5_a16 JTF_DATE_TABLE
1173: , p5_a17 JTF_NUMBER_TABLE
1174: )
1175:
1176: as
1177: ddp_aetv_tbl okl_aet_pvt.aetv_tbl_type;