APPS.BEN_XER_SHD dependencies on BEN_EXT_RCD_IN_FILE

Line 35: ben_ext_rcd_in_file xrf,

31: l_proc varchar2(72) := g_package||'constraint_error';
32: cursor c1 is
33: select xfi.name
34: from ben_ext_file xfi,
35: ben_ext_rcd_in_file xrf,
36: ben_ext_data_elmt_in_rcd xdr
37: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
38: and xdr.ext_rcd_id = xdr.ext_rcd_id
39: and xrf.sort1_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id

Line 45: ben_ext_rcd_in_file xrf,

41:
42: cursor c2 is
43: select xfi.name
44: from ben_ext_file xfi,
45: ben_ext_rcd_in_file xrf,
46: ben_ext_data_elmt_in_rcd xdr
47: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
48: and xdr.ext_rcd_id = xdr.ext_rcd_id
49: and xrf.sort2_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id

Line 55: ben_ext_rcd_in_file xrf,

51:
52: cursor c3 is
53: select xfi.name
54: from ben_ext_file xfi,
55: ben_ext_rcd_in_file xrf,
56: ben_ext_data_elmt_in_rcd xdr
57: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
58: and xdr.ext_rcd_id = xdr.ext_rcd_id
59: and xrf.sort3_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id

Line 65: ben_ext_rcd_in_file xrf,

61:
62: cursor c4 is
63: select xfi.name
64: from ben_ext_file xfi,
65: ben_ext_rcd_in_file xrf,
66: ben_ext_data_elmt_in_rcd xdr
67: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
68: and xdr.ext_rcd_id = xdr.ext_rcd_id
69: and xrf.sort4_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id

Line 75: ben_ext_rcd_in_file xrf,

71:
72: cursor c5 is
73: select xfi.name
74: from ben_ext_file xfi,
75: ben_ext_rcd_in_file xrf,
76: ben_ext_where_clause xwc
77: where xwc.cond_ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
78: and xwc.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id
79: and xrf.ext_file_id = xfi.ext_file_id;

Line 86: If (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK1') Then

82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --
86: If (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK1') Then
87: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
88: fnd_message.set_token('PROCEDURE', l_proc);
89: fnd_message.set_token('STEP','5');
90: fnd_message.raise_error;

Line 111: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK4') Then

107: ben_utility.child_exists_error(p_table_name => 'BEN_EXT_INCL_CHG');
108: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
109: fnd_message.set_name('BEN', 'BEN_92479_XWC_EXISTS');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK4') Then
112: open c1;
113: fetch c1 into l_name;
114: close c1;
115: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');

Line 118: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK5') Then

114: close c1;
115: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');
116: fnd_message.set_token('FILE_NAME', l_name);
117: fnd_message.raise_error;
118: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK5') Then
119: open c2;
120: fetch c2 into l_name;
121: close c2;
122: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');

Line 125: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK6') Then

121: close c2;
122: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');
123: fnd_message.set_token('FILE_NAME', l_name);
124: fnd_message.raise_error;
125: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK6') Then
126: open c3;
127: fetch c3 into l_name;
128: close c3;
129: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');

Line 132: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK7') Then

128: close c3;
129: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');
130: fnd_message.set_token('FILE_NAME', l_name);
131: fnd_message.raise_error;
132: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK7') Then
133: open c4;
134: fetch c4 into l_name;
135: close c4;
136: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');