APPS.JTS_CONFIGURATION_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package jts_configuration_pvt_w AUTHID CURRENT_USER as
2: /* $Header: jtswcfgs.pls 115.4 2002/03/22 19:07:54 pkm ship $ */
3: procedure rosetta_table_copy_in_p5(t out jts_configuration_pvt.config_rec_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p5(t out jts_configuration_pvt.config_rec_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_VARCHAR2_TABLE_200

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: );
36: procedure rosetta_table_copy_out_p5(t jts_configuration_pvt.config_rec_tbl_type, a0 out JTF_NUMBER_TABLE
37: , a1 out JTF_VARCHAR2_TABLE_100

Line 34: , a31 JTF_VARCHAR2_TABLE_100

30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: );
36: procedure rosetta_table_copy_out_p5(t jts_configuration_pvt.config_rec_tbl_type, a0 out JTF_NUMBER_TABLE
37: , a1 out JTF_VARCHAR2_TABLE_100
38: , a2 out JTF_VARCHAR2_TABLE_300

Line 37: , a1 out JTF_VARCHAR2_TABLE_100

33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: );
36: procedure rosetta_table_copy_out_p5(t jts_configuration_pvt.config_rec_tbl_type, a0 out JTF_NUMBER_TABLE
37: , a1 out JTF_VARCHAR2_TABLE_100
38: , a2 out JTF_VARCHAR2_TABLE_300
39: , a3 out JTF_NUMBER_TABLE
40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100

Line 40: , a4 out JTF_VARCHAR2_TABLE_100

36: procedure rosetta_table_copy_out_p5(t jts_configuration_pvt.config_rec_tbl_type, a0 out JTF_NUMBER_TABLE
37: , a1 out JTF_VARCHAR2_TABLE_100
38: , a2 out JTF_VARCHAR2_TABLE_300
39: , a3 out JTF_NUMBER_TABLE
40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100
42: , a6 out JTF_VARCHAR2_TABLE_100
43: , a7 out JTF_VARCHAR2_TABLE_100
44: , a8 out JTF_VARCHAR2_TABLE_100

Line 41: , a5 out JTF_VARCHAR2_TABLE_100

37: , a1 out JTF_VARCHAR2_TABLE_100
38: , a2 out JTF_VARCHAR2_TABLE_300
39: , a3 out JTF_NUMBER_TABLE
40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100
42: , a6 out JTF_VARCHAR2_TABLE_100
43: , a7 out JTF_VARCHAR2_TABLE_100
44: , a8 out JTF_VARCHAR2_TABLE_100
45: , a9 out JTF_VARCHAR2_TABLE_200

Line 42: , a6 out JTF_VARCHAR2_TABLE_100

38: , a2 out JTF_VARCHAR2_TABLE_300
39: , a3 out JTF_NUMBER_TABLE
40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100
42: , a6 out JTF_VARCHAR2_TABLE_100
43: , a7 out JTF_VARCHAR2_TABLE_100
44: , a8 out JTF_VARCHAR2_TABLE_100
45: , a9 out JTF_VARCHAR2_TABLE_200
46: , a10 out JTF_VARCHAR2_TABLE_200

Line 43: , a7 out JTF_VARCHAR2_TABLE_100

39: , a3 out JTF_NUMBER_TABLE
40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100
42: , a6 out JTF_VARCHAR2_TABLE_100
43: , a7 out JTF_VARCHAR2_TABLE_100
44: , a8 out JTF_VARCHAR2_TABLE_100
45: , a9 out JTF_VARCHAR2_TABLE_200
46: , a10 out JTF_VARCHAR2_TABLE_200
47: , a11 out JTF_VARCHAR2_TABLE_200

Line 44: , a8 out JTF_VARCHAR2_TABLE_100

40: , a4 out JTF_VARCHAR2_TABLE_100
41: , a5 out JTF_VARCHAR2_TABLE_100
42: , a6 out JTF_VARCHAR2_TABLE_100
43: , a7 out JTF_VARCHAR2_TABLE_100
44: , a8 out JTF_VARCHAR2_TABLE_100
45: , a9 out JTF_VARCHAR2_TABLE_200
46: , a10 out JTF_VARCHAR2_TABLE_200
47: , a11 out JTF_VARCHAR2_TABLE_200
48: , a12 out JTF_VARCHAR2_TABLE_200

Line 66: , a30 out JTF_VARCHAR2_TABLE_100

62: , a26 out JTF_NUMBER_TABLE
63: , a27 out JTF_DATE_TABLE
64: , a28 out JTF_NUMBER_TABLE
65: , a29 out JTF_NUMBER_TABLE
66: , a30 out JTF_VARCHAR2_TABLE_100
67: , a31 out JTF_VARCHAR2_TABLE_100
68: );
69:
70: procedure create_configuration(p_api_version NUMBER

Line 67: , a31 out JTF_VARCHAR2_TABLE_100

63: , a27 out JTF_DATE_TABLE
64: , a28 out JTF_NUMBER_TABLE
65: , a29 out JTF_NUMBER_TABLE
66: , a30 out JTF_VARCHAR2_TABLE_100
67: , a31 out JTF_VARCHAR2_TABLE_100
68: );
69:
70: procedure create_configuration(p_api_version NUMBER
71: , x_config_id out NUMBER

Line 152: , p4_a1 out JTF_VARCHAR2_TABLE_100

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

Line 155: , p4_a4 out JTF_VARCHAR2_TABLE_100

151: , p4_a0 out JTF_NUMBER_TABLE
152: , p4_a1 out JTF_VARCHAR2_TABLE_100
153: , p4_a2 out JTF_VARCHAR2_TABLE_300
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_100
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_100
158: , p4_a7 out JTF_VARCHAR2_TABLE_100
159: , p4_a8 out JTF_VARCHAR2_TABLE_100

Line 156: , p4_a5 out JTF_VARCHAR2_TABLE_100

152: , p4_a1 out JTF_VARCHAR2_TABLE_100
153: , p4_a2 out JTF_VARCHAR2_TABLE_300
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_100
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_100
158: , p4_a7 out JTF_VARCHAR2_TABLE_100
159: , p4_a8 out JTF_VARCHAR2_TABLE_100
160: , p4_a9 out JTF_VARCHAR2_TABLE_200

Line 157: , p4_a6 out JTF_VARCHAR2_TABLE_100

153: , p4_a2 out JTF_VARCHAR2_TABLE_300
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_100
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_100
158: , p4_a7 out JTF_VARCHAR2_TABLE_100
159: , p4_a8 out JTF_VARCHAR2_TABLE_100
160: , p4_a9 out JTF_VARCHAR2_TABLE_200
161: , p4_a10 out JTF_VARCHAR2_TABLE_200

Line 158: , p4_a7 out JTF_VARCHAR2_TABLE_100

154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_100
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_100
158: , p4_a7 out JTF_VARCHAR2_TABLE_100
159: , p4_a8 out JTF_VARCHAR2_TABLE_100
160: , p4_a9 out JTF_VARCHAR2_TABLE_200
161: , p4_a10 out JTF_VARCHAR2_TABLE_200
162: , p4_a11 out JTF_VARCHAR2_TABLE_200

Line 159: , p4_a8 out JTF_VARCHAR2_TABLE_100

155: , p4_a4 out JTF_VARCHAR2_TABLE_100
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_100
158: , p4_a7 out JTF_VARCHAR2_TABLE_100
159: , p4_a8 out JTF_VARCHAR2_TABLE_100
160: , p4_a9 out JTF_VARCHAR2_TABLE_200
161: , p4_a10 out JTF_VARCHAR2_TABLE_200
162: , p4_a11 out JTF_VARCHAR2_TABLE_200
163: , p4_a12 out JTF_VARCHAR2_TABLE_200

Line 181: , p4_a30 out JTF_VARCHAR2_TABLE_100

177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_DATE_TABLE
179: , p4_a28 out JTF_NUMBER_TABLE
180: , p4_a29 out JTF_NUMBER_TABLE
181: , p4_a30 out JTF_VARCHAR2_TABLE_100
182: , p4_a31 out JTF_VARCHAR2_TABLE_100
183: , x_return_status out VARCHAR2
184: , x_msg_count out NUMBER
185: , x_msg_data out VARCHAR2

Line 182: , p4_a31 out JTF_VARCHAR2_TABLE_100

178: , p4_a27 out JTF_DATE_TABLE
179: , p4_a28 out JTF_NUMBER_TABLE
180: , p4_a29 out JTF_NUMBER_TABLE
181: , p4_a30 out JTF_VARCHAR2_TABLE_100
182: , p4_a31 out JTF_VARCHAR2_TABLE_100
183: , x_return_status out VARCHAR2
184: , x_msg_count out NUMBER
185: , x_msg_data out VARCHAR2
186: );