eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ACTION_API dependencies on AME_UTIL

Line 21: nvl(end_date - ame_util.oneSecond, sysdate);

17: where
18: action_type_id = p_action_type_id and
19: application_id = p_ame_application_id and
20: sysdate between start_date and
21: nvl(end_date - ame_util.oneSecond, sysdate);
22: return(l_order_number);
23: exception
24: when others then
25: hr_utility.set_location(' Leaving:'||l_proc, 60);

Line 42: nvl(end_date - ame_util.oneSecond, sysdate);

38: from ame_action_type_usages
39: where
40: action_type_id = p_action_type_id and
41: sysdate between start_date and
42: nvl(end_date - ame_util.oneSecond, sysdate);
43: if(l_temp_count > 1) then
44: /* authority and exception rule types are mapped to the action type */
45: /* return chain of authority */
46: return(ame_util.authorityRuleType);

Line 46: return(ame_util.authorityRuleType);

42: nvl(end_date - ame_util.oneSecond, sysdate);
43: if(l_temp_count > 1) then
44: /* authority and exception rule types are mapped to the action type */
45: /* return chain of authority */
46: return(ame_util.authorityRuleType);
47: else
48: select rule_type
49: into l_rule_type
50: from ame_action_type_usages

Line 54: nvl(end_date - ame_util.oneSecond, sysdate);

50: from ame_action_type_usages
51: where
52: action_type_id = p_action_type_id and
53: sysdate between start_date and
54: nvl(end_date - ame_util.oneSecond, sysdate);
55: return(l_rule_type);
56: end if;
57: exception
58: when others then

Line 83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

79: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
80: ame_action_type_config.application_id = p_ame_application_id and
81: ame_action_type_usages.rule_type = l_rule_type and
82: sysdate between ame_action_type_config.start_date and
83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

Line 85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

81: ame_action_type_usages.rule_type = l_rule_type and
82: sysdate between ame_action_type_config.start_date and
83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
88: return(l_order_number);
89: exception

Line 87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
88: return(l_order_number);
89: exception
90: when others then
91: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

113: ame_action_type_config.application_id = p_ame_application_id and
114: ame_action_type_config.order_number = p_order_number and
115: ame_action_type_usages.rule_type = l_rule_type and
116: sysdate between ame_action_type_config.start_date and
117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

Line 119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

115: ame_action_type_usages.rule_type = l_rule_type and
116: sysdate between ame_action_type_config.start_date and
117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
122: if(l_temp_count > 1) then
123: return(false);

Line 121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
122: if(l_temp_count > 1) then
123: return(false);
124: else
125: return(true);

Line 154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

150: ame_action_type_config.application_id = p_ame_application_id and
151: ame_action_type_config.order_number > p_order_number and
152: ame_action_type_usages.rule_type = p_rule_type and
153: sysdate between ame_action_type_config.start_date and
154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

152: ame_action_type_usages.rule_type = p_rule_type and
153: sysdate between ame_action_type_config.start_date and
154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';

Line 158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;

Line 161: l_action_type_ids ame_util.idList;

157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;
163: l_acf_object_version_numbers ame_util.idList;
164: l_aty_object_version_numbers ame_util.idList;
165: l_rule_type number;

Line 162: l_order_numbers ame_util.idList;

158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;
163: l_acf_object_version_numbers ame_util.idList;
164: l_aty_object_version_numbers ame_util.idList;
165: l_rule_type number;
166: l_effective_date date;

Line 163: l_acf_object_version_numbers ame_util.idList;

159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;
163: l_acf_object_version_numbers ame_util.idList;
164: l_aty_object_version_numbers ame_util.idList;
165: l_rule_type number;
166: l_effective_date date;
167: l_acf_object_version_number number;

Line 164: l_aty_object_version_numbers ame_util.idList;

160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;
163: l_acf_object_version_numbers ame_util.idList;
164: l_aty_object_version_numbers ame_util.idList;
165: l_rule_type number;
166: l_effective_date date;
167: l_acf_object_version_number number;
168: l_aty_object_version_number number;

