DBA Data[Home] [Help]

APPS.AME_ACTION_PKG dependencies on AME_ACTION_TYPES_VL

Line 182: name ame_action_types_vl.user_action_type_name%type;

178: raise;
179: return(null);
180: end getActionTypeMaxOrderNumber;
181: function getActionTypeName(actionTypeIdIn in integer) return varchar2 as
182: name ame_action_types_vl.user_action_type_name%type;
183: begin
184: if(actionTypeIdIn = ame_util.nullInsertionActionTypeId) then
185: return('no action type');
186: end if;

Line 189: from ame_action_types_vl

185: return('no action type');
186: end if;
187: select user_action_type_name
188: into name
189: from ame_action_types_vl
190: where
191: action_type_id = actionTypeIdIn and
192: sysdate between start_date and
193: nvl(end_date - ame_util.oneSecond, sysdate) ;