APPS.AME_API dependencies on AME_APPROVAL_GROUP_CONFIG

Line 102: from ame_approval_group_config

98: where uniq <> 0;
99: --+
100: cursor chkApprovalGrpNonSerialPar(applicationIdIn in number) is
101: select 'Y'
102: from ame_approval_group_config
103: where application_id = applicationIdIn
104: and (voting_regime = ame_util.consensusVoting
105: or voting_regime = ame_util.firstApproverVoting)
106: and sysdate between start_date and

Line 112: from ame_approval_group_config

108: --+
109: cursor chkApprovalGrpNonUniqueOrder(applicationIdIn in number) is
110: select 'Y'
111: from (select (count(order_number) - count(distinct order_number)) uniq
112: from ame_approval_group_config
113: where application_id = applicationIdIn
114: and sysdate between start_date and
115: nvl(end_date - ame_util.oneSecond, sysdate)
116: )

Line 122: ame_approval_group_config gcf,

118: --+
119: cursor chkApprovalGrpMemberOrder(applicationIdIn in number) is
120: select gpi.approval_group_id group_id
121: from ame_approval_groups apg,
122: ame_approval_group_config gcf,
123: ame_approval_group_items gpi
124: where apg.is_static = ame_util.booleanTrue
125: and gcf.application_id = applicationIdIn
126: and gcf.approval_group_id = apg.approval_group_id

Line 214: --Check if parallelization is induced into ame_approval_group_config

210: raise parallelizationFoundException;
211: end if;
212: close chkActionTypeNonUniqueOrder;
213: --+
214: --Check if parallelization is induced into ame_approval_group_config
215: --by checking voting regime for consensus and first responder wins.
216: --Do not throw error for voting regime = order number since it will
217: --be taken care by one of the checks below.
218: --+

Line 228: --Check if parallelization is induced into ame_approval_group_config

224: raise parallelizationFoundException;
225: end if;
226: close chkApprovalGrpNonSerialPar;
227: --+
228: --Check if parallelization is induced into ame_approval_group_config
229: --by ensuring that no two approval groups have same order number.
230: --+
231: tempAMEObject := 'approval group: non unique order number';
232: open chkApprovalGrpNonUniqueOrder(applicationIdIn => ameApplicationId);