DBA Data[Home] [Help]

APPS.HR_PERSON_ADDRESS_API dependencies on PER_ADD_SHD

Line 7435: l_add_rec per_add_shd.g_rec_type;

7431: -- Declare cursors and local variables
7432: --
7433: l_proc varchar2(72) := g_package||'cre_or_upd_person_address';
7434: l_effective_date date;
7435: l_add_rec per_add_shd.g_rec_type;
7436: l_null_add_rec per_add_shd.g_rec_type;
7437: l_update_mode varchar2(30);
7438: l_api_updating boolean;
7439: --

Line 7436: l_null_add_rec per_add_shd.g_rec_type;

7432: --
7433: l_proc varchar2(72) := g_package||'cre_or_upd_person_address';
7434: l_effective_date date;
7435: l_add_rec per_add_shd.g_rec_type;
7436: l_null_add_rec per_add_shd.g_rec_type;
7437: l_update_mode varchar2(30);
7438: l_api_updating boolean;
7439: --
7440: lv_address_id number := p_address_id ;

Line 7451: l_api_updating := per_add_shd.api_updating

7447: savepoint cre_or_upd_person_address;
7448: --
7449: l_update_mode:=p_update_mode;
7450: l_effective_date:=trunc(p_effective_date);
7451: l_api_updating := per_add_shd.api_updating
7452: (p_address_id => p_address_id
7453: ,p_object_version_number => p_object_version_number);
7454: hr_utility.set_location(l_proc, 20);
7455: --

Line 7459: per_add_shd.convert_args

7455: --
7456: -- set the record
7457: --
7458: l_add_rec:=
7459: per_add_shd.convert_args
7460: (p_address_id
7461: ,p_business_group_id
7462: ,p_person_id
7463: ,trunc(p_date_from)

Line 7521: per_add_shd.g_old_rec:=l_null_add_rec;

7517: if not l_api_updating then
7518: --
7519: -- set g_old_rec to null
7520: --
7521: per_add_shd.g_old_rec:=l_null_add_rec;
7522: hr_utility.set_location(l_proc, 30);
7523: --
7524: -- convert the null values
7525: --

Line 7614: per_add_shd.lck

7610: hr_utility.raise_error;
7611: end if;
7612: hr_utility.set_location(l_proc, 110);
7613: --
7614: per_add_shd.lck
7615: (p_address_id => p_address_id
7616: ,p_object_version_number => p_object_version_number);
7617: --
7618: -- convert the null values

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

7622: --
7623: -- check to see if the start date hasn't changed and is equal to the
7624: -- effective date. This will always be a correction.
7625: --
7626: if per_add_shd.g_old_rec.date_from = l_add_rec.date_from
7627: and l_add_rec.date_from = l_effective_date then
7628: l_update_mode:= hr_api.g_correction;
7629: end if;
7630: --

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

7638: --
7639: -- Bug 2863410 starts here.
7640: -- If the style is changed then used update_pers_addr_with_style.
7641: --
7642: IF per_add_shd.g_old_rec.style <> l_add_rec.style THEN
7643: --
7644: hr_utility.set_location(l_proc, 142);
7645: --
7646: hr_person_address_api.update_pers_addr_with_style

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

7776: -- we have an error. A change of start date is the new start date for
7777: -- the new record, so must be the effective date so that the address
7778: -- is continuous.
7779: --
7780: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from
7781: and l_add_rec.date_from <> l_effective_date then
7782: hr_utility.set_location(l_proc, 170);
7783: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
7784: hr_utility.raise_error;

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

7799: -- );
7800: --
7801:
7802: -- changes started for bug5372061
7803: if per_add_shd.g_old_rec.primary_flag <> 'Y' and p_primary_flag <> 'Y' then
7804: hr_person_address_api.update_person_address
7805: (p_validate => FALSE
7806: ,p_effective_date => l_effective_date
7807: ,p_validate_county => p_validate_county