APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ADDRESSES

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

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

Line 352: ,p_adr_date_from IN per_addresses.date_from%TYPE

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

Line 353: ,p_style IN per_addresses.style%TYPE

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

Line 354: ,p_address_line1 IN per_addresses.address_line1%TYPE

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

Line 355: ,p_address_line2 IN per_addresses.address_line2%TYPE

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

Line 356: ,p_address_line3 IN per_addresses.address_line3%TYPE

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

Line 357: ,p_address_type IN per_addresses.address_type%TYPE

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

Line 358: ,p_country IN per_addresses.country%TYPE

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

Line 359: ,p_adr_date_to IN per_addresses.date_to%TYPE

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

Line 360: ,p_postal_code IN per_addresses.postal_code%TYPE

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

Line 361: ,p_region_1 IN per_addresses.region_1%TYPE

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

Line 362: ,p_region_2 IN per_addresses.region_2%TYPE

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

Line 363: ,p_region_3 IN per_addresses.region_3%TYPE

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

Line 364: ,p_town_or_city IN per_addresses.town_or_city%TYPE

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

Line 365: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

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

Line 366: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

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

Line 367: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

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

Line 368: ,p_add_information13 IN per_addresses.add_information13%TYPE

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

Line 369: ,p_add_information14 IN per_addresses.add_information14%TYPE

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

Line 370: ,p_add_information15 IN per_addresses.add_information15%TYPE

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

Line 371: ,p_add_information16 IN per_addresses.add_information16%TYPE

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

Line 372: ,p_add_information17 IN per_addresses.add_information17%TYPE

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

Line 373: ,p_add_information18 IN per_addresses.add_information18%TYPE

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

Line 374: ,p_add_information19 IN per_addresses.add_information19%TYPE

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

Line 375: ,p_add_information20 IN per_addresses.add_information20%TYPE

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

Line 376: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

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

Line 377: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

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

Line 378: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

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

Line 379: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

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

Line 380: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

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

Line 381: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

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

Line 382: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

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

Line 383: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

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

Line 384: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

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

Line 385: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

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

Line 386: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

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

Line 387: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

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

Line 388: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

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

Line 389: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

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

Line 390: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

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

Line 391: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

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

Line 392: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

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

Line 393: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

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

Line 394: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

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

Line 395: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

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

Line 396: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

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

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

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

Line 776: l_address_id per_addresses.address_id%TYPE;

772: --
773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;
775: --
776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;
778: --
779: l_phone_id per_phones.phone_id%TYPE;
780: l_phn_object_version_number per_phones.object_version_number%TYPE;

Line 777: l_addr_object_version_number per_addresses.object_version_number%TYPE;

773: l_app_object_version_number per_applications.object_version_number%TYPE;
774: l_application_id per_applications.application_id%TYPE;
775: --
776: l_address_id per_addresses.address_id%TYPE;
777: l_addr_object_version_number per_addresses.object_version_number%TYPE;
778: --
779: l_phone_id per_phones.phone_id%TYPE;
780: l_phn_object_version_number per_phones.object_version_number%TYPE;
781: --

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

3045: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE

Line 3050: ,p_adr_date_from IN per_addresses.date_from%TYPE

3046: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE

Line 3051: ,p_style IN per_addresses.style%TYPE

3047: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE

Line 3052: ,p_address_line1 IN per_addresses.address_line1%TYPE

3048: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE

Line 3053: ,p_address_line2 IN per_addresses.address_line2%TYPE

3049: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE

Line 3054: ,p_address_line3 IN per_addresses.address_line3%TYPE

3050: ,p_adr_date_from IN per_addresses.date_from%TYPE
3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE

Line 3055: ,p_address_type IN per_addresses.address_type%TYPE

3051: ,p_style IN per_addresses.style%TYPE
3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE

Line 3056: ,p_country IN per_addresses.country%TYPE

3052: ,p_address_line1 IN per_addresses.address_line1%TYPE
3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE

Line 3057: ,p_adr_date_to IN per_addresses.date_to%TYPE

3053: ,p_address_line2 IN per_addresses.address_line2%TYPE
3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE

Line 3058: ,p_postal_code IN per_addresses.postal_code%TYPE

3054: ,p_address_line3 IN per_addresses.address_line3%TYPE
3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE

Line 3059: ,p_region_1 IN per_addresses.region_1%TYPE

3055: ,p_address_type IN per_addresses.address_type%TYPE
3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

