1: package jtf_perz_profile_pub_w as
2: /* $Header: jtfzwpfs.pls 120.2 2005/11/02 23:48:15 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_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_100
1: package jtf_perz_profile_pub_w as
2: /* $Header: jtfzwpfs.pls 120.2 2005/11/02 23:48:15 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_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_100
8: );
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
38: , p_profile_id NUMBER
39: , p_profile_name VARCHAR2
40: , p_profile_type VARCHAR2
41: , p_profile_desc VARCHAR2
42: , p7_a0 JTF_NUMBER_TABLE
43: , p7_a1 JTF_NUMBER_TABLE
44: , p7_a2 JTF_VARCHAR2_TABLE_100
45: , p7_a3 JTF_VARCHAR2_TABLE_100
46: , p7_a4 JTF_VARCHAR2_TABLE_100
39: , p_profile_name VARCHAR2
40: , p_profile_type VARCHAR2
41: , p_profile_desc VARCHAR2
42: , p7_a0 JTF_NUMBER_TABLE
43: , p7_a1 JTF_NUMBER_TABLE
44: , p7_a2 JTF_VARCHAR2_TABLE_100
45: , p7_a3 JTF_VARCHAR2_TABLE_100
46: , p7_a4 JTF_VARCHAR2_TABLE_100
47: , x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54: , p_init_msg_list VARCHAR2
55: , p_profile_id NUMBER
56: , p_profile_name VARCHAR2
57: , p_profile_type VARCHAR2
58: , p5_a0 JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
55: , p_profile_id NUMBER
56: , p_profile_name VARCHAR2
57: , p_profile_type VARCHAR2
58: , p5_a0 JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
63: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
63: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
64: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
65: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
79: , p_profile_name VARCHAR2
80: , p_profile_type VARCHAR2
81: , p_profile_desc VARCHAR2
82: , p_active_flag VARCHAR2
83: , p8_a0 JTF_NUMBER_TABLE
84: , p8_a1 JTF_NUMBER_TABLE
85: , p8_a2 JTF_VARCHAR2_TABLE_100
86: , p8_a3 JTF_VARCHAR2_TABLE_100
87: , p8_a4 JTF_VARCHAR2_TABLE_100
80: , p_profile_type VARCHAR2
81: , p_profile_desc VARCHAR2
82: , p_active_flag VARCHAR2
83: , p8_a0 JTF_NUMBER_TABLE
84: , p8_a1 JTF_NUMBER_TABLE
85: , p8_a2 JTF_VARCHAR2_TABLE_100
86: , p8_a3 JTF_VARCHAR2_TABLE_100
87: , p8_a4 JTF_VARCHAR2_TABLE_100
88: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER