APPS.HR_QSA_SHD dependencies on HR_QUEST_ANSWERS

Line 21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');

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

20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur

Line 27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then

23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');

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

29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');

Line 67: from hr_quest_answers

63: questionnaire_template_id,
64: type,
65: type_object_id,
66: business_group_id
67: from hr_quest_answers
68: where questionnaire_answer_id = p_questionnaire_answer_id;
69: --
70: l_proc varchar2(72) := g_package||'api_updating';
71: l_fct_ret boolean;

Line 135: from hr_quest_answers

131: questionnaire_template_id,
132: type,
133: type_object_id,
134: business_group_id
135: from hr_quest_answers
136: where questionnaire_answer_id = p_questionnaire_answer_id
137: for update nowait;
138: --
139: l_proc varchar2(72) := g_package||'lck';

Line 180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');

176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');
181: hr_utility.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------