APPS.GHR_PDC_SHD dependencies on GHR_PD_CLASSIFICATIONS

Line 39: If (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_FK1') Then

35: --
36: Begin
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_FK1') Then
40: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP','5');
43: hr_utility.raise_error;

Line 44: ElsIf (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_FK2') Then

40: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP','5');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_FK2') Then
45: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE', l_proc);
47: hr_utility.set_message_token('STEP','5');
48: hr_utility.raise_error;

Line 49: ElsIf (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_PK') Then

45: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE', l_proc);
47: hr_utility.set_message_token('STEP','5');
48: hr_utility.raise_error;
49: ElsIf (p_constraint_name = 'GHR_PD_CLASSIFICATIONS_PK') Then
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','10');
53: hr_utility.raise_error;

Line 91: from ghr_pd_classifications

87: pay_plan,
88: occupational_code,
89: grade_level,
90: object_version_number
91: from ghr_pd_classifications
92: where pd_classification_id = p_pd_classification_id;
93: --
94: l_proc varchar2(72) := g_package||'api_updating';
95: l_fct_ret boolean;

Line 168: from ghr_pd_classifications

164: pay_plan,
165: occupational_code,
166: grade_level,
167: object_version_number
168: from ghr_pd_classifications
169: where pd_classification_id = p_pd_classification_id
170: for update nowait;
171: --
172: l_proc varchar2(72) := g_package||'lck';

Line 212: hr_utility.set_message_token('TABLE_NAME', 'ghr_pd_classifications');

208: -- The object is locked therefore we need to supply a meaningful
209: -- error message.
210: --
211: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
212: hr_utility.set_message_token('TABLE_NAME', 'ghr_pd_classifications');
213: hr_utility.raise_error;
214: End lck;
215: --
216: -- ----------------------------------------------------------------------------