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

Line 134: l_start_date per_all_people_f.start_date%TYPE;

130: l_proc varchar2(72) := g_package||'create_person';
131: l_person_type_id per_person_types.person_type_id%type:=
132: p_person_type_id;
133: l_person_id per_people_f.person_id%type;
134: l_start_date per_all_people_f.start_date%TYPE;
135: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
136: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
137: l_applicant_number number := null;
138: l_employee_number number;

Line 135: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;

131: l_person_type_id per_person_types.person_type_id%type:=
132: p_person_type_id;
133: l_person_id per_people_f.person_id%type;
134: l_start_date per_all_people_f.start_date%TYPE;
135: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
136: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
137: l_applicant_number number := null;
138: l_employee_number number;
139: l_npw_number number;

Line 136: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

132: p_person_type_id;
133: l_person_id per_people_f.person_id%type;
134: l_start_date per_all_people_f.start_date%TYPE;
135: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
136: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
137: l_applicant_number number := null;
138: l_employee_number number;
139: l_npw_number number;
140: l_dummy_var varchar2(30);

Line 147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

143: l_phone_id per_phones.phone_id%TYPE;
144: --
145: -- Declare additional OUT variables
146: --
147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
149: l_object_version_number per_all_people_f.object_version_number%TYPE;
150: l_full_name per_all_people_f.full_name%TYPE;
151: l_comment_id per_all_people_f.comment_id%TYPE;

Line 148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

144: --
145: -- Declare additional OUT variables
146: --
147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
149: l_object_version_number per_all_people_f.object_version_number%TYPE;
150: l_full_name per_all_people_f.full_name%TYPE;
151: l_comment_id per_all_people_f.comment_id%TYPE;
152: l_name_combination_warning boolean;

Line 149: l_object_version_number per_all_people_f.object_version_number%TYPE;

145: -- Declare additional OUT variables
146: --
147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
149: l_object_version_number per_all_people_f.object_version_number%TYPE;
150: l_full_name per_all_people_f.full_name%TYPE;
151: l_comment_id per_all_people_f.comment_id%TYPE;
152: l_name_combination_warning boolean;
153: l_orig_hire_warning boolean;

Line 150: l_full_name per_all_people_f.full_name%TYPE;

146: --
147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
149: l_object_version_number per_all_people_f.object_version_number%TYPE;
150: l_full_name per_all_people_f.full_name%TYPE;
151: l_comment_id per_all_people_f.comment_id%TYPE;
152: l_name_combination_warning boolean;
153: l_orig_hire_warning boolean;
154:

Line 151: l_comment_id per_all_people_f.comment_id%TYPE;

147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
148: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
149: l_object_version_number per_all_people_f.object_version_number%TYPE;
150: l_full_name per_all_people_f.full_name%TYPE;
151: l_comment_id per_all_people_f.comment_id%TYPE;
152: l_name_combination_warning boolean;
153: l_orig_hire_warning boolean;
154:
155: begin

Line 480: ,p_parent_table => 'PER_ALL_PEOPLE_F'

476: ,p_date_to => null
477: ,p_phone_type => 'W1'
478: ,p_phone_number => p_work_telephone
479: ,p_parent_id => l_person_id
480: ,p_parent_table => 'PER_ALL_PEOPLE_F'
481: ,p_validate => FALSE
482: ,p_effective_date => l_start_date
483: ,p_object_version_number => l_phn_object_version_number --out
484: ,p_phone_id => l_phone_id --out

Line 619: FROM per_all_people_f

615:
616: -- Fix 3637708 Start
617: SELECT object_version_number
618: INTO p_object_version_number
619: FROM per_all_people_f
620: WHERE person_id = l_person_id
621: And effective_start_Date = l_effective_start_date
622: and effective_end_Date = l_effective_end_date;
623: -- Fix 3637708 End

Line 812: l_start_date per_all_people_f.start_date%TYPE;

808: l_proc varchar2(72) := g_package||'create_person';
809: l_person_type_id per_person_types.person_type_id%type:=
810: p_person_type_id;
811: l_person_id per_people_f.person_id%type;
812: l_start_date per_all_people_f.start_date%TYPE;
813: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
814: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
815: l_applicant_number number := null;
816: l_employee_number number;

Line 813: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;

809: l_person_type_id per_person_types.person_type_id%type:=
810: p_person_type_id;
811: l_person_id per_people_f.person_id%type;
812: l_start_date per_all_people_f.start_date%TYPE;
813: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
814: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
815: l_applicant_number number := null;
816: l_employee_number number;
817: l_npw_number number;

Line 814: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

810: p_person_type_id;
811: l_person_id per_people_f.person_id%type;
812: l_start_date per_all_people_f.start_date%TYPE;
813: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
814: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
815: l_applicant_number number := null;
816: l_employee_number number;
817: l_npw_number number;
818: l_dummy_var varchar2(30);

Line 825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

821: l_phone_id per_phones.phone_id%TYPE;
822: --
823: -- Declare additional OUT variables
824: --
825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
827: l_object_version_number per_all_people_f.object_version_number%TYPE;
828: l_full_name per_all_people_f.full_name%TYPE;
829: l_comment_id per_all_people_f.comment_id%TYPE;

Line 826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

822: --
823: -- Declare additional OUT variables
824: --
825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
827: l_object_version_number per_all_people_f.object_version_number%TYPE;
828: l_full_name per_all_people_f.full_name%TYPE;
829: l_comment_id per_all_people_f.comment_id%TYPE;
830: l_name_combination_warning boolean;

Line 827: l_object_version_number per_all_people_f.object_version_number%TYPE;

823: -- Declare additional OUT variables
824: --
825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
827: l_object_version_number per_all_people_f.object_version_number%TYPE;
828: l_full_name per_all_people_f.full_name%TYPE;
829: l_comment_id per_all_people_f.comment_id%TYPE;
830: l_name_combination_warning boolean;
831: l_orig_hire_warning boolean;

Line 828: l_full_name per_all_people_f.full_name%TYPE;

824: --
825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
827: l_object_version_number per_all_people_f.object_version_number%TYPE;
828: l_full_name per_all_people_f.full_name%TYPE;
829: l_comment_id per_all_people_f.comment_id%TYPE;
830: l_name_combination_warning boolean;
831: l_orig_hire_warning boolean;
832:

Line 829: l_comment_id per_all_people_f.comment_id%TYPE;

825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
826: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
827: l_object_version_number per_all_people_f.object_version_number%TYPE;
828: l_full_name per_all_people_f.full_name%TYPE;
829: l_comment_id per_all_people_f.comment_id%TYPE;
830: l_name_combination_warning boolean;
831: l_orig_hire_warning boolean;
832:
833: begin

Line 1156: ,p_parent_table => 'PER_ALL_PEOPLE_F'

1152: ,p_date_to => null
1153: ,p_phone_type => 'W1'
1154: ,p_phone_number => p_work_telephone
1155: ,p_parent_id => l_person_id
1156: ,p_parent_table => 'PER_ALL_PEOPLE_F'
1157: ,p_validate => FALSE
1158: ,p_effective_date => l_start_date
1159: ,p_object_version_number => l_phn_object_version_number --out
1160: ,p_phone_id => l_phone_id --out

Line 1295: FROM per_all_people_f

1291:
1292: -- Fix 3637708 Start
1293: SELECT object_version_number
1294: INTO p_object_version_number
1295: FROM per_all_people_f
1296: WHERE person_id = l_person_id
1297: And effective_start_Date = l_effective_start_date
1298: and effective_end_Date = l_effective_end_date;
1299: -- Fix 3637708 End