DBA Data[Home] [Help]

APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on DUAL

Line 56: select csm_bus_processes_acc_s.nextval FROM dual;

52: AND bpr.business_process_id = bpt.business_process_id
53: AND bpr.field_service_flag = 'Y');
54:
55: CURSOR l_access_id_csr IS
56: select csm_bus_processes_acc_s.nextval FROM dual;
57:
58:
59: l_mark_dirty boolean;
60: l_bpr_last_update_date CS_BUSINESS_PROCESSES.LAST_UPDATE_DATE%TYPE;

Line 190: --select csm_bus_processes_acc_s.nextval into l_access_id FROM dual;

186:
187: --generate access_id
188: -- l_access_id := csm_util_pkg.generate_numpk_fromstr(to_char(l_business_process_id) || '.' || to_char(l_transaction_type_id));
189: -- get access_id from seq
190: --select csm_bus_processes_acc_s.nextval into l_access_id FROM dual;
191:
192: OPEN l_access_id_csr ;
193: FETCH l_access_id_csr INTO l_access_id;
194: CLOSE l_access_id_csr;