DBA Data[Home] [Help]

APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on CSM_AD_SRCH_RESULT_EVENT_PKG

Line 1: PACKAGE BODY CSM_AD_SRCH_RESULT_EVENT_PKG AS

1: PACKAGE BODY CSM_AD_SRCH_RESULT_EVENT_PKG AS
2: /* $Header: csmeaslb.pls 120.5 2008/02/22 08:51:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_result_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_VIEW';
5: g_ad_sch_result_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC';

Line 9: g_ad_sch_result_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_RESULT_EVENT_PKG';

5: g_ad_sch_result_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC';
6: g_ad_sch_result_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC_S';
7: g_ad_sch_result_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT';
8:
9: g_ad_sch_result_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_RESULT_EVENT_PKG';
10: g_ad_sch_result_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
11:
12: g_access_list asg_download.access_list;
13:

Line 102: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

98:
99: BEGIN
100:
101: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
102: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
103:
104: OPEN c_lastrundate;
105: FETCH c_lastrundate INTO l_lastrundate;
106: CLOSE c_lastrundate;

Line 109: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

105: FETCH c_lastrundate INTO l_lastrundate;
106: CLOSE c_lastrundate;
107:
108: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
109: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
110:
111: OPEN c_get_user_list;
112: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
113: CLOSE c_get_user_list;

Line 116: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

112: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
113: CLOSE c_get_user_list;
114:
115: CSM_UTIL_PKG.LOG('Got USER list : ',
116: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
117:
118: --delete--
119: OPEN c_delete;
120: FETCH c_delete BULK COLLECT INTO l_tab;

Line 124: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

120: FETCH c_delete BULK COLLECT INTO l_tab;
121: CLOSE c_delete;
122:
123: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
124: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
125:
126: FOR I IN 1..l_tab.COUNT
127: LOOP
128: IF l_user_list.COUNT > 0 THEN --Mark dirty only if there are valid users

Line 138: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

134:
135: COMMIT;
136:
137: CSM_UTIL_PKG.LOG('DELETION successful',
138: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
139: IF l_tab.COUNT > 0 THEN
140: l_tab.DELETE;
141: END IF;
142:

Line 150: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

146: FETCH c_update BULK COLLECT INTO l_tab;
147: CLOSE c_update;
148:
149: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
150: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
151:
152: FOR I IN 1..l_tab.COUNT
153: LOOP
154: IF l_user_list.COUNT > 0 THEN --Mark dirty only if there are valid users

Line 169: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

165:
166: COMMIT;
167:
168: CSM_UTIL_PKG.LOG('UPDATE Successful ',
169: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
170: IF l_tab.COUNT > 0 THEN
171: l_tab.DELETE;
172: END IF;
173:

Line 180: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

176: FETCH c_insert BULK COLLECT INTO l_tab;
177: CLOSE c_insert;
178:
179: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
180: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
181:
182: FOR I IN 1..l_tab.COUNT
183: LOOP
184: OPEN C_GET_ACCESS_ID;

Line 224: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

220:
221: COMMIT;
222:
223: CSM_UTIL_PKG.LOG('INSERTION Successful ',
224: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
225:
226: UPDATE JTM_CON_REQUEST_DATA
227: SET LAST_RUN_DATE = SYSDATE
228: WHERE package_name = g_ad_sch_result_pkg_name

Line 234: p_message := 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC executed successfully';

230:
231: COMMIT;
232:
233: p_status := 'FINE';
234: p_message := 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC executed successfully';
235:
236: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
237: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
238:

Line 237: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

233: p_status := 'FINE';
234: p_message := 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC executed successfully';
235:
236: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
237: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: l_sqlerrno := TO_CHAR(SQLCODE);

Line 244: p_message := 'Error in CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;

240: WHEN OTHERS THEN
241: l_sqlerrno := TO_CHAR(SQLCODE);
242: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
243: p_status := 'ERROR';
244: p_message := 'Error in CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
245: ROLLBACK;
246: csm_util_pkg.log('CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
247:
248: END REFRESH_ACC;

Line 246: csm_util_pkg.log('CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

242: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
243: p_status := 'ERROR';
244: p_message := 'Error in CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
245: ROLLBACK;
246: csm_util_pkg.log('CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
247:
248: END REFRESH_ACC;
249:
250:

Line 251: END CSM_AD_SRCH_RESULT_EVENT_PKG;

247:
248: END REFRESH_ACC;
249:
250:
251: END CSM_AD_SRCH_RESULT_EVENT_PKG;
252: