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_DATA_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package jtf_perz_data_pub_w as
2: /* $Header: jtfzwpds.pls 120.2 2005/11/02 23:48:00 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_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: );

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: jtfzwpds.pls 120.2 2005/11/02 23:48:00 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_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: );
10: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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: );
10: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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

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

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

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

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

Line 22: , a4 JTF_VARCHAR2_TABLE_100

18: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_out_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_200
22: , a4 JTF_VARCHAR2_TABLE_100
23: , a5 JTF_VARCHAR2_TABLE_300
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

25: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
31: );
32:
33: procedure save_perz_data(p_api_version_number NUMBER

Line 42: , p7_a2 JTF_VARCHAR2_TABLE_100

38: , p_profile_name VARCHAR2
39: , p_profile_type VARCHAR2
40: , p7_a0 JTF_NUMBER_TABLE
41: , p7_a1 JTF_NUMBER_TABLE
42: , p7_a2 JTF_VARCHAR2_TABLE_100
43: , p7_a3 JTF_VARCHAR2_TABLE_100
44: , p7_a4 JTF_VARCHAR2_TABLE_100
45: , p_perz_data_id NUMBER
46: , p_perz_data_name VARCHAR2

Line 43: , p7_a3 JTF_VARCHAR2_TABLE_100

39: , p_profile_type VARCHAR2
40: , p7_a0 JTF_NUMBER_TABLE
41: , p7_a1 JTF_NUMBER_TABLE
42: , p7_a2 JTF_VARCHAR2_TABLE_100
43: , p7_a3 JTF_VARCHAR2_TABLE_100
44: , p7_a4 JTF_VARCHAR2_TABLE_100
45: , p_perz_data_id NUMBER
46: , p_perz_data_name VARCHAR2
47: , p_perz_data_type VARCHAR2

Line 44: , p7_a4 JTF_VARCHAR2_TABLE_100

40: , p7_a0 JTF_NUMBER_TABLE
41: , p7_a1 JTF_NUMBER_TABLE
42: , p7_a2 JTF_VARCHAR2_TABLE_100
43: , p7_a3 JTF_VARCHAR2_TABLE_100
44: , p7_a4 JTF_VARCHAR2_TABLE_100
45: , p_perz_data_id NUMBER
46: , p_perz_data_name VARCHAR2
47: , p_perz_data_type VARCHAR2
48: , p_perz_data_desc VARCHAR2

Line 51: , p12_a2 JTF_VARCHAR2_TABLE_100

47: , p_perz_data_type VARCHAR2
48: , p_perz_data_desc VARCHAR2
49: , p12_a0 JTF_NUMBER_TABLE
50: , p12_a1 JTF_NUMBER_TABLE
51: , p12_a2 JTF_VARCHAR2_TABLE_100
52: , p12_a3 JTF_VARCHAR2_TABLE_100
53: , p12_a4 JTF_VARCHAR2_TABLE_300
54: , p12_a5 JTF_VARCHAR2_TABLE_100
55: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 52: , p12_a3 JTF_VARCHAR2_TABLE_100

48: , p_perz_data_desc VARCHAR2
49: , p12_a0 JTF_NUMBER_TABLE
50: , p12_a1 JTF_NUMBER_TABLE
51: , p12_a2 JTF_VARCHAR2_TABLE_100
52: , p12_a3 JTF_VARCHAR2_TABLE_100
53: , p12_a4 JTF_VARCHAR2_TABLE_300
54: , p12_a5 JTF_VARCHAR2_TABLE_100
55: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
56: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 54: , p12_a5 JTF_VARCHAR2_TABLE_100

50: , p12_a1 JTF_NUMBER_TABLE
51: , p12_a2 JTF_VARCHAR2_TABLE_100
52: , p12_a3 JTF_VARCHAR2_TABLE_100
53: , p12_a4 JTF_VARCHAR2_TABLE_300
54: , p12_a5 JTF_VARCHAR2_TABLE_100
55: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
56: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
58: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 72: , p10_a2 JTF_VARCHAR2_TABLE_100

68: , p_perz_data_type VARCHAR2
69: , p_perz_data_desc VARCHAR2
70: , p10_a0 JTF_NUMBER_TABLE
71: , p10_a1 JTF_NUMBER_TABLE
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , p10_a3 JTF_VARCHAR2_TABLE_100
74: , p10_a4 JTF_VARCHAR2_TABLE_300
75: , p10_a5 JTF_VARCHAR2_TABLE_100
76: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 73: , p10_a3 JTF_VARCHAR2_TABLE_100

69: , p_perz_data_desc VARCHAR2
70: , p10_a0 JTF_NUMBER_TABLE
71: , p10_a1 JTF_NUMBER_TABLE
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , p10_a3 JTF_VARCHAR2_TABLE_100
74: , p10_a4 JTF_VARCHAR2_TABLE_300
75: , p10_a5 JTF_VARCHAR2_TABLE_100
76: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
77: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 75: , p10_a5 JTF_VARCHAR2_TABLE_100

71: , p10_a1 JTF_NUMBER_TABLE
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , p10_a3 JTF_VARCHAR2_TABLE_100
74: , p10_a4 JTF_VARCHAR2_TABLE_300
75: , p10_a5 JTF_VARCHAR2_TABLE_100
76: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
77: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
79: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

91: , x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
97: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
98: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
99: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

92: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
97: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
98: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
99: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 98: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
97: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
98: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
99: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
101: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: );

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

111: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
112: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
113: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
115: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
116: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
117: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
119: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 132: , p9_a2 JTF_VARCHAR2_TABLE_100

128: , p_perz_data_type VARCHAR2
129: , p_perz_data_desc VARCHAR2
130: , p9_a0 JTF_NUMBER_TABLE
131: , p9_a1 JTF_NUMBER_TABLE
132: , p9_a2 JTF_VARCHAR2_TABLE_100
133: , p9_a3 JTF_VARCHAR2_TABLE_100
134: , p9_a4 JTF_VARCHAR2_TABLE_300
135: , p9_a5 JTF_VARCHAR2_TABLE_100
136: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 133: , p9_a3 JTF_VARCHAR2_TABLE_100

129: , p_perz_data_desc VARCHAR2
130: , p9_a0 JTF_NUMBER_TABLE
131: , p9_a1 JTF_NUMBER_TABLE
132: , p9_a2 JTF_VARCHAR2_TABLE_100
133: , p9_a3 JTF_VARCHAR2_TABLE_100
134: , p9_a4 JTF_VARCHAR2_TABLE_300
135: , p9_a5 JTF_VARCHAR2_TABLE_100
136: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
137: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 135: , p9_a5 JTF_VARCHAR2_TABLE_100

131: , p9_a1 JTF_NUMBER_TABLE
132: , p9_a2 JTF_VARCHAR2_TABLE_100
133: , p9_a3 JTF_VARCHAR2_TABLE_100
134: , p9_a4 JTF_VARCHAR2_TABLE_300
135: , p9_a5 JTF_VARCHAR2_TABLE_100
136: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
137: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
139: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2