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_CUSTMZ_VIEWS_EVENT_PKG dependencies on CSM_CUSTOMIZATION_VIEWS

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 6: g_cust_view_table_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOMIZATION_VIEWS';

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 :=
10: CSM_ACC_PKG.t_publication_item_list('CSM_CUSTOMIZATION_VIEWS');

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 10: CSM_ACC_PKG.t_publication_item_list('CSM_CUSTOMIZATION_VIEWS');

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:
12: g_cust_view_pkg_name CONSTANT VARCHAR2(30) := 'CSM_CUSTMZ_VIEWS_EVENT_PKG';
13: g_cust_view_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
14:

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 36: FROM CSM_CUSTOMIZATION_VIEWS B

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
39: --Delete the records that have been personalized at a "higher" level
40: SELECT ACC.USER_ID,

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 44: CSM_CUSTOMIZATION_VIEWS BACC --to get cust_view_key,level_id,level_value for that cust_view_id

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,
48: ASG_USER AU

Line 47: FROM CSM_CUSTOMIZATION_VIEWS B,

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,
48: ASG_USER AU
49: WHERE B.PAGE_NAME=BACC.PAGE_NAME
50: AND B.REGION_NAME=BACC.REGION_NAME
51: AND B.CUST_VIEW_KEY=BACC.CUST_VIEW_KEY

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 78: (SELECT 1 FROM CSM_CUSTOMIZATION_VIEWS B

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 );
81:
82:

Line 88: FROM CSM_CUSTOMIZATION_VIEWS B,

84: CURSOR c_insert IS
85: SELECT AU.USER_ID,
86: B.CUST_VIEW_ID,
87: 1 ACCESS_ID
88: FROM CSM_CUSTOMIZATION_VIEWS B,
89: ASG_USER AU
90: WHERE AU.USER_ID = AU.OWNER_ID
91: AND (
92: (B.LEVEL_ID=10004 AND B.LEVEL_VALUE = AU.USER_ID)

Line 97: FROM CSM_CUSTOMIZATION_VIEWS B1

93: OR
94: --If perz at resp level, verify that no User level perz exists
95: (B.LEVEL_ID=10003 AND B.LEVEL_VALUE = AU.RESPONSIBILITY_ID
96: AND NOT EXISTS( SELECT 1
97: FROM CSM_CUSTOMIZATION_VIEWS B1
98: WHERE B.PAGE_NAME = B1.PAGE_NAME
99: AND B.REGION_NAME = B1.REGION_NAME
100: AND B.CUST_VIEW_KEY = B1.CUST_VIEW_KEY
101: AND B1.LEVEL_ID = 10004

Line 108: FROM CSM_CUSTOMIZATION_VIEWS B1

104: OR
105: --If perz at site level, verify that no resp and User level perz exists
106: (B.LEVEL_ID=10001 AND B.LEVEL_VALUE=0
107: AND NOT EXISTS( SELECT 1
108: FROM CSM_CUSTOMIZATION_VIEWS B1
109: WHERE B.PAGE_NAME=B1.PAGE_NAME
110: AND B.REGION_NAME=B1.REGION_NAME
111: AND B.CUST_VIEW_KEY=B1.CUST_VIEW_KEY
112: AND B1.LEVEL_ID=10004

Line 116: FROM CSM_CUSTOMIZATION_VIEWS B1

112: AND B1.LEVEL_ID=10004
113: AND B1.LEVEL_VALUE=AU.USER_ID
114: )
115: AND NOT EXISTS( SELECT 1
116: FROM CSM_CUSTOMIZATION_VIEWS B1
117: WHERE B.PAGE_NAME=B1.PAGE_NAME
118: AND B.REGION_NAME=B1.REGION_NAME
119: AND B.CUST_VIEW_KEY=B1.CUST_VIEW_KEY
120: AND B1.LEVEL_ID=10003

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 266: FROM CSM_CUSTOMIZATION_VIEWS B,

262: CURSOR c_insert(b_user_id NUMBER) IS
263: SELECT AU.USER_ID,
264: B.CUST_VIEW_ID,
265: 1 ACCESS_ID
266: FROM CSM_CUSTOMIZATION_VIEWS B,
267: ASG_USER AU
268: WHERE AU.USER_ID = AU.OWNER_ID
269: AND AU.USER_ID = b_user_id
270: AND (

Line 276: FROM CSM_CUSTOMIZATION_VIEWS B1

272: OR
273: --If perz at resp level, verify that no User level perz exists
274: (B.LEVEL_ID=10003 AND B.LEVEL_VALUE = AU.RESPONSIBILITY_ID
275: AND NOT EXISTS( SELECT 1
276: FROM CSM_CUSTOMIZATION_VIEWS B1
277: WHERE B.PAGE_NAME = B1.PAGE_NAME
278: AND B.REGION_NAME = B1.REGION_NAME
279: AND B.CUST_VIEW_KEY = B1.CUST_VIEW_KEY
280: AND B1.LEVEL_ID = 10004

Line 287: FROM CSM_CUSTOMIZATION_VIEWS B1

283: OR
284: --If perz at site level, verify that no resp and User level perz exists
285: (B.LEVEL_ID=10001 AND B.LEVEL_VALUE=0
286: AND NOT EXISTS( SELECT 1
287: FROM CSM_CUSTOMIZATION_VIEWS B1
288: WHERE B.PAGE_NAME=B1.PAGE_NAME
289: AND B.REGION_NAME=B1.REGION_NAME
290: AND B.CUST_VIEW_KEY=B1.CUST_VIEW_KEY
291: AND B1.LEVEL_ID=10004

Line 295: FROM CSM_CUSTOMIZATION_VIEWS B1

291: AND B1.LEVEL_ID=10004
292: AND B1.LEVEL_VALUE=AU.USER_ID
293: )
294: AND NOT EXISTS( SELECT 1
295: FROM CSM_CUSTOMIZATION_VIEWS B1
296: WHERE B.PAGE_NAME=B1.PAGE_NAME
297: AND B.REGION_NAME=B1.REGION_NAME
298: AND B.CUST_VIEW_KEY=B1.CUST_VIEW_KEY
299: AND B1.LEVEL_ID=10003

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;