DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB_W dependencies on CS_SERVICEREQUEST_PUB

Line 1: package cs_servicerequest_pub_w AUTHID CURRENT_USER as

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

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000

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

Line 13: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 24: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 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

Line 34: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE

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

Line 45: procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 61: procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 78: procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 88: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 99: procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);

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);

Line 100: procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

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:

Line 102: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);

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

Line 103: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy 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

Line 105: procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000

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: );

Line 110: procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000

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: );

Line 116: procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100

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

Line 187: procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy 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

Line 2084: end cs_servicerequest_pub_w;

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;