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_PAGE_PERZ_DELTA_EVENT_PKG dependencies on CSM_PAGE_PERZ_DELTA_ACC

Line 5: g_page_perz_delta_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC';

1: PACKAGE BODY CSM_PAGE_PERZ_DELTA_EVENT_PKG AS
2: /* $Header: csmeppdb.pls 120.5.12010000.2 2008/10/22 12:43:20 trajasek ship $ */
3:
4: /*** Globals ***/
5: g_page_perz_delta_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC';
6: g_page_perz_delta_table_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
7: g_page_perz_delta_seq_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC_S' ;
8: g_page_perz_delta_pubi_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
9:

Line 7: g_page_perz_delta_seq_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC_S' ;

3:
4: /*** Globals ***/
5: g_page_perz_delta_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC';
6: g_page_perz_delta_table_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
7: g_page_perz_delta_seq_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC_S' ;
8: g_page_perz_delta_pubi_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
9:
10: g_page_perz_delta_pkg_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG';
11: g_page_perz_delta_api_name CONSTANT VARCHAR2(30) := 'REFRESH_PAGE_PERZ_DELTA';

Line 37: FROM CSM_PAGE_PERZ_DELTA_ACC ACC,

33: ACC.DELTA_SERVER_VERSION,
34: ACC.DELTA_CLIENT_VERSION,
35: ACC.FILE_DATA,
36: ACC.USER_ID
37: FROM CSM_PAGE_PERZ_DELTA_ACC ACC,
38: ASG_USER AU
39: WHERE ACC.USER_ID=AU.USER_ID
40: AND AU.USER_ID =AU.OWNER_ID
41: AND EXISTS(SELECT 1

Line 71: FROM CSM_PAGE_PERZ_DELTA_ACC ACC

67: ACC.DELTA_SERVER_VERSION,
68: ACC.DELTA_CLIENT_VERSION,
69: ACC.FILE_DATA,
70: ACC.USER_ID
71: FROM CSM_PAGE_PERZ_DELTA_ACC ACC
72: WHERE NOT EXISTS (SELECT 1 FROM CSM_PAGE_PERZ CPP
73: WHERE CPP.PAGE_PERZ_ID= ACC.PAGE_PERZ_ID)
74: OR
75: NOT EXISTS (SELECT 1 FROM CSM_PAGE_PERZ_DELTA CPPD

Line 93: FROM CSM_PAGE_PERZ_DELTA_ACC ACC,

89: CPPD.DELTA_SERVER_VERSION,
90: CPPD.DELTA_CLIENT_VERSION,
91: CPPD.FILE_DATA,
92: ACC.USER_ID
93: FROM CSM_PAGE_PERZ_DELTA_ACC ACC,
94: CSM_PAGE_PERZ_DELTA CPPD
95: WHERE CPPD.PAGE_PERZ_ID= ACC.PAGE_PERZ_ID
96: AND CPPD.LEVEL_ID = ACC.LEVEL_ID
97: AND CPPD.LEVEL_VALUE = ACC.LEVEL_VALUE

Line 143: FROM CSM_PAGE_PERZ_DELTA_ACC ACC

139: AND CPPD1.LEVEL_ID = 10004
140: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
141: )
142: AND NOT EXISTS (SELECT 1
143: FROM CSM_PAGE_PERZ_DELTA_ACC ACC
144: WHERE ACC.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
145: AND ACC.LEVEL_ID = CPPD.LEVEL_ID
146: AND ACC.LEVEL_VALUE = CPPD.LEVEL_VALUE
147: AND ACC.USER_ID = AU.USER_ID);

Line 150: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL

146: AND ACC.LEVEL_VALUE = CPPD.LEVEL_VALUE
147: AND ACC.USER_ID = AU.USER_ID);
148:
149: CURSOR C_GET_ACCESS_ID IS
150: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL
151: FROM DUAL;
152:
153: TYPE con_rec_type IS RECORD
154: (

Line 155: ACCESS_ID CSM_PAGE_PERZ_DELTA_ACC.ACCESS_ID%TYPE,

151: FROM DUAL;
152:
153: TYPE con_rec_type IS RECORD
154: (
155: ACCESS_ID CSM_PAGE_PERZ_DELTA_ACC.ACCESS_ID%TYPE,
156: PAGE_PERZ_ID CSM_PAGE_PERZ_DELTA.PAGE_PERZ_ID%TYPE,
157: LEVEL_ID CSM_PAGE_PERZ_DELTA.LEVEL_ID%TYPE,
158: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,
159: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,

Line 200: DELETE FROM CSM_PAGE_PERZ_DELTA_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

196: FOR I IN 1..l_tab.COUNT
197: LOOP
198: l_dummy := asg_download.mark_dirty(g_page_perz_delta_pubi_name,l_tab(I).ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );
199:
200: DELETE FROM CSM_PAGE_PERZ_DELTA_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
201: END LOOP;
202:
203: COMMIT;
204:

Line 223: UPDATE CSM_PAGE_PERZ_DELTA_ACC

219: FOR I IN 1..l_tab.COUNT
220: LOOP
221: l_dummy := asg_download.mark_dirty(g_page_perz_delta_pubi_name,l_tab(I).ACCESS_ID,l_tab(I).USER_ID, 'U', sysdate );
222:
223: UPDATE CSM_PAGE_PERZ_DELTA_ACC
224: SET
225: DELTA_FILE_NAME=l_tab(I).DELTA_FILE_NAME,
226: DELTA_FILE_TYPE=l_tab(I).DELTA_FILE_TYPE,
227: DELTA_SERVER_VERSION=l_tab(I).DELTA_SERVER_VERSION,

Line 256: INSERT INTO CSM_PAGE_PERZ_DELTA_ACC

252: OPEN C_GET_ACCESS_ID;
253: FETCH C_GET_ACCESS_ID INTO l_access_id;
254: CLOSE C_GET_ACCESS_ID;
255:
256: INSERT INTO CSM_PAGE_PERZ_DELTA_ACC
257: ( ACCESS_ID,
258: PAGE_PERZ_ID,
259: LEVEL_ID,
260: LEVEL_VALUE,

Line 374: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL

370: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
371: );
372:
373: CURSOR C_GET_ACCESS_ID IS
374: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL
375: FROM DUAL;
376:
377: TYPE con_rec_type IS RECORD
378: (

Line 379: ACCESS_ID CSM_PAGE_PERZ_DELTA_ACC.ACCESS_ID%TYPE,

375: FROM DUAL;
376:
377: TYPE con_rec_type IS RECORD
378: (
379: ACCESS_ID CSM_PAGE_PERZ_DELTA_ACC.ACCESS_ID%TYPE,
380: PAGE_PERZ_ID CSM_PAGE_PERZ_DELTA.PAGE_PERZ_ID%TYPE,
381: LEVEL_ID CSM_PAGE_PERZ_DELTA.LEVEL_ID%TYPE,
382: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,
383: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,

Line 403: DELETE FROM CSM_PAGE_PERZ_DELTA_ACC WHERE USER_ID=p_user_id;

399:
400: CSM_UTIL_PKG.LOG('Entering api REFRESH_USER with user id- '||p_user_id,
401: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
402:
403: DELETE FROM CSM_PAGE_PERZ_DELTA_ACC WHERE USER_ID=p_user_id;
404:
405: --insert--
406: OPEN c_insert(p_user_id);
407: FETCH c_insert BULK COLLECT INTO l_tab;

Line 419: INSERT INTO CSM_PAGE_PERZ_DELTA_ACC

415: OPEN C_GET_ACCESS_ID;
416: FETCH C_GET_ACCESS_ID INTO l_access_id;
417: CLOSE C_GET_ACCESS_ID;
418:
419: INSERT INTO CSM_PAGE_PERZ_DELTA_ACC
420: ( ACCESS_ID,
421: PAGE_PERZ_ID,
422: LEVEL_ID,
423: LEVEL_VALUE,