APPS.PAY_BCT_SHD dependencies on PAY_BATCH_CONTROL_TOTALS

Line 32: If (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_FK1') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_FK1') Then
33: fnd_message.set_name('PAY', 'PAY_34575_BHT_INVALID_HEADER');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 35: ElsIf (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_PK') Then

31: --
32: If (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_FK1') Then
33: fnd_message.set_name('PAY', 'PAY_34575_BHT_INVALID_HEADER');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'PAY_BATCH_CONTROL_TOTALS_PK') Then
36: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','10');
39: fnd_message.raise_error;

Line 73: from pay_batch_control_totals

69: ,control_status
70: ,control_total
71: ,control_type
72: ,object_version_number
73: from pay_batch_control_totals
74: where batch_control_id = p_batch_control_id;
75: --
76: l_fct_ret boolean;
77: --

Line 144: from pay_batch_control_totals

140: ,control_status
141: ,control_total
142: ,control_type
143: ,object_version_number
144: from pay_batch_control_totals
145: where batch_control_id = p_batch_control_id
146: for update nowait;
147: --
148: l_proc varchar2(72) := g_package||'lck';

Line 187: fnd_message.set_token('TABLE_NAME', 'pay_batch_control_totals');

183: -- The object is locked therefore we need to supply a meaningful
184: -- error message.
185: --
186: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
187: fnd_message.set_token('TABLE_NAME', 'pay_batch_control_totals');
188: fnd_message.raise_error;
189: End lck;
190: --
191: -- ----------------------------------------------------------------------------