APPS.PER_DPF_SHD dependencies on PER_DEPLOYMENT_FACTORS

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

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

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

35: --
36: If (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK1') Then
37: hr_utility.set_message(801,'HR_52026_DPF_CHK_JOB_ID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK2') Then
40: hr_utility.set_message(801,'HR_52024_DPF_CHK_POSITION_ID');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_FK3') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;

Line 47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then

43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','15');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');

Line 50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then

46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_PK') Then
48: hr_utility.set_message(801, 'HR_52041_DPF_DEP_FACTOR_PK');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'PER_DEPLOYMENT_FACTORS_UK') Then
51: hr_utility.set_message(801, 'HR_52043_DPF_DEP_FACTOR_UK');
52: hr_utility.raise_error;
53: ElsIf (p_constraint_name = 'PER_DPF_AVAILABLE_FOR_TRANSFER') Then
54: hr_utility.set_message(801, 'HR_52044_DPF_DEP_AVAIL_TRANS');

Line 162: from per_deployment_factors

158: attribute17,
159: attribute18,
160: attribute19,
161: attribute20
162: from per_deployment_factors
163: where deployment_factor_id = p_deployment_factor_id;
164: --
165: l_proc varchar2(72) := g_package||'api_updating';
166: l_fct_ret boolean;

Line 286: from per_deployment_factors

282: attribute17,
283: attribute18,
284: attribute19,
285: attribute20
286: from per_deployment_factors
287: where deployment_factor_id = p_deployment_factor_id
288: for update nowait;
289: --
290: l_proc varchar2(72) := g_package||'lck';

Line 329: hr_utility.set_message_token('TABLE_NAME', 'per_deployment_factors');

325: -- The object is locked therefore we need to supply a meaningful
326: -- error message.
327: --
328: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
329: hr_utility.set_message_token('TABLE_NAME', 'per_deployment_factors');
330: hr_utility.raise_error;
331: End lck;
332: --
333: -- ----------------------------------------------------------------------------