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_CONTACT_RELATIONSHIPS_PKG dependencies on PER_ALL_PEOPLE_F

Line 129: reasons for insert/update of PER_ALL_PEOPLE_F

125: contact date of birth is updated with a later
126: date.
127: 12-APR-05 abparekh 115.43 4295302 Called procedure ben_ppf_ler from Insert_Row
128: and Update_Contact to trigger life event
129: reasons for insert/update of PER_ALL_PEOPLE_F
130: records for a Contact
131: 13-APR-05 abparekh 115.44 4295302 Fixed GSCC Error
132: 15-JUN-05 bshukla 115.45 4432200 Fixed GSCC Error
133: 06-OCT-05 irgonzal 115.46 Fixed GSCC error: GSCC Standard - File.Pkg.9

Line 519: FROM per_all_people_f

515: CURSOR Check_For_Duplicate_Person IS
516: SELECT 'Y'
517: FROM sys.dual
518: WHERE EXISTS (SELECT NULL
519: FROM per_all_people_f
520: WHERE UPPER(last_name) = UPPER(X_Last_Name)
521: AND ( last_name like l_ul_check
522: or last_name like l_lu_check
523: or last_name like l_uu_check

Line 539: from per_all_people_f

535: select 'Y'
536: from dual
537: where exists
538: (select 'Y'
539: from per_all_people_f
540: where person_id = X_Contact_Person_Id);
541: --
542: l_dummy varchar2(10);
543: --

Line 780: l_person per_all_people_f%ROWTYPE;

776: --
777:
778: FUNCTION Insert_Person RETURN NUMBER IS
779: --
780: l_person per_all_people_f%ROWTYPE;
781: --
782: l_person_id NUMBER;
783: l_person_type_id NUMBER;
784: l_rowid VARCHAR2(30);

Line 806: FROM per_all_people_f

802: FROM sys.dual;
803: --
804: CURSOR c_person IS
805: SELECT *
806: FROM per_all_people_f
807: WHERE person_id = l_person_id
808: AND l_effective_start_date
809: BETWEEN effective_start_date
810: AND effective_end_date;

Line 1941: -- within the date range of PER_ALL_PEOPLE_F is still alive.

1937: -- are within CTR.DATE_START and CTR.DATE_END date range.
1938: -- Now the validation is relaxed(removed).
1939: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.
1940: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be
1941: -- within the date range of PER_ALL_PEOPLE_F is still alive.
1942: chk_dates(
1943: x_contact_relationship_id => x_contact_relationship_id,
1944: x_date_start => x_date_start,
1945: x_date_end => x_date_end);

Line 2303: FROM PER_ALL_PEOPLE_F paf

2299:
2300: DELETE FROM hr_comments h
2301: WHERE h.comment_id IN
2302: (SELECT comment_id
2303: FROM PER_ALL_PEOPLE_F paf
2304: WHERE paf.person_id = X_Contact_Person_Id);
2305:
2306: -- added for 1931258
2307: ben_person_delete.delete_ben_rows(X_Contact_Person_Id);

Line 2309: DELETE per_all_people_f

2305:
2306: -- added for 1931258
2307: ben_person_delete.delete_ben_rows(X_Contact_Person_Id);
2308:
2309: DELETE per_all_people_f
2310: WHERE person_id = X_Contact_Person_Id;
2311:
2312: END IF;
2313: END Delete_Row;

Line 2568: FROM per_all_people_f ppf,per_person_type_usages ptu

2564: --
2565: --
2566: CURSOR Check_Person_Changed IS
2567: SELECT /*+ NO_EXPAND */ 'Y'
2568: FROM per_all_people_f ppf,per_person_type_usages ptu
2569: WHERE ppf.person_id=X_Contact_Person_id
2570: AND X_Session_Date BETWEEN
2571: ppf.effective_start_date AND ppf.effective_end_date
2572: AND ppf.last_name = X_Last_Name

Line 2724: FROM per_all_people_f

2720: OR (ppf.known_as IS NULL AND X_known_as IS NULL));
2721: --
2722: CURSOR Check_For_Person_Rows IS
2723: SELECT 'Y'
2724: FROM per_all_people_f
2725: WHERE person_id = X_Contact_Person_Id
2726: HAVING COUNT(person_id) > 1;
2727: --
2728: -- bug fix 4281500 start here --

Line 2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;

2761: l_order_name VARCHAR2(240);
2762: l_person_id NUMBER;
2763: l_rowid VARCHAR2(30):=null;
2764: l_dup_name VARCHAR2(1);
2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2766: l_email_address per_all_people_f.email_address%TYPE;
2767: l_employee_number per_all_people_f.employee_number%TYPE;
2768: l_applicant_number per_all_people_f.applicant_number%TYPE;
2769: l_npw_number per_all_people_f.npw_number%TYPE;

Line 2766: l_email_address per_all_people_f.email_address%TYPE;

2762: l_person_id NUMBER;
2763: l_rowid VARCHAR2(30):=null;
2764: l_dup_name VARCHAR2(1);
2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2766: l_email_address per_all_people_f.email_address%TYPE;
2767: l_employee_number per_all_people_f.employee_number%TYPE;
2768: l_applicant_number per_all_people_f.applicant_number%TYPE;
2769: l_npw_number per_all_people_f.npw_number%TYPE;
2770: --

Line 2767: l_employee_number per_all_people_f.employee_number%TYPE;

2763: l_rowid VARCHAR2(30):=null;
2764: l_dup_name VARCHAR2(1);
2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2766: l_email_address per_all_people_f.email_address%TYPE;
2767: l_employee_number per_all_people_f.employee_number%TYPE;
2768: l_applicant_number per_all_people_f.applicant_number%TYPE;
2769: l_npw_number per_all_people_f.npw_number%TYPE;
2770: --
2771: CURSOR Lock_Person_Row IS

Line 2768: l_applicant_number per_all_people_f.applicant_number%TYPE;

2764: l_dup_name VARCHAR2(1);
2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2766: l_email_address per_all_people_f.email_address%TYPE;
2767: l_employee_number per_all_people_f.employee_number%TYPE;
2768: l_applicant_number per_all_people_f.applicant_number%TYPE;
2769: l_npw_number per_all_people_f.npw_number%TYPE;
2770: --
2771: CURSOR Lock_Person_Row IS
2772: SELECT ROWIDTOCHAR(ROWID)

Line 2769: l_npw_number per_all_people_f.npw_number%TYPE;

2765: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2766: l_email_address per_all_people_f.email_address%TYPE;
2767: l_employee_number per_all_people_f.employee_number%TYPE;
2768: l_applicant_number per_all_people_f.applicant_number%TYPE;
2769: l_npw_number per_all_people_f.npw_number%TYPE;
2770: --
2771: CURSOR Lock_Person_Row IS
2772: SELECT ROWIDTOCHAR(ROWID)
2773: , previous_last_name, email_address, employee_number -- #3889584

Line 2775: FROM per_all_people_f

2771: CURSOR Lock_Person_Row IS
2772: SELECT ROWIDTOCHAR(ROWID)
2773: , previous_last_name, email_address, employee_number -- #3889584
2774: , applicant_number, npw_number
2775: FROM per_all_people_f
2776: WHERE person_id = X_Contact_Person_Id;
2777: --Locking of row is cauising ORA-1002, if any statements present in
2778: --cursor for loop. Have logged bug 2030142 for this, for now will
2779: --remove the lock.

Line 2785: from per_all_people_f

2781: --
2782: -- Changes for HR/TCA Merge
2783: cursor c_person is
2784: select *
2785: from per_all_people_f
2786: where ROWID =CHARTOROWID(l_rowid);
2787: --
2788: l_person per_all_people_f%rowtype;
2789: --

Line 2788: l_person per_all_people_f%rowtype;

2784: select *
2785: from per_all_people_f
2786: where ROWID =CHARTOROWID(l_rowid);
2787: --
2788: l_person per_all_people_f%rowtype;
2789: --
2790: -- Bug 4295302
2791: --
2792: CURSOR get_old_ppf (cv_person_id IN NUMBER)

Line 2806: FROM per_all_people_f

2802: attribute12, attribute13, attribute14, attribute15, attribute16,
2803: attribute17, attribute18, attribute19, attribute20, attribute21,
2804: attribute22, attribute23, attribute24, attribute25, attribute26,
2805: attribute27, attribute28, attribute29, attribute30, NULL
2806: FROM per_all_people_f
2807: WHERE x_session_date BETWEEN effective_start_date AND effective_end_date
2808: AND person_id = cv_person_id;
2809: --
2810: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;

Line 2978: UPDATE PER_ALL_PEOPLE_F

2974: p_global_name => l_global_name,
2975: p_local_name => l_local_name,
2976: p_duplicate_flag => l_dup_name
2977: );
2978: UPDATE PER_ALL_PEOPLE_F
2979: SET
2980: person_type_id = -- X_Person_Type_Id,
2981: hr_person_type_usage_info.get_default_person_type_id(X_Person_Type_Id),
2982: last_name = X_Last_Name,