DBA Data[Home] [Help]

APPS.HR_COMM_API dependencies on HR_API

Line 252: When HR_Api.Object_Locked then

248: --
249: -- We need to trap the ORA LOCK exception
250: --
251: Exception
252: When HR_Api.Object_Locked then
253: --
254: -- The object is locked therefore we need to supply a meaningful
255: -- error message.
256: --

Line 321: If (p_rec.source_table_name = hr_api.g_varchar2) then

317: -- p_rec plsql record structure
318: -- to see if a system default is being used. If a system default
319: -- is being used then we must set to the 'current' argument value.
320: --
321: If (p_rec.source_table_name = hr_api.g_varchar2) then
322: p_rec.source_table_name := g_old_rec.source_table_name;
323: End If;
324: If (p_rec.comment_text = hr_api.g_varchar2) then
325: p_rec.comment_text := g_old_rec.comment_text;

Line 324: If (p_rec.comment_text = hr_api.g_varchar2) then

320: --
321: If (p_rec.source_table_name = hr_api.g_varchar2) then
322: p_rec.source_table_name := g_old_rec.source_table_name;
323: End If;
324: If (p_rec.comment_text = hr_api.g_varchar2) then
325: p_rec.comment_text := g_old_rec.comment_text;
326: End If;
327: --
328: -- Return the plsql record structure.

Line 451: Raise HR_Api.Validate_Enabled;

447: --
448: -- If we are validating then raise the Validate_Enabled exception
449: --
450: If p_validate then
451: Raise HR_Api.Validate_Enabled;
452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception

Line 456: When HR_Api.Validate_Enabled Then

452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception
456: When HR_Api.Validate_Enabled Then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --

Line 604: Raise HR_Api.Validate_Enabled;

600: --
601: -- If we are validating then raise the Validate_Enabled exception
602: --
603: If p_validate then
604: Raise HR_Api.Validate_Enabled;
605: End If;
606: --
607: End If;
608: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 610: When HR_Api.Validate_Enabled Then

606: --
607: End If;
608: hr_utility.set_location(' Leaving:'||l_proc, 10);
609: Exception
610: When HR_Api.Validate_Enabled Then
611: --
612: -- As the Validate_Enabled exception has been raised
613: -- we must rollback to the savepoint
614: --

Line 646: p_source_table_name in varchar2 default hr_api.g_varchar2,

642: -- --------------------------------------------------------------------------
643: Procedure upd
644: (
645: p_comment_id in out nocopy number,
646: p_source_table_name in varchar2 default hr_api.g_varchar2,
647: p_comment_text in varchar2 default hr_api.g_varchar2,
648: p_validate in boolean default false
649: ) is
650: --

Line 647: p_comment_text in varchar2 default hr_api.g_varchar2,

643: Procedure upd
644: (
645: p_comment_id in out nocopy number,
646: p_source_table_name in varchar2 default hr_api.g_varchar2,
647: p_comment_text in varchar2 default hr_api.g_varchar2,
648: p_validate in boolean default false
649: ) is
650: --
651: l_rec g_rec_type;

Line 751: Raise HR_Api.Validate_Enabled;

747: --
748: -- If we are validating then raise the Validate_Enabled exception
749: --
750: If p_validate then
751: Raise HR_Api.Validate_Enabled;
752: End If;
753: End If;
754: --
755: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 757: When HR_Api.Validate_Enabled Then

753: End If;
754: --
755: hr_utility.set_location(' Leaving:'||l_proc, 10);
756: Exception
757: When HR_Api.Validate_Enabled Then
758: --
759: -- As the Validate_Enabled exception has been raised
760: -- we must rollback to the savepoint
761: --