APPS.JTF_NOTES_UTIL_PVT dependencies on JTF_NOTES_TL

Line 146: FROM JTF_NOTES_TL

142: (
143: p_note_id NUMBER
144: ) IS
145: SELECT NOTES_DETAIL
146: FROM JTF_NOTES_TL
147: WHERE JTF_NOTE_ID = p_note_id
148: AND LANGUAGE = USERENV('LANG');
149:
150: l_notes_detail JTF_NOTES_TL.NOTES_DETAIL%TYPE;

Line 150: l_notes_detail JTF_NOTES_TL.NOTES_DETAIL%TYPE;

146: FROM JTF_NOTES_TL
147: WHERE JTF_NOTE_ID = p_note_id
148: AND LANGUAGE = USERENV('LANG');
149:
150: l_notes_detail JTF_NOTES_TL.NOTES_DETAIL%TYPE;
151:
152: Amount BINARY_INTEGER := 32767;
153: Position INTEGER := 1;
154: Buffer varchar2(32767);

Line 225: FROM jtf_notes_tl

221: (
222: p_note_id VARCHAR2
223: ) IS
224: SELECT DECODE(DBMS_LOB.SUBSTR(notes_detail,1,1),NULL,'N','Y') hasCLOB
225: FROM jtf_notes_tl
226: WHERE jtf_note_id = p_note_id
227: AND language = userenv('LANG');
228:
229: l_HasCLOB VARCHAR2(1):='N';