So far i figured out what were the data still referenced
There were records in the table acs_objects that have in their acs_objects.context_id the object_id of the package i wanted to uninstall.
That is why i got the constraint error.
I looked at their acs_objects.object_type and their values were "cr_item_child_rel" which took me to look at table cr_child_rels.
Then i wrote the query
DELETE FROM cr_child_rels WHERE parent_id = video_object_id;
After that i removed the remaining two records from acs_objects
DELETE FROM acs_objects WHERE context_id = video_object_id;
and Voila! I was able to uninstall my package.
Now, i wonder why these "cr_item_child_rel" records were not removed from acs_objects when i used plpsql functions properly to delete references from cr_items, cr_revisions as well as acs_objects.
Furthermore, I haven't found any plpsql function that treats the data and its references from the table cr_child_rels.
does anyone have a clue what i am talking about? 😊
cheers,