APPS.PER_CNL_SHD dependencies on PER_RI_CONFIG_LOCATIONS

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

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

Line 76: from per_ri_config_locations

72: ,loc_information18
73: ,loc_information19
74: ,loc_information20
75: ,object_version_number
76: from per_ri_config_locations
77: where location_id = p_location_id;
78: --
79: l_fct_ret boolean;
80: --

Line 168: from per_ri_config_locations

164: ,loc_information18
165: ,loc_information19
166: ,loc_information20
167: ,object_version_number
168: from per_ri_config_locations
169: where location_id = p_location_id
170: for update nowait;
171: --
172: l_proc varchar2(72) := g_package||'lck';

Line 217: fnd_message.set_token('TABLE_NAME', 'per_ri_config_locations');

213: -- The object is locked therefore we need to supply a meaningful
214: -- error message.
215: --
216: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
217: fnd_message.set_token('TABLE_NAME', 'per_ri_config_locations');
218: fnd_message.raise_error;
219: End lck;
220: --
221: -- ----------------------------------------------------------------------------