APPS.AME_APPROVER_GROUP_API dependencies on AME_UTIL

Line 74: l_grp_id_list ame_util.idList;

70: l_grp_id number;
71: l_query_string varchar2(4000);
72: l_orig_system varchar2(100);
73: l_orig_system_id number;
74: l_grp_id_list ame_util.idList;
75: l_count number;
76:
77: begin
78:

Line 136: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);

132: select query_string
133: into l_query_string
134: from ame_approval_groups
135: where to_char(approval_group_id) = r2.param
136: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
137: end if;
138:
139: insert into ame_approval_group_members
140: (

Line 217: where name in ( ame_util.preApprovalTypeName

213: Cursor C_Sel1 is
214: select action_type_id
215: ,name
216: from ame_action_types
217: where name in ( ame_util.preApprovalTypeName
218: ,ame_util.postApprovalTypeName
219: ,ame_util.groupChainApprovalTypeName
220: )
221: and sysdate >= start_date and sysdate < end_date;

Line 218: ,ame_util.postApprovalTypeName

214: select action_type_id
215: ,name
216: from ame_action_types
217: where name in ( ame_util.preApprovalTypeName
218: ,ame_util.postApprovalTypeName
219: ,ame_util.groupChainApprovalTypeName
220: )
221: and sysdate >= start_date and sysdate < end_date;
222:

Line 219: ,ame_util.groupChainApprovalTypeName

215: ,name
216: from ame_action_types
217: where name in ( ame_util.preApprovalTypeName
218: ,ame_util.postApprovalTypeName
219: ,ame_util.groupChainApprovalTypeName
220: )
221: and sysdate >= start_date and sysdate < end_date;
222:
223: begin

Line 274: if(rec.name = ame_util.preApprovalTypeName) then

270: -- Create group based actions.
271: --
272: for rec in C_Sel1
273: loop
274: if(rec.name = ame_util.preApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
276: elsif (rec.name = ame_util.postApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
278: elsif (rec.name = ame_util.groupChainApprovalTypeName) then

Line 276: elsif (rec.name = ame_util.postApprovalTypeName) then

272: for rec in C_Sel1
273: loop
274: if(rec.name = ame_util.preApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
276: elsif (rec.name = ame_util.postApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
278: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
279: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');
280: end if;

Line 278: elsif (rec.name = ame_util.groupChainApprovalTypeName) then

274: if(rec.name = ame_util.preApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
276: elsif (rec.name = ame_util.postApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
278: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
279: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');
280: end if;
281: fnd_message.set_token('GROUP_NAME', p_name);
282: ame_action_api.create_ame_action

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

582: ,act.action_type_id
583: ,act.object_version_number
584: from ame_actions act
585: ,ame_action_types aty
586: where aty.name in ( ame_util.preApprovalTypeName
587: ,ame_util.postApprovalTypeName
588: ,ame_util.groupChainApprovalTypeName
589: )
590: and act.action_type_id = aty.action_type_id

Line 587: ,ame_util.postApprovalTypeName

583: ,act.object_version_number
584: from ame_actions act
585: ,ame_action_types aty
586: where aty.name in ( ame_util.preApprovalTypeName
587: ,ame_util.postApprovalTypeName
588: ,ame_util.groupChainApprovalTypeName
589: )
590: and act.action_type_id = aty.action_type_id
591: and act.parameter = to_char(p_approval_group_id)

Line 588: ,ame_util.groupChainApprovalTypeName

584: from ame_actions act
585: ,ame_action_types aty
586: where aty.name in ( ame_util.preApprovalTypeName
587: ,ame_util.postApprovalTypeName
588: ,ame_util.groupChainApprovalTypeName
589: )
590: and act.action_type_id = aty.action_type_id
591: and act.parameter = to_char(p_approval_group_id)
592: and sysdate >= act.start_date and sysdate < act.end_date