APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ADDRESSES

Line 354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE

350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE

Line 355: ,p_adr_date_from IN per_addresses.date_from%TYPE

351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE

Line 356: ,p_style IN per_addresses.style%TYPE

352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE

Line 357: ,p_address_line1 IN per_addresses.address_line1%TYPE

353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE

Line 358: ,p_address_line2 IN per_addresses.address_line2%TYPE

354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE

Line 359: ,p_address_line3 IN per_addresses.address_line3%TYPE

355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE

Line 360: ,p_address_type IN per_addresses.address_type%TYPE

356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE

Line 361: ,p_country IN per_addresses.country%TYPE

357: ,p_address_line1 IN per_addresses.address_line1%TYPE
358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE

Line 362: ,p_adr_date_to IN per_addresses.date_to%TYPE

358: ,p_address_line2 IN per_addresses.address_line2%TYPE
359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE

Line 363: ,p_postal_code IN per_addresses.postal_code%TYPE

359: ,p_address_line3 IN per_addresses.address_line3%TYPE
360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE

Line 364: ,p_region_1 IN per_addresses.region_1%TYPE

360: ,p_address_type IN per_addresses.address_type%TYPE
361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

Line 365: ,p_region_2 IN per_addresses.region_2%TYPE

361: ,p_country IN per_addresses.country%TYPE
362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

Line 366: ,p_region_3 IN per_addresses.region_3%TYPE

362: ,p_adr_date_to IN per_addresses.date_to%TYPE
363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

Line 367: ,p_town_or_city IN per_addresses.town_or_city%TYPE

363: ,p_postal_code IN per_addresses.postal_code%TYPE
364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE

Line 368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

364: ,p_region_1 IN per_addresses.region_1%TYPE
365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE

Line 369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

365: ,p_region_2 IN per_addresses.region_2%TYPE
366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE

Line 370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

366: ,p_region_3 IN per_addresses.region_3%TYPE
367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE

Line 371: ,p_add_information13 IN per_addresses.add_information13%TYPE

367: ,p_town_or_city IN per_addresses.town_or_city%TYPE
368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE

Line 372: ,p_add_information14 IN per_addresses.add_information14%TYPE

368: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE

Line 373: ,p_add_information15 IN per_addresses.add_information15%TYPE

369: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE

Line 374: ,p_add_information16 IN per_addresses.add_information16%TYPE

370: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE

Line 375: ,p_add_information17 IN per_addresses.add_information17%TYPE

371: ,p_add_information13 IN per_addresses.add_information13%TYPE
372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

Line 376: ,p_add_information18 IN per_addresses.add_information18%TYPE

372: ,p_add_information14 IN per_addresses.add_information14%TYPE
373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

Line 377: ,p_add_information19 IN per_addresses.add_information19%TYPE

373: ,p_add_information15 IN per_addresses.add_information15%TYPE
374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

Line 378: ,p_add_information20 IN per_addresses.add_information20%TYPE

374: ,p_add_information16 IN per_addresses.add_information16%TYPE
375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

Line 379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

375: ,p_add_information17 IN per_addresses.add_information17%TYPE
376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

Line 380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

376: ,p_add_information18 IN per_addresses.add_information18%TYPE
377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

Line 381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

377: ,p_add_information19 IN per_addresses.add_information19%TYPE
378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

Line 382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

378: ,p_add_information20 IN per_addresses.add_information20%TYPE
379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

Line 383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

379: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

Line 384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

380: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

Line 385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

381: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

Line 386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

382: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

Line 387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

383: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

Line 388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

384: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

Line 389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

385: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

Line 390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

386: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

Line 391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

387: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

Line 392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

388: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

Line 393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

389: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

Line 394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

390: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

Line 395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

391: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

Line 396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

392: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE

Line 397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

393: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
401: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE

Line 398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

394: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
401: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
402: ,p_phn_h_date_from IN per_phones.date_from%TYPE

Line 399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

395: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
401: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
402: ,p_phn_h_date_from IN per_phones.date_from%TYPE
403: ,p_phn_h_date_to IN per_phones.date_to%TYPE

Line 400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE

396: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
397: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
398: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
399: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
400: ,p_addr_object_version_number OUT NOCOPY per_addresses.object_version_number%TYPE
401: ,p_phn_h_phone_id OUT NOCOPY per_phones.phone_id%TYPE
402: ,p_phn_h_date_from IN per_phones.date_from%TYPE
403: ,p_phn_h_date_to IN per_phones.date_to%TYPE
404: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

Line 1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE

Line 1074: ,p_adr_date_from IN per_addresses.date_from%TYPE

