APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on CSM_AD_SEARCH_REGION_ACC_S

Line 6: g_ad_sch_region_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC_S' ;

2: /* $Header: csmeasrb.pls 120.5 2008/02/22 08:51:32 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_region_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC';
5: g_ad_sch_region_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_VIEW';
6: g_ad_sch_region_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION_ACC_S' ;
7: g_ad_sch_region_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_REGION';
8:
9: g_ad_sch_region_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_REGION_EVENT_PKG';
10: g_ad_sch_region_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

Line 67: SELECT CSM_AD_SEARCH_REGION_ACC_S.NEXTVAL

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