67: l_tbb_ovn number;
68: l_tat_ovn number;
69: l_time_building_block_id_o number;
70:
71: l_process_id hxc_deposit_processes.deposit_process_id%TYPE;
72:
73: e_process_not_registered exception;
74: e_ovn_not_latest exception;
75:
238: l_time_source_id hxc_time_sources.time_source_id%TYPE := NULL;
239:
240: cursor c_process is
241: select deposit_process_id
242: from hxc_deposit_processes
243: where time_source_id = l_time_source_id
244: and name = p_process_name;
245:
246: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE := NULL;
242: from hxc_deposit_processes
243: where time_source_id = l_time_source_id
244: and name = p_process_name;
245:
246: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE := NULL;
247:
248: begin
249:
250: OPEN csr_get_time_source_id;