[Home] [Help]
PACKAGE: APPS.HZ_CLASSIFICATION_V2PUB_JW
Source
1 package hz_classification_v2pub_jw as
2 /* $Header: ARH2CLJS.pls 120.3 2005/06/18 04:27:28 jhuang noship $ */
3 procedure create_class_category_1(p_init_msg_list VARCHAR2
4 , x_return_status out nocopy VARCHAR2
5 , x_msg_count out nocopy NUMBER
6 , x_msg_data out nocopy VARCHAR2
7 , p1_a0 VARCHAR2 := null
8 , p1_a1 VARCHAR2 := null
9 , p1_a2 VARCHAR2 := null
10 , p1_a3 VARCHAR2 := null
11 , p1_a4 VARCHAR2 := null
12 , p1_a5 NUMBER := null
13 , p1_a6 VARCHAR2 := null
14 );
15 procedure update_class_category_2(p_init_msg_list VARCHAR2
16 , p_object_version_number in out nocopy NUMBER
17 , x_return_status out nocopy VARCHAR2
18 , x_msg_count out nocopy NUMBER
19 , x_msg_data out nocopy VARCHAR2
20 , p1_a0 VARCHAR2 := null
21 , p1_a1 VARCHAR2 := null
22 , p1_a2 VARCHAR2 := null
23 , p1_a3 VARCHAR2 := null
24 , p1_a4 VARCHAR2 := null
25 , p1_a5 NUMBER := null
26 , p1_a6 VARCHAR2 := null
27 );
28 procedure get_class_category_rec_3(p_init_msg_list VARCHAR2
29 , p_class_category VARCHAR2
30 , p2_a0 out nocopy VARCHAR2
31 , p2_a1 out nocopy VARCHAR2
32 , p2_a2 out nocopy VARCHAR2
33 , p2_a3 out nocopy VARCHAR2
34 , p2_a4 out nocopy VARCHAR2
35 , p2_a5 out nocopy NUMBER
36 , p2_a6 out nocopy VARCHAR2
37 , x_return_status out nocopy VARCHAR2
38 , x_msg_count out nocopy NUMBER
39 , x_msg_data out nocopy VARCHAR2
40 );
41 procedure create_class_code_relation_4(p_init_msg_list VARCHAR2
42 , x_return_status out nocopy VARCHAR2
43 , x_msg_count out nocopy NUMBER
44 , x_msg_data out nocopy VARCHAR2
45 , p1_a0 VARCHAR2 := null
46 , p1_a1 VARCHAR2 := null
47 , p1_a2 VARCHAR2 := null
48 , p1_a3 DATE := null
49 , p1_a4 DATE := null
50 , p1_a5 VARCHAR2 := null
51 , p1_a6 NUMBER := null
52 );
53 procedure update_class_code_relation_5(p_init_msg_list VARCHAR2
54 , p_object_version_number in out nocopy NUMBER
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 , p1_a0 VARCHAR2 := null
59 , p1_a1 VARCHAR2 := null
60 , p1_a2 VARCHAR2 := null
61 , p1_a3 DATE := null
62 , p1_a4 DATE := null
63 , p1_a5 VARCHAR2 := null
64 , p1_a6 NUMBER := null
65 );
66 procedure get_class_code_relation_rec_6(p_init_msg_list VARCHAR2
67 , p_class_category VARCHAR2
68 , p_class_code VARCHAR2
69 , p_sub_class_code VARCHAR2
70 , p_start_date_active date
71 , p5_a0 out nocopy VARCHAR2
72 , p5_a1 out nocopy VARCHAR2
73 , p5_a2 out nocopy VARCHAR2
74 , p5_a3 out nocopy DATE
75 , p5_a4 out nocopy DATE
76 , p5_a5 out nocopy VARCHAR2
77 , p5_a6 out nocopy NUMBER
78 , x_return_status out nocopy VARCHAR2
79 , x_msg_count out nocopy NUMBER
80 , x_msg_data out nocopy VARCHAR2
81 );
82 procedure create_code_assignment_7(p_init_msg_list VARCHAR2
83 , x_return_status out nocopy VARCHAR2
84 , x_msg_count out nocopy NUMBER
85 , x_msg_data out nocopy VARCHAR2
86 , x_code_assignment_id out nocopy NUMBER
87 , p1_a0 NUMBER := null
88 , p1_a1 VARCHAR2 := null
89 , p1_a2 NUMBER := null
90 , p1_a3 VARCHAR2 := null
91 , p1_a4 VARCHAR2 := null
92 , p1_a5 VARCHAR2 := null
93 , p1_a6 VARCHAR2 := null
94 , p1_a7 VARCHAR2 := null
95 , p1_a8 VARCHAR2 := null
96 , p1_a9 VARCHAR2 := null
97 , p1_a10 VARCHAR2 := null
98 , p1_a11 VARCHAR2 := null
99 , p1_a12 DATE := null
100 , p1_a13 DATE := null
101 , p1_a14 VARCHAR2 := null
102 , p1_a15 VARCHAR2 := null
103 , p1_a16 NUMBER := null
104 , p1_a17 NUMBER := null
105 , p1_a18 VARCHAR2 := null
106 );
107 procedure update_code_assignment_8(p_init_msg_list VARCHAR2
108 , p_object_version_number in out nocopy NUMBER
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 , p1_a0 NUMBER := null
113 , p1_a1 VARCHAR2 := null
114 , p1_a2 NUMBER := null
115 , p1_a3 VARCHAR2 := null
116 , p1_a4 VARCHAR2 := null
117 , p1_a5 VARCHAR2 := null
118 , p1_a6 VARCHAR2 := null
119 , p1_a7 VARCHAR2 := null
120 , p1_a8 VARCHAR2 := null
121 , p1_a9 VARCHAR2 := null
122 , p1_a10 VARCHAR2 := null
123 , p1_a11 VARCHAR2 := null
124 , p1_a12 DATE := null
125 , p1_a13 DATE := null
126 , p1_a14 VARCHAR2 := null
127 , p1_a15 VARCHAR2 := null
128 , p1_a16 NUMBER := null
129 , p1_a17 NUMBER := null
130 , p1_a18 VARCHAR2 := null
131 );
132 procedure get_code_assignment_rec_9(p_init_msg_list VARCHAR2
133 , p_code_assignment_id NUMBER
134 , p2_a0 out nocopy NUMBER
135 , p2_a1 out nocopy VARCHAR2
136 , p2_a2 out nocopy NUMBER
137 , p2_a3 out nocopy VARCHAR2
138 , p2_a4 out nocopy VARCHAR2
139 , p2_a5 out nocopy VARCHAR2
140 , p2_a6 out nocopy VARCHAR2
141 , p2_a7 out nocopy VARCHAR2
142 , p2_a8 out nocopy VARCHAR2
143 , p2_a9 out nocopy VARCHAR2
144 , p2_a10 out nocopy VARCHAR2
145 , p2_a11 out nocopy VARCHAR2
146 , p2_a12 out nocopy DATE
147 , p2_a13 out nocopy DATE
148 , p2_a14 out nocopy VARCHAR2
149 , p2_a15 out nocopy VARCHAR2
150 , p2_a16 out nocopy NUMBER
151 , p2_a17 out nocopy NUMBER
152 , p2_a18 out nocopy VARCHAR2
153 , x_return_status out nocopy VARCHAR2
154 , x_msg_count out nocopy NUMBER
155 , x_msg_data out nocopy VARCHAR2
156 );
157 procedure create_class_category_use_10(p_init_msg_list VARCHAR2
158 , x_return_status out nocopy VARCHAR2
159 , x_msg_count out nocopy NUMBER
160 , x_msg_data out nocopy VARCHAR2
161 , p1_a0 VARCHAR2 := null
162 , p1_a1 VARCHAR2 := null
163 , p1_a2 VARCHAR2 := null
164 , p1_a3 VARCHAR2 := null
165 , p1_a4 VARCHAR2 := null
166 , p1_a5 NUMBER := null
167 );
168 procedure update_class_category_use_11(p_init_msg_list VARCHAR2
169 , p_object_version_number in out nocopy NUMBER
170 , x_return_status out nocopy VARCHAR2
171 , x_msg_count out nocopy NUMBER
172 , x_msg_data out nocopy VARCHAR2
173 , p1_a0 VARCHAR2 := null
174 , p1_a1 VARCHAR2 := null
175 , p1_a2 VARCHAR2 := null
176 , p1_a3 VARCHAR2 := null
177 , p1_a4 VARCHAR2 := null
178 , p1_a5 NUMBER := null
179 );
180 procedure get_class_category_use_rec_12(p_init_msg_list VARCHAR2
181 , p_class_category VARCHAR2
182 , p_owner_table VARCHAR2
183 , p3_a0 out nocopy VARCHAR2
184 , p3_a1 out nocopy VARCHAR2
185 , p3_a2 out nocopy VARCHAR2
186 , p3_a3 out nocopy VARCHAR2
187 , p3_a4 out nocopy VARCHAR2
188 , p3_a5 out nocopy NUMBER
189 , x_return_status out nocopy VARCHAR2
190 , x_msg_count out nocopy NUMBER
191 , x_msg_data out nocopy VARCHAR2
192 );
193 procedure create_class_code_13(p_init_msg_list VARCHAR2
194 , x_return_status out nocopy VARCHAR2
195 , x_msg_count out nocopy NUMBER
196 , x_msg_data out nocopy VARCHAR2
197 , p1_a0 VARCHAR2 := null
198 , p1_a1 VARCHAR2 := null
199 , p1_a2 VARCHAR2 := null
200 , p1_a3 VARCHAR2 := null
201 , p1_a4 DATE := null
202 , p1_a5 DATE := null
203 , p1_a6 VARCHAR2 := null
204 );
205 procedure update_class_code_14(p_init_msg_list VARCHAR2
206 , p_object_version_number in out nocopy NUMBER
207 , x_return_status out nocopy VARCHAR2
208 , x_msg_count out nocopy NUMBER
209 , x_msg_data out nocopy VARCHAR2
210 , p1_a0 VARCHAR2 := null
211 , p1_a1 VARCHAR2 := null
212 , p1_a2 VARCHAR2 := null
213 , p1_a3 VARCHAR2 := null
214 , p1_a4 DATE := null
215 , p1_a5 DATE := null
216 , p1_a6 VARCHAR2 := null
217 );
218 end hz_classification_v2pub_jw;