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
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
9: , a6 JTF_NUMBER_TABLE
10: , a7 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
13: , a10 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
15: , a12 JTF_NUMBER_TABLE
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
17: , a14 JTF_NUMBER_TABLE
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
19: , a16 JTF_VARCHAR2_TABLE_200
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
21: , a18 JTF_VARCHAR2_TABLE_200
31: , a28 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
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
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 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
45: , a10 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
47: , a12 out nocopy JTF_NUMBER_TABLE
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
49: , a14 out nocopy JTF_NUMBER_TABLE
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
51: , a16 out nocopy JTF_VARCHAR2_TABLE_200
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
53: , a18 out nocopy JTF_VARCHAR2_TABLE_200
64: , a29 out nocopy JTF_VARCHAR2_TABLE_200
65: , a30 out nocopy JTF_VARCHAR2_TABLE_200
66: );
67:
68: procedure rosetta_table_copy_in_p2(t out nocopy ozf_task_template_pvt.ozf_number_tbl_type, a0 JTF_NUMBER_TABLE);
69: procedure rosetta_table_copy_out_p2(t ozf_task_template_pvt.ozf_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
70:
71: procedure create_tasktemplate(p_api_version NUMBER
72: , p_init_msg_list VARCHAR2
65: , a30 out nocopy JTF_VARCHAR2_TABLE_200
66: );
67:
68: procedure rosetta_table_copy_in_p2(t out nocopy ozf_task_template_pvt.ozf_number_tbl_type, a0 JTF_NUMBER_TABLE);
69: procedure rosetta_table_copy_out_p2(t ozf_task_template_pvt.ozf_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
70:
71: procedure create_tasktemplate(p_api_version NUMBER
72: , p_init_msg_list VARCHAR2
73: , p_commit VARCHAR2
74: , p_validation_level NUMBER
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
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
84: , p7_a6 JTF_NUMBER_TABLE
85: , p7_a7 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
88: , p7_a10 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
90: , p7_a12 JTF_NUMBER_TABLE
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
92: , p7_a14 JTF_NUMBER_TABLE
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
94: , p7_a16 JTF_VARCHAR2_TABLE_200
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
96: , p7_a18 JTF_VARCHAR2_TABLE_200
105: , p7_a27 JTF_VARCHAR2_TABLE_200
106: , p7_a28 JTF_VARCHAR2_TABLE_200
107: , p7_a29 JTF_VARCHAR2_TABLE_200
108: , p7_a30 JTF_VARCHAR2_TABLE_200
109: , x_task_template_id out nocopy JTF_NUMBER_TABLE
110: );
111: procedure update_tasktemplate(p_api_version NUMBER
112: , p_init_msg_list VARCHAR2
113: , p_commit VARCHAR2
114: , p_validation_level NUMBER
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
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
124: , p7_a6 JTF_NUMBER_TABLE
125: , p7_a7 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
128: , p7_a10 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
130: , p7_a12 JTF_NUMBER_TABLE
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
132: , p7_a14 JTF_NUMBER_TABLE
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
134: , p7_a16 JTF_VARCHAR2_TABLE_200
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
136: , p7_a18 JTF_VARCHAR2_TABLE_200
145: , p7_a27 JTF_VARCHAR2_TABLE_200
146: , p7_a28 JTF_VARCHAR2_TABLE_200
147: , p7_a29 JTF_VARCHAR2_TABLE_200
148: , p7_a30 JTF_VARCHAR2_TABLE_200
149: , x_object_version_number out nocopy JTF_NUMBER_TABLE
150: );
151: procedure delete_tasktemplate(p_api_version NUMBER
152: , p_init_msg_list VARCHAR2
153: , p_commit VARCHAR2
154: , p_validation_level NUMBER
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_data out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
158: , p_task_template_id JTF_NUMBER_TABLE
159: , p_object_version_number JTF_NUMBER_TABLE
160: );
161: procedure get_tasktemplate(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_data out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
158: , p_task_template_id JTF_NUMBER_TABLE
159: , p_object_version_number JTF_NUMBER_TABLE
160: );
161: procedure get_tasktemplate(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2
163: , p_commit VARCHAR2
165: , x_return_status out nocopy VARCHAR2
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
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
175: , p8_a6 out nocopy JTF_NUMBER_TABLE
176: , p8_a7 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
179: , p8_a10 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
181: , p8_a12 out nocopy JTF_NUMBER_TABLE
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
183: , p8_a14 out nocopy JTF_NUMBER_TABLE
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
185: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
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
187: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200