APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on CSM_NOTES_TYPE_MAPPING_ACC

Line 5: g_notes_type_map_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC';

1: PACKAGE BODY CSM_NOTES_TYPE_MAP_EVENT_PKG AS
2: /* $Header: csmenmpb.pls 120.2 2011/01/10 10:18:06 saradhak ship $ */
3:
4: /*** Globals ***/
5: g_notes_type_map_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC';
6: g_notes_type_map_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC_S' ;
7: g_notes_type_map_pubi_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING';
8:
9: g_notes_type_map_pkg_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAP_EVENT_PKG';

Line 6: g_notes_type_map_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC_S' ;

2: /* $Header: csmenmpb.pls 120.2 2011/01/10 10:18:06 saradhak ship $ */
3:
4: /*** Globals ***/
5: g_notes_type_map_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC';
6: g_notes_type_map_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING_ACC_S' ;
7: g_notes_type_map_pubi_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAPPING';
8:
9: g_notes_type_map_pkg_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_TYPE_MAP_EVENT_PKG';
10: g_notes_type_map_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

Line 27: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC

23:
24: --DELETE--
25: CURSOR c_delete IS
26: SELECT ACC.ACCESS_ID
27: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
28: WHERE NOT EXISTS (SELECT 1
29: FROM JTF_OBJECT_MAPPINGS B
30: WHERE B.MAPPING_ID = ACC.MAPPING_ID);
31:

Line 35: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC

31:
32: --UPDATE--
33: CURSOR c_update(b_lastrundate DATE) IS
34: SELECT ACC.ACCESS_ID
35: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
36: WHERE EXISTS (SELECT 1
37: FROM JTF_OBJECT_MAPPINGS B
38: WHERE B.MAPPING_ID = ACC.MAPPING_ID
39: AND B.LAST_UPDATE_DATE > b_lastrundate );

Line 48: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC

44: SELECT MAPPING_ID
45: FROM JTF_OBJECT_MAPPINGS B
46: WHERE B.OBJECT_CODE = 'JTF_NOTE_TYPE'
47: AND NOT EXISTS (SELECT 1
48: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
49: WHERE ACC.MAPPING_ID = B.MAPPING_ID);
50:
51:
52: CURSOR c_user_id IS

Line 101: DELETE FROM CSM_NOTES_TYPE_MAPPING_ACC WHERE ACCESS_ID=l_access_list(I);

97: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'D', sysdate,TRUE );
98: END IF;
99:
100: FORALL I IN 1..l_access_list.COUNT
101: DELETE FROM CSM_NOTES_TYPE_MAPPING_ACC WHERE ACCESS_ID=l_access_list(I);
102:
103:
104:
105: CSM_UTIL_PKG.LOG('DELETION successful',

Line 138: INSERT INTO CSM_NOTES_TYPE_MAPPING_ACC

134: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_id_tab.count||' records',
135: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
136:
137: FORALL I IN 1..l_id_tab.COUNT
138: INSERT INTO CSM_NOTES_TYPE_MAPPING_ACC
139: ( ACCESS_ID,
140: MAPPING_ID,
141: COUNTER,
142: CREATED_BY,

Line 149: ( CSM_NOTES_TYPE_MAPPING_ACC_S.NEXTVAL,

145: LAST_UPDATE_DATE,
146: LAST_UPDATE_LOGIN
147: )
148: VALUES
149: ( CSM_NOTES_TYPE_MAPPING_ACC_S.NEXTVAL,
150: l_id_tab(I),
151: 1,
152: 1,
153: SYSDATE,