APPS.PER_PRV_SHD dependencies on PER_PERFORMANCE_REVIEWS

Line 36: If (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_FK2') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_FK2') Then
37: hr_utility.set_location(l_proc, 10);
38: hr_utility.set_message(800,'HR_52396_PRV_INVALID_REVIEW');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_PK') Then

Line 40: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_PK') Then

36: If (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_FK2') Then
37: hr_utility.set_location(l_proc, 10);
38: hr_utility.set_message(800,'HR_52396_PRV_INVALID_REVIEW');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_PK') Then
41: hr_utility.set_location(l_proc, 15);
42: hr_utility.set_message(800,'HR_52395_PRV_INVALID_PK');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_DT1') Then

Line 44: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_DT1') Then

40: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_PK') Then
41: hr_utility.set_location(l_proc, 15);
42: hr_utility.set_message(800,'HR_52395_PRV_INVALID_PK');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PERFORMANCE_REVIEWS_DT1') Then
45: hr_utility.set_location(l_proc, 15);
46: hr_utility.set_message(800,'HR_52397_PRV_INVALID_PERSON');
47: hr_utility.raise_error;
48: Else

Line 112: from per_performance_reviews

108: attribute28,
109: attribute29,
110: attribute30,
111: object_version_number
112: from per_performance_reviews
113: where performance_review_id = p_performance_review_id;
114: --
115: l_proc varchar2(72) := g_package||'api_updating';
116: l_fct_ret boolean;

Line 219: from per_performance_reviews

215: attribute28,
216: attribute29,
217: attribute30,
218: object_version_number
219: from per_performance_reviews
220: where performance_review_id = p_performance_review_id
221: for update nowait;
222: --
223: l_proc varchar2(72) := g_package||'lck';

Line 262: hr_utility.set_message_token('TABLE_NAME', 'per_performance_reviews');

258: -- The object is locked therefore we need to supply a meaningful
259: -- error message.
260: --
261: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
262: hr_utility.set_message_token('TABLE_NAME', 'per_performance_reviews');
263: hr_utility.raise_error;
264: End lck;
265: --
266: -- ----------------------------------------------------------------------------