DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_parts_change_pvt.ahl_parts_tbl_type, 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_p1(t out nocopy ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_NUMBER_TABLE

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

Line 18: , a2 JTF_NUMBER_TABLE

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

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 21: , a5 JTF_NUMBER_TABLE

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

Line 22: , a6 JTF_NUMBER_TABLE

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

Line 23: , a7 JTF_NUMBER_TABLE

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

Line 25: , a9 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_NUMBER_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE

Line 27: , a11 JTF_NUMBER_TABLE

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

Line 29: , a13 JTF_NUMBER_TABLE

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

Line 31: , a15 JTF_NUMBER_TABLE

27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100

Line 34: , a18 JTF_NUMBER_TABLE

30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE

Line 37: , a21 JTF_NUMBER_TABLE

33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE

Line 38: , a22 JTF_NUMBER_TABLE

34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_DATE_TABLE

Line 40: , a24 JTF_NUMBER_TABLE

36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_DATE_TABLE
43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE

Line 41: , a25 JTF_NUMBER_TABLE

37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_DATE_TABLE
43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE

Line 43: , a27 JTF_NUMBER_TABLE

39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_DATE_TABLE
43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE

Line 45: , a29 JTF_NUMBER_TABLE

41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_DATE_TABLE
43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_NUMBER_TABLE
49: ) as

Line 46: , a30 JTF_NUMBER_TABLE

42: , a26 JTF_DATE_TABLE
43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;

Line 47: , a31 JTF_NUMBER_TABLE

43: , a27 JTF_NUMBER_TABLE
44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin

Line 48: , a32 JTF_NUMBER_TABLE

44: , a28 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then

