DBA Data[Home] [Help]

APPS.AME_TEST_UTILITY_PKG dependencies on AME_ACTION_TYPES_VL

Line 30: actionTypeName ame_action_types_vl.user_action_type_name%type;

26: return sqlerrm || ' ';
27: end;
28: --+
29: function getActionTypeName(actionTypeIdIn in integer) return varchar2 as
30: actionTypeName ame_action_types_vl.user_action_type_name%type;
31: begin
32: if (actionTypeIdIn = -1) then
33: return ame_util.getMessage('PER','AME_400637_TEXT_NONE');
34: end if;

Line 37: from ame_action_types_vl

33: return ame_util.getMessage('PER','AME_400637_TEXT_NONE');
34: end if;
35: select user_action_type_name
36: into actionTypeName
37: from ame_action_types_vl
38: where action_type_id = actionTypeIdIn
39: and sysdate between start_date
40: and nvl(end_date - ame_util.oneSecond, sysdate);
41: return actionTypeName;

Line 53: actionTypeName ame_action_types_vl.user_action_type_name%type;

49: return actionTypeName;
50: end getActionTypeName;
51: --+
52: function getApproverGroupName(groupIdIn in integer) return varchar2 as
53: actionTypeName ame_action_types_vl.user_action_type_name%type;
54: begin
55: select user_approval_group_name
56: into actionTypeName
57: from ame_approval_groups_vl