748: -- For Passing the privileges information to UDA API.
749: -------------------------------------------------------------
750: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
751: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
752: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
753: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
754: l_privilege_predicate_api_name VARCHAR2(250);
755: l_security_for_validate VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N') ;
756:
749: -------------------------------------------------------------
750: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
751: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
752: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
753: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
754: l_privilege_predicate_api_name VARCHAR2(250);
755: l_security_for_validate VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N') ;
756:
757:
799: IF l_security_for_validate = 'Y' THEN
800: l_privilege_predicate_api_name := 'RRS_BULKLOAD_ENTITIES.Get_Site_Security_Predicate';
801:
802: -- creating default privileges
803: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
804: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
805:
806: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(71802, NULL);
807: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(71802, NULL);
800: l_privilege_predicate_api_name := 'RRS_BULKLOAD_ENTITIES.Get_Site_Security_Predicate';
801:
802: -- creating default privileges
803: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
804: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
805:
806: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(71802, NULL);
807: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(71802, NULL);
808: