eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WORKORDER_UTIL_PKG dependencies on PER_ALL_PEOPLE_F

Line 1850: -- Fetch email address per_all_people_f

1846: AND person_id = (SELECT employee_id
1847: FROM fnd_user
1848: WHERE user_id = p_user_id);
1849:
1850: -- Fetch email address per_all_people_f
1851: CURSOR per_all_people_csr(p_person_id NUMBER) IS
1852: SELECT email_address
1853: FROM per_all_people_f
1854: WHERE person_id = p_person_id

Line 1853: FROM per_all_people_f

1849:
1850: -- Fetch email address per_all_people_f
1851: CURSOR per_all_people_csr(p_person_id NUMBER) IS
1852: SELECT email_address
1853: FROM per_all_people_f
1854: WHERE person_id = p_person_id
1855: AND sysdate between effective_start_date AND effective_end_date;
1856:
1857: -- Fetch email address per_all_people_f

Line 1857: -- Fetch email address per_all_people_f

1853: FROM per_all_people_f
1854: WHERE person_id = p_person_id
1855: AND sysdate between effective_start_date AND effective_end_date;
1856:
1857: -- Fetch email address per_all_people_f
1858: CURSOR per_all_people_fnd_csr(p_user_id NUMBER) IS
1859: SELECT email_address
1860: FROM per_all_people_f
1861: WHERE sysdate between effective_start_date AND effective_end_date

Line 1858: CURSOR per_all_people_fnd_csr(p_user_id NUMBER) IS

1854: WHERE person_id = p_person_id
1855: AND sysdate between effective_start_date AND effective_end_date;
1856:
1857: -- Fetch email address per_all_people_f
1858: CURSOR per_all_people_fnd_csr(p_user_id NUMBER) IS
1859: SELECT email_address
1860: FROM per_all_people_f
1861: WHERE sysdate between effective_start_date AND effective_end_date
1862: AND person_id = (SELECT employee_id

Line 1860: FROM per_all_people_f

1856:
1857: -- Fetch email address per_all_people_f
1858: CURSOR per_all_people_fnd_csr(p_user_id NUMBER) IS
1859: SELECT email_address
1860: FROM per_all_people_f
1861: WHERE sysdate between effective_start_date AND effective_end_date
1862: AND person_id = (SELECT employee_id
1863: FROM fnd_user
1864: WHERE user_id = p_user_id);

Line 1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);

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:
1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;

Line 1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;

1955: FETCH per_addresses_fnd_csr INTO x_workflow_table(i).telephone;
1956: CLOSE per_addresses_fnd_csr;
1957:
1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;

Line 1960: IF per_all_people_fnd_csr%NOTFOUND THEN

1956: CLOSE per_addresses_fnd_csr;
1957:
1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;
1964: END IF;

Line 1965: CLOSE per_all_people_fnd_csr;

1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;
1964: END IF;
1965: CLOSE per_all_people_fnd_csr;
1966:
1967: END IF;
1968: --Added for bug 14123496 start
1969: IF l_approversOut(i).approval_status ='APPROVE' OR l_approversOut(i).approval_status ='REJECT' then