1: package body ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSB.pls 120.2 2006/01/19 16:48 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSB.pls 120.2 2006/01/19 16:48 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package body ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSB.pls 120.2 2006/01/19 16:48 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
2: /* $Header: AHLWTRSB.pls 120.2 2006/01/19 16:48 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
74: end loop;
75: end if;
76: end if;
77: end rosetta_table_copy_in_p1;
78: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
75: end if;
76: end if;
77: end rosetta_table_copy_in_p1;
78: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
76: end if;
77: end rosetta_table_copy_in_p1;
78: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
77: end rosetta_table_copy_in_p1;
78: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
78: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_NUMBER_TABLE
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
84: , a6 out nocopy JTF_VARCHAR2_TABLE_300
85: , a7 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100
87: , a9 out nocopy JTF_VARCHAR2_TABLE_300
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
88: , a10 out nocopy JTF_NUMBER_TABLE
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
89: , a11 out nocopy JTF_VARCHAR2_TABLE_100
90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_VARCHAR2_TABLE_100
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_NUMBER_TABLE
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a16 out nocopy JTF_VARCHAR2_TABLE_100
95: , a17 out nocopy JTF_VARCHAR2_TABLE_100
96: , a18 out nocopy JTF_VARCHAR2_TABLE_100
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_NUMBER_TABLE
99: , a21 out nocopy JTF_VARCHAR2_TABLE_100
100: , a22 out nocopy JTF_VARCHAR2_TABLE_100
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin
110: if t is null or t.count = 0 then
111: a0 := JTF_NUMBER_TABLE();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
108: ddindx binary_integer; indx binary_integer;
109: begin
110: if t is null or t.count = 0 then
111: a0 := JTF_NUMBER_TABLE();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
109: begin
110: if t is null or t.count = 0 then
111: a0 := JTF_NUMBER_TABLE();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
110: if t is null or t.count = 0 then
111: a0 := JTF_NUMBER_TABLE();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
111: a0 := JTF_NUMBER_TABLE();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
112: a1 := JTF_NUMBER_TABLE();
113: a2 := JTF_NUMBER_TABLE();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
114: a3 := JTF_NUMBER_TABLE();
115: a4 := JTF_NUMBER_TABLE();
116: a5 := JTF_NUMBER_TABLE();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
117: a6 := JTF_VARCHAR2_TABLE_300();
118: a7 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
119: a8 := JTF_VARCHAR2_TABLE_100();
120: a9 := JTF_VARCHAR2_TABLE_300();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
121: a10 := JTF_NUMBER_TABLE();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
122: a11 := JTF_VARCHAR2_TABLE_100();
123: a12 := JTF_NUMBER_TABLE();
124: a13 := JTF_VARCHAR2_TABLE_100();
125: a14 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
126: a15 := JTF_NUMBER_TABLE();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
127: a16 := JTF_VARCHAR2_TABLE_100();
128: a17 := JTF_VARCHAR2_TABLE_100();
129: a18 := JTF_VARCHAR2_TABLE_100();
130: a19 := JTF_NUMBER_TABLE();
131: a20 := JTF_NUMBER_TABLE();
132: a21 := JTF_VARCHAR2_TABLE_100();
133: a22 := JTF_VARCHAR2_TABLE_100();
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
144: a3 := JTF_NUMBER_TABLE();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_NUMBER_TABLE();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_VARCHAR2_TABLE_300();
148: a7 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
149: a8 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_300();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_NUMBER_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_NUMBER_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
156: a15 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_VARCHAR2_TABLE_100();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
238: end if;
239: end if;
240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
239: end if;
240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
241:
242: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
242: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
245: , a3 JTF_NUMBER_TABLE
246: , a4 JTF_NUMBER_TABLE
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
253: , a11 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
253: , a11 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_NUMBER_TABLE
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_NUMBER_TABLE
252: , a10 JTF_NUMBER_TABLE
253: , a11 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;
256: begin
279: end loop;
280: end if;
281: end if;
282: end rosetta_table_copy_in_p3;
283: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
280: end if;
281: end if;
282: end rosetta_table_copy_in_p3;
283: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
281: end if;
282: end rosetta_table_copy_in_p3;
283: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
282: end rosetta_table_copy_in_p3;
283: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
283: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
284: , a1 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
285: , a2 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
286: , a3 out nocopy JTF_NUMBER_TABLE
287: , a4 out nocopy JTF_NUMBER_TABLE
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
294: , a11 out nocopy JTF_VARCHAR2_TABLE_100
288: , a5 out nocopy JTF_NUMBER_TABLE
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
294: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: ) as
296: ddindx binary_integer; indx binary_integer;
289: , a6 out nocopy JTF_NUMBER_TABLE
290: , a7 out nocopy JTF_NUMBER_TABLE
291: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a9 out nocopy JTF_NUMBER_TABLE
293: , a10 out nocopy JTF_NUMBER_TABLE
294: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: ) as
296: ddindx binary_integer; indx binary_integer;
297: begin
295: ) as
296: ddindx binary_integer; indx binary_integer;
297: begin
298: if t is null or t.count = 0 then
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
296: ddindx binary_integer; indx binary_integer;
297: begin
298: if t is null or t.count = 0 then
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
297: begin
298: if t is null or t.count = 0 then
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
298: if t is null or t.count = 0 then
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_NUMBER_TABLE();
307: a8 := JTF_VARCHAR2_TABLE_100();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
308: a9 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
309: a10 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
310: a11 := JTF_VARCHAR2_TABLE_100();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
311: else
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
312: a0 := JTF_NUMBER_TABLE();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
313: a1 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
314: a2 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
315: a3 := JTF_NUMBER_TABLE();
316: a4 := JTF_NUMBER_TABLE();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
323: a11 := JTF_VARCHAR2_TABLE_100();
317: a5 := JTF_NUMBER_TABLE();
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
323: a11 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
318: a6 := JTF_NUMBER_TABLE();
319: a7 := JTF_NUMBER_TABLE();
320: a8 := JTF_VARCHAR2_TABLE_100();
321: a9 := JTF_NUMBER_TABLE();
322: a10 := JTF_NUMBER_TABLE();
323: a11 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);
367: , p_module_type VARCHAR2
368: , x_return_status out nocopy VARCHAR2
369: , x_msg_count out nocopy NUMBER
370: , x_msg_data out nocopy VARCHAR2
371: , p9_a0 in out nocopy JTF_NUMBER_TABLE
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
368: , x_return_status out nocopy VARCHAR2
369: , x_msg_count out nocopy NUMBER
370: , x_msg_data out nocopy VARCHAR2
371: , p9_a0 in out nocopy JTF_NUMBER_TABLE
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
369: , x_msg_count out nocopy NUMBER
370: , x_msg_data out nocopy VARCHAR2
371: , p9_a0 in out nocopy JTF_NUMBER_TABLE
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
370: , x_msg_data out nocopy VARCHAR2
371: , p9_a0 in out nocopy JTF_NUMBER_TABLE
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
371: , p9_a0 in out nocopy JTF_NUMBER_TABLE
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
372: , p9_a1 in out nocopy JTF_NUMBER_TABLE
373: , p9_a2 in out nocopy JTF_NUMBER_TABLE
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
374: , p9_a3 in out nocopy JTF_NUMBER_TABLE
375: , p9_a4 in out nocopy JTF_NUMBER_TABLE
376: , p9_a5 in out nocopy JTF_NUMBER_TABLE
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
378: , p9_a7 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
379: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
381: , p9_a10 in out nocopy JTF_NUMBER_TABLE
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
382: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p9_a12 in out nocopy JTF_NUMBER_TABLE
384: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p9_a14 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
386: , p9_a15 in out nocopy JTF_NUMBER_TABLE
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
388: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
389: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p9_a19 in out nocopy JTF_NUMBER_TABLE
391: , p9_a20 in out nocopy JTF_NUMBER_TABLE
392: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
507: , p_module_type VARCHAR2
508: , x_return_status out nocopy VARCHAR2
509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p9_a0 in out nocopy JTF_NUMBER_TABLE
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
508: , x_return_status out nocopy VARCHAR2
509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p9_a0 in out nocopy JTF_NUMBER_TABLE
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
509: , x_msg_count out nocopy NUMBER
510: , x_msg_data out nocopy VARCHAR2
511: , p9_a0 in out nocopy JTF_NUMBER_TABLE
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
510: , x_msg_data out nocopy VARCHAR2
511: , p9_a0 in out nocopy JTF_NUMBER_TABLE
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
511: , p9_a0 in out nocopy JTF_NUMBER_TABLE
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p9_a1 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
513: , p9_a2 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
514: , p9_a3 in out nocopy JTF_NUMBER_TABLE
515: , p9_a4 in out nocopy JTF_NUMBER_TABLE
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
522: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p9_a5 in out nocopy JTF_NUMBER_TABLE
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
522: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
523: )
524:
517: , p9_a6 in out nocopy JTF_NUMBER_TABLE
518: , p9_a7 in out nocopy JTF_NUMBER_TABLE
519: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p9_a9 in out nocopy JTF_NUMBER_TABLE
521: , p9_a10 in out nocopy JTF_NUMBER_TABLE
522: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
523: )
524:
525: as
597: , p_employee_id NUMBER
598: , p_workorder_id NUMBER
599: , p_operation_seq_num NUMBER
600: , p_function_name VARCHAR2
601: , p10_a0 out nocopy JTF_NUMBER_TABLE
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
598: , p_workorder_id NUMBER
599: , p_operation_seq_num NUMBER
600: , p_function_name VARCHAR2
601: , p10_a0 out nocopy JTF_NUMBER_TABLE
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
599: , p_operation_seq_num NUMBER
600: , p_function_name VARCHAR2
601: , p10_a0 out nocopy JTF_NUMBER_TABLE
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
600: , p_function_name VARCHAR2
601: , p10_a0 out nocopy JTF_NUMBER_TABLE
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
601: , p10_a0 out nocopy JTF_NUMBER_TABLE
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
602: , p10_a1 out nocopy JTF_NUMBER_TABLE
603: , p10_a2 out nocopy JTF_NUMBER_TABLE
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
604: , p10_a3 out nocopy JTF_NUMBER_TABLE
605: , p10_a4 out nocopy JTF_NUMBER_TABLE
606: , p10_a5 out nocopy JTF_NUMBER_TABLE
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
607: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
608: , p10_a7 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
609: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
610: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
611: , p10_a10 out nocopy JTF_NUMBER_TABLE
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
612: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
613: , p10_a12 out nocopy JTF_NUMBER_TABLE
614: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
615: , p10_a14 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
616: , p10_a15 out nocopy JTF_NUMBER_TABLE
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
617: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
618: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
619: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
620: , p10_a19 out nocopy JTF_NUMBER_TABLE
621: , p10_a20 out nocopy JTF_NUMBER_TABLE
622: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
623: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100