1492: -- Declare cursors and local variables
1493: --
1494: l_proc varchar2(72) := g_package||'create_eit';
1495: l_dummy_num number;
1496: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1497: l_object_version_number per_people_extra_info.object_version_number%type;
1498: l_transaction_id number default null;
1499: l_result varchar2(100) default null;
1500: l_new_hire boolean default false;
1493: --
1494: l_proc varchar2(72) := g_package||'create_eit';
1495: l_dummy_num number;
1496: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1497: l_object_version_number per_people_extra_info.object_version_number%type;
1498: l_transaction_id number default null;
1499: l_result varchar2(100) default null;
1500: l_new_hire boolean default false;
1501: l_person_id number;