Line 3060: ,p_region_2 IN per_addresses.region_2%TYPE

3056: ,p_country IN per_addresses.country%TYPE
3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

Line 3061: ,p_region_3 IN per_addresses.region_3%TYPE

3057: ,p_adr_date_to IN per_addresses.date_to%TYPE
3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

Line 3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE

3058: ,p_postal_code IN per_addresses.postal_code%TYPE
3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE

Line 3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

3059: ,p_region_1 IN per_addresses.region_1%TYPE
3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE

Line 3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

3060: ,p_region_2 IN per_addresses.region_2%TYPE
3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE

Line 3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

3061: ,p_region_3 IN per_addresses.region_3%TYPE
3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE

Line 3066: ,p_add_information13 IN per_addresses.add_information13%TYPE

3062: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE

Line 3067: ,p_add_information14 IN per_addresses.add_information14%TYPE

3063: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE

Line 3068: ,p_add_information15 IN per_addresses.add_information15%TYPE

3064: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE

Line 3069: ,p_add_information16 IN per_addresses.add_information16%TYPE

3065: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE

Line 3070: ,p_add_information17 IN per_addresses.add_information17%TYPE

3066: ,p_add_information13 IN per_addresses.add_information13%TYPE
3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

Line 3071: ,p_add_information18 IN per_addresses.add_information18%TYPE

3067: ,p_add_information14 IN per_addresses.add_information14%TYPE
3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

Line 3072: ,p_add_information19 IN per_addresses.add_information19%TYPE

3068: ,p_add_information15 IN per_addresses.add_information15%TYPE
3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

Line 3073: ,p_add_information20 IN per_addresses.add_information20%TYPE

3069: ,p_add_information16 IN per_addresses.add_information16%TYPE
3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

Line 3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

3070: ,p_add_information17 IN per_addresses.add_information17%TYPE
3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

Line 3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

3071: ,p_add_information18 IN per_addresses.add_information18%TYPE
3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

Line 3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

3072: ,p_add_information19 IN per_addresses.add_information19%TYPE
3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

Line 3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

3073: ,p_add_information20 IN per_addresses.add_information20%TYPE
3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

Line 3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

3074: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

Line 3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

3075: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

Line 3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

3076: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

Line 3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

3077: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

Line 3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

3078: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

Line 3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

3079: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

Line 3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

3080: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

Line 3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

3081: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

Line 3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

3082: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

Line 3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

3083: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

Line 3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

3084: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

Line 3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

3085: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

Line 3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

3086: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

Line 3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

3087: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3095: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE

Line 3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

3088: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3095: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3096: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

3089: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3095: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3096: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3097: ,p_phn_h_date_from IN per_phones.date_from%TYPE

Line 3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

3090: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3095: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3096: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3097: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3098: ,p_phn_h_date_to IN per_phones.date_to%TYPE

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

3091: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3092: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3093: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3094: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3095: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3096: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3097: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3098: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3099: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

Line 3478: l_address_id per_addresses.address_id%TYPE;

3474: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3475: --
3476: l_app_object_version_number per_applications.object_version_number%TYPE;
3477: --
3478: l_address_id per_addresses.address_id%TYPE;
3479: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3480: --
3481: l_phone_id per_phones.phone_id%TYPE;
3482: l_phn_object_version_number per_phones.object_version_number%TYPE;

Line 3479: l_addr_object_version_number per_addresses.object_version_number%TYPE;

3475: --
3476: l_app_object_version_number per_applications.object_version_number%TYPE;
3477: --
3478: l_address_id per_addresses.address_id%TYPE;
3479: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3480: --
3481: l_phone_id per_phones.phone_id%TYPE;
3482: l_phn_object_version_number per_phones.object_version_number%TYPE;
3483: --

Line 3535: from per_addresses

3531: -- and also template definitions does not support creation of more than one primary address for any legislation.
3532: l_check_primary varchar2(1);
3533: cursor chk_primary is
3534: select 'x'
3535: from per_addresses
3536: where person_id=p_person_id
3537: and primary_flag='Y'
3538: and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
3539:

Line 7066: ,p_address_id per_addresses.address_id%TYPE

7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE
7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7068: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7069: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7070: ,p_phn_w_phone_id per_phones.phone_id%TYPE

Line 7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE

7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7066: ,p_address_id per_addresses.address_id%TYPE
7067: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7068: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7069: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7070: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7071: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE