APPS.JTF_PERZ_QUERY_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package jtf_perz_query_pub_w as
2: /* $Header: jtfzwpqs.pls 120.2 2005/11/02 23:49:08 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: jtfzwpqs.pls 120.2 2005/11/02 23:49:08 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: );

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: );
11: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 13: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: );
11: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
15: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
16: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 14: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

10: );
11: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
15: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
16: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18: );

Line 16: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

12: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
15: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
16: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18: );
19:
20: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE

Line 23: , a3 JTF_VARCHAR2_TABLE_100

19:
20: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
21: , a1 JTF_NUMBER_TABLE
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_VARCHAR2_TABLE_100
24: , a4 JTF_VARCHAR2_TABLE_100
25: , a5 JTF_VARCHAR2_TABLE_300
26: , a6 JTF_VARCHAR2_TABLE_2000
27: );

Line 24: , a4 JTF_VARCHAR2_TABLE_100

20: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
21: , a1 JTF_NUMBER_TABLE
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_VARCHAR2_TABLE_100
24: , a4 JTF_VARCHAR2_TABLE_100
25: , a5 JTF_VARCHAR2_TABLE_300
26: , a6 JTF_VARCHAR2_TABLE_2000
27: );
28: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 31: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

27: );
28: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
29: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
30: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
31: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
35: );

Line 32: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

28: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
29: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
30: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
31: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
34: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
35: );
36:

Line 39: , a2 JTF_VARCHAR2_TABLE_100

35: );
36:
37: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
38: , a1 JTF_NUMBER_TABLE
39: , a2 JTF_VARCHAR2_TABLE_100
40: , a3 JTF_VARCHAR2_TABLE_100
41: , a4 JTF_NUMBER_TABLE
42: );
43: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 40: , a3 JTF_VARCHAR2_TABLE_100

36:
37: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
38: , a1 JTF_NUMBER_TABLE
39: , a2 JTF_VARCHAR2_TABLE_100
40: , a3 JTF_VARCHAR2_TABLE_100
41: , a4 JTF_NUMBER_TABLE
42: );
43: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
44: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 45: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

41: , a4 JTF_NUMBER_TABLE
42: );
43: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
44: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
48: );
49:

Line 46: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

42: );
43: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
44: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
48: );
49:
50: procedure save_perz_query(p_api_version_number NUMBER

Line 59: , p7_a2 JTF_VARCHAR2_TABLE_100

55: , p_profile_name VARCHAR2
56: , p_profile_type VARCHAR2
57: , p7_a0 JTF_NUMBER_TABLE
58: , p7_a1 JTF_NUMBER_TABLE
59: , p7_a2 JTF_VARCHAR2_TABLE_100
60: , p7_a3 JTF_VARCHAR2_TABLE_100
61: , p7_a4 JTF_VARCHAR2_TABLE_100
62: , p_query_id NUMBER
63: , p_query_name VARCHAR2

Line 60: , p7_a3 JTF_VARCHAR2_TABLE_100

56: , p_profile_type VARCHAR2
57: , p7_a0 JTF_NUMBER_TABLE
58: , p7_a1 JTF_NUMBER_TABLE
59: , p7_a2 JTF_VARCHAR2_TABLE_100
60: , p7_a3 JTF_VARCHAR2_TABLE_100
61: , p7_a4 JTF_VARCHAR2_TABLE_100
62: , p_query_id NUMBER
63: , p_query_name VARCHAR2
64: , p_query_type VARCHAR2

Line 61: , p7_a4 JTF_VARCHAR2_TABLE_100

57: , p7_a0 JTF_NUMBER_TABLE
58: , p7_a1 JTF_NUMBER_TABLE
59: , p7_a2 JTF_VARCHAR2_TABLE_100
60: , p7_a3 JTF_VARCHAR2_TABLE_100
61: , p7_a4 JTF_VARCHAR2_TABLE_100
62: , p_query_id NUMBER
63: , p_query_name VARCHAR2
64: , p_query_type VARCHAR2
65: , p_query_desc VARCHAR2

Line 69: , p13_a2 JTF_VARCHAR2_TABLE_100

65: , p_query_desc VARCHAR2
66: , p_query_data_source VARCHAR2
67: , p13_a0 JTF_NUMBER_TABLE
68: , p13_a1 JTF_NUMBER_TABLE
69: , p13_a2 JTF_VARCHAR2_TABLE_100
70: , p13_a3 JTF_VARCHAR2_TABLE_100
71: , p13_a4 JTF_VARCHAR2_TABLE_300
72: , p13_a5 JTF_VARCHAR2_TABLE_100
73: , p13_a6 JTF_NUMBER_TABLE

Line 70: , p13_a3 JTF_VARCHAR2_TABLE_100

66: , p_query_data_source VARCHAR2
67: , p13_a0 JTF_NUMBER_TABLE
68: , p13_a1 JTF_NUMBER_TABLE
69: , p13_a2 JTF_VARCHAR2_TABLE_100
70: , p13_a3 JTF_VARCHAR2_TABLE_100
71: , p13_a4 JTF_VARCHAR2_TABLE_300
72: , p13_a5 JTF_VARCHAR2_TABLE_100
73: , p13_a6 JTF_NUMBER_TABLE
74: , p14_a0 JTF_NUMBER_TABLE

Line 72: , p13_a5 JTF_VARCHAR2_TABLE_100

68: , p13_a1 JTF_NUMBER_TABLE
69: , p13_a2 JTF_VARCHAR2_TABLE_100
70: , p13_a3 JTF_VARCHAR2_TABLE_100
71: , p13_a4 JTF_VARCHAR2_TABLE_300
72: , p13_a5 JTF_VARCHAR2_TABLE_100
73: , p13_a6 JTF_NUMBER_TABLE
74: , p14_a0 JTF_NUMBER_TABLE
75: , p14_a1 JTF_NUMBER_TABLE
76: , p14_a2 JTF_VARCHAR2_TABLE_100

Line 76: , p14_a2 JTF_VARCHAR2_TABLE_100

72: , p13_a5 JTF_VARCHAR2_TABLE_100
73: , p13_a6 JTF_NUMBER_TABLE
74: , p14_a0 JTF_NUMBER_TABLE
75: , p14_a1 JTF_NUMBER_TABLE
76: , p14_a2 JTF_VARCHAR2_TABLE_100
77: , p14_a3 JTF_VARCHAR2_TABLE_100
78: , p14_a4 JTF_NUMBER_TABLE
79: , p15_a0 NUMBER
80: , p15_a1 NUMBER

Line 77: , p14_a3 JTF_VARCHAR2_TABLE_100

73: , p13_a6 JTF_NUMBER_TABLE
74: , p14_a0 JTF_NUMBER_TABLE
75: , p14_a1 JTF_NUMBER_TABLE
76: , p14_a2 JTF_VARCHAR2_TABLE_100
77: , p14_a3 JTF_VARCHAR2_TABLE_100
78: , p14_a4 JTF_NUMBER_TABLE
79: , p15_a0 NUMBER
80: , p15_a1 NUMBER
81: , p15_a2 VARCHAR2

Line 105: , p11_a2 JTF_VARCHAR2_TABLE_100

101: , p_query_desc VARCHAR2
102: , p_query_data_source VARCHAR2
103: , p11_a0 JTF_NUMBER_TABLE
104: , p11_a1 JTF_NUMBER_TABLE
105: , p11_a2 JTF_VARCHAR2_TABLE_100
106: , p11_a3 JTF_VARCHAR2_TABLE_100
107: , p11_a4 JTF_VARCHAR2_TABLE_300
108: , p11_a5 JTF_VARCHAR2_TABLE_100
109: , p11_a6 JTF_NUMBER_TABLE

Line 106: , p11_a3 JTF_VARCHAR2_TABLE_100

102: , p_query_data_source VARCHAR2
103: , p11_a0 JTF_NUMBER_TABLE
104: , p11_a1 JTF_NUMBER_TABLE
105: , p11_a2 JTF_VARCHAR2_TABLE_100
106: , p11_a3 JTF_VARCHAR2_TABLE_100
107: , p11_a4 JTF_VARCHAR2_TABLE_300
108: , p11_a5 JTF_VARCHAR2_TABLE_100
109: , p11_a6 JTF_NUMBER_TABLE
110: , p12_a0 JTF_NUMBER_TABLE

Line 108: , p11_a5 JTF_VARCHAR2_TABLE_100

104: , p11_a1 JTF_NUMBER_TABLE
105: , p11_a2 JTF_VARCHAR2_TABLE_100
106: , p11_a3 JTF_VARCHAR2_TABLE_100
107: , p11_a4 JTF_VARCHAR2_TABLE_300
108: , p11_a5 JTF_VARCHAR2_TABLE_100
109: , p11_a6 JTF_NUMBER_TABLE
110: , p12_a0 JTF_NUMBER_TABLE
111: , p12_a1 JTF_NUMBER_TABLE
112: , p12_a2 JTF_VARCHAR2_TABLE_100

Line 112: , p12_a2 JTF_VARCHAR2_TABLE_100

108: , p11_a5 JTF_VARCHAR2_TABLE_100
109: , p11_a6 JTF_NUMBER_TABLE
110: , p12_a0 JTF_NUMBER_TABLE
111: , p12_a1 JTF_NUMBER_TABLE
112: , p12_a2 JTF_VARCHAR2_TABLE_100
113: , p12_a3 JTF_VARCHAR2_TABLE_100
114: , p12_a4 JTF_NUMBER_TABLE
115: , p13_a0 NUMBER
116: , p13_a1 NUMBER

Line 113: , p12_a3 JTF_VARCHAR2_TABLE_100

109: , p11_a6 JTF_NUMBER_TABLE
110: , p12_a0 JTF_NUMBER_TABLE
111: , p12_a1 JTF_NUMBER_TABLE
112: , p12_a2 JTF_VARCHAR2_TABLE_100
113: , p12_a3 JTF_VARCHAR2_TABLE_100
114: , p12_a4 JTF_NUMBER_TABLE
115: , p13_a0 NUMBER
116: , p13_a1 NUMBER
117: , p13_a2 VARCHAR2

Line 143: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

139: , x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140: , x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
142: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 144: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

140: , x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
142: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 146: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

142: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
150: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 150: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

146: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
150: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p14_a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
153: , p15_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
154: , p15_a1 OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 151: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

147: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
150: , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p14_a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
153: , p15_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
154: , p15_a1 OUT NOCOPY /* file.sql.39 change */ NUMBER
155: , p15_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 176: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