Line 228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

224: ame_action_type_config.action_type_id <> p_action_type_id and
225: ame_action_type_config.order_number >= p_order_number and
226: ame_action_type_usages.rule_type = p_rule_type and
227: sysdate between ame_action_type_config.start_date and
228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

226: ame_action_type_usages.rule_type = p_rule_type and
227: sysdate between ame_action_type_config.start_date and
228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';

Line 232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;
236: l_action_type_ids ame_util.idList;

Line 236: l_action_type_ids ame_util.idList;

232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;
236: l_action_type_ids ame_util.idList;
237: l_acf_object_version_numbers ame_util.idList;
238: l_aty_object_version_numbers ame_util.idList;
239: l_order_numbers ame_util.idList;
240: l_rule_type integer;

Line 237: l_acf_object_version_numbers ame_util.idList;

233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;
236: l_action_type_ids ame_util.idList;
237: l_acf_object_version_numbers ame_util.idList;
238: l_aty_object_version_numbers ame_util.idList;
239: l_order_numbers ame_util.idList;
240: l_rule_type integer;
241: l_acf_object_version_number number;

Line 238: l_aty_object_version_numbers ame_util.idList;

234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;
236: l_action_type_ids ame_util.idList;
237: l_acf_object_version_numbers ame_util.idList;
238: l_aty_object_version_numbers ame_util.idList;
239: l_order_numbers ame_util.idList;
240: l_rule_type integer;
241: l_acf_object_version_number number;
242: l_aty_object_version_number number;

Line 239: l_order_numbers ame_util.idList;

235: l_effective_date date;
236: l_action_type_ids ame_util.idList;
237: l_acf_object_version_numbers ame_util.idList;
238: l_aty_object_version_numbers ame_util.idList;
239: l_order_numbers ame_util.idList;
240: l_rule_type integer;
241: l_acf_object_version_number number;
242: l_aty_object_version_number number;
243: l_acf_start_date date;

Line 307: and nvl(end_date - ame_util.oneSecond, p_effective_date);

303: cursor application_cur(p_effective_date in date) is
304: select application_id
305: from ame_calling_apps
306: where p_effective_date between start_date
307: and nvl(end_date - ame_util.oneSecond, p_effective_date);
308: -- local variables
309: l_proc varchar2(72) := g_package||'create_ame_action_type';
310: l_action_type_id number;
311: l_effective_date date;

Line 325: l_application_ids ame_util.idList;

321: l_apu_object_version_number number;
322: l_apu_start_date date;
323: l_apu_end_date date;
324: l_language_code fnd_languages.language_code%TYPE;
325: l_application_ids ame_util.idList;
326: --
327: begin
328: hr_utility.set_location('Entering:'|| l_proc, 10);
329: -- Validate language code

Line 501: /* if(p_rule_type = ame_util.exceptionRuleType) then

497: -- Issue a savepoint.
498: --
499: savepoint create_ame_action_type_usage;
500: --
501: /* if(p_rule_type = ame_util.exceptionRuleType) then
502: -- chain of authority so insert two rows,
503: -- one for list-creation and one for list-exception
504: -- isthis loop required?
505: for i in 1 .. 2 loop

Line 545: if(p_rule_type = ame_util.exceptionRuleType) then

541: end;
542: end loop;
543: else*/
544: -- no b4 user hook
545: if(p_rule_type = ame_util.exceptionRuleType) then
546: l_rule_type := p_rule_type-1;
547: else
548: l_rule_type := p_rule_type;
549: end if;

Line 778: /* l_voting_regime := ame_util.serializedVoting;

774: -- made from the 'AME_ACTION_SWI' package.
775: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_ACTION_SWI') <> 0) then
776: -- insert the row in ame_action_type_config with default voting regime
777: -- and default chain ordering mode.
778: /* l_voting_regime := ame_util.serializedVoting;
779: l_chain_ordering_mode := ame_util.serialChainsMode;
780: */
781: -- Call Before Process User Hook
782: begin

Line 779: l_chain_ordering_mode := ame_util.serialChainsMode;

