249: l_postal_code per_addresses.postal_code%TYPE;
250: l_country per_addresses.country%TYPE;
251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
250: l_country per_addresses.country%TYPE;
251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
251:
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
252: -- Person details
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
253: l_last_name per_people_f.last_name%TYPE;
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
254: l_first_name per_people_f.first_name%TYPE;
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
255: l_middle_name per_people_f.middle_names%TYPE;
256: l_national_identifier per_people_f.national_identifier%TYPE;
257: l_title per_people_f.title%TYPE;
258: l_date_of_birth per_people_f.date_of_birth%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
259: l_sex per_people_f.sex%TYPE;
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
260: l_passport_no varchar2(50);
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations
261:
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations
269: l_aspp number;
262: -- Partner Person Details
263: l_partner_last_name per_people_f.last_name%TYPE;
264: l_partner_first_name per_people_f.first_name%TYPE;
265: l_partner_middle_name per_people_f.middle_names%TYPE;
266: l_partner_national_id per_people_f.national_identifier%TYPE;
267:
268: -- Assignment Details required for validations
269: l_aspp number;
270: l_start_date date;
521: l_postal_code per_addresses.postal_code%TYPE;
522: l_country per_addresses.country%TYPE;
523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
522: l_country per_addresses.country%TYPE;
523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
523:
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
524: -- Person details
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
525: l_last_name per_people_f.last_name%TYPE;
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
526: l_first_name per_people_f.first_name%TYPE;
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
527: l_middle_name per_people_f.middle_names%TYPE;
528: l_national_identifier per_people_f.national_identifier%TYPE;
529: l_title per_people_f.title%TYPE;
530: l_date_of_birth per_people_f.date_of_birth%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
531: l_sex per_people_f.sex%TYPE;
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
532: l_passport_no varchar2(50);
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations
533:
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations
541: l_aspp number;
534: -- Partner Person Details
535: l_partner_last_name per_people_f.last_name%TYPE;
536: l_partner_first_name per_people_f.first_name%TYPE;
537: l_partner_middle_name per_people_f.middle_names%TYPE;
538: l_partner_national_id per_people_f.national_identifier%TYPE;
539:
540: -- Assignment Details required for validations
541: l_aspp number;
542: l_start_date date;