APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on CSM_AD_SEARCH_TITLE_ACC

Line 4: g_ad_sch_title_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC';

1: PACKAGE BODY CSM_AD_SRCH_TITLE_EVENT_PKG AS
2: /* $Header: csmeastb.pls 120.5 2008/02/22 08:52:31 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_title_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC';
5: g_ad_sch_title_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_VIEW';
6: g_ad_sch_title_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC_S';
7: g_ad_sch_title_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE';
8:

Line 6: g_ad_sch_title_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC_S';

2: /* $Header: csmeastb.pls 120.5 2008/02/22 08:52:31 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_title_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC';
5: g_ad_sch_title_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_VIEW';
6: g_ad_sch_title_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC_S';
7: g_ad_sch_title_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE';
8:
9: g_ad_sch_title_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_TITLE_EVENT_PKG';
10: g_ad_sch_title_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

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

10: g_ad_sch_title_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_TITLE_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_SEARCH_TITLE_ACC ACC

40:
41: CURSOR c_delete IS
42: SELECT ACC.ACCESS_ID,
43: ACC.SEARCH_TYPE
44: FROM CSM_AD_SEARCH_TITLE_ACC ACC
45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW B
46: WHERE B.SEARCH_TYPE=ACC.SEARCH_TYPE);
47:
48: CURSOR c_update(b_lastrundate DATE) IS

Line 51: FROM CSM_AD_SEARCH_TITLE_ACC ACC

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

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

57: CURSOR c_insert IS
58: SELECT 1 ACCESS_ID,
59: B.SEARCH_TYPE
60: FROM CSM_AD_SEARCH_TITLE_VIEW B
61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_ACC ACC
62: WHERE ACC.SEARCH_TYPE=B.SEARCH_TYPE);
63:
64: CURSOR c_get_access_id IS
65: SELECT CSM_AD_SEARCH_TITLE_ACC_S.NEXTVAL

Line 65: SELECT CSM_AD_SEARCH_TITLE_ACC_S.NEXTVAL

61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_ACC ACC
62: WHERE ACC.SEARCH_TYPE=B.SEARCH_TYPE);
63:
64: CURSOR c_get_access_id IS
65: SELECT CSM_AD_SEARCH_TITLE_ACC_S.NEXTVAL
66: FROM DUAL;
67:
68: CURSOR c_get_user_list IS
69: SELECT USER_ID

Line 77: ACCESS_ID CSM_AD_SEARCH_TITLE_ACC.ACCESS_ID%TYPE,

73:
74:
75: TYPE l_conc_rec IS RECORD
76: (
77: ACCESS_ID CSM_AD_SEARCH_TITLE_ACC.ACCESS_ID%TYPE,
78: SEARCH_TYPE CSM_AD_SEARCH_TITLE_VIEW.SEARCH_TYPE%TYPE
79: );
80:
81: TYPE l_tab_type IS TABLE OF l_conc_rec

Line 128: DELETE FROM CSM_AD_SEARCH_TITLE_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

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

Line 155: UPDATE CSM_AD_SEARCH_TITLE_ACC

151: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
152: l_dummy := asg_download.mark_dirty(g_ad_sch_title_pubi_name,g_access_list,l_user_list, 'U', sysdate );
153: END IF;
154:
155: UPDATE CSM_AD_SEARCH_TITLE_ACC
156: SET
157: LAST_UPDATE_DATE=SYSDATE,
158: LAST_UPDATED_BY=1,
159: LAST_UPDATE_LOGIN=1

Line 185: INSERT INTO CSM_AD_SEARCH_TITLE_ACC

181: OPEN C_GET_ACCESS_ID;
182: FETCH C_GET_ACCESS_ID INTO l_access_id;
183: CLOSE C_GET_ACCESS_ID;
184:
185: INSERT INTO CSM_AD_SEARCH_TITLE_ACC
186: ( ACCESS_ID,
187: SEARCH_TYPE,
188: USER_ID,
189: COUNTER,