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.HR_APPLICANT_INTERNAL dependencies on PER_APPLICATIONS

Line 637: from per_applications

633: l_datetrack_mode varchar2(30);
634:
635: cursor fpt_apl is
636: select date_received,date_end
637: from per_applications
638: where person_id = p_person_id
639: and date_received >= p_effective_date
640: order by date_received;
641:

Line 1857: from per_applications

1853: ) IS
1854:
1855: cursor csr_fut_apl(cp_person_id number, cp_effective_date date) is
1856: select application_id, date_received, object_version_number
1857: from per_applications
1858: where person_id = cp_person_id
1859: and date_received > cp_effective_date
1860: order by date_received asc;
1861:

Line 1864: from per_applications

1860: order by date_received asc;
1861:
1862: cursor csr_current_apl(cp_person_id number, cp_effective_date date) is
1863: select application_id, date_received, object_version_number
1864: from per_applications
1865: where person_id = cp_person_id
1866: and date_received <= cp_effective_date
1867: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1868:

Line 1871: from per_applications

1867: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1868:
1869: cursor csr_apl_yesterday(cp_person_id number, cp_effective_date date) is
1870: select application_id, date_received, object_version_number
1871: from per_applications
1872: where person_id = cp_person_id
1873: and date_end = cp_effective_date-1;
1874:
1875: -- start changes for bug 8337406

Line 1890: l_future_apl_id per_applications.application_id%TYPE;

1886: -- start changes for bug 8337406
1887:
1888: l_proc constant varchar2(100) := g_package||
1889: '.create_application';
1890: l_future_apl_id per_applications.application_id%TYPE;
1891: l_fut_apl_date_received per_applications.date_received%TYPE;
1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1893:
1894: l_current_apl_id per_applications.application_id%TYPE;

Line 1891: l_fut_apl_date_received per_applications.date_received%TYPE;

1887:
1888: l_proc constant varchar2(100) := g_package||
1889: '.create_application';
1890: l_future_apl_id per_applications.application_id%TYPE;
1891: l_fut_apl_date_received per_applications.date_received%TYPE;
1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1893:
1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;

Line 1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;

1888: l_proc constant varchar2(100) := g_package||
1889: '.create_application';
1890: l_future_apl_id per_applications.application_id%TYPE;
1891: l_fut_apl_date_received per_applications.date_received%TYPE;
1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1893:
1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:

Line 1894: l_current_apl_id per_applications.application_id%TYPE;

1890: l_future_apl_id per_applications.application_id%TYPE;
1891: l_fut_apl_date_received per_applications.date_received%TYPE;
1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1893:
1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:
1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;

Line 1895: l_yesterday_apl_id per_applications.application_id%TYPE;

1891: l_fut_apl_date_received per_applications.date_received%TYPE;
1892: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1893:
1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:
1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;

Line 1897: l_application_id per_applications.application_id%TYPE;

1893:
1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:
1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;

Line 1898: l_date_received per_applications.date_received%TYPE;

1894: l_current_apl_id per_applications.application_id%TYPE;
1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:
1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;
1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;

Line 1899: l_apl_object_version_number per_applications.object_version_number%TYPE;

1895: l_yesterday_apl_id per_applications.application_id%TYPE;
1896:
1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;
1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1903: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;

Line 1901: l_del_fut_apl_id per_applications.application_id%TYPE;

1897: l_application_id per_applications.application_id%TYPE;
1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;
1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1903: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1904:
1905: l_appl_override_warning boolean;

Line 1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;

1898: l_date_received per_applications.date_received%TYPE;
1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;
1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1903: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1904:
1905: l_appl_override_warning boolean;
1906: l_rowcount number;

Line 1903: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;

1899: l_apl_object_version_number per_applications.object_version_number%TYPE;
1900:
1901: l_del_fut_apl_id per_applications.application_id%TYPE;
1902: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1903: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1904:
1905: l_appl_override_warning boolean;
1906: l_rowcount number;
1907: l_effective_date date;

Line 1909: l_date_received_OUT per_applications.date_received%TYPE;

1905: l_appl_override_warning boolean;
1906: l_rowcount number;
1907: l_effective_date date;
1908:
1909: l_date_received_OUT per_applications.date_received%TYPE;
1910: l_application_id_OUT per_applications.application_id%TYPE;
1911: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1912:
1913: begin

Line 1910: l_application_id_OUT per_applications.application_id%TYPE;

1906: l_rowcount number;
1907: l_effective_date date;
1908:
1909: l_date_received_OUT per_applications.date_received%TYPE;
1910: l_application_id_OUT per_applications.application_id%TYPE;
1911: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1912:
1913: begin
1914: if g_debug then

Line 1911: l_apl_ovn_OUT per_applications.object_version_number%TYPE;

1907: l_effective_date date;
1908:
1909: l_date_received_OUT per_applications.date_received%TYPE;
1910: l_application_id_OUT per_applications.application_id%TYPE;
1911: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1912:
1913: begin
1914: if g_debug then
1915: hr_utility.set_location(' Entering: '||l_proc,10);

Line 2161: l_future_apl_id per_applications.application_id%type;

2157: ,p_effective_date IN DATE
2158: )
2159: RETURN VARCHAR2 IS
2160: --
2161: l_future_apl_id per_applications.application_id%type;
2162: l_current_apl_id per_applications.application_id%type;
2163: l_yesterday_apl_id per_applications.application_id%type;
2164: l_raise_warning VARCHAR2(10);
2165:

Line 2162: l_current_apl_id per_applications.application_id%type;

2158: )
2159: RETURN VARCHAR2 IS
2160: --
2161: l_future_apl_id per_applications.application_id%type;
2162: l_current_apl_id per_applications.application_id%type;
2163: l_yesterday_apl_id per_applications.application_id%type;
2164: l_raise_warning VARCHAR2(10);
2165:
2166: cursor csr_fut_apl is

Line 2163: l_yesterday_apl_id per_applications.application_id%type;

2159: RETURN VARCHAR2 IS
2160: --
2161: l_future_apl_id per_applications.application_id%type;
2162: l_current_apl_id per_applications.application_id%type;
2163: l_yesterday_apl_id per_applications.application_id%type;
2164: l_raise_warning VARCHAR2(10);
2165:
2166: cursor csr_fut_apl is
2167: select application_id

Line 2168: from per_applications

2164: l_raise_warning VARCHAR2(10);
2165:
2166: cursor csr_fut_apl is
2167: select application_id
2168: from per_applications
2169: where person_id = p_person_id
2170: and date_received > p_effective_date
2171: order by date_received asc;
2172:

Line 2175: from per_applications

2171: order by date_received asc;
2172:
2173: cursor csr_current_apl is
2174: select application_id
2175: from per_applications
2176: where person_id = p_person_id
2177: and date_received < p_effective_date
2178: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
2179:

Line 2182: from per_applications

2178: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
2179:
2180: cursor csr_apl_yesterday is
2181: select application_id
2182: from per_applications
2183: where person_id = p_person_id
2184: and date_end = p_effective_date-1;
2185:
2186:

Line 2288: l_application_id per_applications.application_id%type;

2284: l_orig_hire_warning boolean;
2285: l_organization_id per_business_groups.organization_id%type;
2286: l_legislation_code per_business_groups.legislation_code%type;
2287: l_person_type_id per_people_f.person_type_id%type;
2288: l_application_id per_applications.application_id%type;
2289: l_comment_id per_assignments_f.comment_id%type;
2290: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2291: l_assignment_id per_assignments_f.assignment_id%type;
2292: l_object_version_number per_assignments_f.object_version_number%type;