APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on CSM_AD_SEARCH_RESULT_ACC

Line 5: g_ad_sch_result_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC';

1: PACKAGE BODY CSM_AD_SRCH_RESULT_EVENT_PKG AS
2: /* $Header: csmeaslb.pls 120.5 2008/02/22 08:51:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_result_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_VIEW';
5: g_ad_sch_result_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC';
6: g_ad_sch_result_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC_S';
7: g_ad_sch_result_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT';
8:
9: g_ad_sch_result_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_RESULT_EVENT_PKG';

Line 6: g_ad_sch_result_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC_S';

2: /* $Header: csmeaslb.pls 120.5 2008/02/22 08:51:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_result_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_VIEW';
5: g_ad_sch_result_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC';
6: g_ad_sch_result_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_ACC_S';
7: g_ad_sch_result_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT';
8:
9: g_ad_sch_result_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_RESULT_EVENT_PKG';
10: g_ad_sch_result_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

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

10: g_ad_sch_result_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_RESULT_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_RESULT_ACC ACC

40:
41: CURSOR c_delete IS
42: SELECT ACC.ACCESS_ID,
43: ACC.ID
44: FROM CSM_AD_SEARCH_RESULT_ACC ACC
45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_RESULT_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 53: FROM CSM_AD_SEARCH_RESULT_ACC ACC

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

Line 63: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_RESULT_ACC ACC

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

Line 69: SELECT CSM_AD_SEARCH_RESULT_ACC_S.NEXTVAL

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

Line 81: ACCESS_ID CSM_AD_SEARCH_RESULT_ACC.ACCESS_ID%TYPE,

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

Line 132: DELETE FROM CSM_AD_SEARCH_RESULT_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

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

Line 158: UPDATE CSM_AD_SEARCH_RESULT_ACC

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

Line 188: INSERT INTO CSM_AD_SEARCH_RESULT_ACC

184: OPEN C_GET_ACCESS_ID;
185: FETCH C_GET_ACCESS_ID INTO l_access_id;
186: CLOSE C_GET_ACCESS_ID;
187:
188: INSERT INTO CSM_AD_SEARCH_RESULT_ACC
189: ( ACCESS_ID,
190: ID,
191: USER_ID,
192: COUNTER,