APPS.OE_APPROVALS_WF dependencies on OE_APPROVER_LISTS

Line 303: the role from the OE_APPROVER_LISTS with approver_sequence = max+1

299: the definition/setup in the OM Approver List form, insert/update
300: the proper record in the OM Approval transaction table
301: OE_APPROVAL_TRANSACTIONS. Checks the max(approver_sequence) from
302: OE_APPROVAL_TRANSACTIONS given a transaction_id, and then fetches
303: the role from the OE_APPROVER_LISTS with approver_sequence = max+1
304: and insert the record in OE_APPROVER_TRANSACTIONS.
305: Returns Y if it finds the next approver and returns N if there is no
306: approver left. In the case there is no more approvers, it will update
307: the status to APPROVED

Line 603: from OE_APPROVER_LISTS

599: -- Get the approver list_id
600: BEGIN
601: select list_id
602: into l_list_id
603: from OE_APPROVER_LISTS
604: where TRANSACTION_TYPE_ID = l_transaction_type_id
605: and TRANSACTION_PHASE_CODE is not NULL
606: and TRANSACTION_PHASE_CODE = l_transaction_phase_code
607: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )

Line 627: from OE_APPROVER_LISTS

623:
624: BEGIN
625: select list_id
626: into l_list_id
627: from OE_APPROVER_LISTS
628: where TRANSACTION_TYPE_ID = l_transaction_type_id
629: and TRANSACTION_PHASE_CODE is NULL
630: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
631: AND NVL(END_DATE_ACTIVE, SYSDATE );