Line 99: procedure rosetta_table_copy_out_p1(t ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

95: end loop;
96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 100: , a1 out nocopy JTF_NUMBER_TABLE

96: end if;
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE

Line 101: , a2 out nocopy JTF_NUMBER_TABLE

97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE

Line 102: , a3 out nocopy JTF_NUMBER_TABLE

98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_prd_parts_change_pvt.ahl_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE
106: , a7 out nocopy JTF_NUMBER_TABLE

Line 104: , a5 out nocopy JTF_NUMBER_TABLE

100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE
106: , a7 out nocopy JTF_NUMBER_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_NUMBER_TABLE

Line 105: , a6 out nocopy JTF_NUMBER_TABLE

101: , a2 out nocopy JTF_NUMBER_TABLE
102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE
106: , a7 out nocopy JTF_NUMBER_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_NUMBER_TABLE
109: , a10 out nocopy JTF_DATE_TABLE

Line 106: , a7 out nocopy JTF_NUMBER_TABLE

102: , a3 out nocopy JTF_NUMBER_TABLE
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE
106: , a7 out nocopy JTF_NUMBER_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_NUMBER_TABLE
109: , a10 out nocopy JTF_DATE_TABLE
110: , a11 out nocopy JTF_NUMBER_TABLE

Line 108: , a9 out nocopy JTF_NUMBER_TABLE

104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_NUMBER_TABLE
106: , a7 out nocopy JTF_NUMBER_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_NUMBER_TABLE
109: , a10 out nocopy JTF_DATE_TABLE
110: , a11 out nocopy JTF_NUMBER_TABLE
111: , a12 out nocopy JTF_VARCHAR2_TABLE_100
112: , a13 out nocopy JTF_NUMBER_TABLE

Line 110: , a11 out nocopy JTF_NUMBER_TABLE

106: , a7 out nocopy JTF_NUMBER_TABLE
107: , a8 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 out nocopy JTF_NUMBER_TABLE
109: , a10 out nocopy JTF_DATE_TABLE
110: , a11 out nocopy JTF_NUMBER_TABLE
111: , a12 out nocopy JTF_VARCHAR2_TABLE_100
112: , a13 out nocopy JTF_NUMBER_TABLE
113: , a14 out nocopy JTF_VARCHAR2_TABLE_100
114: , a15 out nocopy JTF_NUMBER_TABLE

Line 112: , a13 out nocopy JTF_NUMBER_TABLE

108: , a9 out nocopy JTF_NUMBER_TABLE
109: , a10 out nocopy JTF_DATE_TABLE
110: , a11 out nocopy JTF_NUMBER_TABLE
111: , a12 out nocopy JTF_VARCHAR2_TABLE_100
112: , a13 out nocopy JTF_NUMBER_TABLE
113: , a14 out nocopy JTF_VARCHAR2_TABLE_100
114: , a15 out nocopy JTF_NUMBER_TABLE
115: , a16 out nocopy JTF_VARCHAR2_TABLE_100
116: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , a15 out nocopy JTF_NUMBER_TABLE

110: , a11 out nocopy JTF_NUMBER_TABLE
111: , a12 out nocopy JTF_VARCHAR2_TABLE_100
112: , a13 out nocopy JTF_NUMBER_TABLE
113: , a14 out nocopy JTF_VARCHAR2_TABLE_100
114: , a15 out nocopy JTF_NUMBER_TABLE
115: , a16 out nocopy JTF_VARCHAR2_TABLE_100
116: , a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , a18 out nocopy JTF_NUMBER_TABLE
118: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a18 out nocopy JTF_NUMBER_TABLE

113: , a14 out nocopy JTF_VARCHAR2_TABLE_100
114: , a15 out nocopy JTF_NUMBER_TABLE
115: , a16 out nocopy JTF_VARCHAR2_TABLE_100
116: , a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , a18 out nocopy JTF_NUMBER_TABLE
118: , a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , a20 out nocopy JTF_DATE_TABLE
120: , a21 out nocopy JTF_NUMBER_TABLE
121: , a22 out nocopy JTF_NUMBER_TABLE

Line 120: , a21 out nocopy JTF_NUMBER_TABLE

116: , a17 out nocopy JTF_VARCHAR2_TABLE_100
117: , a18 out nocopy JTF_NUMBER_TABLE
118: , a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , a20 out nocopy JTF_DATE_TABLE
120: , a21 out nocopy JTF_NUMBER_TABLE
121: , a22 out nocopy JTF_NUMBER_TABLE
122: , a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_NUMBER_TABLE
124: , a25 out nocopy JTF_NUMBER_TABLE

Line 121: , a22 out nocopy JTF_NUMBER_TABLE

117: , a18 out nocopy JTF_NUMBER_TABLE
118: , a19 out nocopy JTF_VARCHAR2_TABLE_100
119: , a20 out nocopy JTF_DATE_TABLE
120: , a21 out nocopy JTF_NUMBER_TABLE
121: , a22 out nocopy JTF_NUMBER_TABLE
122: , a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_NUMBER_TABLE
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE

Line 123: , a24 out nocopy JTF_NUMBER_TABLE

119: , a20 out nocopy JTF_DATE_TABLE
120: , a21 out nocopy JTF_NUMBER_TABLE
121: , a22 out nocopy JTF_NUMBER_TABLE
122: , a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_NUMBER_TABLE
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE

Line 124: , a25 out nocopy JTF_NUMBER_TABLE

120: , a21 out nocopy JTF_NUMBER_TABLE
121: , a22 out nocopy JTF_NUMBER_TABLE
122: , a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_NUMBER_TABLE
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE

Line 126: , a27 out nocopy JTF_NUMBER_TABLE

122: , a23 out nocopy JTF_VARCHAR2_TABLE_100
123: , a24 out nocopy JTF_NUMBER_TABLE
124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE

Line 128: , a29 out nocopy JTF_NUMBER_TABLE

124: , a25 out nocopy JTF_NUMBER_TABLE
125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_NUMBER_TABLE
132: ) as

Line 129: , a30 out nocopy JTF_NUMBER_TABLE

125: , a26 out nocopy JTF_DATE_TABLE
126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;

Line 130: , a31 out nocopy JTF_NUMBER_TABLE

126: , a27 out nocopy JTF_NUMBER_TABLE
127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin

Line 131: , a32 out nocopy JTF_NUMBER_TABLE

127: , a28 out nocopy JTF_DATE_TABLE
128: , a29 out nocopy JTF_NUMBER_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_NUMBER_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then

Line 136: a0 := JTF_NUMBER_TABLE();

132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();

Line 137: a1 := JTF_NUMBER_TABLE();

133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();

Line 138: a2 := JTF_NUMBER_TABLE();

134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();

Line 139: a3 := JTF_NUMBER_TABLE();

135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();

Line 141: a5 := JTF_NUMBER_TABLE();

137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();

Line 142: a6 := JTF_NUMBER_TABLE();

138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_DATE_TABLE();

Line 143: a7 := JTF_NUMBER_TABLE();

139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_DATE_TABLE();
147: a11 := JTF_NUMBER_TABLE();

Line 145: a9 := JTF_NUMBER_TABLE();

141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_DATE_TABLE();
147: a11 := JTF_NUMBER_TABLE();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_NUMBER_TABLE();

Line 147: a11 := JTF_NUMBER_TABLE();

143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_DATE_TABLE();
147: a11 := JTF_NUMBER_TABLE();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_NUMBER_TABLE();
150: a14 := JTF_VARCHAR2_TABLE_100();
151: a15 := JTF_NUMBER_TABLE();

