1480: -- Declare cursors and local variables
1481: --
1482: l_proc varchar2(72) := g_package||'create_eit';
1483: l_dummy_num number;
1484: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1485: l_object_version_number per_people_extra_info.object_version_number%type;
1486: l_transaction_id number default null;
1487: l_result varchar2(100) default null;
1488: l_new_hire boolean default false;
1481: --
1482: l_proc varchar2(72) := g_package||'create_eit';
1483: l_dummy_num number;
1484: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1485: l_object_version_number per_people_extra_info.object_version_number%type;
1486: l_transaction_id number default null;
1487: l_result varchar2(100) default null;
1488: l_new_hire boolean default false;
1489: l_person_id number;