APPS.HXC_HRP_SHD dependencies on HXC_RECURRING_PERIODS

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

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_RECURRING_PERIODS_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;

Line 57: from hxc_recurring_periods

53: ,end_date
54: ,period_type
55: ,duration_in_days
56: ,object_version_number
57: from hxc_recurring_periods
58: where recurring_period_id = p_recurring_period_id;
59: --
60: l_fct_ret boolean;
61: --

Line 129: from hxc_recurring_periods

125: ,end_date
126: ,period_type
127: ,duration_in_days
128: ,object_version_number
129: from hxc_recurring_periods
130: where recurring_period_id = p_recurring_period_id
131: for update nowait;
132: --
133: l_proc varchar2(72);

Line 178: fnd_message.set_token('TABLE_NAME', 'hxc_recurring_periods');

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