eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ADD_BUS dependencies on PER_ADDRESSES

Line 62: (p_address_id in per_addresses.address_id%TYPE

58: --
59: -- {End Of Comments}
60: -- ----------------------------------------------------------------------------
61: procedure chk_business_group_id
62: (p_address_id in per_addresses.address_id%TYPE
63: ,p_object_version_number in per_addresses.object_version_number%TYPE
64: ,p_person_id in per_addresses.person_id%TYPE
65: ,p_business_group_id in per_addresses.business_group_id%TYPE
66: )

Line 63: ,p_object_version_number in per_addresses.object_version_number%TYPE

59: -- {End Of Comments}
60: -- ----------------------------------------------------------------------------
61: procedure chk_business_group_id
62: (p_address_id in per_addresses.address_id%TYPE
63: ,p_object_version_number in per_addresses.object_version_number%TYPE
64: ,p_person_id in per_addresses.person_id%TYPE
65: ,p_business_group_id in per_addresses.business_group_id%TYPE
66: )
67: is

Line 64: ,p_person_id in per_addresses.person_id%TYPE

60: -- ----------------------------------------------------------------------------
61: procedure chk_business_group_id
62: (p_address_id in per_addresses.address_id%TYPE
63: ,p_object_version_number in per_addresses.object_version_number%TYPE
64: ,p_person_id in per_addresses.person_id%TYPE
65: ,p_business_group_id in per_addresses.business_group_id%TYPE
66: )
67: is
68: --

Line 65: ,p_business_group_id in per_addresses.business_group_id%TYPE

61: procedure chk_business_group_id
62: (p_address_id in per_addresses.address_id%TYPE
63: ,p_object_version_number in per_addresses.object_version_number%TYPE
64: ,p_person_id in per_addresses.person_id%TYPE
65: ,p_business_group_id in per_addresses.business_group_id%TYPE
66: )
67: is
68: --
69:

Line 151: (p_address_id in per_addresses.address_id%TYPE

147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: procedure chk_person_id
151: (p_address_id in per_addresses.address_id%TYPE
152: ,p_object_version_number in per_addresses.object_version_number%TYPE
153: ,p_person_id in per_addresses.person_id%TYPE
154: ,p_business_group_id in per_addresses.business_group_id%TYPE
155: )

Line 152: ,p_object_version_number in per_addresses.object_version_number%TYPE

148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: procedure chk_person_id
151: (p_address_id in per_addresses.address_id%TYPE
152: ,p_object_version_number in per_addresses.object_version_number%TYPE
153: ,p_person_id in per_addresses.person_id%TYPE
154: ,p_business_group_id in per_addresses.business_group_id%TYPE
155: )
156: is

Line 153: ,p_person_id in per_addresses.person_id%TYPE

149: -- ----------------------------------------------------------------------------
150: procedure chk_person_id
151: (p_address_id in per_addresses.address_id%TYPE
152: ,p_object_version_number in per_addresses.object_version_number%TYPE
153: ,p_person_id in per_addresses.person_id%TYPE
154: ,p_business_group_id in per_addresses.business_group_id%TYPE
155: )
156: is
157: --

Line 154: ,p_business_group_id in per_addresses.business_group_id%TYPE

150: procedure chk_person_id
151: (p_address_id in per_addresses.address_id%TYPE
152: ,p_object_version_number in per_addresses.object_version_number%TYPE
153: ,p_person_id in per_addresses.person_id%TYPE
154: ,p_business_group_id in per_addresses.business_group_id%TYPE
155: )
156: is
157: --
158: l_proc varchar2(72) := g_package||'chk_person_id';

Line 255: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'

251: hr_utility.set_location(' Leaving:'|| l_proc, 50);
252: exception
253: when app_exception.application_exception then
254: if hr_multi_message.exception_add
255: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
256: ) then
257: hr_utility.set_location(' Leaving:'||l_proc,60);
258: raise;
259: end if;

Line 297: l_party_id per_addresses.party_id%TYPE;

293: l_proc varchar2(72) := g_package||'chk_party_id';
294: --
295: l_exists varchar2(1);
296: --
297: l_party_id per_addresses.party_id%TYPE;
298: l_party_id2 per_addresses.party_id%TYPE;
299: --
300: --
301: -- cursor to check that the party_id matches person_id

Line 298: l_party_id2 per_addresses.party_id%TYPE;

294: --
295: l_exists varchar2(1);
296: --
297: l_party_id per_addresses.party_id%TYPE;
298: l_party_id2 per_addresses.party_id%TYPE;
299: --
300: --
301: -- cursor to check that the party_id matches person_id
302: --

Line 322: (p_check_column1 => 'PER_ADDRESSES.PERSON_ID'

318: --
319: --
320: if p_rec.person_id is not null then
321: if hr_multi_message.no_all_inclusive_error
322: (p_check_column1 => 'PER_ADDRESSES.PERSON_ID'
323: ,p_check_column2 => 'PER_ADDRESSES.DATE_FROM'
324: ) then
325: --
326: open csr_get_party_id;

Line 323: ,p_check_column2 => 'PER_ADDRESSES.DATE_FROM'

319: --
320: if p_rec.person_id is not null then
321: if hr_multi_message.no_all_inclusive_error
322: (p_check_column1 => 'PER_ADDRESSES.PERSON_ID'
323: ,p_check_column2 => 'PER_ADDRESSES.DATE_FROM'
324: ) then
325: --
326: open csr_get_party_id;
327: fetch csr_get_party_id into l_party_id;

Line 335: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'

331: if p_rec.party_id <> nvl(l_party_id,-1) then
332: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
333: hr_utility.set_location(l_proc,30);
334: hr_multi_message.add
335: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
336: ,p_associated_column2 => 'PER_ADDRESSES.DATE_FROM'
337: ,p_associated_column3 => 'PER_ADDRESSES.PARTY_ID'
338: );
339: end if;

Line 336: ,p_associated_column2 => 'PER_ADDRESSES.DATE_FROM'

332: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
333: hr_utility.set_location(l_proc,30);
334: hr_multi_message.add
335: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
336: ,p_associated_column2 => 'PER_ADDRESSES.DATE_FROM'
337: ,p_associated_column3 => 'PER_ADDRESSES.PARTY_ID'
338: );
339: end if;
340: else

Line 337: ,p_associated_column3 => 'PER_ADDRESSES.PARTY_ID'

333: hr_utility.set_location(l_proc,30);
334: hr_multi_message.add
335: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
336: ,p_associated_column2 => 'PER_ADDRESSES.DATE_FROM'
337: ,p_associated_column3 => 'PER_ADDRESSES.PARTY_ID'
338: );
339: end if;
340: else
341: --

