APPS.PER_CHK_SHD dependencies on PER_CHECKLIST_ITEMS

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_CHECKLIST_ITEMS_PK') Then
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');

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

35: --
36: If (p_constraint_name = 'PER_CHECKLIST_ITEMS_PK') Then
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 105: from per_checklist_items

101: attribute27,
102: attribute28,
103: attribute29,
104: attribute30
105: from per_checklist_items
106: where checklist_item_id = p_checklist_item_id;
107: --
108: l_proc varchar2(72) := g_package||'api_updating';
109: l_fct_ret boolean;

Line 214: from per_checklist_items

210: attribute27,
211: attribute28,
212: attribute29,
213: attribute30
214: from per_checklist_items
215: where checklist_item_id = p_checklist_item_id
216: for update nowait;
217: --
218: l_proc varchar2(72) := g_package||'lck';

Line 257: fnd_message.set_token('TABLE_NAME', 'per_checklist_items');

253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'per_checklist_items');
258: fnd_message.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------