DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_API dependencies on BEN_ONLINE_WARNINGS

Line 2010: DELETE ben_online_warnings

2006: hr_utility.set_location('Entering:'|| l_proc, 10);
2007: --
2008: if p_person_id is not null and p_crt_ord_warning is not null then
2009: if p_crt_ord_warning = 'CLEAR' then
2010: DELETE ben_online_warnings
2011: WHERE session_id = p_person_id;
2012: else
2013: INSERT INTO ben_online_warnings(session_id, message_text)
2014: VALUES (p_person_id, p_crt_ord_warning);

Line 2013: INSERT INTO ben_online_warnings(session_id, message_text)

2009: if p_crt_ord_warning = 'CLEAR' then
2010: DELETE ben_online_warnings
2011: WHERE session_id = p_person_id;
2012: else
2013: INSERT INTO ben_online_warnings(session_id, message_text)
2014: VALUES (p_person_id, p_crt_ord_warning);
2015: end if;
2016: end if;
2017: --

Line 2115: INSERT INTO ben_online_warnings(session_id, message_text)

2111: if l_comp_obj_list is not null then
2112: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2113: fnd_message.set_token('PARAM', l_comp_obj_list);
2114:
2115: INSERT INTO ben_online_warnings(session_id, message_text)
2116: VALUES (p_person_id, fnd_message.get);
2117: end if;
2118: --
2119: hr_utility.set_location('Leaving'|| l_proc, 20);