APPS.BEN_CSO_SHD dependencies on BEN_CWB_STOCK_OPTN_DTLS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'BEN_CWB_STOCK_OPTN_DTLS_PK') 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 106: from ben_cwb_stock_optn_dtls

102: ,cso_attribute27
103: ,cso_attribute28
104: ,cso_attribute29
105: ,cso_attribute30
106: from ben_cwb_stock_optn_dtls
107: where cwb_stock_optn_dtls_id = p_cwb_stock_optn_dtls_id;
108: --
109: l_fct_ret boolean;
110: --

Line 228: from ben_cwb_stock_optn_dtls

224: ,cso_attribute27
225: ,cso_attribute28
226: ,cso_attribute29
227: ,cso_attribute30
228: from ben_cwb_stock_optn_dtls
229: where cwb_stock_optn_dtls_id = p_cwb_stock_optn_dtls_id
230: for update nowait;
231: --
232: l_proc varchar2(72) := g_package||'lck';

Line 277: fnd_message.set_token('TABLE_NAME', 'ben_cwb_stock_optn_dtls');

273: -- The object is locked therefore we need to supply a meaningful
274: -- error message.
275: --
276: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
277: fnd_message.set_token('TABLE_NAME', 'ben_cwb_stock_optn_dtls');
278: fnd_message.raise_error;
279: End lck;
280: --
281: -- ----------------------------------------------------------------------------