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_GCF_BUS dependencies on AME_UTIL

Line 55: nvl(end_date-ame_util.oneSecond,SYSDATE);

51: from ame_config_vars
52: where variable_name like 'allowAllApproverTypes'
53: and application_id = p_application_id
54: and sysdate between start_date and
55: nvl(end_date-ame_util.oneSecond,SYSDATE);
56: --
57: -- cursor to find if the approver group consists of group members of approver
58: -- type not allowed in the current transaction type.
59: --

Line 80: nvl(end_date-ame_util.oneSecond,SYSDATE);

76: from ame_config_vars
77: where variable_name like 'allowAllApproverTypes'
78: and application_id = 0
79: and sysdate between start_date and
80: nvl(end_date-ame_util.oneSecond,SYSDATE);
81: end if;
82: close C_Sel1;
83: -- if all approver types are allowed for the current transaction ,then return
84: if l_config_value = 'yes' then

Line 97: nvl(end_date-ame_util.oneSecond,SYSDATE)

93: select name into l_group_name
94: from ame_approval_groups
95: where approval_group_id = p_approval_group_id
96: and sysdate between start_date and
97: nvl(end_date-ame_util.oneSecond,SYSDATE)
98: and rownum < 2;
99: fnd_message.set_name('PER','AME_400617_APG_INV_APPR_TYPE');
100: fnd_message.set_token('GRP_NAME',l_group_name);
101: fnd_message.raise_error;

Line 160: where aty.name in ( ame_util.preApprovalTypeName

156: from ame_action_types aty
157: ,ame_actions act
158: ,ame_rule_usages aru
159: ,ame_action_usages actu
160: where aty.name in ( ame_util.preApprovalTypeName
161: ,ame_util.postApprovalTypeName
162: ,ame_util.groupChainApprovalTypeName
163: )
164: and aty.action_type_id = act.action_type_id

Line 161: ,ame_util.postApprovalTypeName

157: ,ame_actions act
158: ,ame_rule_usages aru
159: ,ame_action_usages actu
160: where aty.name in ( ame_util.preApprovalTypeName
161: ,ame_util.postApprovalTypeName
162: ,ame_util.groupChainApprovalTypeName
163: )
164: and aty.action_type_id = act.action_type_id
165: and act.parameter = to_char(p_approval_group_id)

Line 162: ,ame_util.groupChainApprovalTypeName

158: ,ame_rule_usages aru
159: ,ame_action_usages actu
160: where aty.name in ( ame_util.preApprovalTypeName
161: ,ame_util.postApprovalTypeName
162: ,ame_util.groupChainApprovalTypeName
163: )
164: and aty.action_type_id = act.action_type_id
165: and act.parameter = to_char(p_approval_group_id)
166: and aru.item_id = p_application_id

Line 174: nvl(aru.end_date - ame_util.oneSecond, p_effective_date)) or

170: nvl(aty.end_date,p_effective_date)
171: and p_effective_date between act.start_Date and
172: nvl(act.end_date,p_effective_date)
173: and ((p_effective_date between aru.start_date and
174: nvl(aru.end_date - ame_util.oneSecond, p_effective_date)) or
175: (p_effective_date < aru.start_date and
176: aru.start_date < nvl(aru.end_date,aru.start_date + ame_util.oneSecond)))
177: and ((p_effective_date between actu.start_date and
178: nvl(actu.end_date - ame_util.oneSecond, p_effective_date)) or

Line 176: aru.start_date < nvl(aru.end_date,aru.start_date + ame_util.oneSecond)))

172: nvl(act.end_date,p_effective_date)
173: and ((p_effective_date between aru.start_date and
174: nvl(aru.end_date - ame_util.oneSecond, p_effective_date)) or
175: (p_effective_date < aru.start_date and
176: aru.start_date < nvl(aru.end_date,aru.start_date + ame_util.oneSecond)))
177: and ((p_effective_date between actu.start_date and
178: nvl(actu.end_date - ame_util.oneSecond, p_effective_date)) or
179: (p_effective_date < actu.start_date and
180: actu.start_date < nvl(actu.end_date,actu.start_date + ame_util.oneSecond)));

Line 178: nvl(actu.end_date - ame_util.oneSecond, p_effective_date)) or

174: nvl(aru.end_date - ame_util.oneSecond, p_effective_date)) or
175: (p_effective_date < aru.start_date and
176: aru.start_date < nvl(aru.end_date,aru.start_date + ame_util.oneSecond)))
177: and ((p_effective_date between actu.start_date and
178: nvl(actu.end_date - ame_util.oneSecond, p_effective_date)) or
179: (p_effective_date < actu.start_date and
180: actu.start_date < nvl(actu.end_date,actu.start_date + ame_util.oneSecond)));
181:
182: cursor c_sel2 is

Line 180: actu.start_date < nvl(actu.end_date,actu.start_date + ame_util.oneSecond)));

176: aru.start_date < nvl(aru.end_date,aru.start_date + ame_util.oneSecond)))
177: and ((p_effective_date between actu.start_date and
178: nvl(actu.end_date - ame_util.oneSecond, p_effective_date)) or
179: (p_effective_date < actu.start_date and
180: actu.start_date < nvl(actu.end_date,actu.start_date + ame_util.oneSecond)));
181:
182: cursor c_sel2 is
183: select null
184: from ame_approval_group_config

Line 185: where ame_utility_pkg.check_seeddb = 'N'

181:
182: cursor c_sel2 is
183: select null
184: from ame_approval_group_config
185: where ame_utility_pkg.check_seeddb = 'N'
186: and approval_group_id = p_approval_group_id
187: and application_id = p_application_id
188: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
189: and p_effective_date between start_date

Line 188: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById

184: from ame_approval_group_config
185: where ame_utility_pkg.check_seeddb = 'N'
186: and approval_group_id = p_approval_group_id
187: and application_id = p_application_id
188: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
189: and p_effective_date between start_date
190: and nvl(end_date - (1/86400), p_effective_date);
191: Begin
192: hr_utility.set_location('Entering:'||l_proc,10);