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

Line 37: and sysdate < (end_date - ame_util.oneSecond)

33: select distinct to_number(parameter) grp
34: from (select *
35: from ame_approval_group_items
36: where sysdate >= start_date
37: and sysdate < (end_date - ame_util.oneSecond)
38: )
39: where parameter_name = 'OAM_group_id'
40: start with approval_group_id =p_group
41: connect by prior decode(parameter_name,'OAM_group_id',parameter,null)

Line 50: and sysdate < (end_date - ame_util.oneSecond)

46: select distinct approval_group_id grp
47: from (select *
48: from ame_approval_group_items
49: where sysdate >= start_date
50: and sysdate < (end_date - ame_util.oneSecond)
51: )
52: where parameter_name = 'OAM_group_id'
53: start with parameter = to_char(p_group)
54: connect by prior to_char(approval_group_id) = parameter

Line 85: sysdate between start_date and (end_date - ame_util.oneSecond);

81: parameter_name
82: from ame_approval_group_items
83: where
84: approval_group_id = approvalGroupIdIn and
85: sysdate between start_date and (end_date - ame_util.oneSecond);
86: l_proc varchar2(72) := g_package||'group_is_in_group';
87: tempGroupId number;
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 91: if(tempGroup.parameter_name = ame_util.approverOamGroupId) then

