DBA Data[Home] [Help]

APPS.JTF_PERZ_QUERY_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 7: , a4 JTF_VARCHAR2_TABLE_300

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

Line 15: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 25: , a5 JTF_VARCHAR2_TABLE_300

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
29: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 33: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 71: , p13_a4 JTF_VARCHAR2_TABLE_300

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
75: , p14_a1 JTF_NUMBER_TABLE

Line 107: , p11_a4 JTF_VARCHAR2_TABLE_300

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
111: , p12_a1 JTF_NUMBER_TABLE

Line 145: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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
149: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 178: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

Line 198: , p10_a4 JTF_VARCHAR2_TABLE_300

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
202: , p11_a1 JTF_NUMBER_TABLE