DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on AME_UTIL

Line 1828: l_approversOut ame_util.approversTable2;

1824: x_workflow_table OUT NOCOPY t_workflow_table)
1825: IS
1826: l_transaction_id VARCHAR2(50);
1827: l_approvalProcessCompleteYNOut VARCHAR2(1);
1828: l_approversOut ame_util.approversTable2;
1829:
1830:
1831: -- Fetch telephone no from per_addresses
1832: CURSOR per_addresses_csr( p_person_id NUMBER)IS

Line 1895: IF (l_approversOut(i).orig_system = AME_UTIL.PERORIGSYSTEM) THEN

1891: x_workflow_table(i).approver := l_approversOut(i).display_name;
1892: x_workflow_table(i).status := l_approversOut(i).approval_status;
1893: -- x_workflow_table(i).status_date:=
1894:
1895: IF (l_approversOut(i).orig_system = AME_UTIL.PERORIGSYSTEM) THEN
1896: OPEN per_addresses_csr(l_approversOut(i).orig_system_id);
1897: FETCH per_addresses_csr INTO x_workflow_table(i).telephone;
1898: CLOSE per_addresses_csr;
1899:

Line 1904: ELSIF (l_approversOut(i).orig_system = AME_UTIL.FNDUSERORIGSYSTEM) THEN

1900: OPEN per_all_people_csr(l_approversOut(i).orig_system_id);
1901: FETCH per_all_people_csr INTO x_workflow_table(i).email;
1902: CLOSE per_all_people_csr;
1903:
1904: ELSIF (l_approversOut(i).orig_system = AME_UTIL.FNDUSERORIGSYSTEM) THEN
1905: OPEN per_addresses_fnd_csr(l_approversOut(i).orig_system_id);
1906: FETCH per_addresses_fnd_csr INTO x_workflow_table(i).telephone;
1907: CLOSE per_addresses_fnd_csr;
1908: