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: l_temp NUMBER; -- for fix 9395270
1830:
1831:
1832: -- Fetch telephone no from per_addresses

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

1940: x_workflow_table(i).approver := l_approversOut(i).display_name;
1941: x_workflow_table(i).status := l_approversOut(i).approval_status;
1942: -- x_workflow_table(i).status_date:=
1943:
1944: IF (l_approversOut(i).orig_system = AME_UTIL.PERORIGSYSTEM) THEN
1945: OPEN per_addresses_csr(l_approversOut(i).orig_system_id);
1946: FETCH per_addresses_csr INTO x_workflow_table(i).telephone;
1947: CLOSE per_addresses_csr;
1948:

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

1949: OPEN per_all_people_csr(l_approversOut(i).orig_system_id);
1950: FETCH per_all_people_csr INTO x_workflow_table(i).email;
1951: CLOSE per_all_people_csr;
1952:
1953: ELSIF (l_approversOut(i).orig_system = AME_UTIL.FNDUSERORIGSYSTEM) THEN
1954: OPEN per_addresses_fnd_csr(l_approversOut(i).orig_system_id);
1955: FETCH per_addresses_fnd_csr INTO x_workflow_table(i).telephone;
1956: CLOSE per_addresses_fnd_csr;
1957: