APPS.IRC_APPROVALS dependencies on PER_ALL_PEOPLE_F

Line 1270: p_creator_person_id per_all_people_f.person_id%type default null;

1266: --
1267: FUNCTION getTopOffersApprover(transaction_id in varchar2)
1268: return fnd_user.user_id%type is
1269:
1270: p_creator_person_id per_all_people_f.person_id%type default null;
1271: c_approver_id per_all_people_f.person_id%type default null;
1272: c_top_approver_id per_all_people_f.person_id%type default null;
1273:
1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is

Line 1271: c_approver_id per_all_people_f.person_id%type default null;

1267: FUNCTION getTopOffersApprover(transaction_id in varchar2)
1268: return fnd_user.user_id%type is
1269:
1270: p_creator_person_id per_all_people_f.person_id%type default null;
1271: c_approver_id per_all_people_f.person_id%type default null;
1272: c_top_approver_id per_all_people_f.person_id%type default null;
1273:
1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is
1275: select supervisor_id

Line 1272: c_top_approver_id per_all_people_f.person_id%type default null;

1268: return fnd_user.user_id%type is
1269:
1270: p_creator_person_id per_all_people_f.person_id%type default null;
1271: c_approver_id per_all_people_f.person_id%type default null;
1272: c_top_approver_id per_all_people_f.person_id%type default null;
1273:
1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is
1275: select supervisor_id
1276: from per_all_assignments_f

Line 1402: l_originators_name per_all_people_f.full_name%type;

1398: flowmode in varchar2) is
1399: --
1400: l_vacancy_name per_all_vacancies.name%type;
1401: l_transaction_id hr_api_transactions.transaction_id%type;
1402: l_originators_name per_all_people_f.full_name%type;
1403: --
1404: Begin
1405: --
1406: hr_utility.trace('Fetching transaction id :');

Line 1456: (p_person_id per_all_people_f.person_id%type)

1452: -- called internally to give the person name for the given user name --
1453: -- ----------------------------------------------------------------------------
1454: --
1455: FUNCTION getPersonNameFromID
1456: (p_person_id per_all_people_f.person_id%type)
1457: return per_all_people_f.full_name%type is
1458: --
1459: cursor csr_full_name
1460: is select full_name

Line 1457: return per_all_people_f.full_name%type is

1453: -- ----------------------------------------------------------------------------
1454: --
1455: FUNCTION getPersonNameFromID
1456: (p_person_id per_all_people_f.person_id%type)
1457: return per_all_people_f.full_name%type is
1458: --
1459: cursor csr_full_name
1460: is select full_name
1461: from per_all_people_f papf

Line 1461: from per_all_people_f papf

1457: return per_all_people_f.full_name%type is
1458: --
1459: cursor csr_full_name
1460: is select full_name
1461: from per_all_people_f papf
1462: where papf.person_id = p_person_id
1463: and trunc(sysdate) between effective_start_date
1464: and effective_end_date;
1465: --

Line 1466: l_employee_name per_all_people_f.full_name%type;

1462: where papf.person_id = p_person_id
1463: and trunc(sysdate) between effective_start_date
1464: and effective_end_date;
1465: --
1466: l_employee_name per_all_people_f.full_name%type;
1467: --
1468: BEGIN
1469: --
1470: hr_utility.trace('Finding Person name for person_id :' || p_person_id || ':');

Line 1527: l_applicant_name per_all_people_f.full_name%type;

1523: flowmode in varchar2) is
1524: --
1525: l_vacancy_name per_all_vacancies.name%type;
1526: l_transaction_id hr_api_transactions.transaction_id%type;
1527: l_applicant_name per_all_people_f.full_name%type;
1528: --
1529: Begin
1530: --
1531: hr_utility.trace('Fetching transaction id :');