APPS.PQH_CER_BUS dependencies on PQH_CER_SHD

Line 46: l_api_updating := pqh_cer_shd.api_updating

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

Line 52: <> pqh_cer_shd.g_old_rec.copy_entity_result_id) then

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

Line 56: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_PK');

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

Line 66: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_PK');

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

Line 132: -- pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK2');

128: --
129: -- raise error as FK does not relate to PK in pqh_copy_entity_results
130: -- table.
131: --
132: -- pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK2');
133: null;
134: --
135: end if;
136: --

Line 187: l_api_updating := pqh_cer_shd.api_updating

183: Begin
184: --
185: hr_utility.set_location('Entering:'||l_proc,5);
186: --
187: l_api_updating := pqh_cer_shd.api_updating
188: (p_copy_entity_result_id => p_copy_entity_result_id,
189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating

Line 193: <> nvl(pqh_cer_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_copy_entity_txn_id,hr_api.g_number)
193: <> nvl(pqh_cer_shd.g_old_rec.copy_entity_txn_id,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if copy_entity_txn_id value exists in pqh_copy_entity_txns table
197: --

Line 208: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK1');

204: --
205: -- raise error as FK does not relate to PK in pqh_copy_entity_txns
206: -- table.
207: --
208: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK1');
209: --
210: end if;
211: --
212: close c1;

Line 258: l_api_updating := pqh_cer_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := pqh_cer_shd.api_updating
259: (p_copy_entity_result_id => p_copy_entity_result_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating

Line 264: <> nvl(pqh_cer_shd.g_old_rec.result_type_cd,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_result_type_cd
264: <> nvl(pqh_cer_shd.g_old_rec.result_type_cd,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_result_type_cd is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 291: Procedure insert_validate(p_rec in pqh_cer_shd.g_rec_type

287: --
288: -- ----------------------------------------------------------------------------
289: -- |---------------------------< insert_validate >----------------------------|
290: -- ----------------------------------------------------------------------------
291: Procedure insert_validate(p_rec in pqh_cer_shd.g_rec_type
292: ,p_effective_date in date) is
293: --
294: l_proc varchar2(72) := g_package||'insert_validate';
295: --

Line 329: Procedure update_validate(p_rec in pqh_cer_shd.g_rec_type

325: --
326: -- ----------------------------------------------------------------------------
327: -- |---------------------------< update_validate >----------------------------|
328: -- ----------------------------------------------------------------------------
329: Procedure update_validate(p_rec in pqh_cer_shd.g_rec_type
330: ,p_effective_date in date) is
331: --
332: l_proc varchar2(72) := g_package||'update_validate';
333: --

Line 367: Procedure delete_validate(p_rec in pqh_cer_shd.g_rec_type

363: --
364: -- ----------------------------------------------------------------------------
365: -- |---------------------------< delete_validate >----------------------------|
366: -- ----------------------------------------------------------------------------
367: Procedure delete_validate(p_rec in pqh_cer_shd.g_rec_type
368: ,p_effective_date in date) is
369: --
370: l_proc varchar2(72) := g_package||'delete_validate';
371: --