DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300

Line 26: , a1 JTF_NUMBER_TABLE

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE

Line 27: , a2 JTF_NUMBER_TABLE

23: end;
24:
25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100

Line 28: , a3 JTF_NUMBER_TABLE

24:
25: procedure rosetta_table_copy_in_p3(t out nocopy ams_item_owner_pvt.item_owner_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_DATE_TABLE

Line 30: , a5 JTF_NUMBER_TABLE

26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_DATE_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100

Line 35: , a10 JTF_NUMBER_TABLE

31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_DATE_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_NUMBER_TABLE
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
39: if a0 is not null and a0.count > 0 then

Line 64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

60: end loop;
61: end if;
62: end if;
63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 65: , a1 out nocopy JTF_NUMBER_TABLE

61: end if;
62: end if;
63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300
69: , a5 out nocopy JTF_NUMBER_TABLE

Line 66: , a2 out nocopy JTF_NUMBER_TABLE

62: end if;
63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a3 out nocopy JTF_NUMBER_TABLE

63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ams_item_owner_pvt.item_owner_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_100
71: , a7 out nocopy JTF_DATE_TABLE

Line 69: , a5 out nocopy JTF_NUMBER_TABLE

65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_300
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_100
71: , a7 out nocopy JTF_DATE_TABLE
72: , a8 out nocopy JTF_VARCHAR2_TABLE_100
73: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a10 out nocopy JTF_NUMBER_TABLE

70: , a6 out nocopy JTF_VARCHAR2_TABLE_100
71: , a7 out nocopy JTF_DATE_TABLE
72: , a8 out nocopy JTF_VARCHAR2_TABLE_100
73: , a9 out nocopy JTF_VARCHAR2_TABLE_100
74: , a10 out nocopy JTF_NUMBER_TABLE
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then

Line 79: a0 := JTF_NUMBER_TABLE();

75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_300();

Line 80: a1 := JTF_NUMBER_TABLE();

76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_300();
84: a5 := JTF_NUMBER_TABLE();

Line 81: a2 := JTF_NUMBER_TABLE();

77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_300();
84: a5 := JTF_NUMBER_TABLE();
85: a6 := JTF_VARCHAR2_TABLE_100();

Line 82: a3 := JTF_NUMBER_TABLE();

78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_300();
84: a5 := JTF_NUMBER_TABLE();
85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_DATE_TABLE();

Line 84: a5 := JTF_NUMBER_TABLE();

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

Line 89: a10 := JTF_NUMBER_TABLE();

85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_DATE_TABLE();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();

Line 91: a0 := JTF_NUMBER_TABLE();

87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();
94: a3 := JTF_NUMBER_TABLE();
95: a4 := JTF_VARCHAR2_TABLE_300();

Line 92: a1 := JTF_NUMBER_TABLE();

88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();
94: a3 := JTF_NUMBER_TABLE();
95: a4 := JTF_VARCHAR2_TABLE_300();
96: a5 := JTF_NUMBER_TABLE();

Line 93: a2 := JTF_NUMBER_TABLE();

89: a10 := JTF_NUMBER_TABLE();
90: else
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();
94: a3 := JTF_NUMBER_TABLE();
95: a4 := JTF_VARCHAR2_TABLE_300();
96: a5 := JTF_NUMBER_TABLE();
97: a6 := JTF_VARCHAR2_TABLE_100();

Line 94: a3 := JTF_NUMBER_TABLE();

90: else
91: a0 := JTF_NUMBER_TABLE();
92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();
94: a3 := JTF_NUMBER_TABLE();
95: a4 := JTF_VARCHAR2_TABLE_300();
96: a5 := JTF_NUMBER_TABLE();
97: a6 := JTF_VARCHAR2_TABLE_100();
98: a7 := JTF_DATE_TABLE();

Line 96: a5 := JTF_NUMBER_TABLE();

92: a1 := JTF_NUMBER_TABLE();
93: a2 := JTF_NUMBER_TABLE();
94: a3 := JTF_NUMBER_TABLE();
95: a4 := JTF_VARCHAR2_TABLE_300();
96: a5 := JTF_NUMBER_TABLE();
97: a6 := JTF_VARCHAR2_TABLE_100();
98: a7 := JTF_DATE_TABLE();
99: a8 := JTF_VARCHAR2_TABLE_100();
100: a9 := JTF_VARCHAR2_TABLE_100();

Line 101: a10 := JTF_NUMBER_TABLE();

97: a6 := JTF_VARCHAR2_TABLE_100();
98: a7 := JTF_DATE_TABLE();
99: a8 := JTF_VARCHAR2_TABLE_100();
100: a9 := JTF_VARCHAR2_TABLE_100();
101: a10 := JTF_NUMBER_TABLE();
102: if t.count > 0 then
103: a0.extend(t.count);
104: a1.extend(t.count);
105: a2.extend(t.count);

Line 138: procedure rosetta_table_copy_in_p8(t out nocopy ams_item_owner_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE

134: end if;
135: end if;
136: end rosetta_table_copy_out_p3;
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy ams_item_owner_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_VARCHAR2_TABLE_100
141: , a3 JTF_VARCHAR2_TABLE_2000
142: , a4 JTF_VARCHAR2_TABLE_100

Line 139: , a1 JTF_NUMBER_TABLE

135: end if;
136: end rosetta_table_copy_out_p3;
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy ams_item_owner_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_VARCHAR2_TABLE_100
141: , a3 JTF_VARCHAR2_TABLE_2000
142: , a4 JTF_VARCHAR2_TABLE_100
143: , a5 JTF_VARCHAR2_TABLE_100

Line 144: , a6 JTF_NUMBER_TABLE

140: , a2 JTF_VARCHAR2_TABLE_100
141: , a3 JTF_VARCHAR2_TABLE_2000
142: , a4 JTF_VARCHAR2_TABLE_100
143: , a5 JTF_VARCHAR2_TABLE_100
144: , a6 JTF_NUMBER_TABLE
145: ) as
146: ddindx binary_integer; indx binary_integer;
147: begin
148: if a0 is not null and a0.count > 0 then

Line 169: procedure rosetta_table_copy_out_p8(t ams_item_owner_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

165: end loop;
166: end if;
167: end if;
168: end rosetta_table_copy_in_p8;
169: procedure rosetta_table_copy_out_p8(t ams_item_owner_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a1 out nocopy JTF_NUMBER_TABLE
171: , a2 out nocopy JTF_VARCHAR2_TABLE_100
172: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , a1 out nocopy JTF_NUMBER_TABLE

166: end if;
167: end if;
168: end rosetta_table_copy_in_p8;
169: procedure rosetta_table_copy_out_p8(t ams_item_owner_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a1 out nocopy JTF_NUMBER_TABLE
171: , a2 out nocopy JTF_VARCHAR2_TABLE_100
172: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: , a6 out nocopy JTF_NUMBER_TABLE

171: , a2 out nocopy JTF_VARCHAR2_TABLE_100
172: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , a6 out nocopy JTF_NUMBER_TABLE
176: ) as
177: ddindx binary_integer; indx binary_integer;
178: begin
179: if t is null or t.count = 0 then

Line 180: a0 := JTF_NUMBER_TABLE();

176: ) as
177: ddindx binary_integer; indx binary_integer;
178: begin
179: if t is null or t.count = 0 then
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_2000();
184: a4 := JTF_VARCHAR2_TABLE_100();

Line 181: a1 := JTF_NUMBER_TABLE();

177: ddindx binary_integer; indx binary_integer;
178: begin
179: if t is null or t.count = 0 then
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_2000();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();

Line 186: a6 := JTF_NUMBER_TABLE();

182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_2000();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_100();

Line 188: a0 := JTF_NUMBER_TABLE();

184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_100();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();

Line 189: a1 := JTF_NUMBER_TABLE();

185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_100();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();
193: a5 := JTF_VARCHAR2_TABLE_100();

Line 194: a6 := JTF_NUMBER_TABLE();

190: a2 := JTF_VARCHAR2_TABLE_100();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();
193: a5 := JTF_VARCHAR2_TABLE_100();
194: a6 := JTF_NUMBER_TABLE();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);

Line 299: , p12_a0 out nocopy JTF_NUMBER_TABLE

295: , p10_a64 out nocopy VARCHAR2
296: , p10_a65 out nocopy VARCHAR2
297: , p10_a66 out nocopy VARCHAR2
298: , x_item_return_status out nocopy VARCHAR2
299: , p12_a0 out nocopy JTF_NUMBER_TABLE
300: , p12_a1 out nocopy JTF_NUMBER_TABLE
301: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
302: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
303: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 300: , p12_a1 out nocopy JTF_NUMBER_TABLE

296: , p10_a65 out nocopy VARCHAR2
297: , p10_a66 out nocopy VARCHAR2
298: , x_item_return_status out nocopy VARCHAR2
299: , p12_a0 out nocopy JTF_NUMBER_TABLE
300: , p12_a1 out nocopy JTF_NUMBER_TABLE
301: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
302: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
303: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
304: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p12_a6 out nocopy JTF_NUMBER_TABLE

301: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
302: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
303: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
304: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
305: , p12_a6 out nocopy JTF_NUMBER_TABLE
306: , p7_a0 NUMBER := 0-1962.0724
307: , p7_a1 NUMBER := 0-1962.0724
308: , p7_a2 NUMBER := 0-1962.0724
309: , p7_a3 NUMBER := 0-1962.0724

Line 667: , p12_a0 out nocopy JTF_NUMBER_TABLE

663: , p10_a64 out nocopy VARCHAR2
664: , p10_a65 out nocopy VARCHAR2
665: , p10_a66 out nocopy VARCHAR2
666: , x_item_return_status out nocopy VARCHAR2
667: , p12_a0 out nocopy JTF_NUMBER_TABLE
668: , p12_a1 out nocopy JTF_NUMBER_TABLE
669: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
670: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
671: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 668: , p12_a1 out nocopy JTF_NUMBER_TABLE

664: , p10_a65 out nocopy VARCHAR2
665: , p10_a66 out nocopy VARCHAR2
666: , x_item_return_status out nocopy VARCHAR2
667: , p12_a0 out nocopy JTF_NUMBER_TABLE
668: , p12_a1 out nocopy JTF_NUMBER_TABLE
669: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
670: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
671: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
672: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 673: , p12_a6 out nocopy JTF_NUMBER_TABLE

669: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
670: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
671: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
672: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
673: , p12_a6 out nocopy JTF_NUMBER_TABLE
674: , p7_a0 NUMBER := 0-1962.0724
675: , p7_a1 NUMBER := 0-1962.0724
676: , p7_a2 NUMBER := 0-1962.0724
677: , p7_a3 NUMBER := 0-1962.0724