APPS.BEN_ORG_DELETE dependencies on BEN_EXT_DATA_ELMT

Line 258: is select 1 from BEN_EXT_DATA_ELMT

254: is select 1 from BEN_EXT_CRIT_VAL
255: where business_group_id = p_bg_id;
256:
257: cursor c64(p_bg_id NUMBER)
258: is select 1 from BEN_EXT_DATA_ELMT
259: where business_group_id = p_bg_id;
260:
261: cursor c65(p_bg_id NUMBER)
262: is select 1 from BEN_EXT_RSLT

Line 282: is select 1 from BEN_EXT_DATA_ELMT_DECD

278: is select 1 from BEN_EXT_CRIT_CMBN
279: where business_group_id = p_bg_id;
280:
281: cursor c70(p_bg_id NUMBER)
282: is select 1 from BEN_EXT_DATA_ELMT_DECD
283: where business_group_id = p_bg_id;
284:
285: cursor c71(p_bg_id NUMBER)
286: is select 1 from BEN_EXT_DATA_ELMT_IN_RCD

Line 286: is select 1 from BEN_EXT_DATA_ELMT_IN_RCD

282: is select 1 from BEN_EXT_DATA_ELMT_DECD
283: where business_group_id = p_bg_id;
284:
285: cursor c71(p_bg_id NUMBER)
286: is select 1 from BEN_EXT_DATA_ELMT_IN_RCD
287: where business_group_id = p_bg_id;
288:
289: cursor c72(p_bg_id NUMBER)
290: is select 1 from BEN_EXT_RSLT_DTL

Line 2126: -- Testing for values in BEN_EXT_DATA_ELMT

2122: --
2123: close c63;
2124:
2125: --
2126: -- Testing for values in BEN_EXT_DATA_ELMT
2127: --
2128: open c64(p_bg_id);
2129: --
2130: fetch c64 into l_temp;

Line 2134: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT');

2130: fetch c64 into l_temp;
2131: if c64%found then
2132: close c64;
2133: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2134: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT');
2135: fnd_message.raise_error;
2136: end if;
2137: --
2138: close c64;

Line 2216: -- Testing for values in BEN_EXT_DATA_ELMT_DECD

2212: --
2213: close c69;
2214:
2215: --
2216: -- Testing for values in BEN_EXT_DATA_ELMT_DECD
2217: --
2218: open c70(p_bg_id);
2219: --
2220: fetch c70 into l_temp;

Line 2224: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_DECD');

2220: fetch c70 into l_temp;
2221: if c70%found then
2222: close c70;
2223: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2224: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_DECD');
2225: fnd_message.raise_error;
2226: end if;
2227: --
2228: close c70;

Line 2231: -- Testing for values in BEN_EXT_DATA_ELMT_IN_RCD

2227: --
2228: close c70;
2229:
2230: --
2231: -- Testing for values in BEN_EXT_DATA_ELMT_IN_RCD
2232: --
2233: open c71(p_bg_id);
2234: --
2235: fetch c71 into l_temp;

Line 2239: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_IN_RCD');

2235: fetch c71 into l_temp;
2236: if c71%found then
2237: close c71;
2238: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2239: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_IN_RCD');
2240: fnd_message.raise_error;
2241: end if;
2242: --
2243: close c71;

Line 5766: delete from BEN_EXT_DATA_ELMT

5762:
5763: delete from BEN_EXT_CRIT_VAL
5764: where business_group_id = p_bg_id;
5765:
5766: delete from BEN_EXT_DATA_ELMT
5767: where business_group_id = p_bg_id;
5768:
5769: delete from BEN_EXT_RSLT
5770: where business_group_id = p_bg_id;

Line 5784: delete from BEN_EXT_DATA_ELMT_DECD

5780:
5781: delete from BEN_EXT_CRIT_CMBN
5782: where business_group_id = p_bg_id;
5783:
5784: delete from BEN_EXT_DATA_ELMT_DECD
5785: where business_group_id = p_bg_id;
5786:
5787: delete from BEN_EXT_DATA_ELMT_IN_RCD
5788: where business_group_id = p_bg_id;

Line 5787: delete from BEN_EXT_DATA_ELMT_IN_RCD

5783:
5784: delete from BEN_EXT_DATA_ELMT_DECD
5785: where business_group_id = p_bg_id;
5786:
5787: delete from BEN_EXT_DATA_ELMT_IN_RCD
5788: where business_group_id = p_bg_id;
5789:
5790: delete from BEN_EXT_RSLT_DTL
5791: where business_group_id = p_bg_id;