APPS.CSM_AD_SIMPLE_SRCH_EVENT_PKG dependencies on CSM_AD_SIMPLE_SEARCH_ACC

Line 4: g_ad_simple_sch_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC';

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

Line 6: g_ad_simple_sch_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC_S';

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

Line 14: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE ,

10: g_ad_simple_sch_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
11:
12: g_access_list asg_download.access_list;
13:
14: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS
17: BEGIN
18: IF g_access_list.COUNT > 0 THEN

Line 44: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC

40:
41: CURSOR c_delete IS
42: SELECT ACC.ACCESS_ID,
43: ACC.ID
44: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_VIEW B
46: WHERE B.ID=ACC.ID
47: AND EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
48: WHERE C.ID= B.SEARCH_TYPE_ID));

Line 54: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC

50:
51: CURSOR c_update(b_lastrundate DATE) IS
52: SELECT ACC.ACCESS_ID,
53: ACC.ID
54: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
55: WHERE EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_VIEW B
56: WHERE B.ID =ACC.ID
57: AND B.LAST_UPDATE_DATE > b_lastrundate);
58:

Line 64: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_ACC ACC

60: CURSOR c_insert IS
61: SELECT 1 ACCESS_ID,
62: B.ID
63: FROM CSM_AD_SIMPLE_SEARCH_VIEW B
64: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
65: WHERE ACC.ID=B.ID
66: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
67: WHERE C.ID= B.SEARCH_TYPE_ID));
68:

Line 70: SELECT CSM_AD_SIMPLE_SEARCH_ACC_S.NEXTVAL

66: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
67: WHERE C.ID= B.SEARCH_TYPE_ID));
68:
69: CURSOR c_get_access_id IS
70: SELECT CSM_AD_SIMPLE_SEARCH_ACC_S.NEXTVAL
71: FROM DUAL;
72:
73: CURSOR c_get_user_list IS
74: SELECT AU.USER_ID

Line 82: ACCESS_ID CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE,

78:
79:
80: TYPE l_conc_rec IS RECORD
81: (
82: ACCESS_ID CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE,
83: ID CSM_AD_SIMPLE_SEARCH_VIEW.ID%TYPE
84: );
85:
86: TYPE l_tab_type IS TABLE OF l_conc_rec

Line 133: DELETE FROM CSM_AD_SIMPLE_SEARCH_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

129: IF l_user_list.COUNT > 0 THEN
130: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
131: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'D', sysdate );
132: END IF;
133: DELETE FROM CSM_AD_SIMPLE_SEARCH_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
134: END LOOP;
135:
136: COMMIT;
137:

Line 160: UPDATE CSM_AD_SIMPLE_SEARCH_ACC

156: IF l_user_list.COUNT > 0 THEN
157: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
158: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'U', sysdate );
159: END IF;
160: UPDATE CSM_AD_SIMPLE_SEARCH_ACC
161: SET
162: LAST_UPDATE_DATE=SYSDATE,
163: LAST_UPDATED_BY=1,
164: LAST_UPDATE_LOGIN=1

Line 190: INSERT INTO CSM_AD_SIMPLE_SEARCH_ACC

186: OPEN C_GET_ACCESS_ID;
187: FETCH C_GET_ACCESS_ID INTO l_access_id;
188: CLOSE C_GET_ACCESS_ID;
189:
190: INSERT INTO CSM_AD_SIMPLE_SEARCH_ACC
191: ( ACCESS_ID,
192: ID,
193: USER_ID,
194: COUNTER,