775: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_ACTION_SWI') <> 0) then
776: -- insert the row in ame_action_type_config with default voting regime
777: -- and default chain ordering mode.
778: /* l_voting_regime := ame_util.serializedVoting;
779: l_chain_ordering_mode := ame_util.serialChainsMode;
780: */
781: -- Call Before Process User Hook
782: begin
783: ame_action_bk12.create_ame_action_type_conf_b

Line 1004: ,p_is_static => ame_util.booleanTrue

1000: ame_attribute_api.create_ame_attribute_usage
1001: (
1002: p_attribute_id => p_attribute_id
1003: ,p_application_id => rec.application_id
1004: ,p_is_static => ame_util.booleanTrue
1005: ,p_query_string => l_query_string
1006: ,p_object_version_number => l_req_object_version_number
1007: ,p_start_date => l_req_start_date
1008: ,p_end_date => l_req_end_date

Line 1694: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

1690: from ame_mandatory_attributes
1691: where
1692: action_type_id = p_action_type_id
1693: and p_effective_date
1694: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
1695: cursor appr_type_usage_cur(p_action_type_id in number,
1696: p_effective_date in date) is
1697: select approver_type_id, object_version_number
1698: from ame_approver_type_usages

Line 1702: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

1698: from ame_approver_type_usages
1699: where
1700: action_type_id = p_action_type_id
1701: and p_effective_date
1702: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
1703:
1704: cursor action_type_usage_cur(p_action_type_id in number,
1705: p_effective_date in date) is
1706: select rule_type, object_version_number

Line 1711: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

1707: from ame_action_type_usages
1708: where
1709: action_type_id = p_action_type_id
1710: and p_effective_date
1711: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
1712: cursor action_type_conf_cur(p_action_type_id in number,
1713: p_effective_date in date) is
1714: select count(*)
1715: from ame_action_type_config

Line 1719: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

1715: from ame_action_type_config
1716: where
1717: action_type_id = p_action_type_id
1718: and p_effective_date
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

Line 1727: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

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);
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

Line 1738: between ruleUsages.start_date and nvl(ruleUsages.end_date - ame_util.oneSecond, p_effective_date)

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
1737: and p_effective_date
1738: between ruleUsages.start_date and nvl(ruleUsages.end_date - ame_util.oneSecond, p_effective_date)
1739: and p_effective_date
1740: between actions.start_date and nvl(actions.end_date - ame_util.oneSecond, p_effective_date)
1741: and p_effective_date
1742: between actionTypes.start_date and nvl(actionTypes.end_date - ame_util.oneSecond, p_effective_date);

Line 1740: between actions.start_date and nvl(actions.end_date - ame_util.oneSecond, p_effective_date)

1736: and actionTypes.action_type_id = p_action_type_id
1737: and p_effective_date
1738: between ruleUsages.start_date and nvl(ruleUsages.end_date - ame_util.oneSecond, p_effective_date)
1739: and p_effective_date
1740: between actions.start_date and nvl(actions.end_date - ame_util.oneSecond, p_effective_date)
1741: and p_effective_date
1742: between actionTypes.start_date and nvl(actionTypes.end_date - ame_util.oneSecond, p_effective_date);
1743: --
1744: l_proc varchar2(72) := g_package||'delete_ame_action_type';

Line 1742: between actionTypes.start_date and nvl(actionTypes.end_date - ame_util.oneSecond, p_effective_date);

1738: between ruleUsages.start_date and nvl(ruleUsages.end_date - ame_util.oneSecond, p_effective_date)
1739: and p_effective_date
1740: between actions.start_date and nvl(actions.end_date - ame_util.oneSecond, p_effective_date)
1741: and p_effective_date
1742: between actionTypes.start_date and nvl(actionTypes.end_date - ame_util.oneSecond, p_effective_date);
1743: --
1744: l_proc varchar2(72) := g_package||'delete_ame_action_type';
1745: l_effective_date date;
1746: l_man_attribute_ids ame_util.idList;

Line 1746: l_man_attribute_ids ame_util.idList;

