Suppose ChildTable has a foreign key reference to ParentTable with the
constraint ON DELETE CASCADE. Is there any way to distinguish between
the deletion of a row in ChildTable as a result of executing:

DELETE FROM ChildTable WHERE......

and the deletion of a row in ChildTable as a result of a delete
cascaded from ParentTable?

I've not used this feature, but I wonder if you could use a field on a
record (header or detail) to communicate the source of the event.