[Home] [Help]
PACKAGE: APPS.JTF_NOTES_PUB_W
Source
1 package jtf_notes_pub_w AUTHID CURRENT_USER as
2 /* $Header: jtfntsws.pls 120.2 2006/04/26 23:06 mpadhiar ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy jtf_notes_pub.jtf_note_contexts_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 );
13 procedure rosetta_table_copy_out_p1(t jtf_notes_pub.jtf_note_contexts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_NUMBER_TABLE
15 , a2 out nocopy JTF_VARCHAR2_TABLE_300
16 , a3 out nocopy JTF_NUMBER_TABLE
17 , a4 out nocopy JTF_DATE_TABLE
18 , a5 out nocopy JTF_NUMBER_TABLE
19 , a6 out nocopy JTF_DATE_TABLE
20 , a7 out nocopy JTF_NUMBER_TABLE
21 , a8 out nocopy JTF_NUMBER_TABLE
22 );
23
24 procedure create_note(p_parent_note_id NUMBER
25 , p_jtf_note_id NUMBER
26 , p_api_version NUMBER
27 , p_init_msg_list VARCHAR2
28 , p_commit VARCHAR2
29 , p_validation_level NUMBER
30 , x_return_status out nocopy VARCHAR2
31 , x_msg_count out nocopy NUMBER
32 , x_msg_data out nocopy VARCHAR2
33 , p_org_id NUMBER
34 , p_source_object_id NUMBER
35 , p_source_object_code VARCHAR2
36 , p_notes VARCHAR2
37 , p_notes_detail VARCHAR2
38 , p_note_status VARCHAR2
39 , p_entered_by NUMBER
40 , p_entered_date date
41 , x_jtf_note_id out nocopy NUMBER
42 , p_last_update_date date
43 , p_last_updated_by NUMBER
44 , p_creation_date date
45 , p_created_by NUMBER
46 , p_last_update_login NUMBER
47 , p_attribute1 VARCHAR2
48 , p_attribute2 VARCHAR2
49 , p_attribute3 VARCHAR2
50 , p_attribute4 VARCHAR2
51 , p_attribute5 VARCHAR2
52 , p_attribute6 VARCHAR2
53 , p_attribute7 VARCHAR2
54 , p_attribute8 VARCHAR2
55 , p_attribute9 VARCHAR2
56 , p_attribute10 VARCHAR2
57 , p_attribute11 VARCHAR2
58 , p_attribute12 VARCHAR2
59 , p_attribute13 VARCHAR2
60 , p_attribute14 VARCHAR2
61 , p_attribute15 VARCHAR2
62 , p_context VARCHAR2
63 , p_note_type VARCHAR2
64 , p40_a0 JTF_NUMBER_TABLE
65 , p40_a1 JTF_NUMBER_TABLE
66 , p40_a2 JTF_VARCHAR2_TABLE_300
67 , p40_a3 JTF_NUMBER_TABLE
68 , p40_a4 JTF_DATE_TABLE
69 , p40_a5 JTF_NUMBER_TABLE
70 , p40_a6 JTF_DATE_TABLE
71 , p40_a7 JTF_NUMBER_TABLE
72 , p40_a8 JTF_NUMBER_TABLE
73 );
74 procedure update_note(p_api_version NUMBER
75 , p_init_msg_list VARCHAR2
76 , p_commit VARCHAR2
77 , p_validation_level NUMBER
78 , x_return_status out nocopy VARCHAR2
79 , x_msg_count out nocopy NUMBER
80 , x_msg_data out nocopy VARCHAR2
81 , p_jtf_note_id NUMBER
82 , p_entered_by NUMBER
83 , p_last_updated_by NUMBER
84 , p_last_update_date date
85 , p_last_update_login NUMBER
86 , p_notes VARCHAR2
87 , p_notes_detail VARCHAR2
88 , p_append_flag VARCHAR2
89 , p_note_status VARCHAR2
90 , p_note_type VARCHAR2
91 , p17_a0 JTF_NUMBER_TABLE
92 , p17_a1 JTF_NUMBER_TABLE
93 , p17_a2 JTF_VARCHAR2_TABLE_300
94 , p17_a3 JTF_NUMBER_TABLE
95 , p17_a4 JTF_DATE_TABLE
96 , p17_a5 JTF_NUMBER_TABLE
97 , p17_a6 JTF_DATE_TABLE
98 , p17_a7 JTF_NUMBER_TABLE
99 , p17_a8 JTF_NUMBER_TABLE
100 );
101 procedure create_note_context(p_validation_level NUMBER
102 , x_return_status out nocopy VARCHAR2
103 , p_jtf_note_id NUMBER
104 , p_last_update_date date
105 , p_last_updated_by NUMBER
106 , p_creation_date date
107 , p_created_by NUMBER
108 , p_last_update_login NUMBER
109 , p_note_context_type_id NUMBER
110 , p_note_context_type VARCHAR2
111 , x_note_context_id out nocopy NUMBER
112 );
113 procedure update_note_context(p_validation_level NUMBER
114 , x_return_status out nocopy VARCHAR2
115 , p_note_context_id NUMBER
116 , p_jtf_note_id NUMBER
117 , p_note_context_type_id NUMBER
118 , p_note_context_type VARCHAR2
119 , p_last_updated_by NUMBER
120 , p_last_update_date date
121 , p_last_update_login NUMBER
122 );
123 procedure secure_create_note(p_parent_note_id NUMBER
124 , p_jtf_note_id NUMBER
125 , p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , p_commit VARCHAR2
128 , p_validation_level NUMBER
129 , x_return_status out nocopy VARCHAR2
130 , x_msg_count out nocopy NUMBER
131 , x_msg_data out nocopy VARCHAR2
132 , p_org_id NUMBER
133 , p_source_object_id NUMBER
134 , p_source_object_code VARCHAR2
135 , p_notes VARCHAR2
136 , p_notes_detail VARCHAR2
137 , p_note_status VARCHAR2
138 , p_entered_by NUMBER
139 , p_entered_date date
140 , x_jtf_note_id out nocopy NUMBER
141 , p_last_update_date date
142 , p_last_updated_by NUMBER
143 , p_creation_date date
144 , p_created_by NUMBER
145 , p_last_update_login NUMBER
146 , p_attribute1 VARCHAR2
147 , p_attribute2 VARCHAR2
148 , p_attribute3 VARCHAR2
149 , p_attribute4 VARCHAR2
150 , p_attribute5 VARCHAR2
151 , p_attribute6 VARCHAR2
152 , p_attribute7 VARCHAR2
153 , p_attribute8 VARCHAR2
154 , p_attribute9 VARCHAR2
155 , p_attribute10 VARCHAR2
156 , p_attribute11 VARCHAR2
157 , p_attribute12 VARCHAR2
158 , p_attribute13 VARCHAR2
159 , p_attribute14 VARCHAR2
160 , p_attribute15 VARCHAR2
161 , p_context VARCHAR2
162 , p_note_type VARCHAR2
163 , p40_a0 JTF_NUMBER_TABLE
164 , p40_a1 JTF_NUMBER_TABLE
165 , p40_a2 JTF_VARCHAR2_TABLE_300
166 , p40_a3 JTF_NUMBER_TABLE
167 , p40_a4 JTF_DATE_TABLE
168 , p40_a5 JTF_NUMBER_TABLE
169 , p40_a6 JTF_DATE_TABLE
170 , p40_a7 JTF_NUMBER_TABLE
171 , p40_a8 JTF_NUMBER_TABLE
172 , p_use_aol_security VARCHAR2
173 );
174 procedure secure_update_note(p_api_version NUMBER
175 , p_init_msg_list VARCHAR2
176 , p_commit VARCHAR2
177 , p_validation_level NUMBER
178 , x_return_status out nocopy VARCHAR2
179 , x_msg_count out nocopy NUMBER
180 , x_msg_data out nocopy VARCHAR2
181 , p_jtf_note_id NUMBER
182 , p_entered_by NUMBER
183 , p_last_updated_by NUMBER
184 , p_last_update_date date
185 , p_last_update_login NUMBER
186 , p_notes VARCHAR2
187 , p_notes_detail VARCHAR2
188 , p_append_flag VARCHAR2
189 , p_note_status VARCHAR2
190 , p_note_type VARCHAR2
191 , p17_a0 JTF_NUMBER_TABLE
192 , p17_a1 JTF_NUMBER_TABLE
193 , p17_a2 JTF_VARCHAR2_TABLE_300
194 , p17_a3 JTF_NUMBER_TABLE
195 , p17_a4 JTF_DATE_TABLE
196 , p17_a5 JTF_NUMBER_TABLE
197 , p17_a6 JTF_DATE_TABLE
198 , p17_a7 JTF_NUMBER_TABLE
199 , p17_a8 JTF_NUMBER_TABLE
200 , p_attribute1 VARCHAR2
201 , p_attribute2 VARCHAR2
202 , p_attribute3 VARCHAR2
203 , p_attribute4 VARCHAR2
204 , p_attribute5 VARCHAR2
205 , p_attribute6 VARCHAR2
206 , p_attribute7 VARCHAR2
207 , p_attribute8 VARCHAR2
208 , p_attribute9 VARCHAR2
209 , p_attribute10 VARCHAR2
210 , p_attribute11 VARCHAR2
211 , p_attribute12 VARCHAR2
212 , p_attribute13 VARCHAR2
213 , p_attribute14 VARCHAR2
214 , p_attribute15 VARCHAR2
215 , p_context VARCHAR2
216 , p_use_aol_security VARCHAR2
217 );
218 end jtf_notes_pub_w;