Line 149: a13 := JTF_NUMBER_TABLE();

145: a9 := JTF_NUMBER_TABLE();
146: a10 := JTF_DATE_TABLE();
147: a11 := JTF_NUMBER_TABLE();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_NUMBER_TABLE();
150: a14 := JTF_VARCHAR2_TABLE_100();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_VARCHAR2_TABLE_100();
153: a17 := JTF_VARCHAR2_TABLE_100();

Line 151: a15 := JTF_NUMBER_TABLE();

147: a11 := JTF_NUMBER_TABLE();
148: a12 := JTF_VARCHAR2_TABLE_100();
149: a13 := JTF_NUMBER_TABLE();
150: a14 := JTF_VARCHAR2_TABLE_100();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_VARCHAR2_TABLE_100();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_NUMBER_TABLE();
155: a19 := JTF_VARCHAR2_TABLE_100();

Line 154: a18 := JTF_NUMBER_TABLE();

150: a14 := JTF_VARCHAR2_TABLE_100();
151: a15 := JTF_NUMBER_TABLE();
152: a16 := JTF_VARCHAR2_TABLE_100();
153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_NUMBER_TABLE();
155: a19 := JTF_VARCHAR2_TABLE_100();
156: a20 := JTF_DATE_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_NUMBER_TABLE();

Line 157: a21 := JTF_NUMBER_TABLE();

153: a17 := JTF_VARCHAR2_TABLE_100();
154: a18 := JTF_NUMBER_TABLE();
155: a19 := JTF_VARCHAR2_TABLE_100();
156: a20 := JTF_DATE_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_NUMBER_TABLE();
159: a23 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_NUMBER_TABLE();
161: a25 := JTF_NUMBER_TABLE();

Line 158: a22 := JTF_NUMBER_TABLE();

154: a18 := JTF_NUMBER_TABLE();
155: a19 := JTF_VARCHAR2_TABLE_100();
156: a20 := JTF_DATE_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_NUMBER_TABLE();
159: a23 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_NUMBER_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();

Line 160: a24 := JTF_NUMBER_TABLE();

156: a20 := JTF_DATE_TABLE();
157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_NUMBER_TABLE();
159: a23 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_NUMBER_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();

Line 161: a25 := JTF_NUMBER_TABLE();

157: a21 := JTF_NUMBER_TABLE();
158: a22 := JTF_NUMBER_TABLE();
159: a23 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_NUMBER_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();

Line 163: a27 := JTF_NUMBER_TABLE();

159: a23 := JTF_VARCHAR2_TABLE_100();
160: a24 := JTF_NUMBER_TABLE();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();

Line 165: a29 := JTF_NUMBER_TABLE();

161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else

Line 166: a30 := JTF_NUMBER_TABLE();

162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();

Line 167: a31 := JTF_NUMBER_TABLE();

163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();

Line 168: a32 := JTF_NUMBER_TABLE();

164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();

Line 170: a0 := JTF_NUMBER_TABLE();

166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();

Line 171: a1 := JTF_NUMBER_TABLE();

167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();

Line 172: a2 := JTF_NUMBER_TABLE();

168: a32 := JTF_NUMBER_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();

Line 173: a3 := JTF_NUMBER_TABLE();

169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();

Line 175: a5 := JTF_NUMBER_TABLE();

171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_VARCHAR2_TABLE_100();
179: a9 := JTF_NUMBER_TABLE();

Line 176: a6 := JTF_NUMBER_TABLE();

172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_VARCHAR2_TABLE_100();
179: a9 := JTF_NUMBER_TABLE();
180: a10 := JTF_DATE_TABLE();

Line 177: a7 := JTF_NUMBER_TABLE();

173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_VARCHAR2_TABLE_100();
179: a9 := JTF_NUMBER_TABLE();
180: a10 := JTF_DATE_TABLE();
181: a11 := JTF_NUMBER_TABLE();

Line 179: a9 := JTF_NUMBER_TABLE();

175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_VARCHAR2_TABLE_100();
179: a9 := JTF_NUMBER_TABLE();
180: a10 := JTF_DATE_TABLE();
181: a11 := JTF_NUMBER_TABLE();
182: a12 := JTF_VARCHAR2_TABLE_100();
183: a13 := JTF_NUMBER_TABLE();

Line 181: a11 := JTF_NUMBER_TABLE();

