APPS.PAY_EVP_SHD dependencies on PAY_EVENT_PROCEDURES

Line 21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 61: from pay_event_procedures

57: ,business_group_id
58: ,legislation_code
59: ,column_name
60: ,object_version_number
61: from pay_event_procedures
62: where event_procedure_id = p_event_procedure_id;
63: --
64: l_fct_ret boolean;
65: --

Line 133: from pay_event_procedures

129: ,business_group_id
130: ,legislation_code
131: ,column_name
132: ,object_version_number
133: from pay_event_procedures
134: where event_procedure_id = p_event_procedure_id
135: for update nowait;
136: --
137: l_proc varchar2(72) := g_package||'lck';

Line 176: fnd_message.set_token('TABLE_NAME', 'pay_event_procedures');

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