DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_APPROVER_TYPES

Line 2536: tempApproverType ame_approver_types.orig_system%type;

2532: procedure checkApprover(approverIn in ame_util.approverRecord2) is
2533: errorCode integer;
2534: errorMessage ame_util.longestStringType;
2535: tempApproverTypeCount integer;
2536: tempApproverType ame_approver_types.orig_system%type;
2537: invalidApproverException1 exception;
2538: invalidApproverException2 exception;
2539: begin
2540: tempApproverType := approverIn.orig_system;

Line 2547: from ame_approver_types

2543: end if;
2544: if getConfigVarValue(ame_util.allowAllApproverTypesConfigVar) = ame_util.yes then
2545: select count(*)
2546: into tempApproverTypeCount
2547: from ame_approver_types
2548: where orig_system = approverIn.orig_system
2549: and sysdate between start_date and end_date;
2550: if tempApproverTypeCount = 0 then
2551: raise invalidApproverException1;