126: -- Declare cursors and local variables
127: --
128: l_proc varchar2(72) := g_package||'create_applicant';
129: l_date_received per_applications.date_received%TYPE;
130: l_applicant_number per_people_f.applicant_number%TYPE;
131: l_person_type_id per_people_f.person_type_id%TYPE;
132: l_person_id per_people_f.person_id%TYPE;
133: l_application_id per_applications.application_id%TYPE;
134: l_assignment_id per_assignments_f.assignment_id%TYPE;
127: --
128: l_proc varchar2(72) := g_package||'create_applicant';
129: l_date_received per_applications.date_received%TYPE;
130: l_applicant_number per_people_f.applicant_number%TYPE;
131: l_person_type_id per_people_f.person_type_id%TYPE;
132: l_person_id per_people_f.person_id%TYPE;
133: l_application_id per_applications.application_id%TYPE;
134: l_assignment_id per_assignments_f.assignment_id%TYPE;
135: --
128: l_proc varchar2(72) := g_package||'create_applicant';
129: l_date_received per_applications.date_received%TYPE;
130: l_applicant_number per_people_f.applicant_number%TYPE;
131: l_person_type_id per_people_f.person_type_id%TYPE;
132: l_person_id per_people_f.person_id%TYPE;
133: l_application_id per_applications.application_id%TYPE;
134: l_assignment_id per_assignments_f.assignment_id%TYPE;
135: --
136: begin