DBA Data[Home] [Help]

APPS.HR_PERSON_ADDRESS_API dependencies on PER_ADD_SHD

Line 7708: l_add_rec per_add_shd.g_rec_type;

7704: -- Declare cursors and local variables
7705: --
7706: l_proc varchar2(72) := g_package||'cre_or_upd_person_address';
7707: l_effective_date date;
7708: l_add_rec per_add_shd.g_rec_type;
7709: l_null_add_rec per_add_shd.g_rec_type;
7710: l_update_mode varchar2(30);
7711: l_api_updating boolean;
7712: --

Line 7709: l_null_add_rec per_add_shd.g_rec_type;

7705: --
7706: l_proc varchar2(72) := g_package||'cre_or_upd_person_address';
7707: l_effective_date date;
7708: l_add_rec per_add_shd.g_rec_type;
7709: l_null_add_rec per_add_shd.g_rec_type;
7710: l_update_mode varchar2(30);
7711: l_api_updating boolean;
7712: --
7713: lv_address_id number := p_address_id ;

Line 7724: l_api_updating := per_add_shd.api_updating

7720: savepoint cre_or_upd_person_address;
7721: --
7722: l_update_mode:=p_update_mode;
7723: l_effective_date:=trunc(p_effective_date);
7724: l_api_updating := per_add_shd.api_updating
7725: (p_address_id => p_address_id
7726: ,p_object_version_number => p_object_version_number);
7727: hr_utility.set_location(l_proc, 20);
7728: --

Line 7732: per_add_shd.convert_args

7728: --
7729: -- set the record
7730: --
7731: l_add_rec:=
7732: per_add_shd.convert_args
7733: (p_address_id
7734: ,p_business_group_id
7735: ,p_person_id
7736: ,trunc(p_date_from)

Line 7794: per_add_shd.g_old_rec:=l_null_add_rec;

7790: if not l_api_updating then
7791: --
7792: -- set g_old_rec to null
7793: --
7794: per_add_shd.g_old_rec:=l_null_add_rec;
7795: hr_utility.set_location(l_proc, 30);
7796: --
7797: -- convert the null values
7798: --

Line 7887: per_add_shd.lck

7883: hr_utility.raise_error;
7884: end if;
7885: hr_utility.set_location(l_proc, 110);
7886: --
7887: per_add_shd.lck
7888: (p_address_id => p_address_id
7889: ,p_object_version_number => p_object_version_number);
7890: --
7891: -- convert the null values

Line 7899: if per_add_shd.g_old_rec.date_from = l_add_rec.date_from

7895: --
7896: -- check to see if the start date hasn't changed and is equal to the
7897: -- effective date. This will always be a correction.
7898: --
7899: if per_add_shd.g_old_rec.date_from = l_add_rec.date_from
7900: and l_add_rec.date_from = l_effective_date then
7901: l_update_mode:= hr_api.g_correction;
7902: end if;
7903: --

Line 7915: IF per_add_shd.g_old_rec.style <> l_add_rec.style THEN

7911: --
7912: -- Bug 2863410 starts here.
7913: -- If the style is changed then used update_pers_addr_with_style.
7914: --
7915: IF per_add_shd.g_old_rec.style <> l_add_rec.style THEN
7916: --
7917: hr_utility.set_location(l_proc, 142);
7918: --
7919: hr_person_address_api.update_pers_addr_with_style

Line 8053: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from

8049: -- we have an error. A change of start date is the new start date for
8050: -- the new record, so must be the effective date so that the address
8051: -- is continuous.
8052: --
8053: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from
8054: and l_add_rec.date_from <> l_effective_date then
8055: hr_utility.set_location(l_proc, 170);
8056: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
8057: hr_utility.raise_error;

Line 8076: if per_add_shd.g_old_rec.primary_flag <> 'Y' and p_primary_flag <> 'Y' then

8072: -- );
8073: --
8074:
8075: -- changes started for bug5372061
8076: if per_add_shd.g_old_rec.primary_flag <> 'Y' and p_primary_flag <> 'Y' then
8077: hr_person_address_api.update_person_address
8078: (p_validate => FALSE
8079: ,p_effective_date => l_effective_date
8080: ,p_validate_county => p_validate_county