APPS.PER_PDM_SHD dependencies on PER_PERSON_DLVRY_METHODS

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_PERSON_DLVRY_METHODS_PK') Then
22: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;

Line 26: ElsIf (p_constraint_name = 'PER_PERSON_DLVRY_METHODS_UK1') Then

22: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PER_PERSON_DLVRY_METHODS_UK1') Then
27: hr_utility.set_message(800, 'HR_52392_PDM_DUP_DLVRY_METHOD');
28: --hr_utility.set_message_token('PROCEDURE', l_proc);
29: --hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;

Line 31: ElsIf (p_constraint_name = 'PER_PERSON_DLVRY_METHODS_FK1') Then

27: hr_utility.set_message(800, 'HR_52392_PDM_DUP_DLVRY_METHOD');
28: --hr_utility.set_message_token('PROCEDURE', l_proc);
29: --hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PER_PERSON_DLVRY_METHODS_FK1') Then
32: hr_utility.set_message(800, 'HR_52361_PTU_INVALID_PERSON_ID');
33: --hr_utility.set_message_token('PROCEDURE', l_proc);
34: --hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;

Line 92: from per_person_dlvry_methods

88: attribute17,
89: attribute18,
90: attribute19,
91: attribute20
92: from per_person_dlvry_methods
93: where delivery_method_id = p_delivery_method_id;
94: --
95: l_proc varchar2(72) := g_package||'api_updating';
96: l_fct_ret boolean;

Line 193: from per_person_dlvry_methods

189: attribute17,
190: attribute18,
191: attribute19,
192: attribute20
193: from per_person_dlvry_methods
194: where delivery_method_id = p_delivery_method_id
195: for update nowait;
196: --
197: l_proc varchar2(72) := g_package||'lck';

Line 236: hr_utility.set_message_token('TABLE_NAME', 'per_person_dlvry_methods');

232: -- The object is locked therefore we need to supply a meaningful
233: -- error message.
234: --
235: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
236: hr_utility.set_message_token('TABLE_NAME', 'per_person_dlvry_methods');
237: hr_utility.raise_error;
238: End lck;
239: --
240: -- ----------------------------------------------------------------------------