APPS.PQH_PTI_BUS dependencies on PQH_PTI_SHD

Line 46: l_api_updating := pqh_pti_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_pti_shd.api_updating
47: (p_information_type => p_information_type,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_pti_shd.g_old_rec.information_type) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_information_type,hr_api.g_number)
52: <> pqh_pti_shd.g_old_rec.information_type) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_pti_shd.constraint_error('PQH_PTX_INFO_TYPES_PK');

Line 56: pqh_pti_shd.constraint_error('PQH_PTX_INFO_TYPES_PK');

52: <> pqh_pti_shd.g_old_rec.information_type) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_pti_shd.constraint_error('PQH_PTX_INFO_TYPES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_pti_shd.constraint_error('PQH_PTX_INFO_TYPES_PK');

62: if p_information_type is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_pti_shd.constraint_error('PQH_PTX_INFO_TYPES_PK');
67: --
68: end if;
69: --
70: end if;

Line 114: l_api_updating := pqh_pti_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := pqh_pti_shd.api_updating
115: (p_information_type => p_information_type,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

Line 120: <> nvl(pqh_pti_shd.g_old_rec.multiple_occurences_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_multiple_occurences_flag
120: <> nvl(pqh_pti_shd.g_old_rec.multiple_occurences_flag,hr_api.g_varchar2)
121: or not l_api_updating) then
122: --
123: -- check if value of lookup falls within lookup type.
124: --

Line 182: l_api_updating := pqh_pti_shd.api_updating

178: Begin
179: --
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: l_api_updating := pqh_pti_shd.api_updating
183: (p_information_type => p_information_type,
184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating

Line 188: <> nvl(pqh_pti_shd.g_old_rec.active_inactive_flag,hr_api.g_varchar2)

184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating
187: and p_active_inactive_flag
188: <> nvl(pqh_pti_shd.g_old_rec.active_inactive_flag,hr_api.g_varchar2)
189: or not l_api_updating) then
190: --
191: -- check if value of lookup falls within lookup type.
192: --

Line 215: Procedure insert_validate(p_rec in pqh_pti_shd.g_rec_type

211: --
212: -- ----------------------------------------------------------------------------
213: -- |---------------------------< insert_validate >----------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure insert_validate(p_rec in pqh_pti_shd.g_rec_type
216: ,p_effective_date in date) is
217: --
218: l_proc varchar2(72) := g_package||'insert_validate';
219: --

Line 249: Procedure update_validate(p_rec in pqh_pti_shd.g_rec_type

245: --
246: -- ----------------------------------------------------------------------------
247: -- |---------------------------< update_validate >----------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure update_validate(p_rec in pqh_pti_shd.g_rec_type
250: ,p_effective_date in date) is
251: --
252: l_proc varchar2(72) := g_package||'update_validate';
253: --

Line 283: Procedure delete_validate(p_rec in pqh_pti_shd.g_rec_type

279: --
280: -- ----------------------------------------------------------------------------
281: -- |---------------------------< delete_validate >----------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure delete_validate(p_rec in pqh_pti_shd.g_rec_type
284: ,p_effective_date in date) is
285: --
286: l_proc varchar2(72) := g_package||'delete_validate';
287: --