APPS.JTF_NOTES_PKG dependencies on JTF_NOTES_TL

Line 103: insert into JTF_NOTES_TL (

99: X_LAST_UPDATED_BY,
100: X_LAST_UPDATE_LOGIN
101: );
102:
103: insert into JTF_NOTES_TL (
104: JTF_NOTE_ID,
105: NOTES,
106: NOTES_DETAIL,
107: LAST_UPDATE_DATE,

Line 225: from JTF_NOTES_TL

221: cursor c1 is select
222: NOTES,
223: NOTES_DETAIL,
224: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
225: from JTF_NOTES_TL
226: where JTF_NOTE_ID = X_JTF_NOTE_ID
227: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
228: for update of JTF_NOTE_ID nowait;
229: begin

Line 368: update JTF_NOTES_TL set

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: update JTF_NOTES_TL set
369: NOTES = X_NOTES,
370: NOTES_DETAIL = X_NOTES_DETAIL,
371: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
372: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 387: delete from JTF_NOTES_TL

383: procedure DELETE_ROW (
384: X_JTF_NOTE_ID in NUMBER
385: ) is
386: begin
387: delete from JTF_NOTES_TL
388: where JTF_NOTE_ID = X_JTF_NOTE_ID;
389:
390: if (sql%notfound) then
391: raise no_data_found;

Line 407: delete from JTF_NOTES_TL T

403: is
404: begin
405:
406: /** Commented for now for the bug #4229850
407: delete from JTF_NOTES_TL T
408: where not exists
409: (select NULL
410: from JTF_NOTES_B B
411: where B.JTF_NOTE_ID = T.JTF_NOTE_ID

Line 414: update JTF_NOTES_TL T set (

410: from JTF_NOTES_B B
411: where B.JTF_NOTE_ID = T.JTF_NOTE_ID
412: );
413:
414: update JTF_NOTES_TL T set (
415: NOTES,
416: NOTES_DETAIL
417: ) = (select
418: B.NOTES,

Line 420: from JTF_NOTES_TL B

416: NOTES_DETAIL
417: ) = (select
418: B.NOTES,
419: B.NOTES_DETAIL
420: from JTF_NOTES_TL B
421: where B.JTF_NOTE_ID = T.JTF_NOTE_ID
422: and B.LANGUAGE = T.SOURCE_LANG)
423: where (
424: T.JTF_NOTE_ID,

Line 429: from JTF_NOTES_TL SUBB, JTF_NOTES_TL SUBT

425: T.LANGUAGE
426: ) in (select
427: SUBT.JTF_NOTE_ID,
428: SUBT.LANGUAGE
429: from JTF_NOTES_TL SUBB, JTF_NOTES_TL SUBT
430: where SUBB.JTF_NOTE_ID = SUBT.JTF_NOTE_ID
431: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
432: and (SUBB.NOTES <> SUBT.NOTES
433: or (( DBMS_LOB.COMPARE(SUBB.NOTES_DETAIL, SUBT.NOTES_DETAIL,DBMS_LOB.GETLENGTH(SUBB.NOTES_DETAIL),1,1)) <> 0)

Line 440: insert into JTF_NOTES_TL (

436: ));
437: **/
438: /* Commented the code for Perf. Bug 4229850 */
439: /*
440: insert into JTF_NOTES_TL (
441: JTF_NOTE_ID,
442: NOTES,
443: NOTES_DETAIL,
444: LAST_UPDATE_DATE,

Line 462: from JTF_NOTES_TL B, FND_LANGUAGES L

458: B.CREATED_BY,
459: B.LAST_UPDATE_LOGIN,
460: L.LANGUAGE_CODE,
461: B.SOURCE_LANG
462: from JTF_NOTES_TL B, FND_LANGUAGES L
463: where L.INSTALLED_FLAG in ('I', 'B')
464: and B.LANGUAGE = userenv('LANG')
465: and not exists
466: (select NULL

Line 467: from JTF_NOTES_TL T

463: where L.INSTALLED_FLAG in ('I', 'B')
464: and B.LANGUAGE = userenv('LANG')
465: and not exists
466: (select NULL
467: from JTF_NOTES_TL T
468: where T.JTF_NOTE_ID = B.JTF_NOTE_ID
469: and T.LANGUAGE = L.LANGUAGE_CODE);
470: */
471: --

Line 474: insert /*+ append parallel(tl) */ into JTF_NOTES_TL tl

470: */
471: --
472: -- Added this code Perf. Bug 3723927
473: --
474: insert /*+ append parallel(tl) */ into JTF_NOTES_TL tl
475: (
476: JTF_NOTE_ID,
477: NOTES,
478: NOTES_DETAIL,

Line 499: from JTF_NOTES_TL B, FND_LANGUAGES L

495: B.CREATED_BY,
496: B.LAST_UPDATE_LOGIN,
497: L.LANGUAGE_CODE,
498: B.SOURCE_LANG
499: from JTF_NOTES_TL B, FND_LANGUAGES L
500: where L.INSTALLED_FLAG in ('I', 'B')
501: and B.LANGUAGE = userenv('LANG')
502: ) v, JTF_NOTES_TL t
503: where t.JTF_NOTE_ID(+) = v.JTF_NOTE_ID

Line 502: ) v, JTF_NOTES_TL t

498: B.SOURCE_LANG
499: from JTF_NOTES_TL B, FND_LANGUAGES L
500: where L.INSTALLED_FLAG in ('I', 'B')
501: and B.LANGUAGE = userenv('LANG')
502: ) v, JTF_NOTES_TL t
503: where t.JTF_NOTE_ID(+) = v.JTF_NOTE_ID
504: AND t.language(+) = v.language_code
505: AND t.JTF_NOTE_ID is null;
506:

Line 520: from jtf_notes_tl

516: Buffer VARCHAR2(32767);
517:
518: cursor c1 is
519: select notes_detail
520: from jtf_notes_tl
521: where jtf_note_id = x_jtf_note_id
522: for update;
523: Begin
524:

Line 758: UPDATE jtf_notes_tl SET

754: X_OWNER in VARCHAR2
755: ) IS
756:
757: begin
758: UPDATE jtf_notes_tl SET
759: notes=X_NOTES,
760: notes_detail = X_NOTES_DETAIL,
761: last_update_date = sysdate,
762: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),