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

Line 15: g_per_rec per_all_people_f%rowtype;

11: g_apl_num_gen varchar2(5);
12: g_cwk_num_gen varchar2(5);
13: g_business_group_id number(15);
14:
15: g_per_rec per_all_people_f%rowtype;
16: g_scl_rec hr_soft_coding_keyflex%rowtype;
17: g_add_rec per_addresses%rowtype;
18: g_grp_rec pay_people_groups%rowtype;
19: g_asg_rec per_all_assignments_f%rowtype;

Line 51: (person_id per_all_people_f.person_id%type

47:
48: type ref_cur_typ is ref cursor;
49:
50: type t_hrempapi is record
51: (person_id per_all_people_f.person_id%type
52: ,assignment_id per_all_assignments_f.assignment_id%type
53: ,per_object_version_number per_all_people_f.object_version_number%type
54: ,asg_object_version_number per_all_assignments_f.object_version_number%type
55: ,per_effective_start_date date

Line 53: ,per_object_version_number per_all_people_f.object_version_number%type

49:
50: type t_hrempapi is record
51: (person_id per_all_people_f.person_id%type
52: ,assignment_id per_all_assignments_f.assignment_id%type
53: ,per_object_version_number per_all_people_f.object_version_number%type
54: ,asg_object_version_number per_all_assignments_f.object_version_number%type
55: ,per_effective_start_date date
56: ,per_effective_end_date date
57: ,full_name per_all_people_f.full_name%type

Line 57: ,full_name per_all_people_f.full_name%type

53: ,per_object_version_number per_all_people_f.object_version_number%type
54: ,asg_object_version_number per_all_assignments_f.object_version_number%type
55: ,per_effective_start_date date
56: ,per_effective_end_date date
57: ,full_name per_all_people_f.full_name%type
58: ,per_comment_id per_all_people_f.comment_id%type
59: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
60: ,assignment_number per_all_assignments_f.assignment_number%type
61: ,pdp_object_version_number per_all_people_f.object_version_number%type

Line 58: ,per_comment_id per_all_people_f.comment_id%type

54: ,asg_object_version_number per_all_assignments_f.object_version_number%type
55: ,per_effective_start_date date
56: ,per_effective_end_date date
57: ,full_name per_all_people_f.full_name%type
58: ,per_comment_id per_all_people_f.comment_id%type
59: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
60: ,assignment_number per_all_assignments_f.assignment_number%type
61: ,pdp_object_version_number per_all_people_f.object_version_number%type
62: ,name_combination_warning boolean

Line 61: ,pdp_object_version_number per_all_people_f.object_version_number%type

57: ,full_name per_all_people_f.full_name%type
58: ,per_comment_id per_all_people_f.comment_id%type
59: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
60: ,assignment_number per_all_assignments_f.assignment_number%type
61: ,pdp_object_version_number per_all_people_f.object_version_number%type
62: ,name_combination_warning boolean
63: ,assign_payroll_warning boolean
64: ,orig_hire_warning boolean
65: );

Line 102: ,per_effective_start_date per_all_people_f.effective_start_date%type

98:
99: type t_rehireemp_api is record
100: (assignment_id per_all_assignments_f.assignment_id%type
101: ,asg_object_version_number per_all_assignments_f.object_version_number%type
102: ,per_effective_start_date per_all_people_f.effective_start_date%type
103: ,per_effective_end_date per_all_people_f.effective_end_date%type
104: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
105: ,assignment_number per_all_assignments_f.assignment_number%type
106: ,assign_payroll_warning boolean

Line 103: ,per_effective_end_date per_all_people_f.effective_end_date%type

99: type t_rehireemp_api is record
100: (assignment_id per_all_assignments_f.assignment_id%type
101: ,asg_object_version_number per_all_assignments_f.object_version_number%type
102: ,per_effective_start_date per_all_people_f.effective_start_date%type
103: ,per_effective_end_date per_all_people_f.effective_end_date%type
104: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
105: ,assignment_number per_all_assignments_f.assignment_number%type
106: ,assign_payroll_warning boolean
107: );

Line 110: (effective_start_date per_all_people_f.effective_start_date%type

106: ,assign_payroll_warning boolean
107: );
108:
109: type t_updemp_api is record
110: (effective_start_date per_all_people_f.effective_start_date%type
111: ,effective_end_date per_all_people_f.effective_end_date%type
112: ,full_name per_all_people_f.full_name%type
113: ,comment_id number
114: ,name_combination_warning boolean

Line 111: ,effective_end_date per_all_people_f.effective_end_date%type

107: );
108:
109: type t_updemp_api is record
110: (effective_start_date per_all_people_f.effective_start_date%type
111: ,effective_end_date per_all_people_f.effective_end_date%type
112: ,full_name per_all_people_f.full_name%type
113: ,comment_id number
114: ,name_combination_warning boolean
115: ,assign_payroll_warning boolean

Line 112: ,full_name per_all_people_f.full_name%type

108:
109: type t_updemp_api is record
110: (effective_start_date per_all_people_f.effective_start_date%type
111: ,effective_end_date per_all_people_f.effective_end_date%type
112: ,full_name per_all_people_f.full_name%type
113: ,comment_id number
114: ,name_combination_warning boolean
115: ,assign_payroll_warning boolean
116: ,orig_hire_warning boolean

Line 120: (effective_start_date per_all_people_f.effective_start_date%type

116: ,orig_hire_warning boolean
117: );
118:
119: type t_hrtojob_api is record
120: (effective_start_date per_all_people_f.effective_start_date%type
121: ,effective_end_date per_all_people_f.effective_end_date%type
122: ,assignment_id per_all_assignments_f.assignment_id%type
123: ,assign_payroll_warning boolean
124: ,orig_hire_warning boolean

Line 121: ,effective_end_date per_all_people_f.effective_end_date%type

117: );
118:
119: type t_hrtojob_api is record
120: (effective_start_date per_all_people_f.effective_start_date%type
121: ,effective_end_date per_all_people_f.effective_end_date%type
122: ,assignment_id per_all_assignments_f.assignment_id%type
123: ,assign_payroll_warning boolean
124: ,orig_hire_warning boolean
125: );

Line 128: (effective_start_date per_all_people_f.effective_start_date%type

124: ,orig_hire_warning boolean
125: );
126:
127: type t_hrapp_api is record
128: (effective_start_date per_all_people_f.effective_start_date%type
129: ,effective_end_date per_all_people_f.effective_end_date%type
130: ,assign_payroll_warning boolean
131: ,oversubscribed_vacancy_id number
132: );

Line 129: ,effective_end_date per_all_people_f.effective_end_date%type

125: );
126:
127: type t_hrapp_api is record
128: (effective_start_date per_all_people_f.effective_start_date%type
129: ,effective_end_date per_all_people_f.effective_end_date%type
130: ,assign_payroll_warning boolean
131: ,oversubscribed_vacancy_id number
132: );
133:

Line 141: ,full_name per_all_people_f.full_name%type

137: ,per_person_id per_contact_relationships.contact_person_id%type
138: ,per_object_version_number per_contact_relationships.object_version_number%type
139: ,per_effective_start_date per_contact_relationships.date_start%type
140: ,per_effective_end_date per_contact_relationships.date_start%type
141: ,full_name per_all_people_f.full_name%type
142: ,per_comment_id per_all_people_f.comment_id%type
143: ,name_combination_warning boolean
144: ,orig_hire_warning boolean
145: );

Line 142: ,per_comment_id per_all_people_f.comment_id%type

138: ,per_object_version_number per_contact_relationships.object_version_number%type
139: ,per_effective_start_date per_contact_relationships.date_start%type
140: ,per_effective_end_date per_contact_relationships.date_start%type
141: ,full_name per_all_people_f.full_name%type
142: ,per_comment_id per_all_people_f.comment_id%type
143: ,name_combination_warning boolean
144: ,orig_hire_warning boolean
145: );
146:

Line 211: from per_all_people_f ppf

207: cursor csr_per (c_person_id in number
208: ,c_business_group_id in number
209: ,c_effective_date in date ) is
210: select *
211: from per_all_people_f ppf
212: where ppf.person_id = c_person_id
213: and ppf.business_group_id = c_business_group_id
214: and c_effective_date between ppf.effective_start_date
215: and ppf.effective_end_date;

Line 228: from per_all_people_f ppf

224: ,ppf.effective_end_date
225: ,ppf.employee_number
226: ,ppt.person_type_id
227: ,ppf.person_id
228: from per_all_people_f ppf
229: ,per_person_types ppt
230: where ppt.person_type_id = ppf.person_type_id
231: and ppf.business_group_id = c_bg_grp_id
232: and ppt.business_group_id = ppf.business_group_id

Line 479: from per_all_people_f

475: -- Cursor to get the Employee Number
476: --
477: cursor csr_get_employee_num(c_person_id in number) is
478: select employee_number
479: from per_all_people_f
480: where person_id = c_person_id;
481:
482: -- =============================================================================
483: -- Default_Record_Values:

Line 486: return per_all_people_f%rowtype is

482: -- =============================================================================
483: -- Default_Record_Values:
484: -- =============================================================================
485: function Default_Person_Rec
486: return per_all_people_f%rowtype is
487: l_proc_name constant varchar2(150) := g_pkg||'Default_Person_Rec';
488: l_per_rec per_all_people_f%rowtype;
489: begin
490:

Line 488: l_per_rec per_all_people_f%rowtype;

484: -- =============================================================================
485: function Default_Person_Rec
486: return per_all_people_f%rowtype is
487: l_proc_name constant varchar2(150) := g_pkg||'Default_Person_Rec';
488: l_per_rec per_all_people_f%rowtype;
489: begin
490:
491: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
492: /*

Line 653: return per_all_people_f%rowtype is

649: -- Get_PerRecord_Values:
650: -- =============================================================================
651: function Get_PerRecord_Values
652: (p_interface_code in varchar2 default null)
653: return per_all_people_f%rowtype is
654:
655: cursor bne_cols(c_interface_code in varchar2) is
656: select lower(bic.interface_col_name) interface_col_name
657: from bne_interface_cols_b bic

Line 669: l_per_rec per_all_people_f%rowtype;

665: from bne_interface_cols_b bic
666: where bic.interface_code = c_interface_code
667: and bic.display_flag ='N';
668:
669: l_per_rec per_all_people_f%rowtype;
670: col_name varchar2(150);
671: l_proc_name constant varchar2(150) := g_pkg||'Default_Person_Rec';
672: begin
673:

Line 1652: l_national_identifier per_all_people_f.national_identifier%type;

1648: csr_get_unmasked_ni ref_cur_typ;
1649:
1650: l_proc_name constant varchar2(150) :='Get_UnMasked_NI';
1651: l_dyn_sql_qry varchar2(1000);
1652: l_national_identifier per_all_people_f.national_identifier%type;
1653:
1654: begin
1655: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1656:

Line 1712: from per_all_people_f ppf

1708: ,ppf.employee_number
1709: ,ppf.applicant_number
1710: ,ppf.npw_number
1711: ,ppf.party_id
1712: from per_all_people_f ppf
1713: where ppf.national_identifier = c_national_identifier
1714: and ppf.business_group_id = c_business_group_id
1715: and c_effective_date between ppf.effective_start_date
1716: and ppf.effective_end_date;

Line 1731: from per_all_people_f ppf

1727: ,ppf.employee_number
1728: ,ppf.applicant_number
1729: ,ppf.npw_number
1730: ,ppf.party_id
1731: from per_all_people_f ppf
1732: where ppf.date_of_birth = g_per_rec.date_of_birth
1733: and ppf.last_name = g_per_rec.last_name
1734: and ppf.business_group_id = c_business_group_id
1735: and c_effective_date between ppf.effective_start_date

Line 1741: l_person_id per_all_people_f.person_id%type;

1737:
1738: l_per_rec csr_chk_ni_exists%rowtype;
1739: --$
1740: l_per_exists csr_chk_per_exists%rowtype;
1741: l_person_id per_all_people_f.person_id%type;
1742:
1743: l_proc_name constant varchar2(150) := g_pkg||'Chk_NI_Exists';
1744: begin
1745: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1972: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

1968: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1969:
1970: Dt_Api.Find_DT_Upd_Modes
1971: (p_effective_date => g_per_rec.start_date
1972: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1973: ,p_base_key_column => 'PERSON_ID'
1974: ,p_base_key_value => l_cur_per_rec.person_id
1975: ,p_correction => l_dt_correction
1976: ,p_update => l_dt_update

Line 2068: from per_all_people_f ppf

2064: ,ppf.npw_number
2065: ,ptu.person_type_id
2066: ,ppf.person_id
2067: ,ppf.object_version_number
2068: from per_all_people_f ppf
2069: ,per_person_type_usages_f ptu
2070: ,per_person_types ppt
2071: where ptu.person_type_id = ppf.person_type_id
2072: and ppt.person_type_id = ptu.person_type_id

Line 2090: l_person_id per_all_people_f.person_id%type;

2086: --
2087: e_InValid_PerType_Id exception;
2088: e_active_empcwk exception;
2089: e_active_apl exception;
2090: l_person_id per_all_people_f.person_id%type;
2091: l_party_id per_all_people_f.person_id%type;
2092: l_user_person_type per_person_types.user_person_type%TYPE;
2093: l_effective_date date;
2094: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';

Line 2091: l_party_id per_all_people_f.person_id%type;

2087: e_InValid_PerType_Id exception;
2088: e_active_empcwk exception;
2089: e_active_apl exception;
2090: l_person_id per_all_people_f.person_id%type;
2091: l_party_id per_all_people_f.person_id%type;
2092: l_user_person_type per_person_types.user_person_type%TYPE;
2093: l_effective_date date;
2094: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2095: begin

Line 3298: l_per_rec per_all_people_f%rowtype;

3294: ,p_adjusted_svc_date in date default null -- Added by pkagrawa
3295: ) is
3296:
3297: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Batch_Person';
3298: l_per_rec per_all_people_f%rowtype;
3299: l_cur_per_rec per_all_people_f%rowtype;
3300: l_ptu_rec chk_perType_usage%rowtype;
3301: l_datetrack_update_mode varchar2(50);
3302: l_dt_correction boolean;

Line 3299: l_cur_per_rec per_all_people_f%rowtype;

3295: ) is
3296:
3297: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Batch_Person';
3298: l_per_rec per_all_people_f%rowtype;
3299: l_cur_per_rec per_all_people_f%rowtype;
3300: l_ptu_rec chk_perType_usage%rowtype;
3301: l_datetrack_update_mode varchar2(50);
3302: l_dt_correction boolean;
3303: l_dt_update boolean;

Line 3324: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

3320: close csr_per;
3321: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
3322: Dt_Api.Find_DT_Upd_Modes
3323: (p_effective_date => g_per_rec.start_date
3324: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
3325: ,p_base_key_column => 'PERSON_ID'
3326: ,p_base_key_value => l_cur_per_rec.person_id
3327: ,p_correction => l_dt_correction
3328: ,p_update => l_dt_update

Line 3816: ,p_cur_rec in per_all_people_f%rowtype

3812: ,p_person_user_key in varchar2
3813: ,p_user_person_type in varchar2
3814: ,p_action_mode in varchar2
3815: ,p_datetrack_update_mode in varchar2
3816: ,p_cur_rec in per_all_people_f%rowtype
3817: ,p_adjusted_svc_date in date default null -- Added by pkagrawa
3818: ) is
3819:
3820: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_Employee';

Line 4660: l_cur_per_rec per_all_people_f%rowtype;

4656: ,p_adjusted_svc_date date default null
4657: ,p_updper_api_out out NOCOPY t_UpdEmp_Api
4658: ) as
4659:
4660: l_cur_per_rec per_all_people_f%rowtype;
4661: l_per_rec per_all_people_f%rowtype;
4662: l_ptu_rec chk_perType_usage%rowtype;
4663: l_datetrack_update_mode varchar2(50);
4664: l_dt_correction boolean;

Line 4661: l_per_rec per_all_people_f%rowtype;

4657: ,p_updper_api_out out NOCOPY t_UpdEmp_Api
4658: ) as
4659:
4660: l_cur_per_rec per_all_people_f%rowtype;
4661: l_per_rec per_all_people_f%rowtype;
4662: l_ptu_rec chk_perType_usage%rowtype;
4663: l_datetrack_update_mode varchar2(50);
4664: l_dt_correction boolean;
4665: l_dt_update boolean;

Line 4687: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

4683: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4684:
4685: Dt_Api.Find_DT_Upd_Modes
4686: (p_effective_date => p_effective_date
4687: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4688: ,p_base_key_column => 'PERSON_ID'
4689: ,p_base_key_value => l_cur_per_rec.person_id
4690: ,p_correction => l_dt_correction
4691: ,p_update => l_dt_update

Line 4928: ,per_all_people_f ppf

4924: ,ppf.object_version_number per_ovn
4925: ,paf.object_version_number asg_ovn
4926: ,paf.effective_start_date -- For Hiring an applicant on the next day
4927: from per_all_assignments_f paf
4928: ,per_all_people_f ppf
4929: where paf.person_id = c_person_id
4930: and paf.business_group_id = c_business_group_id
4931: and paf.assignment_type = c_asg_type
4932: and paf.assignment_id = c_assignment_id

Line 5135: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

5131:
5132: -- Now get the date-track mode to update the person as an employee
5133: Dt_Api.Find_DT_Upd_Modes
5134: (p_effective_date => l_effective_date
5135: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5136: ,p_base_key_column => 'PERSON_ID'
5137: ,p_base_key_value => l_cur_per_rec.person_id
5138: ,p_correction => l_dt_correction
5139: ,p_update => l_dt_update

Line 5290: ,per_all_people_f ppf

5286: ,c_effective_date in date) is
5287: select paf.assignment_id,
5288: ppf.object_version_number
5289: from per_all_assignments_f paf
5290: ,per_all_people_f ppf
5291: where paf.person_id = c_person_id
5292: and paf.business_group_id = c_business_group_id
5293: and paf.person_id = ppf.person_id
5294: and c_effective_date between ppf.effective_start_date

Line 5321: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

5317: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5318:
5319: Dt_Api.Find_DT_Upd_Modes
5320: (p_effective_date => p_hire_date
5321: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5322: ,p_base_key_column => 'PERSON_ID'
5323: ,p_base_key_value => l_cur_per_rec.person_id
5324: ,p_correction => l_dt_correction
5325: ,p_update => l_dt_update

Line 6927: l_cur_rec per_all_people_f%rowtype;

6923: l_Convert_To_Applicant boolean;
6924:
6925: l_Input_PerType varchar2(90);
6926: l_action_mode varchar2(90);
6927: l_cur_rec per_all_people_f%rowtype;
6928:
6929: l_user_person_type per_person_types.user_person_type%type;
6930: l_user_sequence number(10);
6931: l_link_value number;

Line 10324: g_phn_rec.parent_table := 'PER_ALL_PEOPLE_F';

10320: g_phn_rec.phone_type := p_phone_type;
10321: g_phn_rec.phone_number := p_phone_number;
10322: g_phn_rec.date_from := p_phone_date_from;
10323: g_phn_rec.date_to := p_phone_date_to;
10324: g_phn_rec.parent_table := 'PER_ALL_PEOPLE_F';
10325: end if;
10326: hr_utility.set_location('Phone Details assigned to record ', 140);
10327:
10328: -- ===========================================================================