APPS.HXC_HAC_SHD dependencies on HXC_APPROVAL_COMPS

Line 33: If (p_constraint_name = 'HXC_APPROVAL_COMPS_FK1') Then

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

Line 38: ElsIf (p_constraint_name = 'HXC_APPROVAL_COMPS_FK2') Then

34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_APPROVAL_COMPS_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;

Line 43: ElsIf (p_constraint_name = 'HXC_APPROVAL_COMPS_PK') Then

39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_APPROVAL_COMPS_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;

Line 86: from hxc_approval_comps

82: ,time_category_id
83: ,parent_comp_id
84: ,parent_comp_ovn
85: ,run_recipient_extensions
86: from hxc_approval_comps
87: where approval_comp_id = p_approval_comp_id;
88: --
89: l_fct_ret boolean;
90: --

Line 166: from hxc_approval_comps

162: ,time_category_id
163: ,parent_comp_id
164: ,parent_comp_ovn
165: ,run_recipient_extensions
166: from hxc_approval_comps
167: where approval_comp_id = p_approval_comp_id
168: for update nowait;
169: --
170: l_proc varchar2(72);

Line 215: fnd_message.set_token('TABLE_NAME', 'hxc_approval_comps');

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