DBA Data[Home] [Help]

APPS.AHL_LTP_MATRL_AVAL_PUB_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100

Line 21: , a5 JTF_NUMBER_TABLE

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100

Line 23: , a7 JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE

Line 28: , a12 JTF_NUMBER_TABLE

24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_DATE_TABLE
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_NUMBER_TABLE

Line 29: , a13 JTF_NUMBER_TABLE

25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_DATE_TABLE
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_2000

Line 32: , a16 JTF_NUMBER_TABLE

28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_DATE_TABLE
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_2000
34: , a18 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;

Line 71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE

Line 72: , a1 out nocopy JTF_NUMBER_TABLE

68: end if;
69: end if;
70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE

Line 73: , a2 out nocopy JTF_NUMBER_TABLE

69: end if;
70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE

Line 75: , a4 out nocopy JTF_NUMBER_TABLE

71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a5 out nocopy JTF_NUMBER_TABLE

72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , a6 out nocopy JTF_NUMBER_TABLE

73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 78: , a7 out nocopy JTF_NUMBER_TABLE

74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE

Line 83: , a12 out nocopy JTF_NUMBER_TABLE

79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE
85: , a14 out nocopy JTF_DATE_TABLE
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: , a16 out nocopy JTF_NUMBER_TABLE

Line 84: , a13 out nocopy JTF_NUMBER_TABLE

80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE
85: , a14 out nocopy JTF_DATE_TABLE
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: , a16 out nocopy JTF_NUMBER_TABLE
88: , a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 87: , a16 out nocopy JTF_NUMBER_TABLE

83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE
85: , a14 out nocopy JTF_DATE_TABLE
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: , a16 out nocopy JTF_NUMBER_TABLE
88: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
89: , a18 out nocopy JTF_VARCHAR2_TABLE_100
90: ) as
91: ddindx binary_integer; indx binary_integer;

Line 94: a0 := JTF_NUMBER_TABLE();

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

Line 95: a1 := JTF_NUMBER_TABLE();

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

Line 96: a2 := JTF_NUMBER_TABLE();

92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();

Line 98: a4 := JTF_NUMBER_TABLE();

94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_VARCHAR2_TABLE_100();

Line 99: a5 := JTF_NUMBER_TABLE();

95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_VARCHAR2_TABLE_100();
103: a9 := JTF_VARCHAR2_TABLE_100();

Line 100: a6 := JTF_NUMBER_TABLE();

96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_VARCHAR2_TABLE_100();
103: a9 := JTF_VARCHAR2_TABLE_100();
104: a10 := JTF_VARCHAR2_TABLE_100();

Line 101: a7 := JTF_NUMBER_TABLE();

97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();
102: a8 := JTF_VARCHAR2_TABLE_100();
103: a9 := JTF_VARCHAR2_TABLE_100();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_DATE_TABLE();

Line 106: a12 := JTF_NUMBER_TABLE();

102: a8 := JTF_VARCHAR2_TABLE_100();
103: a9 := JTF_VARCHAR2_TABLE_100();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_DATE_TABLE();
106: a12 := JTF_NUMBER_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();

Line 107: a13 := JTF_NUMBER_TABLE();

103: a9 := JTF_VARCHAR2_TABLE_100();
104: a10 := JTF_VARCHAR2_TABLE_100();
105: a11 := JTF_DATE_TABLE();
106: a12 := JTF_NUMBER_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();
111: a17 := JTF_VARCHAR2_TABLE_2000();

Line 110: a16 := JTF_NUMBER_TABLE();

106: a12 := JTF_NUMBER_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();
111: a17 := JTF_VARCHAR2_TABLE_2000();
112: a18 := JTF_VARCHAR2_TABLE_100();
113: else
114: a0 := JTF_NUMBER_TABLE();

Line 114: a0 := JTF_NUMBER_TABLE();

110: a16 := JTF_NUMBER_TABLE();
111: a17 := JTF_VARCHAR2_TABLE_2000();
112: a18 := JTF_VARCHAR2_TABLE_100();
113: else
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_VARCHAR2_TABLE_100();
118: a4 := JTF_NUMBER_TABLE();

