[Home] [Help]
PACKAGE: APPS.JTF_PERZ_DATA_PUB_W
Source
1 package jtf_perz_data_pub_w AUTHID CURRENT_USER 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 );
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
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
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
34 , p_init_msg_list VARCHAR2
35 , p_commit VARCHAR
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
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
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
59 );
60 procedure create_perz_data(p_api_version_number NUMBER
61 , p_init_msg_list VARCHAR2
62 , p_commit VARCHAR
63 , p_application_id NUMBER
64 , p_profile_id NUMBER
65 , p_profile_name VARCHAR2
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
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
80 );
81 procedure get_perz_data(p_api_version_number NUMBER
82 , p_init_msg_list VARCHAR2
83 , p_application_id NUMBER
84 , p_profile_id NUMBER
85 , p_profile_name VARCHAR2
86 , p_perz_data_id NUMBER
87 , p_perz_data_name VARCHAR2
88 , p_perz_data_type VARCHAR2
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
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 );
103 procedure get_perz_data_summary(p_api_version_number NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_application_id NUMBER
106 , p_profile_id NUMBER
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
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
120 );
121 procedure update_perz_data(p_api_version_number NUMBER
122 , p_init_msg_list VARCHAR2
123 , p_commit VARCHAR
124 , p_application_id NUMBER
125 , p_profile_id NUMBER
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
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
140 );
141 end jtf_perz_data_pub_w;