APPS.IRC_RAV_SHD dependencies on IRC_VAC_REC_AREA_VALUES

Line 32: If (p_constraint_name = 'IRC_VAC_REC_AREA_VALUES_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'IRC_VAC_REC_AREA_VALUES_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 65: from irc_vac_rec_area_values

61: ,vacancy_id
62: ,hierarchy_version_id
63: ,hierarchy_name
64: ,object_version_number
65: from irc_vac_rec_area_values
66: where vac_rec_area_id = p_vac_rec_area_id;
67: --
68: l_fct_ret boolean;
69: --

Line 135: from irc_vac_rec_area_values

131: ,vacancy_id
132: ,hierarchy_version_id
133: ,hierarchy_name
134: ,object_version_number
135: from irc_vac_rec_area_values
136: where vac_rec_area_id = p_vac_rec_area_id
137: for update nowait;
138: --
139: l_proc varchar2(72) := g_package||'lck';

Line 184: fnd_message.set_token('TABLE_NAME', 'irc_vac_rec_area_values');

180: -- The object is locked therefore we need to supply a meaningful
181: -- error message.
182: --
183: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
184: fnd_message.set_token('TABLE_NAME', 'irc_vac_rec_area_values');
185: fnd_message.raise_error;
186: End lck;
187: --
188: -- ----------------------------------------------------------------------------