APPS.HXC_HAS_SHD dependencies on HXC_APPROVAL_STYLES

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

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'HXC_APPROVAL_STYLES_PK') 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 70: from hxc_approval_styles

66: ,description
67: ,run_recipient_extensions
68: ,admin_role
69: ,error_admin_role
70: from hxc_approval_styles
71: where approval_style_id = p_approval_style_id;
72: --
73: l_fct_ret boolean;
74: --

Line 144: from hxc_approval_styles

140: ,description
141: ,run_recipient_extensions
142: ,admin_role
143: ,error_admin_role
144: from hxc_approval_styles
145: where approval_style_id = p_approval_style_id
146: for update nowait;
147: --
148: l_proc varchar2(72);

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

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_approval_styles');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------