APPS.BEN_XEL_SHD dependencies on BEN_EXT_WHERE_CLAUSE

Line 46: ben_ext_where_clause xwc

42:
43: cursor c3 is
44: select xel.name
45: from ben_ext_data_elmt xel,
46: ben_ext_where_clause xwc
47: where g_old_rec.ext_data_elmt_id = xwc.cond_ext_data_elmt_id
48: and xel.ext_data_elmt_id = xwc.ext_data_elmt_id;
49:
50: l_proc varchar2(72) := g_package||'constraint_error';

Line 69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then

65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;

Line 79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then

75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');