DBA Data[Home] [Help]

APPS.AHL_CMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_cmp_pvt_w as
2: /* $Header: AHLWCMPB.pls 120.0.12020000.2 2012/12/13 05:15:14 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_cmp_pvt_w as
2: /* $Header: AHLWCMPB.pls 120.0.12020000.2 2012/12/13 05:15:14 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

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

Line 48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE

Line 50: , a2 out nocopy JTF_NUMBER_TABLE

46: end if;
47: end rosetta_table_copy_in_p4;
48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE

Line 52: , a4 out nocopy JTF_NUMBER_TABLE

48: procedure rosetta_table_copy_out_p4(t ahl_cmp_pvt.ahl_mtlxfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE

Line 54: , a6 out nocopy JTF_NUMBER_TABLE

50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE

Line 56: , a8 out nocopy JTF_NUMBER_TABLE

52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a10 out nocopy JTF_NUMBER_TABLE

54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_300
56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_VARCHAR2_TABLE_100
58: , a10 out nocopy JTF_NUMBER_TABLE
59: , a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_100
62: ) as

Line 66: a0 := JTF_NUMBER_TABLE();

62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();

Line 68: a2 := JTF_NUMBER_TABLE();

64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();

Line 70: a4 := JTF_NUMBER_TABLE();

66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_VARCHAR2_TABLE_100();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();

Line 72: a6 := JTF_NUMBER_TABLE();

68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_VARCHAR2_TABLE_100();
70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();

Line 74: a8 := JTF_NUMBER_TABLE();

70: a4 := JTF_NUMBER_TABLE();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();

Line 76: a10 := JTF_NUMBER_TABLE();

72: a6 := JTF_NUMBER_TABLE();
73: a7 := JTF_VARCHAR2_TABLE_300();
74: a8 := JTF_NUMBER_TABLE();
75: a9 := JTF_VARCHAR2_TABLE_100();
76: a10 := JTF_NUMBER_TABLE();
77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else

Line 81: a0 := JTF_NUMBER_TABLE();

77: a11 := JTF_VARCHAR2_TABLE_300();
78: a12 := JTF_VARCHAR2_TABLE_100();
79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();

Line 83: a2 := JTF_NUMBER_TABLE();

79: a13 := JTF_VARCHAR2_TABLE_100();
80: else
81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();

Line 85: a4 := JTF_NUMBER_TABLE();

81: a0 := JTF_NUMBER_TABLE();
82: a1 := JTF_VARCHAR2_TABLE_100();
83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();

Line 87: a6 := JTF_NUMBER_TABLE();

83: a2 := JTF_NUMBER_TABLE();
84: a3 := JTF_VARCHAR2_TABLE_100();
85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();

Line 89: a8 := JTF_NUMBER_TABLE();

85: a4 := JTF_NUMBER_TABLE();
86: a5 := JTF_VARCHAR2_TABLE_100();
87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();
93: a12 := JTF_VARCHAR2_TABLE_100();

Line 91: a10 := JTF_NUMBER_TABLE();

87: a6 := JTF_NUMBER_TABLE();
88: a7 := JTF_VARCHAR2_TABLE_300();
89: a8 := JTF_NUMBER_TABLE();
90: a9 := JTF_VARCHAR2_TABLE_100();
91: a10 := JTF_NUMBER_TABLE();
92: a11 := JTF_VARCHAR2_TABLE_300();
93: a12 := JTF_VARCHAR2_TABLE_100();
94: a13 := JTF_VARCHAR2_TABLE_100();
95: if t.count > 0 then

Line 137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE

133: end if;
134: end if;
135: end rosetta_table_copy_out_p4;
136:
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE

Line 139: , a2 JTF_NUMBER_TABLE

135: end rosetta_table_copy_out_p4;
136:
137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE

Line 141: , a4 JTF_NUMBER_TABLE

137: procedure rosetta_table_copy_in_p6(t out nocopy ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE

Line 143: , a6 JTF_NUMBER_TABLE

139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_VARCHAR2_TABLE_100
141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE

Line 145: , a8 JTF_NUMBER_TABLE

141: , a4 JTF_NUMBER_TABLE
142: , a5 JTF_VARCHAR2_TABLE_100
143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100

Line 147: , a10 JTF_NUMBER_TABLE

143: , a6 JTF_NUMBER_TABLE
144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100

Line 148: , a11 JTF_NUMBER_TABLE

144: , a7 JTF_VARCHAR2_TABLE_100
145: , a8 JTF_NUMBER_TABLE
146: , a9 JTF_VARCHAR2_TABLE_300
147: , a10 JTF_NUMBER_TABLE
148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE

Line 152: , a15 JTF_NUMBER_TABLE

148: , a11 JTF_NUMBER_TABLE
149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE
153: , a16 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin

Line 153: , a16 JTF_NUMBER_TABLE

149: , a12 JTF_VARCHAR2_TABLE_100
150: , a13 JTF_VARCHAR2_TABLE_100
151: , a14 JTF_VARCHAR2_TABLE_100
152: , a15 JTF_NUMBER_TABLE
153: , a16 JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if a0 is not null and a0.count > 0 then

Line 188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

184: end loop;
185: end if;
186: end if;
187: end rosetta_table_copy_in_p6;
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE

Line 190: , a2 out nocopy JTF_NUMBER_TABLE

186: end if;
187: end rosetta_table_copy_in_p6;
188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE

Line 192: , a4 out nocopy JTF_NUMBER_TABLE

188: procedure rosetta_table_copy_out_p6(t ahl_cmp_pvt.ahl_mtlrtn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_VARCHAR2_TABLE_300
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE

Line 194: , a6 out nocopy JTF_NUMBER_TABLE

190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_VARCHAR2_TABLE_100
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE

Line 196: , a8 out nocopy JTF_NUMBER_TABLE

192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 198: , a10 out nocopy JTF_NUMBER_TABLE

194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 199: , a11 out nocopy JTF_NUMBER_TABLE

195: , a7 out nocopy JTF_VARCHAR2_TABLE_100
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_VARCHAR2_TABLE_300
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE

Line 203: , a15 out nocopy JTF_NUMBER_TABLE

199: , a11 out nocopy JTF_NUMBER_TABLE
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE
204: , a16 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin

Line 204: , a16 out nocopy JTF_NUMBER_TABLE

200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_VARCHAR2_TABLE_100
202: , a14 out nocopy JTF_VARCHAR2_TABLE_100
203: , a15 out nocopy JTF_NUMBER_TABLE
204: , a16 out nocopy JTF_NUMBER_TABLE
205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then

Line 209: a0 := JTF_NUMBER_TABLE();

205: ) as
206: ddindx binary_integer; indx binary_integer;
207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();

Line 211: a2 := JTF_NUMBER_TABLE();

207: begin
208: if t is null or t.count = 0 then
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();

Line 213: a4 := JTF_NUMBER_TABLE();

209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_VARCHAR2_TABLE_300();
211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();

Line 215: a6 := JTF_NUMBER_TABLE();

211: a2 := JTF_NUMBER_TABLE();
212: a3 := JTF_VARCHAR2_TABLE_100();
213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();

Line 217: a8 := JTF_NUMBER_TABLE();

213: a4 := JTF_NUMBER_TABLE();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();

Line 219: a10 := JTF_NUMBER_TABLE();

215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();

Line 220: a11 := JTF_NUMBER_TABLE();

216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_NUMBER_TABLE();
218: a9 := JTF_VARCHAR2_TABLE_300();
219: a10 := JTF_NUMBER_TABLE();
220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();

Line 224: a15 := JTF_NUMBER_TABLE();

220: a11 := JTF_NUMBER_TABLE();
221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();

Line 225: a16 := JTF_NUMBER_TABLE();

221: a12 := JTF_VARCHAR2_TABLE_100();
222: a13 := JTF_VARCHAR2_TABLE_100();
223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();

Line 227: a0 := JTF_NUMBER_TABLE();

223: a14 := JTF_VARCHAR2_TABLE_100();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();

Line 229: a2 := JTF_NUMBER_TABLE();

225: a16 := JTF_NUMBER_TABLE();
226: else
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();

Line 231: a4 := JTF_NUMBER_TABLE();

227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_VARCHAR2_TABLE_300();
229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();

Line 233: a6 := JTF_NUMBER_TABLE();

229: a2 := JTF_NUMBER_TABLE();
230: a3 := JTF_VARCHAR2_TABLE_100();
231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();

Line 235: a8 := JTF_NUMBER_TABLE();

231: a4 := JTF_NUMBER_TABLE();
232: a5 := JTF_VARCHAR2_TABLE_100();
233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();

Line 237: a10 := JTF_NUMBER_TABLE();

233: a6 := JTF_NUMBER_TABLE();
234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();

Line 238: a11 := JTF_NUMBER_TABLE();

234: a7 := JTF_VARCHAR2_TABLE_100();
235: a8 := JTF_NUMBER_TABLE();
236: a9 := JTF_VARCHAR2_TABLE_300();
237: a10 := JTF_NUMBER_TABLE();
238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();

Line 242: a15 := JTF_NUMBER_TABLE();

238: a11 := JTF_NUMBER_TABLE();
239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();
243: a16 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);

Line 243: a16 := JTF_NUMBER_TABLE();

239: a12 := JTF_VARCHAR2_TABLE_100();
240: a13 := JTF_VARCHAR2_TABLE_100();
241: a14 := JTF_VARCHAR2_TABLE_100();
242: a15 := JTF_NUMBER_TABLE();
243: a16 := JTF_NUMBER_TABLE();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
247: a2.extend(t.count);

Line 296: , p4_a0 in out nocopy JTF_NUMBER_TABLE

292: procedure perform_mtl_xfr(p_api_version NUMBER
293: , p_init_msg_list VARCHAR2
294: , p_commit VARCHAR2
295: , p_validation_level NUMBER
296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE

Line 298: , p4_a2 in out nocopy JTF_NUMBER_TABLE

294: , p_commit VARCHAR2
295: , p_validation_level NUMBER
296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 300: , p4_a4 in out nocopy JTF_NUMBER_TABLE

296: , p4_a0 in out nocopy JTF_NUMBER_TABLE
297: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE

Line 302: , p4_a6 in out nocopy JTF_NUMBER_TABLE

298: , p4_a2 in out nocopy JTF_NUMBER_TABLE
299: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE

Line 304: , p4_a8 in out nocopy JTF_NUMBER_TABLE

300: , p4_a4 in out nocopy JTF_NUMBER_TABLE
301: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
308: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p4_a10 in out nocopy JTF_NUMBER_TABLE

302: , p4_a6 in out nocopy JTF_NUMBER_TABLE
303: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_300
304: , p4_a8 in out nocopy JTF_NUMBER_TABLE
305: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p4_a10 in out nocopy JTF_NUMBER_TABLE
307: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_300
308: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
310: , x_return_status out nocopy VARCHAR2

Line 383: , p4_a0 in out nocopy JTF_NUMBER_TABLE

379: procedure perform_return_txn(p_api_version NUMBER
380: , p_init_msg_list VARCHAR2
381: , p_commit VARCHAR2
382: , p_validation_level NUMBER
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE

Line 385: , p4_a2 in out nocopy JTF_NUMBER_TABLE

381: , p_commit VARCHAR2
382: , p_validation_level NUMBER
383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 387: , p4_a4 in out nocopy JTF_NUMBER_TABLE

383: , p4_a0 in out nocopy JTF_NUMBER_TABLE
384: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_300
385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE

Line 389: , p4_a6 in out nocopy JTF_NUMBER_TABLE

385: , p4_a2 in out nocopy JTF_NUMBER_TABLE
386: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE

Line 391: , p4_a8 in out nocopy JTF_NUMBER_TABLE

387: , p4_a4 in out nocopy JTF_NUMBER_TABLE
388: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 393: , p4_a10 in out nocopy JTF_NUMBER_TABLE

389: , p4_a6 in out nocopy JTF_NUMBER_TABLE
390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 394: , p4_a11 in out nocopy JTF_NUMBER_TABLE

390: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p4_a8 in out nocopy JTF_NUMBER_TABLE
392: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_300
393: , p4_a10 in out nocopy JTF_NUMBER_TABLE
394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE

Line 398: , p4_a15 in out nocopy JTF_NUMBER_TABLE

394: , p4_a11 in out nocopy JTF_NUMBER_TABLE
395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE
399: , p4_a16 in out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2

Line 399: , p4_a16 in out nocopy JTF_NUMBER_TABLE

395: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p4_a15 in out nocopy JTF_NUMBER_TABLE
399: , p4_a16 in out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: )