DBA Data[Home] [Help]

APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG dependencies on CSM_DBOARD_SRCH_COLS_EVENT_PKG

Line 1: PACKAGE BODY CSM_DBOARD_SRCH_COLS_EVENT_PKG AS

1: PACKAGE BODY CSM_DBOARD_SRCH_COLS_EVENT_PKG AS
2: /* $Header: csmedscb.pls 120.2 2008/02/07 10:46:16 anaraman ship $ */
3:
4: /*** Globals ***/
5: g_dboard_sch_cols_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS_ACC';

Line 10: g_dboard_sch_cols_pkg_name CONSTANT VARCHAR2(30) := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG';

6: g_dboard_sch_cols_table_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS';
7: g_dboard_sch_cols_seq_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SRCH_COLS_ACC_S' ;
8: g_dboard_sch_cols_pubi_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS';
9:
10: g_dboard_sch_cols_pkg_name CONSTANT VARCHAR2(30) := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG';
11: g_dboard_sch_cols_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
12:
13: g_access_list asg_download.access_list;
14:

Line 94: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

90:
91: BEGIN
92:
93: CSM_UTIL_PKG.LOG('Entering REFRESH_ACC: ',
94: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
95:
96: OPEN c_lastrundate;
97: FETCH c_lastrundate INTO l_lastrundate;
98: CLOSE c_lastrundate;

Line 101: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

97: FETCH c_lastrundate INTO l_lastrundate;
98: CLOSE c_lastrundate;
99:
100: CSM_UTIL_PKG.LOG('Got LASTRUNDATE ',
101: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
102:
103: OPEN c_get_user_list;
104: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
105: CLOSE c_get_user_list;

Line 108: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

104: FETCH c_get_user_list BULK COLLECT INTO l_user_list;
105: CLOSE c_get_user_list;
106:
107: CSM_UTIL_PKG.LOG('Got USER list : ',
108: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
109:
110: --delete--
111: OPEN c_delete;
112: FETCH c_delete BULK COLLECT INTO l_tab;

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

112: FETCH c_delete BULK COLLECT INTO l_tab;
113: CLOSE c_delete;
114:
115: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
116: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
117:
118: FOR I IN 1..l_tab.COUNT
119: LOOP
120: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);

Line 129: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

125:
126: COMMIT;
127:
128: CSM_UTIL_PKG.LOG('DELETION successful',
129: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
130:
131: l_tab.DELETE;
132:
133:

Line 140: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

136: FETCH c_update BULK COLLECT INTO l_tab;
137: CLOSE c_update;
138:
139: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
140: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
141:
142: FOR I IN 1..l_tab.COUNT
143: LOOP
144: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);

Line 158: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

154:
155: COMMIT;
156:
157: CSM_UTIL_PKG.LOG('UPDATE Successful ',
158: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
159: l_tab.DELETE;
160:
161: --insert--
162: OPEN c_insert;

Line 167: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

163: FETCH c_insert BULK COLLECT INTO l_tab;
164: CLOSE c_insert;
165:
166: CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
167: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
168:
169: FOR I IN 1..l_tab.COUNT
170: LOOP
171: OPEN C_GET_ACCESS_ID;

Line 203: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

199:
200: COMMIT;
201:
202: CSM_UTIL_PKG.LOG('INSERTION Successful ',
203: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
204:
205: UPDATE JTM_CON_REQUEST_DATA
206: SET LAST_RUN_DATE = SYSDATE
207: WHERE package_name = g_dboard_sch_cols_pkg_name

Line 213: p_message := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC executed successfully';

209:
210: COMMIT;
211:
212: p_status := 'FINE';
213: p_message := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC executed successfully';
214:
215: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
216: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
217:

Line 216: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

212: p_status := 'FINE';
213: p_message := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC executed successfully';
214:
215: CSM_UTIL_PKG.LOG('Leaving REFRESH_ACC: ',
216: 'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: l_sqlerrno := TO_CHAR(SQLCODE);

Line 223: p_message := 'Error in CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;

219: WHEN OTHERS THEN
220: l_sqlerrno := TO_CHAR(SQLCODE);
221: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
222: p_status := 'ERROR';
223: p_message := 'Error in CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
224: ROLLBACK;
225: csm_util_pkg.log('CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
226:
227: END REFRESH_ACC;

Line 225: csm_util_pkg.log('CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

221: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
222: p_status := 'ERROR';
223: p_message := 'Error in CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
224: ROLLBACK;
225: csm_util_pkg.log('CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
226:
227: END REFRESH_ACC;
228:
229:

Line 231: END CSM_DBOARD_SRCH_COLS_EVENT_PKG;

227: END REFRESH_ACC;
228:
229:
230:
231: END CSM_DBOARD_SRCH_COLS_EVENT_PKG;