DBA Data[Home] [Help]

APPS.HR_PERSON_API dependencies on PER_PERSON_TYPES

Line 162: l_person_type_id per_person_types.person_type_id%type :=

158: -- Declare cursors and local variables
159: --
160: l_proc varchar2(72) := g_package||'update_person';
161: l_effective_date date;
162: l_person_type_id per_person_types.person_type_id%type :=
163: p_person_type_id;
164: l_person_type_id1 per_person_types.person_type_id%type :=
165: p_person_type_id;
166: l_business_group_id per_people_f.business_group_id%type;

Line 164: l_person_type_id1 per_person_types.person_type_id%type :=

160: l_proc varchar2(72) := g_package||'update_person';
161: l_effective_date date;
162: l_person_type_id per_person_types.person_type_id%type :=
163: p_person_type_id;
164: l_person_type_id1 per_person_types.person_type_id%type :=
165: p_person_type_id;
166: l_business_group_id per_people_f.business_group_id%type;
167: l_old_person_type_id per_all_people_f.person_type_id%type;
168: l_current_system_person_type per_person_types.system_person_type%type;

Line 168: l_current_system_person_type per_person_types.system_person_type%type;

164: l_person_type_id1 per_person_types.person_type_id%type :=
165: p_person_type_id;
166: l_business_group_id per_people_f.business_group_id%type;
167: l_old_person_type_id per_all_people_f.person_type_id%type;
168: l_current_system_person_type per_person_types.system_person_type%type;
169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;

Line 209: from per_person_types pet

205: and per.effective_end_date;
206: --
207: cursor csr_system_type(p_person_type_id1 number) is
208: select pet.system_person_type
209: from per_person_types pet
210: where pet.person_type_id=p_person_type_id1;
211: --
212: cursor csr_period_of_service is
213: select pds.period_of_service_id, pds.object_version_number, pds.adjusted_svc_date

Line 1776: FROM per_person_types typ

1772:
1773: --for bug 7369431
1774: cursor chk_person_type is
1775: SELECT typ.system_person_type
1776: FROM per_person_types typ
1777: ,per_person_type_usages_f ptu
1778: WHERE typ.person_type_id = ptu.person_type_id
1779: AND p_effective_date BETWEEN ptu.effective_start_date
1780: AND ptu.effective_end_date