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.1 2008/02/07 08:18:32 anaraman 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.1 2008/02/07 08:18:32 anaraman 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: AND NVL(B.END_DATE,SYSDATE)>= SYSDATE);

Line 36: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC

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

Line 50: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC

46: FROM JTF_OBJECT_MAPPINGS B
47: WHERE NVL(B.END_DATE,SYSDATE)>= SYSDATE
48: AND B.OBJECT_CODE = 'JTF_NOTE_TYPE'
49: AND NOT EXISTS (SELECT 1
50: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
51: WHERE ACC.MAPPING_ID = B.MAPPING_ID);
52:
53:
54: CURSOR c_user_id IS

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

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

Line 140: INSERT INTO CSM_NOTES_TYPE_MAPPING_ACC

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

Line 151: ( CSM_NOTES_TYPE_MAPPING_ACC_S.NEXTVAL,

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