DBA Data[Home] [Help]

APPS.IA_WF_REQUEST_PKG dependencies on AME_UTIL

Line 17: p_releasing_approvers in AME_UTIL.approversTable,

13:
14: /*
15: PROCEDURE Repopulate_Approvers_List
16: (p_request_id in number,
17: p_releasing_approvers in AME_UTIL.approversTable,
18: p_receiving_approvers in AME_UTIL.approversTable
19: );
20: */
21:

Line 18: p_receiving_approvers in AME_UTIL.approversTable

14: /*
15: PROCEDURE Repopulate_Approvers_List
16: (p_request_id in number,
17: p_releasing_approvers in AME_UTIL.approversTable,
18: p_receiving_approvers in AME_UTIL.approversTable
19: );
20: */
21:
22: /*

Line 775: tempApprover AME_UTIL.approverRecord;

771:
772: callingProgram VARCHAR2(80) := 'Get_Next_Approver';
773:
774:
775: tempApprover AME_UTIL.approverRecord;
776: tempApprovers AME_UTIL.approversTable;
777:
778:
779: l_approver_id NUMBER(15) := NULL;

Line 776: tempApprovers AME_UTIL.approversTable;

772: callingProgram VARCHAR2(80) := 'Get_Next_Approver';
773:
774:
775: tempApprover AME_UTIL.approverRecord;
776: tempApprovers AME_UTIL.approversTable;
777:
778:
779: l_approver_id NUMBER(15) := NULL;
780: l_approver_name VARCHAR2(150);

Line 1157: tempReleasingApprovers AME_UTIL.approversTable;

1153: l_chain_phase VARCHAR2(30);
1154: l_approver_id NUMBER(15) := NULL;
1155: l_approval_id NUMBER(15) := NULL;
1156:
1157: tempReleasingApprovers AME_UTIL.approversTable;
1158: tempReceivingApprovers AME_UTIL.approversTable;
1159:
1160: BEGIN
1161:

Line 1158: tempReceivingApprovers AME_UTIL.approversTable;

1154: l_approver_id NUMBER(15) := NULL;
1155: l_approval_id NUMBER(15) := NULL;
1156:
1157: tempReleasingApprovers AME_UTIL.approversTable;
1158: tempReceivingApprovers AME_UTIL.approversTable;
1159:
1160: BEGIN
1161:
1162: if (funcmode = 'RUN') then

Line 1344: p_releasing_approvers in AME_UTIL.approversTable,

1340:
1341: /*
1342: PROCEDURE Repopulate_Approvers_List
1343: (p_request_id in number,
1344: p_releasing_approvers in AME_UTIL.approversTable,
1345: p_receiving_approvers in AME_UTIL.approversTable
1346: )
1347: IS
1348:

Line 1345: p_receiving_approvers in AME_UTIL.approversTable

1341: /*
1342: PROCEDURE Repopulate_Approvers_List
1343: (p_request_id in number,
1344: p_releasing_approvers in AME_UTIL.approversTable,
1345: p_receiving_approvers in AME_UTIL.approversTable
1346: )
1347: IS
1348:
1349: debugInfo VARCHAR2(255) := NULL;

Line 1359: tempApprovers AME_UTIL.approversTable;

1355: callingProgram VARCHAR2(80) := 'Repopulate_Approvers_List';
1356:
1357: itemkey NUMBER(15) := p_request_id;
1358:
1359: tempApprovers AME_UTIL.approversTable;
1360: l_list_id NUMBER(15);
1361: l_approver_id NUMBER(15);
1362: l_ame_approval_status VARCHAR2(30);
1363: l_approval_status VARCHAR2(30);

Line 1521: tempApprover AME_UTIL.approverRecord;

1517: localException EXCEPTION;
1518:
1519: callingProgram VARCHAR2(80) := 'Update_Approval_Status';
1520:
1521: tempApprover AME_UTIL.approverRecord;
1522:
1523: PRAGMA AUTONOMOUS_TRANSACTION;
1524:
1525: BEGIN

Line 1681: tempApprover AME_UTIL.approverRecord;

1677: l_chain_phase VARCHAR2(30);
1678: l_approval_id NUMBER(15);
1679: l_approver_id NUMBER(15);
1680:
1681: tempApprover AME_UTIL.approverRecord;
1682:
1683: BEGIN
1684:
1685: if (funcmode = 'RUN') then

Line 1722: tempApprover.approval_status := AME_UTIL.approvedStatus;

1718: ,itemkey => itemkey
1719: ,aname => 'APPROVER_ID');
1720:
1721: tempApprover.person_id := l_approver_id;
1722: tempApprover.approval_status := AME_UTIL.approvedStatus;
1723:
1724: -----------------------------------------------------
1725: debugInfo := 'Update Approval Status';
1726: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,

Line 1804: tempApprover AME_UTIL.approverRecord;

1800: l_approval_id NUMBER(15);
1801: l_approver_id NUMBER(15);
1802: l_delegatee_id NUMBER(15);
1803:
1804: tempApprover AME_UTIL.approverRecord;
1805: tempDelegatee AME_UTIL.approverRecord;
1806:
1807: BEGIN
1808:

Line 1805: tempDelegatee AME_UTIL.approverRecord;

1801: l_approver_id NUMBER(15);
1802: l_delegatee_id NUMBER(15);
1803:
1804: tempApprover AME_UTIL.approverRecord;
1805: tempDelegatee AME_UTIL.approverRecord;
1806:
1807: BEGIN
1808:
1809: if (funcmode = 'RUN') then

Line 1861: tempApprover.authority := AME_UTIL.authorityApprover; -- ???

1857: IA_WF_UTIL_PKG.AddDebugMessage(callingProgram, debugInfo, l_delegatee_id);
1858:
1859: tempApprover.user_id := NULL;
1860: tempApprover.person_id := l_approver_id;
1861: tempApprover.authority := AME_UTIL.authorityApprover; -- ???
1862: tempApprover.approval_status := AME_UTIL.forwardStatus;
1863:
1864: tempDelegatee.person_id := l_delegatee_id;
1865: tempDelegatee.api_insertion := AME_UTIL.apiInsertion;

Line 1862: tempApprover.approval_status := AME_UTIL.forwardStatus;

1858:
1859: tempApprover.user_id := NULL;
1860: tempApprover.person_id := l_approver_id;
1861: tempApprover.authority := AME_UTIL.authorityApprover; -- ???
1862: tempApprover.approval_status := AME_UTIL.forwardStatus;
1863:
1864: tempDelegatee.person_id := l_delegatee_id;
1865: tempDelegatee.api_insertion := AME_UTIL.apiInsertion;
1866: tempDelegatee.authority := AME_UTIL.authorityApprover;

Line 1865: tempDelegatee.api_insertion := AME_UTIL.apiInsertion;

1861: tempApprover.authority := AME_UTIL.authorityApprover; -- ???
1862: tempApprover.approval_status := AME_UTIL.forwardStatus;
1863:
1864: tempDelegatee.person_id := l_delegatee_id;
1865: tempDelegatee.api_insertion := AME_UTIL.apiInsertion;
1866: tempDelegatee.authority := AME_UTIL.authorityApprover;
1867: tempDelegatee.approval_status := NULL;
1868:
1869: -----------------------------------------------------

Line 1866: tempDelegatee.authority := AME_UTIL.authorityApprover;

1862: tempApprover.approval_status := AME_UTIL.forwardStatus;
1863:
1864: tempDelegatee.person_id := l_delegatee_id;
1865: tempDelegatee.api_insertion := AME_UTIL.apiInsertion;
1866: tempDelegatee.authority := AME_UTIL.authorityApprover;
1867: tempDelegatee.approval_status := NULL;
1868:
1869: -----------------------------------------------------
1870: debugInfo := 'Update AME Approval Status';

Line 1948: tempApprover AME_UTIL.approverRecord;

1944: l_chain_phase VARCHAR2(30);
1945: l_approval_id NUMBER(15);
1946: l_approver_id NUMBER(15);
1947:
1948: tempApprover AME_UTIL.approverRecord;
1949:
1950: BEGIN
1951:
1952: if (funcmode = 'RUN') then

Line 1989: tempApprover.approval_status := AME_UTIL.rejectStatus;

1985: ,itemkey => itemkey
1986: ,aname => 'APPROVER_ID');
1987:
1988: tempApprover.person_id := l_approver_id;
1989: tempApprover.approval_status := AME_UTIL.rejectStatus;
1990:
1991: -----------------------------------------------------
1992: debugInfo := 'Update Approval Status';
1993: IA_WF_UTIL_PKG.AddWFDebugMessage(p_request_id => itemkey,

Line 2097: tempApprover AME_UTIL.approverRecord;

2093: l_chain_phase VARCHAR2(30);
2094: l_approval_id NUMBER(15);
2095: l_approver_id NUMBER(15);
2096:
2097: tempApprover AME_UTIL.approverRecord;
2098:
2099: BEGIN
2100:
2101: if (funcmode = 'RUN') then