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 938: from per_addresses pa

934: where assignment_id = p_assignment_id;
935: --
936: cursor csr_dup_add_type_exists is
937: select null
938: from per_addresses pa
939: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
940: and l_date_to >= pa.date_from
941: and pa.address_type = p_address_type
942: and (pa.person_id = p_person_id OR -- HR/TCA merge

Line 950: from per_addresses pa

946: and pa.address_id <> p_address_id));
947: --
948: cursor csr_dup_prim_flag is
949: select null
950: from per_addresses pa
951: where p_date_from <= nvl(pa.date_to, hr_api.g_eot)
952: and l_date_to >= pa.date_from
953: and pa.primary_flag = 'Y'
954: and (pa.person_id = p_person_id OR --

Line 962: from per_addresses pa

958: and pa.address_id <> p_address_id));
959: --
960: cursor csr_no_primary is
961: select null
962: from per_addresses pa
963: where p_date_from >= pa.date_from
964: and exists (select null
965: from per_addresses pa2
966: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to

Line 965: from per_addresses pa2

961: select null
962: from per_addresses pa
963: where p_date_from >= pa.date_from
964: and exists (select null
965: from per_addresses pa2
966: where nvl(pa2.date_to, hr_api.g_eot) >= l_date_to
967: and (pa2.person_id = p_person_id OR --
968: (pa2.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge -- #3406505
969: and pa2.primary_flag = 'Y')

Line 980: from per_addresses pa

976: cursor csr_invalid_non_prim is
977: select null
978: from sys.dual
979: where exists(select null
980: from per_addresses pa
981: where ((pa.date_from < p_date_from
982: and nvl(pa.date_to, hr_api.g_eot) >=
983: (select date_from
984: from per_addresses

Line 984: from per_addresses

980: from per_addresses pa
981: where ((pa.date_from < p_date_from
982: and nvl(pa.date_to, hr_api.g_eot) >=
983: (select date_from
984: from per_addresses
985: where address_id = p_address_id)
986: and p_date_from <> (select date_from
987: from per_addresses
988: where address_id = p_address_id) )

Line 987: from per_addresses

983: (select date_from
984: from per_addresses
985: where address_id = p_address_id)
986: and p_date_from <> (select date_from
987: from per_addresses
988: where address_id = p_address_id) )
989: or (nvl(pa.date_to, hr_api.g_eot) >
990: nvl(p_date_to, hr_api.g_eot)
991: and pa.date_from <=(select nvl(date_to, hr_api.g_eot)

Line 992: from per_addresses

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

Line 996: from per_addresses

992: from per_addresses
993: where address_id = p_address_id)
994: and nvl(p_date_to, hr_api.g_eot) <>
995: (select nvl(date_to, hr_api.g_eot)
996: from per_addresses
997: where address_id = p_address_id) ))
998: and pa.primary_flag = 'N'
999: and (pa.person_id = p_person_id OR
1000: (pa.party_id = p_party_id and p_person_id is null)));-- HR/TCA merge --#3406505

Line 1007: from per_addresses pa

1003: cursor csr_check_other_addresses is
1004: select null
1005: from sys.dual
1006: where exists(select null
1007: from per_addresses pa
1008: where (pa.person_id = p_person_id OR
1009: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1010: and pa.primary_flag = 'Y'
1011: and (p_address_id is null

Line 1018: from per_addresses pa

1014: --
1015: cursor csr_chk_contig_add_before is
1016: select pa.date_from,
1017: pa.date_to
1018: from per_addresses pa
1019: where (pa.person_id = p_person_id OR
1020: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1021: and pa.primary_flag = 'Y'
1022: and pa.date_to < p_date_from

Line 1029: from per_addresses pa

1025: and p_address_id <> pa.address_id));
1026: --
1027: cursor csr_chk_contig_add_after is
1028: select pa.date_from, pa.date_to
1029: from per_addresses pa
1030: where (pa.person_id = p_person_id OR
1031: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505
1032: and pa.primary_flag = 'Y'
1033: and pa.date_from > p_date_to

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

1060: ,p_argument_value => p_primary_flag
1061: );
1062: hr_utility.set_location(l_proc, 20);
1063: if hr_multi_message.no_all_inclusive_error
1064: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1065: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1066: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1067: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1068: ) then

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

1061: );
1062: hr_utility.set_location(l_proc, 20);
1063: if hr_multi_message.no_all_inclusive_error
1064: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1065: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1066: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1067: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1068: ) then
1069: --

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

1062: hr_utility.set_location(l_proc, 20);
1063: if hr_multi_message.no_all_inclusive_error
1064: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1065: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1066: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1067: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1068: ) then
1069: --
1070: -- Set the DATE_TO to entered value or the end of time

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

1063: if hr_multi_message.no_all_inclusive_error
1064: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1065: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1066: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1067: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'
1068: ) then
1069: --
1070: -- Set the DATE_TO to entered value or the end of time
1071: --

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

1107: if csr_dup_add_type_exists%found then
1108: close csr_dup_add_type_exists;
1109: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1115: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'

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

1108: close csr_dup_add_type_exists;
1109: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1115: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1116: );

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

1109: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1115: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1116: );
1117: else

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

1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1115: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1116: );
1117: else
1118: --

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

1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1115: ,p_associated_column5 => 'PER_ADDRESSES.ADDRESS_TYPE'
1116: );
1117: else
1118: --
1119: close csr_dup_add_type_exists;

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

1143: if csr_dup_prim_flag%found then
1144: close csr_dup_prim_flag;
1145: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1146: hr_multi_message.add
1147: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1148: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1149: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1150: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1151: );

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

1144: close csr_dup_prim_flag;
1145: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1146: hr_multi_message.add
1147: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1148: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1149: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1150: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1151: );
1152: else

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

1145: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1146: hr_multi_message.add
1147: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1148: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1149: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1150: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1151: );
1152: else
1153: --

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

1146: hr_multi_message.add
1147: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1148: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1149: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1150: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1151: );
1152: else
1153: --
1154: close csr_dup_prim_flag;

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

1209: or
1210: (l_good_recs < 1)) then
1211: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1212: hr_multi_message.add
1213: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1214: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1215: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1216: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1217: );

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

1210: (l_good_recs < 1)) then
1211: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1212: hr_multi_message.add
1213: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1214: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1215: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1216: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1217: );
1218: end if;

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

1211: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1212: hr_multi_message.add
1213: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1214: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1215: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1216: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1217: );
1218: end if;
1219: end if;

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

1212: hr_multi_message.add
1213: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1214: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1215: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1216: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1217: );
1218: end if;
1219: end if;
1220: --

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

1236: if csr_invalid_non_prim%found then
1237: close csr_invalid_non_prim;
1238: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1241: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1242: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1243: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1244: );

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

1237: close csr_invalid_non_prim;
1238: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1241: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1242: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1243: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1244: );
1245: else

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

