APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on CSM_AD_SEARCH_TITLE_VIEW

Line 5: g_ad_sch_title_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_VIEW';

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:
9: g_ad_sch_title_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_TITLE_EVENT_PKG';

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

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
49: SELECT ACC.ACCESS_ID,

Line 52: WHERE EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW B

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

Line 60: FROM CSM_AD_SEARCH_TITLE_VIEW B

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

Line 78: SEARCH_TYPE CSM_AD_SEARCH_TITLE_VIEW.SEARCH_TYPE%TYPE

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