4468:
4469: l_cur_add_rec per_addresses%rowtype;
4470: l_proc_name constant varchar2(150):= g_pkg ||'InsUpd_Address';
4471: l_error_msg varchar2(2000);
4472: l_party_id per_people_f.party_id%type;
4473:
4474:
4475: begin
4476: hr_utility.set_location('Entering: ' || l_proc_name, 10);
9711: --
9712: -- Type declarations
9713: --
9714: l_chk_per chk_party%rowtype;
9715: l_national_identifier per_people_f.national_identifier%type;
9716: l_party_id per_people_f.party_id%type;
9717: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
9718:
9719: -- added by dbansal
9712: -- Type declarations
9713: --
9714: l_chk_per chk_party%rowtype;
9715: l_national_identifier per_people_f.national_identifier%type;
9716: l_party_id per_people_f.party_id%type;
9717: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
9718:
9719: -- added by dbansal
9720: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;