[Home] [Help]
PACKAGE: APPS.CN_REASONS_PUB_W
Source
1 package cn_reasons_pub_w AUTHID CURRENT_USER as
2 /* $Header: cnwresns.pls 115.3 2003/07/04 01:43:11 jjhuang ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_4000
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_NUMBER_TABLE
33 );
34 procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
35 , a1 out nocopy JTF_NUMBER_TABLE
36 , a2 out nocopy JTF_VARCHAR2_TABLE_100
37 , a3 out nocopy JTF_NUMBER_TABLE
38 , a4 out nocopy JTF_VARCHAR2_TABLE_4000
39 , a5 out nocopy JTF_VARCHAR2_TABLE_100
40 , a6 out nocopy JTF_VARCHAR2_TABLE_100
41 , a7 out nocopy JTF_VARCHAR2_TABLE_100
42 , a8 out nocopy JTF_VARCHAR2_TABLE_100
43 , a9 out nocopy JTF_VARCHAR2_TABLE_100
44 , a10 out nocopy JTF_VARCHAR2_TABLE_100
45 , a11 out nocopy JTF_VARCHAR2_TABLE_100
46 , a12 out nocopy JTF_VARCHAR2_TABLE_100
47 , a13 out nocopy JTF_VARCHAR2_TABLE_100
48 , a14 out nocopy JTF_VARCHAR2_TABLE_100
49 , a15 out nocopy JTF_VARCHAR2_TABLE_100
50 , a16 out nocopy JTF_VARCHAR2_TABLE_100
51 , a17 out nocopy JTF_VARCHAR2_TABLE_100
52 , a18 out nocopy JTF_VARCHAR2_TABLE_100
53 , a19 out nocopy JTF_VARCHAR2_TABLE_100
54 , a20 out nocopy JTF_VARCHAR2_TABLE_100
55 , a21 out nocopy JTF_VARCHAR2_TABLE_100
56 , a22 out nocopy JTF_VARCHAR2_TABLE_100
57 , a23 out nocopy JTF_VARCHAR2_TABLE_100
58 , a24 out nocopy JTF_VARCHAR2_TABLE_100
59 , a25 out nocopy JTF_VARCHAR2_TABLE_100
60 , a26 out nocopy JTF_DATE_TABLE
61 , a27 out nocopy JTF_NUMBER_TABLE
62 , a28 out nocopy JTF_VARCHAR2_TABLE_100
63 , a29 out nocopy JTF_NUMBER_TABLE
64 );
65
66 procedure show_analyst_notes(p_api_version NUMBER
67 , p_init_msg_list VARCHAR2
68 , p_validation_level VARCHAR2
69 , p_commit VARCHAR2
70 , p_first NUMBER
71 , p_last NUMBER
72 , p_payment_worksheet_id NUMBER
73 , p_table_name VARCHAR2
74 , p_lookup_type VARCHAR2
75 , x_return_status out nocopy VARCHAR2
76 , x_msg_count out nocopy NUMBER
77 , x_msg_data out nocopy VARCHAR2
78 , x_loading_status out nocopy VARCHAR2
79 , p13_a0 out nocopy NUMBER
80 , p13_a1 out nocopy NUMBER
81 , p13_a2 out nocopy VARCHAR2
82 , p13_a3 out nocopy VARCHAR2
83 , p13_a4 out nocopy NUMBER
84 , p13_a5 out nocopy NUMBER
85 , p13_a6 out nocopy VARCHAR2
86 , p13_a7 out nocopy VARCHAR2
87 , p13_a8 out nocopy NUMBER
88 , p13_a9 out nocopy NUMBER
89 , p13_a10 out nocopy VARCHAR2
90 , p13_a11 out nocopy VARCHAR2
91 , p13_a12 out nocopy NUMBER
92 , p13_a13 out nocopy VARCHAR2
93 , p14_a0 out nocopy JTF_NUMBER_TABLE
94 , p14_a1 out nocopy JTF_NUMBER_TABLE
95 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
96 , p14_a3 out nocopy JTF_NUMBER_TABLE
97 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_4000
98 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
99 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
100 , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
101 , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
102 , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
103 , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
104 , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
105 , p14_a12 out nocopy JTF_VARCHAR2_TABLE_100
106 , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100
107 , p14_a14 out nocopy JTF_VARCHAR2_TABLE_100
108 , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
109 , p14_a16 out nocopy JTF_VARCHAR2_TABLE_100
110 , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
111 , p14_a18 out nocopy JTF_VARCHAR2_TABLE_100
112 , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
113 , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
114 , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
115 , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
116 , p14_a23 out nocopy JTF_VARCHAR2_TABLE_100
117 , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
118 , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
119 , p14_a26 out nocopy JTF_DATE_TABLE
120 , p14_a27 out nocopy JTF_NUMBER_TABLE
121 , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
122 , p14_a29 out nocopy JTF_NUMBER_TABLE
123 , x_notes_count out nocopy NUMBER
124 );
125 procedure manage_analyst_notes(p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , p_validation_level VARCHAR2
128 , p_commit VARCHAR2
129 , p4_a0 JTF_NUMBER_TABLE
130 , p4_a1 JTF_NUMBER_TABLE
131 , p4_a2 JTF_VARCHAR2_TABLE_100
132 , p4_a3 JTF_NUMBER_TABLE
133 , p4_a4 JTF_VARCHAR2_TABLE_4000
134 , p4_a5 JTF_VARCHAR2_TABLE_100
135 , p4_a6 JTF_VARCHAR2_TABLE_100
136 , p4_a7 JTF_VARCHAR2_TABLE_100
137 , p4_a8 JTF_VARCHAR2_TABLE_100
138 , p4_a9 JTF_VARCHAR2_TABLE_100
139 , p4_a10 JTF_VARCHAR2_TABLE_100
140 , p4_a11 JTF_VARCHAR2_TABLE_100
141 , p4_a12 JTF_VARCHAR2_TABLE_100
142 , p4_a13 JTF_VARCHAR2_TABLE_100
143 , p4_a14 JTF_VARCHAR2_TABLE_100
144 , p4_a15 JTF_VARCHAR2_TABLE_100
145 , p4_a16 JTF_VARCHAR2_TABLE_100
146 , p4_a17 JTF_VARCHAR2_TABLE_100
147 , p4_a18 JTF_VARCHAR2_TABLE_100
148 , p4_a19 JTF_VARCHAR2_TABLE_100
149 , p4_a20 JTF_VARCHAR2_TABLE_100
150 , p4_a21 JTF_VARCHAR2_TABLE_100
151 , p4_a22 JTF_VARCHAR2_TABLE_100
152 , p4_a23 JTF_VARCHAR2_TABLE_100
153 , p4_a24 JTF_VARCHAR2_TABLE_100
154 , p4_a25 JTF_VARCHAR2_TABLE_100
155 , p4_a26 JTF_DATE_TABLE
156 , p4_a27 JTF_NUMBER_TABLE
157 , p4_a28 JTF_VARCHAR2_TABLE_100
158 , p4_a29 JTF_NUMBER_TABLE
159 , x_return_status out nocopy VARCHAR2
160 , x_msg_count out nocopy NUMBER
161 , x_msg_data out nocopy VARCHAR2
162 , x_loading_status out nocopy VARCHAR2
163 );
164 procedure show_last_analyst_note(p_api_version NUMBER
165 , p_init_msg_list VARCHAR2
166 , p_validation_level VARCHAR2
167 , p_commit VARCHAR2
168 , p_payment_worksheet_id NUMBER
169 , p_table_name VARCHAR2
170 , p_lookup_type VARCHAR2
171 , x_return_status out nocopy VARCHAR2
172 , x_msg_count out nocopy NUMBER
173 , x_msg_data out nocopy VARCHAR2
174 , x_loading_status out nocopy VARCHAR2
175 , p11_a0 out nocopy JTF_NUMBER_TABLE
176 , p11_a1 out nocopy JTF_NUMBER_TABLE
177 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
178 , p11_a3 out nocopy JTF_NUMBER_TABLE
179 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_4000
180 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
181 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
182 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
183 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
184 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
185 , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
186 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
187 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
188 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
189 , p11_a14 out nocopy JTF_VARCHAR2_TABLE_100
190 , p11_a15 out nocopy JTF_VARCHAR2_TABLE_100
191 , p11_a16 out nocopy JTF_VARCHAR2_TABLE_100
192 , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
193 , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
194 , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
195 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
196 , p11_a21 out nocopy JTF_VARCHAR2_TABLE_100
197 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
198 , p11_a23 out nocopy JTF_VARCHAR2_TABLE_100
199 , p11_a24 out nocopy JTF_VARCHAR2_TABLE_100
200 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
201 , p11_a26 out nocopy JTF_DATE_TABLE
202 , p11_a27 out nocopy JTF_NUMBER_TABLE
203 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_100
204 , p11_a29 out nocopy JTF_NUMBER_TABLE
205 , x_notes_count out nocopy NUMBER
206 );
207 end cn_reasons_pub_w;