177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_VARCHAR2_TABLE_100();
179: a9 := JTF_NUMBER_TABLE();
180: a10 := JTF_DATE_TABLE();
181: a11 := JTF_NUMBER_TABLE();
182: a12 := JTF_VARCHAR2_TABLE_100();
183: a13 := JTF_NUMBER_TABLE();
184: a14 := JTF_VARCHAR2_TABLE_100();
185: a15 := JTF_NUMBER_TABLE();

Line 183: a13 := JTF_NUMBER_TABLE();

179: a9 := JTF_NUMBER_TABLE();
180: a10 := JTF_DATE_TABLE();
181: a11 := JTF_NUMBER_TABLE();
182: a12 := JTF_VARCHAR2_TABLE_100();
183: a13 := JTF_NUMBER_TABLE();
184: a14 := JTF_VARCHAR2_TABLE_100();
185: a15 := JTF_NUMBER_TABLE();
186: a16 := JTF_VARCHAR2_TABLE_100();
187: a17 := JTF_VARCHAR2_TABLE_100();

Line 185: a15 := JTF_NUMBER_TABLE();

181: a11 := JTF_NUMBER_TABLE();
182: a12 := JTF_VARCHAR2_TABLE_100();
183: a13 := JTF_NUMBER_TABLE();
184: a14 := JTF_VARCHAR2_TABLE_100();
185: a15 := JTF_NUMBER_TABLE();
186: a16 := JTF_VARCHAR2_TABLE_100();
187: a17 := JTF_VARCHAR2_TABLE_100();
188: a18 := JTF_NUMBER_TABLE();
189: a19 := JTF_VARCHAR2_TABLE_100();

Line 188: a18 := JTF_NUMBER_TABLE();

184: a14 := JTF_VARCHAR2_TABLE_100();
185: a15 := JTF_NUMBER_TABLE();
186: a16 := JTF_VARCHAR2_TABLE_100();
187: a17 := JTF_VARCHAR2_TABLE_100();
188: a18 := JTF_NUMBER_TABLE();
189: a19 := JTF_VARCHAR2_TABLE_100();
190: a20 := JTF_DATE_TABLE();
191: a21 := JTF_NUMBER_TABLE();
192: a22 := JTF_NUMBER_TABLE();

Line 191: a21 := JTF_NUMBER_TABLE();

187: a17 := JTF_VARCHAR2_TABLE_100();
188: a18 := JTF_NUMBER_TABLE();
189: a19 := JTF_VARCHAR2_TABLE_100();
190: a20 := JTF_DATE_TABLE();
191: a21 := JTF_NUMBER_TABLE();
192: a22 := JTF_NUMBER_TABLE();
193: a23 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_NUMBER_TABLE();
195: a25 := JTF_NUMBER_TABLE();

Line 192: a22 := JTF_NUMBER_TABLE();

188: a18 := JTF_NUMBER_TABLE();
189: a19 := JTF_VARCHAR2_TABLE_100();
190: a20 := JTF_DATE_TABLE();
191: a21 := JTF_NUMBER_TABLE();
192: a22 := JTF_NUMBER_TABLE();
193: a23 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_NUMBER_TABLE();
195: a25 := JTF_NUMBER_TABLE();
196: a26 := JTF_DATE_TABLE();

Line 194: a24 := JTF_NUMBER_TABLE();

190: a20 := JTF_DATE_TABLE();
191: a21 := JTF_NUMBER_TABLE();
192: a22 := JTF_NUMBER_TABLE();
193: a23 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_NUMBER_TABLE();
195: a25 := JTF_NUMBER_TABLE();
196: a26 := JTF_DATE_TABLE();
197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();

Line 195: a25 := JTF_NUMBER_TABLE();

191: a21 := JTF_NUMBER_TABLE();
192: a22 := JTF_NUMBER_TABLE();
193: a23 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_NUMBER_TABLE();
195: a25 := JTF_NUMBER_TABLE();
196: a26 := JTF_DATE_TABLE();
197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();

Line 197: a27 := JTF_NUMBER_TABLE();

193: a23 := JTF_VARCHAR2_TABLE_100();
194: a24 := JTF_NUMBER_TABLE();
195: a25 := JTF_NUMBER_TABLE();
196: a26 := JTF_DATE_TABLE();
197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();

Line 199: a29 := JTF_NUMBER_TABLE();

195: a25 := JTF_NUMBER_TABLE();
196: a26 := JTF_DATE_TABLE();
197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_NUMBER_TABLE();
203: if t.count > 0 then

Line 200: a30 := JTF_NUMBER_TABLE();

196: a26 := JTF_DATE_TABLE();
197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_NUMBER_TABLE();
203: if t.count > 0 then
204: a0.extend(t.count);

