APPS.PER_STB_SHD dependencies on PER_RI_SETUP_TASKS

Line 20: If (p_constraint_name = 'PER_RI_SETUP_TASKS_PK') Then

16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: --
20: If (p_constraint_name = 'PER_RI_SETUP_TASKS_PK') Then
21: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
22: fnd_message.set_token('PROCEDURE', l_proc);
23: fnd_message.set_token('STEP','5');
24: fnd_message.raise_error;

Line 57: from per_ri_setup_tasks

53: ,setup_task_last_modified_date
54: ,setup_task_type
55: ,setup_task_action
56: ,object_version_number
57: from per_ri_setup_tasks
58: where setup_task_code = p_setup_task_code;
59: --
60: l_fct_ret boolean;
61: --

Line 131: from per_ri_setup_tasks

127: ,setup_task_last_modified_date
128: ,setup_task_type
129: ,setup_task_action
130: ,object_version_number
131: from per_ri_setup_tasks
132: where setup_task_code = p_setup_task_code
133: for update nowait;
134: --
135: l_proc varchar2(72) := g_package||'lck';

Line 180: fnd_message.set_token('TABLE_NAME', 'per_ri_setup_tasks');

176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
180: fnd_message.set_token('TABLE_NAME', 'per_ri_setup_tasks');
181: fnd_message.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------