APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on CSM_AD_SEARCH_REGION_ACC

Line 4: g_ad_sch_region_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC';

1: PACKAGE BODY CSM_AD_SRCH_REGION_EVENT_PKG AS
2: /* $Header: csmeasrb.pls 120.5 2008/02/22 08:51:32 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_region_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC';
5: g_ad_sch_region_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_VIEW';
6: g_ad_sch_region_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC_S' ;
7: g_ad_sch_region_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION';
8:

Line 6: g_ad_sch_region_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC_S' ;

2: /* $Header: csmeasrb.pls 120.5 2008/02/22 08:51:32 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_region_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC';
5: g_ad_sch_region_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_VIEW';
6: g_ad_sch_region_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC_S' ;
7: g_ad_sch_region_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION';
8:
9: g_ad_sch_region_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_REGION_EVENT_PKG';
10: g_ad_sch_region_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

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

10: g_ad_sch_region_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_SEARCH_REGION_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS
17: BEGIN
18: IF g_access_list.COUNT >0 THEN

Line 42: FROM CSM_AD_SEARCH_REGION_ACC ACC

38:
39: CURSOR c_delete IS
40: SELECT ACC.ACCESS_ID,
41: ACC.ID
42: FROM CSM_AD_SEARCH_REGION_ACC ACC
43: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_VIEW B
44: WHERE B.ID=ACC.ID
45: AND EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
46: WHERE C.ID= B.SEARCH_TYPE_ID));

Line 51: FROM CSM_AD_SEARCH_REGION_ACC ACC

47:
48: CURSOR c_update(b_lastrundate DATE) IS
49: SELECT ACC.ACCESS_ID,
50: ACC.ID
51: FROM CSM_AD_SEARCH_REGION_ACC ACC
52: WHERE EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_VIEW B
53: WHERE B.ID=ACC.ID
54: AND B.LAST_UPDATE_DATE > b_lastrundate);
55:

Line 61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_ACC ACC

57: CURSOR c_insert IS
58: SELECT 1 ACCESS_ID,
59: B.ID
60: FROM CSM_AD_SEARCH_REGION_VIEW B
61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_ACC ACC
62: WHERE ACC.ID=B.ID
63: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
64: WHERE C.ID= B.SEARCH_TYPE_ID));
65:

Line 67: SELECT CSM_AD_SEARCH_REGION_ACC_S.NEXTVAL

63: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
64: WHERE C.ID= B.SEARCH_TYPE_ID));
65:
66: CURSOR c_get_access_id IS
67: SELECT CSM_AD_SEARCH_REGION_ACC_S.NEXTVAL
68: FROM DUAL;
69:
70: CURSOR c_get_user_list IS
71: SELECT USER_ID

Line 79: ACCESS_ID CSM_AD_SEARCH_REGION_ACC.ACCESS_ID%TYPE,

75:
76:
77: TYPE l_conc_rec IS RECORD
78: (
79: ACCESS_ID CSM_AD_SEARCH_REGION_ACC.ACCESS_ID%TYPE,
80: ID CSM_AD_SEARCH_REGION_VIEW.ID%TYPE
81: );
82:
83: TYPE l_tab_type IS TABLE OF l_conc_rec

Line 130: DELETE FROM CSM_AD_SEARCH_REGION_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

126: IF l_user_list.COUNT > 0 THEN --Do Mark dirty only if there are valid users
127: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
128: l_dummy := asg_download.mark_dirty(g_ad_sch_region_pubi_name ,g_access_list,l_user_list, 'D', sysdate );
129: END IF;
130: DELETE FROM CSM_AD_SEARCH_REGION_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
131: END LOOP;
132:
133: COMMIT;
134:

Line 156: UPDATE CSM_AD_SEARCH_REGION_ACC

152: IF l_user_list.COUNT > 0 THEN --Do Mark dirty only if there are valid users
153: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
154: l_dummy := asg_download.mark_dirty(g_ad_sch_region_pubi_name ,g_access_list,l_user_list, 'U', sysdate );
155: END IF;
156: UPDATE CSM_AD_SEARCH_REGION_ACC
157: SET
158: LAST_UPDATE_DATE=SYSDATE,
159: LAST_UPDATED_BY=1,
160: LAST_UPDATE_LOGIN=1

Line 186: INSERT INTO CSM_AD_SEARCH_REGION_ACC

182: OPEN C_GET_ACCESS_ID;
183: FETCH C_GET_ACCESS_ID INTO l_access_id;
184: CLOSE C_GET_ACCESS_ID;
185:
186: INSERT INTO CSM_AD_SEARCH_REGION_ACC
187: ( ACCESS_ID,
188: ID,
189: USER_ID,
190: COUNTER,