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 52: (person_id per_all_people_f.person_id%type

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

Line 54: ,per_object_version_number per_all_people_f.object_version_number%type

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

Line 58: ,full_name per_all_people_f.full_name%type

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

Line 59: ,per_comment_id per_all_people_f.comment_id%type

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

Line 62: ,pdp_object_version_number per_all_people_f.object_version_number%type

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

Line 103: ,per_effective_start_date per_all_people_f.effective_start_date%type

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

Line 104: ,per_effective_end_date per_all_people_f.effective_end_date%type

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

Line 111: (effective_start_date per_all_people_f.effective_start_date%type

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

Line 112: ,effective_end_date per_all_people_f.effective_end_date%type

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

Line 113: ,full_name per_all_people_f.full_name%type

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

Line 121: (effective_start_date per_all_people_f.effective_start_date%type

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

Line 122: ,effective_end_date per_all_people_f.effective_end_date%type

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

Line 129: (effective_start_date per_all_people_f.effective_start_date%type

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

Line 130: ,effective_end_date per_all_people_f.effective_end_date%type

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

Line 142: ,full_name per_all_people_f.full_name%type

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

Line 143: ,per_comment_id per_all_people_f.comment_id%type

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

Line 212: from per_all_people_f ppf

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

Line 229: from per_all_people_f ppf

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

Line 480: from per_all_people_f

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

Line 487: return per_all_people_f%rowtype is

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

Line 489: l_per_rec per_all_people_f%rowtype;

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

Line 654: return per_all_people_f%rowtype is

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

Line 670: l_per_rec per_all_people_f%rowtype;

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

Line 1662: l_national_identifier per_all_people_f.national_identifier%type;

1658: csr_get_unmasked_ni ref_cur_typ;
1659:
1660: l_proc_name constant varchar2(150) :='Get_UnMasked_NI';
1661: l_dyn_sql_qry varchar2(1000);
1662: l_national_identifier per_all_people_f.national_identifier%type;
1663:
1664: begin
1665: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1666:

Line 1716: from per_all_people_f ppf

1712: ,ppf.employee_number
1713: ,ppf.applicant_number
1714: ,ppf.npw_number
1715: ,ppf.party_id
1716: from per_all_people_f ppf
1717: where (ppf.date_of_birth = g_per_rec.date_of_birth
1718: or ppf.date_of_birth is null
1719: or g_per_rec.date_of_birth is null)
1720: and upper(ppf.last_name) = upper(g_per_rec.last_name)

Line 1736: from per_all_people_f ppf

1732: ,ppf.employee_number
1733: ,ppf.applicant_number
1734: ,ppf.npw_number
1735: ,ppf.party_id
1736: from per_all_people_f ppf
1737: where ppf.date_of_birth = g_per_rec.date_of_birth
1738: and upper(ppf.last_name) = upper(g_per_rec.last_name)
1739: and ppf.sex = g_per_rec.sex
1740: and ppf.business_group_id = c_business_group_id

Line 1747: l_person_id per_all_people_f.person_id%type := null;

1743:
1744: --l_per_rec csr_chk_ni_exists%rowtype;
1745: --$
1746: l_per_exists csr_chk_per_exists%rowtype;
1747: l_person_id per_all_people_f.person_id%type := null;
1748:
1749: l_proc_name constant varchar2(150) := g_pkg||'Chk_NI_Exists';
1750:
1751: begin

Line 1832: from per_all_people_f ppf

1828: ,ppf.employee_number
1829: ,ppf.applicant_number
1830: ,ppf.npw_number
1831: ,ppf.party_id
1832: from per_all_people_f ppf
1833: where ppf.national_identifier = c_national_identifier
1834: and ppf.business_group_id = c_business_group_id
1835: and c_effective_date between ppf.effective_start_date
1836: and ppf.effective_end_date;

Line 1841: l_person_id per_all_people_f.person_id%type := null;

1837:
1838: l_per_rec csr_chk_ni_exists%rowtype;
1839: --$
1840: --l_per_exists csr_chk_per_exists%rowtype;
1841: l_person_id per_all_people_f.person_id%type := null;
1842:
1843: l_proc_name constant varchar2(150) := g_pkg||'Chk_NI_Exists';
1844: begin
1845: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2074: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

2070: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
2071:
2072: Dt_Api.Find_DT_Upd_Modes
2073: (p_effective_date => g_per_rec.start_date
2074: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
2075: ,p_base_key_column => 'PERSON_ID'
2076: ,p_base_key_value => l_cur_per_rec.person_id
2077: ,p_correction => l_dt_correction
2078: ,p_update => l_dt_update

Line 2170: from per_all_people_f ppf

2166: ,ppf.npw_number
2167: ,ptu.person_type_id
2168: ,ppf.person_id
2169: ,ppf.object_version_number
2170: from per_all_people_f ppf
2171: ,per_person_type_usages_f ptu
2172: ,per_person_types ppt
2173: where ptu.person_type_id = ppf.person_type_id
2174: and ppt.person_type_id = ptu.person_type_id

Line 2192: l_person_id per_all_people_f.person_id%type;

2188: --
2189: e_InValid_PerType_Id exception;
2190: e_active_empcwk exception;
2191: e_active_apl exception;
2192: l_person_id per_all_people_f.person_id%type;
2193: l_party_id per_all_people_f.person_id%type;
2194: l_user_person_type per_person_types.user_person_type%TYPE;
2195: l_effective_date date;
2196: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';

Line 2193: l_party_id per_all_people_f.person_id%type;

2189: e_InValid_PerType_Id exception;
2190: e_active_empcwk exception;
2191: e_active_apl exception;
2192: l_person_id per_all_people_f.person_id%type;
2193: l_party_id per_all_people_f.person_id%type;
2194: l_user_person_type per_person_types.user_person_type%TYPE;
2195: l_effective_date date;
2196: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2197: begin

Line 3633: l_per_rec per_all_people_f%rowtype;

3629: ,p_adjusted_svc_date in date default null -- Added by pkagrawa
3630: ) is
3631:
3632: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Batch_Person';
3633: l_per_rec per_all_people_f%rowtype;
3634: l_cur_per_rec per_all_people_f%rowtype;
3635: l_ptu_rec chk_perType_usage%rowtype;
3636: l_datetrack_update_mode varchar2(50);
3637: l_dt_correction boolean;

Line 3634: l_cur_per_rec per_all_people_f%rowtype;

3630: ) is
3631:
3632: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Batch_Person';
3633: l_per_rec per_all_people_f%rowtype;
3634: l_cur_per_rec per_all_people_f%rowtype;
3635: l_ptu_rec chk_perType_usage%rowtype;
3636: l_datetrack_update_mode varchar2(50);
3637: l_dt_correction boolean;
3638: l_dt_update boolean;

Line 3659: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

3655: close csr_per;
3656: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
3657: Dt_Api.Find_DT_Upd_Modes
3658: (p_effective_date => g_per_rec.start_date
3659: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
3660: ,p_base_key_column => 'PERSON_ID'
3661: ,p_base_key_value => l_cur_per_rec.person_id
3662: ,p_correction => l_dt_correction
3663: ,p_update => l_dt_update

Line 4151: ,p_cur_rec in per_all_people_f%rowtype

4147: ,p_person_user_key in varchar2
4148: ,p_user_person_type in varchar2
4149: ,p_action_mode in varchar2
4150: ,p_datetrack_update_mode in varchar2
4151: ,p_cur_rec in per_all_people_f%rowtype
4152: ,p_adjusted_svc_date in date default null -- Added by pkagrawa
4153: ) is
4154:
4155: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Batch_Employee';

Line 4995: l_cur_per_rec per_all_people_f%rowtype;

4991: ,p_adjusted_svc_date date default null
4992: ,p_updper_api_out out NOCOPY t_UpdEmp_Api
4993: ) as
4994:
4995: l_cur_per_rec per_all_people_f%rowtype;
4996: l_per_rec per_all_people_f%rowtype;
4997: l_ptu_rec chk_perType_usage%rowtype;
4998: l_datetrack_update_mode varchar2(50);
4999: l_dt_correction boolean;

Line 4996: l_per_rec per_all_people_f%rowtype;

4992: ,p_updper_api_out out NOCOPY t_UpdEmp_Api
4993: ) as
4994:
4995: l_cur_per_rec per_all_people_f%rowtype;
4996: l_per_rec per_all_people_f%rowtype;
4997: l_ptu_rec chk_perType_usage%rowtype;
4998: l_datetrack_update_mode varchar2(50);
4999: l_dt_correction boolean;
5000: l_dt_update boolean;

Line 5022: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

5018: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5019:
5020: Dt_Api.Find_DT_Upd_Modes
5021: (p_effective_date => p_effective_date
5022: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5023: ,p_base_key_column => 'PERSON_ID'
5024: ,p_base_key_value => l_cur_per_rec.person_id
5025: ,p_correction => l_dt_correction
5026: ,p_update => l_dt_update

Line 5264: ,per_all_people_f ppf

5260: ,ppf.object_version_number per_ovn
5261: ,paf.object_version_number asg_ovn
5262: ,paf.effective_start_date -- For Hiring an applicant on the next day
5263: from per_all_assignments_f paf
5264: ,per_all_people_f ppf
5265: where paf.person_id = c_person_id
5266: and paf.business_group_id = c_business_group_id
5267: and paf.assignment_type = c_asg_type
5268: and paf.assignment_id = c_assignment_id

Line 5471: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

5467:
5468: -- Now get the date-track mode to update the person as an employee
5469: Dt_Api.Find_DT_Upd_Modes
5470: (p_effective_date => l_effective_date
5471: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5472: ,p_base_key_column => 'PERSON_ID'
5473: ,p_base_key_value => l_cur_per_rec.person_id
5474: ,p_correction => l_dt_correction
5475: ,p_update => l_dt_update

Line 5626: ,per_all_people_f ppf

5622: ,c_effective_date in date) is
5623: select paf.assignment_id,
5624: ppf.object_version_number
5625: from per_all_assignments_f paf
5626: ,per_all_people_f ppf
5627: where paf.person_id = c_person_id
5628: and paf.business_group_id = c_business_group_id
5629: and paf.person_id = ppf.person_id
5630: and c_effective_date between ppf.effective_start_date

Line 5657: ,p_base_table_name => 'PER_ALL_PEOPLE_F'

5653: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5654:
5655: Dt_Api.Find_DT_Upd_Modes
5656: (p_effective_date => p_hire_date
5657: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5658: ,p_base_key_column => 'PERSON_ID'
5659: ,p_base_key_value => l_cur_per_rec.person_id
5660: ,p_correction => l_dt_correction
5661: ,p_update => l_dt_update

Line 7331: l_cur_rec per_all_people_f%rowtype;

7327: l_Convert_To_Applicant boolean;
7328:
7329: l_Input_PerType varchar2(90);
7330: l_action_mode varchar2(90);
7331: l_cur_rec per_all_people_f%rowtype;
7332:
7333: l_user_person_type per_person_types.user_person_type%type;
7334: l_user_sequence number(10);
7335: l_link_value number;

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

10979: g_phn_rec.phone_type := p_phone_type;
10980: g_phn_rec.phone_number := p_phone_number;
10981: g_phn_rec.date_from := p_phone_date_from;
10982: g_phn_rec.date_to := p_phone_date_to;
10983: g_phn_rec.parent_table := 'PER_ALL_PEOPLE_F';
10984: end if;
10985: hr_utility.set_location('Phone Details assigned to record ', 140);
10986:
10987: -- ===========================================================================