1742: between actionTypes.start_date and nvl(actionTypes.end_date - ame_util.oneSecond, p_effective_date);
1743: --
1744: l_proc varchar2(72) := g_package||'delete_ame_action_type';
1745: l_effective_date date;
1746: l_man_attribute_ids ame_util.idList;
1747: l_axu_rule_types ame_util.idList;
1748: l_axu_object_version_number number;
1749: l_axu_object_version_numbers ame_util.idList;
1750: l_axu_start_date date;

Line 1747: l_axu_rule_types ame_util.idList;

1743: --
1744: l_proc varchar2(72) := g_package||'delete_ame_action_type';
1745: l_effective_date date;
1746: l_man_attribute_ids ame_util.idList;
1747: l_axu_rule_types ame_util.idList;
1748: l_axu_object_version_number number;
1749: l_axu_object_version_numbers ame_util.idList;
1750: l_axu_start_date date;
1751: l_axu_end_date date;

Line 1749: l_axu_object_version_numbers ame_util.idList;

1745: l_effective_date date;
1746: l_man_attribute_ids ame_util.idList;
1747: l_axu_rule_types ame_util.idList;
1748: l_axu_object_version_number number;
1749: l_axu_object_version_numbers ame_util.idList;
1750: l_axu_start_date date;
1751: l_axu_end_date date;
1752: l_man_object_version_number number;
1753: l_man_object_version_numbers ame_util.idList;

Line 1753: l_man_object_version_numbers ame_util.idList;

1749: l_axu_object_version_numbers ame_util.idList;
1750: l_axu_start_date date;
1751: l_axu_end_date date;
1752: l_man_object_version_number number;
1753: l_man_object_version_numbers ame_util.idList;
1754: l_man_start_date date;
1755: l_man_end_date date;
1756: l_acf_object_version_number number;
1757: l_acf_object_version_numbers ame_util.idList;

Line 1757: l_acf_object_version_numbers ame_util.idList;

1753: l_man_object_version_numbers ame_util.idList;
1754: l_man_start_date date;
1755: l_man_end_date date;
1756: l_acf_object_version_number number;
1757: l_acf_object_version_numbers ame_util.idList;
1758: l_acf_start_date date;
1759: l_acf_end_date date;
1760: l_application_ids ame_util.idList;
1761: l_aty_object_version_number number;

Line 1760: l_application_ids ame_util.idList;

1756: l_acf_object_version_number number;
1757: l_acf_object_version_numbers ame_util.idList;
1758: l_acf_start_date date;
1759: l_acf_end_date date;
1760: l_application_ids ame_util.idList;
1761: l_aty_object_version_number number;
1762: l_aty_start_date date;
1763: l_aty_end_date date;
1764: l_apu_approver_type_ids ame_util.idList;

Line 1764: l_apu_approver_type_ids ame_util.idList;

1760: l_application_ids ame_util.idList;
1761: l_aty_object_version_number number;
1762: l_aty_start_date date;
1763: l_aty_end_date date;
1764: l_apu_approver_type_ids ame_util.idList;
1765: l_apu_object_version_number number;
1766: l_apu_object_version_numbers ame_util.idList;
1767: l_apu_start_date date;
1768: l_apu_end_date date;

Line 1766: l_apu_object_version_numbers ame_util.idList;

1762: l_aty_start_date date;
1763: l_aty_end_date date;
1764: l_apu_approver_type_ids ame_util.idList;
1765: l_apu_object_version_number number;
1766: l_apu_object_version_numbers ame_util.idList;
1767: l_apu_start_date date;
1768: l_apu_end_date date;
1769: l_rule_types ame_util.idList;
1770: l_effective_date2 date;

Line 1769: l_rule_types ame_util.idList;

1765: l_apu_object_version_number number;
1766: l_apu_object_version_numbers ame_util.idList;
1767: l_apu_start_date date;
1768: l_apu_end_date date;
1769: l_rule_types ame_util.idList;
1770: l_effective_date2 date;
1771: l_config_count number;
1772: l_rule_usage_count number;
1773: --