1 PACKAGE jtf_notes_vuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfntsvs.pls 115.8 2002/11/16 00:28:11 hbouten ship $ */
3
4 /*****************************************************************************************
5 This is the Vertical User Hook API.
6 The verticals can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Verticals Procedure for pre processing in case of create note */
10
11 PROCEDURE create_note_pre
12 ( p_parent_note_id IN NUMBER DEFAULT NULL
13 , p_api_version IN NUMBER
14 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
16 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 , p_org_id IN NUMBER DEFAULT NULL
20 , p_source_object_id IN NUMBER
21 , p_source_object_code IN VARCHAR2
22 , p_notes IN VARCHAR2
23 , p_notes_detail IN VARCHAR2 DEFAULT NULL
24 , p_note_status IN VARCHAR2 DEFAULT 'I'
25 , p_entered_by IN NUMBER
26 , p_entered_date IN DATE
27 , x_jtf_note_id OUT NOCOPY NUMBER
28 , p_last_update_date IN DATE
29 , p_last_updated_by IN NUMBER
30 , p_creation_date IN DATE
31 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
32 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
33 , p_attribute1 IN VARCHAR2 DEFAULT NULL
34 , p_attribute2 IN VARCHAR2 DEFAULT NULL
35 , p_attribute3 IN VARCHAR2 DEFAULT NULL
36 , p_attribute4 IN VARCHAR2 DEFAULT NULL
37 , p_attribute5 IN VARCHAR2 DEFAULT NULL
38 , p_attribute6 IN VARCHAR2 DEFAULT NULL
39 , p_attribute7 IN VARCHAR2 DEFAULT NULL
40 , p_attribute8 IN VARCHAR2 DEFAULT NULL
41 , p_attribute9 IN VARCHAR2 DEFAULT NULL
42 , p_attribute10 IN VARCHAR2 DEFAULT NULL
43 , p_attribute11 IN VARCHAR2 DEFAULT NULL
44 , p_attribute12 IN VARCHAR2 DEFAULT NULL
45 , p_attribute13 IN VARCHAR2 DEFAULT NULL
46 , p_attribute14 IN VARCHAR2 DEFAULT NULL
47 , p_attribute15 IN VARCHAR2 DEFAULT NULL
48 , p_context IN VARCHAR2 DEFAULT NULL
49 , p_note_type IN VARCHAR2 DEFAULT NULL
50 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
51 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 /* Verticals Procedure for post processing in case of create note */
56
57 PROCEDURE create_note_post
58 ( p_parent_note_id IN NUMBER DEFAULT NULL
59 , p_api_version IN NUMBER
60 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
61 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 , p_org_id IN NUMBER DEFAULT NULL
66 , p_source_object_id IN NUMBER
67 , p_source_object_code IN VARCHAR2
68 , p_notes IN VARCHAR2
69 , p_notes_detail IN VARCHAR2 DEFAULT NULL
70 , p_note_status IN VARCHAR2 DEFAULT 'I'
71 , p_entered_by IN NUMBER
72 , p_entered_date IN DATE
73 , x_jtf_note_id OUT NOCOPY NUMBER
74 , p_last_update_date IN DATE
75 , p_last_updated_by IN NUMBER
76 , p_creation_date IN DATE
77 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
78 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
79 , p_attribute1 IN VARCHAR2 DEFAULT NULL
80 , p_attribute2 IN VARCHAR2 DEFAULT NULL
81 , p_attribute3 IN VARCHAR2 DEFAULT NULL
82 , p_attribute4 IN VARCHAR2 DEFAULT NULL
83 , p_attribute5 IN VARCHAR2 DEFAULT NULL
84 , p_attribute6 IN VARCHAR2 DEFAULT NULL
85 , p_attribute7 IN VARCHAR2 DEFAULT NULL
86 , p_attribute8 IN VARCHAR2 DEFAULT NULL
87 , p_attribute9 IN VARCHAR2 DEFAULT NULL
88 , p_attribute10 IN VARCHAR2 DEFAULT NULL
89 , p_attribute11 IN VARCHAR2 DEFAULT NULL
90 , p_attribute12 IN VARCHAR2 DEFAULT NULL
91 , p_attribute13 IN VARCHAR2 DEFAULT NULL
92 , p_attribute14 IN VARCHAR2 DEFAULT NULL
93 , p_attribute15 IN VARCHAR2 DEFAULT NULL
94 , p_context IN VARCHAR2 DEFAULT NULL
95 , p_note_type IN VARCHAR2 DEFAULT NULL
96 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
97 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
98 , x_return_status OUT NOCOPY VARCHAR2
99 , p_jtf_note_id IN NUMBER DEFAULT NULL
100 );
101
102 /* Verticals Procedure for pre processing in case of update note */
103
104 PROCEDURE update_note_pre
105 ( p_api_version IN NUMBER
106 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
107 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
108 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_jtf_note_id IN NUMBER
112 , p_entered_by IN NUMBER
113 , p_last_updated_by IN NUMBER
114 , p_last_update_date IN DATE DEFAULT SYSDATE
115 , p_last_update_login IN NUMBER DEFAULT NULL
116 , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
117 , p_notes_detail IN VARCHAR2 DEFAULT NULL
118 , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
119 , p_note_status IN VARCHAR2 DEFAULT 'I'
120 , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
122 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
123 , x_return_status OUT NOCOPY VARCHAR2
124 );
125
126
127 /* Vertical Procedure for post processing in case of update note */
128
129 PROCEDURE update_note_post
130 ( p_api_version IN NUMBER
131 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
132 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
133 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
134 , x_msg_count OUT NOCOPY NUMBER
135 , x_msg_data OUT NOCOPY VARCHAR2
136 , p_jtf_note_id IN NUMBER
137 , p_entered_by IN NUMBER
138 , p_last_updated_by IN NUMBER
139 , p_last_update_date IN DATE DEFAULT SYSDATE
140 , p_last_update_login IN NUMBER DEFAULT NULL
141 , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
142 , p_notes_detail IN VARCHAR2 DEFAULT NULL
143 , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
144 , p_note_status IN VARCHAR2 DEFAULT 'I'
145 , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
147 , x_return_status OUT NOCOPY VARCHAR2
148 );
149
150 FUNCTION Ok_to_generate_msg
151 ( p_parent_note_id IN NUMBER DEFAULT NULL
152 , p_api_version IN NUMBER
153 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
155 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_msg_data OUT NOCOPY VARCHAR2
158 , p_org_id IN NUMBER DEFAULT NULL
159 , p_source_object_id IN NUMBER
160 , p_source_object_code IN VARCHAR2
161 , p_notes IN VARCHAR2
162 , p_notes_detail IN VARCHAR2 DEFAULT NULL
163 , p_note_status IN VARCHAR2 DEFAULT 'I'
164 , p_entered_by IN NUMBER
165 , p_entered_date IN DATE
166 , x_jtf_note_id OUT NOCOPY NUMBER
167 , p_last_update_date IN DATE
168 , p_last_updated_by IN NUMBER
169 , p_creation_date IN DATE
170 , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
171 , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
172 , p_attribute1 IN VARCHAR2 DEFAULT NULL
173 , p_attribute2 IN VARCHAR2 DEFAULT NULL
174 , p_attribute3 IN VARCHAR2 DEFAULT NULL
175 , p_attribute4 IN VARCHAR2 DEFAULT NULL
176 , p_attribute5 IN VARCHAR2 DEFAULT NULL
177 , p_attribute6 IN VARCHAR2 DEFAULT NULL
178 , p_attribute7 IN VARCHAR2 DEFAULT NULL
179 , p_attribute8 IN VARCHAR2 DEFAULT NULL
180 , p_attribute9 IN VARCHAR2 DEFAULT NULL
181 , p_attribute10 IN VARCHAR2 DEFAULT NULL
182 , p_attribute11 IN VARCHAR2 DEFAULT NULL
183 , p_attribute12 IN VARCHAR2 DEFAULT NULL
184 , p_attribute13 IN VARCHAR2 DEFAULT NULL
185 , p_attribute14 IN VARCHAR2 DEFAULT NULL
186 , p_attribute15 IN VARCHAR2 DEFAULT NULL
187 , p_context IN VARCHAR2 DEFAULT NULL
188 , p_note_type IN VARCHAR2 DEFAULT NULL
189 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
190 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
191 )RETURN BOOLEAN;
192
193
194 -- The following versions of the APIs are mantained only for backward compatibility
195 -- Please use the above versions for new development.
196
197 -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
198 FUNCTION Ok_to_generate_msg
199 ( p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_jtf_note_id IN NUMBER,
206 p_entered_by IN NUMBER ,
207 p_last_updated_by IN NUMBER,
208 p_last_update_date IN DATE DEFAULT Sysdate,
209 p_last_update_login IN NUMBER DEFAULT NULL,
210 p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
211 p_notes_detail IN VARCHAR2 DEFAULT NULL,
212 p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
213 p_note_status IN VARCHAR2 DEFAULT 'I',
214 p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215 p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
216 DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,
217 x_return_status OUT NOCOPY VARCHAR2
218 )RETURN BOOLEAN;
219
220 -- DO NOT USE THIS VERSION OF CREATE_NOTE_POST
221 PROCEDURE create_note_post (
222 p_parent_note_id IN NUMBER DEFAULT NULL,
223 p_api_version IN NUMBER ,
224 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
227 x_msg_count OUT NOCOPY NUMBER ,
228 x_msg_data OUT NOCOPY VARCHAR2 ,
229 p_org_id IN NUMBER DEFAULT NULL,
230 p_source_object_id IN NUMBER ,
231 p_source_object_code IN VARCHAR2 ,
232 p_notes IN VARCHAR2 ,
233 p_notes_detail IN VARCHAR2 DEFAULT NULL,
234 p_note_status IN VARCHAR2 DEFAULT 'I',
235 p_entered_by IN NUMBER ,
236 p_entered_date IN DATE ,
237 x_jtf_note_id OUT NOCOPY NUMBER ,
238 p_last_update_date IN DATE ,
239 p_last_updated_by IN NUMBER ,
240 p_creation_date IN DATE ,
241 p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
242 p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID,
243 p_attribute1 IN VARCHAR2 DEFAULT NULL,
244 p_attribute2 IN VARCHAR2 DEFAULT NULL,
245 p_attribute3 IN VARCHAR2 DEFAULT NULL,
246 p_attribute4 IN VARCHAR2 DEFAULT NULL,
247 p_attribute5 IN VARCHAR2 DEFAULT NULL,
248 p_attribute6 IN VARCHAR2 DEFAULT NULL,
249 p_attribute7 IN VARCHAR2 DEFAULT NULL,
250 p_attribute8 IN VARCHAR2 DEFAULT NULL,
251 p_attribute9 IN VARCHAR2 DEFAULT NULL,
252 p_attribute10 IN VARCHAR2 DEFAULT NULL,
253 p_attribute11 IN VARCHAR2 DEFAULT NULL,
254 p_attribute12 IN VARCHAR2 DEFAULT NULL,
255 p_attribute13 IN VARCHAR2 DEFAULT NULL,
256 p_attribute14 IN VARCHAR2 DEFAULT NULL,
257 p_attribute15 IN VARCHAR2 DEFAULT NULL,
258 p_context IN VARCHAR2 DEFAULT NULL,
259 p_note_type IN VARCHAR2 DEFAULT NULL,
260 p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt,
261 x_return_status OUT NOCOPY VARCHAR2
262 );
263
264
265
266 END jtf_notes_vuhk;