APPS.CAC_NOTE_PURGE_PVT dependencies on JTF_NOTES_B

Line 43: from jtf_notes_b

39: -- Modified by Manas For bug no 4612646 (for Implementing code Review )
40:
41: cursor c_fetch_note_ids is
42: select jtf_note_id
43: from jtf_notes_b
44: where source_object_code = p_object_type
45: and source_object_id in ( select object_id
46: from jtf_object_purge_param_tmp
47: where processing_set_id = p_processing_set_id

Line 62: l_entity_name VARCHAR2(30) := 'JTF_NOTES_B';

58:
59: TYPE t_tab_num Is Table Of NUMBER;
60: l_tab_note_id t_tab_num:=t_tab_num();
61: l_tab_note_contx_id t_tab_num:=t_tab_num();
62: l_entity_name VARCHAR2(30) := 'JTF_NOTES_B';
63:
64: BEGIN
65:
66: SAVEPOINT purge_notes;

Line 90: --Delete data from JTF_NOTES_B table

86: Close c_fetch_note_ids;
87:
88: IF l_tab_note_id.COUNT > 0
89: THEN
90: --Delete data from JTF_NOTES_B table
91: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST
92: Delete JTF_NOTES_B
93: Where jtf_note_id = l_tab_note_id(j);
94:

Line 92: Delete JTF_NOTES_B

88: IF l_tab_note_id.COUNT > 0
89: THEN
90: --Delete data from JTF_NOTES_B table
91: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST
92: Delete JTF_NOTES_B
93: Where jtf_note_id = l_tab_note_id(j);
94:
95: --Delete data from JTF_NOTES_TL table
96: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST

Line 133: --Delete data from JTF_NOTES_B table

129: Close c_fetch_note_contx_ids;
130:
131: IF l_tab_note_contx_id.COUNT > 0
132: THEN
133: --Delete data from JTF_NOTES_B table
134: Forall j In l_tab_note_contx_id.FIRST.. l_tab_note_contx_id.LAST
135: Delete JTF_NOTE_CONTEXTS
136: Where jtf_note_id = l_tab_note_contx_id(j);
137: END IF;