DBA Data[Home] [Help]

APPS.CSM_AD_SIMPLE_SRCH_EVENT_PKG dependencies on CSM_AD_SIMPLE_SRCH_EVENT_PKG

Line 1: PACKAGE BODY CSM_AD_SIMPLE_SRCH_EVENT_PKG AS

1: PACKAGE BODY CSM_AD_SIMPLE_SRCH_EVENT_PKG AS
2: /* $Header: csmeassb.pls 120.5 2008/02/22 08:52:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_simple_sch_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC';
5: g_ad_simple_sch_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_VIEW';

Line 9: g_ad_simple_sch_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG';

5: g_ad_simple_sch_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_VIEW';
6: g_ad_simple_sch_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC_S';
7: g_ad_simple_sch_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH';
8:
9: g_ad_simple_sch_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG';
10: g_ad_simple_sch_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
11:
12: g_access_list asg_download.access_list;
13:

Line 103: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 110: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 117: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 125: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

121: FETCH c_delete BULK COLLECT INTO l_tab;
122: CLOSE c_delete;
123:
124: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
125: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
126:
127: FOR I IN 1..l_tab.COUNT
128: LOOP
129: IF l_user_list.COUNT > 0 THEN

Line 139: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 152: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

148: FETCH c_update BULK COLLECT INTO l_tab;
149: CLOSE c_update;
150:
151: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
152: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
153:
154: FOR I IN 1..l_tab.COUNT
155: LOOP
156: IF l_user_list.COUNT > 0 THEN

Line 171: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 182: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 226: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

222: l_tab.DELETE;
223: END IF;
224:
225: CSM_UTIL_PKG.LOG('INSERTION Successful ',
226: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
227:
228: UPDATE JTM_CON_REQUEST_DATA
229: SET LAST_RUN_DATE = SYSDATE
230: WHERE package_name = g_ad_simple_sch_pkg_name

Line 236: p_message := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC executed successfully';

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

Line 239: 'CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

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

Line 246: p_message := 'Error in CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;

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

Line 248: csm_util_pkg.log('CSM_AD_SIMPLE_SRCH_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

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

Line 253: END CSM_AD_SIMPLE_SRCH_EVENT_PKG;

249:
250: END REFRESH_ACC;
251:
252:
253: END CSM_AD_SIMPLE_SRCH_EVENT_PKG;