APPS.HR_QSF_SHD dependencies on HR_QUEST_FIELDS

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_FIELDS_FK') Then
22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.

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

20: --
21: If (p_constraint_name = 'HR_QUEST_FIELDS_FK') Then
22: fnd_message.set_name('PER', 'PER_52416_QSF_INVAL_TEMP_ID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_PK') Then
25: -- Unlikely to fail.
26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');

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

26: hr_utility.set_message('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then
34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');

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

29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_SQL_FLAG_CHK') Then
31: fnd_message.set_name('PER', 'PER_52417_QSF_REQD_FLAG_INVAL');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_FIELDS_TYPE_CHK') Then
34: fnd_message.set_name('PER', 'PER_52418_QSF_TYPE_INVALID');
35: fnd_message.raise_error;
36: Else
37: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');

Line 68: from hr_quest_fields

64: html_text,
65: sql_required_flag,
66: sql_text,
67: object_version_number
68: from hr_quest_fields
69: where field_id = p_field_id;
70: --
71: l_proc varchar2(72) := g_package||'api_updating';
72: l_fct_ret boolean;

Line 145: from hr_quest_fields

141: html_text,
142: sql_required_flag,
143: sql_text,
144: object_version_number
145: from hr_quest_fields
146: where field_id = p_field_id
147: for update nowait;
148: --
149: l_proc varchar2(72) := g_package||'lck';

Line 191: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_fields');
192: hr_utility.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------