Following HR (11i) api can be used for creating person extra information, below example show you how to insert a employee passport details into extra information tables using api.
Procedure create_pp_details(p_pp_country In Varchar2 -- passport issuing country
,p_pp_number In Varchar2 -- passport number
,p_pp_issue_date In date -- passport issue date
,p_pp_expiry_date In Date -- passport expiry date
,p_pp_issue_place In Varchar2 -- passport issue place
,p_person_id In Number
)
Is
l_person_extra_info_id Number;
l_object_version_number Number;
Begin
hr_person_extra_info_api.create_person_extra_info
(p_validate => false
,p_person_id => p_person_id -- employee person id
,p_information_type => 'PASSPORT_DETAILS' -- this is same as your extra person information flex filed code.
,p_pei_attribute_category => null
,p_pei_information_category => 'PASSPORT_DETAILS' -- this is same as your extra person information flex filed code.
,p_pei_information1 => p_pp_country
,p_pei_information2 => p_pp_number
,p_pei_information3 => to_char(p_pp_issue_date,'RRRR/MM/DD HH:MI:SS')
,p_pei_information4 => to_char(p_pp_expiry_date,'RRRR/MM/DD HH:MI:SS')
,p_pei_information5 => p_pp_issue_place
,p_person_extra_info_id => l_person_extra_info_id -- out values
,p_object_version_number => l_object_version_number -- out values
);
commit;
end;
Procedure create_pp_details(p_pp_country In Varchar2 -- passport issuing country
,p_pp_number In Varchar2 -- passport number
,p_pp_issue_date In date -- passport issue date
,p_pp_expiry_date In Date -- passport expiry date
,p_pp_issue_place In Varchar2 -- passport issue place
,p_person_id In Number
)
Is
l_person_extra_info_id Number;
l_object_version_number Number;
Begin
hr_person_extra_info_api.create_person_extra_info
(p_validate => false
,p_person_id => p_person_id -- employee person id
,p_information_type => 'PASSPORT_DETAILS' -- this is same as your extra person information flex filed code.
,p_pei_attribute_category => null
,p_pei_information_category => 'PASSPORT_DETAILS' -- this is same as your extra person information flex filed code.
,p_pei_information1 => p_pp_country
,p_pei_information2 => p_pp_number
,p_pei_information3 => to_char(p_pp_issue_date,'RRRR/MM/DD HH:MI:SS')
,p_pei_information4 => to_char(p_pp_expiry_date,'RRRR/MM/DD HH:MI:SS')
,p_pei_information5 => p_pp_issue_place
,p_person_extra_info_id => l_person_extra_info_id -- out values
,p_object_version_number => l_object_version_number -- out values
);
commit;
end;
1 comment:
Thanks a lot Sateesh, I was missing p_pei_attribute_category and p_pei_information_category as those were seems to be non-mandatory but they are actually.
Post a Comment