DBA Data[Home] [Help]

APPS.CSM_PAGE_PERZ_DELTA_EVENT_PKG dependencies on CSM_PAGE_PERZ_DELTA_ACC_S

Line 7: g_page_perz_delta_seq_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC_S' ;

3:
4: /*** Globals ***/
5: g_page_perz_delta_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC';
6: g_page_perz_delta_table_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
7: g_page_perz_delta_seq_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_ACC_S' ;
8: g_page_perz_delta_pubi_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA';
9:
10: g_page_perz_delta_pkg_name CONSTANT VARCHAR2(30) := 'CSM_PAGE_PERZ_DELTA_EVENT_PKG';
11: g_page_perz_delta_api_name CONSTANT VARCHAR2(30) := 'REFRESH_PAGE_PERZ_DELTA';

Line 150: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL

146: AND ACC.LEVEL_VALUE = CPPD.LEVEL_VALUE
147: AND ACC.USER_ID = AU.USER_ID);
148:
149: CURSOR C_GET_ACCESS_ID IS
150: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL
151: FROM DUAL;
152:
153: TYPE con_rec_type IS RECORD
154: (

Line 374: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL

370: AND CPPD1.LEVEL_VALUE= AU.USER_ID ))
371: );
372:
373: CURSOR C_GET_ACCESS_ID IS
374: SELECT CSM_PAGE_PERZ_DELTA_ACC_S.NEXTVAL
375: FROM DUAL;
376:
377: TYPE con_rec_type IS RECORD
378: (