APPS.PER_AST_SHD dependencies on PER_ASSESSMENT_TYPES

Line 24: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_FK2') Then

20: --
21: If (p_constraint_name = 'PER_ASS_TYPES_RATE_NULL_CHK') Then
22: hr_utility.set_message(801, 'HR_51508_AST_R_ASSCLASS_ERR2');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_FK2') Then
25: hr_utility.set_message(801, 'HR_51507_AST_RATE_ID_INVAL');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_ASS_TYPES_RATE_NOTNULL_CHK') Then
28: hr_utility.set_message(801, 'HR_51506_AST_R_ASSCLAS_ERR');

Line 30: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_FK3') Then

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_ASS_TYPES_RATE_NOTNULL_CHK') Then
28: hr_utility.set_message(801, 'HR_51506_AST_R_ASSCLAS_ERR');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_FK3') Then
31: hr_utility.set_message(801, 'HR_51504_AST_WEIGHT_ID_INVAL');
32: hr_utility.raise_error;
33: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_NAME_UK1') Then
34: hr_utility.set_message(801, 'HR_51499_AST_NAME_NOT_UNIQ');

Line 33: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_NAME_UK1') Then

29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_FK3') Then
31: hr_utility.set_message(801, 'HR_51504_AST_WEIGHT_ID_INVAL');
32: hr_utility.raise_error;
33: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPES_NAME_UK1') Then
34: hr_utility.set_message(801, 'HR_51499_AST_NAME_NOT_UNIQ');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PER_ASSESSMENT_TYPE_PK') Then
37: -- The primary key is generated via a sequence, so it should never

Line 110: from per_assessment_types

106: type,
107: line_score_formula_id,
108: default_job_competencies,
109: available_flag
110: from per_assessment_types
111: where assessment_type_id = p_assessment_type_id;
112: --
113: l_proc varchar2(72) := g_package||'api_updating';
114: l_fct_ret boolean;

Line 223: from per_assessment_types

219: type,
220: line_score_formula_id,
221: default_job_competencies,
222: available_flag
223: from per_assessment_types
224: where assessment_type_id = p_assessment_type_id
225: for update nowait;
226: --
227: l_proc varchar2(72) := g_package||'lck';

Line 266: hr_utility.set_message_token('TABLE_NAME', 'per_assessment_types');

262: -- The object is locked therefore we need to supply a meaningful
263: -- error message.
264: --
265: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
266: hr_utility.set_message_token('TABLE_NAME', 'per_assessment_types');
267: hr_utility.raise_error;
268: End lck;
269: --
270: -- ----------------------------------------------------------------------------