APPS.CAC_NOTES_PVT dependencies on JTF_NOTES_B

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 462: insert into JTF_NOTES_B (

458: FETCH l_jtf_note_id_csr INTO l_jtf_note_id;
459: CLOSE l_jtf_note_id_csr;
460: END IF;
461:
462: insert into JTF_NOTES_B (
463: SOURCE_OBJECT_CODE,
464: NOTE_STATUS,
465: ENTERED_BY,
466: ENTERED_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 914: UPDATE JTF_NOTES_B

910:
911: --
912: -- Perform the database operation.
913: --
914: UPDATE JTF_NOTES_B
915: SET last_updated_by = NVL(p_last_updated_by,fnd_global.user_id)
916: , last_update_date = NVL(p_last_update_date,l_current_date)
917: , last_update_login = NVL(p_last_update_login,fnd_global.login_id)
918: , note_status = NVL(l_note_status,note_status)

Line 1060: FROM jtf_notes_b

1056: SELECT source_object_code
1057: , source_object_id
1058: INTO l_source_object_code
1059: , l_source_object_id
1060: FROM jtf_notes_b
1061: WHERE jtf_note_id = p_jtf_note_id;
1062:
1063: JTF_NOTES_EVENTS_PVT.RaiseUpdateNote
1064: ( p_NoteID => p_jtf_note_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 1147: FROM jtf_notes_b

1143: SELECT source_object_code
1144: , source_object_id
1145: INTO l_source_object_code
1146: , l_source_object_id
1147: FROM jtf_notes_b
1148: WHERE jtf_note_id = p_jtf_note_id;
1149:
1150: --
1151: -- Delete the note and it's references

Line 1155: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;

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
1159: ( p_NoteID => p_jtf_note_id