[Home] [Help]
40: l_api_updating boolean;
41: --
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);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_copy_entity_txn_id;
75: --
76: -- ----------------------------------------------------------------------------
105: l_dummy varchar2(1);
106: --
107: Begin
108: --
109: hr_utility.set_location('Entering:'||l_proc,5);
110: --
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: --
120: End chk_completed_target_err;
121: --
122: function chk_completed_target(p_copy_entity_txn_id in number) return boolean is
133: and a.status = 'COMPLETED' ;
134: --
135: Begin
136: --
137: hr_utility.set_location('Entering:'||l_proc,5);
138: --
139: if p_copy_entity_txn_id is not null then
140: --
141: open c1;
156: end if;
157: --
158: return (FALSE);
159: --
160: hr_utility.set_location('Leaving:'||l_proc,10);
161: --
162: End chk_completed_target;
163: --
164: -- ----------------------------------------------------------------------------
200: where a.txn_category_attribute_id = p_txn_category_attribute_id;
201: --
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);
231: close c1;
232: --
233: end if;
234: --
235: hr_utility.set_location('Leaving:'||l_proc,10);
236: --
237: End chk_txn_category_attribute_id;
238: --
239: -- ----------------------------------------------------------------------------
275: where a.business_group_id = p_context_business_group_id;
276: --
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);
306: close c1;
307: --
308: end if;
309: --
310: hr_utility.set_location('Leaving:'||l_proc,10);
311: --
312: End chk_context_business_group_id;
313: --
314: -- ----------------------------------------------------------------------------
350: where a.transaction_category_id = p_transaction_category_id;
351: --
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);
381: close c1;
382: --
383: end if;
384: --
385: hr_utility.set_location('Leaving:'||l_proc,10);
386: --
387: End chk_transaction_category_id;
388: --
389: -- ----------------------------------------------------------------------------
421: l_api_updating boolean;
422: --
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);
442: p_effective_date => p_effective_date) then
443: --
444: -- raise error as does not exist as lookup
445: --
446: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
447: hr_utility.raise_error;
448: --
449: end if;
450: --
443: --
444: -- raise error as does not exist as lookup
445: --
446: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
447: hr_utility.raise_error;
448: --
449: end if;
450: --
451: end if;
449: end if;
450: --
451: end if;
452: --
453: hr_utility.set_location('Leaving:'||l_proc,10);
454: --
455: end chk_replacement_type_cd;
456: --
457: -- ----------------------------------------------------------------------------
462: --
463: l_proc varchar2(72) := g_package||'insert_validate';
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Call all supporting business operations
469: --
470: chk_copy_entity_txn_id
483: p_object_version_number => p_rec.object_version_number);
484: --
485: --
486: --
487: hr_utility.set_location(' Leaving:'||l_proc, 10);
488: End insert_validate;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |---------------------------< update_validate >----------------------------|
495: --
496: l_proc varchar2(72) := g_package||'update_validate';
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Call all supporting business operations
502: --
503: chk_copy_entity_txn_id
516: p_object_version_number => p_rec.object_version_number);
517: --
518: --
519: --
520: hr_utility.set_location(' Leaving:'||l_proc, 10);
521: End update_validate;
522: --
523: -- ----------------------------------------------------------------------------
524: -- |---------------------------< delete_validate >----------------------------|
528: --
529: l_proc varchar2(72) := g_package||'delete_validate';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: -- Call all supporting business operations
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: -- Call all supporting business operations
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: End delete_validate;
538: --
539: end pqh_cet_bus;