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.GHR_COMPLAINTS2_PKG dependencies on PER_PEOPLE_F

Line 10: l_full_name per_people_f.full_name%TYPE := NULL;

6: ,p_effective_date IN DATE
7: ,p_full_name IN OUT NOCOPY VARCHAR2
8: ,p_ssn IN OUT NOCOPY VARCHAR2) IS
9:
10: l_full_name per_people_f.full_name%TYPE := NULL;
11: l_ssn per_people_f.national_identifier%TYPE := NULL;
12: l_record_found BOOLEAN := FALSE;
13:
14: /*

Line 11: l_ssn per_people_f.national_identifier%TYPE := NULL;

7: ,p_full_name IN OUT NOCOPY VARCHAR2
8: ,p_ssn IN OUT NOCOPY VARCHAR2) IS
9:
10: l_full_name per_people_f.full_name%TYPE := NULL;
11: l_ssn per_people_f.national_identifier%TYPE := NULL;
12: l_record_found BOOLEAN := FALSE;
13:
14: /*
15: CURSOR cur_cper IS

Line 25: FROM per_people_f per

21: -- Above commented by Sundar for performance changes
22: CURSOR cur_cper IS
23: SELECT per.full_name
24: ,per.national_identifier
25: FROM per_people_f per
26: WHERE per.person_id = p_complainant_person_id
27: AND p_effective_date between per.effective_start_date and per.effective_end_date;
28: -- NOCOPY variables
29: l_nc_full_name per_people_f.full_name%TYPE;

Line 29: l_nc_full_name per_people_f.full_name%TYPE;

25: FROM per_people_f per
26: WHERE per.person_id = p_complainant_person_id
27: AND p_effective_date between per.effective_start_date and per.effective_end_date;
28: -- NOCOPY variables
29: l_nc_full_name per_people_f.full_name%TYPE;
30: l_nc_ssn per_people_f.national_identifier%TYPE;
31:
32: BEGIN
33: -- NOCOPY Changes

Line 30: l_nc_ssn per_people_f.national_identifier%TYPE;

26: WHERE per.person_id = p_complainant_person_id
27: AND p_effective_date between per.effective_start_date and per.effective_end_date;
28: -- NOCOPY variables
29: l_nc_full_name per_people_f.full_name%TYPE;
30: l_nc_ssn per_people_f.national_identifier%TYPE;
31:
32: BEGIN
33: -- NOCOPY Changes
34: l_nc_full_name := p_full_name;

Line 690: l_full_name per_people_f.full_name%TYPE := NULL;

686: FUNCTION get_window_title(p_complaint_id IN NUMBER
687: ,p_effective_date IN DATE)
688: RETURN VARCHAR2 IS
689: --
690: l_full_name per_people_f.full_name%TYPE := NULL;
691: l_ssn per_people_f.national_identifier%TYPE := NULL;
692: l_complainant_person_id ghr_complaints2.complainant_person_id%TYPE := NULL;
693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;
694:

Line 691: l_ssn per_people_f.national_identifier%TYPE := NULL;

687: ,p_effective_date IN DATE)
688: RETURN VARCHAR2 IS
689: --
690: l_full_name per_people_f.full_name%TYPE := NULL;
691: l_ssn per_people_f.national_identifier%TYPE := NULL;
692: l_complainant_person_id ghr_complaints2.complainant_person_id%TYPE := NULL;
693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;
694:
695: CURSOR cur_cmp IS