840: --
841: -- History
842: -- 12/1/1999 julou created
843: -- 29-Dec-2000 ptendulk 1.Added Additional cursor to get the object details
844: -- from ams_custom_setups_vl
845: -- 2.Check Mandatory flag for object type and activity
846: -- type
847: -- 19-OCT-2001 julou modified. fix for bug 2064453
848: -- added cursor to check mandatory flag for setup with
880:
881: -- Following code is added by ptendulk on 29 Dec
882: CURSOR c_cus_det IS
883: SELECT object_type,activity_type_code
884: FROM ams_custom_setups_vl
885: WHERE custom_setup_id = p_setup_attr_rec.custom_setup_id ;
886:
887: -- Added by cgoyal on 06/Feb/2002 for bugfix 2178381
888: CURSOR c_mand_setup_attr (obj_attr IN VARCHAR2) IS