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
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
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
13: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
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
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
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
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_200
22: , a4 JTF_VARCHAR2_TABLE_100
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
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_200
22: , a4 JTF_VARCHAR2_TABLE_100
23: , a5 JTF_VARCHAR2_TABLE_300
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
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_VARCHAR2_TABLE_200
22: , a4 JTF_VARCHAR2_TABLE_100
23: , a5 JTF_VARCHAR2_TABLE_300
24: );
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
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
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
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
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
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: );
36: , p_application_id NUMBER
37: , p_profile_id NUMBER
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
37: , p_profile_id NUMBER
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
45: , p_perz_data_id NUMBER
46: , p_perz_data_name VARCHAR2
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
46: , p_perz_data_name VARCHAR2
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
66: , p_perz_data_id NUMBER
67: , p_perz_data_name VARCHAR2
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
67: , p_perz_data_name VARCHAR2
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
89: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
90: , x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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
90: , x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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
107: , p_profile_name VARCHAR2
108: , p_perz_data_id NUMBER
109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
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
108: , p_perz_data_id NUMBER
109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
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
109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
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
126: , p_perz_data_id NUMBER
127: , p_perz_data_name VARCHAR2
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
127: , p_perz_data_name VARCHAR2
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