APPS.CAC_NOTE_PURGE_PVT dependencies on JTF_NOTE_CONTEXTS

Line 52: from jtf_note_contexts

48: and ( purge_status is null or purge_status <> 'E'));
49:
50: cursor c_fetch_note_contx_ids is
51: select jtf_note_id
52: from jtf_note_contexts
53: where note_context_type = p_object_type
54: and note_context_type_id in ( select object_id
55: from jtf_object_purge_param_tmp
56: where processing_set_id = p_processing_set_id

Line 100: --Delete data from JTF_NOTE_CONTEXTS table

96: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST
97: Delete JTF_NOTES_TL
98: Where jtf_note_id = l_tab_note_id(j);
99:
100: --Delete data from JTF_NOTE_CONTEXTS table
101: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST
102: Delete JTF_NOTE_CONTEXTS
103: Where jtf_note_id = l_tab_note_id(j);
104:

Line 102: Delete JTF_NOTE_CONTEXTS

98: Where jtf_note_id = l_tab_note_id(j);
99:
100: --Delete data from JTF_NOTE_CONTEXTS table
101: Forall j In l_tab_note_id.FIRST.. l_tab_note_id.LAST
102: Delete JTF_NOTE_CONTEXTS
103: Where jtf_note_id = l_tab_note_id(j);
104:
105: -- Calling delete attachment API
106:

Line 135: Delete JTF_NOTE_CONTEXTS

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;
138:
139: IF fnd_api.to_boolean(p_commit)