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_PROCESS_PHONE_NUMBERS_SS dependencies on PER_PHONES

Line 1364: l_phone_id per_phones.phone_id%type;

1360: ,p_person_id out nocopy number
1361: ,p_phone_data out nocopy varchar2
1362: )is
1363:
1364: l_phone_id per_phones.phone_id%type;
1365: l_phone_type per_phones.phone_type%type;
1366: l_phone_number per_phones.phone_number%type;
1367: l_object_version_number per_phones.object_version_number%type;
1368: l_phone_type_meaning hr_lookups.meaning%TYPE;

Line 1365: l_phone_type per_phones.phone_type%type;

1361: ,p_phone_data out nocopy varchar2
1362: )is
1363:
1364: l_phone_id per_phones.phone_id%type;
1365: l_phone_type per_phones.phone_type%type;
1366: l_phone_number per_phones.phone_number%type;
1367: l_object_version_number per_phones.object_version_number%type;
1368: l_phone_type_meaning hr_lookups.meaning%TYPE;
1369: --StartRgistration

Line 1366: l_phone_number per_phones.phone_number%type;

1362: )is
1363:
1364: l_phone_id per_phones.phone_id%type;
1365: l_phone_type per_phones.phone_type%type;
1366: l_phone_number per_phones.phone_number%type;
1367: l_object_version_number per_phones.object_version_number%type;
1368: l_phone_type_meaning hr_lookups.meaning%TYPE;
1369: --StartRgistration
1370: l_contact_set varchar2(20);

Line 1367: l_object_version_number per_phones.object_version_number%type;

1363:
1364: l_phone_id per_phones.phone_id%type;
1365: l_phone_type per_phones.phone_type%type;
1366: l_phone_number per_phones.phone_number%type;
1367: l_object_version_number per_phones.object_version_number%type;
1368: l_phone_type_meaning hr_lookups.meaning%TYPE;
1369: --StartRgistration
1370: l_contact_set varchar2(20);
1371: l_proc varchar2(72) := g_package||'get_phone_data_from_tt';

Line 1938: l_phone_id per_phones.phone_id%TYPE;

1934: )
1935: IS
1936: l_count INTEGER;
1937: l_deleted_phone_count INTEGER;
1938: l_phone_id per_phones.phone_id%TYPE;
1939: l_phone_ovn per_phones.object_version_number%TYPE;
1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;

Line 1939: l_phone_ovn per_phones.object_version_number%TYPE;

1935: IS
1936: l_count INTEGER;
1937: l_deleted_phone_count INTEGER;
1938: l_phone_id per_phones.phone_id%TYPE;
1939: l_phone_ovn per_phones.object_version_number%TYPE;
1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;
1943: l_effective_date date;

Line 1940: l_phone_type per_phones.phone_type%TYPE;

1936: l_count INTEGER;
1937: l_deleted_phone_count INTEGER;
1938: l_phone_id per_phones.phone_id%TYPE;
1939: l_phone_ovn per_phones.object_version_number%TYPE;
1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;
1943: l_effective_date date;
1944: l_person_id per_all_people_f.person_id%TYPE;

Line 1941: l_phone_number per_phones.phone_number%TYPE;

1937: l_deleted_phone_count INTEGER;
1938: l_phone_id per_phones.phone_id%TYPE;
1939: l_phone_ovn per_phones.object_version_number%TYPE;
1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;
1943: l_effective_date date;
1944: l_person_id per_all_people_f.person_id%TYPE;
1945: l_per_or_contact varchar2(30);

Line 1942: l_deleted_ovn per_phones.object_version_number%TYPE;

1938: l_phone_id per_phones.phone_id%TYPE;
1939: l_phone_ovn per_phones.object_version_number%TYPE;
1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;
1943: l_effective_date date;
1944: l_person_id per_all_people_f.person_id%TYPE;
1945: l_per_or_contact varchar2(30);
1946: l_trs_object_version_number