Line 353: ( p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'

349: if p_rec.party_id is null then
350: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
351: hr_utility.set_location(l_proc,60);
352: hr_multi_message.add
353: ( p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'
354: );
355: else
356: open csr_valid_party_id;
357: fetch csr_valid_party_id into l_party_id2;

Line 363: (p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'

359: close csr_valid_party_id;
360: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
361: hr_utility.set_location(l_proc,70);
362: hr_multi_message.add
363: (p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'
364: );
365: else
366: --
367: close csr_valid_party_id;

Line 401: (p_address_id in per_addresses.address_id%TYPE

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: procedure chk_primary_flag
401: (p_address_id in per_addresses.address_id%TYPE
402: ,p_object_version_number in per_addresses.object_version_number%TYPE
403: ,p_primary_flag in per_addresses.primary_flag%TYPE
404: )
405: is

Line 402: ,p_object_version_number in per_addresses.object_version_number%TYPE

398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: procedure chk_primary_flag
401: (p_address_id in per_addresses.address_id%TYPE
402: ,p_object_version_number in per_addresses.object_version_number%TYPE
403: ,p_primary_flag in per_addresses.primary_flag%TYPE
404: )
405: is
406: --

Line 403: ,p_primary_flag in per_addresses.primary_flag%TYPE

399: -- ----------------------------------------------------------------------------
400: procedure chk_primary_flag
401: (p_address_id in per_addresses.address_id%TYPE
402: ,p_object_version_number in per_addresses.object_version_number%TYPE
403: ,p_primary_flag in per_addresses.primary_flag%TYPE
404: )
405: is
406: --
407: l_proc varchar2(72) := g_package||'chk_primary_flag';

Line 485: (p_address_id in per_addresses.address_id%TYPE

481: --
482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: procedure chk_address_type
485: (p_address_id in per_addresses.address_id%TYPE
486: ,p_address_type in per_addresses.address_type%TYPE
487: ,p_date_from in per_addresses.date_from%TYPE
488: ,p_effective_date in date
489: ,p_object_version_number in per_addresses.object_version_number%TYPE) is

Line 486: ,p_address_type in per_addresses.address_type%TYPE

482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: procedure chk_address_type
485: (p_address_id in per_addresses.address_id%TYPE
486: ,p_address_type in per_addresses.address_type%TYPE
487: ,p_date_from in per_addresses.date_from%TYPE
488: ,p_effective_date in date
489: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
490: --

Line 487: ,p_date_from in per_addresses.date_from%TYPE

483: -- ----------------------------------------------------------------------------
484: procedure chk_address_type
485: (p_address_id in per_addresses.address_id%TYPE
486: ,p_address_type in per_addresses.address_type%TYPE
487: ,p_date_from in per_addresses.date_from%TYPE
488: ,p_effective_date in date
489: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
490: --
491: l_exists varchar2(1);

Line 489: ,p_object_version_number in per_addresses.object_version_number%TYPE) is

485: (p_address_id in per_addresses.address_id%TYPE
486: ,p_address_type in per_addresses.address_type%TYPE
487: ,p_date_from in per_addresses.date_from%TYPE
488: ,p_effective_date in date
489: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
490: --
491: l_exists varchar2(1);
492: l_proc varchar2(72) := g_package||'chk_address_type';
493: l_api_updating boolean;

Line 551: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_TYPE'

547: hr_utility.set_location(' Leaving:'|| l_proc, 4);
548: exception
549: when app_exception.application_exception then
550: if hr_multi_message.exception_add
551: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_TYPE'
552: ) then
553: hr_utility.set_location(' Leaving:'||l_proc,5);
554: raise;
555: end if;

Line 590: (p_address_id in per_addresses.address_id%TYPE

586: --
587: -- {End Of Comments}
588: -- ----------------------------------------------------------------------------
589: procedure chk_country
590: (p_address_id in per_addresses.address_id%TYPE
591: ,p_style in per_addresses.style%TYPE
592: ,p_country in per_addresses.country%TYPE
593: ,p_object_version_number in per_addresses.object_version_number%TYPE)
594: is

Line 591: ,p_style in per_addresses.style%TYPE

587: -- {End Of Comments}
588: -- ----------------------------------------------------------------------------
589: procedure chk_country
590: (p_address_id in per_addresses.address_id%TYPE
591: ,p_style in per_addresses.style%TYPE
592: ,p_country in per_addresses.country%TYPE
593: ,p_object_version_number in per_addresses.object_version_number%TYPE)
594: is
595: --

Line 592: ,p_country in per_addresses.country%TYPE

588: -- ----------------------------------------------------------------------------
589: procedure chk_country
590: (p_address_id in per_addresses.address_id%TYPE
591: ,p_style in per_addresses.style%TYPE
592: ,p_country in per_addresses.country%TYPE
593: ,p_object_version_number in per_addresses.object_version_number%TYPE)
594: is
595: --
596: l_exists varchar2(1);

Line 593: ,p_object_version_number in per_addresses.object_version_number%TYPE)

589: procedure chk_country
590: (p_address_id in per_addresses.address_id%TYPE
591: ,p_style in per_addresses.style%TYPE
592: ,p_country in per_addresses.country%TYPE
593: ,p_object_version_number in per_addresses.object_version_number%TYPE)
594: is
595: --
596: l_exists varchar2(1);
597: l_proc varchar2(72) := g_package||'chk_country';

Line 644: (p_associated_column1 => 'PER_ADDRESSES.COUNTRY'

640: hr_utility.set_location(' Leaving:'|| l_proc, 3);
641: exception
642: when app_exception.application_exception then
643: if hr_multi_message.exception_add
644: (p_associated_column1 => 'PER_ADDRESSES.COUNTRY'
645: ) then
646: hr_utility.set_location(' Leaving:'||l_proc,4);
647: raise;
648: end if;

Line 684: (p_address_id in per_addresses.address_id%TYPE

680: --
681: -- {End Of Comments}
682: -- ----------------------------------------------------------------------------
683: procedure chk_date_to
684: (p_address_id in per_addresses.address_id%TYPE
685: ,p_date_from in per_addresses.date_from%TYPE
686: ,p_date_to in per_addresses.date_to%TYPE
687: ,p_object_version_number in per_addresses.object_version_number%TYPE)
688: is

Line 685: ,p_date_from in per_addresses.date_from%TYPE

681: -- {End Of Comments}
682: -- ----------------------------------------------------------------------------
683: procedure chk_date_to
684: (p_address_id in per_addresses.address_id%TYPE
685: ,p_date_from in per_addresses.date_from%TYPE
686: ,p_date_to in per_addresses.date_to%TYPE
687: ,p_object_version_number in per_addresses.object_version_number%TYPE)
688: is
689: --

Line 686: ,p_date_to in per_addresses.date_to%TYPE

682: -- ----------------------------------------------------------------------------
683: procedure chk_date_to
684: (p_address_id in per_addresses.address_id%TYPE
685: ,p_date_from in per_addresses.date_from%TYPE
686: ,p_date_to in per_addresses.date_to%TYPE
687: ,p_object_version_number in per_addresses.object_version_number%TYPE)
688: is
689: --
690: l_exists varchar2(1);

Line 687: ,p_object_version_number in per_addresses.object_version_number%TYPE)

683: procedure chk_date_to
684: (p_address_id in per_addresses.address_id%TYPE
685: ,p_date_from in per_addresses.date_from%TYPE
686: ,p_date_to in per_addresses.date_to%TYPE
687: ,p_object_version_number in per_addresses.object_version_number%TYPE)
688: is
689: --
690: l_exists varchar2(1);
691: l_proc varchar2(72) := g_package||'chk_date_to';

Line 706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'

702: ,p_argument => 'date_from'
703: ,p_argument_value => p_date_from
704: );
705: if hr_multi_message.no_all_inclusive_error
706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
710: ) then

Line 707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'

703: ,p_argument_value => p_date_from
704: );
705: if hr_multi_message.no_all_inclusive_error
706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
710: ) then
711: --

Line 708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

704: );
705: if hr_multi_message.no_all_inclusive_error
706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
710: ) then
711: --
712: -- Only proceed with validation if :

Line 709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

705: if hr_multi_message.no_all_inclusive_error
706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
710: ) then
711: --
712: -- Only proceed with validation if :
713: -- a) The current g_old_rec is current and

Line 782: (p_address_id in per_addresses.address_id%TYPE

778: --
779: -- {End Of Comments}
780: -- ----------------------------------------------------------------------------
781: procedure chk_date_from
782: (p_address_id in per_addresses.address_id%TYPE
783: ,p_date_from in per_addresses.date_from%TYPE
784: ,p_date_to in per_addresses.date_to%TYPE
785: ,p_object_version_number in per_addresses.object_version_number%TYPE)
786: is

Line 783: ,p_date_from in per_addresses.date_from%TYPE

779: -- {End Of Comments}
780: -- ----------------------------------------------------------------------------
781: procedure chk_date_from
782: (p_address_id in per_addresses.address_id%TYPE
783: ,p_date_from in per_addresses.date_from%TYPE
784: ,p_date_to in per_addresses.date_to%TYPE
785: ,p_object_version_number in per_addresses.object_version_number%TYPE)
786: is
787: --

Line 784: ,p_date_to in per_addresses.date_to%TYPE

780: -- ----------------------------------------------------------------------------
781: procedure chk_date_from
782: (p_address_id in per_addresses.address_id%TYPE
783: ,p_date_from in per_addresses.date_from%TYPE
784: ,p_date_to in per_addresses.date_to%TYPE
785: ,p_object_version_number in per_addresses.object_version_number%TYPE)
786: is
787: --
788: l_exists varchar2(1);

Line 785: ,p_object_version_number in per_addresses.object_version_number%TYPE)

781: procedure chk_date_from
782: (p_address_id in per_addresses.address_id%TYPE
783: ,p_date_from in per_addresses.date_from%TYPE
784: ,p_date_to in per_addresses.date_to%TYPE
785: ,p_object_version_number in per_addresses.object_version_number%TYPE)
786: is
787: --
788: l_exists varchar2(1);
789: l_proc varchar2(72) := g_package||'chk_date_from';

Line 830: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

826: hr_utility.set_location(' Leaving:'|| l_proc, 3);
827: exception
828: when app_exception.application_exception then
829: if hr_multi_message.exception_add
830: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
831: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
832: ) then
833: hr_utility.set_location(' Leaving:'||l_proc,4);
834: raise;

Line 831: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

827: exception
828: when app_exception.application_exception then
829: if hr_multi_message.exception_add
830: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
831: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
832: ) then
833: hr_utility.set_location(' Leaving:'||l_proc,4);
834: raise;
835: end if;

