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 1849: -- Fetch email address per_all_people_f

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

Line 1852: FROM per_all_people_f

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

Line 1856: -- Fetch email address per_all_people_f

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

Line 1857: CURSOR per_all_people_fnd_csr(p_user_id NUMBER) IS

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

Line 1859: FROM per_all_people_f

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

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

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:
1909: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;

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

1906: FETCH per_addresses_fnd_csr INTO x_workflow_table(i).telephone;
1907: CLOSE per_addresses_fnd_csr;
1908:
1909: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;

Line 1911: IF per_all_people_fnd_csr%NOTFOUND THEN

1907: CLOSE per_addresses_fnd_csr;
1908:
1909: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;
1915: END IF;

Line 1916: CLOSE per_all_people_fnd_csr;

1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;
1915: END IF;
1916: CLOSE per_all_people_fnd_csr;
1917:
1918: END IF;
1919: END LOOP;
1920: END IF;