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 1424: l_originators_name per_all_people_f.full_name%type;

1420: flowmode in varchar2) is
1421: --
1422: l_vacancy_name per_all_vacancies.name%type;
1423: l_transaction_id hr_api_transactions.transaction_id%type;
1424: l_originators_name per_all_people_f.full_name%type;
1425: --
1426: Begin
1427: --
1428: hr_utility.trace('Fetching transaction id :');

Line 1470: (p_person_id per_all_people_f.person_id%type)

1466: -- called internally to give the person name for the given user name --
1467: -- ----------------------------------------------------------------------------
1468: --
1469: FUNCTION getPersonNameFromID
1470: (p_person_id per_all_people_f.person_id%type)
1471: return per_all_people_f.full_name%type is
1472: --
1473: cursor csr_full_name
1474: is select full_name

Line 1471: return per_all_people_f.full_name%type is

1467: -- ----------------------------------------------------------------------------
1468: --
1469: FUNCTION getPersonNameFromID
1470: (p_person_id per_all_people_f.person_id%type)
1471: return per_all_people_f.full_name%type is
1472: --
1473: cursor csr_full_name
1474: is select full_name
1475: from per_all_people_f papf

Line 1475: from per_all_people_f papf

1471: return per_all_people_f.full_name%type is
1472: --
1473: cursor csr_full_name
1474: is select full_name
1475: from per_all_people_f papf
1476: where papf.person_id = p_person_id
1477: and trunc(sysdate) between effective_start_date
1478: and effective_end_date;
1479: --

Line 1480: l_employee_name per_all_people_f.full_name%type;

1476: where papf.person_id = p_person_id
1477: and trunc(sysdate) between effective_start_date
1478: and effective_end_date;
1479: --
1480: l_employee_name per_all_people_f.full_name%type;
1481: --
1482: BEGIN
1483: --
1484: hr_utility.trace('Finding Person name for person_id :' || p_person_id || ':');

Line 1541: l_applicant_name per_all_people_f.full_name%type;

1537: flowmode in varchar2) is
1538: --
1539: l_vacancy_name per_all_vacancies.name%type;
1540: l_transaction_id hr_api_transactions.transaction_id%type;
1541: l_applicant_name per_all_people_f.full_name%type;
1542: --
1543: Begin
1544: --
1545: hr_utility.trace('Fetching transaction id :');