APPS.HXC_APS_SHD dependencies on HXC_APPROVAL_PERIOD_SETS

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

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

60: select
61: approval_period_set_id
62: ,name
63: ,object_version_number
64: from hxc_approval_period_sets
65: where approval_period_set_id = p_approval_period_set_id;
66: --
67: l_fct_ret boolean;
68: --

Line 132: from hxc_approval_period_sets

128: select
129: approval_period_set_id
130: ,name
131: ,object_version_number
132: from hxc_approval_period_sets
133: where approval_period_set_id = p_approval_period_set_id
134: for update nowait;
135: --
136: l_proc varchar2(72);

Line 181: fnd_message.set_token('TABLE_NAME', 'hxc_approval_period_sets');

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