DBA Data[Home] [Help]

APPS.AMS_SETUP_ATTR_PVT dependencies on AMS_LOOKUPS

Line 889: SELECT MEANING FROM AMS_LOOKUPS WHERE LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER' AND LOOKUP_CODE = obj_attr;

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
889: SELECT MEANING FROM AMS_LOOKUPS WHERE LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER' AND LOOKUP_CODE = obj_attr;
890: l_mand_setup_attr_rec c_mand_setup_attr%ROWTYPE;
891: -- End add by cgoyal
892:
893: l_obj VARCHAR2(30) ;

Line 897: l_mand_setup_attr AMS_LOOKUPS.meaning%type;

893: l_obj VARCHAR2(30) ;
894: l_act VARCHAR2(30) ;
895:
896: l_mand_flag VARCHAR2(1);
897: l_mand_setup_attr AMS_LOOKUPS.meaning%type;
898:
899: BEGIN
900: x_return_status := FND_API.g_ret_sts_success;
901: l_mand_setup_attr := NULL;