1: package cs_servicerequest_pub_w AUTHID CURRENT_USER as
2: /* $Header: cssrrsws.pls 120.9.12020000.3 2013/02/04 15:50:53 lkullamb ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_32767
5: , a2 JTF_VARCHAR2_TABLE_300
1: package cs_servicerequest_pub_w AUTHID CURRENT_USER as
2: /* $Header: cssrrsws.pls 120.9.12020000.3 2013/02/04 15:50:53 lkullamb ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_VARCHAR2_TABLE_32767
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
14: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
15: , a2 out nocopy JTF_VARCHAR2_TABLE_300
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_VARCHAR2_TABLE_100
28: , a4 JTF_VARCHAR2_TABLE_100
30: , a6 JTF_VARCHAR2_TABLE_100
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_DATE_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE
46: , a1 JTF_VARCHAR2_TABLE_200
47: , a2 JTF_VARCHAR2_TABLE_200
48: , a3 JTF_VARCHAR2_TABLE_200
49: , a4 JTF_VARCHAR2_TABLE_200
57: , a12 JTF_VARCHAR2_TABLE_200
58: , a13 JTF_VARCHAR2_TABLE_100
59: , a14 JTF_VARCHAR2_TABLE_100
60: );
61: procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_200
63: , a2 out nocopy JTF_VARCHAR2_TABLE_200
64: , a3 out nocopy JTF_VARCHAR2_TABLE_200
65: , a4 out nocopy JTF_VARCHAR2_TABLE_200
74: , a13 out nocopy JTF_VARCHAR2_TABLE_100
75: , a14 out nocopy JTF_VARCHAR2_TABLE_100
76: );
77:
78: procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_200
82: , a4 JTF_VARCHAR2_TABLE_4000
84: , a6 JTF_DATE_TABLE
85: , a7 JTF_VARCHAR2_TABLE_4000
86: , a8 JTF_VARCHAR2_TABLE_100
87: );
88: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_200
92: , a4 out nocopy JTF_VARCHAR2_TABLE_4000
95: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98:
99: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);
100: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
101:
102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
96: , a8 out nocopy JTF_VARCHAR2_TABLE_100
97: );
98:
99: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);
100: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
101:
102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
104:
98:
99: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);
100: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
101:
102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
104:
105: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
106: , a1 JTF_VARCHAR2_TABLE_100
99: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);
100: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
101:
102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
104:
105: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
106: , a1 JTF_VARCHAR2_TABLE_100
107: , a2 JTF_CLOB_TABLE
101:
102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
104:
105: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
106: , a1 JTF_VARCHAR2_TABLE_100
107: , a2 JTF_CLOB_TABLE
108: , a3 JTF_NUMBER_TABLE
109: );
106: , a1 JTF_VARCHAR2_TABLE_100
107: , a2 JTF_CLOB_TABLE
108: , a3 JTF_NUMBER_TABLE
109: );
110: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a1 out nocopy JTF_VARCHAR2_TABLE_100
112: , a2 out nocopy JTF_CLOB_TABLE
113: , a3 out nocopy JTF_NUMBER_TABLE
114: );
112: , a2 out nocopy JTF_CLOB_TABLE
113: , a3 out nocopy JTF_NUMBER_TABLE
114: );
115:
116: procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100
117: , a1 JTF_VARCHAR2_TABLE_100
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_VARCHAR2_TABLE_100
183: , a67 JTF_VARCHAR2_TABLE_200
184: , a68 JTF_VARCHAR2_TABLE_200
185: , a69 JTF_VARCHAR2_TABLE_200
186: );
187: procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , a3 out nocopy JTF_VARCHAR2_TABLE_100
191: , a4 out nocopy JTF_VARCHAR2_TABLE_100
2080: , x_return_status out nocopy VARCHAR2
2081: , x_msg_count out nocopy VARCHAR2
2082: , x_msg_data out nocopy VARCHAR2
2083: );
2084: end cs_servicerequest_pub_w;