714:
715: if l_from_party_tab.count > 0 then
716:
717: forall i in 1..l_from_party_tab.count
718: update biv_dbi_activity_sum_f
719: set
720: primary_flag = 'N'
721: , customer_id = l_to_party_tab(i)
722: , last_updated_by = g_user_id
739: ,trunc(p_collect_from_date)+(86399/86400)))
740: ,1);
741:
742: merge
743: into biv_dbi_activity_sum_f a
744: using (
745: select /*+ no_merge cardinality (stg,10) */
746: trunc(audit_date) activity_date
747: , incident_type_id
861: ' to ' ||
862: fnd_date.date_to_displaydt(p_collect_to_date)
863: ,1);
864: insert
865: into biv_dbi_activity_sum_f a
866: ( activity_date
867: , incident_type_id
868: , inventory_item_id
869: , inv_organization_id