172: , p_query_type VARCHAR2
173: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
175: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
176: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
180: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 177: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

173: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
175: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
176: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
180: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 196: , p10_a2 JTF_VARCHAR2_TABLE_100

192: , p_query_desc VARCHAR2
193: , p_query_data_source VARCHAR2
194: , p10_a0 JTF_NUMBER_TABLE
195: , p10_a1 JTF_NUMBER_TABLE
196: , p10_a2 JTF_VARCHAR2_TABLE_100
197: , p10_a3 JTF_VARCHAR2_TABLE_100
198: , p10_a4 JTF_VARCHAR2_TABLE_300
199: , p10_a5 JTF_VARCHAR2_TABLE_100
200: , p10_a6 JTF_NUMBER_TABLE

Line 197: , p10_a3 JTF_VARCHAR2_TABLE_100

193: , p_query_data_source VARCHAR2
194: , p10_a0 JTF_NUMBER_TABLE
195: , p10_a1 JTF_NUMBER_TABLE
196: , p10_a2 JTF_VARCHAR2_TABLE_100
197: , p10_a3 JTF_VARCHAR2_TABLE_100
198: , p10_a4 JTF_VARCHAR2_TABLE_300
199: , p10_a5 JTF_VARCHAR2_TABLE_100
200: , p10_a6 JTF_NUMBER_TABLE
201: , p11_a0 JTF_NUMBER_TABLE

