APPS.HXC_HRR_SHD dependencies on HXC_RESOURCE_RULES

Line 22: If (p_constraint_name = 'HXC_RESOURCE_RULES_FK1') Then

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

Line 27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then

23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 67: from hxc_resource_rules

63: ,resource_type
64: ,start_date
65: ,end_date
66: ,object_version_number
67: from hxc_resource_rules
68: where resource_rule_id = p_resource_rule_id;
69: --
70: l_fct_ret boolean;
71: --

Line 144: from hxc_resource_rules

140: ,resource_type
141: ,start_date
142: ,end_date
143: ,object_version_number
144: from hxc_resource_rules
145: where resource_rule_id = p_resource_rule_id
146: for update nowait;
147: --
148: l_proc varchar2(72);

Line 193: fnd_message.set_token('TABLE_NAME', 'hxc_resource_rules');

189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_resource_rules');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------