Line 115: a1 := JTF_NUMBER_TABLE();

111: a17 := JTF_VARCHAR2_TABLE_2000();
112: a18 := JTF_VARCHAR2_TABLE_100();
113: else
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_VARCHAR2_TABLE_100();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();

Line 116: a2 := JTF_NUMBER_TABLE();

112: a18 := JTF_VARCHAR2_TABLE_100();
113: else
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_VARCHAR2_TABLE_100();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();

Line 118: a4 := JTF_NUMBER_TABLE();

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

Line 119: a5 := JTF_NUMBER_TABLE();

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

Line 120: a6 := JTF_NUMBER_TABLE();

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

Line 121: a7 := JTF_NUMBER_TABLE();

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

Line 126: a12 := JTF_NUMBER_TABLE();

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

Line 127: a13 := JTF_NUMBER_TABLE();

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

Line 130: a16 := JTF_NUMBER_TABLE();

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

Line 185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE

181: end if;
182: end if;
183: end rosetta_table_copy_out_p3;
184:
185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100

Line 186: , a1 JTF_NUMBER_TABLE

182: end if;
183: end rosetta_table_copy_out_p3;
184:
185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100
190: , a5 JTF_VARCHAR2_TABLE_100

Line 187: , a2 JTF_NUMBER_TABLE

183: end rosetta_table_copy_out_p3;
184:
185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100
190: , a5 JTF_VARCHAR2_TABLE_100
191: , a6 JTF_NUMBER_TABLE

Line 191: , a6 JTF_NUMBER_TABLE

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

Line 192: , a7 JTF_NUMBER_TABLE

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

Line 193: , a8 JTF_NUMBER_TABLE

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

Line 197: , a12 JTF_NUMBER_TABLE

193: , a8 JTF_NUMBER_TABLE
194: , a9 JTF_VARCHAR2_TABLE_100
195: , a10 JTF_DATE_TABLE
196: , a11 JTF_VARCHAR2_TABLE_100
197: , a12 JTF_NUMBER_TABLE
198: , a13 JTF_DATE_TABLE
199: , a14 JTF_VARCHAR2_TABLE_300
200: , a15 JTF_NUMBER_TABLE
201: ) as

Line 200: , a15 JTF_NUMBER_TABLE

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

Line 234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE

230: end loop;
231: end if;
232: end if;
233: end rosetta_table_copy_in_p4;
234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 235: , a1 out nocopy JTF_NUMBER_TABLE

231: end if;
232: end if;
233: end rosetta_table_copy_in_p4;
234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 236: , a2 out nocopy JTF_NUMBER_TABLE

232: end if;
233: end rosetta_table_copy_in_p4;
234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE

Line 240: , a6 out nocopy JTF_NUMBER_TABLE

236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE

Line 241: , a7 out nocopy JTF_NUMBER_TABLE

237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE
245: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 242: , a8 out nocopy JTF_NUMBER_TABLE

238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE
245: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a12 out nocopy JTF_NUMBER_TABLE

Line 246: , a12 out nocopy JTF_NUMBER_TABLE

242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE
245: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a12 out nocopy JTF_NUMBER_TABLE
247: , a13 out nocopy JTF_DATE_TABLE
248: , a14 out nocopy JTF_VARCHAR2_TABLE_300
249: , a15 out nocopy JTF_NUMBER_TABLE
250: ) as

Line 249: , a15 out nocopy JTF_NUMBER_TABLE

245: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a12 out nocopy JTF_NUMBER_TABLE
247: , a13 out nocopy JTF_DATE_TABLE
248: , a14 out nocopy JTF_VARCHAR2_TABLE_300
249: , a15 out nocopy JTF_NUMBER_TABLE
250: ) as
251: ddindx binary_integer; indx binary_integer;
252: begin
253: if t is null or t.count = 0 then

Line 254: a0 := JTF_NUMBER_TABLE();

250: ) as
251: ddindx binary_integer; indx binary_integer;
252: begin
253: if t is null or t.count = 0 then
254: a0 := JTF_NUMBER_TABLE();
255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();

Line 255: a1 := JTF_NUMBER_TABLE();