Line 201: a31 := JTF_NUMBER_TABLE();

197: a27 := JTF_NUMBER_TABLE();
198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_NUMBER_TABLE();
203: if t.count > 0 then
204: a0.extend(t.count);
205: a1.extend(t.count);

Line 202: a32 := JTF_NUMBER_TABLE();

198: a28 := JTF_DATE_TABLE();
199: a29 := JTF_NUMBER_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_NUMBER_TABLE();
203: if t.count > 0 then
204: a0.extend(t.count);
205: a1.extend(t.count);
206: a2.extend(t.count);

Line 283: procedure rosetta_table_copy_in_p7(t out nocopy ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 JTF_NUMBER_TABLE

279: end if;
280: end if;
281: end rosetta_table_copy_out_p1;
282:
283: procedure rosetta_table_copy_in_p7(t out nocopy ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_VARCHAR2_TABLE_100
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_NUMBER_TABLE
287: , a4 JTF_VARCHAR2_TABLE_100

Line 285: , a2 JTF_NUMBER_TABLE

281: end rosetta_table_copy_out_p1;
282:
283: procedure rosetta_table_copy_in_p7(t out nocopy ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_VARCHAR2_TABLE_100
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_NUMBER_TABLE
287: , a4 JTF_VARCHAR2_TABLE_100
288: , a5 JTF_NUMBER_TABLE
289: , a6 JTF_VARCHAR2_TABLE_100

Line 286: , a3 JTF_NUMBER_TABLE

282:
283: procedure rosetta_table_copy_in_p7(t out nocopy ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_VARCHAR2_TABLE_100
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_NUMBER_TABLE
287: , a4 JTF_VARCHAR2_TABLE_100
288: , a5 JTF_NUMBER_TABLE
289: , a6 JTF_VARCHAR2_TABLE_100
290: ) as

Line 288: , a5 JTF_NUMBER_TABLE

284: , a1 JTF_VARCHAR2_TABLE_100
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_NUMBER_TABLE
287: , a4 JTF_VARCHAR2_TABLE_100
288: , a5 JTF_NUMBER_TABLE
289: , a6 JTF_VARCHAR2_TABLE_100
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin

Line 314: procedure rosetta_table_copy_out_p7(t ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

310: end loop;
311: end if;
312: end if;
313: end rosetta_table_copy_in_p7;
314: procedure rosetta_table_copy_out_p7(t ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
315: , a1 out nocopy JTF_VARCHAR2_TABLE_100
316: , a2 out nocopy JTF_NUMBER_TABLE
317: , a3 out nocopy JTF_NUMBER_TABLE
318: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , a2 out nocopy JTF_NUMBER_TABLE

312: end if;
313: end rosetta_table_copy_in_p7;
314: procedure rosetta_table_copy_out_p7(t ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
315: , a1 out nocopy JTF_VARCHAR2_TABLE_100
316: , a2 out nocopy JTF_NUMBER_TABLE
317: , a3 out nocopy JTF_NUMBER_TABLE
318: , a4 out nocopy JTF_VARCHAR2_TABLE_100
319: , a5 out nocopy JTF_NUMBER_TABLE
320: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 317: , a3 out nocopy JTF_NUMBER_TABLE

313: end rosetta_table_copy_in_p7;
314: procedure rosetta_table_copy_out_p7(t ahl_prd_parts_change_pvt.move_item_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
315: , a1 out nocopy JTF_VARCHAR2_TABLE_100
316: , a2 out nocopy JTF_NUMBER_TABLE
317: , a3 out nocopy JTF_NUMBER_TABLE
318: , a4 out nocopy JTF_VARCHAR2_TABLE_100
319: , a5 out nocopy JTF_NUMBER_TABLE
320: , a6 out nocopy JTF_VARCHAR2_TABLE_100
321: ) as

Line 319: , a5 out nocopy JTF_NUMBER_TABLE

315: , a1 out nocopy JTF_VARCHAR2_TABLE_100
316: , a2 out nocopy JTF_NUMBER_TABLE
317: , a3 out nocopy JTF_NUMBER_TABLE
318: , a4 out nocopy JTF_VARCHAR2_TABLE_100
319: , a5 out nocopy JTF_NUMBER_TABLE
320: , a6 out nocopy JTF_VARCHAR2_TABLE_100
321: ) as
322: ddindx binary_integer; indx binary_integer;
323: begin

Line 325: a0 := JTF_NUMBER_TABLE();

321: ) as
322: ddindx binary_integer; indx binary_integer;
323: begin
324: if t is null or t.count = 0 then
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_NUMBER_TABLE();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();

Line 327: a2 := JTF_NUMBER_TABLE();

323: begin
324: if t is null or t.count = 0 then
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_NUMBER_TABLE();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_NUMBER_TABLE();
331: a6 := JTF_VARCHAR2_TABLE_100();

Line 328: a3 := JTF_NUMBER_TABLE();

324: if t is null or t.count = 0 then
325: a0 := JTF_NUMBER_TABLE();
326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_NUMBER_TABLE();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_NUMBER_TABLE();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: else

Line 330: a5 := JTF_NUMBER_TABLE();

326: a1 := JTF_VARCHAR2_TABLE_100();
327: a2 := JTF_NUMBER_TABLE();
328: a3 := JTF_NUMBER_TABLE();
329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_NUMBER_TABLE();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();

Line 333: a0 := JTF_NUMBER_TABLE();

329: a4 := JTF_VARCHAR2_TABLE_100();
330: a5 := JTF_NUMBER_TABLE();
331: a6 := JTF_VARCHAR2_TABLE_100();
332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_NUMBER_TABLE();
336: a3 := JTF_NUMBER_TABLE();
337: a4 := JTF_VARCHAR2_TABLE_100();

Line 335: a2 := JTF_NUMBER_TABLE();

331: a6 := JTF_VARCHAR2_TABLE_100();
332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_NUMBER_TABLE();
336: a3 := JTF_NUMBER_TABLE();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_VARCHAR2_TABLE_100();

Line 336: a3 := JTF_NUMBER_TABLE();

332: else
333: a0 := JTF_NUMBER_TABLE();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_NUMBER_TABLE();
336: a3 := JTF_NUMBER_TABLE();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_VARCHAR2_TABLE_100();
340: if t.count > 0 then

Line 338: a5 := JTF_NUMBER_TABLE();

334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_NUMBER_TABLE();
336: a3 := JTF_NUMBER_TABLE();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_VARCHAR2_TABLE_100();
340: if t.count > 0 then
341: a0.extend(t.count);
342: a1.extend(t.count);

Line 374: , p6_a0 in out nocopy JTF_NUMBER_TABLE

370: , p_commit VARCHAR2
371: , p_validation_level NUMBER
372: , p_module_type VARCHAR2
373: , p_default VARCHAR2
374: , p6_a0 in out nocopy JTF_NUMBER_TABLE
375: , p6_a1 in out nocopy JTF_NUMBER_TABLE
376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 375: , p6_a1 in out nocopy JTF_NUMBER_TABLE

371: , p_validation_level NUMBER
372: , p_module_type VARCHAR2
373: , p_default VARCHAR2
374: , p6_a0 in out nocopy JTF_NUMBER_TABLE
375: , p6_a1 in out nocopy JTF_NUMBER_TABLE
376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE

Line 376: , p6_a2 in out nocopy JTF_NUMBER_TABLE

372: , p_module_type VARCHAR2
373: , p_default VARCHAR2
374: , p6_a0 in out nocopy JTF_NUMBER_TABLE
375: , p6_a1 in out nocopy JTF_NUMBER_TABLE
376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE

Line 377: , p6_a3 in out nocopy JTF_NUMBER_TABLE

373: , p_default VARCHAR2
374: , p6_a0 in out nocopy JTF_NUMBER_TABLE
375: , p6_a1 in out nocopy JTF_NUMBER_TABLE
376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE
381: , p6_a7 in out nocopy JTF_NUMBER_TABLE

Line 379: , p6_a5 in out nocopy JTF_NUMBER_TABLE

375: , p6_a1 in out nocopy JTF_NUMBER_TABLE
376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE
381: , p6_a7 in out nocopy JTF_NUMBER_TABLE
382: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a9 in out nocopy JTF_NUMBER_TABLE

Line 380: , p6_a6 in out nocopy JTF_NUMBER_TABLE

376: , p6_a2 in out nocopy JTF_NUMBER_TABLE
377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE
381: , p6_a7 in out nocopy JTF_NUMBER_TABLE
382: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a9 in out nocopy JTF_NUMBER_TABLE
384: , p6_a10 in out nocopy JTF_DATE_TABLE

Line 381: , p6_a7 in out nocopy JTF_NUMBER_TABLE

377: , p6_a3 in out nocopy JTF_NUMBER_TABLE
378: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE
381: , p6_a7 in out nocopy JTF_NUMBER_TABLE
382: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a9 in out nocopy JTF_NUMBER_TABLE
384: , p6_a10 in out nocopy JTF_DATE_TABLE
385: , p6_a11 in out nocopy JTF_NUMBER_TABLE

Line 383: , p6_a9 in out nocopy JTF_NUMBER_TABLE

379: , p6_a5 in out nocopy JTF_NUMBER_TABLE
380: , p6_a6 in out nocopy JTF_NUMBER_TABLE
381: , p6_a7 in out nocopy JTF_NUMBER_TABLE
382: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a9 in out nocopy JTF_NUMBER_TABLE
384: , p6_a10 in out nocopy JTF_DATE_TABLE
385: , p6_a11 in out nocopy JTF_NUMBER_TABLE
386: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a13 in out nocopy JTF_NUMBER_TABLE

Line 385: , p6_a11 in out nocopy JTF_NUMBER_TABLE

381: , p6_a7 in out nocopy JTF_NUMBER_TABLE
382: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a9 in out nocopy JTF_NUMBER_TABLE
384: , p6_a10 in out nocopy JTF_DATE_TABLE
385: , p6_a11 in out nocopy JTF_NUMBER_TABLE
386: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a13 in out nocopy JTF_NUMBER_TABLE
388: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a15 in out nocopy JTF_NUMBER_TABLE

Line 387: , p6_a13 in out nocopy JTF_NUMBER_TABLE

383: , p6_a9 in out nocopy JTF_NUMBER_TABLE
384: , p6_a10 in out nocopy JTF_DATE_TABLE
385: , p6_a11 in out nocopy JTF_NUMBER_TABLE
386: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a13 in out nocopy JTF_NUMBER_TABLE
388: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a15 in out nocopy JTF_NUMBER_TABLE
390: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 389: , p6_a15 in out nocopy JTF_NUMBER_TABLE

385: , p6_a11 in out nocopy JTF_NUMBER_TABLE
386: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a13 in out nocopy JTF_NUMBER_TABLE
388: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a15 in out nocopy JTF_NUMBER_TABLE
390: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p6_a18 in out nocopy JTF_NUMBER_TABLE
393: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 392: , p6_a18 in out nocopy JTF_NUMBER_TABLE

388: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p6_a15 in out nocopy JTF_NUMBER_TABLE
390: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p6_a18 in out nocopy JTF_NUMBER_TABLE
393: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a20 in out nocopy JTF_DATE_TABLE
395: , p6_a21 in out nocopy JTF_NUMBER_TABLE
396: , p6_a22 in out nocopy JTF_NUMBER_TABLE

Line 395: , p6_a21 in out nocopy JTF_NUMBER_TABLE

391: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p6_a18 in out nocopy JTF_NUMBER_TABLE
393: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a20 in out nocopy JTF_DATE_TABLE
395: , p6_a21 in out nocopy JTF_NUMBER_TABLE
396: , p6_a22 in out nocopy JTF_NUMBER_TABLE
397: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a24 in out nocopy JTF_NUMBER_TABLE
399: , p6_a25 in out nocopy JTF_NUMBER_TABLE

Line 396: , p6_a22 in out nocopy JTF_NUMBER_TABLE

392: , p6_a18 in out nocopy JTF_NUMBER_TABLE
393: , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a20 in out nocopy JTF_DATE_TABLE
395: , p6_a21 in out nocopy JTF_NUMBER_TABLE
396: , p6_a22 in out nocopy JTF_NUMBER_TABLE
397: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a24 in out nocopy JTF_NUMBER_TABLE
399: , p6_a25 in out nocopy JTF_NUMBER_TABLE
400: , p6_a26 in out nocopy JTF_DATE_TABLE

Line 398: , p6_a24 in out nocopy JTF_NUMBER_TABLE

394: , p6_a20 in out nocopy JTF_DATE_TABLE
395: , p6_a21 in out nocopy JTF_NUMBER_TABLE
396: , p6_a22 in out nocopy JTF_NUMBER_TABLE
397: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a24 in out nocopy JTF_NUMBER_TABLE
399: , p6_a25 in out nocopy JTF_NUMBER_TABLE
400: , p6_a26 in out nocopy JTF_DATE_TABLE
401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE

Line 399: , p6_a25 in out nocopy JTF_NUMBER_TABLE

395: , p6_a21 in out nocopy JTF_NUMBER_TABLE
396: , p6_a22 in out nocopy JTF_NUMBER_TABLE
397: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a24 in out nocopy JTF_NUMBER_TABLE
399: , p6_a25 in out nocopy JTF_NUMBER_TABLE
400: , p6_a26 in out nocopy JTF_DATE_TABLE
401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE

Line 401: , p6_a27 in out nocopy JTF_NUMBER_TABLE

397: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_100
398: , p6_a24 in out nocopy JTF_NUMBER_TABLE
399: , p6_a25 in out nocopy JTF_NUMBER_TABLE
400: , p6_a26 in out nocopy JTF_DATE_TABLE
401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE
404: , p6_a30 in out nocopy JTF_NUMBER_TABLE
405: , p6_a31 in out nocopy JTF_NUMBER_TABLE

Line 403: , p6_a29 in out nocopy JTF_NUMBER_TABLE

399: , p6_a25 in out nocopy JTF_NUMBER_TABLE
400: , p6_a26 in out nocopy JTF_DATE_TABLE
401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE
404: , p6_a30 in out nocopy JTF_NUMBER_TABLE
405: , p6_a31 in out nocopy JTF_NUMBER_TABLE
406: , p6_a32 in out nocopy JTF_NUMBER_TABLE
407: , x_error_code out nocopy VARCHAR2

Line 404: , p6_a30 in out nocopy JTF_NUMBER_TABLE

400: , p6_a26 in out nocopy JTF_DATE_TABLE
401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE
404: , p6_a30 in out nocopy JTF_NUMBER_TABLE
405: , p6_a31 in out nocopy JTF_NUMBER_TABLE
406: , p6_a32 in out nocopy JTF_NUMBER_TABLE
407: , x_error_code out nocopy VARCHAR2
408: , x_return_status out nocopy VARCHAR2

Line 405: , p6_a31 in out nocopy JTF_NUMBER_TABLE

401: , p6_a27 in out nocopy JTF_NUMBER_TABLE
402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE
404: , p6_a30 in out nocopy JTF_NUMBER_TABLE
405: , p6_a31 in out nocopy JTF_NUMBER_TABLE
406: , p6_a32 in out nocopy JTF_NUMBER_TABLE
407: , x_error_code out nocopy VARCHAR2
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER

Line 406: , p6_a32 in out nocopy JTF_NUMBER_TABLE

402: , p6_a28 in out nocopy JTF_DATE_TABLE
403: , p6_a29 in out nocopy JTF_NUMBER_TABLE
404: , p6_a30 in out nocopy JTF_NUMBER_TABLE
405: , p6_a31 in out nocopy JTF_NUMBER_TABLE
406: , p6_a32 in out nocopy JTF_NUMBER_TABLE
407: , x_error_code out nocopy VARCHAR2
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2

Line 695: , p6_a0 JTF_NUMBER_TABLE

691: , p_commit VARCHAR2
692: , p_validation_level NUMBER
693: , p_module_type VARCHAR2
694: , p_default VARCHAR2
695: , p6_a0 JTF_NUMBER_TABLE
696: , p6_a1 JTF_VARCHAR2_TABLE_100
697: , p6_a2 JTF_NUMBER_TABLE
698: , p6_a3 JTF_NUMBER_TABLE
699: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 697: , p6_a2 JTF_NUMBER_TABLE

693: , p_module_type VARCHAR2
694: , p_default VARCHAR2
695: , p6_a0 JTF_NUMBER_TABLE
696: , p6_a1 JTF_VARCHAR2_TABLE_100
697: , p6_a2 JTF_NUMBER_TABLE
698: , p6_a3 JTF_NUMBER_TABLE
699: , p6_a4 JTF_VARCHAR2_TABLE_100
700: , p6_a5 JTF_NUMBER_TABLE
701: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 698: , p6_a3 JTF_NUMBER_TABLE

694: , p_default VARCHAR2
695: , p6_a0 JTF_NUMBER_TABLE
696: , p6_a1 JTF_VARCHAR2_TABLE_100
697: , p6_a2 JTF_NUMBER_TABLE
698: , p6_a3 JTF_NUMBER_TABLE
699: , p6_a4 JTF_VARCHAR2_TABLE_100
700: , p6_a5 JTF_NUMBER_TABLE
701: , p6_a6 JTF_VARCHAR2_TABLE_100
702: , x_return_status out nocopy VARCHAR2

Line 700: , p6_a5 JTF_NUMBER_TABLE

696: , p6_a1 JTF_VARCHAR2_TABLE_100
697: , p6_a2 JTF_NUMBER_TABLE
698: , p6_a3 JTF_NUMBER_TABLE
699: , p6_a4 JTF_VARCHAR2_TABLE_100
700: , p6_a5 JTF_NUMBER_TABLE
701: , p6_a6 JTF_VARCHAR2_TABLE_100
702: , x_return_status out nocopy VARCHAR2
703: , x_msg_count out nocopy NUMBER
704: , x_msg_data out nocopy VARCHAR2