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

Line 1144: -- by effective_date from the per_phones table. If effective_date is not passed

1140: --------------------------------------------------------------------------------
1141: -- -------------------------< get_phone_number >--------------------------------
1142: --------------------------------------------------------------------------------
1143: -- This function will return phone number by phone_type which is passed in and
1144: -- by effective_date from the per_phones table. If effective_date is not passed
1145: -- in, it will use the either the session date or sysdate.
1146: --
1147: -- NOTES:
1148: -- This is a generic procedure to get phone number by phone_type. The

Line 1189: from per_phones phn

1185: cursor csr_phones(c_effective_date in date) is
1186: select phn.phone_number
1187: ,phn.date_from
1188: ,phn.date_to
1189: from per_phones phn
1190: where phn.parent_id = p_person_id
1191: and phn.parent_table = 'PER_ALL_PEOPLE_F'
1192: and phn.phone_type = p_phone_type
1193: and c_effective_date between phn.date_from and

Line 1228: -- This function will return the work phone number from PER_PHONES

1224:
1225: END get_phone_number;
1226:
1227: --------------------------------------------------------------------------------
1228: -- This function will return the work phone number from PER_PHONES
1229: --
1230: function GET_WORK_PHONE (
1231: p_person_id number) return varchar2 is
1232: --

Line 1234: l_per_phones_phone varchar2(60);

1230: function GET_WORK_PHONE (
1231: p_person_id number) return varchar2 is
1232: --
1233: l_per_people_phone varchar2(60);
1234: l_per_phones_phone varchar2(60);
1235: l_effective_date date;
1236: cursor csr_phones1(c_effective_date in date) is
1237: select phone_number
1238: from per_phones phn

Line 1238: from per_phones phn

1234: l_per_phones_phone varchar2(60);
1235: l_effective_date date;
1236: cursor csr_phones1(c_effective_date in date) is
1237: select phone_number
1238: from per_phones phn
1239: where phn.parent_id = p_person_id
1240: and phn.parent_table = 'PER_ALL_PEOPLE_F'
1241: and phn.phone_type = 'W1'
1242: and c_effective_date between phn.date_from and

Line 1249: fetch csr_phones1 into l_per_phones_phone;

1245:
1246: begin
1247: l_effective_date := hr_general.effective_date;
1248: open csr_phones1(l_effective_date);
1249: fetch csr_phones1 into l_per_phones_phone;
1250: close csr_phones1;
1251: return l_per_phones_phone;
1252:
1253: end get_work_phone;

Line 1251: return l_per_phones_phone;

1247: l_effective_date := hr_general.effective_date;
1248: open csr_phones1(l_effective_date);
1249: fetch csr_phones1 into l_per_phones_phone;
1250: close csr_phones1;
1251: return l_per_phones_phone;
1252:
1253: end get_work_phone;
1254: --------------------------------------------------------------------------------
1255: -- This function will return the home phone number from PER_PHONES

Line 1255: -- This function will return the home phone number from PER_PHONES

1251: return l_per_phones_phone;
1252:
1253: end get_work_phone;
1254: --------------------------------------------------------------------------------
1255: -- This function will return the home phone number from PER_PHONES
1256: --
1257: function GET_HOME_PHONE (
1258:
1259: p_person_id number) return varchar2 is

Line 1262: l_per_phones_phone varchar2(60);

1258:
1259: p_person_id number) return varchar2 is
1260: --
1261: l_per_address_phone varchar2(60);
1262: l_per_phones_phone varchar2(60);
1263:
1264: cursor csr_phones1 is
1265: select phone_number
1266: from per_phones phn,

Line 1266: from per_phones phn,

1262: l_per_phones_phone varchar2(60);
1263:
1264: cursor csr_phones1 is
1265: select phone_number
1266: from per_phones phn,
1267: fnd_sessions f
1268: where phn.parent_id = p_person_id
1269: and phn.parent_table = 'PER_ALL_PEOPLE_F'
1270: and phn.phone_type = 'H1'

Line 1288: fetch csr_phones1 into l_per_phones_phone;

1284:
1285: begin
1286:
1287: open csr_phones1;
1288: fetch csr_phones1 into l_per_phones_phone;
1289: close csr_phones1;
1290:
1291: if l_per_phones_phone is not null then
1292: return l_per_phones_phone;

Line 1291: if l_per_phones_phone is not null then

1287: open csr_phones1;
1288: fetch csr_phones1 into l_per_phones_phone;
1289: close csr_phones1;
1290:
1291: if l_per_phones_phone is not null then
1292: return l_per_phones_phone;
1293: else
1294: open csr_phones2;
1295: fetch csr_phones2 into l_per_address_phone;

Line 1292: return l_per_phones_phone;

1288: fetch csr_phones1 into l_per_phones_phone;
1289: close csr_phones1;
1290:
1291: if l_per_phones_phone is not null then
1292: return l_per_phones_phone;
1293: else
1294: open csr_phones2;
1295: fetch csr_phones2 into l_per_address_phone;
1296: close csr_phones2;