1: package ozf_task_template_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwttes.pls 115.0 2003/06/26 05:12:56 mchang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_template_pvt.ozf_task_template_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_template_pvt.ozf_task_template_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 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
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 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_VARCHAR2_TABLE_100
12: , a9 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_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_200
20: , a17 JTF_VARCHAR2_TABLE_200
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_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_200
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_200
34: );
35: procedure rosetta_table_copy_out_p1(t ozf_task_template_pvt.ozf_task_template_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_VARCHAR2_TABLE_100
35: procedure rosetta_table_copy_out_p1(t ozf_task_template_pvt.ozf_task_template_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_VARCHAR2_TABLE_100
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_VARCHAR2_TABLE_100
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_NUMBER_TABLE
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_VARCHAR2_TABLE_100
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_NUMBER_TABLE
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
40: , a5 out nocopy JTF_VARCHAR2_TABLE_100
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_NUMBER_TABLE
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_NUMBER_TABLE
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_VARCHAR2_TABLE_100
49: , a14 out nocopy JTF_NUMBER_TABLE
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_NUMBER_TABLE
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_VARCHAR2_TABLE_100
49: , a14 out nocopy JTF_NUMBER_TABLE
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
51: , a16 out nocopy JTF_VARCHAR2_TABLE_200
52: , a17 out nocopy JTF_VARCHAR2_TABLE_200
46: , a11 out nocopy JTF_VARCHAR2_TABLE_100
47: , a12 out nocopy JTF_NUMBER_TABLE
48: , a13 out nocopy JTF_VARCHAR2_TABLE_100
49: , a14 out nocopy JTF_NUMBER_TABLE
50: , a15 out nocopy JTF_VARCHAR2_TABLE_100
51: , a16 out nocopy JTF_VARCHAR2_TABLE_200
52: , a17 out nocopy JTF_VARCHAR2_TABLE_200
53: , a18 out nocopy JTF_VARCHAR2_TABLE_200
54: , a19 out nocopy JTF_VARCHAR2_TABLE_200
75: , x_return_status out nocopy VARCHAR2
76: , x_msg_data out nocopy VARCHAR2
77: , x_msg_count out nocopy NUMBER
78: , p7_a0 JTF_NUMBER_TABLE
79: , p7_a1 JTF_VARCHAR2_TABLE_100
80: , p7_a2 JTF_VARCHAR2_TABLE_4000
81: , p7_a3 JTF_NUMBER_TABLE
82: , p7_a4 JTF_VARCHAR2_TABLE_100
83: , p7_a5 JTF_VARCHAR2_TABLE_100
78: , p7_a0 JTF_NUMBER_TABLE
79: , p7_a1 JTF_VARCHAR2_TABLE_100
80: , p7_a2 JTF_VARCHAR2_TABLE_4000
81: , p7_a3 JTF_NUMBER_TABLE
82: , p7_a4 JTF_VARCHAR2_TABLE_100
83: , p7_a5 JTF_VARCHAR2_TABLE_100
84: , p7_a6 JTF_NUMBER_TABLE
85: , p7_a7 JTF_VARCHAR2_TABLE_100
86: , p7_a8 JTF_NUMBER_TABLE
79: , p7_a1 JTF_VARCHAR2_TABLE_100
80: , p7_a2 JTF_VARCHAR2_TABLE_4000
81: , p7_a3 JTF_NUMBER_TABLE
82: , p7_a4 JTF_VARCHAR2_TABLE_100
83: , p7_a5 JTF_VARCHAR2_TABLE_100
84: , p7_a6 JTF_NUMBER_TABLE
85: , p7_a7 JTF_VARCHAR2_TABLE_100
86: , p7_a8 JTF_NUMBER_TABLE
87: , p7_a9 JTF_VARCHAR2_TABLE_100
81: , p7_a3 JTF_NUMBER_TABLE
82: , p7_a4 JTF_VARCHAR2_TABLE_100
83: , p7_a5 JTF_VARCHAR2_TABLE_100
84: , p7_a6 JTF_NUMBER_TABLE
85: , p7_a7 JTF_VARCHAR2_TABLE_100
86: , p7_a8 JTF_NUMBER_TABLE
87: , p7_a9 JTF_VARCHAR2_TABLE_100
88: , p7_a10 JTF_NUMBER_TABLE
89: , p7_a11 JTF_VARCHAR2_TABLE_100
83: , p7_a5 JTF_VARCHAR2_TABLE_100
84: , p7_a6 JTF_NUMBER_TABLE
85: , p7_a7 JTF_VARCHAR2_TABLE_100
86: , p7_a8 JTF_NUMBER_TABLE
87: , p7_a9 JTF_VARCHAR2_TABLE_100
88: , p7_a10 JTF_NUMBER_TABLE
89: , p7_a11 JTF_VARCHAR2_TABLE_100
90: , p7_a12 JTF_NUMBER_TABLE
91: , p7_a13 JTF_VARCHAR2_TABLE_100
85: , p7_a7 JTF_VARCHAR2_TABLE_100
86: , p7_a8 JTF_NUMBER_TABLE
87: , p7_a9 JTF_VARCHAR2_TABLE_100
88: , p7_a10 JTF_NUMBER_TABLE
89: , p7_a11 JTF_VARCHAR2_TABLE_100
90: , p7_a12 JTF_NUMBER_TABLE
91: , p7_a13 JTF_VARCHAR2_TABLE_100
92: , p7_a14 JTF_NUMBER_TABLE
93: , p7_a15 JTF_VARCHAR2_TABLE_100
87: , p7_a9 JTF_VARCHAR2_TABLE_100
88: , p7_a10 JTF_NUMBER_TABLE
89: , p7_a11 JTF_VARCHAR2_TABLE_100
90: , p7_a12 JTF_NUMBER_TABLE
91: , p7_a13 JTF_VARCHAR2_TABLE_100
92: , p7_a14 JTF_NUMBER_TABLE
93: , p7_a15 JTF_VARCHAR2_TABLE_100
94: , p7_a16 JTF_VARCHAR2_TABLE_200
95: , p7_a17 JTF_VARCHAR2_TABLE_200
89: , p7_a11 JTF_VARCHAR2_TABLE_100
90: , p7_a12 JTF_NUMBER_TABLE
91: , p7_a13 JTF_VARCHAR2_TABLE_100
92: , p7_a14 JTF_NUMBER_TABLE
93: , p7_a15 JTF_VARCHAR2_TABLE_100
94: , p7_a16 JTF_VARCHAR2_TABLE_200
95: , p7_a17 JTF_VARCHAR2_TABLE_200
96: , p7_a18 JTF_VARCHAR2_TABLE_200
97: , p7_a19 JTF_VARCHAR2_TABLE_200
115: , x_return_status out nocopy VARCHAR2
116: , x_msg_data out nocopy VARCHAR2
117: , x_msg_count out nocopy NUMBER
118: , p7_a0 JTF_NUMBER_TABLE
119: , p7_a1 JTF_VARCHAR2_TABLE_100
120: , p7_a2 JTF_VARCHAR2_TABLE_4000
121: , p7_a3 JTF_NUMBER_TABLE
122: , p7_a4 JTF_VARCHAR2_TABLE_100
123: , p7_a5 JTF_VARCHAR2_TABLE_100
118: , p7_a0 JTF_NUMBER_TABLE
119: , p7_a1 JTF_VARCHAR2_TABLE_100
120: , p7_a2 JTF_VARCHAR2_TABLE_4000
121: , p7_a3 JTF_NUMBER_TABLE
122: , p7_a4 JTF_VARCHAR2_TABLE_100
123: , p7_a5 JTF_VARCHAR2_TABLE_100
124: , p7_a6 JTF_NUMBER_TABLE
125: , p7_a7 JTF_VARCHAR2_TABLE_100
126: , p7_a8 JTF_NUMBER_TABLE
119: , p7_a1 JTF_VARCHAR2_TABLE_100
120: , p7_a2 JTF_VARCHAR2_TABLE_4000
121: , p7_a3 JTF_NUMBER_TABLE
122: , p7_a4 JTF_VARCHAR2_TABLE_100
123: , p7_a5 JTF_VARCHAR2_TABLE_100
124: , p7_a6 JTF_NUMBER_TABLE
125: , p7_a7 JTF_VARCHAR2_TABLE_100
126: , p7_a8 JTF_NUMBER_TABLE
127: , p7_a9 JTF_VARCHAR2_TABLE_100
121: , p7_a3 JTF_NUMBER_TABLE
122: , p7_a4 JTF_VARCHAR2_TABLE_100
123: , p7_a5 JTF_VARCHAR2_TABLE_100
124: , p7_a6 JTF_NUMBER_TABLE
125: , p7_a7 JTF_VARCHAR2_TABLE_100
126: , p7_a8 JTF_NUMBER_TABLE
127: , p7_a9 JTF_VARCHAR2_TABLE_100
128: , p7_a10 JTF_NUMBER_TABLE
129: , p7_a11 JTF_VARCHAR2_TABLE_100
123: , p7_a5 JTF_VARCHAR2_TABLE_100
124: , p7_a6 JTF_NUMBER_TABLE
125: , p7_a7 JTF_VARCHAR2_TABLE_100
126: , p7_a8 JTF_NUMBER_TABLE
127: , p7_a9 JTF_VARCHAR2_TABLE_100
128: , p7_a10 JTF_NUMBER_TABLE
129: , p7_a11 JTF_VARCHAR2_TABLE_100
130: , p7_a12 JTF_NUMBER_TABLE
131: , p7_a13 JTF_VARCHAR2_TABLE_100
125: , p7_a7 JTF_VARCHAR2_TABLE_100
126: , p7_a8 JTF_NUMBER_TABLE
127: , p7_a9 JTF_VARCHAR2_TABLE_100
128: , p7_a10 JTF_NUMBER_TABLE
129: , p7_a11 JTF_VARCHAR2_TABLE_100
130: , p7_a12 JTF_NUMBER_TABLE
131: , p7_a13 JTF_VARCHAR2_TABLE_100
132: , p7_a14 JTF_NUMBER_TABLE
133: , p7_a15 JTF_VARCHAR2_TABLE_100
127: , p7_a9 JTF_VARCHAR2_TABLE_100
128: , p7_a10 JTF_NUMBER_TABLE
129: , p7_a11 JTF_VARCHAR2_TABLE_100
130: , p7_a12 JTF_NUMBER_TABLE
131: , p7_a13 JTF_VARCHAR2_TABLE_100
132: , p7_a14 JTF_NUMBER_TABLE
133: , p7_a15 JTF_VARCHAR2_TABLE_100
134: , p7_a16 JTF_VARCHAR2_TABLE_200
135: , p7_a17 JTF_VARCHAR2_TABLE_200
129: , p7_a11 JTF_VARCHAR2_TABLE_100
130: , p7_a12 JTF_NUMBER_TABLE
131: , p7_a13 JTF_VARCHAR2_TABLE_100
132: , p7_a14 JTF_NUMBER_TABLE
133: , p7_a15 JTF_VARCHAR2_TABLE_100
134: , p7_a16 JTF_VARCHAR2_TABLE_200
135: , p7_a17 JTF_VARCHAR2_TABLE_200
136: , p7_a18 JTF_VARCHAR2_TABLE_200
137: , p7_a19 JTF_VARCHAR2_TABLE_200
166: , x_msg_data out nocopy VARCHAR2
167: , x_msg_count out nocopy NUMBER
168: , p_reason_code_id NUMBER
169: , p8_a0 out nocopy JTF_NUMBER_TABLE
170: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
171: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
172: , p8_a3 out nocopy JTF_NUMBER_TABLE
173: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
169: , p8_a0 out nocopy JTF_NUMBER_TABLE
170: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
171: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
172: , p8_a3 out nocopy JTF_NUMBER_TABLE
173: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p8_a6 out nocopy JTF_NUMBER_TABLE
176: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p8_a8 out nocopy JTF_NUMBER_TABLE
170: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
171: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_4000
172: , p8_a3 out nocopy JTF_NUMBER_TABLE
173: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p8_a6 out nocopy JTF_NUMBER_TABLE
176: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p8_a8 out nocopy JTF_NUMBER_TABLE
178: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
172: , p8_a3 out nocopy JTF_NUMBER_TABLE
173: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p8_a6 out nocopy JTF_NUMBER_TABLE
176: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p8_a8 out nocopy JTF_NUMBER_TABLE
178: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
179: , p8_a10 out nocopy JTF_NUMBER_TABLE
180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p8_a6 out nocopy JTF_NUMBER_TABLE
176: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p8_a8 out nocopy JTF_NUMBER_TABLE
178: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
179: , p8_a10 out nocopy JTF_NUMBER_TABLE
180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
181: , p8_a12 out nocopy JTF_NUMBER_TABLE
182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p8_a8 out nocopy JTF_NUMBER_TABLE
178: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
179: , p8_a10 out nocopy JTF_NUMBER_TABLE
180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
181: , p8_a12 out nocopy JTF_NUMBER_TABLE
182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
183: , p8_a14 out nocopy JTF_NUMBER_TABLE
184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
178: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
179: , p8_a10 out nocopy JTF_NUMBER_TABLE
180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
181: , p8_a12 out nocopy JTF_NUMBER_TABLE
182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
183: , p8_a14 out nocopy JTF_NUMBER_TABLE
184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
180: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
181: , p8_a12 out nocopy JTF_NUMBER_TABLE
182: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
183: , p8_a14 out nocopy JTF_NUMBER_TABLE
184: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
186: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
187: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
188: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200