APPS.CAC_NOTES_PVT dependencies on JTF_NOTES_TL

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

203:
204: PROCEDURE create_note
205: ------------------------------------------------------------------------------
206: -- Create_note
207: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
208: ------------------------------------------------------------------------------
209: ( p_jtf_note_id IN NUMBER := NULL
210: , p_source_object_id IN NUMBER
211: , p_source_object_code IN VARCHAR2

Line 522: insert into JTF_NOTES_TL (

518: P_ATTRIBUTE15,
519: P_PARENT_NOTE_ID
520: );
521:
522: insert into JTF_NOTES_TL (
523: JTF_NOTE_ID,
524: NOTES,
525: NOTES_DETAIL,
526: CREATION_DATE,

Line 777: -- Updates a note record in the JTF_NOTES_B, JTF_NOTES_TL tables

773:
774: PROCEDURE update_note
775: ------------------------------------------------------------------------------
776: -- Update_note
777: -- Updates a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
778: ------------------------------------------------------------------------------
779: ( p_jtf_note_id IN NUMBER
780: , p_notes IN VARCHAR2 := NULL
781: , p_notes_detail IN CLOB := NULL

Line 940: UPDATE JTF_NOTES_TL

936: WHERE jtf_note_id = p_jtf_note_id;
937:
938: IF (p_notes_detail IS NULL)
939: THEN
940: UPDATE JTF_NOTES_TL
941: SET NOTES = NVL(l_notes,NOTES)
942: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
943: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)
944: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)

Line 948: UPDATE JTF_NOTES_TL

944: , LAST_UPDATE_LOGIN = NVL(p_last_update_login,fnd_global.login_id)
945: , SOURCE_LANG = USERENV('LANG')
946: WHERE JTF_NOTE_ID = p_jtf_note_id;
947: ELSE
948: UPDATE JTF_NOTES_TL
949: SET NOTES = NVL(l_notes,NOTES)
950: , NOTES_DETAIL = p_notes_detail
951: , LAST_UPDATE_DATE = NVL(p_last_update_date,l_current_date)
952: , LAST_UPDATED_BY = NVL(p_last_updated_by,fnd_global.user_id)

Line 1118: -- deletes a note record in the JTF_NOTES_B, JTF_NOTES_TL tables

1114:
1115: PROCEDURE delete_note
1116: ------------------------------------------------------------------------------
1117: -- delete_note
1118: -- deletes a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
1119: ------------------------------------------------------------------------------
1120: ( p_jtf_note_id IN NUMBER
1121: , x_return_status OUT NOCOPY VARCHAR2
1122: , x_msg_count OUT NOCOPY NUMBER

Line 1154: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;

1150: --
1151: -- Delete the note and it's references
1152: --
1153: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;
1154: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;
1155: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;
1156:
1157:
1158: JTF_NOTES_EVENTS_PVT.RaiseDeleteNote