APPS.JTF_NOTES_PUB dependencies on JTF_NOTES_B

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 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 1080: FROM jtf_notes_b

1076: SELECT source_object_code
1077: , source_object_id
1078: INTO l_source_object_code
1079: , l_source_object_id
1080: FROM jtf_notes_b
1081: WHERE jtf_note_id = p_jtf_note_id;
1082:
1083: --
1084: -- Delete the note and it's references

Line 1088: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;

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
1092: , p_SourceObjectCode => l_source_object_code

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 1252: FROM JTF_NOTES_B

1248:
1249: -- Cursor for retrieving from the table to verify insertion
1250: CURSOR l_insert_check_csr
1251: IS SELECT 'x'
1252: FROM JTF_NOTES_B
1253: WHERE jtf_note_id = l_jtf_note_id;
1254:
1255:
1256: -- Local exceptions

Line 1421: FROM jtf_notes_b

1417: )
1418: THEN
1419: SELECT jtf_note_id
1420: INTO l_jtf_note_id
1421: FROM jtf_notes_b
1422: WHERE jtf_note_id = p_jtf_note_id;
1423:
1424: --Exit if another note exists and the calling page is Notes JSP
1425: IF (p_validation_level = 0.5)

Line 2086: FROM JTF_NOTES_B

2082: l_note_select_type NUMBER;
2083:
2084: CURSOR l_com_csr
2085: IS SELECT *
2086: FROM JTF_NOTES_B
2087: WHERE jtf_note_id = p_jtf_note_id
2088: FOR UPDATE OF jtf_note_id NOWAIT;
2089:
2090: CURSOR l_tl_csr

Line 2655: UPDATE JTF_NOTES_B

2651:
2652: --
2653: -- Perform the database operation.
2654: --
2655: UPDATE JTF_NOTES_B
2656: SET last_updated_by = l_last_updated_by
2657: , last_update_date = l_last_update_date
2658: , last_update_login = l_last_update_login
2659: , note_status = l_note_status