APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on CSM_AD_SEARCH_RESULT_VIEW

Line 4: g_ad_sch_result_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_RESULT_VIEW';

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:

Line 45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_RESULT_VIEW B

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));
49:

Line 54: WHERE EXISTS (SELECT 1 FROM CSM_AD_SEARCH_RESULT_VIEW B

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:
58:

Line 62: FROM CSM_AD_SEARCH_RESULT_VIEW B

58:
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));

Line 82: ID CSM_AD_SEARCH_RESULT_VIEW.ID%TYPE

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
86: INDEX BY BINARY_INTEGER;