eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CET_BUS dependencies on PQH_CET_SHD

Line 46: l_api_updating := pqh_cet_shd.api_updating

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

Line 52: <> pqh_cet_shd.g_old_rec.copy_entity_txn_id) then

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

Line 56: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_PK');

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

Line 66: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_PK');

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

Line 115: pqh_cet_shd.constraint_error('PQH_COMPLETED_TARGET');

111: if pqh_cet_bus.chk_completed_target(p_copy_entity_txn_id) then
112: --
113: -- raise error as atleast one target record has been successfully completed
114: --
115: pqh_cet_shd.constraint_error('PQH_COMPLETED_TARGET');
116: end if;
117: --
118: hr_utility.set_location('Leaving:'||l_proc,10);
119: --

Line 206: l_api_updating := pqh_cet_shd.api_updating

202: Begin
203: --
204: hr_utility.set_location('Entering:'||l_proc,5);
205: --
206: l_api_updating := pqh_cet_shd.api_updating
207: (p_copy_entity_txn_id => p_copy_entity_txn_id,
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating

Line 212: <> nvl(pqh_cet_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)

208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_txn_category_attribute_id,hr_api.g_number)
212: <> nvl(pqh_cet_shd.g_old_rec.txn_category_attribute_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if txn_category_attribute_id value exists in pqh_special_attributes table
216: --

Line 227: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK2');

223: --
224: -- raise error as FK does not relate to PK in pqh_special_attributes
225: -- table.
226: --
227: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK2');
228: --
229: end if;
230: --
231: close c1;

Line 281: l_api_updating := pqh_cet_shd.api_updating

277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc,5);
280: --
281: l_api_updating := pqh_cet_shd.api_updating
282: (p_copy_entity_txn_id => p_copy_entity_txn_id,
283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating

Line 287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)

283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and nvl(p_context_business_group_id,hr_api.g_number)
287: <> nvl(pqh_cet_shd.g_old_rec.context_business_group_id,hr_api.g_number)
288: or not l_api_updating) then
289: --
290: -- check if context_business_group_id value exists in per_business_groups table
291: --

Line 302: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK2');

298: --
299: -- raise error as FK does not relate to PK in per_business_groups
300: -- table.
301: --
302: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK2');
303: --
304: end if;
305: --
306: close c1;

Line 356: l_api_updating := pqh_cet_shd.api_updating

352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc,5);
355: --
356: l_api_updating := pqh_cet_shd.api_updating
357: (p_copy_entity_txn_id => p_copy_entity_txn_id,
358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating

Line 362: <> nvl(pqh_cet_shd.g_old_rec.transaction_category_id,hr_api.g_number)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and nvl(p_transaction_category_id,hr_api.g_number)
362: <> nvl(pqh_cet_shd.g_old_rec.transaction_category_id,hr_api.g_number)
363: or not l_api_updating) then
364: --
365: -- check if transaction_category_id value exists in pqh_transaction_categories table
366: --

Line 377: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK1');

373: --
374: -- raise error as FK does not relate to PK in pqh_transaction_categories
375: -- table.
376: --
377: pqh_cet_shd.constraint_error('PQH_COPY_ENTITY_TXNS_FK1');
378: --
379: end if;
380: --
381: close c1;

Line 427: l_api_updating := pqh_cet_shd.api_updating

423: Begin
424: --
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: l_api_updating := pqh_cet_shd.api_updating
428: (p_copy_entity_txn_id => p_copy_entity_txn_id,
429: p_object_version_number => p_object_version_number);
430: --
431: if (l_api_updating

Line 433: <> nvl(pqh_cet_shd.g_old_rec.replacement_type_cd,hr_api.g_varchar2)

429: p_object_version_number => p_object_version_number);
430: --
431: if (l_api_updating
432: and p_replacement_type_cd
433: <> nvl(pqh_cet_shd.g_old_rec.replacement_type_cd,hr_api.g_varchar2)
434: or not l_api_updating)
435: and p_replacement_type_cd is not null then
436: --
437: -- check if value of lookup falls within lookup type.

Line 460: Procedure insert_validate(p_rec in pqh_cet_shd.g_rec_type

456: --
457: -- ----------------------------------------------------------------------------
458: -- |---------------------------< insert_validate >----------------------------|
459: -- ----------------------------------------------------------------------------
460: Procedure insert_validate(p_rec in pqh_cet_shd.g_rec_type
461: ,p_effective_date in date) is
462: --
463: l_proc varchar2(72) := g_package||'insert_validate';
464: --

Line 493: Procedure update_validate(p_rec in pqh_cet_shd.g_rec_type

489: --
490: -- ----------------------------------------------------------------------------
491: -- |---------------------------< update_validate >----------------------------|
492: -- ----------------------------------------------------------------------------
493: Procedure update_validate(p_rec in pqh_cet_shd.g_rec_type
494: ,p_effective_date in date) is
495: --
496: l_proc varchar2(72) := g_package||'update_validate';
497: --

Line 526: Procedure delete_validate(p_rec in pqh_cet_shd.g_rec_type

522: --
523: -- ----------------------------------------------------------------------------
524: -- |---------------------------< delete_validate >----------------------------|
525: -- ----------------------------------------------------------------------------
526: Procedure delete_validate(p_rec in pqh_cet_shd.g_rec_type
527: ,p_effective_date in date) is
528: --
529: l_proc varchar2(72) := g_package||'delete_validate';
530: --