1238: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1241: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1242: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1243: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1244: );
1245: else
1246: --

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

1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1241: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1242: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1243: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1244: );
1245: else
1246: --
1247: close csr_invalid_non_prim;

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

1265: if csr_no_primary%notfound then
1266: close csr_no_primary;
1267: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1268: hr_multi_message.add
1269: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1270: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1271: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1272: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1273: );

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

1266: close csr_no_primary;
1267: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1268: hr_multi_message.add
1269: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1270: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1271: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1272: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1273: );
1274: else

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

1267: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1268: hr_multi_message.add
1269: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1270: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1271: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1272: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1273: );
1274: else
1275: --

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

1268: hr_multi_message.add
1269: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1270: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1271: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1272: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'
1273: );
1274: else
1275: --
1276: close csr_no_primary;

Line 1296: from per_addresses

1292: if p_date_from > l_action_eff_date
1293: then
1294: select count(*)
1295: into l_address_count
1296: from per_addresses
1297: where person_id = p_person_id
1298: and address_id <> p_address_id
1299: and l_action_eff_date between date_from
1300: and nvl(date_to,l_action_eff_date);

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

1391: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1392: exception
1393: when app_exception.application_exception then
1394: if hr_multi_message.exception_add
1395: (p_associated_column1 => 'PER_ADDRESSES.STYLE'
1396: ) then
1397: hr_utility.set_location(' Leaving:'||l_proc,5);
1398: raise;
1399: end if;

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

1458: --
1459: if p_style = 'GB' then
1460: if p_region_2 is not null then
1461: if hr_multi_message.no_exclusive_error
1462: (p_check_column1 => 'PER_ADDRESSES.REGION_2') then
1463: --
1464: l_token := 'region_2';
1465: raise l_error;
1466: --