251: ddindx binary_integer; indx binary_integer;
252: begin
253: if t is null or t.count = 0 then
254: a0 := JTF_NUMBER_TABLE();
255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();

Line 256: a2 := JTF_NUMBER_TABLE();

252: begin
253: if t is null or t.count = 0 then
254: a0 := JTF_NUMBER_TABLE();
255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();

Line 260: a6 := JTF_NUMBER_TABLE();

256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();

Line 261: a7 := JTF_NUMBER_TABLE();

257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();
265: a11 := JTF_VARCHAR2_TABLE_100();

Line 262: a8 := JTF_NUMBER_TABLE();

258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();
265: a11 := JTF_VARCHAR2_TABLE_100();
266: a12 := JTF_NUMBER_TABLE();

Line 266: a12 := JTF_NUMBER_TABLE();

262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();
265: a11 := JTF_VARCHAR2_TABLE_100();
266: a12 := JTF_NUMBER_TABLE();
267: a13 := JTF_DATE_TABLE();
268: a14 := JTF_VARCHAR2_TABLE_300();
269: a15 := JTF_NUMBER_TABLE();
270: else

Line 269: a15 := JTF_NUMBER_TABLE();

265: a11 := JTF_VARCHAR2_TABLE_100();
266: a12 := JTF_NUMBER_TABLE();
267: a13 := JTF_DATE_TABLE();
268: a14 := JTF_VARCHAR2_TABLE_300();
269: a15 := JTF_NUMBER_TABLE();
270: else
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();

Line 271: a0 := JTF_NUMBER_TABLE();

267: a13 := JTF_DATE_TABLE();
268: a14 := JTF_VARCHAR2_TABLE_300();
269: a15 := JTF_NUMBER_TABLE();
270: else
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();

Line 272: a1 := JTF_NUMBER_TABLE();

268: a14 := JTF_VARCHAR2_TABLE_300();
269: a15 := JTF_NUMBER_TABLE();
270: else
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();

Line 273: a2 := JTF_NUMBER_TABLE();

269: a15 := JTF_NUMBER_TABLE();
270: else
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();

Line 277: a6 := JTF_NUMBER_TABLE();

273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();

Line 278: a7 := JTF_NUMBER_TABLE();

274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();
282: a11 := JTF_VARCHAR2_TABLE_100();

Line 279: a8 := JTF_NUMBER_TABLE();

275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();
282: a11 := JTF_VARCHAR2_TABLE_100();
283: a12 := JTF_NUMBER_TABLE();

Line 283: a12 := JTF_NUMBER_TABLE();

279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();
282: a11 := JTF_VARCHAR2_TABLE_100();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_DATE_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_300();
286: a15 := JTF_NUMBER_TABLE();
287: if t.count > 0 then

Line 286: a15 := JTF_NUMBER_TABLE();

282: a11 := JTF_VARCHAR2_TABLE_100();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_DATE_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_300();
286: a15 := JTF_NUMBER_TABLE();
287: if t.count > 0 then
288: a0.extend(t.count);
289: a1.extend(t.count);
290: a2.extend(t.count);

Line 333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE

329: end if;
330: end if;
331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE

Line 334: , a1 JTF_NUMBER_TABLE

330: end if;
331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE

Line 335: , a2 JTF_NUMBER_TABLE

331: end rosetta_table_copy_out_p4;
332:
333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE

Line 337: , a4 JTF_NUMBER_TABLE

333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100

Line 338: , a5 JTF_NUMBER_TABLE

334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100

Line 339: , a6 JTF_NUMBER_TABLE

335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100

Line 345: , a12 JTF_NUMBER_TABLE

341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100
344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100

Line 346: , a13 JTF_NUMBER_TABLE

342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100
344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100
350: , a17 JTF_VARCHAR2_TABLE_100

Line 351: , a18 JTF_NUMBER_TABLE

347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100
350: , a17 JTF_VARCHAR2_TABLE_100
351: , a18 JTF_NUMBER_TABLE
352: , a19 JTF_VARCHAR2_TABLE_2000
353: ) as
354: ddindx binary_integer; indx binary_integer;
355: begin

