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 1697: from per_applications

1693: ) IS
1694:
1695: cursor csr_fut_apl(cp_person_id number, cp_effective_date date) is
1696: select application_id, date_received, object_version_number
1697: from per_applications
1698: where person_id = cp_person_id
1699: and date_received > cp_effective_date
1700: order by date_received asc;
1701:

Line 1704: from per_applications

1700: order by date_received asc;
1701:
1702: cursor csr_current_apl(cp_person_id number, cp_effective_date date) is
1703: select application_id, date_received, object_version_number
1704: from per_applications
1705: where person_id = cp_person_id
1706: and date_received <= cp_effective_date
1707: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1708:

Line 1711: from per_applications

1707: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1708:
1709: cursor csr_apl_yesterday(cp_person_id number, cp_effective_date date) is
1710: select application_id, date_received, object_version_number
1711: from per_applications
1712: where person_id = cp_person_id
1713: and date_end = cp_effective_date-1;
1714:
1715: l_proc constant varchar2(100) := g_package||

Line 1717: l_future_apl_id per_applications.application_id%TYPE;

1713: and date_end = cp_effective_date-1;
1714:
1715: l_proc constant varchar2(100) := g_package||
1716: '.create_application';
1717: l_future_apl_id per_applications.application_id%TYPE;
1718: l_fut_apl_date_received per_applications.date_received%TYPE;
1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1720:
1721: l_current_apl_id per_applications.application_id%TYPE;

Line 1718: l_fut_apl_date_received per_applications.date_received%TYPE;

1714:
1715: l_proc constant varchar2(100) := g_package||
1716: '.create_application';
1717: l_future_apl_id per_applications.application_id%TYPE;
1718: l_fut_apl_date_received per_applications.date_received%TYPE;
1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1720:
1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;

Line 1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;

1715: l_proc constant varchar2(100) := g_package||
1716: '.create_application';
1717: l_future_apl_id per_applications.application_id%TYPE;
1718: l_fut_apl_date_received per_applications.date_received%TYPE;
1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1720:
1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:

Line 1721: l_current_apl_id per_applications.application_id%TYPE;

1717: l_future_apl_id per_applications.application_id%TYPE;
1718: l_fut_apl_date_received per_applications.date_received%TYPE;
1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1720:
1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:
1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;

Line 1722: l_yesterday_apl_id per_applications.application_id%TYPE;

1718: l_fut_apl_date_received per_applications.date_received%TYPE;
1719: l_fut_apl_ovn per_applications.object_version_number%TYPE;
1720:
1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:
1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;

Line 1724: l_application_id per_applications.application_id%TYPE;

1720:
1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:
1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;

Line 1725: l_date_received per_applications.date_received%TYPE;

1721: l_current_apl_id per_applications.application_id%TYPE;
1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:
1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;
1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;

Line 1726: l_apl_object_version_number per_applications.object_version_number%TYPE;

1722: l_yesterday_apl_id per_applications.application_id%TYPE;
1723:
1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;
1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1730: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;

Line 1728: l_del_fut_apl_id per_applications.application_id%TYPE;

1724: l_application_id per_applications.application_id%TYPE;
1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;
1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1730: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1731:
1732: l_appl_override_warning boolean;

Line 1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;

1725: l_date_received per_applications.date_received%TYPE;
1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;
1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1730: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1731:
1732: l_appl_override_warning boolean;
1733: l_rowcount number;

Line 1730: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;

1726: l_apl_object_version_number per_applications.object_version_number%TYPE;
1727:
1728: l_del_fut_apl_id per_applications.application_id%TYPE;
1729: l_del_fut_apl_date_received per_applications.date_received%TYPE;
1730: l_del_fut_apl_ovn per_applications.object_version_number%TYPE;
1731:
1732: l_appl_override_warning boolean;
1733: l_rowcount number;
1734: l_effective_date date;

Line 1736: l_date_received_OUT per_applications.date_received%TYPE;

1732: l_appl_override_warning boolean;
1733: l_rowcount number;
1734: l_effective_date date;
1735:
1736: l_date_received_OUT per_applications.date_received%TYPE;
1737: l_application_id_OUT per_applications.application_id%TYPE;
1738: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1739:
1740: begin

Line 1737: l_application_id_OUT per_applications.application_id%TYPE;

1733: l_rowcount number;
1734: l_effective_date date;
1735:
1736: l_date_received_OUT per_applications.date_received%TYPE;
1737: l_application_id_OUT per_applications.application_id%TYPE;
1738: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1739:
1740: begin
1741: if g_debug then

Line 1738: l_apl_ovn_OUT per_applications.object_version_number%TYPE;

1734: l_effective_date date;
1735:
1736: l_date_received_OUT per_applications.date_received%TYPE;
1737: l_application_id_OUT per_applications.application_id%TYPE;
1738: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1739:
1740: begin
1741: if g_debug then
1742: hr_utility.set_location(' Entering: '||l_proc,10);

Line 1951: l_future_apl_id per_applications.application_id%type;

1947: ,p_effective_date IN DATE
1948: )
1949: RETURN VARCHAR2 IS
1950: --
1951: l_future_apl_id per_applications.application_id%type;
1952: l_current_apl_id per_applications.application_id%type;
1953: l_yesterday_apl_id per_applications.application_id%type;
1954: l_raise_warning VARCHAR2(10);
1955:

Line 1952: l_current_apl_id per_applications.application_id%type;

1948: )
1949: RETURN VARCHAR2 IS
1950: --
1951: l_future_apl_id per_applications.application_id%type;
1952: l_current_apl_id per_applications.application_id%type;
1953: l_yesterday_apl_id per_applications.application_id%type;
1954: l_raise_warning VARCHAR2(10);
1955:
1956: cursor csr_fut_apl is

Line 1953: l_yesterday_apl_id per_applications.application_id%type;

1949: RETURN VARCHAR2 IS
1950: --
1951: l_future_apl_id per_applications.application_id%type;
1952: l_current_apl_id per_applications.application_id%type;
1953: l_yesterday_apl_id per_applications.application_id%type;
1954: l_raise_warning VARCHAR2(10);
1955:
1956: cursor csr_fut_apl is
1957: select application_id

Line 1958: from per_applications

1954: l_raise_warning VARCHAR2(10);
1955:
1956: cursor csr_fut_apl is
1957: select application_id
1958: from per_applications
1959: where person_id = p_person_id
1960: and date_received > p_effective_date
1961: order by date_received asc;
1962:

Line 1965: from per_applications

1961: order by date_received asc;
1962:
1963: cursor csr_current_apl is
1964: select application_id
1965: from per_applications
1966: where person_id = p_person_id
1967: and date_received < p_effective_date
1968: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
1969:

Line 1972: from per_applications

1968: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
1969:
1970: cursor csr_apl_yesterday is
1971: select application_id
1972: from per_applications
1973: where person_id = p_person_id
1974: and date_end = p_effective_date-1;
1975:
1976:

Line 2071: l_application_id per_applications.application_id%type;

2067: l_orig_hire_warning boolean;
2068: l_organization_id per_business_groups.organization_id%type;
2069: l_legislation_code per_business_groups.legislation_code%type;
2070: l_person_type_id per_people_f.person_type_id%type;
2071: l_application_id per_applications.application_id%type;
2072: l_comment_id per_assignments_f.comment_id%type;
2073: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2074: l_assignment_id per_assignments_f.assignment_id%type;
2075: l_object_version_number per_assignments_f.object_version_number%type;