DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_API dependencies on BEN_ONLINE_WARNINGS

Line 2003: DELETE ben_online_warnings

1999: hr_utility.set_location('Entering:'|| l_proc, 10);
2000: --
2001: if p_person_id is not null and p_crt_ord_warning is not null then
2002: if p_crt_ord_warning = 'CLEAR' then
2003: DELETE ben_online_warnings
2004: WHERE session_id = p_person_id;
2005: else
2006: INSERT INTO ben_online_warnings(session_id, message_text)
2007: VALUES (p_person_id, p_crt_ord_warning);

Line 2006: INSERT INTO ben_online_warnings(session_id, message_text)

2002: if p_crt_ord_warning = 'CLEAR' then
2003: DELETE ben_online_warnings
2004: WHERE session_id = p_person_id;
2005: else
2006: INSERT INTO ben_online_warnings(session_id, message_text)
2007: VALUES (p_person_id, p_crt_ord_warning);
2008: end if;
2009: end if;
2010: --

Line 2108: INSERT INTO ben_online_warnings(session_id, message_text)

2104: if l_comp_obj_list is not null then
2105: fnd_message.set_name('BEN', 'BEN_94486_CRT_ORD_WARNING_DDNA');
2106: fnd_message.set_token('PARAM', l_comp_obj_list);
2107:
2108: INSERT INTO ben_online_warnings(session_id, message_text)
2109: VALUES (p_person_id, fnd_message.get);
2110: end if;
2111: --
2112: hr_utility.set_location('Leaving'|| l_proc, 20);