Line 390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE

386: end loop;
387: end if;
388: end if;
389: end rosetta_table_copy_in_p5;
390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE

Line 391: , a1 out nocopy JTF_NUMBER_TABLE

387: end if;
388: end if;
389: end rosetta_table_copy_in_p5;
390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE

Line 392: , a2 out nocopy JTF_NUMBER_TABLE

388: end if;
389: end rosetta_table_copy_in_p5;
390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE

Line 394: , a4 out nocopy JTF_NUMBER_TABLE

390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 395: , a5 out nocopy JTF_NUMBER_TABLE

391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 396: , a6 out nocopy JTF_NUMBER_TABLE

392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 402: , a12 out nocopy JTF_NUMBER_TABLE

398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 403: , a13 out nocopy JTF_NUMBER_TABLE

399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100
407: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 408: , a18 out nocopy JTF_NUMBER_TABLE

404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100
407: , a17 out nocopy JTF_VARCHAR2_TABLE_100
408: , a18 out nocopy JTF_NUMBER_TABLE
409: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
410: ) as
411: ddindx binary_integer; indx binary_integer;
412: begin

Line 414: a0 := JTF_NUMBER_TABLE();

410: ) as
411: ddindx binary_integer; indx binary_integer;
412: begin
413: if t is null or t.count = 0 then
414: a0 := JTF_NUMBER_TABLE();
415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();

Line 415: a1 := JTF_NUMBER_TABLE();

411: ddindx binary_integer; indx binary_integer;
412: begin
413: if t is null or t.count = 0 then
414: a0 := JTF_NUMBER_TABLE();
415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();

Line 416: a2 := JTF_NUMBER_TABLE();

412: begin
413: if t is null or t.count = 0 then
414: a0 := JTF_NUMBER_TABLE();
415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();

Line 418: a4 := JTF_NUMBER_TABLE();

414: a0 := JTF_NUMBER_TABLE();
415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();

Line 419: a5 := JTF_NUMBER_TABLE();

415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();

Line 420: a6 := JTF_NUMBER_TABLE();

416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();

Line 426: a12 := JTF_NUMBER_TABLE();

422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();
425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();

Line 427: a13 := JTF_NUMBER_TABLE();

423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();
425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();
431: a17 := JTF_VARCHAR2_TABLE_100();

Line 432: a18 := JTF_NUMBER_TABLE();

428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();
431: a17 := JTF_VARCHAR2_TABLE_100();
432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else
435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();

Line 435: a0 := JTF_NUMBER_TABLE();

431: a17 := JTF_VARCHAR2_TABLE_100();
432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else
435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();

Line 436: a1 := JTF_NUMBER_TABLE();

432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else
435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();

Line 437: a2 := JTF_NUMBER_TABLE();

433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else
435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();

Line 439: a4 := JTF_NUMBER_TABLE();

435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();

Line 440: a5 := JTF_NUMBER_TABLE();

436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();

Line 441: a6 := JTF_NUMBER_TABLE();

437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();

Line 447: a12 := JTF_NUMBER_TABLE();

443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();
446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();

Line 448: a13 := JTF_NUMBER_TABLE();

444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();
446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();
452: a17 := JTF_VARCHAR2_TABLE_100();

Line 453: a18 := JTF_NUMBER_TABLE();

449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();
452: a17 := JTF_VARCHAR2_TABLE_100();
453: a18 := JTF_NUMBER_TABLE();
454: a19 := JTF_VARCHAR2_TABLE_2000();
455: if t.count > 0 then
456: a0.extend(t.count);
457: a1.extend(t.count);

Line 514: , p5_a0 in out nocopy JTF_NUMBER_TABLE

510: , p_init_msg_list VARCHAR2
511: , p_commit VARCHAR2
512: , p_validation_level NUMBER
513: , p_module_type VARCHAR2
514: , p5_a0 in out nocopy JTF_NUMBER_TABLE
515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 515: , p5_a1 in out nocopy JTF_NUMBER_TABLE

