APPS.JTF_PERZ_QUERY_PUB_W dependencies on JTF_NUMBER_TABLE

Line 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

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 9: , a6 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
13: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 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

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

Line 12: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 17: , a6 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
21: , a1 JTF_NUMBER_TABLE

Line 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

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
21: , a1 JTF_NUMBER_TABLE
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_VARCHAR2_TABLE_100
24: , a4 JTF_VARCHAR2_TABLE_100

Line 21: , a1 JTF_NUMBER_TABLE

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

Line 22: , a2 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
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

Line 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

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

Line 29: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 30: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 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

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

Line 38: , a1 JTF_NUMBER_TABLE

34: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
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: );

Line 41: , a4 JTF_NUMBER_TABLE

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
45: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 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

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

Line 44: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 47: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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
51: , p_init_msg_list VARCHAR2

Line 57: , p7_a0 JTF_NUMBER_TABLE

53: , p_application_id NUMBER
54: , p_profile_id NUMBER
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

Line 58: , p7_a1 JTF_NUMBER_TABLE

54: , p_profile_id NUMBER
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

Line 67: , p13_a0 JTF_NUMBER_TABLE

63: , p_query_name VARCHAR2
64: , p_query_type VARCHAR2
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

Line 68: , p13_a1 JTF_NUMBER_TABLE

64: , p_query_type VARCHAR2
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

Line 73: , p13_a6 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
77: , p14_a3 JTF_VARCHAR2_TABLE_100

Line 74: , p14_a0 JTF_NUMBER_TABLE

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
77: , p14_a3 JTF_VARCHAR2_TABLE_100
78: , p14_a4 JTF_NUMBER_TABLE

Line 75: , p14_a1 JTF_NUMBER_TABLE

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
77: , p14_a3 JTF_VARCHAR2_TABLE_100
78: , p14_a4 JTF_NUMBER_TABLE
79: , p15_a0 NUMBER

Line 78: , p14_a4 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
82: , p15_a3 VARCHAR2

Line 103: , p11_a0 JTF_NUMBER_TABLE

99: , p_query_name VARCHAR2
100: , p_query_type VARCHAR2
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

Line 104: , p11_a1 JTF_NUMBER_TABLE

100: , p_query_type VARCHAR2
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

Line 109: , p11_a6 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
113: , p12_a3 JTF_VARCHAR2_TABLE_100

Line 110: , p12_a0 JTF_NUMBER_TABLE

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
113: , p12_a3 JTF_VARCHAR2_TABLE_100
114: , p12_a4 JTF_NUMBER_TABLE

Line 111: , p12_a1 JTF_NUMBER_TABLE

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
113: , p12_a3 JTF_VARCHAR2_TABLE_100
114: , p12_a4 JTF_NUMBER_TABLE
115: , p13_a0 NUMBER

Line 114: , p12_a4 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
118: , p13_a3 VARCHAR2

Line 141: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

137: , x_query_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138: , x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 142: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

138: , x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 147: , p13_a6 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
151: , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 148: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 149: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 152: , p14_a4 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
156: , p15_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 173: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

169: , p_profile_name VARCHAR2
170: , p_query_id NUMBER
171: , p_query_name VARCHAR2
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

Line 174: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

170: , p_query_id NUMBER
171: , p_query_name VARCHAR2
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

Line 175: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

171: , p_query_name VARCHAR2
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

Line 194: , p10_a0 JTF_NUMBER_TABLE

190: , p_query_name VARCHAR2
191: , p_query_type VARCHAR2
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

Line 195: , p10_a1 JTF_NUMBER_TABLE

191: , p_query_type VARCHAR2
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

Line 200: , p10_a6 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
204: , p11_a3 JTF_VARCHAR2_TABLE_100

Line 201: , p11_a0 JTF_NUMBER_TABLE

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
204: , p11_a3 JTF_VARCHAR2_TABLE_100
205: , p11_a4 JTF_NUMBER_TABLE

Line 202: , p11_a1 JTF_NUMBER_TABLE

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
204: , p11_a3 JTF_VARCHAR2_TABLE_100
205: , p11_a4 JTF_NUMBER_TABLE
206: , p12_a0 NUMBER

Line 205: , p11_a4 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
209: , p12_a3 VARCHAR2