APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on CSM_AD_SEARCH_RESULT_ACC_S

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