Line 900: (p_address_id in per_addresses.address_id%TYPE

896: --
897: -- {End Of Comments}
898: -- ----------------------------------------------------------------------------
899: procedure chk_date_comb
900: (p_address_id in per_addresses.address_id%TYPE
901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE

Line 901: ,p_address_type in per_addresses.address_type%TYPE

897: -- {End Of Comments}
898: -- ----------------------------------------------------------------------------
899: procedure chk_date_comb
900: (p_address_id in per_addresses.address_id%TYPE
901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE

Line 902: ,p_date_from in per_addresses.date_from%TYPE

898: -- ----------------------------------------------------------------------------
899: procedure chk_date_comb
900: (p_address_id in per_addresses.address_id%TYPE
901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 903: ,p_date_to in per_addresses.date_to%TYPE

899: procedure chk_date_comb
900: (p_address_id in per_addresses.address_id%TYPE
901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE
907: ,p_prflagval_override in boolean default false

Line 904: ,p_person_id in per_addresses.person_id%TYPE

900: (p_address_id in per_addresses.address_id%TYPE
901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE
907: ,p_prflagval_override in boolean default false
908: ,p_party_id in per_addresses.party_id%TYPE -- HR/TCA merge

Line 905: ,p_primary_flag in per_addresses.primary_flag%TYPE

901: ,p_address_type in per_addresses.address_type%TYPE
902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE
907: ,p_prflagval_override in boolean default false
908: ,p_party_id in per_addresses.party_id%TYPE -- HR/TCA merge
909: )

Line 906: ,p_object_version_number in per_addresses.object_version_number%TYPE

902: ,p_date_from in per_addresses.date_from%TYPE
903: ,p_date_to in per_addresses.date_to%TYPE
904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE
907: ,p_prflagval_override in boolean default false
908: ,p_party_id in per_addresses.party_id%TYPE -- HR/TCA merge
909: )
910: is

Line 908: ,p_party_id in per_addresses.party_id%TYPE -- HR/TCA merge

904: ,p_person_id in per_addresses.person_id%TYPE
905: ,p_primary_flag in per_addresses.primary_flag%TYPE
906: ,p_object_version_number in per_addresses.object_version_number%TYPE
907: ,p_prflagval_override in boolean default false
908: ,p_party_id in per_addresses.party_id%TYPE -- HR/TCA merge
909: )
910: is
911: --
912: l_proc varchar2(72) := g_package||'chk_date_comb';

Line 946: from per_addresses pa

942: and ACTION_TYPE NOT in ('BEE','X');
943: --
944: cursor csr_dup_add_type_exists is
945: select null
946: from per_addresses pa
947: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
948: and l_date_to >= pa.date_from
949: and pa.address_type = p_address_type
950: and (pa.person_id = p_person_id OR -- HR/TCA merge

Line 958: from per_addresses pa

954: and pa.address_id <> p_address_id));
955: --
956: cursor csr_dup_prim_flag is
957: select null
958: from per_addresses pa
959: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
960: and l_date_to >= pa.date_from
961: and pa.primary_flag = 'Y'
962: and (pa.person_id = p_person_id OR --

Line 970: from per_addresses pa

966: and pa.address_id <> p_address_id));
967: --
968: cursor csr_no_primary is
969: select null
970: from per_addresses pa
971: where p_date_from >= pa.date_from
972: and exists (select null
973: from per_addresses pa2
974: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to

Line 973: from per_addresses pa2

969: select null
970: from per_addresses pa
971: where p_date_from >= pa.date_from
972: and exists (select null
973: from per_addresses pa2
974: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to
975: and (pa2.person_id = p_person_id OR --
976: (pa2.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505
977: and pa2.primary_flag = 'Y')

Line 988: from per_addresses pa

984: cursor csr_invalid_non_prim is
985: select null
986: from sys.dual
987: where exists(select null
988: from per_addresses pa
989: where ((pa.date_from < p_date_from
990: and nvl(pa.date_to, hr_api.g_eot) >=
991: (select date_from
992: from per_addresses

Line 992: from per_addresses

988: from per_addresses pa
989: where ((pa.date_from < p_date_from
990: and nvl(pa.date_to, hr_api.g_eot) >=
991: (select date_from
992: from per_addresses
993: where address_id = p_address_id)
994: and p_date_from <> (select date_from
995: from per_addresses
996: where address_id = p_address_id) )

Line 995: from per_addresses

991: (select date_from
992: from per_addresses
993: where address_id = p_address_id)
994: and p_date_from <> (select date_from
995: from per_addresses
996: where address_id = p_address_id) )
997: or (nvl(pa.date_to, hr_api.g_eot) >
998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)

Line 1000: from per_addresses

996: where address_id = p_address_id) )
997: or (nvl(pa.date_to, hr_api.g_eot) >
998: nvl(p_date_to, hr_api.g_eot)
999: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)
1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>
1003: (select nvl(date_to, hr_api.g_eot)
1004: from per_addresses

Line 1004: from per_addresses

1000: from per_addresses
1001: where address_id = p_address_id)
1002: and nvl(p_date_to, hr_api.g_eot) <>
1003: (select nvl(date_to, hr_api.g_eot)
1004: from per_addresses
1005: where address_id = p_address_id) ))
1006: and pa.primary_flag = 'N'
1007: and (pa.person_id = p_person_id OR
1008: (pa.party_id = p_party_id and p_person_id is null)));-- HR/TCA merge --#3406505

Line 1015: from per_addresses pa

1011: cursor csr_check_other_addresses is
1012: select null
1013: from sys.dual
1014: where exists(select null
1015: from per_addresses pa
1016: where (pa.person_id = p_person_id OR
1017: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1018: and pa.primary_flag = 'Y'
1019: and (p_address_id is null

Line 1026: from per_addresses pa

1022: --
1023: cursor csr_chk_contig_add_before is
1024: select pa.date_from,
1025: pa.date_to
1026: from per_addresses pa
1027: where (pa.person_id = p_person_id OR
1028: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1029: and pa.primary_flag = 'Y'
1030: and pa.date_to < p_date_from

Line 1037: from per_addresses pa

1033: and p_address_id <> pa.address_id));
1034: --
1035: cursor csr_chk_contig_add_after is
1036: select pa.date_from, pa.date_to
1037: from per_addresses pa
1038: where (pa.person_id = p_person_id OR
1039: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1040: and pa.primary_flag = 'Y'
1041: and pa.date_from > p_date_to

Line 1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'

1068: ,p_argument_value => p_primary_flag
1069: );
1070: hr_utility.set_location(l_proc, 20);
1071: if hr_multi_message.no_all_inclusive_error
1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1076: ) then

Line 1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'

1069: );
1070: hr_utility.set_location(l_proc, 20);
1071: if hr_multi_message.no_all_inclusive_error
1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1076: ) then
1077: --

Line 1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'

1070: hr_utility.set_location(l_proc, 20);
1071: if hr_multi_message.no_all_inclusive_error
1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1076: ) then
1077: --
1078: -- Set the DATE_TO to entered value or the end of time

Line 1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'

1071: if hr_multi_message.no_all_inclusive_error
1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1076: ) then
1077: --
1078: -- Set the DATE_TO to entered value or the end of time
1079: --

Line 1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

1115: if csr_dup_add_type_exists%found then
1116: close csr_dup_add_type_exists;
1117: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1118: hr_multi_message.add
1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'

Line 1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

1116: close csr_dup_add_type_exists;
1117: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1118: hr_multi_message.add
1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1124: );

Line 1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'

1117: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1118: hr_multi_message.add
1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1124: );
1125: else

Line 1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

1118: hr_multi_message.add
1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1124: );
1125: else
1126: --

Line 1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'

1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1123: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1124: );
1125: else
1126: --
1127: close csr_dup_add_type_exists;

Line 1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

1151: if csr_dup_prim_flag%found then
1152: close csr_dup_prim_flag;
1153: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1154: hr_multi_message.add
1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1159: );

Line 1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

1152: close csr_dup_prim_flag;
1153: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1154: hr_multi_message.add
1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1159: );
1160: else

Line 1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'

1153: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1154: hr_multi_message.add
1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1159: );
1160: else
1161: --

Line 1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

1154: hr_multi_message.add
1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1159: );
1160: else
1161: --
1162: close csr_dup_prim_flag;

Line 1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

1217: or
1218: (l_good_recs < 1)) then
1219: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1220: hr_multi_message.add
1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1225: );

Line 1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

1218: (l_good_recs < 1)) then
1219: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1220: hr_multi_message.add
1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1225: );
1226: end if;

Line 1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'

1219: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1220: hr_multi_message.add
1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1225: );
1226: end if;
1227: end if;

Line 1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

1220: hr_multi_message.add
1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1225: );
1226: end if;
1227: end if;
1228: --

Line 1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

1244: if csr_invalid_non_prim%found then
1245: close csr_invalid_non_prim;
1246: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1247: hr_multi_message.add
1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1252: );

Line 1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

1245: close csr_invalid_non_prim;
1246: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1247: hr_multi_message.add
1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1252: );
1253: else

Line 1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'

1246: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1247: hr_multi_message.add
1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1252: );
1253: else
1254: --

Line 1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

1247: hr_multi_message.add
1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1252: );
1253: else
1254: --
1255: close csr_invalid_non_prim;

Line 1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'

1273: if csr_no_primary%notfound then
1274: close csr_no_primary;
1275: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1276: hr_multi_message.add
1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1281: );

Line 1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

1274: close csr_no_primary;
1275: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1276: hr_multi_message.add
1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1281: );
1282: else

Line 1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'

1275: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1276: hr_multi_message.add
1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1281: );
1282: else
1283: --

Line 1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

1276: hr_multi_message.add
1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1281: );
1282: else
1283: --
1284: close csr_no_primary;

Line 1315: from per_addresses

1311: if p_date_from > l_action_eff_date
1312: then
1313: select count(*)
1314: into l_address_count
1315: from per_addresses
1316: where person_id = p_person_id
1317: and address_id <> p_address_id
1318: and l_action_eff_date between date_from
1319: and nvl(date_to,l_action_eff_date);

