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_KAD_BUS dependencies on PER_ADDRESSES

Line 44: (p_person_id in per_addresses.person_id%TYPE) is

40: --
41: -- {End Of Comments}
42: -- ----------------------------------------------------------------------------
43: procedure chk_person_id
44: (p_person_id in per_addresses.person_id%TYPE) is
45: --
46: l_exists varchar2(1);
47: l_proc varchar2(72) := g_package||'chk_person_id';
48: --

Line 114: (p_address_id in per_addresses.address_id%TYPE

110: --
111: -- {End Of Comments}
112: -- ----------------------------------------------------------------------------
113: procedure chk_address_type
114: (p_address_id in per_addresses.address_id%TYPE
115: ,p_address_type in per_addresses.address_type%TYPE
116: ,p_date_from in per_addresses.date_from%TYPE
117: ,p_effective_date in date
118: ,p_object_version_number in per_addresses.object_version_number%TYPE) is

Line 115: ,p_address_type in per_addresses.address_type%TYPE

111: -- {End Of Comments}
112: -- ----------------------------------------------------------------------------
113: procedure chk_address_type
114: (p_address_id in per_addresses.address_id%TYPE
115: ,p_address_type in per_addresses.address_type%TYPE
116: ,p_date_from in per_addresses.date_from%TYPE
117: ,p_effective_date in date
118: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
119: --

Line 116: ,p_date_from in per_addresses.date_from%TYPE

112: -- ----------------------------------------------------------------------------
113: procedure chk_address_type
114: (p_address_id in per_addresses.address_id%TYPE
115: ,p_address_type in per_addresses.address_type%TYPE
116: ,p_date_from in per_addresses.date_from%TYPE
117: ,p_effective_date in date
118: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
119: --
120: l_exists varchar2(1);

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

114: (p_address_id in per_addresses.address_id%TYPE
115: ,p_address_type in per_addresses.address_type%TYPE
116: ,p_date_from in per_addresses.date_from%TYPE
117: ,p_effective_date in date
118: ,p_object_version_number in per_addresses.object_version_number%TYPE) is
119: --
120: l_exists varchar2(1);
121: l_proc varchar2(72) := g_package||'chk_address_type';
122: l_api_updating boolean;

Line 206: (p_address_id in per_addresses.address_id%TYPE

202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: procedure chk_country
206: (p_address_id in per_addresses.address_id%TYPE
207: ,p_style in per_addresses.style%TYPE
208: ,p_country in per_addresses.country%TYPE
209: ,p_object_version_number in per_addresses.object_version_number%TYPE)
210: is

Line 207: ,p_style in per_addresses.style%TYPE

203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: procedure chk_country
206: (p_address_id in per_addresses.address_id%TYPE
207: ,p_style in per_addresses.style%TYPE
208: ,p_country in per_addresses.country%TYPE
209: ,p_object_version_number in per_addresses.object_version_number%TYPE)
210: is
211: --

Line 208: ,p_country in per_addresses.country%TYPE

204: -- ----------------------------------------------------------------------------
205: procedure chk_country
206: (p_address_id in per_addresses.address_id%TYPE
207: ,p_style in per_addresses.style%TYPE
208: ,p_country in per_addresses.country%TYPE
209: ,p_object_version_number in per_addresses.object_version_number%TYPE)
210: is
211: --
212: l_exists varchar2(1);

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

205: procedure chk_country
206: (p_address_id in per_addresses.address_id%TYPE
207: ,p_style in per_addresses.style%TYPE
208: ,p_country in per_addresses.country%TYPE
209: ,p_object_version_number in per_addresses.object_version_number%TYPE)
210: is
211: --
212: l_exists varchar2(1);
213: l_proc varchar2(72) := g_package||'chk_country';

Line 289: (p_address_id in per_addresses.address_id%TYPE

285: --
286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: procedure chk_date_to
289: (p_address_id in per_addresses.address_id%TYPE
290: ,p_date_from in per_addresses.date_from%TYPE
291: ,p_date_to in per_addresses.date_to%TYPE
292: ,p_object_version_number in per_addresses.object_version_number%TYPE)
293: is

Line 290: ,p_date_from in per_addresses.date_from%TYPE

286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: procedure chk_date_to
289: (p_address_id in per_addresses.address_id%TYPE
290: ,p_date_from in per_addresses.date_from%TYPE
291: ,p_date_to in per_addresses.date_to%TYPE
292: ,p_object_version_number in per_addresses.object_version_number%TYPE)
293: is
294: --

Line 291: ,p_date_to in per_addresses.date_to%TYPE

287: -- ----------------------------------------------------------------------------
288: procedure chk_date_to
289: (p_address_id in per_addresses.address_id%TYPE
290: ,p_date_from in per_addresses.date_from%TYPE
291: ,p_date_to in per_addresses.date_to%TYPE
292: ,p_object_version_number in per_addresses.object_version_number%TYPE)
293: is
294: --
295: l_exists varchar2(1);

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

288: procedure chk_date_to
289: (p_address_id in per_addresses.address_id%TYPE
290: ,p_date_from in per_addresses.date_from%TYPE
291: ,p_date_to in per_addresses.date_to%TYPE
292: ,p_object_version_number in per_addresses.object_version_number%TYPE)
293: is
294: --
295: l_exists varchar2(1);
296: l_proc varchar2(72) := g_package||'chk_date_to';

Line 370: (p_address_id in per_addresses.address_id%TYPE

366: --
367: -- {End Of Comments}
368: -- ----------------------------------------------------------------------------
369: procedure chk_date_from
370: (p_address_id in per_addresses.address_id%TYPE
371: ,p_date_from in per_addresses.date_from%TYPE
372: ,p_date_to in per_addresses.date_to%TYPE
373: ,p_object_version_number in per_addresses.object_version_number%TYPE)
374: is

Line 371: ,p_date_from in per_addresses.date_from%TYPE

367: -- {End Of Comments}
368: -- ----------------------------------------------------------------------------
369: procedure chk_date_from
370: (p_address_id in per_addresses.address_id%TYPE
371: ,p_date_from in per_addresses.date_from%TYPE
372: ,p_date_to in per_addresses.date_to%TYPE
373: ,p_object_version_number in per_addresses.object_version_number%TYPE)
374: is
375: --

Line 372: ,p_date_to in per_addresses.date_to%TYPE

368: -- ----------------------------------------------------------------------------
369: procedure chk_date_from
370: (p_address_id in per_addresses.address_id%TYPE
371: ,p_date_from in per_addresses.date_from%TYPE
372: ,p_date_to in per_addresses.date_to%TYPE
373: ,p_object_version_number in per_addresses.object_version_number%TYPE)
374: is
375: --
376: l_exists varchar2(1);

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

369: procedure chk_date_from
370: (p_address_id in per_addresses.address_id%TYPE
371: ,p_date_from in per_addresses.date_from%TYPE
372: ,p_date_to in per_addresses.date_to%TYPE
373: ,p_object_version_number in per_addresses.object_version_number%TYPE)
374: is
375: --
376: l_exists varchar2(1);
377: l_proc varchar2(72) := g_package||'chk_date_from';

Line 677: (p_address_id in per_addresses.address_id%TYPE

673: --
674: -- {End Of Comments}
675: -- ----------------------------------------------------------------------------
676: procedure chk_address_line1
677: (p_address_id in per_addresses.address_id%TYPE
678: ,p_style in per_addresses.style%TYPE
679: ,p_address_line1 in per_addresses.region_2%TYPE
680: ,p_object_version_number in per_addresses.object_version_number%TYPE)
681: is

Line 678: ,p_style in per_addresses.style%TYPE

674: -- {End Of Comments}
675: -- ----------------------------------------------------------------------------
676: procedure chk_address_line1
677: (p_address_id in per_addresses.address_id%TYPE
678: ,p_style in per_addresses.style%TYPE
679: ,p_address_line1 in per_addresses.region_2%TYPE
680: ,p_object_version_number in per_addresses.object_version_number%TYPE)
681: is
682: --

Line 679: ,p_address_line1 in per_addresses.region_2%TYPE

675: -- ----------------------------------------------------------------------------
676: procedure chk_address_line1
677: (p_address_id in per_addresses.address_id%TYPE
678: ,p_style in per_addresses.style%TYPE
679: ,p_address_line1 in per_addresses.region_2%TYPE
680: ,p_object_version_number in per_addresses.object_version_number%TYPE)
681: is
682: --
683: l_exists varchar2(1);

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

676: procedure chk_address_line1
677: (p_address_id in per_addresses.address_id%TYPE
678: ,p_style in per_addresses.style%TYPE
679: ,p_address_line1 in per_addresses.region_2%TYPE
680: ,p_object_version_number in per_addresses.object_version_number%TYPE)
681: is
682: --
683: l_exists varchar2(1);
684: l_proc varchar2(72) := g_package||'chk_address_line1';

Line 772: p_address_id in per_addresses.address_id%TYPE,

768: -- |--------------------------------------------|
769: -- ----------------------------------------------------------------------------
770: --
771: procedure chk_address1_towncity_comb(
772: p_address_id in per_addresses.address_id%TYPE,
773: p_object_version_number in per_addresses.object_version_number%TYPE,
774: p_town_or_city in out nocopy per_addresses.town_or_city%type,
775: p_address_line1 in out nocopy per_addresses.address_line1%type,
776: p_region_1 in out nocopy per_addresses.region_1%type) is

Line 773: p_object_version_number in per_addresses.object_version_number%TYPE,

769: -- ----------------------------------------------------------------------------
770: --
771: procedure chk_address1_towncity_comb(
772: p_address_id in per_addresses.address_id%TYPE,
773: p_object_version_number in per_addresses.object_version_number%TYPE,
774: p_town_or_city in out nocopy per_addresses.town_or_city%type,
775: p_address_line1 in out nocopy per_addresses.address_line1%type,
776: p_region_1 in out nocopy per_addresses.region_1%type) is
777:

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

770: --
771: procedure chk_address1_towncity_comb(
772: p_address_id in per_addresses.address_id%TYPE,
773: p_object_version_number in per_addresses.object_version_number%TYPE,
774: p_town_or_city in out nocopy per_addresses.town_or_city%type,
775: p_address_line1 in out nocopy per_addresses.address_line1%type,
776: p_region_1 in out nocopy per_addresses.region_1%type) is
777:
778: -- p_town_or_city ===> district_code

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

771: procedure chk_address1_towncity_comb(
772: p_address_id in per_addresses.address_id%TYPE,
773: p_object_version_number in per_addresses.object_version_number%TYPE,
774: p_town_or_city in out nocopy per_addresses.town_or_city%type,
775: p_address_line1 in out nocopy per_addresses.address_line1%type,
776: p_region_1 in out nocopy per_addresses.region_1%type) is
777:
778: -- p_town_or_city ===> district_code
779: -- p_address_line1 ===> address_line1

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

772: p_address_id in per_addresses.address_id%TYPE,
773: p_object_version_number in per_addresses.object_version_number%TYPE,
774: p_town_or_city in out nocopy per_addresses.town_or_city%type,
775: p_address_line1 in out nocopy per_addresses.address_line1%type,
776: p_region_1 in out nocopy per_addresses.region_1%type) is
777:
778: -- p_town_or_city ===> district_code
779: -- p_address_line1 ===> address_line1
780: -- p_region_1 ===> address_line1_kana

Line 862: p_address_id in per_addresses.address_id%TYPE,

858: -- |---------------------------------------------|
859: -- ----------------------------------------------------------------------------
860: --
861: procedure chk_address2_region2_comb(
862: p_address_id in per_addresses.address_id%TYPE,
863: p_object_version_number in per_addresses.object_version_number%TYPE,
864: p_address_line2 in per_addresses.address_line2%type,
865: p_region_2 in per_addresses.region_2%type) is
866:

Line 863: p_object_version_number in per_addresses.object_version_number%TYPE,

859: -- ----------------------------------------------------------------------------
860: --
861: procedure chk_address2_region2_comb(
862: p_address_id in per_addresses.address_id%TYPE,
863: p_object_version_number in per_addresses.object_version_number%TYPE,
864: p_address_line2 in per_addresses.address_line2%type,
865: p_region_2 in per_addresses.region_2%type) is
866:
867: -- p_address_line2 ===> address_line2

Line 864: p_address_line2 in per_addresses.address_line2%type,

860: --
861: procedure chk_address2_region2_comb(
862: p_address_id in per_addresses.address_id%TYPE,
863: p_object_version_number in per_addresses.object_version_number%TYPE,
864: p_address_line2 in per_addresses.address_line2%type,
865: p_region_2 in per_addresses.region_2%type) is
866:
867: -- p_address_line2 ===> address_line2
868: -- p_region_2 ===> address_line2_kana

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

861: procedure chk_address2_region2_comb(
862: p_address_id in per_addresses.address_id%TYPE,
863: p_object_version_number in per_addresses.object_version_number%TYPE,
864: p_address_line2 in per_addresses.address_line2%type,
865: p_region_2 in per_addresses.region_2%type) is
866:
867: -- p_address_line2 ===> address_line2
868: -- p_region_2 ===> address_line2_kana
869:

Line 908: p_address_id in per_addresses.address_id%TYPE,

904: -- |---------------------------------------------|
905: -- ----------------------------------------------------------------------------
906: --
907: procedure chk_address3_region3_comb(
908: p_address_id in per_addresses.address_id%TYPE,
909: p_object_version_number in per_addresses.object_version_number%TYPE,
910: p_address_line3 in per_addresses.address_line3%type,
911: p_region_3 in per_addresses.region_3%type) is
912:

Line 909: p_object_version_number in per_addresses.object_version_number%TYPE,

905: -- ----------------------------------------------------------------------------
906: --
907: procedure chk_address3_region3_comb(
908: p_address_id in per_addresses.address_id%TYPE,
909: p_object_version_number in per_addresses.object_version_number%TYPE,
910: p_address_line3 in per_addresses.address_line3%type,
911: p_region_3 in per_addresses.region_3%type) is
912:
913: -- p_address_line3 ===> address_line3

Line 910: p_address_line3 in per_addresses.address_line3%type,

906: --
907: procedure chk_address3_region3_comb(
908: p_address_id in per_addresses.address_id%TYPE,
909: p_object_version_number in per_addresses.object_version_number%TYPE,
910: p_address_line3 in per_addresses.address_line3%type,
911: p_region_3 in per_addresses.region_3%type) is
912:
913: -- p_address_line3 ===> address_line3
914: -- p_region_3 ===> address_line3_kana

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

907: procedure chk_address3_region3_comb(
908: p_address_id in per_addresses.address_id%TYPE,
909: p_object_version_number in per_addresses.object_version_number%TYPE,
910: p_address_line3 in per_addresses.address_line3%type,
911: p_region_3 in per_addresses.region_3%type) is
912:
913: -- p_address_line3 ===> address_line3
914: -- p_region_3 ===> address_line3_kana
915:

Line 1049: (p_address_id in per_addresses.address_id%TYPE

1045: --
1046: -- {End Of Comments}
1047: -- ----------------------------------------------------------------------------
1048: procedure chk_postal_code
1049: (p_address_id in per_addresses.address_id%TYPE
1050: ,p_style in per_addresses.style%TYPE
1051: ,p_postal_code in per_addresses.postal_code%TYPE
1052: ,p_business_group_id in per_addresses.business_group_id%TYPE
1053: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 1050: ,p_style in per_addresses.style%TYPE

1046: -- {End Of Comments}
1047: -- ----------------------------------------------------------------------------
1048: procedure chk_postal_code
1049: (p_address_id in per_addresses.address_id%TYPE
1050: ,p_style in per_addresses.style%TYPE
1051: ,p_postal_code in per_addresses.postal_code%TYPE
1052: ,p_business_group_id in per_addresses.business_group_id%TYPE
1053: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1054: is

Line 1051: ,p_postal_code in per_addresses.postal_code%TYPE

1047: -- ----------------------------------------------------------------------------
1048: procedure chk_postal_code
1049: (p_address_id in per_addresses.address_id%TYPE
1050: ,p_style in per_addresses.style%TYPE
1051: ,p_postal_code in per_addresses.postal_code%TYPE
1052: ,p_business_group_id in per_addresses.business_group_id%TYPE
1053: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1054: is
1055: --

Line 1052: ,p_business_group_id in per_addresses.business_group_id%TYPE

1048: procedure chk_postal_code
1049: (p_address_id in per_addresses.address_id%TYPE
1050: ,p_style in per_addresses.style%TYPE
1051: ,p_postal_code in per_addresses.postal_code%TYPE
1052: ,p_business_group_id in per_addresses.business_group_id%TYPE
1053: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1054: is
1055: --
1056: l_proc varchar2(72) := g_package||'chk_postal_code';

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

1049: (p_address_id in per_addresses.address_id%TYPE
1050: ,p_style in per_addresses.style%TYPE
1051: ,p_postal_code in per_addresses.postal_code%TYPE
1052: ,p_business_group_id in per_addresses.business_group_id%TYPE
1053: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1054: is
1055: --
1056: l_proc varchar2(72) := g_package||'chk_postal_code';
1057: l_api_updating boolean;

Line 1234: (p_address_id in per_addresses.address_id%TYPE

1230: --
1231: -- {End Of Comments}
1232: -- ----------------------------------------------------------------------------
1233: procedure chk_region_1
1234: (p_address_id in per_addresses.address_id%TYPE
1235: ,p_style in per_addresses.style%TYPE
1236: ,p_region_1 in per_addresses.region_1%TYPE
1237: ,p_business_group_id in per_addresses.business_group_id%TYPE
1238: ,p_effective_date in date

Line 1235: ,p_style in per_addresses.style%TYPE

1231: -- {End Of Comments}
1232: -- ----------------------------------------------------------------------------
1233: procedure chk_region_1
1234: (p_address_id in per_addresses.address_id%TYPE
1235: ,p_style in per_addresses.style%TYPE
1236: ,p_region_1 in per_addresses.region_1%TYPE
1237: ,p_business_group_id in per_addresses.business_group_id%TYPE
1238: ,p_effective_date in date
1239: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 1236: ,p_region_1 in per_addresses.region_1%TYPE

1232: -- ----------------------------------------------------------------------------
1233: procedure chk_region_1
1234: (p_address_id in per_addresses.address_id%TYPE
1235: ,p_style in per_addresses.style%TYPE
1236: ,p_region_1 in per_addresses.region_1%TYPE
1237: ,p_business_group_id in per_addresses.business_group_id%TYPE
1238: ,p_effective_date in date
1239: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1240: is

Line 1237: ,p_business_group_id in per_addresses.business_group_id%TYPE

1233: procedure chk_region_1
1234: (p_address_id in per_addresses.address_id%TYPE
1235: ,p_style in per_addresses.style%TYPE
1236: ,p_region_1 in per_addresses.region_1%TYPE
1237: ,p_business_group_id in per_addresses.business_group_id%TYPE
1238: ,p_effective_date in date
1239: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1240: is
1241: --

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

1235: ,p_style in per_addresses.style%TYPE
1236: ,p_region_1 in per_addresses.region_1%TYPE
1237: ,p_business_group_id in per_addresses.business_group_id%TYPE
1238: ,p_effective_date in date
1239: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1240: is
1241: --
1242: l_exists varchar2(1);
1243: l_proc varchar2(72) := g_package||'chk_region_1';

Line 1363: (p_address_id in per_addresses.address_id%TYPE

1359: --
1360: -- {End Of Comments}
1361: -- ----------------------------------------------------------------------------
1362: procedure chk_region_2
1363: (p_address_id in per_addresses.address_id%TYPE
1364: ,p_style in per_addresses.style%TYPE
1365: ,p_region_2 in per_addresses.region_2%TYPE
1366: ,p_business_group_id in per_addresses.business_group_id%TYPE
1367: ,p_effective_date in date

Line 1364: ,p_style in per_addresses.style%TYPE

1360: -- {End Of Comments}
1361: -- ----------------------------------------------------------------------------
1362: procedure chk_region_2
1363: (p_address_id in per_addresses.address_id%TYPE
1364: ,p_style in per_addresses.style%TYPE
1365: ,p_region_2 in per_addresses.region_2%TYPE
1366: ,p_business_group_id in per_addresses.business_group_id%TYPE
1367: ,p_effective_date in date
1368: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 1365: ,p_region_2 in per_addresses.region_2%TYPE

1361: -- ----------------------------------------------------------------------------
1362: procedure chk_region_2
1363: (p_address_id in per_addresses.address_id%TYPE
1364: ,p_style in per_addresses.style%TYPE
1365: ,p_region_2 in per_addresses.region_2%TYPE
1366: ,p_business_group_id in per_addresses.business_group_id%TYPE
1367: ,p_effective_date in date
1368: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1369: is

Line 1366: ,p_business_group_id in per_addresses.business_group_id%TYPE

1362: procedure chk_region_2
1363: (p_address_id in per_addresses.address_id%TYPE
1364: ,p_style in per_addresses.style%TYPE
1365: ,p_region_2 in per_addresses.region_2%TYPE
1366: ,p_business_group_id in per_addresses.business_group_id%TYPE
1367: ,p_effective_date in date
1368: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1369: is
1370: --

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

1364: ,p_style in per_addresses.style%TYPE
1365: ,p_region_2 in per_addresses.region_2%TYPE
1366: ,p_business_group_id in per_addresses.business_group_id%TYPE
1367: ,p_effective_date in date
1368: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1369: is
1370: --
1371: l_exists varchar2(1);
1372: l_proc varchar2(72) := g_package||'chk_region_2';

Line 1499: (p_address_id in per_addresses.address_id%TYPE

1495: --
1496: -- {End Of Comments}
1497: -- ----------------------------------------------------------------------------
1498: procedure chk_town_or_city
1499: (p_address_id in per_addresses.address_id%TYPE
1500: ,p_style in per_addresses.style%TYPE
1501: ,p_town_or_city in per_addresses.town_or_city%TYPE
1502: ,p_business_group_id in per_addresses.business_group_id%TYPE
1503: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 1500: ,p_style in per_addresses.style%TYPE

1496: -- {End Of Comments}
1497: -- ----------------------------------------------------------------------------
1498: procedure chk_town_or_city
1499: (p_address_id in per_addresses.address_id%TYPE
1500: ,p_style in per_addresses.style%TYPE
1501: ,p_town_or_city in per_addresses.town_or_city%TYPE
1502: ,p_business_group_id in per_addresses.business_group_id%TYPE
1503: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1504: is

Line 1501: ,p_town_or_city in per_addresses.town_or_city%TYPE

1497: -- ----------------------------------------------------------------------------
1498: procedure chk_town_or_city
1499: (p_address_id in per_addresses.address_id%TYPE
1500: ,p_style in per_addresses.style%TYPE
1501: ,p_town_or_city in per_addresses.town_or_city%TYPE
1502: ,p_business_group_id in per_addresses.business_group_id%TYPE
1503: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1504: is
1505: --

Line 1502: ,p_business_group_id in per_addresses.business_group_id%TYPE

1498: procedure chk_town_or_city
1499: (p_address_id in per_addresses.address_id%TYPE
1500: ,p_style in per_addresses.style%TYPE
1501: ,p_town_or_city in per_addresses.town_or_city%TYPE
1502: ,p_business_group_id in per_addresses.business_group_id%TYPE
1503: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1504: is
1505: --
1506: l_exists varchar2(1);

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

1499: (p_address_id in per_addresses.address_id%TYPE
1500: ,p_style in per_addresses.style%TYPE
1501: ,p_town_or_city in per_addresses.town_or_city%TYPE
1502: ,p_business_group_id in per_addresses.business_group_id%TYPE
1503: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1504: is
1505: --
1506: l_exists varchar2(1);
1507: l_proc varchar2(72) := g_package||'chk_town_or_city';

Line 1602: (p_address_id in per_addresses.address_id%TYPE

1598: --
1599: -- {End Of Comments}
1600: -- ----------------------------------------------------------------------------
1601: procedure chk_city_state_zip_comb
1602: (p_address_id in per_addresses.address_id%TYPE
1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE

Line 1603: ,p_style in per_addresses.style%TYPE

1599: -- {End Of Comments}
1600: -- ----------------------------------------------------------------------------
1601: procedure chk_city_state_zip_comb
1602: (p_address_id in per_addresses.address_id%TYPE
1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE

Line 1604: ,p_postal_code in per_addresses.postal_code%TYPE

1600: -- ----------------------------------------------------------------------------
1601: procedure chk_city_state_zip_comb
1602: (p_address_id in per_addresses.address_id%TYPE
1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE
1608: ,p_object_version_number in per_addresses.object_version_number%TYPE)

Line 1605: ,p_region_2 in per_addresses.region_2%TYPE

1601: procedure chk_city_state_zip_comb
1602: (p_address_id in per_addresses.address_id%TYPE
1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE
1608: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1609: is

Line 1606: ,p_town_or_city in per_addresses.town_or_city%TYPE

1602: (p_address_id in per_addresses.address_id%TYPE
1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE
1608: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1609: is
1610: --

Line 1607: ,p_business_group_id in per_addresses.business_group_id%TYPE

1603: ,p_style in per_addresses.style%TYPE
1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE
1608: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1609: is
1610: --
1611: l_exists varchar2(1);

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

1604: ,p_postal_code in per_addresses.postal_code%TYPE
1605: ,p_region_2 in per_addresses.region_2%TYPE
1606: ,p_town_or_city in per_addresses.town_or_city%TYPE
1607: ,p_business_group_id in per_addresses.business_group_id%TYPE
1608: ,p_object_version_number in per_addresses.object_version_number%TYPE)
1609: is
1610: --
1611: l_exists varchar2(1);
1612: l_proc varchar2(72) := g_package||'chk_city_state_zip_comb';

Line 1745: from per_addresses pa

1741: l_date date;
1742: --
1743: cursor csr_del_address is
1744: select null
1745: from per_addresses pa
1746: where pa.date_from between per_kad_shd.g_old_rec.date_from
1747: and l_date
1748: and pa.person_id = per_kad_shd.g_old_rec.person_id
1749: and pa.primary_flag = 'N';

Line 1755: from per_addresses pa2

1751: cursor csr_no_del_contig_add is
1752: select null
1753: from sys.dual
1754: where exists(select null
1755: from per_addresses pa2
1756: where pa2.date_from > l_date
1757: and pa2.person_id = per_kad_shd.g_old_rec.person_id
1758: and pa2.primary_flag = 'Y');
1759: --