APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG dependencies on CSM_DASHBOARD_SEARCH_COLS

Line 5: g_dboard_sch_cols_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS_ACC';

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

Line 6: g_dboard_sch_cols_table_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS';

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

Line 8: g_dboard_sch_cols_pubi_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS';

4: /*** Globals ***/
5: g_dboard_sch_cols_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_DASHBOARD_SEARCH_COLS_ACC';
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:

Line 15: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE ,

11: g_dboard_sch_cols_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
12:
13: g_access_list asg_download.access_list;
14:
15: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE ,
16: p_count IN NUMBER)
17: IS
18: BEGIN
19: g_access_list.DELETE;

Line 41: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC

37:
38: CURSOR c_delete IS
39: SELECT ACC.ACCESS_ID,
40: ACC.COLUMN_NAME
41: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
42: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B
43: WHERE B.COLUMN_NAME=ACC.COLUMN_NAME);
44:
45: CURSOR c_update(b_lastrundate DATE) IS

Line 42: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B

38: CURSOR c_delete IS
39: SELECT ACC.ACCESS_ID,
40: ACC.COLUMN_NAME
41: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
42: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B
43: WHERE B.COLUMN_NAME=ACC.COLUMN_NAME);
44:
45: CURSOR c_update(b_lastrundate DATE) IS
46: SELECT ACC.ACCESS_ID,

Line 48: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC

44:
45: CURSOR c_update(b_lastrundate DATE) IS
46: SELECT ACC.ACCESS_ID,
47: ACC.COLUMN_NAME
48: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
49: WHERE EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B
50: WHERE B.COLUMN_NAME=ACC.COLUMN_NAME
51: AND B.LAST_UPDATE_DATE > b_lastrundate);
52:

Line 49: WHERE EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B

45: CURSOR c_update(b_lastrundate DATE) IS
46: SELECT ACC.ACCESS_ID,
47: ACC.COLUMN_NAME
48: FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
49: WHERE EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS B
50: WHERE B.COLUMN_NAME=ACC.COLUMN_NAME
51: AND B.LAST_UPDATE_DATE > b_lastrundate);
52:
53:

Line 57: FROM CSM_DASHBOARD_SEARCH_COLS B

53:
54: CURSOR c_insert IS
55: SELECT 1 ACCESS_ID,
56: B.COLUMN_NAME
57: FROM CSM_DASHBOARD_SEARCH_COLS B
58: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
59: WHERE ACC.COLUMN_NAME=B.COLUMN_NAME);
60:
61: CURSOR c_get_access_id IS

Line 58: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC

54: CURSOR c_insert IS
55: SELECT 1 ACCESS_ID,
56: B.COLUMN_NAME
57: FROM CSM_DASHBOARD_SEARCH_COLS B
58: WHERE NOT EXISTS (SELECT 1 FROM CSM_DASHBOARD_SEARCH_COLS_ACC ACC
59: WHERE ACC.COLUMN_NAME=B.COLUMN_NAME);
60:
61: CURSOR c_get_access_id IS
62: SELECT CSM_DASHBOARD_SRCH_COLS_ACC_S.NEXTVAL

Line 73: ACCESS_ID CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE,

69:
70:
71: TYPE l_conc_rec IS RECORD
72: (
73: ACCESS_ID CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE,
74: COLUMN_NAME CSM_DASHBOARD_SEARCH_COLS.COLUMN_NAME%TYPE
75: );
76:
77: TYPE l_tab_type IS TABLE OF l_conc_rec

Line 74: COLUMN_NAME CSM_DASHBOARD_SEARCH_COLS.COLUMN_NAME%TYPE

70:
71: TYPE l_conc_rec IS RECORD
72: (
73: ACCESS_ID CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE,
74: COLUMN_NAME CSM_DASHBOARD_SEARCH_COLS.COLUMN_NAME%TYPE
75: );
76:
77: TYPE l_tab_type IS TABLE OF l_conc_rec
78: INDEX BY BINARY_INTEGER;

Line 123: DELETE FROM CSM_DASHBOARD_SEARCH_COLS_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

119: LOOP
120: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
121: l_dummy := asg_download.mark_dirty(g_dboard_sch_cols_pubi_name,g_access_list,l_user_list, 'D', sysdate );
122:
123: DELETE FROM CSM_DASHBOARD_SEARCH_COLS_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
124: END LOOP;
125:
126: COMMIT;
127:

Line 147: UPDATE CSM_DASHBOARD_SEARCH_COLS_ACC

143: LOOP
144: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
145: l_dummy := asg_download.mark_dirty(g_dboard_sch_cols_pubi_name,g_access_list,l_user_list, 'U', sysdate );
146:
147: UPDATE CSM_DASHBOARD_SEARCH_COLS_ACC
148: SET
149: LAST_UPDATE_DATE=SYSDATE,
150: LAST_UPDATED_BY=1,
151: LAST_UPDATE_LOGIN=1

Line 175: INSERT INTO CSM_DASHBOARD_SEARCH_COLS_ACC

171: OPEN C_GET_ACCESS_ID;
172: FETCH C_GET_ACCESS_ID INTO l_access_id;
173: CLOSE C_GET_ACCESS_ID;
174:
175: INSERT INTO CSM_DASHBOARD_SEARCH_COLS_ACC
176: ( ACCESS_ID,
177: COLUMN_NAME,
178: CREATED_BY,
179: CREATION_DATE,