Line 199: , p10_a5 JTF_VARCHAR2_TABLE_100

195: , p10_a1 JTF_NUMBER_TABLE
196: , p10_a2 JTF_VARCHAR2_TABLE_100
197: , p10_a3 JTF_VARCHAR2_TABLE_100
198: , p10_a4 JTF_VARCHAR2_TABLE_300
199: , p10_a5 JTF_VARCHAR2_TABLE_100
200: , p10_a6 JTF_NUMBER_TABLE
201: , p11_a0 JTF_NUMBER_TABLE
202: , p11_a1 JTF_NUMBER_TABLE
203: , p11_a2 JTF_VARCHAR2_TABLE_100

Line 203: , p11_a2 JTF_VARCHAR2_TABLE_100

199: , p10_a5 JTF_VARCHAR2_TABLE_100
200: , p10_a6 JTF_NUMBER_TABLE
201: , p11_a0 JTF_NUMBER_TABLE
202: , p11_a1 JTF_NUMBER_TABLE
203: , p11_a2 JTF_VARCHAR2_TABLE_100
204: , p11_a3 JTF_VARCHAR2_TABLE_100
205: , p11_a4 JTF_NUMBER_TABLE
206: , p12_a0 NUMBER
207: , p12_a1 NUMBER

Line 204: , p11_a3 JTF_VARCHAR2_TABLE_100

200: , p10_a6 JTF_NUMBER_TABLE
201: , p11_a0 JTF_NUMBER_TABLE
202: , p11_a1 JTF_NUMBER_TABLE
203: , p11_a2 JTF_VARCHAR2_TABLE_100
204: , p11_a3 JTF_VARCHAR2_TABLE_100
205: , p11_a4 JTF_NUMBER_TABLE
206: , p12_a0 NUMBER
207: , p12_a1 NUMBER
208: , p12_a2 VARCHAR2