eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_QUERY_PUB_W dependencies on JTF_PERZ_QUERY_PUB

Line 1: package jtf_perz_query_pub_w AUTHID CURRENT_USER as

1: package jtf_perz_query_pub_w AUTHID CURRENT_USER 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

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 AUTHID CURRENT_USER 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 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 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 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 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 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 219: end jtf_perz_query_pub_w;

215: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
216: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
217: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218: );
219: end jtf_perz_query_pub_w;