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

Line 1: PACKAGE BODY CSM_PAGE_PERZ_DELTA_EVENT_PKG AS

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';

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

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:
10: g_page_perz_delta_pkg_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG';

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 8: g_page_perz_delta_pubi_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';

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';
12:

Line 10: g_page_perz_delta_pkg_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG';

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';
12:
13:
14:

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 42: FROM CSM_PAGE_PERZ_DELTA CPPD

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
42: FROM CSM_PAGE_PERZ_DELTA CPPD
43: WHERE CPPD.PAGE_PERZ_ID=ACC.PAGE_PERZ_ID
44: AND CPPD.LEVEL_ID<>10001
45: AND (
46: (ACC.LEVEL_ID = 10001

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 75: NOT EXISTS (SELECT 1 FROM CSM_PAGE_PERZ_DELTA CPPD

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
76: WHERE CPPD.PAGE_PERZ_ID= ACC.PAGE_PERZ_ID
77: AND CPPD.LEVEL_ID = ACC.LEVEL_ID
78: AND CPPD.LEVEL_VALUE = ACC.LEVEL_VALUE);
79:

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 94: CSM_PAGE_PERZ_DELTA CPPD

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
98: AND CPPD.LAST_UPDATE_DATE > b_lastrundate ;

Line 114: CSM_PAGE_PERZ_DELTA CPPD,

110: CPPD.DELTA_CLIENT_VERSION,
111: CPPD.FILE_DATA,
112: AU.USER_ID
113: FROM CSM_PAGE_PERZ CPP,
114: CSM_PAGE_PERZ_DELTA CPPD,
115: ASG_USER AU
116: WHERE CPP.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
117: AND AU.USER_ID =AU.OWNER_ID
118: AND ( (CPPD.LEVEL_VALUE = AU.USER_ID

Line 124: FROM CSM_PAGE_PERZ_DELTA CPPD1

120: OR
121: (CPPD.LEVEL_VALUE = AU.RESPONSIBILITY_ID
122: AND CPPD.LEVEL_ID = 10003
123: AND NOT EXISTS (SELECT 1
124: FROM CSM_PAGE_PERZ_DELTA CPPD1
125: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
126: AND CPPD1.LEVEL_ID = 10004
127: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
128: OR

Line 132: FROM CSM_PAGE_PERZ_DELTA CPPD1

128: OR
129: (CPPD.LEVEL_VALUE=0
130: AND CPPD.LEVEL_ID = 10001
131: AND NOT EXISTS (SELECT 1
132: FROM CSM_PAGE_PERZ_DELTA CPPD1
133: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
134: AND CPPD1.LEVEL_ID = 10003
135: AND CPPD1.LEVEL_VALUE= AU.RESPONSIBILITY_ID )
136: AND NOT EXISTS (SELECT 1

Line 137: FROM CSM_PAGE_PERZ_DELTA CPPD1

133: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
134: AND CPPD1.LEVEL_ID = 10003
135: AND CPPD1.LEVEL_VALUE= AU.RESPONSIBILITY_ID )
136: AND NOT EXISTS (SELECT 1
137: FROM CSM_PAGE_PERZ_DELTA CPPD1
138: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
139: AND CPPD1.LEVEL_ID = 10004
140: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
141: )

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 156: PAGE_PERZ_ID CSM_PAGE_PERZ_DELTA.PAGE_PERZ_ID%TYPE,

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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,

Line 157: LEVEL_ID CSM_PAGE_PERZ_DELTA.LEVEL_ID%TYPE,

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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,

Line 158: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,

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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,

Line 159: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,

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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,

Line 160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
164: USER_ID ASG_USER.USER_ID%TYPE

Line 161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%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,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
164: USER_ID ASG_USER.USER_ID%TYPE
165: );

Line 162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,

158: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,
159: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
164: USER_ID ASG_USER.USER_ID%TYPE
165: );
166:

Line 163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,

159: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,
160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
164: USER_ID ASG_USER.USER_ID%TYPE
165: );
166:
167: TYPE l_tab_type IS TABLE OF con_rec_type

Line 180: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

176:
177: BEGIN
178:
179: CSM_UTIL_PKG.LOG('Entering REFRESH_PAGE_PERZ_DELTA: ',
180: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
181:
182: OPEN c_lastrundate;
183: FETCH c_lastrundate INTO l_lastrundate;
184: CLOSE c_lastrundate;

Line 187: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

183: FETCH c_lastrundate INTO l_lastrundate;
184: CLOSE c_lastrundate;
185:
186: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
187: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
188: --delete--
189: OPEN c_delete;
190: FETCH c_delete BULK COLLECT INTO l_tab;
191: CLOSE c_delete;

Line 194: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

190: FETCH c_delete BULK COLLECT INTO l_tab;
191: CLOSE c_delete;
192:
193: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
194: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
195:
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 );

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 206: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

202:
203: COMMIT;
204:
205: CSM_UTIL_PKG.LOG('DELETION successful',
206: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
207:
208: l_tab.DELETE;
209:
210:

Line 217: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

213: FETCH c_update BULK COLLECT INTO l_tab;
214: CLOSE c_update;
215:
216: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
217: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
218:
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 );

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 239: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

235:
236: COMMIT;
237:
238: CSM_UTIL_PKG.LOG('UPDATE Successful ',
239: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
240: l_tab.DELETE;
241:
242: --insert--
243: OPEN c_insert;

Line 248: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

244: FETCH c_insert BULK COLLECT INTO l_tab;
245: CLOSE c_insert;
246:
247: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
248: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
249:
250: FOR I IN 1..l_tab.COUNT
251: LOOP
252: OPEN C_GET_ACCESS_ID;

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 300: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

296:
297: COMMIT;
298:
299: CSM_UTIL_PKG.LOG('INSERTION Successful ',
300: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
301:
302: UPDATE JTM_CON_REQUEST_DATA
303: SET LAST_RUN_DATE = SYSDATE
304: WHERE package_name = g_page_perz_delta_pkg_name

Line 310: p_message := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA executed successfully';

306:
307: COMMIT;
308:
309: p_status := 'FINE';
310: p_message := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA executed successfully';
311:
312: CSM_UTIL_PKG.LOG('Leaving REFRESH_PAGE_PERZ_DELTA: ',
313: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
314:

Line 313: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);

309: p_status := 'FINE';
310: p_message := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA executed successfully';
311:
312: CSM_UTIL_PKG.LOG('Leaving REFRESH_PAGE_PERZ_DELTA: ',
313: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA',FND_LOG.LEVEL_PROCEDURE);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: l_sqlerrno := TO_CHAR(SQLCODE);

Line 320: p_message := 'Error in CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA: ' || l_sqlerrno || ':' || l_sqlerrmsg;

316: WHEN OTHERS THEN
317: l_sqlerrno := TO_CHAR(SQLCODE);
318: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
319: p_status := 'ERROR';
320: p_message := 'Error in CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA: ' || l_sqlerrno || ':' || l_sqlerrmsg;
321: ROLLBACK;
322: csm_util_pkg.log('CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
323:
324: END REFRESH_PAGE_PERZ_DELTA;

Line 322: csm_util_pkg.log('CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

318: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
319: p_status := 'ERROR';
320: p_message := 'Error in CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA: ' || l_sqlerrno || ':' || l_sqlerrmsg;
321: ROLLBACK;
322: csm_util_pkg.log('CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_PAGE_PERZ_DELTA ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
323:
324: END REFRESH_PAGE_PERZ_DELTA;
325:
326: --7239431

Line 343: CSM_PAGE_PERZ_DELTA CPPD,

339: CPPD.DELTA_CLIENT_VERSION,
340: CPPD.FILE_DATA,
341: AU.USER_ID
342: FROM CSM_PAGE_PERZ CPP,
343: CSM_PAGE_PERZ_DELTA CPPD,
344: ASG_USER AU
345: WHERE AU.USER_ID=b_user_id
346: AND AU.USER_ID =AU.OWNER_ID
347: AND CPP.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID

Line 354: FROM CSM_PAGE_PERZ_DELTA CPPD1

350: OR
351: (CPPD.LEVEL_VALUE = AU.RESPONSIBILITY_ID
352: AND CPPD.LEVEL_ID = 10003
353: AND NOT EXISTS (SELECT 1
354: FROM CSM_PAGE_PERZ_DELTA CPPD1
355: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
356: AND CPPD1.LEVEL_ID = 10004
357: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
358: OR

Line 362: FROM CSM_PAGE_PERZ_DELTA CPPD1

358: OR
359: (CPPD.LEVEL_VALUE=0
360: AND CPPD.LEVEL_ID = 10001
361: AND NOT EXISTS (SELECT 1
362: FROM CSM_PAGE_PERZ_DELTA CPPD1
363: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
364: AND CPPD1.LEVEL_ID = 10003
365: AND CPPD1.LEVEL_VALUE= AU.RESPONSIBILITY_ID )
366: AND NOT EXISTS (SELECT 1

Line 367: FROM CSM_PAGE_PERZ_DELTA CPPD1

363: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
364: AND CPPD1.LEVEL_ID = 10003
365: AND CPPD1.LEVEL_VALUE= AU.RESPONSIBILITY_ID )
366: AND NOT EXISTS (SELECT 1
367: FROM CSM_PAGE_PERZ_DELTA CPPD1
368: WHERE CPPD1.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
369: AND CPPD1.LEVEL_ID = 10004
370: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
371: );

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 380: PAGE_PERZ_ID CSM_PAGE_PERZ_DELTA.PAGE_PERZ_ID%TYPE,

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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,

Line 381: LEVEL_ID CSM_PAGE_PERZ_DELTA.LEVEL_ID%TYPE,

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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,

Line 382: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,

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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,

Line 383: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,

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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,

Line 384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
388: USER_ID ASG_USER.USER_ID%TYPE

Line 385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%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,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
388: USER_ID ASG_USER.USER_ID%TYPE
389: );

Line 386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,

382: LEVEL_VALUE CSM_PAGE_PERZ_DELTA.LEVEL_VALUE%TYPE,
383: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
388: USER_ID ASG_USER.USER_ID%TYPE
389: );
390:

Line 387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,

383: DELTA_FILE_NAME CSM_PAGE_PERZ_DELTA.DELTA_FILE_NAME%TYPE,
384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
388: USER_ID ASG_USER.USER_ID%TYPE
389: );
390:
391: TYPE l_tab_type IS TABLE OF con_rec_type

Line 401: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

397:
398: BEGIN
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--

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 411: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

407: FETCH c_insert BULK COLLECT INTO l_tab;
408: CLOSE c_insert;
409:
410: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records for user',
411: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
412:
413: FOR I IN 1..l_tab.COUNT
414: LOOP
415: OPEN C_GET_ACCESS_ID;

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,

Line 461: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);

457:
458: END LOOP;
459:
460: CSM_UTIL_PKG.LOG('INSERTION Successful ',
461: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
462:
463: END REFRESH_USER;
464:
465: END CSM_PAGE_PERZ_DELTA_EVENT_PKG;

Line 465: END CSM_PAGE_PERZ_DELTA_EVENT_PKG;

461: 'CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER',FND_LOG.LEVEL_PROCEDURE);
462:
463: END REFRESH_USER;
464:
465: END CSM_PAGE_PERZ_DELTA_EVENT_PKG;