Line 1415: (p_associated_column1 => 'PER_ADDRESSES.STYLE'

1411: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1412: exception
1413: when app_exception.application_exception then
1414: if hr_multi_message.exception_add
1415: (p_associated_column1 => 'PER_ADDRESSES.STYLE'
1416: ) then
1417: hr_utility.set_location(' Leaving:'||l_proc,5);
1418: raise;
1419: end if;

Line 1482: (p_check_column1 => 'PER_ADDRESSES.REGION_2') then

1478: --
1479: if p_style = 'GB' then
1480: if p_region_2 is not null then
1481: if hr_multi_message.no_exclusive_error
1482: (p_check_column1 => 'PER_ADDRESSES.REGION_2') then
1483: --
1484: l_token := 'region_2';
1485: raise l_error;
1486: --

Line 1594: (p_address_id in per_addresses.address_id%TYPE

1590: --
1591: -- {End Of Comments}
1592: -- ----------------------------------------------------------------------------
1593: procedure chk_address_line1
1594: (p_address_id in per_addresses.address_id%TYPE
1595: ,p_style in per_addresses.style%TYPE
1596: ,p_address_line1 in per_addresses.region_2%TYPE
1597: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1598: is

Line 1595: ,p_style in per_addresses.style%TYPE

1591: -- {End Of Comments}
1592: -- ----------------------------------------------------------------------------
1593: procedure chk_address_line1
1594: (p_address_id in per_addresses.address_id%TYPE
1595: ,p_style in per_addresses.style%TYPE
1596: ,p_address_line1 in per_addresses.region_2%TYPE
1597: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1598: is
1599: --

Line 1596: ,p_address_line1 in per_addresses.region_2%TYPE

1592: -- ----------------------------------------------------------------------------
1593: procedure chk_address_line1
1594: (p_address_id in per_addresses.address_id%TYPE
1595: ,p_style in per_addresses.style%TYPE
1596: ,p_address_line1 in per_addresses.region_2%TYPE
1597: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1598: is
1599: --
1600: l_exists varchar2(1);

Line 1597: ,p_object_version_number in per_addresses.object_version_number%TYPE)

1593: procedure chk_address_line1
1594: (p_address_id in per_addresses.address_id%TYPE
1595: ,p_style in per_addresses.style%TYPE
1596: ,p_address_line1 in per_addresses.region_2%TYPE
1597: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1598: is
1599: --
1600: l_exists varchar2(1);
1601: l_proc varchar2(72) := g_package||'chk_address_line1';

Line 1651: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_LINE1'

1647: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1648: exception
1649: when app_exception.application_exception then
1650: if hr_multi_message.exception_add
1651: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_LINE1'
1652: ) then
1653: hr_utility.set_location(' Leaving:'||l_proc,6);
1654: raise;
1655: end if;

Line 1666: p_address_id in per_addresses.address_id%TYPE,

1662: -- ----------------------------------------------------------------------------
1663: /* Bug 1677965
1664: procedure chk_address1_towncity_comb(
1665: p_business_group_id in number,
1666: p_address_id in per_addresses.address_id%TYPE,
1667: p_object_version_number in per_addresses.object_version_number%TYPE,
1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1669: p_address_line1 in out nocopy per_addresses.address_line1%type,
1670: p_region_1 in out nocopy per_addresses.region_1%type) is

Line 1667: p_object_version_number in per_addresses.object_version_number%TYPE,

1663: /* Bug 1677965
1664: procedure chk_address1_towncity_comb(
1665: p_business_group_id in number,
1666: p_address_id in per_addresses.address_id%TYPE,
1667: p_object_version_number in per_addresses.object_version_number%TYPE,
1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1669: p_address_line1 in out nocopy per_addresses.address_line1%type,
1670: p_region_1 in out nocopy per_addresses.region_1%type) is
1671:

Line 1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,

1664: procedure chk_address1_towncity_comb(
1665: p_business_group_id in number,
1666: p_address_id in per_addresses.address_id%TYPE,
1667: p_object_version_number in per_addresses.object_version_number%TYPE,
1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1669: p_address_line1 in out nocopy per_addresses.address_line1%type,
1670: p_region_1 in out nocopy per_addresses.region_1%type) is
1671:
1672: -- p_town_or_city ===> district_code

Line 1669: p_address_line1 in out nocopy per_addresses.address_line1%type,

1665: p_business_group_id in number,
1666: p_address_id in per_addresses.address_id%TYPE,
1667: p_object_version_number in per_addresses.object_version_number%TYPE,
1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1669: p_address_line1 in out nocopy per_addresses.address_line1%type,
1670: p_region_1 in out nocopy per_addresses.region_1%type) is
1671:
1672: -- p_town_or_city ===> district_code
1673: -- p_address_line1 ===> address_line1

Line 1670: p_region_1 in out nocopy per_addresses.region_1%type) is

1666: p_address_id in per_addresses.address_id%TYPE,
1667: p_object_version_number in per_addresses.object_version_number%TYPE,
1668: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1669: p_address_line1 in out nocopy per_addresses.address_line1%type,
1670: p_region_1 in out nocopy per_addresses.region_1%type) is
1671:
1672: -- p_town_or_city ===> district_code
1673: -- p_address_line1 ===> address_line1
1674: -- p_region_1 ===> address_line1_kana

Line 1677: l_town_or_city per_addresses.town_or_city%type;

1673: -- p_address_line1 ===> address_line1
1674: -- p_region_1 ===> address_line1_kana
1675:
1676: l_legislation_code per_business_groups.legislation_code%TYPE;
1677: l_town_or_city per_addresses.town_or_city%type;
1678: l_address_line1 per_addresses.address_line1%type;
1679: l_region_1 per_addresses.region_1%type;
1680: l_sql_cursor integer; -- Dynamic sql cursor
1681: l_dynamic_sql varchar2(2000); -- Dynamic sql text

Line 1678: l_address_line1 per_addresses.address_line1%type;

1674: -- p_region_1 ===> address_line1_kana
1675:
1676: l_legislation_code per_business_groups.legislation_code%TYPE;
1677: l_town_or_city per_addresses.town_or_city%type;
1678: l_address_line1 per_addresses.address_line1%type;
1679: l_region_1 per_addresses.region_1%type;
1680: l_sql_cursor integer; -- Dynamic sql cursor
1681: l_dynamic_sql varchar2(2000); -- Dynamic sql text
1682: l_rows integer; -- No of rows returned

Line 1679: l_region_1 per_addresses.region_1%type;

1675:
1676: l_legislation_code per_business_groups.legislation_code%TYPE;
1677: l_town_or_city per_addresses.town_or_city%type;
1678: l_address_line1 per_addresses.address_line1%type;
1679: l_region_1 per_addresses.region_1%type;
1680: l_sql_cursor integer; -- Dynamic sql cursor
1681: l_dynamic_sql varchar2(2000); -- Dynamic sql text
1682: l_rows integer; -- No of rows returned
1683:

Line 1867: p_address_id in per_addresses.address_id%TYPE,

1863: -- ----------------------------------------------------------------------------
1864: --
1865: /* Bug 1677965
1866: procedure chk_address2_region2_comb(
1867: p_address_id in per_addresses.address_id%TYPE,
1868: p_object_version_number in per_addresses.object_version_number%TYPE,
1869: p_address_line2 in per_addresses.address_line2%type,
1870: p_region_2 in per_addresses.region_2%type) is
1871:

Line 1868: p_object_version_number in per_addresses.object_version_number%TYPE,

1864: --
1865: /* Bug 1677965
1866: procedure chk_address2_region2_comb(
1867: p_address_id in per_addresses.address_id%TYPE,
1868: p_object_version_number in per_addresses.object_version_number%TYPE,
1869: p_address_line2 in per_addresses.address_line2%type,
1870: p_region_2 in per_addresses.region_2%type) is
1871:
1872: -- p_address_line2 ===> address_line2

Line 1869: p_address_line2 in per_addresses.address_line2%type,

1865: /* Bug 1677965
1866: procedure chk_address2_region2_comb(
1867: p_address_id in per_addresses.address_id%TYPE,
1868: p_object_version_number in per_addresses.object_version_number%TYPE,
1869: p_address_line2 in per_addresses.address_line2%type,
1870: p_region_2 in per_addresses.region_2%type) is
1871:
1872: -- p_address_line2 ===> address_line2
1873: -- p_region_2 ===> address_line2_kana

Line 1870: p_region_2 in per_addresses.region_2%type) is

1866: procedure chk_address2_region2_comb(
1867: p_address_id in per_addresses.address_id%TYPE,
1868: p_object_version_number in per_addresses.object_version_number%TYPE,
1869: p_address_line2 in per_addresses.address_line2%type,
1870: p_region_2 in per_addresses.region_2%type) is
1871:
1872: -- p_address_line2 ===> address_line2
1873: -- p_region_2 ===> address_line2_kana
1874:

Line 1880: l_region_2 per_addresses.region_2%type;

1876: l_proc varchar2(72) := g_package||'chk_address2_region2_comb';
1877: --
1878: l_output varchar2(150);
1879: l_rgeflg varchar2(10);
1880: l_region_2 per_addresses.region_2%type;
1881: --
1882: begin
1883: hr_utility.set_location('Entering:'|| l_proc, 1);
1884:

Line 1928: p_address_id in per_addresses.address_id%TYPE,

1924: -- ----------------------------------------------------------------------------
1925: --
1926: /* Bug 1677965
1927: procedure chk_address3_region3_comb(
1928: p_address_id in per_addresses.address_id%TYPE,
1929: p_object_version_number in per_addresses.object_version_number%TYPE,
1930: p_address_line3 in per_addresses.address_line3%type,
1931: p_region_3 in per_addresses.region_3%type) is
1932:

Line 1929: p_object_version_number in per_addresses.object_version_number%TYPE,

1925: --
1926: /* Bug 1677965
1927: procedure chk_address3_region3_comb(
1928: p_address_id in per_addresses.address_id%TYPE,
1929: p_object_version_number in per_addresses.object_version_number%TYPE,
1930: p_address_line3 in per_addresses.address_line3%type,
1931: p_region_3 in per_addresses.region_3%type) is
1932:
1933: -- p_address_line3 ===> address_line3

Line 1930: p_address_line3 in per_addresses.address_line3%type,

1926: /* Bug 1677965
1927: procedure chk_address3_region3_comb(
1928: p_address_id in per_addresses.address_id%TYPE,
1929: p_object_version_number in per_addresses.object_version_number%TYPE,
1930: p_address_line3 in per_addresses.address_line3%type,
1931: p_region_3 in per_addresses.region_3%type) is
1932:
1933: -- p_address_line3 ===> address_line3
1934: -- p_region_3 ===> address_line3_kana

Line 1931: p_region_3 in per_addresses.region_3%type) is

1927: procedure chk_address3_region3_comb(
1928: p_address_id in per_addresses.address_id%TYPE,
1929: p_object_version_number in per_addresses.object_version_number%TYPE,
1930: p_address_line3 in per_addresses.address_line3%type,
1931: p_region_3 in per_addresses.region_3%type) is
1932:
1933: -- p_address_line3 ===> address_line3
1934: -- p_region_3 ===> address_line3_kana
1935:

Line 1941: l_region_3 per_addresses.region_3%type;

1937: l_proc varchar2(72) := g_package||'chk_address3_region3_comb';
1938: --
1939: l_output varchar2(150);
1940: l_rgeflg varchar2(10);
1941: l_region_3 per_addresses.region_3%type;
1942: --
1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 1);
1945:

Line 2079: (p_address_id in per_addresses.address_id%TYPE

2075: --
2076: -- {End Of Comments}
2077: -- ----------------------------------------------------------------------------
2078: procedure chk_postal_code
2079: (p_address_id in per_addresses.address_id%TYPE
2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2080: ,p_style in per_addresses.style%TYPE

2076: -- {End Of Comments}
2077: -- ----------------------------------------------------------------------------
2078: procedure chk_postal_code
2079: (p_address_id in per_addresses.address_id%TYPE
2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE
2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)

Line 2081: ,p_postal_code in per_addresses.postal_code%TYPE

2077: -- ----------------------------------------------------------------------------
2078: procedure chk_postal_code
2079: (p_address_id in per_addresses.address_id%TYPE
2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE
2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2085: is

Line 2082: ,p_business_group_id in per_addresses.business_group_id%TYPE

2078: procedure chk_postal_code
2079: (p_address_id in per_addresses.address_id%TYPE
2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE
2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2085: is
2086: -- Cursor Defination added for bug 5367066

Line 2083: ,p_object_version_number in per_addresses.object_version_number%TYPE

2079: (p_address_id in per_addresses.address_id%TYPE
2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE
2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2085: is
2086: -- Cursor Defination added for bug 5367066
2087: cursor get_city_address is

Line 2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)

2080: ,p_style in per_addresses.style%TYPE
2081: ,p_postal_code in per_addresses.postal_code%TYPE
2082: ,p_business_group_id in per_addresses.business_group_id%TYPE
2083: ,p_object_version_number in per_addresses.object_version_number%TYPE
2084: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2085: is
2086: -- Cursor Defination added for bug 5367066
2087: cursor get_city_address is
2088: select c.state_abbrev

Line 2364: (p_associated_column1 => 'PER_ADDRESSES.POSTAL_CODE'

2360: hr_utility.set_location(' Leaving:'|| l_proc, 9);
2361: exception
2362: when app_exception.application_exception then
2363: if hr_multi_message.exception_add
2364: (p_associated_column1 => 'PER_ADDRESSES.POSTAL_CODE'
2365: ) then
2366: hr_utility.set_location(' Leaving:'||l_proc,10);
2367: raise;
2368: end if;

Line 2410: (p_address_id in per_addresses.address_id%TYPE

2406: --
2407: -- {End Of Comments}
2408: -- ----------------------------------------------------------------------------
2409: procedure chk_tax_address_zip
2410: (p_address_id in per_addresses.address_id%TYPE
2411: ,p_style in per_addresses.style%TYPE
2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2413: ,p_business_group_id in per_addresses.business_group_id%TYPE
2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 2411: ,p_style in per_addresses.style%TYPE

2407: -- {End Of Comments}
2408: -- ----------------------------------------------------------------------------
2409: procedure chk_tax_address_zip
2410: (p_address_id in per_addresses.address_id%TYPE
2411: ,p_style in per_addresses.style%TYPE
2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2413: ,p_business_group_id in per_addresses.business_group_id%TYPE
2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2415: is

Line 2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE

2408: -- ----------------------------------------------------------------------------
2409: procedure chk_tax_address_zip
2410: (p_address_id in per_addresses.address_id%TYPE
2411: ,p_style in per_addresses.style%TYPE
2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2413: ,p_business_group_id in per_addresses.business_group_id%TYPE
2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2415: is
2416: --

Line 2413: ,p_business_group_id in per_addresses.business_group_id%TYPE

2409: procedure chk_tax_address_zip
2410: (p_address_id in per_addresses.address_id%TYPE
2411: ,p_style in per_addresses.style%TYPE
2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2413: ,p_business_group_id in per_addresses.business_group_id%TYPE
2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2415: is
2416: --
2417: l_proc varchar2(72) := g_package||'chk_tax_address_zip';

Line 2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)

2410: (p_address_id in per_addresses.address_id%TYPE
2411: ,p_style in per_addresses.style%TYPE
2412: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2413: ,p_business_group_id in per_addresses.business_group_id%TYPE
2414: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2415: is
2416: --
2417: l_proc varchar2(72) := g_package||'chk_tax_address_zip';
2418: l_api_updating boolean;

Line 2537: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'

2533: hr_utility.set_location(' Leaving:'|| l_proc, 7);
2534: exception
2535: when app_exception.application_exception then
2536: if hr_multi_message.exception_add
2537: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
2538: ) then
2539: hr_utility.set_location(' Leaving:'||l_proc,6);
2540: raise;
2541: end if;

Line 2586: (p_address_id in per_addresses.address_id%TYPE

2582: --
2583: -- {End Of Comments}
2584: -- ----------------------------------------------------------------------------
2585: procedure chk_region_1
2586: (p_address_id in per_addresses.address_id%TYPE
2587: ,p_style in per_addresses.style%TYPE
2588: ,p_region_1 in per_addresses.region_1%TYPE
2589: ,p_business_group_id in per_addresses.business_group_id%TYPE
2590: ,p_effective_date in date

Line 2587: ,p_style in per_addresses.style%TYPE

2583: -- {End Of Comments}
2584: -- ----------------------------------------------------------------------------
2585: procedure chk_region_1
2586: (p_address_id in per_addresses.address_id%TYPE
2587: ,p_style in per_addresses.style%TYPE
2588: ,p_region_1 in per_addresses.region_1%TYPE
2589: ,p_business_group_id in per_addresses.business_group_id%TYPE
2590: ,p_effective_date in date
2591: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2588: ,p_region_1 in per_addresses.region_1%TYPE

2584: -- ----------------------------------------------------------------------------
2585: procedure chk_region_1
2586: (p_address_id in per_addresses.address_id%TYPE
2587: ,p_style in per_addresses.style%TYPE
2588: ,p_region_1 in per_addresses.region_1%TYPE
2589: ,p_business_group_id in per_addresses.business_group_id%TYPE
2590: ,p_effective_date in date
2591: ,p_object_version_number in per_addresses.object_version_number%TYPE
2592: ,p_validate_county in boolean default TRUE)

Line 2589: ,p_business_group_id in per_addresses.business_group_id%TYPE

2585: procedure chk_region_1
2586: (p_address_id in per_addresses.address_id%TYPE
2587: ,p_style in per_addresses.style%TYPE
2588: ,p_region_1 in per_addresses.region_1%TYPE
2589: ,p_business_group_id in per_addresses.business_group_id%TYPE
2590: ,p_effective_date in date
2591: ,p_object_version_number in per_addresses.object_version_number%TYPE
2592: ,p_validate_county in boolean default TRUE)
2593: is

Line 2591: ,p_object_version_number in per_addresses.object_version_number%TYPE

2587: ,p_style in per_addresses.style%TYPE
2588: ,p_region_1 in per_addresses.region_1%TYPE
2589: ,p_business_group_id in per_addresses.business_group_id%TYPE
2590: ,p_effective_date in date
2591: ,p_object_version_number in per_addresses.object_version_number%TYPE
2592: ,p_validate_county in boolean default TRUE)
2593: is
2594: --
2595: l_exists varchar2(1);

Line 2694: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'

2690: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2691: exception
2692: when app_exception.application_exception then
2693: if hr_multi_message.exception_add
2694: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
2695: ) then
2696: hr_utility.set_location(' Leaving:'||l_proc,7);
2697: raise;
2698: end if;

Line 2739: (p_address_id in per_addresses.address_id%TYPE

2735: --
2736: -- {End Of Comments}
2737: -- ----------------------------------------------------------------------------
2738: procedure chk_tax_county
2739: (p_address_id in per_addresses.address_id%TYPE
2740: ,p_style in per_addresses.style%TYPE
2741: ,p_tax_county in per_addresses.add_information19%TYPE
2742: ,p_business_group_id in per_addresses.business_group_id%TYPE
2743: ,p_effective_date in date

Line 2740: ,p_style in per_addresses.style%TYPE

2736: -- {End Of Comments}
2737: -- ----------------------------------------------------------------------------
2738: procedure chk_tax_county
2739: (p_address_id in per_addresses.address_id%TYPE
2740: ,p_style in per_addresses.style%TYPE
2741: ,p_tax_county in per_addresses.add_information19%TYPE
2742: ,p_business_group_id in per_addresses.business_group_id%TYPE
2743: ,p_effective_date in date
2744: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 2741: ,p_tax_county in per_addresses.add_information19%TYPE

2737: -- ----------------------------------------------------------------------------
2738: procedure chk_tax_county
2739: (p_address_id in per_addresses.address_id%TYPE
2740: ,p_style in per_addresses.style%TYPE
2741: ,p_tax_county in per_addresses.add_information19%TYPE
2742: ,p_business_group_id in per_addresses.business_group_id%TYPE
2743: ,p_effective_date in date
2744: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2745: is

Line 2742: ,p_business_group_id in per_addresses.business_group_id%TYPE

2738: procedure chk_tax_county
2739: (p_address_id in per_addresses.address_id%TYPE
2740: ,p_style in per_addresses.style%TYPE
2741: ,p_tax_county in per_addresses.add_information19%TYPE
2742: ,p_business_group_id in per_addresses.business_group_id%TYPE
2743: ,p_effective_date in date
2744: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2745: is
2746: --

Line 2744: ,p_object_version_number in per_addresses.object_version_number%TYPE)

2740: ,p_style in per_addresses.style%TYPE
2741: ,p_tax_county in per_addresses.add_information19%TYPE
2742: ,p_business_group_id in per_addresses.business_group_id%TYPE
2743: ,p_effective_date in date
2744: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2745: is
2746: --
2747: l_exists varchar2(1);
2748: l_proc varchar2(72) := g_package||'chk_tax_county';

Line 2816: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION19'

2812: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2813: exception
2814: when app_exception.application_exception then
2815: if hr_multi_message.exception_add
2816: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION19'
2817: ) then
2818: hr_utility.set_location(' Leaving:'||l_proc,7);
2819: raise;
2820: end if;

Line 2861: (p_address_id in per_addresses.address_id%TYPE

2857: --
2858: -- {End Of Comments}
2859: -- ----------------------------------------------------------------------------
2860: procedure chk_region_2
2861: (p_address_id in per_addresses.address_id%TYPE
2862: ,p_style in per_addresses.style%TYPE
2863: ,p_region_2 in per_addresses.region_2%TYPE
2864: ,p_business_group_id in per_addresses.business_group_id%TYPE
2865: ,p_effective_date in date

Line 2862: ,p_style in per_addresses.style%TYPE

2858: -- {End Of Comments}
2859: -- ----------------------------------------------------------------------------
2860: procedure chk_region_2
2861: (p_address_id in per_addresses.address_id%TYPE
2862: ,p_style in per_addresses.style%TYPE
2863: ,p_region_2 in per_addresses.region_2%TYPE
2864: ,p_business_group_id in per_addresses.business_group_id%TYPE
2865: ,p_effective_date in date
2866: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2863: ,p_region_2 in per_addresses.region_2%TYPE

2859: -- ----------------------------------------------------------------------------
2860: procedure chk_region_2
2861: (p_address_id in per_addresses.address_id%TYPE
2862: ,p_style in per_addresses.style%TYPE
2863: ,p_region_2 in per_addresses.region_2%TYPE
2864: ,p_business_group_id in per_addresses.business_group_id%TYPE
2865: ,p_effective_date in date
2866: ,p_object_version_number in per_addresses.object_version_number%TYPE
2867: )

Line 2864: ,p_business_group_id in per_addresses.business_group_id%TYPE

2860: procedure chk_region_2
2861: (p_address_id in per_addresses.address_id%TYPE
2862: ,p_style in per_addresses.style%TYPE
2863: ,p_region_2 in per_addresses.region_2%TYPE
2864: ,p_business_group_id in per_addresses.business_group_id%TYPE
2865: ,p_effective_date in date
2866: ,p_object_version_number in per_addresses.object_version_number%TYPE
2867: )
2868: is

Line 2866: ,p_object_version_number in per_addresses.object_version_number%TYPE

2862: ,p_style in per_addresses.style%TYPE
2863: ,p_region_2 in per_addresses.region_2%TYPE
2864: ,p_business_group_id in per_addresses.business_group_id%TYPE
2865: ,p_effective_date in date
2866: ,p_object_version_number in per_addresses.object_version_number%TYPE
2867: )
2868: is
2869: --
2870: l_exists varchar2(1);

Line 2976: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'

2972: hr_utility.set_location(' Leaving:'|| l_proc, 10);
2973: exception
2974: when app_exception.application_exception then
2975: if hr_multi_message.exception_add
2976: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
2977: ) then
2978: hr_utility.set_location(' Leaving:'||l_proc,11);
2979: raise;
2980: end if;

Line 3021: (p_address_id in per_addresses.address_id%TYPE

3017: --
3018: -- {End Of Comments}
3019: -- ----------------------------------------------------------------------------
3020: procedure chk_tax_state
3021: (p_address_id in per_addresses.address_id%TYPE
3022: ,p_style in per_addresses.style%TYPE
3023: ,p_tax_state in per_addresses.add_information17%TYPE
3024: ,p_business_group_id in per_addresses.business_group_id%TYPE
3025: ,p_effective_date in date

Line 3022: ,p_style in per_addresses.style%TYPE

3018: -- {End Of Comments}
3019: -- ----------------------------------------------------------------------------
3020: procedure chk_tax_state
3021: (p_address_id in per_addresses.address_id%TYPE
3022: ,p_style in per_addresses.style%TYPE
3023: ,p_tax_state in per_addresses.add_information17%TYPE
3024: ,p_business_group_id in per_addresses.business_group_id%TYPE
3025: ,p_effective_date in date
3026: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3023: ,p_tax_state in per_addresses.add_information17%TYPE

3019: -- ----------------------------------------------------------------------------
3020: procedure chk_tax_state
3021: (p_address_id in per_addresses.address_id%TYPE
3022: ,p_style in per_addresses.style%TYPE
3023: ,p_tax_state in per_addresses.add_information17%TYPE
3024: ,p_business_group_id in per_addresses.business_group_id%TYPE
3025: ,p_effective_date in date
3026: ,p_object_version_number in per_addresses.object_version_number%TYPE
3027: )

Line 3024: ,p_business_group_id in per_addresses.business_group_id%TYPE

3020: procedure chk_tax_state
3021: (p_address_id in per_addresses.address_id%TYPE
3022: ,p_style in per_addresses.style%TYPE
3023: ,p_tax_state in per_addresses.add_information17%TYPE
3024: ,p_business_group_id in per_addresses.business_group_id%TYPE
3025: ,p_effective_date in date
3026: ,p_object_version_number in per_addresses.object_version_number%TYPE
3027: )
3028: is

Line 3026: ,p_object_version_number in per_addresses.object_version_number%TYPE

3022: ,p_style in per_addresses.style%TYPE
3023: ,p_tax_state in per_addresses.add_information17%TYPE
3024: ,p_business_group_id in per_addresses.business_group_id%TYPE
3025: ,p_effective_date in date
3026: ,p_object_version_number in per_addresses.object_version_number%TYPE
3027: )
3028: is
3029: --
3030: l_exists varchar2(1);

Line 3120: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3116: hr_utility.set_location(' Leaving:'|| l_proc, 10);
3117: exception
3118: when app_exception.application_exception then
3119: if hr_multi_message.exception_add
3120: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3121: ) then
3122: hr_utility.set_location(' Leaving:'||l_proc,11);
3123: raise;
3124: end if;

Line 3163: (p_address_id in per_addresses.address_id%TYPE

3159: --
3160: -- {End Of Comments}
3161: -- ----------------------------------------------------------------------------
3162: procedure chk_town_or_city
3163: (p_address_id in per_addresses.address_id%TYPE
3164: ,p_style in per_addresses.style%TYPE
3165: ,p_town_or_city in per_addresses.town_or_city%TYPE
3166: ,p_business_group_id in per_addresses.business_group_id%TYPE
3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 3164: ,p_style in per_addresses.style%TYPE

3160: -- {End Of Comments}
3161: -- ----------------------------------------------------------------------------
3162: procedure chk_town_or_city
3163: (p_address_id in per_addresses.address_id%TYPE
3164: ,p_style in per_addresses.style%TYPE
3165: ,p_town_or_city in per_addresses.town_or_city%TYPE
3166: ,p_business_group_id in per_addresses.business_group_id%TYPE
3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3168: is

Line 3165: ,p_town_or_city in per_addresses.town_or_city%TYPE

3161: -- ----------------------------------------------------------------------------
3162: procedure chk_town_or_city
3163: (p_address_id in per_addresses.address_id%TYPE
3164: ,p_style in per_addresses.style%TYPE
3165: ,p_town_or_city in per_addresses.town_or_city%TYPE
3166: ,p_business_group_id in per_addresses.business_group_id%TYPE
3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3168: is
3169: --

Line 3166: ,p_business_group_id in per_addresses.business_group_id%TYPE

3162: procedure chk_town_or_city
3163: (p_address_id in per_addresses.address_id%TYPE
3164: ,p_style in per_addresses.style%TYPE
3165: ,p_town_or_city in per_addresses.town_or_city%TYPE
3166: ,p_business_group_id in per_addresses.business_group_id%TYPE
3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3168: is
3169: --
3170: l_exists varchar2(1);

Line 3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)

3163: (p_address_id in per_addresses.address_id%TYPE
3164: ,p_style in per_addresses.style%TYPE
3165: ,p_town_or_city in per_addresses.town_or_city%TYPE
3166: ,p_business_group_id in per_addresses.business_group_id%TYPE
3167: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3168: is
3169: --
3170: l_exists varchar2(1);
3171: l_proc varchar2(72) := g_package||'chk_town_or_city';

Line 3235: (p_associated_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'

3231: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3232: exception
3233: when app_exception.application_exception then
3234: if hr_multi_message.exception_add
3235: (p_associated_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3236: ) then
3237: hr_utility.set_location(' Leaving:'||l_proc,6);
3238: raise;
3239: end if;

Line 3278: (p_address_id in per_addresses.address_id%TYPE

3274: --
3275: -- {End Of Comments}
3276: -- ----------------------------------------------------------------------------
3277: procedure chk_tax_city
3278: (p_address_id in per_addresses.address_id%TYPE
3279: ,p_style in per_addresses.style%TYPE
3280: ,p_tax_city in per_addresses.add_information18%TYPE
3281: ,p_business_group_id in per_addresses.business_group_id%TYPE
3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 3279: ,p_style in per_addresses.style%TYPE

3275: -- {End Of Comments}
3276: -- ----------------------------------------------------------------------------
3277: procedure chk_tax_city
3278: (p_address_id in per_addresses.address_id%TYPE
3279: ,p_style in per_addresses.style%TYPE
3280: ,p_tax_city in per_addresses.add_information18%TYPE
3281: ,p_business_group_id in per_addresses.business_group_id%TYPE
3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3283: is

Line 3280: ,p_tax_city in per_addresses.add_information18%TYPE

3276: -- ----------------------------------------------------------------------------
3277: procedure chk_tax_city
3278: (p_address_id in per_addresses.address_id%TYPE
3279: ,p_style in per_addresses.style%TYPE
3280: ,p_tax_city in per_addresses.add_information18%TYPE
3281: ,p_business_group_id in per_addresses.business_group_id%TYPE
3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3283: is
3284: --

Line 3281: ,p_business_group_id in per_addresses.business_group_id%TYPE

3277: procedure chk_tax_city
3278: (p_address_id in per_addresses.address_id%TYPE
3279: ,p_style in per_addresses.style%TYPE
3280: ,p_tax_city in per_addresses.add_information18%TYPE
3281: ,p_business_group_id in per_addresses.business_group_id%TYPE
3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3283: is
3284: --
3285: l_exists varchar2(1);

Line 3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)

3278: (p_address_id in per_addresses.address_id%TYPE
3279: ,p_style in per_addresses.style%TYPE
3280: ,p_tax_city in per_addresses.add_information18%TYPE
3281: ,p_business_group_id in per_addresses.business_group_id%TYPE
3282: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3283: is
3284: --
3285: l_exists varchar2(1);
3286: l_proc varchar2(72) := g_package||'chk_tax_city';

Line 3343: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'

3339: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3340: exception
3341: when app_exception.application_exception then
3342: if hr_multi_message.exception_add
3343: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3344: ) then
3345: hr_utility.set_location(' Leaving:'||l_proc,6);
3346: raise;
3347: end if;

Line 3391: (p_address_id in per_addresses.address_id%TYPE

3387: --
3388: -- {End Of Comments}
3389: -- ----------------------------------------------------------------------------
3390: procedure chk_city_state_zip_comb
3391: (p_address_id in per_addresses.address_id%TYPE
3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE

Line 3392: ,p_style in per_addresses.style%TYPE

3388: -- {End Of Comments}
3389: -- ----------------------------------------------------------------------------
3390: procedure chk_city_state_zip_comb
3391: (p_address_id in per_addresses.address_id%TYPE
3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE

Line 3393: ,p_postal_code in per_addresses.postal_code%TYPE

3389: -- ----------------------------------------------------------------------------
3390: procedure chk_city_state_zip_comb
3391: (p_address_id in per_addresses.address_id%TYPE
3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE

Line 3394: ,p_region_1 in per_addresses.region_1%TYPE

3390: procedure chk_city_state_zip_comb
3391: (p_address_id in per_addresses.address_id%TYPE
3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE
3398: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3395: ,p_region_2 in per_addresses.region_2%TYPE

3391: (p_address_id in per_addresses.address_id%TYPE
3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE
3398: ,p_object_version_number in per_addresses.object_version_number%TYPE
3399: )

Line 3396: ,p_town_or_city in per_addresses.town_or_city%TYPE

3392: ,p_style in per_addresses.style%TYPE
3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE
3398: ,p_object_version_number in per_addresses.object_version_number%TYPE
3399: )
3400: is

Line 3397: ,p_business_group_id in per_addresses.business_group_id%TYPE

3393: ,p_postal_code in per_addresses.postal_code%TYPE
3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE
3398: ,p_object_version_number in per_addresses.object_version_number%TYPE
3399: )
3400: is
3401: --

Line 3398: ,p_object_version_number in per_addresses.object_version_number%TYPE

3394: ,p_region_1 in per_addresses.region_1%TYPE
3395: ,p_region_2 in per_addresses.region_2%TYPE
3396: ,p_town_or_city in per_addresses.town_or_city%TYPE
3397: ,p_business_group_id in per_addresses.business_group_id%TYPE
3398: ,p_object_version_number in per_addresses.object_version_number%TYPE
3399: )
3400: is
3401: --
3402: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';

Line 3509: (p_check_column1 => 'PER_ADDRESSES.REGION_2'

3505: --
3506: if (p_region_1 is null) then
3507: --
3508: if hr_multi_message.no_exclusive_error
3509: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3510: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3511: ) then
3512: --
3513: hr_utility.set_location(l_proc, 40);

Line 3510: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'

3506: if (p_region_1 is null) then
3507: --
3508: if hr_multi_message.no_exclusive_error
3509: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3510: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3511: ) then
3512: --
3513: hr_utility.set_location(l_proc, 40);
3514: --

Line 3525: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'

3521: close csr_val_st_city;
3522: hr_utility.set_location(l_proc, 50);
3523: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3524: hr_multi_message.add
3525: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3526: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3527: );
3528: else
3529: close csr_val_st_city;

Line 3526: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'

3522: hr_utility.set_location(l_proc, 50);
3523: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3524: hr_multi_message.add
3525: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3526: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3527: );
3528: else
3529: close csr_val_st_city;
3530: hr_utility.set_location(l_proc, 60);

Line 3535: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'

3531: --
3532: -- check for a valid state, city, zip combination
3533: --
3534: if hr_multi_message.no_exclusive_error
3535: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3536: ) then
3537: --
3538: open csr_valid_zip_code_no_ncty;
3539: fetch csr_valid_zip_code_no_ncty into l_exists;

Line 3545: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'

3541: close csr_valid_zip_code_no_ncty;
3542: hr_utility.set_location(l_proc, 70);
3543: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3544: hr_multi_message.add
3545: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3546: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3547: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3548: );
3549: else

Line 3546: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'

3542: hr_utility.set_location(l_proc, 70);
3543: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3544: hr_multi_message.add
3545: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3546: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3547: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3548: );
3549: else
3550: close csr_valid_zip_code_no_ncty;

Line 3547: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'

3543: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3544: hr_multi_message.add
3545: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3546: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3547: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3548: );
3549: else
3550: close csr_valid_zip_code_no_ncty;
3551: hr_utility.set_location(l_proc, 80);

Line 3567: (p_check_column1 => 'PER_ADDRESSES.REGION_1'

3563: --
3564: -- Validate the state and county combination
3565: --
3566: if hr_multi_message.no_exclusive_error
3567: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3568: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3569: ) then
3570: --
3571: hr_utility.set_location(l_proc, 90);

Line 3568: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'

3564: -- Validate the state and county combination
3565: --
3566: if hr_multi_message.no_exclusive_error
3567: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3568: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3569: ) then
3570: --
3571: hr_utility.set_location(l_proc, 90);
3572: open csr_valid_state_county;

Line 3581: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'

3577: --
3578: hr_utility.set_location(l_proc, 100);
3579: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3580: hr_multi_message.add
3581: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3582: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3583: );
3584: else
3585: close csr_valid_state_county;

Line 3582: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'

3578: hr_utility.set_location(l_proc, 100);
3579: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3580: hr_multi_message.add
3581: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3582: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3583: );
3584: else
3585: close csr_valid_state_county;
3586: hr_utility.set_location(l_proc, 110);

Line 3592: (p_check_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'

3588: --
3589: -- Validate the state, county and city combination
3590: --
3591: if hr_multi_message.no_exclusive_error
3592: (p_check_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3593: ) then
3594: open csr_val_st_county_city;
3595: fetch csr_val_st_county_city into l_city_code;
3596: --

Line 3603: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'

3599: --
3600: hr_utility.set_location(l_proc, 120);
3601: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3602: hr_multi_message.add
3603: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3604: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3605: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3606: );
3607: else

Line 3604: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'

3600: hr_utility.set_location(l_proc, 120);
3601: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3602: hr_multi_message.add
3603: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3604: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3605: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3606: );
3607: else
3608: close csr_val_st_county_city;

Line 3605: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'

3601: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3602: hr_multi_message.add
3603: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3604: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3605: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3606: );
3607: else
3608: close csr_val_st_county_city;
3609: hr_utility.set_location(l_proc, 130);

Line 3615: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'

3611: --
3612: -- Validate the state, county, city and zip code combination
3613: --
3614: if hr_multi_message.no_exclusive_error
3615: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3616: ) then
3617: --
3618: open csr_valid_zip_code;
3619: fetch csr_valid_zip_code into l_exists;

Line 3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'

3622: --
3623: hr_utility.set_location(l_proc, 140);
3624: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3625: hr_multi_message.add
3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3630: );

Line 3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'

3623: hr_utility.set_location(l_proc, 140);
3624: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3625: hr_multi_message.add
3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3630: );
3631: else

Line 3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'

3624: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3625: hr_multi_message.add
3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3630: );
3631: else
3632: close csr_valid_zip_code;

Line 3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'

3625: hr_multi_message.add
3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3630: );
3631: else
3632: close csr_valid_zip_code;
3633: hr_utility.set_location(l_proc, 150);

Line 3692: (p_address_id in per_addresses.address_id%TYPE

3688: --
3689: -- {End Of Comments}
3690: -- ----------------------------------------------------------------------------
3691: procedure chk_tax_city_state_zip_comb
3692: (p_address_id in per_addresses.address_id%TYPE
3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE

Line 3693: ,p_style in per_addresses.style%TYPE

3689: -- {End Of Comments}
3690: -- ----------------------------------------------------------------------------
3691: procedure chk_tax_city_state_zip_comb
3692: (p_address_id in per_addresses.address_id%TYPE
3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE

Line 3694: ,p_tax_zip in per_addresses.add_information20%TYPE

3690: -- ----------------------------------------------------------------------------
3691: procedure chk_tax_city_state_zip_comb
3692: (p_address_id in per_addresses.address_id%TYPE
3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE

Line 3695: ,p_tax_county in per_addresses.add_information19%TYPE

3691: procedure chk_tax_city_state_zip_comb
3692: (p_address_id in per_addresses.address_id%TYPE
3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE
3699: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3696: ,p_tax_state in per_addresses.add_information17%TYPE

3692: (p_address_id in per_addresses.address_id%TYPE
3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE
3699: ,p_object_version_number in per_addresses.object_version_number%TYPE
3700: )

Line 3697: ,p_tax_city in per_addresses.add_information18%TYPE

3693: ,p_style in per_addresses.style%TYPE
3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE
3699: ,p_object_version_number in per_addresses.object_version_number%TYPE
3700: )
3701: is

Line 3698: ,p_business_group_id in per_addresses.business_group_id%TYPE

3694: ,p_tax_zip in per_addresses.add_information20%TYPE
3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE
3699: ,p_object_version_number in per_addresses.object_version_number%TYPE
3700: )
3701: is
3702: --

Line 3699: ,p_object_version_number in per_addresses.object_version_number%TYPE

3695: ,p_tax_county in per_addresses.add_information19%TYPE
3696: ,p_tax_state in per_addresses.add_information17%TYPE
3697: ,p_tax_city in per_addresses.add_information18%TYPE
3698: ,p_business_group_id in per_addresses.business_group_id%TYPE
3699: ,p_object_version_number in per_addresses.object_version_number%TYPE
3700: )
3701: is
3702: --
3703: l_proc varchar2(72) := g_package||'chk_tax_city_state_zip_comb';

Line 3813: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3809: --
3810: --
3811: if (p_tax_county is null) then
3812: if hr_multi_message.no_exclusive_error
3813: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3814: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3815: ) then
3816: hr_utility.set_location(l_proc, 40);
3817: --

Line 3814: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'

3810: --
3811: if (p_tax_county is null) then
3812: if hr_multi_message.no_exclusive_error
3813: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3814: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3815: ) then
3816: hr_utility.set_location(l_proc, 40);
3817: --
3818: -- no county is given, so procede with validation which excluses it;

Line 3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3824: close csr_val_st_city;
3825: hr_utility.set_location(l_proc, 50);
3826: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: );
3831: else
3832: close csr_val_st_city;

Line 3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'

3825: hr_utility.set_location(l_proc, 50);
3826: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: );
3831: else
3832: close csr_val_st_city;
3833: hr_utility.set_location(l_proc, 60);

Line 3838: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'

3834: --
3835: -- check for a valid state, city, zip combination
3836: --
3837: if hr_multi_message.no_exclusive_error
3838: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3839: ) then
3840: open csr_valid_zip_code_no_ncty;
3841: fetch csr_valid_zip_code_no_ncty into l_exists;
3842: if csr_valid_zip_code_no_ncty%notfound then

Line 3847: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3843: close csr_valid_zip_code_no_ncty;
3844: hr_utility.set_location(l_proc, 70);
3845: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3846: hr_multi_message.add
3847: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3848: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3849: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3850: );
3851: else

Line 3848: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'

3844: hr_utility.set_location(l_proc, 70);
3845: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3846: hr_multi_message.add
3847: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3848: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3849: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3850: );
3851: else
3852: --

Line 3849: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'

3845: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3846: hr_multi_message.add
3847: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3848: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3849: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3850: );
3851: else
3852: --
3853: close csr_valid_zip_code_no_ncty;

Line 3871: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3867: --
3868: -- Validate the state and county combination
3869: --
3870: if hr_multi_message.no_exclusive_error
3871: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3872: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3873: ) then
3874: --
3875: hr_utility.set_location(l_proc, 90);

Line 3872: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'

3868: -- Validate the state and county combination
3869: --
3870: if hr_multi_message.no_exclusive_error
3871: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3872: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3873: ) then
3874: --
3875: hr_utility.set_location(l_proc, 90);
3876: open csr_valid_state_county;

Line 3885: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3881: --
3882: hr_utility.set_location(l_proc, 100);
3883: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3884: hr_multi_message.add
3885: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3886: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3887: );
3888: --
3889: else

Line 3886: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'

3882: hr_utility.set_location(l_proc, 100);
3883: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3884: hr_multi_message.add
3885: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3886: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3887: );
3888: --
3889: else
3890: --

Line 3899: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'

3895: --
3896: -- Validate the state, county and city combination
3897: --
3898: if hr_multi_message.no_exclusive_error
3899: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3900: ) then
3901: open csr_val_st_county_city;
3902: fetch csr_val_st_county_city into l_city_code;
3903: --

Line 3910: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3906: --
3907: hr_utility.set_location(l_proc, 120);
3908: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3909: hr_multi_message.add
3910: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3911: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3912: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3913: );
3914: --

Line 3911: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'

3907: hr_utility.set_location(l_proc, 120);
3908: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3909: hr_multi_message.add
3910: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3911: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3912: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3913: );
3914: --
3915: else

Line 3912: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'

3908: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3909: hr_multi_message.add
3910: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3911: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3912: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3913: );
3914: --
3915: else
3916: --

Line 3925: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'

3921: --
3922: -- Validate the state, county, city and zip code combination
3923: --
3924: if hr_multi_message.no_exclusive_error
3925: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3926: ) then
3927: open csr_valid_zip_code;
3928: fetch csr_valid_zip_code into l_exists;
3929: if csr_valid_zip_code%notfound then

Line 3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'

3931: --
3932: hr_utility.set_location(l_proc, 140);
3933: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3939: );

Line 3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'

3932: hr_utility.set_location(l_proc, 140);
3933: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3939: );
3940: --

Line 3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'

3933: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3939: );
3940: --
3941: else

Line 3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'

3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3939: );
3940: --
3941: else
3942: --

Line 4008: from per_addresses pa

4004: l_date date;
4005: --
4006: cursor csr_del_address is
4007: select null
4008: from per_addresses pa
4009: where pa.date_from between per_add_shd.g_old_rec.date_from
4010: and l_date
4011: and pa.person_id = per_add_shd.g_old_rec.person_id
4012: and pa.primary_flag = 'N';

Line 4018: from per_addresses pa2

4014: cursor csr_no_del_contig_add is
4015: select null
4016: from sys.dual
4017: where exists(select null
4018: from per_addresses pa2
4019: where pa2.date_from > l_date
4020: and pa2.person_id = per_add_shd.g_old_rec.person_id
4021: and pa2.primary_flag = 'Y');
4022: --

Line 4219: ,p_descflex_name => 'PER_ADDRESSES'

4215: then
4216: --
4217: hr_dflex_utility.ins_or_upd_descflex_attribs
4218: (p_appl_short_name => 'PER'
4219: ,p_descflex_name => 'PER_ADDRESSES'
4220: ,p_attribute_category => p_rec.addr_attribute_category
4221: ,p_attribute1_name => 'ADDR_ATTRIBUTE1'
4222: ,p_attribute1_value => p_rec.ADDR_ATTRIBUTE1
4223: ,p_attribute2_name => 'ADDR_ATTRIBUTE2'

Line 5277: , per_addresses adr

5273: --
5274: cursor csr_leg_code is
5275: select pbg.legislation_code
5276: from per_business_groups pbg
5277: , per_addresses adr
5278: where adr.address_id = p_address_id
5279: and pbg.business_group_id = adr.business_group_id;
5280:
5281: --