APPS.AME_APPROVER_TYPE_API dependencies on AME_UTIL

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

154: from ame_attributes
155: where
156: approver_type_id = p_approver_type_id
157: and p_effective_date
158: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
159: --
160: l_proc varchar2(72) := g_package||'delete_ame_approver_type';
161: l_effective_date date;
162:

Line 163: l_attribute_ids ame_util.idList;

159: --
160: l_proc varchar2(72) := g_package||'delete_ame_approver_type';
161: l_effective_date date;
162:
163: l_attribute_ids ame_util.idList;
164: l_atr_object_version_number number;
165: l_atr_object_version_numbers ame_util.idList;
166: l_atr_start_date date;
167: l_atr_end_date date;

Line 165: l_atr_object_version_numbers ame_util.idList;

161: l_effective_date date;
162:
163: l_attribute_ids ame_util.idList;
164: l_atr_object_version_number number;
165: l_atr_object_version_numbers ame_util.idList;
166: l_atr_start_date date;
167: l_atr_end_date date;
168: l_apt_object_version_number number;
169: l_apt_start_date date;

Line 173: l_approver_group_ids ame_util.idList;

169: l_apt_start_date date;
170: l_apt_end_date date;
171: l_apg_object_version_number number;
172: l_apg_orig_system varchar2(100);
173: l_approver_group_ids ame_util.idList;
174: l_apu_approver_type_ids ame_util.idList;
175: l_apu_object_version_number number;
176: l_apu_object_version_numbers ame_util.idList;
177: l_apu_start_date date;

Line 174: l_apu_approver_type_ids ame_util.idList;

170: l_apt_end_date date;
171: l_apg_object_version_number number;
172: l_apg_orig_system varchar2(100);
173: l_approver_group_ids ame_util.idList;
174: l_apu_approver_type_ids ame_util.idList;
175: l_apu_object_version_number number;
176: l_apu_object_version_numbers ame_util.idList;
177: l_apu_start_date date;
178: l_apu_end_date date;

Line 176: l_apu_object_version_numbers ame_util.idList;

172: l_apg_orig_system varchar2(100);
173: l_approver_group_ids ame_util.idList;
174: l_apu_approver_type_ids ame_util.idList;
175: l_apu_object_version_number number;
176: l_apu_object_version_numbers ame_util.idList;
177: l_apu_start_date date;
178: l_apu_end_date date;
179: l_rule_types ame_util.idList;
180: l_effective_date2 date;

Line 179: l_rule_types ame_util.idList;

175: l_apu_object_version_number number;
176: l_apu_object_version_numbers ame_util.idList;
177: l_apu_start_date date;
178: l_apu_end_date date;
179: l_rule_types ame_util.idList;
180: l_effective_date2 date;
181: l_config_count number;
182: l_rule_usage_count number;
183: --