APPS.JTF_NOTES_PUB dependencies on JTF_NOTES_TL

Line 9: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL

5:
6: PROCEDURE Create_note
7: ------------------------------------------------------------------------------
8: -- Create_note
9: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL
10: -- and JTF_NOTE_CONTEXTS table
11: ------------------------------------------------------------------------------
12: ( p_parent_note_id IN NUMBER DEFAULT 9.99E125
13: , p_jtf_note_id IN NUMBER DEFAULT 9.99E125

Line 837: FROM jtf_notes_tl

833: Position INTEGER := 1;
834:
835: CURSOR c1
836: IS SELECT notes_detail
837: FROM jtf_notes_tl
838: WHERE jtf_note_id = x_jtf_note_id
839: FOR UPDATE;
840:
841: BEGIN

Line 959: -- Usage : Deletes a note record in the table JTF_NOTES_B/JTF_NOTES_TL

955: -- Start of notes
956: -- API Name : Delete_Note will only work when the user is granted the
957: -- JTF_NOTE_DELETE privilege through AOL security framework
958: -- Type : Public
959: -- Usage : Deletes a note record in the table JTF_NOTES_B/JTF_NOTES_TL
960: -- and JTF_NOTE_CONTEXTS
961: -- Pre-reqs : None
962: -- Parameters :
963: -- p_api_version IN NUMBER Required

Line 1087: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;

1083: --
1084: -- Delete the note and it's references
1085: --
1086: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;
1087: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;
1088: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;
1089:
1090: JTF_NOTES_EVENTS_PVT.RaiseDeleteNote
1091: ( p_NoteID => p_jtf_note_id

Line 1161: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL

1157:
1158: PROCEDURE Secure_Create_note
1159: ------------------------------------------------------------------------------
1160: -- Create_note
1161: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL
1162: -- and JTF_NOTE_CONTEXTS table
1163: ------------------------------------------------------------------------------
1164: ( p_parent_note_id IN NUMBER DEFAULT 9.99E125
1165: , p_jtf_note_id IN NUMBER DEFAULT 9.99E125

Line 2092: FROM JTF_NOTES_TL

2088: FOR UPDATE OF jtf_note_id NOWAIT;
2089:
2090: CURSOR l_tl_csr
2091: IS SELECT *
2092: FROM JTF_NOTES_TL
2093: WHERE JTF_NOTE_ID = p_JTF_NOTE_ID
2094: AND USERENV('LANG') = LANGUAGE;
2095:
2096: l_com_rec l_com_csr%ROWTYPE;

Line 2687: UPDATE JTF_NOTES_TL

2683: AND l_append_flag = 'N'
2684: )
2685: THEN
2686: -- empty the clob..
2687: UPDATE JTF_NOTES_TL
2688: SET NOTES = l_notes
2689: , NOTES_DETAIL = EMPTY_CLOB()
2690: , LAST_UPDATE_DATE = l_last_update_date
2691: , LAST_UPDATED_BY = l_last_updated_by

Line 2701: UPDATE JTF_NOTES_TL

2697: AND l_append_flag = 'Y'
2698: )
2699: THEN
2700: -- don't do anything with clob
2701: UPDATE JTF_NOTES_TL
2702: SET NOTES = l_notes
2703: , LAST_UPDATE_DATE = l_last_update_date
2704: , LAST_UPDATED_BY = l_last_updated_by
2705: , LAST_UPDATE_LOGIN = l_last_update_login

Line 2710: UPDATE JTF_NOTES_TL

2706: , SOURCE_LANG = USERENV('LANG')
2707: WHERE JTF_NOTE_ID = p_jtf_note_id;
2708:
2709: ELSE
2710: UPDATE JTF_NOTES_TL
2711: SET NOTES = l_notes
2712: , NOTES_DETAIL = EMPTY_CLOB()
2713: , LAST_UPDATE_DATE = l_last_update_date
2714: , LAST_UPDATED_BY = l_last_updated_by