APPS.PER_VGR_SHD dependencies on PER_VALID_GRADES

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_VALID_GRADES_FK1') Then
37: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK2') Then
40: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');

Line 39: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK2') Then

35: --
36: If (p_constraint_name = 'PER_VALID_GRADES_FK1') Then
37: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK2') Then
40: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK50') Then
43: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');

Line 42: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK50') Then

38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK2') Then
40: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK50') Then
43: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK51') Then
46: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');

Line 45: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK51') Then

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK50') Then
43: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK51') Then
46: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_VALID_GRADES_PK') Then
49: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

Line 48: ElsIf (p_constraint_name = 'PER_VALID_GRADES_PK') Then

44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PER_VALID_GRADES_FK51') Then
46: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_VALID_GRADES_PK') Then
49: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
50: hr_utility.raise_error;
51: Else
52: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 109: from per_valid_grades

105: attribute18,
106: attribute19,
107: attribute20,
108: object_version_number
109: from per_valid_grades
110: where valid_grade_id = p_valid_grade_id;
111: --
112: l_proc varchar2(72) := g_package||'api_updating';
113: l_fct_ret boolean;

Line 212: from per_valid_grades

208: attribute18,
209: attribute19,
210: attribute20,
211: object_version_number
212: from per_valid_grades
213: where valid_grade_id = p_valid_grade_id
214: for update nowait;
215: --
216: l_proc varchar2(72) := g_package||'lck';

Line 258: hr_utility.set_message_token('TABLE_NAME', 'per_valid_grades');

254: -- The object is locked therefore we need to supply a meaningful
255: -- error message.
256: --
257: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
258: hr_utility.set_message_token('TABLE_NAME', 'per_valid_grades');
259: hr_utility.raise_error;
260: End lck;
261: --
262: -- ----------------------------------------------------------------------------