1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE

Line 1075: ,p_style IN per_addresses.style%TYPE

1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE

Line 1076: ,p_address_line1 IN per_addresses.address_line1%TYPE

1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE

Line 1077: ,p_address_line2 IN per_addresses.address_line2%TYPE

1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE

Line 1078: ,p_address_line3 IN per_addresses.address_line3%TYPE

1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE

Line 1079: ,p_address_type IN per_addresses.address_type%TYPE

1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE

Line 1080: ,p_country IN per_addresses.country%TYPE

1076: ,p_address_line1 IN per_addresses.address_line1%TYPE
1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE

Line 1081: ,p_adr_date_to IN per_addresses.date_to%TYPE

1077: ,p_address_line2 IN per_addresses.address_line2%TYPE
1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE

Line 1082: ,p_postal_code IN per_addresses.postal_code%TYPE

1078: ,p_address_line3 IN per_addresses.address_line3%TYPE
1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE

Line 1083: ,p_region_1 IN per_addresses.region_1%TYPE

1079: ,p_address_type IN per_addresses.address_type%TYPE
1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

Line 1084: ,p_region_2 IN per_addresses.region_2%TYPE

1080: ,p_country IN per_addresses.country%TYPE
1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

Line 1085: ,p_region_3 IN per_addresses.region_3%TYPE

1081: ,p_adr_date_to IN per_addresses.date_to%TYPE
1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

Line 1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE

1082: ,p_postal_code IN per_addresses.postal_code%TYPE
1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE

Line 1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

1083: ,p_region_1 IN per_addresses.region_1%TYPE
1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE

Line 1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

1084: ,p_region_2 IN per_addresses.region_2%TYPE
1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE

Line 1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

1085: ,p_region_3 IN per_addresses.region_3%TYPE
1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE

Line 1090: ,p_add_information13 IN per_addresses.add_information13%TYPE

1086: ,p_town_or_city IN per_addresses.town_or_city%TYPE
1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE

Line 1091: ,p_add_information14 IN per_addresses.add_information14%TYPE

1087: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE

Line 1092: ,p_add_information15 IN per_addresses.add_information15%TYPE

1088: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE

Line 1093: ,p_add_information16 IN per_addresses.add_information16%TYPE

1089: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE

Line 1094: ,p_add_information17 IN per_addresses.add_information17%TYPE

1090: ,p_add_information13 IN per_addresses.add_information13%TYPE
1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

Line 1095: ,p_add_information18 IN per_addresses.add_information18%TYPE

1091: ,p_add_information14 IN per_addresses.add_information14%TYPE
1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

Line 1096: ,p_add_information19 IN per_addresses.add_information19%TYPE

1092: ,p_add_information15 IN per_addresses.add_information15%TYPE
1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

Line 1097: ,p_add_information20 IN per_addresses.add_information20%TYPE

1093: ,p_add_information16 IN per_addresses.add_information16%TYPE
1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

Line 1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

1094: ,p_add_information17 IN per_addresses.add_information17%TYPE
1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

Line 1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

1095: ,p_add_information18 IN per_addresses.add_information18%TYPE
1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

Line 1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

1096: ,p_add_information19 IN per_addresses.add_information19%TYPE
1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

Line 1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

1097: ,p_add_information20 IN per_addresses.add_information20%TYPE
1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

Line 1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

1098: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

Line 1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

1099: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

Line 1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

1100: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

Line 1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

1101: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

Line 1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

1102: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

Line 1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

1103: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

Line 1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

1104: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

Line 1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

1105: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

Line 1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

1106: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

Line 1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

1107: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

Line 1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

1108: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

Line 1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

1109: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

Line 1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

1110: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

Line 1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

1111: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE

Line 1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

1112: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1120: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

1113: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1120: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1121: ,p_phn_h_date_from IN per_phones.date_from%TYPE

Line 1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

1114: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1120: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1121: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1122: ,p_phn_h_date_to IN per_phones.date_to%TYPE

Line 1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE

1115: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
1116: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
1117: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
1118: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
1119: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
1120: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
1121: ,p_phn_h_date_from IN per_phones.date_from%TYPE
1122: ,p_phn_h_date_to IN per_phones.date_to%TYPE
1123: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

Line 1482: ,p_address_id per_addresses.address_id%TYPE

1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE
1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1484: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1485: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1486: ,p_phn_w_phone_id per_phones.phone_id%TYPE

Line 1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE

1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE
1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1484: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1485: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
1486: ,p_phn_w_phone_id per_phones.phone_id%TYPE
1487: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE