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 3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE

3011: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE

Line 3016: ,p_adr_date_from IN per_addresses.date_from%TYPE

3012: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE

Line 3017: ,p_style IN per_addresses.style%TYPE

3013: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE

Line 3018: ,p_address_line1 IN per_addresses.address_line1%TYPE

3014: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE

Line 3019: ,p_address_line2 IN per_addresses.address_line2%TYPE

3015: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE

Line 3020: ,p_address_line3 IN per_addresses.address_line3%TYPE

3016: ,p_adr_date_from IN per_addresses.date_from%TYPE
3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE

Line 3021: ,p_address_type IN per_addresses.address_type%TYPE

3017: ,p_style IN per_addresses.style%TYPE
3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE

Line 3022: ,p_country IN per_addresses.country%TYPE

3018: ,p_address_line1 IN per_addresses.address_line1%TYPE
3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE

Line 3023: ,p_adr_date_to IN per_addresses.date_to%TYPE

3019: ,p_address_line2 IN per_addresses.address_line2%TYPE
3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE

Line 3024: ,p_postal_code IN per_addresses.postal_code%TYPE

3020: ,p_address_line3 IN per_addresses.address_line3%TYPE
3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE

Line 3025: ,p_region_1 IN per_addresses.region_1%TYPE

3021: ,p_address_type IN per_addresses.address_type%TYPE
3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

Line 3026: ,p_region_2 IN per_addresses.region_2%TYPE

3022: ,p_country IN per_addresses.country%TYPE
3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

Line 3027: ,p_region_3 IN per_addresses.region_3%TYPE

3023: ,p_adr_date_to IN per_addresses.date_to%TYPE
3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

Line 3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE

3024: ,p_postal_code IN per_addresses.postal_code%TYPE
3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE

Line 3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE

3025: ,p_region_1 IN per_addresses.region_1%TYPE
3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE

Line 3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE

3026: ,p_region_2 IN per_addresses.region_2%TYPE
3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE

Line 3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE

3027: ,p_region_3 IN per_addresses.region_3%TYPE
3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE

Line 3032: ,p_add_information13 IN per_addresses.add_information13%TYPE

3028: ,p_town_or_city IN per_addresses.town_or_city%TYPE
3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE

Line 3033: ,p_add_information14 IN per_addresses.add_information14%TYPE

3029: ,p_telephone_number_1 IN per_addresses.telephone_number_1%TYPE
3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE

Line 3034: ,p_add_information15 IN per_addresses.add_information15%TYPE

3030: ,p_telephone_number_2 IN per_addresses.telephone_number_2%TYPE
3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE

Line 3035: ,p_add_information16 IN per_addresses.add_information16%TYPE

3031: ,p_telephone_number_3 IN per_addresses.telephone_number_3%TYPE
3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE

Line 3036: ,p_add_information17 IN per_addresses.add_information17%TYPE

3032: ,p_add_information13 IN per_addresses.add_information13%TYPE
3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

Line 3037: ,p_add_information18 IN per_addresses.add_information18%TYPE

3033: ,p_add_information14 IN per_addresses.add_information14%TYPE
3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

Line 3038: ,p_add_information19 IN per_addresses.add_information19%TYPE

3034: ,p_add_information15 IN per_addresses.add_information15%TYPE
3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

Line 3039: ,p_add_information20 IN per_addresses.add_information20%TYPE

3035: ,p_add_information16 IN per_addresses.add_information16%TYPE
3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

Line 3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE

3036: ,p_add_information17 IN per_addresses.add_information17%TYPE
3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

Line 3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE

3037: ,p_add_information18 IN per_addresses.add_information18%TYPE
3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

Line 3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE

3038: ,p_add_information19 IN per_addresses.add_information19%TYPE
3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

Line 3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE

3039: ,p_add_information20 IN per_addresses.add_information20%TYPE
3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

Line 3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE

3040: ,p_addr_attribute_category IN per_addresses.addr_attribute_category%TYPE
3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

Line 3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE

3041: ,p_addr_attribute1 IN per_addresses.addr_attribute1%TYPE
3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

Line 3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE

3042: ,p_addr_attribute2 IN per_addresses.addr_attribute2%TYPE
3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

Line 3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE

3043: ,p_addr_attribute3 IN per_addresses.addr_attribute3%TYPE
3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

Line 3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE

3044: ,p_addr_attribute4 IN per_addresses.addr_attribute4%TYPE
3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

Line 3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE

3045: ,p_addr_attribute5 IN per_addresses.addr_attribute5%TYPE
3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

Line 3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE

3046: ,p_addr_attribute6 IN per_addresses.addr_attribute6%TYPE
3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

Line 3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE

3047: ,p_addr_attribute7 IN per_addresses.addr_attribute7%TYPE
3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

Line 3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE

3048: ,p_addr_attribute8 IN per_addresses.addr_attribute8%TYPE
3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

Line 3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE

3049: ,p_addr_attribute9 IN per_addresses.addr_attribute9%TYPE
3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

Line 3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE

3050: ,p_addr_attribute10 IN per_addresses.addr_attribute10%TYPE
3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

Line 3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE

3051: ,p_addr_attribute11 IN per_addresses.addr_attribute11%TYPE
3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

Line 3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE

3052: ,p_addr_attribute12 IN per_addresses.addr_attribute12%TYPE
3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

Line 3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE

3053: ,p_addr_attribute13 IN per_addresses.addr_attribute13%TYPE
3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE

Line 3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE

3054: ,p_addr_attribute14 IN per_addresses.addr_attribute14%TYPE
3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE

Line 3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE

3055: ,p_addr_attribute15 IN per_addresses.addr_attribute15%TYPE
3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE

Line 3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE

3056: ,p_addr_attribute16 IN per_addresses.addr_attribute16%TYPE
3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE

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

3057: ,p_addr_attribute17 IN per_addresses.addr_attribute17%TYPE
3058: ,p_addr_attribute18 IN per_addresses.addr_attribute18%TYPE
3059: ,p_addr_attribute19 IN per_addresses.addr_attribute19%TYPE
3060: ,p_addr_attribute20 IN per_addresses.addr_attribute20%TYPE
3061: ,p_addr_object_version_number IN OUT NOCOPY per_addresses.object_version_number%TYPE
3062: ,p_phn_h_phone_id IN OUT NOCOPY per_phones.phone_id%TYPE
3063: ,p_phn_h_date_from IN per_phones.date_from%TYPE
3064: ,p_phn_h_date_to IN per_phones.date_to%TYPE
3065: ,p_phn_h_phone_number IN per_phones.phone_number%TYPE

Line 3444: l_address_id per_addresses.address_id%TYPE;

3440: l_scl_rec hr_soft_coding_keyflex%ROWTYPE;
3441: --
3442: l_app_object_version_number per_applications.object_version_number%TYPE;
3443: --
3444: l_address_id per_addresses.address_id%TYPE;
3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3446: --
3447: l_phone_id per_phones.phone_id%TYPE;
3448: l_phn_object_version_number per_phones.object_version_number%TYPE;

Line 3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;

3441: --
3442: l_app_object_version_number per_applications.object_version_number%TYPE;
3443: --
3444: l_address_id per_addresses.address_id%TYPE;
3445: l_addr_object_version_number per_addresses.object_version_number%TYPE;
3446: --
3447: l_phone_id per_phones.phone_id%TYPE;
3448: l_phn_object_version_number per_phones.object_version_number%TYPE;
3449: --

Line 3501: from per_addresses

3497: -- and also template definitions does not support creation of more than one primary address for any legislation.
3498: l_check_primary varchar2(1);
3499: cursor chk_primary is
3500: select 'x'
3501: from per_addresses
3502: where person_id=p_person_id
3503: and primary_flag='Y'
3504: and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
3505:

Line 7026: ,p_address_id per_addresses.address_id%TYPE

7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE

Line 7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE

7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
7026: ,p_address_id per_addresses.address_id%TYPE
7027: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
7028: ,p_phn_h_phone_id per_phones.phone_id%TYPE
7029: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE
7030: ,p_phn_w_phone_id per_phones.phone_id%TYPE
7031: ,p_phn_w_object_version_number per_phones.object_version_number%TYPE