Line 1574: (p_address_id in per_addresses.address_id%TYPE

1570: --
1571: -- {End Of Comments}
1572: -- ----------------------------------------------------------------------------
1573: procedure chk_address_line1
1574: (p_address_id in per_addresses.address_id%TYPE
1575: ,p_style in per_addresses.style%TYPE
1576: ,p_address_line1 in per_addresses.region_2%TYPE
1577: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1578: is

Line 1575: ,p_style in per_addresses.style%TYPE

1571: -- {End Of Comments}
1572: -- ----------------------------------------------------------------------------
1573: procedure chk_address_line1
1574: (p_address_id in per_addresses.address_id%TYPE
1575: ,p_style in per_addresses.style%TYPE
1576: ,p_address_line1 in per_addresses.region_2%TYPE
1577: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1578: is
1579: --

Line 1576: ,p_address_line1 in per_addresses.region_2%TYPE

1572: -- ----------------------------------------------------------------------------
1573: procedure chk_address_line1
1574: (p_address_id in per_addresses.address_id%TYPE
1575: ,p_style in per_addresses.style%TYPE
1576: ,p_address_line1 in per_addresses.region_2%TYPE
1577: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1578: is
1579: --
1580: l_exists varchar2(1);

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

1573: procedure chk_address_line1
1574: (p_address_id in per_addresses.address_id%TYPE
1575: ,p_style in per_addresses.style%TYPE
1576: ,p_address_line1 in per_addresses.region_2%TYPE
1577: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1578: is
1579: --
1580: l_exists varchar2(1);
1581: l_proc varchar2(72) := g_package||'chk_address_line1';

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

1627: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1628: exception
1629: when app_exception.application_exception then
1630: if hr_multi_message.exception_add
1631: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_LINE1'
1632: ) then
1633: hr_utility.set_location(' Leaving:'||l_proc,6);
1634: raise;
1635: end if;

Line 1646: p_address_id in per_addresses.address_id%TYPE,

1642: -- ----------------------------------------------------------------------------
1643: /* Bug 1677965
1644: procedure chk_address1_towncity_comb(
1645: p_business_group_id in number,
1646: p_address_id in per_addresses.address_id%TYPE,
1647: p_object_version_number in per_addresses.object_version_number%TYPE,
1648: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1649: p_address_line1 in out nocopy per_addresses.address_line1%type,
1650: p_region_1 in out nocopy per_addresses.region_1%type) is

Line 1647: p_object_version_number in per_addresses.object_version_number%TYPE,

1643: /* Bug 1677965
1644: procedure chk_address1_towncity_comb(
1645: p_business_group_id in number,
1646: p_address_id in per_addresses.address_id%TYPE,
1647: p_object_version_number in per_addresses.object_version_number%TYPE,
1648: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1649: p_address_line1 in out nocopy per_addresses.address_line1%type,
1650: p_region_1 in out nocopy per_addresses.region_1%type) is
1651:

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

1644: procedure chk_address1_towncity_comb(
1645: p_business_group_id in number,
1646: p_address_id in per_addresses.address_id%TYPE,
1647: p_object_version_number in per_addresses.object_version_number%TYPE,
1648: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1649: p_address_line1 in out nocopy per_addresses.address_line1%type,
1650: p_region_1 in out nocopy per_addresses.region_1%type) is
1651:
1652: -- p_town_or_city ===> district_code

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

1645: p_business_group_id in number,
1646: p_address_id in per_addresses.address_id%TYPE,
1647: p_object_version_number in per_addresses.object_version_number%TYPE,
1648: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1649: p_address_line1 in out nocopy per_addresses.address_line1%type,
1650: p_region_1 in out nocopy per_addresses.region_1%type) is
1651:
1652: -- p_town_or_city ===> district_code
1653: -- p_address_line1 ===> address_line1

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

1646: p_address_id in per_addresses.address_id%TYPE,
1647: p_object_version_number in per_addresses.object_version_number%TYPE,
1648: p_town_or_city in out nocopy per_addresses.town_or_city%type,
1649: p_address_line1 in out nocopy per_addresses.address_line1%type,
1650: p_region_1 in out nocopy per_addresses.region_1%type) is
1651:
1652: -- p_town_or_city ===> district_code
1653: -- p_address_line1 ===> address_line1
1654: -- p_region_1 ===> address_line1_kana

Line 1657: l_town_or_city per_addresses.town_or_city%type;

1653: -- p_address_line1 ===> address_line1
1654: -- p_region_1 ===> address_line1_kana
1655:
1656: l_legislation_code per_business_groups.legislation_code%TYPE;
1657: l_town_or_city per_addresses.town_or_city%type;
1658: l_address_line1 per_addresses.address_line1%type;
1659: l_region_1 per_addresses.region_1%type;
1660: l_sql_cursor integer; -- Dynamic sql cursor
1661: l_dynamic_sql varchar2(2000); -- Dynamic sql text

Line 1658: l_address_line1 per_addresses.address_line1%type;

1654: -- p_region_1 ===> address_line1_kana
1655:
1656: l_legislation_code per_business_groups.legislation_code%TYPE;
1657: l_town_or_city per_addresses.town_or_city%type;
1658: l_address_line1 per_addresses.address_line1%type;
1659: l_region_1 per_addresses.region_1%type;
1660: l_sql_cursor integer; -- Dynamic sql cursor
1661: l_dynamic_sql varchar2(2000); -- Dynamic sql text
1662: l_rows integer; -- No of rows returned

Line 1659: l_region_1 per_addresses.region_1%type;

1655:
1656: l_legislation_code per_business_groups.legislation_code%TYPE;
1657: l_town_or_city per_addresses.town_or_city%type;
1658: l_address_line1 per_addresses.address_line1%type;
1659: l_region_1 per_addresses.region_1%type;
1660: l_sql_cursor integer; -- Dynamic sql cursor
1661: l_dynamic_sql varchar2(2000); -- Dynamic sql text
1662: l_rows integer; -- No of rows returned
1663:

Line 1847: p_address_id in per_addresses.address_id%TYPE,

1843: -- ----------------------------------------------------------------------------
1844: --
1845: /* Bug 1677965
1846: procedure chk_address2_region2_comb(
1847: p_address_id in per_addresses.address_id%TYPE,
1848: p_object_version_number in per_addresses.object_version_number%TYPE,
1849: p_address_line2 in per_addresses.address_line2%type,
1850: p_region_2 in per_addresses.region_2%type) is
1851:

Line 1848: p_object_version_number in per_addresses.object_version_number%TYPE,

1844: --
1845: /* Bug 1677965
1846: procedure chk_address2_region2_comb(
1847: p_address_id in per_addresses.address_id%TYPE,
1848: p_object_version_number in per_addresses.object_version_number%TYPE,
1849: p_address_line2 in per_addresses.address_line2%type,
1850: p_region_2 in per_addresses.region_2%type) is
1851:
1852: -- p_address_line2 ===> address_line2

Line 1849: p_address_line2 in per_addresses.address_line2%type,

1845: /* Bug 1677965
1846: procedure chk_address2_region2_comb(
1847: p_address_id in per_addresses.address_id%TYPE,
1848: p_object_version_number in per_addresses.object_version_number%TYPE,
1849: p_address_line2 in per_addresses.address_line2%type,
1850: p_region_2 in per_addresses.region_2%type) is
1851:
1852: -- p_address_line2 ===> address_line2
1853: -- p_region_2 ===> address_line2_kana

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

1846: procedure chk_address2_region2_comb(
1847: p_address_id in per_addresses.address_id%TYPE,
1848: p_object_version_number in per_addresses.object_version_number%TYPE,
1849: p_address_line2 in per_addresses.address_line2%type,
1850: p_region_2 in per_addresses.region_2%type) is
1851:
1852: -- p_address_line2 ===> address_line2
1853: -- p_region_2 ===> address_line2_kana
1854:

Line 1860: l_region_2 per_addresses.region_2%type;

1856: l_proc varchar2(72) := g_package||'chk_address2_region2_comb';
1857: --
1858: l_output varchar2(150);
1859: l_rgeflg varchar2(10);
1860: l_region_2 per_addresses.region_2%type;
1861: --
1862: begin
1863: hr_utility.set_location('Entering:'|| l_proc, 1);
1864:

Line 1908: p_address_id in per_addresses.address_id%TYPE,

1904: -- ----------------------------------------------------------------------------
1905: --
1906: /* Bug 1677965
1907: procedure chk_address3_region3_comb(
1908: p_address_id in per_addresses.address_id%TYPE,
1909: p_object_version_number in per_addresses.object_version_number%TYPE,
1910: p_address_line3 in per_addresses.address_line3%type,
1911: p_region_3 in per_addresses.region_3%type) is
1912:

Line 1909: p_object_version_number in per_addresses.object_version_number%TYPE,

1905: --
1906: /* Bug 1677965
1907: procedure chk_address3_region3_comb(
1908: p_address_id in per_addresses.address_id%TYPE,
1909: p_object_version_number in per_addresses.object_version_number%TYPE,
1910: p_address_line3 in per_addresses.address_line3%type,
1911: p_region_3 in per_addresses.region_3%type) is
1912:
1913: -- p_address_line3 ===> address_line3

Line 1910: p_address_line3 in per_addresses.address_line3%type,

1906: /* Bug 1677965
1907: procedure chk_address3_region3_comb(
1908: p_address_id in per_addresses.address_id%TYPE,
1909: p_object_version_number in per_addresses.object_version_number%TYPE,
1910: p_address_line3 in per_addresses.address_line3%type,
1911: p_region_3 in per_addresses.region_3%type) is
1912:
1913: -- p_address_line3 ===> address_line3
1914: -- p_region_3 ===> address_line3_kana

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

1907: procedure chk_address3_region3_comb(
1908: p_address_id in per_addresses.address_id%TYPE,
1909: p_object_version_number in per_addresses.object_version_number%TYPE,
1910: p_address_line3 in per_addresses.address_line3%type,
1911: p_region_3 in per_addresses.region_3%type) is
1912:
1913: -- p_address_line3 ===> address_line3
1914: -- p_region_3 ===> address_line3_kana
1915:

Line 1921: l_region_3 per_addresses.region_3%type;

1917: l_proc varchar2(72) := g_package||'chk_address3_region3_comb';
1918: --
1919: l_output varchar2(150);
1920: l_rgeflg varchar2(10);
1921: l_region_3 per_addresses.region_3%type;
1922: --
1923: begin
1924: hr_utility.set_location('Entering:'|| l_proc, 1);
1925:

Line 2059: (p_address_id in per_addresses.address_id%TYPE

2055: --
2056: -- {End Of Comments}
2057: -- ----------------------------------------------------------------------------
2058: procedure chk_postal_code
2059: (p_address_id in per_addresses.address_id%TYPE
2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2060: ,p_style in per_addresses.style%TYPE

2056: -- {End Of Comments}
2057: -- ----------------------------------------------------------------------------
2058: procedure chk_postal_code
2059: (p_address_id in per_addresses.address_id%TYPE
2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE
2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)

Line 2061: ,p_postal_code in per_addresses.postal_code%TYPE

2057: -- ----------------------------------------------------------------------------
2058: procedure chk_postal_code
2059: (p_address_id in per_addresses.address_id%TYPE
2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE
2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2065: is

Line 2062: ,p_business_group_id in per_addresses.business_group_id%TYPE

2058: procedure chk_postal_code
2059: (p_address_id in per_addresses.address_id%TYPE
2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE
2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2065: is
2066: -- Cursor Defination added for bug 5367066

Line 2063: ,p_object_version_number in per_addresses.object_version_number%TYPE

2059: (p_address_id in per_addresses.address_id%TYPE
2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE
2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2065: is
2066: -- Cursor Defination added for bug 5367066
2067: cursor get_city_address is

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

2060: ,p_style in per_addresses.style%TYPE
2061: ,p_postal_code in per_addresses.postal_code%TYPE
2062: ,p_business_group_id in per_addresses.business_group_id%TYPE
2063: ,p_object_version_number in per_addresses.object_version_number%TYPE
2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2065: is
2066: -- Cursor Defination added for bug 5367066
2067: cursor get_city_address is
2068: select /*+index(Z PAY_US_ZIP_CODES_N1)

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

2341: hr_utility.set_location(' Leaving:'|| l_proc, 9);
2342: exception
2343: when app_exception.application_exception then
2344: if hr_multi_message.exception_add
2345: (p_associated_column1 => 'PER_ADDRESSES.POSTAL_CODE'
2346: ) then
2347: hr_utility.set_location(' Leaving:'||l_proc,10);
2348: raise;
2349: end if;

Line 2391: (p_address_id in per_addresses.address_id%TYPE

2387: --
2388: -- {End Of Comments}
2389: -- ----------------------------------------------------------------------------
2390: procedure chk_tax_address_zip
2391: (p_address_id in per_addresses.address_id%TYPE
2392: ,p_style in per_addresses.style%TYPE
2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2394: ,p_business_group_id in per_addresses.business_group_id%TYPE
2395: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 2392: ,p_style in per_addresses.style%TYPE

2388: -- {End Of Comments}
2389: -- ----------------------------------------------------------------------------
2390: procedure chk_tax_address_zip
2391: (p_address_id in per_addresses.address_id%TYPE
2392: ,p_style in per_addresses.style%TYPE
2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2394: ,p_business_group_id in per_addresses.business_group_id%TYPE
2395: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2396: is

Line 2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE

2389: -- ----------------------------------------------------------------------------
2390: procedure chk_tax_address_zip
2391: (p_address_id in per_addresses.address_id%TYPE
2392: ,p_style in per_addresses.style%TYPE
2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2394: ,p_business_group_id in per_addresses.business_group_id%TYPE
2395: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2396: is
2397: --

Line 2394: ,p_business_group_id in per_addresses.business_group_id%TYPE

2390: procedure chk_tax_address_zip
2391: (p_address_id in per_addresses.address_id%TYPE
2392: ,p_style in per_addresses.style%TYPE
2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2394: ,p_business_group_id in per_addresses.business_group_id%TYPE
2395: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2396: is
2397: --
2398: l_proc varchar2(72) := g_package||'chk_tax_address_zip';

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

2391: (p_address_id in per_addresses.address_id%TYPE
2392: ,p_style in per_addresses.style%TYPE
2393: ,p_tax_address_zip in per_addresses.add_information20%TYPE
2394: ,p_business_group_id in per_addresses.business_group_id%TYPE
2395: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2396: is
2397: --
2398: l_proc varchar2(72) := g_package||'chk_tax_address_zip';
2399: l_api_updating boolean;

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

2514: hr_utility.set_location(' Leaving:'|| l_proc, 7);
2515: exception
2516: when app_exception.application_exception then
2517: if hr_multi_message.exception_add
2518: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
2519: ) then
2520: hr_utility.set_location(' Leaving:'||l_proc,6);
2521: raise;
2522: end if;

Line 2567: (p_address_id in per_addresses.address_id%TYPE

2563: --
2564: -- {End Of Comments}
2565: -- ----------------------------------------------------------------------------
2566: procedure chk_region_1
2567: (p_address_id in per_addresses.address_id%TYPE
2568: ,p_style in per_addresses.style%TYPE
2569: ,p_region_1 in per_addresses.region_1%TYPE
2570: ,p_business_group_id in per_addresses.business_group_id%TYPE
2571: ,p_effective_date in date

Line 2568: ,p_style in per_addresses.style%TYPE

2564: -- {End Of Comments}
2565: -- ----------------------------------------------------------------------------
2566: procedure chk_region_1
2567: (p_address_id in per_addresses.address_id%TYPE
2568: ,p_style in per_addresses.style%TYPE
2569: ,p_region_1 in per_addresses.region_1%TYPE
2570: ,p_business_group_id in per_addresses.business_group_id%TYPE
2571: ,p_effective_date in date
2572: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2569: ,p_region_1 in per_addresses.region_1%TYPE

2565: -- ----------------------------------------------------------------------------
2566: procedure chk_region_1
2567: (p_address_id in per_addresses.address_id%TYPE
2568: ,p_style in per_addresses.style%TYPE
2569: ,p_region_1 in per_addresses.region_1%TYPE
2570: ,p_business_group_id in per_addresses.business_group_id%TYPE
2571: ,p_effective_date in date
2572: ,p_object_version_number in per_addresses.object_version_number%TYPE
2573: ,p_validate_county in boolean default TRUE)

Line 2570: ,p_business_group_id in per_addresses.business_group_id%TYPE

2566: procedure chk_region_1
2567: (p_address_id in per_addresses.address_id%TYPE
2568: ,p_style in per_addresses.style%TYPE
2569: ,p_region_1 in per_addresses.region_1%TYPE
2570: ,p_business_group_id in per_addresses.business_group_id%TYPE
2571: ,p_effective_date in date
2572: ,p_object_version_number in per_addresses.object_version_number%TYPE
2573: ,p_validate_county in boolean default TRUE)
2574: is

Line 2572: ,p_object_version_number in per_addresses.object_version_number%TYPE

2568: ,p_style in per_addresses.style%TYPE
2569: ,p_region_1 in per_addresses.region_1%TYPE
2570: ,p_business_group_id in per_addresses.business_group_id%TYPE
2571: ,p_effective_date in date
2572: ,p_object_version_number in per_addresses.object_version_number%TYPE
2573: ,p_validate_county in boolean default TRUE)
2574: is
2575: --
2576: l_exists varchar2(1);

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

2671: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2672: exception
2673: when app_exception.application_exception then
2674: if hr_multi_message.exception_add
2675: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
2676: ) then
2677: hr_utility.set_location(' Leaving:'||l_proc,7);
2678: raise;
2679: end if;

Line 2720: (p_address_id in per_addresses.address_id%TYPE

2716: --
2717: -- {End Of Comments}
2718: -- ----------------------------------------------------------------------------
2719: procedure chk_tax_county
2720: (p_address_id in per_addresses.address_id%TYPE
2721: ,p_style in per_addresses.style%TYPE
2722: ,p_tax_county in per_addresses.add_information19%TYPE
2723: ,p_business_group_id in per_addresses.business_group_id%TYPE
2724: ,p_effective_date in date

Line 2721: ,p_style in per_addresses.style%TYPE

2717: -- {End Of Comments}
2718: -- ----------------------------------------------------------------------------
2719: procedure chk_tax_county
2720: (p_address_id in per_addresses.address_id%TYPE
2721: ,p_style in per_addresses.style%TYPE
2722: ,p_tax_county in per_addresses.add_information19%TYPE
2723: ,p_business_group_id in per_addresses.business_group_id%TYPE
2724: ,p_effective_date in date
2725: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 2722: ,p_tax_county in per_addresses.add_information19%TYPE

2718: -- ----------------------------------------------------------------------------
2719: procedure chk_tax_county
2720: (p_address_id in per_addresses.address_id%TYPE
2721: ,p_style in per_addresses.style%TYPE
2722: ,p_tax_county in per_addresses.add_information19%TYPE
2723: ,p_business_group_id in per_addresses.business_group_id%TYPE
2724: ,p_effective_date in date
2725: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2726: is

Line 2723: ,p_business_group_id in per_addresses.business_group_id%TYPE

2719: procedure chk_tax_county
2720: (p_address_id in per_addresses.address_id%TYPE
2721: ,p_style in per_addresses.style%TYPE
2722: ,p_tax_county in per_addresses.add_information19%TYPE
2723: ,p_business_group_id in per_addresses.business_group_id%TYPE
2724: ,p_effective_date in date
2725: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2726: is
2727: --

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

2721: ,p_style in per_addresses.style%TYPE
2722: ,p_tax_county in per_addresses.add_information19%TYPE
2723: ,p_business_group_id in per_addresses.business_group_id%TYPE
2724: ,p_effective_date in date
2725: ,p_object_version_number in per_addresses.object_version_number%TYPE)
2726: is
2727: --
2728: l_exists varchar2(1);
2729: l_proc varchar2(72) := g_package||'chk_tax_county';

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

2793: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2794: exception
2795: when app_exception.application_exception then
2796: if hr_multi_message.exception_add
2797: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION19'
2798: ) then
2799: hr_utility.set_location(' Leaving:'||l_proc,7);
2800: raise;
2801: end if;

Line 2842: (p_address_id in per_addresses.address_id%TYPE

2838: --
2839: -- {End Of Comments}
2840: -- ----------------------------------------------------------------------------
2841: procedure chk_region_2
2842: (p_address_id in per_addresses.address_id%TYPE
2843: ,p_style in per_addresses.style%TYPE
2844: ,p_region_2 in per_addresses.region_2%TYPE
2845: ,p_business_group_id in per_addresses.business_group_id%TYPE
2846: ,p_effective_date in date

Line 2843: ,p_style in per_addresses.style%TYPE

2839: -- {End Of Comments}
2840: -- ----------------------------------------------------------------------------
2841: procedure chk_region_2
2842: (p_address_id in per_addresses.address_id%TYPE
2843: ,p_style in per_addresses.style%TYPE
2844: ,p_region_2 in per_addresses.region_2%TYPE
2845: ,p_business_group_id in per_addresses.business_group_id%TYPE
2846: ,p_effective_date in date
2847: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 2844: ,p_region_2 in per_addresses.region_2%TYPE

2840: -- ----------------------------------------------------------------------------
2841: procedure chk_region_2
2842: (p_address_id in per_addresses.address_id%TYPE
2843: ,p_style in per_addresses.style%TYPE
2844: ,p_region_2 in per_addresses.region_2%TYPE
2845: ,p_business_group_id in per_addresses.business_group_id%TYPE
2846: ,p_effective_date in date
2847: ,p_object_version_number in per_addresses.object_version_number%TYPE
2848: )

Line 2845: ,p_business_group_id in per_addresses.business_group_id%TYPE

2841: procedure chk_region_2
2842: (p_address_id in per_addresses.address_id%TYPE
2843: ,p_style in per_addresses.style%TYPE
2844: ,p_region_2 in per_addresses.region_2%TYPE
2845: ,p_business_group_id in per_addresses.business_group_id%TYPE
2846: ,p_effective_date in date
2847: ,p_object_version_number in per_addresses.object_version_number%TYPE
2848: )
2849: is

Line 2847: ,p_object_version_number in per_addresses.object_version_number%TYPE

2843: ,p_style in per_addresses.style%TYPE
2844: ,p_region_2 in per_addresses.region_2%TYPE
2845: ,p_business_group_id in per_addresses.business_group_id%TYPE
2846: ,p_effective_date in date
2847: ,p_object_version_number in per_addresses.object_version_number%TYPE
2848: )
2849: is
2850: --
2851: l_exists varchar2(1);

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

2953: hr_utility.set_location(' Leaving:'|| l_proc, 10);
2954: exception
2955: when app_exception.application_exception then
2956: if hr_multi_message.exception_add
2957: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
2958: ) then
2959: hr_utility.set_location(' Leaving:'||l_proc,11);
2960: raise;
2961: end if;

Line 3002: (p_address_id in per_addresses.address_id%TYPE

2998: --
2999: -- {End Of Comments}
3000: -- ----------------------------------------------------------------------------
3001: procedure chk_tax_state
3002: (p_address_id in per_addresses.address_id%TYPE
3003: ,p_style in per_addresses.style%TYPE
3004: ,p_tax_state in per_addresses.add_information17%TYPE
3005: ,p_business_group_id in per_addresses.business_group_id%TYPE
3006: ,p_effective_date in date

Line 3003: ,p_style in per_addresses.style%TYPE

2999: -- {End Of Comments}
3000: -- ----------------------------------------------------------------------------
3001: procedure chk_tax_state
3002: (p_address_id in per_addresses.address_id%TYPE
3003: ,p_style in per_addresses.style%TYPE
3004: ,p_tax_state in per_addresses.add_information17%TYPE
3005: ,p_business_group_id in per_addresses.business_group_id%TYPE
3006: ,p_effective_date in date
3007: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3004: ,p_tax_state in per_addresses.add_information17%TYPE

3000: -- ----------------------------------------------------------------------------
3001: procedure chk_tax_state
3002: (p_address_id in per_addresses.address_id%TYPE
3003: ,p_style in per_addresses.style%TYPE
3004: ,p_tax_state in per_addresses.add_information17%TYPE
3005: ,p_business_group_id in per_addresses.business_group_id%TYPE
3006: ,p_effective_date in date
3007: ,p_object_version_number in per_addresses.object_version_number%TYPE
3008: )

Line 3005: ,p_business_group_id in per_addresses.business_group_id%TYPE

3001: procedure chk_tax_state
3002: (p_address_id in per_addresses.address_id%TYPE
3003: ,p_style in per_addresses.style%TYPE
3004: ,p_tax_state in per_addresses.add_information17%TYPE
3005: ,p_business_group_id in per_addresses.business_group_id%TYPE
3006: ,p_effective_date in date
3007: ,p_object_version_number in per_addresses.object_version_number%TYPE
3008: )
3009: is

Line 3007: ,p_object_version_number in per_addresses.object_version_number%TYPE

3003: ,p_style in per_addresses.style%TYPE
3004: ,p_tax_state in per_addresses.add_information17%TYPE
3005: ,p_business_group_id in per_addresses.business_group_id%TYPE
3006: ,p_effective_date in date
3007: ,p_object_version_number in per_addresses.object_version_number%TYPE
3008: )
3009: is
3010: --
3011: l_exists varchar2(1);

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

3097: hr_utility.set_location(' Leaving:'|| l_proc, 10);
3098: exception
3099: when app_exception.application_exception then
3100: if hr_multi_message.exception_add
3101: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3102: ) then
3103: hr_utility.set_location(' Leaving:'||l_proc,11);
3104: raise;
3105: end if;

Line 3144: (p_address_id in per_addresses.address_id%TYPE

3140: --
3141: -- {End Of Comments}
3142: -- ----------------------------------------------------------------------------
3143: procedure chk_town_or_city
3144: (p_address_id in per_addresses.address_id%TYPE
3145: ,p_style in per_addresses.style%TYPE
3146: ,p_town_or_city in per_addresses.town_or_city%TYPE
3147: ,p_business_group_id in per_addresses.business_group_id%TYPE
3148: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 3145: ,p_style in per_addresses.style%TYPE

3141: -- {End Of Comments}
3142: -- ----------------------------------------------------------------------------
3143: procedure chk_town_or_city
3144: (p_address_id in per_addresses.address_id%TYPE
3145: ,p_style in per_addresses.style%TYPE
3146: ,p_town_or_city in per_addresses.town_or_city%TYPE
3147: ,p_business_group_id in per_addresses.business_group_id%TYPE
3148: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3149: is

Line 3146: ,p_town_or_city in per_addresses.town_or_city%TYPE

3142: -- ----------------------------------------------------------------------------
3143: procedure chk_town_or_city
3144: (p_address_id in per_addresses.address_id%TYPE
3145: ,p_style in per_addresses.style%TYPE
3146: ,p_town_or_city in per_addresses.town_or_city%TYPE
3147: ,p_business_group_id in per_addresses.business_group_id%TYPE
3148: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3149: is
3150: --

Line 3147: ,p_business_group_id in per_addresses.business_group_id%TYPE

3143: procedure chk_town_or_city
3144: (p_address_id in per_addresses.address_id%TYPE
3145: ,p_style in per_addresses.style%TYPE
3146: ,p_town_or_city in per_addresses.town_or_city%TYPE
3147: ,p_business_group_id in per_addresses.business_group_id%TYPE
3148: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3149: is
3150: --
3151: l_exists varchar2(1);

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

3144: (p_address_id in per_addresses.address_id%TYPE
3145: ,p_style in per_addresses.style%TYPE
3146: ,p_town_or_city in per_addresses.town_or_city%TYPE
3147: ,p_business_group_id in per_addresses.business_group_id%TYPE
3148: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3149: is
3150: --
3151: l_exists varchar2(1);
3152: l_proc varchar2(72) := g_package||'chk_town_or_city';

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

3212: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3213: exception
3214: when app_exception.application_exception then
3215: if hr_multi_message.exception_add
3216: (p_associated_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3217: ) then
3218: hr_utility.set_location(' Leaving:'||l_proc,6);
3219: raise;
3220: end if;

Line 3259: (p_address_id in per_addresses.address_id%TYPE

3255: --
3256: -- {End Of Comments}
3257: -- ----------------------------------------------------------------------------
3258: procedure chk_tax_city
3259: (p_address_id in per_addresses.address_id%TYPE
3260: ,p_style in per_addresses.style%TYPE
3261: ,p_tax_city in per_addresses.add_information18%TYPE
3262: ,p_business_group_id in per_addresses.business_group_id%TYPE
3263: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 3260: ,p_style in per_addresses.style%TYPE

3256: -- {End Of Comments}
3257: -- ----------------------------------------------------------------------------
3258: procedure chk_tax_city
3259: (p_address_id in per_addresses.address_id%TYPE
3260: ,p_style in per_addresses.style%TYPE
3261: ,p_tax_city in per_addresses.add_information18%TYPE
3262: ,p_business_group_id in per_addresses.business_group_id%TYPE
3263: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3264: is

Line 3261: ,p_tax_city in per_addresses.add_information18%TYPE

3257: -- ----------------------------------------------------------------------------
3258: procedure chk_tax_city
3259: (p_address_id in per_addresses.address_id%TYPE
3260: ,p_style in per_addresses.style%TYPE
3261: ,p_tax_city in per_addresses.add_information18%TYPE
3262: ,p_business_group_id in per_addresses.business_group_id%TYPE
3263: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3264: is
3265: --

Line 3262: ,p_business_group_id in per_addresses.business_group_id%TYPE

3258: procedure chk_tax_city
3259: (p_address_id in per_addresses.address_id%TYPE
3260: ,p_style in per_addresses.style%TYPE
3261: ,p_tax_city in per_addresses.add_information18%TYPE
3262: ,p_business_group_id in per_addresses.business_group_id%TYPE
3263: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3264: is
3265: --
3266: l_exists varchar2(1);

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

3259: (p_address_id in per_addresses.address_id%TYPE
3260: ,p_style in per_addresses.style%TYPE
3261: ,p_tax_city in per_addresses.add_information18%TYPE
3262: ,p_business_group_id in per_addresses.business_group_id%TYPE
3263: ,p_object_version_number in per_addresses.object_version_number%TYPE)
3264: is
3265: --
3266: l_exists varchar2(1);
3267: l_proc varchar2(72) := g_package||'chk_tax_city';

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

3320: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3321: exception
3322: when app_exception.application_exception then
3323: if hr_multi_message.exception_add
3324: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3325: ) then
3326: hr_utility.set_location(' Leaving:'||l_proc,6);
3327: raise;
3328: end if;

Line 3372: (p_address_id in per_addresses.address_id%TYPE

3368: --
3369: -- {End Of Comments}
3370: -- ----------------------------------------------------------------------------
3371: procedure chk_city_state_zip_comb
3372: (p_address_id in per_addresses.address_id%TYPE
3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE

Line 3373: ,p_style in per_addresses.style%TYPE

3369: -- {End Of Comments}
3370: -- ----------------------------------------------------------------------------
3371: procedure chk_city_state_zip_comb
3372: (p_address_id in per_addresses.address_id%TYPE
3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE

Line 3374: ,p_postal_code in per_addresses.postal_code%TYPE

3370: -- ----------------------------------------------------------------------------
3371: procedure chk_city_state_zip_comb
3372: (p_address_id in per_addresses.address_id%TYPE
3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE

Line 3375: ,p_region_1 in per_addresses.region_1%TYPE

3371: procedure chk_city_state_zip_comb
3372: (p_address_id in per_addresses.address_id%TYPE
3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE
3379: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3376: ,p_region_2 in per_addresses.region_2%TYPE

3372: (p_address_id in per_addresses.address_id%TYPE
3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE
3379: ,p_object_version_number in per_addresses.object_version_number%TYPE
3380: )

Line 3377: ,p_town_or_city in per_addresses.town_or_city%TYPE

3373: ,p_style in per_addresses.style%TYPE
3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE
3379: ,p_object_version_number in per_addresses.object_version_number%TYPE
3380: )
3381: is

Line 3378: ,p_business_group_id in per_addresses.business_group_id%TYPE

3374: ,p_postal_code in per_addresses.postal_code%TYPE
3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE
3379: ,p_object_version_number in per_addresses.object_version_number%TYPE
3380: )
3381: is
3382: --

Line 3379: ,p_object_version_number in per_addresses.object_version_number%TYPE

3375: ,p_region_1 in per_addresses.region_1%TYPE
3376: ,p_region_2 in per_addresses.region_2%TYPE
3377: ,p_town_or_city in per_addresses.town_or_city%TYPE
3378: ,p_business_group_id in per_addresses.business_group_id%TYPE
3379: ,p_object_version_number in per_addresses.object_version_number%TYPE
3380: )
3381: is
3382: --
3383: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';

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

3486: --
3487: if (p_region_1 is null) then
3488: --
3489: if hr_multi_message.no_exclusive_error
3490: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3491: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3492: ) then
3493: --
3494: hr_utility.set_location(l_proc, 40);

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

3487: if (p_region_1 is null) then
3488: --
3489: if hr_multi_message.no_exclusive_error
3490: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3491: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3492: ) then
3493: --
3494: hr_utility.set_location(l_proc, 40);
3495: --

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

3502: close csr_val_st_city;
3503: hr_utility.set_location(l_proc, 50);
3504: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3505: hr_multi_message.add
3506: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3507: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3508: );
3509: else
3510: close csr_val_st_city;

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

3503: hr_utility.set_location(l_proc, 50);
3504: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3505: hr_multi_message.add
3506: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3507: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3508: );
3509: else
3510: close csr_val_st_city;
3511: hr_utility.set_location(l_proc, 60);

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

3512: --
3513: -- check for a valid state, city, zip combination
3514: --
3515: if hr_multi_message.no_exclusive_error
3516: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3517: ) then
3518: --
3519: open csr_valid_zip_code_no_ncty;
3520: fetch csr_valid_zip_code_no_ncty into l_exists;

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

3522: close csr_valid_zip_code_no_ncty;
3523: hr_utility.set_location(l_proc, 70);
3524: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3525: hr_multi_message.add
3526: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3527: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3528: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3529: );
3530: else

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

3523: hr_utility.set_location(l_proc, 70);
3524: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3525: hr_multi_message.add
3526: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3527: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3528: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3529: );
3530: else
3531: close csr_valid_zip_code_no_ncty;

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

3524: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3525: hr_multi_message.add
3526: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3527: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3528: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3529: );
3530: else
3531: close csr_valid_zip_code_no_ncty;
3532: hr_utility.set_location(l_proc, 80);

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

3544: --
3545: -- Validate the state and county combination
3546: --
3547: if hr_multi_message.no_exclusive_error
3548: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3549: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3550: ) then
3551: --
3552: hr_utility.set_location(l_proc, 90);

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

3545: -- Validate the state and county combination
3546: --
3547: if hr_multi_message.no_exclusive_error
3548: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3549: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3550: ) then
3551: --
3552: hr_utility.set_location(l_proc, 90);
3553: open csr_valid_state_county;

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

3558: --
3559: hr_utility.set_location(l_proc, 100);
3560: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3561: hr_multi_message.add
3562: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3563: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3564: );
3565: else
3566: close csr_valid_state_county;

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

3559: hr_utility.set_location(l_proc, 100);
3560: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3561: hr_multi_message.add
3562: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3563: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3564: );
3565: else
3566: close csr_valid_state_county;
3567: hr_utility.set_location(l_proc, 110);

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

3569: --
3570: -- Validate the state, county and city combination
3571: --
3572: if hr_multi_message.no_exclusive_error
3573: (p_check_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3574: ) then
3575: open csr_val_st_county_city;
3576: fetch csr_val_st_county_city into l_city_code;
3577: --

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

3580: --
3581: hr_utility.set_location(l_proc, 120);
3582: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3583: hr_multi_message.add
3584: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3585: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3586: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3587: );
3588: else

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

3581: hr_utility.set_location(l_proc, 120);
3582: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3583: hr_multi_message.add
3584: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3585: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3586: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3587: );
3588: else
3589: close csr_val_st_county_city;

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

3582: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3583: hr_multi_message.add
3584: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3585: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3586: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3587: );
3588: else
3589: close csr_val_st_county_city;
3590: hr_utility.set_location(l_proc, 130);

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

3592: --
3593: -- Validate the state, county, city and zip code combination
3594: --
3595: if hr_multi_message.no_exclusive_error
3596: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3597: ) then
3598: --
3599: open csr_valid_zip_code;
3600: fetch csr_valid_zip_code into l_exists;

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

3603: --
3604: hr_utility.set_location(l_proc, 140);
3605: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3606: hr_multi_message.add
3607: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3608: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3609: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3610: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3611: );

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

3604: hr_utility.set_location(l_proc, 140);
3605: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3606: hr_multi_message.add
3607: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3608: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3609: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3610: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3611: );
3612: else

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

3605: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3606: hr_multi_message.add
3607: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3608: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3609: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3610: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3611: );
3612: else
3613: close csr_valid_zip_code;

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

3606: hr_multi_message.add
3607: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3608: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3609: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3610: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'
3611: );
3612: else
3613: close csr_valid_zip_code;
3614: hr_utility.set_location(l_proc, 150);

Line 3673: (p_address_id in per_addresses.address_id%TYPE

3669: --
3670: -- {End Of Comments}
3671: -- ----------------------------------------------------------------------------
3672: procedure chk_tax_city_state_zip_comb
3673: (p_address_id in per_addresses.address_id%TYPE
3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE

Line 3674: ,p_style in per_addresses.style%TYPE

3670: -- {End Of Comments}
3671: -- ----------------------------------------------------------------------------
3672: procedure chk_tax_city_state_zip_comb
3673: (p_address_id in per_addresses.address_id%TYPE
3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE

Line 3675: ,p_tax_zip in per_addresses.add_information20%TYPE

3671: -- ----------------------------------------------------------------------------
3672: procedure chk_tax_city_state_zip_comb
3673: (p_address_id in per_addresses.address_id%TYPE
3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE

Line 3676: ,p_tax_county in per_addresses.add_information19%TYPE

3672: procedure chk_tax_city_state_zip_comb
3673: (p_address_id in per_addresses.address_id%TYPE
3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE
3680: ,p_object_version_number in per_addresses.object_version_number%TYPE

Line 3677: ,p_tax_state in per_addresses.add_information17%TYPE

3673: (p_address_id in per_addresses.address_id%TYPE
3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE
3680: ,p_object_version_number in per_addresses.object_version_number%TYPE
3681: )

Line 3678: ,p_tax_city in per_addresses.add_information18%TYPE

3674: ,p_style in per_addresses.style%TYPE
3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE
3680: ,p_object_version_number in per_addresses.object_version_number%TYPE
3681: )
3682: is

Line 3679: ,p_business_group_id in per_addresses.business_group_id%TYPE

3675: ,p_tax_zip in per_addresses.add_information20%TYPE
3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE
3680: ,p_object_version_number in per_addresses.object_version_number%TYPE
3681: )
3682: is
3683: --

Line 3680: ,p_object_version_number in per_addresses.object_version_number%TYPE

3676: ,p_tax_county in per_addresses.add_information19%TYPE
3677: ,p_tax_state in per_addresses.add_information17%TYPE
3678: ,p_tax_city in per_addresses.add_information18%TYPE
3679: ,p_business_group_id in per_addresses.business_group_id%TYPE
3680: ,p_object_version_number in per_addresses.object_version_number%TYPE
3681: )
3682: is
3683: --
3684: l_proc varchar2(72) := g_package||'chk_tax_city_state_zip_comb';

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

3790: --
3791: --
3792: if (p_tax_county is null) then
3793: if hr_multi_message.no_exclusive_error
3794: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3795: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3796: ) then
3797: hr_utility.set_location(l_proc, 40);
3798: --

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

3791: --
3792: if (p_tax_county is null) then
3793: if hr_multi_message.no_exclusive_error
3794: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3795: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3796: ) then
3797: hr_utility.set_location(l_proc, 40);
3798: --
3799: -- no county is given, so procede with validation which excluses it;

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

3805: close csr_val_st_city;
3806: hr_utility.set_location(l_proc, 50);
3807: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3808: hr_multi_message.add
3809: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3810: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3811: );
3812: else
3813: close csr_val_st_city;

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

3806: hr_utility.set_location(l_proc, 50);
3807: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3808: hr_multi_message.add
3809: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3810: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3811: );
3812: else
3813: close csr_val_st_city;
3814: hr_utility.set_location(l_proc, 60);

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

3815: --
3816: -- check for a valid state, city, zip combination
3817: --
3818: if hr_multi_message.no_exclusive_error
3819: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3820: ) then
3821: open csr_valid_zip_code_no_ncty;
3822: fetch csr_valid_zip_code_no_ncty into l_exists;
3823: if csr_valid_zip_code_no_ncty%notfound then

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

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

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

3825: hr_utility.set_location(l_proc, 70);
3826: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3831: );
3832: else
3833: --

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

3826: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3831: );
3832: else
3833: --
3834: close csr_valid_zip_code_no_ncty;

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

3848: --
3849: -- Validate the state and county combination
3850: --
3851: if hr_multi_message.no_exclusive_error
3852: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3853: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3854: ) then
3855: --
3856: hr_utility.set_location(l_proc, 90);

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

3849: -- Validate the state and county combination
3850: --
3851: if hr_multi_message.no_exclusive_error
3852: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3853: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3854: ) then
3855: --
3856: hr_utility.set_location(l_proc, 90);
3857: open csr_valid_state_county;

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

3862: --
3863: hr_utility.set_location(l_proc, 100);
3864: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3865: hr_multi_message.add
3866: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3867: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3868: );
3869: --
3870: else

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

3863: hr_utility.set_location(l_proc, 100);
3864: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3865: hr_multi_message.add
3866: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3867: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3868: );
3869: --
3870: else
3871: --

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

3876: --
3877: -- Validate the state, county and city combination
3878: --
3879: if hr_multi_message.no_exclusive_error
3880: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3881: ) then
3882: open csr_val_st_county_city;
3883: fetch csr_val_st_county_city into l_city_code;
3884: --

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

3887: --
3888: hr_utility.set_location(l_proc, 120);
3889: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3890: hr_multi_message.add
3891: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3892: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3893: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3894: );
3895: --

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

3888: hr_utility.set_location(l_proc, 120);
3889: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3890: hr_multi_message.add
3891: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3892: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3893: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3894: );
3895: --
3896: else

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

3889: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3890: hr_multi_message.add
3891: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3892: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3893: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3894: );
3895: --
3896: else
3897: --

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

3902: --
3903: -- Validate the state, county, city and zip code combination
3904: --
3905: if hr_multi_message.no_exclusive_error
3906: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3907: ) then
3908: open csr_valid_zip_code;
3909: fetch csr_valid_zip_code into l_exists;
3910: if csr_valid_zip_code%notfound then

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

3912: --
3913: hr_utility.set_location(l_proc, 140);
3914: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3915: hr_multi_message.add
3916: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3917: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3918: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3919: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3920: );

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

3913: hr_utility.set_location(l_proc, 140);
3914: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3915: hr_multi_message.add
3916: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3917: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3918: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3919: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3920: );
3921: --

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

3914: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3915: hr_multi_message.add
3916: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3917: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3918: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3919: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3920: );
3921: --
3922: else

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

3915: hr_multi_message.add
3916: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3917: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3918: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3919: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'
3920: );
3921: --
3922: else
3923: --

Line 3989: from per_addresses pa

3985: l_date date;
3986: --
3987: cursor csr_del_address is
3988: select null
3989: from per_addresses pa
3990: where pa.date_from between per_add_shd.g_old_rec.date_from
3991: and l_date
3992: and pa.person_id = per_add_shd.g_old_rec.person_id
3993: and pa.primary_flag = 'N';

Line 3999: from per_addresses pa2

3995: cursor csr_no_del_contig_add is
3996: select null
3997: from sys.dual
3998: where exists(select null
3999: from per_addresses pa2
4000: where pa2.date_from > l_date
4001: and pa2.person_id = per_add_shd.g_old_rec.person_id
4002: and pa2.primary_flag = 'Y');
4003: --

Line 4200: ,p_descflex_name => 'PER_ADDRESSES'

4196: then
4197: --
4198: hr_dflex_utility.ins_or_upd_descflex_attribs
4199: (p_appl_short_name => 'PER'
4200: ,p_descflex_name => 'PER_ADDRESSES'
4201: ,p_attribute_category => p_rec.addr_attribute_category
4202: ,p_attribute1_name => 'ADDR_ATTRIBUTE1'
4203: ,p_attribute1_value => p_rec.ADDR_ATTRIBUTE1
4204: ,p_attribute2_name => 'ADDR_ATTRIBUTE2'

Line 5258: , per_addresses adr

5254: --
5255: cursor csr_leg_code is
5256: select pbg.legislation_code
5257: from per_business_groups pbg
5258: , per_addresses adr
5259: where adr.address_id = p_address_id
5260: and pbg.business_group_id = adr.business_group_id;
5261:
5262: --