DBA Data[Home] [Help]

APPS.PER_JP_CONTACT_EXTRA_INFO dependencies on HR_UTILITY

Line 40: hr_utility.set_location('Entering : ' || c_proc, 10);

36: and information_type <> p_information_type
37: and effective_end_date >= p_validation_start_date
38: and effective_start_date <= p_validation_end_date;
39: begin
40: hr_utility.set_location('Entering : ' || c_proc, 10);
41: --
42: -- No need to lock contact_relationship_id which is already locked in lck and ins_lck.
43: --
44: if p_information_type in ('JP_ITAX_DEPENDENT', 'JP_ITAX_DEPENDENT_ON_OTHER_EMP', 'JP_ITAX_DEPENDENT_ON_OTHER_PAY') then

Line 64: hr_utility.set_location('Leaving : ' || c_proc, 20);

60: end if;
61: close csr_si;
62: end if;
63: --
64: hr_utility.set_location('Leaving : ' || c_proc, 20);
65: end chk_information_type;
66: -- ----------------------------------------------------------------------------
67: -- |------------------------< chk_information_type_rkd >----------------------|
68: -- ----------------------------------------------------------------------------

Line 79: hr_utility.set_location('Entering : ' || c_proc, 10);

75: p_validation_end_date in date)
76: is
77: c_proc constant varchar2(61) := c_package || 'chk_information_type_rkd';
78: begin
79: hr_utility.set_location('Entering : ' || c_proc, 10);
80: --
81: if p_datetrack_mode in (hr_api.g_future_change, hr_api.g_delete_next_change) then
82: chk_information_type(
83: p_contact_extra_info_id => p_contact_extra_info_id,

Line 90: hr_utility.set_location('Leaving : ' || c_proc, 20);

86: p_validation_start_date => p_validation_start_date,
87: p_validation_end_date => p_validation_end_date);
88: end if;
89: --
90: hr_utility.set_location('Leaving : ' || c_proc, 20);
91: end chk_information_type_rkd;
92: /*
93: -- ----------------------------------------------------------------------------
94: -- |--------------------------< chk_information_type >------------------------|