APPS.CSM_CUSTMZ_VIEWS_EVENT_PKG dependencies on CSM_CUSTOMIZATION_VIEWS_ACC

Line 5: g_cust_view_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC';

1: PACKAGE BODY CSM_CUSTMZ_VIEWS_EVENT_PKG AS
2: /* $Header: csmeczvb.pls 120.8.12010000.2 2008/10/22 12:44:36 trajasek ship $ */
3:
4: /*** Globals ***/
5: g_cust_view_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC';
6: g_cust_view_table_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS';
7: g_cust_view_seq_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC_S' ;
8: g_cust_view_pk1_name CONSTANT VARCHAR2(30) := 'CUST_VIEW_ID';
9: g_cust_view_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 7: g_cust_view_seq_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC_S' ;

3:
4: /*** Globals ***/
5: g_cust_view_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC';
6: g_cust_view_table_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS';
7: g_cust_view_seq_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS_ACC_S' ;
8: g_cust_view_pk1_name CONSTANT VARCHAR2(30) := 'CUST_VIEW_ID';
9: g_cust_view_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
10: CSM_ACC_PKG.t_publication_item_list('CSM_CUSTOMIZATION_VIEWS');
11:

Line 34: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC

30: --Delete the records that have been removed from the base table
31: SELECT ACC.USER_ID,
32: ACC.CUST_VIEW_ID,
33: ACC.ACCESS_ID
34: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC
35: WHERE NOT EXISTS (SELECT 1
36: FROM CSM_CUSTOMIZATION_VIEWS B
37: WHERE B.CUST_VIEW_ID = ACC.CUST_VIEW_ID)
38: UNION ALL

Line 43: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC,

39: --Delete the records that have been personalized at a "higher" level
40: SELECT ACC.USER_ID,
41: ACC.CUST_VIEW_ID,
42: ACC.ACCESS_ID
43: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC,
44: CSM_CUSTOMIZATION_VIEWS BACC --to get cust_view_key,level_id,level_value for that cust_view_id
45: WHERE BACC.CUST_VIEW_ID=ACC.CUST_VIEW_ID
46: AND EXISTS(SELECT 1
47: FROM CSM_CUSTOMIZATION_VIEWS B,

Line 76: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC

72: CURSOR c_update(b_lastrundate DATE) IS
73: SELECT ACC.USER_ID,
74: ACC.CUST_VIEW_ID,
75: ACC.ACCESS_ID
76: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC
77: WHERE EXISTS
78: (SELECT 1 FROM CSM_CUSTOMIZATION_VIEWS B
79: WHERE B.CUST_VIEW_ID = ACC.CUST_VIEW_ID
80: AND B.LAST_UPDATE_DATE > b_lastrundate );

Line 125: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC

121: AND B1.LEVEL_VALUE=AU.RESPONSIBILITY_ID)
122: )
123: )
124: AND NOT EXISTS (SELECT 1
125: FROM CSM_CUSTOMIZATION_VIEWS_ACC ACC
126: WHERE B.CUST_VIEW_ID = ACC.CUST_VIEW_ID
127: AND AU.USER_ID = ACC.USER_ID );
128:
129:

Line 322: DELETE FROM CSM_CUSTOMIZATION_VIEWS_ACC WHERE USER_ID=p_user_id;

318:
319: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,
320: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
321:
322: DELETE FROM CSM_CUSTOMIZATION_VIEWS_ACC WHERE USER_ID=p_user_id;
323:
324: --insert--
325: OPEN c_insert(p_user_id);
326: FETCH c_insert BULK COLLECT INTO l_tab;