eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_NOTES_EVENT_PKG dependencies on CSM_NOTES_ACC

Line 16: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';

12: -- Enter procedure, function bodies as shown below
13:
14: l_markdirty_failed EXCEPTION;
15:
16: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
19: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';

14: l_markdirty_failed EXCEPTION;
15:
16: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
19: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');
22:

Line 30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,

26: g_omappings_pk1_name CONSTANT VARCHAR2(30) := 'MAPPING_ID';
27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');
29:
30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,
31: p_user_id fnd_user.user_id%TYPE)
32: IS
33:
34: BEGIN

Line 48: 'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);

44:
45:
46: EXCEPTION WHEN OTHERS THEN
47: CSM_UTIL_PKG.LOG( sqlerrm|| ' for PK ' || to_char(p_jtf_note_id),
48: 'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
49: RAISE;
50:
51: END;-- end INSERT_CSM_NOTES_ACC;
52:

Line 51: END;-- end INSERT_CSM_NOTES_ACC;

47: CSM_UTIL_PKG.LOG( sqlerrm|| ' for PK ' || to_char(p_jtf_note_id),
48: 'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
49: RAISE;
50:
51: END;-- end INSERT_CSM_NOTES_ACC;
52:
53: PROCEDURE INSERT_CSM_OBJECT_MAPPINGS_ACC (p_access_id IN NUMBER,
54: p_mapping_id jtf_object_mappings.mapping_id%TYPE
55: )

Line 190: -- insert into csm_notes_acc table

186: -- insert for all the affected users
187: FOR i IN 1..l_userlist.COUNT
188: LOOP
189: l_user_found := true;
190: -- insert into csm_notes_acc table
191: insert_csm_notes_acc (l_jtf_note_id, l_userlist(i));
192: --Bug 5532961
193: update csm_notes_acc set counter=l_countlist(i) where jtf_note_id=l_jtf_note_id and user_id=l_userlist(i);
194: END LOOP;

Line 191: insert_csm_notes_acc (l_jtf_note_id, l_userlist(i));

187: FOR i IN 1..l_userlist.COUNT
188: LOOP
189: l_user_found := true;
190: -- insert into csm_notes_acc table
191: insert_csm_notes_acc (l_jtf_note_id, l_userlist(i));
192: --Bug 5532961
193: update csm_notes_acc set counter=l_countlist(i) where jtf_note_id=l_jtf_note_id and user_id=l_userlist(i);
194: END LOOP;
195:

Line 193: update csm_notes_acc set counter=l_countlist(i) where jtf_note_id=l_jtf_note_id and user_id=l_userlist(i);

189: l_user_found := true;
190: -- insert into csm_notes_acc table
191: insert_csm_notes_acc (l_jtf_note_id, l_userlist(i));
192: --Bug 5532961
193: update csm_notes_acc set counter=l_countlist(i) where jtf_note_id=l_jtf_note_id and user_id=l_userlist(i);
194: END LOOP;
195:
196: IF l_userlist.COUNT >0 THEN
197: l_userlist.DELETE;

Line 230: FROM csm_notes_acc acc

226: --cursor declarations
227: CURSOR l_csm_notes_foreachuser_csr (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE) IS
228: SELECT acc.user_id,
229: acc.access_id
230: FROM csm_notes_acc acc
231: WHERE acc.jtf_note_id = p_jtf_note_id;
232:
233: BEGIN
234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 290: -- insert into csm_notes_acc table

286:
287: FOR l_notes_by_task_rec in l_notes_by_task_csr(p_sourceobjectcode,
288: p_sourceobjectid) LOOP
289:
290: -- insert into csm_notes_acc table
291: insert_csm_notes_acc (l_notes_by_task_rec.jtf_note_id, p_userid);
292: END LOOP;
293:
294: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',

Line 291: insert_csm_notes_acc (l_notes_by_task_rec.jtf_note_id, p_userid);

287: FOR l_notes_by_task_rec in l_notes_by_task_csr(p_sourceobjectcode,
288: p_sourceobjectid) LOOP
289:
290: -- insert into csm_notes_acc table
291: insert_csm_notes_acc (l_notes_by_task_rec.jtf_note_id, p_userid);
292: END LOOP;
293:
294: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',
295: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_PROCEDURE);

Line 315: FROM jtf_notes_b notes, csm_notes_acc acc

311: CURSOR l_notes_by_task_csr (p_source_object_code VARCHAR2,
312: p_source_object_id NUMBER,
313: p_user_id NUMBER) IS
314: SELECT acc.jtf_note_id, acc.user_id
315: FROM jtf_notes_b notes, csm_notes_acc acc
316: WHERE notes.source_object_code = p_source_object_code
317: AND notes.source_object_id = p_source_object_id
318: AND notes.jtf_note_id = acc.jtf_note_id
319: AND acc.user_id = p_user_id;