DBA Data[Home] [Help]

APPS.JTS_CONFIG_VERSION_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE

1: package jts_config_version_pvt_w AUTHID CURRENT_USER as
2: /* $Header: jtswcvrs.pls 115.5 2002/03/27 18:03:15 pkm ship $ */
3: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_NUMBER_TABLE

1: package jts_config_version_pvt_w AUTHID CURRENT_USER as
2: /* $Header: jtswcvrs.pls 115.5 2002/03/27 18:03:15 pkm ship $ */
3: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: jtswcvrs.pls 115.5 2002/03/27 18:03:15 pkm ship $ */
3: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100

Line 45: , a42 JTF_NUMBER_TABLE

41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100

Line 47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE

43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100
50: , a3 out JTF_NUMBER_TABLE
51: , a4 out JTF_VARCHAR2_TABLE_300

Line 48: , a1 out JTF_NUMBER_TABLE

44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100
50: , a3 out JTF_NUMBER_TABLE
51: , a4 out JTF_VARCHAR2_TABLE_300
52: , a5 out JTF_VARCHAR2_TABLE_100

Line 50: , a3 out JTF_NUMBER_TABLE

46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100
50: , a3 out JTF_NUMBER_TABLE
51: , a4 out JTF_VARCHAR2_TABLE_300
52: , a5 out JTF_VARCHAR2_TABLE_100
53: , a6 out JTF_VARCHAR2_TABLE_200
54: , a7 out JTF_VARCHAR2_TABLE_200

Line 70: , a23 out JTF_NUMBER_TABLE

66: , a19 out JTF_VARCHAR2_TABLE_200
67: , a20 out JTF_VARCHAR2_TABLE_200
68: , a21 out JTF_VARCHAR2_TABLE_200
69: , a22 out JTF_DATE_TABLE
70: , a23 out JTF_NUMBER_TABLE
71: , a24 out JTF_DATE_TABLE
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100

Line 72: , a25 out JTF_NUMBER_TABLE

68: , a21 out JTF_VARCHAR2_TABLE_200
69: , a22 out JTF_DATE_TABLE
70: , a23 out JTF_NUMBER_TABLE
71: , a24 out JTF_DATE_TABLE
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100

Line 73: , a26 out JTF_NUMBER_TABLE

69: , a22 out JTF_DATE_TABLE
70: , a23 out JTF_NUMBER_TABLE
71: , a24 out JTF_DATE_TABLE
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300

Line 78: , a31 out JTF_NUMBER_TABLE

74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100

Line 89: , a42 out JTF_NUMBER_TABLE

85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);
93: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE);

Line 92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);

88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);
93: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE);
94:
95: procedure delete_some_versions(p_api_version NUMBER
96: , p_version_tbl JTF_NUMBER_TABLE

Line 93: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE);

89: , a42 out JTF_NUMBER_TABLE
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);
93: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE);
94:
95: procedure delete_some_versions(p_api_version NUMBER
96: , p_version_tbl JTF_NUMBER_TABLE
97: );

Line 96: , p_version_tbl JTF_NUMBER_TABLE

92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);
93: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE);
94:
95: procedure delete_some_versions(p_api_version NUMBER
96: , p_version_tbl JTF_NUMBER_TABLE
97: );
98: procedure get_version(p_api_version NUMBER
99: , p_version_id NUMBER
100: , p2_a0 out NUMBER

Line 151: , p4_a0 out JTF_NUMBER_TABLE

147: procedure get_versions(p_api_version NUMBER
148: , p_config_id NUMBER
149: , p_order_by VARCHAR2
150: , p_how_to_order VARCHAR2
151: , p4_a0 out JTF_NUMBER_TABLE
152: , p4_a1 out JTF_NUMBER_TABLE
153: , p4_a2 out JTF_VARCHAR2_TABLE_100
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_300

Line 152: , p4_a1 out JTF_NUMBER_TABLE

148: , p_config_id NUMBER
149: , p_order_by VARCHAR2
150: , p_how_to_order VARCHAR2
151: , p4_a0 out JTF_NUMBER_TABLE
152: , p4_a1 out JTF_NUMBER_TABLE
153: , p4_a2 out JTF_VARCHAR2_TABLE_100
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_300
156: , p4_a5 out JTF_VARCHAR2_TABLE_100

Line 154: , p4_a3 out JTF_NUMBER_TABLE

150: , p_how_to_order VARCHAR2
151: , p4_a0 out JTF_NUMBER_TABLE
152: , p4_a1 out JTF_NUMBER_TABLE
153: , p4_a2 out JTF_VARCHAR2_TABLE_100
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_300
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_200
158: , p4_a7 out JTF_VARCHAR2_TABLE_200

Line 174: , p4_a23 out JTF_NUMBER_TABLE

170: , p4_a19 out JTF_VARCHAR2_TABLE_200
171: , p4_a20 out JTF_VARCHAR2_TABLE_200
172: , p4_a21 out JTF_VARCHAR2_TABLE_200
173: , p4_a22 out JTF_DATE_TABLE
174: , p4_a23 out JTF_NUMBER_TABLE
175: , p4_a24 out JTF_DATE_TABLE
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100

Line 176: , p4_a25 out JTF_NUMBER_TABLE

172: , p4_a21 out JTF_VARCHAR2_TABLE_200
173: , p4_a22 out JTF_DATE_TABLE
174: , p4_a23 out JTF_NUMBER_TABLE
175: , p4_a24 out JTF_DATE_TABLE
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100

Line 177: , p4_a26 out JTF_NUMBER_TABLE

173: , p4_a22 out JTF_DATE_TABLE
174: , p4_a23 out JTF_NUMBER_TABLE
175: , p4_a24 out JTF_DATE_TABLE
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300

Line 182: , p4_a31 out JTF_NUMBER_TABLE

178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100

Line 193: , p4_a42 out JTF_NUMBER_TABLE

189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
193: , p4_a42 out JTF_NUMBER_TABLE
194: , x_return_status out VARCHAR2
195: , x_msg_count out NUMBER
196: , x_msg_data out VARCHAR2
197: );