511: , p_commit VARCHAR2
512: , p_validation_level NUMBER
513: , p_module_type VARCHAR2
514: , p5_a0 in out nocopy JTF_NUMBER_TABLE
515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 516: , p5_a2 in out nocopy JTF_NUMBER_TABLE

512: , p_validation_level NUMBER
513: , p_module_type VARCHAR2
514: , p5_a0 in out nocopy JTF_NUMBER_TABLE
515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE

Line 518: , p5_a4 in out nocopy JTF_NUMBER_TABLE

514: , p5_a0 in out nocopy JTF_NUMBER_TABLE
515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 519: , p5_a5 in out nocopy JTF_NUMBER_TABLE

515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 520: , p5_a6 in out nocopy JTF_NUMBER_TABLE

516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 521: , p5_a7 in out nocopy JTF_NUMBER_TABLE

517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE

Line 526: , p5_a12 in out nocopy JTF_NUMBER_TABLE

522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE
528: , p5_a14 in out nocopy JTF_DATE_TABLE
529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p5_a16 in out nocopy JTF_NUMBER_TABLE

Line 527: , p5_a13 in out nocopy JTF_NUMBER_TABLE

523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE
528: , p5_a14 in out nocopy JTF_DATE_TABLE
529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p5_a16 in out nocopy JTF_NUMBER_TABLE
531: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 530: , p5_a16 in out nocopy JTF_NUMBER_TABLE

526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE
528: , p5_a14 in out nocopy JTF_DATE_TABLE
529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p5_a16 in out nocopy JTF_NUMBER_TABLE
531: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER

Line 621: , p6_a0 out nocopy JTF_NUMBER_TABLE

617: , p_commit VARCHAR2
618: , p_validation_level NUMBER
619: , p_module_type VARCHAR2
620: , p_visit_id NUMBER
621: , p6_a0 out nocopy JTF_NUMBER_TABLE
622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 622: , p6_a1 out nocopy JTF_NUMBER_TABLE

618: , p_validation_level NUMBER
619: , p_module_type VARCHAR2
620: , p_visit_id NUMBER
621: , p6_a0 out nocopy JTF_NUMBER_TABLE
622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 623: , p6_a2 out nocopy JTF_NUMBER_TABLE

619: , p_module_type VARCHAR2
620: , p_visit_id NUMBER
621: , p6_a0 out nocopy JTF_NUMBER_TABLE
622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 627: , p6_a6 out nocopy JTF_NUMBER_TABLE

623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE

Line 628: , p6_a7 out nocopy JTF_NUMBER_TABLE

624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE
632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 629: , p6_a8 out nocopy JTF_NUMBER_TABLE

625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE
632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 633: , p6_a12 out nocopy JTF_NUMBER_TABLE

629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE
632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a12 out nocopy JTF_NUMBER_TABLE
634: , p6_a13 out nocopy JTF_DATE_TABLE
635: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
636: , p6_a15 out nocopy JTF_NUMBER_TABLE
637: , x_return_status out nocopy VARCHAR2

Line 636: , p6_a15 out nocopy JTF_NUMBER_TABLE

632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a12 out nocopy JTF_NUMBER_TABLE
634: , p6_a13 out nocopy JTF_DATE_TABLE
635: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
636: , p6_a15 out nocopy JTF_NUMBER_TABLE
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER
639: , x_msg_data out nocopy VARCHAR2
640: )

Line 705: , p6_a0 out nocopy JTF_NUMBER_TABLE

701: , p_commit VARCHAR2
702: , p_validation_level NUMBER
703: , p_module_type VARCHAR2
704: , p_visit_id NUMBER
705: , p6_a0 out nocopy JTF_NUMBER_TABLE
706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 706: , p6_a1 out nocopy JTF_NUMBER_TABLE

702: , p_validation_level NUMBER
703: , p_module_type VARCHAR2
704: , p_visit_id NUMBER
705: , p6_a0 out nocopy JTF_NUMBER_TABLE
706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 707: , p6_a2 out nocopy JTF_NUMBER_TABLE

703: , p_module_type VARCHAR2
704: , p_visit_id NUMBER
705: , p6_a0 out nocopy JTF_NUMBER_TABLE
706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 709: , p6_a4 out nocopy JTF_NUMBER_TABLE

