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 1451: l_business_group_id per_all_people_f.business_group_id%TYPE;

1447:
1448: IS
1449: l_procedure VARCHAR2(100);
1450: p_message_name VARCHAR2(100);
1451: l_business_group_id per_all_people_f.business_group_id%TYPE;
1452: l_message VARCHAR2(250);
1453:
1454: CURSOR csr_person IS
1455: SELECT per_information4

Line 1473: l_per_information4 per_all_people_f.per_information4%TYPE;

1469: WHERE p_effective_date BETWEEN effective_start_date
1470: AND effective_end_date
1471: AND person_id = p_person_id;
1472:
1473: l_per_information4 per_all_people_f.per_information4%TYPE;
1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;

Line 1474: l_per_information5 per_all_people_f.per_information5%TYPE;

1470: AND effective_end_date
1471: AND person_id = p_person_id;
1472:
1473: l_per_information4 per_all_people_f.per_information4%TYPE;
1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;

Line 1475: l_per_information6 per_all_people_f.per_information6%TYPE;

1471: AND person_id = p_person_id;
1472:
1473: l_per_information4 per_all_people_f.per_information4%TYPE;
1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;

Line 1476: l_per_information7 per_all_people_f.per_information7%TYPE;

1472:
1473: l_per_information4 per_all_people_f.per_information4%TYPE;
1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;

Line 1477: l_per_information8 per_all_people_f.per_information8%TYPE;

1473: l_per_information4 per_all_people_f.per_information4%TYPE;
1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;

Line 1478: l_per_information9 per_all_people_f.per_information9%TYPE;

1474: l_per_information5 per_all_people_f.per_information5%TYPE;
1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;

Line 1479: l_per_information10 per_all_people_f.per_information10%TYPE;

1475: l_per_information6 per_all_people_f.per_information6%TYPE;
1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;

Line 1480: l_per_information11 per_all_people_f.per_information11%TYPE;

1476: l_per_information7 per_all_people_f.per_information7%TYPE;
1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;
1484: l_per_information15 per_all_people_f.per_information15%TYPE;

Line 1481: l_per_information12 per_all_people_f.per_information12%TYPE;

1477: l_per_information8 per_all_people_f.per_information8%TYPE;
1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;
1484: l_per_information15 per_all_people_f.per_information15%TYPE;
1485:

Line 1482: l_per_information13 per_all_people_f.per_information13%TYPE;

1478: l_per_information9 per_all_people_f.per_information9%TYPE;
1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;
1484: l_per_information15 per_all_people_f.per_information15%TYPE;
1485:
1486: BEGIN

Line 1483: l_per_information14 per_all_people_f.per_information14%TYPE;

1479: l_per_information10 per_all_people_f.per_information10%TYPE;
1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;
1484: l_per_information15 per_all_people_f.per_information15%TYPE;
1485:
1486: BEGIN
1487:

Line 1484: l_per_information15 per_all_people_f.per_information15%TYPE;

1480: l_per_information11 per_all_people_f.per_information11%TYPE;
1481: l_per_information12 per_all_people_f.per_information12%TYPE;
1482: l_per_information13 per_all_people_f.per_information13%TYPE;
1483: l_per_information14 per_all_people_f.per_information14%TYPE;
1484: l_per_information15 per_all_people_f.per_information15%TYPE;
1485:
1486: BEGIN
1487:
1488: l_procedure := g_package||'check_in_person_update';