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 520: FROM per_all_people_f

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

Line 540: from per_all_people_f

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

Line 781: l_person per_all_people_f%ROWTYPE;

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

Line 807: FROM per_all_people_f

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

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

1949: -- are within CTR.DATE_START and CTR.DATE_END date range.
1950: -- Now the validation is relaxed(removed).
1951: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.
1952: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be
1953: -- within the date range of PER_ALL_PEOPLE_F is still alive.
1954: chk_dates(
1955: x_contact_relationship_id => x_contact_relationship_id,
1956: x_date_start => x_date_start,
1957: x_date_end => x_date_end);

Line 2315: FROM PER_ALL_PEOPLE_F paf

2311:
2312: DELETE FROM hr_comments h
2313: WHERE h.comment_id IN
2314: (SELECT comment_id
2315: FROM PER_ALL_PEOPLE_F paf
2316: WHERE paf.person_id = X_Contact_Person_Id);
2317:
2318: -- added for 1931258
2319: ben_person_delete.delete_ben_rows(X_Contact_Person_Id);

Line 2321: DELETE per_all_people_f

2317:
2318: -- added for 1931258
2319: ben_person_delete.delete_ben_rows(X_Contact_Person_Id);
2320:
2321: DELETE per_all_people_f
2322: WHERE person_id = X_Contact_Person_Id;
2323:
2324: END IF;
2325: END Delete_Row;

Line 2578: FROM per_all_people_f ppf,per_person_type_usages ptu

2574: --
2575: --
2576: CURSOR Check_Person_Changed IS
2577: SELECT /*+ NO_EXPAND */ 'Y'
2578: FROM per_all_people_f ppf,per_person_type_usages ptu
2579: WHERE ppf.person_id=X_Contact_Person_id
2580: AND X_Session_Date BETWEEN
2581: ppf.effective_start_date AND ppf.effective_end_date
2582: AND ppf.last_name = X_Last_Name

Line 2734: FROM per_all_people_f

2730: OR (ppf.known_as IS NULL AND X_known_as IS NULL));
2731: --
2732: CURSOR Check_For_Person_Rows IS
2733: SELECT 'Y'
2734: FROM per_all_people_f
2735: WHERE person_id = X_Contact_Person_Id
2736: HAVING COUNT(person_id) > 1;
2737: --
2738: -- bug fix 4281500 start here --

Line 2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;

2771: l_order_name VARCHAR2(240);
2772: l_person_id NUMBER;
2773: l_rowid VARCHAR2(30):=null;
2774: l_dup_name VARCHAR2(1);
2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2776: l_email_address per_all_people_f.email_address%TYPE;
2777: l_employee_number per_all_people_f.employee_number%TYPE;
2778: l_applicant_number per_all_people_f.applicant_number%TYPE;
2779: l_npw_number per_all_people_f.npw_number%TYPE;

Line 2776: l_email_address per_all_people_f.email_address%TYPE;

2772: l_person_id NUMBER;
2773: l_rowid VARCHAR2(30):=null;
2774: l_dup_name VARCHAR2(1);
2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2776: l_email_address per_all_people_f.email_address%TYPE;
2777: l_employee_number per_all_people_f.employee_number%TYPE;
2778: l_applicant_number per_all_people_f.applicant_number%TYPE;
2779: l_npw_number per_all_people_f.npw_number%TYPE;
2780: --

Line 2777: l_employee_number per_all_people_f.employee_number%TYPE;

2773: l_rowid VARCHAR2(30):=null;
2774: l_dup_name VARCHAR2(1);
2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2776: l_email_address per_all_people_f.email_address%TYPE;
2777: l_employee_number per_all_people_f.employee_number%TYPE;
2778: l_applicant_number per_all_people_f.applicant_number%TYPE;
2779: l_npw_number per_all_people_f.npw_number%TYPE;
2780: --
2781: CURSOR Lock_Person_Row IS

Line 2778: l_applicant_number per_all_people_f.applicant_number%TYPE;

2774: l_dup_name VARCHAR2(1);
2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2776: l_email_address per_all_people_f.email_address%TYPE;
2777: l_employee_number per_all_people_f.employee_number%TYPE;
2778: l_applicant_number per_all_people_f.applicant_number%TYPE;
2779: l_npw_number per_all_people_f.npw_number%TYPE;
2780: --
2781: CURSOR Lock_Person_Row IS
2782: SELECT ROWIDTOCHAR(ROWID)

Line 2779: l_npw_number per_all_people_f.npw_number%TYPE;

2775: l_previous_last_name per_all_people_f.previous_last_name%TYPE;
2776: l_email_address per_all_people_f.email_address%TYPE;
2777: l_employee_number per_all_people_f.employee_number%TYPE;
2778: l_applicant_number per_all_people_f.applicant_number%TYPE;
2779: l_npw_number per_all_people_f.npw_number%TYPE;
2780: --
2781: CURSOR Lock_Person_Row IS
2782: SELECT ROWIDTOCHAR(ROWID)
2783: , previous_last_name, email_address, employee_number -- #3889584

Line 2785: FROM per_all_people_f

2781: CURSOR Lock_Person_Row IS
2782: SELECT ROWIDTOCHAR(ROWID)
2783: , previous_last_name, email_address, employee_number -- #3889584
2784: , applicant_number, npw_number
2785: FROM per_all_people_f
2786: WHERE person_id = X_Contact_Person_Id;
2787: --Locking of row is cauising ORA-1002, if any statements present in
2788: --cursor for loop. Have logged bug 2030142 for this, for now will
2789: --remove the lock.

Line 2795: from per_all_people_f

2791: --
2792: -- Changes for HR/TCA Merge
2793: cursor c_person is
2794: select *
2795: from per_all_people_f
2796: where ROWID =CHARTOROWID(l_rowid);
2797: --
2798: l_person per_all_people_f%rowtype;
2799: --

Line 2798: l_person per_all_people_f%rowtype;

2794: select *
2795: from per_all_people_f
2796: where ROWID =CHARTOROWID(l_rowid);
2797: --
2798: l_person per_all_people_f%rowtype;
2799: --
2800: -- Bug 4295302
2801: --
2802: CURSOR get_old_ppf (cv_person_id IN NUMBER)

Line 2816: FROM per_all_people_f

2812: attribute12, attribute13, attribute14, attribute15, attribute16,
2813: attribute17, attribute18, attribute19, attribute20, attribute21,
2814: attribute22, attribute23, attribute24, attribute25, attribute26,
2815: attribute27, attribute28, attribute29, attribute30, NULL
2816: FROM per_all_people_f
2817: WHERE x_session_date BETWEEN effective_start_date AND effective_end_date
2818: AND person_id = cv_person_id;
2819: --
2820: l_ppf_ler_new_rec ben_ppf_ler.g_ppf_ler_rec;

Line 2988: UPDATE PER_ALL_PEOPLE_F

2984: p_global_name => l_global_name,
2985: p_local_name => l_local_name,
2986: p_duplicate_flag => l_dup_name
2987: );
2988: UPDATE PER_ALL_PEOPLE_F
2989: SET
2990: person_type_id = -- X_Person_Type_Id,
2991: hr_person_type_usage_info.get_default_person_type_id(X_Person_Type_Id),
2992: last_name = X_Last_Name,