705: , p6_a0 out nocopy JTF_NUMBER_TABLE
706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 710: , p6_a5 out nocopy JTF_NUMBER_TABLE

706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 711: , p6_a6 out nocopy JTF_NUMBER_TABLE

707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 712: , p6_a7 out nocopy JTF_NUMBER_TABLE

708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE

Line 717: , p6_a12 out nocopy JTF_NUMBER_TABLE

713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE
719: , p6_a14 out nocopy JTF_DATE_TABLE
720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
721: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 718: , p6_a13 out nocopy JTF_NUMBER_TABLE

714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE
719: , p6_a14 out nocopy JTF_DATE_TABLE
720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
721: , p6_a16 out nocopy JTF_NUMBER_TABLE
722: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 721: , p6_a16 out nocopy JTF_NUMBER_TABLE

717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE
719: , p6_a14 out nocopy JTF_DATE_TABLE
720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
721: , p6_a16 out nocopy JTF_NUMBER_TABLE
722: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
723: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
724: , x_return_status out nocopy VARCHAR2
725: , x_msg_count out nocopy NUMBER

Line 794: , p5_a0 in out nocopy JTF_NUMBER_TABLE

790: , p_init_msg_list VARCHAR2
791: , p_commit VARCHAR2
792: , p_validation_level NUMBER
793: , p_module_type VARCHAR2
794: , p5_a0 in out nocopy JTF_NUMBER_TABLE
795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 795: , p5_a1 in out nocopy JTF_NUMBER_TABLE

791: , p_commit VARCHAR2
792: , p_validation_level NUMBER
793: , p_module_type VARCHAR2
794: , p5_a0 in out nocopy JTF_NUMBER_TABLE
795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 796: , p5_a2 in out nocopy JTF_NUMBER_TABLE

792: , p_validation_level NUMBER
793: , p_module_type VARCHAR2
794: , p5_a0 in out nocopy JTF_NUMBER_TABLE
795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE

Line 798: , p5_a4 in out nocopy JTF_NUMBER_TABLE

794: , p5_a0 in out nocopy JTF_NUMBER_TABLE
795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 799: , p5_a5 in out nocopy JTF_NUMBER_TABLE

795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 800: , p5_a6 in out nocopy JTF_NUMBER_TABLE

796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 806: , p5_a12 in out nocopy JTF_NUMBER_TABLE

802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 807: , p5_a13 in out nocopy JTF_NUMBER_TABLE

803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 812: , p5_a18 in out nocopy JTF_NUMBER_TABLE

808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
812: , p5_a18 in out nocopy JTF_NUMBER_TABLE
813: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_2000
814: , x_return_status out nocopy VARCHAR2
815: , x_msg_count out nocopy NUMBER
816: , x_msg_data out nocopy VARCHAR2

Line 904: , p6_a0 out nocopy JTF_NUMBER_TABLE

900: , p_commit VARCHAR2
901: , p_validation_level NUMBER
902: , p_module_type VARCHAR2
903: , p_visit_id NUMBER
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 905: , p6_a1 out nocopy JTF_NUMBER_TABLE

901: , p_validation_level NUMBER
902: , p_module_type VARCHAR2
903: , p_visit_id NUMBER
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 906: , p6_a2 out nocopy JTF_NUMBER_TABLE

902: , p_module_type VARCHAR2
903: , p_visit_id NUMBER
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 908: , p6_a4 out nocopy JTF_NUMBER_TABLE

904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 909: , p6_a5 out nocopy JTF_NUMBER_TABLE

905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 910: , p6_a6 out nocopy JTF_NUMBER_TABLE

906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 916: , p6_a12 out nocopy JTF_NUMBER_TABLE

912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 917: , p6_a13 out nocopy JTF_NUMBER_TABLE

913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 922: , p6_a18 out nocopy JTF_NUMBER_TABLE

918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a18 out nocopy JTF_NUMBER_TABLE
923: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
924: , x_return_status out nocopy VARCHAR2
925: , x_msg_count out nocopy NUMBER
926: , x_msg_data out nocopy VARCHAR2