APPS.AME_ACTION_API dependencies on AME_ACTIONS

Line 1112: l_description ame_actions.description%TYPE;

1108: l_object_version_number number;
1109: l_start_date date;
1110: l_end_date date;
1111: l_language_code fnd_languages.language_code%TYPE;
1112: l_description ame_actions.description%TYPE;
1113: l_action_type_name ame_action_types.name%TYPE;
1114: l_approver varchar2(100);
1115: --
1116: begin

Line 1164: -- insert the row in ame_actions

1160: fnd_message.set_name('PER', 'AME_400616_SUB_ACT_DESC');
1161: fnd_message.set_token('APPROVER', l_approver);
1162: l_description := fnd_message.get;
1163: end if;
1164: -- insert the row in ame_actions
1165: ame_act_ins.ins(p_effective_date => l_effective_date,
1166: p_action_type_id => p_action_type_id,
1167: p_parameter => p_parameter,
1168: p_parameter_two => p_parameter_two,

Line 1547: l_description ame_actions.description%TYPE;

1543: l_object_version_number number;
1544: l_start_date date;
1545: l_end_date date;
1546: l_language_code fnd_languages.language_code%TYPE;
1547: l_description ame_actions.description%TYPE;
1548: l_action_type_name ame_action_types.name%TYPE;
1549: l_approver varchar2(100);
1550: --
1551: begin

Line 1723: from ame_actions

1719: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
1720: cursor actions_cur(p_action_type_id in number,
1721: p_effective_date in date) is
1722: select action_id, object_version_number
1723: from ame_actions
1724: where
1725: action_type_id = p_action_type_id
1726: and p_effective_date
1727: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

Line 1732: ,ame_actions actions

1728: cursor rule_usage_cur(p_action_type_id in number,
1729: p_effective_date in date) is
1730: select count(*)
1731: from ame_action_usages ruleUsages
1732: ,ame_actions actions
1733: ,ame_action_types actionTypes
1734: where ruleUsages.action_id = actions.action_id
1735: and actions.action_type_id = actionTypes.action_type_id
1736: and actionTypes.action_type_id = p_action_type_id