APPS.CSM_AD_SIMPLE_SRCH_EVENT_PKG dependencies on CSM_AD_SIMPLE_SEARCH_VIEW

Line 5: g_ad_simple_sch_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_VIEW';

1: PACKAGE BODY CSM_AD_SIMPLE_SRCH_EVENT_PKG AS
2: /* $Header: csmeassb.pls 120.5 2008/02/22 08:52:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_simple_sch_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC';
5: g_ad_simple_sch_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_VIEW';
6: g_ad_simple_sch_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC_S';
7: g_ad_simple_sch_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH';
8:
9: g_ad_simple_sch_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG';

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

41: CURSOR c_delete IS
42: SELECT ACC.ACCESS_ID,
43: ACC.ID
44: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_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 55: WHERE EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_VIEW B

51: CURSOR c_update(b_lastrundate DATE) IS
52: SELECT ACC.ACCESS_ID,
53: ACC.ID
54: FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
55: WHERE EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_VIEW B
56: WHERE B.ID =ACC.ID
57: AND B.LAST_UPDATE_DATE > b_lastrundate);
58:
59:

Line 63: FROM CSM_AD_SIMPLE_SEARCH_VIEW B

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

Line 83: ID CSM_AD_SIMPLE_SEARCH_VIEW.ID%TYPE

79:
80: TYPE l_conc_rec IS RECORD
81: (
82: ACCESS_ID CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE,
83: ID CSM_AD_SIMPLE_SEARCH_VIEW.ID%TYPE
84: );
85:
86: TYPE l_tab_type IS TABLE OF l_conc_rec
87: INDEX BY BINARY_INTEGER;