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

Line 11: l_per_rec per_all_people_f%ROWTYPE;

7: g_pkg CONSTANT Varchar2(150) := 'PQP_HROSS_Integration.';
8: g_leg_code Varchar2(5);
9: g_emp_num_gen Varchar2(5);
10: g_debug_on Boolean;
11: l_per_rec per_all_people_f%ROWTYPE;
12: l_asg_rec per_all_assignments_f%ROWTYPE;
13: l_add_rec per_addresses%ROWTYPE;
14: l_cntct_rec per_contact_relationships%ROWTYPE;
15: l_phones_rec per_phones%ROWTYPE;

Line 20: (person_id per_all_people_f.person_id%TYPE

16: l_hr_soft_rec hr_soft_coding_keyflex%ROWTYPE;
17: l_ppl_grp_rec pay_people_groups%ROWTYPE;
18:
19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE
21: ,assignment_id per_all_assignments_f.assignment_id%TYPE
22: ,per_object_version_number per_all_people_f.object_version_number%TYPE
23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date

Line 22: ,per_object_version_number per_all_people_f.object_version_number%TYPE

18:
19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE
21: ,assignment_id per_all_assignments_f.assignment_id%TYPE
22: ,per_object_version_number per_all_people_f.object_version_number%TYPE
23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date
25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE

Line 26: ,full_name per_all_people_f.full_name%TYPE

22: ,per_object_version_number per_all_people_f.object_version_number%TYPE
23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date
25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE
27: ,per_comment_id per_all_people_f.comment_id%TYPE
28: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
29: ,assignment_number per_all_assignments_f.assignment_number%TYPE
30: ,name_combination_warning Boolean

Line 27: ,per_comment_id per_all_people_f.comment_id%TYPE

23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date
25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE
27: ,per_comment_id per_all_people_f.comment_id%TYPE
28: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
29: ,assignment_number per_all_assignments_f.assignment_number%TYPE
30: ,name_combination_warning Boolean
31: ,assign_payroll_warning Boolean

Line 70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE

66:
67: TYPE t_RehireEmp_Api IS RECORD
68: (assignment_id per_all_assignments_f.assignment_id%TYPE
69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
73: ,assignment_number per_all_assignments_f.assignment_number%TYPE
74: ,assign_payroll_warning Boolean

Line 71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE

67: TYPE t_RehireEmp_Api IS RECORD
68: (assignment_id per_all_assignments_f.assignment_id%TYPE
69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
73: ,assignment_number per_all_assignments_f.assignment_number%TYPE
74: ,assign_payroll_warning Boolean
75: );

Line 78: (effective_start_date per_all_people_f.effective_start_date%TYPE

74: ,assign_payroll_warning Boolean
75: );
76:
77: TYPE t_UpdEmp_Api IS RECORD
78: (effective_start_date per_all_people_f.effective_start_date%TYPE
79: ,effective_end_date per_all_people_f.effective_end_date%TYPE
80: ,full_name per_all_people_f.full_name%TYPE
81: ,comment_id Number
82: ,name_combination_warning Boolean

Line 79: ,effective_end_date per_all_people_f.effective_end_date%TYPE

75: );
76:
77: TYPE t_UpdEmp_Api IS RECORD
78: (effective_start_date per_all_people_f.effective_start_date%TYPE
79: ,effective_end_date per_all_people_f.effective_end_date%TYPE
80: ,full_name per_all_people_f.full_name%TYPE
81: ,comment_id Number
82: ,name_combination_warning Boolean
83: ,assign_payroll_warning Boolean

Line 80: ,full_name per_all_people_f.full_name%TYPE

76:
77: TYPE t_UpdEmp_Api IS RECORD
78: (effective_start_date per_all_people_f.effective_start_date%TYPE
79: ,effective_end_date per_all_people_f.effective_end_date%TYPE
80: ,full_name per_all_people_f.full_name%TYPE
81: ,comment_id Number
82: ,name_combination_warning Boolean
83: ,assign_payroll_warning Boolean
84: ,orig_hire_warning Boolean

Line 88: (effective_start_date per_all_people_f.effective_start_date%TYPE

84: ,orig_hire_warning Boolean
85: );
86:
87: TYPE t_HrToJob_Api IS RECORD
88: (effective_start_date per_all_people_f.effective_start_date%TYPE
89: ,effective_end_date per_all_people_f.effective_end_date%TYPE
90: ,assignment_id per_all_assignments_f.assignment_id%TYPE
91: ,assign_payroll_warning Boolean
92: ,orig_hire_warning Boolean

Line 89: ,effective_end_date per_all_people_f.effective_end_date%TYPE

85: );
86:
87: TYPE t_HrToJob_Api IS RECORD
88: (effective_start_date per_all_people_f.effective_start_date%TYPE
89: ,effective_end_date per_all_people_f.effective_end_date%TYPE
90: ,assignment_id per_all_assignments_f.assignment_id%TYPE
91: ,assign_payroll_warning Boolean
92: ,orig_hire_warning Boolean
93: );

Line 96: (effective_start_date per_all_people_f.effective_start_date%TYPE

92: ,orig_hire_warning Boolean
93: );
94:
95: TYPE t_HrApp_Api IS RECORD
96: (effective_start_date per_all_people_f.effective_start_date%TYPE
97: ,effective_end_date per_all_people_f.effective_end_date%TYPE
98: ,assign_payroll_warning Boolean
99: ,oversubscribed_vacancy_id Number
100: );

Line 97: ,effective_end_date per_all_people_f.effective_end_date%TYPE

93: );
94:
95: TYPE t_HrApp_Api IS RECORD
96: (effective_start_date per_all_people_f.effective_start_date%TYPE
97: ,effective_end_date per_all_people_f.effective_end_date%TYPE
98: ,assign_payroll_warning Boolean
99: ,oversubscribed_vacancy_id Number
100: );
101:

Line 110: ,full_name per_all_people_f.full_name%TYPE

106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,per_comment_id per_all_people_f.comment_id%TYPE
112: ,name_combination_warning Boolean
113: ,orig_hire_warning Boolean
114: );

Line 111: ,per_comment_id per_all_people_f.comment_id%TYPE

107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,per_comment_id per_all_people_f.comment_id%TYPE
112: ,name_combination_warning Boolean
113: ,orig_hire_warning Boolean
114: );
115:

Line 153: FROM per_all_people_f ppf

149: CURSOR csr_per (c_person_id IN Number
150: ,c_business_group_id IN Number
151: ,c_effective_date IN Date ) IS
152: SELECT *
153: FROM per_all_people_f ppf
154: WHERE ppf.person_id = c_person_id
155: AND ppf.business_group_id = c_business_group_id
156: AND c_effective_date BETWEEN ppf.effective_start_date
157: AND ppf.effective_end_date;

Line 170: FROM per_all_people_f ppf

166: ,ppf.effective_end_date
167: ,ppf.employee_number
168: ,ppt.person_type_id
169: ,ppf.person_id
170: FROM per_all_people_f ppf
171: ,per_person_types ppt
172: WHERE ppt.person_type_id = ppf.person_type_id
173: AND ppf.business_group_id = c_bg_grp_id
174: AND ppt.business_group_id = ppf.business_group_id

Line 1095: ,per_all_people_f ppf

1091: ,ppf.person_id
1092: ,ppf.object_version_number per_ovn
1093: ,paf.object_version_number asg_ovn
1094: FROM per_all_assignments_f paf
1095: ,per_all_people_f ppf
1096: WHERE paf.person_id = c_person_id
1097: AND paf.business_group_id = c_business_group_id
1098: AND paf.assignment_type = c_asg_type
1099: AND paf.assignment_id = c_assignment_id

Line 1277: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

1273:
1274: -- Now get the date-track mode to update the person as an employee
1275: Dt_Api.Find_DT_Upd_Modes
1276: (p_effective_date => l_effective_date
1277: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1278: ,p_base_key_column => 'PERSON_ID'
1279: ,p_base_key_value => l_cur_per_rec.person_id
1280: ,p_correction => l_dt_correction
1281: ,p_update => l_dt_update

Line 1611: ,per_all_people_f ppf

1607: ,c_effective_date IN Date) IS
1608: SELECT paf.assignment_id,
1609: ppf.object_version_number
1610: FROM per_all_assignments_f paf
1611: ,per_all_people_f ppf
1612: WHERE paf.person_id = c_person_id
1613: AND paf.business_group_id = c_business_group_id
1614: AND paf.person_id = ppf.person_id
1615: AND paf.assignment_type = 'E'

Line 1643: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

1639: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1640:
1641: Dt_Api.Find_DT_Upd_Modes
1642: (p_effective_date => p_hire_date
1643: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1644: ,p_base_key_column => 'PERSON_ID'
1645: ,p_base_key_value => l_cur_per_rec.person_id
1646: ,p_correction => l_dt_correction
1647: ,p_update => l_dt_update

Line 1984: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

1980: CLOSE csr_per;
1981: hr_utility.set_location(' l_cur_asg_rec: ' || l_cur_per_rec.person_id, 20);
1982: Dt_Api.Find_DT_Upd_Modes
1983: (p_effective_date => p_rehire_date
1984: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1985: ,p_base_key_column => 'PERSON_ID'
1986: ,p_base_key_value => l_cur_per_rec.person_id
1987: ,p_correction => l_dt_correction
1988: ,p_update => l_dt_update

Line 2237: l_person_id per_all_people_f.person_id%TYPE;

2233: ,p_adjusted_svc_date Date DEFAULT NULL
2234: ,p_per_comments Varchar2 DEFAULT NULL
2235: ,p_emp_api_out OUT NOCOPY t_hrEmpApi)AS
2236:
2237: l_person_id per_all_people_f.person_id%TYPE;
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;

Line 2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

2235: ,p_emp_api_out OUT NOCOPY t_hrEmpApi)AS
2236:
2237: l_person_id per_all_people_f.person_id%TYPE;
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;

Line 2243: l_full_name per_all_people_f.full_name%TYPE;

2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;
2244: l_per_comment_id per_all_people_f.comment_id%TYPE;
2245: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
2246: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2247: l_name_combination_warning Boolean;

Line 2244: l_per_comment_id per_all_people_f.comment_id%TYPE;

2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;
2244: l_per_comment_id per_all_people_f.comment_id%TYPE;
2245: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
2246: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2247: l_name_combination_warning Boolean;
2248: l_assign_payroll_warning Boolean;

Line 2699: ,per_all_people_f ppf

2695: ,c_effective_date IN Date) IS
2696: SELECT paf.assignment_id,
2697: ppf.object_version_number
2698: FROM per_all_assignments_f paf
2699: ,per_all_people_f ppf
2700: WHERE paf.person_id = c_person_id
2701: AND paf.business_group_id = c_business_group_id
2702: AND paf.person_id = ppf.person_id
2703: AND c_effective_date BETWEEN ppf.effective_start_date

