APPS.PER_SUB_SHD dependencies on PER_SUBJECTS_TAKEN

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

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

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

35: --
36: If (p_constraint_name = 'PER_SUBJECTS_TAKEN_FK1') Then
37: hr_utility.set_message(801, 'HR_51813_SUB_QUAL_ID_REF');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_SUBJECTS_TAKEN_PK') Then
40: hr_utility.set_message(801, 'HR_51814_SUB_SUB_TAKEN_ID_PK');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_SUBJECTS_TAKEN_UK1') Then
43: hr_utility.set_message(801, 'HR_51815_SUB_REC_NOT_UNIQ');

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

38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_SUBJECTS_TAKEN_PK') Then
40: hr_utility.set_message(801, 'HR_51814_SUB_SUB_TAKEN_ID_PK');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_SUBJECTS_TAKEN_UK1') Then
43: hr_utility.set_message(801, 'HR_51815_SUB_REC_NOT_UNIQ');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PER_SUB_START_DATES') Then
46: hr_utility.set_message(801, 'HR_51816_SUB_START_DATE_INV');

Line 123: from per_subjects_taken

119: sub_information17,
120: sub_information18,
121: sub_information19,
122: sub_information20
123: from per_subjects_taken
124: where subjects_taken_id = p_subjects_taken_id;
125: --
126: l_proc varchar2(72) := g_package||'api_updating';
127: l_fct_ret boolean;

Line 243: from per_subjects_taken

239: sub_information17,
240: sub_information18,
241: sub_information19,
242: sub_information20
243: from per_subjects_taken
244: where subjects_taken_id = p_subjects_taken_id
245: for update nowait;
246: --
247: l_proc varchar2(72) := g_package||'lck';

Line 286: hr_utility.set_message_token('TABLE_NAME', 'per_subjects_taken');

282: -- The object is locked therefore we need to supply a meaningful
283: -- error message.
284: --
285: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
286: hr_utility.set_message_token('TABLE_NAME', 'per_subjects_taken');
287: hr_utility.raise_error;
288: End lck;
289: --
290: -- ----------------------------------------------------------------------------