[Home] [Help]
Skip to content
PACKAGE: APPS.JTF_PERZ_LF_PUB_W
Source
1 package jtf_perz_lf_pub_w AUTHID CURRENT_USER as
2 /* $Header: jtfzwlfs.pls 120.2 2005/11/02 23:01:20 skothe ship $ */
3 procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 );
7 procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10 );
11
12 procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
13 , a1 JTF_VARCHAR2_TABLE_100
14 , a2 JTF_VARCHAR2_TABLE_100
15 , a3 JTF_VARCHAR2_TABLE_100
16 , a4 JTF_NUMBER_TABLE
17 );
18 procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
19 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
20 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
21 , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
22 , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
23 );
24
25 procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE
26 , a1 JTF_NUMBER_TABLE
27 , a2 JTF_NUMBER_TABLE
28 , a3 JTF_VARCHAR2_TABLE_100
29 , a4 JTF_VARCHAR2_TABLE_300
30 , a5 JTF_NUMBER_TABLE
31 , a6 JTF_VARCHAR2_TABLE_100
32 , a7 JTF_NUMBER_TABLE
33 , a8 JTF_VARCHAR2_TABLE_100
34 , a9 JTF_VARCHAR2_TABLE_100
35 , a10 JTF_VARCHAR2_TABLE_100
36 , a11 JTF_VARCHAR2_TABLE_100
37 , a12 JTF_NUMBER_TABLE
38 );
39 procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
40 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
41 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
42 , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
43 , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
44 , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45 , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46 , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47 , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48 , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49 , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50 , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51 , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52 );
53
54 procedure save_lf_object(p_api_version_number NUMBER
55 , p_init_msg_list VARCHAR2
56 , p_commit VARCHAR2
57 , p_profile_id NUMBER
58 , p_profile_name VARCHAR2
59 , p_profile_type VARCHAR2
60 , p6_a0 JTF_NUMBER_TABLE
61 , p6_a1 JTF_NUMBER_TABLE
62 , p6_a2 JTF_VARCHAR2_TABLE_100
63 , p6_a3 JTF_VARCHAR2_TABLE_100
64 , p6_a4 JTF_VARCHAR2_TABLE_100
65 , p_application_id NUMBER
66 , p_parent_id NUMBER
67 , p_object_type_id NUMBER
68 , p_object_type VARCHAR2
69 , p_object_id NUMBER
70 , p_object_name VARCHAR2
71 , p_object_description VARCHAR2
72 , p_active_flag VARCHAR2
73 , p15_a0 JTF_NUMBER_TABLE
74 , p15_a1 JTF_VARCHAR2_TABLE_100
75 , p15_a2 JTF_VARCHAR2_TABLE_100
76 , p15_a3 JTF_VARCHAR2_TABLE_100
77 , p15_a4 JTF_NUMBER_TABLE
78 , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
79 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
81 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 );
83 procedure save_lf_object_type(p_api_version_number NUMBER
84 , p_init_msg_list VARCHAR2
85 , p_commit VARCHAR2
86 , p_object_type_id NUMBER
87 , p_object_type VARCHAR2
88 , p_object_type_desc VARCHAR2
89 , p6_a0 JTF_NUMBER_TABLE
90 , p6_a1 JTF_VARCHAR2_TABLE_100
91 , p6_a2 JTF_VARCHAR2_TABLE_100
92 , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
93 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
95 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 );
97 procedure create_lf_object(p_api_version_number NUMBER
98 , p_init_msg_list VARCHAR2
99 , p_commit VARCHAR2
100 , p_profile_id NUMBER
101 , p_profile_name VARCHAR2
102 , p_application_id NUMBER
103 , p_parent_id NUMBER
104 , p_object_id NUMBER
105 , p_object_name VARCHAR2
106 , p_object_type_id NUMBER
107 , p_object_type VARCHAR2
108 , p11_a0 JTF_NUMBER_TABLE
109 , p11_a1 JTF_VARCHAR2_TABLE_100
110 , p11_a2 JTF_VARCHAR2_TABLE_100
111 , p11_a3 JTF_VARCHAR2_TABLE_100
112 , p11_a4 JTF_NUMBER_TABLE
113 , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
114 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
116 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 );
118 procedure get_lf_object_type(p_api_version_number NUMBER
119 , p_init_msg_list VARCHAR2
120 , p_object_type VARCHAR
121 , p_object_type_id NUMBER
122 , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
123 , x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
125 , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
126 , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
129 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 );
131 procedure get_lf_object(p_api_version_number NUMBER
132 , p_init_msg_list VARCHAR2
133 , p_application_id NUMBER
134 , p_priority NUMBER
135 , p_profile_id NUMBER
136 , p_profile_name VARCHAR2
137 , p_object_id NUMBER
138 , p_object_name VARCHAR
139 , p_obj_active_flag VARCHAR2
140 , p_get_children_flag VARCHAR2
141 , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
142 , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143 , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
144 , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145 , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146 , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147 , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148 , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149 , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150 , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151 , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152 , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153 , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
154 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
156 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 );
158 procedure update_lf_object(p_api_version_number NUMBER
159 , p_init_msg_list VARCHAR2
160 , p_commit VARCHAR2
161 , p_profile_id NUMBER
162 , p_profile_name VARCHAR2
163 , p_application_id NUMBER
164 , p_parent_id NUMBER
165 , p_object_id NUMBER
166 , p_object_name VARCHAR2
167 , p_active_flag VARCHAR2
168 , p_object_type_id NUMBER
169 , p_object_type VARCHAR2
170 , p12_a0 JTF_NUMBER_TABLE
171 , p12_a1 JTF_VARCHAR2_TABLE_100
172 , p12_a2 JTF_VARCHAR2_TABLE_100
173 , p12_a3 JTF_VARCHAR2_TABLE_100
174 , p12_a4 JTF_NUMBER_TABLE
175 , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
176 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
178 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 );
180 end jtf_perz_lf_pub_w;