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.

[Home] [Help]

APPS.HR_GENERAL dependencies on PER_PHONES

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

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

Line 1191: from per_phones phn

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

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

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

Line 1236: l_per_phones_phone varchar2(60);

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

Line 1240: from per_phones phn

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

Line 1251: fetch csr_phones1 into l_per_phones_phone;

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

Line 1253: return l_per_phones_phone;

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

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

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

Line 1264: l_per_phones_phone varchar2(60);

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

Line 1268: from per_phones phn,

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

Line 1290: fetch csr_phones1 into l_per_phones_phone;

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

Line 1293: if l_per_phones_phone is not null then

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

Line 1294: return l_per_phones_phone;

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