87: tempGroupId number;
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 10);
90: for tempGroup in groupMemberCursor(approvalGroupIdIn => p_approval_group_id) loop
91: if(tempGroup.parameter_name = ame_util.approverOamGroupId) then
92: tempGroupId := to_number(tempGroup.parameter);
93: if(tempGroupId = possiblyNestedGroupIdIn) then
94: return(true);
95: elsif(group_is_in_group(p_approval_group_id => tempGroupId,

Line 112: ,allowedNestedGroupIdsOut out nocopy ame_util.stringList

108: -- ----------------------------------------------------------------------------
109: --
110: procedure get_allowed_nested_groups
111: (p_approval_group_id in number
112: ,allowedNestedGroupIdsOut out nocopy ame_util.stringList
113: ,allowedNestedGroupNamesOut out nocopy ame_util.stringList) as
114: cursor groupCursor is
115: select
116: approval_group_id

Line 113: ,allowedNestedGroupNamesOut out nocopy ame_util.stringList) as

109: --
110: procedure get_allowed_nested_groups
111: (p_approval_group_id in number
112: ,allowedNestedGroupIdsOut out nocopy ame_util.stringList
113: ,allowedNestedGroupNamesOut out nocopy ame_util.stringList) as
114: cursor groupCursor is
115: select
116: approval_group_id
117: ,name

Line 120: sysdate between start_date and (end_date - ame_util.oneSecond);

116: approval_group_id
117: ,name
118: from ame_approval_groups
119: where
120: sysdate between start_date and (end_date - ame_util.oneSecond);
121: l_proc varchar2(72) := g_package||'get_allowed_nested_groups';
122: tempIndex number;
123: begin
124: hr_utility.set_location('Entering:'|| l_proc, 10);

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

190: ,ame_calling_apps aca
191: where approval_group_id = p_approval_group_id
192: and aca.application_id = apgc.application_id
193: and sysdate between apgc.start_date and
194: nvl(apgc.end_date-ame_util.oneSecond,SYSDATE)
195: and sysdate between aca.start_date and
196: nvl(aca.end_date-ame_util.oneSecond,SYSDATE);
197: --
198: -- cursor to find the value of allowAllApproverTypes config variable for the

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

192: and aca.application_id = apgc.application_id
193: and sysdate between apgc.start_date and
194: nvl(apgc.end_date-ame_util.oneSecond,SYSDATE)
195: and sysdate between aca.start_date and
196: nvl(aca.end_date-ame_util.oneSecond,SYSDATE);
197: --
198: -- cursor to find the value of allowAllApproverTypes config variable for the
199: -- current transaction type.
200: --

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

203: from ame_config_vars
204: where variable_name like 'allowAllApproverTypes'
205: and application_id = l_application_id
206: and sysdate between start_date and
207: nvl(end_date-ame_util.oneSecond,SYSDATE);
208:
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: hr_api.mandatory_arg_error(p_api_name => l_proc

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

246: from ame_config_vars
247: where variable_name like 'allowAllApproverTypes'
248: and application_id = 0
249: and sysdate between start_date and
250: nvl(end_date-ame_util.oneSecond,SYSDATE);
251: end if;
252: close C_Sel2;
253: -- if all approver types are allowed for the current transaction ,then return
254: if l_config_value = 'no' then

Line 313: and (t.end_date - ame_util.oneSecond);

309: select count(t.approval_group_id)
310: from ame_approval_groups t
311: where t.approval_group_id = p_approval_group_id
312: and p_effective_date between t.start_date
313: and (t.end_date - ame_util.oneSecond);
314: Cursor C_Sel2 Is
315: select count(t.approval_group_id)
316: from ame_approval_groups t
317: where t.approval_group_id = p_approval_group_id

Line 320: and (t.end_date - ame_util.oneSecond);

316: from ame_approval_groups t
317: where t.approval_group_id = p_approval_group_id
318: and t.is_static = 'Y'
319: and p_effective_date between t.start_date
320: and (t.end_date - ame_util.oneSecond);
321: Begin
322: hr_utility.set_location('Entering:'||l_proc,10);
323: hr_api.mandatory_arg_error(p_api_name => l_proc
324: ,p_argument => 'APPROVAL_GROUP_ID'

Line 449: l_allowed_nested_group_ids ame_util.stringList;

445: --
446: l_proc varchar2(72) := g_package || 'CHK_PARAMETER';
447: l_count number;
448: l_parameter_allowed boolean;
449: l_allowed_nested_group_ids ame_util.stringList;
450: l_allowed_nested_group_names ame_util.stringList;
451: --
452: -- Cursor to find number of groups with approval_group_id = p_parameter
453: --

Line 450: l_allowed_nested_group_names ame_util.stringList;

446: l_proc varchar2(72) := g_package || 'CHK_PARAMETER';
447: l_count number;
448: l_parameter_allowed boolean;
449: l_allowed_nested_group_ids ame_util.stringList;
450: l_allowed_nested_group_names ame_util.stringList;
451: --
452: -- Cursor to find number of groups with approval_group_id = p_parameter
453: --
454: Cursor C_Sel1 Is

Line 458: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);

454: Cursor C_Sel1 Is
455: select count(t.approval_group_id)
456: from ame_approval_groups t
457: where to_char(t.approval_group_id) = p_parameter
458: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
459:
460: Cursor C_Sel2 Is
461: select count(name)
462: from wf_roles

Line 479: if p_parameter_name = ame_util.approverOamGroupId then

475: -- Check if the parameter corresponds to a valid group in ame_approval_groups
476: -- whenever parameter_name = 'OAM_group_id'
477: -- If parameter_name = 'wf_roles_name' then validate the wf_roles_name.
478: --
479: if p_parameter_name = ame_util.approverOamGroupId then
480: open C_Sel1;
481: fetch C_Sel1 into l_count;
482: close C_Sel1;
483: if (l_count = 0) then

Line 635: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);

631: from ame_approval_group_items t
632: where t.approval_group_id = p_approval_group_id
633: and t.parameter_name = p_parameter_name
634: and t.parameter = p_parameter
635: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
636: Begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'

Line 712: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);

708: Cursor C_Sel1 Is
709: select t.created_by
710: from ame_approval_group_items t
711: where t.approval_group_item_id = p_rec.approval_group_item_id
712: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
713: Begin
714: --
715: -- Only proceed with the validation if a row exists for the current
716: -- record in the HR Schema.

Line 740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and

736: close C_Sel1;
737: --
738: -- ORDER_NUMBER is non-updateable if the group is seeded
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc