DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_APPROVER_TYPES

Line 2496: tempApproverType ame_approver_types.orig_system%type;

2492: procedure checkApprover(approverIn in ame_util.approverRecord2) is
2493: errorCode integer;
2494: errorMessage ame_util.longestStringType;
2495: tempApproverTypeCount integer;
2496: tempApproverType ame_approver_types.orig_system%type;
2497: invalidApproverException1 exception;
2498: invalidApproverException2 exception;
2499: begin
2500: tempApproverType := approverIn.orig_system;

Line 2507: from ame_approver_types

2503: end if;
2504: if getConfigVarValue(ame_util.allowAllApproverTypesConfigVar) = ame_util.yes then
2505: select count(*)
2506: into tempApproverTypeCount
2507: from ame_approver_types
2508: where orig_system = approverIn.orig_system
2509: and sysdate between start_date and end_date;
2510: if tempApproverTypeCount = 0 then
2511: raise invalidApproverException1;