eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.JTF_NOTES_VUHK

Source


1 PACKAGE BODY JTF_NOTES_VUHK AS
2 /* $Header: jtmnoteb.pls 120.2 2005/08/24 02:16:21 saradhak noship $ */
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
15 , p_commit                  IN     VARCHAR2
16 , p_validation_level        IN     NUMBER
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
24 , p_note_status             IN     VARCHAR2
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
32 , p_last_update_login       IN     NUMBER
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 , x_return_status              OUT NOCOPY VARCHAR2
52 ) is
53 begin
54    /* NOT USED */
55    x_return_status := FND_API.G_RET_STS_SUCCESS;
56 end create_note_pre;
57 
58 
59 /* Verticals Procedure for post processing in case of create note */
60 
61 PROCEDURE create_note_post
62 ( p_parent_note_id          IN     NUMBER
63 , p_api_version             IN     NUMBER
64 , p_init_msg_list           IN     VARCHAR2
65 , p_commit                  IN     VARCHAR2
66 , p_validation_level        IN     NUMBER
67 , x_msg_count                  OUT NOCOPY NUMBER
68 , x_msg_data                   OUT NOCOPY VARCHAR2
69 , p_org_id                  IN     NUMBER
70 , p_source_object_id        IN     NUMBER
71 , p_source_object_code      IN     VARCHAR2
72 , p_notes                   IN     VARCHAR2
73 , p_notes_detail            IN     VARCHAR2 DEFAULT NULL
74 , p_note_status             IN     VARCHAR2 DEFAULT 'I'
75 , p_entered_by              IN     NUMBER
76 , p_entered_date            IN     DATE
77 , x_jtf_note_id                OUT NOCOPY NUMBER
78 , p_last_update_date        IN     DATE
79 , p_last_updated_by         IN     NUMBER
80 , p_creation_date           IN     DATE
81 , p_created_by              IN     NUMBER
82 , p_last_update_login       IN     NUMBER
83 , p_attribute1              IN     VARCHAR2 DEFAULT NULL
84 , p_attribute2              IN     VARCHAR2 DEFAULT NULL
85 , p_attribute3              IN     VARCHAR2 DEFAULT NULL
86 , p_attribute4              IN     VARCHAR2 DEFAULT NULL
87 , p_attribute5              IN     VARCHAR2 DEFAULT NULL
88 , p_attribute6              IN     VARCHAR2 DEFAULT NULL
89 , p_attribute7              IN     VARCHAR2 DEFAULT NULL
90 , p_attribute8              IN     VARCHAR2 DEFAULT NULL
91 , p_attribute9              IN     VARCHAR2 DEFAULT NULL
92 , p_attribute10             IN     VARCHAR2 DEFAULT NULL
93 , p_attribute11             IN     VARCHAR2 DEFAULT NULL
94 , p_attribute12             IN     VARCHAR2 DEFAULT NULL
95 , p_attribute13             IN     VARCHAR2 DEFAULT NULL
96 , p_attribute14             IN     VARCHAR2 DEFAULT NULL
97 , p_attribute15             IN     VARCHAR2 DEFAULT NULL
98 , p_context                 IN     VARCHAR2 DEFAULT NULL
99 , p_note_type               IN     VARCHAR2 DEFAULT NULL
100 , p_jtf_note_contexts_tab   IN     jtf_notes_pub.jtf_note_contexts_tbl_type
101 , x_return_status              OUT NOCOPY VARCHAR2
102 , p_jtf_note_id             IN     NUMBER
103 ) is
104   l_JTM_enable_prof_value varchar2(255);
105   l_cursorid   INTEGER;
106   l_execute_status INTEGER;
107   l_strBuffer   VARCHAR2(2000);
108   l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
109         ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
110            ' ''CREATE_NOTE_POST'', ' ||
111            ' ''JTF_NOTES_VUHK'', ' ||
112            ' ''Error:'' || SQLERRM ' || ',' ||
113            ' 1,' ||
114            ' ''JTM.JTF_NOTES_VUHK.CREATE_NOTE_POST''); ' ||
115         ' exception ' ||
116             ' when others then null;' ||
117         ' end; ';
118 
119 begin
120    x_return_status := FND_API.G_RET_STS_SUCCESS;
121 
122    begin
123          EXECUTE IMMEDIATE
124          ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
125            ' ''CREATE_NOTE_POST'', ' ||
126            ' ''JTF_NOTES_VUHK'', ' ||
127            ' ''The procedure is called.'', ' ||
128            ' 4,' ||
129            ' ''JTM.JTF_NOTES_VUHK.CREATE_NOTE_POST''); ' ||
130          ' end; ';
131    exception
132        when others then
133               null;
134    end;
135 
136   /* check if JTM is installed */
137   l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
138           Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
139 
140   if (l_JTM_enable_prof_value = 'Y') then
141          l_cursorid := DBMS_SQL.open_cursor;
142          l_strBuffer :=
143             ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'CREATE_NOTE_POST' ||
144             '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
145             ' :11,:12,:13,:14,:15,:16,:17,:18,:19,:20,' ||
146             ' :21,:22,:23,:24,:25,:26,:27,:28,:29,:30,' ||
147             ' :31,:32,:33,:34,:35,:36,:37,:38,:40,:41); ' ||
148             ' exception ' ||
149             '   when others then ' ||
150             l_strLogBuffer ||
151             ' end; ';
152          DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
153          DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
154          DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
155          DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
156          DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
157          DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
158          DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
159          DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
160          DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
161          DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
162          DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
163          DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
164          DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
165          DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
166          DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
167          DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
168          DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
169          DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
170          DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
171          DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
172          DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
173          DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
174          DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
175          DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
176          DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
177          DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
178          DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
179          DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
180          DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
181          DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
182          DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
183          DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
184          DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
185          DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
186          DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
187          DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
188          DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
189          DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
190          DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
191          --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
192          DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
193          DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
194 
195          begin
196            l_execute_status := DBMS_SQL.execute (l_cursorid);
197          exception
198             when others then
199                EXECUTE IMMEDIATE l_strLogBuffer;
200          end;
201          DBMS_SQL.close_cursor (l_cursorid);
202 
203   end if;
204 EXCEPTION
205    WHEN OTHERS THEN
206        x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207        begin
208          EXECUTE IMMEDIATE l_strLogBuffer;
209        exception
210            when others then
211               null;
212        end;
213 end create_note_post;
214 
215 
216 /* Verticals Procedure for pre processing in case of update note */
217 
218 PROCEDURE update_note_pre
219 ( p_api_version           IN     NUMBER
220 , p_init_msg_list         IN     VARCHAR2
221 , p_commit                IN     VARCHAR2
222 , p_validation_level      IN     NUMBER
223 , x_msg_count                OUT NOCOPY NUMBER
224 , x_msg_data                 OUT NOCOPY VARCHAR2
225 , p_jtf_note_id           IN     NUMBER
226 , p_entered_by            IN     NUMBER
227 , p_last_updated_by       IN     NUMBER
228 , p_last_update_date      IN     DATE     DEFAULT SYSDATE
229 , p_last_update_login     IN     NUMBER   DEFAULT NULL
230 , p_notes                 IN     VARCHAR2
231 , p_notes_detail          IN     VARCHAR2
232 , p_append_flag           IN     VARCHAR2
233 , p_note_status           IN     VARCHAR2
234 , p_note_type             IN     VARCHAR2
235 , p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
236 , x_return_status            OUT NOCOPY VARCHAR2
237 ) IS
238   l_JTM_enable_prof_value varchar2(255);
239   l_cursorid   INTEGER;
240   l_execute_status INTEGER;
241   l_strBuffer   VARCHAR2(2000);
242   l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
243         ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
244            ' ''UPDATE_NOTE_PRE'', ' ||
245            ' ''JTF_NOTES_VUHK'', ' ||
246            ' ''Error:'' || SQLERRM ' || ',' ||
247            ' 1,' ||
248            ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_PRE''); ' ||
249         ' exception ' ||
250             ' when others then null;' ||
251         ' end; ';
252 
253 begin
254    x_return_status := FND_API.G_RET_STS_SUCCESS;
255 
256    begin
257          EXECUTE IMMEDIATE
258          ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
259            ' ''UPDATE_NOTE_PRE'', ' ||
260            ' ''JTF_NOTES_VUHK'', ' ||
261            ' ''The procedure is called.'', ' ||
262            ' 4,' ||
263            ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_PRE''); ' ||
264          ' end; ';
265    exception
266        when others then
267               null;
268    end;
269 
270    /* check if JTM is installed */
271   l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
272           Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
273 
274   if (l_JTM_enable_prof_value = 'Y') then
275          l_cursorid := DBMS_SQL.open_cursor;
276          l_strBuffer :=
277             ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_pre' ||
278             '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
279             ' :11,:12,:13,:14,:15,:16,:17); ' ||
280             ' exception ' ||
281             '   when others then ' ||
282             l_strLogBuffer ||
283             ' end; ';
284          DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
285          DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
286          DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
287          DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
288          DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
289          DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
290          DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
291          DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
292          DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
293          DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
294          DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
295          DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
296          DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
297          DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
298          DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
299          DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
300          DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
301          DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
302          begin
303            l_execute_status := DBMS_SQL.execute (l_cursorid);
304          exception
305             when others then
306                EXECUTE IMMEDIATE l_strLogBuffer;
307          end;
308          DBMS_SQL.close_cursor (l_cursorid);
309   end if;
310 
311 EXCEPTION
312    WHEN OTHERS THEN
313        x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314        begin
315          EXECUTE IMMEDIATE l_strLogBuffer;
316        exception
317            when others then
318               null;
319        end;
320 end update_note_pre;
321 
322 
323 /* Vertical Procedure for post processing in case of update note */
324 
325 PROCEDURE update_note_post
326 ( p_api_version           IN     NUMBER
327 , p_init_msg_list         IN     VARCHAR2
328 , p_commit                IN     VARCHAR2
329 , p_validation_level      IN     NUMBER
330 , x_msg_count                OUT NOCOPY NUMBER
331 , x_msg_data                 OUT NOCOPY VARCHAR2
332 , p_jtf_note_id           IN     NUMBER
333 , p_entered_by            IN     NUMBER
334 , p_last_updated_by       IN     NUMBER
335 , p_last_update_date      IN     DATE
336 , p_last_update_login     IN     NUMBER
337 , p_notes                 IN     VARCHAR2
338 , p_notes_detail          IN     VARCHAR2
339 , p_append_flag           IN     VARCHAR2
340 , p_note_status           IN     VARCHAR2
341 , p_note_type             IN     VARCHAR2
342 , p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
343 , x_return_status            OUT NOCOPY VARCHAR2
344 ) IS
345   l_JTM_enable_prof_value varchar2(255);
346   l_cursorid   INTEGER;
347   l_execute_status INTEGER;
348   l_strBuffer   VARCHAR2(2000);
349   l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
350         ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
351            ' ''UPDATE_NOTE_POST'', ' ||
352            ' ''JTF_NOTES_VUHK'', ' ||
353            ' ''Error:'' || SQLERRM ' || ',' ||
354            ' 1,' ||
358         ' end; ';
355            ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_POST''); ' ||
356         ' exception ' ||
357             ' when others then null;' ||
359 
360 begin
361    x_return_status := FND_API.G_RET_STS_SUCCESS;
362 
363    begin
364          EXECUTE IMMEDIATE
365          ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
366            ' ''UPDATE_NOTE_POST'', ' ||
367            ' ''JTF_NOTES_VUHK'', ' ||
368            ' ''The procedure is called.'', ' ||
369            ' 4,' ||
370            ' ''JTM.JTF_NOTES_VUHK.UPDATE_NOTE_POST''); ' ||
371          ' end; ';
372    exception
373        when others then
374               null;
375    end;
376 
377    /* check if JTM is installed */
378   l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
379           Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
380 
381   if (l_JTM_enable_prof_value = 'Y') then
382          l_cursorid := DBMS_SQL.open_cursor;
383          l_strBuffer :=
384             ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_post' ||
385             '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
386             ' :11,:12,:13,:14,:15,:16,:17); ' ||
387             ' exception ' ||
388             '   when others then ' ||
389             l_strLogBuffer ||
390             ' end; ';
391          DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392          DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393          DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394          DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395          DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396          DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397          DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398          DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399          DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400          DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401          DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402          DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403          DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404          DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405          DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406          DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407          DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408          DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409 
410          begin
411            l_execute_status := DBMS_SQL.execute (l_cursorid);
412          exception
413             when others then
414               EXECUTE IMMEDIATE l_strLogBuffer;
415          end;
416          DBMS_SQL.close_cursor (l_cursorid);
417   end if;
418 
419 EXCEPTION
420    WHEN OTHERS THEN
421        x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422        begin
423          EXECUTE IMMEDIATE l_strLogBuffer;
424        exception
425            when others then
426               null;
427        end;
428 END;
429 
430 FUNCTION Ok_to_generate_msg
431 ( p_parent_note_id        IN     NUMBER
432 , p_api_version           IN     NUMBER
433 , p_init_msg_list         IN     VARCHAR2
434 , p_commit                IN     VARCHAR2
435 , p_validation_level      IN     NUMBER
436 , x_msg_count                OUT NOCOPY NUMBER
437 , x_msg_data                 OUT NOCOPY VARCHAR2
438 , p_org_id                IN     NUMBER
439 , p_source_object_id      IN     NUMBER
440 , p_source_object_code    IN     VARCHAR2
441 , p_notes                 IN     VARCHAR2
442 , p_notes_detail          IN     VARCHAR2
443 , p_note_status           IN     VARCHAR2
444 , p_entered_by            IN     NUMBER
445 , p_entered_date          IN     DATE
446 , x_jtf_note_id              OUT NOCOPY NUMBER
447 , p_last_update_date      IN     DATE
448 , p_last_updated_by       IN     NUMBER
449 , p_creation_date         IN     DATE
450 , p_created_by            IN     NUMBER
451 , p_last_update_login     IN     NUMBER
452 , p_attribute1            IN     VARCHAR2 DEFAULT NULL
453 , p_attribute2            IN     VARCHAR2 DEFAULT NULL
454 , p_attribute3            IN     VARCHAR2 DEFAULT NULL
455 , p_attribute4            IN     VARCHAR2 DEFAULT NULL
456 , p_attribute5            IN     VARCHAR2 DEFAULT NULL
457 , p_attribute6            IN     VARCHAR2 DEFAULT NULL
458 , p_attribute7            IN     VARCHAR2 DEFAULT NULL
459 , p_attribute8            IN     VARCHAR2 DEFAULT NULL
460 , p_attribute9            IN     VARCHAR2 DEFAULT NULL
461 , p_attribute10           IN     VARCHAR2 DEFAULT NULL
462 , p_attribute11           IN     VARCHAR2 DEFAULT NULL
463 , p_attribute12           IN     VARCHAR2 DEFAULT NULL
464 , p_attribute13           IN     VARCHAR2 DEFAULT NULL
465 , p_attribute14           IN     VARCHAR2 DEFAULT NULL
466 , p_attribute15           IN     VARCHAR2 DEFAULT NULL
467 , p_context               IN     VARCHAR2 DEFAULT NULL
468 , p_note_type             IN     VARCHAR2 DEFAULT NULL
469 , p_jtf_note_contexts_tab IN     jtf_notes_pub.jtf_note_contexts_tbl_type
470 )RETURN BOOLEAN
471 IS
472 BEGIN
473  RETURN TRUE;
474 END;
475 
476 
477 -- The following versions of the APIs are mantained only for backward compatibility
478 -- Please use the above versions for new development.
479 
480 -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
484     p_commit                    IN      VARCHAR2,
481 FUNCTION  Ok_to_generate_msg
482   ( p_api_version               IN      NUMBER,
483     p_init_msg_list             IN      VARCHAR2,
485     p_validation_level          IN      NUMBER,
486     x_msg_count                 OUT     NOCOPY NUMBER,
487     x_msg_data                  OUT     NOCOPY VARCHAR2,
488     p_jtf_note_id               IN      NUMBER,
489     p_entered_by              IN NUMBER   ,
490     p_last_updated_by           IN      NUMBER,
491     p_last_update_date          IN      DATE,
492     p_last_update_login         IN      NUMBER,
493     p_notes                     IN      VARCHAR2,
494     p_notes_detail              IN      VARCHAR2,
495     p_append_flag             IN VARCHAR2 ,
496     p_note_status       IN      VARCHAR2 ,
497     p_note_type           IN   VARCHAR2 ,
498     p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type ,
499     x_return_status        OUT  NOCOPY VARCHAR2
500     )RETURN BOOLEAN
501 IS
502 BEGIN
503  RETURN TRUE;
504 END;
505 
506 -- DO NOT USE THIS VERSION OF CREATE_NOTE_POST
507 PROCEDURE  create_note_post (
508                 p_parent_note_id          IN NUMBER DEFAULT NULL,
509                 p_api_version             IN NUMBER  ,
510                 p_init_msg_list           IN VARCHAR2,
511                 p_commit                  IN VARCHAR2,
512                 p_validation_level        IN NUMBER  ,
513                 x_msg_count              OUT NOCOPY NUMBER   ,
514                 x_msg_data               OUT NOCOPY VARCHAR2 ,
515                       p_org_id            IN NUMBER    DEFAULT NULL,
516                 p_source_object_id        IN NUMBER   ,
517                 p_source_object_code      IN VARCHAR2 ,
518                 p_notes                IN VARCHAR2 ,
519                 p_notes_detail                IN VARCHAR2 DEFAULT NULL,
520                 p_note_status     IN VARCHAR2 DEFAULT 'I',
521                 p_entered_by              IN NUMBER   ,
522                 p_entered_date            IN DATE     ,
523                       x_jtf_note_id              OUT NOCOPY NUMBER   ,
524                       p_last_update_date        IN DATE     ,
525                  p_last_updated_by         IN NUMBER   ,
526                  p_creation_date           IN DATE     ,
527                  p_created_by              IN NUMBER,
528                  p_last_update_login       IN NUMBER,
529                       p_attribute1                IN VARCHAR2  DEFAULT NULL,
530                       p_attribute2                IN VARCHAR2  DEFAULT NULL,
531                       p_attribute3                IN VARCHAR2  DEFAULT NULL,
532                       p_attribute4                IN VARCHAR2  DEFAULT NULL,
533                       p_attribute5                IN VARCHAR2  DEFAULT NULL,
534                       p_attribute6                IN VARCHAR2  DEFAULT NULL,
535                       p_attribute7                IN VARCHAR2  DEFAULT NULL,
536                       p_attribute8                IN VARCHAR2  DEFAULT NULL,
537                       p_attribute9                IN VARCHAR2  DEFAULT NULL,
538                       p_attribute10               IN VARCHAR2  DEFAULT NULL,
539                       p_attribute11               IN VARCHAR2  DEFAULT NULL,
540                       p_attribute12               IN VARCHAR2  DEFAULT NULL,
541                       p_attribute13               IN VARCHAR2  DEFAULT NULL,
542                       p_attribute14               IN VARCHAR2  DEFAULT NULL,
543                       p_attribute15               IN VARCHAR2  DEFAULT NULL,
544                       p_context           IN VARCHAR2  DEFAULT NULL,
545                       p_note_type  IN VARCHAR2  DEFAULT NULL,
546                       p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type ,
547                       x_return_status        OUT  NOCOPY VARCHAR2
548         )
549 IS
550 BEGIN
551  x_return_status := FND_API.G_RET_STS_SUCCESS;
552 END;
553 
554 END jtf_notes_vuhk;