AME Steps with an example:
-----------------------------
Responsibility : Approvals Management Business Analyst
---------------
*Rule
*Name : XXTEST_LEAVE_SUPERVISOR_APPROVAL
*Rule Type : List Creation
Catagory : Approver/FYI
*Priority : 1
*Start Date :
*End Date :
## Setup
I. Attributes
===========
Name : XXTEST_IS_EMPLOYEE_INITAITED_TXN
Item Class : Header
Description : This will check if the transaction is initiated by an employee.
Data Type : String
Approver Type : None
Usage Type : Dynamic
Value Set :
Value : select 'YES' from hr_api_transactions
where creator_person_id=selected_person_id
and transaction_id=:transactionId
union all
select 'NO' from hr_api_transactions
where creator_person_id !=selected_person_id
and transaction_id=:transactionId
union all
select 'NO' from dual
where not exists ( select 1 from hr_api_transactions where transaction_id=:transactionId )
Category : Others
Action Types : None
II. Conditions
==========
1. Condition Type : Ordinary
Item Class : Header
Attribute Name : XXTEST_IS_EMPLOYEE_INITAITED_TXN
Data Type : String
Condition : XXTEST_IS_EMPLOYEE_INITAITED_TXN in (YES)
2. WORKFLOW_PROCESS_NAME in (HR_GENERIC_APPROVAL_PRC)
III. Action Types
============
approval-group chain of authority
IV. Approver Groups
===============
Name : XXTEST_LEAVE_SUPERVISOR_APPROVER
Description : This will fetch the supervisor.
Usage Type : Dynamic
Order Number : 1
Voting Method : Serial
Query : select 'person_id:'||supervisor_id
from per_assignments_f paf,
hr_api_transactions hat
where hat.transaction_id=:transactionId
and hat.selected_person_id=paf.person_id
and trunc(sysdate) between effective_start_date and effective_end_date
and primary_flag='Y'