Line 2934: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

2930: CLOSE csr_per;
2931:
2932: Dt_Api.Find_DT_Upd_Modes
2933: (p_effective_date => l_per_rec.START_DATE
2934: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
2935: ,p_base_key_column => 'PERSON_ID'
2936: ,p_base_key_value => l_cur_per_rec.person_id
2937: ,p_correction => l_dt_correction
2938: ,p_update => l_dt_update

Line 4943: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

4939: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4940:
4941: Dt_Api.Find_DT_Upd_Modes
4942: (p_effective_date => p_effective_date
4943: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4944: ,p_base_key_column => 'PERSON_ID'
4945: ,p_base_key_value => l_cur_per_rec.person_id
4946: ,p_correction => l_dt_correction
4947: ,p_update => l_dt_update

Line 6054: l_phones_rec.parent_table := 'PER_ALL_PEOPLE_F';

6050: l_phones_rec.phone_number := p_phone_number;
6051: l_phones_rec.date_from := p_phone_date_from;
6052: l_phones_rec.date_to := p_phone_date_to;
6053: l_phones_rec.party_id := l_party_id;
6054: l_phones_rec.parent_table := 'PER_ALL_PEOPLE_F';
6055:
6056: hr_utility.set_location('Phone Details assigned to record ', 140);
6057: -- ========================================================================
6058: -- ~ Soft Coding Keyflex field

Line 6756: -- Person Details: Per_All_People_F

6752: PROCEDURE Create_OSS_Person
6753: (p_business_group_id IN Number
6754: ,p_dup_person_id IN Number
6755: ,p_effective_date IN Date
6756: -- Person Details: Per_All_People_F
6757: ,p_party_id IN Number
6758: ,p_last_name IN Varchar2
6759: ,p_middle_name IN Varchar2
6760: ,p_first_name IN Varchar2