1: package jtf_perz_ddf_pub_w as
2: /* $Header: jtfzwdds.pls 120.2 2005/11/02 23:00:47 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package jtf_perz_ddf_pub_w as
2: /* $Header: jtfzwdds.pls 120.2 2005/11/02 23:00:47 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: jtfzwdds.pls 120.2 2005/11/02 23:00:47 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
15: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
16: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
15: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
16: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
15: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
16: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
19: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
15: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
16: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
19: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
20: );
21:
25: , p_application_id NUMBER
26: , p_profile_id NUMBER
27: , p_profile_name VARCHAR2
28: , p_profile_type VARCHAR2
29: , p7_a0 JTF_NUMBER_TABLE
30: , p7_a1 JTF_NUMBER_TABLE
31: , p7_a2 JTF_VARCHAR2_TABLE_100
32: , p7_a3 JTF_VARCHAR2_TABLE_100
33: , p7_a4 JTF_VARCHAR2_TABLE_100
26: , p_profile_id NUMBER
27: , p_profile_name VARCHAR2
28: , p_profile_type VARCHAR2
29: , p7_a0 JTF_NUMBER_TABLE
30: , p7_a1 JTF_NUMBER_TABLE
31: , p7_a2 JTF_VARCHAR2_TABLE_100
32: , p7_a3 JTF_VARCHAR2_TABLE_100
33: , p7_a4 JTF_VARCHAR2_TABLE_100
34: , p_perz_ddf_id NUMBER
52: , p_gui_object_name VARCHAR2
53: , p_gui_object_id NUMBER
54: , p_ddf_value VARCHAR2
55: , p_ddf_value_type VARCHAR2
56: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
57: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
58: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
54: , p_ddf_value VARCHAR2
55: , p_ddf_value_type VARCHAR2
56: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
57: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
58: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
61: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
62: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
55: , p_ddf_value_type VARCHAR2
56: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
57: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
58: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
61: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
62: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
63: , p11_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
58: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
61: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
62: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
63: , p11_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
64: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER