[Home] [Help]
802: g_sub_loc := 'Get_Next_Batch_Id';
803: -- l_batch_id := get_next_batch_id;
804:
805: -- create a batch first
806: pay_batch_element_entry_api.create_batch_header (
807: p_session_date=> g_sysdatetime,
808: p_batch_name=> to_char(sysdate, 'DD-MM-RRRR HH24:MI:SS'),
809: p_batch_status=> 'U',
810: p_business_group_id=> g_bus_group_id,
824: g_autogen_error
825: );
826: g_sub_loc := 'INSERT INTO pay_batch_headers';
827: --update the batch name
828: pay_batch_element_entry_api.update_batch_header (
829: p_session_date=> g_sysdatetime,
830: p_batch_id=> l_batch_id,
831: p_object_version_number=> l_object_version_number,
832: p_action_if_exists=> 'I',
883: Open c_ovn;
884: Fetch c_ovn into l_object_version_number;
885: Close c_ovn;
886:
887: pay_batch_element_entry_api.update_batch_header (
888: p_session_date => g_sysdatetime,
889: p_batch_id=> l_batch_id,
890: p_batch_reference=> a_reference_num,
891: p_object_version_number => l_object_version_number