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.PER_IN_PERSON_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 1498: l_business_group_id per_all_people_f.business_group_id%TYPE;

1494:
1495: IS
1496: l_procedure VARCHAR2(100);
1497: p_message_name VARCHAR2(100);
1498: l_business_group_id per_all_people_f.business_group_id%TYPE;
1499: l_message VARCHAR2(250);
1500:
1501: CURSOR csr_person IS
1502: SELECT per_information4

Line 1520: l_per_information4 per_all_people_f.per_information4%TYPE;

1516: WHERE p_effective_date BETWEEN effective_start_date
1517: AND effective_end_date
1518: AND person_id = p_person_id;
1519:
1520: l_per_information4 per_all_people_f.per_information4%TYPE;
1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;

Line 1521: l_per_information5 per_all_people_f.per_information5%TYPE;

1517: AND effective_end_date
1518: AND person_id = p_person_id;
1519:
1520: l_per_information4 per_all_people_f.per_information4%TYPE;
1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;

Line 1522: l_per_information6 per_all_people_f.per_information6%TYPE;

1518: AND person_id = p_person_id;
1519:
1520: l_per_information4 per_all_people_f.per_information4%TYPE;
1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;

Line 1523: l_per_information7 per_all_people_f.per_information7%TYPE;

1519:
1520: l_per_information4 per_all_people_f.per_information4%TYPE;
1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;

Line 1524: l_per_information8 per_all_people_f.per_information8%TYPE;

1520: l_per_information4 per_all_people_f.per_information4%TYPE;
1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;

Line 1525: l_per_information9 per_all_people_f.per_information9%TYPE;

1521: l_per_information5 per_all_people_f.per_information5%TYPE;
1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;

Line 1526: l_per_information10 per_all_people_f.per_information10%TYPE;

1522: l_per_information6 per_all_people_f.per_information6%TYPE;
1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;

Line 1527: l_per_information11 per_all_people_f.per_information11%TYPE;

1523: l_per_information7 per_all_people_f.per_information7%TYPE;
1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;
1531: l_per_information15 per_all_people_f.per_information15%TYPE;

Line 1528: l_per_information12 per_all_people_f.per_information12%TYPE;

1524: l_per_information8 per_all_people_f.per_information8%TYPE;
1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;
1531: l_per_information15 per_all_people_f.per_information15%TYPE;
1532:

Line 1529: l_per_information13 per_all_people_f.per_information13%TYPE;

1525: l_per_information9 per_all_people_f.per_information9%TYPE;
1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;
1531: l_per_information15 per_all_people_f.per_information15%TYPE;
1532:
1533: BEGIN

Line 1530: l_per_information14 per_all_people_f.per_information14%TYPE;

1526: l_per_information10 per_all_people_f.per_information10%TYPE;
1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;
1531: l_per_information15 per_all_people_f.per_information15%TYPE;
1532:
1533: BEGIN
1534:

Line 1531: l_per_information15 per_all_people_f.per_information15%TYPE;

1527: l_per_information11 per_all_people_f.per_information11%TYPE;
1528: l_per_information12 per_all_people_f.per_information12%TYPE;
1529: l_per_information13 per_all_people_f.per_information13%TYPE;
1530: l_per_information14 per_all_people_f.per_information14%TYPE;
1531: l_per_information15 per_all_people_f.per_information15%TYPE;
1532:
1533: BEGIN
1534:
1535: l_procedure := g_package||'check_in_person_update';